Membership - AnthologyDev2

Staging web site. (this banner will not appear on your "live" website)

Shopping cart is empty !

Last Viewed

Update your site by replacing this text with your own message.

Debugging Information

ColdFusion Server Enterprise	2021,0,21,330446
Template	/index.cfm
Time Stamp	18-Aug-25 02:36 PM
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.63
Host Name	172.31.102.63

Execution Time

Total Time	Avg Time	Count	Template
261 ms	261 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequest(/index.cfm) ] from E:/Lumens/Application.cfc
261 ms	261 ms	1	E:/Lumens/Versions/v81ERPQA/index.cfm
218 ms	218 ms	1	E:/Lumens/Versions/v81ERPQA/Fusebox1.cfm
125 ms	125 ms	1	E:/Lumens/Versions/v81ERPQA/templates/membership.cfm
47 ms	47 ms	1	CFC[ E:/Lumens/Application.cfc \| onRequestStart(/index.cfm) ] from E:/Lumens/Application.cfc
31 ms	31 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/MembershipTypesQry.cfm
31 ms	31 ms	1	E:/Lumens/Versions/v81ERPQA/globalVariables.cfm
27 ms	27 ms	1	E:/Lumens/Versions/v81ERPQA/header.cfm
27 ms	27 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/header_section.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81ERPQA/Administration/SQL/CustomizationsQry.cfm
16 ms	16 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/custom_style.cfm
15 ms	15 ms	1	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getsocialNetIconsControlFields(1) ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
11 ms	11 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-banner.cfm
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/cart/cart_dao.cfc \| INIT(AnthologyDev2) ] from E:/Lumens/Versions/v81ERPQA/cfc/cart/cart_dao.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc \| INIT() ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/ColorUtils.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| INIT() ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	2	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getGraphicsDetails(1) ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| getSiteResourcePathDetailsByID(1) ] from E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/Versions/v81ERPQA/cfc/systemoptions/siteconfiguration/siteconfiguration.cfc \| setLearnerfieldOrder(1, 90) ] from E:/Lumens/Versions/v81ERPQA/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/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.101) ] 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/v81ERPQA/cfc/cart/cart.cfc \| init(AnthologyDev2) ] from E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc
0 ms	0 ms	6	CFC[ E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc \| isCartExist() ] from E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc \| isCartMerchandiseExist() ] from E:/Lumens/versions/v81ERPQA/cfc/cart/cart.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/merchandise/merchandise.cfc \| init(AnthologyDev2) ] from E:/Lumens/versions/v81ERPQA/cfc/merchandise/merchandise.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc \| INIT() ] from E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc \| getFooterNavItems() ] from E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	CFC[ E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc \| getUserNavItems() ] from E:/Lumens/versions/v81ERPQA/cfc/systemoptions/poweruser/poweruser.cfc
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Administration/SQL/MenuQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/AppVariables.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Circuits.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/Profile/Templates/dspStudentEdit_Membership.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/Contents2Qry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/SQL/ContentsQry.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/checkPermission.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/intercepts.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/nLoadVars.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/plugins/GlobalFunctions.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/templates/checkPermissionForUserRole.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81ERPQA/templates/loggedUserDetail.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/udf/index.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/udf/logger.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/back-top-desktop.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/back-top-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/branding-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/cart/act_cart_action.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/cart/cart.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/client-logo-footer.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/client-logo.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/facebook-pixel.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/google-analytics.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/google-tag-manager.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/menu_action.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/nav-footer-buttons.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/nav-social-media.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/nav-user.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/search-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/shared/includes/search.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/footer_section.cfm
0 ms	0 ms	2	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-account.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-last-viewed.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-main.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/vendor/site_templates/template1/includes/nav-mobile.cfm
0 ms	0 ms	1	E:/Lumens/Versions/v81ERPQA/view/css/style.cfm
0 ms	0 ms	1	E:/Lumens/shared/CustomTags/UpdateMetaTagContent.cfm
0 ms	0 ms	1	E:/Lumens/shared/CustomTags/UpdatePageTitle.cfm
16 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
324 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

checkAccessControlRules (Datasource=LumensCustomers, Time=0ms, Records=6) in E:\Lumens\Versions\v81ERPQA\checkPermission.cfm @ 14:36:45.045

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) = 1050

MenuQry (Datasource=AnthologyDev2, Time=0ms, Records=10) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\MenuQry.cfm @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\MenuQry.cfm @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=112) in E:\Lumens\versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:36:45.045

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=AnthologyDev2, Time=15ms, Records=4) in E:\Lumens\versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:36:45.045

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qUserNavItems (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\cfc\systemoptions\poweruser\poweruser.cfc @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\cfc\systemoptions\poweruser\poweruser.cfc @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=0) in E:\Lumens\Application.cfc @ 14:36:45.045

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-18 14:36:45.557

			    
			        Parameter #2(cf_sql_varchar) = 6DC592AA939523ED10A4A0A1EEFE7857.cfusion

			    
			        Parameter #3(cf_sql_varchar) = 6DC592AA939523ED10A4A0A1EEFE7857.cfusion

variables.custom_scripts (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\versions\v81ERPQA\cfc\systemoptions\siteconfiguration\siteconfiguration.cfc @ 14:36:45.045

select * from UIVariables where RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 1

qSocialMediaHeader (Datasource=, Time=0ms, Records=4) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\shared\includes\nav-social-media.cfm @ 14:36:45.045

select * from qSocialMedia order by int_order desc

qGetDonateUserNavLabel (Datasource=AnthologyDev2, Time=11ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\header.cfm @ 14:36:45.045

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

qTempCourseMenu (Datasource=, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

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=1) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

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=2) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

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) = 9

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempCourseMenu (Datasource=, Time=0ms, Records=2) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

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) = 14

			    
			        Parameter #2(cf_sql_varchar) = Sub

			    
			        Parameter #3(cf_sql_varchar) = All Classes

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 540

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 518

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 500

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 616

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 2

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 5

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 6

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 7

qTempMenu (Datasource=, Time=0ms, Records=0) in E:\Lumens\Versions\v81ERPQA\vendor\site_templates\template1\includes\nav-main.cfm @ 14:36:45.045

select * from qMenu where int_parent_id = 458

CustomizationsQry (Datasource=AnthologyDev2, Time=16ms, Records=0) in E:\Lumens\Versions\v81ERPQA\Administration\SQL\CustomizationsQry.cfm @ 14:36:45.045

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=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\SQL\ContentsQry.cfm @ 14:36:45.045

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) = Membership

			    
			        Parameter #2(cf_sql_integer) = 1

			    
			        Parameter #3(cf_sql_integer) = 1

Content2 (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\SQL\Contents2Qry.cfm @ 14:36:45.045

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	regionid= ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = Membership2

			    
			        Parameter #2(cf_sql_integer) = 1

MembershipTypesQry (Datasource=AnthologyDev2, Time=31ms, Records=3) in E:\Lumens\Versions\v81ERPQA\SQL\MembershipTypesQry.cfm @ 14:36:45.045

SELECT MembershipTypeID, Code, Name, Description,
		AnnualFee, RenewalFee, TermInMonths, DiscountRate, DiscountAmount, MaxNumberMembers, SortOrder,flt_early_renewal_fee
		,bit_allow_student_purchase_mbrship /*Added Dec 14 2012 AI MembershipEnhancement Uc 10 Neo 00110*/
	FROM MembershipTypes
	WHERE Status = 'A' AND RegionID = 1	
	AND CASE WHEN str_mbrship_duration_type ='Terms' THEN (SELECT MAX(ClassesEndDate) FROM InstructionCalendar WHERE TermID IN(SELECT int_term_id FROM tbl_membership_type_terms WHERE int_membership_type_id = MembershipTypeID)) ELSE 1 END > CASE WHEN str_mbrship_duration_type ='Terms' THEN dbo.fun_GetDateCT() ELSE 0 END /*Added Jan 17 2013 AI Membership Enhancement:To avoid expired membership types Neo 00110*/
	
	
		AND bit_allow_student_purchase_mbrship=1
	
	
	ORDER BY IsDefault desc, SortOrder, Name

qGetMembershipTypes (Datasource=AnthologyDev2, Time=0ms, Records=1) in E:\Lumens\Versions\v81ERPQA\SQL\MembershipTypesQry.cfm @ 14:36:45.045

SELECT  count(distinct maxNumberMembers) as MembershipTypeCount
	FROM MembershipTypes
	WHERE Status = ? 
	AND RegionID = ?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_char) = A

			    
			        Parameter #2(cf_sql_integer) = 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-1=_remove_; LUMPERSIST=E5DFB803BA0DAEC2610B4F96D5071840; AWSALBAPP-3=_remove_; AWSALBAPP-2=_remove_; AWSALBAPP-0=AAAAAAAAAABZgJ1+lc0Uzzo8X5eAkzywW3jLRT8RECwfvAP+Wgiomtc99FmjKZN7V5w/+6Y+vgMu+gg7LlCJnEb1Mt6B/fd8XoXEr0NZpcGpn/i2mMndzlDWmt0kyVuDm0XSLQvZ81gDqw==; JSESSIONID=6DC592AA939523ED10A4A0A1EEFE7857.cfusion
HTTP_HOST=anthologydev2.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm?fuseaction=1050
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=fuseaction=1050
REMOTE_ADDR=172.31.102.63
REMOTE_HOST=172.31.102.63
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=anthologydev2.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=AAAAAAAAAABZgJ1 lc0Uzzo8X5eAkzywW3jLRT8RECwfvAP Wgiomtc99FmjKZN7V5w/ 6Y vgMu gg7LlCJnEb1Mt6B/fd8XoXEr0NZpcGpn/i2mMndzlDWmt0kyVuDm0XSLQvZ81gDqw
AWSALBAPP-1=_remove_
AWSALBAPP-2=_remove_
AWSALBAPP-3=_remove_
JSESSIONID=6DC592AA939523ED10A4A0A1EEFE7857.cfusion
LUMPERSIST=E5DFB803BA0DAEC2610B4F96D5071840

Session Variables:
actortypeid=90
addtoken=CFID=19168104&CFTOKEN=fa644322fa85d6b6-72D7197A-9A73-AD7D-78138ECC901AB309&jsessionid=6DC592AA939523ED10A4A0A1EEFE7857.cfusion
allowunmaskeddata=0
appname=AnthologyDev2
basecfcs=versions.v81ERPQA
basecode=/versions/v81ERPQA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.AnthologyDev2
customerid=618
custompath=/Customers/AnthologyDev2/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=anthologydev2.augusoft.net
ds=AnthologyDev2
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=216.73.216.101
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=6DC592AA939523ED10A4A0A1EEFE7857.cfusion
sitepath=/Customers/AnthologyDev2
sslreturnurl=https://anthologydev2.augusoft.net/
stylesheetpath=/Customers/AnthologyDev2/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=19168105&CFTOKEN=3a7299908f540925-72D72243-ED67-CB07-10EC2C03AB08401C&jsessionid=6DC592AA939523ED10A4A0A1EEFE7857.cfusion
version=v81ERPQA

URL Parameters:
fuseaction=1050

Debug Rendering Time: 16 ms