Survey Summary

<<< Back to Dataset Account
Pakistan: Standard DHS, 2012-13
DHS Final Reports
Summary Reports/Key Findings
Other Dissemination Materials
General Fact Sheets
Survey Presentations
In The News:
In The News:
In The News:
-- show all items --
Survey Datasets
Data Available
HIV Testing
Not Collected
GPS Datasets
Not Distributed
SPA Datasets
Not Applicable
Country: Pakistan
Contract Phase: DHS-VI
Recode Structure: DHS-VI
Implementing Organization: National Institute of Population Studies (NIPS)
Fieldwork: October 2012 - April 2013
Status: Completed
Respondents  
Households: Sample Size: 12943
Female: Ever Married Women
Age: 15 to 49
Sample Size: 13558
Male: Ever Married Men
Age: 15 to 49
Sample Size: 3134
Facilities: N/A
Survey Characteristics
  • Abortion ‹Questions asking women about pregnancies that ended in an abortion. Includes pregnancy histories where abortion is mentioned as an outcome or when a question such as "Did you or someone else do something to end this pregnancy?" is used.
  • Alcohol consumption ‹Questions asking about the consumption of alcoholic beverages. Can be asked of women and/or men.
  • Anthropometry
  • Birth registration ‹A question on birth registration asked about each household member under the age of 5 years.
  • CAFÉ survey ‹Computer Assisted Field Editing. Interviews conducted on paper and entered into a laptop or tablet in the field for verification.
  • Calendar ‹The DHS calendar is a month by month history of certain key reproductive and contraceptive key events in the life of the woman respondent for the 5 years preceding the interview.
  • Cooking fuel ‹A question asking the household respondent about the type of cooking fuel used by the household. These are included as part of the core questionnaire.
  • Domestic violence ‹A set of questions on lifetime experience of domestic violence. Typically asked of women only but in some surveys asked of men.
  • GPS/georeferenced ‹Surveys with latitude and longitude coordinates for survey clusters. Note that cluster coordinates are randomly displaced to protect the privacy of respondents.
  • HIV behavior ‹Questions asking individuals about behavioral risk factors related to the transmission of HIV. Can be asked of women and/or men. These are included as part of the core questionnaire.
  • HIV knowledge ‹Questions asking individuals about their knowledge about HIV. Can be asked of women and/or men. These are included as part of the core questionnaire.
  • Malaria questions ‹Questions asking women about anti-malarial medication received during pregnancy and anti-malarial medication given to young children, as well as questions asking household respondents about household mosquito net ownership and use.
  • Men's survey ‹Surveys that include men in addition to women as individual respondents.
  • Micronutrients ‹Questions asking which foods and drinks were consumed by children in the 24 hours prior to the survey.
  • Migration ‹Questions asking individuals about their prior residences if they have moved since birth. Can be asked of women and/or men.
  • Paper survey ‹Interviews conducted with paper questionnaires which are later entered into a computer at a central office.
  • Pregnancy history ‹A full enumeration of all pregnancies to women interviewed as opposed to a birth history which only includes live births.
  • Social marketing ‹Questions asking individuals about the brands of condoms and pills used by respondents to identify the social marketing brands used in the country. Condom brands can be asked of women and/or men.
  • Tobacco use ‹Questions asking individuals about the consumption of smoked and smokeless tobacco products. Can be asked of women and/or men.
  • Tuberculosis questions ‹Questions asking individuals about their knowledge and attitudes about tuberculosis. Can be asked of women and/or men.
  • Vitamin A questions ‹Questions on whether a child received a vitamin A dose recently, or whether the mother received a dose after a delivery. These are included as part of the core questionnaire.
  • Women's status ‹Questions asking individuals about decision-making, ownership of house/land, use of banks, and other related questions. Can be asked of women and/or men. These are included as part of the core questionnaire.

Footnotes:
A couples dataset could not be generated since the household line number of the wife/partner (used to create variable MV034 and to link the man with his wife/partner) was not recorded in the Man’s Questionnaire.


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /methodology/survey/survey-display-419.cfm
Time Stamp 03-Jul-24 01:28 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.129
Host Name 10.0.2.129


Execution Time

Total Time Avg Time Count Template
816 ms 31 ms 26 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
816 ms 31 ms 26 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
578 ms 578 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
578 ms 578 ms 1 C:/inetpub/wwwroot/dhs/methodology/survey/survey-display-419.cfm
531 ms 531 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
469 ms 469 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
469 ms 469 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
469 ms 469 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
469 ms 469 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
453 ms 45 ms 10 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
453 ms 453 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
173 ms 173 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c1378-l70-t51-dAny.read
157 ms 157 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
110 ms 110 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
63 ms 63 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/p16964-c19154-l70-t51-dAny.read
47 ms 47 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c19155-l70-t51-dAny.read
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
33 ms 17 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(16964, 8772) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
32 ms 32 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c19152-l70-t51-dAny.read
32 ms 32 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c19153-l70-t51-dAny.read
17 ms 9 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(16964) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c1432-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c19174-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/render-head.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.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/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/methodology/survey/Application.cfm
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 | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/33/p16964-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-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
0 ms 0 ms 4 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/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/dataset_display.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/customcf/legacy/survey/survey_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 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(16964, 33, 8770, 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(3901, 19, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(8770, 33, 3901, 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, 16964, 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(16964) ] 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/cache/template-cache.cfc | getTemplatePageData(8770) ] 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(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(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/visitor-context-rule-actions.cfc | onPageVisit(16964, 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/livebookmarks.cfc | getTags(16964) ] 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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
594 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=15ms, Records=2059) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 01:28:24.024
		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) = 16964
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 @ 01:28:24.024
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=16964 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 @ 01:28:24.024
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16964

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

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

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=76) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 01:28:24.024
		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) = 16964
Parameter #5(CF_SQL_INTEGER) = 3901

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 01:28:24.024
		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 @ 01:28:24.024
	SELECT *
	  FROM Data_CustomCF
	 WHERE (PageID=16964 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 @ 01:28:24.024
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16964

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:28:24.024
		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 @ 01:28:24.024
		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 @ 01:28:24.024
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:28:24.024
		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=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\survey_qry.cfm @ 01:28:24.024
    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) = 419

qMetaDataFeatures (Datasource=dhs_legacy_live, Time=0ms, Records=22) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\survey_qry.cfm @ 01:28:24.024
    SELECT DISTINCT l.Mod_Feat_ID, m.Mod_Feat_Name, m.Mod_Feat_Type, m.Mod_Feat_Desc
    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
    ORDER BY Mod_Feat_Name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 419

publicationMetaData (Datasource=commonspot-site-dhs, Time=15ms, Records=624) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
    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 @ 01:28:24.024
        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 = 27862
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 23626
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 23433
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 23270
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 23211
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 23094
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 22888
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 21696
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 21431
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 20763
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19508
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19499
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19123
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19126
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19036
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19033
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19030
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19027
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19018
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 18881
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19024
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19021
		and p.subsiteid = 18  
        
qPressMetaData (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
        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 = 19015
		and p.subsiteid = 18  
        
qCtryName (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\dataset_display.cfm @ 01:28:24.024
SELECT Ctry_Name, Ctry_Code
FROM Ctry
WHERE Ctry_ID =? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 31

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 01:28:24.024
		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 @ 01:28:24.024
		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 @ 01:28:24.024
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2

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


Stored Procedures

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

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_integer  419    
    
resultsets
nameresultset
 qPubDsp  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1370    
    
resultsets
nameresultset
 qDetails  1
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1370    
    
resultsets
nameresultset
 qPDF  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1371    
    
resultsets
nameresultset
 qDetails  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1373    
    
resultsets
nameresultset
 qDetails  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1372    
    
resultsets
nameresultset
 qDetails  1
sp_pubs_details (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\summary_page.cfm @ 01:28:24.024
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1397    
    
resultsets
nameresultset
 qDetails  1
sp_dataset_display (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\customcf\legacy\survey\dataset_display.cfm @ 01:28:24.024
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  31    
 IN  CF_SQL_INTEGER  419    
    
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 (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\methodology\survey\survey-display-419.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=JSESSIONID=C6E211724F8C38274B1693B923FE5143.cfusion; CSRFTOKEN=331503F0F5A1D8662AE577D673B9FFE3FA0E969E
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=http://preview.dhsprogram.com/methodology/survey/survey-display-419.cfm
HTTP_URL=/methodology/survey/survey-display-419.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-419.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.129
REMOTE_HOST=10.0.2.129
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/methodology/survey/survey-display-419.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=331503F0F5A1D8662AE577D673B9FFE3FA0E969E
JSESSIONID=C6E211724F8C38274B1693B923FE5143.cfusion
Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=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=3152499184
cs_runningdashboardcmdcode=0
csrftoken=331503F0F5A1D8662AE577D673B9FFE3FA0E969E
ctrl_data=Struct (64)
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-07-03 01:28:24
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719970104454
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-03 01:28:24.454
req_sequenceid=56908
req_startticks=1719970104454
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_C6E211724F8C38274B1693B923FE5143.cfusion
sessionstring=1_C6E211724F8C38274B1693B923FE5143.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-07-03 01:28:24'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (31)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=331503F0F5A1D8662AE577D673B9FFE3FA0E969E
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=16964
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719970098861
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=C6E211724F8C38274B1693B923FE5143.cfusion
sessionstring=1_C6E211724F8C38274B1693B923FE5143.cfusion
urltoken=CFID=2272857&CFTOKEN=6eeb95c24d20b560-9E11C302-0FD9-EC20-E1591916A25318E4&jsessionid=C6E211724F8C38274B1693B923FE5143.cfusion
usagelist=
user=Struct (31)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 31 ms