|
|
|
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'/Expertise/Technical'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical'; 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'/Expertise/Technical' 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 ("/Expertise/Technical") @NodeAliasPath ("/Expertise/Technical") @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'/Expertise', N'/') AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (1) @DocumentCulture ("en-US") 378 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
|
|
|
|
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
|
|
3
|
(intellicorp.pagegroup.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN IntelliCorp_PageGroup AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[PageGroupID] AND V.ClassName = N'IntelliCorp.PageGroup' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE (NodeID = 40) AND [DocumentCulture] = @DocumentCulture @DocumentCulture ("en-US") 409 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
|
|
4
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; 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'/Expertise/Technical', N'/Expertise', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'IntelliCorp.PageGroup', 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/15/2026 4:18:55 PM) @NodeLevel (2) @DocumentCulture ("en-US") 1.6 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
|
|
|
|
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 DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
5
|
(.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical/%'; DECLARE @NodeLevel int = 3; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM ( ( SELECT [PageGroupID], [MenuItemName], [MenuItemTeaserImage], [promo], [MenuItemGroup], [MenuNavGroups], [Excerpt], [showLearnMoreAnyway], [footerScripting], [CustomCanonicalLink], NULL AS [MenuItemID], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeBodyElementAttributes], [NodeInheritPageLevels], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeCustomData], [NodeGroupID], [NodeLinkedNodeSiteID], [NodeTemplateID], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeHasChildren], [NodeHasLinks], [NodeOriginalNodeID], [NodeIsContentOnly], [NodeIsACLOwner], [NodeBodyScripts], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentModifiedWhen], [DocumentModifiedByUserID], [DocumentForeignKeyValue], [DocumentCreatedByUserID], [DocumentCreatedWhen], [DocumentCheckedOutByUserID], [DocumentCheckedOutWhen], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentNodeID], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuCaption], [DocumentMenuStyle], [DocumentMenuItemImage], [DocumentMenuItemLeftImage], [DocumentMenuItemRightImage], [DocumentPageTemplateID], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentUseNamePathForUrlPath], [DocumentStylesheetID], [DocumentContent], [DocumentMenuClass], [DocumentMenuStyleHighlighted], [DocumentMenuClassHighlighted], [DocumentMenuItemImageHighlighted], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImageHighlighted], [DocumentMenuItemInactive], [DocumentCustomData], [DocumentExtensions], [DocumentTags], [DocumentTagGroupID], [DocumentWildcardRule], [DocumentWebParts], [DocumentRatingValue], [DocumentRatings], [DocumentPriority], [DocumentType], [DocumentLastPublished], [DocumentUseCustomExtensions], [DocumentGroupWebParts], [DocumentCheckedOutAutomatically], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentSearchExcluded], [DocumentLastVersionNumber], [DocumentIsArchived], [DocumentHash], [DocumentLogVisitActivity], [DocumentGUID], [DocumentWorkflowCycleGUID], [DocumentSitemapSettings], [DocumentIsWaitingForTranslation], [DocumentSKUName], [DocumentSKUDescription], [DocumentSKUShortDescription], [DocumentWorkflowActionStatus], [DocumentMenuRedirectToFirstChild], [DocumentCanBePublished], [DocumentInheritsStylesheet], [ClassName], [ClassDisplayName], NodeLevel AS [CMS_O1], NodeOrder AS [CMS_O2], NodeName AS [CMS_O3], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 0 AS [CMS_SN], 'cms.document.intellicorp.pagegroup' AS [CMS_T] FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN IntelliCorp_PageGroup AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[PageGroupID] AND V.ClassName = N'IntelliCorp.PageGroup' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) )
UNION ALL ( SELECT NULL AS [PageGroupID], [MenuItemName], [MenuItemTeaserImage], [promo], [MenuItemGroup], [MenuNavGroups], [Excerpt], [showLearnMoreAnyway], [footerScripting], [CustomCanonicalLink], [MenuItemID], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeBodyElementAttributes], [NodeInheritPageLevels], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeCustomData], [NodeGroupID], [NodeLinkedNodeSiteID], [NodeTemplateID], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeHasChildren], [NodeHasLinks], [NodeOriginalNodeID], [NodeIsContentOnly], [NodeIsACLOwner], [NodeBodyScripts], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentModifiedWhen], [DocumentModifiedByUserID], [DocumentForeignKeyValue], [DocumentCreatedByUserID], [DocumentCreatedWhen], [DocumentCheckedOutByUserID], [DocumentCheckedOutWhen], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentNodeID], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuCaption], [DocumentMenuStyle], [DocumentMenuItemImage], [DocumentMenuItemLeftImage], [DocumentMenuItemRightImage], [DocumentPageTemplateID], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentUseNamePathForUrlPath], [DocumentStylesheetID], [DocumentContent], [DocumentMenuClass], [DocumentMenuStyleHighlighted], [DocumentMenuClassHighlighted], [DocumentMenuItemImageHighlighted], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImageHighlighted], [DocumentMenuItemInactive], [DocumentCustomData], [DocumentExtensions], [DocumentTags], [DocumentTagGroupID], [DocumentWildcardRule], [DocumentWebParts], [DocumentRatingValue], [DocumentRatings], [DocumentPriority], [DocumentType], [DocumentLastPublished], [DocumentUseCustomExtensions], [DocumentGroupWebParts], [DocumentCheckedOutAutomatically], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentSearchExcluded], [DocumentLastVersionNumber], [DocumentIsArchived], [DocumentHash], [DocumentLogVisitActivity], [DocumentGUID], [DocumentWorkflowCycleGUID], [DocumentSitemapSettings], [DocumentIsWaitingForTranslation], [DocumentSKUName], [DocumentSKUDescription], [DocumentSKUShortDescription], [DocumentWorkflowActionStatus], [DocumentMenuRedirectToFirstChild], [DocumentCanBePublished], [DocumentInheritsStylesheet], [ClassName], [ClassDisplayName], NodeLevel AS [CMS_O1], NodeOrder AS [CMS_O2], NodeName AS [CMS_O3], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 1 AS [CMS_SN], 'cms.document.cms.menuitem' AS [CMS_T] FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) )
) AS SubData ORDER BY CMS_O1, CMS_O2, CMS_O3, CMS_SRN, CMS_SN @NodeSiteID (1) @Now (4/15/2026 4:18:55 PM) @NodeAliasPath ("/Expertise/Technical/%") @NodeLevel (3) @DocumentCulture ("en-US") 7.2 kB
|
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 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 DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClassb.<LogConnectionOperation>b__9
|
N/A
|
|
|
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|
|
6
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical/ATS-Integration/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeLevel, NodeOrder, NodeName @NodeSiteID (1) @Now (4/15/2026 4:18:55 PM) @NodeAliasPath ("/Expertise/Technical/ATS-Integration/%") @DocumentCulture ("en-US") 872 B
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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.000
|
|
|
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|
|
|
|
|
N/A
|
|
7
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical/Candidate-Direct-Portal/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeLevel, NodeOrder, NodeName @NodeSiteID (1) @Now (4/15/2026 4:18:55 PM) @NodeAliasPath ("/Expertise/Technical/Candidate-Direct-Portal/%") @DocumentCulture ("en-US") 888 B
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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.000
|
|
|
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|
|
|
|
|
N/A
|
|
8
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical/Self-Service-Batching/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeLevel, NodeOrder, NodeName @NodeSiteID (1) @Now (4/15/2026 4:18:55 PM) @NodeAliasPath ("/Expertise/Technical/Self-Service-Batching/%") @DocumentCulture ("en-US") 884 B
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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.000
|
|
|
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|
|
|
|
|
N/A
|
|
9
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical/Volunteer-Portal/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeLevel, NodeOrder, NodeName @NodeSiteID (1) @Now (4/15/2026 4:18:55 PM) @NodeAliasPath ("/Expertise/Technical/Volunteer-Portal/%") @DocumentCulture ("en-US") 874 B
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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.000
|
|
|
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|
|
|
|
|
N/A
|
|
10
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical/Website/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeLevel, NodeOrder, NodeName @NodeSiteID (1) @Now (4/15/2026 4:18:55 PM) @NodeAliasPath ("/Expertise/Technical/Website/%") @DocumentCulture ("en-US") 856 B
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|
|
|
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|
|
|
|
|
N/A
|
|
11
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 1; DECLARE @Now datetime2 = '4/15/2026 4:18:55 PM'; DECLARE @NodeAliasPath nvarchar(max) = N'/Expertise/Technical/XML-Gateway/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeLevel, NodeOrder, NodeName @NodeSiteID (1) @Now (4/15/2026 4:18:55 PM) @NodeAliasPath ("/Expertise/Technical/XML-Gateway/%") @DocumentCulture ("en-US") 864 B
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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.000
|
|
|
|
cmsvirtualfiles_transformations__vg_96423393_14e0_4b66_8b23_1d16ec251cc8_intellicorp_pagegroup_sectionlaunchpad_ascx.OnInit CMSUniView.ReloadData 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
|