+84 9 0679 7888

Colorectal Surgery Center

The Colorectal Surgery Center at Bumrungrad International Hospital offers assessments, diagnoses, and treatments of conditions affecting the colon and rectum. Our team of expert colorectal specialists are trained and experienced in colorectal conditions and diseases, and work alongside other experienced specialists including specialist nurses and radiologists. Our hospital’s expert doctors and staff provide high quality medical services to every patient. 
  • Our services
    Services include assessments, diagnoses, and potentially surgical treatments of conditions of all types affecting the colon and rectum, including:
    • Hemorrhoid surgery through modern methods 
    • Anal abscess and anal fistula surgery without damage to the anal sphincter   
    • Diagnostic colonoscopy
    • Laparoscopic surgery / advanced endoscopic procedure 
    • Robotic-assisted colorectal cancer surgery 
  • Treatment
    Common Conditions We Treat
    • Colorectal cancer 
    • Hemorrhoids 
    • Anal fistulas and anal abscesses 
    • Anal fissures 
    • Rectal prolapse 
    • STDs involving the rectum 
    • Impaired pelvic floor muscle conditions, such as constipation or fecal incontinence 

    The Colorectal Surgery Center at Bumrungrad International Hospital consists of a team of experienced doctors who specialize in conditions of the colon and rectum. Our team is also comprised of the inventors of the technique known as “LIFT technique,” which is a non-invasive surgical technique for the treatment of fistula-in-ano. The technique is currently the most widely used technique of its kind worldwide. Each year, many people from around the world visit Bumrungrad for successful treatment due to the LIFT technique. 
  • Faclities and equipment
    Modern, state-of-the-art equipment utilized at the center:
    • High-definition colonoscopy with magnifying narrow band imaging
    • MR defecography  
    • High-resolution anorectal manometry   
    • Colonic transit time   

Check our Colorectal Surgery Center Packages:

Talk to our Referral Office Representative in Vietnam

Our local representatives speak your language and can assist you by answering any questions you have about the hospital as well as book travel arrangements.There are no additional costs for using this service as per Bumrungrad's One Price Policy.

Enquiry Book Appointment
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> WebFarmSyncHandlers.StartWebFarmThreads
> 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 >> URLRewritingEvents.ProcessABTest.Execute SimpleHandler`2.StartEvent
>>> ABHandlers.ProcessABTest
9 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
10 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> CsrfProtection.OnPostMapRequestHandlerExecute
> ABHandlers.ExcludeVisitorFromAB
> WebAnalyticsWebUIHandlers.SetCampaign
> URLRewritingHandlers.PostMapRequestHandler
11 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
12 RequestEvents.AcquireRequestState.Execute
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderWebUIHandlers.BindStrandsToPagePreRender
13 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
> <>c.b__0_0
> OutputFilterHandlers.EndRequestByOutputFilter
> ABHandlers.LogABVisit
> WebAnalyticsWebUIHandlers.LogPageViewConversion
> <>c.b__5_0
14 DocumentEvents.GetData custom_global_templates_master_bumrungrad_master.__BuildControlTree
15 > TypeInfo(cms.document.bumrungrad.conditionandtreatment).Events.GetData custom_global_templates_master_bumrungrad_master.__BuildControlTree
16 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
17 > TypeInfo(cms.document).Events.GetData PageContext.CurrentPage_InitComplete
18 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
19 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
20 TypeInfo(cms.webpart).Events.GetData PageContext.CurrentPage_InitComplete
21 TypeInfo(cms.resourcestring).Events.GetData custom_global_webparts_packages_ascx.__BuildControlTree
22 TypeInfo(cms.resourcestring).Events.GetData
23 TypeInfo(cms.resourcestring).Events.GetData
24 TypeInfo(cms.resourcestring).Events.GetData
25 TypeInfo(cms.resourcestring).Events.GetData
26 TypeInfo(cms.resourcestring).Events.GetData
27 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
28 TypeInfo(cms.class).Events.GetData PageContext.CurrentPage_InitComplete
29 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
30 > TypeInfo(cms.document.bumrungrad.packages).Events.GetData PageContext.CurrentPage_InitComplete
31 >> TypeInfo(cms.query).Events.GetData PageContext.CurrentPage_InitComplete
32 TypeInfo(cms.transformation).Events.GetData PageContext.CurrentPage_InitComplete
33 DocumentEvents.GetData CMSRepeater.InitControl
34 > TypeInfo(cms.document).Events.GetData CMSRepeater.InitControl
35 DocumentEvents.GetData Bumrungrad.Page_Load
36 > TypeInfo(cms.document).Events.GetData Bumrungrad.Page_Load
37 DocumentEvents.GetData _Header.Page_Load
38 > TypeInfo(cms.document.cms.menuitem).Events.GetData _Header.Page_Load
39 DocumentEvents.GetData _Header.rptMainNav_ItemDataBound
40 > TypeInfo(cms.document).Events.GetData _Header.rptMainNav_ItemDataBound
41 DocumentEvents.GetData _Header.rptMainNav_ItemDataBound
42 > TypeInfo(cms.document).Events.GetData _Header.rptMainNav_ItemDataBound
43 DocumentEvents.GetData _Header.rptMainNav_ItemDataBound
44 > TypeInfo(cms.document).Events.GetData _Header.rptMainNav_ItemDataBound
45 DocumentEvents.GetData _Header.rptMainNav_ItemDataBound
46 > TypeInfo(cms.document).Events.GetData _Header.rptMainNav_ItemDataBound
47 DocumentEvents.GetData WhereSelectEnumerableIterator`2.MoveNext
48 > TypeInfo(cms.document).Events.GetData WhereSelectEnumerableIterator`2.MoveNext
49 TypeInfo(cms.culture).Events.GetData CMSAbstractWebPart.OnLoad
50 DocumentEvents.GetData _Footer.Page_Load
51 > TypeInfo(cms.document.cms.menuitem).Events.GetData _Footer.Page_Load
52 DocumentEvents.GetData BasicRepeater.OnLoad
53 > TypeInfo(cms.document.bumrungrad.footerlinkscolumn).Events.GetData BasicRepeater.OnLoad
54 DocumentEvents.GetData BasicRepeater.BasicRepeater_DataBinding
55 > TypeInfo(cms.document.bumrungrad.footerlink).Events.GetData BasicRepeater.BasicRepeater_DataBinding
56 DocumentEvents.GetData CMSRepeater.CMSRepeater_ItemDataBound
57 > TypeInfo(cms.document.bumrungrad.footerlink).Events.GetData CMSRepeater.CMSRepeater_ItemDataBound
58 DocumentEvents.GetData CMSRepeater.CMSRepeater_ItemDataBound
59 > TypeInfo(cms.document.bumrungrad.footerlink).Events.GetData CMSRepeater.CMSRepeater_ItemDataBound
60 DocumentEvents.GetData CMSRepeater.CMSRepeater_ItemDataBound
61 > TypeInfo(cms.document.bumrungrad.footerlink).Events.GetData CMSRepeater.CMSRepeater_ItemDataBound
62 DocumentEvents.GetData CMSRepeater.CMSRepeater_ItemDataBound
63 > TypeInfo(cms.document.bumrungrad.footerlink).Events.GetData CMSRepeater.CMSRepeater_ItemDataBound
64 DocumentEvents.GetData BasicRepeater.OnLoad
65 > TypeInfo(cms.document.bumrungrad.footercontactinfo).Events.GetData BasicRepeater.OnLoad
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart 		File pathProviderContext
1 EXISTS
 ~/CMSVirtualFiles/Transformations/Bumrungrad.Packages/TileWithColumn.ascx Local PageContext.CurrentPage_InitComplete
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 EXISTS
 ~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
5 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 vietnam.bumrungrad.com LicenseLimitation True Blogs custom_global_templates_master_bumrungrad_master.__BuildControlTree
2 ValidateHash True LocalizationContext.CurrentCulture.CultureCode == "ar-AE" ? "المُستشفى الأمريكي في تايلاند (بامرنجراد)" : "Bumrungrad International Hospital" nattawat DocumentBase.Load
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data		Context
1 ADD pageinfo|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|/treatments-centers/colorectal-surgery-center|true
template|25725
nodeid|10674
 SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|vietnam.bumrungrad|https://vietnam.bumrungrad.com/en/treatments-centers/colorectal-surgery-center|en-us||true|true
template|25725
nodeid|10674
 SimpleHandler`2.StartEvent
3 GET cms.searchengine|cachedids|crawlers SimpleHandler`2.StartEvent
4 ADD currentdocument|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us
nodes|vietnam.bumrungrad|bumrungrad.conditionandtreatment|all
node|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center
 custom_global_templates_master_bumrungrad_master.__BuildControlTree
5 ADD pageinfo|vietnam.bumrungrad|/treatments-centers|en-us||false
template|25699
nodeid|4606
 PageContext.CurrentPage_InitComplete
6 GET pageinfo|vietnam.bumrungrad|/|en-us||false PageContext.CurrentPage_InitComplete
7 ADD cmsdatasource||en-us|vietnam.bumrungrad|/packages/colorectal-surgery-packages/%|en-us|false|bumrungrad.packages||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0|imagetile, title, shortdescription, cost, nodealiaspath, nodeorder|false||
nodes|vietnam.bumrungrad|bumrungrad.packages|all
 PageContext.CurrentPage_InitComplete
8 ADD cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false||||-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
node|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center
 CMSRepeater.InitControl
9 GET querydatasource|bumrungrad.socialmedia.getallitems||||0|| QueryRepeater.InitControl
10 ADD cmsdatasource||en-us|vietnam.bumrungrad|/%|en-us|false|cms.menuitem|documentmenuitemhideinnavigation = 0 and (menuitemgroup is null or menuitemgroup = 'top')|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, menuitemgroup, megamenubg, documentmenucaption|false||
node|vietnam.bumrungrad|/|childnodes
 _Header.Page_Load
11 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false||||-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
12 ADD cmsdatasource||en-us|vietnam.bumrungrad|/about-us/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false||
node|vietnam.bumrungrad|/about-us|childnodes
 _Header.rptMainNav_ItemDataBound
13 GET cmsdatasource||en-us|vietnam.bumrungrad|/about-us/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false|| CMSRepeater.CMSRepeater_ItemDataBound
14 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false||||-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
15 ADD cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false||
node|vietnam.bumrungrad|/treatments-centers|childnodes
 _Header.rptMainNav_ItemDataBound
16 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false|| CMSRepeater.CMSRepeater_ItemDataBound
17 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false||||-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
18 ADD cmsdatasource||en-us|vietnam.bumrungrad|/patient-services/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false||
node|vietnam.bumrungrad|/patient-services|childnodes
 _Header.rptMainNav_ItemDataBound
19 GET cmsdatasource||en-us|vietnam.bumrungrad|/patient-services/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false|| CMSRepeater.CMSRepeater_ItemDataBound
20 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false||||-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
21 ADD cmsdatasource||en-us|vietnam.bumrungrad|/contact-us/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false||
node|vietnam.bumrungrad|/contact-us|childnodes
 _Header.rptMainNav_ItemDataBound
22 GET cmsdatasource||en-us|vietnam.bumrungrad|/contact-us/%|en-us|false||documentmenuitemhideinnavigation = 0|nodeorder|1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, documentmenucaption|false|| CMSRepeater.CMSRepeater_ItemDataBound
23 ADD cmsdatasource||en-us|vietnam.bumrungrad|/%|en-us|false|cms.menuitem|documentmenuitemhideinnavigation = 0 and menuitemgroup = 'footer-center'|nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0|documentmenuitemhideinnavigation, nodealiaspath, documentname, nodeorder, menuitemgroup, documentmenucaption|false||
node|vietnam.bumrungrad|/|childnodes
 _Footer.Page_Load
24 GET querydatasource|bumrungrad.socialmedia.getallitems||siteid = 34||0|| _Footer.Page_Load
25 ADD cmsdatasource||en-us|vietnam.bumrungrad|/%|en-us|false|bumrungrad.footerlinkscolumn||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
bumrungrad.footerlinkscolumn|all
 BasicRepeater.OnLoad
26 ADD cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
bumrungrad.footerlink|all
 BasicRepeater.BasicRepeater_DataBinding
27 ADD cmsdatasource||en-us|vietnam.bumrungrad|/data/footer-links/about/%|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
bumrungrad.footerlink|all
 CMSRepeater.CMSRepeater_ItemDataBound
28 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
29 ADD cmsdatasource||en-us|vietnam.bumrungrad|/data/footer-links/medical-services/%|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
bumrungrad.footerlink|all
 CMSRepeater.CMSRepeater_ItemDataBound
30 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
31 ADD cmsdatasource||en-us|vietnam.bumrungrad|/data/footer-links/patient-services/%|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
bumrungrad.footerlink|all
 CMSRepeater.CMSRepeater_ItemDataBound
32 GET cmsdatasource||en-us|vietnam.bumrungrad|/treatments-centers/colorectal-surgery-center|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false|| BasicRepeater.BasicRepeater_DataBinding
33 ADD cmsdatasource||en-us|vietnam.bumrungrad|/data/footer-links/contact-us/%|en-us|false|bumrungrad.footerlink||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
bumrungrad.footerlink|all
 CMSRepeater.CMSRepeater_ItemDataBound
34 ADD cmsdatasource||en-us|vietnam.bumrungrad|/%|en-us|false|bumrungrad.footercontactinfo||nodeorder|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
bumrungrad.footercontactinfo|all
 BasicRepeater.OnLoad
35 GET favicon|vietnam.bumrungrad Bumrungrad.OnPreRender
36 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /en/treatments-centers/colorectal-surgery-center 0.000
0.062
 
2 PathRewritten ~/Custom/Global/Templates/ConditionAndTreatmentWidgetizedDetailsPage.aspx 0.062
0.000
 
3 > OnPreInit 0.062
0.016
 
4 > OnInit 0.078
0.094
 
5 > OnLoad 0.172
0.094
 
6 > OnPreRender 0.266
N/A
    0.266  
Request cookies:
 NameValue
1 CMSPreferredCultureen-US
2 CMSCsrfCookieDX8o3Py+duTOFmrOL7Pg3oZ6BbxlJDA+nNS2HD3x
3 ASP.NET_SessionIdvbocdyyaxbzqnxdzfrioj4wv
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-US3/22/2024 8:31:40 AM
2 CMSCsrfCookieDX8o3Py+duTOFmrOL7Pg3oZ6BbxlJDA+nNS2HD3x 
3 ASP.NET_SessionIdvbocdyyaxbzqnxdzfrioj4wv 
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (https://commoncrawl.org/faq/)
4 UserHostAddress3.238.250.73
5 UserLanguagesen-US;en;q=0.5
6 UserName 
7 SessionIDvbocdyyaxbzqnxdzfrioj4wv
8 ServerNameRD281878B2E3AE
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 = 34;
DECLARE @DocumentUrlPath nvarchar(max) = N'/treatments-centers/colorectal-surgery-center';
DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/colorectal-surgery-center';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @DocumentCulture1 nvarchar(max) = N'vi-VN';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentCulture] = N'vi-VN' THEN 1 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/treatments-centers/colorectal-surgery-center' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND ([DocumentCulture] = @DocumentCulture OR [DocumentCulture] = @DocumentCulture1))))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (34)
@DocumentUrlPath ("/treatments-centers/colorectal-surgery-center")
@NodeAliasPath ("/treatments-centers/colorectal-surgery-center")
@DocumentCulture ("en-US")
@DocumentCulture1 ("vi-VN")
3.8 kB
 
Table (1 [65], 37 kB)
 
 SimpleHandler`2.StartEvent 0.047
 
CloseConnection()
 SimpleHandler`2.StartEvent N/A
OpenConnection()
 SimpleHandler`2.StartEvent N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 34;
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'/treatments-centers', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (34)
@DocumentCulture ("en-US")
388 B
 
Table (2 [157], 16.5 kB)
 
 SimpleHandler`2.StartEvent 0.016
 
CloseConnection()
 SimpleHandler`2.StartEvent N/A
OpenConnection()
 custom_global_templates_master_bumrungrad_master.__BuildControlTree N/A
3
(bumrungrad.conditionandtreatment.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_ConditionAndTreatment AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ConditionAndTreatmentID] AND V.ClassName = N'Bumrungrad.ConditionAndTreatment' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 10674) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
446 B
 
Table (1 [165], 38 kB)
 
 custom_global_templates_master_bumrungrad_master.__BuildControlTree 0.016
 
CloseConnection()
 custom_global_templates_master_bumrungrad_master.__BuildControlTree N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
4
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 4606;

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID)
) AS SubData
ORDER BY CMS_P DESC
@DocumentCulture ("en-US")
@NodeID (4606)
3.1 kB
 
Table (1 [65], 15.6 kB)
 
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
5
(cms.document.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] = N'/' AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (34)
@DocumentCulture ("en-US")
361 B
 
Table (1 [157], 603 B)
 
 PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
6
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 27981
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
7
(cms.webpart.generalselect)
DECLARE @WebPartID int = 1688;

SELECT TOP 1 *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (1688)
102 B
 
Table (1 [19], 1.7 kB)
 
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 custom_global_webparts_packages_ascx.__BuildControlTree N/A
8
(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
@StringKey ("DataPager.ResultText")
@CultureCode ("en-US")
302 B
 
 custom_global_webparts_packages_ascx.__BuildControlTree 0.000
 
CloseConnection()
 custom_global_webparts_packages_ascx.__BuildControlTree N/A
OpenConnection()
 N/A
9
(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
@StringKey ("DataPager.LabelText")
@CultureCode ("en-US")
300 B
 
 custom_global_webparts_packages_ascx.__BuildControlTree 0.000
 
CloseConnection()
 custom_global_webparts_packages_ascx.__BuildControlTree N/A
OpenConnection()
 N/A
10
(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
@StringKey ("DataPager.Back")
@CultureCode ("en-US")
290 B
 
 custom_global_webparts_packages_ascx.__BuildControlTree 0.016
 
CloseConnection()
 custom_global_webparts_packages_ascx.__BuildControlTree N/A
OpenConnection()
 N/A
11
(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
@StringKey ("DataPager.Next")
@CultureCode ("en-US")
290 B
 
 custom_global_webparts_packages_ascx.__BuildControlTree 0.000
 
CloseConnection()
 custom_global_webparts_packages_ascx.__BuildControlTree N/A
OpenConnection()
 N/A
12
(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
@StringKey ("DataPager.First")
@CultureCode ("en-US")
292 B
 
 custom_global_webparts_packages_ascx.__BuildControlTree 0.000
 
CloseConnection()
 custom_global_webparts_packages_ascx.__BuildControlTree N/A
OpenConnection()
 N/A
13
(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
@StringKey ("DataPager.Last")
@CultureCode ("en-US")
290 B
 
 custom_global_webparts_packages_ascx.__BuildControlTree 0.000
 
CloseConnection()
 custom_global_webparts_packages_ascx.__BuildControlTree N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
14
(.generalselect)
DECLARE @ClassName nvarchar(max) = N'bumrungrad.packages';

SELECT (COUNT(*)) AS [Count]
FROM (
SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
) AS SubData
@ClassName ("bumrungrad.packages")
189 B
 
Table (1 [1], 4 B)
 
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
15
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'bumrungrad.packages';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("bumrungrad.packages")
137 B
 
Table (1 [54], 9.4 kB)
 
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
16
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'bumrungrad.packages';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("bumrungrad.packages")
170 B
 
Table (1 [2], 2.9 kB)
 
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
17

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('Bumrungrad_Packages');
Table (1 [1], 10 B)
 
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
18
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE QueryName = N'generalselect' AND ClassID = 5510
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
19
(bumrungrad.packages.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/packages/colorectal-surgery-packages/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ImageTile], [Title], [ShortDescription], [Cost], [NodeAliasPath], [NodeOrder], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_Packages AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[PackagesID] AND V.ClassName = N'Bumrungrad.Packages' 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 [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/packages/colorectal-surgery-packages/%")
@DocumentCulture ("en-US")
1 kB
 
 PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 PageContext.CurrentPage_InitComplete N/A
20
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE [TransformationClassID] = 5510 AND [TransformationName] = N'TileWithColumn_en-US'
 PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
 PageContext.CurrentPage_InitComplete N/A
OpenConnection()
 CMSRepeater.InitControl N/A
21
(cms.document.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/colorectal-surgery-center';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT DISTINCT [ClassName]
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 (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY ClassName
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/treatments-centers/colorectal-surgery-center")
@DocumentCulture ("en-US")
749 B
 
Table (1 [1], 32 B)
 
 CMSRepeater.InitControl 0.000
 
CloseConnection()
 CMSRepeater.InitControl N/A
OpenConnection()
 CMSRepeater.InitControl N/A
22
(.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/colorectal-surgery-center';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 0 AS [CMS_SN], 'cms.document.bumrungrad.conditionandtreatment' AS [CMS_T]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_ConditionAndTreatment AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ConditionAndTreatmentID] AND V.ClassName = N'Bumrungrad.ConditionAndTreatment' 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)
) AS SubData
ORDER BY CMS_SRN, CMS_SN
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/treatments-centers/colorectal-surgery-center")
@DocumentCulture ("en-US")
1.1 kB
 
Table (1 [168], 38 kB)
 
 CMSRepeater.InitControl 0.016
 
CloseConnection()
 CMSRepeater.InitControl N/A
OpenConnection()
 Bumrungrad.Page_Load N/A
23
(cms.document.generalselect)
DECLARE @NodeId int = 10674;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';

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 [NodeId] = @NodeId AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
@NodeId (10674)
@Now (3/22/2023 8:31:40 AM)
429 B
 
Table (1 [157], 38 kB)
 
 Bumrungrad.Page_Load 0.016
 
CloseConnection()
 Bumrungrad.Page_Load N/A
OpenConnection()
 _Header.Page_Load N/A
24
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeLevel int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [MenuItemGroup], [MegaMenuBG], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID]
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 (DocumentMenuItemHideInNavigation = 0 AND (MenuItemGroup IS NULL OR MenuItemGroup = 'top')) 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 NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeLevel (1)
@DocumentCulture ("en-US")
1.1 kB
 
Table (4 [14], 352 B)
 
 _Header.Page_Load 0.000
 
CloseConnection()
 _Header.Page_Load N/A
OpenConnection()
 _Header.rptMainNav_ItemDataBound N/A
25
(cms.document.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/about-us/%';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID]
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 (DocumentMenuItemHideInNavigation = 0) 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 NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/about-us/%")
@NodeLevel (2)
@DocumentCulture ("en-US")
978 B
 
Table (3 [12], 298 B)
 
 _Header.rptMainNav_ItemDataBound 0.000
 
CloseConnection()
 _Header.rptMainNav_ItemDataBound N/A
OpenConnection()
 N/A
26
(cms.document.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/%';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID]
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 (DocumentMenuItemHideInNavigation = 0) 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 NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/treatments-centers/%")
@NodeLevel (2)
@DocumentCulture ("en-US")
998 B
 
Table (36 [12], 5 kB)
 
 _Header.rptMainNav_ItemDataBound 0.016
 
CloseConnection()
 _Header.rptMainNav_ItemDataBound N/A
OpenConnection()
 N/A
27
(cms.document.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/patient-services/%';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID]
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 (DocumentMenuItemHideInNavigation = 0) 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 NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/patient-services/%")
@NodeLevel (2)
@DocumentCulture ("en-US")
994 B
 
Table (4 [12], 444 B)
 
 _Header.rptMainNav_ItemDataBound 0.000
 
CloseConnection()
 _Header.rptMainNav_ItemDataBound N/A
OpenConnection()
 N/A
28
(cms.document.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/contact-us/%';
DECLARE @NodeLevel int = 2;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID]
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 (DocumentMenuItemHideInNavigation = 0) 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 NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/contact-us/%")
@NodeLevel (2)
@DocumentCulture ("en-US")
982 B
 
Table (10 [12], 1.1 kB)
 
 _Header.rptMainNav_ItemDataBound 0.000
 
CloseConnection()
 _Header.rptMainNav_ItemDataBound N/A
OpenConnection()
 WhereSelectEnumerableIterator`2.MoveNext N/A
29
(cms.document.generalselect)
DECLARE @NodeID int = 10674;
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';

SELECT DISTINCT [ClassName]
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 [NodeID] = @NodeID AND [NodeSiteID] = @NodeSiteID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
ORDER BY ClassName
@NodeID (10674)
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
534 B
 
Table (1 [1], 32 B)
 
 WhereSelectEnumerableIterator`2.MoveNext 0.000
 
CloseConnection()
 WhereSelectEnumerableIterator`2.MoveNext N/A
OpenConnection()
 WhereSelectEnumerableIterator`2.MoveNext N/A
30
(.generalselect)
DECLARE @NodeID int = 10674;
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';

SELECT *
FROM (
SELECT [ConditionAndTreatmentID], [Title], [Content], [Icon], [ImageTile], [BannerImage], [IconName], [TitleAlignment], [DocumentCulture], DocumentName AS [CMS_O1], ROW_NUMBER() OVER (ORDER BY DocumentName) AS [CMS_SRN], 0 AS [CMS_SN], 'cms.document.bumrungrad.conditionandtreatment' AS [CMS_T], [ClassName]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_ConditionAndTreatment AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[ConditionAndTreatmentID] AND V.ClassName = N'Bumrungrad.ConditionAndTreatment' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeID] = @NodeID AND [NodeSiteID] = @NodeSiteID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_O1, CMS_SRN, CMS_SN
@NodeID (10674)
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
1 kB
 
Table (1 [14], 322 B)
 
 WhereSelectEnumerableIterator`2.MoveNext 0.000
 
CloseConnection()
 WhereSelectEnumerableIterator`2.MoveNext N/A
OpenConnection()
 CMSAbstractWebPart.OnLoad N/A
31
(cms.culture.generalselect)
SELECT *
FROM CMS_Culture
WHERE ((LOWER(CultureCode) LIKE 'en-us'))
Table (1 [8], 86 B)
 
 CMSAbstractWebPart.OnLoad 0.000
 
CloseConnection()
 CMSAbstractWebPart.OnLoad N/A
OpenConnection()
 _Footer.Page_Load N/A
32
(cms.menuitem.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [DocumentMenuItemHideInNavigation], [NodeAliasPath], [DocumentName], [NodeOrder], [MenuItemGroup], [DocumentMenuCaption], [DocumentCulture], [NodeID], [NodeLinkedNodeID], [NodeSiteID], [ClassName], [NodeLevel], [NodeParentID]
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 (DocumentMenuItemHideInNavigation = 0 AND MenuItemGroup = 'footer-center') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@DocumentCulture ("en-US")
994 B
 
Table (2 [13], 180 B)
 
 _Footer.Page_Load 0.000
 
CloseConnection()
 _Footer.Page_Load N/A
OpenConnection()
 BasicRepeater.OnLoad N/A
33
(bumrungrad.footerlinkscolumn.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND V.ClassName = N'bumrungrad.footerlinkscolumn' AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@DocumentCulture ("en-US")
608 B
 
Table (4 [157], 3.2 kB)
 
 BasicRepeater.OnLoad 0.000
 
CloseConnection()
 BasicRepeater.OnLoad N/A
OpenConnection()
 BasicRepeater.BasicRepeater_DataBinding N/A
34
(bumrungrad.footerlink.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/treatments-centers/colorectal-surgery-center';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/treatments-centers/colorectal-surgery-center")
@DocumentCulture ("en-US")
879 B
 
 BasicRepeater.BasicRepeater_DataBinding 0.000
 
CloseConnection()
 BasicRepeater.BasicRepeater_DataBinding N/A
OpenConnection()
 CMSRepeater.CMSRepeater_ItemDataBound N/A
35
(bumrungrad.footerlink.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/about/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/data/footer-links/about/%")
@DocumentCulture ("en-US")
844 B
 
Table (4 [160], 3.4 kB)
 
 CMSRepeater.CMSRepeater_ItemDataBound 0.016
 
CloseConnection()
 CMSRepeater.CMSRepeater_ItemDataBound N/A
OpenConnection()
 N/A
36
(bumrungrad.footerlink.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/medical-services/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/data/footer-links/medical-services/%")
@DocumentCulture ("en-US")
866 B
 
Table (6 [160], 5.2 kB)
 
 CMSRepeater.CMSRepeater_ItemDataBound 0.000
 
CloseConnection()
 CMSRepeater.CMSRepeater_ItemDataBound N/A
OpenConnection()
 N/A
37
(bumrungrad.footerlink.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/patient-services/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/data/footer-links/patient-services/%")
@DocumentCulture ("en-US")
866 B
 
Table (7 [160], 6.4 kB)
 
 CMSRepeater.CMSRepeater_ItemDataBound 0.000
 
CloseConnection()
 CMSRepeater.CMSRepeater_ItemDataBound N/A
OpenConnection()
 N/A
38
(bumrungrad.footerlink.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/data/footer-links/contact-us/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterLink AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterLinkID] AND V.ClassName = N'Bumrungrad.FooterLink' 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 [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@NodeAliasPath ("/data/footer-links/contact-us/%")
@DocumentCulture ("en-US")
854 B
 
Table (3 [160], 2.7 kB)
 
 CMSRepeater.CMSRepeater_ItemDataBound 0.000
 
CloseConnection()
 CMSRepeater.CMSRepeater_ItemDataBound N/A
OpenConnection()
 BasicRepeater.OnLoad N/A
39
(bumrungrad.footercontactinfo.generalselect)
DECLARE @NodeSiteID int = 34;
DECLARE @Now datetime2 = '3/22/2023 8:31:40 AM';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN Bumrungrad_FooterContactInfo AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[FooterContactInfoID] AND V.ClassName = N'Bumrungrad.FooterContactInfo' 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 [DocumentCulture] = @DocumentCulture)
ORDER BY NodeOrder
@NodeSiteID (34)
@Now (3/22/2023 8:31:40 AM)
@DocumentCulture ("en-US")
728 B
 
 BasicRepeater.OnLoad 0.000
 
CloseConnection()
 BasicRepeater.OnLoad N/A
OpenConnection()
 CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
40
(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
@StringKey ("General.Expires")
@CultureCode ("en-US")
292 B
 
 CMSAdminControls_Debug_ValuesTable.OnPreRender 0.000
 
CloseConnection()
 CMSAdminControls_Debug_ValuesTable.OnPreRender N/A
  40 queries, 28 kB write, 226 kB read   0.187
Macros resolved in the content of this page:
 ExpressionResultIdentity / userContextDuration
1 {% prefix %}
{%LocalizationContext.CurrentCulture.CultureCode == "ar-AE" ? "المُستشفى الأمريكي في تايلاند (بام...
 		DocumentBase.Load 0.000
> prefix
{%LocalizationContext.CurrentCulture.CultureCode == "ar-AE" ? "المُستشفى الأمريكي في تايلاند (بام...
 		0.000
> {% LocalizationContext.CurrentCulture.CultureCode == "ar-AE" ? "المُستشفى الأمريكي في تايلاند (بامرنجراد)" : "Bumrungrad International Hospital" %} Bumrungrad International Hospital (user) nattawat 0.000
>> LocalizationContext.CurrentCulture.CultureCode == "ar-AE" ? "المُستشفى الأمريكي في تايلاند (بامرنجراد)" : "Bumrungrad International Hospital" Bumrungrad International Hospital (user) nattawat 0.000
2 {% pagetitle_orelse_name %} Colorectal Surgery Center 0.000
> pagetitle_orelse_name Colorectal Surgery Center 0.000
      
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 N/A No
No
 name = "viewport" (8 B)
content = "width=device-width, initial-scale=1, maximum-scale=1, user-scalable=0" (69 B)
 77 B
 
2 N/A No
No
 name = "theme-color" (11 B)
content = "#00685e" (7 B)
 18 B
 
3 N/A No
No
 name = "google-site-verification" (24 B)
content = "GwRXJI_Z5d3ipArqcV6vv9bUP8rs8ZQ83WQZVffF4jQ" (43 B)
 67 B
 
4 HeadPlaceholder
N/A 		No
No
 rel = "canonical" (9 B)
href = "https://vietnam.bumrungrad.com/en/treatments-centers/colorectal-surgery-center" (78 B)
 87 B
 
5 HeadPlaceholder
N/A 		No
No
No
 rel = "alternate" (9 B)
href = "https://vietnam.bumrungrad.com/en/treatments-centers/colorectal-surgery-center" (78 B)
hreflang = "en-us" (5 B)
 92 B
 
6 form Yes
 action = "/en/treatments-centers/colorectal-surgery-center" (48 B)
 48 B
 
7 _Header
plcHeader
rptMainNav 		No
No
Yes
 NestedControlsID = "rptSubMenu" (10 B)
DelayedLoading = True
_!ItemCount = 4
 10 B
 
8 rptMainNav
ltlHasSubMenu 		Yes
 Text = "data-has-submenu='true'" (23 B)
 23 B
 
9 rptMainNav
ltlIsSubVisible 		Yes
 Text = "header__submenu--visible" (24 B)
 24 B
 
10 rptMainNav
rptSubMenu 		No
No
No
Yes
 HideControlForZeroRows = True
DelayedLoading = True
DataBindByDefault = False
_!ItemCount = 3
 0 B
 
11 rptMainNav
ltlHasSubMenu 		Yes
 Text = "data-has-submenu='true'" (23 B)
 23 B
 
12 rptMainNav
ltlIsSubVisible 		Yes
 Text = "header__submenu--visible" (24 B)
 24 B
 
13 rptMainNav
rptSubMenu 		No
No
No
Yes
 HideControlForZeroRows = True
DelayedLoading = True
DataBindByDefault = False
_!ItemCount = 36
 0 B
 
14 rptMainNav
ltlHasSubMenu 		Yes
 Text = "data-has-submenu='true'" (23 B)
 23 B
 
15 rptMainNav
ltlIsSubVisible 		Yes
 Text = "header__submenu--visible" (24 B)
 24 B
 
16 rptMainNav
rptSubMenu 		No
No
No
Yes
 HideControlForZeroRows = True
DelayedLoading = True
DataBindByDefault = False
_!ItemCount = 4
 0 B
 
17 rptMainNav
ltlHasSubMenu 		Yes
 Text = "data-has-submenu='true'" (23 B)
 23 B
 
18 rptMainNav
ltlIsSubVisible 		Yes
 Text = "header__submenu--visible" (24 B)
 24 B
 
19 rptMainNav
rptSubMenu 		No
No
No
Yes
 HideControlForZeroRows = True
DelayedLoading = True
DataBindByDefault = False
_!ItemCount = 10
 0 B
 
20 LanguageSelector
plcLanguageSelector
ltlItems 		Yes
 Text = "<div class="amazing-dropdown__item js-dropdown-item"><a href="/en/treatments-centers/colorectal-surgery-center"><img class="js-dropdown-item-img" data-src="/custom/global/resources/app/images/cultures/en-us.jpg" />English</a></div>" (231 B)
 231 B
 
21 HeaderPlaceHolder
cmsHeaderBannerPlaceholder
pnlPage 		Yes
 CssClass = "PagePlaceholder" (15 B)
 15 B
 
22 pnlPage
lt
zoneHeaderBanner 		No
 CssClass = "zone__header-banner" (19 B)
 19 B
 
23 ContentPlaceHolder
cmsContentPagePlaceHolder
pnlPage 		Yes
 CssClass = "PagePlaceholder" (15 B)
 15 B
 
24 pnlPage
lt
zoneContent 		No
 CssClass = "zone__body-content" (18 B)
 18 B
 
25 SectionLayout_121_1
PackagesListing
rptPackages 		Yes
No
Yes
Yes
Yes
 DelayedLoading = True
EnablePaging = True
TransformationName = "Bumrungrad.Packages.TileWithColumn" (34 B)
HideControlForZeroRows = True
_!ItemCount = 0
 34 B
 
26 FooterPlaceholder
CMSFooterPlaceholder
pnlPage 		Yes
 CssClass = "PagePlaceholder" (15 B)
 15 B
 
27 pnlPage
lt
zoneFooterBanner 		No
 CssClass = "zone__footer-section" (20 B)
 20 B
 
28 _Footer
rptFooterLinks 		No
No
Yes
 NestedControlsID = "rptFooterLink" (13 B)
DelayedLoading = True
_!ItemCount = 4
 13 B
 
29 rptFooterLinks
rptFooterLink 		No
Yes
 DelayedLoading = True
_!ItemCount = 4
 0 B
 
30 rptFooterLinks
rptFooterLink 		No
Yes
 DelayedLoading = True
_!ItemCount = 6
 0 B
 
31 rptFooterLinks
rptFooterLink 		No
Yes
 DelayedLoading = True
_!ItemCount = 7
 0 B
 
32 rptFooterLinks
rptFooterLink 		No
Yes
 DelayedLoading = True
_!ItemCount = 3
 0 B
 
33 _Footer
rptFooterContactInfo 		No
Yes
 DelayedLoading = True
_!ItemCount = 0
 0 B
 
34 _Footer
rptFooterSecondaryNav 		No
Yes
 DelayedLoading = True
_!ItemCount = 2
 0 B
 
35 dbg
pnlDebugContainer 		No
 CssClass = "debug" (5 B)
 5 B
 
     Total viewstate size: bytes