Shopping Cart

Precisa Radwag Balances Rice Lake Salter Brecknell Sartorius Seca Setra Shimpo T-Scale Tanita Torrey Scales TREE Troemner US Balance UWE Scales US Balance Vision Tech WeighMax WeighSouth

Analytical/Lab Baby Scales Bariatric Scales Bathroom Scales Calibration Weights Cannabis Scales Counting Scales Crane Scales Explosion Proof

Fishing/Game Food/Deli Scales Floor Scales Force Gauges Height Measurement Industrial Scales Jewelry Scales Kitchen Scales Laundromat Scales Legal for Trade Legal for Trade Canada

Medical Scales Moisture Analyzers Pallet Jack Scales Physician Scales Retail Scales Specialty Medical Shipping Scales Test Stands Veterinary Scales Wheelchair Scales Wheel Weighing Scales

Shopping Cart

Quantity

Name

Price EA

Total

Remove

Mark-10 ES20 Manual Test Stand, 100 lb, Hand Wheel Operated
SKU: ES20
In Stock - Ships within 24 hours
View Accessories

$736.25

$736.25

Ground, UPS

$0.00

$0.00

3 Day, UPS

$114.00

2 Day Air, UPS

$145.00

2 Day Air, UPS - Alaska

$202.00

2 Day Air, UPS - Hawaii

$202.00

2 Day Air, UPS - Puerto Rico

$202.00

Next Day Air, UPS

$223.00

Next Day Air Saturday, UPS

$238.00

Select a Country

Enter Promo Code

Sub Total

$736.25

*itinscales.com does not collect sales tax from any state other than NY.
**Alaska, Hawaii and Puerto Rico Two day shipping only

Debugging Information

ColdFusion Server Enterprise	10,0,23,302580
Template	/checkout/cart.cfm
Time Stamp	25-Apr-24 02:05 PM
Locale	English (US)
User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP	10.189.254.4
Host Name	10.189.254.4

Execution Time

Total Time	Avg Time	Count	Template
156 ms	156 ms	1	E:\inetpub\Websites\itinscales.com\checkout\cart.cfm
93 ms	93 ms	1	E:/inetpub/Websites/global/checkout/dsp_cart.cfm
32 ms	16 ms	2	E:/inetpub/Websites/itinscales.com/includes/inc_site_settings.cfm
32 ms	32 ms	1	E:/inetpub/Websites/itinscales.com/includes/top_new.cfm
16 ms	16 ms	1	E:/inetpub/Websites/global/qry/qry_cart.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/includes/act_add_to_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/itinscales.com/includes/bottom_new.cfm
15 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
171 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

BLOCK (Datasource=STORE2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\includes\ACT_BLOCK.cfm @ 14:05:48.048

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

new_cart (Datasource=store2008, Time=15ms, Records=1) in E:\inetpub\Websites\global\includes\act_add_to_cart.cfm @ 14:05:48.048

	insert into cart (IP,fk_store_id,the_datetime) values ('18.218.184.214',17,{ts '2024-04-25 14:05:48'})

new_cart (Datasource=store2008, Time=0ms, Records=1) in E:\inetpub\Websites\global\includes\act_add_to_cart.cfm @ 14:05:48.048

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

product_cart (Datasource=store2008, Time=0ms, Records=1) in E:\inetpub\Websites\global\includes\act_add_to_cart.cfm @ 14:05:48.048

	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 = 17) 
			AND (product.product_id = 6556)
	 limit 1

insert_cart (Datasource=store2008, Time=0ms, Records=1) in E:\inetpub\Websites\global\includes\act_add_to_cart.cfm @ 14:05:48.048

		insert into cart_detail 
		(fk_cart_id, fk_product_id, Arcust_id, product_name, qty, price_ea, weight,source,Block_Promo) 
		values (20545110,6556,'MAR-ES20','Mark-10 ES20 Manual Test Stand, 100 lb, Hand Wheel Operated',1,
		736.25,
		40,
		
		'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
		,
		
		0
		
		
		)

date (Datasource=store2008, Time=0ms, Records=1) in E:\inetpub\Websites\global\qry\qry_cart.cfm @ 14:05:48.048

		UPDATE cart
		SET the_datetime={ts '2024-04-25 14:05:48'} 
		 where cart_id = 20545110

cart (Datasource=store2008, Time=16ms, Records=1) in E:\inetpub\Websites\global\qry\qry_cart.cfm @ 14:05:48.048

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 = 20545110) 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 = 20545110) and (cart_detail.fk_product_id = 0)

Has_free_shipping (Datasource=store2008, Time=0ms, Records=4) in E:\inetpub\Websites\global\qry\qry_cart.cfm @ 14:05:48.048

	SELECT fk_acc_id FROM product_to_acc where fk_product_id in(6556)

countrycodes (Datasource=store2008, Time=0ms, Records=232, Cached Query) in E:\inetpub\Websites\global\qry\qry_cart.cfm @ 14:05:48.048

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

cart_shipping (Datasource=store2008, Time=0ms, Records=8) in E:\inetpub\Websites\global\qry\qry_cart.cfm @ 14:05:48.048

			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=6556 limit 1
				) > 0 ) then 
				0
				else
				(SELECT     dim_weight from Product_detail where fk_product_id=6556 limit 1)
				end
		
		) as   dim_weight
		FROM         shipping_type
		WHERE     (countryCode = 'US')

stateCode (Datasource=store2008, Time=0ms, Records=53, Cached Query) in E:\inetpub\Websites\global\checkout\dsp_cart.cfm @ 14:05:48.048

 
	SELECT     stateCode, stateName
	FROM         statecode
	
	ORDER BY stateName

countryCode (Datasource=store2008, Time=0ms, Records=225, Cached Query) in E:\inetpub\Websites\global\checkout\dsp_cart.cfm @ 14:05:48.048

 
	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

warranty (Datasource=store2008, Time=0ms, Records=0) in E:\inetpub\Websites\global\checkout\dsp_cart.cfm @ 14:05:48.048

		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 <= 736.25 and to_price >= 736.25
		order by warranty_group.from_price, product.product_name

cart_shipping (Datasource=store2008, Time=0ms, Records=8) in E:\inetpub\Websites\global\CFC\cfc_shipping.cfc @ 14:05:48.048

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

temp_shipping (Datasource=, Time=15ms, Records=1) in E:\inetpub\Websites\global\CFC\cfc_shipping.cfc @ 14:05:48.048

select amount from shipping where shipping_type_id = 10