CONTENTSTART
EXCLUDESTART EXCLUDEEND

Small Business Initiative

CTED Corporate Training and Economic Development Small Business Initiative Workshops, Networking, Special Events

Welcome to the Small Business Initiative at NWTC. Are you looking to take your business to the next level? Want to turn your entrepreneurial idea into a business? The Small Business Initiative is a great place to start!

The Small Business Initiative (SBI) is the comprehensive resource in Northeast Wisconsin to assist in the development of entrepreneurs and growth of local small businesses. The Small Business Initiative provides customized coaching and workshops with the help of our team of experienced business owners, entrepreneurs, marketing, operations, legal and financial professionals. Let us help you put your business on the path to success through our specialized programming. 

What can you do at the Small Business Initiative? 

  • Receive one-on-one coaching
  • Participate in team building programs
  • Network and receive referrals to professional service providers
  • Get marketing and graphic design advice for business
  • Learn from business-focused workshops
  • Attend special events centered on small business success
  • Assess your entrepreneurial talents
  • Get the resources you need to launch or develop your business.
  • Earn a credential, take a class, or attend a seminar/workshop.
  • Get inspired by the latest trends, tips, and thought leadership. 

Visit our office!

The Small Business Initiative is located in the Advance Business and Manufacturing Center building on the NWTC Green Bay Campus.

Contact the Small Business Initiative today! 

sbi@nwtc.edu or call (920) 498-6379
 


Are you considering starting a business?

NWTC BOOST Entrepreneurial Boot Camp Image

Do you have an idea for a business, but have no idea where to start? The BOOST 5 Day Entrepreneurial Boot Camp is an intensive program that is designed to provide you with the tools you need to turn an idea or opportunity into a successful business!

BOOST Entrepreneurial Boot Camp is a new program that is scheduled over five days at the Advance Business & Manufacturing Center in Green Bay. The format includes learning activites as individuals and as a group, interactive dialogue with the presenters, individual project work on your business idea and opportunities to network with presenters and classmates. The topics covered in this program are a sampling of high demand areas that any entrepreneur would be seeking for approval of a product and/or service. They include:
  • Risk and inspiration to begin the journey of an entrepreneur
  • Accounting
  • Legal Matters
  • Marketing, Branding, Social Media
  • Local Resources
  • Capital and Banking
  • Business Insurance
The goal of this bootcamp is to provide you with working tools to utilize in additional training programs over the course of the business development process. The additional investment of time and energy will yield the following results:
  • Establish the initial framework necessarty to create and/or revise a solid business plan
  • Create a presentation showcasing initial business plan highlights and present to an executive panel of investors, business leaders and entrepeneurship coaches
  • Develop the foundational strategy fora comprehensive marketing plan and branding platform for the service/product
Class Schedule:
Wednesday 3/21 - 5pm to 9pm
Thursday 3/22 - 5pm to 9pm
Friday 3/23 - 5pm to 9pm
Saturday 3/24 - 8am to 4pm
Sunday - OFF
Monday 3/26 - 5pm to 9pm

Awards:
Participatnts are eligible for awards providing complementary professional services and scholarships for additional training. In addition, all participants completing the Boot Camp will receive a certificate of completion and graduation gift.

Register for the BOOST Entrepreneurial Boot Camp on Eventbrite

More Information:
Contact NWTC Small Business Initiative, Michelle Madl-Soehren (920) 498-6379
Ticket sales end 3/19 @ 6pm
7 day refund policy

 
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/009D/m1694359555.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|/business-industry/business-resources/small-business-initiative|en-us|/business-industry/business-resources/small-business-initiative|true
template|24105
nodeid|1748
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|nwtc|https://wwwdev.nwtc.edu/business-industry/business-resources/small-business-initiative|en-us||true|true
template|24105
nodeid|1748
SimpleHandler`2.StartEvent
3 ADD currentdocument|nwtc|/business-industry/business-resources/small-business-initiative|en-us
nodes|nwtc|cms.menuitem|all
node|nwtc|/business-industry/business-resources/small-business-initiative
SimpleHandler`2.StartEvent
4 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
5 GET siteresourcerolespermissions|1|cms.content SimpleHandler`2.StartEvent
6 ADD pageinfo|nwtc|/business-industry/business-resources|en-us||false
template|24108
nodeid|1225
PageContext.CurrentPage_InitComplete
7 GET pageinfo|nwtc|/business-industry|en-us||false PageContext.CurrentPage_InitComplete
8 GET pageinfo|nwtc|/|en-us||false
9 ADD Partial cache (FollowUsIcons)
webpartinstance|cee26456-df64-4365-b6c9-97254b0aae37
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
10 ADD Partial cache (SocialQuickLinks)
webpartinstance|f2f76694-7317-40d1-88a9-e32da8c6e5b3
partial
template|24098
11 ADD Partial cache (Logo)
webpartinstance|9cf64ba0-e6e5-4b12-bf8f-7c9eb1e63fa0
documentid|1746
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|/business-industry/business-resources/small-business-initiative|/|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|/business-industry/business-resources/small-business-initiative|/|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|/business-industry/business-resources/small-business-initiative|/|newmobilemenu
19 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/business-industry/business-resources/small-business-initiative|/|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|1746
partial
template|24098
22 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1746
partial
template|24098
23 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1746
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|1746
partial
template|24098
27 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1746
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|1746
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|/business-industry/business-resources/small-business-initiative|/|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|/business-industry/business-resources/small-business-initiative|/|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|/business-industry/business-resources/small-business-initiative|/|newmobilemenu
39 ADD Partial cache (MobileMenu)
webpartinstance|e569868b-0908-4ea9-8c19-9be0feec8022
partial
template|24098
controlexpiracy||username=|sitename=nwtc|lang=en-us|/business-industry/business-resources/small-business-initiative|/|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|1746
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
42 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1746
partial
template|24098
43 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1746
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|1746
partial
template|24098
CMSWebPartZone.CachedWebPart_Init
47 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1746
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|1746
partial
template|24098
52 ADD Partial cache (FooterContent2)
webpartinstance|d4d02dfd-df3b-4979-afe3-cc5f612a46ff
documentid|1746
partial
template|24098
53 ADD Partial cache (FooterContent3)
webpartinstance|9a8686e1-8b18-4783-b60b-87f42d3b229f
documentid|1746
partial
template|24098
54 ADD Partial cache (CopyrightLeftContent)
webpartinstance|c43c1c63-190c-4dea-9469-d3b744a928f2
documentid|1746
partial
template|24098
55 ADD Partial cache (CopyrightRightContent)
webpartinstance|4da75bb0-d6be-4e69-b3ce-1ab3ecb56e7a
documentid|1746
partial
template|24098
56 GET onlinemarketingcpvariantsbytemplateid|24105 PageContext.CurrentPage_InitComplete
57 GET onlinemarketingcpvariantsbytemplateid|24105
58 GET onlinemarketingcpvariantsbytemplateid|24105
59 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24105
CMSWebPartZone.CachedWebPart_Init
60 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24105
61 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|1746
partial
template|24105
62 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|1746
partial
template|24105
63 ADD Partial cache (NewLeftMenu)
webpartinstance|07769954-cbf0-4d4f-be40-7f5c973d5ac4
partial
template|24105
64 ADD Partial cache (LeftMenu)
webpartinstance|752c82b4-5689-4f18-b6f4-ffb101f89bd4
partial
template|24105
65 ADD Partial cache (Breadcrumbs)
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
partial
template|24105
PageContext.CurrentPage_InitComplete
66 ADD Partial cache (Title)
webpartinstance|4786d690-c462-4969-bbdd-c3580d8f14af
partial
template|24105
67 ADD Partial cache (MainImage)
webpartinstance|19f96105-92a8-4331-9a25-178b17ac5a9f
documentid|1746
partial
template|24105
68 ADD Partial cache (MainContent)
webpartinstance|a4cf9a45-5985-4dbd-bfdf-cb6bb62f34cc
documentid|1746
partial
template|24105
69 ADD Partial cache (NewLeftMenu)
webpartinstance|07769954-cbf0-4d4f-be40-7f5c973d5ac4
partial
template|24105
70 ADD Partial cache (LeftMenu)
webpartinstance|752c82b4-5689-4f18-b6f4-ffb101f89bd4
partial
template|24105
71 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
72 GET pageinfo|nwtc|/master-items/mega-menus/admissions|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/programs|en-us||false CMSAbstractWebPart.OnLoad
76 GET inlinewidgetcontrol|528|1572 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
77 GET inlinewidgetcontrol|528|1572
78 GET pageinfo|nwtc|/master-items/mega-menus/student-experience|en-us||false CMSAbstractWebPart.OnLoad
79 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
80 GET pageinfo|nwtc|/master-items/mega-menus/corporate-training|en-us||false CMSAbstractWebPart.OnLoad
81 GET pageinfo|nwtc|/master-items/mega-menus/about-nwtc|en-us||false
82 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
83 GET pageinfo|nwtc|/resources/shared-page-content/satisfaction|en-us||false CMSAbstractWebPart.OnLoad
84 ADD breadcrumbs|nwtc|/business-industry/business-resources/small-business-initiative|en-us|false|cms.menuitem;nwtc.programcluster||true|
webpartinstance|d216008d-0c9d-4dfe-8348-f4f4c0bfa48e
node|nwtc|/business-industry/business-resources/small-business-initiative
node|nwtc|/business-industry/business-resources
node|nwtc|/business-industry
node|nwtc|/
CMSAbstractMenuProperties.OnLoad
85 ADD cmsdatasource||en-us|nwtc|/resources/shared-page-content/erc-social-links|en-us|false|custom.shareablecontent|||-1|true|00000000-0000-0000-0000-000000000000||false|0||false||
webpartinstance|8a0e3e6d-90c3-4030-a317-9ce67d00c20e
nodes|nwtc|custom.shareablecontent|all
node|nwtc|/resources/shared-page-content/erc-social-links
BasicRepeater.OnLoad
86 ADD pageinfo|nwtc|/resources/shared-page-content/erc-social-links|en-us||false
template|24101
nodeid|2775
CMSAbstractWebPart.OnLoad
87 GET inlinewidgetcontrol|526|1571 CMSModules_Widgets_InlineControl_InlineWidget.Page_Load
88 GET favicon|nwtc CMSPages_PortalTemplate.OnPreRender
89 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'/business-industry/business-resources/small-business-initiative';
DECLARE @NodeAliasPath nvarchar(max) = N'/business-industry/business-resources/small-business-initiative';
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'/business-industry/business-resources/small-business-initiative' 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 ("/business-industry/business-resources/small-business-initiative")
@NodeAliasPath ("/business-industry/business-resources/small-business-initiative")
@DocumentCulture ("en-US")
3.7 kB
 
Table (1 [65], 25 kB)
 
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] IN (N'/Business-Industry/Business-Resources', N'/Business-Industry', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
428 B
 
Table (3 [157], 58 kB)
 
SimpleHandler`2.StartEvent 0.016
 
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.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 = 1748) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
396 B
 
Table (1 [166], 25 kB)
 
SimpleHandler`2.StartEvent 0.016
 
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.000
 
6
(cms.acl.generalselect)
DECLARE @ACLID int = 16;

SELECT *
FROM CMS_ACL
WHERE [ACLID] = @ACLID
@ACLID (16)
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:03:35 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 (16)

@UserID (65)
@SiteID (1)
@Date (1/18/2018 12:03:35 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
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 1225;

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

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
 
12
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

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

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

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

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_Blog ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_Blog.BlogID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.Blog' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((((((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/%')) AND (NodeLevel < 3)) AND (Published = 1)) 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.047
 
13
SELECT * FROM (
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
INNER JOIN CONTENT_MenuItem ON
View_CMS_Tree_Joined_Versions.DocumentForeignKeyValue = CONTENT_MenuItem.MenuItemID
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'CMS.MenuItem' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )

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

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

UNION ALL
( SELECT [documentmenujavascript], [documentmenucaption], [documentname], NULL as [menuitemname], [documentmenuredirecturl], [nodename], [nodeid], [nodealiaspath], [documentnamepath], [documentid], [documentmenuitemhideinnavigation], [documentculture], [nodelinkednodeid], [sitename], [classname], [nodelevel], [nodeorder], [nodeparentid], [published]
FROM view_cms_tree_joined_versions
LEFT OUTER JOIN COM_SKU ON view_cms_tree_joined_versions.NodeSKUID = COM_SKU.SKUID
WHERE [classname] = N'NWTC.ProgramSubCluster' and [NodeSiteID] =1 AND [DocumentCulture] = 'en-US' )
) CombinedTables
WHERE ((DocumentMenuItemHideInNavigation = 0) AND (NodeAliasPath like '/Business-Industry/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.8 kB
 
Table (50 [19], 14.7 kB)
 
CMSWebPartZone.CachedWebPart_Init 0.016
 
14
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 '/Business-Industry/%')) AND (Published = 1)) AND (NodeAliasPath like '/Business-Industry/%')) AND (Published = 1)
ORDER BY 1,NodeLevel, NodeOrder
2.9 kB
 
Table (50 [19], 14.7 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
15
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:03:36 AM';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND ([NodeAliasPath] IN (N'/Business-Industry/Business-Resources/Small-Business-Initiative', N'/Business-Industry/Business-Resources', N'/Business-Industry', 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/18/2018 12:03:36 AM)
@NodeLevel (3)
@DocumentCulture ("en-US")
1.6 kB
 
Table (3 [36], 734 B)
 
CMSAbstractMenuProperties.OnLoad 0.000
 
16
(custom.shareablecontent.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '1/18/2018 12:03:36 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/Resources/Shared-Page-Content/ERC-Social-links';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN custom_ShareableContent AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ShareableContentID] AND V.ClassName = N'custom.ShareableContent' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (1/18/2018 12:03:36 AM)
@NodeAliasPath ("/Resources/Shared-Page-Content/ERC-Social-links")
@DocumentCulture ("en-US")
873 B
 
Table (1 [159], 4.9 kB)
 
BasicRepeater.OnLoad 0.016
 
17
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/Resources/Shared-Page-Content/ERC-Social-links';
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 [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 ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@NodeAliasPath ("/Resources/Shared-Page-Content/ERC-Social-links")
@DocumentCulture ("en-US")
3.3 kB
 
Table (1 [65], 4.5 kB)
 
CMSAbstractWebPart.OnLoad 0.000
 
18
(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'/Resources/Shared-Page-Content', N'/Resources', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
413 B
 
Table (3 [157], 8.7 kB)
 
CMSAbstractWebPart.OnLoad 0.016
 
  18 queries, 29 kB write, 238 kB read   0.172