Total Time	Avg Time	Count	Template
16 ms	16 ms	1	E:/inetpub/wwwroot/itemdetail/qry_getproducts.cfm
16 ms	16 ms	1	E:\inetpub\wwwroot\products2_addtocart_new.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/block_access.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/library.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/security/sql_injection.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/Application.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/itemdetail/dsp_scripts.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
16 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, sum(e.qoh + e.qc) as qoh
        from tb_skus a
        left join tb_sku_buckets e on (e.sku_id = a.sku_id)
        where a.style_id = 249654
        and e.store_id = 10
		
        group by a.style_id, qc

Application Variables:
acceptorid=011668467
accountid=1027380
accounttoken=64BB6980FDEAF842266AC866F250CA9877FF24AE92795FB9BE490EAF527645FC4E54DC01
adminurl=https://www.sportsmansoutdoorsuperstore.com/web_admin/products/menu.cfm?style_id=
applicationname=SOS
bannerurl=https://www.sportsmansoutdoorsuperstore.com/images/banners/
ccprocessor=VANTIV
checkinventory=Struct (3)
companyname=Vance Outdoors
credova=Struct (5)
ds=celerantsql
enter_inscription=OFF
feedsdir=E:\websites\feeds\
forumemail=info@sportsmansoutdoorsuperstore.com
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:\websites\images\
logdir=E:\websites\logs\
metadesc=
metatags=
mydomain=https://www.sportsmansoutdoorsuperstore.com/
pagetitle=
picurl=https://www.sportsmansoutdoorsuperstore.com/images/
prodimgdir=E:\websites\prodimages\
prodimgurl=https://www.sportsmansoutdoorsuperstore.com/prodimages/
qoh_store=10
safety_stock=0
salesemail=sales@sportsmansoutdoorsuperstore.com
secureurl=https://www.sportsmansoutdoorsuperstore.com/
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=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\products2_addtocart_new.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=LAST_NAME=; FIRST_NAME=; PRD_U=293384%2C762; CUSTOMER_ID=; USERNAME=; EMAIL=; PASSWORD=; CT_U=2600
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=
HTTP_URL=/products2_addtocart_new.cfm?id=249654&dept=Firearms
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.200.30.6
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\wwwroot\products2_addtocart_new.cfm
QUERY_STRING=id=249654&dept=Firearms
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/products2_addtocart_new.cfm
SERVER_NAME=www.sportsmansoutdoorsuperstore.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Client Variables:
cfid=5317
cftoken=6a517731e5970d84-E8EFC5A0-D506-D735-666BF4C65052EC93
hitcount=1
lastvisit={ts '2024-05-20 14:37:17'}
timecreated={ts '2024-05-20 14:37:17'}
urltoken=CFID=5317&CFTOKEN=6a517731e5970d84-E8EFC5A0-D506-D735-666BF4C65052EC93

Cookie Variables:
CFID=5317
CFTOKEN=6a517731e5970d84-E8EFC5A0-D506-D735-666BF4C65052EC93
CT_U=2600
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
PRD_U=293384,762
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=5317
cftoken=6a517731e5970d84-E8EFC5A0-D506-D735-666BF4C65052EC93
cs=/index.cfm
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_5317_6a517731e5970d84-E8EFC5A0-D506-D735-666BF4C65052EC93
strarray=Array (0)
urltoken=CFID=5317&CFTOKEN=6a517731e5970d84-E8EFC5A0-D506-D735-666BF4C65052EC93

URL Parameters:
dept=Firearms
id=249654