0

Rooibos

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6179959774017 347 1.1297 0


No Amazon API Requests Made.


App Debug - Total Time 1.6179959774017 seconds

Number Time From Start Name Description
1 0.42556095123291 Initialise Initialise FSB Function
2 0.44440698623657 App Controller Start Start of the App controller (called before the controller of every page)
3 0.47048687934875 Start of getCategoryListByGroup Function Before first category groups query
4 0.47182893753052 After initial query Before first category groups query
5 0.47182893753052 Get Category List for Group Before the call to getCategoryList function
6 0.47183084487915 Start of GetCategoryList function Start of the function
7 0.47183179855347 Before getting categories Query to get specific category list
8 0.47235488891602 After getting categories Query to get specific category list
9 0.47235488891602 Before getting category custom Before call to function getCategoryCustom
10 0.49022889137268 After getting category custom After call to function getCategoryCustom
11 0.49023079872131 Before getting category custom Before call to function getCategoryCustom
12 0.50095391273499 After getting category custom After call to function getCategoryCustom
13 0.50095582008362 Before getting category custom Before call to function getCategoryCustom
14 0.50735688209534 After getting category custom After call to function getCategoryCustom
15 0.50735783576965 Before getting category custom Before call to function getCategoryCustom
16 0.51227879524231 After getting category custom After call to function getCategoryCustom
17 0.51228094100952 Before getting category custom Before call to function getCategoryCustom
18 0.51714181900024 After getting category custom After call to function getCategoryCustom
19 0.51714396476746 Before getting category custom Before call to function getCategoryCustom
20 0.52199196815491 After getting category custom After call to function getCategoryCustom
21 0.52199482917786 End of GetCategoryList function End of the function
22 0.52199983596802 Get Category List for Group Before the call to getCategoryList function
23 0.52200198173523 Start of GetCategoryList function Start of the function
24 0.52200388908386 Before getting categories Query to get specific category list
25 0.52250099182129 End of getCategoryListByGroup Function Before return()
26 1.3223028182983 App Controller End End of the App controller (called before the controller of every page)
27 1.5123858451843 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 1.5139269828796 Before Get Options Before the call to getOptions in the tpl class
29 1.5690388679504 After Get Options After the call to getOptions in the tpl class
30 1.5690817832947 App_after Controller End End of the App_after controller (called after the controller of every page)
31 1.6179850101471 Finalizing debug Before the debug is output to the page.
32 1.6179947853088 End of App This is the end of the app logging, final timestamp


Query Debug - 347 Database Queries. Total time 1.1297 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0029 0.0029098987579346
SELECT parameter, value FROM parameters
2 0.0034 0.0034399032592773
SELECT * FROM `bad_bots`
3 0.0003 0.00025701522827148
SET time_zone = 'Europe/London'
4 0.0015 0.0014791488647461
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019090175628662
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.137.142.60\";}'
6 0.0016 0.0015609264373779
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747133694'
7 0.0041 0.0040981769561768
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00073599815368652
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0029 0.0028500556945801
SELECT id FROM pages WHERE pagename = 'tag' LIMIT 1
10 0.0040 0.0039639472961426
SELECT id FROM products WHERE pagename = 'tag' AND hidden = 0 LIMIT 1
11 0.0026 0.0026021003723145
SELECT id FROM ebay_products WHERE pagename = 'tag'
12 0.0021 0.0021400451660156
SELECT id FROM custom_products WHERE pagename = 'tag'
13 0.0015 0.0015230178833008
SELECT id FROM categories WHERE pagename = 'tag' LIMIT 1
14 0.0015 0.0014989376068115
SELECT id FROM manufacturers WHERE pagename = 'tag' LIMIT 1
15 0.0016 0.0016038417816162
SELECT id FROM bundles WHERE pagename = 'tag' LIMIT 1
16 0.0014 0.0013601779937744
SELECT id FROM tags WHERE pagename = 'rooibos' LIMIT 1
17 0.0020 0.0019521713256836
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
18 0.0232 0.023204803466797
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
19 0.0005 0.00054621696472168
SELECT * FROM pages WHERE pagename = 'tag'
20 0.0013 0.0013370513916016
SELECT * FROM categorygroups ORDER BY sortorder ASC
21 0.0005 0.00051379203796387
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
22 0.0067 0.0067138671875
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 = 26
23 0.0005 0.00052595138549805
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
24 0.0014 0.0013558864593506
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
25 0.0004 0.00042200088500977
SELECT id FROM categories WHERE parent_id = '26'
26 0.0057 0.0057320594787598
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
27 0.0005 0.00052189826965332
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
28 0.0006 0.00062799453735352
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
29 0.0015 0.001507043838501
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
30 0.0004 0.00039410591125488
SELECT * FROM categorygroups WHERE id = '1'
31 0.0036 0.0035979747772217
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 = 27
32 0.0005 0.00045490264892578
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
33 0.0004 0.00037693977355957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
34 0.0004 0.00039005279541016
SELECT id FROM categories WHERE parent_id = '27'
35 0.0036 0.0036380290985107
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
36 0.0006 0.00056004524230957
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
37 0.0007 0.00066518783569336
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
38 0.0006 0.00057101249694824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
39 0.0004 0.00043487548828125
SELECT * FROM categorygroups WHERE id = '1'
40 0.0015 0.0015327930450439
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 = 28
41 0.0005 0.00050210952758789
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
42 0.0005 0.00046014785766602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
43 0.0005 0.00046896934509277
SELECT id FROM categories WHERE parent_id = '28'
44 0.0015 0.0014908313751221
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
45 0.0005 0.00051379203796387
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
46 0.0005 0.00050091743469238
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
47 0.0005 0.00047612190246582
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
48 0.0004 0.00042104721069336
SELECT * FROM categorygroups WHERE id = '1'
49 0.0006 0.00064611434936523
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 = 29
50 0.0006 0.00058698654174805
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
51 0.0005 0.00047683715820312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
52 0.0005 0.00047206878662109
SELECT id FROM categories WHERE parent_id = '29'
53 0.0007 0.0006721019744873
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
54 0.0005 0.00049209594726562
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
55 0.0005 0.00048494338989258
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
56 0.0005 0.00050187110900879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
57 0.0006 0.00056195259094238
SELECT * FROM categorygroups WHERE id = '1'
58 0.0007 0.00067591667175293
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 = 30
59 0.0005 0.00050997734069824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
60 0.0004 0.00039505958557129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
61 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '30'
62 0.0007 0.00072193145751953
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
63 0.0005 0.00049901008605957
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
64 0.0006 0.00063204765319824
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
65 0.0006 0.00057506561279297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
66 0.0004 0.00041818618774414
SELECT * FROM categorygroups WHERE id = '1'
67 0.0006 0.00059413909912109
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 = 31
68 0.0005 0.00049281120300293
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
69 0.0004 0.00040197372436523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
70 0.0005 0.00051498413085938
SELECT id FROM categories WHERE parent_id = '31'
71 0.0008 0.00078701972961426
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
72 0.0005 0.00053501129150391
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
73 0.0005 0.00054502487182617
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
74 0.0005 0.00046491622924805
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
75 0.0005 0.00046181678771973
SELECT * FROM categorygroups WHERE id = '1'
76 0.0005 0.0004880428314209
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
77 0.0015 0.0015468597412109
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
78 0.0020 0.0019629001617432
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
79 0.0006 0.00060296058654785
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
80 0.0013 0.0012738704681396
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
81 0.0011 0.0010769367218018
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
82 0.0008 0.00081014633178711
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
83 0.7873 0.78730607032776
SELECT * FROM ipgeocountries WHERE INET_ATON('3.137.142.60') >= INET_ATON(ip_start) AND INET_ATON('3.137.142.60') <= INET_ATON(ip_end)
84 0.0022 0.0022158622741699
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
85 0.0012 0.0012259483337402
SELECT * FROM countryredirects WHERE countrycode = 'US'
86 0.0095 0.009519100189209
SELECT * FROM tags WHERE pagename = 'rooibos'
87 0.0152 0.015151023864746
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
88 0.0031 0.0030620098114014
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89 0.0045 0.0044758319854736
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
90 0.0074 0.0073790550231934
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
91 0.0020 0.0020139217376709
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
92 0.0006 0.00058794021606445
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
93 0.0026 0.0026311874389648
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND parent_id = 0 AND t.tag_id = '1' AND hidden = 0 AND enabled = 1  AND 1 = 1
94 0.0038 0.0037729740142822
SELECT DISTINCT(p.id), p.*, IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank FROM products p, product_tags t WHERE p.id = t.product_id AND p.parent_id = 0 AND t.tag_id = '1' AND hidden = 0 AND enabled = 1  AND 1 = 1 ORDER BY salesrank ASC LIMIT 72, 18
95 0.0014 0.0014369487762451
SELECT * FROM productimages WHERE product_id = '1443' ORDER BY sortorder ASC
96 0.0016 0.0015859603881836
SELECT * FROM product_image_select WHERE product_id = '1443'
97 0.0012 0.0012040138244629
SELECT * FROM productcustomimages WHERE product_id = '1443'
98 0.0021 0.0021071434020996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1443' AND a.name = n.originalname
99 0.0014 0.0013699531555176
SELECT * FROM productoffers WHERE product_id = '1443' AND merchantid = 'A1X6FK5RDHNB96'
100 0.0005 0.00053620338439941
SELECT * FROM productoffers
                WHERE product_id = '1443' AND price > 0
                ORDER BY price ASC LIMIT 1
101 0.0008 0.00078988075256348
SELECT value FROM productattributes WHERE product_id = '1443' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102 0.0005 0.00047492980957031
SELECT * FROM productimages WHERE product_id = '1447' ORDER BY sortorder ASC
103 0.0007 0.0006721019744873
SELECT * FROM product_image_select WHERE product_id = '1447'
104 0.0005 0.00047016143798828
SELECT * FROM productcustomimages WHERE product_id = '1447'
105 0.0013 0.0013129711151123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1447' AND a.name = n.originalname
106 0.0004 0.00044512748718262
SELECT * FROM productoffers WHERE product_id = '1447' AND merchantid = 'A1X6FK5RDHNB96'
107 0.0004 0.00041103363037109
SELECT * FROM productoffers
                WHERE product_id = '1447' AND price > 0
                ORDER BY price ASC LIMIT 1
108 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = 1447
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00040507316589355
SELECT value FROM productattributes
                WHERE product_id = '1447'
                AND name = 'ListPriceAmount'
110 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '1447' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0007 0.00069212913513184
SELECT * FROM productimages WHERE product_id = '1448' ORDER BY sortorder ASC
112 0.0006 0.00064611434936523
SELECT * FROM product_image_select WHERE product_id = '1448'
113 0.0004 0.00042486190795898
SELECT * FROM productcustomimages WHERE product_id = '1448'
114 0.0010 0.0010130405426025
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1448' AND a.name = n.originalname
115 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '1448' AND merchantid = 'A1X6FK5RDHNB96'
116 0.0004 0.00037407875061035
SELECT * FROM productoffers
                WHERE product_id = '1448' AND price > 0
                ORDER BY price ASC LIMIT 1
117 0.0003 0.00032901763916016
SELECT * FROM productoffers
                WHERE product_id = 1448
                ORDER BY price ASC LIMIT 1
118 0.0004 0.00037908554077148
SELECT value FROM productattributes
                WHERE product_id = '1448'
                AND name = 'ListPriceAmount'
119 0.0006 0.00063300132751465
SELECT value FROM productattributes WHERE product_id = '1448' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0005 0.00047993659973145
SELECT * FROM productimages WHERE product_id = '1460' ORDER BY sortorder ASC
121 0.0006 0.00061798095703125
SELECT * FROM product_image_select WHERE product_id = '1460'
122 0.0004 0.00044822692871094
SELECT * FROM productcustomimages WHERE product_id = '1460'
123 0.0013 0.0012600421905518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1460' AND a.name = n.originalname
124 0.0005 0.00046586990356445
SELECT * FROM productoffers WHERE product_id = '1460' AND merchantid = 'A1X6FK5RDHNB96'
125 0.0003 0.0003349781036377
SELECT * FROM productoffers
                WHERE product_id = '1460' AND price > 0
                ORDER BY price ASC LIMIT 1
126 0.0004 0.00035905838012695
SELECT * FROM productoffers
                WHERE product_id = 1460
                ORDER BY price ASC LIMIT 1
127 0.0004 0.0003659725189209
SELECT value FROM productattributes
                WHERE product_id = '1460'
                AND name = 'ListPriceAmount'
128 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '1460' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0004 0.00041103363037109
SELECT * FROM productimages WHERE product_id = '1461' ORDER BY sortorder ASC
130 0.0006 0.00061297416687012
SELECT * FROM product_image_select WHERE product_id = '1461'
131 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '1461'
132 0.0010 0.00097012519836426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1461' AND a.name = n.originalname
133 0.0004 0.0004119873046875
SELECT * FROM productoffers WHERE product_id = '1461' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00042510032653809
SELECT * FROM productoffers
                WHERE product_id = '1461' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0003 0.00032401084899902
SELECT * FROM productoffers
                WHERE product_id = 1461
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00036716461181641
SELECT value FROM productattributes
                WHERE product_id = '1461'
                AND name = 'ListPriceAmount'
137 0.0004 0.00042414665222168
SELECT value FROM productattributes WHERE product_id = '1461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0004 0.00041794776916504
SELECT * FROM productimages WHERE product_id = '1473' ORDER BY sortorder ASC
139 0.0005 0.00054621696472168
SELECT * FROM product_image_select WHERE product_id = '1473'
140 0.0004 0.00038003921508789
SELECT * FROM productcustomimages WHERE product_id = '1473'
141 0.0009 0.00094079971313477
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1473' AND a.name = n.originalname
142 0.0005 0.00050711631774902
SELECT * FROM productoffers WHERE product_id = '1473' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0003 0.00034308433532715
SELECT * FROM productoffers
                WHERE product_id = '1473' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0003 0.00029110908508301
SELECT * FROM productoffers
                WHERE product_id = 1473
                ORDER BY price ASC LIMIT 1
145 0.0003 0.00032997131347656
SELECT value FROM productattributes
                WHERE product_id = '1473'
                AND name = 'ListPriceAmount'
146 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '1473' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0004 0.00041007995605469
SELECT * FROM productimages WHERE product_id = '1668' ORDER BY sortorder ASC
148 0.0005 0.00053310394287109
SELECT * FROM product_image_select WHERE product_id = '1668'
149 0.0003 0.00033402442932129
SELECT * FROM productcustomimages WHERE product_id = '1668'
150 0.0007 0.00069093704223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1668' AND a.name = n.originalname
151 0.0004 0.00042390823364258
SELECT * FROM productoffers WHERE product_id = '1668' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0004 0.00040483474731445
SELECT * FROM productoffers
                WHERE product_id = '1668' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0003 0.00031089782714844
SELECT * FROM productoffers
                WHERE product_id = 1668
                ORDER BY price ASC LIMIT 1
154 0.0003 0.00033903121948242
SELECT value FROM productattributes
                WHERE product_id = '1668'
                AND name = 'ListPriceAmount'
155 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '1668' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0005 0.0004580020904541
SELECT * FROM productimages WHERE product_id = '3675' ORDER BY sortorder ASC
157 0.0006 0.00060415267944336
SELECT * FROM product_image_select WHERE product_id = '3675'
158 0.0005 0.0004570484161377
SELECT * FROM productcustomimages WHERE product_id = '3675'
159 0.0009 0.00093603134155273
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3675' AND a.name = n.originalname
160 0.0005 0.00050091743469238
SELECT * FROM productoffers WHERE product_id = '3675' AND merchantid = 'A1X6FK5RDHNB96'
161 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '3675' AND price > 0
                ORDER BY price ASC LIMIT 1
162 0.0004 0.00041913986206055
SELECT * FROM productoffers
                WHERE product_id = 3675
                ORDER BY price ASC LIMIT 1
163 0.0004 0.00042390823364258
SELECT value FROM productattributes
                WHERE product_id = '3675'
                AND name = 'ListPriceAmount'
164 0.0005 0.00049114227294922
SELECT value FROM productattributes WHERE product_id = '3675' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165 0.0005 0.00049591064453125
SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
166 0.0006 0.00060296058654785
SELECT * FROM product_image_select WHERE product_id = '3525'
167 0.0004 0.00040578842163086
SELECT * FROM productcustomimages WHERE product_id = '3525'
168 0.0008 0.00077605247497559
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
169 0.0006 0.00056290626525879
SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '3525' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0005 0.00049400329589844
SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0004 0.00044608116149902
SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
173 0.0005 0.00048589706420898
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
174 0.0006 0.00055098533630371
SELECT * FROM product_image_select WHERE product_id = '3578'
175 0.0004 0.00036096572875977
SELECT * FROM productcustomimages WHERE product_id = '3578'
176 0.0005 0.00048708915710449
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3578'
                GROUP BY o.product_id
177 0.0024 0.0024418830871582
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     = '3578'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
178 0.0005 0.00054287910461426
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
179 0.0008 0.00077199935913086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
180 0.0004 0.00035190582275391
SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00036907196044922
SELECT * FROM productoffers
                WHERE product_id = '3578' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = 3578
                ORDER BY price ASC LIMIT 1
183 0.0004 0.00037908554077148
SELECT value FROM productattributes
                WHERE product_id = '3578'
                AND name = 'ListPriceAmount'
184 0.0004 0.00044703483581543
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3578'
                GROUP BY o.product_id
185 0.0006 0.00061488151550293
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     = '3578'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
186 0.0004 0.00043487548828125
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
187 0.0006 0.00056791305541992
SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0004 0.00040197372436523
SELECT * FROM products WHERE parent_id = '3578'
189 0.0005 0.00053501129150391
SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
190 0.0006 0.00059795379638672
SELECT * FROM product_image_select WHERE product_id = '3587'
191 0.0004 0.00041103363037109
SELECT * FROM productcustomimages WHERE product_id = '3587'
192 0.0009 0.00089383125305176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
193 0.0005 0.0004570484161377
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
194 0.0005 0.0004580020904541
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
195 0.0006 0.00056982040405273
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196 0.0005 0.00054502487182617
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
197 0.0006 0.000640869140625
SELECT * FROM product_image_select WHERE product_id = '3588'
198 0.0009 0.00094103813171387
SELECT * FROM productcustomimages WHERE product_id = '3588'
199 0.0016 0.0016410350799561
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
200 0.0011 0.0011298656463623
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
201 0.0009 0.00087380409240723
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
202 0.0011 0.0011250972747803
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203 0.0012 0.0012249946594238
SELECT * FROM productimages WHERE product_id = '3626' ORDER BY sortorder ASC
204 0.0014 0.001439094543457
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3626' AND p.id = pi.product_id ORDER BY pi.sortorder
205 0.0016 0.0016160011291504
SELECT * FROM product_image_select WHERE product_id = '3626'
206 0.0009 0.00093698501586914
SELECT * FROM productcustomimages WHERE product_id = '3626'
207 0.0013 0.0013279914855957
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3626'
                GROUP BY o.product_id
208 0.0017 0.0016651153564453
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     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
209 0.0007 0.00066304206848145
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
210 0.0024 0.0024380683898926
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3626' AND a.name = n.originalname
211 0.0006 0.00058698654174805
SELECT * FROM productoffers WHERE product_id = '3626' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0006 0.00056290626525879
SELECT * FROM productoffers
                WHERE product_id = '3626' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0005 0.00054693222045898
SELECT * FROM productoffers
                WHERE product_id = 3626
                ORDER BY price ASC LIMIT 1
214 0.0006 0.00061798095703125
SELECT value FROM productattributes
                WHERE product_id = '3626'
                AND name = 'ListPriceAmount'
215 0.0007 0.00072193145751953
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '3626'
                GROUP BY o.product_id
216 0.0011 0.0011248588562012
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     = '3626'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
217 0.0006 0.0006258487701416
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
218 0.0010 0.00098395347595215
SELECT value FROM productattributes WHERE product_id = '3626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0012 0.0011551380157471
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3626'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
220 0.0006 0.00059819221496582
SELECT * FROM productimages WHERE product_id = '949' ORDER BY sortorder ASC
221 0.0007 0.00065422058105469
SELECT * FROM product_image_select WHERE product_id = '949'
222 0.0004 0.0004279613494873
SELECT * FROM productcustomimages WHERE product_id = '949'
223 0.0015 0.0014688968658447
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '949' AND a.name = n.originalname
224 0.0006 0.00057697296142578
SELECT * FROM productoffers WHERE product_id = '949' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0005 0.00045013427734375
SELECT * FROM productoffers
                WHERE product_id = '949' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = 949
                ORDER BY price ASC LIMIT 1
227 0.0004 0.00040102005004883
SELECT value FROM productattributes
                WHERE product_id = '949'
                AND name = 'ListPriceAmount'
228 0.0005 0.00051093101501465
SELECT value FROM productattributes WHERE product_id = '949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0006 0.00057506561279297
SELECT * FROM productimages WHERE product_id = '945' ORDER BY sortorder ASC
230 0.0007 0.00072193145751953
SELECT * FROM product_image_select WHERE product_id = '945'
231 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '945'
232 0.0008 0.00078701972961426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '945' AND a.name = n.originalname
233 0.0005 0.0005488395690918
SELECT * FROM productoffers WHERE product_id = '945' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '945' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0003 0.00033998489379883
SELECT * FROM productoffers
                WHERE product_id = 945
                ORDER BY price ASC LIMIT 1
236 0.0004 0.00044083595275879
SELECT value FROM productattributes
                WHERE product_id = '945'
                AND name = 'ListPriceAmount'
237 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '945' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0006 0.00056695938110352
SELECT * FROM productimages WHERE product_id = '3673' ORDER BY sortorder ASC
239 0.0006 0.00060391426086426
SELECT * FROM product_image_select WHERE product_id = '3673'
240 0.0004 0.00041985511779785
SELECT * FROM productcustomimages WHERE product_id = '3673'
241 0.0010 0.0010130405426025
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3673' AND a.name = n.originalname
242 0.0005 0.00049495697021484
SELECT * FROM productoffers WHERE product_id = '3673' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0004 0.00036811828613281
SELECT * FROM productoffers
                WHERE product_id = '3673' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0003 0.00031399726867676
SELECT * FROM productoffers
                WHERE product_id = 3673
                ORDER BY price ASC LIMIT 1
245 0.0003 0.00033211708068848
SELECT value FROM productattributes
                WHERE product_id = '3673'
                AND name = 'ListPriceAmount'
246 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '3673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0004 0.00041294097900391
SELECT * FROM productimages WHERE product_id = '3674' ORDER BY sortorder ASC
248 0.0006 0.00057601928710938
SELECT * FROM product_image_select WHERE product_id = '3674'
249 0.0004 0.00042009353637695
SELECT * FROM productcustomimages WHERE product_id = '3674'
250 0.0010 0.0010030269622803
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3674' AND a.name = n.originalname
251 0.0004 0.00044393539428711
SELECT * FROM productoffers WHERE product_id = '3674' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0004 0.00036787986755371
SELECT * FROM productoffers
                WHERE product_id = '3674' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0003 0.0003199577331543
SELECT * FROM productoffers
                WHERE product_id = 3674
                ORDER BY price ASC LIMIT 1
254 0.0004 0.00044989585876465
SELECT value FROM productattributes
                WHERE product_id = '3674'
                AND name = 'ListPriceAmount'
255 0.0005 0.00047397613525391
SELECT value FROM productattributes WHERE product_id = '3674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0005 0.00045990943908691
SELECT * FROM productimages WHERE product_id = '4222' ORDER BY sortorder ASC
257 0.0006 0.00055599212646484
SELECT * FROM product_image_select WHERE product_id = '4222'
258 0.0004 0.00035786628723145
SELECT * FROM productcustomimages WHERE product_id = '4222'
259 0.0010 0.0010159015655518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname
260 0.0004 0.00041794776916504
SELECT * FROM productoffers WHERE product_id = '4222' AND merchantid = 'A1X6FK5RDHNB96'
261 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '4222' AND price > 0
                ORDER BY price ASC LIMIT 1
262 0.0004 0.00040102005004883
SELECT value FROM productattributes WHERE product_id = '4222' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263 0.0016 0.0015859603881836
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1443' ORDER BY timestamp DESC
264 0.0003 0.00031185150146484
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1447' ORDER BY timestamp DESC
265 0.0003 0.00029301643371582
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1448' ORDER BY timestamp DESC
266 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1460' ORDER BY timestamp DESC
267 0.0003 0.00028204917907715
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1461' ORDER BY timestamp DESC
268 0.0003 0.00028300285339355
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1473' ORDER BY timestamp DESC
269 0.0003 0.00025606155395508
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1668' ORDER BY timestamp DESC
270 0.0003 0.0002741813659668
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3675' ORDER BY timestamp DESC
271 0.0003 0.00025296211242676
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3525' ORDER BY timestamp DESC
272 0.0003 0.00026392936706543
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3578' ORDER BY timestamp DESC
273 0.0002 0.00023484230041504
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3587' ORDER BY timestamp DESC
274 0.0002 0.00023603439331055
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3588' ORDER BY timestamp DESC
275 0.0003 0.0002598762512207
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3626' ORDER BY timestamp DESC
276 0.0003 0.00027298927307129
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '949' ORDER BY timestamp DESC
277 0.0003 0.00029492378234863
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '945' ORDER BY timestamp DESC
278 0.0003 0.00025796890258789
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3673' ORDER BY timestamp DESC
279 0.0003 0.00029301643371582
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3674' ORDER BY timestamp DESC
280 0.0003 0.00025510787963867
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4222' ORDER BY timestamp DESC
281 0.0014 0.0014100074768066
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
282 0.0011 0.0011298656463623
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
283 0.0004 0.00036311149597168
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
284 0.0130 0.012986898422241
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
285 0.0017 0.001666784286499
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
286 0.0005 0.00051498413085938
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
287 0.0005 0.0005028247833252
SELECT * FROM products WHERE id = 1626
288 0.0005 0.0004889965057373
SELECT * FROM products WHERE id = 4041
289 0.0005 0.00053095817565918
SELECT * FROM products WHERE id = 4312
290 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = 777
291 0.0005 0.00045418739318848
SELECT * FROM products WHERE id = 3881
292 0.0005 0.00050497055053711
SELECT * FROM products WHERE id = 4213
293 0.0004 0.00036406517028809
SELECT * FROM products WHERE id = '1626'
294 0.0006 0.00055408477783203
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
295 0.0007 0.00065493583679199
SELECT * FROM product_image_select WHERE product_id = '1626'
296 0.0005 0.00046801567077637
SELECT * FROM productcustomimages WHERE product_id = '1626'
297 0.0008 0.00084519386291504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
298 0.0005 0.00049185752868652
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
299 0.0004 0.00043916702270508
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
300 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0005 0.00050497055053711
SELECT * FROM products WHERE id = '4041'
302 0.0004 0.00043892860412598
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
303 0.0006 0.00063991546630859
SELECT * FROM product_image_select WHERE product_id = '4041'
304 0.0004 0.00041484832763672
SELECT * FROM productcustomimages WHERE product_id = '4041'
305 0.0010 0.0010459423065186
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
306 0.0006 0.0006101131439209
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
307 0.0006 0.00058603286743164
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
308 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309 0.0006 0.00060105323791504
SELECT * FROM products WHERE id = '4312'
310 0.0004 0.00043487548828125
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
311 0.0006 0.000640869140625
SELECT * FROM product_image_select WHERE product_id = '4312'
312 0.0005 0.00045585632324219
SELECT * FROM productcustomimages WHERE product_id = '4312'
313 0.0010 0.0010471343994141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
314 0.0008 0.00081110000610352
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
315 0.0004 0.00041913986206055
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
316 0.0004 0.00041294097900391
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317 0.0006 0.00062417984008789
SELECT * FROM products WHERE id = '777'
318 0.0006 0.00055098533630371
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
319 0.0007 0.00067400932312012
SELECT * FROM product_image_select WHERE product_id = '777'
320 0.0004 0.00038909912109375
SELECT * FROM productcustomimages WHERE product_id = '777'
321 0.0010 0.00099682807922363
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
322 0.0005 0.00046992301940918
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
323 0.0004 0.00043010711669922
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
324 0.0005 0.00046110153198242
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
325 0.0006 0.00055193901062012
SELECT * FROM products WHERE id = '3881'
326 0.0007 0.0006861686706543
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
327 0.0006 0.0006260871887207
SELECT * FROM product_image_select WHERE product_id = '3881'
328 0.0004 0.00041317939758301
SELECT * FROM productcustomimages WHERE product_id = '3881'
329 0.0011 0.0011179447174072
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
330 0.0005 0.00050878524780273
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
331 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
332 0.0005 0.00049686431884766
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
333 0.0006 0.00064897537231445
SELECT * FROM products WHERE id = '4213'
334 0.0008 0.0008080005645752
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
335 0.0006 0.00059819221496582
SELECT * FROM product_image_select WHERE product_id = '4213'
336 0.0004 0.00041007995605469
SELECT * FROM productcustomimages WHERE product_id = '4213'
337 0.0012 0.0011501312255859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
338 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
339 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
340 0.0005 0.000518798828125
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341 0.0019 0.0019121170043945
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
342 0.0007 0.00073409080505371
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
343 0.0024 0.0024349689483643
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
344 0.0016 0.0015809535980225
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
345 0.0005 0.00048708915710449
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
346 0.0013 0.0013489723205566
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
347 0.0011 0.0011310577392578
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'