|
|
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'/shop/targeted-vibration/power-plate-roller'; DECLARE @NodeAliasPath nvarchar(max) = N'/shop/targeted-vibration/power-plate-roller'; 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'/shop/targeted-vibration/power-plate-roller' 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 ("/shop/targeted-vibration/power-plate-roller") @NodeAliasPath ("/shop/targeted-vibration/power-plate-roller") @DocumentCulture ("en-US") 3.6 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.031
|
|
|
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 PageInfoCacheHelper.GetDependencyCacheKeys PageInfo.get_UsedPageTemplateInfo PageInfo.get_DesignPageTemplateInfo PageInfo.EnsurePageTemplateInfo PageInfo.GetInheritedTemplateInfo 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
|
2
|
(.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @NodeAliasPath nvarchar(max) = N'/Shop/Targeted-Vibration'; 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 ("/Shop/Targeted-Vibration") @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 PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoCacheHelper.GetDependencyCacheKeys PageInfo.get_UsedPageTemplateInfo PageInfo.get_DesignPageTemplateInfo PageInfo.EnsurePageTemplateInfo PageInfo.GetInheritedTemplateInfo 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 PageInfoCacheHelper.GetDependencyCacheKeys PageInfo.get_UsedPageTemplateInfo PageInfo.get_DesignPageTemplateInfo PageInfo.EnsurePageTemplateInfo PageInfo.GetInheritedTemplateInfo 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 PageInfoCacheHelper.GetDependencyCacheKeys PageInfo.get_UsedPageTemplateInfo PageInfo.get_DesignPageTemplateInfo PageInfo.EnsurePageTemplateInfo PageInfo.GetInheritedTemplateInfo PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile 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
|
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'/Shop', N'/') AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (1) @DocumentCulture ("en-US") 373 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 PageInfoCacheHelper.GetDependencyCacheKeys PageInfo.get_UsedPageTemplateInfo PageInfo.get_DesignPageTemplateInfo PageInfo.EnsurePageTemplateInfo PageInfo.GetInheritedTemplateInfo PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile 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 PageInfoCacheHelper.GetDependencyCacheKeys PageInfo.get_UsedPageTemplateInfo PageInfo.get_DesignPageTemplateInfo PageInfo.EnsurePageTemplateInfo PageInfo.GetInheritedTemplateInfo PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile 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
|
|
|
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 CacheDebug.LogToFile 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] IN (N'/Shop/Targeted-Vibration', N'/Shop', N'/') AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (1) @DocumentCulture ("en-us") 402 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 CacheDebug.LogToFile 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.031
|
|
|
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 CacheDebug.LogToFile 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
|
5
|
(.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US'; DECLARE @NodeID int = 10;
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 (10) 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 CacheDebug.LogToFile 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
|
6
|
(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 CacheDebug.LogToFile 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.016
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo..ctor HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile 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
|
7
|
(.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..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
|
|
|
CMSWebParts_Ecommerce_Checkout_Selectors_AutoCurrencySelection.OnLoad ECommerceContext.get_CurrentShoppingCart CurrentShoppingCartService.GetCurrentShoppingCart CurrentShoppingCartService.CreateCart CurrentShoppingCartStrategy.TakeOverCart ContactMembershipInfoProvider.GetContactIDByMembership DataQueryBase`1.GetScalarResult 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
|
8
|
(om.membership.generalselect) DECLARE @RelatedID int = 65; DECLARE @MemberType nvarchar = NULL;
SELECT [ContactID] FROM OM_Membership WHERE [RelatedID] = @RelatedID AND [MemberType] = @MemberType @RelatedID (65) @MemberType (CmsUser) 182 B
|
CMSWebParts_Ecommerce_Checkout_Selectors_AutoCurrencySelection.OnLoad ECommerceContext.get_CurrentShoppingCart CurrentShoppingCartService.GetCurrentShoppingCart CurrentShoppingCartService.CreateCart CurrentShoppingCartStrategy.TakeOverCart ContactMembershipInfoProvider.GetContactIDByMembership DataQueryBase`1.GetScalarResult 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
|
|
|
CMSWebParts_Ecommerce_Checkout_Selectors_AutoCurrencySelection.OnLoad ECommerceContext.get_CurrentShoppingCart CurrentShoppingCartService.GetCurrentShoppingCart CurrentShoppingCartService.CreateCart CurrentShoppingCartStrategy.TakeOverCart ContactMembershipInfoProvider.GetContactIDByMembership DataQueryBase`1.GetScalarResult 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
|
|
|
BasicRepeater.OnLoad CMSRepeater.InitControl CMSRepeater.ReloadData ControlsExtensions.CallHandled <>c__DisplayClass3.<ReloadData>b__2 CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSBaseDataSource.GetDataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetDataSet>b__1 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.product_powerplate_tvps.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '1/23/2021 1:20:21 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Shop/Targeted-Vibration/Power-Plate-Roller'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CMS_Product_PowerPlate_Models AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[Product_PowerPlate_ModelsID] AND V.ClassName = N'CMS.Product_PowerPlate_TVPs' 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 [DocumentCulture] = @DocumentCulture) @NodeSiteID (1) @Now (1/23/2021 1:20:21 AM) @NodeAliasPath ("/Shop/Targeted-Vibration/Power-Plate-Roller") @DocumentCulture ("en-US") 883 B
|
BasicRepeater.OnLoad CMSRepeater.InitControl CMSRepeater.ReloadData ControlsExtensions.CallHandled <>c__DisplayClass3.<ReloadData>b__2 CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSBaseDataSource.GetDataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetDataSet>b__1 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
|
|
|
BasicRepeater.OnLoad CMSRepeater.InitControl CMSRepeater.ReloadData ControlsExtensions.CallHandled <>c__DisplayClass3.<ReloadData>b__2 CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSBaseDataSource.GetDataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass2`1.<Cache>b__0 <>c__DisplayClass2.<GetDataSet>b__1 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_PowerPlateWebParts_PP_ShoppingCartItemSelector.OnLoad CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.ReloadData CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.LoadProductOptions OptionCategoryInfoProvider.GetProductOptionCategoriesInternal AbstractInfoProvider`3.ExecuteQuery ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
10
|
(ecommerce.optioncategory.selectoptioncategorylist) SELECT * FROM View_COM_SKUOptionCategory_OptionCategory_Joined WHERE [SKUID] = 61 ORDER BY SKUCategoryOrder
|
CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.OnLoad CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.ReloadData CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.LoadProductOptions OptionCategoryInfoProvider.GetProductOptionCategoriesInternal AbstractInfoProvider`3.ExecuteQuery ConnectionHelper.ExecuteQuery 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_PowerPlateWebParts_PP_ShoppingCartItemSelector.OnLoad CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.ReloadData CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.LoadProductOptions OptionCategoryInfoProvider.GetProductOptionCategoriesInternal AbstractInfoProvider`3.ExecuteQuery ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.OnPreRender CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.get_SKUHasOptions SKUInfoProvider.HasSKUEnabledOptionsInternal 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
|
11
|
(ecommerce.sku.generalselect) DECLARE @SKUEnabled bit = 1; DECLARE @SKUID int = 61;
SELECT TOP 1 [SKUID] FROM COM_SKU WHERE [SKUEnabled] = @SKUEnabled AND [SKUOptionCategoryID] IN ( SELECT [CategoryID] FROM COM_SKUOptionCategory WHERE [SKUID] = @SKUID ) @SKUEnabled (True) @SKUID (61) 242 B
|
CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.OnPreRender CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.get_SKUHasOptions SKUInfoProvider.HasSKUEnabledOptionsInternal 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.015
|
|
|
CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.OnPreRender CMSWebParts_PowerPlateWebParts_PP_ShoppingCartItemSelector.get_SKUHasOptions SKUInfoProvider.HasSKUEnabledOptionsInternal 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
|