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	14-Jun-24 04:34 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.2.110
Host Name	10.0.2.110

Execution Time

Total Time	Avg Time	Count	Template
312 ms	12 ms	25	C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
296 ms	12 ms	25	C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
234 ms	234 ms	1	C:/inetpub/wwwroot/commonspot/master.cfm
234 ms	234 ms	1	C:\inetpub\wwwroot\dhs\countries\Country-Main.cfm
187 ms	187 ms	1	C:/inetpub/wwwroot/commonspot/master-render.cfm
187 ms	187 ms	1	C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
187 ms	187 ms	1	C:/inetpub/wwwroot/commonspot/render-page.cfm
187 ms	187 ms	1	C:/inetpub/wwwroot/commonspot/uncached-master.cfm
187 ms	187 ms	1	C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.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
93 ms	47 ms	2	C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
78 ms	78 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c1432-l70-t51-dAny.read
77 ms	39 ms	2	C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.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
31 ms	31 ms	1	C:/inetpub/wwwroot/commonspot/set-page-vars.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
30 ms	15 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:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19153-l70-t51-dAny.read
16 ms	16 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19172-l70-t51-dAny.read
16 ms	8 ms	2	C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
16 ms	16 ms	1	C:/inetpub/wwwroot/commonspot/site-application.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/customcf/listCountriesByRegion-cs.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/public_api/element.cfc \| getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
15 ms	15 ms	1	C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/21/p5010-c19155-l70-t51-dAny.read
15 ms	15 ms	1	C:/inetpub/wwwroot/commonspot/render-head.cfm
15 ms	15 ms	1	C:/inetpub/wwwroot/commonspot/render-metatags.cfm
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-c19154-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-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-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/build-request-params.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/commonspot/startup/core-application-meat.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	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	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	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	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
250 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 @ 04:34:31.031

		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=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 04:34:31.031

			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 @ 04:34:31.031

					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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

	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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

	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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

        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 @ 04:34:31.031

           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 @ 04:34:31.031

           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 @ 04:34:31.031

           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 @ 04:34:31.031

           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 @ 04:34:31.031

           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 @ 04:34:31.031

           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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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 @ 04:34:31.031

		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

Stored Procedures

usp_getCountrys (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\cfcs\Countries.cfc @ 04:34:31.031

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-06-14 20:53:41
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=fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E; CSRFTOKEN=EFF0A7BCFA15FBFE98128C928FF3BD9B53AE8727; JSESSIONID=BD613D01CF510902C09C8C8E1B94548C.cfusion
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=http://preview.dhsprogram.com/countries/Country-Main.cfm?c=Togo&ctry_id=41&r=1
HTTP_URL=/countries/Country-Main.cfm?c=Togo&ctry_id=41&r=1
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=c=Togo&ctry_id=41&r=1
REMOTE_ADDR=10.0.2.110
REMOTE_HOST=10.0.2.110
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=EFF0A7BCFA15FBFE98128C928FF3BD9B53AE8727
JSESSIONID=BD613D01CF510902C09C8C8E1B94548C.cfusion
fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E

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=3670250104
cs_runningdashboardcmdcode=0
csrftoken=EFF0A7BCFA15FBFE98128C928FF3BD9B53AE8727
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-06-14 04:34:30
getghost=Query (0)
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1718339670970
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 (7)
params_formfields=
params_urlfields=r,ctry_id,c
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-06-14 04:34:30.970
req_sequenceid=110872
req_startticks=1718339670970
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_BD613D01CF510902C09C8C8E1B94548C.cfusion
sessionstring=1_BD613D01CF510902C09C8C8E1B94548C.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-06-14 04:34:30'}
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=VYPdt1zd5ficUBPHcLBjNA==
SURVEYINFO_ACTIVE_DATE=2024-6-12
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
_csrf_token=EFF0A7BCFA15FBFE98128C928FF3BD9B53AE8727
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=1718339669329
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=BD613D01CF510902C09C8C8E1B94548C.cfusion
sessionstring=1_BD613D01CF510902C09C8C8E1B94548C.cfusion
urltoken=CFID=1370139&CFTOKEN=208027760f4c64de-D2411133-C1A1-6332-B9BB61B236F278EE&jsessionid=BD613D01CF510902C09C8C8E1B94548C.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)

URL Parameters:
c=Togo
ctry_id=41
r=1

Debug Rendering Time: 16 ms

WHO WE ARE

Countries

Methodology

RESEARCH

DATA

PUBLICATIONS

TOPICS