Shopping Cart

SKU Number Product Name Quantity Unit Price Total Price
Your shopping cart is empty
Cart Subtotal $0.00
Shipping $0.00
Tax $0.00
Order Total $0.00
Minimum order is $25.00

Shipping Method:

Payment Method:

AVStar business accounts will be billed according to terms of agreement.

All other accounts must use paypal (requires paypal account).

© 2009 Avstar Fuel Systems Inc.

(default) 12 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `carts`771
2DESCRIBE `products`12121
3DESCRIBE `categories`220
4DESCRIBE `orders`11111
5DESCRIBE `users`12121
6DESCRIBE `addresses`17171
7DESCRIBE `rates`660
8SELECT COUNT(*) AS `count` FROM `carts` AS `Cart` LEFT JOIN `products` AS `Product` ON (`Cart`.`product_id` = `Product`.`id`) LEFT JOIN `orders` AS `Order` ON (`Cart`.`order_id` = `Order`.`id`) WHERE `Cart`.`sessionid` = 'a9b35d08846c2a269b811f9ac3f37faf' 111
9SELECT `Product`.`sku`, `Product`.`title`, `Product`.`id`, `Cart`.`id`, SUM(`Cart`.`qty`) as qty, `Product`.`price`, SUM(`Cart`.`price`) as productPrice FROM `carts` AS `Cart` LEFT JOIN `products` AS `Product` ON (`Cart`.`product_id` = `Product`.`id`) LEFT JOIN `orders` AS `Order` ON (`Cart`.`order_id` = `Order`.`id`) WHERE `Cart`.`sessionid` = 'a9b35d08846c2a269b811f9ac3f37faf' GROUP BY `Cart`.`product_id` 001
10SELECT SUM(`Cart`.`price`) as subtotal FROM `carts` AS `Cart` LEFT JOIN `products` AS `Product` ON (`Cart`.`product_id` = `Product`.`id`) LEFT JOIN `orders` AS `Order` ON (`Cart`.`order_id` = `Order`.`id`) WHERE `Cart`.`sessionid` = 'a9b35d08846c2a269b811f9ac3f37faf' 111
11SELECT `Rate`.`id`, `Rate`.`type`, `Rate`.`price` FROM `rates` AS `Rate` WHERE `Rate`.`category` = '1' 330
12SELECT `Order`.`id`, `Order`.`confirmation`, `Order`.`user_id`, `Order`.`total`, `Order`.`subtotal`, `Order`.`tax`, `Order`.`rate_id`, `Order`.`status`, `Order`.`created`, `Order`.`modified`, `Order`.`notes` FROM `orders` AS `Order` WHERE `Order`.`rate_id` IN (1, 5, 10) 45451