Survey Summary

Madagascar: Standard DHS, 2003-04
Survey Datasets
Data Available
HIV Testing
Not Collected
GPS Datasets
Not Distributed
SPA Datasets
Not Applicable
Country: Madagascar
Contract Phase: DHS-IV
Recode Structure: DHS-IV
Implementing Organization: Institut National de la Statistique (INSTAT)
Fieldwork: November 2003 - March 2004
Status: Completed
Respondents  
Households: Sample Size: 8420
Female: All Women
Age: 15 to 49
Sample Size: 7949
Male: All Men
Age: 15 to 59
Sample Size: 2432
Facilities: N/A
Survey Characteristics
Features
Alcohol consumption
Anemia questions
Birth registration
Calendar
Cooking fuel
GPS/georeferenced
Health insurance
HIV behavior
HIV knowledge
Iodine salt test
Malaria questions
Men's survey
Paper survey
Social marketing
Tobacco use
Women's status
Biomarkers
Anemia testing
Anthropometry
Measles testing
Syphilis testing
Tetanus testing
Modules
Maternal mortality


Debugging Information
ColdFusion Server Standard 2018,0,19,330149
Template /methodology/survey/survey-display-207.cfm
Time Stamp 19-Sep-24 05:49 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.97
Host Name 10.0.2.97


Execution Time

Total Time Avg Time Count Template
4330 ms 167 ms 26 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
4282 ms 165 ms 26 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
2488 ms 2488 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
2488 ms 2488 ms 1 C:/inetpub/wwwroot/dhs/methodology/survey/survey-display-207.cfm
2284 ms 2284 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
2221 ms 2221 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
2221 ms 2221 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
2221 ms 2221 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
2221 ms 2221 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
2203 ms 220 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
2203 ms 2203 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
2032 ms 2032 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c1378-l70-t51-dAny.read
2000 ms 2000 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
141 ms 141 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
141 ms 141 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
111 ms 111 ms 1 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
109 ms 109 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
78 ms 78 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/survey/summary_page.cfm
47 ms 47 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c19154-l70-t51-dAny.read
47 ms 47 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c19174-l70-t51-dAny.read
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
42 ms 42 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
33 ms 33 ms 1 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.cfm
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(9088, 8772) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
30 ms 30 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-stub.cfm
18 ms 18 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
17 ms 17 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/survey/survey_qry.cfm
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c19152-l70-t51-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.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/init-server-scope.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/methodology/survey/Application.cfm
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(8770, 33, 3901, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | getTemplatePageData(8770) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 9088) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c1432-l70-t51-dAny.read
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c19155-l70-t51-dAny.read
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/survey/dataset_display.cfm
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c19153-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p9088-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 1 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-metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.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/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-site.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/style/load-page-classes.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 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.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 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfwddx.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 14 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/item-visible.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 3 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/Methodology/survey/template-Survey-Summary-Display.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/customcf/legacy/publication/pubs_functions.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/survey/countries_functions.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/customcf/legacy/survey/publication_qry.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms 0 ms 2 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 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
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(3901) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(8770) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(9088) ] 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(3901, 19, 2, 0) ] 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(9088, 33, 8770, 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], 33, 9088, 8770, 0, 0, 2) ] 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], 33, 9088, 8770, 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/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(33) ] 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, 33) ] 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(9088) ] 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(33) ] 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 | GetTemplatePageData(3901) ] 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-Survey-Summary-Display.cfm, 8770, 33) ] 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 | getTemplatePageData(3901) ] 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 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(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=33)) ] 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(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 1 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/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/visitor-context-rule-actions.cfc | onPageVisit(9088, 33) ] 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(9088) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.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
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2519 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get (Datasource=dhs_legacy_live, Time=0ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 05:49:54.054
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
GetPageRec (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\verify-stub-data.cfm @ 05:49:54.054
		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088

GetPageRec (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\build-and-write-stub.cfm @ 05:49:54.054
	SELECT *
	  FROM SitePages
	 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088

inheritedCacheSettings (Datasource=commonspot-site-dhs, Time=0ms, Records=4) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 05:49:54.054
		SELECT StaleCacheMaxKeepTime,DynamicContentCacheKeepTime
		  FROM SitePages
		 WHERE (ID IN (?,?,?,?)) 
	 ORDER BY ID
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 3901

GetBaseTemplateSubSiteID (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 05:49:54.054
		SELECT DISTINCT SitePages.SubSiteID
		  FROM SitePages, Subsites
		 WHERE SitePages.SubSiteID = Subsites.ID
		
			AND Subsites.ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

qParentTemplateInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 05:49:54.054
			SELECT PageType
			  FROM SitePages
			 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8770

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 05:49:54.054
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 05:49:54.054
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088

qryKeywords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\keywords-tags\keywords-tags-base.cfc @ 05:49:54.054
		SELECT OriginalString AS Word 
				, KeywordType As KeywordTypeID
				
		  FROM ObjectKeywords
		 WHERE ObjectID = ? 
			AND KeywordType = ? 
	 ORDER BY Position, OriginalString
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088
Parameter #2(CF_SQL_TINYINT) = 0

GetRenderOptions (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 05:49:54.054
			SELECT GeneralCategories.Category, RenderOptions.PageID
			  FROM RenderOptions, GeneralCategories
			 WHERE GeneralCategories.ID = RenderOptions.CategoryID
				AND GeneralCategories.CategoryTypeID = ?
				AND (RenderOptions.PageID IN (?,?,?,?,?)) 
		 ORDER BY RenderOptions.PageID Desc
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 12
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 8770
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 9088
Parameter #6(CF_SQL_INTEGER) = 3901

getPageInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 05:49:54.054
	SELECT PageType, SubSiteID, CategoryID, InheritedTemplateList, DocType, Uploaded
	  FROM SitePages
	 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088

FormData (Datasource=commonspot-site-dhs, Time=47ms, Records=22) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 05:49:54.054
	SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue, FormInputControl.FieldName, FormInputControl.type, FormControl.FormName,
			 FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,
			 Data_FieldValue.MemoValue, Data_FieldValue.listid, FormInputControl.params AS fieldParams
						  
	  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue,FormControlMap
	 WHERE (Data_FieldValue.PageID IN (?,?,?,?,?))  
		AND Data_FieldValue.FieldID = FormInputControl.ID
		AND Data_FieldValue.FormID = FormControl.ID
		AND FormInputControl.ID = FormInputControlMap.FieldID
		AND FormControl.ID = FormInputControlMap.FormID
		AND FormControl.ID = FormControlMap.FormID
	
		
		AND (
				
				(
					(FormControlMap.ClassConstant = 4)
				
					AND (FormControlMap.ClassID IN (?,?,?)) 
				)
				
				
					OR (
								 (FormControlMap.ClassConstant = 1)
							AND ( (FormControlMap.ClassID IN (?,?,?,?)) )
						)
				
				
					OR (
								 (FormControlMap.ClassConstant = 2)
							AND (FormControlMap.ClassID = ?)
						)
				
				

				
			 )
	
 ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 9088
Parameter #5(CF_SQL_INTEGER) = 3901
Parameter #6(CF_SQL_INTEGER) = 33
Parameter #7(CF_SQL_INTEGER) = 1
Parameter #8(CF_SQL_INTEGER) = 19
Parameter #9(CF_SQL_INTEGER) = 1
Parameter #10(CF_SQL_INTEGER) = 8770
Parameter #11(CF_SQL_INTEGER) = 2
Parameter #12(CF_SQL_INTEGER) = 3901
Parameter #13(CF_SQL_INTEGER) = 1

getTerm (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 05:49:54.054
				SELECT Term.Name
				  FROM Term, data_ListItems
				 WHERE (Term.ID = ?) 
					AND Term.id = data_ListItems.numitemvalue
					AND data_ListItems.listid = ?
					AND Term.TaxonomyID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 46
Parameter #2(CF_SQL_INTEGER) = 14551
Parameter #3(CF_SQL_INTEGER) = 1

NamedClasses (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\style\load-page-classes.cfm @ 05:49:54.054
	SELECT *
	  FROM Data_ClassNames
	 WHERE (PageID IN (?,?,?,?,?)) 
		AND VersionState = ?
		AND OutputTypeID = 0
 ORDER BY PageID DESC, ControlID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 9088
Parameter #5(CF_SQL_INTEGER) = 3901
Parameter #6(CF_SQL_INTEGER) = 2

StyleSheetGroups (Datasource=commonspot-site-dhs, Time=17ms, Records=2) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 05:49:54.054
		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 9088
Parameter #5(CF_SQL_INTEGER) = 3901
Parameter #6(CF_SQL_INTEGER) = 2

PageStyleSheets (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 05:49:54.054
		SELECT *
		  FROM Data_StyleSheets
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND ControlID = ?
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 9088
Parameter #5(CF_SQL_INTEGER) = 3901
Parameter #6(CF_SQL_INTEGER) = 3474
Parameter #7(CF_SQL_INTEGER) = 2

CheckCustomRender (Datasource=commonspot-site-dhs, Time=0ms, Records=52) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 05:49:54.054
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 9088
Parameter #5(CF_SQL_INTEGER) = 3901
Parameter #6(CF_SQL_INTEGER) = 2

SecurityRecords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 05:49:54.054
	SELECT DISTINCT ControlID
	  FROM ItemSecurity
	 WHERE PageID = ?
		AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088

ParentTemplateInfo (Datasource=commonspot-site-dhs, Time=14ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\write-stub.cfm @ 05:49:54.054
		SELECT SubsiteID,Filename,PageType
		  FROM SitePages
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8770

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=15ms, Records=1999) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 05:49:54.054
		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) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 9088
Parameter #5(CF_SQL_INTEGER) = 3901
Parameter #6(CF_SQL_INTEGER) = 2

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

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

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

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=63) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 05:49:54.054
		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) = 8770
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 9088
Parameter #5(CF_SQL_INTEGER) = 3901

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 05:49:55.055
		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=2) in C:\inetpub\wwwroot\commonspot\controls\upfront-generic.cfm @ 05:49:55.055
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=9088 OR (PageID IN (8770,3901,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 @ 05:49:55.055
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9088

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

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

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

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

qMetaData (Datasource=dhs_legacy_live, Time=17ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\survey_qry.cfm @ 05:49:55.055
    SELECT DISTINCT 
       S.Survey_ID, 
       P.Phase_Name,
       PR.Phase_Name AS Phase_Name_Recode,
       S.Survey_Yr_Display, 
       C.Ctry_Name,
       T.Survey_Type_ID, 
       T.Survey_Type_Lbl, 
       T1.Survey_SubType_Desc,
       S.Stts_ID,
       St.Stts_Lbl, 
       S.Survey_Start, 
       S.Survey_End, 
       S.Implementing, 
       S.Notes, 
       S.data_Avail_flag,
       Facil_Samp_Size, 
       House_Samp_Size, 
       Survey_Footnotes, 
       S.data_avail_date,
       S.rpt_avail_date,
       survey_type_mainid,
       
       (SELECT U.Univ_Lbl 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id
         AND u.univ_type = 'f') AS Univ_Lbl_F,
       
       (SELECT Sr.Resp_Age_Min 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id
         AND u.univ_type = 'f') AS Min_Age_F,
       
       (SELECT Sr.Resp_Age_Max 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id
         AND u.univ_type = 'f') AS Max_Age_F,
       
       (SELECT Sr.Sample_Size 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id
         AND u.univ_type = 'f') AS Sample_F,
       
       (SELECT U.Univ_Lbl 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id
         AND u.univ_type = 'm') AS Univ_Lbl_M,
       
       (SELECT Sr.Resp_Age_Min 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id 
         AND u.univ_type = 'm') AS Min_Age_M,
       
       (SELECT Sr.Resp_Age_Max 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id
         AND u.univ_type = 'm') AS Max_Age_M,
       
       (SELECT Sr.Sample_Size 
       FROM Survey_Resp Sr 
          INNER JOIN Univ U ON U.Univ_ID = Sr.Univ_ID 
       WHERE sr.survey_id = s.survey_id
         AND u.univ_type = 'm') AS Sample_M
    
    FROM Survey S
       INNER JOIN Phase P ON P.Phase_ID = S.Survey_Phase_ID
       INNER JOIN Phase PR ON PR.Phase_ID = S.Survey_Recode_ID
       INNER JOIN Ctry C ON S.Ctry_ID = C.Ctry_ID
       INNER JOIN Survey_subType T1 ON T1.Survey_subType_ID = S.Survey_Type_ID
        INNER JOIN Survey_Type T ON  T.Survey_Type_ID = T1.Survey_Type_MainID  
       INNER JOIN Survey_Stts St ON St.Stts_ID = S.Stts_ID
    WHERE S.Survey_ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 207

qMetaDataFeatures (Datasource=dhs_legacy_live, Time=0ms, Records=16) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\survey_qry.cfm @ 05:49:55.055
	SELECT DISTINCT l.Mod_Feat_ID, m.Mod_Feat_Name, m.Mod_Feat_Type, m.Mod_Feat_Desc, biomarker, Mod_Feat_ID_Group
    FROM Survey_Mod_Feat_Lnk l
       INNER JOIN Mod_Feat m ON m.Mod_Feat_ID = l.Mod_Feat_ID
    WHERE Survey_ID = ?
      AND m.Active_Flag = 1
	  AND m.Internal_Flag = 0
	  AND m.Mod_Feat_Type = 'f'
	  AND biomarker = '0'
    ORDER BY Mod_Feat_Name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 207

qMetaDataBios (Datasource=dhs_legacy_live, Time=0ms, Records=5) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\survey_qry.cfm @ 05:49:55.055
 
	SELECT DISTINCT l.Mod_Feat_ID, m.Mod_Feat_Name, m.Mod_Feat_Type, m.Mod_Feat_Desc, biomarker, Mod_Feat_ID_Group, Survey_ID
	   FROM Survey_Mod_Feat_Lnk l
	      INNER JOIN Mod_Feat m ON m.Mod_Feat_ID = l.Mod_Feat_ID
	   WHERE Survey_ID = ?
	     AND m.Active_Flag = 1
	  AND m.Internal_Flag = 0
	  AND m.Mod_Feat_Type = 'f'
	  AND biomarker = '1'
	  AND (Mod_Feat_ID_Group is NULL or Mod_Feat_ID_Group = 0)
   ORDER BY Mod_Feat_Name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 207

qMetaDataMods (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\survey_qry.cfm @ 05:49:55.055
 
	SELECT DISTINCT l.Mod_Feat_ID, m.Mod_Feat_Name, m.Mod_Feat_Type, m.Mod_Feat_Desc, biomarker, Mod_Feat_ID_Group
	   FROM Survey_Mod_Feat_Lnk l
	      INNER JOIN Mod_Feat m ON m.Mod_Feat_ID = l.Mod_Feat_ID
	   WHERE Survey_ID = ?
	     AND m.Active_Flag = 1
	  AND m.Internal_Flag = 0
	  AND m.Mod_Feat_Type = 'm'
	  AND biomarker = '0'
   ORDER BY Mod_Feat_Name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 207

publicationMetaData (Datasource=commonspot-site-dhs, Time=16ms, Records=624) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    select pageid, fieldvalue 
    from data_fieldValue d, sitepages p 
    where d.pageid = p.id
	and versionstate = 2
    and fieldid = 13565
    and fieldvalue is not NULL
    and fieldvalue != ''
	order by PublicReleaseDate desc
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
        select s.subsiteurl + p.filename as combined_filename, p.title, p.PublicReleaseDate as posted_on, InheritedTemplateList
        from sitepages p, subsites s
        where p.subsiteid = s.id
        and p.id = 4888
		and p.subsiteid = 18  
        
qCtryName (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\dataset_display.cfm @ 05:49:55.055
SELECT Ctry_Name, Ctry_Code
FROM Ctry
WHERE Ctry_ID =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 23

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

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 05:49:55.055
		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 @ 05:49:55.055
		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=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 05:49:57.057
					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-09-19 05:49:54
Parameter #3(CF_SQL_VARCHAR) = 2124-09-19 05:49:54
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) = 33
Parameter #18(CF_SQL_INTEGER) = 9088
Parameter #19(CF_SQL_INTEGER) = 0
Parameter #20(CF_SQL_INTEGER) = 2
Parameter #21(CF_SQL_INTEGER) = 0


Stored Procedures

usp_getPubs_by_Surveyid (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\publication_qry.cfm @ 05:49:55.055

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  207    
    
resultsets
nameresultset
 qPubDsp  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  523    
    
resultsets
nameresultset
 qDetails  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  491    
    
resultsets
nameresultset
 qDetails  1
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  491    
    
resultsets
nameresultset
 qPDF  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  555    
    
resultsets
nameresultset
 qDetails  1
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=14ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  555    
    
resultsets
nameresultset
 qPDF  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  498    
    
resultsets
nameresultset
 qDetails  1
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  498    
    
resultsets
nameresultset
 qPDF  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  545    
    
resultsets
nameresultset
 qDetails  1
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  545    
    
resultsets
nameresultset
 qPDF  1
sp_dataset_display (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\dataset_display.cfm @ 05:49:55.055
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  23    
 IN  CF_SQL_INTEGER  207    
    
resultsets
nameresultset
 qCtrySurvey  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 (34)
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)
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 (7)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-09-20 00:47:10
serverclockcheck=2024-09-04 20:02:17
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\methodology\survey\survey-display-207.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=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=http://preview.dhsprogram.com/methodology/survey/survey-display-207.cfm
HTTP_URL=/methodology/survey/survey-display-207.cfm
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\methodology\survey\survey-display-207.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.97
REMOTE_HOST=10.0.2.97
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/methodology/survey/survey-display-207.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=23FD45C3F526FD79FD9190A8F8ABEEA79DACBEE3
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=24
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=1418060296
cs_runningdashboardcmdcode=0
csrftoken=23FD45C3F526FD79FD9190A8F8ABEEA79DACBEE3
ctrl_data=Struct (62)
customcf_data=Struct (2)
customcfupfront=Query (2)
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 (42)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138,459,518
formattedtimestamp=2024-09-19 05:49:54
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1726724994681
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (2)
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 (85)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
parentisbasetemplate=0
parenttemplate=Struct (3)
previewmode=0
readmodewhereclause=(VersionState = 2)
rebuilt_stubs=
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-09-19 05:49:54.665
req_sequenceid=347721
req_startticks=1726724994665
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_286217941A8F1C830F8D65F7D252F914.cfusion
sessionstring=1_286217941A8F1C830F8D65F7D252F914.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=33
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-09-19 05:49:54'}
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=MYsXW98072w1hKIa6BHuuw==
SURVEYINFO_ACTIVE_DATE=2024-9-25
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=23FD45C3F526FD79FD9190A8F8ABEEA79DACBEE3
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=9088
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1726724994681
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=286217941A8F1C830F8D65F7D252F914.cfusion
sessionstring=1_286217941A8F1C830F8D65F7D252F914.cfusion
urltoken=CFID=8233263&CFTOKEN=bb95e295a18d2ebe-584BC64B-B37F-3367-117F4705E8FBD69E&jsessionid=286217941A8F1C830F8D65F7D252F914.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 31 ms