Moultrie Code Blue Coon Urine Raccoon Cover Scent 2 oz Bottle

Total Time	Avg Time	Count	Template
83 ms	83 ms	1	E:\inetpub\wwwroot\products2.cfm
17 ms	17 ms	1	E:/inetpub/wwwroot/Application.cfm
16 ms	16 ms	1	E:/inetpub/wwwroot/includes/dropship.cfm
13 ms	13 ms	1	E:/inetpub/wwwroot/products2_mfgpromo_qry.cfm
1 ms	1 ms	1	E:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms	0 ms	3	E:/inetpub/wwwroot/includes/brands.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/json/productpage.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/metatags.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/newfooter.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/newheader.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/redirects.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/security/library.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/security/sql_injection.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/shipping_disclaimer.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/includes/similar-products.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/itemdetail/qry_getproducts.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/products2_breadcrumbs.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/products2_combos.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/products2_discount_offers.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/products2_mfgpromo.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/products2_reviews.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
100 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

select style from tb_styles with (nolock) where style_id=?

select a.*,b.scale_id,b.attr1_id,b.attr2_id 
	 from web_all_products a WITH(NOLOCK)
	 inner join tb_styles b WITH(NOLOCK) on (b.style_id = a.style_id) 
	 where a.style_id=? and a.dept <>'California Guns'
	 order by a.dept asc

select e.qc as qc, max(e.sugg_price) as sugg_price, sum(e.qoh + e.qc) as qoh
	from tb_skus a WITH(NOLOCK)
	left join tb_sku_buckets e WITH(NOLOCK) on (e.sku_id = a.sku_id)
	where a.style_id = 320932
	and e.store_id in (10,32)
	group by a.style_id, qc
	order by qoh desc

select e.sku_bucket_id, e.price, e.sugg_price, (e.qoh + e.qc) as qoh, z.of15,e.last_cost,e.store_id
	from 
	tb_styles z with (nolock) inner join tb_skus a with (nolock) on (z.style_id=a.style_id)
	inner join tb_parts b with (nolock) on (a.STYLE_ID=b.STYLE_ID)
	inner join tb_sku_buckets e with (nolock) on (e.sku_id = a.sku_id)
	where a.style_id = 320932 and (e.qoh + e.qc) >= 1
	and (
		(b.contact_id=22620 and e.store_id = 27) or 
		(b.contact_id=19570 and e.store_id = 29) or 
		(b.contact_id=25130 and e.store_id = 28) or
          (b.contact_id=15358 and e.store_id = 30)
		)
		
		
		and (e.last_cost>0 and z.of15 is not NULL) 
	and z.brand not in (?,?,?,?,?,?,?,?,?)
		order by e.last_cost asc

select *
	from tb_term_sale_entries with (nolock)
	where start_date<= 'Apr 14, 2026 09:38:37' and
	end_date >= 'Apr 14, 2026 09:38:37'
	and store_id=10 and style_id=?

Select * FROM tb_mfg_promo.dbo.tb_new_version where new_style_id=?

select * from tb_product_reviews with (nolock)
	where (style_id=?)
	and status='A' and site = 'sportsman'

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews  with (nolock)
	where (style_id=?)
	and status='A' 
	and site = 'sportsman'

Select web_url, dept from tb_web_taxonomy with (nolock) where dept = 'Hunting' and typ='EMPTY' and site = 'sportsman' and dept <>'California Guns'

Select web_url from tb_web_taxonomy with (nolock) where dept = 'Hunting' and typ='Lures & Scents' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url from tb_web_taxonomy with (nolock) where dept = 'Hunting' and typ='Lures & Scents' and subtyp_1='Lures & Dispensers' and subtyp_2='EMPTY' and site = 'sportsman'

SELECT *
FROM 
tb_mfg_promo.dbo.tb_mfg_promos a WITH (NOLOCK)
INNER JOIN tb_mfg_promo.dbo.tb_mfg_promo_items b WITH (NOLOCK)
    ON (a.promo_id = b.promo_id)
where b.style_id = 320932 
and (a.start_date<= 'Apr 14, 2026 09:38:37' or a.active = 1)
and a.end_date >= '04/14/2026'
order by a.promo_id desc

select * from get_promos320932

select * from tb_styles with (nolock) where style_id in (?,?)

select 
*

from GetBestProductsMain

Select web_url, dept from tb_web_taxonomy with (nolock) where dept = 'Hunting' and typ='EMPTY' and site = 'sportsman' and dept <>'California Guns'

Select web_url from tb_web_taxonomy with (nolock) where dept = 'Hunting' and typ='Lures & Scents' and subtyp_1='EMPTY' and site = 'sportsman'

Select web_url from tb_web_taxonomy with (nolock) where dept = 'Hunting' and typ='Lures & Scents' and subtyp_1='Lures & Dispensers' and subtyp_2='EMPTY' and site = 'sportsman'

select * from tb_alt_pictures with (nolock) where style_id=320932

select distinct bulk_id, max(prc_dis) as prc_dis, max(qty) as qty, max(qty_multiple) as qty_multiple from tb_mfg_promo.dbo.BULK_ITM_DSCS with (nolock) where bulk_id = ? and site is NULL
							group by bulk_id

Select * FROM tb_mfg_promo.dbo.tb_new_version where old_style_id=?

SELECT *
FROM 
	tb_mfg_promo.dbo.tb_pkg a WITH (NOLOCK)
	INNER JOIN tb_mfg_promo.dbo.tb_pkg_main_items b WITH (NOLOCK)
		ON (a.pkg_id = b.pkg_id)
where 
b.main_id = 320932 and a.start_date<= '04/14/2026 23:59:00' and a.end_date >= '04/14/2026' and site='sportsman'

select * from tb_mfg_promo.dbo.tb_video_url where style_id=320932 and site <> 'outdoors'

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOSS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
baseurl=https://www.sportsmansoutdoorsuperstore.com/sezzle/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\inetpub\feeds\
[email protected]
forumtitle=Sportsmans Outdoor Superstore
giftcardimgpath=file:///C:/websites/images/
giftcardpdfpath=E:\websites\giftcardPDF\
googlefeedproducttype=
homeurl=https://www.sportsmansoutdoorsuperstore.com/
hostedpagelink=https://transaction.hostedpayments.com/
iconurl=https://www.sportsmansoutdoorsuperstore.com/images/icons/
imagedir=E:\inetpub\images\
logdir=E:\inetpub\logs
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
privatekay=sz_pr_nMBvrWcNk9cNGP9sN695umNINohQkV4r
prodimgdir=E:\inetpub\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
publickey=sz_pub_T20udXXUkabHIADEGrGe3pgtZjwms0K6
qoh_store=10
safety_stock=0
[email protected]
secureurl=https://www.sportsmansoutdoorsuperstore.com/
sezzleapiurl=https://gateway.sezzle.com
sezzletenderid=66
site=sportsman
tempmailport=25
tempmailserver=127.0.0.1
tokenurl=https://services.elementexpress.com/express.asmx
use_multi_buy=OFF
vantivurl=https://transaction.elementexpress.com/express.asmx
webadminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/
websitename=Sportsmans Outdoor Superstore

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, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
CERT_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\products2.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, S=Arizona, L=Scottsdale, O="GoDaddy.com, Inc.", OU=http://certs.godaddy.com/repository/, CN=Go Daddy Secure Certificate Authority - G2
HTTPS_SERVER_SUBJECT=CN=sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/products2.cfm/ID/320932/oa1106/moultrie-code-blue-coon-urine-raccoon-cover-scent-2-oz-bottle
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=10.200.30.6
PATH_INFO=/ID/320932/oa1106/moultrie-code-blue-coon-urine-raccoon-cover-scent-2-oz-bottle
PATH_TRANSLATED=E:\inetpub\wwwroot\products2.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/products2.cfm
SERVER_NAME=sportsmansoutdoorsuperstore.com
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=22877395
cftoken=70680914f4543e85-7A26B15A-E828-E01F-C6EF55515C3162B1
hitcount=1
lastvisit={ts '2026-04-14 09:38:37'}
timecreated={ts '2026-04-14 09:38:37'}
urltoken=CFID=22877395&CFTOKEN=70680914f4543e85-7A26B15A-E828-E01F-C6EF55515C3162B1

Cookie Variables:
CFID=22877395
CFTOKEN=70680914f4543e85-7A26B15A-E828-E01F-C6EF55515C3162B1
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=320932,3734
S_U_F345=Y
USERNAME=

Form Fields:
RETURN_TO_PAGE=null

Request Parameters:
samesite_value=

Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)

Session Variables:
cfid=22877395
cftoken=70680914f4543e85-7A26B15A-E828-E01F-C6EF55515C3162B1
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOSS_22877395_70680914f4543e85-7A26B15A-E828-E01F-C6EF55515C3162B1
strarray=Array (0)
urltoken=CFID=22877395&CFTOKEN=70680914f4543e85-7A26B15A-E828-E01F-C6EF55515C3162B1

URL Parameters:
ATTR1=
ATTR2=
BRAND=
CLEARANCE=
DEPT=Hunting
ID=320932
MULTIBUYITEM=NO
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SIZ=
SORTBY=
SPORTSMAN=
SUBTYP_1=Lures & Dispensers
SUBTYP_2=
SUBTYP_3=
TYP=Lures & Scents
WHATSNEW=
oa1106=moultrie-code-blue-coon-urine-raccoon-cover-scent-2-oz-bottle