Member Login

SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/public/Login';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Login';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/public/Login' THEN 4 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 (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@DocumentUrlPath ("/public/Login")
@NodeAliasPath ("/public/Login")
@DocumentCulture ("en-US")
3.5 kB
 
Table (1 [65], 442 B)
 
SimpleHandler`2.StartEvent 0.005
 
2
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25759;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25759)
117 B
 
Table (1 [33], 8.8 kB)
 
SimpleHandler`2.StartEvent 0.002
 
3
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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] IN (N'/public', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
375 B
 
Table (2 [157], 4 kB)
 
SimpleHandler`2.StartEvent 0.005
 
4
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 71;

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-US' 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-US")
@NodeID (71)
3.1 kB
 
Table (1 [65], 1.5 kB)
 
PageContext.CurrentPage_InitComplete 0.003
 
5
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 1;

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-US' 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-US")
@NodeID (1)
3.1 kB
 
Table (1 [65], 1.8 kB)
 
0.002
 
6
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 87
PageContext.CurrentPage_InitComplete 0.002
 
7
(cms.webpart.generalselect)
DECLARE @WebPartName nvarchar(max) = N'logonform';

SELECT *
FROM CMS_WebPart
WHERE [WebPartName] = @WebPartName
@WebPartName ("logonform")
125 B
 
Table (1 [20], 4.9 kB)
 
PageContext.CurrentPage_InitComplete 0.002
 
8
(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.002
 
9
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPartLayout';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WebPartLayout")
133 B
 
Table (1 [55], 11.1 kB)
 
PageContext.CurrentPage_InitComplete 0.002
 
10
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1514)
PageContext.CurrentPage_InitComplete 0.002
 
11
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1514)
PageContext.CurrentPage_InitComplete 0.001
 
12
(cms.webpartlayout.generalselect)
SELECT *
FROM CMS_WebPartLayout
Table (17 [11], 115 kB)
 
PageContext.CurrentPage_InitComplete 0.004
 
13
(cms.webpart.generalselect)
DECLARE @WebPartID int = 173;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (173)
95 B
 
Table (1 [20], 18.4 kB)
 
PageContext.CurrentPage_InitComplete 0.002
 
14
(cms.webpart.generalselect)
DECLARE @WebPartID int = 179;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (179)
95 B
 
Table (1 [20], 15.4 kB)
 
0.002
 
15
(cms.webpart.generalselect)
DECLARE @WebPartID int = 239;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (239)
95 B
 
Table (1 [20], 1.1 kB)
 
0.001
 
16
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1675;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1675)
96 B
 
Table (1 [20], 15.4 kB)
 
0.001
 
17
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1678;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1678)
96 B
 
Table (1 [20], 15.4 kB)
 
0.001
 
18
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1685;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1685)
96 B
 
Table (1 [20], 5.8 kB)
 
0.002
 
19
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1686;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1686)
96 B
 
Table (1 [20], 15.4 kB)
 
0.002
 
20
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'LogonForm.NameRequired';
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 ("LogonForm.NameRequired")
@CultureCode ("en-US")
306 B
 
PageContext.CurrentPage_InitComplete 0.002
 
21
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'LogonForm.EnterName';
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 ("LogonForm.EnterName")
@CultureCode ("en-US")
300 B
 
0.002
 
22
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSAutocompleteEnableForLogin';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSAutocompleteEnableForLogin")
219 B
 
PageContext.CurrentPage_InitComplete 0.001
 
23
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 6:12:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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 (DocumentMenuItemHideInNavigation = 0) 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 NodeLevel, NodeOrder, NodeName
@NodeSiteID (1)
@Now (4/10/2020 6:12:25 AM)
@NodeAliasPath ("/public/%")
@DocumentCulture ("en-US")
857 B
 
Table (151 [161], 929 kB)
 
BasicUniView.OnLoad 0.026
 
24
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 6:12:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/About-Local-One%';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, NodeName
@NodeSiteID (1)
@Now (4/10/2020 6:12:25 AM)
@NodeAliasPath ("/public/About-Local-One%")
@NodeLevel (3)
@DocumentCulture ("en-US")
907 B
 
Table (7 [161], 61 kB)
 
BasicRepeater.OnLoad 0.007
 
25
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 6:12:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Become-a-Member%';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, NodeName
@NodeSiteID (1)
@Now (4/10/2020 6:12:25 AM)
@NodeAliasPath ("/public/Become-a-Member%")
@NodeLevel (3)
@DocumentCulture ("en-US")
907 B
 
Table (5 [161], 42 kB)
 
0.006
 
26
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 6:12:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Hire-Local-One%';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, NodeName
@NodeSiteID (1)
@Now (4/10/2020 6:12:25 AM)
@NodeAliasPath ("/public/Hire-Local-One%")
@NodeLevel (3)
@DocumentCulture ("en-US")
905 B
 
Table (3 [161], 11.1 kB)
 
0.005
 
27
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 6:12:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/New-Candidates%';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, NodeName
@NodeSiteID (1)
@Now (4/10/2020 6:12:25 AM)
@NodeAliasPath ("/public/New-Candidates%")
@NodeLevel (3)
@DocumentCulture ("en-US")
905 B
 
Table (1 [161], 9.3 kB)
 
0.005
 
28
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 6:12:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/News';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (1)
@Now (4/10/2020 6:12:25 AM)
@NodeAliasPath ("/public/News")
@NodeLevel (2)
@DocumentCulture ("en-US")
859 B
 
Table (1 [161], 770 B)
 
0.005
 
29
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 6:12:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Events';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (1)
@Now (4/10/2020 6:12:25 AM)
@NodeAliasPath ("/public/Events")
@NodeLevel (2)
@DocumentCulture ("en-US")
863 B
 
Table (1 [161], 784 B)
 
0.005
 
30
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'LogonForm.Password';
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 ("LogonForm.Password")
@CultureCode ("en-US")
298 B
 
LocalizedLabel.LoadData 0.002
 
31
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'LogonForm.RememberMe';
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 ("LogonForm.RememberMe")
@CultureCode ("en-US")
302 B
 
CMSCheckBox.OnPreRender 0.003
 
32
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'LogonForm.LogOnButton';
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 ("LogonForm.LogOnButton")
@CultureCode ("en-US")
304 B
 
LocalizedButton.OnPreRender 0.002
 
33
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'LogonForm.lnkPasswordRetrieval';
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 ("LogonForm.lnkPasswordRetrieval")
@CultureCode ("en-US")
322 B
 
LocalizedLinkButton.OnPreRender 0.002
 
  33 queries, 19.6 kB write, 1.3 MB read   0.116