Total Time	Avg Time	Count	Template
47 ms	47 ms	1	E:\inetpub\Websites\healthchecksystems.com\cat\product_list.cfm
31 ms	16 ms	2	E:/inetpub/Websites/healthchecksystems.com/includes/inc_site_settings.cfm
16 ms	16 ms	1	E:/inetpub/Websites/global/cat/product_list_1.cfm
15 ms	15 ms	1	E:/inetpub/Websites/healthchecksystems.com/includes/top.cfm
0 ms	0 ms	1	E:/inetpub/Websites/global/includes/ACT_BLOCK.cfm
0 ms	0 ms	1	E:/inetpub/Websites/global/qry/qry_product_list.cfm
0 ms	0 ms	1	E:/inetpub/Websites/healthchecksystems.com/includes/bottom.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
47 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

	SELECT IP FROM block_ip 
	WHERE IP = '18.119.172.146'
	limit 1

SELECT    product.product_id, product.product_name, man.man_id, man.man_name, Cat_sub.Cat_sub_id, Cat_sub.sub_name, Cat_Category.Cat_Category_id, 
                      Cat_Category.Category_name, Cat_department.Cat_department_id, Cat_department.Department_name, Product_group.Product_group_id, 
                      Product_group.Group_name, product_store.Price,product_store.HTML_Page, Product_detail.qty_in_stock,Product_description.caption,Product_detail.Product_note, Product_detail.sale_price,
                      Product_detail.Product_note_start, Product_detail.Product_note_end,Product_detail.SKU,stock_type.stock_type_id, 
		stock_type.stock_type_color, page_rank.rank,
		stock_type.stock_type_name, 
					  Product_detail.Pre_Sale_QTY,Product_detail.Pre_Sale_QTY,
			 (select product_name from product p where product_id=Product_detail.Free_product) as Free_product_name,
			 (select product_kit_name from product p where product_id=Product_detail.Free_product) as Free_product_kit_name,
			 Product_detail.Free_product as Free_product_id,(SELECT     shipping_type.shipmentDesc
                            FROM          product_shipping INNER JOIN
                                                   shipping_type ON product_shipping.fk_shipping_type = shipping_type.shipping_type_id
                            WHERE      (shipping_type.stateCode IS NOT NULL) AND (shipping_type.countryCode = 'US') AND 
                                                   (product_shipping.fk_product_id = product.product_id)
                            ORDER BY shipping_type.shipping_type_id DESC limit 1 ) AS shipping,
							(select AVG(RATING) from product_review where fk_product_id =  product.product_id and APROVED = 1 ) as RATING,
			(SELECT HTML_page FROM man_store where fk_store_id=1 and fk_man_id = man.man_id limit 1) as man_HTML_page
FROM 
		product INNER JOIN
		Product_description ON 	Product_description.fk_product_id = product.product_id INNER JOIN
		product_store ON product_store.fk_product_id = product.product_id INNER JOIN
		man ON product.fk_man_id = man.man_id  INNER JOIN
		Product_detail ON product.product_id = Product_detail.fk_product_id LEFT OUTER JOIN
		Product_to_cat_sub ON product.product_id = Product_to_cat_sub.fk_product_id LEFT OUTER JOIN
		Cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id LEFT OUTER JOIN
		Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id LEFT OUTER JOIN
		Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id LEFT OUTER JOIN
		page_rank ON product.product_id = page_rank.fk_product_id LEFT OUTER JOIN
		product_group_to_product_id ON product.product_id = product_group_to_product_id.fk_product_id LEFT OUTER JOIN
		Product_group ON Product_group.Product_group_id = product_group_to_product_id.fk_product_group_id inner join 
		stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id  
WHERE     (product.is_active = 1) AND 
			product_detail.Block_cart = 0 and
		  (product_store.fk_store_id = 1) and
		  product_store.is_active = 1
		   and man.man_id <> 286
		  
		  and (Product_to_cat_sub.fk_Cat_sub_id in(485) )
		  
		  and product.product_id not in(SELECT fk_product_id FROM product_kit_component where fk_product_id = product.product_id)
		  


 ORDER BY Cat_department.ORDER_BY ,Cat_department.Cat_department_id,
		Cat_Category.ORDER_BY,Cat_Category.Cat_Category_id,
		Cat_sub.ORDER_BY,Cat_sub.Cat_sub_id,
		man.man_name,
		Product_group.Group_name DESC, 
		page_rank.rank desc, 
		product_store.Price ,
		product.product_name  
limit 600 

Application Variables:
applicationname=store_1

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\Websites\healthchecksystems.com\cat\product_list.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=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www1.healthchecksystems.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=www1.itinscales.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\Websites\healthchecksystems.com\cat\product_list.cfm
QUERY_STRING=Cat_sub_id=485
REMOTE_ADDR=10.189.254.4
REMOTE_HOST=10.189.254.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/cat/product_list.cfm
SERVER_NAME=www1.healthchecksystems.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.0
WEB_SERVER_API=

Client Variables:
cfid=17754561
cftoken=ef81a494c67a4da2-E05512C0-B038-1975-B25A4E6945CDE540
hitcount=2
lastvisit={ts '2024-04-25 14:05:18'}
remote_addr=18.119.172.146
timecreated={ts '2024-04-25 14:05:18'}
urltoken=CFID=17754561&CFTOKEN=ef81a494c67a4da2-E05512C0-B038-1975-B25A4E6945CDE540&jsessionid=BC5FD02DE6ABD5793EAF8321B98AC40E.cfusion

Cookie Variables:
CFID=17754561
CFTOKEN=ef81a494c67a4da2-E05512C0-B038-1975-B25A4E6945CDE540

Form Fields:
S_PRODUCT=
S_PRODUCT_NAME=

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

Session Variables:
sessionid=BC5FD02DE6ABD5793EAF8321B98AC40E.cfusion
urltoken=CFID=17754561&CFTOKEN=ef81a494c67a4da2-E05512C0-B038-1975-B25A4E6945CDE540&jsessionid=BC5FD02DE6ABD5793EAF8321B98AC40E.cfusion

URL Parameters:
Cat_sub_id=485