Best Sellers

These are our current bestselling products - popular with our customers not only for the price, but for the great quality!

1 to 12 of 24 products
1 2
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean aliquam luctus euismod. Pellentesque cursus felis sodales ligula gravida vel ultrices purus pellentesque. Vestibulum scelerisque, lorem nec cursus aliquet, sem neque placerat nulla, id ullamcorper ante orci a purus. Etiam urna lorem, faucibus vitae porta sed, semper sit amet massa. Fusce quis nisi et nisl ullamcorper varius vitae nec magna. Ut pharetra pharetra urna, ac lacinia metus porttitor ut. Integer eu rutrum velit. Cras vitae mauris nisi.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.20752286911 280 0.0475 0


No Amazon API Requests Made.

Total time 0.20752286911 seconds

Number Time From Start Name Description
1 0.0642108917236 Initialise Initialise FSB Function
2 0.0653619766235 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0699138641357 Start of getCategoryListByGroup Function Before first category groups query
4 0.0701110363007 After initial query Before first category groups query
5 0.0701129436493 Get Category List for Group Before the call to getCategoryList function
6 0.0701289176941 Start of GetCategoryList function Start of the function
7 0.0701358318329 Before getting categories Query to get specific category list
8 0.0704128742218 After getting categories Query to get specific category list
9 0.0704159736633 Before getting category custom Before call to function getCategoryCustom
10 0.0718009471893 After getting category custom After call to function getCategoryCustom
11 0.071802854538 Before getting category custom Before call to function getCategoryCustom
12 0.0729448795319 After getting category custom After call to function getCategoryCustom
13 0.0729470252991 Before getting category custom Before call to function getCategoryCustom
14 0.0739099979401 After getting category custom After call to function getCategoryCustom
15 0.0739119052887 Before getting category custom Before call to function getCategoryCustom
16 0.0748918056488 After getting category custom After call to function getCategoryCustom
17 0.074893951416 End of GetCategoryList function End of the function
18 0.0749068260193 End of getCategoryListByGroup Function Before return()
19 0.0770518779755 App Controller End End of the App controller (called before the controller of every page)
20 0.112916946411 App_after Controller Start Start of the App_after controller (called after the controller of every page)
21 0.112996816635 Before Get Options Before the call to getOptions in the tpl class
22 0.130336999893 After Get Options After the call to getOptions in the tpl class
23 0.130668878555 App_after Controller End End of the App_after controller (called after the controller of every page)
24 0.207501888275 Finalizing debug Before the debug is output to the page.
25 0.207521915436 End of App This is the end of the app logging, final timestamp


Query Debug - 280 Database Queries. Total time 0.0475 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000409126281738
SELECT parameter, value FROM parameters
2 0.0002 0.000200986862183
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000187873840332
SET time_zone = 'Europe/London'
4 0.0003 0.00032114982605
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000195026397705
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0002 0.000214815139771
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
7 0.0002 0.000185012817383
SELECT * FROM pages WHERE id = 6
8 0.0004 0.00037407875061
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
9 0.0028 0.00283002853394
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
10 0.0003 0.000281095504761
SELECT * FROM pages WHERE pagename = 'best-sellers'
11 0.0002 0.000171184539795
SELECT * FROM categorygroups ORDER BY sortorder ASC
12 0.0002 0.000224828720093
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.000275135040283
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.000169038772583
SELECT id FROM categories WHERE parent_id = '67'
15 0.0002 0.000247955322266
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.000180006027222
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.000183820724487
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
18 0.0002 0.000158071517944
SELECT * FROM categorygroups WHERE id = '10'
19 0.0002 0.000205993652344
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.000130176544189
SELECT id FROM categories WHERE parent_id = '68'
21 0.0002 0.000214099884033
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.000134944915771
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.00014591217041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
24 0.0002 0.000159978866577
SELECT * FROM categorygroups WHERE id = '10'
25 0.0002 0.000201940536499
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.000123977661133
SELECT id FROM categories WHERE parent_id = '69'
27 0.0002 0.000192165374756
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.000139951705933
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.000118970870972
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
30 0.0001 7.79628753662E-5
SELECT * FROM categorygroups WHERE id = '10'
31 0.0002 0.0001540184021
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.00013279914856
SELECT id FROM categories WHERE parent_id = '70'
33 0.0002 0.000156879425049
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.000123977661133
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.0002 0.000157833099365
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
36 0.0001 0.000105142593384
SELECT * FROM categorygroups WHERE id = '10'
37 0.0002 0.000216007232666
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
38 0.0002 0.000170946121216
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
39 0.0001 0.000108957290649
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
40 0.0001 0.000142097473145
SELECT * FROM pages WHERE id = '37'
41 0.0001 0.000144958496094
SELECT * FROM pages WHERE id = '4'
42 0.0001 8.51154327393E-5
SELECT * FROM pages WHERE id = '34'
43 0.0001 8.32080841064E-5
SELECT * FROM pages WHERE id = '3'
44 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = '24'
45 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = '5'
46 0.0001 8.29696655273E-5
SELECT * FROM pages WHERE id = '38'
47 0.0001 8.39233398438E-5
SELECT * FROM pages WHERE id = '39'
48 0.0002 0.000178098678589
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
49 0.0002 0.000229120254517
SELECT * FROM pages WHERE pagename = 'best-sellers'
50 0.0003 0.000337839126587
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|12'
51 0.0002 0.000210046768188
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|1|bestselling|12'
52 0.0003 0.000303983688354
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
53 0.0003 0.0002760887146
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
54 0.0002 0.000200986862183
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
55 0.0003 0.000294923782349
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
56 0.0003 0.000266075134277
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
57 0.0002 0.000200033187866
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
58 0.0003 0.000257968902588
SELECT id FROM products p
		WHERE enabled = 1
		AND parent_id = 0
		AND hidden = 0
		AND offers > 0
		AND salesrank <> 0
		AND 1 = 1
		ORDER BY salesrank ASC
		LIMIT 50
59 0.0004 0.000355958938599
SELECT * FROM products p
		WHERE enabled = 1
		AND parent_id = 0
		AND hidden = 0
		AND offers > 0
		AND salesrank <> 0
		AND 1 = 1
		AND id IN (53167,53155,53141,53187,53159,53160,53188,53163,53162,53164,53196,53189,53176,53170,53178,53168,53165,53130,53156,53149,53147,53144,53142,53197)
		ORDER BY salesrank ASC
		LIMIT 0, 12
60 0.0002 0.000192165374756
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
61 0.0001 0.000137090682983
SELECT * FROM product_image_select WHERE product_id = '53167'
62 0.0002 0.000173807144165
SELECT * FROM productcustomimages WHERE product_id = '53167'
63 0.0005 0.00053596496582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
64 0.0002 0.000170946121216
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
65 0.0002 0.000188112258911
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
66 0.0002 0.000191926956177
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
67 0.0001 0.000139951705933
UPDATE products SET price = '3395' WHERE id = '53167'
68 0.0001 0.000140905380249
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
69 0.0001 0.000123977661133
SELECT * FROM product_image_select WHERE product_id = '53155'
70 0.0001 9.20295715332E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
71 0.0005 0.000478029251099
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
72 0.0001 0.000144004821777
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
73 0.0001 0.000134944915771
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
74 0.0002 0.000165939331055
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
75 0.0001 0.000103950500488
UPDATE products SET price = '1595' WHERE id = '53155'
76 0.0001 0.000120878219604
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
77 0.0001 9.79900360107E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
78 0.0001 9.08374786377E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
79 0.0006 0.00059700012207
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
80 0.0001 0.000126838684082
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
81 0.0001 0.000130891799927
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
82 0.0002 0.000190019607544
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
83 0.0001 0.000104904174805
UPDATE products SET price = '44900' WHERE id = '53141'
84 0.0001 0.000137090682983
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
85 0.0001 0.000134944915771
SELECT * FROM product_image_select WHERE product_id = '53187'
86 0.0001 9.01222229004E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
87 0.0006 0.000560998916626
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
88 0.0001 0.000124931335449
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
89 0.0001 0.000143051147461
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
90 0.0002 0.000212907791138
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
91 0.0001 0.000113964080811
UPDATE products SET price = '1998' WHERE id = '53187'
92 0.0001 0.000115156173706
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
93 0.0001 0.000105857849121
SELECT * FROM product_image_select WHERE product_id = '53159'
94 0.0001 9.10758972168E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
95 0.0005 0.000500202178955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
96 0.0001 0.000136137008667
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
97 0.0002 0.000153064727783
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
98 0.0002 0.000207185745239
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
99 0.0001 0.000113964080811
UPDATE products SET price = '998' WHERE id = '53159'
100 0.0001 0.000148057937622
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
101 0.0001 9.3936920166E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
102 0.0001 9.3936920166E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
103 0.0004 0.000384092330933
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
104 0.0001 0.000123977661133
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
105 0.0001 0.000146150588989
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
106 0.0002 0.000164985656738
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
107 0.0001 8.9168548584E-5
UPDATE products SET price = '471' WHERE id = '53160'
108 0.0002 0.000155925750732
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
109 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
110 0.0001 6.60419464111E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
111 0.0004 0.000431060791016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
112 0.0001 0.00010085105896
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
113 0.0001 0.000110864639282
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
114 0.0002 0.000160932540894
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0001 7.60555267334E-5
UPDATE products SET price = '2854' WHERE id = '53188'
116 0.0001 9.10758972168E-5
SELECT * FROM productimages WHERE product_id = '53163' ORDER BY sortorder ASC
117 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53163'
118 0.0001 6.50882720947E-5
SELECT * FROM productcustomimages WHERE product_id = '53163'
119 0.0004 0.000351905822754
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.00011420249939
SELECT * FROM productoffers WHERE product_id = '53163' AND merchantid = 'ATVPDKIKX0DER'
121 0.0001 0.000118970870972
SELECT * FROM productoffers
				WHERE product_id = '53163' AND price > 0
				ORDER BY price ASC LIMIT 1
122 0.0001 0.000139951705933
SELECT value FROM productattributes WHERE product_id = '53163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0001 7.5101852417E-5
UPDATE products SET price = '648' WHERE id = '53163'
124 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
125 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
126 0.0001 6.48498535156E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
127 0.0006 0.000617027282715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
128 0.0001 0.000127077102661
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
129 0.0001 0.0001060962677
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
130 0.0002 0.000160932540894
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0001 8.01086425781E-5
UPDATE products SET price = '1510' WHERE id = '53162'
132 0.0001 9.20295715332E-5
SELECT * FROM productimages WHERE product_id = '53164' ORDER BY sortorder ASC
133 0.0001 6.98566436768E-5
SELECT * FROM product_image_select WHERE product_id = '53164'
134 0.0001 7.79628753662E-5
SELECT * FROM productcustomimages WHERE product_id = '53164'
135 0.0004 0.000446081161499
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53164' AND a.name = n.originalname
136 0.0001 0.000100135803223
SELECT * FROM productoffers WHERE product_id = '53164' AND merchantid = 'ATVPDKIKX0DER'
137 0.0001 0.000146865844727
SELECT * FROM productoffers
				WHERE product_id = '53164' AND price > 0
				ORDER BY price ASC LIMIT 1
138 0.0002 0.000164031982422
SELECT value FROM productattributes WHERE product_id = '53164' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139 0.0001 7.58171081543E-5
UPDATE products SET price = '849' WHERE id = '53164'
140 0.0001 9.08374786377E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
141 0.0001 8.32080841064E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
142 0.0001 0.000107049942017
SELECT * FROM productcustomimages WHERE product_id = '53196'
143 0.0006 0.00058388710022
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
144 0.0001 0.000142812728882
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
145 0.0002 0.000159978866577
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
146 0.0002 0.000209093093872
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0001 0.000118970870972
UPDATE products SET price = '3597' WHERE id = '53196'
148 0.0001 0.000125169754028
SELECT * FROM productimages WHERE product_id = '53130' ORDER BY sortorder ASC
149 0.0001 0.000128984451294
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '53130' AND p.id = pi.product_id ORDER BY pi.sortorder
150 0.0001 7.20024108887E-5
SELECT * FROM product_image_select WHERE product_id = '53130'
151 0.0001 6.79492950439E-5
SELECT * FROM productcustomimages WHERE product_id = '53130'
152 0.0001 0.000147104263306
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53130'
				GROUP BY o.product_id
153 0.0002 0.000179052352905
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		= '53130'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
154 0.0001 0.00012993812561
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53130
155 0.0003 0.000276803970337
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53130' AND a.name = n.originalname
156 0.0001 0.000101089477539
SELECT * FROM productoffers WHERE product_id = '53130' AND merchantid = 'ATVPDKIKX0DER'
157 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53130' AND price > 0
				ORDER BY price ASC LIMIT 1
158 0.0001 0.000119924545288
SELECT * FROM productoffers
				WHERE product_id = 53130
				ORDER BY price ASC LIMIT 1
159 0.0001 0.000123023986816
SELECT value FROM productattributes
				WHERE product_id = '53130'
				AND name = 'ListPriceAmount'
160 0.0002 0.000150918960571
SELECT	o.product_id, MIN(o.price) as price
				FROM	products		p,
						productoffers	o
				WHERE	p.id		= o.product_id
				  AND	p.parent_id	= '53130'
				GROUP BY o.product_id
161 0.0002 0.000169038772583
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		= '53130'
				GROUP BY n.displayname
				ORDER BY n.displayname DESC
162 0.0001 0.000125169754028
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 53130
163 0.0002 0.000150918960571
SELECT value FROM productattributes WHERE product_id = '53130' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164 0.0001 7.60555267334E-5
UPDATE products SET price = '18049' WHERE id = '53130'
165 0.0002 0.0001540184021
SELECT	o.value
				FROM	products			p,
						productoptions		o
				WHERE	p.parent_id		= '53130'
				  AND	p.id			= o.product_id
				  AND	o.name			= 'Size'
				GROUP BY o.value
				ORDER BY o.value ASC
166 0.0001 0.000111103057861
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53167
          ORDER BY timestamp DESC
          
167 0.0001 9.10758972168E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53155
          ORDER BY timestamp DESC
          
168 0.0001 8.70227813721E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53141
          ORDER BY timestamp DESC
          
169 0.0001 8.51154327393E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53187
          ORDER BY timestamp DESC
          
170 0.0001 8.39233398438E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53159
          ORDER BY timestamp DESC
          
171 0.0001 8.51154327393E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53160
          ORDER BY timestamp DESC
          
172 0.0001 8.51154327393E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53188
          ORDER BY timestamp DESC
          
173 0.0001 0.000109910964966
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53163
          ORDER BY timestamp DESC
          
174 0.0001 8.39233398438E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53162
          ORDER BY timestamp DESC
          
175 0.0001 8.39233398438E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53164
          ORDER BY timestamp DESC
          
176 0.0001 8.51154327393E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53196
          ORDER BY timestamp DESC
          
177 0.0001 8.70227813721E-5
          SELECT *
          FROM customerreviews
          WHERE approved = 1
          AND productid = 53130
          ORDER BY timestamp DESC
          
178 0.0001 0.0001220703125
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
179 0.0001 9.3936920166E-5
SELECT * FROM pages WHERE id = 2
180 0.0001 8.51154327393E-5
SELECT * FROM pages WHERE id = 38
181 0.0001 7.91549682617E-5
SELECT * FROM pages WHERE id = 39
182 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = 6
183 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = 7
184 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 32
185 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = 2
186 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = 28
187 0.0001 8.79764556885E-5
SELECT * FROM pages WHERE id = 13
188 0.0001 8.10623168945E-5
SELECT * FROM pages WHERE id = 24
189 0.0002 0.000171899795532
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
190 0.0001 0.00010085105896
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
191 0.0001 9.67979431152E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
192 0.0001 6.5803527832E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
193 0.0005 0.00052809715271
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.98973846436E-5
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
195 0.0001 0.000107049942017
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
196 0.0002 0.000161170959473
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0001 9.01222229004E-5
UPDATE products SET price = '44900' WHERE id = '53141'
198 0.0001 0.000108003616333
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
199 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
200 0.0001 6.5803527832E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
201 0.0005 0.000451803207397
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
202 0.0001 0.000101089477539
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
203 0.0001 0.000108957290649
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
204 0.0002 0.0001540184021
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0001 7.60555267334E-5
UPDATE products SET price = '1595' WHERE id = '53155'
206 0.0001 0.000118017196655
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
207 0.0001 6.98566436768E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
208 0.0001 7.79628753662E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
209 0.0005 0.000471115112305
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.98973846436E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
211 0.0001 0.000103950500488
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
212 0.0002 0.000164985656738
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0001 7.70092010498E-5
UPDATE products SET price = '998' WHERE id = '53159'
214 0.0001 9.89437103271E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
215 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
216 0.0001 7.79628753662E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
217 0.0004 0.000359058380127
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.98973846436E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
219 0.0001 0.000105142593384
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
220 0.0001 0.000141143798828
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0001 7.58171081543E-5
UPDATE products SET price = '471' WHERE id = '53160'
222 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
223 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
224 0.0001 6.48498535156E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
225 0.0005 0.000529050827026
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.91821289062E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
227 0.0001 0.000121116638184
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
228 0.0002 0.000174999237061
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0001 7.5101852417E-5
UPDATE products SET price = '1510' WHERE id = '53162'
230 0.0001 9.70363616943E-5
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
231 0.0001 7.10487365723E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
232 0.0001 6.60419464111E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
233 0.0005 0.000459909439087
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
234 0.0001 0.000102043151855
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
235 0.0001 0.000105142593384
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
236 0.0002 0.000159978866577
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0001 7.70092010498E-5
UPDATE products SET price = '3395' WHERE id = '53167'
238 0.0001 9.08374786377E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
239 0.0001 6.98566436768E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
240 0.0001 6.69956207275E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
241 0.0004 0.00041389465332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
242 0.0001 0.000123977661133
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
243 0.0001 0.000111103057861
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
244 0.0001 0.000108003616333
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
245 0.0001 0.000118970870972
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
246 0.0001 9.20295715332E-5
UPDATE products SET price = '6995' WHERE id = '53186'
247 0.0001 0.000112056732178
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
248 0.0001 7.00950622559E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
249 0.0001 6.60419464111E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
250 0.0005 0.000522136688232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
251 0.0001 0.000130891799927
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
252 0.0001 0.000104904174805
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
253 0.0002 0.000159025192261
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0001 7.5101852417E-5
UPDATE products SET price = '1998' WHERE id = '53187'
255 0.0001 0.000107049942017
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
256 0.0001 6.98566436768E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
257 0.0001 9.29832458496E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
258 0.0005 0.00046181678772
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
259 0.0001 0.000125885009766
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
260 0.0001 0.000105857849121
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
261 0.0002 0.000159978866577
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262 0.0001 9.01222229004E-5
UPDATE products SET price = '2854' WHERE id = '53188'
263 0.0001 9.3936920166E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
264 0.0001 7.20024108887E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
265 0.0001 7.79628753662E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
266 0.0005 0.000451803207397
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.89437103271E-5
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
268 0.0001 0.000133037567139
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
269 0.0002 0.000231027603149
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270 0.0001 7.89165496826E-5
UPDATE products SET price = '3597' WHERE id = '53196'
271 0.0002 0.000177145004272
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
272 0.0002 0.000152111053467
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
273 0.0004 0.000403165817261
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
274 0.0002 0.000157117843628
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
275 0.0001 0.000149011611938
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
276 0.0003 0.000325202941895
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'ICON_RSS_FEED'
277 0.0002 0.000226020812988
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
278 0.0002 0.000205039978027
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
279 0.0002 0.000184059143066
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
280 0.0002 0.000212907791138
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'