The DHS Program

Sub-Saharan Africa

Angola Benin Botswana Burkina Faso Burundi Cameroon Cape Verde Central African Republic Chad Comoros Congo Congo Democratic Republic Cote d'Ivoire Equatorial Guinea Eritrea Eswatini Ethiopia Gabon Gambia Ghana Guinea Kenya Lesotho Liberia Madagascar Malawi Mali Mauritania Mozambique Namibia Niger Nigeria Nigeria (Ondo State) Rwanda Sao Tome and Principe Senegal Sierra Leone South Africa Sudan Tanzania Togo Uganda Zambia Zimbabwe

North Africa/West Asia/Europe

Albania Armenia Azerbaijan Egypt Jordan Moldova Morocco Tunisia Turkey Ukraine Yemen

Central Asia

Kazakhstan Kyrgyz Republic Tajikistan Turkmenistan Uzbekistan

South & Southeast Asia

Afghanistan Bangladesh Cambodia India Indonesia Lao People's Democratic Republic Maldives Myanmar Nepal Pakistan Philippines Sri Lanka Thailand Timor-Leste Vietnam

Oceania

Papua New Guinea Samoa

Latin America & Caribbean

Bolivia Brazil Colombia Dominican Republic Ecuador El Salvador Guatemala Guyana Haiti Honduras Mexico Nicaragua Paraguay Peru Trinidad and Tobago

Processing...

Debugging Information

ColdFusion Server Developer	2018,0,19,330149
Template	/Countries/Country-Main.cfm
Time Stamp	03-Jul-24 01:32 AM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	10.0.0.149
Host Name	10.0.0.149

Execution Time

Total Time	Avg Time	Count	Template
282 ms	11 ms	25	C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
282 ms	11 ms	25	C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
250 ms	250 ms	1	C:/inetpub/wwwroot/commonspot/master.cfm
250 ms	250 ms	1	C:\inetpub\wwwroot\dhs\Countries\Country-Main.cfm
219 ms	219 ms	1	C:/inetpub/wwwroot/commonspot/master-render.cfm
219 ms	219 ms	1	C:/inetpub/wwwroot/commonspot/render-page.cfm
219 ms	219 ms	1	C:/inetpub/wwwroot/commonspot/uncached-master.cfm
219 ms	219 ms	1	C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
203 ms	203 ms	1	C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
172 ms	172 ms	1	C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
156 ms	16 ms	10	C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
94 ms	94 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c1432-l70-t51-dAny.read
93 ms	47 ms	2	C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
93 ms	47 ms	2	C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
47 ms	47 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c1378-l70-t51-dAny.read
32 ms	16 ms	2	C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
31 ms	31 ms	1	C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
31 ms	31 ms	1	C:/inetpub/wwwroot/dhs/Countries/customcf/listCountriesByRegion-cs.cfm
31 ms	16 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc \| getElementCacheSettings(5010, 4208) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
31 ms	16 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc \| getElementCacheSettings(5010, 4210) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
16 ms	16 ms	1	C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/dhs/Countries/Application.cfm
16 ms	16 ms	1	CFC[ C:/inetpub/wwwroot/cfcs/Countries.cfc \| getCountries() ] from C:/inetpub/wwwroot/cfcs/Countries.cfc
16 ms	8 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc \| GetTemplatePageData(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19152-l70-t51-dAny.read
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19153-l70-t51-dAny.read
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19154-l70-t51-dAny.read
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19155-l70-t51-dAny.read
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19169-l70-t51-dAny.read
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19172-l70-t51-dAny.read
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19174-l70-t51-dAny.read
0 ms	0 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19177-l70-t51-dAny.read
0 ms	0 ms	1	C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms	0 ms	2	C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/controls/dhtmlmenu/menu-output-display.cfm
0 ms	0 ms	2	C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/render-head.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/security/security-page.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/upfront-ghost-queries.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms	0 ms	6	C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms	0 ms	3	C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms	0 ms	2	C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
0 ms	0 ms	6	C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms	0 ms	2	C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
0 ms	0 ms	3	C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/dhs/Countries/customcf/countryMain-cs.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/dhs/custom-application.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms	0 ms	4	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc \| getPageSettings(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms	0 ms	4	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc \| getPageSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms	0 ms	4	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc \| getPageSettings(4190) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms	0 ms	4	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc \| getPageSettings(5010) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc \| DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms	0 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc \| GetPageCacheStatus(1, 1, 0, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc \| GetPageCacheStatus(1, 21, 0, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc \| GetPageCacheStatus(4190, 21, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms	0 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc \| GetPageCacheStatus(5010, 21, 4190, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc \| ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms	0 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc \| UpdateStatus(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc \| getCustomAppPath(21) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc \| getCustomModulePath(post-page-render, 21) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc \| GetEntry(5010) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc \| getRewriteSettings(21) ] from C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc \| getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc \| getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc \| LoadTemplateProperties(template-Where-We-Work.cfm, 4190, 21) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc \| executeFunction(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc \| checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms	0 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc \| queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc \| getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(RequestTimeout check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(Server-level remote requests checked) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(Subsite context updated (ID=21)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(customerScope object initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc \| init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms	0 ms	4	CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc \| getObject(Cache) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms	0 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc \| getObject(Element) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc \| getObject(Keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc \| getObject(LiveBookmarks) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc \| onPageVisit(5010, 21) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms	0 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc \| getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc \| appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms	0 ms	1	CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc \| getTags(5010) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
0 ms	0 ms	2	CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc \| getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
266 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=2114) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 01:32:21.021

		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 5010

			    
			        Parameter #3(CF_SQL_INTEGER) = 2

			    
			        Parameter #4(CF_SQL_INTEGER) = 4190

			    
			        Parameter #5(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 01:32:21.021

			SELECT *
			  FROM Param_Page
			 WHERE (PageID=5010 OR (PageID IN (4190,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 01:32:21.021

					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 01:32:21.021

		SELECT Data_SeeAlso.ID, SubSites.SubSiteURL, SitePages.filename as pagename,
				 XMLPublications.name as feedname, XMLPublicationFormat.name as feedformat,
				 XMLPublications.description,
				 CASE
					 	WHEN XMLPublicationFormat.IsSyndication = 0 THEN 0
						ELSE 1
				 END AS IsSyndicationFeed
		  FROM Data_SeeAlso, XMLPublications, XMLPublicationFormat, SitePages, SubSites
		 WHERE Data_SeeAlso.PageID = ?
		 	AND Data_SeeAlso.Action = ?
		 	AND Data_SeeAlso.ItemID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND Data_SeeAlso.TargetPageID = XMLPublications.XMLPublicationID
		 	AND XMLPublications.XMLPublicationFormatID = XMLPublicationFormat.XMLPublicationFormatID
		 	AND XMLPublications.PageID = SitePages.ID
		 	AND SitePages.SubSiteID = SubSites.ID

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

			    
			        Parameter #2(CF_SQL_INTEGER) = 11

Request.GetGhost (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\upfront-ghost-queries.cfm @ 01:32:21.021

	SELECT *
	  FROM Data_Ghost_Common
	 WHERE (PageID=5010 OR (PageID IN (4190,2,1) AND (VersionState = 2)))
	ORDER BY ControlID, PageID DESC

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=76) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 01:32:21.021

		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

			    
			        Parameter #2(CF_SQL_INTEGER) = 5010

			    
			        Parameter #3(CF_SQL_INTEGER) = 2

			    
			        Parameter #4(CF_SQL_INTEGER) = 4190

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 01:32:21.021

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 400

			    
			        Parameter #2(CF_SQL_INTEGER) = 22

			    
			        Parameter #3(CF_SQL_INTEGER) = 44

			    
			        Parameter #4(CF_SQL_INTEGER) = 55

			    
			        Parameter #5(CF_SQL_INTEGER) = 1

			    
			        Parameter #6(CF_SQL_INTEGER) = 56

			    
			        Parameter #7(CF_SQL_INTEGER) = 47

			    
			        Parameter #8(CF_SQL_INTEGER) = 26

			    
			        Parameter #9(CF_SQL_INTEGER) = 48

			    
			        Parameter #10(CF_SQL_INTEGER) = 27

			    
			        Parameter #11(CF_SQL_INTEGER) = 28

			    
			        Parameter #12(CF_SQL_INTEGER) = 51

			    
			        Parameter #13(CF_SQL_INTEGER) = 31

			    
			        Parameter #14(CF_SQL_INTEGER) = 33

			    
			        Parameter #15(CF_SQL_INTEGER) = 26

			    
			        Parameter #16(CF_SQL_INTEGER) = 48

			    
			        Parameter #17(CF_SQL_INTEGER) = 37

			    
			        Parameter #18(CF_SQL_INTEGER) = 27

			    
			        Parameter #19(CF_SQL_INTEGER) = 38

			    
			        Parameter #20(CF_SQL_INTEGER) = 28

			    
			        Parameter #21(cf_sql_integer) = 26

Request.customCFUpfront (Datasource=commonspot-site-dhs, Time=0ms, Records=3) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 01:32:21.021

	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=5010 OR (PageID IN (4190,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY ControlID, PageID DESC, VersionID DESC

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 01:32:21.021

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 4190

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

qRgns (Datasource=, Time=0ms, Records=6) in C:\inetpub\wwwroot\dhs\Countries\customcf\listCountriesByRegion-cs.cfm @ 01:32:21.021

        SELECT DISTINCT Prnt_Rgn_Name, Prnt_Rgn_Order, Prnt_Rgn_ID
        FROM qStatistics
        ORDER BY Prnt_Rgn_Order

qRgnCtrys1 (Datasource=, Time=0ms, Records=44) in C:\inetpub\wwwroot\dhs\Countries\customcf\listCountriesByRegion-cs.cfm @ 01:32:21.021

           SELECT Ctry_Name, Ctry_ID
           FROM qStatistics
           WHERE Prnt_Rgn_ID = ?
           ORDER BY Ctry_Name

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 4

qRgnCtrys2 (Datasource=, Time=0ms, Records=11) in C:\inetpub\wwwroot\dhs\Countries\customcf\listCountriesByRegion-cs.cfm @ 01:32:21.021

           SELECT Ctry_Name, Ctry_ID
           FROM qStatistics
           WHERE Prnt_Rgn_ID = ?
           ORDER BY Ctry_Name

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 3

qRgnCtrys3 (Datasource=, Time=0ms, Records=5) in C:\inetpub\wwwroot\dhs\Countries\customcf\listCountriesByRegion-cs.cfm @ 01:32:21.021

           SELECT Ctry_Name, Ctry_ID
           FROM qStatistics
           WHERE Prnt_Rgn_ID = ?
           ORDER BY Ctry_Name

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 5

qRgnCtrys4 (Datasource=, Time=0ms, Records=15) in C:\inetpub\wwwroot\dhs\Countries\customcf\listCountriesByRegion-cs.cfm @ 01:32:21.021

           SELECT Ctry_Name, Ctry_ID
           FROM qStatistics
           WHERE Prnt_Rgn_ID = ?
           ORDER BY Ctry_Name

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qRgnCtrys5 (Datasource=, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Countries\customcf\listCountriesByRegion-cs.cfm @ 01:32:21.021

           SELECT Ctry_Name, Ctry_ID
           FROM qStatistics
           WHERE Prnt_Rgn_ID = ?
           ORDER BY Ctry_Name

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 7

qRgnCtrys6 (Datasource=, Time=0ms, Records=15) in C:\inetpub\wwwroot\dhs\Countries\customcf\listCountriesByRegion-cs.cfm @ 01:32:21.021

           SELECT Ctry_Name, Ctry_ID
           FROM qStatistics
           WHERE Prnt_Rgn_ID = ?
           ORDER BY Ctry_Name

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 01:32:21.021

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 4190

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 01:32:21.021

		SELECT ac.ShortDesc AS Name, CustomRenderSupport AS SupportsCustomLayouts,
				 CASE
					WHEN ac.ID <?
					 THEN 'Standard'
					WHEN (ac.Name is NULL or ac.Name = '')
					 THEN 'Saved'
					WHEN fcm.ClassID = 1
					 THEN 'Global'
					ELSE 'Local'
				 END AS ElementType,
				 CASE WHEN ac.Name = 'custom' THEN 'custom/ce' ELSE ac.ControlPrefix END AS ElementURLPrefix,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasFontColorProperties,
				 CASE WHEN (ac.ID IN (?,?,?,?,?,?,?))  THEN 0 ELSE 1 END AS HasLayoutProperties,
				 1 AS HasStyleProperties
		  FROM AvailableControls ac
		  LEFT OUTER JOIN FormControlMap fcm ON fcm.FormID = ac.ID
		 WHERE ac.ID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 400

			    
			        Parameter #2(CF_SQL_INTEGER) = 22

			    
			        Parameter #3(CF_SQL_INTEGER) = 44

			    
			        Parameter #4(CF_SQL_INTEGER) = 55

			    
			        Parameter #5(CF_SQL_INTEGER) = 1

			    
			        Parameter #6(CF_SQL_INTEGER) = 56

			    
			        Parameter #7(CF_SQL_INTEGER) = 47

			    
			        Parameter #8(CF_SQL_INTEGER) = 26

			    
			        Parameter #9(CF_SQL_INTEGER) = 48

			    
			        Parameter #10(CF_SQL_INTEGER) = 27

			    
			        Parameter #11(CF_SQL_INTEGER) = 28

			    
			        Parameter #12(CF_SQL_INTEGER) = 51

			    
			        Parameter #13(CF_SQL_INTEGER) = 31

			    
			        Parameter #14(CF_SQL_INTEGER) = 33

			    
			        Parameter #15(CF_SQL_INTEGER) = 26

			    
			        Parameter #16(CF_SQL_INTEGER) = 48

			    
			        Parameter #17(CF_SQL_INTEGER) = 37

			    
			        Parameter #18(CF_SQL_INTEGER) = 27

			    
			        Parameter #19(CF_SQL_INTEGER) = 38

			    
			        Parameter #20(CF_SQL_INTEGER) = 28

			    
			        Parameter #21(cf_sql_integer) = 26

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 01:32:21.021

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 4190

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 01:32:21.021

		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 5010

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 4190

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:32:21.021

		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 1

CacheUpdate (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 01:32:21.021

					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_INTEGER) = 0

			    
			        Parameter #2(CF_SQL_VARCHAR) = 2124-07-03 01:32:21

			    
			        Parameter #3(CF_SQL_VARCHAR) = 2124-07-03 01:32:21

			    
			        Parameter #4(CF_SQL_INTEGER) = 0

			    
			        Parameter #5(CF_SQL_INTEGER) = 0

			    
			        Parameter #6(CF_SQL_VARCHAR) = 

			    
			        Parameter #7(CF_SQL_INTEGER) = 0

			    
			        Parameter #8(CF_SQL_INTEGER) = 1

			    
			        Parameter #9(CF_SQL_INTEGER) = 2

			    
			        Parameter #10(CF_SQL_INTEGER) = 0

			    
			        Parameter #11(CF_SQL_INTEGER) = 0

			    
			        Parameter #12(CF_SQL_INTEGER) = 0

			    
			        Parameter #13(CF_SQL_INTEGER) = 0

			    
			        Parameter #14(CF_SQL_INTEGER) = 0

			    
			        Parameter #15(CF_SQL_VARCHAR) = 

			    
			        Parameter #16(CF_SQL_INTEGER) = 1

			    
			        Parameter #17(CF_SQL_INTEGER) = 34

			    
			        Parameter #18(CF_SQL_INTEGER) = 23214

			    
			        Parameter #19(CF_SQL_INTEGER) = 0

			    
			        Parameter #20(CF_SQL_INTEGER) = 2

			    
			        Parameter #21(CF_SQL_INTEGER) = 0

Stored Procedures

usp_getCountrys (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\cfcs\Countries.cfc @ 01:32:21.021

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`

resultsets
`name`	`resultset`
`qStatistics`	`1`

Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\Countries\Country-Main.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=CSRFTOKEN=2F428AE0A3CDC442808F38DB3F3E93BE36B6B645; JSESSIONID=DCE05C27DE57B75A9B4C6F3C526C040C.cfusion
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/Countries/Country-Main.cfm?Country=Sri+Lanka&c=Sri+Lanka&ctry_id=37&r=4
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\Countries\Country-Main.cfm
QUERY_STRING=Country=Sri+Lanka&c=Sri+Lanka&ctry_id=37&r=4
REMOTE_ADDR=10.0.0.149
REMOTE_HOST=10.0.0.149
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Countries/Country-Main.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CSRFTOKEN=2F428AE0A3CDC442808F38DB3F3E93BE36B6B645
JSESSIONID=DCE05C27DE57B75A9B4C6F3C526C040C.cfusion

Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=21
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
cloudfrontkeypairid=K3LSHNFSZFMIUC
cloudfronturl=d1vyaiefsqy4pf
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (123)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_request_start_memory=2422408192
cs_runningdashboardcmdcode=0
csrftoken=2F428AE0A3CDC442808F38DB3F3E93BE36B6B645
ctrl_data=Struct (64)
customcf_data=Struct (2)
customcfupfront=Query (3)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
data_ghost=Struct (0)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (2)
elementsrun=2
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-07-03 01:32:21
getghost=Query (0)
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719970341688
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (8)
params_formfields=
params_urlfields=Country,ctry_id,c,r
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-03 01:32:21.688
req_sequenceid=57306
req_startticks=1719970341688
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_DCE05C27DE57B75A9B4C6F3C526C040C.cfusion
sessionstring=1_DCE05C27DE57B75A9B4C6F3C526C040C.cfusion
sicupfront=
sicupfrontparam=
site=Struct (74)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
subsiteid=21
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-03 01:32:21'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)

Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
_csrf_token=2F428AE0A3CDC442808F38DB3F3E93BE36B6B645
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=5010
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719970339969
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=DCE05C27DE57B75A9B4C6F3C526C040C.cfusion
sessionstring=1_DCE05C27DE57B75A9B4C6F3C526C040C.cfusion
urltoken=CFID=2273678&CFTOKEN=8cebf66041870e94-9E35F5F6-B525-43E9-6E6B214D03561384&jsessionid=DCE05C27DE57B75A9B4C6F3C526C040C.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)

URL Parameters:
Country=Sri Lanka
c=Sri Lanka
ctry_id=37
r=4

Debug Rendering Time: 31 ms

WHO WE ARE

Countries

Methodology

RESEARCH

DATA

PUBLICATIONS

TOPICS