|
|
|
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'/About-Us/Contact-Us'; DECLARE @NodeAliasPath nvarchar(max) = N'/About-Us/Contact-Us'; 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'/About-Us/Contact-Us' 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 ("/About-Us/Contact-Us") @NodeAliasPath ("/About-Us/Contact-Us") @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 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
|
|
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] IN (N'/About-Us', N'/') AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (1) @DocumentCulture ("en-US") 377 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 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 PageInfoByPathSearcher.Search 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
|
|
3
|
(.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US'; DECLARE @NodeID int = 11;
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 (11) 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.000
|
|
|
|
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
|
|
4
|
(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
|
|
|
|
CMSAbstractWebPart.OnInit CMSAbstractWebPart.get_StopProcessing CMSAbstractWebPart.get_HideOnCurrentPage CMSAbstractWebPart.get_IsVisible CMSAbstractWebPart.GetValue CMSAbstractWebPart.GetValueInternal CMSAbstractWebPart.ResolveMacros MacroResolver.ResolveMacros MacroResolver.ResolveMacrosInternal MacroProcessor.ProcessMacros MacroResolver.ResolveMacroHandler MacroResolver.ResolveMacroExpression (2) ExpressionEvaluator.Evaluate ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.PrepareParameters ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateProperty ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateProperty MacroResolver.GetObjectValue AbstractHierarchicalObject`1.TryGetProperty (2) RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate CMSContext.<RegisterProperties>b__4 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
|
|
5
|
(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 = 60) AND [DocumentCulture] = @DocumentCulture @DocumentCulture ("en-US") 394 B
|
CMSAbstractWebPart.OnInit CMSAbstractWebPart.get_StopProcessing CMSAbstractWebPart.get_HideOnCurrentPage CMSAbstractWebPart.get_IsVisible CMSAbstractWebPart.GetValue CMSAbstractWebPart.GetValueInternal CMSAbstractWebPart.ResolveMacros MacroResolver.ResolveMacros MacroResolver.ResolveMacrosInternal MacroProcessor.ProcessMacros MacroResolver.ResolveMacroHandler MacroResolver.ResolveMacroExpression (2) ExpressionEvaluator.Evaluate ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.PrepareParameters ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateProperty ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateProperty MacroResolver.GetObjectValue AbstractHierarchicalObject`1.TryGetProperty (2) RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate CMSContext.<RegisterProperties>b__4 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.000
|
|
|
|
CMSAbstractWebPart.OnInit CMSAbstractWebPart.get_StopProcessing CMSAbstractWebPart.get_HideOnCurrentPage CMSAbstractWebPart.get_IsVisible CMSAbstractWebPart.GetValue CMSAbstractWebPart.GetValueInternal CMSAbstractWebPart.ResolveMacros MacroResolver.ResolveMacros MacroResolver.ResolveMacrosInternal MacroProcessor.ProcessMacros MacroResolver.ResolveMacroHandler MacroResolver.ResolveMacroExpression (2) ExpressionEvaluator.Evaluate ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateMethodCall ExpressionEvaluator.PrepareParameters ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateProperty ExpressionEvaluator.EvaluateChild ExpressionEvaluator.EvaluateInternal ExpressionEvaluator.EvaluateProperty MacroResolver.GetObjectValue AbstractHierarchicalObject`1.TryGetProperty (2) RegisteredProperties`1.Evaluate PropertySettings`1.Evaluate CMSContext.<RegisterProperties>b__4 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
|
|
|
|
CMSAbstractMenuProperties.OnLoad CMSBreadCrumbs.InitControl CMSBreadCrumbs.ReloadData CMSBreadCrumbs.GetDataSet CMSBreadCrumbs.GetNodeDataSet 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
|
|
6
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/13/2026 4:35:03 AM'; DECLARE @NodeLevel int = 2; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings] 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'/About-Us/Contact-Us', N'/About-Us', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'IntelliCorp.Product')) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeAliasPath DESC @NodeSiteID (1) @Now (4/13/2026 4:35:03 AM) @NodeLevel (2) @DocumentCulture ("en-US") 1.5 kB
|
CMSAbstractMenuProperties.OnLoad CMSBreadCrumbs.InitControl CMSBreadCrumbs.ReloadData CMSBreadCrumbs.GetDataSet CMSBreadCrumbs.GetNodeDataSet 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
|
|
|
|
CMSAbstractMenuProperties.OnLoad CMSBreadCrumbs.InitControl CMSBreadCrumbs.ReloadData CMSBreadCrumbs.GetDataSet CMSBreadCrumbs.GetNodeDataSet 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
|