|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry AbstractDataConnection.get_NativeDBConnection <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
1
|
(.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @DocumentUrlPath nvarchar(max) = N'/branding/cmaa/default'; DECLARE @NodeAliasPath nvarchar(max) = N'/branding/cmaa/default'; 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'/branding/cmaa/default' 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 ("/branding/cmaa/default") @NodeAliasPath ("/branding/cmaa/default") @DocumentCulture ("en-US") 3.5 kB
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 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__DisplayClass7.<LogQueryStart>b__5
|
0.000
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo PageInfoDataProvider.GetBlankPageInfo Queryable.FirstOrDefault CMSQueryProvider`1.Execute CMSQueryProvider`1.ExecuteInternal EnumerableQuery`1.System.Linq.IQueryProvider.Execute EnumerableExecutor`1.ExecuteBoxed EnumerableExecutor`1.Execute lambda_method Enumerable.FirstOrDefault GetEnumerator>d__0.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
2
|
(cms.tree.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @NodeAliasPath nvarchar(max) = N'/branding/cmaa/default';
SELECT TOP 1 * FROM CMS_Tree WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] = @NodeAliasPath @NodeSiteID (1) @NodeAliasPath ("/branding/cmaa/default") 225 B
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo PageInfoDataProvider.GetBlankPageInfo Queryable.FirstOrDefault CMSQueryProvider`1.Execute CMSQueryProvider`1.ExecuteInternal EnumerableQuery`1.System.Linq.IQueryProvider.Execute EnumerableExecutor`1.ExecuteBoxed EnumerableExecutor`1.Execute lambda_method Enumerable.FirstOrDefault GetEnumerator>d__0.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.000
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo PageInfoDataProvider.GetBlankPageInfo Queryable.FirstOrDefault CMSQueryProvider`1.Execute CMSQueryProvider`1.ExecuteInternal EnumerableQuery`1.System.Linq.IQueryProvider.Execute EnumerableExecutor`1.ExecuteBoxed EnumerableExecutor`1.Execute lambda_method Enumerable.FirstOrDefault GetEnumerator>d__0.MoveNext ObjectQueryBase`2.System.Collections.IEnumerable.GetEnumerator ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByWildcardSearcher.Search PageInfoByWildcardSearcher.FindCandidateByWildcard DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
3
|
(cms.document.generalselect) DECLARE @Value nvarchar(max) = N'/branding/cmaa/default'; DECLARE @NodeSiteID int = 1;
SELECT TOP 1 [NodeAliasPath], [DocumentCulture], [DocumentURLPath], [DocumentExtensions] 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 (@Value LIKE [DocumentWildcardRule] AND [NodeSiteID] = @NodeSiteID) ORDER BY CASE WHEN [DocumentCulture] = N'en-US' THEN 2 WHEN [DocumentCulture] = N'en-US' THEN 1 ELSE 0 END DESC, DocumentPriority DESC, DocumentCulture @Value ("/branding/cmaa/default") @NodeSiteID (1) 565 B
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByWildcardSearcher.Search PageInfoByWildcardSearcher.FindCandidateByWildcard DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.016
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByWildcardSearcher.Search PageInfoByWildcardSearcher.FindCandidateByWildcard DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search DocumentAliasInfoProvider.GetDocumentAliasCandidatesInternal ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
4
|
(cms.documentalias.generalselect) DECLARE @AliasSiteID int = 1; DECLARE @Value nvarchar(max) = N'/branding/cmaa/default'; DECLARE @Now datetime2 = '4/13/2026 5:56:49 AM';
SELECT * FROM CMS_DocumentAlias WHERE ([AliasSiteID] = @AliasSiteID AND (@Value = [AliasURLPath] OR @Value LIKE [AliasWildcardRule])) AND [AliasNodeID] IN ( SELECT [NodeID] 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 ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) ) ORDER BY CASE WHEN ([AliasWildcardRule] = N'' OR [AliasWildcardRule] IS NULL) THEN 1 ELSE 0 END DESC, CASE WHEN [AliasCulture] = N'en-US' THEN 2 WHEN [AliasCulture] = N'en-US' THEN 1 ELSE 0 END DESC, AliasPriority DESC, AliasCulture @AliasSiteID (1) @Value ("/branding/cmaa/default") @Now (4/13/2026 5:56:49 AM) 896 B
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search DocumentAliasInfoProvider.GetDocumentAliasCandidatesInternal ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.000
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search DocumentAliasInfoProvider.GetDocumentAliasCandidatesInternal ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search TreePathUtils.GetAliasPathByNodeId DocumentNodeDataInfoProvider.GetDocumentNodeDataInfoInternal AbstractInfoProvider`3.GetInfoById AbstractInfoProvider`3.GetInfoByColumn AbstractInfoProvider`3.GetDataByColumn ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
5
|
(cms.tree.generalselect) DECLARE @NodeID int = 169;
SELECT * FROM CMS_Tree WHERE [NodeID] = @NodeID
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search TreePathUtils.GetAliasPathByNodeId DocumentNodeDataInfoProvider.GetDocumentNodeDataInfoInternal AbstractInfoProvider`3.GetInfoById AbstractInfoProvider`3.GetInfoByColumn AbstractInfoProvider`3.GetDataByColumn ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.016
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search TreePathUtils.GetAliasPathByNodeId DocumentNodeDataInfoProvider.GetDocumentNodeDataInfoInternal AbstractInfoProvider`3.GetInfoById AbstractInfoProvider`3.GetInfoByColumn AbstractInfoProvider`3.GetDataByColumn ObjectQueryBase`2.EnsureTypedResult DataQueryBase`1.get_Result ObjectQueryBase`2.GetData DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search PageInfoByDocumentAliasesSearcher.GetPageInfoByDocumentAliasInfo PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
6
|
(.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @NodeAliasPath nvarchar(max) = N'/Lander/CMAA'; 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 [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 (1) @NodeAliasPath ("/Lander/CMAA") @DocumentCulture ("en-US") 3.3 kB
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search PageInfoByDocumentAliasesSearcher.GetPageInfoByDocumentAliasInfo PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.000
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search PageInfoByDocumentAliasesSearcher.GetPageInfoByDocumentAliasInfo PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search PageInfoByDocumentAliasesSearcher.GetPageInfoByDocumentAliasInfo PageInfoProvider.GetPageInfo CacheHelper.AddInternal <>c__DisplayClass3.<LogCacheOperation>b__1 DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue AbstractSimpleDataContainer`1.TryGetValue RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate PageInfo.<RegisterColumns>b__2a PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree PageInfo.GetUpperTree TreePathUtils.GetNodeUpperTreeInternal DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
7
|
(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'/Lander', N'/') AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (1) @DocumentCulture ("en-US") 375 B
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search PageInfoByDocumentAliasesSearcher.GetPageInfoByDocumentAliasInfo PageInfoProvider.GetPageInfo CacheHelper.AddInternal <>c__DisplayClass3.<LogCacheOperation>b__1 DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue AbstractSimpleDataContainer`1.TryGetValue RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate PageInfo.<RegisterColumns>b__2a PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree PageInfo.GetUpperTree TreePathUtils.GetNodeUpperTreeInternal DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.000
|
|
|
|
ApplicationModule.PostResolveRequestCache SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute (2) URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetPageInfoForUrl>b__1 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByDocumentAliasesSearcher.Search PageInfoByDocumentAliasesSearcher.GetPageInfoByDocumentAliasInfo PageInfoProvider.GetPageInfo CacheHelper.AddInternal <>c__DisplayClass3.<LogCacheOperation>b__1 DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue AbstractSimpleDataContainer`1.TryGetValue RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate PageInfo.<RegisterColumns>b__2a PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree PageInfo.GetUpperTree TreePathUtils.GetNodeUpperTreeInternal DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo..ctor HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
8
|
(.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US'; DECLARE @NodeID int = 18;
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 (18) 3.1 kB
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo..ctor HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.010
|
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo..ctor HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo..ctor HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo CacheHelper.AddInternal <>c__DisplayClass3.<LogCacheOperation>b__1 DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue AbstractSimpleDataContainer`1.TryGetValue RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate PageInfo.<RegisterColumns>b__2a PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree PageInfo.GetUpperTree TreePathUtils.GetNodeUpperTreeInternal DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
9
|
(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
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo..ctor HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo CacheHelper.AddInternal <>c__DisplayClass3.<LogCacheOperation>b__1 DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue AbstractSimpleDataContainer`1.TryGetValue RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate PageInfo.<RegisterColumns>b__2a PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree PageInfo.GetUpperTree TreePathUtils.GetNodeUpperTreeInternal DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.000
|
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo..ctor HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo CacheHelper.AddInternal <>c__DisplayClass3.<LogCacheOperation>b__1 DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue AbstractSimpleDataContainer`1.TryGetValue RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate PageInfo.<RegisterColumns>b__2a PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree PageInfo.GetUpperTree TreePathUtils.GetNodeUpperTreeInternal DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
CMSWebParts_Text_editabletext.OnInit CMSWebParts_Text_editabletext.SetupControl CMSAbstractWebPart.get_StopProcessing CMSAbstractWebPart.get_HideOnCurrentPage CMSAbstractWebPart.get_IsVisible CMSAbstractEditableWebPart.GetValue CMSAbstractWebPart.GetValueInternal CMSAbstractWebPart.ResolveMacros MacroResolver.ResolveMacros MacroResolver.ResolveMacrosInternal MacroProcessor.ProcessMacros MacroResolver.ResolveMacroHandler MacroResolver.ResolveMacroExpression (2) ExpressionEvaluator.Evaluate ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateCompoundExpression ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateTernaryOperator ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateEquality ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateDataMember MacroResolver.CheckDataSources MacroResolver.CheckDataSourcesInternal (4) MacroResolver.GetObjectValue MacroField.GetValue DocumentMacros.<Init>b__5 DocumentContext.get_CurrentDocument DocumentContext.GetCachedCurrentDocument TreeProvider.SelectSingleNode (4) TreeProvider.SelectNodes NodesDataProvider.GetDataSet MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
10
|
(cms.menuitem.generalselect) 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 (NodeID = 169) AND [DocumentCulture] = @DocumentCulture @DocumentCulture ("en-US") 395 B
|
CMSWebParts_Text_editabletext.OnInit CMSWebParts_Text_editabletext.SetupControl CMSAbstractWebPart.get_StopProcessing CMSAbstractWebPart.get_HideOnCurrentPage CMSAbstractWebPart.get_IsVisible CMSAbstractEditableWebPart.GetValue CMSAbstractWebPart.GetValueInternal CMSAbstractWebPart.ResolveMacros MacroResolver.ResolveMacros MacroResolver.ResolveMacrosInternal MacroProcessor.ProcessMacros MacroResolver.ResolveMacroHandler MacroResolver.ResolveMacroExpression (2) ExpressionEvaluator.Evaluate ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateCompoundExpression ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateTernaryOperator ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateEquality ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateDataMember MacroResolver.CheckDataSources MacroResolver.CheckDataSourcesInternal (4) MacroResolver.GetObjectValue MacroField.GetValue DocumentMacros.<Init>b__5 DocumentContext.get_CurrentDocument DocumentContext.GetCachedCurrentDocument TreeProvider.SelectSingleNode (4) TreeProvider.SelectNodes NodesDataProvider.GetDataSet MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass7.<LogQueryStart>b__5
|
0.016
|
|
|
|
CMSWebParts_Text_editabletext.OnInit CMSWebParts_Text_editabletext.SetupControl CMSAbstractWebPart.get_StopProcessing CMSAbstractWebPart.get_HideOnCurrentPage CMSAbstractWebPart.get_IsVisible CMSAbstractEditableWebPart.GetValue CMSAbstractWebPart.GetValueInternal CMSAbstractWebPart.ResolveMacros MacroResolver.ResolveMacros MacroResolver.ResolveMacrosInternal MacroProcessor.ProcessMacros MacroResolver.ResolveMacroHandler MacroResolver.ResolveMacroExpression (2) ExpressionEvaluator.Evaluate ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateCompoundExpression ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateTernaryOperator ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateEquality ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateDataMember MacroResolver.CheckDataSources MacroResolver.CheckDataSourcesInternal (4) MacroResolver.GetObjectValue MacroField.GetValue DocumentMacros.<Init>b__5 DocumentContext.get_CurrentDocument DocumentContext.GetCachedCurrentDocument TreeProvider.SelectSingleNode (4) TreeProvider.SelectNodes NodesDataProvider.GetDataSet MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData MultiDocumentQueryBase`3.GetDataFromDB DocumentQueryProperties.GetDataInternal MultiDocumentQueryBase`3.<GetDataFromDB>b__4 DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryBase`2.GetDataFromDB DocumentQueryProperties.GetDataInternal DocumentQueryBase`2.<GetDataFromDB>b__2 DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|