|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry AbstractDataConnection.get_NativeDBConnection <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
1
|
(.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @DocumentUrlPath nvarchar(max) = N'/treatments-centers/intensive-care-unit-(icu)'; DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/intensive-care-unit-(icu)'; DECLARE @DocumentCulture nvarchar(max) = N'en-US'; DECLARE @DocumentCulture1 nvarchar(max) = N'vi-VN';
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 [DocumentCulture] = N'vi-VN' THEN 1 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/treatments-centers/intensive-care-unit-(icu)' 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 OR [DocumentCulture] = @DocumentCulture1)))) ) AS SubData ORDER BY CMS_P DESC @NodeSiteID (34) @DocumentUrlPath ("/treatments-centers/intensive-care-unit-(icu)") @NodeAliasPath ("/treatments-centers/intensive-care-unit-(icu)") @DocumentCulture ("en-US") @DocumentCulture1 ("vi-VN") 3.8 kB
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.062
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue RegisteredProperties`1.Evaluate <>c.<RegisterColumns>b__343_34 PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
2
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 34; 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'/treatments-centers', N'/') AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC @NodeSiteID (34) @DocumentCulture ("en-US") 388 B
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue RegisteredProperties`1.Evaluate <>c.<RegisterColumns>b__343_34 PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
SimpleHandler`2.StartEvent SimpleHandler`2.RaiseExecute URLRewritingHandlers.RewriteUrl URLRewriter.RewriteUrl (2) PageInfoProvider.GetPageInfoForUrl CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass18_0.<GetPageInfoForUrl>b__0 PageInfoDataProvider.GetDataForPageInfoForUrl PageInfoByPathSearcher.Search PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue RegisteredProperties`1.Evaluate <>c.<RegisterColumns>b__343_34 PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
custom_global_templates_master_bumrungrad_master.__BuildControlTree custom_global_templates_master_bumrungrad_master.__BuildControlform custom_global_templates_master_bumrungrad_master.__BuildControl_Header custom_global_templates_partials__header_ascx.__BuildControlTree custom_global_templates_partials__header_ascx.__BuildControlplcHeader custom_global_templates_partials__header_ascx.__BuildControlLanguageSelector custom_global_usercontrols_languageselector_ascx..ctor LanguageSelector..ctor DocumentContext.get_CurrentDocument DocumentContext.GetCachedCurrentDocument TreeProvider.SelectSingleNode (2) NodesDataProvider.GetDataSet MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
3
|
(bumrungrad.conditionandtreatment.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_ConditionAndTreatment AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ConditionAndTreatmentID] AND V.ClassName = N'Bumrungrad.ConditionAndTreatment' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE (NodeID = 10681) AND [DocumentCulture] = @DocumentCulture @DocumentCulture ("en-US") 446 B
|
custom_global_templates_master_bumrungrad_master.__BuildControlTree custom_global_templates_master_bumrungrad_master.__BuildControlform custom_global_templates_master_bumrungrad_master.__BuildControl_Header custom_global_templates_partials__header_ascx.__BuildControlTree custom_global_templates_partials__header_ascx.__BuildControlplcHeader custom_global_templates_partials__header_ascx.__BuildControlLanguageSelector custom_global_usercontrols_languageselector_ascx..ctor LanguageSelector..ctor DocumentContext.get_CurrentDocument DocumentContext.GetCachedCurrentDocument TreeProvider.SelectSingleNode (2) NodesDataProvider.GetDataSet MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.016
|
|
|
custom_global_templates_master_bumrungrad_master.__BuildControlTree custom_global_templates_master_bumrungrad_master.__BuildControlform custom_global_templates_master_bumrungrad_master.__BuildControl_Header custom_global_templates_partials__header_ascx.__BuildControlTree custom_global_templates_partials__header_ascx.__BuildControlplcHeader custom_global_templates_partials__header_ascx.__BuildControlLanguageSelector custom_global_usercontrols_languageselector_ascx..ctor LanguageSelector..ctor DocumentContext.get_CurrentDocument DocumentContext.GetCachedCurrentDocument TreeProvider.SelectSingleNode (2) NodesDataProvider.GetDataSet MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
4
|
(.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US'; DECLARE @NodeID int = 4606;
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 (4606) 3.1 kB
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue RegisteredProperties`1.Evaluate <>c.<RegisterColumns>b__343_34 PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
5
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 34; 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 (34) @DocumentCulture ("en-US") 361 B
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue RegisteredProperties`1.Evaluate <>c.<RegisterColumns>b__343_34 PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo CacheHelper.AddInternal CacheDebug.LogToFile DataHelper.GetObjectString DataHelper.GetDataContainerSize AbstractSimpleDataContainer`1.GetValue RegisteredProperties`1.Evaluate <>c.<RegisterColumns>b__343_34 PageInfo.get_RequiresAuthentication PageInfo.GetValueFromUpperTree PageInfo.get_UpperTree DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
6
|
(.generalselect) DECLARE @DocumentCulture nvarchar(max) = N'en-US'; DECLARE @NodeID int = 4597;
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 (4597) 3.1 kB
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPortalManager.get_HierarchyPageInfo HierarchyPageInfo.ProcessHierarchy PageInfoProvider.GetPageInfo PageInfoDataProvider.GetDataForPageInfo DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
7
|
(cms.personalization.selectall) SELECT TOP 1 * FROM CMS_Personalization WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 27988
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
PageContext.CurrentPage_InitComplete CMSPortalManager.PageHelper_InitComplete CMSPortalManager.LoadPage CMSPagePlaceholder.LoadContent CMSAbstractLayout.LoadContent PersonalizationInfoProvider.GetPersonalizedTemplateInstance PersonalizationInfoProvider.GetUserPersonalization ConnectionHelper.ExecuteQuery DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB MultiDocumentQueryBase`3.GetExecutingQuery DataQueryBase`1.GetListResult DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
8
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/intensive-care-unit-(icu)'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT DISTINCT [ClassName] 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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture) ORDER BY ClassName @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/treatments-centers/intensive-care-unit-(icu)") @DocumentCulture ("en-US") 749 B
|
CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB MultiDocumentQueryBase`3.GetExecutingQuery DataQueryBase`1.GetListResult DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB MultiDocumentQueryBase`3.GetExecutingQuery DataQueryBase`1.GetListResult DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
9
|
(.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/intensive-care-unit-(icu)'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 0 AS [CMS_SN], 'cms.document.bumrungrad.conditionandtreatment' AS [CMS_T] FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_ConditionAndTreatment AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ConditionAndTreatmentID] AND V.ClassName = N'Bumrungrad.ConditionAndTreatment' 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) ) AS SubData ORDER BY CMS_SRN, CMS_SN @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/treatments-centers/intensive-care-unit-(icu)") @DocumentCulture ("en-US") 1.1 kB
|
CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.016
|
|
|
CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
Bumrungrad.Page_Load MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
10
|
(cms.document.generalselect) DECLARE @NodeId int = 10681; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM';
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 [NodeId] = @NodeId AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) @NodeId (10681) @Now (3/22/2023 9:27:40 AM) 429 B
|
Bumrungrad.Page_Load MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.016
|
|
|
Bumrungrad.Page_Load MultiObjectQueryBase`3.EnsureTypedResult DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
_Header.Page_Load ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
11
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeLevel int = 1; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [MenuItemGroup], [MegaMenuBG], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID] 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 (DocumentMenuItemHideInNavigation = 0 AND (MenuItemGroup IS NULL OR MenuItemGroup = 'top')) 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 NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeLevel (1) @DocumentCulture ("en-US") 1.1 kB
|
_Header.Page_Load ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
_Header.Page_Load ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
12
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/about-us/%'; DECLARE @NodeLevel int = 2; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID] 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 (DocumentMenuItemHideInNavigation = 0) 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) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/about-us/%") @NodeLevel (2) @DocumentCulture ("en-US") 978 B
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
13
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/%'; DECLARE @NodeLevel int = 2; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID] 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 (DocumentMenuItemHideInNavigation = 0) 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) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/treatments-centers/%") @NodeLevel (2) @DocumentCulture ("en-US") 998 B
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
14
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/patient-services/%'; DECLARE @NodeLevel int = 2; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID] 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 (DocumentMenuItemHideInNavigation = 0) 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) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/patient-services/%") @NodeLevel (2) @DocumentCulture ("en-US") 994 B
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.016
|
|
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
15
|
(cms.document.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/contact-us/%'; DECLARE @NodeLevel int = 2; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID] 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 (DocumentMenuItemHideInNavigation = 0) 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) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/contact-us/%") @NodeLevel (2) @DocumentCulture ("en-US") 982 B
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
_Header.rptMainNav_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
WhereSelectEnumerableIterator`2.MoveNext <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext <GetEnumerator>d__233.MoveNext <GetEnumeratorInternal>d__234.MoveNext InfoObjectCollection`1.get_InternalCount InfoObjectCollection`1.GetItem InfoObjectCollection`1.GetItemInternal TreeNodeCollection.GetData DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB MultiDocumentQueryBase`3.GetExecutingQuery DataQueryBase`1.GetListResult DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
16
|
(cms.document.generalselect) DECLARE @NodeID int = 10681; DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM';
SELECT DISTINCT [ClassName] 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 [NodeID] = @NodeID AND [NodeSiteID] = @NodeSiteID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) ORDER BY ClassName @NodeID (10681) @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) 534 B
|
WhereSelectEnumerableIterator`2.MoveNext <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext <GetEnumerator>d__233.MoveNext <GetEnumeratorInternal>d__234.MoveNext InfoObjectCollection`1.get_InternalCount InfoObjectCollection`1.GetItem InfoObjectCollection`1.GetItemInternal TreeNodeCollection.GetData DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB MultiDocumentQueryBase`3.GetExecutingQuery DataQueryBase`1.GetListResult DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
WhereSelectEnumerableIterator`2.MoveNext <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext <GetEnumerator>d__233.MoveNext <GetEnumeratorInternal>d__234.MoveNext InfoObjectCollection`1.get_InternalCount InfoObjectCollection`1.GetItem InfoObjectCollection`1.GetItemInternal TreeNodeCollection.GetData DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB MultiDocumentQueryBase`3.GetExecutingQuery DataQueryBase`1.GetListResult DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
WhereSelectEnumerableIterator`2.MoveNext <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext <GetEnumerator>d__233.MoveNext <GetEnumeratorInternal>d__234.MoveNext InfoObjectCollection`1.get_InternalCount InfoObjectCollection`1.GetItem InfoObjectCollection`1.GetItemInternal TreeNodeCollection.GetData DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
17
|
(.generalselect) DECLARE @NodeID int = 10681; DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM';
SELECT * FROM ( SELECT [ConditionAndTreatmentID], [Title], [Content], [Icon], [ImageTile], [BannerImage], [IconName], [TitleAlignment], [DocumentCulture], DocumentName AS [CMS_O1], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 0 AS [CMS_SN], 'cms.document.bumrungrad.conditionandtreatment' AS [CMS_T], [ClassName] FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_ConditionAndTreatment AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ConditionAndTreatmentID] AND V.ClassName = N'Bumrungrad.ConditionAndTreatment' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID] WHERE [NodeID] = @NodeID AND [NodeSiteID] = @NodeSiteID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) ) AS SubData ORDER BY CMS_O1, CMS_SRN, CMS_SN @NodeID (10681) @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) 1 kB
|
WhereSelectEnumerableIterator`2.MoveNext <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext <GetEnumerator>d__233.MoveNext <GetEnumeratorInternal>d__234.MoveNext InfoObjectCollection`1.get_InternalCount InfoObjectCollection`1.GetItem InfoObjectCollection`1.GetItemInternal TreeNodeCollection.GetData DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
WhereSelectEnumerableIterator`2.MoveNext <System-Collections-Generic-IEnumerable<TObject>-GetEnumerator>d__5.MoveNext <GetEnumerator>d__233.MoveNext <GetEnumeratorInternal>d__234.MoveNext InfoObjectCollection`1.get_InternalCount InfoObjectCollection`1.GetItem InfoObjectCollection`1.GetItemInternal TreeNodeCollection.GetData DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
CMSAbstractWebPart.OnLoad LanguageSelector.SetupControl CultureInfoProvider.GetCultures 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__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
18
|
(cms.culture.generalselect) SELECT * FROM CMS_Culture WHERE ((LOWER(CultureCode) LIKE 'en-us'))
|
CMSAbstractWebPart.OnLoad LanguageSelector.SetupControl CultureInfoProvider.GetCultures 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__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSAbstractWebPart.OnLoad LanguageSelector.SetupControl CultureInfoProvider.GetCultures 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__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
_Footer.Page_Load ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
19
|
(cms.menuitem.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [MenuItemGroup], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID] 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 (DocumentMenuItemHideInNavigation = 0 AND MenuItemGroup = 'footer-center') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @DocumentCulture ("en-US") 994 B
|
_Footer.Page_Load ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
_Footer.Page_Load ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
BasicRepeater.OnLoad CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
20
|
(bumrungrad.footerlinkscolumn.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; 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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND V.ClassName = N'bumrungrad.footerlinkscolumn' AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @DocumentCulture ("en-US") 608 B
|
BasicRepeater.OnLoad CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.016
|
|
|
BasicRepeater.OnLoad CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
BasicRepeater.BasicRepeater_DataBinding CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
21
|
(bumrungrad.footerlink.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/intensive-care-unit-(icu)'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/treatments-centers/intensive-care-unit-(icu)") @DocumentCulture ("en-US") 879 B
|
BasicRepeater.BasicRepeater_DataBinding CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
BasicRepeater.BasicRepeater_DataBinding CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
22
|
(bumrungrad.footerlink.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/about/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/data/footer-links/about/%") @DocumentCulture ("en-US") 844 B
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
23
|
(bumrungrad.footerlink.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/medical-services/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/data/footer-links/medical-services/%") @DocumentCulture ("en-US") 866 B
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.016
|
|
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
24
|
(bumrungrad.footerlink.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/patient-services/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/data/footer-links/patient-services/%") @DocumentCulture ("en-US") 866 B
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
|
N/A
|
25
|
(bumrungrad.footerlink.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/contact-us/%'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @NodeAliasPath ("/data/footer-links/contact-us/%") @DocumentCulture ("en-US") 854 B
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
CMSRepeater.CMSRepeater_ItemDataBound ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
|
|
BasicRepeater.OnLoad CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|
26
|
(bumrungrad.footercontactinfo.generalselect) DECLARE @NodeSiteID int = 34; DECLARE @Now datetime2 = '3/22/2023 9:27:40 AM'; DECLARE @DocumentCulture nvarchar(max) = N'en-US';
SELECT * FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterContactInfo AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterContactInfoID] AND V.ClassName = N'Bumrungrad.FooterContactInfo' 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 [DocumentCulture] = @DocumentCulture) ORDER BY NodeOrder @NodeSiteID (34) @Now (3/22/2023 9:27:40 AM) @DocumentCulture ("en-US") 728 B
|
BasicRepeater.OnLoad CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry GeneralConnection.LogQueryStart <>c__DisplayClass15_0.<LogQueryStart>b__0
|
0.000
|
|
|
BasicRepeater.OnLoad CMSRepeater.InitControl ControlsExtensions.CallHandled CMSRepeater.ReloadDataInternal CMSBaseDataSource.get_DataSource CMSDocumentsDataSource.GetDataSource CMSAbstractDataProperties.LoadData CMSAbstractDataProperties.GetDataSet CacheHelper.Cache CachedSection`1.LoadDataHandled <>c__DisplayClass86_0`1.<Cache>b__0 <>c__DisplayClass53_0.<GetDataSet>b__0 DataQueryBase`1.get_Result DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetResults DataQueryBase`1.get_Result DocumentQueryBase`2.GetData ObjectQueryBase`2.GetData DataQueryBase`1.GetData DocumentQueryProperties.GetDataInternal DataQueryBase`1.GetDataFromDB ObjectQueryBase`2.GetResults DataQueryBase`1.get_Result DataQueryBase`1.GetData DataQueryBase`1.GetDataFromDB DataQueryBase`1.GetDataFromDBInternal GeneralConnection.RunQueryWithRetry <>c__DisplayClass19_0.<LogConnectionOperation>b__0
|
N/A
|