Total Time	Avg Time	Count	Template
46 ms	46 ms	1	E:\inetpub\Websites\itinscales.com\cat\cat.cfm
16 ms	16 ms	1	E:/inetpub/Websites/global/qry/qry_cat_list.cfm
15 ms	15 ms	1	E:/inetpub/Websites/global/cat/cat_list.cfm
15 ms	15 ms	1	E:/inetpub/Websites/global/qry/qry_product_search.cfm
15 ms	15 ms	1	E:/inetpub/Websites/itinscales.com/includes/inc_site_settings.cfm
0 ms	0 ms	1	E:/inetpub/Websites/global/includes/ACT_BLOCK.cfm
0 ms	0 ms	1	E:/inetpub/Websites/itinscales.com/includes/bottom.cfm
0 ms	0 ms	1	E:/inetpub/Websites/itinscales.com/includes/top.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
46 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SELECT     Cat_sub.Cat_sub_id, Cat_sub.sub_name, Cat_Category.Cat_Category_id, Cat_Category.Category_name,Cat_Category.ScaleGalore_HTML, Cat_department.Cat_department_id, 
                      Cat_department.Department_name, Cat_sub.has_image 
					 , Cat_Category.Caption 
					
FROM         product_store INNER JOIN
                      product ON 
                      product_store.fk_product_id = product.product_id INNER JOIN
                      Product_to_cat_sub ON product.product_id = Product_to_cat_sub.fk_product_id INNER JOIN
                      Cat_sub ON Product_to_cat_sub.fk_Cat_sub_id = Cat_sub.Cat_sub_id INNER JOIN
                      Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id INNER JOIN
                      Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id 
					   
where (Cat_sub.is_active = 1) and product.is_active = 1 and product_store.is_active =1 and product_store.fk_store_id =17 
	and Cat_Category.Cat_Category_id = 45 
GROUP BY 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, Cat_sub.has_image, Cat_sub.Caption, Cat_sub.is_active, 
					  Cat_department.order_by, Cat_Category.order_by, Cat_sub.order_by
					  
   

ORDER BY Cat_department.order_by, Cat_Category.order_by, Cat_sub.order_by
	

SELECT   man_id, man_name , product_id , (select HTML_page From man_store where man.man_id = fk_man_id and fk_store_id = 17 limit 1) as HTML_page
FROM   product INNER JOIN    
		man ON man.man_id = product.fk_man_id INNER JOIN   
		product_store ON product_store.fk_product_id = product.product_id INNER JOIN
	   Product_to_cat_sub ON product.product_id = Product_to_cat_sub.fk_product_id INNER JOIN
      Cat_sub ON Product_to_cat_sub.fk_Cat_sub_id = Cat_sub.Cat_sub_id INNER JOIN
      Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id INNER JOIN
      Cat_department ON Cat_Category.fk_Cat_department_id = Cat_department.Cat_department_id 
 where      (Cat_sub.is_active = 1)

	and Cat_Category.Cat_Category_id = 45 
     
 AND (product.is_active =  1)
GROUP BY man_id, man_name , product_id
    

ORDER BY man_name
	

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

SELECT  product.product_id, 
		product.product_name,
		
		man.man_id,
		man.man_name,
		stock_type.stock_type_id, 
		stock_type.stock_type_color, 
		stock_type.stock_type_name, 
		stock_type.stock_type_name_internal, 
		product_store.price , 
		product_store.HTML_Page,
   		product_store.fk_store_id,
		product_store.is_active,  
		 Cat_sub.Cat_sub_id, Cat_sub.sub_name,
		 Product_detail.Free_product as Free_product_id,
		 Product_detail.cost, 
		 Product_detail.qty_in_stock, 
		 Product_detail.eta, 
		 Product_detail.SKU, 
		  Product_detail.SKU2, 
         Product_detail.ARCUST_CODE, 
		 Product_detail.use_map,
		 Product_detail.Block_cart,
		 Product_detail.Product_note,
		 Product_detail.sale_price,
         Product_detail.Product_note_start, 
		 Product_detail.Product_note_end,
		 Product_detail.Pre_Sale_QTY,
		 Product_detail.qty_in_stock as ONHAND, 
		 Product_detail.man_Warranty,
		 Product_detail.fk_product_condition_id as product_condition_id,
		 page_rank.rank,
		 Cat_Category.Cat_Category_id,
		 Cat_Category.Category_name ,
		 product_description.caption,
		 (select AVG(RATING) from product_review where fk_product_id =  product.product_id and APROVED = 1 ) as RATING,
		(SELECT fk_shipping_type FROM product_shipping where fk_product_id=product.product_id limit 1) as shipping,
		(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, 
		 (SELECT ALOC FROM arinv99 where ITEM = left(product_detail.ARcust_code,50) limit 1) as ALOC
		 
		 
		 

FROM     product 			inner join man on product.fk_man_id = man.man_id 
							INNER JOIN Product_detail ON product.product_id = Product_detail.fk_product_id 
					  		inner JOIN product_description ON product.product_id = product_description.fk_product_id 
                      		inner JOIN product_store on product.product_id = product_store.fk_product_id
                      		inner join stock_type ON Product_detail.fk_stock_type_id = stock_type.stock_type_id 
                      		
					 
					  
					  inner join 
					  product_to_cat_sub on product.product_id = product_to_cat_sub.fk_product_id inner join 
					  Cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id inner join 
					  Cat_Category ON Cat_sub.fk_Cat_Category_id = Cat_Category.Cat_Category_id inner 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  

where price > 0 and
  
		product.is_active=1 and  
	  product_store.is_active = 1 and
	   Product_detail.Block_Search = 0   and 
	  product_store.fk_store_id = 17 
	 and product_detail.Block_cart <> 3
	   and  product_detail.fk_stock_type_id not in (12)
	  and man.man_id <> 286
  
	and Cat_Category.Cat_Category_id in( 45)

group by product.product_id

ORDER BY stock_type.order_by ,page_rank.rank desc,RATING,product.product_name,product.product_id DESC


limit 25 

Application Variables:
applicationname=store_17

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\itinscales.com\cat\cat.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.itinscales.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.healthchecksystems.com
PATH_INFO=
PATH_TRANSLATED=E:\inetpub\Websites\itinscales.com\cat\cat.cfm
QUERY_STRING=Cat_Category_id=45
REMOTE_ADDR=10.189.254.4
REMOTE_HOST=10.189.254.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/cat/Cat.cfm
SERVER_NAME=www1.itinscales.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=17754571
cftoken=da2fe84f5f6d9230-E05AF979-BB71-2376-FEDAFD3F33627EF8
hitcount=1
lastvisit={ts '2024-04-25 14:05:56'}
remote_addr=18.119.125.135
timecreated={ts '2024-04-25 14:05:56'}
urltoken=CFID=17754571&CFTOKEN=da2fe84f5f6d9230-E05AF979-BB71-2376-FEDAFD3F33627EF8&jsessionid=6032399BCC2682BC9B0ED0C4F0D0E193.cfusion

Cookie Variables:
CFID=17754571
CFTOKEN=da2fe84f5f6d9230-E05AF979-BB71-2376-FEDAFD3F33627EF8

Form Fields:
CAT_CATEGORY_ID=
ORDER_BY=0
PAGE_NO=1
S_PRODUCT=
S_PRODUCT_W_S=

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

Session Variables:
sessionid=6032399BCC2682BC9B0ED0C4F0D0E193.cfusion
urltoken=CFID=17754571&CFTOKEN=da2fe84f5f6d9230-E05AF979-BB71-2376-FEDAFD3F33627EF8&jsessionid=6032399BCC2682BC9B0ED0C4F0D0E193.cfusion

URL Parameters:
Cat_Category_id=45