Testimonials And Reviews

We take pride in delivering superior results to our customers. Read what satisfied TruGreen lawn owners have to say.

customer reviews

  •  
    A Real Difference!

    by Brent H.

    "Since we started using Trugreen a couple of years ago I have seen a real difference in the appearance of our yard, greener thicker grass and very few weeds. After wasting alot of time and money trying to do my own lawn maintenance I believe that Trugreen is a very good value to our investment in our home. And we have recommended you to friend and neighbors. Thank You"

     
  •  
    Before and After

    by Darci F.

    "I wish I could upload a before and after photo!! My front lawn went from straw & weeds to the nicest lawn on the street!! Thank you Trugreen!!"

     
  •  
    Service with Pride

    by Carol H.

    "The tech was so interested in the care of my yard. He has seen it prosper and was so proud of it. He had suggestions for the future care of my yard. There was a lot of pride in his service."

     
  •  
    Thank you for the wonderful service

    by Patrick F.

    "For three years, I have pulled weeds, and bought products from the store. I was pseudo-consistent, and the problem would come back (typically worse) in the areas I had removed weeds. I am only a few applications into my TruGreen service, and I am definitely noticing a difference, and seeing some patchy spots where the weeds were overtaking everything before. I definitely prefer seeding and sodding to pulling weeds up any day of the week, and now I have more time for other more enjoyable landscape maintenance. Thank you for the wonderful service, and I look forward to seeing my lawn by the end of the summer and every summer after."

     
  •   < 1 2 3 4 5 6 7 8 9 10  > 
Shop Now

lawn care

Explore lawn plans and learn about our tailored approach.

Learn More

tree and shrub care

Browse plans and services tailored for your landscape.

Learn More

other services

View additional services for your lawn, landscape and beyond.

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 >> TypeInfo(cms.pagetemplate).Events.GetData SimpleHandler`2.StartEvent
10 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
11 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
12 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
13 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
14 >> TypeInfo(cms.settingskey).Events.GetData SimpleHandler`2.StartEvent
15 >> URLRewritingEvents.ProcessABTest.Execute SimpleHandler`2.StartEvent
>>> ABHandlers.ProcessABTest
16 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
>>> URLRewritingEvents.ProcessRewritingResult.Before
>>>> CustomApplicationEventsAttribute.ProcessRewritingResult_Before
17 >>>>> DocumentEvents.GetData SimpleHandler`2.StartEvent
18 >>>>>> TypeInfo(cms.document.tg.urlredirect).Events.GetData SimpleHandler`2.StartEvent
19 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> CsrfProtection.OnPostMapRequestHandlerExecute
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
20 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
21 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
22 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> CustomApplicationEventsAttribute.SessionStart_Execute
23 >> DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
24 >>> TypeInfo(cms.document.tg.product).Events.GetData ObjectQueryBase`2.GetEnumerator
25 >>>> TypeInfo(cms.versionhistory).Events.GetData ObjectQueryBase`2.GetEnumerator
26 >> DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
27 >>> TypeInfo(cms.document.tg.servicetype).Events.GetData ObjectQueryBase`2.GetEnumerator
28 RequestEvents.AcquireRequestState.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
29 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
30 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
31 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
32 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
33 TypeInfo(cms.document).Events.GetData PageContext.CurrentPage_InitComplete
34 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
35 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
36 TypeInfo(cms.resourcestring).Events.GetData CMSWebParts_Text_editabletext.OnInit
37 TypeInfo(cms.settingskey).Events.GetData PageContext.CurrentPage_InitComplete
38 TypeInfo(cms.class).Events.GetData TextLayout.CreateChildControls
39 DocumentEvents.GetData TextLayout.CreateChildControls
40 TypeInfo(cms.document.cms.menuitem).Events.GetData TextLayout.CreateChildControls
41 >> TypeInfo(cms.query).Events.GetData TextLayout.CreateChildControls
42 TypeInfo(cms.class).Events.GetData TextLayout.CreateChildControls
43 TypeInfo(cms.class).Events.GetData TextLayout.CreateChildControls
44 TypeInfo(cms.inlinecontrol).Events.GetData TextLayout.CreateChildControls
45 TypeInfo(cms.class).Events.GetData TextLayout.CreateChildControls
46 TypeInfo(cms.class).Events.GetData TextLayout.CreateChildControls
47 TypeInfo(cms.query).Events.GetData TextLayout.CreateChildControls
48 TypeInfo(cms.query).Events.GetData TextLayout.CreateChildControls
49 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
50 TypeInfo(cms.resourcestring).Events.GetData PageContext.CurrentPage_InitComplete
51 TypeInfo(cms.resourcestring).Events.GetData
52 TypeInfo(cms.resourcestring).Events.GetData
53 TypeInfo(cms.resourcestring).Events.GetData
54 TypeInfo(cms.resourcestring).Events.GetData
55 TypeInfo(cms.resourcestring).Events.GetData
56 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
57 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
58 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
59 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
60 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
61 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
62 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
63 TypeInfo(cms.document.tg.megamenuproductcategory).Events.GetData ObjectQueryBase`2.GetEnumerator
64 DocumentEvents.GetData ObjectQueryBase`2.GetEnumerator
65 TypeInfo(cms.document.tg.megamenuitem).Events.GetData ObjectQueryBase`2.GetEnumerator
66 >> TypeInfo(cms.versionhistory).Events.GetData ObjectQueryBase`2.GetEnumerator
67 DocumentEvents.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
68 TypeInfo(cms.document.tg.infographic).Events.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
69 >> TypeInfo(cms.versionhistory).Events.GetData _Page_Views_TruGreen_Megamenu_cshtml.Execute
70 DocumentEvents.GetData CMSAbstractMenuProperties.OnLoad
71 TypeInfo(cms.document).Events.GetData CMSAbstractMenuProperties.OnLoad
72 TypeInfo(cms.relationshipname).Events.GetData BasicRepeater.OnLoad
73 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
74 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
75 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
76 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
77 DocumentEvents.GetData BasicRepeater.OnLoad
78 TypeInfo(cms.document.cms.menuitem).Events.GetData BasicRepeater.OnLoad
79 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
80 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
81 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
82 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
83 TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
84 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
85 TypeInfo(cms.class).Events.GetData
86 TypeInfo(cms.class).Events.GetData
87 TypeInfo(cms.class).Events.GetData
88 TypeInfo(cms.class).Events.GetData
89 TypeInfo(cms.class).Events.GetData
90 TypeInfo(cms.class).Events.GetData
91 TypeInfo(cms.class).Events.GetData
92 TypeInfo(cms.class).Events.GetData
93 TypeInfo(cms.class).Events.GetData
94 TypeInfo(cms.class).Events.GetData
95 TypeInfo(cms.class).Events.GetData
96 TypeInfo(cms.class).Events.GetData
97 TypeInfo(cms.class).Events.GetData
98 TypeInfo(cms.class).Events.GetData
99 TypeInfo(cms.class).Events.GetData
100 TypeInfo(cms.class).Events.GetData
101 TypeInfo(cms.class).Events.GetData
102 TypeInfo(cms.class).Events.GetData
103 TypeInfo(cms.class).Events.GetData
104 TypeInfo(cms.class).Events.GetData
105 TypeInfo(cms.class).Events.GetData
106 TypeInfo(cms.class).Events.GetData
107 TypeInfo(cms.class).Events.GetData
108 TypeInfo(cms.class).Events.GetData
109 TypeInfo(cms.class).Events.GetData
110 TypeInfo(cms.class).Events.GetData
111 TypeInfo(cms.class).Events.GetData
112 TypeInfo(cms.class).Events.GetData
113 TypeInfo(cms.class).Events.GetData
114 TypeInfo(cms.class).Events.GetData
115 TypeInfo(cms.class).Events.GetData
116 TypeInfo(cms.class).Events.GetData
117 TypeInfo(cms.class).Events.GetData
118 TypeInfo(cms.class).Events.GetData
119 TypeInfo(cms.class).Events.GetData
120 TypeInfo(cms.class).Events.GetData
121 TypeInfo(cms.class).Events.GetData
122 TypeInfo(cms.class).Events.GetData
123 TypeInfo(cms.class).Events.GetData
124 TypeInfo(cms.class).Events.GetData
125 TypeInfo(cms.class).Events.GetData
126 TypeInfo(cms.class).Events.GetData
127 TypeInfo(cms.class).Events.GetData
128 TypeInfo(cms.class).Events.GetData
129 TypeInfo(cms.class).Events.GetData
130 TypeInfo(cms.class).Events.GetData
131 TypeInfo(cms.class).Events.GetData
132 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
133 TypeInfo(cms.class).Events.GetData BasicRepeater.OnLoad
134 DocumentEvents.GetData BasicRepeater.OnLoad
135 TypeInfo(cms.document.tg.testimonial).Events.GetData BasicRepeater.OnLoad
136 >> TypeInfo(cms.query).Events.GetData BasicRepeater.OnLoad
137 TypeInfo(cms.transformation).Events.GetData BasicRepeater.OnLoad
138 TypeInfo(cms.transformation).Events.GetData
139 TypeInfo(cms.transformation).Events.GetData
140 TypeInfo(cms.transformation).Events.GetData
141 TypeInfo(cms.settingskey).Events.GetData CMSPages_PortalTemplate.OnPreRender
142 TypeInfo(cms.settingskey).Events.GetData CMSPages_PortalTemplate.OnPreRender
143 TypeInfo(cms.settingskey).Events.GetData CMSPages_PortalTemplate.OnPreRender
144 TypeInfo(cms.settingskey).Events.GetData WebPartActionManager.OnPreRender
145 TypeInfo(cms.settingskey).Events.GetData
146 TypeInfo(cms.resourcestring).Events.GetData EvaluationException.get_Message
147 TypeInfo(cms.resourcestring).Events.GetData CMSAdminControls_Debug_HandlersLog.OnPreRender
148 TypeInfo(cms.resourcestring).Events.GetData
149 TypeInfo(cms.resourcestring).Events.GetData
150 TypeInfo(cms.resourcestring).Events.GetData CMSAdminControls_Debug_HandlersLog.OnPreRender
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/favicon.ico Local CMSPages_PortalTemplate.OnPreRender
2 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
3 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
4 DIREXISTS
~/CMSResources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
5 EXISTS
~/CMSResources/First.resx Local CMSAdminControls_Debug_HandlersLog.OnPreRender
6 EXISTS
~/CMSResources/Fast.resx Local
7 EXISTS
~/CMSResources/CMS_Install.resx Local
8 EXISTS
~/CMSResources/CMS.resx Local
9 EXISTS
~/CMSResources/Custom.resx Local
10 EXISTS
~/CMSResources/Hotfix.resx Local
11 EXISTS
~/CMSResources/Last.resx Local
12 GETDIRECTORIES
~/CMSResources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
13 GETDIRECTORIES
~/CMSResources
0
Local CMSAdminControls_Debug_HandlersLog.OnPreRender
14 DIREXISTS
~/App_Data Local CMSAdminControls_Debug_HandlersLog.OnPreRender
15 GETDIRECTORIES
~/App_Data Local CMSAdminControls_Debug_HandlersLog.OnPreRender
16 GETDIRECTORIES
~/App_Data
10
Local CMSAdminControls_Debug_HandlersLog.OnPreRender
17 DIREXISTS
~/App_Data/Backup/Resources Local CMSAdminControls_Debug_HandlersLog.OnPreRender
18 DIREXISTS
~/App_Data/CMSModules/Resources Local
19 DIREXISTS
~/App_Data/CMSTemp/Resources Local
20 DIREXISTS
~/App_Data/CodeTemplates/Resources Local
21 DIREXISTS
~/App_Data/DBSeparation/Resources Local
22 DIREXISTS
~/App_Data/Dictionaries/Resources Local
23 DIREXISTS
~/App_Data/Install/Resources Local
24 DIREXISTS
~/App_Data/Persistent/Resources Local
25 DIREXISTS
~/App_Data/Templates/Resources Local
26 DIREXISTS
~/App_Data/UI/Resources Local
27 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
28 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 if (CurrentDocument.TemplateSectionIdValue.Length > 0) { CurrentDocument.TemplateSectionIdValue; } else { CurrentDocument.DocumentName; } administrator TextLayout.CreateChildControls
8 ValidateHash True if (CurrentDocument.NodeAliasPath.Contains("why-choose-trugreen")) {return true;} else {return false;} administrator CMSAbstractWebPart.OnInit
9 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.DocumentName.Contains("Select A Plan")) {return true;} else {return false;} administrator
10 ValidateHash True if (NodeAliasPath.Contains("Testimonials")) {return true;} else {return false;} administrator CMSAbstractWebPart.OnInit
11 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.DocumentName.Contains("Select A Plan")) {return true;} else {return false;} administrator CMSAbstractWebPart.OnInit
12 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.DocumentName.Contains("Select A Plan")) {return true;} else {return false;} administrator
13 ValidateHash True if (CurrentDocument.NodeAliasPath.Contains("get-a-quote")) {return true;} else {return false;} administrator
14 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.DocumentName.Contains("Select A Plan")) {return true;} else {return false;} administrator
15 This same security check is called more than once within the request. ValidateHash True if (CurrentDocument.DocumentName.Contains("Select A Plan")) {return true;} else {return false;} administrator
16 ValidateHash True RenderView("~/Views/TruGreen/Shared/_StylesCombined.cshtml")ron.cundiff DocumentBase.Load
17 ValidateHash True RenderView("~/Views/TruGreen/Shared/_ScriptsCombined.cshtml")ron.cundiff
18 ValidateHash True if(CurrentDocument.DocumentName == "Homepage") { @"<meta name=""google-site-verification"" content=""xroegriqTZDld_HsGJXi42RWPgAN9qWGJAtJA2PXd_w"" />" administrator
19 ValidateHash True if (CurrentDocument.BodyIdValue.Length > 0) { CurrentDocument.BodyIdValue; } else { CurrentDocument.DocumentName; } ron.cundiff
20 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator CMSPagePlaceholder.LoadRegionsContent
21 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Yearadministrator CMSPagePlaceholder.LoadRegionsContent
22 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
23 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
24 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
25 This same security check is called more than once within the request. ValidateHash True CurrentDocument.DocumentNameadministrator
26 This same security check is called more than once within the request. ValidateHash True QueryString["q"]administrator
27 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
28 This same security check is called more than once within the request. ValidateHash True CurrentDocument.DocumentNameadministrator
29 This same security check is called more than once within the request. ValidateHash True QueryString["q"]administrator
30 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|/why-choose-trugreen/testimonials-and-ratings|en-us|/why-choose-trugreen/testimonials-and-ratings|true
template|24154
nodeid|2551
pageinfo
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|trugreen|http://devkcms.trugreen.vanickurl.com/why-choose-trugreen/testimonials-and-ratings|en-us||true|true
template|24154
nodeid|2551
pageinfo
SimpleHandler`2.StartEvent
3 ADD pageinfo|trugreen|/why-choose-trugreen|en-us||false
template|24150
nodeid|2536
pageinfo
PageContext.CurrentPage_InitComplete
4 GET pageinfo|trugreen|/|en-us||false PageContext.CurrentPage_InitComplete
5 ADD currentdocument|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us
nodes|trugreen|cms.menuitem|all
node|trugreen|/why-choose-trugreen/testimonials-and-ratings
TextLayout.CreateChildControls
6 ADD breadcrumbs|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|||true|
webpartinstance|3d182886-848d-4862-bfdb-33c11d460e8a
node|trugreen|/why-choose-trugreen/testimonials-and-ratings|childnodes
CMSAbstractMenuProperties.OnLoad
7 ADD cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|e70d9339-47d2-41dd-b91c-8e04d388d216
nodes|trugreen|cms.menuitem|all
node|trugreen|/why-choose-trugreen/testimonials-and-ratings
BasicRepeater.OnLoad
8 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| BasicRepeater.OnLoad
9 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
10 ADD cmsdatasource||en-us|trugreen|/[_]content/testimonial/%|en-us|false|tg.testimonial||date desc|1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
webpartinstance|958d4bb7-7617-433b-9570-6df2dd54f8e7
nodes|trugreen|tg.testimonial|all
node|trugreen|/[_]content/testimonial|childnodes
BasicRepeater.OnLoad
11 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false|| BasicRepeater.OnLoad
12 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
13 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
14 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
15 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
16 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
17 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
18 GET cmsdatasource||en-us|trugreen|/why-choose-trugreen/testimonials-and-ratings|en-us|false|cms.menuitem|||-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|0||false||
19 ADD scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /why-choose-trugreen/testimonials-and-ratings 0.000
0.054
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.054
21.328
 
3 > OnPreInit 21.382
0.000
 
4 > OnInit 21.382
1.014
 
5 > OnLoad 22.396
2.278
 
6 > OnPreRender 24.675
N/A
    24.675  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookieGDQd7AAmiCUhuL7mIh+qxGYTgJ1ON2mUxJNN2H1A
3 ASP.NET_SessionIdvyltaztjj4vjetndtqmmlmpb
4 persistlastVisit=3/19/2019 4:41:24 AM&cookieId=c6f4d31e-af6c-4038-aea4-3f8390cb5d04
5 __RequestVerificationTokenB1qmISakGiaTC-ci2iLVtcyklDx8s8QGZ2DLqs3d3sfynFZhoI5IQ8PDK3N5eomJuiA_HOgbLbb0BAXS8qup1b9Ge_Ainf_KBqrFYdD-f1I1
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US3/19/2020 4:41:24 AM
2 CMSCsrfCookieGDQd7AAmiCUhuL7mIh+qxGYTgJ1ON2mUxJNN2H1A 
3 ASP.NET_SessionIdvyltaztjj4vjetndtqmmlmpb 
4 persistlastVisit=3/19/2019 4:41:24 AM&cookieId=c6f4d31e-af6c-4038-aea4-3f8390cb5d044/18/2019 4:41:24 AM
5 __RequestVerificationTokenB1qmISakGiaTC-ci2iLVtcyklDx8s8QGZ2DLqs3d3sfynFZhoI5IQ8PDK3N5eomJuiA_HOgbLbb0BAXS8qup1b9Ge_Ainf_KBqrFYdD-f1I1 
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress54.243.17.113
5 UserName 
6 SessionIDvyltaztjj4vjetndtqmmlmpb
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'/why-choose-trugreen/testimonials-and-ratings';
DECLARE @NodeAliasPath nvarchar(max) = N'/why-choose-trugreen/testimonials-and-ratings';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @Now datetime2 = '3/19/2019 4:41: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'/why-choose-trugreen/testimonials-and-ratings' 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.7 kB
 
Table (1 [64], 661 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 IN (N'/why-choose-trugreen', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 3 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 = 24154;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 79 kB)
 
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
4
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 24150;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
Table (1 [34], 117 kB)
 
SimpleHandler`2.StartEvent 0.003
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
5
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSFilesFriendlyURLExtension';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
6
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSDefaulPage';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
7
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectAliasesToMainURL';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
8
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectInvalidCasePages';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.001
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
9
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectToMainExtension';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
10
(tg.urlredirect.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @IsActive bit = 1;
DECLARE @Request nvarchar(max) = N'/why-choose-trugreen/testimonials-and-ratings';
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
583 B
 
SimpleHandler`2.StartEvent 0.002
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
11
(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.010
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
12
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 1448
Table (1 [23], 7.3 kB)
 
ObjectQueryBase`2.GetEnumerator 0.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
13
(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.003
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
14
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 2536;
DECLARE @Now datetime2 = '3/19/2019 4:41:46 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 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 ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID) 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.3 kB
 
Table (1 [64], 594 B)
 
PageContext.CurrentPage_InitComplete 0.002
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
15
(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)
 
PageContext.CurrentPage_InitComplete 0.002
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
16
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 1
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
CMSWebParts_Text_editabletext.OnInit N/A
17
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.richtexteditor';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSWebParts_Text_editabletext.OnInit 0.001
 
CloseConnection()
CMSWebParts_Text_editabletext.OnInit N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
18
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSCacheMinutes';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
TextLayout.CreateChildControls N/A
19
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'cms.menuitem';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 58 kB)
 
TextLayout.CreateChildControls 0.026
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
20

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CONTENT_MenuItem');
Table (1 [1], 10 B)
 
TextLayout.CreateChildControls 0.001
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
21
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4608)
TextLayout.CreateChildControls 0.002
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
22
(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 = 2551) AND [DocumentCulture] = @DocumentCulture
Table (1 [353], 2.8 kB)
 
TextLayout.CreateChildControls 0.003
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
23
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Relationship';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 1.5 kB)
 
TextLayout.CreateChildControls 0.001
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
24
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Relationship';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 3.5 kB)
 
TextLayout.CreateChildControls 0.001
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
25

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Relationship');
Table (1 [1], 14 B)
 
TextLayout.CreateChildControls 0.002
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
26
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.InlineControl';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 3 kB)
 
TextLayout.CreateChildControls 0.061
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
27
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.InlineControl';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 9.2 kB)
 
TextLayout.CreateChildControls 0.001
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
28
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 877)
TextLayout.CreateChildControls 0.001
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
29
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 877)
TextLayout.CreateChildControls 0.001
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
TextLayout.CreateChildControls N/A
30
(cms.inlinecontrol.generalselect)
DECLARE @ControlName nvarchar(max) = N'WebPartZone';

SELECT *
FROM CMS_InlineControl
WHERE [ControlName] = @ControlName
Table (1 [11], 171 B)
 
TextLayout.CreateChildControls 0.001
 
CloseConnection()
TextLayout.CreateChildControls N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
31
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 2539
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
32
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.ResultText';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.002
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
33
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.LabelText';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
34
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Back';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
35
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Next';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
36
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.First';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
N/A
37
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'DataPager.Last';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
PageContext.CurrentPage_InitComplete 0.001
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
38 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
39 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
40 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
41 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
42
(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.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
ObjectQueryBase`2.GetEnumerator N/A
43
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 2966
Table (1 [23], 2.7 kB)
 
ObjectQueryBase`2.GetEnumerator 0.001
 
CloseConnection()
ObjectQueryBase`2.GetEnumerator N/A
OpenConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
44
(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.001
 
CloseConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
OpenConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
45
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 333
Table (1 [23], 3.9 kB)
 
_Page_Views_TruGreen_Megamenu_cshtml.Execute 0.001
 
CloseConnection()
_Page_Views_TruGreen_Megamenu_cshtml.Execute N/A
OpenConnection()
CMSAbstractMenuProperties.OnLoad N/A
46
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '3/19/2019 4:41:49 AM';
DECLARE @NodeLevel int = 2;
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'/why-choose-trugreen/testimonials-and-ratings', N'/why-choose-trugreen', 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.5 kB
 
Table (3 [36], 582 B)
 
CMSAbstractMenuProperties.OnLoad 0.002
 
CloseConnection()
CMSAbstractMenuProperties.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
47
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.RelationshipName';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2.1 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
48
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.RelationshipName';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 6.3 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
49
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 530)
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
50
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 530)
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
51
(cms.relationshipname.generalselect)
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';

SELECT *
FROM CMS_RelationshipName
WHERE [RelationshipName] = @RelationshipName
Table (1 [7], 91 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
52
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '3/19/2019 4:41:49 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/why-choose-trugreen/testimonials-and-ratings';
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)
764 B
 
Table (1 [353], 2.8 kB)
 
BasicRepeater.OnLoad 0.003
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
53
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Transformation';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 3.4 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
54
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Transformation';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [55], 8.6 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
55
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 162)
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
56
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 162)
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
57
(cms.transformation.generalselect)
SELECT *
FROM CMS_Transformation
Table (1156 [12], 526 kB)
 
BasicRepeater.OnLoad 0.011
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
58
(cms.class.generalselect)
DECLARE @ClassID int = 1685;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 4 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
59
(cms.class.generalselect)
DECLARE @ClassID int = 3140;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 272 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
60
(cms.class.generalselect)
DECLARE @ClassID int = 4602;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 354 B)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
61
(cms.class.generalselect)
DECLARE @ClassID int = 4603;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 329 B)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
62
(cms.class.generalselect)
DECLARE @ClassID int = 4604;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 334 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
63
(cms.class.generalselect)
DECLARE @ClassID int = 4605;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 7.9 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
64
(cms.class.generalselect)
DECLARE @ClassID int = 4606;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 4.6 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
65
(cms.class.generalselect)
DECLARE @ClassID int = 4607;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.4 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
66
(cms.class.generalselect)
DECLARE @ClassID int = 4609;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 321 B)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
67
(cms.class.generalselect)
DECLARE @ClassID int = 4610;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 317 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
68
(cms.class.generalselect)
DECLARE @ClassID int = 4612;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 272 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
69
(cms.class.generalselect)
DECLARE @ClassID int = 4613;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.5 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
70
(cms.class.generalselect)
DECLARE @ClassID int = 4614;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 16 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
71
(cms.class.generalselect)
DECLARE @ClassID int = 4615;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10.7 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
72
(cms.class.generalselect)
DECLARE @ClassID int = 4616;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 3.6 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
73
(cms.class.generalselect)
DECLARE @ClassID int = 4617;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.4 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
74
(cms.class.generalselect)
DECLARE @ClassID int = 4618;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 6 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
75
(cms.class.generalselect)
DECLARE @ClassID int = 4619;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 3 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
76
(cms.class.generalselect)
DECLARE @ClassID int = 4620;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 14.1 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
77
(cms.class.generalselect)
DECLARE @ClassID int = 4621;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 3.3 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
78
(cms.class.generalselect)
DECLARE @ClassID int = 4622;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 2.4 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
79
(cms.class.generalselect)
DECLARE @ClassID int = 4623;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 328 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
80
(cms.class.generalselect)
DECLARE @ClassID int = 4624;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10.1 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
81
(cms.class.generalselect)
DECLARE @ClassID int = 4625;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 295 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
82
(cms.class.generalselect)
DECLARE @ClassID int = 4627;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 12.2 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
83
(cms.class.generalselect)
DECLARE @ClassID int = 4631;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 8 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
84
(cms.class.generalselect)
DECLARE @ClassID int = 4632;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.5 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
85
(cms.class.generalselect)
DECLARE @ClassID int = 4633;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 9.7 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
86
(cms.class.generalselect)
DECLARE @ClassID int = 4635;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10.8 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
87
(cms.class.generalselect)
DECLARE @ClassID int = 4637;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 3.3 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
88
(cms.class.generalselect)
DECLARE @ClassID int = 4639;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 22 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
89
(cms.class.generalselect)
DECLARE @ClassID int = 4640;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.2 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
90
(cms.class.generalselect)
DECLARE @ClassID int = 4641;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 8 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
91
(cms.class.generalselect)
DECLARE @ClassID int = 4642;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 6.9 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
92
(cms.class.generalselect)
DECLARE @ClassID int = 4643;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 14.4 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
93
(cms.class.generalselect)
DECLARE @ClassID int = 4644;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 9.3 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
94
(cms.class.generalselect)
DECLARE @ClassID int = 4645;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 14.6 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
95
(cms.class.generalselect)
DECLARE @ClassID int = 4647;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 10.2 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
96
(cms.class.generalselect)
DECLARE @ClassID int = 4649;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 4.4 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
97
(cms.class.generalselect)
DECLARE @ClassID int = 4650;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 6.4 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
98
(cms.class.generalselect)
DECLARE @ClassID int = 4652;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 3.3 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
99
(cms.class.generalselect)
DECLARE @ClassID int = 4654;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 7.7 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
100
(cms.class.generalselect)
DECLARE @ClassID int = 4655;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.4 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
101
(cms.class.generalselect)
DECLARE @ClassID int = 4656;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 6.3 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
102
(cms.class.generalselect)
DECLARE @ClassID int = 4657;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.4 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
103
(cms.class.generalselect)
DECLARE @ClassID int = 4658;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 9.7 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
104
(cms.class.generalselect)
DECLARE @ClassID int = 4659;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 7.8 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
105
(cms.class.generalselect)
DECLARE @ClassID int = 4679;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 5.9 kB)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
106
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4608 AND [TransformationName] = N'TGRES-TGC-Page-Header-1_en-US')
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
107
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'tg.testimonial';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 2.5 kB)
 
BasicRepeater.OnLoad 0.002
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
108

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('TG_Testimonial');
Table (1 [1], 13 B)
 
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
109
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 4654)
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
110
(tg.testimonial.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '3/19/2019 4:41:49 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/[_]content/Testimonial/%';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN TG_Testimonial AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.TestimonialID AND V.ClassName = N'TG.Testimonial' 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] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY Date DESC
829 B
 
Table (50 [165], 56 kB)
 
BasicRepeater.OnLoad 0.005
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
BasicRepeater.OnLoad N/A
111
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4654 AND [TransformationName] = N'Default_en-US')
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
112
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4608 AND [TransformationName] = N'TGRES-TGH-Default_en-US')
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
113
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4608 AND [TransformationName] = N'TGRES-TGI-Default_en-US')
BasicRepeater.OnLoad 0.001
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
114
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 4608 AND [TransformationName] = N'TGRES-TGJ-Default_en-US')
BasicRepeater.OnLoad 0.000
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
CMSPages_PortalTemplate.OnPreRender N/A
115
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSExcludedFormFilterURLs';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSPages_PortalTemplate.OnPreRender 0.001
 
CloseConnection()
CMSPages_PortalTemplate.OnPreRender N/A
OpenConnection()
CMSPages_PortalTemplate.OnPreRender N/A
116
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSPageDescriptionPrefix';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSPages_PortalTemplate.OnPreRender 0.001
 
CloseConnection()
CMSPages_PortalTemplate.OnPreRender N/A
OpenConnection()
CMSPages_PortalTemplate.OnPreRender N/A
117
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSPageKeyWordsPrefix';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
CMSPages_PortalTemplate.OnPreRender 0.001
 
CloseConnection()
CMSPages_PortalTemplate.OnPreRender N/A
OpenConnection()
WebPartActionManager.OnPreRender N/A
118
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSScreenLockInterval';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
WebPartActionManager.OnPreRender 0.001
 
CloseConnection()
WebPartActionManager.OnPreRender N/A
OpenConnection()
N/A
119
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSScreenLockWarningInterval';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
WebPartActionManager.OnPreRender 0.001
 
CloseConnection()
WebPartActionManager.OnPreRender N/A
OpenConnection()
EvaluationException.get_Message N/A
120
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'macros.evaluationerror';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
EvaluationException.get_Message 0.002
 
CloseConnection()
EvaluationException.get_Message N/A
OpenConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
121
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
N/A
122
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'HandlersLog.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
N/A
123
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Context';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
124
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'HandlersLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_HandlersLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_HandlersLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
125
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
N/A
126
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.FilePath';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
N/A
127
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.OperationType';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
128
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'FilesLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_FilesLog.OnPreRender 0.000
 
CloseConnection()
CMSAdminControls_Debug_FilesLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
129
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.UserName';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
130
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
131
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Result';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.000
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
132
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Resource';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
133
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
N/A
134
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Site';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
135
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_SecurityLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_SecurityLog.OnPreRender N/A
OpenConnection()
cmsadmincontrols_debug_securitylog_ascx.__DataBind__control5 N/A
136
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'SecurityLog.Duplicit';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
cmsadmincontrols_debug_securitylog_ascx.__DataBind__control5 0.001
 
CloseConnection()
cmsadmincontrols_debug_securitylog_ascx.__DataBind__control5 N/A
OpenConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
137
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'CacheLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_CacheLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
OpenConnection()
N/A
138
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'CacheLog.Data';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_CacheLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
139
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'CacheLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_CacheLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_CacheLog.OnPreRender N/A
OpenConnection()
cmsadmincontrols_debug_cachelog_ascx.__DataBind__control11 N/A
140
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.View';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
cmsadmincontrols_debug_cachelog_ascx.__DataBind__control11 0.001
 
CloseConnection()
cmsadmincontrols_debug_cachelog_ascx.__DataBind__control11 N/A
OpenConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
141
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.ResponseCookies';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
142
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.RequestCookies';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
143
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Values';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
144
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Operation';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
145
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Parameter';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
146
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.FromStart';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.000
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
N/A
147
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Duration';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
148
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'RequestLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_RequestLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_RequestLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
149
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General..General.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
150
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Name';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
151
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General..General.Value';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
152
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Value';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
153
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General..General.Expires';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
N/A
154
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'General.Expires';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_ValuesTable.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
155
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryText';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_QueryLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
OpenConnection()
N/A
156
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'QueryLog.QueryDuration';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_QueryLog.OnPreRender 0.001
 
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
OpenConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
157
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'QueryLog.Info';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
CMSAdminControls_Debug_QueryLog.OnPreRender 0.000
 
CloseConnection()
CMSAdminControls_Debug_QueryLog.OnPreRender N/A
  157 queries, 37 kB write, 1.6 MB read   0.303
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% CurrentDateTime.Year %} 2019 administrator PageContext.CurrentPage_InitComplete 0.139
 
> CurrentDateTime.Year 2019 0.066
 
>> CurrentDateTime 3/19/2019 4:41:46 AM 0.058
 
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