TruGreen.com sitemap

Back to top
800-800-8008
Arrange a call back
700-700-7007
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
7 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
8 >> TypeInfo(cms.pagetemplate).Events.GetData SimpleHandler`2.StartEvent
9 >> URLRewritingEvents.ProcessABTest.Execute SimpleHandler`2.StartEvent
>>> ABHandlers.ProcessABTest
10 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
>>> URLRewritingEvents.ProcessRewritingResult.Before
>>>> CustomApplicationEventsAttribute.ProcessRewritingResult_Before
11 >>>>> DocumentEvents.GetData SimpleHandler`2.StartEvent
12 >>>>>> TypeInfo(cms.document.tg.urlredirect).Events.GetData SimpleHandler`2.StartEvent
13 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
14 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
15 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
16 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> CustomApplicationEventsAttribute.SessionStart_Execute
17 >> DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
18 >>> TypeInfo(cms.document.tg.product).Events.GetData ObjectQueryBase`2.GetEnumerator
19 >> DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
20 >>> TypeInfo(cms.document.tg.servicetype).Events.GetData ObjectQueryBase`2.GetEnumerator
21 RequestEvents.AcquireRequestState.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
22 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
23 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
24 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
25 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
26 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
27 DocumentEvents.GetData TextLayout.CreateChildControls
28 TypeInfo(cms.document.cms.menuitem).Events.GetData TextLayout.CreateChildControls
29 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
30 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
31 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
32 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
33 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
34 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
35 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
36 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
37 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
38 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
39 TypeInfo(cms.document.tg.megamenuitem).Events.GetData ObjectQueryBase`2.GetEnumerator
40 DocumentEvents.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
41 TypeInfo(cms.document.tg.infographic).Events.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
42 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
43 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
44 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
45 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
46 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
47 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
48 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
49 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
50 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
51 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
52 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
53 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
54 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
55 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
56 DocumentEvents.GetData MultiObjectQueryBase`3.GetEnumerator
57 TypeInfo(cms.document).Events.GetData MultiObjectQueryBase`3.GetEnumerator
58 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
59 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
60 DocumentEvents.GetData BasicRepeater.OnLoad
61 TypeInfo(cms.document.cms.menuitem).Events.GetData BasicRepeater.OnLoad
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
2 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
3 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
4 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator PageContext.CurrentPage_InitComplete
2 ValidateHash True s=GetMyAccountFirstName(); if (s.Length > 0) { %} <li class="regular-mobile-menu"><a href="/manage-my-account">{%s%}'s Account</a> <ul class="sub-hide-mobile-menu"> <li class="sub-mobile-menu"><a href="/account/logout">Account Log Out</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account">Account Summary</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/transaction-history">Billing History</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/servce-history">Service Details</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/account-update">Update Account</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/faq">Questions</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/prepay">PrePay and Save</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/easypay-status">EasyPay Settings</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/prepay">Save money by paying up front for a full year</a></li> <li class="sub-mobile-menu"><a href="/manage-my-account/prepay">Sign Up for PrePay</a></li> </ul> </li> </li> {%} else { %} <a {% (IsBranchFranchise() =="true") ? "" : "href='/manage-my-account/login'" %}>Account Log In</a> {%} ron.cundiff PageContext.CurrentPage_InitComplete
3 ValidateHash True s=GetMyAccountFirstName(); if (s.Length > 0) { print(ResolveMacros("\r\n <li class=\"regular-mobile-menu\"><a href=\"/manage-my-account\">{%s%\}\'s Account</a>\r\n\t\t\t<ul class=\"sub-hide-mobile-menu\">\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/account/logout\">Account Log Out</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account\">Account Summary</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/transaction-history\">Billing History</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/servce-history\">Service Details</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/account-update\">Update Account</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/faq\">Questions</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">PrePay and Save</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/easypay-status\">EasyPay Settings</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Save money by paying up front for a full year</a></li>\r\n\t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Sign Up for PrePay</a></li> \r\n\t\t\t</ul>\r\n\t\t</li>\r\n </li>\r\n "))} else { print(ResolveMacros(" \r\n <a {% (IsBranchFranchise() ==\"true\") ? \"\" : \"href=\'/manage-my-account/login\'\" %\}>Account Log In</a> \r\n "))} ron.cundiff PageContext.CurrentPage_InitComplete
4 ValidateHash True FormatNotEmpty(GetUserZipCode(), "{0}", "Enter Zip") administrator PageContext.CurrentPage_InitComplete
5 ValidateHash True branchUrl = GetUserBranchUrl(); if (branchUrl.Length > 0) { %} <a href="{% branchUrl %}" id="LocalBranch">Your Local Branch</a> {% } ron.cundiff
6 ValidateHash True if (GetSessionVariable("sls-cobranding") != null) { "src='/TruGreen/media/images/tg-sls.png' class='sls-logo'" } else { "src='/TruGreen/media/images/header-logo.png'" } administrator
7 ValidateHash True CurrentDocument.DocumentName administrator TextLayout.CreateChildControls
8 ValidateHash True RenderView("~/Views/TruGreen/Shared/_StylesCombined.cshtml")ron.cundiff DocumentBase.Load
9 ValidateHash True RenderView("~/Views/TruGreen/Shared/_ScriptsCombined.cshtml")ron.cundiff
10 ValidateHash True if(CurrentDocument.DocumentName == "Homepage") { @"<meta name=""google-site-verification"" content=""xroegriqTZDld_HsGJXi42RWPgAN9qWGJAtJA2PXd_w"" />" administrator
11 ValidateHash True if (CurrentDocument.BodyIdValue.Length > 0) { CurrentDocument.BodyIdValue; } else { CurrentDocument.DocumentName; } ron.cundiff
12 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator CMSPagePlaceholder.LoadRegionsContent
13 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator CMSPagePlaceholder.LoadRegionsContent
14 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } administrator CMSWebParts_General_javascript.OnPreRender
15 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } administrator
16 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } administrator
17 This same security check is called more than once within the request. ValidateHash True CurrentDocument.DocumentNameadministrator
18 This same security check is called more than once within the request. ValidateHash True QueryString["q"]administrator
19 This same security check is called more than once within the request. ValidateHash True if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";}administrator
20 This same security check is called more than once within the request. ValidateHash True CurrentDocument.DocumentNameadministrator
21 This same security check is called more than once within the request. ValidateHash True QueryString["q"]administrator
22 This same security check is called more than once within the request. ValidateHash True if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";}administrator
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|trugreen|/sitemap|en-us|/sitemap|true
template|24161
nodeid|2526
pageinfo
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|trugreen|http://devkcms.trugreen.vanickurl.com/sitemap|en-us||true|true
template|24161
nodeid|2526
pageinfo
SimpleHandler`2.StartEvent
3 GET pageinfo|trugreen|/|en-us||false PageContext.CurrentPage_InitComplete
4 ADD currentdocument|trugreen|/sitemap|en-us
nodes|trugreen|cms.menuitem|all
node|trugreen|/sitemap
TextLayout.CreateChildControls
5 ADD breadcrumbs|trugreen|/sitemap|en-us|false|||true|
webpartinstance|973997f9-36cb-4e3b-b4c8-aabd6a0600e0
node|trugreen|/sitemap|childnodes
CMSAbstractMenuProperties.OnLoad
6 ADD cmsdatasource||en-us|trugreen|/sitemap|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|a7af324f-4d2d-421b-96f1-ed50778e0c01
nodes|trugreen|cms.menuitem|all
node|trugreen|/sitemap
BasicRepeater.OnLoad
7 GET cmsdatasource||en-us|trugreen|/sitemap|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| BasicRepeater.OnLoad
8 GET cmsdatasource||en-us|trugreen|/sitemap|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
9 GET cmsdatasource||en-us|trugreen|/sitemap|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
10 GET cmsdatasource||en-us|trugreen|/sitemap|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
11 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /sitemap 0.000
0.013
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.013
21.350
 
3 > OnPreInit 21.363
0.000
 
4 > OnInit 21.363
0.034
 
5 > OnLoad 21.397
0.109
 
6 > OnPreRender 21.506
N/A
    21.506  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookie4Bbs3fnQL3+N3VtuXX/uYoMNPuNzaaB4P9S9mlik
3 ASP.NET_SessionIduy3a0wwxmnpzolsx23eauppy
4 persistlastVisit=3/19/2019 4:44:24 AM&cookieId=9f43d3e2-0f8f-440f-91c7-e8891787a336
5 __RequestVerificationTokenD26MDJKc6_7sQGWOorqsLUiO7fX68G3o_bzyFTQ7POvopdOL_ked4oYf2LbQzjqpsRjzqkp81uCQj7bwM338ouVzAmESMhaS6lgv3MZaM8o1
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US3/19/2020 4:44:24 AM
2 CMSCsrfCookie4Bbs3fnQL3+N3VtuXX/uYoMNPuNzaaB4P9S9mlik 
3 ASP.NET_SessionIduy3a0wwxmnpzolsx23eauppy 
4 persistlastVisit=3/19/2019 4:44:24 AM&cookieId=9f43d3e2-0f8f-440f-91c7-e8891787a3364/18/2019 4:44:24 AM
5 __RequestVerificationTokenD26MDJKc6_7sQGWOorqsLUiO7fX68G3o_bzyFTQ7POvopdOL_ked4oYf2LbQzjqpsRjzqkp81uCQj7bwM338ouVzAmESMhaS6lgv3MZaM8o1 
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.243.17.113
5 UserName 
6 SessionIDuy3a0wwxmnpzolsx23eauppy
7 ServerNameTG01CMSIIS2
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/sitemap';
DECLARE @NodeAliasPath nvarchar(max) = N'/sitemap';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '3/19/2019 4:44:24 AM';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/sitemap' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) 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))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.6 kB
 
Table (1 [64], 346 B)
 
SimpleHandler`2.StartEvent 0.004
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
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
Table (1 [157], 2.1 kB)
 
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
3
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 24161;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 54 kB)
 
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
4
(tg.urlredirect.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @IsActive bit = 1;
DECLARE @Request nvarchar(max) = N'/sitemap';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_UrlRedirect AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.UrlRedirectID AND V.ClassName = N'TG.UrlRedirect' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [IsActive] = @IsActive AND [Request] = @Request AND [DocumentCulture] = @DocumentCulture
546 B
 
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
5
(tg.product.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_Product AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.ProductID AND V.ClassName = N'TG.Product' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (174 [177], 415 kB)
 
ObjectQueryBase`2.GetEnumerator 0.012
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
6
(tg.servicetype.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_ServiceType AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.ServiceTypeID AND V.ClassName = N'TG.ServiceType' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (23 [169], 27 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
TextLayout.CreateChildControls N/A
7
(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 = 2526) AND [DocumentCulture] = @DocumentCulture
Table (1 [353], 7.5 kB)
 
TextLayout.CreateChildControls 0.002
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
8
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 2514
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
9 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
10 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
11 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
12 This same query was called more than once within this request.
(tg.megamenuproductcategory.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuProductCategory AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuProductCategoryID AND V.ClassName = N'TG.MegaMenuProductCategory' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID AND [DocumentCulture] = @DocumentCulture
Table (3 [167], 3.2 kB)
 
ObjectQueryBase`2.GetEnumerator 0.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
N/A
13
(tg.megamenuitem.generalselect)
DECLARE @NodeSiteID int = 1;

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_MegaMenuItem AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.MegaMenuItemID AND V.ClassName = N'TG.MegaMenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE [NodeSiteID] = @NodeSiteID
ORDER BY [SortOrder]
Table (10 [162], 8.5 kB)
 
ObjectQueryBase`2.GetEnumerator 0.002
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
14
(tg.infographic.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @p int = 1;

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_Infographic AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.InfographicID AND V.ClassName = N'TG.Infographic' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE ([NodeSiteID] = @NodeSiteID) AND (([Featured] = @p))
ORDER BY [SORTORDER] DESC
Table (1 [172], 2.2 kB)
 
_Page_Views_TruGreen_Megamenu_cshtml.Execute 0.002
 
CloseConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
OpenConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
15 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'tree')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
719 B
 
Table (2 [157], 1.9 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.004
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
N/A
16 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'other')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
720 B
 
Table (3 [157], 2.8 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.005
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
N/A
17 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'tree')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
719 B
 
Table (2 [157], 1.9 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.005
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
N/A
18 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'other')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
720 B
 
Table (3 [157], 2.8 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.005
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
N/A
19 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'tree')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
719 B
 
Table (2 [157], 1.9 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.005
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
N/A
20 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'other')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
720 B
 
Table (3 [157], 2.8 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.005
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
N/A
21 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'tree')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
719 B
 
Table (2 [157], 1.9 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.004
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
N/A
22 This same query was called more than once within this request.
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/products-and-services/%';
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
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] LIKE @NodeAliasPath AND (DocumentMenuStyle = 'other')) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY DocumentName ASC
720 B
 
Table (3 [157], 2.8 kB)
 
MultiObjectQueryBase`3.GetEnumerator 0.005
 
CloseConnection()
MultiObjectQueryBase`3.GetEnumerator N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
23
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '3/19/2019 4:44:45 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'/sitemap', N'/')) 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
1.4 kB
 
Table (2 [36], 230 B)
 
CMSAbstractMenuProperties.OnLoad 0.002
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
24
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '3/19/2019 4:44:45 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/sitemap';
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 [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)
727 B
 
Table (1 [353], 7.5 kB)
 
BasicRepeater.OnLoad 0.004
 
CloseConnection()
BasicRepeater.OnLoad N/A
  24 queries, 16.1 kB write, 556 kB read   0.084
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% CurrentDateTime.Year %} 2019 administrator PageContext.CurrentPage_InitComplete 0.000
 
> CurrentDateTime.Year 2019 0.000
 
>> CurrentDateTime 3/19/2019 4:44:45 AM 0.000
 
2 {% s=GetMyAccountFirstName(); if (s.Length > 0) { print(ResolveMacros(" <li class=\"regular-mobile-menu\"><a href=\"/manage-my-account\">{%s%}\'s Account</a> \t\t\t<ul class=\"sub-hide-mobile-menu\"> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/account/logout\">Account Log Out</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account\">Account Summary</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/transaction-history\">Billing History</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/servce-history\">Service Details</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/account-update\">Update Account</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/faq\">Questions</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">PrePay and Save</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/easypay-status\">EasyPay Settings</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Save money by paying up front for a full year</a></li> \t\t\t\t<li class=\"sub-mobile-menu\"><a href=\"/manage-my-account/prepay\">Sign Up for PrePay</a></li> \t\t\t</ul> \t\t</li> </li> "))} else { print(ResolveMacros(" <a {% (IsBranchFranchise() ==\"true\") ? \"\" : \"href=\'/manage-my-account/login\'\" %}>Account Log In</a> "))} %} <a href='/manage-my-account/login'>Account Log In</a> ron.cundiff PageContext.CurrentPage_InitComplete 0.001
 
> s = GetMyAccountFirstName(); if (s.Length > 0) { ... } else { ... } <a href='/manage-my-account/login'>Account Log In</a> 0.001
 
> s.Length 0 0.001
 
>> s 0.001
 
> {% (IsBranchFranchise() =="true") ? "" : "href='/manage-my-account/login'" %} href='/manage-my-account/login' 0.000
 
3 {% GetServiceNumber() %} 800.458.4186 PageContext.CurrentPage_InitComplete 0.000
 
4 {% FormatNotEmpty(GetUserZipCode(), "{0}", "Enter Zip") %} Enter Zip administrator PageContext.CurrentPage_InitComplete 0.000
 
5 {% branchUrl = GetUserBranchUrl(); if (branchUrl.Length > 0) { print(ResolveMacros(" <a href=\"{% branchUrl %}\" id=\"LocalBranch\">Your Local Branch</a> ")) } %} null ron.cundiff 0.004
 
> branchUrl = GetUserBranchUrl(); if (branchUrl.Length > 0) { ... } null 0.004
 
> branchUrl.Length 0 0.004
 
>> branchUrl 0.004
 
6 {% if (GetSessionVariable("sls-cobranding") != null) { "src='/TruGreen/media/images/tg-sls.png' class='sls-logo'" } else { "src='/TruGreen/media/images/header-logo.png'" } %} src='/TruGreen/media/images/header-logo.png' administrator 0.001
 
> if (GetSessionVariable("sls-cobranding") != null) { ... } else { ... } src='/TruGreen/media/images/header-logo.png' 0.000
 
7 {% CurrentDocument.DocumentName %} Sitemap administrator TextLayout.CreateChildControls 0.006
 
> CurrentDocument.DocumentName Sitemap 0.006
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.006
 
8 {% TGFRepeaterTransformationName %} null PageContext.CurrentPage_InitComplete 0.000
 
> TGFRepeaterTransformationName null 0.000
 
9 {% TGGRepeaterTransformationName %} null 0.000
 
> TGGRepeaterTransformationName null 0.000
 
10 {% TGDRepeaterTransformationName %} null 0.001
 
> TGDRepeaterTransformationName null 0.000
 
11 {% TGCRepeaterTransformationName %} CMS.MenuItem.TGRES-TGC-Default-with-no-Subhead 0.001
 
> TGCRepeaterTransformationName CMS.MenuItem.TGRES-TGC-Default-with-no-Subhead 0.001
 
12 {% TGARepeaterTransformationName %} null 0.000
 
> TGARepeaterTransformationName null 0.000
 
13 {% RenderView("~/Views/TruGreen/Shared/_StylesCombined.cshtml") %}
<link href="/css/TruGreen/normalize.css" rel="stylesheet"/> <link href="/css/TruGreen/jquery-ui....
ron.cundiff DocumentBase.Load 0.000
 
14 {% RenderView("~/Views/TruGreen/Shared/_ScriptsCombined.cshtml") %}
<script src="/js/TruGreen/jquery.js"></script> <script src="/js/TruGreen/jquery-ui-1.10.1.custom...
ron.cundiff 0.001
 
15 {% if(CurrentDocument.DocumentName == "Homepage") { @"<meta name=""google-site-verification"" content=""xroegriqTZDld_HsGJXi42RWPgAN9qWGJAtJA2PXd_w"" />" %} null administrator 0.000
 
> CurrentDocument.DocumentName Sitemap 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.000
 
16 {% if (CurrentDocument.BodyIdValue.Length > 0) { CurrentDocument.BodyIdValue; } else { CurrentDocument.DocumentName; } %} Sitemap ron.cundiff 0.002
 
> if (CurrentDocument.BodyIdValue.Length > 0) { ... } else { ... } Sitemap 0.001
 
> CurrentDocument.BodyIdValue.Length null 0.000
 
>> CurrentDocument.BodyIdValue null 0.000
 
>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.000
 
> CurrentDocument.BodyIdValue.Length null 0.001
 
>> CurrentDocument.BodyIdValue null 0.001
 
>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.001
 
>>>>> CurrentDocument.DocumentName Sitemap 0.001
 
> CurrentDocument.DocumentName Sitemap 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.001
 
17 {% pagetitle_orelse_name %} Sitemap DocumentBase.Load 0.000
 
> pagetitle_orelse_name Sitemap 0.000
 
18 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
19 {% GetSalesNumber() %} 800.464.0171 0.000
 
20 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
21 {% GetSalesNumber() %} 800.464.0171 0.000
 
22 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.001
 
23 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
24 {% CurrentDateTime.Year %} 2019 administrator CMSPagePlaceholder.LoadRegionsContent 0.000
 
> CurrentDateTime.Year 2019 0.000
 
>> CurrentDateTime 3/19/2019 4:44:45 AM 0.000
 
25 {% CurrentDateTime.Year %} 2019 administrator CMSPagePlaceholder.LoadRegionsContent 0.000
 
> CurrentDateTime.Year 2019 0.000
 
>> CurrentDateTime 3/19/2019 4:44:45 AM 0.000
 
26 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
27 {% GetSalesNumber() %} 800.464.0171 0.001
 
28 {% GetSalesNumber() %} 800.464.0171 CMSPagePlaceholder.LoadRegionsContent 0.000
 
29 {% GetSalesNumber() %} 800.464.0171 0.000
 
30 {% GetServiceNumber() %} 800.458.4186 CMSPagePlaceholder.LoadRegionsContent 0.000
 
31 {% GetServiceNumber() %} 800.458.4186 0.000
 
32 {% GetServiceNumber() %} 800.458.4186 CMSPagePlaceholder.LoadRegionsContent 0.001
 
33 {% GetServiceNumber() %} 800.458.4186 0.000
 
34 {% htmlSitemapProducts("tree") %}
<li style="margin-left: 20px; "><a href='/products-and-services/horticultural-oil' style="color:#...
CMSPagePlaceholder.LoadRegionsContent 0.011
 
35 {% htmlSitemapProducts("other") %}
<li style="margin-left: 20px; "><a href='/products-and-services/home-pest-control' style="color:#...
0.008
 
36 {% htmlSitemapProducts("tree") %}
<li style="margin-left: 20px; "><a href='/products-and-services/horticultural-oil' style="color:#...
CMSPagePlaceholder.LoadRegionsContent 0.007
 
37 {% htmlSitemapProducts("other") %}
<li style="margin-left: 20px; "><a href='/products-and-services/home-pest-control' style="color:#...
0.008
 
38 {% htmlSitemapProducts("tree") %}
<li style="margin-left: 20px; "><a href='/products-and-services/horticultural-oil' style="color:#...
CMSPagePlaceholder.LoadRegionsContent 0.007
 
39 {% htmlSitemapProducts("other") %}
<li style="margin-left: 20px; "><a href='/products-and-services/home-pest-control' style="color:#...
0.008
 
40 {% htmlSitemapProducts("tree") %}
<li style="margin-left: 20px; "><a href='/products-and-services/horticultural-oil' style="color:#...
CMSPagePlaceholder.LoadRegionsContent 0.006
 
41 {% htmlSitemapProducts("other") %}
<li style="margin-left: 20px; "><a href='/products-and-services/home-pest-control' style="color:#...
0.008
 
42 CurrentPath /sitemap BasicRepeater.OnLoad 0.001
 
43 CurrentPath /sitemap BasicRepeater.OnLoad 0.000
 
44 CurrentPath /sitemap BasicRepeater.OnLoad 0.000
 
45 {% TGCHeadline %} <span>TruGreen.com </span> sitemap TextTransformationTemplate.ltl_DataBinding 0.000
 
> TGCHeadline <span>TruGreen.com </span> sitemap 0.000
 
46 CurrentPath /sitemap BasicRepeater.OnLoad 0.000
 
47 CurrentPath /sitemap 0.000
 
48 CurrentPath /sitemap 0.000
 
49 {% if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } %} //gateway.answerscloud.com/trugreen/staging/gateway.min.js administrator CMSWebParts_General_javascript.OnPreRender 0.001
 
> if (Contains(CurrentDocument.AbsoluteURL, "http://www.trugreen.com")) { ... } else { ... } //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
> CurrentDocument.AbsoluteURL http://devkcms.trugreen.vanickurl.com/sitemap 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.001
 
>>>>> forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js" //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
50 {% "'" + forseeScriptName + "'" %} '//gateway.answerscloud.com/trugreen/staging/gateway.min.js' 0.000
 
> forseeScriptName //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
51 {% if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } %} //gateway.answerscloud.com/trugreen/staging/gateway.min.js administrator 0.000
 
> if (Contains(CurrentDocument.AbsoluteURL, "http://www.trugreen.com")) { ... } else { ... } //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
> CurrentDocument.AbsoluteURL http://devkcms.trugreen.vanickurl.com/sitemap 0.000
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.000
 
>>>>> forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js" //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
52 {% "'" + forseeScriptName + "'" %} '//gateway.answerscloud.com/trugreen/staging/gateway.min.js' 0.000
 
> forseeScriptName //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
53 {% if (CurrentDocument.AbsoluteURL.Contains("http://www.trugreen.com")) { forseeScriptName = "//gateway.answerscloud.com/trugreen/production/gateway.min.js"; } else { forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js"; } %} //gateway.answerscloud.com/trugreen/staging/gateway.min.js administrator 0.001
 
> if (Contains(CurrentDocument.AbsoluteURL, "http://www.trugreen.com")) { ... } else { ... } //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
> CurrentDocument.AbsoluteURL http://devkcms.trugreen.vanickurl.com/sitemap 0.001
 
>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.001
 
>>>>> forseeScriptName = "//gateway.answerscloud.com/trugreen/staging/gateway.min.js" //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.001
 
54 {% "'" + forseeScriptName + "'" %} '//gateway.answerscloud.com/trugreen/staging/gateway.min.js' 0.000
 
> forseeScriptName //gateway.answerscloud.com/trugreen/staging/gateway.min.js 0.000
 
55 {% IsBranchFranchise() %} false 0.001
 
56 {% IsServiceable() %} false 0.000
 
57 {% CustomerHasAddress() %} false 0.000
 
58 {% GetUserZipCode() %} 0.000
 
59 {% GetUserZipOrigin() %} 0 0.000
 
60 N/A
> GetTotalCartItems()
Error while evaluating expression: GetTotalCartItems() CMS.MacroEngine.EvaluationException: Ex...
0.000
 
> {% IsBranchFranchise() %} false 0.000
 
> {% IsServiceable() %} false 0.000
 
> {% CustomerHasAddress() %} false 0.000
 
> {% GetUserZipCode() %} 0.001
 
> {% GetUserZipOrigin() %} 0 0.000
 
61 N/A
>> GetTotalCartItems()
Error while evaluating expression: GetTotalCartItems() CMS.MacroEngine.EvaluationException: Ex...
0.000
 
>> {% IsBranchFranchise() %} false 0.001
 
>> {% IsServiceable() %} false 0.000
 
>> {% CustomerHasAddress() %} false 0.000
 
>> {% GetUserZipCode() %} 0.000
 
>> {% GetUserZipOrigin() %} 0 0.000
 
62 N/A
>>> GetTotalCartItems()
Error while evaluating expression: GetTotalCartItems() CMS.MacroEngine.EvaluationException: Ex...
0.000
 
>>> {% CurrentDocument.DocumentName %} Sitemap administrator 0.001
 
>>>> CurrentDocument.DocumentName Sitemap 0.001
 
>>>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.001
 
>>> {% QueryString["q"] %} null administrator 0.000
 
>>>> QueryString aliaspath=%2fsitemap 0.000
 
>>> {% getgaValue("imp_ids",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("imp_names",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_lists",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_brands",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_categories",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_variants",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_positions",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_prices",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("product_ids",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_names",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_categories",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_variants",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_prices",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_quantities",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_positions",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("action_type",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_id",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("action_revenue",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_tax",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_coupon",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_step",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_id",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_cust_id",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_city",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("order_country",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_state",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_price",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";} %} "" administrator 0.001
 
>>>> if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { ... } else { ... } "" 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>>>>>>> return "\"\"" "" 0.001
 
>>>> return "\"\"" "" 0.000
 
>>> {% GetApplicationSetting("tealium_env") %} dev 0.000
 
>>> {% CurrentDocument.DocumentName %} Sitemap administrator 0.001
 
>>>> CurrentDocument.DocumentName Sitemap 0.001
 
>>>>> CurrentDocument CMS.DocumentEngine.TreeNode (cms.document.cms.menuitem) - Sitemap 0.001
 
>>> {% QueryString["q"] %} null administrator 0.000
 
>>>> QueryString aliaspath=%2fsitemap 0.000
 
>>> {% getgaValue("imp_ids",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("imp_names",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_lists",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_brands",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_categories",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_variants",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_positions",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("imp_prices",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("product_ids",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_names",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_categories",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_variants",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_prices",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_quantities",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("product_positions",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_type",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_id",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_revenue",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_tax",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("action_coupon",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("action_step",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.001
 
>>> {% getgaValue("order_id",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_cust_id",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_city",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_country",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_state",NodeAliasPath) %} 0.001
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% getgaValue("order_price",NodeAliasPath) %} 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>> {% if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { return "\"Address not found\"";} else {return "\"\"";} %} "" administrator 0.001
 
>>>> if (NodeAliasPath.Contains("/get-a-quote/custom-services")) { ... } else { ... } "" 0.000
 
>>>> NodeAliasPath /sitemap 0.000
 
>>>>>>>> return "\"\"" "" 0.000
 
>>>> return "\"\"" "" 0.000
 
>>> {% GetApplicationSetting("tealium_env") %} dev 0.001
 
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/sitemap" (8 B)
8 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 PrimaryNav
ViewRenderer
ViewResult
Yes
Text = "
<nav id="primaryNav">
<ul>
<li style='text-align:-webkit-right'><a href="/"><section class='home-icon-menu'></section></a></li>
<li data-hover="plans"><a href="/products-and-services" >Plans & Services</a></li>
<li data-hover="whytrugreen"><a href="/why-choose-trugreen" >Why TruGreen</a></li>
<li data-hover="trupurpose"><a href="/trupurpose" >TruPurpose</a></li>
<li data-hover="learningcenter"><a href="/learning-center" >Learning Cen..." (16 kB)
16 kB
 
4 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
5 TGA
TGARepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
6 TGC
TGCRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "CMS.MenuItem.TGRES-TGC-Default-with-no-Subhead" (46 B)
HideControlForZeroRows = True
59 B
 
7 TGD
TGDRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
8 TGF
TGFRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
9 TGG
TGGRepeater
repItems
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
DataSourceName = "" (0 B)
EnablePaging = False
NestedControlsID = "" (0 B)
ShowDeleteButton = False
AlternatingTransformationName = "" (0 B)
ShowEditButton = False
_!ItemCount = 1
TransformationName = "" (0 B)
HideControlForZeroRows = True
13 B
 
10 GetACallBack
GetACallBackView
ViewResult
Yes
Text = "



<section class="header">
How can we help?
</section>

<section class="tab">
<span class="heading" style="margin-right: -4px; background-position: 85%;" name="NewServices"><a href="#">Buy By Phone</a></span>
<span class="heading selected" style="border-left: 1px solid #BFC0C0; " name="CurrentServices"><a href="#">Get Service Help</a></span>

<section class="tabcontent" id="NewServices">
<table class="choice new">
<tr>
..." (5.5 kB)
5.5 kB
 
11 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes