Berricle

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.

Sorry, we currently have no available products here.


Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.100104808807 168 0.0278 0


No Amazon API Requests Made.

Total time 0.100104808807 seconds

Number Time From Start Name Description
1 0.051285982132 Initialise Initialise FSB Function
2 0.0528378486633 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0569598674774 Start of getCategoryListByGroup Function Before first category groups query
4 0.0572028160095 After initial query Before first category groups query
5 0.0572049617767 Get Category List for Group Before the call to getCategoryList function
6 0.0572078227997 Start of GetCategoryList function Start of the function
7 0.0572140216827 Before getting categories Query to get specific category list
8 0.0575399398804 After getting categories Query to get specific category list
9 0.057541847229 Before getting category custom Before call to function getCategoryCustom
10 0.0590298175812 After getting category custom After call to function getCategoryCustom
11 0.0590319633484 Before getting category custom Before call to function getCategoryCustom
12 0.0601489543915 After getting category custom After call to function getCategoryCustom
13 0.0601508617401 Before getting category custom Before call to function getCategoryCustom
14 0.0610959529877 After getting category custom After call to function getCategoryCustom
15 0.0610978603363 Before getting category custom Before call to function getCategoryCustom
16 0.0619368553162 After getting category custom After call to function getCategoryCustom
17 0.0619378089905 End of GetCategoryList function End of the function
18 0.0619449615479 End of getCategoryListByGroup Function Before return()
19 0.0635979175568 App Controller End End of the App controller (called before the controller of every page)
20 0.0672879219055 App_after Controller Start Start of the App_after controller (called after the controller of every page)
21 0.0673367977142 Before Get Options Before the call to getOptions in the tpl class
22 0.0828568935394 After Get Options After the call to getOptions in the tpl class
23 0.0829010009766 App_after Controller End End of the App_after controller (called after the controller of every page)
24 0.100080013275 Finalizing debug Before the debug is output to the page.
25 0.100103855133 End of App This is the end of the app logging, final timestamp


Query Debug - 168 Database Queries. Total time 0.0278 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000416040420532
SELECT parameter, value FROM parameters
2 0.0002 0.000235080718994
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000232934951782
SET time_zone = 'Europe/London'
4 0.0003 0.000332832336426
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000231981277466
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0002 0.00020694732666
SELECT id FROM pages WHERE pagename = 'berricle' LIMIT 1
7 0.0002 0.000245094299316
SELECT id FROM products WHERE pagename = 'berricle' AND hidden = 0 LIMIT 1
8 0.0001 0.000144004821777
SELECT id FROM categories WHERE pagename = 'berricle' LIMIT 1
9 0.0002 0.000243902206421
SELECT id FROM manufacturers WHERE pagename = 'berricle' LIMIT 1
10 0.0004 0.000414133071899
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
11 0.0029 0.00288414955139
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
12 0.0003 0.000250101089478
SELECT * FROM pages WHERE pagename = 'berricle'
13 0.0002 0.000226974487305
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0003 0.000272989273071
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
15 0.0003 0.000285863876343
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
16 0.0002 0.000180959701538
SELECT id FROM categories WHERE parent_id = '67'
17 0.0003 0.000325918197632
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
18 0.0002 0.00016713142395
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
19 0.0002 0.000221967697144
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
20 0.0002 0.000152111053467
SELECT * FROM categorygroups WHERE id = '10'
21 0.0003 0.000265836715698
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
22 0.0002 0.000154972076416
SELECT id FROM categories WHERE parent_id = '68'
23 0.0002 0.000216960906982
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
24 0.0001 0.000118970870972
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
25 0.0001 0.000135898590088
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
26 0.0001 0.000123023986816
SELECT * FROM categorygroups WHERE id = '10'
27 0.0002 0.000195026397705
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
28 0.0001 0.000123977661133
SELECT id FROM categories WHERE parent_id = '69'
29 0.0002 0.00019097328186
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
30 0.0001 0.000118017196655
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
31 0.0001 0.000124216079712
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
32 0.0001 0.000114917755127
SELECT * FROM categorygroups WHERE id = '10'
33 0.0002 0.000152111053467
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
34 0.0001 0.000113010406494
SELECT id FROM categories WHERE parent_id = '70'
35 0.0002 0.000162124633789
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
36 0.0001 0.000118017196655
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
37 0.0001 0.000123023986816
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
38 0.0001 0.000113010406494
SELECT * FROM categorygroups WHERE id = '10'
39 0.0002 0.000200986862183
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
40 0.0002 0.00016188621521
SELECT * FROM sideboxes WHERE (templateuid = 'fsbp-evolutionstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
41 0.0001 8.01086425781E-5
SELECT * FROM sideboxes_pages WHERE sidebox_id = '25'
42 0.0001 9.60826873779E-5
SELECT * FROM pages WHERE id = '37'
43 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = '4'
44 0.0001 7.9870223999E-5
SELECT * FROM pages WHERE id = '34'
45 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = '3'
46 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = '24'
47 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = '5'
48 0.0001 7.9870223999E-5
SELECT * FROM pages WHERE id = '38'
49 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = '39'
50 0.0002 0.000153064727783
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
51 0.0001 0.0001060962677
SELECT * FROM manufacturers WHERE pagename = 'berricle'
52 0.0001 7.41481781006E-5
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '275' LIMIT 1
53 0.0001 0.000113964080811
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '275'
54 0.0001 0.000117063522339
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '275'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 AND offers > 0
55 0.0001 7.58171081543E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '275'
56 0.0001 0.000118970870972
SELECT * FROM cachefiles WHERE identifier = '303421114d82a3ffda93f610d4eb00d4'
57 0.0001 0.000102996826172
DELETE FROM cachefiles WHERE identifier = '303421114d82a3ffda93f610d4eb00d4'
58 0.0002 0.000188112258911
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
59 0.0002 0.000158786773682
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
60 0.0001 0.000110149383545
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
61 0.0002 0.000179052352905
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
62 0.0002 0.0001540184021
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
63 0.0001 0.000105142593384
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
64 0.0001 0.000125885009766
SELECT COUNT(*) FROM products p
		WHERE manufacturer_id = 275
		AND parent_id = 0
		AND hidden = 0
		AND enabled = 1
		AND offers > 0
		AND 1 = 1
65 0.0001 0.000126838684082
SELECT * FROM products p
			WHERE	manufacturer_id = 275
			  AND	parent_id = 0
			  AND	hidden = 0
			  AND	enabled = 1
			  AND offers > 0
			  AND 	1 = 1 
			ORDER BY salesrank ASC
			LIMIT 0, 12
66 0.0001 9.08374786377E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '275'
67 0.0001 9.3936920166E-5
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
68 0.0001 8.60691070557E-5
SELECT * FROM pages WHERE id = 2
69 0.0001 7.9870223999E-5
SELECT * FROM pages WHERE id = 38
70 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 39
71 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 6
72 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 7
73 0.0001 9.01222229004E-5
SELECT * FROM pages WHERE id = 32
74 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 2
75 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 28
76 0.0001 8.29696655273E-5
SELECT * FROM pages WHERE id = 13
77 0.0001 7.60555267334E-5
SELECT * FROM pages WHERE id = 24
78 0.0002 0.000164985656738
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
79 0.0001 9.98973846436E-5
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
80 0.0001 7.00950622559E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
81 0.0001 6.50882720947E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
82 0.0005 0.000519037246704
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
83 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
84 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
85 0.0002 0.000158071517944
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
86 0.0001 9.29832458496E-5
UPDATE products SET price = '44900' WHERE id = '53141'
87 0.0001 9.20295715332E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
88 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
89 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
90 0.0004 0.000432014465332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
91 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
92 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
93 0.0001 0.000149011611938
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
94 0.0001 7.79628753662E-5
UPDATE products SET price = '1595' WHERE id = '53155'
95 0.0001 8.79764556885E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
96 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
97 0.0001 6.103515625E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
98 0.0004 0.000449180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
99 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
100 0.0001 9.89437103271E-5
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
101 0.0002 0.00022292137146
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0001 7.58171081543E-5
UPDATE products SET price = '998' WHERE id = '53159'
103 0.0001 9.29832458496E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
104 0.0001 8.29696655273E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
105 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
106 0.0003 0.000334024429321
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
107 0.0001 9.89437103271E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
108 0.0001 0.000100135803223
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
109 0.0001 0.000135898590088
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0001 7.29560852051E-5
UPDATE products SET price = '471' WHERE id = '53160'
111 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
112 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
113 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
114 0.0005 0.000527858734131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53162' AND a.name = n.originalname
115 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
116 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
117 0.0002 0.000158071517944
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0001 7.39097595215E-5
UPDATE products SET price = '1510' WHERE id = '53162'
119 0.0001 9.3936920166E-5
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
120 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
121 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
122 0.0004 0.000432014465332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
123 0.0001 9.70363616943E-5
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
124 0.0001 0.000102043151855
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
125 0.0001 0.000128984451294
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0001 7.48634338379E-5
UPDATE products SET price = '3395' WHERE id = '53167'
127 0.0001 9.10758972168E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
128 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
129 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
130 0.0004 0.000406980514526
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
131 0.0001 9.29832458496E-5
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
132 0.0001 9.20295715332E-5
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
133 0.0001 8.9168548584E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
134 0.0001 0.000117063522339
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
135 0.0001 8.89301300049E-5
UPDATE products SET price = '6995' WHERE id = '53186'
136 0.0001 9.51290130615E-5
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
137 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
138 0.0001 6.41345977783E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
139 0.0005 0.000514030456543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
140 0.0001 0.000127077102661
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
141 0.0001 0.00010085105896
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
142 0.0002 0.000154972076416
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0001 7.29560852051E-5
UPDATE products SET price = '1998' WHERE id = '53187'
144 0.0001 8.98838043213E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
145 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
146 0.0001 6.31809234619E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
147 0.0004 0.000430107116699
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
148 0.0001 0.000109910964966
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
149 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
150 0.0001 0.000143051147461
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0001 7.39097595215E-5
UPDATE products SET price = '2854' WHERE id = '53188'
152 0.0001 8.82148742676E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
153 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
154 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
155 0.0005 0.000464916229248
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
156 0.0001 9.51290130615E-5
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
157 0.0001 9.98973846436E-5
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
158 0.0001 0.000149011611938
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0001 7.29560852051E-5
UPDATE products SET price = '3597' WHERE id = '53196'
160 0.0002 0.000195980072021
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
161 0.0001 0.000144004821777
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
162 0.0004 0.000384092330933
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
163 0.0001 0.000148057937622
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
164 0.0001 0.000134944915771
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
165 0.0003 0.000283002853394
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
166 0.0003 0.000251054763794
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
167 0.0002 0.000216007232666
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
168 0.0003 0.000290870666504
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'