Houston Diamond District

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.0999789237976 170 0.0270 0


No Amazon API Requests Made.

Total time 0.0999789237976 seconds

Number Time From Start Name Description
1 0.0517799854279 Initialise Initialise FSB Function
2 0.0530869960785 App Controller Start Start of the App controller (called before the controller of every page)
3 0.0571489334106 Start of getCategoryListByGroup Function Before first category groups query
4 0.0573270320892 After initial query Before first category groups query
5 0.0573289394379 Get Category List for Group Before the call to getCategoryList function
6 0.0573320388794 Start of GetCategoryList function Start of the function
7 0.0573379993439 Before getting categories Query to get specific category list
8 0.0575468540192 After getting categories Query to get specific category list
9 0.0575478076935 Before getting category custom Before call to function getCategoryCustom
10 0.0586078166962 After getting category custom After call to function getCategoryCustom
11 0.0586109161377 Before getting category custom Before call to function getCategoryCustom
12 0.059473991394 After getting category custom After call to function getCategoryCustom
13 0.0594758987427 Before getting category custom Before call to function getCategoryCustom
14 0.0603139400482 After getting category custom After call to function getCategoryCustom
15 0.0603148937225 Before getting category custom Before call to function getCategoryCustom
16 0.0609378814697 After getting category custom After call to function getCategoryCustom
17 0.060938835144 End of GetCategoryList function End of the function
18 0.0609469413757 End of getCategoryListByGroup Function Before return()
19 0.0625429153442 App Controller End End of the App controller (called before the controller of every page)
20 0.0664768218994 App_after Controller Start Start of the App_after controller (called after the controller of every page)
21 0.0665309429169 Before Get Options Before the call to getOptions in the tpl class
22 0.0827188491821 After Get Options After the call to getOptions in the tpl class
23 0.0827670097351 App_after Controller End End of the App_after controller (called after the controller of every page)
24 0.0999619960785 Finalizing debug Before the debug is output to the page.
25 0.0999789237976 End of App This is the end of the app logging, final timestamp


Query Debug - 170 Database Queries. Total time 0.0270 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0004 0.000351905822754
SELECT parameter, value FROM parameters
2 0.0002 0.000177145004272
SELECT version FROM version ORDER BY installed DESC LIMIT 1
3 0.0002 0.000164985656738
SET time_zone = 'Europe/London'
4 0.0003 0.000265121459961
SELECT * FROM autorun ORDER BY lastrun ASC
5 0.0002 0.000173091888428
SELECT * FROM version ORDER BY installed DESC LIMIT 1
6 0.0002 0.000191926956177
SELECT id FROM pages WHERE pagename = 'houston-diamond-district' LIMIT 1
7 0.0002 0.000174045562744
SELECT id FROM products WHERE pagename = 'houston-diamond-district' AND hidden = 0 LIMIT 1
8 0.0001 0.000138998031616
SELECT id FROM categories WHERE pagename = 'houston-diamond-district' LIMIT 1
9 0.0002 0.0001540184021
SELECT id FROM manufacturers WHERE pagename = 'houston-diamond-district' LIMIT 1
10 0.0003 0.000345945358276
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
11 0.0029 0.00292086601257
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND language = 'en'
12 0.0002 0.000189781188965
SELECT * FROM pages WHERE pagename = 'houston-diamond-district'
13 0.0002 0.000162124633789
SELECT * FROM categorygroups ORDER BY sortorder ASC
14 0.0002 0.000189065933228
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '10'  AND hidden = 0 ORDER BY categorygroup_id ASC, sortorder ASC
15 0.0002 0.000223159790039
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.0001 0.000128030776978
SELECT id FROM categories WHERE parent_id = '67'
17 0.0002 0.000226020812988
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.0001 0.000127077102661
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.0001 0.000149011611938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '67'
20 0.0001 0.000128030776978
SELECT * FROM categorygroups WHERE id = '10'
21 0.0002 0.000197887420654
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.0001 0.0001380443573
SELECT id FROM categories WHERE parent_id = '68'
23 0.0002 0.000185966491699
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (68)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 AND offers > 0
24 0.0001 8.51154327393E-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
25 0.0001 9.67979431152E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '68'
26 0.0001 0.000101089477539
SELECT * FROM categorygroups WHERE id = '10'
27 0.0002 0.000172853469849
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.000100135803223
SELECT id FROM categories WHERE parent_id = '69'
29 0.0002 0.000180006027222
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.000109195709229
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.000118970870972
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '69'
32 0.0001 0.000102996826172
SELECT * FROM categorygroups WHERE id = '10'
33 0.0001 0.000133037567139
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 7.20024108887E-5
SELECT id FROM categories WHERE parent_id = '70'
35 0.0001 0.000124931335449
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 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 (70)
				  AND p.disabled = 0 AND offers > 0
37 0.0001 8.48770141602E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '70'
38 0.0001 7.39097595215E-5
SELECT * FROM categorygroups WHERE id = '10'
39 0.0002 0.00016188621521
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
40 0.0001 0.000119924545288
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.51290130615E-5
SELECT * FROM pages WHERE id = '37'
43 0.0001 8.20159912109E-5
SELECT * FROM pages WHERE id = '4'
44 0.0001 7.89165496826E-5
SELECT * FROM pages WHERE id = '34'
45 0.0001 7.79628753662E-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.89165496826E-5
SELECT * FROM pages WHERE id = '38'
49 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = '39'
50 0.0002 0.000185966491699
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
51 0.0001 0.000113010406494
SELECT * FROM manufacturers WHERE pagename = 'houston-diamond-district'
52 0.0001 7.48634338379E-5
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '449' LIMIT 1
53 0.0001 9.70363616943E-5
SELECT pagename, id FROM products p WHERE manufacturer_id = '449' ORDER BY RAND() LIMIT 1
54 0.0001 9.10758972168E-5
SELECT * FROM productimages WHERE product_id = '' ORDER BY sortorder ASC
55 0.0001 9.60826873779E-5
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '449'
56 0.0001 0.000103950500488
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '449'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 AND offers > 0
57 0.0001 7.58171081543E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '449'
58 0.0001 0.000118017196655
SELECT * FROM cachefiles WHERE identifier = '5e94162aa44be8e6f517ed3845e25cd1'
59 0.0001 0.000101089477539
DELETE FROM cachefiles WHERE identifier = '5e94162aa44be8e6f517ed3845e25cd1'
60 0.0002 0.000193119049072
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
61 0.0002 0.000159978866577
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
62 0.0001 0.000108003616333
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
63 0.0002 0.000182151794434
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
64 0.0002 0.000156879425049
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
65 0.0001 0.000109910964966
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
66 0.0001 9.58442687988E-5
SELECT COUNT(*) FROM products p
		WHERE manufacturer_id = 449
		AND parent_id = 0
		AND hidden = 0
		AND enabled = 1
		AND offers > 0
		AND 1 = 1
67 0.0001 0.000126838684082
SELECT * FROM products p
			WHERE	manufacturer_id = 449
			  AND	parent_id = 0
			  AND	hidden = 0
			  AND	enabled = 1
			  AND offers > 0
			  AND 	1 = 1 
			ORDER BY salesrank ASC
			LIMIT 0, 12
68 0.0001 7.79628753662E-5
SELECT * FROM manufacturerimages WHERE manufacturer_id = '449'
69 0.0001 8.98838043213E-5
SELECT * FROM template_info WHERE templateuid = 'fsbp-evolutionstore'
70 0.0001 8.48770141602E-5
SELECT * FROM pages WHERE id = 2
71 0.0001 8.10623168945E-5
SELECT * FROM pages WHERE id = 38
72 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 39
73 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 6
74 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 7
75 0.0001 7.70092010498E-5
SELECT * FROM pages WHERE id = 32
76 0.0001 8.01086425781E-5
SELECT * FROM pages WHERE id = 2
77 0.0001 7.79628753662E-5
SELECT * FROM pages WHERE id = 28
78 0.0001 8.08238983154E-5
SELECT * FROM pages WHERE id = 13
79 0.0001 7.5101852417E-5
SELECT * FROM pages WHERE id = 24
80 0.0002 0.000164985656738
SELECT * FROM products WHERE id IN (53167,53155,53186,53188,53187,53159,53162,53141,53196,53160)
81 0.0001 9.82284545898E-5
SELECT * FROM productimages WHERE product_id = '53141' ORDER BY sortorder ASC
82 0.0001 6.91413879395E-5
SELECT * FROM product_image_select WHERE product_id = '53141'
83 0.0001 6.38961791992E-5
SELECT * FROM productcustomimages WHERE product_id = '53141'
84 0.0005 0.000530004501343
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53141' AND a.name = n.originalname
85 0.0001 9.98973846436E-5
SELECT * FROM productoffers WHERE product_id = '53141' AND merchantid = 'ATVPDKIKX0DER'
86 0.0001 0.000103950500488
SELECT * FROM productoffers
				WHERE product_id = '53141' AND price > 0
				ORDER BY price ASC LIMIT 1
87 0.0002 0.000159978866577
SELECT value FROM productattributes WHERE product_id = '53141' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
88 0.0001 7.79628753662E-5
UPDATE products SET price = '44900' WHERE id = '53141'
89 0.0001 9.51290130615E-5
SELECT * FROM productimages WHERE product_id = '53155' ORDER BY sortorder ASC
90 0.0001 6.89029693604E-5
SELECT * FROM product_image_select WHERE product_id = '53155'
91 0.0001 6.48498535156E-5
SELECT * FROM productcustomimages WHERE product_id = '53155'
92 0.0004 0.000428915023804
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53155' AND a.name = n.originalname
93 0.0001 9.79900360107E-5
SELECT * FROM productoffers WHERE product_id = '53155' AND merchantid = 'ATVPDKIKX0DER'
94 0.0001 0.000102996826172
SELECT * FROM productoffers
				WHERE product_id = '53155' AND price > 0
				ORDER BY price ASC LIMIT 1
95 0.0002 0.000154972076416
SELECT value FROM productattributes WHERE product_id = '53155' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
96 0.0001 7.60555267334E-5
UPDATE products SET price = '1595' WHERE id = '53155'
97 0.0001 8.79764556885E-5
SELECT * FROM productimages WHERE product_id = '53159' ORDER BY sortorder ASC
98 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53159'
99 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53159'
100 0.0004 0.000447988510132
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53159' AND a.name = n.originalname
101 0.0001 0.000116109848022
SELECT * FROM productoffers WHERE product_id = '53159' AND merchantid = 'ATVPDKIKX0DER'
102 0.0001 0.000116109848022
SELECT * FROM productoffers
				WHERE product_id = '53159' AND price > 0
				ORDER BY price ASC LIMIT 1
103 0.0002 0.000161170959473
SELECT value FROM productattributes WHERE product_id = '53159' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
104 0.0001 7.5101852417E-5
UPDATE products SET price = '998' WHERE id = '53159'
105 0.0001 9.51290130615E-5
SELECT * FROM productimages WHERE product_id = '53160' ORDER BY sortorder ASC
106 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53160'
107 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53160'
108 0.0003 0.000335931777954
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53160' AND a.name = n.originalname
109 0.0001 9.48905944824E-5
SELECT * FROM productoffers WHERE product_id = '53160' AND merchantid = 'ATVPDKIKX0DER'
110 0.0001 0.000101804733276
SELECT * FROM productoffers
				WHERE product_id = '53160' AND price > 0
				ORDER BY price ASC LIMIT 1
111 0.0001 0.000137090682983
SELECT value FROM productattributes WHERE product_id = '53160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0001 7.41481781006E-5
UPDATE products SET price = '471' WHERE id = '53160'
113 0.0001 0.000103950500488
SELECT * FROM productimages WHERE product_id = '53162' ORDER BY sortorder ASC
114 0.0001 8.01086425781E-5
SELECT * FROM product_image_select WHERE product_id = '53162'
115 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53162'
116 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
117 0.0001 0.0001380443573
SELECT * FROM productoffers WHERE product_id = '53162' AND merchantid = 'ATVPDKIKX0DER'
118 0.0001 0.000139951705933
SELECT * FROM productoffers
				WHERE product_id = '53162' AND price > 0
				ORDER BY price ASC LIMIT 1
119 0.0002 0.000156879425049
SELECT value FROM productattributes WHERE product_id = '53162' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0001 9.98973846436E-5
UPDATE products SET price = '1510' WHERE id = '53162'
121 0.0001 9.70363616943E-5
SELECT * FROM productimages WHERE product_id = '53167' ORDER BY sortorder ASC
122 0.0001 6.79492950439E-5
SELECT * FROM product_image_select WHERE product_id = '53167'
123 0.0001 8.98838043213E-5
SELECT * FROM productcustomimages WHERE product_id = '53167'
124 0.0004 0.000443935394287
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53167' AND a.name = n.originalname
125 0.0001 0.000123023986816
SELECT * FROM productoffers WHERE product_id = '53167' AND merchantid = 'ATVPDKIKX0DER'
126 0.0001 0.000144958496094
SELECT * FROM productoffers
				WHERE product_id = '53167' AND price > 0
				ORDER BY price ASC LIMIT 1
127 0.0001 0.000130176544189
SELECT value FROM productattributes WHERE product_id = '53167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0001 7.29560852051E-5
UPDATE products SET price = '3395' WHERE id = '53167'
129 0.0001 8.70227813721E-5
SELECT * FROM productimages WHERE product_id = '53186' ORDER BY sortorder ASC
130 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53186'
131 0.0001 7.70092010498E-5
SELECT * FROM productcustomimages WHERE product_id = '53186'
132 0.0004 0.000419139862061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53186' AND a.name = n.originalname
133 0.0001 0.000104904174805
SELECT * FROM productoffers WHERE product_id = '53186' AND merchantid = 'ATVPDKIKX0DER'
134 0.0001 0.000106811523438
SELECT * FROM productoffers
				WHERE product_id = '53186' AND price > 0
				ORDER BY price ASC LIMIT 1
135 0.0001 8.9168548584E-5
SELECT * FROM productoffers
				WHERE product_id = 53186
				ORDER BY price ASC LIMIT 1
136 0.0001 0.00012993812561
SELECT value FROM productattributes
				WHERE product_id = '53186'
				AND name = 'ListPriceAmount'
137 0.0001 8.89301300049E-5
UPDATE products SET price = '6995' WHERE id = '53186'
138 0.0001 0.000134944915771
SELECT * FROM productimages WHERE product_id = '53187' ORDER BY sortorder ASC
139 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53187'
140 0.0001 8.89301300049E-5
SELECT * FROM productcustomimages WHERE product_id = '53187'
141 0.0006 0.000584125518799
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53187' AND a.name = n.originalname
142 0.0001 9.48905944824E-5
SELECT * FROM productoffers WHERE product_id = '53187' AND merchantid = 'ATVPDKIKX0DER'
143 0.0001 0.000101089477539
SELECT * FROM productoffers
				WHERE product_id = '53187' AND price > 0
				ORDER BY price ASC LIMIT 1
144 0.0002 0.0001540184021
SELECT value FROM productattributes WHERE product_id = '53187' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0001 7.48634338379E-5
UPDATE products SET price = '1998' WHERE id = '53187'
146 0.0001 8.89301300049E-5
SELECT * FROM productimages WHERE product_id = '53188' ORDER BY sortorder ASC
147 0.0001 8.08238983154E-5
SELECT * FROM product_image_select WHERE product_id = '53188'
148 0.0001 7.60555267334E-5
SELECT * FROM productcustomimages WHERE product_id = '53188'
149 0.0004 0.000425100326538
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53188' AND a.name = n.originalname
150 0.0001 0.000109195709229
SELECT * FROM productoffers WHERE product_id = '53188' AND merchantid = 'ATVPDKIKX0DER'
151 0.0001 0.000118970870972
SELECT * FROM productoffers
				WHERE product_id = '53188' AND price > 0
				ORDER BY price ASC LIMIT 1
152 0.0001 0.000141143798828
SELECT value FROM productattributes WHERE product_id = '53188' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0001 0.000101089477539
UPDATE products SET price = '2854' WHERE id = '53188'
154 0.0001 8.60691070557E-5
SELECT * FROM productimages WHERE product_id = '53196' ORDER BY sortorder ASC
155 0.0001 6.69956207275E-5
SELECT * FROM product_image_select WHERE product_id = '53196'
156 0.0001 6.29425048828E-5
SELECT * FROM productcustomimages WHERE product_id = '53196'
157 0.0005 0.000510931015015
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '53196' AND a.name = n.originalname
158 0.0001 0.000106811523438
SELECT * FROM productoffers WHERE product_id = '53196' AND merchantid = 'ATVPDKIKX0DER'
159 0.0001 0.000113964080811
SELECT * FROM productoffers
				WHERE product_id = '53196' AND price > 0
				ORDER BY price ASC LIMIT 1
160 0.0001 0.000149011611938
SELECT value FROM productattributes WHERE product_id = '53196' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0001 7.41481781006E-5
UPDATE products SET price = '3597' WHERE id = '53196'
162 0.0002 0.00016713142395
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'header' ORDER BY sortorder ASC
163 0.0001 0.000145196914673
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND area = 'footer' ORDER BY sortorder ASC
164 0.0004 0.000418901443481
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore' AND skinuid = ''
165 0.0002 0.000177145004272
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
166 0.0001 0.000134944915771
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsbp-evolutionstore'
167 0.0003 0.000319004058838
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
168 0.0003 0.000306129455566
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
169 0.0003 0.000281095504761
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'HEAD_LOGO'
170 0.0003 0.000307083129883
SELECT * FROM template_images WHERE templateuid = 'fsbp-evolutionstore' AND imageuid = 'FOOT_SECURE_PAYMENTS'