home hornady

All Products

Sort by:
Display:

Items 55 to 63 of 84 total

6 7 8 9 10
Sort by:
Display:

Items 55 to 63 of 84 total

6 7 8 9 10

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

Execution Time

Total Time Avg Time Count Template
218 ms 218 ms 1 top level C:\websites\bullseye\category.cfm
218 ms 218 ms 1 CFC[ C:/websites/bullseye/application.cfc | onRequest(/category.cfm) ] from C:/websites/bullseye/application.cfc
109 ms 12 ms 9 C:/websites/bullseye/includes/views/thumbnails.cfm
32 ms 32 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 C:/websites/bullseye/includes/application/check_db.cfm
16 ms 16 ms 1 CFC[ C:/websites/bullseye/application.cfc | onRequestStart(/category.cfm) ] from C:/websites/bullseye/application.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(2969, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(3255, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(2999) ] from C:/websites/bullseye/functions/itemDetails.cfc
16 ms 16 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(2992) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms 15 ms 1 C:/websites/bullseye/includes/footer.cfm
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236CFAC8-155D-9BEA-014EF87802FDB145) ] from C:/websites/bullseye/functions/cms.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getPagetByTitleAndParentId(hornady, ) ] from C:/websites/bullseye/functions/cms.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(3084, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
15 ms 15 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(3157) ] from C:/websites/bullseye/functions/itemDetails.cfc
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 | 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(84, 7, 9, 5, https://www.bullseyenorth.com/all-products/browse/price/50-to-100/brand/hornady/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 | getPageTitleFromFormula([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 | 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(236D22DF-155D-9BEA-010FAA115A719DE2) ] from C:/websites/bullseye/functions/cms.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(23CAF9FB-155D-9BEA-014DE05AEA6984A7) ] 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(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(2992, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(2999, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(3084, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(3157, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(3236, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(3252, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(3255, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | GetQOHQueryProd(3270, NULL, NULL, NULL) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(2969, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(2992, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(2999, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(3157, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(3236, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(3252, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviews(3270, ) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(2969) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(2992) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(3084) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(3157) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(3236) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(3252) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(3255) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | getProductReviewsAverage(3270) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(2969) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(2999) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(3084) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(3236) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(3252) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(3255) ] from C:/websites/bullseye/functions/itemDetails.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/itemDetails.cfc | isStyleonQtyPricing(3270) ] 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(.224 DIAMETER) ] 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(25 06 REMINGTON) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(257 WEATHERBY MAGNUM) ] 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(30 30 WINCHESTER) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(300 AAC BLACKOUT) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(300 WEATHERBY MAGNUM) ] 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(303 BRITISH) ] 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(357 MAGNUM) ] 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(45 ACP) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(460 SW MAGNUM) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(50 AE) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(50-to-100) ] 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(6MM CREEDMOOR) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(7MM 08 REMINGTON) ] 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(8X57 MAUSER) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | prepUrlVar(Hornady) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | resolveUrlVar(50-to-100) ] 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 | resolveUrlVar(hornady) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady .44 Special / .44 Magnum Full Length Nitride Three Die Set 546548, 2999) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady .45 ACP Auto Mag and Auto Rim Full Length Nitride Three Die Set 546554, 3255) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady 7mm Remington Magnum Two Die Set 546326, 2992) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady Dial Caliper 6" Stainless Steel 050075, 2969) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady Lock-N-Load AP Progressive Press Shellplate #10 (357 Sig 40 S&W 10mm Auto), 3270) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady Lock-N-Load AP Progressive Press Shellplate #8 (30 Luger 38 Super 9mm Luger), 3236) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady Lock-N-Load Headspace Gauge 5 Bushing Set with Comparator, 3252) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady Superformance Ammo 6.5 Creedmoor SST Polymer Tip 129gr 2950 fps 81496 - Box of 20, 3084) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | safeURL(Hornady Unprimed Brass Cartridge Cases 6.5 Creedmoor New 86281 - Box of 50, 3157) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 1 CFC[ C:/websites/bullseye/functions/utilities.cfc | titlecase(50 TO 100) ] 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(HORNADY) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms 0 ms 2 CFC[ C:/websites/bullseye/functions/utilities.cfc | titlecase(hornady) ] from C:/websites/bullseye/functions/utilities.cfc
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
234 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

checkThis (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\includes\application\check_db.cfm @ 20:22:52.052
SELECT Style_ID FROM TB_Styles
getQueryStr (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\category.cfc @ 20:22:52.052
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 @ 20:22:52.052
select * from application.getWebTaxonomy where upper(web_url)=?  and sort_position<>'NO'
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) =

gpbtapi (Datasource=muraDB, Time=15ms, Records=0) in C:\websites\bullseye\functions\cms.cfc @ 20:22:52.052
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 = '') and (urltitle = 'hornady') AND (active = 1) AND (type='PAGE') AND ( (display = 1) or (display=2 and displaystart<='2024-05-14 20:22:52.0' and displaystop>='2024-05-14 20:22:52.0') 
		    )
gcbi (Datasource=muraDB, Time=0ms, Records=0) in C:\websites\bullseye\functions\cms.cfc @ 20:22:52.052
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 @ 20:22:52.052
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=84) in C:\websites\bullseye\functions\category.cfc @ 20:22:52.052
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 upper(pricerange)='50-to-100'
											
                    	and upper(brand) LIKE '%hornady%'						
						
							--Do Nothing Here
                    GROUP BY STYLE_ID
		ORDER BY min(sortposition)
results (Datasource=, Time=0ms, Records=84) in C:\websites\bullseye\functions\category.cfc @ 20:22:52.052
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 @ 20:22:52.052
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 @ 20:22:52.052
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) = 3091
Parameter #2(CF_SQL_FLOAT) = 3068
Parameter #3(CF_SQL_FLOAT) = 3031
Parameter #4(CF_SQL_FLOAT) = 3131
Parameter #5(CF_SQL_FLOAT) = 3111
Parameter #6(CF_SQL_FLOAT) = 3115
Parameter #7(CF_SQL_FLOAT) = 3080
Parameter #8(CF_SQL_FLOAT) = 3087
Parameter #9(CF_SQL_FLOAT) = 2989
Parameter #10(CF_SQL_FLOAT) = 2990
Parameter #11(CF_SQL_FLOAT) = 2994
Parameter #12(CF_SQL_FLOAT) = 2995
Parameter #13(CF_SQL_FLOAT) = 2996
Parameter #14(CF_SQL_FLOAT) = 3192
Parameter #15(CF_SQL_FLOAT) = 27526
Parameter #16(CF_SQL_FLOAT) = 3182
Parameter #17(CF_SQL_FLOAT) = 3266
Parameter #18(CF_SQL_FLOAT) = 3176
Parameter #19(CF_SQL_FLOAT) = 3096
Parameter #20(CF_SQL_FLOAT) = 3137
Parameter #21(CF_SQL_FLOAT) = 8822
Parameter #22(CF_SQL_FLOAT) = 8836
Parameter #23(CF_SQL_FLOAT) = 3209
Parameter #24(CF_SQL_FLOAT) = 3250
Parameter #25(CF_SQL_FLOAT) = 2868
Parameter #26(CF_SQL_FLOAT) = 2882
Parameter #27(CF_SQL_FLOAT) = 2997
Parameter #28(CF_SQL_FLOAT) = 8811
Parameter #29(CF_SQL_FLOAT) = 3069
Parameter #30(CF_SQL_FLOAT) = 24632
Parameter #31(CF_SQL_FLOAT) = 3113
Parameter #32(CF_SQL_FLOAT) = 3198
Parameter #33(CF_SQL_FLOAT) = 2953
Parameter #34(CF_SQL_FLOAT) = 2984
Parameter #35(CF_SQL_FLOAT) = 3058
Parameter #36(CF_SQL_FLOAT) = 2891
Parameter #37(CF_SQL_FLOAT) = 3085
Parameter #38(CF_SQL_FLOAT) = 30511
Parameter #39(CF_SQL_FLOAT) = 2894
Parameter #40(CF_SQL_FLOAT) = 2889
Parameter #41(CF_SQL_FLOAT) = 10364
Parameter #42(CF_SQL_FLOAT) = 3061
Parameter #43(CF_SQL_FLOAT) = 3110
Parameter #44(CF_SQL_FLOAT) = 3052
Parameter #45(CF_SQL_FLOAT) = 3092
Parameter #46(CF_SQL_FLOAT) = 2895
Parameter #47(CF_SQL_FLOAT) = 3038
Parameter #48(CF_SQL_FLOAT) = 3086
Parameter #49(CF_SQL_FLOAT) = 8816
Parameter #50(CF_SQL_FLOAT) = 2904
Parameter #51(CF_SQL_FLOAT) = 3191
Parameter #52(CF_SQL_FLOAT) = 19003
Parameter #53(CF_SQL_FLOAT) = 3001
Parameter #54(CF_SQL_FLOAT) = 3254
Parameter #55(CF_SQL_FLOAT) = 3084
Parameter #56(CF_SQL_FLOAT) = 2999
Parameter #57(CF_SQL_FLOAT) = 2992
Parameter #58(CF_SQL_FLOAT) = 3157
Parameter #59(CF_SQL_FLOAT) = 3252
Parameter #60(CF_SQL_FLOAT) = 3255
Parameter #61(CF_SQL_FLOAT) = 3236
Parameter #62(CF_SQL_FLOAT) = 2969
Parameter #63(CF_SQL_FLOAT) = 3270
Parameter #64(CF_SQL_FLOAT) = 3036
Parameter #65(CF_SQL_FLOAT) = 3079
Parameter #66(CF_SQL_FLOAT) = 3035
Parameter #67(CF_SQL_FLOAT) = 3074
Parameter #68(CF_SQL_FLOAT) = 8792
Parameter #69(CF_SQL_FLOAT) = 10202
Parameter #70(CF_SQL_FLOAT) = 3098
Parameter #71(CF_SQL_FLOAT) = 10376
Parameter #72(CF_SQL_FLOAT) = 3156
Parameter #73(CF_SQL_FLOAT) = 8786
Parameter #74(CF_SQL_FLOAT) = 3078
Parameter #75(CF_SQL_FLOAT) = 3162
Parameter #76(CF_SQL_FLOAT) = 3049
Parameter #77(CF_SQL_FLOAT) = 3073
Parameter #78(CF_SQL_FLOAT) = 8846
Parameter #79(CF_SQL_FLOAT) = 8787
Parameter #80(CF_SQL_FLOAT) = 3159
Parameter #81(CF_SQL_FLOAT) = 23602
Parameter #82(CF_SQL_FLOAT) = 24633
Parameter #83(CF_SQL_FLOAT) = 3138
Parameter #84(CF_SQL_FLOAT) = 3102

this.GetFilterQuery (Datasource=koalaSQL, Time=32ms, Records=1) in C:\websites\bullseye\includes\sidenav.cfm @ 20:22:52.052
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 (3091,3068,3031,3131,3111,3115,3080,3087,2989,2990,2994,2995,2996,3192,27526,3182,3266,3176,3096,3137,8822,8836,3209,3250,2868,2882,2997,8811,3069,24632,3113,3198,2953,2984,3058,2891,3085,30511,2894,2889,10364,3061,3110,3052,3092,2895,3038,3086,8816,2904,3191,19003,3001,3254,3084,2999,2992,3157,3252,3255,3236,2969,3270,3036,3079,3035,3074,8792,10202,3098,10376,3156,8786,3078,3162,3049,3073,8846,8787,3159,23602,24633,3138,3102)  
      GROUP BY Ltrim(brand),Ltrim(branddisplay)
      ORDER BY  max(brand) ASC
this.GetFilterQuery (Datasource=, Time=0ms, Records=23) in C:\websites\bullseye\includes\sidenav.cfm @ 20:22:52.052
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 @ 20:22:52.052
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 @ 20:22:52.052
SELECT * FROM temp ORDER BY ranking ASC
get_reviews (Datasource=koalaSQL, Time=15ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3084

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 3084

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 3084

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2999

get_rating (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 2999

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 2999

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2992

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 2992

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 2992

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3157

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 3157

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 3157

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3252

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 3252

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
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) = 3252

get_reviews (Datasource=koalaSQL, Time=16ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3255

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 3255

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 3255

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3236

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 3236

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 3236

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2969

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 2969

getQOHQueryCart (Datasource=koalaSQL, Time=16ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 2969

get_reviews (Datasource=koalaSQL, Time=0ms, Records=0) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
select * 
        from tb_product_reviews 
        where style_id=
		? 
		and status='A'
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3270

get_rating (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 3270

getQOHQueryCart (Datasource=koalaSQL, Time=0ms, Records=1) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
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) = 3270

gcbi (Datasource=muraDB, Time=0ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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=15ms, Records=1) in C:\websites\bullseye\functions\cms.cfc @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:53.053
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 @ 20:22:52.052

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  3084    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  2999    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=16ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  2992    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  3157    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:52.052
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  3252    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  3255    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  3236    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  2969    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 spResult  1
USP_ECOMM_LOAD_QTY_PRICE_FOR_PRODUCT (Datasource=koalaSQL, Time=0ms) in C:\websites\bullseye\functions\itemDetails.cfc @ 20:22:53.053
    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  CF_SQL_INTEGER  3270    
 IN  CF_SQL_INTEGER  99    
 IN  CF_SQL_SMALLINT  1    
    
resultsets
nameresultset
 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=
HTTP_HOST=www.bullseyenorth.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=all-products/browse/price/50-to-100/brand/hornady/instock/all/page/7
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/price/50-to-100/brand/hornady/instock/all/page/7
REMOTE_ADDR=18.118.121.55
REMOTE_HOST=18.118.121.55
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=12981149
CFTOKEN=a2856102fd7b9eac-C04E2682-BD65-91D0-12EC6C57F0398BB7

Form Fields:
KWORD=

Session Variables:
altimgurl=https://www.bullseyenorth.com/prodimages/alt_images/
cartstatus=NEW
cfid=12981149
cftoken=a2856102fd7b9eac-C04E2682-BD65-91D0-12EC6C57F0398BB7
checkout=Struct (4)
couponreset=NO
cs=https://www.bullseyenorth.com/all-products/browse/price/50-to-100/brand/hornady/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/all-products/browse/price/50-to-100/brand/hornady/instock/all
password=
phone=
picurl=https://www.bullseyenorth.com/images/
prodimgurl=https://www.bullseyenorth.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_12981149_a2856102fd7b9eac-C04E2682-BD65-91D0-12EC6C57F0398BB7
shipmethodlist=0,1
urltoken=CFID=12981149&CFTOKEN=a2856102fd7b9eac-C04E2682-BD65-91D0-12EC6C57F0398BB7
username=
website=Struct (1)

URL Parameters:
mapping=all-products/browse/price/50-to-100/brand/hornady/instock/all/page/7
Debug Rendering Time: 32 ms