Oil for Generators

Oil for Generators


Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Notice: Undefined index: hasvars in /home/demofres/public_html/evolution/cache/fsbp-evolutionstore/smarty/57f846989081b0caecbc3a55469b2d8e23692b24.template.category_products.tpl.php on line 103

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.180844068527 280 0.0403 0


No Amazon API Requests Made.

Total time 0.180844068527 seconds

Number Time From Start Name Description
1 0.0527789592743 Initialise Initialise FSB Function
2 0.0541169643402 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0608658790588 App Controller End End of the App controller (called before the controller of every page)
4 0.0613939762115 Category Start Start of the category controller
5 0.0613970756531 Before Get Category Before getting the category information
6 0.0631470680237 After Get Category After getting the category information
7 0.063148021698 Before Get Category List Before getting the updated category list
8 0.0632650852203 Start of getCategoryListByGroup Function Before first category groups query
9 0.0633389949799 After initial query Before first category groups query
10 0.0633409023285 Get Category List for Group Before the call to getCategoryList function
11 0.0633430480957 Start of GetCategoryList function Start of the function
12 0.0633459091187 Before getting categories Query to get specific category list
13 0.0634610652924 After getting categories Query to get specific category list
14 0.063462972641 Before getting category custom Before call to function getCategoryCustom
15 0.064129114151 After getting category custom After call to function getCategoryCustom
16 0.0641310214996 Before getting category custom Before call to function getCategoryCustom
17 0.0647659301758 After getting category custom After call to function getCategoryCustom
18 0.0647668838501 Before getting sub category list Before call to recursive function getCategoryList
19 0.0647690296173 Start of GetCategoryList function Start of the function
20 0.0647718906403 Before getting categories Query to get specific category list
21 0.0648710727692 After getting sub category list After call to recursive function getCategoryList
22 0.0648720264435 Before getting category custom Before call to function getCategoryCustom
23 0.0655229091644 After getting category custom After call to function getCategoryCustom
24 0.0655250549316 Before getting category custom Before call to function getCategoryCustom
25 0.0661120414734 After getting category custom After call to function getCategoryCustom
26 0.066113948822 End of GetCategoryList function End of the function
27 0.0661199092865 End of getCategoryListByGroup Function Before return()
28 0.0661211013794 After Get Category List After getting the updated category list
29 0.0661220550537 Before Category Images Before getting the category images
30 0.0661969184875 After Category Images After getting the category images
31 0.0663089752197 Before Sub Category Check Before checking for sub category or products category
32 0.0663950443268 Before Category Products Controller Before loading the category products controller
33 0.0671479701996 Start Category Products Start of Category Products Controller
34 0.0671629905701 After Pagination Options After pagination options in Category Products Controller
35 0.0674328804016 After Cache After Cache checking in Category Products Controller
36 0.0686008930206 After Filter Options After getting filter options and SQL in Category Products Controller
37 0.0687599182129 After Counting Products After counting products in the Category Products Controller
38 0.0688560009003 After Counting Bundles After counting bundles in the Category Products Controller
39 0.0691239833832 After Getting Products After getting products and bundles in the Category Products Controller
40 0.0691709518433 After Pagination Links After getting pagination listing links in the Category Products Controller
41 0.0691719055176 After Getting Bundle Details After getting full details for the bundles in the Category Products Controller
42 0.0819671154022 After Getting Product Details After getting full product details in the Category Products Controller
43 0.0827569961548 After Getting Product/Bundle Reviews After getting full product/bundle customer review in the Category Products Controller
44 0.0833950042725 App_after Controller Start Start of the App_after controller (called after the controller of every page)
45 0.0834419727325 Before Get Options Before the call to getOptions in the tpl class
46 0.0985379219055 After Get Options After the call to getOptions in the tpl class
47 0.0986890792847 App_after Controller End End of the App_after controller (called after the controller of every page)
48 0.0986909866333 Before Smarty Before passing everything over to Smarty in the Category Products Controller
49 0.180828094482 After Loading sub/product controller After checking for sub category or products category and then loading the relevant controller
50 0.180830955505 Finalizing debug Before the debug is output to the page.
51 0.180844068527 End of App This is the end of the app logging, final timestamp


Query Debug - 280 Database Queries. Total time 0.0403 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000372171401978
SELECT parameter, value FROM parameters
2 0.0002 0.000236034393311
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000220060348511
SET time_zone = 'Europe/London'
4 0.0003 0.000290155410767
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000226020812988
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0003 0.00025200843811
SELECT id FROM pages WHERE pagename = 'oil-for-generators' LIMIT 1
7 0.0003 0.000255823135376
SELECT id FROM products WHERE pagename = 'oil-for-generators' AND hidden = 0 LIMIT 1
8 0.0002 0.000174999237061
SELECT id FROM categories WHERE pagename = 'oil-for-generators' LIMIT 1
9 0.0004 0.000432014465332
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
10 0.0029 0.00286889076233
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
11 0.0002 0.000247001647949
SELECT * FROM pages WHERE pagename = 'oil-for-generators'
12 0.0003 0.000312089920044
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
13 0.0003 0.000268936157227
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
14 0.0002 0.00022292137146
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
15 0.0002 0.000239133834839
SELECT * FROM pages WHERE id = '37'
16 0.0002 0.000223875045776
SELECT * FROM pages WHERE id = '4'
17 0.0002 0.000216960906982
SELECT * FROM pages WHERE id = '34'
18 0.0002 0.000194072723389
SELECT * FROM pages WHERE id = '3'
19 0.0001 9.01222229004E-5
SELECT * FROM pages WHERE id = '24'
20 0.0001 0.000107049942017
SELECT * FROM pages WHERE id = '5'
21 0.0001 0.000103950500488
SELECT * FROM pages WHERE id = '38'
22 0.0001 8.79764556885E-5
SELECT * FROM pages WHERE id = '39'
23 0.0002 0.000150918960571
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
24 0.0001 9.67979431152E-5
SELECT * FROM categories WHERE pagename = 'oil-for-generators'
25 0.0002 0.000179052352905
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
26 0.0001 9.48905944824E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 68
27 0.0001 9.60826873779E-5
SELECT id FROM categories WHERE parent_id = '68'
28 0.0002 0.000174999237061
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
29 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
30 0.0001 8.79764556885E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
31 0.0001 7.10487365723E-5
SELECT id FROM categories WHERE parent_id = '68'
32 0.0001 0.000147104263306
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (68) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
33 0.0001 9.60826873779E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
34 0.0002 0.000178098678589
SELECT * FROM categoryimages WHERE category_id = 68
35 0.0001 7.39097595215E-5
SELECT * FROM categorygroups WHERE id = '10'
36 0.0002 0.000151872634888
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '68'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
37 0.0001 7.29560852051E-5
SELECT parent_id FROM categories WHERE id = '68'
38 0.0001 0.000103950500488
SELECT parent_id FROM categories WHERE id = '68'
39 0.0001 6.48498535156E-5
SELECT * FROM categorygroups ORDER BY sortorder ASC
40 0.0001 9.98973846436E-5
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
41 0.0001 0.000144958496094
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 67
42 0.0001 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '67'
43 0.0001 0.000149965286255
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
44 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 (67)
				  AND p.disabled = 0 AND offers > 0
45 0.0001 8.41617584229E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
46 0.0001 7.31945037842E-5
SELECT * FROM categorygroups WHERE id = '10'
47 0.0001 0.000135183334351
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
48 0.0001 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '68'
49 0.0001 0.000140905380249
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
50 0.0001 7.9870223999E-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
51 0.0001 8.29696655273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
52 0.0001 7.10487365723E-5
SELECT * FROM categorygroups WHERE id = '10'
53 0.0001 8.89301300049E-5
SELECT * FROM categories WHERE parent_id = '68'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
54 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 = 69
55 0.0001 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '69'
56 0.0002 0.000152826309204
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
57 0.0001 7.89165496826E-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
58 0.0001 8.39233398438E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
59 0.0001 7.29560852051E-5
SELECT * FROM categorygroups WHERE id = '10'
60 0.0001 0.000110149383545
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
61 0.0001 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '70'
62 0.0001 0.000123023986816
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
63 0.0001 7.70092010498E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (70)
				  AND p.disabled = 0 AND offers > 0
64 0.0001 8.29696655273E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
65 0.0001 7.20024108887E-5
SELECT * FROM categorygroups WHERE id = '10'
66 0.0001 6.69956207275E-5
SELECT * FROM categoryimages WHERE category_id = 68
67 0.0001 8.70227813721E-5
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
68 0.0001 7.70092010498E-5
SELECT * FROM categories WHERE parent_id = '68'
69 0.0002 0.000185966491699
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
70 0.0002 0.000157117843628
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
71 0.0001 0.000107049942017
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
72 0.0002 0.000180959701538
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
73 0.0002 0.000153064727783
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
74 0.0001 0.000103950500488
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
75 0.0001 0.000149011611938
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 68
		AND hidden = 0
		AND enabled = 1
		AND offers > 0
		AND 1 = 1
76 0.0001 8.39233398438E-5
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 68
			AND p.disabled = 0
			AND offers > 0
			AND 1 = 1
77 0.0002 0.000236034393311
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.averagescore, p.linktitle, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 68
			AND hidden = 0
			AND enabled = 1
			AND offers > 0
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.averagescore, p.linktitle, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 68
			AND disabled = 0
			AND offers > 0
			AND 1 = 1 ORDER BY salesrank ASC
			LIMIT 0, 12
78 0.0001 0.000110149383545
SELECT * FROM products WHERE id = '53155'
79 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
80 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
81 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
82 0.0004 0.000420093536377
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
83 0.0001 9.58442687988E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
84 0.0001 0.000136852264404
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
85 0.0002 0.000150918960571
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
86 0.0001 7.5101852417E-5
UPDATE products SET price = '1595' WHERE id = '53155'
87 0.0001 0.00010085105896
SELECT * FROM products WHERE id = '53159'
88 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
89 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
90 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
91 0.0004 0.000442981719971
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
92 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
93 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
94 0.0002 0.000162124633789
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
95 0.0001 7.20024108887E-5
UPDATE products SET price = '998' WHERE id = '53159'
96 0.0001 9.98973846436E-5
SELECT * FROM products WHERE id = '53160'
97 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
98 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
99 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
100 0.0003 0.000326156616211
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
101 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
102 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
103 0.0001 0.000136137008667
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104 0.0001 7.29560852051E-5
UPDATE products SET price = '471' WHERE id = '53160'
105 0.0001 0.000103950500488
SELECT * FROM products WHERE id = '53163'
106 0.0001 0.000102996826172
SELECT * FROM productimages WHERE product_id = '53163' ORDER BY sortorder ASC
107 0.0001 6.5803527832E-5
SELECT * FROM product_image_select WHERE product_id = '53163'
108 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53163'
109 0.0003 0.000310897827148
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53163' AND a.name = n.originalname
110 0.0001 9.41753387451E-5
SELECT * FROM productoffers WHERE product_id = '53163' AND merchantid = 'ATVPDKIKX0DER'
111 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = '53163' AND price > 0
				ORDER BY price ASC LIMIT 1
112 0.0001 0.000137090682983
SELECT value FROM productattributes WHERE product_id = '53163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0001 7.31945037842E-5
UPDATE products SET price = '648' WHERE id = '53163'
114 0.0001 9.89437103271E-5
SELECT * FROM products WHERE id = '53162'
115 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
116 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
117 0.0001 6.31809234619E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
118 0.0005 0.000514030456543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
119 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
120 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
121 0.0002 0.000154972076416
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0001 7.20024108887E-5
UPDATE products SET price = '1510' WHERE id = '53162'
123 0.0001 0.00010085105896
SELECT * FROM products WHERE id = '53164'
124 0.0001 8.60691070557E-5
SELECT * FROM productimages WHERE product_id = '53164' ORDER BY sortorder ASC
125 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53164'
126 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53164'
127 0.0005 0.000450849533081
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53164' AND a.name = n.originalname
128 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53164' AND merchantid = 'ATVPDKIKX0DER'
129 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53164' AND price > 0
				ORDER BY price ASC LIMIT 1
130 0.0001 0.00014591217041
SELECT value FROM productattributes WHERE product_id = '53164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0001 7.20024108887E-5
UPDATE products SET price = '849' WHERE id = '53164'
132 0.0001 0.000101089477539
SELECT * FROM products WHERE id = '53149'
133 0.0001 8.60691070557E-5
SELECT * FROM productimages WHERE product_id = '53149' ORDER BY sortorder ASC
134 0.0001 0.00011420249939
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
135 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53149'
136 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53149'
137 0.0001 0.000121831893921
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
138 0.0002 0.000152111053467
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
139 0.0001 0.000109195709229
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53149
140 0.0003 0.000336885452271
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53149' AND a.name = n.originalname
141 0.0001 9.08374786377E-5
SELECT * FROM productoffers WHERE product_id = '53149' AND merchantid = 'ATVPDKIKX0DER'
142 0.0001 9.41753387451E-5
SELECT * FROM productoffers
				WHERE product_id = '53149' AND price > 0
				ORDER BY price ASC LIMIT 1
143 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53149
				ORDER BY price ASC LIMIT 1
144 0.0001 0.000106811523438
SELECT value FROM productattributes
				WHERE product_id = '53149'
				AND name = 'ListPriceAmount'
145 0.0001 0.000123977661133
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
146 0.0001 0.000146865844727
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
147 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
148 0.0002 0.000159978866577
SELECT value FROM productattributes WHERE product_id = '53149' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0001 8.70227813721E-5
UPDATE products SET price = '1323' WHERE id = '53149'
150 0.0001 0.00012993812561
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
151 0.0001 0.000103950500488
SELECT * FROM products WHERE id = '53156'
152 0.0001 8.29696655273E-5
SELECT * FROM productimages WHERE product_id = '53156' ORDER BY sortorder ASC
153 0.0001 0.000108003616333
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53156' AND p.id = pi.product_id ORDER BY pi.sortorder
154 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53156'
155 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53156'
156 0.0001 0.000112056732178
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53156'
				GROUP BY o.product_id
157 0.0001 0.000135898590088
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		= '53156'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
158 0.0001 0.000101089477539
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53156
159 0.0004 0.000437021255493
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53156' AND a.name = n.originalname
160 0.0001 8.89301300049E-5
SELECT * FROM productoffers WHERE product_id = '53156' AND merchantid = 'ATVPDKIKX0DER'
161 0.0001 9.29832458496E-5
SELECT * FROM productoffers
				WHERE product_id = '53156' AND price > 0
				ORDER BY price ASC LIMIT 1
162 0.0001 8.70227813721E-5
SELECT * FROM productoffers
				WHERE product_id = 53156
				ORDER BY price ASC LIMIT 1
163 0.0001 0.000117063522339
SELECT value FROM productattributes
				WHERE product_id = '53156'
				AND name = 'ListPriceAmount'
164 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	= '53156'
				GROUP BY o.product_id
165 0.0001 0.000130891799927
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		= '53156'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
166 0.0001 9.89437103271E-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 = 53156
167 0.0001 0.000149965286255
SELECT value FROM productattributes WHERE product_id = '53156' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168 0.0001 7.29560852051E-5
UPDATE products SET price = '314' WHERE id = '53156'
169 0.0001 0.000120878219604
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53156'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Style'
				GROUP BY o.value
				ORDER BY o.value ASC
170 0.0001 9.10758972168E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53155
          ORDER BY timestamp DESC
          
171 0.0001 8.32080841064E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53159
          ORDER BY timestamp DESC
          
172 0.0001 0.00011682510376
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53160
          ORDER BY timestamp DESC
          
173 0.0001 8.08238983154E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53163
          ORDER BY timestamp DESC
          
174 0.0001 8.17775726318E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53162
          ORDER BY timestamp DESC
          
175 0.0001 7.9870223999E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53164
          ORDER BY timestamp DESC
          
176 0.0001 7.91549682617E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53149
          ORDER BY timestamp DESC
          
177 0.0001 7.9870223999E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53156
          ORDER BY timestamp DESC
          
178 0.0001 8.89301300049E-5
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
179 0.0001 8.58306884766E-5
SELECT * FROM pages WHERE id = 2
180 0.0001 7.91549682617E-5
SELECT * FROM pages WHERE id = 38
181 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 39
182 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 6
183 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 7
184 0.0001 7.39097595215E-5
SELECT * FROM pages WHERE id = 32
185 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = 2
186 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 28
187 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = 13
188 0.0001 7.48634338379E-5
SELECT * FROM pages WHERE id = 24
189 0.0002 0.000162124633789
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
190 0.0001 9.70363616943E-5
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
191 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
192 0.0001 6.31809234619E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
193 0.0005 0.00049090385437
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
194 0.0001 9.58442687988E-5
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
195 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
196 0.0002 0.000155925750732
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0001 7.39097595215E-5
UPDATE products SET price = '44900' WHERE id = '53141'
198 0.0001 9.10758972168E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
199 0.0001 8.9168548584E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
200 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
201 0.0004 0.00042200088501
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
202 0.0001 9.48905944824E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
203 0.0001 0.000100135803223
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
204 0.0001 0.000147104263306
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0001 7.70092010498E-5
UPDATE products SET price = '1595' WHERE id = '53155'
206 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
207 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
208 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
209 0.0004 0.000434875488281
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
210 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
211 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
212 0.0002 0.000160932540894
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0001 7.29560852051E-5
UPDATE products SET price = '998' WHERE id = '53159'
214 0.0001 9.41753387451E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
215 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
216 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
217 0.0003 0.000322818756104
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
218 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
219 0.0001 0.000130891799927
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
220 0.0001 0.000136137008667
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0001 7.29560852051E-5
UPDATE products SET price = '471' WHERE id = '53160'
222 0.0001 8.98838043213E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
223 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
224 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
225 0.0005 0.000509023666382
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
226 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
227 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
228 0.0002 0.000155925750732
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0001 7.20024108887E-5
UPDATE products SET price = '1510' WHERE id = '53162'
230 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
231 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
232 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
233 0.0004 0.000417947769165
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
234 0.0001 9.3936920166E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
235 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
236 0.0001 0.000128984451294
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0001 7.29560852051E-5
UPDATE products SET price = '3395' WHERE id = '53167'
238 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
239 0.0001 6.60419464111E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
240 0.0001 6.60419464111E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
241 0.0004 0.000391960144043
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
242 0.0001 9.01222229004E-5
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
243 0.0001 9.10758972168E-5
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
244 0.0001 8.6784362793E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
245 0.0001 0.000101804733276
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
246 0.0001 7.29560852051E-5
UPDATE products SET price = '6995' WHERE id = '53186'
247 0.0001 0.000125885009766
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
248 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
249 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
250 0.0005 0.00049901008606
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
251 0.0001 9.20295715332E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
252 0.0001 0.000102996826172
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
253 0.0002 0.0001540184021
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0001 7.39097595215E-5
UPDATE products SET price = '1998' WHERE id = '53187'
255 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
256 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
257 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
258 0.0004 0.00041389465332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
259 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
260 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
261 0.0001 0.000140190124512
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0001 7.29560852051E-5
UPDATE products SET price = '2854' WHERE id = '53188'
263 0.0001 8.79764556885E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
264 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
265 0.0001 6.19888305664E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
266 0.0005 0.000476121902466
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
267 0.0001 9.41753387451E-5
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
268 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
269 0.0001 0.000148057937622
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0001 7.29560852051E-5
UPDATE products SET price = '3597' WHERE id = '53196'
271 0.0002 0.000163078308105
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
272 0.0001 0.000141859054565
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
273 0.0004 0.000380039215088
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
274 0.0001 0.000147104263306
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
275 0.0001 0.000132083892822
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
276 0.0004 0.000422954559326
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'ICON_RSS_FEED'
277 0.0003 0.000319004058838
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
278 0.0003 0.000285148620605
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
279 0.0003 0.000277042388916
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
280 0.0003 0.000283002853394
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'