Events

18
17
Sample Event

May 17, 2017

More Events »
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
2 RequestEvents.Authenticate.Execute
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute
> URLRewritingHandlers.RewriteUrl
6 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
7 >> TypeInfo(cms.class).Events.GetData SimpleHandler`2.StartEvent
8 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
9 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
10 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
11 >> TypeInfo(cms.pagetemplate).Events.GetData SimpleHandler`2.StartEvent
12 >>> TypeInfo(cms.class).Events.GetData SimpleHandler`2.StartEvent
13 >>> TypeInfo(cms.class).Events.GetData SimpleHandler`2.StartEvent
14 >>> TypeInfo(cms.query).Events.GetData SimpleHandler`2.StartEvent
15 >>> TypeInfo(cms.query).Events.GetData SimpleHandler`2.StartEvent
16 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
17 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
18 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
19 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
20 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
21 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
22 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
23 RequestEvents.AcquireRequestState.Execute
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
24 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
25 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
26 RequestEvents.PostAcquireRequestState.Execute SimpleHandler`2.StartEvent
> MembershipHandlers.UpdateSession
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
27 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
> WebAnalyticsServiceScriptsRenderer.b__0
28 TypeInfo(cms.cssstylesheet).Events.GetData DocumentBase.PreInit
29 TypeInfo(cms.class).Events.GetData DocumentBase.PreInit
30 TypeInfo(cms.class).Events.GetData DocumentBase.PreInit
31 TypeInfo(cms.query).Events.GetData DocumentBase.PreInit
32 TypeInfo(cms.query).Events.GetData DocumentBase.PreInit
33 TypeInfo(cms.settingskey).Events.GetData HeaderPanel.CreateChildControls
34 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
35 TypeInfo(cms.resourcestring).Events.GetData PageContext.CurrentPage_InitComplete
36 TypeInfo(cms.pagetemplate).Events.GetData PageContext.CurrentPage_InitComplete
37 TypeInfo(cms.settingskey).Events.GetData PageContext.CurrentPage_InitComplete
38 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
39 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
40 TypeInfo(cms.query).Events.GetData PageContext.CurrentPage_InitComplete
41 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
42 TypeInfo(cms.webpart).Events.GetData PageContext.CurrentPage_InitComplete
43 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
44 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
45 TypeInfo(cms.query).Events.GetData PageContext.CurrentPage_InitComplete
46 TypeInfo(cms.query).Events.GetData PageContext.CurrentPage_InitComplete
47 TypeInfo(cms.settingskey).Events.GetData PageContext.CurrentPage_InitComplete
48 TypeInfo(cms.webpartlayout).Events.GetData PageContext.CurrentPage_InitComplete
49 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
50 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
51 TypeInfo(cms.query).Events.GetData PageContext.CurrentPage_InitComplete
52 TypeInfo(cms.query).Events.GetData PageContext.CurrentPage_InitComplete
53 TypeInfo(cms.webpart).Events.GetData PageContext.CurrentPage_InitComplete
54 TypeInfo(cms.webpart).Events.GetData
55 TypeInfo(cms.webpart).Events.GetData
56 TypeInfo(cms.webpart).Events.GetData
57 TypeInfo(cms.settingskey).Events.GetData PageContext.CurrentPage_InitComplete
58 TypeInfo(cms.resourcestring).Events.GetData PageContext.CurrentPage_InitComplete
59 TypeInfo(cms.resourcestring).Events.GetData
60 TypeInfo(cms.resourcestring).Events.GetData
61 TypeInfo(cms.resourcestring).Events.GetData
62 TypeInfo(cms.resourcestring).Events.GetData
63 TypeInfo(cms.resourcestring).Events.GetData
64 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
65 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
66 TypeInfo(cms.relationshipname).Events.GetData BasicRepeater.OnLoad
67 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
68 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
69 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
70 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
71 DocumentEvents.GetData BasicRepeater.OnLoad
72 TypeInfo(cms.document.cms.menuitem).Events.GetData BasicRepeater.OnLoad
73 >> TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
74 >> TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
75 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
76 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
77 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
78 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
79 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
80 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
81 TypeInfo(cms.class).Events.GetData
82 TypeInfo(cms.class).Events.GetData
83 TypeInfo(cms.class).Events.GetData
84 TypeInfo(cms.class).Events.GetData
85 TypeInfo(cms.class).Events.GetData
86 TypeInfo(cms.class).Events.GetData
87 TypeInfo(cms.class).Events.GetData
88 TypeInfo(cms.class).Events.GetData
89 TypeInfo(cms.class).Events.GetData
90 TypeInfo(cms.class).Events.GetData
91 TypeInfo(cms.class).Events.GetData
92 TypeInfo(cms.class).Events.GetData
93 TypeInfo(cms.class).Events.GetData
94 TypeInfo(cms.class).Events.GetData
95 TypeInfo(cms.class).Events.GetData
96 TypeInfo(cms.class).Events.GetData
97 TypeInfo(cms.class).Events.GetData
98 TypeInfo(cms.class).Events.GetData
99 TypeInfo(cms.class).Events.GetData
100 TypeInfo(cms.class).Events.GetData
101 TypeInfo(cms.class).Events.GetData
102 TypeInfo(cms.class).Events.GetData
103 TypeInfo(cms.class).Events.GetData
104 TypeInfo(cms.class).Events.GetData
105 TypeInfo(cms.class).Events.GetData
106 TypeInfo(cms.class).Events.GetData
107 TypeInfo(cms.class).Events.GetData
108 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
109 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
110 DocumentEvents.GetData BasicRepeater.OnLoad
111 TypeInfo(cms.document.slider.sbpd).Events.GetData BasicRepeater.OnLoad
112 >> TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
113 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
114 TypeInfo(cms.settingskey).Events.GetData cmsvirtualfiles_transformations__vg_c6fce947_57d7_4e2e_a3cd_331e5c05056a_slider_sbpd_slidelist_ascx.__DataBind__control2
115 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
116 DocumentEvents.GetData BasicRepeater.OnLoad
117 TypeInfo(cms.document.cms.event).Events.GetData BasicRepeater.OnLoad
118 >> TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
119 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
120 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
121 DocumentEvents.GetData BasicRepeater.OnLoad
122 TypeInfo(cms.document.cms.news).Events.GetData BasicRepeater.OnLoad
123 >> TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
124 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
125 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
126 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
127 TypeInfo(cms.settingskey).Events.GetData CMSPages_PortalTemplate.OnPreRender
128 TypeInfo(cms.settingskey).Events.GetData PageContext.CurrentPage_PreRender
129 TypeInfo(cms.settingskey).Events.GetData CMSPages_PortalTemplate.OnPreRender
130 TypeInfo(cms.settingskey).Events.GetData CMSPages_PortalTemplate.OnPreRender
131 TypeInfo(cms.settingskey).Events.GetData WebPartActionManager.OnPreRender
132 TypeInfo(cms.settingskey).Events.GetData
133 TypeInfo(cms.resourcestring).Events.GetData CMSAdminControls_Debug_HandlersLog.OnPreRender
134 TypeInfo(cms.resourcestring).Events.GetData
135 TypeInfo(cms.resourcestring).Events.GetData
136 TypeInfo(cms.resourcestring).Events.GetData CMSAdminControls_Debug_HandlersLog.OnPreRender
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 DIREXISTS
~/App_Themes/base-foundation Local DocumentBase.PreInit
2 EXISTS
~/CMSWebParts/Navigation/cmslistmenu.ascx.cs Local DbPathProvider.GetFileHash
3 EXISTS
~/favicon.ico Local CMSPages_PortalTemplate.OnPreRender
4 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
5 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
6 DIREXISTS
~/CMSResources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
7 EXISTS
~/CMSResources/First.resx Local CMSAdminControls_Debug_HandlersLog.OnPreRender
8 EXISTS
~/CMSResources/Fast.resx Local
9 EXISTS
~/CMSResources/CMS_Install.resx Local
10 EXISTS
~/CMSResources/CMS.resx Local
11 EXISTS
~/CMSResources/Custom.resx Local
12 EXISTS
~/CMSResources/Hotfix.resx Local
13 EXISTS
~/CMSResources/Last.resx Local
14 GETDIRECTORIES
~/CMSResources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
15 GETDIRECTORIES
~/CMSResources
0
Local CMSAdminControls_Debug_HandlersLog.OnPreRender
16 DIREXISTS
~/App_Data Local CMSAdminControls_Debug_HandlersLog.OnPreRender
17 GETDIRECTORIES
~/App_Data Local CMSAdminControls_Debug_HandlersLog.OnPreRender
18 GETDIRECTORIES
~/App_Data
13
Local CMSAdminControls_Debug_HandlersLog.OnPreRender
19 DIREXISTS
~/App_Data/51Degrees/Resources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
20 DIREXISTS
~/App_Data/AzureCache/Resources Local
21 DIREXISTS
~/App_Data/AzureTemp/Resources Local
22 DIREXISTS
~/App_Data/CMSModules/Resources Local
23 DIREXISTS
~/App_Data/CMSTemp/Resources Local
24 DIREXISTS
~/App_Data/CodeTemplates/Resources Local
25 DIREXISTS
~/App_Data/DancingGoat/Resources Local
26 GETFILES
~/App_Data/DancingGoat/Resources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
27 GETFILES
~/App_Data/DancingGoat/Resources
1
Local CMSAdminControls_Debug_HandlersLog.OnPreRender
28 DIREXISTS
~/App_Data/DBSeparation/Resources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
29 DIREXISTS
~/App_Data/Dictionaries/Resources Local
30 DIREXISTS
~/App_Data/Install/Resources Local
31 DIREXISTS
~/App_Data/Persistent/Resources Local
32 DIREXISTS
~/App_Data/Templates/Resources Local
33 DIREXISTS
~/App_Data/UI/Resources Local
34 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
35 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 This same security check is called more than once within the request. public IsGlobalAdministrator False CMSAbstractWebPart.OnInit
2 This same security check is called more than once within the request. public IsInRole False _authenticated_ PublicDefender CMSAbstractWebPart.OnInit
3 This same security check is called more than once within the request. public IsGlobalAdministrator False PageContext.CurrentPage_InitComplete
4 This same security check is called more than once within the request. public IsInRole False _authenticated_ PublicDefender PageContext.CurrentPage_InitComplete
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|publicdefender|/home|en-us|/home|true
template|25500
nodeid|3
pageinfo
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|publicdefender|http://wwwtest.pmcworld.com|en-us||true|true
template|25500
nodeid|3
pageinfo
SimpleHandler`2.StartEvent
3 ADD pageinfo|publicdefender|/|en-us||false
template|25446
nodeid|1
pageinfo
PageContext.CurrentPage_InitComplete
4 ADD cmsdatasource||en-us|publicdefender|/top-menu/%|en-us|false|cms.menuitem||nodeorder desc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|1a63e356-2658-44a5-b81c-e4b4a37e86e8
nodes|publicdefender|cms.menuitem|all
node|publicdefender|/top-menu|childnodes
BasicRepeater.OnLoad
5 ADD cmsdatasource||en-us|publicdefender|/home/slides/%|en-us|false|slider.sbpd||nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|d5541c2e-857c-4ba0-b26e-0ab6315da5cd
nodes|publicdefender|slider.sbpd|all
node|publicdefender|/home/slides|childnodes
6 ADD cmsdatasource||en-us|publicdefender|/events/%|en-us|false|cms.event|eventdate > getdate()|eventdate asc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|3||false||
webpartinstance|4e0eb6cc-d9cb-4520-aa5e-96cc3ec365dc
nodes|publicdefender|cms.event|all
node|publicdefender|/events|childnodes
7 ADD cmsdatasource||en-us|publicdefender|/news/%|en-us|false|cms.news||newsreleasedate desc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|3||false||
webpartinstance|785fe373-2205-498c-9d9a-102d862f1f92
nodes|publicdefender|cms.news|all
node|publicdefender|/news|childnodes
8 ADD cmsmenudatasource||en-us|publicdefender|/sitemap/%|en-us|false|cms.menuitem|||-1|true||false|false
webpartinstance|eed94b14-b41a-413e-a82d-0ac5bb3ef146
node|publicdefender|/sitemap|childnodes
CMSAbstractMenuProperties.OnLoad
9 ADD scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL / 0.000
0.102
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.102
0.177
 
3 > OnPreInit 0.279
0.177
 
4 > OnInit 0.456
2.541
 
5 > OnLoad 2.997
0.946
 
6 > OnPreRender 3.943
N/A
    3.943  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookie3AQqA0NgVhuZwYZy/aZViU+fWol6QQ9khiVCV2cX
3 CMSCurrentThemebase-foundation
4 ASP.NET_SessionIdapwb3fsuwdw2mylcdxynm0jk
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US2/27/2018 1:30:11 AM
2 CMSCsrfCookie3AQqA0NgVhuZwYZy/aZViU+fWol6QQ9khiVCV2cX 
3 CMSCurrentThemebase-foundation2/28/2017 1:30:11 AM
4 ASP.NET_SessionIdapwb3fsuwdw2mylcdxynm0jk 
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (http://commoncrawl.org/faq/)
4 UserHostAddress54.159.242.217
5 UserName 
6 SessionIDapwb3fsuwdw2mylcdxynm0jk
7 ServerNameWEB08
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/Home';
DECLARE @NodeAliasPath nvarchar(max) = N'/Home';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '2/27/2017 1:30:11 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 [DocumentUrlPath] = N'/Home' 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)
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))) 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.5 kB
 
Table (1 [64], 336 B)
 
SimpleHandler`2.StartEvent 0.009
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
2
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSForbiddenCharactersReplacement';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
3
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.MenuItem';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 4.4 kB)
 
SimpleHandler`2.StartEvent 0.004
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
4
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSCombineWithDefaultCulture';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.004
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
5
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND)
WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath = N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (1 [108], 1.1 kB)
 
SimpleHandler`2.StartEvent 0.008
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
6
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.PageTemplate';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 7.5 kB)
 
SimpleHandler`2.StartEvent 0.005
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
7
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.PageTemplate';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 31 kB)
 
SimpleHandler`2.StartEvent 0.007
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
8
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 157)
SimpleHandler`2.StartEvent 0.004
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
9
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 157)
SimpleHandler`2.StartEvent 0.005
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
10
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25500;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 26 kB)
 
SimpleHandler`2.StartEvent 0.016
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
11
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSDefaulPage';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
12
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectAliasesToMainURL';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
13
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectInvalidCasePages';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
14
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectToMainExtension';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
15
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSBannedIPEnabled';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
16
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSCheckPagePermissions';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
17
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSWebAnalyticsUseJavascriptLogging';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
DocumentBase.PreInit N/A
18
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.CssStylesheet';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2.8 kB)
 
DocumentBase.PreInit 0.004
 
CloseConnection()
DocumentBase.PreInit N/A
OpenConnection()
DocumentBase.PreInit N/A
19
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.CssStylesheet';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 11.6 kB)
 
DocumentBase.PreInit 0.005
 
CloseConnection()
DocumentBase.PreInit N/A
OpenConnection()
DocumentBase.PreInit N/A
20
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 555)
DocumentBase.PreInit 0.004
 
CloseConnection()
DocumentBase.PreInit N/A
OpenConnection()
DocumentBase.PreInit N/A
21
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 555)
DocumentBase.PreInit 0.004
 
CloseConnection()
DocumentBase.PreInit N/A
OpenConnection()
DocumentBase.PreInit N/A
22
(cms.cssstylesheet.generalselect)
DECLARE @StylesheetID int = 1;

SELECT *
FROM CMS_CssStyleSheet
WHERE [StylesheetID] = @StylesheetID
Table (1 [9], 195 kB)
 
DocumentBase.PreInit 0.033
 
CloseConnection()
DocumentBase.PreInit N/A
OpenConnection()
HeaderPanel.CreateChildControls N/A
23
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSAllowOnSiteEditing';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
HeaderPanel.CreateChildControls 0.002
 
CloseConnection()
HeaderPanel.CreateChildControls N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
24
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 1;
DECLARE @Now datetime2 = '2/27/2017 1:30:12 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)
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.2 kB
 
Table (1 [64], 1 kB)
 
PageContext.CurrentPage_InitComplete 0.011
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
25
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Root';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 305 B)
 
PageContext.CurrentPage_InitComplete 0.003
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
26
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.slash';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.011
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
27
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25446;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 52 kB)
 
PageContext.CurrentPage_InitComplete 0.011
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
28
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSContentPersonalizationEnabled';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
PageContext.CurrentPage_InitComplete 0.003
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
29
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.personalization';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2 kB)
 
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
30
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.personalization';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 4.7 kB)
 
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
31
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1841)
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
32
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 1
PageContext.CurrentPage_InitComplete 0.006
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
33
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPart';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 4.7 kB)
 
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
34
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPart';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 15.6 kB)
 
PageContext.CurrentPage_InitComplete 0.007
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
35
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 425)
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
36
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 425)
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
37
(cms.webpart.generalselect)
DECLARE @WebPartLoadGeneration int = 0;

SELECT *
FROM CMS_WebPart
WHERE [WebPartLoadGeneration] = @WebPartLoadGeneration
Table (209 [20], 1.6 MB)
 
PageContext.CurrentPage_InitComplete 0.224
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
38
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSEnablePartialCache';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
PageContext.CurrentPage_InitComplete 0.002
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
39
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPartLayout';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 3.1 kB)
 
PageContext.CurrentPage_InitComplete 0.003
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
40
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPartLayout';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 11.6 kB)
 
PageContext.CurrentPage_InitComplete 0.007
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
41
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1514)
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
42
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1514)
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
43
(cms.webpartlayout.generalselect)
SELECT *
FROM CMS_WebPartLayout
Table (9 [11], 14.8 kB)
 
PageContext.CurrentPage_InitComplete 0.007
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
44
(cms.webpart.generalselect)
DECLARE @WebPartID int = 173;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
Table (1 [20], 18.4 kB)
 
PageContext.CurrentPage_InitComplete 0.009
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
45
(cms.webpart.generalselect)
DECLARE @WebPartID int = 178;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
Table (1 [20], 4.9 kB)
 
PageContext.CurrentPage_InitComplete 0.006
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
46
(cms.webpart.generalselect)
DECLARE @WebPartID int = 179;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
Table (1 [20], 17.3 kB)
 
PageContext.CurrentPage_InitComplete 0.005
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
47
(cms.webpart.generalselect)
DECLARE @WebPartID int = 239;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
Table (1 [20], 972 B)
 
PageContext.CurrentPage_InitComplete 0.003
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
48
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSCacheMinutes';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
PageContext.CurrentPage_InitComplete 0.002
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
49
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.ResultText';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.010
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
50
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.LabelText';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.009
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
51
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Back';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.009
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
52
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Next';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.002
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
53
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.First';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.009
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
54
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Last';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.002
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
55
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 3
PageContext.CurrentPage_InitComplete 0.004
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
BasicRepeater.OnLoad N/A
56

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_Tree');
Table (1 [1], 6 B)
 
BasicRepeater.OnLoad 0.015
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
57
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.menuitem';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 1.6 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
58

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('CONTENT_MenuItem');
Table (1 [1], 10 B)
 
BasicRepeater.OnLoad 0.044
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
59
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.RelationshipName';

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

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 6.4 kB)
 
BasicRepeater.OnLoad 0.007
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
61
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 530)
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
62
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 530)
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
63
(cms.relationshipname.generalselect)
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';

SELECT *
FROM CMS_RelationshipName
WHERE [RelationshipName] = @RelationshipName
Table (1 [7], 88 B)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
64
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Document';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 15.3 kB)
 
BasicRepeater.OnLoad 0.007
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
65

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_Document');
Table (1 [1], 10 B)
 
BasicRepeater.OnLoad 0.012
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
66
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5052)
BasicRepeater.OnLoad 0.005
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
67
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/27/2017 1:30:14 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Top-Menu/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MenuItemID AND V.ClassName = N'CMS.MenuItem'
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 DESC
690 B
 
Table (2 [112], 1 kB)
 
BasicRepeater.OnLoad 0.013
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
68
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Transformation';

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

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 8.6 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
70
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 162)
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
71
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 162)
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
72
(cms.transformation.generalselect)
SELECT *
FROM CMS_Transformation
Table (229 [12], 142 kB)
 
BasicRepeater.OnLoad 0.007
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
73
(cms.class.generalselect)
DECLARE @ClassID int = 1685;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 4 kB)
 
BasicRepeater.OnLoad 0.006
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
74
(cms.class.generalselect)
DECLARE @ClassID int = 3140;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 278 B)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
75
(cms.class.generalselect)
DECLARE @ClassID int = 5046;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 358 B)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
76
(cms.class.generalselect)
DECLARE @ClassID int = 5047;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 334 B)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
77
(cms.class.generalselect)
DECLARE @ClassID int = 5048;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 339 B)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
78
(cms.class.generalselect)
DECLARE @ClassID int = 5049;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 7.9 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
79
(cms.class.generalselect)
DECLARE @ClassID int = 5051;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.5 kB)
 
BasicRepeater.OnLoad 0.005
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
80
(cms.class.generalselect)
DECLARE @ClassID int = 5053;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 326 B)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
81
(cms.class.generalselect)
DECLARE @ClassID int = 5054;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 321 B)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
82
(cms.class.generalselect)
DECLARE @ClassID int = 5055;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 277 B)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
83
(cms.class.generalselect)
DECLARE @ClassID int = 5056;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.6 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
84
(cms.class.generalselect)
DECLARE @ClassID int = 5057;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 16.1 kB)
 
BasicRepeater.OnLoad 0.006
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
85
(cms.class.generalselect)
DECLARE @ClassID int = 5058;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10.7 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
86
(cms.class.generalselect)
DECLARE @ClassID int = 5059;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 3.6 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
87
(cms.class.generalselect)
DECLARE @ClassID int = 5060;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.3 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
88
(cms.class.generalselect)
DECLARE @ClassID int = 5061;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 6 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
89
(cms.class.generalselect)
DECLARE @ClassID int = 5062;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 4.1 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
90
(cms.class.generalselect)
DECLARE @ClassID int = 5063;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 14.2 kB)
 
BasicRepeater.OnLoad 0.006
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
91
(cms.class.generalselect)
DECLARE @ClassID int = 5065;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 2.4 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
92
(cms.class.generalselect)
DECLARE @ClassID int = 5066;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 333 B)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
93
(cms.class.generalselect)
DECLARE @ClassID int = 5067;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
94
(cms.class.generalselect)
DECLARE @ClassID int = 5068;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 295 B)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
95
(cms.class.generalselect)
DECLARE @ClassID int = 5069;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 12.2 kB)
 
BasicRepeater.OnLoad 0.005
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
96
(cms.class.generalselect)
DECLARE @ClassID int = 5070;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.9 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
97
(cms.class.generalselect)
DECLARE @ClassID int = 5071;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10.9 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
98
(cms.class.generalselect)
DECLARE @ClassID int = 5072;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10.8 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
99
(cms.class.generalselect)
DECLARE @ClassID int = 5075;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 6.9 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
100
(cms.class.generalselect)
DECLARE @ClassID int = 5089;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 3.5 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
101
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5067 AND [TransformationName] = N'TopMenuLink_en-US')
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
102
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'slider.sbpd';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2.5 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
103

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('Slider_sbpd');
Table (1 [1], 6 B)
 
BasicRepeater.OnLoad 0.014
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
104
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5075)
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
105
(slider.sbpd.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/27/2017 1:30:14 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Home/Slides/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Slider_sbpd AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.SbpdID AND V.ClassName = N'Slider.sbpd'
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
678 B
 
Table (3 [115], 2.2 kB)
 
BasicRepeater.OnLoad 0.014
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
106
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5075 AND [TransformationName] = N'slideList_en-US')
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
cmsvirtualfiles_transformations__vg_c6fce947_57d7_4e2e_a3cd_331e5c05056a_slider_sbpd_slidelist_ascx.__DataBind__control2 N/A
107
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSFilesFriendlyURLExtension';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
cmsvirtualfiles_transformations__vg_c6fce947_57d7_4e2e_a3cd_331e5c05056a_slider_sbpd_slidelist_ascx.__DataBind__control2 0.002
 
CloseConnection()
cmsvirtualfiles_transformations__vg_c6fce947_57d7_4e2e_a3cd_331e5c05056a_slider_sbpd_slidelist_ascx.__DataBind__control2 N/A
OpenConnection()
BasicRepeater.OnLoad N/A
108
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.event';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2.1 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
109

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('CONTENT_Event');
Table (1 [1], 7 B)
 
BasicRepeater.OnLoad 0.013
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
110
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5060)
BasicRepeater.OnLoad 0.005
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
111
(cms.event.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/27/2017 1:30:14 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Events/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_Event AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.EventID AND V.ClassName = N'CMS.Event'
WHERE [NodeSiteID] = @NodeSiteID AND (EventDate > GETDATE()) 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 EventDate ASC
712 B
 
Table (3 [114], 3 kB)
 
BasicRepeater.OnLoad 0.016
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
112
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5060 AND [TransformationName] = N'SBPD_HomePageEvent_en-US')
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
113
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.news';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
114

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('CONTENT_News');
Table (1 [1], 6 B)
 
BasicRepeater.OnLoad 0.012
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
115
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5051)
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
116
(cms.news.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/27/2017 1:30:15 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/News/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 3 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_News AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.NewsID AND V.ClassName = N'CMS.News'
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 NewsReleaseDate DESC
686 B
 
Table (3 [114], 5.3 kB)
 
BasicRepeater.OnLoad 0.014
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
117
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5051 AND [TransformationName] = N'newsItemHome_en-US')
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
118
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/27/2017 1:30:15 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/SiteMap/%';
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)
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 [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, DocumentName
1.4 kB
 
Table (9 [36], 1.4 kB)
 
CMSAbstractMenuProperties.OnLoad 0.007
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
CMSPages_PortalTemplate.OnPreRender N/A
119
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSExcludedFormFilterURLs';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSPages_PortalTemplate.OnPreRender 0.003
 
CloseConnection()
CMSPages_PortalTemplate.OnPreRender N/A
OpenConnection()
PageContext.CurrentPage_PreRender N/A
120
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSEnableOnlineMarketing';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
PageContext.CurrentPage_PreRender 0.002
 
CloseConnection()
PageContext.CurrentPage_PreRender N/A
OpenConnection()
CMSPages_PortalTemplate.OnPreRender N/A
121
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSPageDescriptionPrefix';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSPages_PortalTemplate.OnPreRender 0.001
 
CloseConnection()
CMSPages_PortalTemplate.OnPreRender N/A
OpenConnection()
CMSPages_PortalTemplate.OnPreRender N/A
122
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSPageKeyWordsPrefix';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSPages_PortalTemplate.OnPreRender 0.002
 
CloseConnection()
CMSPages_PortalTemplate.OnPreRender N/A
OpenConnection()
WebPartActionManager.OnPreRender N/A
123
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSScreenLockInterval';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
WebPartActionManager.OnPreRender 0.002
 
CloseConnection()
WebPartActionManager.OnPreRender N/A
OpenConnection()
N/A
124
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSScreenLockWarningInterval';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
WebPartActionManager.OnPreRender 0.002
 
CloseConnection()
WebPartActionManager.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
125
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.010
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
N/A
126
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'HandlersLog.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.009
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
N/A
127
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Context';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
128
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'HandlersLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
129
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.011
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
N/A
130
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.FilePath';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.009
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
N/A
131
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.OperationType';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
132
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
133
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.UserName';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
134
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.009
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
135
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Result';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
136
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Resource';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
137
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
138
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Site';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
139
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
cmsadmincontrols_debug_securitylog_ascx.__DataBind__control5 N/A
140
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Duplicit';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
cmsadmincontrols_debug_securitylog_ascx.__DataBind__control5 0.001
 
CloseConnection()
cmsadmincontrols_debug_securitylog_ascx.__DataBind__control5 N/A
OpenConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
141
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'CacheLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_CacheLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
OpenConnection()
N/A
142
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'CacheLog.Data';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_CacheLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
143
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'CacheLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_CacheLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
OpenConnection()
cmsadmincontrols_debug_cachelog_ascx.__DataBind__control11 N/A
144
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.View';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
cmsadmincontrols_debug_cachelog_ascx.__DataBind__control11 0.010
 
CloseConnection()
cmsadmincontrols_debug_cachelog_ascx.__DataBind__control11 N/A
OpenConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
145
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.ResponseCookies';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.009
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
146
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.RequestCookies';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.009
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
147
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Values';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
148
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
149
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Parameter';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
150
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.FromStart';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
151
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Duration';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
152
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
153
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General..General.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
154
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
155
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General..General.Value';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
156
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Value';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
157
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General..General.Expires';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.008
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
158
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Expires';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.002
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
159
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryText';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_QueryLog.OnPreRender 0.002
 
CloseConnection()