CONTENTSTART
EXCLUDESTART EXCLUDEEND

Program by Advisor

Ashley Sevcik
EXCLUDESTART
EXCLUDESTART EXCLUDEEND
EXCLUDEEND
CONTENTEND
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/NWTC/outputdata/0090/1213515231.cache Local SimpleHandler`2.StartEvent
2 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local DbPathProvider.GetFileHash
3 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
4 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
5 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|nwtc|/student-experience/academic-advising/all-advisors|en-us|/student-experience/academic-advising/all-advisors|true
template|24181
nodeid|2835
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/student-experience/academic-advising/all-advisors|en-us||true|true
template|24181
nodeid|2835
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/student-experience/academic-advising/all-advisors|en-us
nodes|nwtc|cms.menuitem|all
node|nwtc|/student-experience/academic-advising/all-advisors
SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
6 ADD pageinfo|nwtc|/student-experience/academic-advising|en-us||false
template|24105
nodeid|1654
PageContext.CurrentPage_InitComplete
7 GET pageinfo|nwtc|/student-experience|en-us||false PageContext.CurrentPage_InitComplete
8 GET pageinfo|nwtc|/|en-us||false
9 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
10 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
11 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|2742
partial
template|24098
12 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
13 GET cmsdatasource||en-us|nwtc|/master-items/mega-menus/%|en-us|false|nwtc.megamenu||nodeorder asc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| CMSWebPartZone.CachedWebPart_Init
14 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
15 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
16 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|mobilemenubutton
17 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
18 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|newmobilemenu
19 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|mobilemenu
20 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
21 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|2742
partial
template|24098
22 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|2742
partial
template|24098
23 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|2742
partial
template|24098
24 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
25 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
26 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|2742
partial
template|24098
27 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|2742
partial
template|24098
28 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
29 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
30 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
31 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
32 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|2742
partial
template|24098
33 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
34 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|googletranslator
35 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
36 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|mobilemenubutton
37 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
38 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|newmobilemenu
39 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/student-experience/academic-advising/all-advisors|/|mobilemenu
40 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
41 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|2742
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
42 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|2742
partial
template|24098
43 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|2742
partial
template|24098
44 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
45 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
46 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|2742
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
47 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|2742
partial
template|24098
48 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
49 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
50 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
51 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|2742
partial
template|24098
52 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|2742
partial
template|24098
53 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|2742
partial
template|24098
54 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|2742
partial
template|24098
55 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|2742
partial
template|24098
56 ADD onlinemarketingcpvariantsbytemplateid|24181
om.personalizationvariant|bytemplateid|24181
PageContext.CurrentPage_InitComplete
57 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
58 GET onlinemarketingcpvariantsbytemplateid|24181
59 GET onlinemarketingcpvariantsbytemplateid|24181
60 GET onlinemarketingcpvariantsbytemplateid|24181
61 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
62 GET onlinemarketingcpvariantsbytemplateid|24181
63 GET onlinemarketingcpvariantsbytemplateid|24181
64 GET onlinemarketingcpvariantsbytemplateid|24181
65 GET onlinemarketingcpvariantsbytemplateid|24181
66 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
67 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
68 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
69 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
70 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
71 GET onlinemarketingcpvariantsbytemplateid|24181
72 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
73 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
74 GET onlinemarketingcpvariantsbytemplateid|24181
75 GET onlinemarketingcpvariantsbytemplateid|24181 PageContext.CurrentPage_InitComplete
76 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24181
CMSWebPartZone.CachedWebPart_Init
77 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24181
78 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|2742
partial
template|24181
79 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|2742
partial
template|24181
80 ADD Partial cache (AdvisorListing)
webpartinstance|af5a7f99-93c2-44fb-b846-970da27df5c7
partial
template|24181
81 ADD querydatasource|nwtc.transformationsqueries.getuserwithlocations||userposition like 'advisor,%' and
programsadvisesfor is not null|lastname, firstname|0|useravatarid, userid, firstname, lastname, email, userposition, department, userphone, fullname, programsadvisesfor|
webpartinstance|af5a7f99-93c2-44fb-b846-970da27df5c7
nwtc.transformationsqueries|all
CMSWebPartZone.CachedWebPart_Init
82 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315081','105081','101601','105301','315302','105131','905131') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
BasicRepeater.BasicRepeater_DataBinding
83 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('undecided','104551','104552','104555','314082','314101','314131','106141') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
84 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101023','101023-e','101023-h','101023-p','101023-s','101821') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
85 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('106071','314132','105062','314692','106011','104821','104681','104824','104813','106241') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
86 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('veterans') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
87 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105431','315431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
88 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315091','315121','105461','105241','105151','315371') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
89 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315431','105431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
90 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105046','105045','305042','305313','305316','105312','305318','315311','105203','315501') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
91 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101011','314043','101023','105033','101161','101961','324441','314201','101965','311011','101066','311061') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
92 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101011','311011','101101','311101','324042','106023','104051','324051','104123','314128') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
93 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105431','105241','314421','315431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
94 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101066','311061','101161','101961','101965','311093','313162','undecided') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
95 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('311011','101023','104121','324121','105441','105392','311093','101161','101961','101965','105431','311061','315431','315371','314421','908902','908903') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
96 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('100014','100903','103201','103202','106056','100905','106061','106142','314421','105033','310905') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
97 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101117','311045','102065','101043','312031','312041','311048','317013','international') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
98 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('908902','908903','105065') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
99 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('106641','106201','324441','314201','106233','106621') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
100 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101543','311546','101502','101021','301506','301507','301505','301501','101521','101522','311522','311523','101512') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
101 ADD cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105262','105261','315223','313076','103071','105222','315222') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
nodes|nwtc|nwtc.programpage|all
node|nwtc|/programs|childnodes
102 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315081','105081','101601','105301','315302','105131','905131') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
103 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('undecided','104551','104552','104555','314082','314101','314131','106141') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
104 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101023','101023-e','101023-h','101023-p','101023-s','101821') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
105 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('106071','314132','105062','314692','106011','104821','104681','104824','104813','106241') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
106 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('veterans') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
107 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105431','315431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
108 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315091','315121','105461','105241','105151','315371') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
109 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315431','105431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
110 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105046','105045','305042','305313','305316','105312','305318','315311','105203','315501') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
111 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101011','314043','101023','105033','101161','101961','324441','314201','101965','311011','101066','311061') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
112 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101011','311011','101101','311101','324042','106023','104051','324051','104123','314128') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
113 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105431','105241','314421','315431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
114 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101066','311061','101161','101961','101965','311093','313162','undecided') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
115 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('311011','101023','104121','324121','105441','105392','311093','101161','101961','101965','105431','311061','315431','315371','314421','908902','908903') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
116 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('100014','100903','103201','103202','106056','100905','106061','106142','314421','105033','310905') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
117 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101117','311045','102065','101043','312031','312041','311048','317013','international') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
118 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('908902','908903','105065') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
119 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('106641','106201','324441','314201','106233','106621') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
120 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101543','311546','101502','101021','301506','301507','301505','301501','101521','101522','311522','311523','101512') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
121 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105262','105261','315223','313076','103071','105222','315222') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
122 ADD Partial cache (LeftMenu)
webpartinstance|a0c23aa1-64dd-4117-b3f1-658d14ebcd1b
partial
template|24181
CMSWebPartZone.CachedWebPart_Init
123 ADD cmsdatasource||en-us|nwtc|/student-experience/%|en-us|false|cms.menuitem;nwtc.programpage;nwtc.programcluster;nwtc.programsubcluster|documentmenuitemhideinnavigation = 0|nodelevel, nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0|documentmenujavascript, documentmenucaption, documentname, documentmenucaption, documentmenuredirecturl, nodename, nodeid, nodealiaspath, documentnamepath, documentid|false||
webpartinstance|a0c23aa1-64dd-4117-b3f1-658d14ebcd1b
nodes|nwtc|cms.menuitem|all
nodes|nwtc|nwtc.programpage|all
nodes|nwtc|nwtc.programcluster|all
nodes|nwtc|nwtc.programsubcluster|all
node|nwtc|/student-experience|childnodes
CMSWebPartZone.CachedWebPart_Init
124 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24181
PageContext.CurrentPage_InitComplete
125 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24181
126 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|2742
partial
template|24181
127 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|2742
partial
template|24181
128 ADD Partial cache (AdvisorListing)
webpartinstance|af5a7f99-93c2-44fb-b846-970da27df5c7
partial
template|24181
129 ADD Partial cache (LeftMenu)
webpartinstance|a0c23aa1-64dd-4117-b3f1-658d14ebcd1b
partial
template|24181
130 GET cmsdatasource||en-us|nwtc|/master-items/alerts/%|en-us|false|nwtc.alert||nodeorder|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|1||false|| BasicRepeater.OnLoad
131 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
132 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
133 GET inlinewidgetcontrol|528|1572
134 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
135 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
136 GET inlinewidgetcontrol|528|1572
137 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
138 GET cmsdatasource||en-us|nwtc|/events/%|en-us|false|nwtc.event|((eventallday = 0 and datediff(minute,getdate(),eventdate)>=0) or (eventallday = 1 and datediff(day, getdate(), eventdate)>=0) or (eventenddate is not null and ((eventallday = 1 and datediff(day,eventenddate,getdate())<=0) or (eventallday = 0 and datediff(minute,eventenddate,getdate())<=0)))) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('academiccalendar_1','studentlife_1') )) ) and ( documentid in (select documentid from cms_documentcategory where categoryid in (select categoryid from cms_category where categoryname in('greenbaycampus') )) ) |eventdate asc, nodelevel, nodeorder|-1|true|00000000-0000-0000-0000-000000000000||false|2||false|| BasicRepeater.OnLoad
139 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
140 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
141 GET cmsdatasource||en-us|nwtc|/resources/shared-page-content/satisfaction|en-us|false|custom.shareablecontent|||-1|true|00000000-0000-0000-0000-000000000000||false|0||false|| BasicRepeater.OnLoad
142 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
143 ADD breadcrumbs|nwtc|/student-experience/academic-advising/all-advisors|en-us|false|cms.menuitem||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/student-experience/academic-advising/all-advisors
node|nwtc|/student-experience/academic-advising
node|nwtc|/student-experience
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
144 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315081','105081','101601','105301','315302','105131','905131') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.OnLoad
145 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('undecided','104551','104552','104555','314082','314101','314131','106141') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
146 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101023','101023-e','101023-h','101023-p','101023-s','101821') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
147 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('106071','314132','105062','314692','106011','104821','104681','104824','104813','106241') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
148 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('veterans') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
149 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105431','315431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
150 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315091','315121','105461','105241','105151','315371') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
151 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('315431','105431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
152 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105046','105045','305042','305313','305316','105312','305318','315311','105203','315501') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
153 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101011','314043','101023','105033','101161','101961','324441','314201','101965','311011','101066','311061') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
154 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101011','311011','101101','311101','324042','106023','104051','324051','104123','314128') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
155 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105431','105241','314421','315431') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
156 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101066','311061','101161','101961','101965','311093','313162','undecided') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
157 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('311011','101023','104121','324121','105441','105392','311093','101161','101961','101965','105431','311061','315431','315371','314421','908902','908903') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
158 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('100014','100903','103201','103202','106056','100905','106061','106142','314421','105033','310905') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
159 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101117','311045','102065','101043','312031','312041','311048','317013','international') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
160 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('908902','908903','105065') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
161 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('106641','106201','324441','314201','106233','106621') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
162 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('101543','311546','101502','101021','301506','301507','301505','301501','101521','101522','311522','311523','101512') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
163 GET cmsdatasource||en-us|nwtc|/programs/%|en-us|false|nwtc.programpage|programcode in ('105262','105261','315223','313076','103071','105222','315222') and nodelinkednodeid is null||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
164 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
165 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
166 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/student-experience/academic-advising/all-advisors';
DECLARE @NodeAliasPath nvarchar(max) = N'/student-experience/academic-advising/all-advisors';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/student-experience/academic-advising/all-advisors' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@DocumentUrlPath ("/student-experience/academic-advising/all-advisors")
@NodeAliasPath ("/student-experience/academic-advising/all-advisors")
@DocumentCulture ("en-US")
3.7 kB
 
Table (1 [65], 3.3 kB)
 
SimpleHandler`2.StartEvent 0.031
 
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] IN (N'/Student-Experience/Academic-Advising', N'/Student-Experience', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
429 B
 
Table (3 [157], 38 kB)
 
SimpleHandler`2.StartEvent 0.031
 
3
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 24181;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (24181)
117 B
 
Table (1 [33], 32 kB)
 
SimpleHandler`2.StartEvent 0.031
 
4 This same query was called more than once within this request.
(om.contact.generalselect)
DECLARE @VisitorToContactVisitorGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000';

SELECT TOP 1 *
FROM OM_Contact
WHERE [ContactID] IN (
SELECT TOP 1 [VisitorToContactContactID]
FROM OM_VisitorToContact
WHERE [VisitorToContactVisitorGUID] = @VisitorToContactVisitorGUID
)
@VisitorToContactVisitorGUID (00000000-0000-0000-0000-000000000000)
333 B
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 2835) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
396 B
 
Table (1 [166], 3.7 kB)
 
SimpleHandler`2.StartEvent 0.016
 
6
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 4608;
DECLARE @PermissionName nvarchar(max) = N'read';
DECLARE @SiteID int = 1;

SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
@ClassID (4608)
@PermissionName ("read")
@SiteID (1)
359 B
 
Table (2 [10], 193 B)
 
SimpleHandler`2.StartEvent 0.000
 
7
(cms.acl.generalselect)
DECLARE @ACLID int = 10;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (10)
78 B
 
Table (1 [5], 52 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 1;
DECLARE @Date datetime2 = '1/18/2018 12:04:24 AM';

SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (10)

@UserID (65)
@SiteID (1)
@Date (1/18/2018 12:04:24 AM)
1.3 kB
 
SimpleHandler`2.StartEvent 0.016
 
9 This same query was called more than once within this request.
(om.contact.generalselect)
DECLARE @VisitorToContactVisitorGUID uniqueidentifier = '00000000-0000-0000-0000-000000000000';

SELECT TOP 1 *
FROM OM_Contact
WHERE [ContactID] IN (
SELECT TOP 1 [VisitorToContactContactID]
FROM OM_VisitorToContact
WHERE [VisitorToContactVisitorGUID] = @VisitorToContactVisitorGUID
)
@VisitorToContactVisitorGUID (00000000-0000-0000-0000-000000000000)
333 B
 
SimpleHandler`2.StartEvent 0.000
 
10
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 1654;

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID)
) AS SubData
ORDER BY CMS_P DESC
@DocumentCulture ("en-US")
@NodeID (1654)
3.1 kB
 
Table (1 [65], 7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
11
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] IN (N'/Student-Experience', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
387 B
 
Table (2 [157], 30 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
12
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_Blog ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Blog.BlogID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.Blog' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE (((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
3.4 kB
 
Table (74 [19], 12.7 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.031
 
13
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN NWTC_ProgramPage ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = NWTC_ProgramPage.ProgramPageID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramPage' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_ProgramCluster ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_ProgramCluster.ProgramClusterID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_Blog ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Blog.BlogID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.Blog' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
3.5 kB
 
Table (74 [19], 12.7 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
14
(om.personalizationvariant.generalselect)
DECLARE @VariantPageTemplateID int = 24181;

SELECT *
FROM OM_PersonalizationVariant
WHERE [VariantPageTemplateID] = @VariantPageTemplateID
ORDER BY VariantPosition
@VariantPageTemplateID (24181)
173 B
 
PageContext.CurrentPage_InitComplete 0.000
 
15
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 2742
PageContext.CurrentPage_InitComplete 0.016
 
16
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'GetUserWithLocations' AND ClassID = 4659)
Table (1 [12], 490 B)
 
CMSWebPartZone.CachedWebPart_Init 0.016
 
17
(nwtc.transformationsqueries.getuserwithlocations)
Select [UserAvatarID], [UserID], [FirstName], [LastName], [Email], [UserPosition], [Department], [UserPhone], [FullName], [ProgramsAdvisesFor],
STUFF((Select ','+CAST(RT.RoleName as varchar(MAX)) from CMS_Role RT where RT.RoleID in (Select RoleID from CMS_UserRole where UserID = UT.UserID) and RT.RoleName in ('NWTC-D-MN','NWTC-D-SB','NWTC-D-GreenBay', 'NWTC-D-SS_StudentDevelopment_AcademicAdvising') for XML PATH('')),1,1,'') Locations
from View_CMS_User as UT WHERE UserPosition like 'Advisor,%' and
ProgramsAdvisesFor is not null ORDER BY LastName, FirstName
569 B
 
Table (20 [11], 4.3 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.313
 
18
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4659 AND [TransformationName] = N'UserListingWidgetWithProgramsAdvisesFor_en-US')
CMSWebPartZone.CachedWebPart_Init 0.000
 
19
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 33)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.016
 
20
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4645 AND [TransformationName] = N'AdvisorListingProgramList_en-US')
CMSRepeater.DataBind 0.000
 
21
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('315081','105081','101601','105301','315302','105131','905131') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:25 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
900 B
 
Table (7 [180], 78 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.078
 
22
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 1727)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
23
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:25 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('Undecided','104551','104552','104555','314082','314101','314131','106141') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:25 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
912 B
 
Table (7 [180], 86 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.859
 
24
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 886)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
25
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:26 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('101023','101023-E','101023-H','101023-P','101023-S','101821') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:26 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
899 B
 
Table (6 [180], 73 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.047
 
26
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 329)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
27
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:26 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('106071','314132','105062','314692','106011','104821','104681','104824','104813','106241') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:26 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
927 B
 
Table (9 [180], 114 kB)
 
BasicRepeater.BasicRepeater_DataBinding 1.219
 
28
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 1078)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.016
 
29
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:27 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('Veterans') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:27 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
848 B
 
BasicRepeater.BasicRepeater_DataBinding 0.031
 
30
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 114)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
31
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:27 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('105431','315431') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:27 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
855 B
 
Table (2 [180], 45 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.141
 
32
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 485)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
33
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:28 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('315091','315121','105461','105241','105151','315371') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:28 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
891 B
 
Table (6 [180], 66 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.031
 
34
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 390)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
35
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:28 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('315431','105431') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:28 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
855 B
 
Table (2 [180], 45 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.031
 
36
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 1667)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.016
 
37
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:28 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('105046','105045','305042','305313','305316','105312','305318','315311','105203','315501') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:28 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
927 B
 
Table (10 [180], 122 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.391
 
38
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 1210)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
39
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:28 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('101011','314043','101023','105033','101161','101961','324441','314201','101965','311011','101066','311061') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:28 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
945 B
 
Table (12 [180], 176 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.156
 
40
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 90)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
41
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:28 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('101011','311011','101101','311101','324042','106023','104051','324051','104123','314128') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:28 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
927 B
 
Table (8 [180], 116 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.578
 
42
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 2148)
Table (1 [16], 127 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
43
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('105431','105241','314421','315431') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
873 B
 
Table (4 [180], 76 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.016
 
44
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 74)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.016
 
45
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('101066','311061','101161','101961','101965','311093','313162','Undecided') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
912 B
 
Table (7 [180], 92 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.031
 
46
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 2695)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.016
 
47
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('311011','101023','104121','324121','105441','105392','311093','101161','101961','101965','105431','311061','315431','315371','314421','908902','908903') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
990 B
 
Table (15 [180], 209 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.063
 
48
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 61)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
49
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('100014','100903','103201','103202','106056','100905','106061','106142','314421','105033','310905') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
936 B
 
Table (11 [180], 148 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.062
 
50
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 324)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
51
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('101117','311045','102065','101043','312031','312041','311048','317013','International') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
925 B
 
Table (8 [180], 100 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.203
 
52
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 876)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
53
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('908902','908903','105065') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
864 B
 
Table (3 [180], 32 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.156
 
54
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 469)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
55
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('106641','106201','324441','314201','106233','106621') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
891 B
 
Table (6 [180], 85 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.047
 
56
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 944)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
57
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:29 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('101543','311546','101502','101021','301506','301507','301505','301501','101521','101522','311522','311523','101512') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:29 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
954 B
 
Table (11 [180], 158 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.063
 
58
(cms.avatar.generalselect)
SELECT [AvatarID], [AvatarName], [AvatarFileName], [AvatarFileExtension], [AvatarType], [AvatarIsCustom], [AvatarGUID], [AvatarLastModified], [AvatarMimeType], [AvatarFileSize], [AvatarImageHeight], [AvatarImageWidth], [DefaultMaleUserAvatar], [DefaultFemaleUserAvatar], [DefaultGroupAvatar], [DefaultUserAvatar]
FROM CMS_Avatar
WHERE (AvatarID = 232)
Table (1 [16], 131 B)
 
cmsvirtualfiles_transformations__vg_8d909cfe_6431_4a8f_8905_01a4d6fb1608_nwtc_transformationsqueries_userlistingwidgetwithprogramsadvisesfor_ascx.__DataBind__control2 0.000
 
59
(nwtc.programpage.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:30 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Programs/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (ProgramCode in ('105262','105261','315223','313076','103071','105222','315222') and NodeLinkedNodeID is null) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:04:30 AM)
@NodeAliasPath ("/Programs/%")
@DocumentCulture ("en-US")
900 B
 
Table (7 [180], 99 kB)
 
BasicRepeater.BasicRepeater_DataBinding 0.203
 
60
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:30 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Student-Experience/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM (
(
SELECT [DocumentMenuJavascript], [DocumentMenuCaption], [DocumentName], [DocumentMenuRedirectUrl], [NodeName], [NodeID], [NodeAliasPath], [DocumentNamePath], [DocumentID], [DocumentCulture], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID], NodeLevel AS [CMS_O1], NodeOrder AS [CMS_O2], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 0 AS [CMS_SN], 'cms.document.cms.menuitem' AS [CMS_T]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentMenuItemHideInNavigation = 0) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
)

UNION ALL
(
SELECT [DocumentMenuJavascript], [DocumentMenuCaption], [DocumentName], [DocumentMenuRedirectUrl], [NodeName], [NodeID], [NodeAliasPath], [DocumentNamePath], [DocumentID], [DocumentCulture], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID], NodeLevel AS [CMS_O1], NodeOrder AS [CMS_O2], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 1 AS [CMS_SN], 'cms.document.nwtc.programpage' AS [CMS_T]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN NWTC_ProgramPage AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramPageID] AND V.ClassName = N'NWTC.ProgramPage' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentMenuItemHideInNavigation = 0) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
)

UNION ALL
(
SELECT [DocumentMenuJavascript], [DocumentMenuCaption], [DocumentName], [DocumentMenuRedirectUrl], [NodeName], [NodeID], [NodeAliasPath], [DocumentNamePath], [DocumentID], [DocumentCulture], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID], NodeLevel AS [CMS_O1], NodeOrder AS [CMS_O2], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 2 AS [CMS_SN], 'cms.document.nwtc.programcluster' AS [CMS_T]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_ProgramCluster AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ProgramClusterID] AND V.ClassName = N'NWTC.ProgramCluster' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentMenuItemHideInNavigation = 0) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
)

UNION ALL
(
SELECT [DocumentMenuJavascript], [DocumentMenuCaption], [DocumentName], [DocumentMenuRedirectUrl], [NodeName], [NodeID], [NodeAliasPath], [DocumentNamePath], [DocumentID], [DocumentCulture], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeOrder], [NodeParentID], NodeLevel AS [CMS_O1], NodeOrder AS [CMS_O2], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 3 AS [CMS_SN], 'cms.document.nwtc.programsubcluster' AS [CMS_T]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (DocumentMenuItemHideInNavigation = 0) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND V.ClassName = N'nwtc.programsubcluster' AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
)

) AS SubData
ORDER BY CMS_O1, CMS_O2, CMS_SRN, CMS_SN
@NodeSiteID (1)
@Now (1/18/2018 12:04:30 AM)
@NodeAliasPath ("/Student-Experience/%")
@DocumentCulture ("en-US")
4.4 kB
 
Table (209 [21], 61 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.078
 
61
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:04:31 AM';
DECLARE @NodeLevel int = 3;
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'/Student-Experience/Academic-Advising/All-Advisors', N'/Student-Experience/Academic-Advising', N'/Student-Experience', 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
@NodeSiteID (1)
@Now (1/18/2018 12:04:31 AM)
@NodeLevel (3)
@DocumentCulture ("en-US")
1.6 kB
 
Table (3 [36], 704 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
  61 queries, 49 kB write, 2.1 MB read   5.126