CONTENTSTART
EXCLUDESTART EXCLUDEEND

Mission, Vision and Values

Values

Customer Focus:

We are committed to exceeding the service and learning expectations of our customers and our community.

Everyone Has Worth:

We are committed to embracing the worth of every individual, creating a place for all people, and promoting the respectful environment necessary for intellectual and personal discovery.

Passion and Inspiration:

We have a personal passion for achieving the College’s vision, inspiring and motivating others to action.

Creativity and Innovation:

We are committed to energizing and fostering transformative change through challenging experiences, proactive thinking, and taking initiative.

Collaboration:

We are committed to open communication, teamwork, and productive conflict that strengthen relationships and create better solutions.

Emotional Intelligence:

We are committed to growth in our individual awareness through personal reflection, seeking input from others and aligning our actions.

Results and Accountability:

We are individually and collectively accountable for the sustainable and optimal use of resources and the achievement of meaningful, measurable results.

Valuing Talent & Well Being:

We are committed to fostering a mentally and physically healthy work environment that promotes learning and growth and attracts and retains talented people.

Ethics:

We are committed to ethical and honest behavior and personal responsibility for living and modeling the values of NWTC.

Our Mission

We are a two-year technical college, serving Northeast Wisconsin by providing education, training, and life-long learning opportunities for individuals and businesses leading to the development of a skilled workforce. Our customers stimulate the economic vitality of our district as a result of the application of skills and knowledge acquired through the completion of certificates, degrees, diplomas, and courses.

Our Vision

NWTC is a cutting edge life-long learning college that transforms, strengthens, and inspires.

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/008C/m2029786656.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 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
7 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|/about-nwtc/overview/mission-vision-and-values|en-us|/about-nwtc/overview/mission-vision-and-values|true
template|24108
nodeid|201
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/about-nwtc/overview/mission-vision-and-values|en-us||true|true
template|24108
nodeid|201
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/about-nwtc/overview/mission-vision-and-values|en-us
nodes|nwtc|cms.menuitem|all
node|nwtc|/about-nwtc/overview/mission-vision-and-values
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|/about-nwtc/overview|en-us||false PageContext.CurrentPage_InitComplete
7 GET pageinfo|nwtc|/about-nwtc|en-us||false
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|199
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|/about-nwtc/overview/mission-vision-and-values|/|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|/about-nwtc/overview/mission-vision-and-values|/|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|/about-nwtc/overview/mission-vision-and-values|/|newmobilemenu
19 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/overview/mission-vision-and-values|/|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|199
partial
template|24098
22 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|199
partial
template|24098
23 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|199
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|199
partial
template|24098
27 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|199
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|199
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|/about-nwtc/overview/mission-vision-and-values|/|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|/about-nwtc/overview/mission-vision-and-values|/|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|/about-nwtc/overview/mission-vision-and-values|/|newmobilemenu
39 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/about-nwtc/overview/mission-vision-and-values|/|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|199
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
42 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|199
partial
template|24098
43 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|199
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|199
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
47 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|199
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|199
partial
template|24098
52 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|199
partial
template|24098
53 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|199
partial
template|24098
54 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|199
partial
template|24098
55 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|199
partial
template|24098
56 GET onlinemarketingcpvariantsbytemplateid|24108 PageContext.CurrentPage_InitComplete
57 GET onlinemarketingcpvariantsbytemplateid|24108
58 GET onlinemarketingcpvariantsbytemplateid|24108
59 GET onlinemarketingcpvariantsbytemplateid|24108
60 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24108
CMSWebPartZone.CachedWebPart_Init
61 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24108
62 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|199
partial
template|24108
63 ADD Partial cache (LeftMenu)
webpartinstance|a0c23aa1-64dd-4117-b3f1-658d14ebcd1b
partial
template|24108
64 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24108
PageContext.CurrentPage_InitComplete
65 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24108
66 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|199
partial
template|24108
67 ADD Partial cache (LeftMenu)
webpartinstance|a0c23aa1-64dd-4117-b3f1-658d14ebcd1b
partial
template|24108
68 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
69 GET pageinfo|nwtc|/master-items/mega-menus/admissions|en-us||false CMSAbstractWebPart.OnLoad
70 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
71 GET inlinewidgetcontrol|528|1572
72 GET pageinfo|nwtc|/master-items/mega-menus/programs|en-us||false CMSAbstractWebPart.OnLoad
73 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
74 GET inlinewidgetcontrol|528|1572
75 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
76 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
77 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
78 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
79 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
80 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
81 ADD breadcrumbs|nwtc|/about-nwtc/overview/mission-vision-and-values|en-us|false|cms.menuitem;nwtc.programcluster||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/about-nwtc/overview/mission-vision-and-values
node|nwtc|/about-nwtc/overview
node|nwtc|/about-nwtc
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
82 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
83 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
84 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'/about-nwtc/overview/mission-vision-and-values';
DECLARE @NodeAliasPath nvarchar(max) = N'/about-nwtc/overview/mission-vision-and-values';
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'/about-nwtc/overview/mission-vision-and-values' 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 ("/about-nwtc/overview/mission-vision-and-values")
@NodeAliasPath ("/about-nwtc/overview/mission-vision-and-values")
@DocumentCulture ("en-US")
3.6 kB
 
Table (1 [65], 13.5 kB)
 
SimpleHandler`2.StartEvent 0.023
 
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'/About-NWTC/Overview', N'/About-NWTC', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
404 B
 
Table (3 [157], 28 kB)
 
SimpleHandler`2.StartEvent 0.011
 
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.003
 
4
(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 = 201) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
395 B
 
Table (1 [166], 13.9 kB)
 
SimpleHandler`2.StartEvent 0.021
 
5
(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.003
 
6
(cms.acl.generalselect)
DECLARE @ACLID int = 44;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (44)
78 B
 
Table (1 [5], 54 B)
 
SimpleHandler`2.StartEvent 0.002
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
DECLARE @UserID int = 65;
DECLARE @SiteID int = 1;
DECLARE @Date datetime2 = '1/16/2018 1:04:20 PM';

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 (12,44)

@UserID (65)
@SiteID (1)
@Date (1/16/2018 1:04:20 PM)
1.3 kB
 
SimpleHandler`2.StartEvent 0.005
 
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.002
 
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.032
 
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.018
 
11
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 199
PageContext.CurrentPage_InitComplete 0.007
 
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' )
) CombinedTables
WHERE ((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/About-NWTC/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (259 [19], 69 kB)
 
PageContext.CurrentPage_InitComplete 0.048
 
13
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/16/2018 1:04:22 PM';
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'/About-NWTC/Overview/Mission-Vision-and-Values', N'/About-NWTC/Overview', N'/About-NWTC', N'/'))) AND ([ClassName] IN (N'CMS.MenuItem', N'NWTC.ProgramCluster')) 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/16/2018 1:04:22 PM)
@NodeLevel (3)
@DocumentCulture ("en-US")
1.6 kB
 
Table (3 [36], 657 B)
 
CMSAbstractMenuProperties.OnLoad 0.025
 
  13 queries, 18.2 kB write, 151 kB read   0.200