GIS

Geographic Information Systems (GIS) GPS Clusters

Geographic location affects peoples' health, nutrition, and access to health care services. The DHS Program can now analyze the impact of location using DHS data and geographic information systems (GIS). These spatial analyses improve our understanding of how location affects health status, leading to more effective interventions.

The DHS Program routinely collects geographic information in all surveyed countries. Using GIS, researchers can link DHS data with routine health data, health facility locations, local infrastructure such as roads and rivers, and environmental conditions. Linked DHS and geographic data are now being used to improve planning for family planning interventions, to assess the correlation of malaria prevalence and anemia in children in West Africa, and to analyze the effects of environment on early childhood mortality.

GIS Data at Work

Linked DHS and geographic data are now being used to meet a large variety of public health needs, including planning for HIV/AIDS and family planning programs and analysis of the effects of environment on early childhood mortality.

Resources


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /Methodology/GIS.cfm
Time Stamp 02-Jul-24 11:18 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.2.129
Host Name 10.0.2.129


Execution Time

Total Time Avg Time Count Template
2718 ms 78 ms 35 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
2718 ms 78 ms 35 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
1125 ms 1125 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
1125 ms 1125 ms 1 C:/inetpub/wwwroot/dhs/Methodology/GIS.cfm
1062 ms 1062 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
1062 ms 1062 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
1062 ms 1062 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
1062 ms 1062 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
1062 ms 1062 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
1047 ms 95 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
1047 ms 1047 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
641 ms 641 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c1378-l70-t51-dAny.read
610 ms 610 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c16579-l70-t51-dAny.read
532 ms 532 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
516 ms 516 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/cpe-custom.cfm
171 ms 29 ms 6 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getFieldMappings(moduleID = 27367, elementID = 27356) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
156 ms 156 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c1433-l70-t51-dAny.read
125 ms 125 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c16587-l70-t51-dAny.read
123 ms 9 ms 13 C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock-generic-rh.cfm
108 ms 8 ms 13 CFC[ C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc | loadResources() ] from C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc
93 ms 16 ms 6 C:/inetpub/wwwroot/commonspot/utilities/resolve-image-url.cfm
62 ms 10 ms 6 C:/inetpub/wwwroot/commonspot/utilities/explicit-module-cfinclude.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
32 ms 16 ms 2 C:/inetpub/wwwroot/commonspot/utilities/ct-extract-wddx-data.cfm
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19152-l70-t51-dAny.read
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19153-l70-t51-dAny.read
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19154-l70-t51-dAny.read
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19155-l70-t51-dAny.read
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/get-params.cfm
30 ms 5 ms 6 C:/inetpub/wwwroot/commonspot/utilities/module-cfinclude-execute.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/get-data.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
16 ms 1 ms 16 C:/inetpub/wwwroot/commonspot/utilities/ct-decipher-linkurl.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/ct-limit-inheritance.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/Methodology/Application.cfm
16 ms 8 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(16578, 48939) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 27356) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
16 ms 1 ms 18 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | isWebPRenderingEnabled(1) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(26405) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(26461) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(27074) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19177-l70-t51-dAny.read
15 ms 15 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c49469-l70-t27356-dAny.read
15 ms 8 ms 2 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load_core.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
15 ms 0 ms 121 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | getImageFileName(baseFileName = STATcompiler_2.jpg, width = 0, id = 1, height = 0) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(25605) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(27075) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc | getAndRenderItems([complex value], [complex value]) ] from C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c1432-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19169-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19172-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c19174-l70-t51-dAny.read
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/19/p16578-c49455-l70-t27356-dAny.read
0 ms 0 ms 1 C:/inetpub/wwwroot/ADF/core/load_site_adf.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/ct-get-inheritance.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/custom/custom-pre-render.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/escape-data.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/tags/get-mask-collection.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/controls/default-mode.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/pageindex/cache-query-instance.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/cache-query.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/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/security/security-page.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 3 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/get-image-given-pageid.cfm
0 ms 0 ms 10 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 2 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 CFC[ C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc | INIT() ] from C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc | addParam(cfsqltype = cf_sql_varchar, value = csw imagetextblock, name = FormName) ] from C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc | execute() ] from C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc
0 ms 0 ms 1 CFC[ C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc | setAttributes(mdCheckQry = [complex value]) ] from C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc
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(16578) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(3901) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(16578, 19, 3901, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(3901, 19, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 19, 16578, 3901, 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(19) ] 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, 19) ] 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(16578) ] 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(19) ] from C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | GetTemplatePageData(3901) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(template-what-we-do-temp-new.cfm, 3901, 19) ] 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 6 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/Methodology/override-imagerender.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 6 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/override-imagerender.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 | 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 6 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/ColdFusion2018/cfusion/wwwroot, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/Methodology/images/GISTraining2.jpg, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/Methodology/images/GPSDataCollection_2.jpg, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/Methodology/images/Geographic-Data-Analyis_thumbnail_1.jpg, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/Methodology/images/STATcompiler_2.jpg, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/Methodology/images/covariates_thumbail.jpg, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/Methodology/images/rounded-Spatial-webpage_thumbnail.jpg, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 6 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock-generic-rh.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(RequestTimeout check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Server-level remote requests checked) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Subsite context updated (ID=19)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(customerScope object initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Cache) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 7 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 12 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(ImageGallery) ] 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 8 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(image) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 6 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(imageGallery) ] 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(16578, 19) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | getImageFileName(baseFileName = GISTraining2.jpg, width = 0, id = 1, height = 0) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | getImageFileName(baseFileName = GPSDataCollection_2.jpg, width = 0, id = 1, height = 0) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | getImageFileName(baseFileName = Geographic-Data-Analyis_thumbnail_1.jpg, width = 0, id = 1, height = 0) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | getImageFileName(baseFileName = covariates_thumbail.jpg, width = 0, id = 1, height = 0) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | getImageFileName(baseFileName = rounded-Spatial-webpage_thumbnail.jpg, width = 0, id = 1, height = 0) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(27073) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(16578) ] 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 0 ms 6 CFC[ C:/inetpub/wwwroot/commonspot/udf/tag.cfc | anyTag(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/udf/tag.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc | hasProperties([complex value]) ] from C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc | loadProperties([complex value], [complex value]) ] from C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock.cfc
15 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1156 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=2365) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 23:18:49.049
		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) = 16578
Parameter #4(CF_SQL_INTEGER) = 3901
Parameter #5(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 23:18:49.049
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=16578 OR (PageID IN (3901,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		
qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 23:18:49.049
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16578

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

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

ControlInstanceData (Datasource=commonspot-site-dhs, Time=0ms, Records=96) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 23:18:49.049
		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) = 16578
Parameter #4(CF_SQL_INTEGER) = 3901

qInfo (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:18:49.049
		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) = 27356

getForms (Datasource=commonspot-site-dhs, Time=0ms, Records=37) in C:\inetpub\wwwroot\commonspot\metadata\tags\form_control\load_core.cfm @ 23:18:49.049
		SELECT d1.ID,
				 d1.FormName,
				 d1.Method,
				 d1.Action,
				 d1.JSHandler,
				 d1.DateCreated,
				 d1.DateLastModified,
				 d1.Params,
				 d1.ViewerPageID,
				 d1.OwnerID,
			
				 d4.ClassConstant as Class,
				 CASE
				 	WHEN d1.action = 'custom_form_element' THEN 1  
					ELSE d4.ClassID
				 END AS ClassID,
			
				 d2.ID as inputID,
				 d2.fieldName,
				 cft.ID as custFldType_ID,
				 cft.CSDataType AS custFldType_DataType,
				 cft.FilterModule as custFldType_FilterModule,
				 d2.shared,
				 d3.formID,
				 d3.itemPos,
				 d3.TabID,
				 d5.TabDisplayName,
				 d5.TabSortName,
				 d2.type as inputType,
				 d2.params as inputParams,
				 d2.OverrideParams as inputOverrideParams,
				 d2.dateCreated as inputCreated,
				 d2.description,
				 d2.dateLastModified as inputLastModified
		  FROM formControl d1
	
		INNER JOIN formControlMap d4 ON d1.ID = d4.formID
	
		INNER JOIN formInputControlMap d3 ON d1.ID = d3.formID
		INNER JOIN FormControlTabs d5 ON d5.ID = d3.TabID
		INNER JOIN formInputControl d2 ON d3.fieldID = d2.ID
		LEFT OUTER JOIN CustomFieldTypes cft ON d2.type = cft.type
		 WHERE (1=1)
	AND d4.classConstant = 7 AND d4.classID = 27367 ORDER BY d1.id, d2.id 
FormData (Datasource=commonspot-site-dhs, Time=0ms, Records=37) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 23:18:49.049
			SELECT Data_FieldValue.PageID, Data_FieldValue.FieldValue,FormInputControl.FieldName,FormControl.FormName,FormControl.ID AS FormControlID, FormInputControl.ID AS ficID,Data_FieldValue.MemoValue
			  FROM FormInputControl,FormControl,FormInputControlMap,Data_FieldValue
			 WHERE Data_FieldValue.FieldID = FormInputControl.ID
				AND Data_FieldValue.FormID = FormControl.ID
				AND (Data_FieldValue.PageID IN (?,?,?,?)) 
				AND FormInputControl.ID = FormInputControlMap.FieldID
				AND FormControl.ID = FormInputControlMap.FormID
				AND (( (Data_FieldValue.FieldID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)) 
				AND (Data_FieldValue.formID = ?) ))
				AND ControlID = ?
		 ORDER BY Data_FieldValue.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) = 16578
Parameter #4(CF_SQL_INTEGER) = 3901
Parameter #5(CF_SQL_INTEGER) = 27708
Parameter #6(CF_SQL_INTEGER) = 27709
Parameter #7(CF_SQL_INTEGER) = 27728
Parameter #8(CF_SQL_INTEGER) = 27707
Parameter #9(CF_SQL_INTEGER) = 27729
Parameter #10(CF_SQL_INTEGER) = 27722
Parameter #11(CF_SQL_INTEGER) = 27723
Parameter #12(CF_SQL_INTEGER) = 27720
Parameter #13(CF_SQL_INTEGER) = 27742
Parameter #14(CF_SQL_INTEGER) = 27721
Parameter #15(CF_SQL_INTEGER) = 27743
Parameter #16(CF_SQL_INTEGER) = 27726
Parameter #17(CF_SQL_INTEGER) = 27727
Parameter #18(CF_SQL_INTEGER) = 27724
Parameter #19(CF_SQL_INTEGER) = 27725
Parameter #20(CF_SQL_INTEGER) = 27740
Parameter #21(CF_SQL_INTEGER) = 27741
Parameter #22(CF_SQL_INTEGER) = 27719
Parameter #23(CF_SQL_INTEGER) = 27717
Parameter #24(CF_SQL_INTEGER) = 27739
Parameter #25(CF_SQL_INTEGER) = 27718
Parameter #26(CF_SQL_INTEGER) = 27711
Parameter #27(CF_SQL_INTEGER) = 27733
Parameter #28(CF_SQL_INTEGER) = 27712
Parameter #29(CF_SQL_INTEGER) = 27734
Parameter #30(CF_SQL_INTEGER) = 27731
Parameter #31(CF_SQL_INTEGER) = 27710
Parameter #32(CF_SQL_INTEGER) = 27732
Parameter #33(CF_SQL_INTEGER) = 27715
Parameter #34(CF_SQL_INTEGER) = 27737
Parameter #35(CF_SQL_INTEGER) = 27716
Parameter #36(CF_SQL_INTEGER) = 27738
Parameter #37(CF_SQL_INTEGER) = 27713
Parameter #38(CF_SQL_INTEGER) = 27735
Parameter #39(CF_SQL_INTEGER) = 27714
Parameter #40(CF_SQL_INTEGER) = 27736
Parameter #41(CF_SQL_INTEGER) = 27730
Parameter #42(CF_SQL_INTEGER) = 27701
Parameter #43(CF_SQL_INTEGER) = 48939

CheckInheritance (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-limit-inheritance.cfm @ 23:18:49.049
   SELECT PageID,VersionState,AuthorID
     FROM Param_WDDX
    WHERE ControlID=?
		AND (PageID=16578 OR (PageID IN (3901,2,1) AND (VersionState = 2)))
		AND (VersionState = 2) 
 ORDER BY PageID Desc
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 48939

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

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

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

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

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

cachedData (Datasource=commonspot-site-dhs, Time=16ms, Records=6) in C:\inetpub\wwwroot\commonspot\udf\custom_element.cfm @ 23:18:49.049
			SELECT DataBlock, PageID, ControlID
			  FROM ElementDataCache
			 WHERE (PageID IN (?,?,?,?,?,?)) 
				AND ControlID = 0
			
				AND FormID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 48956
Parameter #2(CF_SQL_INTEGER) = 48944
Parameter #3(CF_SQL_INTEGER) = 48953
Parameter #4(CF_SQL_INTEGER) = 48941
Parameter #5(CF_SQL_INTEGER) = 48950
Parameter #6(CF_SQL_INTEGER) = 48947
Parameter #7(CF_SQL_INTEGER) = 27356

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 23:18:49.049
		SELECT ig.GalleryID, ig.OrigHeight, ig.OrigWidth, ig.FileName, ig.SubsiteID, ig.PageID, igs.SizeRestrictionType, ig.SubsiteID
		  FROM ImageGallery ig
		  JOIN Subsites s ON s.ID = ig.SubsiteID
		  JOIN SitePages sp ON sp.ID = ig.PageID
		  JOIN ImageGalleries igs ON ig.GalleryID = igs.ID
		 WHERE ig.PageID IN (?)
			AND ig.VersionState = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27075
Parameter #2(CF_SQL_INTEGER) = 2

imageDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\ui.cfm @ 23:18:49.049
			SELECT IsTransparent, SubsiteID, GalleryID, FileName
			  FROM ImageGallery
			 WHERE PageID = ?
				AND VersionState = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27075
Parameter #2(CF_SQL_INTEGER) = 2

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:18:49.049
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:18:49.049
		SELECT Name, HasFieldMappings, GenericFieldMappings, ModulePath
		  FROM CustomElementModules
		 WHERE ElementType = ?
			AND ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27356
Parameter #2(cf_sql_integer) = 27367

getFileInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-decipher-linkurl.cfm @ 23:18:49.049
			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16592

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\page.cfm @ 23:18:49.049
		SELECT ID AS PageID, Name, SubSiteID, PageType, Title, FileName, DocType,Uploaded
		  FROM SitePages
		 WHERE ID = ?
			 OR (FileName = ?
				 AND PageType = ?)
	 ORDER BY PageType ASC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 16592
Parameter #2(cf_sql_varchar) = CP___PAGEID=16592,Geographic-Data-Analysis.cfm,19
Parameter #3(cf_sql_integer) = 8

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 23:18:49.049
		SELECT ig.GalleryID, ig.OrigHeight, ig.OrigWidth, ig.FileName, ig.SubsiteID, ig.PageID, igs.SizeRestrictionType, ig.SubsiteID
		  FROM ImageGallery ig
		  JOIN Subsites s ON s.ID = ig.SubsiteID
		  JOIN SitePages sp ON sp.ID = ig.PageID
		  JOIN ImageGalleries igs ON ig.GalleryID = igs.ID
		 WHERE ig.PageID IN (?)
			AND ig.VersionState = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27073
Parameter #2(CF_SQL_INTEGER) = 2

imageDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\ui.cfm @ 23:18:49.049
			SELECT IsTransparent, SubsiteID, GalleryID, FileName
			  FROM ImageGallery
			 WHERE PageID = ?
				AND VersionState = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27073
Parameter #2(CF_SQL_INTEGER) = 2

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

testQuery (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:18:49.049
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:18:49.049
		SELECT Name, HasFieldMappings, GenericFieldMappings, ModulePath
		  FROM CustomElementModules
		 WHERE ElementType = ?
			AND ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27356
Parameter #2(cf_sql_integer) = 27367

getFileInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-decipher-linkurl.cfm @ 23:18:49.049
			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16606

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\page.cfm @ 23:18:49.049
		SELECT ID AS PageID, Name, SubSiteID, PageType, Title, FileName, DocType,Uploaded
		  FROM SitePages
		 WHERE ID = ?
			 OR (FileName = ?
				 AND PageType = ?)
	 ORDER BY PageType ASC
	
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 16606
Parameter #2(cf_sql_varchar) = CP___PAGEID=16606,GIS-Training.cfm,19
Parameter #3(cf_sql_integer) = 8

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 23:18:49.049
		SELECT ig.GalleryID, ig.OrigHeight, ig.OrigWidth, ig.FileName, ig.SubsiteID, ig.PageID, igs.SizeRestrictionType, ig.SubsiteID
		  FROM ImageGallery ig
		  JOIN Subsites s ON s.ID = ig.SubsiteID
		  JOIN SitePages sp ON sp.ID = ig.PageID
		  JOIN ImageGalleries igs ON ig.GalleryID = igs.ID
		 WHERE ig.PageID IN (?)
			AND ig.VersionState = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27074
Parameter #2(CF_SQL_INTEGER) = 2

imageDetails (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\ui.cfm @ 23:18:49.049
			SELECT IsTransparent, SubsiteID, GalleryID, FileName
			  FROM ImageGallery
			 WHERE PageID = ?
				AND VersionState = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27074
Parameter #2(CF_SQL_INTEGER) = 2

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:18:49.049
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:18:49.049
		SELECT Name, HasFieldMappings, GenericFieldMappings, ModulePath
		  FROM CustomElementModules
		 WHERE ElementType = ?
			AND ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27356
Parameter #2(cf_sql_integer) = 27367

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 23:18:49.049
		SELECT ig.GalleryID, ig.OrigHeight, ig.OrigWidth, ig.FileName, ig.SubsiteID, ig.PageID, igs.SizeRestrictionType, ig.SubsiteID
		  FROM ImageGallery ig
		  JOIN Subsites s ON s.ID = ig.SubsiteID
		  JOIN SitePages sp ON sp.ID = ig.PageID
		  JOIN ImageGalleries igs ON ig.GalleryID = igs.ID
		 WHERE ig.PageID IN (?)
			AND ig.VersionState = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 25605
Parameter #2(CF_SQL_INTEGER) = 2

imageDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\ui.cfm @ 23:18:49.049
			SELECT IsTransparent, SubsiteID, GalleryID, FileName
			  FROM ImageGallery
			 WHERE PageID = ?
				AND VersionState = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 25605
Parameter #2(CF_SQL_INTEGER) = 2

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:18:49.049
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:18:49.049
		SELECT Name, HasFieldMappings, GenericFieldMappings, ModulePath
		  FROM CustomElementModules
		 WHERE ElementType = ?
			AND ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27356
Parameter #2(cf_sql_integer) = 27367

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 23:18:49.049
		SELECT ig.GalleryID, ig.OrigHeight, ig.OrigWidth, ig.FileName, ig.SubsiteID, ig.PageID, igs.SizeRestrictionType, ig.SubsiteID
		  FROM ImageGallery ig
		  JOIN Subsites s ON s.ID = ig.SubsiteID
		  JOIN SitePages sp ON sp.ID = ig.PageID
		  JOIN ImageGalleries igs ON ig.GalleryID = igs.ID
		 WHERE ig.PageID IN (?)
			AND ig.VersionState = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26461
Parameter #2(CF_SQL_INTEGER) = 2

imageDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\ui.cfm @ 23:18:49.049
			SELECT IsTransparent, SubsiteID, GalleryID, FileName
			  FROM ImageGallery
			 WHERE PageID = ?
				AND VersionState = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 26461
Parameter #2(CF_SQL_INTEGER) = 2

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:18:49.049
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:18:49.049
		SELECT Name, HasFieldMappings, GenericFieldMappings, ModulePath
		  FROM CustomElementModules
		 WHERE ElementType = ?
			AND ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27356
Parameter #2(cf_sql_integer) = 27367

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 23:18:49.049
		SELECT ig.GalleryID, ig.OrigHeight, ig.OrigWidth, ig.FileName, ig.SubsiteID, ig.PageID, igs.SizeRestrictionType, ig.SubsiteID
		  FROM ImageGallery ig
		  JOIN Subsites s ON s.ID = ig.SubsiteID
		  JOIN SitePages sp ON sp.ID = ig.PageID
		  JOIN ImageGalleries igs ON ig.GalleryID = igs.ID
		 WHERE ig.PageID IN (?)
			AND ig.VersionState = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 26405
Parameter #2(CF_SQL_INTEGER) = 2

imageDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\ui.cfm @ 23:18:49.049
			SELECT IsTransparent, SubsiteID, GalleryID, FileName
			  FROM ImageGallery
			 WHERE PageID = ?
				AND VersionState = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 26405
Parameter #2(CF_SQL_INTEGER) = 2

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

testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 23:18:49.049
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 23:18:49.049
		SELECT Name, HasFieldMappings, GenericFieldMappings, ModulePath
		  FROM CustomElementModules
		 WHERE ElementType = ?
			AND ID = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27356
Parameter #2(cf_sql_integer) = 27367

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

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

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

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

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

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

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

qryname44875 (Datasource=, Time=0ms, Records=37) in C:\ColdFusion2018\cfusion\CustomTags\com\adobe\coldfusion\base.cfc @ 23:18:49.049
 SELECT FormName FROM mdCheckQry where lower(FormName) = ? 
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = csw imagetextblock

getFileInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-decipher-linkurl.cfm @ 23:18:49.049
			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16592

getFileInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-decipher-linkurl.cfm @ 23:18:49.049
			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16592

getFileInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-decipher-linkurl.cfm @ 23:18:49.049
			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16606

getFileInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-decipher-linkurl.cfm @ 23:18:49.049
			SELECT SubSiteID, PageType, publicReleaseDate, expDate, filename, uploaded
			  FROM SitePages
			 WHERE ID=? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 16606

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

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

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

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


Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58
adf=Struct (89)
adfscheduler=Struct (0)
applicationname=site1
assocpubdocs=Struct (4)
blogcache=Struct (4)
cachedimages=Struct (32)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=10
covid_newsarticlecount=49
covid_pressreleasecount=4
covid_pubcount=3
cs_elementcache=Struct (10)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerinfo=Complex type
customerscope=Struct (21)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (4)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-03 12:12:03
serverstatus=Struct (1)
site=Struct (74)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (46)
subsitecachebysecuritypageid=Struct (46)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\Methodology\GIS.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=JSESSIONID=88999A1BA8A9ABEDDDE184EA63F5A69C.cfusion; CSRFTOKEN=38F153373554C1886D9491436FAE29C5B1A56EB1
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/Methodology/GIS.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.0.111
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\dhs\Methodology\GIS.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.129
REMOTE_HOST=10.0.2.129
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Methodology/GIS.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=38F153373554C1886D9491436FAE29C5B1A56EB1
JSESSIONID=88999A1BA8A9ABEDDDE184EA63F5A69C.cfusion
Request Parameters:
anonnoreadelements=26058
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=33
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=3136906752
cs_runningdashboardcmdcode=0
csrftoken=38F153373554C1886D9491436FAE29C5B1A56EB1
ctrl_data=Struct (84)
customcfupfront=
customerinfo=Complex type
customhead=1
customrenderhandlerpairs=
customsearch=Struct (11)
dbdsn=measure_db
debugstate=Struct (1)
dhspagesyncdata=Struct (1)
dhtmlmenuitemsprefetch=
disablehideformenus=0
dsource=dhs_legacy_live
editmode=0
element=Struct (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-02 23:18:49
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1719962329003
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nocacheheaderincluded=1
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (84)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
readmodewhereclause=(VersionState = 2)
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-02 23:18:49.003
req_sequenceid=55125
req_startticks=1719962329003
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_88999A1BA8A9ABEDDDE184EA63F5A69C.cfusion
sessionstring=1_88999A1BA8A9ABEDDDE184EA63F5A69C.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=19
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-02 23:18:49'}
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=38F153373554C1886D9491436FAE29C5B1A56EB1
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=16578
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1719962328113
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=88999A1BA8A9ABEDDDE184EA63F5A69C.cfusion
sessionstring=1_88999A1BA8A9ABEDDDE184EA63F5A69C.cfusion
urltoken=CFID=2267511&CFTOKEN=88f128a7eee56c7d-996F5236-0939-F101-439BBE1FE311B931&jsessionid=88999A1BA8A9ABEDDDE184EA63F5A69C.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 31 ms