Skip to main content

A to Z of Council Services

SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Class';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Class")
150 B
 
Table (1 [2], 12 kB)
 
ApplicationModule.BeginRequest 0.031
 
2
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Class';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Class")
123 B
 
Table (1 [54], 36 kB)
 
ApplicationModule.BeginRequest 0.000
 
3

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Class');
Table (1 [1], 7 B)
 
ApplicationModule.BeginRequest 0.031
 
4
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Resource';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Resource")
156 B
 
Table (1 [2], 3.7 kB)
 
ApplicationModule.BeginRequest 0.000
 
5
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Resource';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Resource")
129 B
 
Table (1 [54], 12.3 kB)
 
ApplicationModule.BeginRequest 0.000
 
6
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 134
ApplicationModule.BeginRequest 0.000
 
7
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Query';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Query")
150 B
 
Table (1 [2], 2.3 kB)
 
ApplicationModule.BeginRequest 0.000
 
8
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Query';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Query")
123 B
 
Table (1 [54], 6.6 kB)
 
ApplicationModule.BeginRequest 0.000
 
9

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Query');
Table (1 [1], 7 B)
 
ApplicationModule.BeginRequest 0.031
 
10
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 134
ApplicationModule.BeginRequest 0.000
 
11
(cms.resource.generalselect)
DECLARE @ResourceInstallationState nvarchar(max) = N'installed';
DECLARE @ResourceInstallationState1 nvarchar(max) = N'installed_pending_restart';

SELECT [ResourceName], [ResourceInstalledVersion]
FROM CMS_Resource
WHERE [ResourceInstallationState] = @ResourceInstallationState OR [ResourceInstallationState] = @ResourceInstallationState1
@ResourceInstallationState ("installed")
@ResourceInstallationState1 ("installed_pending_restart")
378 B
 
ApplicationModule.BeginRequest 0.000
 
12
(cms.settingskey.generalselect)
DECLARE @KeyName nvarchar(max) = N'DataProtectionSamplesEnabled';

SELECT *
FROM CMS_SettingsKey
WHERE [SiteID] IS NULL AND [KeyName] = @KeyName
@KeyName ("DataProtectionSamplesEnabled")
176 B
 
ApplicationModule.BeginRequest 0.000
 
13
SELECT 1 FROM sys.objects WHERE name = @tableName AND type = 'U'
@tableName ("OM_Contact")
74 B
 
Table (1 [1], 4 B)
 
ApplicationModule.BeginRequest 0.016
 
14
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.EventLog';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.EventLog")
156 B
 
Table (1 [2], 4.3 kB)
 
ApplicationModule.BeginRequest 0.000
 
15
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.EventLog';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.EventLog")
129 B
 
Table (1 [54], 9 kB)
 
ApplicationModule.BeginRequest 0.000
 
16

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_EventLog');
Table (1 [1], 7 B)
 
ApplicationModule.BeginRequest 0.016
 
17
(cms.resource.generalselect)
DECLARE @ResourceInstallationState nvarchar(max) = N'installed_pending_restart';

SELECT *
FROM CMS_Resource
WHERE [ResourceInstallationState] = @ResourceInstallationState
@ResourceInstallationState ("installed_pending_restart")
200 B
 
ApplicationModule.BeginRequest 0.000
 
18
(cms.resource.generalselect)
DECLARE @ResourceInstallationState nvarchar(max) = N'';

SELECT [ResourceName], [ResourceInstalledVersion]
FROM CMS_Resource
WHERE ([ResourceInstallationState] <> @ResourceInstallationState AND [ResourceInstallationState] IS NOT NULL)
@ResourceInstallationState ("")
238 B
 
ObjectQueryBase`2.GetEnumerator 0.000
 
19
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Site';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Site")
148 B
 
Table (1 [2], 4 kB)
 
SimpleHandler`2.StartEvent 0.000
 
20
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Site';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Site")
121 B
 
Table (1 [54], 16.1 kB)
 
SimpleHandler`2.StartEvent 0.000
 
21
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 52
SimpleHandler`2.StartEvent 0.016
 
22
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 52
SimpleHandler`2.StartEvent 0.000
 
23
(cms.site.generalselect)
DECLARE @SitePresentationURL nvarchar(max) = N'%midulstercouncil-dev.zestydev.com%';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE [SitePresentationURL] LIKE @SitePresentationURL AND [SiteStatus] = @SiteStatus
ORDER BY SitePresentationURL
@SitePresentationURL ("%midulstercouncil-dev.zestydev.com%")
@SiteStatus ("RUNNING")
318 B
 
SimpleHandler`2.StartEvent 0.000
 
24
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.SiteDomainAlias';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.SiteDomainAlias")
143 B
 
Table (1 [54], 5.6 kB)
 
SimpleHandler`2.StartEvent 0.000
 
25
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 661
SimpleHandler`2.StartEvent 0.000
 
26
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.SiteDomainAlias';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.SiteDomainAlias")
170 B
 
Table (1 [2], 2.4 kB)
 
SimpleHandler`2.StartEvent 0.000
 
27
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 661
SimpleHandler`2.StartEvent 0.000
 
28
(cms.site.generalselect)
DECLARE @SiteDomainName nvarchar(max) = N'midulstercouncil-dev.zestydev.com/';
DECLARE @SiteDomainAliasName nvarchar(max) = N'midulstercouncil-dev.zestydev.com/';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE ([SiteDomainName] = @SiteDomainName OR [SiteID] IN (
SELECT [SiteID]
FROM CMS_SiteDomainAlias
WHERE [SiteDomainAliasName] = @SiteDomainAliasName
)) AND [SiteStatus] = @SiteStatus
@SiteDomainName ("midulstercouncil-dev.zestydev.com/")
@SiteDomainAliasName ("midulstercouncil-dev.zestydev.com/")
@SiteStatus ("RUNNING")
508 B
 
SimpleHandler`2.StartEvent 0.000
 
29
(cms.site.generalselect)
DECLARE @SiteDomainName nvarchar(max) = N'midulstercouncil-dev.zestydev.com';
DECLARE @SiteDomainAliasName nvarchar(max) = N'midulstercouncil-dev.zestydev.com';
DECLARE @SiteStatus nvarchar(max) = N'RUNNING';

SELECT *
FROM CMS_Site
WHERE ([SiteDomainName] = @SiteDomainName OR [SiteID] IN (
SELECT [SiteID]
FROM CMS_SiteDomainAlias
WHERE [SiteDomainAliasName] = @SiteDomainAliasName
)) AND [SiteStatus] = @SiteStatus
@SiteDomainName ("midulstercouncil-dev.zestydev.com")
@SiteDomainAliasName ("midulstercouncil-dev.zestydev.com")
@SiteStatus ("RUNNING")
504 B
 
Table (1 [16], 169 B)
 
0.016
 
30
(cms.site.generalselect)
SELECT *
FROM CMS_Site
Table (1 [16], 169 B)
 
SimpleHandler`2.StartEvent 0.016
 
31
(cms.settingskey.generalselect)
DECLARE @SiteID int = 2;

SELECT [KeyName], [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID
@SiteID (2)
108 B
 
System.Data.SqlClient.SqlDataReader
 
SimpleHandler`2.StartEvent 0.000
 
32
(cms.sitedomainalias.generalselect)
DECLARE @SiteID int = 2;

SELECT *
FROM CMS_SiteDomainAlias
WHERE [SiteID] = @SiteID
@SiteID (2)
92 B
 
Table (4 [8], 373 B)
 
SimpleHandler`2.StartEvent 0.000
 
33
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.CultureSite';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.CultureSite")
135 B
 
Table (1 [54], 2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
34
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1633
SimpleHandler`2.StartEvent 0.000
 
35
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.CultureSite';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.CultureSite")
162 B
 
Table (1 [2], 928 B)
 
SimpleHandler`2.StartEvent 0.000
 
36
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 1633
SimpleHandler`2.StartEvent 0.000
 
37
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Culture';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Culture")
127 B
 
Table (1 [54], 7.9 kB)
 
SimpleHandler`2.StartEvent 0.000
 
38
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1
SimpleHandler`2.StartEvent 0.000
 
39
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Culture';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Culture")
154 B
 
Table (1 [2], 2.3 kB)
 
SimpleHandler`2.StartEvent 0.016
 
40
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 1
SimpleHandler`2.StartEvent 0.000
 
41
(cms.culture.generalselect)
DECLARE @SiteID int = 2;

SELECT *
FROM CMS_Culture
WHERE [CultureID] IN (
SELECT [CultureID]
FROM CMS_SiteCulture
WHERE [SiteID] = @SiteID
)
@SiteID (2)
157 B
 
Table (1 [8], 89 B)
 
SimpleHandler`2.StartEvent 0.000
 
42
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.LicenseKey';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.LicenseKey")
160 B
 
Table (1 [2], 2.1 kB)
 
SimpleHandler`2.StartEvent 0.000
 
43
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.LicenseKey';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.LicenseKey")
133 B
 
Table (1 [54], 5.6 kB)
 
SimpleHandler`2.StartEvent 0.016
 
44
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 930
SimpleHandler`2.StartEvent 0.000
 
45
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 930
SimpleHandler`2.StartEvent 0.000
 
46
(cms.licensekey.generalselect)
DECLARE @LicenseDomain nvarchar(max) = N'midulstercouncil-dev.zestydev.com';

SELECT TOP 1 *
FROM CMS_LicenseKey
WHERE [LicenseDomain] = @LicenseDomain
@LicenseDomain ("midulstercouncil-dev.zestydev.com")
188 B
 
Table (1 [6], 518 B)
 
SimpleHandler`2.StartEvent 0.000
 
47

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_LicenseKey');
Table (1 [1], 12 B)
 
SimpleHandler`2.StartEvent 0.016
 
48
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'ecommerce.sku';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("ecommerce.sku")
131 B
 
Table (1 [54], 43 kB)
 
SimpleHandler`2.StartEvent 0.016
 
49
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Document';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Document")
129 B
 
Table (1 [54], 83 kB)
 
SimpleHandler`2.StartEvent 0.016
 
50
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 144
SimpleHandler`2.StartEvent 0.000
 
51
(cms.document.generalselect)
DECLARE @DocumentURLPath nvarchar(max) = N'ROUTE:%';

SELECT [NodeAliasPath], [DocumentURLPath], [NodeID], [DocumentCulture], [ClassName]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeSiteID = 2) AND [DocumentURLPath] LIKE @DocumentURLPath
@DocumentURLPath ("ROUTE:%")
346 B
 
SimpleHandler`2.StartEvent 0.016
 
52
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.DocumentAlias';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.DocumentAlias")
166 B
 
Table (1 [2], 2.8 kB)
 
SimpleHandler`2.StartEvent 0.000
 
53
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Tree';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Tree")
121 B
 
Table (1 [54], 16.1 kB)
 
SimpleHandler`2.StartEvent 0.000
 
54
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.DocumentAlias';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.DocumentAlias")
139 B
 
Table (1 [54], 7.8 kB)
 
SimpleHandler`2.StartEvent 0.000
 
55
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1719
SimpleHandler`2.StartEvent 0.000
 
56
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 1719
SimpleHandler`2.StartEvent 0.000
 
57
(cms.documentalias.generalselect)
SELECT [NodeAliasPath], [AliasNodeID], [AliasCulture], [AliasURLPath], [AliasSiteID], [AliasActionMode]
FROM CMS_DocumentAlias INNER JOIN CMS_Tree ON [CMS_DocumentAlias].[AliasNodeID] = [CMS_Tree].[NodeID]
WHERE ((AliasSiteID = 2) AND (AliasURLPath LIKE 'ROUTE:%'))
Table (1 [6], 114 B)
 
SimpleHandler`2.StartEvent 0.000
 
58
(.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @NodeAliasPath nvarchar(max) = N'/Home';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-GB' THEN 2 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (2)
@NodeAliasPath ("/Home")
@DocumentCulture ("en-GB")
3.2 kB
 
Table (1 [65], 8.5 kB)
 
SimpleHandler`2.StartEvent 0.016
 
59
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.MenuItem';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.MenuItem")
129 B
 
Table (1 [54], 7.8 kB)
 
SimpleHandler`2.StartEvent 0.016
 
60
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WorkflowStep")
164 B
 
Table (1 [2], 4.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
61
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WorkflowStep")
137 B
 
Table (1 [54], 12.8 kB)
 
SimpleHandler`2.StartEvent 0.016
 
62

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_WorkflowStep');
Table (1 [1], 6 B)
 
SimpleHandler`2.StartEvent 0.031
 
63
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 172
SimpleHandler`2.StartEvent 0.016
 
64
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 172
SimpleHandler`2.StartEvent 0.000
 
65
(cms.workflowstep.generalselect)
DECLARE @StepID int = 255;

SELECT TOP 1 *
FROM CMS_WorkflowStep
WHERE [StepID] = @StepID
@StepID (255)
97 B
 
Table (1 [23], 469 B)
 
SimpleHandler`2.StartEvent 0.000
 
66
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.PageTemplate';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.PageTemplate")
164 B
 
Table (1 [2], 6.8 kB)
 
SimpleHandler`2.StartEvent 0.000
 
67
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.PageTemplate';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.PageTemplate")
137 B
 
Table (1 [54], 27 kB)
 
SimpleHandler`2.StartEvent 0.000
 
68
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 157
SimpleHandler`2.StartEvent 0.000
 
69
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 157
SimpleHandler`2.StartEvent 0.000
 
70
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25794;

SELECT TOP 1 *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25794)
123 B
 
Table (1 [31], 38 kB)
 
SimpleHandler`2.StartEvent 0.000
 
71
(cms.document.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] = N'/' AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (2)
@DocumentCulture ("en-GB")
360 B
 
Table (1 [160], 5 kB)
 
SimpleHandler`2.StartEvent 0.016
 
72
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';
DECLARE @NodeID int = 2;

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-GB' THEN 2 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID)
) AS SubData
ORDER BY CMS_P DESC
@DocumentCulture ("en-GB")
@NodeID (2)
3.1 kB
 
Table (1 [65], 4.7 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
73
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Root';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Root")
121 B
 
Table (1 [54], 285 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
74
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25750;

SELECT TOP 1 *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25750)
123 B
 
Table (1 [31], 60 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
75
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.User';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.User")
148 B
 
Table (1 [2], 6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
76
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.User';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.User")
121 B
 
Table (1 [54], 25 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
77

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_User');
Table (1 [1], 6 B)
 
PageContext.CurrentPage_InitComplete 0.031
 
78
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 59
PageContext.CurrentPage_InitComplete 0.000
 
79
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 59
PageContext.CurrentPage_InitComplete 0.016
 
80
(cms.user.generalselect)
DECLARE @UserName nvarchar(max) = N'public';

SELECT TOP 1 *
FROM CMS_User
WHERE [UserName] = @UserName
@UserName ("public")
113 B
 
Table (1 [28], 129 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
81
(cms.culture.generalselect)
SELECT *
FROM CMS_Culture
Table (137 [8], 11.2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
82
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.personalization';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("cms.personalization")
170 B
 
Table (1 [2], 2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
83
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.personalization';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("cms.personalization")
143 B
 
Table (1 [54], 4.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
84
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1841
PageContext.CurrentPage_InitComplete 0.000
 
85
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 2
PageContext.CurrentPage_InitComplete 0.000
 
86
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPart';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WebPart")
154 B
 
Table (1 [2], 4.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
87
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPart';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WebPart")
127 B
 
Table (1 [54], 15.2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
88
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 425
PageContext.CurrentPage_InitComplete 0.000
 
89
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 425
PageContext.CurrentPage_InitComplete 0.000
 
90
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'repeater';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("repeater")
129 B
 
Table (1 [19], 23 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
91
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'editabletext';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("editabletext")
137 B
 
Table (1 [19], 11.3 kB)
 
0.016
 
92
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.richtexteditor';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("general.richtexteditor")
@CultureCode ("en-GB")
306 B
 
CMSWebParts_Text_editabletext.OnInit 0.016
 
93
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'pageplaceholder';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("pageplaceholder")
143 B
 
Table (1 [19], 6.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
94
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'BizForm';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("BizForm")
127 B
 
Table (1 [19], 4.4 kB)
 
0.000
 
95
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'statichtml';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("statichtml")
133 B
 
Table (1 [19], 1.9 kB)
 
0.000
 
96
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'SocialMetaData';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("SocialMetaData")
141 B
 
Table (1 [19], 2 kB)
 
0.000
 
97
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'SimpleCookieLaw';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("SimpleCookieLaw")
143 B
 
Table (1 [19], 2.5 kB)
 
0.000
 
98
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1173;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1173)
102 B
 
Table (1 [19], 14.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
99
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.ResultText';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("DataPager.ResultText")
@CultureCode ("en-GB")
302 B
 
PageContext.CurrentPage_InitComplete 0.000
 
100
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.LabelText';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("DataPager.LabelText")
@CultureCode ("en-GB")
300 B
 
0.016
 
101
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Back';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("DataPager.Back")
@CultureCode ("en-GB")
290 B
 
0.000
 
102
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Next';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("DataPager.Next")
@CultureCode ("en-GB")
290 B
 
0.000
 
103
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.First';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("DataPager.First")
@CultureCode ("en-GB")
292 B
 
0.016
 
104
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Last';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("DataPager.Last")
@CultureCode ("en-GB")
290 B
 
0.000
 
105
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 9
PageContext.CurrentPage_InitComplete 0.000
 
106
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Widget';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Widget")
152 B
 
Table (1 [2], 4.1 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
107
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Widget';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Widget")
125 B
 
Table (1 [54], 16.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
108
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 2197
PageContext.CurrentPage_InitComplete 0.016
 
109
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 2197
PageContext.CurrentPage_InitComplete 0.000
 
110
(cms.widget.generalselect)
SELECT *
FROM CMS_Widget
Table (125 [22], 421 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
111
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1677;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1677)
102 B
 
Table (1 [19], 15.1 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
112
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'SearchBox';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("SearchBox")
131 B
 
Table (1 [19], 26 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
113
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPartLayout';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WebPartLayout")
166 B
 
Table (1 [2], 3.1 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
114
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPartLayout';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WebPartLayout")
139 B
 
Table (1 [54], 11 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
115
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1514
PageContext.CurrentPage_InitComplete 0.000
 
116
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 1514
PageContext.CurrentPage_InitComplete 0.000
 
117
(cms.webpartlayout.generalselect)
SELECT *
FROM CMS_WebPartLayout
Table (9 [11], 19 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
118
(cms.webpart.generalselect)
DECLARE @WebPartID int = 173;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (173)
101 B
 
Table (1 [19], 18.4 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
119
(cms.webpart.generalselect)
DECLARE @WebPartID int = 178;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (178)
101 B
 
Table (1 [19], 4.9 kB)
 
0.000
 
120
(cms.webpart.generalselect)
DECLARE @WebPartID int = 179;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (179)
101 B
 
Table (1 [19], 15.7 kB)
 
0.000
 
121
(cms.webpart.generalselect)
DECLARE @WebPartID int = 239;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (239)
101 B
 
Table (1 [19], 1 kB)
 
0.000
 
122
(cms.webpart.generalselect)
DECLARE @WebPartID int = 525;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (525)
101 B
 
Table (1 [19], 6.5 kB)
 
0.000
 
123
(cms.webpart.generalselect)
DECLARE @WebPartID int = 676;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (676)
101 B
 
Table (1 [19], 6.9 kB)
 
0.000
 
124
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1363;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1363)
102 B
 
Table (1 [19], 3.8 kB)
 
0.000
 
125
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1678;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1678)
102 B
 
Table (1 [19], 2.3 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
126
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'CMSUniView';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("CMSUniView")
133 B
 
Table (1 [19], 32 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
127
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'HeadHTML';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("HeadHTML")
129 B
 
Table (1 [19], 726 B)
 
0.000
 
128
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'Link';

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("Link")
121 B
 
Table (1 [19], 7.1 kB)
 
0.000
 
129
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'unigridpager.previouspage';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("unigridpager.previouspage")
@CultureCode ("en-GB")
312 B
 
CMSUniView.CreateChildControls 0.000
 
130
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'unigridpager.nextpage';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("unigridpager.nextpage")
@CultureCode ("en-GB")
304 B
 
0.016
 
131
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Transformation';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Transformation")
168 B
 
Table (1 [2], 3.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
132
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Transformation';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Transformation")
141 B
 
Table (1 [54], 8.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
133
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 162
PageContext.CurrentPage_InitComplete 0.000
 
134
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 162
PageContext.CurrentPage_InitComplete 0.016
 
135
(cms.transformation.generalselect)
SELECT *
FROM CMS_Transformation
Table (220 [12], 133 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
136
(cms.class.generalselect)
DECLARE @ClassID int = 1685;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (1685)
94 B
 
Table (1 [54], 4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
137
(cms.class.generalselect)
DECLARE @ClassID int = 3140;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (3140)
94 B
 
Table (1 [54], 275 B)
 
0.000
 
138
(cms.class.generalselect)
DECLARE @ClassID int = 5477;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5477)
94 B
 
Table (1 [54], 349 B)
 
0.000
 
139
(cms.class.generalselect)
DECLARE @ClassID int = 5478;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5478)
94 B
 
Table (1 [54], 335 B)
 
0.000
 
140
(cms.class.generalselect)
DECLARE @ClassID int = 5479;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5479)
94 B
 
Table (1 [54], 323 B)
 
0.000
 
141
(cms.class.generalselect)
DECLARE @ClassID int = 5480;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5480)
94 B
 
Table (1 [54], 7.8 kB)
 
0.000
 
142
(cms.class.generalselect)
DECLARE @ClassID int = 5482;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5482)
94 B
 
Table (1 [54], 5.3 kB)
 
0.000
 
143
(cms.class.generalselect)
DECLARE @ClassID int = 5484;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5484)
94 B
 
Table (1 [54], 327 B)
 
0.016
 
144
(cms.class.generalselect)
DECLARE @ClassID int = 5485;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5485)
94 B
 
Table (1 [54], 317 B)
 
0.000
 
145
(cms.class.generalselect)
DECLARE @ClassID int = 5486;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5486)
94 B
 
Table (1 [54], 283 B)
 
0.000
 
146
(cms.class.generalselect)
DECLARE @ClassID int = 5487;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5487)
94 B
 
Table (1 [54], 5.7 kB)
 
0.000
 
147
(cms.class.generalselect)
DECLARE @ClassID int = 5488;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5488)
94 B
 
Table (1 [54], 16.4 kB)
 
0.000
 
148
(cms.class.generalselect)
DECLARE @ClassID int = 5489;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5489)
94 B
 
Table (1 [54], 10.6 kB)
 
0.016
 
149
(cms.class.generalselect)
DECLARE @ClassID int = 5490;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5490)
94 B
 
Table (1 [54], 3.5 kB)
 
0.000
 
150
(cms.class.generalselect)
DECLARE @ClassID int = 5491;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5491)
94 B
 
Table (1 [54], 6.3 kB)
 
0.000
 
151
(cms.class.generalselect)
DECLARE @ClassID int = 5492;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5492)
94 B
 
Table (1 [54], 5.9 kB)
 
0.000
 
152
(cms.class.generalselect)
DECLARE @ClassID int = 5493;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5493)
94 B
 
Table (1 [54], 3 kB)
 
0.000
 
153
(cms.class.generalselect)
DECLARE @ClassID int = 5494;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5494)
94 B
 
Table (1 [54], 14.1 kB)
 
0.016
 
154
(cms.class.generalselect)
DECLARE @ClassID int = 5496;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5496)
94 B
 
Table (1 [54], 2.3 kB)
 
0.000
 
155
(cms.class.generalselect)
DECLARE @ClassID int = 5497;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5497)
94 B
 
Table (1 [54], 334 B)
 
0.000
 
156
(cms.class.generalselect)
DECLARE @ClassID int = 5498;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5498)
94 B
 
Table (1 [54], 10.5 kB)
 
0.000
 
157
(cms.class.generalselect)
DECLARE @ClassID int = 5499;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5499)
94 B
 
Table (1 [54], 296 B)
 
0.000
 
158
(cms.class.generalselect)
DECLARE @ClassID int = 5500;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5500)
94 B
 
Table (1 [54], 12.1 kB)
 
0.015
 
159
(cms.class.generalselect)
DECLARE @ClassID int = 5502;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5502)
94 B
 
Table (1 [54], 6.7 kB)
 
0.000
 
160
(cms.class.generalselect)
DECLARE @ClassID int = 5507;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5507)
94 B
 
Table (1 [54], 5.3 kB)
 
0.000
 
161
(cms.class.generalselect)
DECLARE @ClassID int = 5509;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5509)
94 B
 
Table (1 [54], 11.3 kB)
 
0.000
 
162
(cms.class.generalselect)
DECLARE @ClassID int = 5510;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5510)
94 B
 
Table (1 [54], 22 kB)
 
0.000
 
163
(cms.class.generalselect)
DECLARE @ClassID int = 5518;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5518)
94 B
 
Table (1 [54], 6.2 kB)
 
0.016
 
164
(cms.class.generalselect)
DECLARE @ClassID int = 5519;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5519)
94 B
 
Table (1 [54], 10.5 kB)
 
0.000
 
165
(cms.class.generalselect)
DECLARE @ClassID int = 5520;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5520)
94 B
 
Table (1 [54], 3.6 kB)
 
0.000
 
166
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-Pages_en-GB'
PageContext.CurrentPage_InitComplete 0.000
 
167
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-CurrentPage_en-GB'
0.000
 
168
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PageSeparator_en-GB'
0.000
 
169

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Transformation');
Table (1 [1], 16 B)
 
PageContext.CurrentPage_InitComplete 0.031
 
170
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-FirstPage_en-GB'
PageContext.CurrentPage_InitComplete 0.000
 
171
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-LastPage_en-GB'
0.016
 
172
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PreviousPage_en-GB'
0.000
 
173
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-NextPage_en-GB'
0.000
 
174
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PreviousGroup_en-GB'
0.000
 
175
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-NextGroup_en-GB'
0.000
 
176
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5484 AND [TransformationName] = N'General-PagerLayout_en-GB'
0.000
 
177
SELECT SiteID, SiteStatus FROM CMS_Site WHERE ( SiteDomainName = 'midulstercouncil-dev.zestydev.com' OR SiteDomainName LIKE 'midulstercouncil-dev.zestydev.com:%' )
PageContext.CurrentPage_InitComplete 0.000
 
178
SELECT SiteID, SiteStatus FROM CMS_Site WHERE SiteID IN ( SELECT SiteID FROM CMS_SiteDomainAlias WHERE SiteDomainAliasName='midulstercouncil-dev.zestydev.com' OR SiteDomainAliasName LIKE 'midulstercouncil-dev.zestydev.com:%' )
Table (1 [2], 11 B)
 
0.000
 
179
SELECT COUNT(*) AS NUM FROM CMS_Tree WHERE NodeClassID = 5488 AND NodeSiteID = 2
Table (1 [1], 4 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
180
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Tree';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Tree")
148 B
 
Table (1 [2], 5.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
181

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Tree');
Table (1 [1], 6 B)
 
PageContext.CurrentPage_InitComplete 0.031
 
182
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.menuitem';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("cms.menuitem")
156 B
 
Table (1 [2], 2.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
183

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CONTENT_MenuItem');
Table (1 [1], 10 B)
 
PageContext.CurrentPage_InitComplete 0.031
 
184
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5483
PageContext.CurrentPage_InitComplete 0.016
 
185
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 9) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-GB")
393 B
 
Table (1 [169], 8.9 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
186
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Document';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Document")
156 B
 
Table (1 [2], 16.2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
187
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.search';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("General.search")
@CultureCode ("en-GB")
290 B
 
PageContext.CurrentPage_InitComplete 0.000
 
188
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'srch.searchbox.searchfor';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("srch.searchbox.searchfor")
@CultureCode ("en-GB")
310 B
 
PageContext.CurrentPage_InitComplete 0.016
 
189
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Form';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Form")
148 B
 
Table (1 [2], 6.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
190
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Form';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Form")
121 B
 
Table (1 [54], 18.1 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
191
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 880
PageContext.CurrentPage_InitComplete 0.000
 
192
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 880
PageContext.CurrentPage_InitComplete 0.016
 
193
(cms.form.generalselect)
SELECT *
FROM CMS_Form
Table (7 [27], 6.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
194
(cms.class.generalselect)
DECLARE @ClassID int = 5523;

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassID] = @ClassID
@ClassID (5523)
94 B
 
Table (1 [54], 5.3 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
195
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.AlternativeForm';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.AlternativeForm")
170 B
 
Table (1 [2], 3.5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
196
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.AlternativeForm';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.AlternativeForm")
143 B
 
Table (1 [54], 8.2 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
197
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 1745
PageContext.CurrentPage_InitComplete 0.000
 
198
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 1745
PageContext.CurrentPage_InitComplete 0.016
 
199
(cms.alternativeform.generalselect)
SELECT TOP 1 *
FROM CMS_AlternativeForm
WHERE [FormClassID] = 5523 AND [FormName] = N'insert'
PageContext.CurrentPage_InitComplete 0.000
 
200
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'bizform.newslettersignup';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("bizform.newslettersignup")
180 B
 
Table (1 [2], 1.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
201

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('Form_MidUlsterCouncil_NewsletterSignUp');
Table (1 [1], 18 B)
 
PageContext.CurrentPage_InitComplete 0.016
 
202
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.FormUserControl';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.FormUserControl")
170 B
 
Table (1 [2], 5.7 kB)
 
EditingFormControl.InitializeControl 0.000
 
203
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.FormUserControl';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.FormUserControl")
143 B
 
Table (1 [54], 21 kB)
 
EditingFormControl.InitializeControl 0.000
 
204
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 846
EditingFormControl.InitializeControl 0.016
 
205
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 846
EditingFormControl.InitializeControl 0.000
 
206
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'TextBoxControl';

SELECT TOP 1 *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
@UserControlCodeName ("TextBoxControl")
173 B
 
Table (1 [36], 14.6 kB)
 
EditingFormControl.InitializeControl 0.000
 
207
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'ReCAPTCHA';

SELECT TOP 1 *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
@UserControlCodeName ("ReCAPTCHA")
163 B
 
Table (1 [36], 2.2 kB)
 
0.000
 
208
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.ok';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("general.ok")
@CultureCode ("en-GB")
282 B
 
PageContext.CurrentPage_InitComplete 0.016
 
209
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.sociallink';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.sociallink")
158 B
 
Table (1 [2], 2.3 kB)
 
SocialLink..ctor 0.016
 
210

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('SZ_SocialLink');
Table (1 [1], 12 B)
 
SocialLink..ctor 0.016
 
211
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.RelationshipName';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.RelationshipName")
172 B
 
Table (1 [2], 2.1 kB)
 
BasicRepeater.OnLoad 0.000
 
212
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.RelationshipName';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.RelationshipName")
145 B
 
Table (1 [54], 6.5 kB)
 
BasicRepeater.OnLoad 0.000
 
213
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'selectall' AND ClassID = 530
BasicRepeater.OnLoad 0.000
 
214
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 530
BasicRepeater.OnLoad 0.016
 
215
(cms.relationshipname.generalselect)
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';

SELECT TOP 1 *
FROM CMS_RelationshipName
WHERE [RelationshipName] = @RelationshipName
@RelationshipName ("isrelatedto")
159 B
 
Table (1 [7], 88 B)
 
BasicRepeater.OnLoad 0.000
 
216
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5502
BasicRepeater.OnLoad 0.016
 
217
(sz.sociallink.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '1/19/2020 10:37:54 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SZ_SocialLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[SocialLinkID] AND V.ClassName = N'SZ.SocialLink' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (2)
@Now (19/01/2020 10:37:54)
@DocumentCulture ("en-GB")
671 B
 
Table (4 [166], 3.3 kB)
 
BasicRepeater.OnLoad 0.000
 
218
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5502 AND [TransformationName] = N'SimpleList_en-GB'
BasicRepeater.OnLoad 0.000
 
219
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '1/19/2020 10:37:54 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (MenuItemGroup='top') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, NodeName
@NodeSiteID (2)
@Now (19/01/2020 10:37:54)
@DocumentCulture ("en-GB")
738 B
 
Table (8 [169], 47 kB)
 
BasicRepeater.OnLoad 0.016
 
220
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5483 AND [TransformationName] = N'SimpleList_en-GB'
BasicRepeater.OnLoad 0.000
 
221
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.card';

SELECT TOP 1 *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.card")
119 B
 
Table (1 [54], 5.4 kB)
 
BasicRepeater.OnLoad 0.000
 
222
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.card';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.card")
146 B
 
Table (1 [2], 2.2 kB)
 
BasicRepeater.OnLoad 0.016
 
223

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('SZ_Card');
Table (1 [1], 6 B)
 
BasicRepeater.OnLoad 0.016
 
224
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5508
BasicRepeater.OnLoad 0.016
 
225
(sz.card.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '1/19/2020 10:37:54 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Home/Home-Feature-Cards/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SZ_Card AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[CardID] AND V.ClassName = N'SZ.Card' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder ASC
@NodeSiteID (2)
@Now (19/01/2020 10:37:54)
@NodeAliasPath ("/Home/Home-Feature-Cards/%")
@DocumentCulture ("en-GB")
814 B
 
Table (12 [166], 11.7 kB)
 
BasicRepeater.OnLoad 0.016
 
226
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '1/19/2020 10:37:54 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ShowOnHomePage = 1) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel ASC, NodeOrder ASC, NodeName ASC
@NodeSiteID (2)
@Now (19/01/2020 10:37:54)
@DocumentCulture ("en-GB")
749 B
 
BasicUniView.OnLoad 0.016
 
227
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5483 AND [TransformationName] = N'SzFeatureCard_en-GB'
BasicUniView.OnLoad 0.016
 
228
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.news';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.news")
146 B
 
Table (1 [2], 1.8 kB)
 
BasicRepeater.OnLoad 0.000
 
229

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('SZ_News');
Table (1 [1], 6 B)
 
BasicRepeater.OnLoad 0.031
 
230
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5507
BasicRepeater.OnLoad 0.016
 
231
(sz.news.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '1/19/2020 10:37:54 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SZ_News AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[NewsID] AND V.ClassName = N'SZ.News' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY NewsReleaseDate desc
@NodeSiteID (2)
@Now (19/01/2020 10:37:54)
@DocumentCulture ("en-GB")
690 B
 
Table (3 [166], 21 kB)
 
BasicRepeater.OnLoad 0.016
 
232
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5507 AND [TransformationName] = N'LatestListing_en-GB'
BasicRepeater.OnLoad 0.000
 
233
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'sz.event';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("sz.event")
148 B
 
Table (1 [2], 3.7 kB)
 
BasicRepeater.OnLoad 0.016
 
234

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('SZ_Event');
Table (1 [1], 7 B)
 
BasicRepeater.OnLoad 0.016
 
235
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5509
BasicRepeater.OnLoad 0.000
 
236
(sz.event.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '1/19/2020 10:37:55 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN SZ_Event AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventID] AND V.ClassName = N'SZ.Event' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY EventDate
@NodeSiteID (2)
@Now (19/01/2020 10:37:55)
@DocumentCulture ("en-GB")
682 B
 
Table (3 [173], 6.2 kB)
 
BasicRepeater.OnLoad 0.016
 
237
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5509 AND [TransformationName] = N'Latest_en-GB'
BasicRepeater.OnLoad 0.000
 
238
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 2;
DECLARE @Now datetime2 = '1/19/2020 10:37:55 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-GB';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (MenuItemGroup='footer') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (2)
@Now (19/01/2020 10:37:55)
@DocumentCulture ("en-GB")
700 B
 
Table (4 [169], 30 kB)
 
BasicRepeater.OnLoad 0.016
 
239
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.requiredmark';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("general.requiredmark")
@CultureCode ("en-GB")
302 B
 
LocalizedLabel.LoadData 0.016
 
240
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.colon';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("general.colon")
@CultureCode ("en-GB")
288 B
 
LocalizedLabel.LoadData 0.000
 
241
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'Sign Up';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("Sign Up")
@CultureCode ("en-GB")
276 B
 
LocalizedButton.OnPreRender 0.000
 
242
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'Sign Up';
DECLARE @CultureCode nvarchar(max) = N'en-us';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("Sign Up")
@CultureCode ("en-us")
276 B
 
0.000
 
243
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("")
@CultureCode ("en-GB")
262 B
 
CMSAdminControls_Debug_QueryLog.OnPreRender 0.016
 
244
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'';
DECLARE @CultureCode nvarchar(max) = N'en-us';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("")
@CultureCode ("en-us")
262 B
 
0.000
 
245
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryText';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("QueryLog.QueryText")
@CultureCode ("en-GB")
298 B
 
0.000
 
246
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Context';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("General.Context")
@CultureCode ("en-GB")
292 B
 
0.000
 
247
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryDuration';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("QueryLog.QueryDuration")
@CultureCode ("en-GB")
306 B
 
0.000
 
248
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'QueryLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-GB';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("QueryLog.Info")
@CultureCode ("en-GB")
288 B
 
CMSAdminControls_Debug_QueryLog.OnPreRender 0.000
 
  248 queries, 47 kB write, 1.8 MB read   1.251