Total Time	Avg Time	Count	Template
93 ms	93 ms	1	C:\websites\bullseye\category.cfm
93 ms	93 ms	1	CFC[ C:/websites/bullseye/application.cfc | onRequest(/category.cfm) ] from C:/websites/bullseye/application.cfc
32 ms	32 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc | getProductsFromOverallQuery([complex value]) ] from C:/websites/bullseye/functions/category.cfc
31 ms	31 ms	1	C:/websites/bullseye/includes/footer.cfm
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/cms.cfc | getContentById(236C0F49-155D-9BEA-014E0DE3321A0824) ] from C:/websites/bullseye/functions/cms.cfc
15 ms	15 ms	1	C:/websites/bullseye/includes/sidenav.cfm
15 ms	15 ms	1	C:/websites/bullseye/includes/views/departments.cfm
15 ms	15 ms	1	CFC[ C:/websites/bullseye/functions/category.cfc | init([complex value]) ] from C:/websites/bullseye/functions/category.cfc
15 ms	15 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	C:/websites/bullseye/includes/application/create_query_string.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/session_defaults.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/sql_injection.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/url_actions.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/application/url_variable_defaults.cfm
0 ms	0 ms	1	C:/websites/bullseye/includes/header.cfm
0 ms	0 ms	1	CFC[ C:/websites/bullseye/application.cfc | onRequestEnd(/category.cfm) ] from C:/websites/bullseye/application.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/application.cfc | 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 | 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(236C2F35-155D-9BEA-0116EE02CB815150) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236CDE9D-155D-9BEA-018641D3692BE8E9) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236CFAC8-155D-9BEA-014EF87802FDB145) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(236D22DF-155D-9BEA-010FAA115A719DE2) ] from C:/websites/bullseye/functions/cms.cfc
0 ms	0 ms	1	CFC[ C:/websites/bullseye/functions/cms.cfc | getContentById(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 | getPagetByTitleAndParentId(reloading-powder, 5BCE52F1-B419-688B-3A23CE726CD826CC) ] from C:/websites/bullseye/functions/cms.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	2	CFC[ C:/websites/bullseye/functions/utilities.cfc | resolveUrlVar(270-winchester) ] 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 | titlecase(270 WINCHESTER) ] 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			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
109 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT Style_ID FROM TB_Styles

select * from web_category_mappings where url='reloading-powder' or url='/reloading-powder'

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

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

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

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

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

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

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

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

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

SELECT distinct style_id
		
		, max(url) as url
		, max(realName) as realName
		, max(style) as style
		, max(overallqoh) as overallqoh
		, max(usePackage) as usePackage
		, max(sale) as sale
		, max(new) as new
		, max(SmallPicture) as SmallPicture
		, max(MediumPicture) as MediumPicture
		, max(LargePicture) as LargePicture
		, min(sortposition) as sortposition
		, max(dept) as dept
		, max(typ) as typ
		, max(subtyp1) as subtyp1
		, max(subtyp2) as subtyp2
		, max(subtyp3) as subtyp3
		, max(brand) as brand
		, max(branddisplay) as branddisplay
		, max(priceRange) as priceRange
		, min(salePriceRangeBottom) as salePriceRangeBottom
		, max(salePriceRangeTop) as salePriceRangeTop
		, max(ListPrice) as ListPrice
		, max(ranking) as ranking
		, max(romanticcopylong) as romanticcopylong
		, max(romanticcopyshort) as romanticcopyshort
		, max(depttree) as depttree
		, max(attr1list) as attr1list
		, max(sizelist) as sizelist
		, max(name) as name
		, max(gender) as gender
		, max(agerange) as agerange
		, max(picture_id) as picture_id
		, max(prodReviewsAverage) as prodReviewsAverage
		, max(INTERNALLISTPRICE) as INTERNALLISTPRICE
		, max(INTERNALMARKDOWN) as INTERNALMARKDOWN
		, max(INTERNALPRICE) as INTERNALPRICE
		, max(TERMSALELISTPRICE) as TERMSALELISTPRICE
		, max(TERMSALEPRICE) as TERMSALEPRICE
		, max(TERMSALE) as TERMSALE
		, max(of1) as of1
        , max(of2) as of2
        , max(of3) as of3
        , max(of4) as of4
        , max(of5) as of5
        , max(of6) as of6
        , max(of7) as of7
        , max(of8) as of8
        , max(of9) as of9
        , max(of10) as of10
		, max(of11) as of11
		, max(of12) as of12
		, max(of13) as of13
		, max(of14) as of14
		, max(of15) as of15
		, max(of16) as of16
		, max(of17) as of17
		, max(of18) as of18
		, max(of19) as of19
		, max(of20) as of20
        , max(WEB_OF1) as WEB_OF1
        , max(WEB_OF2) as WEB_OF2
        , max(WEB_OF3) as WEB_OF3
        , max(WEB_OF4) as WEB_OF4
        , max(WEB_OF5) as WEB_OF5
        , max(WEB_OF6) as WEB_OF6
        , max(WEB_OF7) as WEB_OF7
        , max(WEB_OF8) as WEB_OF8
        , max(WEB_OF9) as WEB_OF9
        , max(WEB_OF10) as WEB_OF10
        , max(WEB_OF11) as WEB_OF11
        , max(WEB_OF12) as WEB_OF12 
        , max(WEB_OF13) as WEB_OF13
        , max(WEB_OF14) as WEB_OF14
        , max(WEB_OF15) as WEB_OF15
        , max(WEB_OF16) as WEB_OF16
        , max(WEB_OF17) as WEB_OF17
        , max(WEB_OF18) as WEB_OF18
        , max(WEB_OF19) as WEB_OF19
        , max(WEB_OF20) as WEB_OF20
		, min(deposit) as deposit
		, max(last_rcvd) as last_rcvd
		, ROW_NUMBER() OVER(ORDER BY max(OF7) ASC) AS RowNum
		FROM [dbo].[web_all_products] 
        WHERE 1=1
            --AND pictureid is not null

		
			and ltrim(rtrim(dept))='Reloading'
            
			and ltrim(rtrim(typ))='Powder'
			and ltrim(rtrim(subtyp1)) = 'EMPTY' 
			and (overallQOH > 0 OR len(OF7) > 0)
			
						and upper(pricerange)='50-to-100'
					and upper(of18) = '270 WINCHESTER' GROUP BY STYLE_ID
		ORDER BY min(sortposition)

SELECT * FROM GetALLProducts117 ORDER BY
		last_rcvd desc

select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='reloading-powder'

select dept, typ, subtyp_1, subtyp_2, subtyp_3 from tb_web_taxonomy where web_url='reloading-powder'

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

SELECT DISTINCT subtyp1, count(distinct style_id) as itemCount 
                FROM web_all_products 
                WHERE dept='RELOADING' and typ='POWDER' and upper(subtyp1)<>'EMPTY' 
                GROUP BY subtyp1

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

SELECT pricerange as price, count(distinct
      
        style_id
      
      ) as itemCount FROM GETPRODUCTS 
      WHERE pricerange > ''
      GROUP BY pricerange 
      ORDER BY pricerange ASC

SELECT * FROM temp ORDER BY ranking ASC

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

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

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

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

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

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

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

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

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

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

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

SELECT dept,web_url,sort_position 
                            FROM application.getWebTaxonomy 
                            WHERE typ='EMPTY'  
                            ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='FIREARMS' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='AMMUNITION' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='MAGAZINES' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='RELOADING' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='STORAGE' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='OPTICS' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='KNIVES' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ACCESSORIES' 
                                    ORDER BY sort_position

SELECT typ, web_url 
                                    FROM application.getWebTaxonomy 
                                    WHERE subtyp_1='EMPTY' and typ<>'EMPTY' and upper(dept)='ON SALE' 
                                    ORDER BY sort_position

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
CERT_SERVER_SUBJECT=CN=www.bullseyenorth.com
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\websites\bullseye\category.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=Let's Encrypt, CN=R3
HTTPS_SERVER_SUBJECT=CN=www.bullseyenorth.com
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close
HTTP_COOKIE=fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ
HTTP_HOST=www.bullseyenorth.com
HTTP_REFERER=
HTTP_URL=/category.cfm?mapping=reloading-powder/browse/price/50-to-100/caliber/270-winchester
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=reloading-powder/browse/price/50-to-100/caliber/270-winchester
REMOTE_ADDR=18.216.190.41
REMOTE_HOST=18.216.190.41
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=12972745
CFTOKEN=ea83822003590d25-BA3D2C41-B291-ACF9-59E5137FF3894967
fikker-2ITi-jkXI=4enQXwhGlJjmPkfWL9j3di8QM5h9hgJJ

Form Fields:
KWORD=

Session Variables:
altimgurl=https://www.bullseyenorth.com/prodimages/alt_images/
cartstatus=NEW
cfid=12972745
cftoken=ea83822003590d25-BA3D2C41-B291-ACF9-59E5137FF3894967
checkout=Struct (4)
couponreset=NO
cs=https://www.bullseyenorth.com/reloading-powder/browse/price/50-to-100/caliber/270-winchester
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/reloading-powder/browse/price/50-to-100/caliber/270-winchester
password=
phone=
picurl=https://www.bullseyenorth.com/images/
prodimgurl=https://www.bullseyenorth.com/prodimages/
qualifyingpromoitems=0
sessionid=APPCFC_12972745_ea83822003590d25-BA3D2C41-B291-ACF9-59E5137FF3894967
shipmethodlist=0,1
urltoken=CFID=12972745&CFTOKEN=ea83822003590d25-BA3D2C41-B291-ACF9-59E5137FF3894967
username=
website=Struct (1)

URL Parameters:
mapping=reloading-powder/browse/price/50-to-100/caliber/270-winchester