Midwest Can Gas Can by Midwest Can

from $14.81

Please choose from the options above to see price and availability.

Product prices and availability are accurate as of 2017-07-24 12:55:01 UTC and are subject to change. Any price and availability information displayed on http://www.amazon.com/ at the time of purchase will apply to the purchase of this product.

Description of Midwest Can Gas Can by Midwest Can

We are happy to present the excellent Midwest Can Gas Can.

With so many on offer recently, it is great to have a brand you can trust. The Midwest Can Gas Can is certainly that and will be a perfect acquisition.

For this great price, the Midwest Can Gas Can is widely respected and is a popular choice amongst lots of people. Midwest Can have included some great touches and this results in great value for money.

Manufacturer Description

2 Gallon 6 OZ, Red, Plastic Gas Can, Extra Capacity For Mixing Oil, Spill Proof Spout Automatically Shuts Off When Tank Is Full, Bottom Hand Hold For Easier Pouring, Meets CARB & EPA Requirements.

Write a Review

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.204861879349 297 0.0488 0


No Amazon API Requests Made.

Total time 0.204861879349 seconds

Number Time From Start Name Description
1 0.0505068302155 Initialise Initialise FSB Function
2 0.0518038272858 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0562908649445 Start of getCategoryListByGroup Function Before first category groups query
4 0.0565659999847 After initial query Before first category groups query
5 0.0565679073334 Get Category List for Group Before the call to getCategoryList function
6 0.0565829277039 Start of GetCategoryList function Start of the function
7 0.0565869808197 Before getting categories Query to get specific category list
8 0.056893825531 After getting categories Query to get specific category list
9 0.0569088459015 Before getting category custom Before call to function getCategoryCustom
10 0.0586309432983 After getting category custom After call to function getCategoryCustom
11 0.058632850647 Before getting category custom Before call to function getCategoryCustom
12 0.0594999790192 After getting category custom After call to function getCategoryCustom
13 0.0595018863678 Before getting category custom Before call to function getCategoryCustom
14 0.060243844986 After getting category custom After call to function getCategoryCustom
15 0.0602450370789 Before getting category custom Before call to function getCategoryCustom
16 0.0609638690948 After getting category custom After call to function getCategoryCustom
17 0.0609660148621 End of GetCategoryList function End of the function
18 0.0609738826752 End of getCategoryListByGroup Function Before return()
19 0.0626859664917 App Controller End End of the App controller (called before the controller of every page)
20 0.0638318061829 Product Start Start of the product info controller
21 0.0642700195312 Cache file not found Starting get product details
22 0.0694708824158 Related products Start getting related products if enabled
23 0.0694718360901 Related Products Start Before the related products are found
24 0.069473028183 Related Products Keywords Before the related product keywords are found
25 0.0694780349731 Create Keyword List Function Start of function
26 0.0698800086975 Create Keyword List Function After looping provided content - 284 keywords found
27 0.0832369327545 Create Keyword List Function After looping initial keyword list - 248 keywords remaining
28 0.0832948684692 Create Keyword List Function After reducing keyword list
29 0.0851240158081 Create Keyword List Function After selecting by scoring keywords
30 0.0851278305054 Create Keyword List Function After final loop of keywords
31 0.0851340293884 Related Products Keywords After the related product keywords are found
32 0.0983870029449 Related Products End After the related products are found
33 0.10399389267 Product End End of the product info controller (Product Info)
34 0.104770898819 App_after Controller Start Start of the App_after controller (called after the controller of every page)
35 0.10483288765 Before Get Options Before the call to getOptions in the tpl class
36 0.122156858444 After Get Options After the call to getOptions in the tpl class
37 0.122279882431 App_after Controller End End of the App_after controller (called after the controller of every page)
38 0.122282028198 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
39 0.185524940491 Product Info: After Smarty Fetch After the product.tpl template is fetched
40 0.185534000397 Product Info: Before Template Display Before the template is displayed
41 0.204830884933 Product Info: After Template Display After the template is displayed
42 0.204834938049 Finalizing debug Before the debug is output to the page.
43 0.204860925674 End of App This is the end of the app logging, final timestamp


Query Debug - 297 Database Queries. Total time 0.0488 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000353097915649
SELECT parameter, value FROM parameters
2 0.0002 0.000165939331055
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000161170959473
SET time_zone = 'Europe/London'
4 0.0003 0.000346899032593
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0003 0.000277042388916
UPDATE autorun SET lastrun = '2017-07-25 12:31:40' WHERE id = '10'
6 0.0002 0.000229120254517
SELECT * FROM version ORDER BY installed DESC LIMIT 1
7 0.0003 0.000256061553955
SELECT id FROM pages WHERE pagename = 'midwest-can-gas-can' LIMIT 1
8 0.0003 0.000285863876343
SELECT id FROM products WHERE pagename = 'midwest-can-gas-can' AND hidden = 0 LIMIT 1
9 0.0004 0.000395059585571
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
10 0.0031 0.00312399864197
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
11 0.0003 0.000255107879639
SELECT * FROM pages WHERE pagename = 'midwest-can-gas-can'
12 0.0002 0.000231027603149
SELECT * FROM categorygroups ORDER BY sortorder ASC
13 0.0003 0.00026798248291
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
14 0.0004 0.000350952148438
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 67
15 0.0002 0.000249147415161
SELECT id FROM categories WHERE parent_id = '67'
16 0.0003 0.000300884246826
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (67)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
17 0.0002 0.000185012817383
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (67)
				  AND p.disabled = 0 AND offers > 0
18 0.0002 0.000247001647949
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
19 0.0002 0.000197887420654
SELECT * FROM categorygroups WHERE id = '10'
20 0.0002 0.000188827514648
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 68
21 0.0001 0.000104904174805
SELECT id FROM categories WHERE parent_id = '68'
22 0.0002 0.000208139419556
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
23 0.0001 9.70363616943E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (68)
				  AND p.disabled = 0 AND offers > 0
24 0.0001 9.98973846436E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
25 0.0001 7.29560852051E-5
SELECT * FROM categorygroups WHERE id = '10'
26 0.0001 0.000144004821777
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 69
27 0.0001 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '69'
28 0.0002 0.000180959701538
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
29 0.0001 9.20295715332E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 AND offers > 0
30 0.0001 9.70363616943E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
31 0.0001 0.000101089477539
SELECT * FROM categorygroups WHERE id = '10'
32 0.0001 0.0001380443573
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 70
33 0.0001 9.79900360107E-5
SELECT id FROM categories WHERE parent_id = '70'
34 0.0001 0.000125885009766
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (70)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
35 0.0001 7.82012939453E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 AND offers > 0
36 0.0001 0.000123023986816
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
37 0.0001 9.89437103271E-5
SELECT * FROM categorygroups WHERE id = '10'
38 0.0002 0.000174999237061
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
39 0.0001 0.000123023986816
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
40 0.0001 7.79628753662E-5
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
41 0.0001 9.79900360107E-5
SELECT * FROM pages WHERE id = '37'
42 0.0001 0.000107049942017
SELECT * FROM pages WHERE id = '4'
43 0.0001 7.91549682617E-5
SELECT * FROM pages WHERE id = '34'
44 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = '3'
45 0.0001 0.000103950500488
SELECT * FROM pages WHERE id = '24'
46 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = '5'
47 0.0001 7.91549682617E-5
SELECT * FROM pages WHERE id = '38'
48 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = '39'
49 0.0002 0.000164031982422
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
50 0.0001 0.000137090682983
SELECT * FROM products WHERE pagename = 'midwest-can-gas-can'
51 0.0001 9.08374786377E-5
SELECT * FROM manufacturers WHERE id = '639'
52 0.0001 0.0001060962677
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
53 0.0001 7.5101852417E-5
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
54 0.0001 0.00010085105896
SELECT pagename, id FROM products p WHERE manufacturer_id = '639' ORDER BY RAND() LIMIT 1
55 0.0001 9.10758972168E-5
SELECT * FROM productimages WHERE product_id = '53170' ORDER BY sortorder ASC
56 0.0001 0.000112056732178
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
57 0.0001 0.000137090682983
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 AND offers > 0
58 0.0001 8.79764556885E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
59 0.0001 8.98838043213E-5
SELECT category_id FROM products_categories WHERE product_id = '53170'
60 0.0001 0.000108003616333
SELECT * FROM categories WHERE id = '69'
61 0.0001 0.000144958496094
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 69
62 0.0001 6.60419464111E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
63 0.0001 7.00950622559E-5
SELECT id FROM categories WHERE parent_id = '69'
64 0.0002 0.000194072723389
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
65 0.0001 9.51290130615E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 AND offers > 0
66 0.0001 0.000110864639282
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
67 0.0001 0.000104188919067
SELECT * FROM productimages WHERE product_id = '53170' ORDER BY sortorder ASC
68 0.0001 0.000144958496094
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53170' AND p.id = pi.product_id ORDER BY pi.sortorder
69 0.0001 9.58442687988E-5
SELECT * FROM product_image_select WHERE product_id = '53170'
70 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53170'
71 0.0001 6.69956207275E-5
SELECT * FROM productfeeds WHERE product_id = '53170' ORDER BY item_date DESC
72 0.0001 0.000137090682983
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '53170' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
73 0.0002 0.000166893005371
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '53170' AND t.hidden = 0 AND display_product = 1
74 0.0001 0.000118970870972
SELECT * FROM productamazoncontent WHERE product_id = '53170'
75 0.0002 0.000163078308105
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53170'
				GROUP BY o.product_id
76 0.0002 0.000155210494995
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53170'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
77 0.0001 0.000112056732178
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53170
78 0.0004 0.000411033630371
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53170' AND a.name = n.originalname
79 0.0001 0.000118970870972
SELECT * FROM productoffers WHERE product_id = '53170' AND merchantid = 'ATVPDKIKX0DER'
80 0.0001 0.000112056732178
SELECT * FROM productoffers
				WHERE product_id = '53170' AND price > 0
				ORDER BY price ASC LIMIT 1
81 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = 53170
				ORDER BY price ASC LIMIT 1
82 0.0001 0.000139951705933
SELECT value FROM productattributes
				WHERE product_id = '53170'
				AND name = 'ListPriceAmount'
83 0.0002 0.00016713142395
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53170'
				GROUP BY o.product_id
84 0.0002 0.000164985656738
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53170'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
85 0.0001 0.000109195709229
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53170
86 0.0001 0.000148057937622
SELECT value FROM productattributes WHERE product_id = '53170' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
87 0.0001 9.91821289062E-5
UPDATE products SET price = '1481' WHERE id = '53170'
88 0.0001 0.000133037567139
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53170'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
89 0.0004 0.000436067581177
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('midwest' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('midwest' IN BOOLEAN MODE) AND 53170 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
90 0.0002 0.000249147415161
SELECT * FROM productimages WHERE product_id = '53170' ORDER BY sortorder ASC
91 0.0003 0.000277996063232
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53170' AND p.id = pi.product_id ORDER BY pi.sortorder
92 0.0002 0.000224828720093
SELECT * FROM product_image_select WHERE product_id = '53170'
93 0.0002 0.000219821929932
SELECT * FROM productcustomimages WHERE product_id = '53170'
94 0.0003 0.000287055969238
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53170'
				GROUP BY o.product_id
95 0.0003 0.00032901763916
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53170'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
96 0.0002 0.000240087509155
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53170
97 0.0005 0.000530004501343
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53170' AND a.name = n.originalname
98 0.0002 0.000196933746338
SELECT * FROM productoffers WHERE product_id = '53170' AND merchantid = 'ATVPDKIKX0DER'
99 0.0002 0.000180006027222
SELECT * FROM productoffers
				WHERE product_id = '53170' AND price > 0
				ORDER BY price ASC LIMIT 1
100 0.0001 0.000127077102661
SELECT * FROM productoffers
				WHERE product_id = 53170
				ORDER BY price ASC LIMIT 1
101 0.0001 0.000138998031616
SELECT value FROM productattributes
				WHERE product_id = '53170'
				AND name = 'ListPriceAmount'
102 0.0002 0.0001540184021
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53170'
				GROUP BY o.product_id
103 0.0002 0.000156164169312
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53170'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
104 0.0001 0.000110149383545
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53170
105 0.0002 0.000174999237061
SELECT value FROM productattributes WHERE product_id = '53170' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
106 0.0001 0.000102996826172
UPDATE products SET price = '1481' WHERE id = '53170'
107 0.0002 0.000173807144165
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53170'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
108 0.0002 0.000189065933228
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('gas can' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('gas can' IN BOOLEAN MODE) AND 53170 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
109 0.0004 0.000355958938599
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('great' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('great' IN BOOLEAN MODE) AND 53170 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
110 0.0001 0.000118017196655
SELECT * FROM productimages WHERE product_id = '53139' ORDER BY sortorder ASC
111 0.0002 0.000178813934326
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53139' AND p.id = pi.product_id ORDER BY pi.sortorder
112 0.0001 0.000125885009766
SELECT * FROM product_image_select WHERE product_id = '53139'
113 0.0001 0.000103950500488
SELECT * FROM productcustomimages WHERE product_id = '53139'
114 0.0002 0.000171899795532
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53139'
				GROUP BY o.product_id
115 0.0002 0.000189065933228
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53139'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
116 0.0001 0.000126838684082
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53139
117 0.0003 0.000329971313477
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53139' AND a.name = n.originalname
118 0.0001 9.17911529541E-5
SELECT * FROM productoffers WHERE product_id = '53139' AND merchantid = 'ATVPDKIKX0DER'
119 0.0001 9.58442687988E-5
SELECT * FROM productoffers
				WHERE product_id = '53139' AND price > 0
				ORDER BY price ASC LIMIT 1
120 0.0001 0.000126123428345
SELECT * FROM productoffers
				WHERE product_id = 53139
				ORDER BY price ASC LIMIT 1
121 0.0001 0.000133037567139
SELECT value FROM productattributes
				WHERE product_id = '53139'
				AND name = 'ListPriceAmount'
122 0.0001 0.000118970870972
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53139'
				GROUP BY o.product_id
123 0.0001 0.000134944915771
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53139'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
124 0.0001 0.000129222869873
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53139
125 0.0001 0.0001380443573
SELECT value FROM productattributes WHERE product_id = '53139' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0001 7.48634338379E-5
UPDATE products SET price = '35378' WHERE id = '53139'
127 0.0002 0.000173807144165
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53139'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Style'
				GROUP BY o.value
				ORDER BY o.value ASC
128 0.0001 9.79900360107E-5
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
129 0.0001 9.51290130615E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
130 0.0001 6.50882720947E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
131 0.0005 0.000542163848877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
132 0.0001 0.000125885009766
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
133 0.0001 0.000104904174805
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
134 0.0002 0.000174999237061
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0001 8.89301300049E-5
UPDATE products SET price = '44900' WHERE id = '53141'
136 0.0001 0.00011420249939
SELECT * FROM productimages WHERE product_id = '53142' ORDER BY sortorder ASC
137 0.0001 0.000117063522339
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53142' AND p.id = pi.product_id ORDER BY pi.sortorder
138 0.0001 6.8187713623E-5
SELECT * FROM product_image_select WHERE product_id = '53142'
139 0.0001 9.20295715332E-5
SELECT * FROM productcustomimages WHERE product_id = '53142'
140 0.0001 0.000138998031616
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53142'
				GROUP BY o.product_id
141 0.0002 0.000164031982422
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53142'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
142 0.0001 0.000149965286255
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53142
143 0.0005 0.000470161437988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53142' AND a.name = n.originalname
144 0.0001 0.0001220703125
SELECT * FROM productoffers WHERE product_id = '53142' AND merchantid = 'ATVPDKIKX0DER'
145 0.0001 9.48905944824E-5
SELECT * FROM productoffers
				WHERE product_id = '53142' AND price > 0
				ORDER BY price ASC LIMIT 1
146 0.0001 0.00012993812561
SELECT * FROM productoffers
				WHERE product_id = 53142
				ORDER BY price ASC LIMIT 1
147 0.0001 0.000132083892822
SELECT value FROM productattributes
				WHERE product_id = '53142'
				AND name = 'ListPriceAmount'
148 0.0001 0.000113964080811
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53142'
				GROUP BY o.product_id
149 0.0001 0.000123977661133
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53142'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
150 0.0001 0.000137090682983
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53142
151 0.0002 0.00018310546875
SELECT value FROM productattributes WHERE product_id = '53142' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0001 9.98973846436E-5
UPDATE products SET price = '49365' WHERE id = '53142'
153 0.0001 0.000118970870972
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53142'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Color'
				GROUP BY o.value
				ORDER BY o.value ASC
154 0.0001 0.000109910964966
SELECT * FROM products WHERE parent_id = '53142'
155 0.0003 0.000339031219482
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53143' AND a.name = n.originalname
156 0.0001 0.000112056732178
SELECT * FROM productoffers WHERE product_id = '53143' AND merchantid = 'ATVPDKIKX0DER'
157 0.0001 0.000132083892822
SELECT * FROM productoffers
				WHERE product_id = '53143' AND price > 0
				ORDER BY price ASC LIMIT 1
158 0.0001 0.000116109848022
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53170
          ORDER BY timestamp DESC
          
159 0.0001 7.60555267334E-5
SELECT category_id FROM products_categories WHERE product_id = '53170'
160 0.0001 9.60826873779E-5
SELECT * FROM categories WHERE id = '69'
161 0.0002 0.000174045562744
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 69
162 0.0001 6.69956207275E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
163 0.0001 9.60826873779E-5
SELECT id FROM categories WHERE parent_id = '69'
164 0.0002 0.000191926956177
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
165 0.0001 8.01086425781E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 AND offers > 0
166 0.0001 8.60691070557E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
167 0.0004 0.000394821166992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53170' AND a.name = n.originalname
168 0.0001 0.000103950500488
SELECT * FROM productoffers WHERE product_id = '53170' AND merchantid = 'ATVPDKIKX0DER'
169 0.0001 0.000147104263306
SELECT * FROM productoffers
				WHERE product_id = '53170' AND price > 0
				ORDER BY price ASC LIMIT 1
170 0.0001 0.000118970870972
SELECT * FROM productoffers
				WHERE product_id = 53170
				ORDER BY price ASC LIMIT 1
171 0.0001 0.000137805938721
SELECT value FROM productattributes
				WHERE product_id = '53170'
				AND name = 'ListPriceAmount'
172 0.0001 0.00012993812561
SELECT * FROM products WHERE id = '53170'
173 0.0001 0.000126838684082
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53170'
				GROUP BY o.product_id
174 0.0002 0.000178098678589
SELECT	n.displayname, o.name
				FROM	productoptionnames	n,
						productoptions		o,
						products			p
				WHERE	n.originalname	= o.name
				  AND	o.product_id	= p.id
				  AND	p.parent_id		= '53170'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
175 0.0001 0.000109910964966
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53170
176 0.0002 0.000173807144165
SELECT value FROM productattributes WHERE product_id = '53170' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0001 7.70092010498E-5
UPDATE products SET price = '1481' WHERE id = '53170'
178 0.0004 0.000421047210693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53170' AND a.name = n.originalname
179 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53170' AND merchantid = 'ATVPDKIKX0DER'
180 0.0001 9.41753387451E-5
SELECT * FROM productoffers
				WHERE product_id = '53170' AND price > 0
				ORDER BY price ASC LIMIT 1
181 0.0001 0.000125885009766
SELECT * FROM productoffers
				WHERE product_id = 53170
				ORDER BY price ASC LIMIT 1
182 0.0001 0.00011420249939
SELECT value FROM productattributes
				WHERE product_id = '53170'
				AND name = 'ListPriceAmount'
183 0.0001 8.20159912109E-5
SELECT DISTINCT (name) FROM productoptions
184 0.0002 0.000207901000977
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 53170))
185 0.0001 0.000125885009766
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 53170
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
186 0.0002 0.000231981277466
SELECT * FROM translationsfilter
187 0.0001 0.000108003616333
SELECT category_id FROM products_categories WHERE product_id = '53170'
188 0.0001 9.58442687988E-5
SELECT parent_id FROM categories WHERE id = '69'
189 0.0001 9.48905944824E-5
SELECT * FROM categories WHERE id = '69'
190 0.0002 0.000184059143066
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 69
191 0.0001 6.69956207275E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
192 0.0001 8.39233398438E-5
SELECT id FROM categories WHERE parent_id = '69'
193 0.0002 0.000155925750732
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (69)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
194 0.0001 7.91549682617E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (69)
				  AND p.disabled = 0 AND offers > 0
195 0.0001 8.41617584229E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
196 0.0001 0.000121831893921
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
197 0.0001 8.70227813721E-5
SELECT * FROM pages WHERE id = 2
198 0.0001 9.41753387451E-5
SELECT * FROM pages WHERE id = 38
199 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = 39
200 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 6
201 0.0001 0.000102996826172
SELECT * FROM pages WHERE id = 7
202 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 32
203 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 2
204 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 28
205 0.0001 7.91549682617E-5
SELECT * FROM pages WHERE id = 13
206 0.0001 7.58171081543E-5
SELECT * FROM pages WHERE id = 24
207 0.0002 0.00018310546875
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
208 0.0001 0.000100135803223
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
209 0.0001 8.20159912109E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
210 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
211 0.0005 0.000530958175659
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
212 0.0001 0.000118017196655
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
213 0.0001 0.00012993812561
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
214 0.0002 0.000175952911377
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0001 7.39097595215E-5
UPDATE products SET price = '44900' WHERE id = '53141'
216 0.0001 0.000117063522339
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
217 0.0001 9.48905944824E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
218 0.0001 8.89301300049E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
219 0.0005 0.000452041625977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
220 0.0001 0.000109910964966
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
221 0.0001 0.000115156173706
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
222 0.0002 0.000150918960571
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0001 9.89437103271E-5
UPDATE products SET price = '1595' WHERE id = '53155'
224 0.0001 0.000128030776978
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
225 0.0001 0.000108003616333
SELECT * FROM product_image_select WHERE product_id = '53159'
226 0.0001 8.89301300049E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
227 0.0005 0.000463008880615
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
228 0.0001 0.0001380443573
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
229 0.0001 0.000131845474243
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
230 0.0002 0.000180006027222
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0001 7.29560852051E-5
UPDATE products SET price = '1146' WHERE id = '53159'
232 0.0001 0.000120162963867
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
233 0.0001 9.48905944824E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
234 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
235 0.0004 0.000356912612915
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
236 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
237 0.0001 0.000127792358398
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
238 0.0002 0.000151872634888
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0001 8.70227813721E-5
UPDATE products SET price = '471' WHERE id = '53160'
240 0.0001 0.000116109848022
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
241 0.0001 6.8187713623E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
242 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
243 0.0006 0.000576019287109
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
244 0.0001 0.000108957290649
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
245 0.0001 0.000114917755127
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
246 0.0002 0.000159978866577
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0001 7.91549682617E-5
UPDATE products SET price = '1465' WHERE id = '53162'
248 0.0001 0.000134944915771
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
249 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
250 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
251 0.0005 0.000476121902466
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
252 0.0001 0.000125169754028
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
253 0.0001 0.000140905380249
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
254 0.0002 0.000159025192261
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0001 0.000100135803223
UPDATE products SET price = '3390' WHERE id = '53167'
256 0.0001 8.79764556885E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
257 0.0001 8.08238983154E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
258 0.0001 0.000102043151855
SELECT * FROM productcustomimages WHERE product_id = '53186'
259 0.0004 0.000427961349487
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
260 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
261 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
262 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
263 0.0001 0.000104904174805
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
264 0.0001 7.20024108887E-5
UPDATE products SET price = '6995' WHERE id = '53186'
265 0.0001 9.41753387451E-5
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
266 0.0001 7.00950622559E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
267 0.0001 9.01222229004E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
268 0.0006 0.000553846359253
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
269 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
270 0.0001 0.000100135803223
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
271 0.0002 0.000187873840332
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0001 7.20024108887E-5
UPDATE products SET price = '1998' WHERE id = '53187'
273 0.0001 8.9168548584E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
274 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
275 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
276 0.0005 0.000458955764771
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
277 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
278 0.0001 0.000140905380249
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
279 0.0002 0.000157117843628
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0001 8.6784362793E-5
UPDATE products SET price = '2884' WHERE id = '53188'
281 0.0001 0.000113010406494
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
282 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
283 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
284 0.0005 0.000538110733032
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
285 0.0001 9.48905944824E-5
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
286 0.0001 0.000107049942017
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
287 0.0001 8.98838043213E-5
SELECT * FROM productoffers
				WHERE product_id = 53196
				ORDER BY price ASC LIMIT 1
288 0.0002 0.000169038772583
SELECT value FROM productattributes
				WHERE product_id = '53196'
				AND name = 'ListPriceAmount'
289 0.0001 0.000117063522339
UPDATE products SET price = '3597' WHERE id = '53196'
290 0.0002 0.000170946121216
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
291 0.0002 0.000159025192261
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
292 0.0004 0.000405073165894
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
293 0.0001 0.000148057937622
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
294 0.0002 0.000176906585693
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
295 0.0004 0.000354051589966
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
296 0.0003 0.000257015228271
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
297 0.0003 0.00034499168396
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'