Notice: Undefined index: id in /home/demofres/public_html/evolution/library/Class.OpenGraph.php on line 35

Royal Purple HP 2-C High Performance Synthetic 2-Cycle Oil from Royal Purple

from $13.23

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

Product prices and availability are accurate as of 2017-07-20 05:45:52 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 Royal Purple HP 2-C High Performance Synthetic 2-Cycle...

Portable Generator Shop are proud to offer the excellent Royal Purple HP 2-C High Performance Synthetic 2-Cycle Oil.

With so many on offer these days, it is good to have a brand you can trust. The Royal Purple HP 2-C High Performance Synthetic 2-Cycle Oil is certainly that and will be a superb buy.

For this great price, the Royal Purple HP 2-C High Performance Synthetic 2-Cycle Oil is highly recommended and is always a popular choice amongst lots of people. Royal Purple have included some excellent touches and this equals good value for money.

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.135316848755 270 0.0410 0


No Amazon API Requests Made.

Total time 0.135316848755 seconds

Number Time From Start Name Description
1 0.0532469749451 Initialise Initialise FSB Function
2 0.0542638301849 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0584900379181 Start of getCategoryListByGroup Function Before first category groups query
4 0.0586688518524 After initial query Before first category groups query
5 0.0586709976196 Get Category List for Group Before the call to getCategoryList function
6 0.0586738586426 Start of GetCategoryList function Start of the function
7 0.0586810112 Before getting categories Query to get specific category list
8 0.0589170455933 After getting categories Query to get specific category list
9 0.0589189529419 Before getting category custom Before call to function getCategoryCustom
10 0.0601689815521 After getting category custom After call to function getCategoryCustom
11 0.0601718425751 Before getting category custom Before call to function getCategoryCustom
12 0.0612020492554 After getting category custom After call to function getCategoryCustom
13 0.0612049102783 Before getting category custom Before call to function getCategoryCustom
14 0.0620548725128 After getting category custom After call to function getCategoryCustom
15 0.06205701828 Before getting category custom Before call to function getCategoryCustom
16 0.0627799034119 After getting category custom After call to function getCategoryCustom
17 0.0627820491791 End of GetCategoryList function End of the function
18 0.0627908706665 End of getCategoryListByGroup Function Before return()
19 0.0644090175629 App Controller End End of the App controller (called before the controller of every page)
20 0.0655269622803 Product Start Start of the product info controller
21 0.0659918785095 Cache file not found Starting get product details
22 0.070652961731 Related products Start getting related products if enabled
23 0.0706539154053 Related Products Start Before the related products are found
24 0.0706548690796 Related Products Keywords Before the related product keywords are found
25 0.0706598758698 Create Keyword List Function Start of function
26 0.0710878372192 Create Keyword List Function After looping provided content - 217 keywords found
27 0.0817308425903 Create Keyword List Function After looping initial keyword list - 188 keywords remaining
28 0.081778049469 Create Keyword List Function After reducing keyword list
29 0.0832068920135 Create Keyword List Function After selecting by scoring keywords
30 0.0832118988037 Create Keyword List Function After final loop of keywords
31 0.0832200050354 Related Products Keywords After the related product keywords are found
32 0.0914130210876 Related Products End After the related products are found
33 0.0962119102478 Product End End of the product info controller (Product Info)
34 0.0969359874725 App_after Controller Start Start of the App_after controller (called after the controller of every page)
35 0.0970089435577 Before Get Options Before the call to getOptions in the tpl class
36 0.113368034363 After Get Options After the call to getOptions in the tpl class
37 0.113492012024 App_after Controller End End of the App_after controller (called after the controller of every page)
38 0.113493919373 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
39 0.120293855667 Product Info: After Smarty Fetch After the product.tpl template is fetched
40 0.120298862457 Product Info: Before Template Display Before the template is displayed
41 0.135298013687 Product Info: After Template Display After the template is displayed
42 0.13530087471 Finalizing debug Before the debug is output to the page.
43 0.135315895081 End of App This is the end of the app logging, final timestamp


Query Debug - 270 Database Queries. Total time 0.0410 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000363826751709
SELECT parameter, value FROM parameters
2 0.0002 0.000180959701538
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000165939331055
SET time_zone = 'Europe/London'
4 0.0003 0.000284910202026
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000175952911377
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0002 0.000163078308105
SELECT id FROM pages WHERE pagename = 'royal-purple-hp-2-c-high-performance-synthetic-2-cycle-oil' LIMIT 1
7 0.0002 0.000209093093872
SELECT id FROM products WHERE pagename = 'royal-purple-hp-2-c-high-performance-synthetic-2-cycle-oil' AND hidden = 0 LIMIT 1
8 0.0004 0.000355005264282
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
9 0.0030 0.00301313400269
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
10 0.0002 0.000196933746338
SELECT * FROM pages WHERE pagename = 'royal-purple-hp-2-c-high-performance-synthetic-2-cycle-oil'
11 0.0002 0.00016188621521
SELECT * FROM categorygroups ORDER BY sortorder ASC
12 0.0002 0.000211000442505
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.000269174575806
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.0001 0.000138998031616
SELECT id FROM categories WHERE parent_id = '67'
15 0.0002 0.000236988067627
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.000153064727783
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.000185012817383
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
18 0.0001 0.000144004821777
SELECT * FROM categorygroups WHERE id = '10'
19 0.0002 0.000220060348511
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.0001 0.000144958496094
SELECT id FROM categories WHERE parent_id = '68'
21 0.0002 0.000195026397705
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.000120878219604
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.000125885009766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
24 0.0001 0.000113010406494
SELECT * FROM categorygroups WHERE id = '10'
25 0.0002 0.000174999237061
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.000101089477539
SELECT id FROM categories WHERE parent_id = '69'
27 0.0002 0.000185966491699
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.000106811523438
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.000112056732178
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
30 0.0001 0.000103950500488
SELECT * FROM categorygroups WHERE id = '10'
31 0.0001 0.000140190124512
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.000102043151855
SELECT id FROM categories WHERE parent_id = '70'
33 0.0002 0.0001540184021
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.000107049942017
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 8.70227813721E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
36 0.0001 7.70092010498E-5
SELECT * FROM categorygroups WHERE id = '10'
37 0.0002 0.000170946121216
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
38 0.0001 0.000128030776978
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
39 0.0001 8.29696655273E-5
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
40 0.0001 0.000102043151855
SELECT * FROM pages WHERE id = '37'
41 0.0001 8.39233398438E-5
SELECT * FROM pages WHERE id = '4'
42 0.0001 8.08238983154E-5
SELECT * FROM pages WHERE id = '34'
43 0.0001 7.9870223999E-5
SELECT * FROM pages WHERE id = '3'
44 0.0001 9.3936920166E-5
SELECT * FROM pages WHERE id = '24'
45 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = '5'
46 0.0001 8.08238983154E-5
SELECT * FROM pages WHERE id = '38'
47 0.0001 8.29696655273E-5
SELECT * FROM pages WHERE id = '39'
48 0.0002 0.000154972076416
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
49 0.0001 0.000139951705933
SELECT * FROM products WHERE pagename = 'royal-purple-hp-2-c-high-performance-synthetic-2-cycle-oil'
50 0.0001 9.67979431152E-5
SELECT * FROM manufacturers WHERE id = '631'
51 0.0001 0.000110864639282
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '631'
52 0.0001 7.79628753662E-5
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '631' LIMIT 1
53 0.0001 0.000105142593384
SELECT pagename, id FROM products p WHERE manufacturer_id = '631' ORDER BY RAND() LIMIT 1
54 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53149' ORDER BY sortorder ASC
55 0.0001 0.000102043151855
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '631'
56 0.0001 0.000113010406494
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '631'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 AND offers > 0
57 0.0001 7.79628753662E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '631'
58 0.0001 7.79628753662E-5
SELECT category_id FROM products_categories WHERE product_id = '53149'
59 0.0001 9.10758972168E-5
SELECT * FROM categories WHERE id = '68'
60 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 = 68
61 0.0001 7.10487365723E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
62 0.0001 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '68'
63 0.0002 0.000153064727783
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
64 0.0001 8.39233398438E-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
65 0.0001 8.89301300049E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
66 0.0001 9.79900360107E-5
SELECT * FROM productimages WHERE product_id = '53149' ORDER BY sortorder ASC
67 0.0001 0.000116109848022
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53149' AND p.id = pi.product_id ORDER BY pi.sortorder
68 0.0001 7.08103179932E-5
SELECT * FROM product_image_select WHERE product_id = '53149'
69 0.0001 7.20024108887E-5
SELECT * FROM productcustomimages WHERE product_id = '53149'
70 0.0001 6.89029693604E-5
SELECT * FROM productfeeds WHERE product_id = '53149' ORDER BY item_date DESC
71 0.0001 0.000135898590088
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '53149' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
72 0.0001 0.0001220703125
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '53149' AND t.hidden = 0 AND display_product = 1
73 0.0001 9.51290130615E-5
SELECT * FROM productamazoncontent WHERE product_id = '53149'
74 0.0001 0.000133037567139
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53149'
				GROUP BY o.product_id
75 0.0002 0.000159978866577
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		= '53149'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
76 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 = 53149
77 0.0004 0.000358104705811
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53149' AND a.name = n.originalname
78 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53149' AND merchantid = 'ATVPDKIKX0DER'
79 0.0001 9.79900360107E-5
SELECT * FROM productoffers
				WHERE product_id = '53149' AND price > 0
				ORDER BY price ASC LIMIT 1
80 0.0001 8.79764556885E-5
SELECT * FROM productoffers
				WHERE product_id = 53149
				ORDER BY price ASC LIMIT 1
81 0.0001 0.000113010406494
SELECT value FROM productattributes
				WHERE product_id = '53149'
				AND name = 'ListPriceAmount'
82 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	= '53149'
				GROUP BY o.product_id
83 0.0002 0.000156879425049
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		= '53149'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
84 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 = 53149
85 0.0001 0.00014591217041
SELECT value FROM productattributes WHERE product_id = '53149' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
86 0.0001 7.79628753662E-5
UPDATE products SET price = '1323' WHERE id = '53149'
87 0.0001 0.000133991241455
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53149'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
88 0.0003 0.000303983688354
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('royal purple' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('royal purple' IN BOOLEAN MODE) AND 53149 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
89 0.0002 0.000174045562744
SELECT * FROM productimages WHERE product_id = '53149' ORDER BY sortorder ASC
90 0.0002 0.000184059143066
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53149' AND p.id = pi.product_id ORDER BY pi.sortorder
91 0.0002 0.000150918960571
SELECT * FROM product_image_select WHERE product_id = '53149'
92 0.0002 0.000154972076416
SELECT * FROM productcustomimages WHERE product_id = '53149'
93 0.0002 0.000227928161621
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53149'
				GROUP BY o.product_id
94 0.0002 0.000222206115723
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		= '53149'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
95 0.0002 0.000174999237061
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53149
96 0.0004 0.000417947769165
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53149' AND a.name = n.originalname
97 0.0002 0.000179052352905
SELECT * FROM productoffers WHERE product_id = '53149' AND merchantid = 'ATVPDKIKX0DER'
98 0.0001 0.000138998031616
SELECT * FROM productoffers
				WHERE product_id = '53149' AND price > 0
				ORDER BY price ASC LIMIT 1
99 0.0001 0.00012993812561
SELECT * FROM productoffers
				WHERE product_id = 53149
				ORDER BY price ASC LIMIT 1
100 0.0002 0.000156164169312
SELECT value FROM productattributes
				WHERE product_id = '53149'
				AND name = 'ListPriceAmount'
101 0.0002 0.000195026397705
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53149'
				GROUP BY o.product_id
102 0.0002 0.000216007232666
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		= '53149'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
103 0.0001 0.000147104263306
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53149
104 0.0002 0.000169992446899
SELECT value FROM productattributes WHERE product_id = '53149' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
105 0.0001 0.00010085105896
UPDATE products SET price = '1323' WHERE id = '53149'
106 0.0002 0.000163078308105
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53149'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
107 0.0003 0.000271081924438
SELECT *, MATCH (description, keyfeatures, title) AGAINST ('performance synthetic 2-cycle' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, keyfeatures, title) AGAINST ('performance synthetic 2-cycle' IN BOOLEAN MODE) AND 53149 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
108 0.0001 0.000123023986816
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
109 0.0001 9.51290130615E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
110 0.0001 8.98838043213E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
111 0.0005 0.00046706199646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
112 0.0001 0.000121831893921
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
113 0.0001 0.000126838684082
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
114 0.0002 0.000176906585693
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0001 0.000102996826172
UPDATE products SET price = '1595' WHERE id = '53155'
116 0.0001 0.000113964080811
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
117 0.0001 9.29832458496E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
118 0.0001 8.89301300049E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
119 0.0005 0.000452041625977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
120 0.0001 0.000121116638184
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
121 0.0001 0.000125885009766
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
122 0.0002 0.000165939331055
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0001 7.41481781006E-5
UPDATE products SET price = '998' WHERE id = '53159'
124 0.0001 9.32216644287E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
125 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
126 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
127 0.0003 0.000331163406372
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
128 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
129 0.0001 0.000134944915771
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
130 0.0001 0.000135898590088
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0001 7.20024108887E-5
UPDATE products SET price = '471' WHERE id = '53160'
132 0.0001 8.89301300049E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53149
          ORDER BY timestamp DESC
          
133 0.0001 7.60555267334E-5
SELECT category_id FROM products_categories WHERE product_id = '53149'
134 0.0001 8.10623168945E-5
SELECT * FROM categories WHERE id = '68'
135 0.0001 0.000138998031616
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
136 0.0001 6.69956207275E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
137 0.0001 6.89029693604E-5
SELECT id FROM categories WHERE parent_id = '68'
138 0.0001 0.000149011611938
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
139 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 (68)
				  AND p.disabled = 0 AND offers > 0
140 0.0001 8.51154327393E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
141 0.0003 0.000344038009644
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53149' AND a.name = n.originalname
142 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53149' AND merchantid = 'ATVPDKIKX0DER'
143 0.0001 9.20295715332E-5
SELECT * FROM productoffers
				WHERE product_id = '53149' AND price > 0
				ORDER BY price ASC LIMIT 1
144 0.0001 8.58306884766E-5
SELECT * FROM productoffers
				WHERE product_id = 53149
				ORDER BY price ASC LIMIT 1
145 0.0001 0.000111103057861
SELECT value FROM productattributes
				WHERE product_id = '53149'
				AND name = 'ListPriceAmount'
146 0.0001 0.000103950500488
SELECT * FROM products WHERE id = '53149'
147 0.0001 0.000127077102661
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53149'
				GROUP BY o.product_id
148 0.0001 0.000149965286255
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		= '53149'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
149 0.0001 0.000108003616333
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53149
150 0.0001 0.000138998031616
SELECT value FROM productattributes WHERE product_id = '53149' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0001 7.31945037842E-5
UPDATE products SET price = '1323' WHERE id = '53149'
152 0.0004 0.000407934188843
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53149' AND a.name = n.originalname
153 0.0001 8.98838043213E-5
SELECT * FROM productoffers WHERE product_id = '53149' AND merchantid = 'ATVPDKIKX0DER'
154 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53149' AND price > 0
				ORDER BY price ASC LIMIT 1
155 0.0001 8.51154327393E-5
SELECT * FROM productoffers
				WHERE product_id = 53149
				ORDER BY price ASC LIMIT 1
156 0.0001 0.000107049942017
SELECT value FROM productattributes
				WHERE product_id = '53149'
				AND name = 'ListPriceAmount'
157 0.0001 8.10623168945E-5
SELECT DISTINCT (name) FROM productoptions
158 0.0002 0.000201940536499
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 53149))
159 0.0001 0.000127077102661
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 53149
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
160 0.0001 8.98838043213E-5
SELECT * FROM translationsfilter
161 0.0001 7.79628753662E-5
SELECT category_id FROM products_categories WHERE product_id = '53149'
162 0.0001 6.89029693604E-5
SELECT parent_id FROM categories WHERE id = '68'
163 0.0001 8.10623168945E-5
SELECT * FROM categories WHERE id = '68'
164 0.0001 0.000133991241455
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
165 0.0001 7.89165496826E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
166 0.0001 6.8187713623E-5
SELECT id FROM categories WHERE parent_id = '68'
167 0.0002 0.000160932540894
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
168 0.0001 8.20159912109E-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
169 0.0001 8.29696655273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
170 0.0001 0.000133037567139
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
171 0.0001 8.70227813721E-5
SELECT * FROM pages WHERE id = 2
172 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = 38
173 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = 39
174 0.0001 7.58171081543E-5
SELECT * FROM pages WHERE id = 6
175 0.0001 0.000102043151855
SELECT * FROM pages WHERE id = 7
176 0.0001 9.01222229004E-5
SELECT * FROM pages WHERE id = 32
177 0.0001 8.08238983154E-5
SELECT * FROM pages WHERE id = 2
178 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 28
179 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = 13
180 0.0001 0.000121831893921
SELECT * FROM pages WHERE id = 24
181 0.0002 0.000180006027222
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
182 0.0001 0.000123977661133
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
183 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
184 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
185 0.0005 0.00049901008606
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
186 0.0001 0.000108957290649
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
187 0.0001 0.000100135803223
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
188 0.0002 0.000156164169312
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189 0.0001 7.41481781006E-5
UPDATE products SET price = '44900' WHERE id = '53141'
190 0.0001 0.000117063522339
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
191 0.0001 8.20159912109E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
192 0.0001 7.5101852417E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
193 0.0004 0.000431776046753
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
194 0.0001 0.000107049942017
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
195 0.0001 0.000113964080811
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
196 0.0002 0.000208139419556
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0001 7.5101852417E-5
UPDATE products SET price = '1595' WHERE id = '53155'
198 0.0001 8.60691070557E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
199 0.0001 6.8187713623E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
200 0.0001 7.58171081543E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
201 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
202 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
203 0.0001 9.79900360107E-5
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
204 0.0002 0.000161170959473
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0001 7.29560852051E-5
UPDATE products SET price = '998' WHERE id = '53159'
206 0.0001 0.000105857849121
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
207 0.0001 8.20159912109E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
208 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
209 0.0003 0.00033712387085
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
210 0.0001 0.000109910964966
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
211 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
212 0.0001 0.000135183334351
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0001 7.20024108887E-5
UPDATE products SET price = '471' WHERE id = '53160'
214 0.0001 8.79764556885E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
215 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
216 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
217 0.0006 0.000571966171265
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
218 0.0001 9.60826873779E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
219 0.0001 0.000113964080811
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
220 0.0002 0.000169992446899
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0001 7.39097595215E-5
UPDATE products SET price = '1510' WHERE id = '53162'
222 0.0001 0.000111818313599
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
223 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
224 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
225 0.0004 0.00043797492981
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
226 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
227 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
228 0.0001 0.000133037567139
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0001 7.39097595215E-5
UPDATE products SET price = '3395' WHERE id = '53167'
230 0.0001 8.60691070557E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
231 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
232 0.0001 8.89301300049E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
233 0.0004 0.00040602684021
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
234 0.0001 0.000134944915771
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
235 0.0001 0.000105142593384
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
236 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
237 0.0001 0.000102996826172
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
238 0.0001 7.41481781006E-5
UPDATE products SET price = '6995' WHERE id = '53186'
239 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
240 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
241 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
242 0.0005 0.000527858734131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
243 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
244 0.0001 9.79900360107E-5
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
245 0.0002 0.000154972076416
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0001 7.41481781006E-5
UPDATE products SET price = '1998' WHERE id = '53187'
247 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
248 0.0001 8.29696655273E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
249 0.0001 7.5101852417E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
250 0.0004 0.000425100326538
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
251 0.0001 9.48905944824E-5
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
252 0.0001 0.000113964080811
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
253 0.0002 0.000154972076416
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0002 0.000174045562744
UPDATE products SET price = '2854' WHERE id = '53188'
255 0.0001 9.89437103271E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
256 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
257 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
258 0.0005 0.000458002090454
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
259 0.0001 0.000108957290649
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
260 0.0001 0.000113010406494
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
261 0.0001 0.000149011611938
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0001 7.29560852051E-5
UPDATE products SET price = '3597' WHERE id = '53196'
263 0.0002 0.000168085098267
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
264 0.0001 0.000146150588989
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
265 0.0004 0.000394105911255
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
266 0.0002 0.000185966491699
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
267 0.0002 0.000163078308105
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
268 0.0003 0.000309944152832
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
269 0.0003 0.000250101089478
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
270 0.0003 0.000280141830444
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'