Youth Topic Banner

Youth and Reproductive Health

The DHS surveys gather information about young people's age at first marriage, sexual debut, knowledge and use of contraception, and childbearing.

When young women marry or become sexually active at a young age, they risk having children before they are physically ready. Early marriage also adds to the number of children a woman will bear over her lifetime. Early and unplanned pregnancies put young woman at risk for reproductive health complications. The DHS also collects information about the time intervals between births. Together, all of these data provide a broad picture of the reproductive health needs of young women and men.

Youth and HIV/AIDS

Of the 33 million people living with HIV, about a quarter or 8 million, are young adults. An estimated 5,000 young people contract the virus every day. DHS surveys have collected extensive information about youth and their sexual behavior in more than 50 countries.

DHS interviewers ask young adults a variety of questions about their reproductive health, including their age at sexual debut, their contraceptive use, and their history of sexually transmitted infections (STIs). Early sexual activity exposes young women and men to diseases such as syphilis and gonorrhea, which in turn make them more vulnerable to HIV.

Youth and Gender

In many countries, gender inequality remains a fact of life. DHS surveys offer an objective look at the balance of power between the sexes. Women and men frequently have dramatically different levels of education, employment, decision-making powers, and exposure to media.

The DHS data captures these key measures as well as knowledge, attitudes, and practices on a wide range of indicators. Additionally, in a selected number of countries, information is available on the experience of physical and sexual violence by women ages 15-24.

Youth and Education

The DHS Surveys have consistently shown a positive relationship between education and good health, safe practices to prevent HIV/AIDS, lower fertility, greater decision-making abilities, and many other benefits.

For example, data show a strong correlation between educating women and girls and higher maternal and child life expectancy as well as improved child and family health and nutrition. Educating a girl greatly reduces the chance that her child will die before the age of five. Girls and women who are educated are far more likely to immunize their children. Their children are less likely to be malnourished.

Country Profiles

youth country profile graphic

Publications

No pages meet the criteria

Resources


Debugging Information
ColdFusion Server Standard 2018,0,07,316715
Template /topics/Youth-Corner/index.cfm
Time Stamp 17-Oct-21 12:54 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 3.237.16.210
Host Name 3.237.16.210


Execution Time

Total Time Avg Time Count Template
8810 ms 215 ms 41 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element.cfm
8779 ms 214 ms 41 C:/inetpub/wwwroot/commonspot/utilities/ct-render-element-core.cfm
3409 ms 3409 ms 1 C:/inetpub/wwwroot/dhs/topics/Youth-Corner/index.cfm
3274 ms 3274 ms 1 C:/inetpub/wwwroot/commonspot/master.cfm
3191 ms 3191 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cached-page-render.cfm
3179 ms 3179 ms 1 C:/inetpub/wwwroot/commonspot/uncached-master.cfm
3178 ms 3178 ms 1 C:/inetpub/wwwroot/commonspot/master-render.cfm
3177 ms 3177 ms 1 C:/inetpub/wwwroot/commonspot/render-page-meat.cfm
3177 ms 3177 ms 1 C:/inetpub/wwwroot/commonspot/render-page.cfm
3148 ms 3148 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm
3140 ms 285 ms 11 C:/inetpub/wwwroot/commonspot/utilities/ct-render-named-element.cfm
2747 ms 2747 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c1433-l70-t51-dAny.read
2636 ms 2636 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c5116-l70-t51-dAny.read
2593 ms 2593 ms 1 C:/inetpub/wwwroot/commonspot/utilities/run-element.cfm
1796 ms 1796 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/cpe-pageindex.cfm
1780 ms 1780 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/main.cfm
1072 ms 1072 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/query-loop.cfm
702 ms 702 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/query-and-params.cfm
660 ms 660 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | config(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
157 ms 79 ms 2 C:/inetpub/wwwroot/commonspot/utilities/verify-stub-data.cfm
145 ms 73 ms 2 C:/inetpub/wwwroot/commonspot/utilities/build-and-write-stub.cfm
133 ms 133 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-properties.cfm
132 ms 132 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | LoadTemplateProperties(template-corner-mciii.cfm, 5075, 6) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
129 ms 129 ms 1 C:/inetpub/wwwroot/commonspot/utilities/load-template-stub.cfm
127 ms 64 ms 2 C:/inetpub/wwwroot/commonspot/utilities/populate-page.cfm
111 ms 111 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c1378-l70-t51-dAny.read
75 ms 38 ms 2 C:/inetpub/wwwroot/commonspot/metadata/build-struct.cfm
44 ms 44 ms 1 C:/inetpub/wwwroot/commonspot/site-application.cfm
44 ms 44 ms 1 C:/inetpub/wwwroot/dhs/topics/Youth-Corner/Application.cfm
43 ms 43 ms 1 C:/inetpub/wwwroot/commonspot/startup/site-application-meat.cfm
34 ms 34 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19154-l70-t51-dAny.read
26 ms 26 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19152-l70-t51-dAny.read
26 ms 26 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19174-l70-t51-dAny.read
24 ms 24 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19153-l70-t51-dAny.read
23 ms 23 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c5117-l70-t51-dAny.read
23 ms 12 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/public_api/cache.cfc | getElementCacheSettings(5143, 14294) ] from C:/inetpub/wwwroot/commonspot/public_api/cache.cfc
22 ms 22 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19155-l70-t51-dAny.read
19 ms 10 ms 2 C:/inetpub/wwwroot/dhs/Topics/template-corner-mciii.cfm
18 ms 18 ms 1 C:/inetpub/wwwroot/commonspot/controls/control-setup.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/render-head.cfm
15 ms 15 ms 1 C:/inetpub/wwwroot/commonspot/startup/core-application-meat.cfm
14 ms 14 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/pageindex-standard-render.cfm
14 ms 14 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | runQuery() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
13 ms 7 ms 2 C:/inetpub/wwwroot/commonspot/utilities/write-stub.cfm
12 ms 12 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c1432-l70-t51-dAny.read
12 ms 12 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c5138-l70-t51-dAny.read
12 ms 4 ms 3 C:/inetpub/wwwroot/commonspot/controls/ct-include-once.cfm
10 ms 10 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/get-params.cfm
10 ms 5 ms 2 C:/inetpub/wwwroot/commonspot/utilities/set-style-vars.cfm
9 ms 9 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/element.cfc | getInfo(elementTypeID = 36) ] from C:/inetpub/wwwroot/commonspot/public_api/element.cfc
8 ms 8 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19169-l70-t51-dAny.read
8 ms 4 ms 2 C:/inetpub/wwwroot/commonspot/utilities/ct-extract-wddx-data.cfm
8 ms 8 ms 1 C:/inetpub/wwwroot/commonspot/utilities/update-page-cache-status.cfm
8 ms 4 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(5143, 22, 5075, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
8 ms 8 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | genAdvancedClause() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
7 ms 2 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(5075, 6, 1886, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
7 ms 7 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc | setAQP( | metadataList| 14149_14151| likelist | | Youth| | ) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc
7 ms 7 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 5075) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
6 ms 6 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | genCommonClause() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
5 ms 5 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19177-l70-t51-dAny.read
5 ms 2 ms 3 C:/inetpub/wwwroot/commonspot/components/query-engine/render-clause.cfm
5 ms 3 ms 2 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile.cfm
5 ms 0 ms 26 C:/inetpub/wwwroot/commonspot/utilities/handle-in-list.cfm
5 ms 5 ms 1 C:/inetpub/wwwroot/dhs/custom-application.cfm
4 ms 4 ms 1 C:/commonspot-data/customers/commonspot-users/sites/commonspot-site-dhs/mapped/cache/22/p5143-c19172-l70-t51-dAny.read
4 ms 1 ms 3 C:/inetpub/wwwroot/commonspot/components/query-engine/render-extrafilter.cfm
4 ms 4 ms 1 C:/inetpub/wwwroot/commonspot/render-metatags.cfm
4 ms 4 ms 1 C:/inetpub/wwwroot/commonspot/security/security-page.cfm
4 ms 2 ms 2 C:/inetpub/wwwroot/commonspot/style/load-page-classes.cfm
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addMetadata(MetadataList, [complex value], [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | getDelimitedListForObject(objectID = 5143) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc | getTags(5143) ] from C:/inetpub/wwwroot/commonspot/public_api/livebookmarks.cfc
3 ms 2 ms 2 C:/inetpub/wwwroot/commonspot/utilities/cp-cffile-meat.cfm
3 ms 3 ms 1 C:/inetpub/wwwroot/commonspot/utilities/flush-cache-db-queue.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/set-page-vars.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/startup/init-server-scope.cfm
2 ms 2 ms 1 C:/inetpub/wwwroot/commonspot/startup/session-first-global.cfm
2 ms 1 ms 2 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js.cfm
2 ms 2 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | ProcessDBQueue(noWait) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
2 ms 2 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc | init(pageindex) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/lview-contribute-mode-redirect-check.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/non-dashboard-include.cfm
1 ms 1 ms 2 C:/inetpub/wwwroot/commonspot/utilities/item-visible.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/newwindow-js-meat.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-page-stub.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/commonspot/utilities/write-template-stub.cfm
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 22, 5143, 5075, 0, 0, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 22, 5143, 5075, 0, 0, 90) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus([complex value], [complex value], 6, 5075, 1886, 0, 0, 2) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc | GetEntry(5143) ] from C:/inetpub/wwwroot/commonspot/components/cache/item-security-cache.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | getTemplatePageData(1886) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | getTemplatePageData(5075) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc | appendEnforced(subsiteIDOrURL = , keywordList = ) ] from C:/inetpub/wwwroot/commonspot/public_api/keywords.cfc
0 ms 0 ms 1 C:/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 1 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.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/get-expand-icon-urls.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/pageindex-js.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/pageindex-pre-render.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/controls/pageindex/param-override-with-passedin.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/pagemode/pagemodeui.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-body-tag.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-foot.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/render-tracking-code.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/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/session-first-site.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/add-resource-request.cfm
0 ms 0 ms 6 C:/inetpub/wwwroot/commonspot/utilities/add-unregistered-resource-request.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/append-to-resource-group.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/build-user-struct.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfheader.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/commonspot/utilities/cp-cfmail-request-queue.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/define-upfront-vars.cfm
0 ms 0 ms 2 C:/inetpub/wwwroot/commonspot/utilities/validate-date-string.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/custom-search/inc-custom-application-search-vars.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/dhs/templates/template-basepage.head
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-settings-cache.cfc | getPageSettings(5075) ] 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(5143) ] 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 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | GetPageCacheStatus(1886, 1, 2, 0) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc | UpdateStatus(argumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/cache-status.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc | getCustomAppPath(22) ] 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, 22) ] from C:/inetpub/wwwroot/commonspot/components/cache/custom-module-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc | getRewriteSettings(22) ] from C:/inetpub/wwwroot/commonspot/components/cache/rewrite-rules-cache.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getLatest() ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc | getSecurityPageIDMap([complex value]) ] from C:/inetpub/wwwroot/commonspot/components/cache/subsite-cache-manager.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc | InvalidateCachedTemplate(5075) ] from C:/inetpub/wwwroot/commonspot/components/cache/template-cache.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc | executeFunction(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/custom-application-framework/handle-applications.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | checkFileExists(C:/inetpub/wwwroot/dhs/templates/template-basepage.cfm, 0) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc | queryRowToStruct(ArgumentCollection = [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/engine/ACF/utilities.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc | getClause() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc | setAdvPK(SitePages.ID) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc | setForceCache(0) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc | setPageType(2) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/advanced-parser.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.ApprovalStatus, 0, int) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.AudienceID, 0, int) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.PageSetID, 0, int) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | add(SitePages.SubSiteID, 0, int, <>) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addExtraFilter(Availability) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addExtraFilter(ExcludeExpired) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addExtraFilter(PageType, [complex value]) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addJoin(GeneralCategories.CategoryTypeID, 1) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | addJoin(GeneralCategories.ID, SitePages.CategoryID) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 3 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | getObject() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 4 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc | init(pageindex) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/clause.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | initTypedCacheInfo(5143, 14294, 0) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc | setFacetNavControl(5143, 0, true) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/page-index.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | chkCategorization() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | chkSortOrder() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | getCategorizedColumns() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | getOrderBy() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | getRenderMethods() ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.cfc | init(0, 7, desc) ] from C:/inetpub/wwwroot/commonspot/components/query-engine/result-display-options.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('site' Remote Requests processed) ] 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' Remote Requests processed) ] 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=22)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(authoring suspended check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(basic setup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(check for server property changes) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core cleanup) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(core variables) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(custom-application.cfm) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(handleRequestStart) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(init-server-scope loaded) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(lock checks/updates) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site environment initialization) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(site session check) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(subsite context refreshed) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user object created) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(user session initialized) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Server_Scope (read)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | addEvent(wait for lock: CommonSpot_Site1_Core (exclusive)) ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc | init() ] from C:/inetpub/wwwroot/commonspot/components/util/debug-timing.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Cache) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(Element) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(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 2 CFC[ C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc | getObject(keywords) ] from C:/inetpub/wwwroot/commonspot/components/util/object-factory.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.cfc | onPageVisit(5143, 22) ] from C:/inetpub/wwwroot/commonspot/components/util/visitor-context-rule-actions.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
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3469 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

pendingRequests (Datasource=commonspot-sites, Time=2ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 12:54:41.041
				SELECT params,RequestSequenceID
				  FROM ServerRemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-sites, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 12:54:41.041
			SELECT *
			  FROM ServerRemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

get (Datasource=dhs_legacy_live, Time=3ms, Records=217) in C:\inetpub\wwwroot\dhs\custom-application.cfm @ 12:54:41.041
    	SELECT lang_text_var, lang_text_en
        FROM dataset_lang_dictionary
    
pendingRequests (Datasource=commonspot-users, Time=3ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 12:54:41.041
				SELECT params,RequestSequenceID
				  FROM UsersRemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-users, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 12:54:41.041
			SELECT *
			  FROM UsersRemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 12:54:41.041
				SELECT params,RequestSequenceID
				  FROM RemoteRequests
				 WHERE DestServerID = ?
					AND RequestMode = 3
			 ORDER BY RequestSequenceID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

pendingRequests (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\udf\remote.cfm @ 12:54:41.041
			SELECT *
			  FROM RemoteRequests
			 WHERE DestServerID = ? 
				AND RequestMode IN (0,2)
		
		 ORDER BY RequestSequenceID, SourceServerID
		
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1

CacheInfo (Datasource=commonspot-site-dhs, Time=3ms, Records=44) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 12:54:41.041
			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) = 6
Parameter #2(CF_SQL_INTEGER) = 5075
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1

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

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

inheritedCacheSettings (Datasource=commonspot-site-dhs, Time=1ms, Records=3) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 12:54:41.041
		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) = 1886
Parameter #3(CF_SQL_INTEGER) = 2

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

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

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

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

GetRenderOptions (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 12:54:41.041
			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) = 5075
Parameter #3(CF_SQL_INTEGER) = 1
Parameter #4(CF_SQL_INTEGER) = 1886
Parameter #5(CF_SQL_INTEGER) = 2

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

FormData (Datasource=commonspot-site-dhs, Time=43ms, Records=15) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 12:54:41.041
	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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 1
Parameter #6(CF_SQL_INTEGER) = 6
Parameter #7(CF_SQL_INTEGER) = 5075
Parameter #8(CF_SQL_INTEGER) = 1
Parameter #9(CF_SQL_INTEGER) = 1886
Parameter #10(CF_SQL_INTEGER) = 2
Parameter #11(CF_SQL_INTEGER) = 18

NamedClasses (Datasource=commonspot-site-dhs, Time=0ms, Records=13) in C:\inetpub\wwwroot\commonspot\style\load-page-classes.cfm @ 12:54:41.041
	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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 2

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

PageStyleSheets (Datasource=commonspot-site-dhs, Time=1ms, Records=4) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 12:54:41.041
		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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 1376
Parameter #6(CF_SQL_INTEGER) = 2

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

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

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

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

CacheInfo (Datasource=commonspot-site-dhs, Time=2ms, Records=49) in C:\inetpub\wwwroot\commonspot\components\cache\cache-status.cfc @ 12:54:41.041
			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) = 22
Parameter #2(CF_SQL_INTEGER) = 5143
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 1

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

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

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

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

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

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

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

GetRenderOptions (Datasource=commonspot-site-dhs, Time=0ms, Records=0) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 12:54:41.041
			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) = 5075
Parameter #3(CF_SQL_INTEGER) = 1
Parameter #4(CF_SQL_INTEGER) = 1886
Parameter #5(CF_SQL_INTEGER) = 2
Parameter #6(CF_SQL_INTEGER) = 5143

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

FormData (Datasource=commonspot-site-dhs, Time=25ms, Records=20) in C:\inetpub\wwwroot\commonspot\metadata\build-struct.cfm @ 12:54:41.041
	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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 5143
Parameter #6(CF_SQL_INTEGER) = 22
Parameter #7(CF_SQL_INTEGER) = 1
Parameter #8(CF_SQL_INTEGER) = 6
Parameter #9(CF_SQL_INTEGER) = 5075
Parameter #10(CF_SQL_INTEGER) = 1
Parameter #11(CF_SQL_INTEGER) = 1886
Parameter #12(CF_SQL_INTEGER) = 2
Parameter #13(CF_SQL_INTEGER) = 8

NamedClasses (Datasource=commonspot-site-dhs, Time=1ms, Records=21) in C:\inetpub\wwwroot\commonspot\style\load-page-classes.cfm @ 12:54:41.041
	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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 5143
Parameter #6(CF_SQL_INTEGER) = 2

StyleSheetGroups (Datasource=commonspot-site-dhs, Time=1ms, Records=3) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 12:54:41.041
		SELECT *
		  FROM Data_StyleSheetGroups
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState = ?
	 ORDER BY PageID DESC, ItemPos ASC
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 5143
Parameter #6(CF_SQL_INTEGER) = 2

PageStyleSheets (Datasource=commonspot-site-dhs, Time=1ms, Records=4) in C:\inetpub\wwwroot\commonspot\utilities\set-style-vars.cfm @ 12:54:41.041
		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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 5143
Parameter #6(CF_SQL_INTEGER) = 1376
Parameter #7(CF_SQL_INTEGER) = 2

CheckCustomRender (Datasource=commonspot-site-dhs, Time=1ms, Records=16) in C:\inetpub\wwwroot\commonspot\utilities\populate-page.cfm @ 12:54:41.041
		SELECT *
		  FROM Data_Custom_Render
		 WHERE (PageID IN (?,?,?,?,?)) 
			AND VersionState >= ?
			AND ModuleID <> 0
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 5143
Parameter #6(CF_SQL_INTEGER) = 2

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

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

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

SelectedCustomRenderElements (Datasource=commonspot-site-dhs, Time=0ms, Records=16) in C:\inetpub\wwwroot\commonspot\set-page-vars.cfm @ 12:54:41.041
		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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 5143
Parameter #6(CF_SQL_INTEGER) = 2

Request.PageData.PageParams (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\render-page-meat.cfm @ 12:54:41.041
			SELECT *
			  FROM Param_Page
			 WHERE (PageID=5143 OR (PageID IN (5075,1886,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 @ 12:54:41.041
					SELECT SubsiteID
					  FROM SitePages
					 WHERE ID = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5143

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

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

ControlInstanceData (Datasource=commonspot-site-dhs, Time=2ms, Records=105) in C:\inetpub\wwwroot\commonspot\controls\control-setup.cfm @ 12:54:41.041
		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) = 5075
Parameter #2(CF_SQL_INTEGER) = 1
Parameter #3(CF_SQL_INTEGER) = 1886
Parameter #4(CF_SQL_INTEGER) = 2
Parameter #5(CF_SQL_INTEGER) = 5143

qInfo (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\commands\element.cfc @ 12:54:41.041
		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) = 36

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

GetWDDXData (Datasource=commonspot-site-dhs, Time=1ms, Records=1) in C:\inetpub\wwwroot\commonspot\utilities\ct-extract-wddx-data.cfm @ 12:54:41.041
	SELECT *
	  FROM Data_WDDX
	 WHERE ControlID=?
		AND ItemID=?
		AND ElementTypeID = ? 
		AND ((PageID=5143 AND (VersionState = 2)) OR ((PageID IN (5075,1886,2,1)) AND (VersionState=2))) 
 ORDER BY PageID DESC, VersionID DESC, Sort1, Sort2 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 14294
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 36

getMdListIDs (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\query-engine\clause.cfc @ 12:54:42.042
			SELECT Data_FieldValue.PageID AS ColValue
			  FROM Data_FieldValue
			  JOIN Data_ListItems ON Data_FieldValue.ListID = Data_ListItems.ListID and Data_FieldValue.PageID = Data_ListItems.PageID
			 WHERE Data_FieldValue.FieldID = ?
				AND Data_FieldValue.FormID = ?
				AND Data_FieldValue.PageID > ?
				AND Data_FieldValue.ControlID = ?
				AND Data_FieldValue.VersionState >= ?  
				AND (Data_ListItems.StrItemValue = ?) 
			 GROUP BY Data_FieldValue.PageID 
			HAVING COUNT(Data_FieldValue.PageID) = 1 
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 14151
Parameter #2(CF_SQL_INTEGER) = 14149
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 2
Parameter #6(CF_SQL_VARCHAR) = Youth

pageIndexQuery (Datasource=commonspot-site-dhs, Time=1ms, Records=0) in C:\inetpub\wwwroot\commonspot\components\query-engine\page-index.cfc @ 12:54:42.042
			SELECT SitePages.*,GeneralCategories.Category 
				,UploadedDocs.PublicFileName
		
			  FROM GeneralCategories,SitePages 
			LEFT OUTER JOIN UploadedDocs ON UploadedDocs.PageID = SitePages.ID AND UploadedDocs.VersionState = 2
		
			 WHERE
				
		(SitePages.ExpDate >= ?
			OR	(SitePages.ExpDate is NULL or SitePages.ExpDate = ''))
	AND GeneralCategories.ID = SitePages.CategoryID AND GeneralCategories.CategoryTypeID = 1 AND SitePages.AudienceID = ? AND SitePages.SubSiteID <> ? AND SitePages.PageSetID = ? AND SitePages.ApprovalStatus = ? AND 
		( (SitePages.PageType IN (?,?,?,?)) 
		)
		AND 
		( (SitePages.IsPublic IN (?,?,?,?,?,?,?,?)) 
		)
	AND 
			(
			1=0 
			)
			
				ORDER BY SitePages.PublicReleaseDate desc,SitePages.title desc,SitePages.ID
			
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 2021-10-17 12:54:42
Parameter #2(CF_SQL_INTEGER) = 0
Parameter #3(CF_SQL_INTEGER) = 0
Parameter #4(CF_SQL_INTEGER) = 0
Parameter #5(CF_SQL_INTEGER) = 0
Parameter #6(CF_SQL_INTEGER) = 0
Parameter #7(CF_SQL_INTEGER) = 14
Parameter #8(CF_SQL_INTEGER) = 6
Parameter #9(CF_SQL_INTEGER) = 8
Parameter #10(CF_SQL_INTEGER) = 11
Parameter #11(CF_SQL_INTEGER) = 1
Parameter #12(CF_SQL_INTEGER) = 13
Parameter #13(CF_SQL_INTEGER) = 3
Parameter #14(CF_SQL_INTEGER) = 15
Parameter #15(CF_SQL_INTEGER) = 5
Parameter #16(CF_SQL_INTEGER) = 7
Parameter #17(CF_SQL_INTEGER) = 9

GetDocType (Datasource=commonspot-site-dhs, Time=2ms, Records=81) in C:\inetpub\wwwroot\commonspot\controls\pageindex\query-and-params.cfm @ 12:54:42.042
		SELECT *
		  FROM Formats
	
testQuery (Datasource=commonspot-site-dhs, Time=0ms, Records=1) in C:\inetpub\wwwroot\commonspot\udf\validation\generated-validators.cfm @ 12:54:42.042
		SELECT ID
		  FROM SitePages
		 WHERE ID = ?
			AND (PageType IN (0,1,2) AND Uploaded=0)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5143

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

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

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

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

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

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


Scope Variables

Application Variables:
activesubsites=1,2,5,6,8,17,18,19,20,21,22,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56
adf=Struct (88)
adfscheduler=Struct (0)
applicationname=site1
blogcache=Struct (4)
cachedimages=Struct (20)
cacheinfocache=Struct (51)
confidentiality=Array (5)
controlinstance_toplevel_cache=Struct (126)
covid_articlecount=6
covid_newsarticlecount=24
covid_pressreleasecount=4
covid_pubcount=2
cs_element_cache=Struct (0)
cs_resourcesmissing=Struct (0)
cs_rewriterulescache=Struct (21)
cs_subsitecachemanager=Struct (28)
customerscope=Struct (18)
custommodulecache=Struct (21)
defaultconfidentiality=2
dhspagesyncdata=Struct (1)
itemsecuritycache=Struct (31)
languagenames=Struct (51)
languages=Struct (51)
lastknownchange=Struct (18)
lastupdate=Struct (14)
metadatacache=Struct (3)
pendingstubrequests=Struct (0)
rsscache=Struct (2)
search_archive_next_clean=2021-10-17 17:16:40
search_orphan_next_clean=2021-10-17 17:16:41
serverstatus=Struct (1)
site=Struct (71)
sitescope=Struct (9)
styleids=Struct (248)
stylenames=Struct (248)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
taxonomy=Struct (2)
templatecache=Struct (28)
templatedefaultsecuritycache=Struct (60)
templateenforcedsecuritycache=Struct (60)
treecache=Struct (25)
twittercache=Struct (2)
typefactory=Complex type
youtubecache=Struct (3)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
CERT_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\dhs\topics\Youth-Corner\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, S=Illinois, L=Chicago, O="Trustwave Holdings, Inc.", CN="Trustwave Organization Validation SHA256 CA, Level 1", E=ca@trustwave.com
HTTPS_SERVER_SUBJECT=CN=*.dhsprogram.com, O=ICF International, L=Fairfax, S=Virginia, C=US
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=preview.dhsprogram.com
HTTP_REFERER=
HTTP_URL=/topics/Youth-Corner/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\topics\Youth-Corner\index.cfm
QUERY_STRING=
REMOTE_ADDR=3.237.16.210
REMOTE_HOST=3.237.16.210
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/topics/Youth-Corner/index.cfm
SERVER_NAME=preview.dhsprogram.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=1568715
CFTOKEN=13431ceaa0f4a1ae-8F2F104E-F599-D9F9-6FD710710860E010
Request Parameters:
anonnoreadelements=
applockname=CS_App_Site1_1
archiveemail=archive@dhsprogram.com
assetsdir=/assets/
author_approve_whereclause=(VersionState = 2)
authormode=0
authorok=1
autologinhandled=0
blupfront=
browser=Struct (13)
browserallincluded=1
cachefilesused=38
cachestatus=Complex type
cfflushcount=0
cgivars=Struct (49)
constants=Complex type
cors.isCorsRequest=NO
cp=Struct (124)
cs_includedobjects=nwjs,pgIndexJS
cs_init_timings=Struct (23)
cs_isdashboardcmd=0
cs_runningdashboardcmdcode=0
ctrl_data=Struct (103)
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 (41)
elementrundetail=Struct (1)
elementsrun=1
environment=Struct (5)
finalreportids=5,26,21,10,18,30,39
finalreportna=139,315,445,488,107,138
formattedtimestamp=2021-10-17 12:54:41
getghost=
gvpageid=5143
hivbold=1,3,8,9
ignoreauthuser=0
imageupfront=
imgdir=/images/
includerootdir=/
initialsiteid=1
initticks=1634475281346
jswarnmessage=
linkdataupfront_itempos=
linkdataupfront_itemtitle=
lockid=0
mainpage=Struct (86)
master_cfm_used=1
maxperms=Complex type
metadata=Struct (1)
modeorderbyclause=VersionID Desc
modeorderbyclause_page=VersionID Desc
modewhereclause=(VersionState = 2)
modewhereclause_page=(VersionState = 2)
multisectionupfront=
noauthorreason=
nocacheelementtypes=
nondashboardincludedone=1
obcountires=EG,ZM
package=Struct (0)
page=Struct (85)
pagedata=Struct (1)
pagedhtmlitems=
pagedhtmlmenus=
pageperms=Complex type
pagesync=Struct (4)
params=Struct (4)
parentisbasetemplate=0
parenttemplate=Struct (3)
previewmode=0
readmodewhereclause=(VersionState = 2)
rebuilt_stubs=
renderedelements=Struct (0)
renderelementdata=Struct (0)
renderfordiff=0
renderforprint=0
renderstate=Struct (72)
req_cam_callcount=1
req_inittimestamp=2021-10-17 12:54:41.340
req_sequenceid=9820
req_startticks=1634475281340
rootdir=/
rootpath=
rooturldatasetadmin=https://preview.dhsprogram.com/data/dataset_admin
scheduleupfront=
serverdatasource=commonspot-sites
sessionlockname=Session_1_3BF8572B51E0C2EDEDEB21AE160C165A.cfusion
sessionstring=1_3BF8572B51E0C2EDEDEB21AE160C165A.cfusion
sicupfront=
sicupfrontparam=
site=Struct (71)
siteid=1
standardrenderhandlers=
structdoctypes=Struct (162)
styleids=Struct (248)
stylenames=Struct (248)
subsite=Struct (0)
subsitecache=Struct (44)
subsitecachebysecuritypageid=Struct (44)
subsiteid=22
taiupfrontparam=
tbupfront=
tbupfrontparam=
templatecachestatus=Struct (0)
templaterootdir=/
thecontrolid=14294
timestamp={ts '2021-10-17 12:54:41'}
trustcachestatus=1
typefactory=Complex type
udslockname=CS_Customer_commonspot-users
updatingschemas=0
user=Struct (27)
usersdatasource=commonspot-users
vcontrolid=14294
wanterrorsrethrown=0
warnmessage=
xmlbrowser=Struct (13)
Server Variables:
ADF=Struct (15)
COMMONSPOT=Struct (40)
EMAILALERTKEY=Cz/qOdKOVEQwE3OVjxl3UA==
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
adf=Struct (0)
authormode=0
contributemode=read
currentpageid=5143
debugmode=0
debugstate=Struct (1)
editmode=0
hasusertempfiles=0
language=Struct (216)
lastupdate=Struct (2)
lastuserupdate=1634475281361
lockid=0
lockobjectid=0
lockobjecttype=
locktype=
logintime=
ownedobjecttypes=
pendingapprovalpages=
pendingapprovals=
previewmode=0
requestedversioncounter=
requestedversiontimestamp=
sessionid=3BF8572B51E0C2EDEDEB21AE160C165A.cfusion
urltoken=CFID=1568715&CFTOKEN=13431ceaa0f4a1ae-8F2F104E-F599-D9F9-6FD710710860E010&jsessionid=3BF8572B51E0C2EDEDEB21AE160C165A.cfusion
usagelist=
user=Struct (27)
Debug Rendering Time: 35 ms