CONTENTSTART
EXCLUDESTART EXCLUDEEND

NWTC Blog

You're Hired! NWTC Associate Degree Nursing Grad
You're Hired! NWTC Associate Degree Nursing Grad
Relevance:
You may have heard this rumor, some hospitals and clinics will not hire associate degree Nursing grads. That is not true. We went right to HSHS.  The healthcare group hires a large number of NWTC Nursing graduates. Watch this video to find out more. If you'd like to learn mor...
Friday May 26, 2017
View Details
One Thing to Know: How to Determine the Class You Need Right Now
One Thing to Know: How to Determine the Class You Need Right Now
Relevance:
So you’re thinking about taking a class at NWTC. We’re not talking total commitment here. You know you need skills and knowledge to level up your life, but you don’t want to enroll in a full degree or diploma program - does that sound about right? First of all, good news: Y...
Monday May 8, 2017
View Details
One Thing to Know: Study Abroad is for You
One Thing to Know: Study Abroad is for You
Relevance:
Spending two weeks immersed in another country’s colorful culture while earning college credit sounds pretty awesome, right? Well, that’s what you can get with NWTC’s Study Abroad programs. Thailand, Belize, Ireland, and Amsterdam are just a few of the places NWTC students c...
Friday March 31, 2017
View Details
One Thing to Know: Prepare Now for Spring Career Fairs
One Thing to Know: Prepare Now for Spring Career Fairs
Relevance:
"The need is real,” said Ileana Rodriguez as we sat down at the Campus Buzz yesterday to talk about the NWTC Career Services department. Ileana, an NWTC career advisor, was referring to the high volume of services her department provides to students, alumni, and community mem...
Tuesday February 28, 2017
View Details
Why Damiana chose NWTC
Why Damiana chose NWTC
Relevance:
Damiana Stevens, a 4.0 NWTC Graphic Design student who is graduating this semester shares her story about why she chose NWTC. 
Tuesday February 7, 2017
View Details
Dr. Rafn: NWTC welcomes and supports every student
Dr. Rafn: NWTC welcomes and supports every student
Relevance:
Given the politicization of immigration policy and the divisiveness of recent executive decisions, it is tempting to remain silent on the issues surrounding immigration.  Yet, to do so would be to ignore an essential truth.  Every person is worthy of support, worthy of bei...
Friday February 3, 2017
View Details
One Thing to Know: A tuition-free degree is possible
One Thing to Know: A tuition-free degree is possible
Relevance:
Are you a high school senior in the NWTC District? Do you want free tuition at NWTC? If you answered "yes" and "yes," you need to check out the new NWTC Promise Scholarship.  NWTC Promise pays the balance of tuition and course fees for eligible students  and  provides a $10...
Friday January 20, 2017
View Details
|<  <   1 2 3 4    >  >|
1 of 4
You can use the RSS URL below to subscribe to the blog.

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/0063/1411526221.cache Local SimpleHandler`2.StartEvent
2 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local DbPathProvider.GetFileHash
3 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
4 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx Local
5 EXISTS
~/CMSWebParts/General/pageplaceholder.ascx.cs Local
6 GETFILES
~/App_Data/CMSModules/SmartSearch/Blog/ Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
7 GETFILES
~/App_Data/CMSModules/SmartSearch/Blog/
5
Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
8 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/Blog/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
9 READ
20 B (1)
 
~/App_Data/CMSModules/SmartSearch/Blog/segments.gen Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
10 CLOSE
~/App_Data/CMSModules/SmartSearch/Blog/segments.gen Local FileStream.CloseInnerStream
11 OPEN (read, readwrite)
~/App_Data/CMSModules/SmartSearch/Blog/segments_9 Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
12 READ
200 B (1)
 
~/App_Data/CMSModules/SmartSearch/Blog/segments_9 Local CMSModules_SmartSearch_Controls_SearchResults.OnPreRender
13 CLOSE
~/App_Data/CMSModules/SmartSearch/Blog/segments_9 Local FileStream.CloseInnerStream
14 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local cmsvirtualfiles_transformations__vg_c5a2f903_ec18_4c7d_970e_a6a3d01085a3_cms_blogpost_blogpostlisting_ascx.__DataBind__control2
15 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
16 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
17 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
18 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
19 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
20 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
21 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
22 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
23 EXISTS
~/NWTC/media/Design/Images/WebPage.jpg Local
24 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
25 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|/blog|en-us|/blog|true
template|24118
nodeid|1725
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/blog|en-us||true|true
template|24118
nodeid|1725
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/blog|en-us
nodes|nwtc|cms.blog|all
node|nwtc|/blog
SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
6 GET pageinfo|nwtc|/|en-us||false PageContext.CurrentPage_InitComplete
7 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
8 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
9 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|1723
partial
template|24098
10 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
11 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
12 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|googletranslator
CMSWebPartZone.CachedWebPart_Init
13 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
14 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|mobilemenubutton
15 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
16 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|newmobilemenu
17 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|mobilemenu
18 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
19 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|1723
partial
template|24098
20 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1723
partial
template|24098
21 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1723
partial
template|24098
22 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
23 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
24 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|1723
partial
template|24098
25 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1723
partial
template|24098
26 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
27 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
28 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
29 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
PageContext.CurrentPage_InitComplete
30 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|1723
partial
template|24098
31 ADD Partial cache (MegaMenuRepeater)
webpartinstance|48673702-3d7f-41fa-bafb-7bbb00d9d872
partial
template|24098
32 ADD Partial cache (GoogleTranslator)
webpartinstance|0ab79caf-bf0e-4014-b16e-e442aeee5d16
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|googletranslator
33 ADD Partial cache (SearchBoxTop)
webpartinstance|231815e2-bd20-40af-8a81-d4d0326235fb
partial
template|24098
34 ADD Partial cache (MobileMenuButton)
webpartinstance|cdfed3be-a8dc-4968-b094-5e8bf6f7ec6a
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|mobilemenubutton
35 ADD Partial cache (SearchboxDesktop1)
webpartinstance|c80230ce-6940-42f6-93c4-75be20fd5eec
partial
template|24098
36 ADD Partial cache (NewMobileMenu)
webpartinstance|1e3603ff-05ba-4a90-b98e-9dc8a4e21164
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|newmobilemenu
37 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/|mobilemenu
38 ADD Partial cache (SearchboxDesktop)
webpartinstance|3bb06838-8064-4177-b5ce-97da3cbf7cc7
partial
template|24098
39 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|1723
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
40 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1723
partial
template|24098
41 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1723
partial
template|24098
42 ADD Partial cache (FooterColumns)
webpartinstance|8201f8df-48d6-4c29-9dc7-f0306961b1ba
partial
template|24098
PageContext.CurrentPage_InitComplete
43 ADD Partial cache (FooterBackgroundHtml)
webpartinstance|b146d2db-a174-438f-8cf9-4b32a18a9b3d
partial
template|24098
44 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|1723
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
45 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1723
partial
template|24098
46 ADD Partial cache (ColumnLayout_Bootstrap3)
webpartinstance|78cc61dc-37c1-478c-96de-569e664d4743
partial
template|24098
PageContext.CurrentPage_InitComplete
47 ADD Partial cache (JavascriptIncludes)
webpartinstance|a3fc418a-18b6-47d8-b6ba-1f4d3404fa4d
partial
template|24098
48 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
49 ADD Partial cache (FooterColumn1Content)
webpartinstance|d80bc0cf-13c1-470c-9fdc-c6b4c1289060
documentid|1723
partial
template|24098
50 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1723
partial
template|24098
51 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1723
partial
template|24098
52 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|1723
partial
template|24098
53 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1723
partial
template|24098
54 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24118
CMSWebPartZone.CachedWebPart_Init
55 ADD Partial cache (NewLeftMenu)
webpartinstance|d345485e-0141-42b4-8f74-ae61777ee42e
partial
template|24118
56 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24118
57 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|1723
partial
template|24118
58 ADD Partial cache (SubsribeToRSS)
webpartinstance|1d8fce81-89b8-4fb9-9004-6b56c5727d94
partial
template|24118
59 ADD Partial cache (ShareThisContent)
webpartinstance|fbce1ce3-9dab-4271-a815-61c85fb74518
partial
template|24118
60 GET cmsdatasource||en-us|nwtc|/resources/shared-page-content/sharethis-main|en-us|false|custom.shareablecontent|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| CMSWebPartZone.CachedWebPart_Init
61 ADD Partial cache (FilterButton)
webpartinstance|add6729d-846d-4007-9533-ed49afca0bab
partial
template|24118
CMSWebPartZone.CachedWebPart_Init
62 ADD Partial cache (TagCloud)
webpartinstance|f98c908a-0e6b-40d1-af76-05d6b38188d1
partial
template|24118
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/blog|tagcloud
63 ADD tagcloud|blogtags|tagname asc|20|/blog||tagid|20|10|documents|nwtc|/%|en-us|false||true|-1
webpartinstance|f98c908a-0e6b-40d1-af76-05d6b38188d1
node|nwtc|/|childnodes
cms.taggroup|byid|2
CMSWebPartZone.CachedWebPart_Init
64 ADD Partial cache (BlogListing)
webpartinstance|1eb01a48-6da8-476a-99e8-51aaf146a754
partial
template|24118
CMSWebPartZone.CachedWebPart_Init
65 ADD querydatasource|nwtc.transformationsqueries.blogandfolderjoined||nodealiaspath like '/blog/%' and
documentmenuitemhideinnavigation = 0
and ([documentcanbepublished] = 1 and ([documentpublishfrom] is null or [documentpublishfrom] <= getdate()) and ([documentpublishto] is null or [documentpublishto] >= getdate()))|nodelevel, blogmonthstartingdate desc, blogpostdate desc, nodeorder|0||
webpartinstance|1eb01a48-6da8-476a-99e8-51aaf146a754
nwtc.transformationsqueries|all
CMSWebPartZone.CachedWebPart_Init
66 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24118
PageContext.CurrentPage_InitComplete
67 ADD Partial cache (NewLeftMenu)
webpartinstance|d345485e-0141-42b4-8f74-ae61777ee42e
partial
template|24118
68 ADD Partial cache (LeftMenu)
webpartinstance|3e06f2c2-4300-4bfb-8129-69f62431964c
partial
template|24118
69 ADD Partial cache (SubsribeToRSS)
webpartinstance|1d8fce81-89b8-4fb9-9004-6b56c5727d94
partial
template|24118
70 ADD Partial cache (ShareThisContent)
webpartinstance|fbce1ce3-9dab-4271-a815-61c85fb74518
partial
template|24118
71 ADD Partial cache (TagCloud)
webpartinstance|f98c908a-0e6b-40d1-af76-05d6b38188d1
node|nwtc|/|childnodes
cms.taggroup|byid|2
partial
template|24118
controlexpiracy||username=|sitename=nwtc|lang=en-us|/blog|/blog|tagcloud
72 ADD Partial cache (BlogListing)
webpartinstance|1eb01a48-6da8-476a-99e8-51aaf146a754
partial
template|24118
73 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|1723
partial
template|24118
74 ADD Partial cache (FilterButton)
webpartinstance|add6729d-846d-4007-9533-ed49afca0bab
partial
template|24118
75 GET tagcloud|blogtags|tagname asc|20|/blog||tagid|20|10|documents|nwtc|/%|en-us|false||true|-1 PageContext.CurrentPage_InitComplete
76 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
77 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
78 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
79 GET inlinewidgetcontrol|528|1572
80 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
81 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
82 GET inlinewidgetcontrol|528|1572
83 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
84 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
85 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
86 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
87 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
88 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
89 ADD breadcrumbs|nwtc|/blog|en-us|false|cms.menuitem;cms.blogpost;cms.blogmonth;cms.blog||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/blog
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
90 GET pageinfo|nwtc|/resources/shared-page-content/sharethis-main|en-us||false CMSAbstractWebPart.OnLoad
91 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
92 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
93 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'/blog';
DECLARE @NodeAliasPath nvarchar(max) = N'/blog';
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'/blog' 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 ("/blog")
@NodeAliasPath ("/blog")
@DocumentCulture ("en-US")
3.4 kB
 
Table (1 [65], 618 B)
 
SimpleHandler`2.StartEvent 0.016
 
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] = N'/' AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
360 B
 
Table (1 [157], 7.3 kB)
 
SimpleHandler`2.StartEvent 0.000
 
3 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
 
4
(cms.blog.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_Blog AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[BlogID] AND V.ClassName = N'CMS.Blog' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 1725) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
384 B
 
Table (1 [174], 1.2 kB)
 
SimpleHandler`2.StartEvent 0.016
 
5
(cms.class.selectrequiredroles)
DECLARE @ClassID int = 4614;
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 (4614)
@PermissionName ("read")
@SiteID (1)
359 B
 
Table (4 [10], 408 B)
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
DECLARE @ACLID int = 74;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (74)
78 B
 
Table (1 [5], 52 B)
 
SimpleHandler`2.StartEvent 0.000
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 1;
DECLARE @Date datetime2 = '1/18/2018 12:10:20 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 (74)

@UserID (65)
@SiteID (1)
@Date (1/18/2018 12:10:20 AM)
1.3 kB
 
SimpleHandler`2.StartEvent 0.000
 
8 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
 
9
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.016
 
10
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.031
 
11
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' )
) CombinedTables
WHERE ((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (1172 [19], 341 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.094
 
12
(cms.tag.selectdocumentstags)
DECLARE @TagGroupName nvarchar(max) = N'BlogTags';
DECLARE @TagGroupSiteID int = 1;

SELECT TOP 20 CMS_Tag.TagID, TagName, COUNT(DocumentID) AS TagCount FROM CMS_DocumentTag JOIN CMS_Tag ON CMS_DocumentTag.TagID = CMS_Tag.TagID JOIN CMS_TagGroup ON CMS_Tag.TagGroupID = CMS_TagGroup.TagGroupID WHERE (DocumentID IN (SELECT DocumentID FROM View_CMS_Tree_Joined WHERE ((NodeSiteID = 1) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= '1/18/2018 12:10:22 AM') AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= '1/18/2018 12:10:22 AM'))) AND ([DocumentCulture] = N'en-US') AND [TagGroupName] = @TagGroupName AND [TagGroupSiteID] = @TagGroupSiteID)) GROUP BY CMS_Tag.TagID, TagName ORDER BY TagName ASC
@TagGroupName ("BlogTags")
@TagGroupSiteID (1)
770 B
 
Table (20 [3], 283 B)
 
CMSWebPartZone.CachedWebPart_Init 0.172
 
13
(nwtc.transformationsqueries.blogandfolderjoined)
SELECT * from (SELECT TreeTable.*
,BlogPostTable.[BlogPostID]
,BlogPostTable.[BlogPostTitle]
,BlogPostTable.[BlogPostDate]
,BlogPostTable.[BlogPostSummary]
,BlogPostTable.[BlogPostBody]
,BlogPostTable.[BlogPostTeaser]
,BlogPostTable.[BlogPostAllowComments]
--,BlogPostTable.[BlogPostPingedUrls]
--,BlogPostTable.[BlogPostNotPingedUrls]
,BlogPostTable.[BlogLogActivity]
,BlogPostTable.[FacebookAutoPost]
,BlogPostTable.[TwitterAutoPost]
,BlogPostTable.[LinkedInAutoPost]
,BlogPostTable.[BlogPostUseCustomContent]
,BlogPostTable.[Synonyms]
,BlogPostTable.[BestBet]
,BlogMonthTable.[BlogMonthName] as BlogMonth
,BlogMonthTable.[BlogMonthStartingDate] as BlogMonthStartingDate
,BlogMonthTable.[BlogMonthID] as BlogMonthID
FROM View_CMS_Tree_Joined as TreeTable
Left Join View_CONTENT_BlogPost_Joined as BlogPostTable on TreeTable.DocumentID = BlogPostTable.DocumentID
Left Join View_CONTENT_BlogMonth_Joined as BlogMonthTable on TreeTable.DocumentID = BlogMonthTable.DocumentID
where TreeTable.ClassName in('CMS.BlogMonth', 'CMS.BlogPost')) as JoinedTable WHERE NodeAliasPath like '/Blog/%' and
DocumentMenuItemHideInNavigation = 0
AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= GETDATE()) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= GETDATE())) order by NodeLevel, BlogMonthStartingDate Desc, BlogPostDate Desc, NodeOrder
1.5 kB
 
Table (70 [126], 174 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.016
 
14 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/December-2017-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/December-2017-1/%")
@SiteID (1)
499 B
 
Table (1 [1], 4 B)
 
cmsvirtualfiles_transformations__vg_b6483ceb_0f8a_41b4_93f9_e51069bc5252_cms_folder_collapsiblemenuitemblog_ascx.__DataBind__control2 0.000
 
15 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/December-2017-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/December-2017-1/%")
@SiteID (1)
499 B
 
Table (1 [1], 4 B)
 
0.016
 
16 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/November-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/November-2017/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
17 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/November-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/November-2017/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
18 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/October-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/October-2017/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.000
 
19 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/October-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/October-2017/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.000
 
20 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/September-2017-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/September-2017-1/%")
@SiteID (1)
501 B
 
Table (1 [1], 4 B)
 
0.015
 
21 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/September-2017-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/September-2017-1/%")
@SiteID (1)
501 B
 
Table (1 [1], 4 B)
 
0.000
 
22 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/August-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/August-2017/%")
@SiteID (1)
491 B
 
Table (1 [1], 4 B)
 
0.000
 
23 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/August-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/August-2017/%")
@SiteID (1)
491 B
 
Table (1 [1], 4 B)
 
0.000
 
24 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/July-2017-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/July-2017-1/%")
@SiteID (1)
491 B
 
Table (1 [1], 4 B)
 
0.000
 
25 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/July-2017-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/July-2017-1/%")
@SiteID (1)
491 B
 
Table (1 [1], 4 B)
 
0.000
 
26 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/June-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/June-2017/%")
@SiteID (1)
487 B
 
Table (1 [1], 4 B)
 
0.000
 
27 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/June-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/June-2017/%")
@SiteID (1)
487 B
 
Table (1 [1], 4 B)
 
0.000
 
28 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/May-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/May-2017/%")
@SiteID (1)
485 B
 
Table (1 [1], 4 B)
 
0.000
 
29 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/May-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/May-2017/%")
@SiteID (1)
485 B
 
Table (1 [1], 4 B)
 
0.000
 
30 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/April-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/April-2017/%")
@SiteID (1)
489 B
 
Table (1 [1], 4 B)
 
0.000
 
31 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/April-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/April-2017/%")
@SiteID (1)
489 B
 
Table (1 [1], 4 B)
 
0.000
 
32 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/March-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/March-2017/%")
@SiteID (1)
489 B
 
Table (1 [1], 4 B)
 
0.000
 
33 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/March-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/March-2017/%")
@SiteID (1)
489 B
 
Table (1 [1], 4 B)
 
0.000
 
34 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/February-2016-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/February-2016-1/%")
@SiteID (1)
499 B
 
Table (1 [1], 4 B)
 
0.000
 
35 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/February-2016-1/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/February-2016-1/%")
@SiteID (1)
499 B
 
Table (1 [1], 4 B)
 
0.016
 
36 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/January-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/January-2017/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.000
 
37 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/January-2017/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/January-2017/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.000
 
38 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/December-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/December-2016/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
39 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/December-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/December-2016/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
40 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/November-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/November-2016/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
41 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/November-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/November-2016/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
42 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/October-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/October-2016/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.016
 
43 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/October-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/October-2016/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.000
 
44 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/September-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/September-2016/%")
@SiteID (1)
497 B
 
Table (1 [1], 4 B)
 
0.000
 
45 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/September-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/September-2016/%")
@SiteID (1)
497 B
 
Table (1 [1], 4 B)
 
0.000
 
46 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/April-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/April-2016/%")
@SiteID (1)
489 B
 
Table (1 [1], 4 B)
 
0.000
 
47 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/April-2016/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/April-2016/%")
@SiteID (1)
489 B
 
Table (1 [1], 4 B)
 
0.000
 
48 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/March/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/March/%")
@SiteID (1)
479 B
 
Table (1 [1], 4 B)
 
0.000
 
49 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/March/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/March/%")
@SiteID (1)
479 B
 
Table (1 [1], 4 B)
 
0.000
 
50 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/February/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/February/%")
@SiteID (1)
485 B
 
Table (1 [1], 4 B)
 
0.000
 
51 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/February/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/February/%")
@SiteID (1)
485 B
 
Table (1 [1], 4 B)
 
0.000
 
52 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/January/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/January/%")
@SiteID (1)
483 B
 
Table (1 [1], 4 B)
 
0.000
 
53 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/January/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/January/%")
@SiteID (1)
483 B
 
Table (1 [1], 4 B)
 
0.000
 
54 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/December-2015/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/December-2015/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
55 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/December-2015/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/December-2015/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
56 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/November-2015/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/November-2015/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
57 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/November-2015/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/November-2015/%")
@SiteID (1)
495 B
 
Table (1 [1], 4 B)
 
0.000
 
58 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/October-2015/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/October-2015/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.016
 
59 This same query was called more than once within this request.
(nwtc.transformationsqueries.getchildcount)
DECLARE @NodePath nvarchar(max) = N'/Blog/October-2015/%';
DECLARE @SiteID int = 1;

SELECT Count(*) as 'Count'
FROM CMS_Document as Doc
LEFT JOIN CMS_Tree as Tree on Doc.DocumentNodeID = tree.NodeID
LEFT JOIN CMS_Class as Class on Tree.NodeClassID = Class.ClassID
WHERE Doc.DocumentIsArchived = 0 and Doc.DocumentMenuItemHideInNavigation = 0 and (1=0 or Class.ClassName = 'CMS.BlogPost' ) and NodeAliasPath like @NodePath and tree.NodeSiteID = @SiteID
@NodePath ("/Blog/October-2015/%")
@SiteID (1)
493 B
 
Table (1 [1], 4 B)
 
0.000
 
60
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' )
) CombinedTables
WHERE ((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (Published = 1)) AND (NodeAliasPath like '/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (1172 [19], 341 kB)
 
PageContext.CurrentPage_InitComplete 0.094
 
61
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:10:23 AM';
DECLARE @NodeLevel int = 1;
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'/Blog', N'/'))) AND ([ClassName] IN (N'CMS.Blog', N'CMS.BlogMonth', N'CMS.BlogPost', 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:10:23 AM)
@NodeLevel (1)
@DocumentCulture ("en-US")
1.5 kB
 
Table (1 [36], 183 B)
 
CMSAbstractMenuProperties.OnLoad 0.031
 
62
(cms.site.generalselect)
SELECT [SiteID], [SiteName], [SiteStatus]
FROM CMS_Site
WHERE [SiteID] IN (
SELECT [IndexSiteID]
FROM CMS_SearchIndexSite
WHERE [IndexId] = 11
)
Table (1 [3], 15 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.000
 
63
(cms.blogpost.generalselect)
DECLARE @Now datetime2 = '1/18/2018 12:10:23 AM';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogPost AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[BlogPostID] AND V.ClassName = N'CMS.BlogPost' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (([DocumentID] IN (5495, 5386, 5333, 5291, 5289, 5151, 5072, 5009, 4999, 4872) AND [NodeLinkedNodeID] IS NULL)) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
@Now (1/18/2018 12:10:23 AM)
622 B
 
Table (10 [175], 30 kB)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.047
 
64
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '672bb9f3-02fc-4286-83d6-f63af99bc9e1';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (672bb9f3-02fc-4286-83d6-f63af99bc9e1)
302 B
 
Table (1 [1], 4 B)
 
CMSModules_SmartSearch_Controls_SearchResults.OnPreRender 0.000
 
65
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'fa70f55b-5493-42d2-8666-959d6051731b';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (fa70f55b-5493-42d2-8666-959d6051731b)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
66
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'e247fea1-24e8-44c8-856e-d5893facb738';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (e247fea1-24e8-44c8-856e-d5893facb738)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
67
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'c2cd07fc-3a02-476c-b576-c86126da920d';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (c2cd07fc-3a02-476c-b576-c86126da920d)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
68
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = 'c36f7a0c-3056-4da2-8a33-98e63a9ea0ed';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (c36f7a0c-3056-4da2-8a33-98e63a9ea0ed)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
69
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '77e7a710-870f-4bdf-8303-49595183aaf3';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (77e7a710-870f-4bdf-8303-49595183aaf3)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
70
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '9ca049b0-456f-45e2-bea2-4217692c6894';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (9ca049b0-456f-45e2-bea2-4217692c6894)
302 B
 
Table (1 [1], 5 B)
 
0.000
 
71
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '08969235-86d4-4162-8134-1c36cd3d0b7d';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (08969235-86d4-4162-8134-1c36cd3d0b7d)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
72
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '7d2611c4-4edd-4291-8fe7-0c832a416d2f';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (7d2611c4-4edd-4291-8fe7-0c832a416d2f)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
73
(cms.attachment.generalselect)
DECLARE @AttachmentSiteID int = 1;
DECLARE @AttachmentGuid uniqueidentifier = '0cc16ea9-9727-4013-ba9e-301cdf6f95ab';

SELECT TOP 1 [AttachmentExtension]
FROM CMS_Attachment
WHERE [AttachmentSiteID] = @AttachmentSiteID AND [AttachmentGuid] = @AttachmentGuid
@AttachmentSiteID (1)
@AttachmentGuid (0cc16ea9-9727-4013-ba9e-301cdf6f95ab)
302 B
 
Table (1 [1], 4 B)
 
0.000
 
74
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = '672bb9f3-02fc-4286-83d6-f63af99bc9e1';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (672bb9f3-02fc-4286-83d6-f63af99bc9e1)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 178 B)
 
cmsvirtualfiles_transformations__vg_c5a2f903_ec18_4c7d_970e_a6a3d01085a3_cms_blogpost_blogpostlisting_ascx.__DataBind__control2 0.000
 
75
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = 'fa70f55b-5493-42d2-8666-959d6051731b';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (fa70f55b-5493-42d2-8666-959d6051731b)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 165 B)
 
0.000
 
76
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = 'e247fea1-24e8-44c8-856e-d5893facb738';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (e247fea1-24e8-44c8-856e-d5893facb738)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 149 B)
 
0.000
 
77
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = 'c2cd07fc-3a02-476c-b576-c86126da920d';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (c2cd07fc-3a02-476c-b576-c86126da920d)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 167 B)
 
0.000
 
78
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = 'c36f7a0c-3056-4da2-8a33-98e63a9ea0ed';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (c36f7a0c-3056-4da2-8a33-98e63a9ea0ed)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 153 B)
 
0.016
 
79
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = '77e7a710-870f-4bdf-8303-49595183aaf3';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (77e7a710-870f-4bdf-8303-49595183aaf3)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 153 B)
 
0.000
 
80
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = '9ca049b0-456f-45e2-bea2-4217692c6894';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (9ca049b0-456f-45e2-bea2-4217692c6894)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 174 B)
 
0.000
 
81
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = '08969235-86d4-4162-8134-1c36cd3d0b7d';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (08969235-86d4-4162-8134-1c36cd3d0b7d)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 145 B)
 
0.000
 
82
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = '7d2611c4-4edd-4291-8fe7-0c832a416d2f';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (7d2611c4-4edd-4291-8fe7-0c832a416d2f)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 162 B)
 
0.000
 
83
(cms.attachment.generalselect)
DECLARE @AttachmentGuid uniqueidentifier = '0cc16ea9-9727-4013-ba9e-301cdf6f95ab';
DECLARE @AttachmentSiteID int = 1;

SELECT TOP 1 [AttachmentID], [AttachmentName], [AttachmentExtension], [AttachmentSize], [AttachmentMimeType], [AttachmentImageWidth], [AttachmentImageHeight], [AttachmentDocumentID], [AttachmentGUID], [AttachmentSiteID], [AttachmentLastModified], [AttachmentIsUnsorted], [AttachmentOrder], [AttachmentGroupGUID], [AttachmentFormGUID], [AttachmentHash], [AttachmentTitle], [AttachmentDescription], [AttachmentCustomData], [AttachmentSearchContent], [AttachmentVariantDefinitionIdentifier], [AttachmentVariantParentID]
FROM CMS_Attachment
WHERE [AttachmentGuid] = @AttachmentGuid AND [AttachmentSiteID] = @AttachmentSiteID
@AttachmentGuid (0cc16ea9-9727-4013-ba9e-301cdf6f95ab)
@AttachmentSiteID (1)
784 B
 
Table (1 [22], 169 B)
 
0.015
 
  83 queries, 56 kB write, 923 kB read   0.641