Debugging Information
| ColdFusion Server Enterprise |
2021,0,21,330446 |
| Template |
/index.cfm |
| Time Stamp |
03-Aug-25 10:40 AM |
| Locale |
English (US) |
| User Agent |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Remote IP |
172.31.102.40 |
| Host Name |
172.31.102.40 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 62 ms |
62 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequest(/index.cfm) ] from E:/Lumens/Application.cfc |
| 62 ms |
62 ms |
1 |
E:/Lumens/Versions/v81QA/index.cfm |
| 31 ms |
31 ms |
1 |
E:/Lumens/Versions/v81QA/Fusebox1.cfm |
| 31 ms |
31 ms |
1 |
E:/Lumens/Versions/v81QA/header.cfm |
| 31 ms |
31 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template3/header_section.cfm |
| 16 ms |
16 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc |
| 16 ms |
16 ms |
1 |
E:/Lumens/Versions/v81QA/globalVariables.cfm |
| 16 ms |
16 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/nav-main.cfm |
| 15 ms |
15 ms |
1 |
E:/Lumens/Versions/v81QA/SQL/CourseClassDiscountQry.cfm |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc | INIT(GenooSandbox) ] from E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc | INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | INIT() ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getGraphicsDetails(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getSiteResourcePathDetailsByID(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CRLFInjectionFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/CrossSiteScriptingFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/DotDotSlashFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/FileUploadFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc | decodeEntities(/index.cfm?ClassID=3955&CourseID=1&fuseaction=1001) ] from E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc | decodeEntities(ClassID=3955&CourseID=1&fuseaction=1001) ] from E:/Lumens/shared/fuseguard/components/filters/FilterUtils.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/IDValidationFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/NullByteFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/QueryStringLengthFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/RepeatOffenderFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SQLInjectionFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/ScopeInjectionFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc | inspectRequest() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc | inspectsURI() ] from E:/Lumens/shared/fuseguard/components/filters/SessionHijackingFilter.cfc |
| 0 ms |
0 ms |
2 |
CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc | getRequestIPAddress() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc | processRequest(ip_address = 216.73.216.8) ] from E:/Lumens/shared/fuseguard/components/firewall.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc | shouldReInitialize() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc | init(GenooSandbox) ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc |
| 0 ms |
0 ms |
4 |
CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc | isCartExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc | isCartMerchandiseExist() ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc | init(GenooSandbox) ] from E:/Lumens/versions/v81QA/cfc/merchandise/merchandise.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc | INIT() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc | getFooterNavItems() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc | getUserNavItems() ] from E:/Lumens/versions/v81QA/cfc/systemoptions/poweruser/poweruser.cfc |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/Administration/SQL/CustomizationsQry.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/Administration/SQL/MenuQry.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/AppVariables.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/Circuits.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/checkPermission.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/footer.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/intercepts.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/nLoadVars.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/plugins/GlobalFunctions.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/templates/CourseClassDiscountList.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/templates/checkPermissionForUserRole.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/templates/loggedUserDetail.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/udf/index.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/udf/logger.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/back-top-mobile.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/branding-logo.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/cart.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/client-logo.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/facebook-pixel.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-analytics.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/google-tag-manager.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/menu_action.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-account.cfm |
| 0 ms |
0 ms |
2 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/nav-social-media.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/search.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/view-cart.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template3/footer_section.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/custom_style.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template3/includes/nav-tabs.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/view/css/style.cfm |
| 0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 78 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\checkPermission.cfm @ 10:40:09.009
SELECT DISTINCT ACA.int_actor_type_id
FROM tbl_access_control_rules ACR
INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id
WHERE
str_fuse_action LIKE ?
AND ISNULL(ACA.int_actor_type_id,'')<>''
AND ACA.bit_allow = 1
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 1001
MenuQry (Datasource=GenooSandbox, Time=0ms, Records=9) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:40:09.009
SET NOCOUNT ON
SELECT OrgID
, RegionID
, MenuItemID
, MenuItemType
, MainLevel
, SubLevel
,MainLevelSortOrder
, SubLevelSortOrder
,
SiteURL
, AccessLevel
, IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1
, IsNull(DisplayValue_1, '') AS DisplayValue_1
, IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2
, IsNull(DisplayValue_2, '') AS DisplayValue_2
, Condition
, LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName
, m.Label AS UniqueLable
, CASE
WHEN str_user_nav_label IS NULL
THEN CASE
WHEN MenuItemType != 'Lnk'
AND SiteURL = 'index.cfm?fuseaction=9440'
THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership')
WHEN MenuItemType != 'Lnk'
AND SiteURL = 'index.cfm?fuseaction=9620'
THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member')
/*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */
WHEN m.Label LIKE 'Donate'
THEN Replace(m.Label, 'Donate', 'Donate')
/*END NEO 00106 20 FEB 2015 Student Donations UC-02 */
WHEN m.Label LIKE 'MERCHANDISE'
THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
THEN Replace(m.Label, 'Scholarships', 'Scholarship')
ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"')
END
ELSE
/*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */
CASE
WHEN str_menu_label LIKE 'Donate'
THEN (str_user_nav_label)
ELSE str_user_nav_label
END
/*END NEO 00106 20 FEB 2015 Student Donations UC-02 */
END AS Label
, CASE
WHEN str_user_nav_label IS NULL
THEN CASE
WHEN MenuItemType != 'Lnk'
AND SiteURL = 'index.cfm?fuseaction=9440'
THEN Replace(m.Label, 'Membership', 'Membership')
WHEN MenuItemType != 'Lnk'
AND SiteURL = 'index.cfm?fuseaction=9620'
THEN Replace(m.Label, 'Member', 'Member')
/*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */
WHEN m.Label LIKE 'Donate'
THEN Replace(m.Label, 'Donate', 'Donate')
/*END NEO 00106 20 FEB 2015 Student Donations UC-02 */
WHEN m.Label LIKE 'MERCHANDISE'
THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
THEN Replace(m.Label, 'Scholarships', 'Scholarship')
ELSE m.Label
END
ELSE
/*BEGIN NEO 00106 20 FEB 2015 Student Donations UC-02 */
CASE
WHEN str_menu_label LIKE 'Donate'
THEN dbo.fun_strip_html((str_user_nav_label))
ELSE dbo.fun_strip_html(str_user_nav_label)
END
/*END NEO 00106 20 FEB 2015 Student Donations UC-02 */
END AS LabelNoHTML
, ISNULL(int_parent_id,0) as int_parent_id
, int_sort_order
, m.UniqueLabel
, m.bit_default_behavior
FROM MenuItems m
LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id
WHERE STATUS = 'A'
AND SubCategoryID IS NULL
AND (
int_actor_type_id = ?
OR
(
int_actor_type_id IS NULL
AND AccessLevel = ?
)
)
AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/
ORDER BY int_sort_order
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 90
Parameter #2(cf_sql_integer) = 90
qGetDashboardName (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 10:40:09.009
SET ANSI_NULLS ON
SELECT IsNull((
CASE
WHEN str_dashboard_name = ''
THEN NULL
ELSE str_dashboard_name
END
), CASE
WHEN ActorTypeID = 55
THEN 'Dashboard'
ELSE 'my dashboard'
END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */
FROM ActorTypes
WHERE ActorTypeID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 90
qLearnerfields (Datasource=GenooSandbox, Time=0ms, Records=107) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:40:09.009
SELECT pfo.int_order
, pf.str_field_display_name
, pf.str_field_name
, pfo.int_profile_field_tab_id
, pf.str_actor_types
, pf.chr_field_type
FROM tbl_profile_field_order pfo
INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id
WHERE pf.int_region_id = ?
AND bit_enabled = ?
AND
(
(
pf.chr_field_type not in ('C','O')
)
OR
(
pf.chr_field_type in ('C','O') AND
(
pf.str_actor_types LIKE ?
)
)
)
ORDER BY pfo.int_profile_field_tab_id
, pfo.int_order ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_varchar) = %90%
qsocialNetFieldDetails (Datasource=GenooSandbox, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:40:09.009
select * from tbl_social_media_details WHERE int_region_id = ?
order by int_order asc
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
qGraphics (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 10:40:09.009
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
qUserNavItems (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:40:09.009
SELECT menitms.SiteURL AS nav_site_url
, menitms.label AS nav_label
, menitms.rowNum
, COUNT(menitms.rowNum) OVER () AS Total_Rows
, menitms.DisplayCriteria_1
, menitms.DisplayValue_1
, menitms.DisplayCriteria_2
, menitms.DisplayValue_2
, menitms.Condition
, menitms.NewWindowName
FROM (
SELECT SiteURL
, label
, DisplayCriteria_1
, DisplayValue_1
, DisplayCriteria_2
, DisplayValue_2
, Condition
, Row_Number() OVER (
ORDER BY MenuitemID ASC
) AS rowNum
, NewWindowName
FROM MenuItems
WHERE AccessLevel
= ?
AND RegionID = ?
AND bit_display_in_nav=1
AND STATUS = ?
) menitms
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 90
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_char) = A
qFooterNavItems (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 10:40:09.009
SELECT menitms.SiteURL
, menitms.label
, menitms.AccessLevel
, menitms.rowNum
, ((rowNum - 1) / 4) + 1 AS block
, menitms.DisplayCriteria_1
, menitms.DisplayValue_1
, menitms.DisplayCriteria_2
, menitms.DisplayValue_2
, menitms.Condition
, menitms.NewWindowName
FROM (
SELECT SiteURL
, label
, AccessLevel
, DisplayCriteria_1
, DisplayValue_1
, DisplayCriteria_2
, DisplayValue_2
, Condition
, Row_Number() OVER (
ORDER BY MenuitemID ASC
) AS rowNum
, NewWindowName
FROM MenuItems
WHERE AccessLevel
= ?
AND RegionID = ?
AND bit_display_in_footer=1
AND STATUS = ?
) menitms
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 90
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_char) = A
q (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 10:40:09.009
DECLARE @currentTime DATETIME2 = ?
UPDATE tbl_cart_class_detail
SET EnteredDate = @currentTime
WHERE SessionID = ?;
UPDATE tbl_cart_merchandise_detail
SET EnteredDate = @currentTime
WHERE SessionID = ?;
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2025-08-03 10:40:09.628
Parameter #2(cf_sql_varchar) = 2254CA108D6C649A38AB93A0E41DCBDC.cfusion
Parameter #3(cf_sql_varchar) = 2254CA108D6C649A38AB93A0E41DCBDC.cfusion
variables.custom_scripts (Datasource=GenooSandbox, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 10:40:09.009
SELECT str_header_script
, str_footer_script
FROM tbl_style_settings WITH (NOLOCK)
-- WHERE int_region_id = Commented as long as multiple regions are not there
qTempMenu (Datasource=, Time=0ms, Records=5) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 10:40:09.009
select * from qTempMenu where MenuItemID NOT IN (529,600,2,456)
qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 10:40:09.009
select * from qSocialMedia order by int_order desc
qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 6
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 13
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 16
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 19
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 22
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 27
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 32
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 35
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 42
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qCourseMenu where int_parent_id = ?
and MenuItemType = ?
and Label <> ?
and int_parent_id<>0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 49
Parameter #2(cf_sql_varchar) = Sub
Parameter #3(cf_sql_varchar) = All Classes
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qMenu where int_parent_id = 513
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qMenu where int_parent_id = 520
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qMenu where int_parent_id = 5
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qMenu where int_parent_id = 6
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template3\includes\nav-main.cfm @ 10:40:09.009
select * from qMenu where int_parent_id = 7
CustomizationsQry (Datasource=GenooSandbox, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\Administration\SQL\CustomizationsQry.cfm @ 10:40:09.009
SELECT OrgID, RegionID, CustomizationID, rtrim(ltrim(FuseAction)) as fuseAction, Status,
CASE Status When 'A' Then 'Active' When 'I' Then 'Inactive' END AS StatusDesc,
CreateDate, CustomizationName, CustomizationDesc
FROM Customizations c
WHERE Status = 'A'
AND RegionID = 1
Order By Status, Fuseaction
CourseClassDiscountQry (Datasource=GenooSandbox, Time=15ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\CourseClassDiscountQry.cfm @ 10:40:09.009
DECLARE @EarlyBirdDate SMALLDATETIME
, @TimeZoneShift AS FLOAT
SET @EarlyBirdDate = (
SELECT EarlyBirdDate
FROM InstructionCalendar ic
INNER JOIN Classes cl ON cl.TermID = ic.TermID
WHERE cl.ClassID = ?
)
SET @TimeZoneShift = IsNull((
SELECT TimeZoneHourAdjustment
FROM Regions WITH (NOLOCK)
WHERE RegionID = ?
), 0)
SELECT cl.ClassID
, cf.FeeTypeID
, CASE
WHEN cf.FeeTypeID IN (3, 8)
THEN 'Other'
ELSE ft.Description
END AS FeeTypeDesc
, CASE cf.FeeTypeID
WHEN 2
THEN mt.Name
ELSE cf.Name
END AS FeeOptionName
, cl.Cost AS ClassFee
, cl.Name AS ClassName
, clf.Cost_1 AS DiscountedFee
, clf.Cost_2 AS Break_2_Fee
, clf.Cost_3 AS Break_3_Fee
, clf.QtyBreak_1
, clf.QtyBreak_2
, clf.QtyBreak_3
, clf.DiscountAmount_1 * -1 as DiscountAmount_1
, clf.DiscountAmount_2 * -1 as DiscountAmount_2
, clf.DiscountAmount_3 * -1 as DiscountAmount_3
, clf.StartDate
, clf.EndDate
, @EarlyBirdDate AS EarlyBirdDate
FROM CourseFees cf
INNER JOIN FeeTypes ft ON ft.FeeTypeID = cf.FeeTypeID
INNER JOIN ClassFees clf ON clf.CourseFeeID = cf.CourseFeeID
INNER JOIN Classes cl ON cl.ClassID = clf.ClassID
LEFT JOIN MembershipTypes mt ON mt.MembershipTypeID = cf.MembershipTypeID
WHERE (
ft.FeeTypeID IN (2, 3, 6, 8, 10)
OR (
ft.FeeTypeID = 1
AND cl.AllowQtyPurchase = 1
)
OR (
ft.FeeTypeID IN (4, 5)
AND DateAdd(hh, @TimeZoneShift, dbo.fun_GetDateCT()) BETWEEN clf.StartDate
AND clf.EndDate
)
)
AND clf.ClassID = ?
AND clf.STATUS = 'A'
ORDER BY FeeTypeDesc
, FeeOptionName
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3955
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_integer) = 3955
qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 10:40:09.009
select * from qSocialMedia order by int_order desc
Scope Variables
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=E:\Lumens\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=AWSALBAPP-2=_remove_; AWSALBAPP-3=_remove_; JSESSIONID=2254CA108D6C649A38AB93A0E41DCBDC.cfusion; AWSALBAPP-0=AAAAAAAAAAB+7FrA0ATqOR7iYIL8FrHDUxg0o77Ji9rE4KIEKU7WHbKBFi0uYO31hbRo9xUSqEHbMsbih2lU0T5j6idnfxKsWs4NLxGa2bTnOxAtX0aVLIu1gg32XH3k5eMnR1jdbLgreA==; LUMPERSIST=8F0DEA52B3B83B56A29AC17144F7615C; AWSALBAPP-1=_remove_
HTTP_HOST=genoosandbox.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm?ClassID=3955&CourseID=1&fuseaction=1001
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.100.167
PATH_INFO=
PATH_TRANSLATED=E:\Lumens\index.cfm
QUERY_STRING=ClassID=3955&CourseID=1&fuseaction=1001
REMOTE_ADDR=172.31.102.40
REMOTE_HOST=172.31.102.40
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=genoosandbox.augusoft.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
AWSALBAPP-0=AAAAAAAAAAB 7FrA0ATqOR7iYIL8FrHDUxg0o77Ji9rE4KIEKU7WHbKBFi0uYO31hbRo9xUSqEHbMsbih2lU0T5j6idnfxKsWs4NLxGa2bTnOxAtX0aVLIu1gg32XH3k5eMnR1jdbLgreA
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
JSESSIONID=2254CA108D6C649A38AB93A0E41DCBDC.cfusion
LUMPERSIST=8F0DEA52B3B83B56A29AC17144F7615C
Session Variables:
actortypeid=90
addtoken=CFID=18676965&CFTOKEN=52880885030b35c-65E6F469-F3BC-F7C1-E9122C1E0CCD3437&jsessionid=2254CA108D6C649A38AB93A0E41DCBDC.cfusion
allowunmaskeddata=0
appname=GenooSandbox
arrtrackflowregister=Array (6)
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.GenooSandbox
customerid=325
custompath=/Customers/GenooSandbox/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=genoosandbox.augusoft.net
ds=GenooSandbox
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=216.73.216.8
foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
loggedin=No
loggeduseremail=
loggeduserfname=Guest
loggeduserlname=
membershiptypeid=0
menuid=1
orgid=1
privacypolicyack=
regionid=1
sessionid=2254CA108D6C649A38AB93A0E41DCBDC.cfusion
sitepath=/Customers/GenooSandbox
sslreturnurl=https://genoosandbox.augusoft.net/
stylesheetpath=/Customers/GenooSandbox/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=18676969&CFTOKEN=809daff80c07ce12-65E7181F-FBE5-07D4-33D4679085EC472A&jsessionid=2254CA108D6C649A38AB93A0E41DCBDC.cfusion
version=v81QA
URL Parameters:
ClassID=3955
CourseID=1
fuseaction=1001
Debug Rendering Time: 16 ms
|
Login/Create account
