SUBSCRIBE TO OUR NEWSLETTER exit newsletter popup icon

FOLLOW BC SURF & SPORT bc facebook icon white bc twitter icon white bc pinterest icon white bc youtube icon white bc instagram icon white

ABOUT BC SURF & SPORT

B.C Surf & Sport began with one small store in Ft. Lauderdale, Florida over thirty-five years ago and is still owned and run today by the same surfers, skaters and snowboarders who built the business. Since that day in 1977, we have grown to 9 locations in 3 states with over 150 associates.


Debugging Information
ColdFusion Server Standard 2018,0,19,330149
Template /index.cfm
Time Stamp 19-Mar-24 06:19 AM
Locale English (US)
User Agent claudebot
Remote IP 54.235.6.60
Host Name 54.235.6.60


Execution Time

Total Time Avg Time Count Template
2700 ms 2700 ms 1 CFC[ D:/websites/application.cfc | onRequest(/index.cfm) ] from D:/websites/application.cfc
2700 ms 2700 ms 1 D:/websites/defaultWebsite/index.cfm
2624 ms 2624 ms 1 D:/websites/includes/footer.cfm
390 ms 390 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = New, department = Mens, recordcount = 3) ] from D:/websites/functions/category.cfc
245 ms 245 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = Saleitems, department = Womens, recordcount = 3) ] from D:/websites/functions/category.cfc
228 ms 228 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = Default, department = Womens, recordcount = 3) ] from D:/websites/functions/category.cfc
174 ms 174 ms 1 CFC[ D:/websites/application.cfc | onRequestStart(/index.cfm) ] from D:/websites/application.cfc
167 ms 167 ms 1 D:/websites/includes/application/check_db.cfm
122 ms 122 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = , department = Accessories, recordcount = 3) ] from D:/websites/functions/category.cfc
95 ms 95 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = , department = Snowboarding, recordcount = 3) ] from D:/websites/functions/category.cfc
85 ms 85 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = , department = Skateboards, recordcount = 3) ] from D:/websites/functions/category.cfc
69 ms 69 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = , department = Footwear, recordcount = 3) ] from D:/websites/functions/category.cfc
36 ms 36 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = , department = Surf Shop, recordcount = 3) ] from D:/websites/functions/category.cfc
33 ms 33 ms 1 CFC[ D:/websites/functions/category.cfc | getFeaturedItems(filter = , department = Kids, recordcount = 3) ] from D:/websites/functions/category.cfc
31 ms 31 ms 1 CFC[ D:/websites/functions/cms.cfc | getChildren(37E89363-F840-001F-D0D0C1F51DD37145) ] from D:/websites/functions/cms.cfc
6 ms 6 ms 1 CFC[ D:/websites/functions/cms.cfc | getChildren(392996B5-0856-30D9-82B641CD66F9813E) ] from D:/websites/functions/cms.cfc
5 ms 5 ms 1 CFC[ D:/websites/functions/cms.cfc | getChildren(385D1538-B54C-3F80-FFA8ED40CBCF7F9D) ] from D:/websites/functions/cms.cfc
5 ms 5 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(3575014A-EDB6-21D0-51829D81B2081191) ] from D:/websites/functions/cms.cfc
5 ms 5 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(3A1CA9E9-E7E4-20D5-73F8D0287EA77D9C) ] from D:/websites/functions/cms.cfc
5 ms 5 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(3A4BF3FC-92A3-4369-DE902AFB0FA40208) ] from D:/websites/functions/cms.cfc
4 ms 4 ms 1 CFC[ D:/websites/functions/cms.cfc | getChildren(1A914999-DFE6-3992-87E5EB96B4418AC1) ] from D:/websites/functions/cms.cfc
4 ms 4 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(35FD8DD0-ECD9-D4DB-CCB36427DF793CD8) ] from D:/websites/functions/cms.cfc
4 ms 4 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(367528A6-02D5-2606-1E8EAD27DFCF9231) ] from D:/websites/functions/cms.cfc
4 ms 4 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(369974F5-FEE3-6BF2-4BFB1627C1DFC7B2) ] from D:/websites/functions/cms.cfc
4 ms 4 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(37315476-024A-8BC9-D51E1DBAD6ED47A2) ] from D:/websites/functions/cms.cfc
4 ms 4 ms 1 D:/websites/includes/header.cfm
3 ms 3 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(35684555-EE35-F7BD-2C48AB815CFB5149) ] from D:/websites/functions/cms.cfc
3 ms 3 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(3581E028-0BA8-C86F-CA4ECFC3081F3CF7) ] from D:/websites/functions/cms.cfc
3 ms 3 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(35E53A2F-C82C-4DE8-CDD02EAA62DE69C2) ] from D:/websites/functions/cms.cfc
3 ms 3 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(36560044-E1D3-8E01-AE5A2AC67D5BBCF0) ] from D:/websites/functions/cms.cfc
3 ms 3 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(36913E04-EBCB-DAB8-962FE7042A6EC031) ] from D:/websites/functions/cms.cfc
3 ms 3 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(39F0B7AB-EA2B-839B-3806DC8452155F1C) ] from D:/websites/functions/cms.cfc
3 ms 3 ms 1 CFC[ D:/websites/functions/cms.cfc | getContentById(5C25A5EC-934B-0AFE-D9C7F220F22FD78F) ] from D:/websites/functions/cms.cfc
1 ms 1 ms 1 CFC[ D:/websites/application.cfc | onSessionStart() ] from D:/websites/application.cfc
1 ms 1 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Blind Reaper Sweater Pattern First Push Complete Skateboard, 8.125") ] from D:/websites/functions/utilities.cfc
1 ms 1 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Never Summer Proto Slinger Women's Snowboard, 2023) ] from D:/websites/functions/utilities.cfc
1 ms 1 ms 1 D:/websites/includes/application/sql_injection.cfm
0 ms 0 ms 1 CFC[ D:/websites/application.cfc | onRequestEnd(/index.cfm) ] from D:/websites/application.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/cart.cfc | getCartQtyTotal() ] from D:/websites/functions/cart.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/tracking.cfc | googleTrackingPixel(UA-2790860-5) ] from D:/websites/functions/tracking.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Anon MFI Lightweight Neck Warmer) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Autumn Mask Beanie) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Billabong Drift Away Women's Shorts) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Billabong Shenanigans Girls Trucker Hat) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Costa Del Mar Keeper Sunglasses Retainer) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Creature Logo Outline Long Shoreman Beanie) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(DC Shoes Manual Skates Shoes, Grey) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Dakine Aero Bar Rack Pad Set, 18") ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Dot Dash Poseur Sunglasses, Black Satin/Ice Blue) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Enjoi Half and Half First Push Complete Skateboard, 8.0") ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Lakai NB Numeric Jamie Foy 306 Skate Shoes, Phantom/Brown) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Lost Rad Ripper 5'5" Surfboard, FCS II) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(New Balance NB Numeric Jamie Foy 306 Skate Shoes, White/Black) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Protec Street Open Back Knee Pads, Camo) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Quiksilver Close Call Boy's Shorts Sleeve T-Shirt) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Reef Ahi Kids Sandals) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Salty Crew Tailed Long Sleeve Rashguard) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Shake Junt SJ Outline Snapback Adjustable Hat) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Stance Poly OTC Snow Socks) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Stance Tucked In Casual Crew Socks) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Stance x The Rolling Stones Ladies and Gentlemen Crew Socks) ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 CFC[ D:/websites/functions/utilities.cfc | titlecase(Vissla Solid Sets Eco Sofa Surfer Shorts, 18.5") ] from D:/websites/functions/utilities.cfc
0 ms 0 ms 1 D:/websites/includes/application/create_query_string.cfm
0 ms 0 ms 1 D:/websites/includes/application/session_defaults.cfm
0 ms 0 ms 1 D:/websites/includes/application/url_actions.cfm
0 ms 0 ms 1 D:/websites/includes/application/url_variable_defaults.cfm
4 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2879 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

checkThis (Datasource=koalaSQL, Time=167ms, Records=1) in D:\websites\includes\application\check_db.cfm @ 06:19:49.049
	SELECT Style_ID FROM TB_Styles
	
getChild (Datasource=muraDB, Time=31ms, Records=6) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '37E89363-F840-001F-D0D0C1F51DD37145') AND (active = 1) and display > 0
            ORDER BY orderno
        
getChild (Datasource=muraDB, Time=5ms, Records=11) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '385D1538-B54C-3F80-FFA8ED40CBCF7F9D') AND (active = 1) and display > 0
            ORDER BY orderno
        
gcbi (Datasource=muraDB, Time=2ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '5C25A5EC-934B-0AFE-D9C7F220F22FD78F') AND (active = 1) AND display > 0
        
getChild (Datasource=muraDB, Time=5ms, Records=9) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '392996B5-0856-30D9-82B641CD66F9813E') AND (active = 1) and display > 0
            ORDER BY orderno
        
gcbi (Datasource=muraDB, Time=3ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '39F0B7AB-EA2B-839B-3806DC8452155F1C') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=5ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3A1CA9E9-E7E4-20D5-73F8D0287EA77D9C') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=3ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '37315476-024A-8BC9-D51E1DBAD6ED47A2') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=4ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3A4BF3FC-92A3-4369-DE902AFB0FA40208') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=3ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35684555-EE35-F7BD-2C48AB815CFB5149') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=3ms, Records=0) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3581E028-0BA8-C86F-CA4ECFC3081F3CF7') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=4ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '3575014A-EDB6-21D0-51829D81B2081191') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=4ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35FD8DD0-ECD9-D4DB-CCB36427DF793CD8') AND (active = 1) AND display > 0
        
getChild (Datasource=muraDB, Time=3ms, Records=4) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '1A914999-DFE6-3992-87E5EB96B4418AC1') AND (active = 1) and display > 0
            ORDER BY orderno
        
gcbi (Datasource=muraDB, Time=3ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '35E53A2F-C82C-4DE8-CDD02EAA62DE69C2') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=3ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '36560044-E1D3-8E01-AE5A2AC67D5BBCF0') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=2ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '367528A6-02D5-2606-1E8EAD27DFCF9231') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=3ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '36913E04-EBCB-DAB8-962FE7042A6EC031') AND (active = 1) AND display > 0
        
gcbi (Datasource=muraDB, Time=3ms, Records=1) in D:\websites\functions\cms.cfc @ 06:19:49.049
            SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes
            FROM tcontent
            WHERE (contentID = '369974F5-FEE3-6BF2-4BFB1627C1DFC7B2') AND (active = 1) AND display > 0
        
getDepts (Datasource=, Time=0ms, Records=9) in D:\websites\includes\footer.cfm @ 06:19:49.049
          					SELECT dept,web_url,sort_position, category_style 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position
          				
webDepts (Datasource=koalaSQL, Time=18ms, Records=9) in D:\websites\includes\footer.cfm @ 06:19:49.049
							select distinct dept from web_all_products group by dept
						
getTyps (Datasource=, Time=0ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:49.049
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='MENS' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=19ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:49.049
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='MENS' 
											group by typ
										
getSubTyps (Datasource=, Time=0ms, Records=4) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=4) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=1) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=1) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=15) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='MENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=21ms, Records=14) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='MENS'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=368ms, Records=2346) in D:\websites\functions\category.cfc @ 06:19:49.049
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Mens' 
		
					and EXISTS (
						SELECT 1
						FROM tb_skus c WITH (NOLOCK)
						LEFT JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id)
						LEFT JOIN tb_receiptline e WITH (NOLOCK) ON (d.sku_bucket_id = e.sku_bucket_id)
						LEFT JOIN tb_receipt f WITH (NOLOCK) ON (e.receipt_num = f.receipt_num)
						WHERE c.style_id = a.style_id
							AND dateDiff(day,getDate(),f.date_time) < 30
					)
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=13ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:49.049
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
getTyps (Datasource=, Time=1ms, Records=8) in D:\websites\includes\footer.cfm @ 06:19:49.049
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='WOMENS' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=20ms, Records=8) in D:\websites\includes\footer.cfm @ 06:19:49.049
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='WOMENS' 
											group by typ
										
getSubTyps (Datasource=, Time=1ms, Records=5) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=4) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOTTOMS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=9) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=9) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='TOPS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:49.049
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SWIM' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SWIM' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=5) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=16) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=15) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='ACCESSORIES' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='DRESSES/ROMPERS' and upper(dept)='WOMENS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='DRESSES/ROMPERS' and upper(dept)='WOMENS'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=16ms, Records=0) in D:\websites\functions\category.cfc @ 06:19:50.050
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Womens' 
		
					and a.sale='Y'
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
firstQuery (Datasource=koalaSQL, Time=212ms, Records=1681) in D:\websites\functions\category.cfc @ 06:19:50.050
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Womens' 
		
					and EXISTS (
						SELECT 1
						FROM tb_skus c WITH (NOLOCK)
						LEFT JOIN tb_sku_buckets d WITH (NOLOCK) ON (c.sku_id = d.sku_id)
						LEFT JOIN tb_receiptline e WITH (NOLOCK) ON (d.sku_bucket_id = e.sku_bucket_id)
						LEFT JOIN tb_receipt f WITH (NOLOCK) ON (e.receipt_num = f.receipt_num)
						WHERE c.style_id = a.style_id
							AND dateDiff(day,getDate(),f.date_time) < 30
					)
				
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=9ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:50.050
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
this.returnQry (Datasource=, Time=1ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:50.050
				SELECT *, 1 as querySort
				FROM firstQuery
				UNION
				SELECT *, 2 as querySort
				FROM getFiller
				ORDER BY querySort, sortBy
			
getTyps (Datasource=, Time=0ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:50.050
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='KIDS' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=18ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:50.050
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='KIDS' 
											group by typ
										
getSubTyps (Datasource=, Time=0ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOYS' and upper(dept)='KIDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=5) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOYS' and upper(dept)='KIDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='GIRLS' and upper(dept)='KIDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GIRLS' and upper(dept)='KIDS'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=30ms, Records=151) in D:\websites\functions\category.cfc @ 06:19:50.050
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Kids' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=1ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:50.050
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
getTyps (Datasource=, Time=0ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:50.050
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='FOOTWEAR' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=19ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:50.050
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='FOOTWEAR' 
											group by typ
										
getSubTyps (Datasource=, Time=1ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='FOOTWEAR' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SANDALS' and upper(dept)='FOOTWEAR'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='FOOTWEAR' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SHOES' and upper(dept)='FOOTWEAR'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=63ms, Records=591) in D:\websites\functions\category.cfc @ 06:19:50.050
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Footwear' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=3ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:50.050
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
getTyps (Datasource=, Time=0ms, Records=12) in D:\websites\includes\footer.cfm @ 06:19:50.050
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='SKATEBOARDS' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=18ms, Records=11) in D:\websites\includes\footer.cfm @ 06:19:50.050
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SKATEBOARDS' 
											group by typ
										
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='COMPLETE SKATEBOARDS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='COMPLETE SKATEBOARDS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='PARTS AND ACCESSORIES' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PARTS AND ACCESSORIES' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD TRUCKS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD TRUCKS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD DECKS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD DECKS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD WHEELS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD WHEELS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='PROTECTIVE GEAR' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PROTECTIVE GEAR' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=5) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='LONGBOARDS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LONGBOARDS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATEBOARD BEARINGS' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATEBOARD BEARINGS' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='GRIPTAPE' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GRIPTAPE' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SKATES' and upper(dept)='SKATEBOARDS' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SKATES' and upper(dept)='SKATEBOARDS'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=77ms, Records=825) in D:\websites\functions\category.cfc @ 06:19:50.050
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Skateboards' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=4ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:50.050
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
getTyps (Datasource=, Time=0ms, Records=9) in D:\websites\includes\footer.cfm @ 06:19:50.050
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='SURF SHOP' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=18ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:50.050
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SURF SHOP' 
											group by typ
										
getSubTyps (Datasource=, Time=0ms, Records=4) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SURFBOARDS' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=4) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SURFBOARDS' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=7) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SURF ACCESSORIES' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SURF ACCESSORIES' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=4) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BODYBOARDING' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=17ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BODYBOARDING' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:50.050
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='STAND UP PADDLE' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=16ms, Records=1) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='STAND UP PADDLE' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=6) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='DIVE' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=16ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='DIVE' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='LYCRA' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LYCRA' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WETSUITS' and upper(dept)='SURF SHOP' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=2) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WETSUITS' and upper(dept)='SURF SHOP'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=33ms, Records=227) in D:\websites\functions\category.cfc @ 06:19:51.051
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Surf Shop' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=2ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:51.051
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
getTyps (Datasource=, Time=0ms, Records=8) in D:\websites\includes\footer.cfm @ 06:19:51.051
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='SNOWBOARDING' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=19ms, Records=8) in D:\websites\includes\footer.cfm @ 06:19:51.051
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='SNOWBOARDING' 
											group by typ
										
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD BINDINGS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BINDINGS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD BOOTS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BOOTS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='GOGGLES' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='GOGGLES' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD HELMETS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD HELMETS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD BAGS AND PACKS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD BAGS AND PACKS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARDS' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARDS' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=3) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='OUTERWEAR' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SNOWBOARD ACCESSORIES' and upper(dept)='SNOWBOARDING' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SNOWBOARD ACCESSORIES' and upper(dept)='SNOWBOARDING'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=86ms, Records=818) in D:\websites\functions\category.cfc @ 06:19:51.051
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Snowboarding' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=4ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:51.051
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
getTyps (Datasource=, Time=0ms, Records=21) in D:\websites\includes\footer.cfm @ 06:19:51.051
										SELECT typ, web_url 
										FROM application.getWebTaxonomy 
										WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
										ORDER BY sort_position
									
webTyps (Datasource=koalaSQL, Time=19ms, Records=21) in D:\websites\includes\footer.cfm @ 06:19:51.051
											SELECT distinct typ
											FROM web_all_products 
											WHERE subtyp1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
											group by typ
										
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BACKPACKS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BACKPACKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BAGS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BAGS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BEANIES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BEANIES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='HAIR CARE' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='HAIR CARE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='HATS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='HATS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='JEWELRY' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='JEWELRY' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='PURSES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='PURSES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SOCKS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SOCKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SUNGLASSES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SUNGLASSES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='SUNSCREEN/SKIN CARE' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='SUNSCREEN/SKIN CARE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WALLETS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=18ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WALLETS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WATCHES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=15ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WATCHES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='AUDIO AND VIDEO' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='FACEMASKS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='FACEMASKS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='STICKERS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='STICKERS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BOXERS/BRIEFS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BOXERS/BRIEFS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='WATER BOTTLES' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='WATER BOTTLES' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BEACH TOWELS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BEACH TOWELS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=1ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='COOLERS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=20ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='COOLERS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='BELTS' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='BELTS' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
getSubTyps (Datasource=, Time=0ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT subtyp_1, web_url 
																			FROM application.getWebTaxonomy 
																			WHERE subtyp_2='EMPTY' and subtyp_1<>'EMPTY' and upper(typ)='LUGGAGE' and upper(dept)='ACCESSORIES' 
																			ORDER BY sort_position
																		
webSubTyps (Datasource=koalaSQL, Time=19ms, Records=0) in D:\websites\includes\footer.cfm @ 06:19:51.051
																			SELECT distinct subtyp1
																			FROM web_all_products 
																			WHERE subtyp2='EMPTY' and subtyp1<>'EMPTY' and upper(typ)='LUGGAGE' and upper(dept)='ACCESSORIES'  
																			group by subtyp1 order by subtyp1 asc
																		
firstQuery (Datasource=koalaSQL, Time=110ms, Records=1311) in D:\websites\functions\category.cfc @ 06:19:51.051
		SELECT distinct a.style_id
		
		, max(a.url) as url
		, max(a.realName) as realName
		, max(a.style) as style
		, max(a.overallqoh) as overallqoh
		, max(a.sale) as sale
		, max(a.new) as new
		, max(a.SmallPicture) as SmallPicture
		, max(a.MediumPicture) as MediumPicture
		, max(a.LargePicture) as LargePicture
		, max(a.sortposition) as sortposition
		, max(a.dept) as dept
		, max(a.typ) as typ
		, max(a.subtyp1) as subtyp1
		, max(a.subtyp2) as subtyp2
		, max(a.subtyp3) as subtyp3
		, max(a.brand) as brand
		, max(a.branddisplay) as branddisplay
		, max(a.priceRange) as priceRange
		, min(a.salePriceRangeBottom) as salePriceRangeBottom
		, max(a.salePriceRangeTop) as salePriceRangeTop
		, max(a.ListPrice) as ListPrice
		, max(a.ranking) as ranking
		, max(a.romanticcopylong) as romanticcopylong
		, max(a.romanticcopyshort) as romanticcopyshort
		, max(a.depttree) as depttree
		, max(a.attr1list) as attr1list
		, max(a.sizelist) as sizelist
		, max(a.name) as name
		, max(a.prodreviewsaverage) as prodreviewsaverage
		, max(a.INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(a.INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(a.INTERNALPRICE) as INTERNALPRICE
		, max(a.TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(a.TERMSALEPRICE) as TERMSALEPRICE
		, max(a.TERMSALE) as TERMSALE
		, max(a.of1) as of1
        , max(a.of2) as of2
        , max(a.of3) as of3
        , max(a.of4) as of4
        , max(a.of5) as of5
        , max(a.of6) as of6
        , max(a.of7) as of7
        , max(a.of8) as of8
        , max(a.of9) as of9
        , max(a.of10) as of10
		, max(a.of11) as of11
		, max(a.of12) as of12
		, max(a.of13) as of13
		, max(a.of14) as of14
		, max(a.of15) as of15
		, max(a.of16) as of16
		, max(a.of17) as of17
		, max(a.of18) as of18
		, max(a.of19) as of19
		, max(a.of20) as of20
        , max(a.WEB_OF1) as WEB_OF1
        , max(a.WEB_OF2) as WEB_OF2
        , max(a.WEB_OF3) as WEB_OF3
        , max(a.WEB_OF4) as WEB_OF4
        , max(a.WEB_OF5) as WEB_OF5
        , max(a.WEB_OF6) as WEB_OF6
        , max(a.WEB_OF7) as WEB_OF7
        , max(a.WEB_OF8) as WEB_OF8
        , max(a.WEB_OF9) as WEB_OF9
        , max(a.WEB_OF10) as WEB_OF10
        , max(a.WEB_OF11) as WEB_OF11
        , max(a.WEB_OF12) as WEB_OF12 
        , max(a.WEB_OF13) as WEB_OF13
        , max(a.WEB_OF14) as WEB_OF14
        , max(a.WEB_OF15) as WEB_OF15
        , max(a.WEB_OF16) as WEB_OF16
        , max(a.WEB_OF17) as WEB_OF17
        , max(a.WEB_OF18) as WEB_OF18
        , max(a.WEB_OF19) as WEB_OF19
        , max(a.WEB_OF20) as WEB_OF20
		, 0 as sortBy
		
		FROM web_all_products a
		WHERE a.pictureid is not null
		
		
		and a.dept='Accessories' 
		
		
		
		and len(a.realName)>0
		
		
		GROUP BY a.STYLE_ID
		
this.returnQry (Datasource=, Time=7ms, Records=3) in D:\websites\functions\category.cfc @ 06:19:51.051
				SELECT *
				FROM firstQuery
				ORDER BY sortBy
			
getDepts (Datasource=, Time=0ms, Records=9) in D:\websites\includes\footer.cfm @ 06:19:51.051
          					SELECT dept,web_url,sort_position 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position
          		
getTyps (Datasource=, Time=0ms, Records=30) in D:\websites\includes\footer.cfm @ 06:19:51.051
                                    SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY'
                                    ORDER BY sort_position
                    			


Scope Variables

Application Variables:
accuratetaxchecksum=
accuratetaxlicensekey=
addtocarturl=https://www.bcsurf.com/
adminurl=https://www.bcsurf.com/web_admin/products/menu.cfm?style_id=
adwordsid=
allow_out_of_stock=NO
allow_sell_out_of_stock=NO
allow_show_out_of_stock=NO
altimgdir=D:\websites\prodimages\alt_images\
amazoncheckout=Struct (1)
applicationname=AppCFC
attr1_name=Color
attr2_name=Option
authorizenet=Struct (3)
bannerdir=D:\websites\images\banners\
bingverificationstr=
blogurl=
breakoutsizes=false
cms=muraDB
companyname=BC Surf & Sport
dbname=celerant
display_ship_methods=true
displaycount=24
displaypercentage=5
domesticshippingonly=false
ds=koalaSQL
egiftcardshippingmethodid=1
facebookurl=
fedex=Struct (12)
feedsdir=D:\websites\feeds\
filterlist=Price,Brand,Sale,New,Color,Size,length,test
forumemail=customerservice@bcsurf.com
freeshippingthreshold=50
fullauth=true
getwebtaxonomy=Query (272)
giftcardimgpath=file:///D:\websites\images/
giftcardpdfpath=D:\websites\giftcardPDF\
giftcardurl=https://www.bcsurf.com/info/e-gift-certificate
googleadwords=true
googleanalytics=true
googleanalyticsid=UA-2790860-5
googlecheckout=Struct (21)
googlefeedproducttype=Apparel & Accessories > Clothing
googleplusurl=
googleverificationstr=
homeurl=https://www.bcsurf.com/
imagedir=D:\websites\images\
instagramurl=
instockmsg=In-Stock
internationalcheckout=Struct (2)
invoverride=ALWAYS IN,DROP SHIP ITEM
isapirewritedir=D:\Program Files\Helicon\ISAPI_Rewrite3\
iscelerantactive=true
iscmsactive=false
isstorelocationsdbactive=false
largeprodimgdim=Struct (2)
locationdsdb=STORE_LOCATIONS
logdir=D:\websites\logs\
machine_id=8900
mailport=25
mailserver=127.0.0.1
medprodimgdim=Struct (2)
metadesc=
metatags=
multiplesitelist=/
mydomain=
orderemails=customerservice@bcsurf.com
outofstockmsg=Out of Stock
outofstockthreshold=0
packageid=0
packagetype=UNIVERSAL
pagetitle=BC Surf & Sport- Skate,Surf,Snowboard across the country since 1977
paypalconfig=Struct (11)
pinteresturl=
prefguestid=
pricing_store=90
prodimgdir=D:\websites\prodimages\
productreviews=true
qoh_store=ALL
quickcharge=Struct (6)
recaptcha=Struct (3)
receipttyp=SPECORDER
salesemail=customerservice@bcsurf.com
secureurl=https://www.bcsurf.com/
shiptomilitary=true
shiptostoreshippingmethodid=1
showattr1=true
showattr2=true
showsize=true
siteid=1
sitephone=800-528-9061
size_name=Size
smallprodimgdim=Struct (2)
speclist=length,test
startshoppingurl=https://www.bcsurf.com/
store=90
storelocator=false
supportemail=customerservice@bcsurf.com
tinyprodimgdim=Struct (2)
tsys=Struct (16)
twittername=
twitterurl=
ups=Struct (11)
use301redirects=false
use_authorizenet=true
use_avatax=false
use_celerant_shipping_rates=true
use_celerant_ups_live_rates=ON
use_dimensions=true
use_fedex_live_rates=false
use_giftcards=true
use_only_giftcards=true
use_quickcharge=false
use_ship_tax_codes=true
use_tsys=false
use_ups_live_rates=true
use_usps_live_rates=true
useaccuratetax=false
useamazoncheckout=false
usecelerantstorelocations=false
usegiftcerticates=true
usegooglecheckout=false
usepackages=false
usepaypal=true
usesavedcart=true
useshiptostore=true
usewebstylegrouping=false
usewishlists=true
usps=Struct (6)
util=Struct (27)
viewnosellmsg=Out of Stock
webadminurl=https://www.bcsurf.com/web_admin/
webroot=D:\websites\
websitename=BC Surf & Sport
wishlistemail=customerservice@bcsurf.com
wishlistphone=800-528-9061
woeurl=https://www.bcsurf.com/woe/
yahooverificationstr=
youtubeurl=
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.bcsurf.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\websites\defaultWebsite\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.bcsurf.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.bcsurf.com
HTTP_REFERER=https://www.bcsurf.com/brands/indo.html
HTTP_URL=/index.cfm
HTTP_USER_AGENT=claudebot
LOCAL_ADDR=192.168.50.250
PATH_INFO=
PATH_TRANSLATED=D:\websites\defaultWebsite\index.cfm
QUERY_STRING=
REMOTE_ADDR=54.235.6.60
REMOTE_HOST=54.235.6.60
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.bcsurf.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
cfid=34163756
cftoken=81e5c2d04b743752-5E3E7291-AB19-3C7B-9EE5B5061C73219D
Form Fields:
KWORD=
Request Parameters:
samesite_value=
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
altimgurl=https://www.bcsurf.com/prodimages/alt_images/
cartstatus=NEW
cfid=34163756
cftoken=81e5c2d04b743752-5E3E7291-AB19-3C7B-9EE5B5061C73219D
checkout=Struct (4)
couponreset=NO
cs=/index.cfm
customer_id=
customerdiscount=0
display_cc=YES
displaycount=25
email=
employeeloggedin=false
first_name=
iconurl=https://www.bcsurf.com/images/icons/
last_name=
memberloggedin=N
myreturnurl=https://www.bcsurf.com/index.cfm
password=
phone=
picurl=https://www.bcsurf.com/images/
prodimgurl=https://www.bcsurf.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_34163756_81e5c2d04b743752-5E3E7291-AB19-3C7B-9EE5B5061C73219D
shipmethodlist=0,1
urltoken=CFID=34163756&CFTOKEN=81e5c2d04b743752-5E3E7291-AB19-3C7B-9EE5B5061C73219D
username=
URL Parameters:
ACTION=
BRAND=
CHOOSEADDRESS=
CONFIRM=NO
CURRENTPAGE=1
Color=
DEPT=
GOTO=
KEYWORD=
NAV_CHOOSER=home
NEW=
ORDER=
ORDERBY=
PAGE=1
PAYMETHOD=CC
PERPAGE=
PPSUCCESS=NO
PRICE=
RATE=
RECEIPT_NUM=
RETURNTO=
RETURN_TO_PAGE=
SALE=
SAVEDCART=NO
SHIPPING=
SHOP=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
Size=
TITLE=
TYP=
WEB_TAXONOMY_ID=
length=
test=
Debug Rendering Time: 28 ms