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 2021

Measurement Approaches for Effective Coverage Estimation

Effective coverage is increasingly being used to evaluate maternal and child health programs.

Topics: Child Health and Development, Health facilities/SPA surveys, Maternal Health

 

Aug 2021

Review of health facility referrals for severe malaria in DHS Program Surveys

This paper examines the severe malaria referral process for 188,686 children tested for malaria and anemia in 37 surveys across 19 countries in sub-Saharan Africa collected between 2011 and 2018.

Topics: Malaria

 

Aug 2021

Correlates of Secondary Infertility

The experience of infertility has social, economic, and psychological effects on women and their partners.

Topics: Fertility and Fertility Preferences

 

Aug 2021

Levels and Trends of Infertility and Childlessness

Infertility is a significant reproductive health issue for couples worldwide.

Topics:  --

 

Jul 2021

Comparing Ideal and Completed Family Size: A Focus on Women in Low-and Middle-income Countries with Unrealized Fertility

The study of fertility preferences in relation to the number of children is important for understanding the factors that contribute to fertility levels.

Topics: Fertility and Fertility Preferences, Wealth/Socioeconomics

 

Jul 2021

Young Women's Empowerment and Fertility Intentions

Fertility intentions among young women are important drivers of future fertility trends.

Topics: Family Planning, Youth

 

Sep 2020

Typologies and Trajectories: A Descriptive Study of Men's Reproductive Life Course

There is little research on the implications of family formation patterns for individual outcomes and life course trajectories of men.

Topics: Gender

 

Sep 2020

Household Wealth Relative to Community Wealth: Associations with Specific Asset Ownership and Maternal and Child Health Indicators

This report describes inequalities in asset ownership and maternal and child health indicator coverage in 11 countries, using the most recent Demographic and Health surveys from each country.

Topics: Child Health and Development, Maternal Health, Wealth/Socioeconomics

 

Sep 2020

Data Quality in Demographic and Health Surveys That Used Long and Short Questionnaires

Since the first phase of The DHS Program in 1984, DHS surveys have increased in scope and complexity as questionnaires are lengthened and survey modules are added.

Topics:  --

 

Sep 2020

Geospatial Covariates: Proxies for Mapping Urban-Related Indicators

The enumeration areas selected by The DHS Program are classified as either rural or urban.

Topics: Geographic Information

 


Debugging Information
ColdFusion Server Standard 2018,0,07,316715
Template /Research/index.cfm
Time Stamp 27-Nov-21 04:40 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 54.227.97.219
Host Name 54.227.97.219


Execution Time

Total Time Avg Time Count Template
774 ms 26 ms 30 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
759 ms 25 ms 30 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
625 ms 625 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
625 ms 625 ms 1 C:/inetpub/wwwroot/dhs/Research/index.cfm
424 ms 424 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
424 ms 424 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
424 ms 424 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
424 ms 424 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
424 ms 424 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
392 ms 392 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
377 ms 34 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
188 ms 188 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c1378-l70-t51-dAny.read
157 ms 79 ms 2 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
157 ms 79 ms 2 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
141 ms 141 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
109 ms 55 ms 2 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
94 ms 94 ms 1 C:/inetpub/wwwroot/commonspot/controls/customcf/cpe-customcf.cfm
93 ms 93 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
93 ms 93 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | getTemplatePageData(7) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
78 ms 78 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-stub.cfm
62 ms 31 ms 2 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
62 ms 62 ms 1 C:/inetpub/wwwroot/dhs/Research/customcf/analysis_main.cfm
47 ms 47 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19153-l70-t51-dAny.read
32 ms 16 ms 2 C:/inetpub/wwwroot/commonspot/utilities/write-stub.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:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19172-l70-t51-dAny.read
17 ms 17 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19154-l70-t51-dAny.read
17 ms 17 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19155-l70-t51-dAny.read
17 ms 17 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19174-l70-t51-dAny.read
17 ms 17 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19177-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19152-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/55/p148333-c19169-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/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 8 ms 2 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.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/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/livebookmarks.cfc | getTags(148333) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/Research/template-Research-and-Analysis-Template-2021.cfm
14 ms 14 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
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/handle-styles.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/upfront-generic.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.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-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 2 C:/inetpub/wwwroot/commonspot/style/load-page-classes.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 22 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 4 C:/inetpub/wwwroot/commonspot/utilities/item-visible.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-template-stub.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/template-1x1-Base.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(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 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 3 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 | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 1, 7, 2, 0, 0, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 55, 148333, 148330, 0, 0, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 55, 148333, 148330, 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(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 2 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 2 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 | InvalidateCachedTemplate(7) ] 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/custom-application-framework/handle-applications.cfc | executeFunction(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(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(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 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(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/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 148333) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 7) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/udf/database.cfc | getUDF(commonspot-site-dhs) ] from C:/inetpub/wwwroot/commonspot/udf/database.cfc
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
656 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 @ 04:40:50.050
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
GetPageRec (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\verify-stub-data.cfm @ 04:40:50.050
		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148333

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

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

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

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

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 04:40:50.050
					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 @ 04:40:50.050
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 148333

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

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

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

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

				
			 )
	
 ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 7
Parameter #4(CF_SQL_INTEGER) = 148333
Parameter #5(CF_SQL_INTEGER) = 148330
Parameter #6(CF_SQL_INTEGER) = 55
Parameter #7(CF_SQL_INTEGER) = 1
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 2
Parameter #10(CF_SQL_INTEGER) = 7
Parameter #11(CF_SQL_INTEGER) = 148330
Parameter #12(CF_SQL_INTEGER) = 1003

NamedClasses (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\style\load-page-classes.cfm @ 04:40:50.050
	SELECT *
	  FROM Data_ClassNames
	 WHERE (PageID IN (?,?,?,?,?)) 
		AND VersionState = ?
		AND OutputTypeID = 0
 ORDER BY PageID DESC, ControlID DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 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

StyleSheetGroups (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 04:40:50.050
		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 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

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

CheckCustomRender (Datasource=commonspot-site-dhs, Time=0ms, Records=15) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 04:40:50.050
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 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

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

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

CacheUpdate (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 04:40:50.050
					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_VARCHAR) = 2121-11-27 04:40:50
Parameter #3(CF_SQL_VARCHAR) = 2121-11-27 04:40:50
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 0
Parameter #6(CF_SQL_VARCHAR) =
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 2
Parameter #10(CF_SQL_INTEGER) = 0
Parameter #11(CF_SQL_INTEGER) = 0
Parameter #12(CF_SQL_INTEGER) = 0
Parameter #13(CF_SQL_INTEGER) = 0
Parameter #14(CF_SQL_INTEGER) = 0
Parameter #15(CF_SQL_VARCHAR) =
Parameter #16(CF_SQL_INTEGER) = 1
Parameter #17(CF_SQL_INTEGER) = 55
Parameter #18(CF_SQL_INTEGER) = 148333
Parameter #19(CF_SQL_INTEGER) = 0
Parameter #20(CF_SQL_INTEGER) = 2
Parameter #21(CF_SQL_INTEGER) = 0

CacheInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=26) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 04:40:50.050
			SELECT *
			  FROM ElementInstance
			 WHERE SubsiteID=?
				AND PageID=?
				AND IsWIP=? 
				AND ServerID=? 
		 ORDER BY ControlID DESC,CacheLevel
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 7
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1

TemplateInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\template-cache.cfc @ 04:40:50.050
					SELECT SubsiteID,Filename
					  FROM SitePages
					 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7

GetPageRec (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\verify-stub-data.cfm @ 04:40:50.050
		SELECT *
		  FROM SitePages
		 WHERE ID=?
			AND AudienceID=0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7

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

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

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

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 04:40:50.050
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
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 @ 04:40:50.050
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2,8,6,3,11,14,15))
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7

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

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

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

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

				
			 )
	
 ORDER BY PageID DESC, FormControl.ID, FormInputControl.ID
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 7
Parameter #4(CF_SQL_INTEGER) = 1
Parameter #5(CF_SQL_INTEGER) = 1
Parameter #6(CF_SQL_INTEGER) = 2
Parameter #7(CF_SQL_INTEGER) = 7
Parameter #8(CF_SQL_INTEGER) = 1

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

StyleSheetGroups (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 04:40:50.050
		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 7
Parameter #4(CF_SQL_INTEGER) = 2

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

CheckCustomRender (Datasource=commonspot-site-dhs, Time=0ms, Records=14) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 04:40:50.050
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 7
Parameter #4(CF_SQL_INTEGER) = 2

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

RestrictedSecurity (Datasource=commonspot-site-dhs, Time=15ms, Records=22) in C:\inetpub\wwwroot\commonspot\components\cache\template-cache.cfc @ 04:40:50.050
				SELECT ControlID, max(pAuthor) AS maxAuthor, max(pDesign) AS maxDesign, max(pStyle) AS maxStyle, max(pAdmin) AS maxAdmin
				  FROM RestrictedSecurity
				 WHERE (PageID IN (?,?,?)) 
			 GROUP BY ControlID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1
Parameter #2(CF_SQL_INTEGER) = 2
Parameter #3(CF_SQL_INTEGER) = 7

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=0ms, Records=15) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 04:40:50.050
		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 @ 04:40:50.050
			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 @ 04:40:50.050
					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 @ 04:40:50.050
		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 @ 04:40:50.050
		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

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=63) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 04:40:50.050
		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 @ 04:40:50.050
		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 @ 04:40:50.050
	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 @ 04:40:50.050
		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 @ 04:40:50.050
		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 @ 04:40:50.050
		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

qPubs_analysis (Datasource=dhs_legacy_live, Time=0ms, Records=255) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
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=21) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
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=3) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2197 
qTopicList (Datasource=, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	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 @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2195 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	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 @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2196 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2193 
qTopicList (Datasource=, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	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 @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2189 
qTopicList (Datasource=, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=16ms, Records=2) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2191 
qTopicList (Datasource=, Time=0ms, Records=2) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	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 @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2143 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2142 
qTopicList (Datasource=, Time=0ms, Records=3) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT topic_id, pub_topic_name
	FROM qGetTopicList
	ORDER by pub_topic_name
	
qGetTopicList (Datasource=dhs_legacy_live, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2152 
qTopicList (Datasource=, Time=0ms, Records=0) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	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 @ 04:40:50.050
	SELECT * FROM pub_topics pt, pub_topics_lnk pl
	WHERE pl.topic_id = pt. pub_topic_id
	AND pl.pub_id= 2144 
qTopicList (Datasource=, Time=0ms, Records=1) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
	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 @ 04:40:50.050
		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 @ 04:40:50.050
		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 @ 04:40:50.050
		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

CacheUpdate (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 04:40:50.050
					UPDATE ElementInstance
						SET CacheFormat=?,
							 CacheValidUntil=?,
							 ContentValidUntil=?,
							 DataPageID=?,
							 DependentObjectID=?,
							 DynamicStatus=?,
							 HasChildren=?,
							 HasData=?,
							 HasDynamicContent=?,
							 IndexStatus=?,
							 IsDeviceDependent=?,
							 ParamPageID=?,
							 PrintStatus=?,
							 ShareStatus=?,
							 ConflictList=?
					 WHERE ServerID=?
						AND SubsiteID=?
						AND PageID=?
						AND ControlID=?
						AND CacheLevel=?
						AND IsWIP=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_VARCHAR) = 2121-11-27 04:40:50
Parameter #3(CF_SQL_VARCHAR) = 2121-11-27 04:40:50
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 0
Parameter #6(CF_SQL_VARCHAR) =
Parameter #7(CF_SQL_INTEGER) = 0
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 2
Parameter #10(CF_SQL_INTEGER) = 0
Parameter #11(CF_SQL_INTEGER) = 0
Parameter #12(CF_SQL_INTEGER) = 0
Parameter #13(CF_SQL_INTEGER) = 0
Parameter #14(CF_SQL_INTEGER) = 0
Parameter #15(CF_SQL_VARCHAR) =
Parameter #16(CF_SQL_INTEGER) = 1
Parameter #17(CF_SQL_INTEGER) = 1
Parameter #18(CF_SQL_INTEGER) = 7
Parameter #19(CF_SQL_INTEGER) = 0
Parameter #20(CF_SQL_INTEGER) = 2
Parameter #21(CF_SQL_INTEGER) = 0


Stored Procedures

usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=0ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2197    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2195    
    
resultsets
nameresultset
 qGetPubsDetails  1
 qGetTopicList_zzz  2
usp_get_Pub_PDF (Datasource=dhs_legacy_live, Time=16ms) in C:\inetpub\wwwroot\dhs\Research\customcf\analysis_main.cfm @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2196    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2193    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2189    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2191    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2143    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2142    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2152    
    
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 @ 04:40:50.050
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_numeric  2144    
    
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
adf=Struct (88)
adfscheduler=Struct (0)
applicationname=site1
blogcache=Struct (4)
cachedimages=Struct (20)
cacheinfocache=Struct (51)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=6
covid_newsarticlecount=24
covid_pressreleasecount=4
covid_pubcount=2
cs_element_cache=Struct (0)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerscope=Struct (18)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (3)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2021-11-28 03:10:48
search_orphan_next_clean=2021-11-28 03:10:48
serverstatus=Struct (1)
site=Struct (71)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
taxonomy=Struct (2)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
CERT_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\Research\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
HTTPS_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/Research/index.cfm
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\Research\index.cfm
QUERY_STRING=
REMOTE_ADDR=54.227.97.219
REMOTE_HOST=54.227.97.219
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Research/index.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=1875849
CFTOKEN=52f8c109c60ceabf-BCF54F2D-DB52-86D1-98F48B92E74B8905
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
autologinhandled=0
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 (124)
cs_includedobjects=nwjs
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_runningdashboardcmdcode=0
ctrl_data=Struct (63)
customcf_data=Struct (2)
customcfupfront=Query (1)
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (41)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138
formattedtimestamp=2021-11-27 04:40:50
getghost=
hivbold=1,3,8,9
ignoreauthuser=0
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1637988050334
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (1)
modeorderbyclause=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (85)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
parentisbasetemplate=0
parenttemplate=Struct (3)
previewmode=0
readmodewhereclause=(VersionState = 2)
rebuilt_stubs=
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (72)
req_cam_callcount=1
req_inittimestamp=2021-11-27 04:40:50.334
req_sequenceid=58382
req_startticks=1637988050334
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_2C9DC4BD4DABD73EED95C5C70CF0ED98.cfusion
sessionstring=1_2C9DC4BD4DABD73EED95C5C70CF0ED98.cfusion
sicupfront=
sicupfrontparam=
site=Struct (71)
siteid=1
standardrenderhandlers=
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
subsiteid=55
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (3)
templaterootdir=/
timestamp={ts '2021-11-27 04:40:50'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (27)
usersdatasource=commonspot-users
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (40)
EMAILALERTKEY=LZIA60f/S/A4a/iAH17Viw==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=148333
debugmode=0
debugstate=Struct (1)
editmode=0
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1637988050334
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=2C9DC4BD4DABD73EED95C5C70CF0ED98.cfusion
urltoken=CFID=1875849&CFTOKEN=52f8c109c60ceabf-BCF54F2D-DB52-86D1-98F48B92E74B8905&jsessionid=2C9DC4BD4DABD73EED95C5C70CF0ED98.cfusion
usagelist=
user=Struct (27)
Debug Rendering Time: 31 ms