Back to Top
Close Menu
 
Campus IT Services logo
Menu
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute ApplicationModule.BeginRequest
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute ApplicationModule.AuthenticateRequest
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute ApplicationModule.AuthorizeRequest
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute ApplicationModule.PostAuthorizeRequest
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute ApplicationModule.PostResolveRequestCache
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData ApplicationModule.PostResolveRequestCache
7 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostResolveRequestCache
8 >> TypeInfo(cms.pagetemplate).Events.GetData ApplicationModule.PostResolveRequestCache
9 >> URLRewritingEvents.ProcessABTest.Execute ApplicationModule.PostResolveRequestCache
>>> ABHandlers.ProcessABTest
10 >> URLRewritingEvents.ProcessRewritingResult ApplicationModule.PostResolveRequestCache
11 RequestEvents.PostMapRequestHandler.Execute ApplicationModule.PostMapRequestHandler
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
12 ApplicationEvents.SessionStart.Execute CMSHttpApplication.Session_Start
> MembershipHandlers.SessionStart
13 >> SessionEvents.UpdateSession CMSHttpApplication.Session_Start
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
14 RequestEvents.AcquireRequestState.Execute ApplicationModule.AcquireRequestState
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
15 RequestEvents.PostAcquireRequestState.Execute ApplicationModule.PostAcquireRequestState
> MembershipHandlers.UpdateSession
16 >> SessionEvents.UpdateSession ApplicationModule.PostAcquireRequestState
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
17 >> DocumentEvents.GetData ApplicationModule.PostAcquireRequestState
18 >>> TypeInfo(cms.document).Events.GetData ApplicationModule.PostAcquireRequestState
19 >> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
20 >>> TypeInfo(om.abvariant).Events.GetData ApplicationModule.PostAcquireRequestState
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
21 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
22 TypeInfo(cms.document).Events.GetData PageContext.CurrentPage_InitComplete
23 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
24 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
25 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
26 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
27 TypeInfo(cms.document).Events.GetData PageContext.CurrentPage_InitComplete
28 DocumentEvents.GetData BasicUniView.OnLoad
29 TypeInfo(cms.document.cms.menuitem).Events.GetData BasicUniView.OnLoad
30 TypeInfo(cms.documentlocalization).Events.GetData TextTransformationTemplate.ltl_DataBinding
31 TypeInfo(cms.node).Events.GetData TextTransformationTemplate.ltl_DataBinding
32 DocumentEvents.GetData TextTransformationTemplate.ltl_DataBinding
33 TypeInfo(cms.document.cms.menuitem).Events.GetData TextTransformationTemplate.ltl_DataBinding
34 TypeInfo(cms.documentlocalization).Events.GetData TextTransformationTemplate.ltl_DataBinding
35 TypeInfo(cms.node).Events.GetData TextTransformationTemplate.ltl_DataBinding
36 DocumentEvents.GetData TextTransformationTemplate.ltl_DataBinding
37 TypeInfo(cms.document.cms.menuitem).Events.GetData TextTransformationTemplate.ltl_DataBinding
38 TypeInfo(cms.documentlocalization).Events.GetData TextTransformationTemplate.ltl_DataBinding
39 TypeInfo(cms.node).Events.GetData TextTransformationTemplate.ltl_DataBinding
40 DocumentEvents.GetData TextTransformationTemplate.ltl_DataBinding
41 TypeInfo(cms.document.cms.menuitem).Events.GetData TextTransformationTemplate.ltl_DataBinding
42 TypeInfo(cms.documentlocalization).Events.GetData TextTransformationTemplate.ltl_DataBinding
43 TypeInfo(cms.node).Events.GetData TextTransformationTemplate.ltl_DataBinding
44 DocumentEvents.GetData TextTransformationTemplate.ltl_DataBinding
45 TypeInfo(cms.document.cms.menuitem).Events.GetData TextTransformationTemplate.ltl_DataBinding
46 TypeInfo(cms.documentlocalization).Events.GetData TextTransformationTemplate.ltl_DataBinding
47 TypeInfo(cms.node).Events.GetData TextTransformationTemplate.ltl_DataBinding
48 DocumentEvents.GetData TextTransformationTemplate.ltl_DataBinding
49 TypeInfo(cms.document.cms.menuitem).Events.GetData TextTransformationTemplate.ltl_DataBinding
50 TypeInfo(cms.documentlocalization).Events.GetData TextTransformationTemplate.ltl_DataBinding
51 TypeInfo(cms.node).Events.GetData TextTransformationTemplate.ltl_DataBinding
52 DocumentEvents.GetData TextTransformationTemplate.ltl_DataBinding
53 TypeInfo(cms.document.cms.menuitem).Events.GetData TextTransformationTemplate.ltl_DataBinding
54 TypeInfo(cms.documentlocalization).Events.GetData TextTransformationTemplate.ltl_DataBinding
55 TypeInfo(cms.node).Events.GetData TextTransformationTemplate.ltl_DataBinding
56 DocumentEvents.GetData TextTransformationTemplate.ltl_DataBinding
57 TypeInfo(cms.document.cms.menuitem).Events.GetData TextTransformationTemplate.ltl_DataBinding
58 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
59 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
60 TypeInfo(cms.settingskey).Events.GetData BasicRepeater.OnLoad
61 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
62 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
63 TypeInfo(cms.category).Events.GetData BasicRepeater.OnLoad
64 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
65 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
66 TypeInfo(cms.user).Events.GetData BasicRepeater.OnLoad
67 DocumentEvents.GetData BasicRepeater.OnLoad
68 TypeInfo(cms.document).Events.GetData BasicRepeater.OnLoad
69 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Data/Persistent/Cache/CampusITServices/outputdata/0096/m1491075608.cache Local ApplicationModule.AuthorizeRequest
2 DIREXISTS
~/App_Themes/CITSCSS Local ContentPage.OnPreInit
3 EXISTS
~/CMSControls/cave_footer_responsive.ascx Local DbPathProvider.GetFileHash
4 EXISTS
~/CMSControls/cave_footer_responsive.ascx.cs Local
5 EXISTS
~/CMSControls/cave_header_responsive.ascx Local
6 EXISTS
~/CMSControls/cave_header_responsive.ascx.cs Local
7 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
8 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
9 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
10 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|campusitservices|/services/all-services|en-us|/services/all-services|true
template|628
nodeid|19002
pageinfo
ApplicationModule.PostResolveRequestCache
2 ADD pageinfobyurl|campusitservices|https://www.cavehill.uwi.edu/campusitservices/services/all-services.aspx|en-us||true|true
template|628
nodeid|19002
pageinfo
ApplicationModule.PostResolveRequestCache
3 GET cms.searchengine|cachedids|crawlers ApplicationModule.PostAcquireRequestState
4 ADD pageinfo|campusitservices|/16987|en-us||false
template|552
nodeid|16180
pageinfo
PageContext.CurrentPage_InitComplete
5 ADD pageinfo|campusitservices|/|en-us||false
template|511
nodeid|15088
pageinfo
6 ADD cmsmenudatasource||en-us|campusitservices|/16987/%|en-us|false||||1|true||false|false
webpartinstance|6a6d7bd6-9d83-4f04-a6c7-09cb01b88ef8
node|campusitservices|/16987|childnodes
PageContext.CurrentPage_InitComplete
7 ADD cmsdatasource||en-us|campusitservices|/%|en-us|false|cms.menuitem|documentmenuitemhideinnavigation = 0|nodelevel, nodeorder|1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0|documentname, nodealiaspath,documentid|false||
webpartinstance|db33e4e7-269c-4eda-ab62-c8bd6c11072a
nodes|campusitservices|cms.menuitem|all
node|campusitservices|/|childnodes
BasicUniView.OnLoad
8 ADD breadcrumbs|campusitservices|/16987/19812|en-us|false|cms.menuitem||true|
webpartinstance|128e5c53-8e68-4bd2-8873-8834df06fccf
node|campusitservices|/16987/19812|childnodes
CMSAbstractMenuProperties.OnLoad
9 ADD cmsdatasource||en-us|campusitservices|/%|en-us|false|||nodename asc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|citsservices|
webpartinstance|2d717ae6-cd94-4e11-a072-1a4de4688a73
node|campusitservices|/|childnodes
BasicRepeater.OnLoad
10 ADD scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /services/all-services.aspx 0.000
0.500
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.500
0.047
 
3 > OnPreInit 0.547
0.016
 
4 > OnInit 0.563
0.219
 
5 > OnLoad 0.781
3.063
 
6 > OnPreRender 3.844
N/A
    3.844  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookieVg0nwljBwykBpSQQAina0C0Aph8bdFJP/OKbBwNE
3 ASP.NET_SessionIdnefozuxumiqvevb5iwqengjr
4 Campaign 
5 Source 
6 CMSCurrentThemeCITSCSS
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US4/24/2020 10:26:13 AM
2 CMSCsrfCookieVg0nwljBwykBpSQQAina0C0Aph8bdFJP/OKbBwNE 
3 ASP.NET_SessionIdnefozuxumiqvevb5iwqengjr 
4 Campaign 4/24/2018 10:26:13 AM
5 Source 4/24/2018 10:26:13 AM
6 CMSCurrentThemeCITSCSS4/25/2019 10:26:13 AM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.90.86.231
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDnefozuxumiqvevb5iwqengjr
8 ServerNameARES1_campusitservices
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 88;
DECLARE @DocumentUrlPath nvarchar(max) = N'/services/all-services';
DECLARE @NodeAliasPath nvarchar(max) = N'/services/all-services';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @DocumentCulture1 nvarchar(max) = N'en-GB';
DECLARE @Now datetime2 = '4/24/2019 10:26:13 AM';

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], [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'en-GB' THEN 1 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/services/all-services' 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], [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)))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.8 kB
 
Table (1 [64], 962 B)
 
ApplicationModule.PostResolveRequestCache 0.047
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 88;
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'/16987', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 1.7 kB)
 
ApplicationModule.PostResolveRequestCache 0.016
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostResolveRequestCache N/A
3
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 628;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 13.7 kB)
 
ApplicationModule.PostResolveRequestCache 0.438
 
CloseConnection()
ApplicationModule.PostResolveRequestCache N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
4
(cms.document.generalselect)
DECLARE @NodeSiteID int = 88;
DECLARE @NodeGUID uniqueidentifier = 'ae5dbe2e-85af-4585-9cf8-422db28bde3e';
DECLARE @Now datetime2 = '4/24/2019 10:26:13 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 [NodeSiteID] = @NodeSiteID AND [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
524 B
 
Table (1 [157], 1.3 kB)
 
ApplicationModule.PostAcquireRequestState 0.000
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
ApplicationModule.PostAcquireRequestState N/A
5
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/16987/19812';
DECLARE @ABVariantSiteID int = 88;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
ApplicationModule.PostAcquireRequestState 0.000
 
CloseConnection()
ApplicationModule.PostAcquireRequestState N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
6
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 16180;
DECLARE @Now datetime2 = '4/24/2019 10:26:13 AM';

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], [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], [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) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.3 kB
 
Table (1 [64], 491 B)
 
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
7
(cms.document.generalselect)
DECLARE @NodeSiteID int = 88;
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
Table (1 [157], 922 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
8
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 15088;
DECLARE @Now datetime2 = '4/24/2019 10:26:13 AM';

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], [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], [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) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.3 kB
 
Table (1 [64], 609 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
9
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 19812
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
10
(cms.document.generalselect)
DECLARE @NodeSiteID int = 88;
DECLARE @Now datetime2 = '4/24/2019 10:26:14 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/16987/%';
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 (DocumentMenuItemHideInNavigation = 0)) AND ([ClassName] = N'CMS.MenuItem') 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 NodeLevel, NodeOrder, DocumentName
1.6 kB
 
Table (6 [36], 1.3 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
BasicUniView.OnLoad N/A
11
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 88;
DECLARE @Now datetime2 = '4/24/2019 10:26:14 AM';
DECLARE @NodeLevel int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [DocumentName], [NodeAliasPath], [DocumentID], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder
934 B
 
Table (7 [11], 418 B)
 
BasicUniView.OnLoad 0.219
 
CloseConnection()
BasicUniView.OnLoad N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
12
(cms.document.generalselect)
DECLARE @DocumentID int = 15850;

SELECT TOP 1 [DocumentNodeID]
FROM CMS_Document
WHERE [DocumentID] = @DocumentID
Table (1 [1], 4 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
13
(cms.tree.generalselect)
DECLARE @NodeID int = 15091;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
Table (1 [33], 149 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
14
(cms.menuitem.generalselect)
DECLARE @DocumentID int = 15850;

SELECT TOP 1 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK) 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 [DocumentID] = @DocumentID AND [NodeLinkedNodeID] IS NULL
Table (1 [160], 3.2 kB)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
15
(cms.document.generalselect)
DECLARE @DocumentID int = 17344;

SELECT TOP 1 [DocumentNodeID]
FROM CMS_Document
WHERE [DocumentID] = @DocumentID
Table (1 [1], 4 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
16
(cms.tree.generalselect)
DECLARE @NodeID int = 16537;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
Table (1 [33], 156 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
17
(cms.menuitem.generalselect)
DECLARE @DocumentID int = 17344;

SELECT TOP 1 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK) 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 [DocumentID] = @DocumentID AND [NodeLinkedNodeID] IS NULL
Table (1 [160], 2.7 kB)
 
TextTransformationTemplate.ltl_DataBinding 0.000
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
18
(cms.document.generalselect)
DECLARE @DocumentID int = 16987;

SELECT TOP 1 [DocumentNodeID]
FROM CMS_Document
WHERE [DocumentID] = @DocumentID
Table (1 [1], 4 B)
 
TextTransformationTemplate.ltl_DataBinding 0.172
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
19
(cms.tree.generalselect)
DECLARE @NodeID int = 16180;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
Table (1 [33], 152 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
20
(cms.menuitem.generalselect)
DECLARE @DocumentID int = 16987;

SELECT TOP 1 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK) 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 [DocumentID] = @DocumentID AND [NodeLinkedNodeID] IS NULL
Table (1 [160], 838 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
21
(cms.document.generalselect)
DECLARE @DocumentID int = 16054;

SELECT TOP 1 [DocumentNodeID]
FROM CMS_Document
WHERE [DocumentID] = @DocumentID
Table (1 [1], 4 B)
 
TextTransformationTemplate.ltl_DataBinding 0.031
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
22
(cms.tree.generalselect)
DECLARE @NodeID int = 15295;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
Table (1 [33], 164 B)
 
TextTransformationTemplate.ltl_DataBinding 0.000
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
23
(cms.menuitem.generalselect)
DECLARE @DocumentID int = 16054;

SELECT TOP 1 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK) 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 [DocumentID] = @DocumentID AND [NodeLinkedNodeID] IS NULL
Table (1 [160], 776 B)
 
TextTransformationTemplate.ltl_DataBinding 0.000
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
24
(cms.document.generalselect)
DECLARE @DocumentID int = 16031;

SELECT TOP 1 [DocumentNodeID]
FROM CMS_Document
WHERE [DocumentID] = @DocumentID
Table (1 [1], 4 B)
 
TextTransformationTemplate.ltl_DataBinding 0.047
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
25
(cms.tree.generalselect)
DECLARE @NodeID int = 15272;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
Table (1 [33], 147 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
26
(cms.menuitem.generalselect)
DECLARE @DocumentID int = 16031;

SELECT TOP 1 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK) 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 [DocumentID] = @DocumentID AND [NodeLinkedNodeID] IS NULL
Table (1 [160], 1.1 kB)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
27
(cms.document.generalselect)
DECLARE @DocumentID int = 17118;

SELECT TOP 1 [DocumentNodeID]
FROM CMS_Document
WHERE [DocumentID] = @DocumentID
Table (1 [1], 4 B)
 
TextTransformationTemplate.ltl_DataBinding 0.172
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
28
(cms.tree.generalselect)
DECLARE @NodeID int = 16311;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
Table (1 [33], 151 B)
 
TextTransformationTemplate.ltl_DataBinding 0.016
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
29
(cms.menuitem.generalselect)
DECLARE @DocumentID int = 17118;

SELECT TOP 1 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK) 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 [DocumentID] = @DocumentID AND [NodeLinkedNodeID] IS NULL
Table (1 [160], 852 B)
 
TextTransformationTemplate.ltl_DataBinding 0.047
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
30
(cms.document.generalselect)
DECLARE @DocumentID int = 15926;

SELECT TOP 1 [DocumentNodeID]
FROM CMS_Document
WHERE [DocumentID] = @DocumentID
Table (1 [1], 4 B)
 
TextTransformationTemplate.ltl_DataBinding 0.078
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
31
(cms.tree.generalselect)
DECLARE @NodeID int = 15166;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
Table (1 [33], 156 B)
 
TextTransformationTemplate.ltl_DataBinding 0.031
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
TextTransformationTemplate.ltl_DataBinding N/A
32
(cms.menuitem.generalselect)
DECLARE @DocumentID int = 15926;

SELECT TOP 1 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK) 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 [DocumentID] = @DocumentID AND [NodeLinkedNodeID] IS NULL
Table (1 [160], 2.2 kB)
 
TextTransformationTemplate.ltl_DataBinding 0.000
 
CloseConnection()
TextTransformationTemplate.ltl_DataBinding N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
33
(cms.document.generalselect)
DECLARE @NodeSiteID int = 88;
DECLARE @Now datetime2 = '4/24/2019 10:26:15 AM';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/16987/19812', N'/16987', N'/'))) AND ([ClassName] = N'CMS.MenuItem') 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
1.5 kB
 
Table (2 [36], 383 B)
 
CMSAbstractMenuProperties.OnLoad 0.016
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
34
(cms.settingskey.generalselect)
DECLARE @SiteID int = 88;
DECLARE @KeyName nvarchar(max) = N'CMSAllowGlobalCategories';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
BasicRepeater.OnLoad 0.219
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
35
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Category';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 3.1 kB)
 
BasicRepeater.OnLoad 0.078
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
36
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Category';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 11.8 kB)
 
BasicRepeater.OnLoad 0.453
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
37

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Category');
Table (1 [1], 10 B)
 
BasicRepeater.OnLoad 0.328
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
38
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1721)
BasicRepeater.OnLoad 0.016
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
39
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1721)
BasicRepeater.OnLoad 0.031
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
40
(cms.category.generalselect)
SELECT *
FROM CMS_Category
Table (14 [15], 2 kB)
 
BasicRepeater.OnLoad 0.031
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
41
(cms.user.generalselect)
DECLARE @UserID int = 306;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
Table (1 [29], 291 B)
 
BasicRepeater.OnLoad 0.016
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
42
(cms.document.generalselect)
DECLARE @NodeSiteID int = 88;
DECLARE @Now datetime2 = '4/24/2019 10:26:16 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 (
DocumentID IN (
SELECT DocumentID FROM CMS_DocumentCategory WHERE CategoryID IN(
SELECT CategoryID FROM CMS_Category
WHERE CategoryIDPath LIKE '/00000011%' AND CategoryEnabled = 1 AND (NOT EXISTS(SELECT CategoryID FROM CMS_Category AS pc WHERE (pc.CategoryEnabled = 0) AND (CMS_Category.CategoryIDPath LIKE pc.CategoryIDPath+'/%')))))) AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeName ASC
884 B
 
Table (16 [157], 38 kB)
 
BasicRepeater.OnLoad 0.578
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
43
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 2214 AND [TransformationName] = N'CITSServicesList_en-US')
BasicRepeater.OnLoad 0.000
 
CloseConnection()
BasicRepeater.OnLoad N/A
  43 queries, 22 kB write, 89 kB read   3.250
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% prefix %} Campus IT Services | The University of the West Indies at Cave Hill, Barbados ContentPage.OnLoad 0.000
 
> prefix Campus IT Services | The University of the West Indies at Cave Hill, Barbados 0.000
 
2 {% pagetitle_orelse_name %} All Services 0.000
 
> pagetitle_orelse_name All Services 0.000
 
3 {% GetDocumentUrlByID(DocumentID) %} /campusitservices/home.aspx TextTransformationTemplate.ltl_DataBinding 0.047
 
> GetDocumentUrlByID(DocumentID) /campusitservices/home.aspx 0.000
 
4 {% HTMLEncode(DocumentName) %} Home 0.000
 
> HTMLEncode(DocumentName) Home 0.000
 
5 {% GetDocumentUrlByID(DocumentID) %} /campusitservices/about-us.aspx 0.047
 
> GetDocumentUrlByID(DocumentID) /campusitservices/about-us.aspx 0.000
 
6 {% HTMLEncode(DocumentName) %} About Us 0.000
 
> HTMLEncode(DocumentName) About Us 0.000
 
7 {% GetDocumentUrlByID(DocumentID) %} /campusitservices/services.aspx 0.219
 
> GetDocumentUrlByID(DocumentID) /campusitservices/services.aspx 0.000
 
8 {% HTMLEncode(DocumentName) %} Services 0.000
 
> HTMLEncode(DocumentName) Services 0.000
 
9 {% GetDocumentUrlByID(DocumentID) %} /campusitservices/information-security.aspx 0.063
 
> GetDocumentUrlByID(DocumentID) /campusitservices/information-security.aspx 0.000
 
10 {% HTMLEncode(DocumentName) %} Information Security 0.016
 
> HTMLEncode(DocumentName) Information Security 0.000
 
11 {% GetDocumentUrlByID(DocumentID) %} /campusitservices/faqs.aspx 0.078
 
> GetDocumentUrlByID(DocumentID) /campusitservices/faqs.aspx 0.000
 
12 {% HTMLEncode(DocumentName) %} FAQs 0.000
 
> HTMLEncode(DocumentName) FAQs 0.000
 
13 {% GetDocumentUrlByID(DocumentID) %} /campusitservices/notices.aspx 0.250
 
> GetDocumentUrlByID(DocumentID) /campusitservices/notices.aspx 0.000
 
14 {% HTMLEncode(DocumentName) %} Notices 0.000
 
> HTMLEncode(DocumentName) Notices 0.000
 
15 {% GetDocumentUrlByID(DocumentID) %} /campusitservices/contact-us.aspx 0.141
 
> GetDocumentUrlByID(DocumentID) /campusitservices/contact-us.aspx 0.000
 
16 {% HTMLEncode(DocumentName) %} Contact Us 0.000
 
> HTMLEncode(DocumentName) Contact Us 0.000
 
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/campusitservices/services/all-services.aspx" (44 B)
44 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 lt
cave_header1
mtaJSCheck
No
No
http-equiv = "refresh" (7 B)
content = "0;URL=http://www.cavehill.uwi.edu/NoScript.aspx" (47 B)
54 B
 
4 lt
cave_header1
TextBox1
No
CssClass = "sbox" (4 B)
4 B
 
5 lt
cave_header1
ImageButton1
No
No
ImageUrl = "/Images/bn_search.png" (21 B)
CssClass = "site_search_button" (18 B)
39 B
 
6 cave_header1
partPlaceholder
pnlPage
No
CssClass = "PagePlaceholder" (15 B)
15 B
 
7 nav
HierarchicalViewer3
uniView
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
SeparatorTransformationName = "" (0 B)
SelectedFootertemTransformationName = "" (0 B)
TransformationName = "" (0 B)
ShowEditButton = False
HideControlForZeroRows = True
ItemCount = 9
FooterTransformationName = "" (0 B)
NestedControlsID = "" (0 B)
HeaderTransformationName = "" (0 B)
AlternatingTransformationName = "" (0 B)
ShowDeleteButton = False
_!ItemCount = 9
HierarchicalTransformationName = "CMS.MenuItem.HViewer" (20 B)
PagerPosition = Bottom
LastTransformationName = "" (0 B)
DelayedLoading = False
_!DataBound = True
LoadHierarchicalData = True
FirstTransformationName = "" (0 B)
ZeroRowsText = "No data found" (13 B)
SelectedHeaderItemTransformationName = "" (0 B)
SingleTransformationName = "" (0 B)
UseHierarchicalOrdering = True
DataSourceName = "" (0 B)
33 B
 
8 HierarchicalViewer3
uniView
uniViewPager
No
No
No
No
No
No
PageSize = 10
QueryStringKey = "Page" (4 B)
PagerMode = Querystring
GroupSize = 10
DisplayFirstLastAutomatically = False
DisplayPreviousNextAutomatically = False
4 B
 
9 lt
partPlaceholder
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
10 SideContentArea
TabMenu
tabElem
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
useClientScript = False
RenderImageAlt = True
EncodeMenuCaption = True
SelectedTab = 0
TabControlIdPrefix = "" (0 B)
HideControlForZeroRows = True
SelectFirstItemByDefault = False
TabControlLayout = Vertical
RenderLinkTitle = False
ZeroRowsText = "No data found" (13 B)
HighlightedNodePath = "/16987/19812" (12 B)
UrlTarget = "" (0 B)
25 B
 
11 MainContentArea
Repeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
NestedControlsID = "" (0 B)
TransformationName = "CMS.MenuItem.CITSServicesList" (29 B)
ShowEditButton = False
_!ItemCount = 16
ShowDeleteButton = False
HideControlForZeroRows = True
DataSourceName = "" (0 B)
ZeroRowsText = "No data found" (13 B)
AlternatingTransformationName = "" (0 B)
EnablePaging = False
42 B
 
12 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes