Debugging Information
| ColdFusion Server Enterprise |
2021,0,20,330407 |
| Template |
/index.cfm |
| Time Stamp |
16-Jul-25 02:26 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.103.217 |
| Host Name |
172.31.103.217 |
Execution Time
| Total Time |
Avg Time |
Count |
Template |
| 180 ms |
180 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc |
| 150 ms |
150 ms |
1 |
E:/Lumens/Versions/v81QA/globalVariables.cfm |
| 63 ms |
63 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onRequest(/index.cfm) ] from E:/Lumens/Application.cfc |
| 63 ms |
63 ms |
1 |
E:/Lumens/Versions/v81QA/Administration/SQL/FeatureConfigurationQry.cfm |
| 63 ms |
63 ms |
1 |
E:/Lumens/Versions/v81QA/index.cfm |
| 56 ms |
56 ms |
1 |
E:/Lumens/Versions/v81QA/Administration/SQL/MenuQry.cfm |
| 31 ms |
31 ms |
1 |
E:/Lumens/Versions/v81QA/header.cfm |
| 16 ms |
16 ms |
1 |
CFC[ E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc | getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 16 ms |
16 ms |
1 |
E:/Lumens/Versions/v81QA/templates/home.cfm |
| 16 ms |
8 ms |
2 |
E:/Lumens/shared/CustomTags/UpdateMetaTagContent.cfm |
| 15 ms |
15 ms |
1 |
CFC[ E:/Lumens/shared/fuseguard/components/firewall.cfc | processRequest(ip_address = 216.73.216.241) ] from E:/Lumens/shared/fuseguard/components/firewall.cfc |
| 15 ms |
15 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/cart/cart.cfc | init(testing6) ] from E:/Lumens/versions/v81QA/cfc/cart/cart.cfc |
| 15 ms |
15 ms |
1 |
CFC[ E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.cfc | styleExists(testing6, /customers/testing6) ] from E:/Lumens/versions/v81QA/cfc/stylesheet/styleManager.cfc |
| 15 ms |
15 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm |
| 15 ms |
15 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/header_section.cfm |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Application.cfc | onSessionStart() ] from E:/Lumens/Application.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/Versions/v81QA/cfc/cart/cart_dao.cfc | INIT(testing6) ] 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 |
2 |
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 | setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81QA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/app_setup.cfc | FindApplicationCustomer(LumensCustomers, testing6.augusoft.net) ] from E:/Lumens/app_setup.cfc |
| 0 ms |
0 ms |
1 |
CFC[ E:/Lumens/app_setup.cfc | INIT() ] from E:/Lumens/app_setup.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/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 | shouldReInitialize() ] from E:/Lumens/shared/fuseguard/components/firewall.cfc |
| 0 ms |
0 ms |
6 |
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(testing6) ] 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/AppVariables.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/Circuits.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/SQL/ContentsQry.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/checkPermissionForUserRole.cfm |
| 0 ms |
0 ms |
2 |
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-desktop.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 |
2 |
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-footer.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-footer-buttons.cfm |
| 0 ms |
0 ms |
1 |
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/nav-user.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/shared/includes/search-mobile.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/template1/footer_section.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/custom_style.cfm |
| 0 ms |
0 ms |
2 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-account.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-banner.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-main.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/vendor/site_templates/template1/includes/nav-mobile.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/Versions/v81QA/view/css/style.cfm |
| 0 ms |
0 ms |
1 |
E:/Lumens/shared/CustomTags/UpdatePageTitle.cfm |
| 0 ms | |
STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN |
| 243 ms | |
TOTAL EXECUTION TIME |
red = over 250 ms average execution time
SQL Queries
FeatureConfigurationQry (Datasource=testing6, Time=47ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\FeatureConfigurationQry.cfm @ 02:26:12.012
SET NOCOUNT ON
DECLARE @UsesRefundRequest CHAR(1)
SET @UsesRefundRequest = 0
SET @UsesRefundRequest = (
SELECT 1
FROM RefundPaymentMethods
WHERE RefundPaymentMethodID = 7
AND STATUS = 'A'
)
SELECT TOP 1 rg.RegionID
, rg.NAME
, rg.Address1
, rg.Address2
, rtrim(rg.City) + ', ' + rg.STATE + ' ' + rg.Zip AS CSZ
, rg.Phone1
, rg.SiteTitle
, rg.Footer
/**/
, rg.prefooter
, rg.brandingfooter
/**/
, rg.MetaText
, rg.EmailAux4
, IsNull((
SELECT Fee
FROM Products
WHERE Code = 'REGFEE'
AND STATUS = 'A'
AND RegionID = rg.RegionID
), 0.00) AS RegistrationFee
, IsNull((
SELECT Fee
FROM Products
WHERE Code = 'DEFERRED_PAYMENT_FEE'
AND STATUS = 'A'
AND RegionID = rg.RegionID
), 0.00) AS deferred_payment_fee
, fc.*
, @UsesRefundRequest AS UsesRefundRequest
, rg.privacy_data_mask_id
, rg.str_google_verify
, rg.str_yahoo_verify
, rg.str_hubspot_portal_id
, rg.str_hubspot_salog_version
, rg.str_hubspot_ppa
, rg.str_genoo_api_key
, rg.str_genoo_tracking_code
, rg.TimeZoneHourAdjustment
/**/
/**/
/**/
, e.str_erp_name
/**/
/**/
, CAST(DecryptByKeyAutoCert(cert_id('LumensCert'), NULL, ec.varbin_erp_password) AS NVARCHAR(500)) AS str_erp_password_decrypted
/**/
/**/
, rg.theURL
, rg.URLText
, rg.str_analytics_linked_domains
, rg.GTMContainerID
, rg.str_social_media_sharing
, ec.*
, (
SELECT TOP 1 Description
FROM PaymentMethods
WHERE PaymentMethodID >= 200
AND STATUS = 'A'
) AS str_internal_payment_method_name
FROM FeatureConfiguration fc
INNER JOIN Regions rg ON fc.RegionID = rg.RegionID
LEFT JOIN tbl_erp e ON fc.int_erp_id = e.int_erp_id
LEFT JOIN tbl_erp_config ec ON ec.str_erp_url <> ''
WHERE rg.STATUS = 'A'
qryGetRegion (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\globalVariables.cfm @ 02:26:12.012
SELECT regionId,orgID
FROM featureConfigurationQry
WHERE baseurl LIKE '%testing6.augusoft.net%'
MenuQry (Datasource=testing6, Time=40ms, Records=8) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 02:26:12.012
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=testing6, Time=16ms, Records=1) in E:\Lumens\Versions\v81QA\Administration\SQL\MenuQry.cfm @ 02:26:12.012
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=testing6, Time=0ms, Records=105) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 02:26:12.012
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=testing6, Time=16ms, Records=3) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 02:26:12.012
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=testing6, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 02:26:12.012
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
qUserNavItems (Datasource=testing6, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 02:26:12.012
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=testing6, Time=0ms, Records=0) in E:\Lumens\versions\v81QA\cfc\systemoptions\poweruser\poweruser.cfc @ 02:26:12.012
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
qryResult (Datasource=testing6, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 02:26:12.012
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-07-16 02:26:12.711
Parameter #2(cf_sql_varchar) = 64C3340819FD29F2188C10F25373B923.cfusion
Parameter #3(cf_sql_varchar) = 64C3340819FD29F2188C10F25373B923.cfusion
qryResult (Datasource=testing6, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 02:26:12.012
DECLARE @expireRequestsAfter DATETIME2 = ?;
DELETE FROM tbl_cart_class_detail WHERE EnteredDate <= @expireRequestsAfter;
DELETE FROM tbl_cart_merchandise_detail WHERE EnteredDate <= @expireRequestsAfter;
Query Parameter Value(s) -
Parameter #1(cf_sql_timestamp) = 2025-07-16 01:26:12.711
variables.custom_scripts (Datasource=testing6, Time=16ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 02:26:12.012
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
qGraphics (Datasource=testing6, Time=0ms, Records=1) in E:\Lumens\versions\v81QA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 02:26:12.012
select * from UIVariables where RegionID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
qTempMenu (Datasource=, Time=0ms, Records=7) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\menu_action.cfm @ 02:26:12.012
select * from qTempMenu where MenuItemID NOT IN (510)
qSocialMediaHeader (Datasource=, Time=0ms, Records=3) in E:\Lumens\Versions\v81QA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 02:26:12.012
select * from qSocialMedia order by int_order desc
qGetDonateUserNavLabel (Datasource=testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 02:26:12.012
SELECT isNull(str_user_nav_label,'') AS str_menu_label
FROM tbl_user_nav_menu_label
WHERE int_actor_type_id = ?
AND str_menu_label LIKE 'DONATE'
AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 90
qGetDonateUserNavLabel (Datasource=testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 02:26:12.012
SELECT isNull(str_user_nav_label,'') AS str_menu_label
FROM tbl_user_nav_menu_label
WHERE int_actor_type_id = ?
AND str_menu_label LIKE 'DONATE'
AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 90
qGetDonateUserNavLabel (Datasource=testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\header.cfm @ 02:26:12.012
SELECT isNull(str_user_nav_label,'') AS str_menu_label
FROM tbl_user_nav_menu_label
WHERE int_actor_type_id = ?
AND str_menu_label LIKE 'DONATE'
AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 90
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 02:26:12.012
select * from qMenu where int_parent_id = 576
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 02:26:12.012
select * from qMenu where int_parent_id = 503
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 02:26:12.012
select * from qMenu where int_parent_id = 603
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 02:26:12.012
select * from qMenu where int_parent_id = 2
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 02:26:12.012
select * from qMenu where int_parent_id = 5
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 02:26:12.012
select * from qMenu where int_parent_id = 7
qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\vendor\site_templates\template1\includes\nav-main.cfm @ 02:26:12.012
select * from qMenu where int_parent_id = 458
CustomizationsQry (Datasource=testing6, Time=0ms, Records=0) in E:\Lumens\Versions\v81QA\Administration\SQL\CustomizationsQry.cfm @ 02:26:12.012
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
ContentsQry (Datasource=testing6, Time=0ms, Records=1) in E:\Lumens\Versions\v81QA\SQL\ContentsQry.cfm @ 02:26:12.012
SELECT ContentID
, OrgID
, RegionID
, Section
, Path
, Contents
, ContentsNoHTML
, Description
, Name
, emailTemplate
, str_default_condition
, str_page_title
, str_meta_description
, str_keywords
FROM Contents
WHERE Path = ?
AND orgid = ?
AND regionid= ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Home
Parameter #2(cf_sql_integer) = 1
Parameter #3(cf_sql_integer) = 1
Stored Procedures
q_customer_by_domain (Datasource=LumensCustomers, Time=0ms) in E:\Lumens\app_setup.cfc @ 02:26:12.012
| |
| parameters |
type | CFSQLType | value | variable | dbVarName |
IN |
cf_sql_varchar |
testing6.augusoft.net |
|
|
|
| |
| resultsets |
name | resultset |
qCustomer |
1 |
|
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-0=_remove_; AWSALBAPP-3=_remove_; AWSALBAPP-2=_remove_; AWSALBAPP-1=_remove_
HTTP_HOST=testing6.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.100.171
PATH_INFO=
PATH_TRANSLATED=E:\Lumens\index.cfm
QUERY_STRING=
REMOTE_ADDR=172.31.103.217
REMOTE_HOST=172.31.103.217
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=testing6.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=_remove_
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
LUMPERSIST=1590D730CD4EC2EB253015D5E95B7949
Session Variables:
actortypeid=90
addtoken=CFID=16354311&CFTOKEN=14a4cb08c54e514e-B543D5D4-ADFB-ACD6-24C8F65AFC2E6D63&jsessionid=64C3340819FD29F2188C10F25373B923.cfusion
allowunmaskeddata=0
appname=testing6
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=Syed123
customcfcs=customers.testing6
customerid=205
custompath=/customers/testing6/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=testing6.augusoft.net
ds=testing6
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=216.73.216.241
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=64C3340819FD29F2188C10F25373B923.cfusion
sitepath=/customers/testing6
sslreturnurl=https://testing6.augusoft.net/
stylesheetpath=/customers/testing6/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=16354311&CFTOKEN=14a4cb08c54e514e-B543D5D4-ADFB-ACD6-24C8F65AFC2E6D63&jsessionid=64C3340819FD29F2188C10F25373B923.cfusion
version=v81QA
Debug Rendering Time: 15 ms
|
buy 
Donate
Login/Create account
checkout
view cart (
