The Demographic and Health Surveys (DHS) Program has collected, analyzed, and disseminated accurate and representative data on population, health, HIV, and nutrition through more than 400 surveys in over 90 countries.

A mother and daughters in Jimma Ethiopia work with coffee beans after their house has received Indoor Residual Spraying (IRS) to reduce malaria transmission. Photo Credit: AIRS Ethiopia PMI

Tools & Resources

  • All
  • Featured
  • Analysis
  • Learning

Stay Informed with The DHS Program

Sign up to receive quarterly newsletters and alerts for new survey datasets.

Discover, Share, & Engage with The DHS Program


Debugging Information
ColdFusion Server Standard 2018,0,07,316715
Template /index.cfm
Time Stamp 17-Oct-21 11:46 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 3.237.16.210
Host Name 3.237.16.210


Execution Time

Total Time Avg Time Count Template
1718 ms 59 ms 29 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
1690 ms 58 ms 29 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
967 ms 967 ms 1 C:/inetpub/wwwroot/dhs/index.cfm
964 ms 964 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
944 ms 944 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
935 ms 935 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
934 ms 934 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
934 ms 934 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
932 ms 932 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
900 ms 900 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
896 ms 112 ms 8 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
719 ms 719 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19270-l70-t51-dAny.read
544 ms 544 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
377 ms 377 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/cpe-custom.cfm
115 ms 115 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
77 ms 77 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/get-params.cfm
54 ms 27 ms 2 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load.cfm
35 ms 35 ms 1 C:/inetpub/wwwroot/dhs/Application.cfm
34 ms 34 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
33 ms 33 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
31 ms 16 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(2244, 135734) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
27 ms 27 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/custom-pre-render.cfm
25 ms 25 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19153-l70-t51-dAny.read
24 ms 24 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19152-l70-t51-dAny.read
24 ms 24 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19154-l70-t51-dAny.read
19 ms 19 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19155-l70-t51-dAny.read
18 ms 18 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/ct-limit-inheritance.cfm
10 ms 10 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c148433-l70-t31-dAny.read
10 ms 10 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
10 ms 10 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
10 ms 5 ms 2 C:/inetpub/wwwroot/commonspot/utilities/ct-extract-wddx-data.cfm
8 ms 8 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 135726) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
6 ms 6 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/get-data.cfm
5 ms 5 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19169-l70-t51-dAny.read
5 ms 5 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19174-l70-t51-dAny.read
5 ms 5 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
5 ms 5 ms 1 C:/inetpub/wwwroot/dhs/renderhandlers/2020__home--publications.cfm
5 ms 5 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(2244) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
4 ms 2 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
4 ms 2 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
3 ms 3 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19172-l70-t51-dAny.read
3 ms 3 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
3 ms 3 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
3 ms 3 ms 1 CFC[ C:/inetpub/wwwroot/cfcs/Publications.cfc | qpubsrecent4() ] from C:/inetpub/wwwroot/cfcs/Publications.cfc
2 ms 2 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/1/p2244-c19177-l70-t51-dAny.read
2 ms 1 ms 2 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/escape-data.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/tags/get-mask-collection.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load_core.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/controls/ct-get-inheritance.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
1 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
1 ms 1 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(template-base-plus-one.cfm, 2, 1) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
1 ms 1 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 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/controls/default-mode.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/cache-query-instance.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/cache-query.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/pagemode/pagemodeui.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/browser-detect-methods.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/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/session-first-site.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
0 ms 0 ms 1 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 7 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 1 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/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2244) ] 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 3 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(2, 1, 1, 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(2244, 1, 2, 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 | UpdateStatus([complex value], [complex value], 1, 2244, 2, 0, 0, 90) ] 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(1) ] 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, 1) ] 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(2244) ] 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(1) ] 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/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) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 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('site' Remote Requests processed) ] 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('user' Remote Requests processed) ] 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(New (global) session 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(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=1)) ] 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(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(user object created) ] 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(user session 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(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 2 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(2244, 1) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
18 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1020 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get (Datasource=dhs_legacy_live, Time=1ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 11:46:34.034
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
pendingRequests (Datasource=commonspot-users, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 11:46:34.034
				SELECT params,RequestSequenceID
				  FROM UsersRemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-users, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 11:46:34.034
			SELECT *
			  FROM UsersRemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 11:46:34.034
				SELECT params,RequestSequenceID
				  FROM RemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 11:46:34.034
			SELECT *
			  FROM RemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=9ms, Records=271) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 11:46:34.034
		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) = 2
Parameter #3(CF_SQL_INTEGER) = 2244
Parameter #4(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 11:46:34.034
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=2244 OR (PageID IN (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 @ 11:46:34.034
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2244

testQuery (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 11:46:34.034
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2244

qry (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\commands\livebookmarks.cfc @ 11:46:34.034
		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) = 2244
Parameter #2(CF_SQL_INTEGER) = 11

ControlInstanceData (Datasource=commonspot-site-dhs, Time=3ms, Records=197) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 11:46:34.034
		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) = 2
Parameter #3(CF_SQL_INTEGER) = 2244

qInfo (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 11:46:34.034
		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) = 135726

getForms (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\metadata\tags\form_control\load_core.cfm @ 11:46:34.034
		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as CFTID,
				 cft.CSDataType AS CFTDataType,
				 cft.FilterModule as CFTFilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 135732 ORDER BY d1.id, d2.id 
CheckInheritance (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\ct-limit-inheritance.cfm @ 11:46:34.034
   SELECT PageID,VersionState,AuthorID
     FROM Param_WDDX
    WHERE ControlID=?
		AND (PageID=2244 OR (PageID IN (2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 135734

GetWDDXData (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 11:46:34.034
	SELECT *
	  FROM Param_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=2244 AND (VersionState = 2)) OR ((PageID IN (2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 135734
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 135726

GetWDDXData (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 11:46:34.034
		SELECT *
		  FROM Param_WDDX
		 WHERE PageID=0
			AND ControlID=0
			AND ItemID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 135726

qDspTpl (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\custom\get-params.cfm @ 11:46:34.034
	SELECT DisplayTemplateID, ModuleID
	  FROM Data_Custom_Render
	 WHERE ControlID = ?
		AND (PageID IN (?,?,?)) 
		AND (VersionState = 2)
 ORDER BY PageID DESC, VersionID DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 135734
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 2244

getDefaultModule (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\custom\get-params.cfm @ 11:46:34.034
	SELECT *
	  FROM ElementDefaults
	 WHERE ElementTypeID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 135726

qryFC (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\custom\get-params.cfm @ 11:46:34.034
		SELECT params
		  FROM FormControl
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 135726

qLayoutProps (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\controls\custom\get-params.cfm @ 11:46:34.034
		SELECT *
		  FROM CustomElementModules
		 WHERE ID = ?
			AND (IncludeStyle + IncludeParams + IncludeLayout + IncludeMetadata) > 0 
			AND DisplayTemplateID = 0
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 0

GetWDDXData (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 11:46:34.034
	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=2244 AND (VersionState = 2)) OR ((PageID IN (2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 135734
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 135726

cachedData (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\custom_element.cfm @ 11:46:34.034
			SELECT DataBlock, PageID, ControlID
			  FROM ElementDataCache
			 WHERE (PageID = ?) 
				AND ControlID = 0
			
				AND FormID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 135735
Parameter #2(CF_SQL_INTEGER) = 135726

getRHDetails (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 11:46:34.034
			SELECT cem.ID, cem.Name, cem.HasFieldMappings, ac.Name AS ElementTypeName
			  FROM CustomElementModules cem
			  JOIN AvailableControls ac ON ac.ID = cem.ElementType
			 WHERE cem.ElementType = ?
				AND cem.ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 135726
Parameter #2(cf_sql_integer) = 135732

qSubRenderDT (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\controls\custom\cpe-custom.cfm @ 11:46:34.034
			SELECT DisplayTemplateID
			  FROM Data_Custom_Render
			 WHERE ModuleID > 0
				AND DisplayTemplateID > 0
				AND ControlID = ?
				AND (PageID IN (?,?,?)) 
				AND (VersionState = 2)
		 ORDER BY PageID DESC, VersionID DESC
		
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 135734
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 2244

qry (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\controls\custom\tags\get-mask-collection.cfm @ 11:46:34.034
		SELECT rmm.FormControlID, rmm.Data_TextBlockID, rmm.TransactionDate, rmm.PreviewImageID, rmm.ItemState, rmm.Description,
			CASE WHEN ed.DisplayTemplateID = rmm.Data_TextBlockID THEN 1 ELSE 0 END AS IsDefault
		  FROM RenderMaskMap rmm
		  LEFT OUTER JOIN ElementDefaults ed ON ed.DisplayTemplateID = rmm.Data_TextBlockID AND ed.HandlerID = 0
		 WHERE rmm.FormControlID = ? 
			AND rmm.Data_TextBlockID = ed.DisplayTemplateID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 135726

qryFields (Datasource=, Time=1ms, Records=4) in C:\inetpub\wwwroot\commonspot\controls\custom\escape-data.cfm @ 11:46:34.034
	SELECT InputType, FieldName, FormID, InputID, CFTID, CFTDataType
	  FROM attributes.formDefQuery
	 WHERE InputType IN (?,?,?,?,?,?,?,?,?,?)
		 OR CFTID > 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = checkbox
Parameter #2(CF_SQL_VARCHAR) = email
Parameter #3(CF_SQL_VARCHAR) = hidden
Parameter #4(CF_SQL_VARCHAR) = multicheckbox
Parameter #5(CF_SQL_VARCHAR) = radiobutton
Parameter #6(CF_SQL_VARCHAR) = select
Parameter #7(CF_SQL_VARCHAR) = text
Parameter #8(CF_SQL_VARCHAR) = large_textarea
Parameter #9(CF_SQL_VARCHAR) = small_textarea
Parameter #10(CF_SQL_VARCHAR) = img

testQuery (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 11:46:34.034
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2244

qry (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 11:46:34.034
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2244

testQuery (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 11:46:34.034
		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

qpubs_recent4 (Datasource=dhs_legacy_live, Time=2ms, Records=4) in C:\inetpub\wwwroot\cfcs\Publications.cfc @ 11:46:34.034
SELECT DISTINCT TOP 4

   c.Pub_ID,
   c.Pub_Type_ID,
   c.Pub_Code,
   Year(c.print_date) as PrintYear,
   CONVERT(CHAR(8), c.print_date, 1) as pubPrintDate,
   c.Pub_Code_Num,
   c.ctry_list,
   c.Print_Date,
   c.Release_Date,
   c.Lang_List,
   c.Title AS Title2,
   t.Pub_Type_Name,
   s.Survey_Yr_Display,
   t2.Pub_Type_Prnt_Name,

    (SELECT Count(*)
     FROM Pub_PDF
     WHERE Pub_PDF.Pub_ID = c.Pub_ID) AS NoPDF,

	 (SELECT
	  CASE WHEN survey_subtype_desc = 'Standard DHS' THEN 'DHS'
	       WHEN survey_subtype_desc = 'Standard AIS' THEN 'AIS'
	       ELSE survey_subtype_desc END
    FROM survey_subtype, survey
    WHERE survey_subtype.survey_subtype_id = survey.survey_type_ID
   and survey.survey_id=c.survey_id
   ) AS SurveyType,

     (SELECT ctry_name
    FROM Ctry, survey
    WHERE ctry.ctry_id = survey.ctry_id
   and survey.survey_id=c.survey_id
   ) AS ctry_name,

    (SELECT PDF_File_Name
    FROM Pub_PDF
    WHERE Pub_PDF.Pub_ID = c.Pub_ID
    AND (SELECT Count(*)
        FROM Pub_PDF
        WHERE Pub_PDF.Pub_ID = c.Pub_ID) = 1) AS PDFFileName

FROM Pub_Catalog c
   INNER JOIN Pub_Type t ON t.Pub_Type_ID = c.Pub_Type_ID
   INNER JOIN Pub_Type_Prnt t2 ON t.Pub_Type_Prnt_ID = t2.Pub_Type_Prnt_ID
   LEFT OUTER JOIN Survey s ON s.Survey_ID = c.Survey_ID
WHERE c.Pub_Code <> 'NA'
  AND c.Stts_ID =3
  AND c.Pub_Type_ID IN (5,21,26,30,39)

ORDER BY c.Release_Date DESC 
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 11:46:34.034
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2244

qry (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\cache.cfc @ 11:46:34.034
		SELECT SubsiteID, InheritedTemplateList
		  FROM SitePages
		 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2244

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 11:46:34.034
		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


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
adf=Struct (88)
adfscheduler=Struct (0)
applicationname=site1
blogcache=Struct (4)
cachedimages=Struct (20)
cacheinfocache=Struct (51)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=6
covid_newsarticlecount=24
covid_pressreleasecount=4
covid_pubcount=2
cs_element_cache=Struct (0)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerscope=Struct (18)
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 (3)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2021-10-17 17:16:40
search_orphan_next_clean=2021-10-17 17:16:41
serverstatus=Struct (1)
site=Struct (71)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
taxonomy=Struct (2)
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=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
CERT_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
HTTPS_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/index.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\index.cfm
QUERY_STRING=
REMOTE_ADDR=3.237.16.210
REMOTE_HOST=3.237.16.210
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=1568431
CFTOKEN=5b532d6e6d8fa542-8CBF6855-CEB3-2169-9A99FDEDA02327F2
Request Parameters:
anonnoreadelements=61254
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
autologinhandled=0
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=26
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (124)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_runningdashboardcmdcode=0
ctrl_data=Struct (183)
customcfupfront=
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (41)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138
formattedtimestamp=2021-10-17 11:46:34
getghost=
hivbold=1,3,8,9
ignoreauthuser=0
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1634471194153
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (86)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
previewmode=0
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (72)
req_cam_callcount=1
req_inittimestamp=2021-10-17 11:46:34.147
req_sequenceid=9536
req_startticks=1634471194147
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_5E33261B4B9FC3A25A6BC9C15636AFD2.cfusion
sessionstring=1_5E33261B4B9FC3A25A6BC9C15636AFD2.cfusion
sicupfront=
sicupfrontparam=
site=Struct (71)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
subsiteid=1
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2021-10-17 11:46:34'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (27)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (40)
EMAILALERTKEY=Cz/qOdKOVEQwE3OVjxl3UA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=2244
debugmode=0
debugstate=Struct (1)
editmode=0
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1634471194160
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=5E33261B4B9FC3A25A6BC9C15636AFD2.cfusion
urltoken=CFID=1568431&CFTOKEN=5b532d6e6d8fa542-8CBF6855-CEB3-2169-9A99FDEDA02327F2&jsessionid=5E33261B4B9FC3A25A6BC9C15636AFD2.cfusion
usagelist=
user=Struct (27)
Debug Rendering Time: 21 ms