1
|
(.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @DocumentUrlPath nvarchar(max) = N'/Annual-Reports'; DECLARE @NodeAliasPath nvarchar(max) = N'/Annual-Reports'; 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'/Annual-Reports' 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 ("/Annual-Reports") @NodeAliasPath ("/Annual-Reports") @DocumentCulture ("en-US") 3.5 kB
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass83_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
2
|
(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] = N'/' AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (1) @DocumentCulture ("en-US") 360 B
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.CheckSecurity PageSecurityHelper.CheckPageSecurity PageSecurityHelper.RequestSecurePage PageInfo.get_RequiresSSLValue PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
3
|
(.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
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
4
|
(ncpdp.annualreport.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @NodeAliasPath nvarchar(max) = N'/Annual-Reports/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN ncpdp_AnnualReport AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[AnnualReportID] AND V.ClassName = N'ncpdp.AnnualReport' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY FileYear Desc @NodeSiteID (1) @NodeAliasPath ("/Annual-Reports/%") @DocumentCulture ("en-US") 598 B Table (15 [165], 16.2 kB)
|
BasicRepeater.OnLoad CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass83_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|