Shopping Cart

Total Time	Avg Time	Count	Template
171 ms	171 ms	1	E:\inetpub\Websites\healthchecksystems.com\checkout\cart.cfm
109 ms	109 ms	1	E:/inetpub/Websites/global/checkout/dsp_cart.cfm
16 ms	16 ms	1	E:/inetpub/Websites/global/includes/act_add_to_cart.cfm
16 ms	8 ms	2	E:/inetpub/Websites/healthchecksystems.com/includes/inc_site_settings.cfm
16 ms	16 ms	1	E:/inetpub/Websites/healthchecksystems.com/includes/top.cfm
15 ms	15 ms	1	CFC[ E:/inetpub/Websites/global/CFC/cfc_shipping.cfc | GetCartShipping(CART = [complex value]) ] from E:/inetpub/Websites/global/CFC/cfc_shipping.cfc
15 ms	15 ms	1	E:/inetpub/Websites/global/qry/qry_cart.cfm
0 ms	0 ms	3	E:/inetpub/Websites/global/includes/ACT_BLOCK.cfm
0 ms	0 ms	1	E:/inetpub/Websites/global/includes/act_cart_convert_id.cfm
0 ms	0 ms	1	E:/inetpub/Websites/healthchecksystems.com/includes/bottom.cfm
0 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
171 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

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

	insert into cart (IP,fk_store_id,the_datetime) values ('18.118.184.237',1,{ts '2024-04-25 14:16:04'})
	

	select max(cart_id) as new_cart from cart where IP = '18.118.184.237'
	

	SELECT     product.product_id, 
	product.product_name, product.is_active, product.old_id, product_store.Price, 
	Product_detail.dim_weight, 
	Product_detail.SKU, Product_detail.ARCUST_CODE,
                      product_store.fk_store_id
	FROM         product INNER JOIN
                      Product_detail ON product.product_id = Product_detail.fk_product_id INNER JOIN
                      product_store ON product.product_id = product_store.fk_product_id
	WHERE     (product.is_active = 1) AND (product_store.fk_store_id = 1) 
			AND (product.product_id = 24079)
	 limit 1 

		insert into cart_detail 
		(fk_cart_id, fk_product_id, Arcust_id, product_name, qty, price_ea, weight,source,Block_Promo) 
		values (20545227,24079,'FLE-626BLUE','Flexible Flyer 626 Flying Saucer - Blue',1,
		34.99,
		35,
		
		'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
		,
		
		0
		
		
		)
		

		UPDATE cart
		SET the_datetime={ts '2024-04-25 14:16:04'} 
		 where cart_id = 20545227 

SELECT     cart.cart_id, cart.the_datetime, cart.fk_customer_id, cart.IP, cart.fk_campain_id,cart.fk_store_id, cart.IP, cart.shippint_type, cart.paypal_token, cart.google_shoppingcart, 
                      cart.promo, cart.COUNTRYCODE, cart_detail.fk_product_id, cart_detail.Arcust_id, cart_detail.product_name, cart_detail.qty, cart_detail.price_ea, 
                      cart_detail.weight, Product_detail.dim_weight,Product_detail.SKU,cart_detail.source,cart_detail.Block_Promo,
					  stock_type.stock_type_name,stock_type.stock_type_color,stock_type.stock_type_id,Product_detail.fk_product_condition_id as product_condition_id,
					  cart_detail.cart_detail_id, Product_detail.use_map, Product_detail.cost,Product_detail.Only_With_Scale, Product_detail.qty_in_stock, Product_detail.qty_in_stock,Product_detail.Flat_Shipping,
					    Product_detail.qty_in_stock as ONHAND, Product_detail.man_Warranty,Product_detail.buy_upc,
					  Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only, Product_detail.days_till_ship,Product_detail.fk_Warranty_id, Product_detail.eta, Product_detail.Pre_Sale_QTY,
					        (SELECT   Cat_sub.fk_Cat_Category_id
                            FROM          Cat_sub INNER JOIN
                                                   Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id
                            WHERE      (Product_to_cat_sub.fk_product_id = cart_detail.fk_product_id)
							 limit 1
							) AS fk_Cat_Category_id, product.fk_man_id,product.old_id,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 10 limit 1) as ship_10,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 20 limit 1) as ship_20,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 30 limit 1) as ship_30,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 32 limit 1) as ship_32,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 34 limit 1) as ship_34,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 36 limit 1) as ship_36,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 40 limit 1) as ship_40,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 42 limit 1) as ship_42,
							(SELECT fk_acc_id FROM product_to_acc where fk_product_id = product.product_id limit 1) as has_ACC,
							
							0 as ALOC,
							
							 (SELECT GSAIFF FROM gsa_price_list where fk_product_id = product_detail.fk_product_id and Com_name = 'ItinScales' limit 1) as gsa_price 
											
FROM         product RIGHT OUTER JOIN
                      cart_detail ON product.product_id = cart_detail.fk_product_id LEFT OUTER JOIN
                      Product_detail ON cart_detail.fk_product_id = Product_detail.fk_product_id RIGHT OUTER JOIN
                      cart ON cart_detail.fk_cart_id = cart.cart_id  LEFT OUTER JOIN
					  stock_type ON stock_type.stock_type_id=Product_detail.fk_stock_type_id 
					
WHERE     (cart.cart_id = 20545227) and (product.is_active = 1)



union


SELECT  distinct    cart.cart_id, cart.the_datetime, cart.fk_customer_id, cart.IP, cart.fk_campain_id,cart.fk_store_id, cart.IP, cart.shippint_type, cart.paypal_token, cart.google_shoppingcart, 
                      cart.promo, cart.COUNTRYCODE, cart_detail.fk_product_id, cart_detail.Arcust_id, cart_detail.product_name, cart_detail.qty, cart_detail.price_ea, 
                      cart_detail.weight, Product_detail.dim_weight,Product_detail.SKU,cart_detail.source,cart_detail.Block_Promo,
					  stock_type.stock_type_name,stock_type.stock_type_color,stock_type.stock_type_id,Product_detail.fk_product_condition_id as product_condition_id,
					  cart_detail.cart_detail_id, Product_detail.use_map, Product_detail.cost, Product_detail.Only_With_Scale, Product_detail.qty_in_stock, Product_detail.qty_in_stock,Product_detail.Flat_Shipping,
					    Product_detail.qty_in_stock as ONHAND, Product_detail.man_Warranty,Product_detail.buy_upc,
					  Product_detail.show_Ship_USA_only, Product_detail.ship_ground_only, Product_detail.days_till_ship,Product_detail.fk_Warranty_id, Product_detail.eta, Product_detail.Pre_Sale_QTY,
					        (SELECT   Cat_sub.fk_Cat_Category_id
                            FROM          Cat_sub INNER JOIN
                                                   Product_to_cat_sub ON Cat_sub.Cat_sub_id = Product_to_cat_sub.fk_Cat_sub_id
                            WHERE      (Product_to_cat_sub.fk_product_id = cart_detail.fk_product_id)
							 limit 1
							) AS fk_Cat_Category_id, product.fk_man_id,product.old_id,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 10 limit 1) as ship_10,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 20 limit 1) as ship_20,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 30 limit 1) as ship_30,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 32 limit 1) as ship_32,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 34 limit 1) as ship_34,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 36 limit 1) as ship_36,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 40 limit 1) as ship_40,
							(SELECT fk_shipping_type FROM product_shipping where fk_product_id = product.product_id and fk_shipping_type = 42 limit 1) as ship_42,
							(SELECT count(fk_product_id) FROM product_to_acc where fk_product_id = product.product_id limit 1) as has_ACC,
							
							0 as ALOC,
							
							
							(SELECT GSA_Price FROM product_gsa where FK_PRODUCT_ID = product.product_id limit 1) as GSA_Price
														
FROM         product RIGHT OUTER JOIN
                      cart_detail ON product.product_id = cart_detail.fk_product_id LEFT OUTER JOIN
                      Product_detail ON cart_detail.fk_product_id = Product_detail.fk_product_id RIGHT OUTER JOIN
                      cart ON cart_detail.fk_cart_id = cart.cart_id  LEFT OUTER JOIN
					  stock_type ON stock_type.stock_type_id=Product_detail.fk_stock_type_id 
					
WHERE     (cart.cart_id = 20545227) and (cart_detail.fk_product_id = 0)


	

	SELECT fk_acc_id FROM product_to_acc where fk_product_id in(24079)
	

	SELECT     shipping_type_id, COUNTRYCODE,shipmentDesc
	FROM         shipping_type 
	Where shipping_type_id <> 322
	order by shipmentDesc
	

			SELECT     shipping_type_id, shipmentDesc, amazon_code,
				priceToAdd, perWeightToAdd, stateCode, countryCode,
				(
		
				 case
				when ( (SELECT     Product_detail.dim_weight
				FROM         product_shipping INNER JOIN
		                      Product_detail ON product_shipping.fk_product_id = Product_detail.fk_product_id
				where product_shipping.fk_shipping_type = shipping_type.shipping_type_id and 
				Product_detail.fk_product_id=24079 limit 1
				) > 0 ) then 
				0
				else
				(SELECT     dim_weight from Product_detail where fk_product_id=24079 limit 1)
				end
		
		) as   dim_weight
		FROM         shipping_type
		WHERE     (countryCode = 'US')
		

 
	SELECT     stateCode, stateName
	FROM         statecode
	
	ORDER BY stateName
	

 
	select 'United States' as shipmentDesc , 'US' as countryCode
	union
	select 'Canada' as shipmentDesc , 'CA' as countryCode
	union
	SELECT     REPLACE(shipmentDesc, 'UPS Intl - ', '') AS shipmentDesc, countryCode
	FROM         shipping_type
	WHERE     (countryCode <> 'US') AND (countryCode <> 'CA')
	ORDER BY shipmentDesc
	

		SELECT warranty_group.Warranty_Group_id, warranty_group.fk_Warranty_id, warranty_group.fk_product_id, warranty_group.from_price, warranty_group.to_price,
		warranty.warranty_id,warranty.warranty_name,product.product_name
		FROM warranty_group inner join warranty on warranty.warranty_id = warranty_group.fk_Warranty_id inner join product
		 on product.product_id = warranty_group.fk_product_id
		 where warranty_group.fk_Warranty_id=0 and from_price <= 34.99 and to_price >= 34.99
		order by warranty_group.from_price, product.product_name
		

			SELECT     shipping_type_id, shipmentDesc, amazon_code,
				priceToAdd, perWeightToAdd, stateCode, countryCode 
		FROM         shipping_type
		WHERE     (countryCode = 'US')
		

select amount from shipping where shipping_type_id = 10

select amount from shipping where shipping_type_id = 20

select amount from shipping where shipping_type_id = 30

select amount from shipping where shipping_type_id = 32

select amount from shipping where shipping_type_id = 34

select amount from shipping where shipping_type_id = 36

select amount from shipping where shipping_type_id = 40

select amount from shipping where shipping_type_id = 42

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\checkout\cart.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\checkout\cart.cfm
QUERY_STRING=add_product_id=24079
REMOTE_ADDR=10.189.254.4
REMOTE_HOST=10.189.254.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/checkout/cart.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:
cart_id=20545227
cfid=17754630
cftoken=b964127e04343174-E0B7A340-E21F-FC3A-3685F02D2E0A8172
hitcount=2
lastvisit={ts '2024-04-25 14:16:04'}
remote_addr=18.118.184.237
timecreated={ts '2024-04-25 14:16:04'}
urltoken=CFID=17754630&CFTOKEN=b964127e04343174-E0B7A340-E21F-FC3A-3685F02D2E0A8172&jsessionid=7126A5E304FD325572D3664BB5C7B921.cfusion

Cookie Variables:
CFID=17754630
CFTOKEN=b964127e04343174-E0B7A340-E21F-FC3A-3685F02D2E0A8172

Form Fields:
SHIPPING_TYPE_COUNTRY_H=US
S_PRODUCT=

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

Session Variables:
sessionid=7126A5E304FD325572D3664BB5C7B921.cfusion
urltoken=CFID=17754630&CFTOKEN=b964127e04343174-E0B7A340-E21F-FC3A-3685F02D2E0A8172&jsessionid=7126A5E304FD325572D3664BB5C7B921.cfusion

URL Parameters:
add_product_id=24079