Firearms

Sort by:

Display:

Items 1 to 9 of 93 total

1 2 3 4

Ruger Precision Rimfire Rifle 22 Long Rifle 18" Threaded Barrel Black $799.99
In Stock
Brand: Ruger
Item Number: # 340-08401

ISSC Scout SR Straight Pull Bolt Rifle 22LR 10 Rounds 612503 $599.99
In Stock
Brand: Issc
Item Number: # 612503

Benelli Lupo BE.S.T Bolt-Action Rifle 300 Win Mag 24" Barrel Elevated II $2,025.00
In Stock
Brand: Benelli
Item Number: # 11994

Benelli LUPO .308 Win 22" Barrel Matte BE.S.T./Open Country 5+1 Bolt-Action Rifle $2,025.00
In Stock
Brand: Benelli
Item Number: # 11996

Sako S20 Precision 6.5 PRC Bolt Action Rifle, 24" Barrel, 3+1rd Mag, Synthetic W/ Cerakote Tungsten $1,799.00
In Stock
Brand: Sako
Item Number: # SKS9636A42A9S0

Savage 110 Storm Bolt Action Rifle .270 Win 22" Barrel 4 Rounds Synthetic Adjustable AccuFit AccuStock Stainless Steel Finish Regular Price: $1,264.99 $1,138.49
In Stock
Brand: Savage
Item Number: # 57052

Black Creek Labs MRX Bison Recon Bolt Rifle 5.56 FDE 16.5" Barrel $1,059.99
In Stock
Brand: Black Creek Labs
Item Number: # BISRECFOLD55616FDE

Bergara B-14 Squared Crest .308 Winchester Bolt-Action Rifle, 20", Fluted Steel Barrel - Carbon Fiber $2,499.95
In Stock
Brand: Canuck
Item Number: # B14S751

Bergara B-14 Squared Crest 6.5 Creedmoor Bolt-Action Rifle, 20", Fluted Steel Barrel - Carbon Fiber $2,499.95
In Stock
Brand: Canuck
Item Number: # B14S752

Sort by:

Display:

Items 1 to 9 of 93 total

1 2 3 4

Debugging Information

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

Execution Time

Total Time	Avg Time	Count	Template
219 ms	219 ms	1	C:\websites\bullseye\category.cfm
219 ms	219 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
47 ms	47 ms	1	C:/websites/bullseye/includes/sidenav.cfm
31 ms	31 ms	1	C:/websites/bullseye/includes/footer.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	C:/websites/bullseye/includes/views/departments.cfm
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/cms.cfc \| getContentById(5BF5D4F7-B37F-F6D3-63451E6205BEB29C) ] from C:/websites/bullseye/functions/cms.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(30615) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(9910) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(30628) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms	16 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(33270) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms	15 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getChildren(25C195B5-155D-9BEA-01E09712618C03C4) ] from C:/websites/bullseye/functions/cms.cfc
15 ms	15 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(30640) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms	15 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(3372) ] 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	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(93, 1, 9, 5, https://www.bullseyenorth.com/firearms/browse/price/500-or-more/guntype/bolt-action/instock/all, [complex value], [complex value]) ] from C:/websites/bullseye/functions/category.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc \| init([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 \| 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(25C195B5-155D-9BEA-01E09712618C03C4) ] 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(831A3F76-155D-9BEA-01EECAF7F29E927E) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc \| getPagetByTitleAndParentId(firearms, 5BCE52F1-B419-688B-3A23CE726CD826CC) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(30608, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(30615, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(30628, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(30640, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(33270, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(33271, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(3372, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(6004, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| GetQOHQueryProd(9910, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(30608, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(30615, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(30628, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(30640, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(33270, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(33271, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(3372, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(6004, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviews(9910, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(30608) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(30628) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(33270) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(33271) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(3372) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| getProductReviewsAverage(6004) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(30608) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(30615) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(30640) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(33271) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(6004) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/itemDetails.cfc \| isStyleonQtyPricing(9910) ] 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(17 HMR) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(20 GAUGE) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(204 RUGER) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(22 250 REMINGTON) ] 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(22 WMR) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(223 REMINGTON) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(243 WINCHESTER) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(270 WINCHESTER) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(30 06 SPRINGFIELD) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(300 PRC) ] 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(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(45 70 GOVERNMENT) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(5.56 NATO) ] 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(7.62 x 39) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(7.62 x 54R) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(7MM REMINGTON MAGNUM) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(BOLT ACTION) ] 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(Bergara) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Black Creek Labs) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Canuck) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Christensen Arms) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Cz) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Hardy) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Henry) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Howa) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Issc) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Jp Sauer) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Maple Ridge Armoury) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Ruger) ] 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(Savage) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Sig Sauer) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Springfield Armory) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| prepUrlVar(Surplus) ] 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 \| resolveUrlVar(500-or-more) ] 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	2	CFC[ C:/websites/bullseye/functions/utilities.cfc \| resolveUrlVar(bolt-action) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Benelli LUPO .308 Win 22" Barrel Matte BE.S.T./Open Country 5+1 Bolt-Action Rifle, 30615) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Benelli Lupo BE.S.T Bolt-Action Rifle 300 Win Mag 24" Barrel Elevated II, 30608) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Bergara B-14 Squared Crest .308 Winchester Bolt-Action Rifle, 20", Fluted Steel Barrel - Carbon Fiber, 33270) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Bergara B-14 Squared Crest 6.5 Creedmoor Bolt-Action Rifle, 20", Fluted Steel Barrel - Carbon Fiber, 33271) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Black Creek Labs MRX Bison Recon Bolt Rifle 5.56 FDE 16.5" Barrel, 30640) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(ISSC Scout SR Straight Pull Bolt Rifle 22LR 10 Rounds 612503, 3372) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Ruger Precision Rimfire Rifle 22 Long Rifle 18" Threaded Barrel Black, 9910) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Sako S20 Precision 6.5 PRC Bolt Action Rifle, 24" Barrel, 3+1rd Mag, Synthetic W/ Cerakote Tungsten, 30628) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| safeURL(Savage 110 Storm Bolt Action Rifle .270 Win 22" Barrel 4 Rounds Synthetic Adjustable AccuFit AccuStock Stainless Steel Finish, 6004) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| titlecase(500 OR MORE) ] 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	0 ms	1	CFC[ C:/websites/bullseye/functions/utilities.cfc \| titlecase(BOLT ACTION) ] from C:/websites/bullseye/functions/utilities.cfc
15 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
234 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:13:47.047

SELECT Style_ID FROM TB_Styles

getQueryStr (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

select * from web_category_mappings where url='firearms' or url='/firearms'

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

select * 
				from application.getWebTaxonomy 
				where upper(web_url)=?

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_varchar) = FIREARMS

getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

select web_url from application.getWebTaxonomy where upper(dept)='FIREARMS' and typ='EMPTY'

getWebUrl (Datasource=, Time=0ms, Records=1) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

select web_url from application.getWebTaxonomy where upper(dept)='FIREARMS' and typ='EMPTY'

myCatVars.subCategories (Datasource=, Time=0ms, Records=6) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

select * from application.getWebTaxonomy where dept='Firearms' and typ<>'EMPTY' and subtyp_1='EMPTY' and sort_position<>'NO' order by sort_position desc

gpbtapi (Datasource=muraDB, Time=0ms, Records=0) in C:\websites\bullseye\functions\cms.cfc @ 17:13:47.047

SELECT contentID, active, Body, METAKEYWORDS, METADESC, parentID, path, HTMLTITLE, releaseDate, FileName, Title, menuTitle, urlTitle, fileID, DisplayStart, DisplayStop, Summary, Tags, Type, KEYPOINTS
		    FROM tcontent
		    WHERE (parentID = '5BCE52F1-B419-688B-3A23CE726CD826CC') and (urltitle = 'firearms') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2024-05-14 17:13:47.0' and displaystop>='2024-05-14 17:13:47.0') 
		    )

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

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=1) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

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

getLandingPageSubCats (Datasource=, Time=0ms, Records=6) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

select dept, typ, subtyp_1, subtyp_2, subtyp_3, active, web_url, category_style from application.getWebTaxonomy where 
			
			
					dept='Firearms'
					and typ<>'EMPTY'
					and subtyp_1='EMPTY'
				
			
			order by sort_position

GetALLProducts6 (Datasource=koalaSQL, Time=31ms, Records=93) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

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

		
			and ltrim(rtrim(dept))='Firearms'
            and ltrim(rtrim(typ)) = 'EMPTY' 
						and upper(pricerange)='500-or-more'
					
					   and upper(of2) = 'BOLT ACTION'
				   	
							--Do Nothing Here
                    GROUP BY STYLE_ID
		ORDER BY min(sortposition)

results (Datasource=, Time=0ms, Records=93) in C:\websites\bullseye\functions\category.cfc @ 17:13:47.047

SELECT * FROM GetALLProducts6 ORDER BY
		last_rcvd desc

getCurrentDept (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\includes\sidenav.cfm @ 17:13:47.047

select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='firearms'

getCurrentDept (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\includes\views\departments.cfm @ 17:13:47.047

select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='firearms'

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

SELECT typ, web_url 
                FROM tb_web_taxonomy 
                WHERE dept='Firearms' and typ>'' and subtyp_1='EMPTY' and typ<>'EMPTY' 
                ORDER BY sort_position

getCurrentDept (Datasource=koalaSQL, Time=16ms, Records=2) in C:\websites\bullseye\includes\views\departments.cfm @ 17:13:47.047

SELECT DISTINCT typ, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='FIREARMS' and upper(typ)<>'EMPTY'  and style_id IN (9910,3372,30608,30615,30628,6004,30640,33270,33271,10973,10974,32886,6830,6096,32206,3301,3305,6133,6019,6138,13679,13681,5740,32145,5780,5781,8281,32142,31905,32132,32135,32129,9103,32131,5978,28319,32107,10343,11154,6134,8273,5750,5885,5886,28772,10209,30612,30614,6121,520,10565,31714,31716,30637,30639,30607,8568,6142,6000,6106,10511,6135,30552,537,6095,6001,23577,18776,6097,6108,6111,8261,26660,522,24084,2495,3319,6015,6119,27287,8571,523,23519,23520,538,11093,5077,17855,9831,3300,3315,3325,3322) 
                GROUP BY typ

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

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 (9910,3372,30608,30615,30628,6004,30640,33270,33271,10973,10974,32886,6830,6096,32206,3301,3305,6133,6019,6138,13679,13681,5740,32145,5780,5781,8281,32142,31905,32132,32135,32129,9103,32131,5978,28319,32107,10343,11154,6134,8273,5750,5885,5886,28772,10209,30612,30614,6121,520,10565,31714,31716,30637,30639,30607,8568,6142,6000,6106,10511,6135,30552,537,6095,6001,23577,18776,6097,6108,6111,8261,26660,522,24084,2495,3319,6015,6119,27287,8571,523,23519,23520,538,11093,5077,17855,9831,3300,3315,3325,3322)  
      GROUP BY Ltrim(brand),Ltrim(branddisplay)
      ORDER BY  max(brand) ASC

this.GetFilterQuery (Datasource=, Time=0ms, Records=1) in C:\websites\bullseye\includes\sidenav.cfm @ 17:13:47.047

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

this.GetFilterQuery (Datasource=, Time=0ms, Records=22) in C:\websites\bullseye\includes\sidenav.cfm @ 17:13:47.047

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=1) in C:\websites\bullseye\includes\sidenav.cfm @ 17:13:47.047

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=1) in C:\websites\bullseye\includes\sidenav.cfm @ 17:13:47.047

SELECT * FROM temp ORDER BY ranking ASC

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 9910

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

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 3372

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

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30608

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

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30615

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

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30628

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

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 6004

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

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 30640

get_rating (Datasource=koalaSQL, Time=15ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:13:47.047

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 33270

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

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

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

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

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

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

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_integer) = 33271

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

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

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

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

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

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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=0ms, Records=0) in C:\websites\bullseye\functions\cms.cfc @ 17:13:47.047

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=15ms, Records=5) in C:\websites\bullseye\functions\cms.cfc @ 17:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

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:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`9910`
`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:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`3372`
`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:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`30608`
`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:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`30615`
`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=16ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`30628`
`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:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`6004`
`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:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`30640`
`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=16ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 17:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`33270`
`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:13:47.047

parameters
`type`	`CFSQLType`	`value`	`variable`	`dbVarName`
`IN`	`CF_SQL_INTEGER`	`33271`
`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; handl_url_base=https%3A%2F%2Frepublicgrandranch.com%2Fbuilders%2F; handl_ip=3.144.4.221; handl_landing_page=https%3A%2F%2Frepublicgrandranch.com%2Fbuilders%2F%3Fpage_number_5%3D12%26page_number_1%3D2%26page_number_4%3D2%26page_number_6%3D10%26page_number_7%3D13; fly_device=desktop; HandLtestDomainNameServer=HandLtestDomainValueServer; user_agent=Mozilla%2F5.0%20AppleWebKit%2F537.36%20%28KHTML%2C%20like%20Gecko%3B%20compatible%3B%20ClaudeBot%2F1.0%3B%20%2Bclaudebot%40anthropic.com%29; fly_geo={"countryCode":"us","region":"oh","dma":"535"}; fly_ab_uid=07e47cef-1006-406a-8087-11bb75ce22d5; handl_url=https%3A%2F%2Frepublicgrandranch.com%2Fbuilders%2F%3Fpage_number_5%3D12%26page_number_1%3D2%26page_number_4%3D2%26page_number_6%3D10%26page_number_7%3D13
HTTP_HOST=www.bullseyenorth.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=firearms/browse/price/500-or-more/guntype/bolt-action/instock/all/guntype/bolt-action
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=firearms/browse/price/500-or-more/guntype/bolt-action/instock/all/guntype/bolt-action
REMOTE_ADDR=3.144.4.221
REMOTE_HOST=3.144.4.221
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=12971693
CFTOKEN=91aa0476f9e69c71-B98AEFC0-9F21-4DC3-C2EB1AB8A65A216D
HandLtestDomainNameServer=HandLtestDomainValueServer
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
fly_ab_uid=07e47cef-1006-406a-8087-11bb75ce22d5
fly_device=desktop
handl_ip=3.144.4.221
handl_landing_page=https://republicgrandranch.com/builders/?page_number_5=12&page_number_1=2&page_number_4=2&page_number_6=10&page_number_7=13
handl_url=https://republicgrandranch.com/builders/?page_number_5=12&page_number_1=2&page_number_4=2&page_number_6=10&page_number_7=13
handl_url_base=https://republicgrandranch.com/builders/
user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

Form Fields:
KWORD=

Session Variables:
altimgurl=https://www.bullseyenorth.com/prodimages/alt_images/
cartstatus=NEW
cfid=12971693
cftoken=91aa0476f9e69c71-B98AEFC0-9F21-4DC3-C2EB1AB8A65A216D
checkout=Struct (4)
couponreset=NO
cs=https://www.bullseyenorth.com/firearms/browse/price/500-or-more/guntype/bolt-action/instock/all
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/firearms/browse/price/500-or-more/guntype/bolt-action/instock/all
password=
phone=
picurl=https://www.bullseyenorth.com/images/
prodimgurl=https://www.bullseyenorth.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_12971693_91aa0476f9e69c71-B98AEFC0-9F21-4DC3-C2EB1AB8A65A216D
shipmethodlist=0,1
urltoken=CFID=12971693&CFTOKEN=91aa0476f9e69c71-B98AEFC0-9F21-4DC3-C2EB1AB8A65A216D
username=
website=Struct (1)

URL Parameters:
mapping=firearms/browse/price/500-or-more/guntype/bolt-action/instock/all/guntype/bolt-action

Debug Rendering Time: 16 ms