Data Visualizations

Data visualizations allow users to explore DHS data through various online applications.

Download Datasets

The DHS Program is authorized to distribute, at no cost, unrestricted survey data files for legitimate academic research. Registration is required for access to data.

Guide to Using Datasets


Debugging Information
ColdFusion Server Developer 2018,0,19,330149
Template /data/visualizations/index.cfm
Time Stamp 24-Jul-24 08:08 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.0.2.138
Host Name 10.0.2.138


Execution Time

Total Time Avg Time Count Template
13702 ms 428 ms 32 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
13672 ms 427 ms 32 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
7235 ms 7235 ms 1 C:/inetpub/wwwroot/dhs/data/visualizations/index.cfm
7218 ms 7218 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
7031 ms 7031 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
7015 ms 7015 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
7015 ms 7015 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
7015 ms 7015 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
7015 ms 7015 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
6984 ms 6984 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
6937 ms 631 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
6047 ms 6047 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c1378-l70-t51-dAny.read
5797 ms 5797 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
5719 ms 5719 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/cpe-custom.cfm
3843 ms 769 ms 5 C:/inetpub/wwwroot/commonspot/utilities/resolve-image-url.cfm
2125 ms 304 ms 7 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(image) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
1484 ms 297 ms 5 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(imageGallery) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
1236 ms 112 ms 11 C:/inetpub/wwwroot/dhs/_cs_widgets/csw-imagetextblock/renderhandlers/csw-imagetextblock-generic-rh.cfm
842 ms 168 ms 5 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getFieldMappings(moduleID = 27367, elementID = 27356) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
626 ms 125 ms 5 C:/inetpub/wwwroot/commonspot/utilities/explicit-module-cfinclude.cfm
531 ms 531 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
250 ms 250 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c1433-l70-t51-dAny.read
203 ms 203 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
125 ms 125 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19152-l70-t51-dAny.read
124 ms 124 ms 1 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
113 ms 10 ms 11 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
110 ms 110 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19154-l70-t51-dAny.read
110 ms 110 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
94 ms 94 ms 1 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
78 ms 78 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19153-l70-t51-dAny.read
77 ms 39 ms 2 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load.cfm
77 ms 39 ms 2 C:/inetpub/wwwroot/commonspot/metadata/tags/form_control/load_core.cfm
64 ms 4 ms 15 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | isWebPRenderingEnabled(1) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
62 ms 62 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19155-l70-t51-dAny.read
62 ms 62 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19169-l70-t51-dAny.read
62 ms 12 ms 5 C:/inetpub/wwwroot/commonspot/utilities/module-cfinclude-execute.cfm
62 ms 31 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(162230, 162260) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
62 ms 62 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
61 ms 61 ms 1 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
48 ms 0 ms 105 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
47 ms 47 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
33 ms 33 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(162307) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c1432-l70-t51-dAny.read
31 ms 31 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19174-l70-t51-dAny.read
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/get-params.cfm
31 ms 31 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
31 ms 31 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(267046) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
28 ms 28 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
28 ms 28 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
28 ms 28 ms 1 C:/inetpub/wwwroot/dhs/data/visualizations/Application.cfm
27 ms 27 ms 1 CFC[ C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc | execute() ] from C:/ColdFusion2018/cfusion/CustomTags/com/adobe/coldfusion/query.cfc
18 ms 18 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c49731-l70-t27356-dAny.read
17 ms 17 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
17 ms 17 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(template-Data-Template.cfm, 2352, 5) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19177-l70-t51-dAny.read
16 ms 16 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c49703-l70-t27356-dAny.read
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/controls/custom/get-data.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/style/load-page-classes.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile.cfm
16 ms 8 ms 2 C:/inetpub/wwwroot/commonspot/utilities/ct-extract-wddx-data.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/ct-limit-inheritance.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-stub.cfm
16 ms 16 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(162309) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(204157) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
16 ms 16 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | getImageSizePaths(222820) ] from C:/inetpub/wwwroot/commonspot/public_api/image.cfc
15 ms 3 ms 5 C:/inetpub/wwwroot/commonspot/utilities/get-image-given-pageid.cfm
15 ms 8 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
15 ms 15 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(162230) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
12 ms 12 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
0 ms 0 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/56/p162230-c19172-l70-t51-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/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/browser-detect-methods.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/build-request-params.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-head-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/handle-request-timeout.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-customer-scope.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/startup/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 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 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.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 11 C:/inetpub/wwwroot/commonspot/utilities/ct-decipher-linkurl.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 19 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/item-visible.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/nocache-headers.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
0 ms 0 ms 4 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/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/data/template-Data-Template.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 | 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(162230) ] 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(2352) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | DBQueue_Count() ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(162230, 56, 2352, 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(2352, 5, 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], 56, 162230, 2352, 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], 56, 162230, 2352, 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(56) ] 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, 56) ] 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(162230) ] 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(56) ] 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(2352) ] 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 5 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/data/override-imagerender.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 5 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/data/visualizations/override-imagerender.cfm, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 5 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 5 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 5 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 3 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/data/visualizations/images/Gender-dashboard-thumb-1.png, 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/data/visualizations/images/Thumbnail_DVS.png, 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/images/Evolution-Overview-150.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/images/Nigeria-indicators-unmet-need-thumbnail-wide.png, 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/images/STATcompiler-thumbnail-wide.png, 0, false) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc | getDSN(site) ] from C:/inetpub/wwwroot/commonspot/components/util/commonspot-context.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent('head' request check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(CGI variable processing) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(New (global) session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request object updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Request.Params initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(RequestTimeout check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Server-level remote requests checked) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(Subsite context updated (ID=56)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(customerScope object initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user object created) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Cache) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 6 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 10 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 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(162230, 56) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 27356) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery-security.cfc | init(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery-security.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc | getImageFileName(baseFileName = Evolution-Overview-150.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 = Gender-dashboard-thumb-1.png, 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 = Nigeria-indicators-unmet-need-thumbnail-wide.png, 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 = STATcompiler-thumbnail-wide.png, 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 = Thumbnail_DVS.png, 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 | init(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/public_api/image-gallery.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/image.cfc | init(argumentCollection = [complex value]) ] 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/keywords.cfc | getDelimitedListForObject(objectID = 162230) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/site-tools.cfc | init(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/public_api/site-tools.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/site.cfc | init(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/public_api/site.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/subsite-general-security.cfc | init(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/public_api/subsite-general-security.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 5 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
35 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
7298 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 @ 08:08:23.023
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
CacheInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=33) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 08:08:23.023
			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) = 56
Parameter #2(CF_SQL_INTEGER) = 162230
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1

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

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

inheritedCacheSettings (Datasource=commonspot-site-dhs, Time=0ms, Records=3) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 08:08:23.023
		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) = 2352

GetBaseTemplateSubSiteID (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 08:08:23.023
		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 @ 08:08:23.023
			SELECT PageType
			  FROM SitePages
			 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2352

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

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

qryKeywords (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\keywords-tags\keywords-tags-base.cfc @ 08:08:23.023
		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) = 162230
Parameter #2(CF_SQL_TINYINT) = 0

GetRenderOptions (Datasource=commonspot-site-dhs, Time=17ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 08:08:23.023
			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) = 2352
Parameter #5(CF_SQL_INTEGER) = 162230

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

FormData (Datasource=commonspot-site-dhs, Time=47ms, Records=24) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 08:08:23.023
	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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230
Parameter #5(CF_SQL_INTEGER) = 56
Parameter #6(CF_SQL_INTEGER) = 1
Parameter #7(CF_SQL_INTEGER) = 5
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 2
Parameter #10(CF_SQL_INTEGER) = 2352
Parameter #11(CF_SQL_INTEGER) = 9

NamedClasses (Datasource=commonspot-site-dhs, Time=16ms, Records=2) in C:\inetpub\wwwroot\commonspot\style\load-page-classes.cfm @ 08:08:23.023
	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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230
Parameter #5(CF_SQL_INTEGER) = 2

StyleSheetGroups (Datasource=commonspot-site-dhs, Time=0ms, Records=2) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 08:08:23.023
		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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230
Parameter #5(CF_SQL_INTEGER) = 2

PageStyleSheets (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 08:08:23.023
		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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230
Parameter #5(CF_SQL_INTEGER) = 3474
Parameter #6(CF_SQL_INTEGER) = 2

CheckCustomRender (Datasource=commonspot-site-dhs, Time=0ms, Records=72) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 08:08:23.023
		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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230
Parameter #5(CF_SQL_INTEGER) = 2

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

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

PagePermissions (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\cache\item-security-cache.cfc @ 08:08:23.023
			SELECT *
			  FROM ItemSecurity
			 WHERE PageID = ?
				AND ApplyTo = 0 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 162230

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=31ms, Records=2845) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 08:08:23.023
		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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230
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 @ 08:08:23.023
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=162230 OR (PageID IN (2352,2,1) AND (VersionState = 2)))
			   AND VersionState=2
			 ORDER BY PageID DESC
		
qry (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\core.cfm @ 08:08:23.023
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 162230

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

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

ControlInstanceData (Datasource=commonspot-site-dhs, Time=16ms, Records=84) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 08:08:23.023
		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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230

qInfo (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 08:08:23.023
		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=31ms, Records=37) in C:\inetpub\wwwroot\commonspot\metadata\tags\form_control\load_core.cfm @ 08:08:23.023
		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=125ms, Records=37) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 08:08:23.023
			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) = 2352
Parameter #4(CF_SQL_INTEGER) = 162230
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) = 162260

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

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

qDspTpl (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\custom\get-params.cfm @ 08:08:23.023
	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) = 162260
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 2352
Parameter #5(CF_SQL_INTEGER) = 162230

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

qLayoutProps (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\controls\custom\get-params.cfm @ 08:08:23.023
		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=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 08:08:23.023
	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=162230 AND (VersionState = 2)) OR ((PageID IN (2352,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 162260
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 27356

getForms (Datasource=commonspot-site-dhs, Time=15ms, Records=8) in C:\inetpub\wwwroot\commonspot\metadata\tags\form_control\load_core.cfm @ 08:08:23.023
		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 d1.ID = 27356 ORDER BY d5.TabSortName, d1.ID, d3.itemPos 
getForms (Datasource=, Time=0ms, Records=8) in C:\inetpub\wwwroot\commonspot\metadata\tags\form_control\load_core.cfm @ 08:08:23.023
			SELECT *
			  FROM getForms
			 WHERE Class = ?
				AND ClassID = ?
			 ORDER By CS_ExistingOrder
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6
Parameter #2(CF_SQL_INTEGER) = 1

cachedData (Datasource=commonspot-site-dhs, Time=16ms, Records=5) in C:\inetpub\wwwroot\commonspot\udf\custom_element.cfm @ 08:08:23.023
			SELECT DataBlock, PageID, ControlID
			  FROM ElementDataCache
			 WHERE (PageID IN (?,?,?,?,?)) 
				AND ControlID = 0
			
				AND FormID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 267048
Parameter #2(CF_SQL_INTEGER) = 222807
Parameter #3(CF_SQL_INTEGER) = 204160
Parameter #4(CF_SQL_INTEGER) = 162268
Parameter #5(CF_SQL_INTEGER) = 162262
Parameter #6(CF_SQL_INTEGER) = 27356

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\image.cfm @ 08:08:23.023
			SELECT ig.*, sp.Title
			  FROM ImageGallery ig, SitePages sp
			 WHERE ig.PageID = ?
				AND ig.VersionState = ?
				AND ig.PageID = sp.ID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 267046
Parameter #2(CF_SQL_INTEGER) = 2

qry (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 08:08:27.027
		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) = 267046
Parameter #2(CF_SQL_INTEGER) = 2

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

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 08:08:27.027
			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 @ 08:08:27.027
		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 @ 08:08:27.027
		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\udf\image.cfm @ 08:08:28.028
			SELECT ig.*, sp.Title
			  FROM ImageGallery ig, SitePages sp
			 WHERE ig.PageID = ?
				AND ig.VersionState = ?
				AND ig.PageID = sp.ID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 222820
Parameter #2(CF_SQL_INTEGER) = 2

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 08:08:28.028
		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) = 222820
Parameter #2(CF_SQL_INTEGER) = 2

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

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 08:08:28.028
			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 @ 08:08:28.028
		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 @ 08:08:28.028
		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

GetContactInfo (Datasource=commonspot-users, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\xmltools.cfm @ 08:08:28.028
			SELECT *
			  FROM Organization, Contacts, Users, Company
			 WHERE Organization.OrgID = Contacts.OrgID
			 	AND Contacts.ContactID = Users.ID
				AND Contacts.CompanyID = Company.CompanyID
			   AND Users.ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1000046

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\image.cfm @ 08:08:28.028
			SELECT ig.*, sp.Title
			  FROM ImageGallery ig, SitePages sp
			 WHERE ig.PageID = ?
				AND ig.VersionState = ?
				AND ig.PageID = sp.ID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 204157
Parameter #2(CF_SQL_INTEGER) = 2

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 08:08:28.028
		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) = 204157
Parameter #2(CF_SQL_INTEGER) = 2

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

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 08:08:28.028
			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 @ 08:08:28.028
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 08:08:28.028
		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\udf\image.cfm @ 08:08:28.028
			SELECT ig.*, sp.Title
			  FROM ImageGallery ig, SitePages sp
			 WHERE ig.PageID = ?
				AND ig.VersionState = ?
				AND ig.PageID = sp.ID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 162307
Parameter #2(CF_SQL_INTEGER) = 2

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 08:08:28.028
		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) = 162307
Parameter #2(CF_SQL_INTEGER) = 2

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

getRHDetails (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 08:08:28.028
			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 @ 08:08:28.028
		SELECT ID
		  FROM CustomElementModules
		 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 27367

getRHDetails (Datasource=commonspot-site-dhs, Time=15ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 08:08:28.028
		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\udf\image.cfm @ 08:08:28.028
			SELECT ig.*, sp.Title
			  FROM ImageGallery ig, SitePages sp
			 WHERE ig.PageID = ?
				AND ig.VersionState = ?
				AND ig.PageID = sp.ID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 162309
Parameter #2(CF_SQL_INTEGER) = 2

qry (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\image.cfc @ 08:08:28.028
		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) = 162309
Parameter #2(CF_SQL_INTEGER) = 2

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

getRHDetails (Datasource=commonspot-site-dhs, Time=32ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\util.cfm @ 08:08:28.028
			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 @ 08:08:28.028
		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 @ 08:08:28.028
		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=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\controls\custom\cpe-custom.cfm @ 08:08:28.028
		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) = 162260
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 2
Parameter #4(CF_SQL_INTEGER) = 2352
Parameter #5(CF_SQL_INTEGER) = 162230

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\controls\custom\tags\get-mask-collection.cfm @ 08:08:28.028
		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 @ 08:08:28.028
	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 @ 08:08:28.028
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 162230

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

qry (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\cache\cache-settings-cache.cfc @ 08:08:28.028
					SELECT ControlID,keepCache,MaxCacheLifetime,MaxCacheLifetimeUnits,StaleKeepLimit,IndexStatus,PrintStatus,ShareStatus
					  FROM Param_CacheSettings
					 WHERE PageID = ?
						AND VersionState=2
				
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 162230

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

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

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

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

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

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

testQuery (Datasource=commonspot-site-dhs, Time=16ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 08:08:29.029
		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 @ 08:08:29.029
		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 (88)
adfscheduler=Struct (0)
applicationname=site1
blogcache=Struct (4)
cachedimages=Struct (5)
cacheinfocache=Struct (53)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=0
covid_newsarticlecount=0
covid_pressreleasecount=0
covid_pubcount=0
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 (2)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2024-07-25 06:27:33
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\data\visualizations\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=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=
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/data/visualizations/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\data\visualizations\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.0.2.138
REMOTE_HOST=10.0.2.138
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/data/visualizations/index.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CSRFTOKEN=FE29CA87973782DAB0086B63F03EC6B8A91796AF
Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=30
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=2627360768
cs_runningdashboardcmdcode=0
csrftoken=FE29CA87973782DAB0086B63F03EC6B8A91796AF
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-24 08:08:22
getghost=
hivbold=1,3,8,9
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1721808502987
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (84)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (6)
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 (85)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
params_formfields=
params_urlfields=
parentisbasetemplate=0
parenttemplate=Struct (3)
previewmode=0
readmodewhereclause=(VersionState = 2)
rebuilt_stubs=
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (73)
req_cam_callcount=1
req_inittimestamp=2024-07-24 08:08:22.987
req_sequenceid=2111
req_startticks=1721808502987
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
samesite_value=
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_29680076B27E9BDFABC9084CB37D13E9.cfusion
sessionstring=1_29680076B27E9BDFABC9084CB37D13E9.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=56
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (1)
templaterootdir=/
timestamp={ts '2024-07-24 08:08:22'}
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)
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
_csrf_token=FE29CA87973782DAB0086B63F03EC6B8A91796AF
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=162230
debugmode=0
debugstate=Struct (1)
editmode=0
environment=Struct (5)
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1721808502999
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=29680076B27E9BDFABC9084CB37D13E9.cfusion
sessionstring=1_29680076B27E9BDFABC9084CB37D13E9.cfusion
urltoken=CFID=3700629&CFTOKEN=2dbb3fac2020f5d0-E5D78876-B8BD-DF1B-9A1E764BA8F6BD04&jsessionid=29680076B27E9BDFABC9084CB37D13E9.cfusion
usagelist=
user=Struct (30)
xmlbrowser=Struct (13)
xmlenvironment=Struct (5)
Debug Rendering Time: 78 ms