Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal. from Eagle Mfg

Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal. from Eagle Mfg
Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal. from Eagle Mfg Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal. from Eagle Mfg (click images to enlarge)
$36.63
In Stock Add to Cart
Product prices and availability are accurate as of 2017-07-19 09:15:11 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 Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal. from...

We are delighted to offer the famous Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal..

With so many on offer recently, it is good to have a make you can recognise. The Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal. is certainly that and will be a superb buy.

For this price, the Eagle Mfg UI-50-FS Gasoline Can, Type-I, 5-Gal. is widely respected and is a popular choice for lots of people. Eagle Mfg have added some nice touches and this means good value.

Manufacturer Description

5 Gallon, Type l, Safety Gasoline Can With F-15 Funnel, Heavy Gauge Steel, Sturdy Bottom Rim & Carrying Handle, Patented Comfort Grip Trigger Release, Brass Pour Spout & Flame Arrestor, UL, ULC, & FM Approved.

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.163529157639 353 0.0567 0


No Amazon API Requests Made.

Total time 0.163529157639 seconds

Number Time From Start Name Description
1 0.0584111213684 Initialise Initialise FSB Function
2 0.0596129894257 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0644521713257 Start of getCategoryListByGroup Function Before first category groups query
4 0.0646522045135 After initial query Before first category groups query
5 0.0646541118622 Get Category List for Group Before the call to getCategoryList function
6 0.0646572113037 Start of GetCategoryList function Start of the function
7 0.0646650791168 Before getting categories Query to get specific category list
8 0.0649290084839 After getting categories Query to get specific category list
9 0.0649311542511 Before getting category custom Before call to function getCategoryCustom
10 0.0663511753082 After getting category custom After call to function getCategoryCustom
11 0.0663530826569 Before getting category custom Before call to function getCategoryCustom
12 0.0675160884857 After getting category custom After call to function getCategoryCustom
13 0.0675191879272 Before getting category custom Before call to function getCategoryCustom
14 0.0684731006622 After getting category custom After call to function getCategoryCustom
15 0.0684762001038 Before getting category custom Before call to function getCategoryCustom
16 0.0693171024323 After getting category custom After call to function getCategoryCustom
17 0.0693190097809 End of GetCategoryList function End of the function
18 0.0693280696869 End of getCategoryListByGroup Function Before return()
19 0.0711891651154 App Controller End End of the App controller (called before the controller of every page)
20 0.0724241733551 Product Start Start of the product info controller
21 0.0729241371155 Cache file not found Starting get product details
22 0.0785291194916 Related products Start getting related products if enabled
23 0.0785310268402 Related Products Start Before the related products are found
24 0.0785319805145 Related Products Keywords Before the related product keywords are found
25 0.0785369873047 Create Keyword List Function Start of function
26 0.0790390968323 Create Keyword List Function After looping provided content - 286 keywords found
27 0.093917131424 Create Keyword List Function After looping initial keyword list - 250 keywords remaining
28 0.0939810276031 Create Keyword List Function After reducing keyword list
29 0.0957980155945 Create Keyword List Function After selecting by scoring keywords
30 0.0958030223846 Create Keyword List Function After final loop of keywords
31 0.0958089828491 Related Products Keywords After the related product keywords are found
32 0.117470979691 Related Products End After the related products are found
33 0.122680187225 Product End End of the product info controller (Product Info)
34 0.123425006866 App_after Controller Start Start of the App_after controller (called after the controller of every page)
35 0.123489141464 Before Get Options Before the call to getOptions in the tpl class
36 0.140697002411 After Get Options After the call to getOptions in the tpl class
37 0.140820980072 App_after Controller End End of the App_after controller (called after the controller of every page)
38 0.140824079514 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
39 0.148699998856 Product Info: After Smarty Fetch After the product.tpl template is fetched
40 0.148706197739 Product Info: Before Template Display Before the template is displayed
41 0.163511037827 Product Info: After Template Display After the template is displayed
42 0.163514137268 Finalizing debug Before the debug is output to the page.
43 0.163528203964 End of App This is the end of the app logging, final timestamp


Query Debug - 353 Database Queries. Total time 0.0567 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000412940979004
SELECT parameter, value FROM parameters
2 0.0002 0.000180006027222
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000173091888428
SET time_zone = 'Europe/London'
4 0.0003 0.000317096710205
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000207901000977
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0002 0.000228881835938
SELECT id FROM pages WHERE pagename = 'eagle-mfg-ui-50-fs-gasoline-can-type-i-5-gal' LIMIT 1
7 0.0002 0.000219106674194
SELECT id FROM products WHERE pagename = 'eagle-mfg-ui-50-fs-gasoline-can-type-i-5-gal' AND hidden = 0 LIMIT 1
8 0.0004 0.000418901443481
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
9 0.0035 0.0034658908844
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
10 0.0002 0.000223159790039
SELECT * FROM pages WHERE pagename = 'eagle-mfg-ui-50-fs-gasoline-can-type-i-5-gal'
11 0.0002 0.000180006027222
SELECT * FROM categorygroups ORDER BY sortorder ASC
12 0.0002 0.000234127044678
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
13 0.0003 0.000299215316772
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
14 0.0002 0.000160932540894
SELECT id FROM categories WHERE parent_id = '67'
15 0.0003 0.000278949737549
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
16 0.0002 0.000171899795532
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
17 0.0002 0.000211954116821
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
18 0.0002 0.000156879425049
SELECT * FROM categorygroups WHERE id = '10'
19 0.0002 0.000240087509155
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
20 0.0002 0.000160932540894
SELECT id FROM categories WHERE parent_id = '68'
21 0.0003 0.000255823135376
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
22 0.0001 0.000128984451294
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
23 0.0001 0.000135898590088
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
24 0.0001 0.000119924545288
SELECT * FROM categorygroups WHERE id = '10'
25 0.0002 0.000207901000977
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
26 0.0001 0.000113010406494
SELECT id FROM categories WHERE parent_id = '69'
27 0.0002 0.000201940536499
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
28 0.0001 0.000115156173706
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
29 0.0001 0.000123977661133
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
30 0.0001 0.000110149383545
SELECT * FROM categorygroups WHERE id = '10'
31 0.0002 0.000154972076416
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
32 0.0001 0.000108957290649
SELECT id FROM categories WHERE parent_id = '70'
33 0.0002 0.000166893005371
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
34 0.0001 0.000113010406494
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
35 0.0001 0.000119924545288
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
36 0.0001 0.000109195709229
SELECT * FROM categorygroups WHERE id = '10'
37 0.0002 0.000211000442505
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
38 0.0002 0.000164985656738
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
39 0.0001 0.000114917755127
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
40 0.0001 0.000109195709229
SELECT * FROM pages WHERE id = '37'
41 0.0001 9.51290130615E-5
SELECT * FROM pages WHERE id = '4'
42 0.0001 9.10758972168E-5
SELECT * FROM pages WHERE id = '34'
43 0.0001 9.10758972168E-5
SELECT * FROM pages WHERE id = '3'
44 0.0001 8.98838043213E-5
SELECT * FROM pages WHERE id = '24'
45 0.0001 9.20295715332E-5
SELECT * FROM pages WHERE id = '5'
46 0.0001 9.3936920166E-5
SELECT * FROM pages WHERE id = '38'
47 0.0001 8.79764556885E-5
SELECT * FROM pages WHERE id = '39'
48 0.0002 0.000171899795532
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
49 0.0002 0.000150918960571
SELECT * FROM products WHERE pagename = 'eagle-mfg-ui-50-fs-gasoline-can-type-i-5-gal'
50 0.0001 0.000102996826172
SELECT * FROM manufacturers WHERE id = '640'
51 0.0001 0.000123023986816
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '640'
52 0.0001 8.48770141602E-5
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '640' LIMIT 1
53 0.0001 0.000114917755127
SELECT pagename, id FROM products p WHERE manufacturer_id = '640' ORDER BY RAND() LIMIT 1
54 0.0001 0.000107049942017
SELECT * FROM productimages WHERE product_id = '53176' ORDER BY sortorder ASC
55 0.0001 0.000118970870972
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '640'
56 0.0001 0.000128030776978
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '640'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 AND offers > 0
57 0.0001 8.60691070557E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '640'
58 0.0001 8.51154327393E-5
SELECT category_id FROM products_categories WHERE product_id = '53176'
59 0.0001 0.000105857849121
SELECT * FROM categories WHERE id = '69'
60 0.0002 0.000159978866577
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
61 0.0001 7.41481781006E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
62 0.0001 7.70092010498E-5
SELECT id FROM categories WHERE parent_id = '69'
63 0.0002 0.000170946121216
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
64 0.0001 9.58442687988E-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
65 0.0001 9.51290130615E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
66 0.0001 0.000102043151855
SELECT * FROM productimages WHERE product_id = '53176' ORDER BY sortorder ASC
67 0.0001 0.000123023986816
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53176' AND p.id = pi.product_id ORDER BY pi.sortorder
68 0.0001 7.70092010498E-5
SELECT * FROM product_image_select WHERE product_id = '53176'
69 0.0001 7.08103179932E-5
SELECT * FROM productcustomimages WHERE product_id = '53176'
70 0.0001 7.60555267334E-5
SELECT * FROM productfeeds WHERE product_id = '53176' ORDER BY item_date DESC
71 0.0001 0.000147819519043
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
72 0.0001 0.000138998031616
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '53176' AND t.hidden = 0 AND display_product = 1
73 0.0001 0.000105857849121
SELECT * FROM productamazoncontent WHERE product_id = '53176'
74 0.0001 0.00012993812561
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
75 0.0001 0.000144004821777
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
76 0.0001 0.000110864639282
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
77 0.0005 0.000500917434692
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
78 0.0001 0.0001060962677
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
79 0.0001 0.0001060962677
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
80 0.0001 0.000110864639282
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
81 0.0001 0.000123023986816
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
82 0.0001 0.000125169754028
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
83 0.0001 0.000137090682983
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
84 0.0001 0.000107049942017
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
85 0.0002 0.000167846679688
SELECT value FROM productattributes WHERE product_id = '53176' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
86 0.0001 8.60691070557E-5
UPDATE products SET price = '3663' WHERE id = '53176'
87 0.0001 0.000128984451294
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53176'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'PackageQuantity'
				GROUP BY o.value
				ORDER BY o.value ASC
88 0.0001 0.000114917755127
SELECT * FROM products WHERE parent_id = '53176'
89 0.0001 0.000114917755127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53177' AND a.name = n.originalname
90 0.0001 0.00010085105896
SELECT * FROM productoffers WHERE product_id = '53177' AND merchantid = 'ATVPDKIKX0DER'
91 0.0001 0.000108003616333
SELECT * FROM productoffers
				WHERE product_id = '53177' AND price > 0
				ORDER BY price ASC LIMIT 1
92 0.0003 0.000321865081787
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('eagle mfg' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('eagle mfg' IN BOOLEAN MODE) AND 53176 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
93 0.0002 0.000200986862183
SELECT * FROM productimages WHERE product_id = '53176' ORDER BY sortorder ASC
94 0.0002 0.000196933746338
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53176' AND p.id = pi.product_id ORDER BY pi.sortorder
95 0.0001 0.000146865844727
SELECT * FROM product_image_select WHERE product_id = '53176'
96 0.0001 0.000142097473145
SELECT * FROM productcustomimages WHERE product_id = '53176'
97 0.0002 0.000239133834839
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
98 0.0002 0.00019907951355
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
99 0.0002 0.00016713142395
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
100 0.0005 0.000524044036865
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
101 0.0002 0.00018310546875
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
102 0.0002 0.000161170959473
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
103 0.0002 0.000156879425049
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
104 0.0002 0.000168085098267
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
105 0.0002 0.000202894210815
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
106 0.0002 0.000216960906982
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
107 0.0002 0.000188112258911
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
108 0.0002 0.000211954116821
SELECT value FROM productattributes WHERE product_id = '53176' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109 0.0001 0.000120878219604
UPDATE products SET price = '3663' WHERE id = '53176'
110 0.0002 0.000164031982422
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53176'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'PackageQuantity'
				GROUP BY o.value
				ORDER BY o.value ASC
111 0.0002 0.000152111053467
SELECT * FROM products WHERE parent_id = '53176'
112 0.0001 0.000149011611938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53177' AND a.name = n.originalname
113 0.0001 0.0001380443573
SELECT * FROM productoffers WHERE product_id = '53177' AND merchantid = 'ATVPDKIKX0DER'
114 0.0001 0.000149011611938
SELECT * FROM productoffers
				WHERE product_id = '53177' AND price > 0
				ORDER BY price ASC LIMIT 1
115 0.0003 0.000263929367065
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('gasoline can type-i' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('gasoline can type-i' IN BOOLEAN MODE) AND 53176 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
116 0.0001 0.000133991241455
SELECT * FROM productimages WHERE product_id = '53163' ORDER BY sortorder ASC
117 0.0001 0.000114917755127
SELECT * FROM product_image_select WHERE product_id = '53163'
118 0.0001 0.000104188919067
SELECT * FROM productcustomimages WHERE product_id = '53163'
119 0.0004 0.000372886657715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53163' AND a.name = n.originalname
120 0.0001 0.000138998031616
SELECT * FROM productoffers WHERE product_id = '53163' AND merchantid = 'ATVPDKIKX0DER'
121 0.0001 0.000144004821777
SELECT * FROM productoffers
				WHERE product_id = '53163' AND price > 0
				ORDER BY price ASC LIMIT 1
122 0.0002 0.000179052352905
SELECT value FROM productattributes WHERE product_id = '53163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0001 0.000117063522339
UPDATE products SET price = '648' WHERE id = '53163'
124 0.0001 0.00013279914856
SELECT * FROM productimages WHERE product_id = '53164' ORDER BY sortorder ASC
125 0.0001 0.000108957290649
SELECT * FROM product_image_select WHERE product_id = '53164'
126 0.0001 0.000104904174805
SELECT * FROM productcustomimages WHERE product_id = '53164'
127 0.0005 0.000473022460938
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53164' AND a.name = n.originalname
128 0.0001 0.000135898590088
SELECT * FROM productoffers WHERE product_id = '53164' AND merchantid = 'ATVPDKIKX0DER'
129 0.0002 0.00015115737915
SELECT * FROM productoffers
				WHERE product_id = '53164' AND price > 0
				ORDER BY price ASC LIMIT 1
130 0.0002 0.00019097328186
SELECT value FROM productattributes WHERE product_id = '53164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0001 0.000115871429443
UPDATE products SET price = '849' WHERE id = '53164'
132 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53176' ORDER BY sortorder ASC
133 0.0001 0.000117778778076
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53176' AND p.id = pi.product_id ORDER BY pi.sortorder
134 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53176'
135 0.0001 6.50882720947E-5
SELECT * FROM productcustomimages WHERE product_id = '53176'
136 0.0001 0.000114917755127
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
137 0.0001 0.000133991241455
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
138 0.0001 9.98973846436E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
139 0.0004 0.000447988510132
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
140 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
141 0.0001 9.60826873779E-5
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
142 0.0001 9.01222229004E-5
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
143 0.0001 0.000136137008667
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
144 0.0001 0.000128984451294
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
145 0.0001 0.000142097473145
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
146 0.0001 0.000100135803223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
147 0.0002 0.000180006027222
SELECT value FROM productattributes WHERE product_id = '53176' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148 0.0001 7.60555267334E-5
UPDATE products SET price = '3663' WHERE id = '53176'
149 0.0001 0.000146865844727
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53176'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'PackageQuantity'
				GROUP BY o.value
				ORDER BY o.value ASC
150 0.0001 0.000117063522339
SELECT * FROM products WHERE parent_id = '53176'
151 0.0001 0.000108003616333
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53177' AND a.name = n.originalname
152 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53177' AND merchantid = 'ATVPDKIKX0DER'
153 0.0001 0.000115871429443
SELECT * FROM productoffers
				WHERE product_id = '53177' AND price > 0
				ORDER BY price ASC LIMIT 1
154 0.0002 0.000195980072021
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('mfg ui-50-fs gasoline' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('mfg ui-50-fs gasoline' IN BOOLEAN MODE) AND 53176 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
155 0.0001 0.000118017196655
SELECT * FROM productimages WHERE product_id = '53163' ORDER BY sortorder ASC
156 0.0001 7.00950622559E-5
SELECT * FROM product_image_select WHERE product_id = '53163'
157 0.0001 7.89165496826E-5
SELECT * FROM productcustomimages WHERE product_id = '53163'
158 0.0004 0.000372886657715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53163' AND a.name = n.originalname
159 0.0001 0.000108957290649
SELECT * FROM productoffers WHERE product_id = '53163' AND merchantid = 'ATVPDKIKX0DER'
160 0.0001 0.000128030776978
SELECT * FROM productoffers
				WHERE product_id = '53163' AND price > 0
				ORDER BY price ASC LIMIT 1
161 0.0001 0.000138998031616
SELECT value FROM productattributes WHERE product_id = '53163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162 0.0001 0.000102043151855
UPDATE products SET price = '648' WHERE id = '53163'
163 0.0002 0.000177145004272
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('type-i 5-gal' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('type-i 5-gal' IN BOOLEAN MODE) AND 53176 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
164 0.0001 0.000111103057861
SELECT * FROM productimages WHERE product_id = '53176' ORDER BY sortorder ASC
165 0.0002 0.000170946121216
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53176' AND p.id = pi.product_id ORDER BY pi.sortorder
166 0.0001 0.000102043151855
SELECT * FROM product_image_select WHERE product_id = '53176'
167 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53176'
168 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	= '53176'
				GROUP BY o.product_id
169 0.0002 0.0001540184021
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
170 0.0001 0.000121116638184
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
171 0.0005 0.000458002090454
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
172 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
173 0.0001 9.51290130615E-5
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
174 0.0001 0.000126838684082
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
175 0.0001 0.000146865844727
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
176 0.0001 0.000141143798828
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
177 0.0002 0.000154972076416
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
178 0.0001 9.98973846436E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
179 0.0002 0.000155925750732
SELECT value FROM productattributes WHERE product_id = '53176' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180 0.0001 7.48634338379E-5
UPDATE products SET price = '3663' WHERE id = '53176'
181 0.0001 0.000133991241455
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53176'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'PackageQuantity'
				GROUP BY o.value
				ORDER BY o.value ASC
182 0.0001 0.000139951705933
SELECT * FROM products WHERE parent_id = '53176'
183 0.0001 0.0001220703125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53177' AND a.name = n.originalname
184 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53177' AND merchantid = 'ATVPDKIKX0DER'
185 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53177' AND price > 0
				ORDER BY price ASC LIMIT 1
186 0.0002 0.000189065933228
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('5-gal from eagle' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('5-gal from eagle' IN BOOLEAN MODE) AND 53176 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
187 0.0001 9.51290130615E-5
SELECT * FROM productimages WHERE product_id = '53176' ORDER BY sortorder ASC
188 0.0001 0.000113010406494
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53176' AND p.id = pi.product_id ORDER BY pi.sortorder
189 0.0001 8.39233398438E-5
SELECT * FROM product_image_select WHERE product_id = '53176'
190 0.0001 0.000111103057861
SELECT * FROM productcustomimages WHERE product_id = '53176'
191 0.0001 0.000126123428345
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
192 0.0001 0.000140905380249
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
193 0.0001 9.98973846436E-5
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
194 0.0005 0.000484943389893
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
195 0.0001 9.58442687988E-5
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
196 0.0001 9.58442687988E-5
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
197 0.0001 0.000130891799927
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
198 0.0001 0.000116109848022
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
199 0.0001 0.000142097473145
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
200 0.0001 0.000128030776978
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
201 0.0001 0.000100135803223
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
202 0.0002 0.000157117843628
SELECT value FROM productattributes WHERE product_id = '53176' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0001 7.70092010498E-5
UPDATE products SET price = '3663' WHERE id = '53176'
204 0.0002 0.000160932540894
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53176'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'PackageQuantity'
				GROUP BY o.value
				ORDER BY o.value ASC
205 0.0001 0.000113010406494
SELECT * FROM products WHERE parent_id = '53176'
206 0.0001 0.000108003616333
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53177' AND a.name = n.originalname
207 0.0001 9.41753387451E-5
SELECT * FROM productoffers WHERE product_id = '53177' AND merchantid = 'ATVPDKIKX0DER'
208 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53177' AND price > 0
				ORDER BY price ASC LIMIT 1
209 0.0001 0.00014591217041
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '53176') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
210 0.0005 0.000504970550537
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '69' AND offers > 0 AND p.id <> '53176' ORDER BY RAND()
211 0.0001 0.000105142593384
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
212 0.0001 7.20024108887E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
213 0.0001 8.08238983154E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
214 0.0005 0.000471830368042
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
215 0.0001 9.89437103271E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
216 0.0001 0.000104904174805
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
217 0.0001 0.000133991241455
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0001 7.48634338379E-5
UPDATE products SET price = '3395' WHERE id = '53167'
219 0.0001 0.0001060962677
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53176
          ORDER BY timestamp DESC
          
220 0.0001 0.000103950500488
SELECT category_id FROM products_categories WHERE product_id = '53176'
221 0.0001 8.32080841064E-5
SELECT * FROM categories WHERE id = '69'
222 0.0001 0.000149965286255
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
223 0.0001 6.89029693604E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
224 0.0001 9.70363616943E-5
SELECT id FROM categories WHERE parent_id = '69'
225 0.0002 0.000159025192261
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
226 0.0001 9.41753387451E-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
227 0.0001 0.000125885009766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
228 0.0005 0.000450849533081
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
229 0.0001 0.000118970870972
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
230 0.0001 9.48905944824E-5
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
231 0.0001 0.000127792358398
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
232 0.0001 0.000115871429443
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
233 0.0001 0.000149011611938
SELECT * FROM products WHERE id = '53176'
234 0.0001 0.00012993812561
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53176'
				GROUP BY o.product_id
235 0.0002 0.000170946121216
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		= '53176'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
236 0.0001 0.000115156173706
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53176
237 0.0002 0.000154972076416
SELECT value FROM productattributes WHERE product_id = '53176' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0001 8.89301300049E-5
UPDATE products SET price = '3663' WHERE id = '53176'
239 0.0005 0.000473976135254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53176' AND a.name = n.originalname
240 0.0001 0.000105857849121
SELECT * FROM productoffers WHERE product_id = '53176' AND merchantid = 'ATVPDKIKX0DER'
241 0.0001 0.000135183334351
SELECT * FROM productoffers
				WHERE product_id = '53176' AND price > 0
				ORDER BY price ASC LIMIT 1
242 0.0002 0.000154972076416
SELECT * FROM productoffers
				WHERE product_id = 53176
				ORDER BY price ASC LIMIT 1
243 0.0001 0.000141859054565
SELECT value FROM productattributes
				WHERE product_id = '53176'
				AND name = 'ListPriceAmount'
244 0.0001 0.000102996826172
SELECT category_id FROM products_categories WHERE product_id = '53176'
245 0.0001 0.000124931335449
SELECT parent_id FROM categories WHERE id = '69'
246 0.0001 0.000119209289551
SELECT * FROM categories WHERE id = '69'
247 0.0002 0.000159025192261
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
248 0.0001 9.29832458496E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 69
249 0.0001 7.00950622559E-5
SELECT id FROM categories WHERE parent_id = '69'
250 0.0002 0.00018310546875
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
251 0.0001 8.08238983154E-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
252 0.0001 0.000115871429443
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
253 0.0001 9.91821289062E-5
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
254 0.0001 9.29832458496E-5
SELECT * FROM pages WHERE id = 2
255 0.0001 8.29696655273E-5
SELECT * FROM pages WHERE id = 38
256 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = 39
257 0.0001 0.000104904174805
SELECT * FROM pages WHERE id = 6
258 0.0001 0.000103950500488
SELECT * FROM pages WHERE id = 7
259 0.0001 0.000102043151855
SELECT * FROM pages WHERE id = 32
260 0.0001 9.10758972168E-5
SELECT * FROM pages WHERE id = 2
261 0.0001 7.82012939453E-5
SELECT * FROM pages WHERE id = 28
262 0.0001 0.000121831893921
SELECT * FROM pages WHERE id = 13
263 0.0001 8.10623168945E-5
SELECT * FROM pages WHERE id = 24
264 0.0002 0.000185012817383
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
265 0.0001 0.000111103057861
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
266 0.0001 0.000121831893921
SELECT * FROM product_image_select WHERE product_id = '53141'
267 0.0001 9.20295715332E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
268 0.0005 0.000518083572388
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
269 0.0001 0.000125885009766
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
270 0.0001 0.000142812728882
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
271 0.0002 0.000214815139771
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272 0.0001 9.58442687988E-5
UPDATE products SET price = '44900' WHERE id = '53141'
273 0.0001 9.3936920166E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
274 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
275 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
276 0.0004 0.000437021255493
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
277 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
278 0.0001 0.000111103057861
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
279 0.0002 0.000168085098267
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280 0.0001 7.5101852417E-5
UPDATE products SET price = '1595' WHERE id = '53155'
281 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
282 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
283 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
284 0.0005 0.000468015670776
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
285 0.0001 9.58442687988E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
286 0.0001 0.000142097473145
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
287 0.0002 0.000180006027222
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288 0.0001 7.41481781006E-5
UPDATE products SET price = '998' WHERE id = '53159'
289 0.0001 0.000120162963867
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
290 0.0001 9.58442687988E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
291 0.0001 8.98838043213E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
292 0.0004 0.000351905822754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
293 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
294 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
295 0.0001 0.000139951705933
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296 0.0001 7.41481781006E-5
UPDATE products SET price = '471' WHERE id = '53160'
297 0.0001 9.10758972168E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
298 0.0001 8.60691070557E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
299 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
300 0.0005 0.000545978546143
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
301 0.0001 9.58442687988E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
302 0.0001 0.000108003616333
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
303 0.0002 0.00016188621521
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304 0.0001 0.000100135803223
UPDATE products SET price = '1510' WHERE id = '53162'
305 0.0001 0.000107049942017
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
306 0.0001 8.29696655273E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
307 0.0001 6.31809234619E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
308 0.0004 0.000440120697021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
309 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
310 0.0001 0.000128030776978
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
311 0.0001 0.000146865844727
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312 0.0001 8.9168548584E-5
UPDATE products SET price = '3395' WHERE id = '53167'
313 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
314 0.0001 9.51290130615E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
315 0.0001 8.98838043213E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
316 0.0005 0.000453948974609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
317 0.0001 0.000104904174805
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
318 0.0001 9.60826873779E-5
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
319 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
320 0.0001 0.000131130218506
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
321 0.0001 9.3936920166E-5
UPDATE products SET price = '6995' WHERE id = '53186'
322 0.0001 0.000108003616333
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
323 0.0001 6.98566436768E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
324 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
325 0.0005 0.000539064407349
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
326 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
327 0.0001 0.000103950500488
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
328 0.0002 0.000183820724487
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329 0.0001 7.70092010498E-5
UPDATE products SET price = '1998' WHERE id = '53187'
330 0.0001 0.000117063522339
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
331 0.0001 9.70363616943E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
332 0.0001 8.89301300049E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
333 0.0004 0.000445127487183
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
334 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
335 0.0001 0.000103950500488
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
336 0.0001 0.000146865844727
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337 0.0001 7.39097595215E-5
UPDATE products SET price = '2854' WHERE id = '53188'
338 0.0001 0.00012993812561
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
339 0.0001 0.0001060962677
SELECT * FROM product_image_select WHERE product_id = '53196'
340 0.0001 9.3936920166E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
341 0.0005 0.000457048416138
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
342 0.0001 0.000106811523438
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
343 0.0001 0.000128984451294
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
344 0.0002 0.000211000442505
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345 0.0001 8.70227813721E-5
UPDATE products SET price = '3597' WHERE id = '53196'
346 0.0002 0.000198125839233
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
347 0.0002 0.00016188621521
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
348 0.0004 0.000426054000854
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
349 0.0001 0.000149965286255
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
350 0.0001 0.000144004821777
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
351 0.0004 0.000380992889404
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
352 0.0003 0.000292062759399
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
353 0.0003 0.000302076339722
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'