Journal Articles

Search our database of 1000's of peer-reviewed journal articles that feature DHS data.

Search Journals

Featured Studies

Featured research topics go beyond a single research paper and often include multiple publications and user-friendly summaries and dissemination materials.

Learn More

The DHS Fellows Program

Researchers in DHS countries work with DHS analysts to design, analyze, and write a publishable paper.

Learn More

DHS Analysis Blogs

Read  more about our recent research, innovative methods, and success stories.

Go to DHS Blogs

Research and Further Analysis

DHS training

The DHS Program's in-house Research and Analysis team conducts rigorous, timely, and innovative mixed-methods research on topics related to global public health, demography, and social epidemiology. Our team also trains, mentors, and closely collaborates with fellow researchers and stakeholders who are driven to utilize DHS Program surveys and other survey data to inform programs and policies in various countries and contexts.

Visit the publications search for a full list of publications.  Also, go to the  journal articles search for a full list of published journal artilcles that feature The DHS Program data.

DHS Research Reports

Aug 2017

Assessing the Impact of Imperfect Immunoassays on HIV Prevalence Estimates from Surveys Conducted by The DHS Program

The DHS Program has supported the conduct of numerous large-scale HIV seroprevalence surveys.

Topics: HIV/AIDS

 

Aug 2017

Hemoglobin Data in DHS Surveys: Intrinsic Variation and Measurement Error

The accurate estimation of anemia is important for tracking and targeting public health interventions.

Topics: Anemia, Child Health and Development, Maternal Health, Nutrition

 

Aug 2017

A Comparison of Summary Measures of Quality of Service and Quality of Care for Family Planning in Haiti, Malawi, and Tanzania

Researchers generally agree on a framework of domains and indicators of quality of care in family planning, although there is less consensus on methodological approaches for creating summary measures.

Topics: Family Planning

 

Jul 2017

Women's Marital Status, Contraceptive Use, and Unmet Need in Sub-Saharan Africa, Latin America, and the Caribbean

This comparative report analyzes contraceptive use and unmet need for family planning among sexually active women age 15-49 in 21 countries of sub-Saharan Africa, Latin America, and the Caribbean.

Topics: Family Planning, Household and Respondent Characteristics

 

Aug 2016

Factors Associated with Prior Testing among HIV-Positive Adults in Sub-Saharan Africa

With evidence on the benefits of the early diagnosis of HIV and the initiation of antiretroviral therapy (ART) mounting, HIV testing is a primary entry point for the prevention of HIV transmission.

Topics: HIV/AIDS

 

Aug 2016

Levels and Trends in Newborn Care Service Availability and Readiness in Bangladesh, Haiti, Malawi, Senegal, and Tanzania

This study examines levels and trends in two dimensions of newborn care quality—service availability and service readiness—in Bangladesh, Haiti, Malawi, Senegal, and Tanzania, the five USAID maternal and child health (MCH) priority countries with Service Provision Assessment (SPA) surveys conducted since 2011.

Topics: Infant and Child Mortality

 

Aug 2016

Levels and Trends in Maternal and Child Health Disparities by Wealth and Region in Eleven Countries with DHS Surveys

This report describes recent levels and trends in 11 maternal and child health (MCH) indicators in 11 countries, using the two most recent DHS surveys from each country.

Topics: Child Health and Development, Family Planning, Maternal Health, Nutrition, Wealth/Socioeconomics

 

Aug 2016

Urban Child Poverty, Health, and Survival in Low- and Middle-Income Countries

This report examines levels and trends in poverty, health status, and use of health services among children under age 5 living in large cities in low- and middle-income countries, and compares their health status and use of services to those of their other urban, rural, and non-poor counterparts.

Topics: Child Health and Development, Infant and Child Mortality, Nutrition, Wealth/Socioeconomics

 

Aug 2016

Guidance for Use of The DHS Program Modeled Map Surfaces

Improved understanding of geographic variation and inequity in health status, wealth, and access to resources within countries is central to meeting sustainable development goals.

Topics: Geographic Information

 

Aug 2016

Geospatial Modeling of Child Mortality across 27 Countries in Sub-Saharan Africa

Preventable mortality of children has been targeted as one of the UN’s Sustainable Development Goals for the 2015-30 period.

Topics: Geographic Information, Infant and Child Mortality

 


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /research/index.cfm
Time Stamp 03-Jul-24 04:22 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.0.0.149
Host Name 10.0.0.149


Execution Time

Total Time Avg Time Count Template
330 ms 11 ms 30 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
314 ms 10 ms 30 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
250 ms 250 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
250 ms 250 ms 1 top level C:\inetpub\wwwroot\dhs\research\index.cfm
219 ms 219 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
219 ms 219 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
204 ms 204 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
204 ms 204 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
204 ms 204 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
188 ms 17 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
188 ms 188 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
110 ms 110 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c1378-l70-t51-dAny.read
94 ms 94 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
94 ms 94 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/dhs/Research/customcf/analysis_main.cfm
32 ms 16 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(148333, 148339) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c1432-l70-t51-dAny.read
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19153-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/site-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/research/Application.cfm
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/55/p148333-c19152-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19154-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19155-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-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/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/core-application-meat.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/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/upfront-ghost-queries.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 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 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 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms 0 ms 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(148330) ] 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(148333) ] 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(7) ] 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 5 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(1, 1, 0, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(1, 55, 0, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 4 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(148330, 55, 7, 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(148333, 55, 148330, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(7, 1, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(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(55) ] 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, 55) ] 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(148333) ] 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(55) ] 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 4 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(1) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(148330) ] 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-Research-and-Analysis-Template-2021.cfm, 148330, 55) ] 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(148330) ] 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(7) ] 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=55)) ] 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/visitor-context-rule-actions.cfc | onPageVisit(148333, 55) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 26) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(148333) ] 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
266 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 @ 16:22:13.013
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=1996) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 16:22:13.013
		SELECT dcr.*
		  FROM Data_Custom_Render dcr, CustomElementModules cem
		 WHERE (dcr.PageID IN (?,?,?,?,?)) 
			AND dcr.VersionState=?
			AND (dcr.ModuleID = cem.ID OR dcr.ModuleID <= 0)
	 ORDER BY dcr.ControlID, dcr.PageID DESC, dcr.VersionID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 7
Parameter #4(CF_SQL_INTEGER) = 148333
Parameter #5(CF_SQL_INTEGER) = 148330
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 @ 16:22:13.013
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=148333 OR (PageID IN (148330,7,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 @ 16:22:13.013
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148333

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

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

Request.GetGhost (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\upfront-ghost-queries.cfm @ 16:22:13.013
	SELECT *
	  FROM Data_Ghost_Common
	 WHERE (PageID=148333 OR (PageID IN (148330,7,2,1) AND (VersionState = 2)))
	ORDER BY ControlID, PageID DESC
ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=63) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 16:22:13.013
		SELECT ControlID, ControlName, ControlType, ParentControlID, ParentControlType, pageID
		  FROM ControlInstance
		 WHERE (PageID IN (?,?,?,?,?)) 
	 ORDER BY ControlID, PageID DESC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 7
Parameter #4(CF_SQL_INTEGER) = 148333
Parameter #5(CF_SQL_INTEGER) = 148330

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

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

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

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

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

qPubs_analysis (Datasource=dhs_legacy_live, Time=15ms, Records=270) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
SELECT c.Pub_ID,
   c.Pub_code,
   c.Ctry_List,
   c.Lang_List,
   c.Print_Date,
   c.Title,
   t.Pub_Type_ID,
   t.Pub_Type_Name, release_date, abstract as abstract_text,
    (SELECT ctry_name
    	FROM Ctry, survey
    	WHERE ctry.ctry_id = survey.ctry_id
   		and survey.survey_id=c.survey_id ) AS ctry_name
FROM Pub_Catalog c
   INNER JOIN Pub_Type t ON t.Pub_Type_ID = c.Pub_Type_ID
WHERE Pub_Code <> 'NA'
  AND c.Stts_ID = 3
  AND t.pub_type_id IN (15,16,18,6,45,9)
  
ORDER BY Print_Date DESC
qPubsTopics (Datasource=dhs_legacy_live, Time=0ms, Records=24) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
SELECT * FROM pub_Topics t
where active_flag = 1
  and pub_topic_id IN (select topic_id FROM pub_topics_lnk k, pub_catalog c where c.pub_id = k.pub_id and c.pub_type_id IN (15,16,18,6,45,9))
order by pub_topic_name
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1804 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1802 
qTopicList (Datasource=, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1803 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1795 
qTopicList (Datasource=, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1670 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1672 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=5) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1673 
qTopicList (Datasource=, Time=0ms, Records=5) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=16ms, Records=4) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1676 
qTopicList (Datasource=, Time=0ms, Records=4) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1685 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 1684 
qTopicList (Datasource=, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 16:22:13.013
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148333

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 16:22:13.013
		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 @ 16:22:13.013
		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_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1804    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1802    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1803    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1795    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1670    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1672    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1673    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1676    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1685    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 16:22:13.013
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  1684    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2


Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,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-04 14:21:54
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\research\index.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_URL=/research/index.cfm?pub_topic_id=0&startrow=61&yr=0
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\research\index.cfm
QUERY_STRING=pub_topic_id=0&startrow=61&yr=0
REMOTE_ADDR=10.0.0.149
REMOTE_HOST=10.0.0.149
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/research/index.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=D37E3A93EC971CC0DE4B5C329D592728C8E3E362
Form Fields:
TOPICID=0
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=26
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=2545043224
cs_runningdashboardcmdcode=0
csrftoken=D37E3A93EC971CC0DE4B5C329D592728C8E3E362
ctrl_data=Struct (63)
customcf_data=Struct (2)
customcfupfront=Query (1)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
data_ghost=Struct (0)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (42)
elementrundetail=Struct (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 16:22:13
getghost=Query (0)
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1720023733621
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (7)
params_formfields=
params_urlfields=pub_topic_id,startrow,yr
previewmode=0
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 16:22:13.621
req_sequenceid=83583
req_startticks=1720023733621
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_1374FD0BE72FA241DC43ADB5C8D2791C.cfusion
sessionstring=1_1374FD0BE72FA241DC43ADB5C8D2791C.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=55
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (3)
templaterootdir=/
timestamp={ts '2024-07-03 16:22:13'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (30)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (44)
EMAILALERTKEY=BSu0cRa8xSWdSrClnnGvpA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=D37E3A93EC971CC0DE4B5C329D592728C8E3E362
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=148333
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1720023733621
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=1374FD0BE72FA241DC43ADB5C8D2791C.cfusion
sessionstring=1_1374FD0BE72FA241DC43ADB5C8D2791C.cfusion
urltoken=CFID=2361431&CFTOKEN=c726a00e8d18a69d-BE08EC40-0160-99A0-FBDE595E92BCC791&jsessionid=1374FD0BE72FA241DC43ADB5C8D2791C.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
URL Parameters:
pub_topic_id=0
startrow=61
yr=0
Debug Rendering Time: 31 ms