All Products

Sort by:

Display:

Items 37 to 45 of 125 total

5 6 7 8

Uberti 1873 Lever-Action Short Rifle and Carbine, .45LC, 20" Barrel - Case Hardened $1,965.00
In Stock
Brand: Uberti
Item Number: # 281

Benelli LUPO BEST Bolt-Action Rifle 6.5 Creedmoor 24" Barrel Open Country Camo $1,890.00
In Stock
Brand: Benelli
Item Number: # 11990

Franchi Affinity 3 Catalyst, 20 Gauge, 26" Barrel $1,350.00
In Stock
Brand: Franchi
Item Number: # 40873

Beretta 1301 Tactical Shotgun, 12 Gauge, 3", 18.5" Barrel, FDE $2,000.00
In Stock
Brand: Beretta
Item Number: # 7R3B33132CA11

Franchi Affinity 3.5 Waterfowl Elite 12GA 3.5" 28" Barrel Gore Optifade Timber Cobalt Shotgun $1,525.00
In Stock
Brand: Franchi
Item Number: # 41240

Stoeger M3500 Semi-Auto Shotgun 12 Gauge 28" Barrel Realtree Max-5 Bronze $985.00
In Stock
Brand: Stoeger
Item Number: # 31885

Vortex Razor Gen II Rifle Scope HD-E 1-6x24 JM-1 BDC RZR-16008 $2,199.00
In Stock
Brand: Vortex
Item Number: # RZR-16008

$N PWRHEAD BLADE 7MMRM 9.1/140 TXM 685B (10 BOX/100 PCS) $40.00
In Stock
Brand: Sako
Item Number: # C627685BSB10

Norma Bondstrike Extreme .300 Winchester Short Magnum 180gr - Case of 200 $1,244.99
In Stock
Brand: Norma
Item Number: # CASE-20175832

Sort by:

Display:

Items 37 to 45 of 125 total

5 6 7 8

Debugging Information

ColdFusion Server Standard	2021,0,13,330286
Template	/category.cfm
Time Stamp	14-May-24 05:37 PM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	13.58.25.75
Host Name	13.58.25.75

Execution Time

Total Time	Avg Time	Count	Template
203 ms	203 ms	1	C:\websites\bullseye\category.cfm
203 ms	203 ms	1	CFC[ C:/websites/bullseye/application.cfc \| onRequest(/category.cfm) ] from C:/websites/bullseye/application.cfc
94 ms	10 ms	9	C:/websites/bullseye/includes/views/thumbnails.cfm
31 ms	31 ms	1	C:/websites/bullseye/includes/footer.cfm
31 ms	31 ms	1	C:/websites/bullseye/includes/sidenav.cfm
31 ms	31 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc \| getProductsFromOverallQuery([complex value]) ] from C:/websites/bullseye/functions/category.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc \| init([complex value]) ] from C:/websites/bullseye/functions/category.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(23CAF9FB-155D-9BEA-014DE05AEA6984A7) ] from C:/websites/bullseye/functions/cms.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(28888, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(31799, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(12042, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(6797) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms	15 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(25C195B5-155D-9BEA-01E09712618C03C4) ] from C:/websites/bullseye/functions/cms.cfc
15 ms	15 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(9527, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms	15 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(11725) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	C:/websites/bullseye/includes/application/check_db.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/create_query_string.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/session_defaults.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/sql_injection.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/url_actions.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/url_variable_defaults.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/header.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/views/departments.cfm
0 ms	0 ms	1	CFC[ C:/websites/bullseye/application.cfc \| onRequestEnd(/category.cfm) ] from C:/websites/bullseye/application.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/application.cfc \| onRequestStart(/category.cfm) ] from C:/websites/bullseye/application.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/application.cfc \| onSessionStart() ] from C:/websites/bullseye/application.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cart.cfc \| getCartQtyTotal(false) ] from C:/websites/bullseye/functions/cart.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc \| checkForBottomTaxonomyLevel([complex value]) ] from C:/websites/bullseye/functions/category.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc \| createPagination(125, 5, 9, 5, https://www.bullseyenorth.com/all-products/browse/instock/all/preorders/yes, [complex value], [complex value]) ] from C:/websites/bullseye/functions/category.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc \| getPageTitleFromFormula([complex value]) ] from C:/websites/bullseye/functions/category.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc \| loadCategoryQuery([complex value]) ] from C:/websites/bullseye/functions/category.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getChildren(25C195B5-155D-9BEA-01E09712618C03C4) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(2363C0DF-155D-9BEA-018D2CD496E7A280) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(236C0F49-155D-9BEA-014E0DE3321A0824) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(236C2F35-155D-9BEA-0116EE02CB815150) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(236CDE9D-155D-9BEA-018641D3692BE8E9) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(236CFAC8-155D-9BEA-014EF87802FDB145) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(236D22DF-155D-9BEA-010FAA115A719DE2) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(36A31A9E-E77A-435E-A56D80D272E5C3DB) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(5BF5D4F7-B37F-F6D3-63451E6205BEB29C) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getContentById(831A3F76-155D-9BEA-01EECAF7F29E927E) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(11725, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(12042, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(28590, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(30564, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(30607, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(6797, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(11725, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(28590, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(28888, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(30564, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(30607, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(31799, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(6797, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(9527, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(11725) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(12042) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(28590) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(28888) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(30564) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(30607) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(31799) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(9527) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(12042) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(28590) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(28888) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(30564) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(30607) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(31799) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(6797) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(9527) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/tracking.cfc \| googleTrackingPixel(UA-59690783-1) ] from C:/websites/bullseye/functions/tracking.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(12 GAUGE) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(12) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(12GA) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(17 HMR) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(20) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(20GA) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(22 LR) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(25-to-50) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(28GA) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(30-06) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(30-30) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(300 WINCHESTER MAGNUM) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(300-to-350) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(308 WIN) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(308 WINCHESTER) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(350-to-400) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(400-to-450) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(410GA) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(45-70) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(450-to-500) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(45LC) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(500-or-more) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(6.5 CREEDMOOR) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(6.5 PRC) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(7MM REMINGTON) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Benelli) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Beretta) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Browning) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Franchi) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Norma) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Sako) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Stoeger) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Tikka) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Uberti) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Vortex) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Winchester) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| resolveUrlVar(all) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL($N PWRHEAD BLADE 7MMRM 9.1/140 TXM 685B (10 BOX/100 PCS), 31799) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Benelli LUPO BEST Bolt-Action Rifle 6.5 Creedmoor 24" Barrel Open Country Camo, 30607) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Beretta 1301 Tactical Shotgun, 12 Gauge, 3", 18.5" Barrel, FDE, 11725) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Franchi Affinity 3 Catalyst, 20 Gauge, 26" Barrel, 12042) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Franchi Affinity 3.5 Waterfowl Elite 12GA 3.5" 28" Barrel Gore Optifade Timber Cobalt Shotgun, 28590) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Norma Bondstrike Extreme .300 Winchester Short Magnum 180gr - Case of 200, 30564) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Stoeger M3500 Semi-Auto Shotgun 12 Gauge 28" Barrel Realtree Max-5 Bronze, 6797) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Uberti 1873 Lever-Action Short Rifle and Carbine, .45LC, 20" Barrel - Case Hardened, 28888) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Vortex Razor Gen II Rifle Scope HD-E 1-6x24 JM-1 BDC RZR-16008, 9527) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| titlecase(ALL) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
203 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

checkThis (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\includes\application\check_db.cfm @ 17:37:13.013

SELECT Style_ID FROM TB_Styles

getQueryStr (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\category.cfc @ 17:37:13.013

select * from web_category_mappings where url='all-products' or url='/all-products'

Getwebdepts (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\functions\category.cfc @ 17:37:13.013

select * from application.getWebTaxonomy where upper(web_url)=?  and sort_position<>'NO'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) =

gcbi (Datasource=muraDB, Time=0ms, Records=0) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '5BF5D4F7-B37F-F6D3-63451E6205BEB29C') AND (active = 1) AND display > 0

checkTaxonomyLevel (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\functions\category.cfc @ 17:37:13.013

select dept, typ, subtyp_1, subtyp_2, subtyp_3,category_style from application.getWebTaxonomy where 
		
			dept='' and typ='' and subtyp_1='' and subtyp_2='' and subtyp_3=''	
		order by dept asc, typ asc, subtyp_1 asc, subtyp_2 asc, subtyp_3 asc

GetALLProducts (Datasource=koalaSQL, Time=31ms, Records=125) in C:\websites\bullseye\functions\category.cfc @ 17:37:13.013

SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(usePackage) as usePackage
		, max(sale) as sale
		, max(new) as new
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, min(sortposition) as sortposition
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(attr1list) as attr1list
		, max(sizelist) as sizelist
		, max(name) as name
		, max(gender) as gender
		, max(agerange) as agerange
		, max(picture_id) as picture_id
		, max(prodReviewsAverage) as prodReviewsAverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE
		, max(of1) as of1
        , max(of2) as of2
        , max(of3) as of3
        , max(of4) as of4
        , max(of5) as of5
        , max(of6) as of6
        , max(of7) as of7
        , max(of8) as of8
        , max(of9) as of9
        , max(of10) as of10
		, max(of11) as of11
		, max(of12) as of12
		, max(of13) as of13
		, max(of14) as of14
		, max(of15) as of15
		, max(of16) as of16
		, max(of17) as of17
		, max(of18) as of18
		, max(of19) as of19
		, max(of20) as of20
        , max(WEB_OF1) as WEB_OF1
        , max(WEB_OF2) as WEB_OF2
        , max(WEB_OF3) as WEB_OF3
        , max(WEB_OF4) as WEB_OF4
        , max(WEB_OF5) as WEB_OF5
        , max(WEB_OF6) as WEB_OF6
        , max(WEB_OF7) as WEB_OF7
        , max(WEB_OF8) as WEB_OF8
        , max(WEB_OF9) as WEB_OF9
        , max(WEB_OF10) as WEB_OF10
        , max(WEB_OF11) as WEB_OF11
        , max(WEB_OF12) as WEB_OF12 
        , max(WEB_OF13) as WEB_OF13
        , max(WEB_OF14) as WEB_OF14
        , max(WEB_OF15) as WEB_OF15
        , max(WEB_OF16) as WEB_OF16
        , max(WEB_OF17) as WEB_OF17
        , max(WEB_OF18) as WEB_OF18
        , max(WEB_OF19) as WEB_OF19
        , max(WEB_OF20) as WEB_OF20
		, min(deposit) as deposit
		, max(last_rcvd) as last_rcvd
		, ROW_NUMBER() OVER(ORDER BY max(OF7) ASC) AS RowNum
		FROM [dbo].[web_all_products] 
        WHERE 1=1
            --AND pictureid is not null

		
							--Do Nothing Here
                    and upper(of12) = 'YES' GROUP BY STYLE_ID
		ORDER BY min(sortposition)

results (Datasource=, Time=0ms, Records=125) in C:\websites\bullseye\functions\category.cfc @ 17:37:13.013

SELECT * FROM GetALLProducts ORDER BY
		last_rcvd desc

getTaxTree (Datasource=koalaSQL, Time=0ms, Records=11, Cached Query) in C:\websites\bullseye\includes\views\departments.cfm @ 17:37:13.013

SELECT max(dept) as dept, max(web_url) as web_url, max(sort_position) as sort_position
					FROM tb_web_taxonomy 
					WHERE dept>'' and typ='EMPTY' and dept<>'EMPTY'  
					group by dept
					ORDER BY sort_position

getCurrentDept (Datasource=, Time=0ms, Records=3) in C:\websites\bullseye\includes\views\departments.cfm @ 17:37:13.013

SELECT DISTINCT dept, count(distinct style_id) as itemCount 
                FROM getproducts 
                WHERE upper(dept)<>'EMPTY'  
					
					and style_id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
					
                GROUP BY dept

Query Parameter Value(s) -

			
			    
			        Parameter #1(CF_SQL_FLOAT) = 31752

			    
			        Parameter #2(CF_SQL_FLOAT) = 10210

			    
			        Parameter #3(CF_SQL_FLOAT) = 28816

			    
			        Parameter #4(CF_SQL_FLOAT) = 31749

			    
			        Parameter #5(CF_SQL_FLOAT) = 30608

			    
			        Parameter #6(CF_SQL_FLOAT) = 30615

			    
			        Parameter #7(CF_SQL_FLOAT) = 30628

			    
			        Parameter #8(CF_SQL_FLOAT) = 6795

			    
			        Parameter #9(CF_SQL_FLOAT) = 31750

			    
			        Parameter #10(CF_SQL_FLOAT) = 28842

			    
			        Parameter #11(CF_SQL_FLOAT) = 11318

			    
			        Parameter #12(CF_SQL_FLOAT) = 10340

			    
			        Parameter #13(CF_SQL_FLOAT) = 28841

			    
			        Parameter #14(CF_SQL_FLOAT) = 28369

			    
			        Parameter #15(CF_SQL_FLOAT) = 31746

			    
			        Parameter #16(CF_SQL_FLOAT) = 31748

			    
			        Parameter #17(CF_SQL_FLOAT) = 31753

			    
			        Parameter #18(CF_SQL_FLOAT) = 31193

			    
			        Parameter #19(CF_SQL_FLOAT) = 26665

			    
			        Parameter #20(CF_SQL_FLOAT) = 491

			    
			        Parameter #21(CF_SQL_FLOAT) = 2122

			    
			        Parameter #22(CF_SQL_FLOAT) = 12128

			    
			        Parameter #23(CF_SQL_FLOAT) = 25309

			    
			        Parameter #24(CF_SQL_FLOAT) = 9428

			    
			        Parameter #25(CF_SQL_FLOAT) = 31745

			    
			        Parameter #26(CF_SQL_FLOAT) = 11653

			    
			        Parameter #27(CF_SQL_FLOAT) = 29045

			    
			        Parameter #28(CF_SQL_FLOAT) = 28483

			    
			        Parameter #29(CF_SQL_FLOAT) = 11924

			    
			        Parameter #30(CF_SQL_FLOAT) = 31751

			    
			        Parameter #31(CF_SQL_FLOAT) = 31747

			    
			        Parameter #32(CF_SQL_FLOAT) = 31154

			    
			        Parameter #33(CF_SQL_FLOAT) = 31151

			    
			        Parameter #34(CF_SQL_FLOAT) = 23318

			    
			        Parameter #35(CF_SQL_FLOAT) = 30612

			    
			        Parameter #36(CF_SQL_FLOAT) = 30614

			    
			        Parameter #37(CF_SQL_FLOAT) = 28888

			    
			        Parameter #38(CF_SQL_FLOAT) = 30607

			    
			        Parameter #39(CF_SQL_FLOAT) = 12042

			    
			        Parameter #40(CF_SQL_FLOAT) = 11725

			    
			        Parameter #41(CF_SQL_FLOAT) = 28590

			    
			        Parameter #42(CF_SQL_FLOAT) = 6797

			    
			        Parameter #43(CF_SQL_FLOAT) = 9527

			    
			        Parameter #44(CF_SQL_FLOAT) = 31799

			    
			        Parameter #45(CF_SQL_FLOAT) = 30564

			    
			        Parameter #46(CF_SQL_FLOAT) = 30663

			    
			        Parameter #47(CF_SQL_FLOAT) = 30705

			    
			        Parameter #48(CF_SQL_FLOAT) = 30706

			    
			        Parameter #49(CF_SQL_FLOAT) = 30726

			    
			        Parameter #50(CF_SQL_FLOAT) = 30728

			    
			        Parameter #51(CF_SQL_FLOAT) = 30731

			    
			        Parameter #52(CF_SQL_FLOAT) = 30732

			    
			        Parameter #53(CF_SQL_FLOAT) = 30733

			    
			        Parameter #54(CF_SQL_FLOAT) = 30735

			    
			        Parameter #55(CF_SQL_FLOAT) = 30736

			    
			        Parameter #56(CF_SQL_FLOAT) = 30740

			    
			        Parameter #57(CF_SQL_FLOAT) = 30752

			    
			        Parameter #58(CF_SQL_FLOAT) = 30754

			    
			        Parameter #59(CF_SQL_FLOAT) = 30764

			    
			        Parameter #60(CF_SQL_FLOAT) = 30772

			    
			        Parameter #61(CF_SQL_FLOAT) = 30774

			    
			        Parameter #62(CF_SQL_FLOAT) = 30786

			    
			        Parameter #63(CF_SQL_FLOAT) = 30794

			    
			        Parameter #64(CF_SQL_FLOAT) = 30795

			    
			        Parameter #65(CF_SQL_FLOAT) = 30796

			    
			        Parameter #66(CF_SQL_FLOAT) = 30799

			    
			        Parameter #67(CF_SQL_FLOAT) = 30800

			    
			        Parameter #68(CF_SQL_FLOAT) = 30803

			    
			        Parameter #69(CF_SQL_FLOAT) = 30805

			    
			        Parameter #70(CF_SQL_FLOAT) = 30837

			    
			        Parameter #71(CF_SQL_FLOAT) = 30842

			    
			        Parameter #72(CF_SQL_FLOAT) = 30843

			    
			        Parameter #73(CF_SQL_FLOAT) = 30844

			    
			        Parameter #74(CF_SQL_FLOAT) = 30845

			    
			        Parameter #75(CF_SQL_FLOAT) = 30846

			    
			        Parameter #76(CF_SQL_FLOAT) = 30847

			    
			        Parameter #77(CF_SQL_FLOAT) = 30848

			    
			        Parameter #78(CF_SQL_FLOAT) = 30849

			    
			        Parameter #79(CF_SQL_FLOAT) = 30923

			    
			        Parameter #80(CF_SQL_FLOAT) = 30933

			    
			        Parameter #81(CF_SQL_FLOAT) = 30952

			    
			        Parameter #82(CF_SQL_FLOAT) = 30981

			    
			        Parameter #83(CF_SQL_FLOAT) = 30991

			    
			        Parameter #84(CF_SQL_FLOAT) = 31092

			    
			        Parameter #85(CF_SQL_FLOAT) = 31141

			    
			        Parameter #86(CF_SQL_FLOAT) = 31142

			    
			        Parameter #87(CF_SQL_FLOAT) = 31155

			    
			        Parameter #88(CF_SQL_FLOAT) = 31158

			    
			        Parameter #89(CF_SQL_FLOAT) = 31168

			    
			        Parameter #90(CF_SQL_FLOAT) = 31182

			    
			        Parameter #91(CF_SQL_FLOAT) = 31194

			    
			        Parameter #92(CF_SQL_FLOAT) = 31196

			    
			        Parameter #93(CF_SQL_FLOAT) = 31199

			    
			        Parameter #94(CF_SQL_FLOAT) = 31202

			    
			        Parameter #95(CF_SQL_FLOAT) = 31208

			    
			        Parameter #96(CF_SQL_FLOAT) = 31209

			    
			        Parameter #97(CF_SQL_FLOAT) = 31210

			    
			        Parameter #98(CF_SQL_FLOAT) = 31221

			    
			        Parameter #99(CF_SQL_FLOAT) = 31225

			    
			        Parameter #100(CF_SQL_FLOAT) = 31230

			    
			        Parameter #101(CF_SQL_FLOAT) = 31238

			    
			        Parameter #102(CF_SQL_FLOAT) = 31239

			    
			        Parameter #103(CF_SQL_FLOAT) = 31245

			    
			        Parameter #104(CF_SQL_FLOAT) = 31248

			    
			        Parameter #105(CF_SQL_FLOAT) = 31254

			    
			        Parameter #106(CF_SQL_FLOAT) = 31255

			    
			        Parameter #107(CF_SQL_FLOAT) = 31256

			    
			        Parameter #108(CF_SQL_FLOAT) = 31261

			    
			        Parameter #109(CF_SQL_FLOAT) = 31265

			    
			        Parameter #110(CF_SQL_FLOAT) = 31266

			    
			        Parameter #111(CF_SQL_FLOAT) = 31267

			    
			        Parameter #112(CF_SQL_FLOAT) = 12036

			    
			        Parameter #113(CF_SQL_FLOAT) = 12116

			    
			        Parameter #114(CF_SQL_FLOAT) = 12119

			    
			        Parameter #115(CF_SQL_FLOAT) = 12120

			    
			        Parameter #116(CF_SQL_FLOAT) = 12132

			    
			        Parameter #117(CF_SQL_FLOAT) = 12144

			    
			        Parameter #118(CF_SQL_FLOAT) = 12147

			    
			        Parameter #119(CF_SQL_FLOAT) = 12148

			    
			        Parameter #120(CF_SQL_FLOAT) = 28588

			    
			        Parameter #121(CF_SQL_FLOAT) = 28702

			    
			        Parameter #122(CF_SQL_FLOAT) = 28832

			    
			        Parameter #123(CF_SQL_FLOAT) = 28837

			    
			        Parameter #124(CF_SQL_FLOAT) = 28839

			    
			        Parameter #125(CF_SQL_FLOAT) = 28844

this.GetFilterQuery (Datasource=koalaSQL, Time=31ms, Records=11) in C:\websites\bullseye\includes\sidenav.cfm @ 17:37:13.013

SELECT max(brand) as brand,max(branddisplay) as branddisplay, count(distinct
      
        style_id
      
      ) as itemCount 
      FROM web_all_products 
      WHERE brand >'' and style_id IN (31752,10210,28816,31749,30608,30615,30628,6795,31750,28842,11318,10340,28841,28369,31746,31748,31753,31193,26665,491,2122,12128,25309,9428,31745,11653,29045,28483,11924,31751,31747,31154,31151,23318,30612,30614,28888,30607,12042,11725,28590,6797,9527,31799,30564,30663,30705,30706,30726,30728,30731,30732,30733,30735,30736,30740,30752,30754,30764,30772,30774,30786,30794,30795,30796,30799,30800,30803,30805,30837,30842,30843,30844,30845,30846,30847,30848,30849,30923,30933,30952,30981,30991,31092,31141,31142,31155,31158,31168,31182,31194,31196,31199,31202,31208,31209,31210,31221,31225,31230,31238,31239,31245,31248,31254,31255,31256,31261,31265,31266,31267,12036,12116,12119,12120,12132,12144,12147,12148,28588,28702,28832,28837,28839,28844)  
      GROUP BY Ltrim(brand),Ltrim(branddisplay)
      ORDER BY  max(brand) ASC

this.GetFilterQuery (Datasource=, Time=0ms, Records=19) in C:\websites\bullseye\includes\sidenav.cfm @ 17:37:13.013

SELECT distinct of18  , count(distinct
        
          style_id
        
        ) as itemCount 
        FROM GETPRODUCTS 
        WHERE of18 >''  
        GROUP BY of18 
        ORDER BY of18 asc

this.GetFilterQuery (Datasource=, Time=0ms, Records=6) in C:\websites\bullseye\includes\sidenav.cfm @ 17:37:13.013

SELECT pricerange as price, count(distinct
      
        style_id
      
      ) as itemCount FROM GETPRODUCTS 
      WHERE pricerange > ''
      GROUP BY pricerange 
      ORDER BY pricerange ASC

this.GetFilterQuery (Datasource=, Time=0ms, Records=6) in C:\websites\bullseye\includes\sidenav.cfm @ 17:37:13.013

SELECT * FROM temp ORDER BY ranking ASC

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 28888

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 28888

getQOHQueryCart (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 28888

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30607

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30607

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30607

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 12042

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 12042

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 12042

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 11725

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 11725

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 11725

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 28590

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 28590

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 28590

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 6797

get_rating (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 6797

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 6797

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 9527

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 9527

getQOHQueryCart (Datasource=koalaSQL, Time=15ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 9527

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 31799

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 31799

getQOHQueryCart (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 31799

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30564

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

select sum(overall_rating) as rating, count(*) as cnt 
        from tb_product_reviews 
        where style_id=? and status='A'

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30564

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

SELECT CASE WHEN max(isNull(a.of12,'')) = 'YES' THEN sum(c.qoh+c.qc+c.qoo) ELSE (CASE WHEN sum(c.qoh+c.qc)< 0 THEN 0 ELSE sum(c.qoh+c.qc) END) END as qoh      	
            , max(b.sku_id) as sku_id
			, max(b.scale_entry_id) as scale_entry_id
			, max(b.attr2_entry_id) as attr2_entry_id
			, max(e.attr1_entry_id) as attr1_entry_id
			, max(g.dept) as dept
			, max(a.style) as style
			, max(a.of12) as of12
			, max(a.of7) as of7
			, isNull(max(a.non_invt),'N') as non_invt
			, max(c.arrival_date) as arrival_date
		FROM tb_styles a WITH (NOLOCK)
		LEFT JOIN tb_skus b WITH (NOLOCK) ON (a.style_id = b.style_id)
		LEFT JOIN tb_sku_buckets c WITH (NOLOCK) ON (b.sku_id = c.sku_id)
		LEFT JOIN tb_size_entries d WITH (NOLOCK) ON (d.scale_entry_id = b.scale_entry_id)
		LEFT JOIN tb_attr1_entries e WITH (NOLOCK) ON (e.attr1_entry_id = b.attr1_entry_id)
		LEFT JOIN tb_attr2_entries f WITH (NOLOCK) ON (f.attr2_entry_id = b.attr2_entry_id)
		LEFT JOIN tb_taxonomy g WITH (NOLOCK) ON (g.taxonomy_id = a.taxonomy_id)
		
		WHERE a.style_id = ? 
        	and c.store_id=1 
		GROUP BY b.sku_id
		ORDER BY b.sku_id

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30564

gcbi (Datasource=muraDB, Time=16ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '23CAF9FB-155D-9BEA-014DE05AEA6984A7') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '2363C0DF-155D-9BEA-018D2CD496E7A280') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236C0F49-155D-9BEA-014E0DE3321A0824') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236C2F35-155D-9BEA-0116EE02CB815150') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236D22DF-155D-9BEA-010FAA115A719DE2') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236CFAC8-155D-9BEA-014EF87802FDB145') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '236CDE9D-155D-9BEA-018641D3692BE8E9') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=15ms, Records=0) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '25C195B5-155D-9BEA-01E09712618C03C4') AND (active = 1) AND display > 0

getChild (Datasource=muraDB, Time=0ms, Records=5) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Body, credits, display, Notes
            FROM tcontent
            WHERE (parentID = '25C195B5-155D-9BEA-01E09712618C03C4') AND (active = 1) and display > 0
            ORDER BY orderno

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '831A3F76-155D-9BEA-01EECAF7F29E927E') AND (active = 1) AND display > 0

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 17:37:13.013

SELECT contentID, active, Body, parentID, path, releaseDate, FileName, Title, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, credits, display, notes, HTMLTITLE, METAKEYWORDS, METADESC
            FROM tcontent
            WHERE (contentID = '36A31A9E-E77A-435E-A56D80D272E5C3DB') AND (active = 1) AND display > 0

getDepts (Datasource=, Time=0ms, Records=9) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT dept,web_url,sort_position 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=6) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='FIREARMS' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=8) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='AMMUNITION' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='MAGAZINES' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=8) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='RELOADING' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=7) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='STORAGE' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=8) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='OPTICS' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='KNIVES' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=14) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
                                    ORDER BY sort_position

getTyps (Datasource=, Time=0ms, Records=0) in C:\websites\bullseye\includes\footer.cfm @ 17:37:13.013

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ON SALE' 
                                    ORDER BY sort_position

Stored Procedures

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`28888`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`30607`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`12042`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=15ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`11725`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`28590`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`6797`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`9527`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`31799`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:37:13.013

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`30564`
`IN`	`CF_SQL_INTEGER`	`99`
`IN`	`CF_SQL_SMALLINT`	`1`

resultsets
`name`	`resultset`
`spResult`	`1`

Scope Variables

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.bullseyenorth.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\websites\bullseye\category.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.bullseyenorth.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ; fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu
HTTP_HOST=www.bullseyenorth.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=all-products/browse/instock/all/preorders/yes/page/5
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.16.53.112
PATH_INFO=
PATH_TRANSLATED=C:\websites\bullseye\category.cfm
QUERY_STRING=mapping=all-products/browse/instock/all/preorders/yes/page/5
REMOTE_ADDR=13.58.25.75
REMOTE_HOST=13.58.25.75
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/category.cfm
SERVER_NAME=www.bullseyenorth.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=12972953
CFTOKEN=62ddd6e2ed696083-BA6182E5-93E2-C5F9-07BCBDA55EADD714
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
fikker-KEPi-Z7Xa=BsBSbwRLNOhAxs6UKNM9KWTshGBARUhu

Form Fields:
KWORD=

Session Variables:
altimgurl=https://www.bullseyenorth.com/prodimages/alt_images/
cartstatus=NEW
cfid=12972953
cftoken=62ddd6e2ed696083-BA6182E5-93E2-C5F9-07BCBDA55EADD714
checkout=Struct (4)
couponreset=NO
cs=https://www.bullseyenorth.com/all-products/browse/instock/all/preorders/yes
customer_id=
customerdiscount=0
display_cc=YES
displaycount=9
email=
employeeloggedin=false
first_name=
iconurl=https://www.bullseyenorth.com/images/icons/
last_name=
memberloggedin=N
myreturnurl=https://www.bullseyenorth.com/all-products/browse/instock/all/preorders/yes
password=
phone=
picurl=https://www.bullseyenorth.com/images/
prodimgurl=https://www.bullseyenorth.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_12972953_62ddd6e2ed696083-BA6182E5-93E2-C5F9-07BCBDA55EADD714
shipmethodlist=0,1
urltoken=CFID=12972953&CFTOKEN=62ddd6e2ed696083-BA6182E5-93E2-C5F9-07BCBDA55EADD714
username=
website=Struct (1)

URL Parameters:
mapping=all-products/browse/instock/all/preorders/yes/page/5

Debug Rendering Time: 16 ms