Total Time	Avg Time	Count	Template
196 ms	196 ms	1	E:\inetpub\wwwroot\index.cfm
46 ms	2 ms	20	C:/inetpub/wwwroot/includes/qry_mfg_promo_price.cfm
16 ms	1 ms	20	C:/inetpub/wwwroot/includes/qry_term_sale_price.cfm
0 ms	0 ms	26	C:/inetpub/wwwroot/includes/brands.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/metatags.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/newfooter.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/newheader.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	C:/inetpub/wwwroot/includes/shipping_disclaimer.cfm
0 ms	0 ms	1	C:/inetpub/wwwroot/includes/similar-products.cfm
0 ms	0 ms	1	E:/inetpub/wwwroot/Application.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
196 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

select * from tb_mfg_promo.dbo.tb_category_pages with (nolock)
where web_taxonomy_id = 99999999 and (scheduled = 0 or (scheduled = 1 and 

scheduled_start<= 'May 20, 2024 14:36:00' and
scheduled_end >= 'May 20, 2024 14:36:00'))


 and site='sportsman'
order by sort_position asc

select * from category_landing99999999 where type = 'banner'
order by sort_position asc

select * from category_landing99999999 where type = 'single'
order by sort_position asc

select 
*

from GetBestProductsMain

select distinct style_id, min(min_price) as min_price,max(max_price) as max_price,max(style) as style,max(web_desc) as web_desc,max(web_description) as web_description,max(picture_id) as picture_id,   max(dept) as dept,max(qoh) as qoh,max(qc) as qc,max(qs) as qs,sum(qoh + qc) as available,sum(qs - qc) as sold,max(brand) as brand,max(max_sugg_price) AS max_sugg_price,max(of12) as of12
from GetBestProductsMain where style_id is not null and available>0 and dept='Firearms'
group by Style_id order by qc asc, sold desc

select distinct style_id, min(min_price) as min_price,	max(max_price) as max_price,	max(web_style) as web_style, max(style) as style,	max(web_desc) as web_desc,	max(web_description) as web_description,	max(picture_id) as picture_id,   max(dept) as dept,   max(qoh) as qoh,	max(qc) as qc,	max(qs) as qs,	sum(qoh + qc) as available,	sum(qs - qc) as sold, 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(of9) as of9,max(of12) as of12, max(of19) as of19, max(brand) as brand,	MAX(max_sugg_price) AS max_sugg_price
from GetBestProductsMain where style_id is not null and available>0 and dept='Ammo'
group by Style_id order by qc asc, sold desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=168578

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 = 168578 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=288434

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 = 288434 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=303154

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 = 303154 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=250461

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 = 250461 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=274642

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 = 274642 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=274643

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 = 274643 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=250777

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 = 250777 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=276181

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 = 276181 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=250779

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 = 250779 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=295087

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 = 295087 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=39351

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 = 39351 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=216569

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 = 216569 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=300496

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 = 300496 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=310025

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 = 310025 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=249953

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 = 249953 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=125355

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 = 125355 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=24654

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 = 24654 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=122241

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 = 122241 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=250681

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 = 250681 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select typ,amount,end_date,term_sale_id
from tb_term_sale_entries with (nolock)
where start_date<= 'May 20, 2024 14:36:03' and
end_date >= 'May 20, 2024 14:36:03'
and store_id=10 and style_id=12715

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 = 12715 
and (a.start_date<= 'May 20, 2024 14:36:03' or a.active = 1)
and a.end_date >= 'May 20, 2024 14:36:03'
order by a.promo_id desc

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

select distinct *
        FROM
                tb_product_reviews a WITH (NOLOCK)
                INNER JOIN dbo.tb_styles b WITH (NOLOCK)
                    ON (a.style_id = b.style_id)
                INNER JOIN dbo.tb_skus c WITH (NOLOCK)
                    ON (a.style_id = c.style_id)
                INNER JOIN dbo.tb_sku_buckets d WITH (NOLOCK)
                    ON (c.sku_id = d.sku_id)
        where a.status='A' and a.site = 'sportsman' and d.store_id=10 and d.qoh>0 and a.custom_rating_1 > 3
        order by dte desc

select sum(CAST(custom_rating_1 AS INTEGER)) as custom_rating_1 from tb_product_reviews with (nolock)
            where style_id=269388 
            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=50329 
            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=282860 
            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=12715 
            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=277414 
            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=142969 
            and status='A' 
            and site = 'sportsman'

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=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.sportsmansoutdoorsuperstore.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\inetpub\wwwroot\index.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.sportsmansoutdoorsuperstore.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=CFTOKEN=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876; CFID=Z98olbwg5rxrj4kxa625akg5dpmaa354uo66g173yqvk4tox9o-5054; CFGLOBALS=urltoken%3DCFID%23%3D5054%26CFTOKEN%23%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23lastvisit%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A03%27%7D%23hitcount%3D4%23timecreated%3D%7Bts%20%272024%2D05%2D20%2014%3A36%3A02%27%7D%23cftoken%3Dae2897c1f26072f5%2DE8E457D9%2DC345%2D0FDC%2D1A536E3A78F8D876%23cfid%3D5054%23; CUSTOMER_ID=; USERNAME=; EMAIL=; FIRST_NAME=; LAST_NAME=; PASSWORD=
HTTP_HOST=www.sportsmansoutdoorsuperstore.com
HTTP_REFERER=https://www.sportsmansoutdoorsuperstore.com/category.cfm/sportsman//brand/WALTHER/currentpage/11
HTTP_URL=/index.cfm
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\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.200.2.4
REMOTE_HOST=10.200.2.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.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=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
hitcount=4
lastvisit={ts '2024-05-20 14:36:03'}
timecreated={ts '2024-05-20 14:36:02'}
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

Cookie Variables:
CFGLOBALS=urltoken=CFID#=5054&CFTOKEN#=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#lastvisit={ts '2024-05-20 14:36:03'}#hitcount=4#timecreated={ts '2024-05-20 14:36:02'}#cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876#cfid=5054#
CFID=5054
CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
CUSTOMER_ID=
EMAIL=
FIRST_NAME=
LAST_NAME=
PASSWORD=
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=5054
cftoken=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
cs=/category.cfm/sportsman/brand/WALTHER/currentpage/11
displaycount=18
employeeloggedin=N
fflnote=
firearm_agreement=NO
imgarray=Array (0)
memberloggedin=N
pickupstore=10
prodtype=none
selected_ffl=NO
sessionid=SOS_5054_ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876
strarray=Array (0)
urltoken=CFID=5054&CFTOKEN=ae2897c1f26072f5-E8E457D9-C345-0FDC-1A536E3A78F8D876

URL Parameters:
BRAND=
CLEARANCE=
DEPT=
NAV_CHOOSER=
OF1=
OF10=
OF2=
OF3=
OF4=
OF5=
OF6=
ORDER_BY=
PRODTYPE=none
RETURN_TO_PAGE=null
SECTION=
SPORTSMAN=
SUBTYP_1=
SUBTYP_2=
SUBTYP_3=
TYP=
WHATSNEW=