0

Heath & Heather - Organic - Green Rooibos - 30g

Price: Click Button for Price
Product prices and availability are accurate as of 2022-05-26 21:33:16 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

There are no customer reviews yet. Be the first to Write a Review!

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
2.9314420223236 259 0.9421 0


No Amazon API Requests Made.


App Debug - Total Time 2.9314420223236 seconds

Number Time From Start Name Description
1 1.9300391674042 Initialise Initialise FSB Function
2 1.9435040950775 App Controller Start Start of the App controller (called before the controller of every page)
3 1.9781370162964 Start of getCategoryListByGroup Function Before first category groups query
4 1.9805171489716 After initial query Before first category groups query
5 1.9805190563202 Get Category List for Group Before the call to getCategoryList function
6 1.9805221557617 Start of GetCategoryList function Start of the function
7 1.9805262088776 Before getting categories Query to get specific category list
8 1.982773065567 After getting categories Query to get specific category list
9 1.9827740192413 Before getting category custom Before call to function getCategoryCustom
10 2.0186080932617 After getting category custom After call to function getCategoryCustom
11 2.0186131000519 Before getting category custom Before call to function getCategoryCustom
12 2.0581459999084 After getting category custom After call to function getCategoryCustom
13 2.0581510066986 Before getting category custom Before call to function getCategoryCustom
14 2.0704810619354 After getting category custom After call to function getCategoryCustom
15 2.0704832077026 Before getting category custom Before call to function getCategoryCustom
16 2.076758146286 After getting category custom After call to function getCategoryCustom
17 2.076761007309 Before getting category custom Before call to function getCategoryCustom
18 2.0825791358948 After getting category custom After call to function getCategoryCustom
19 2.0825810432434 Before getting category custom Before call to function getCategoryCustom
20 2.0874421596527 After getting category custom After call to function getCategoryCustom
21 2.0874450206757 End of GetCategoryList function End of the function
22 2.0874512195587 Get Category List for Group Before the call to getCategoryList function
23 2.0874540805817 Start of GetCategoryList function Start of the function
24 2.0874571800232 Before getting categories Query to get specific category list
25 2.0879981517792 End of getCategoryListByGroup Function Before return()
26 2.6691241264343 App Controller End End of the App controller (called before the controller of every page)
27 2.6700410842896 Product Start Start of the product info controller
28 2.6849451065063 Cache file not found Starting get product details
29 2.7259931564331 Related products Start getting related products if enabled
30 2.7259950637817 Related Products Start Before the related products are found
31 2.7259960174561 Related Products Keywords Before the related product keywords are found
32 2.7260010242462 Create Keyword List Function Start of function
33 2.7260980606079 Create Keyword List Function After looping provided content - 18 keywords found
34 2.7269191741943 Create Keyword List Function After looping initial keyword list - 17 keywords remaining
35 2.7269260883331 Create Keyword List Function After reducing keyword list
36 2.7269620895386 Create Keyword List Function After selecting by scoring keywords
37 2.7269651889801 Create Keyword List Function After final loop of keywords
38 2.7269680500031 Related Products Keywords After the related product keywords are found
39 2.7768151760101 Related Products End After the related products are found
40 2.8086411952972 Product End End of the product info controller (Product Info)
41 2.8114051818848 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.8133730888367 Before Get Options Before the call to getOptions in the tpl class
43 2.8763780593872 After Get Options After the call to getOptions in the tpl class
44 2.8765451908112 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.8765780925751 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.8927850723267 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.8927900791168 Product Info: Before Template Display Before the template is displayed
48 2.9314172267914 Product Info: After Template Display After the template is displayed
49 2.9314291477203 Finalizing debug Before the debug is output to the page.
50 2.9314410686493 End of App This is the end of the app logging, final timestamp


Query Debug - 259 Database Queries. Total time 0.9421 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0021588802337646
SELECT parameter, value FROM parameters
2 0.0060 0.006026029586792
SELECT * FROM `bad_bots`
3 0.0004 0.00039911270141602
SET time_zone = 'Europe/London'
4 0.0020 0.002032995223999
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0023 0.002295970916748
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.145.172.206\";}'
6 0.0023 0.002288818359375
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734792650'
7 0.0052 0.0052289962768555
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0012 0.0011570453643799
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0041 0.0040550231933594
SELECT id FROM pages WHERE pagename = 'heath-heather-organic-green-rooibos-30g' LIMIT 1
10 0.0073 0.0072858333587646
SELECT id FROM products WHERE pagename = 'heath-heather-organic-green-rooibos-30g' AND hidden = 0 LIMIT 1
11 0.0043 0.0042741298675537
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0290 0.028995990753174
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00073981285095215
SELECT * FROM pages WHERE pagename = 'heath-heather-organic-green-rooibos-30g'
14 0.0024 0.0023679733276367
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0022 0.002223014831543
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0116 0.011565923690796
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
17 0.0037 0.0036590099334717
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0015 0.0014779567718506
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00051498413085938
SELECT id FROM categories WHERE parent_id = '26'
20 0.0063 0.0063059329986572
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 
21 0.0021 0.0020780563354492
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 
22 0.0021 0.0020790100097656
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
23 0.0040 0.004040002822876
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0040 0.0039710998535156
SELECT * FROM categorygroups WHERE id = '1'
25 0.0217 0.021728992462158
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
26 0.0014 0.0014379024505615
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0009 0.00089788436889648
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0009 0.0008552074432373
SELECT id FROM categories WHERE parent_id = '27'
29 0.0099 0.0099358558654785
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 
30 0.0012 0.0012249946594238
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 
31 0.0013 0.0013229846954346
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
32 0.0011 0.001086950302124
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0009 0.00087594985961914
SELECT * FROM categorygroups WHERE id = '1'
34 0.0041 0.0040860176086426
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
35 0.0009 0.00087714195251465
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0006 0.00060296058654785
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.00062203407287598
SELECT id FROM categories WHERE parent_id = '28'
38 0.0030 0.0030159950256348
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 
39 0.0008 0.00076389312744141
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 
40 0.0009 0.00087118148803711
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
41 0.0007 0.00073695182800293
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0007 0.00065493583679199
SELECT * FROM categorygroups WHERE id = '1'
43 0.0010 0.0010011196136475
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
44 0.0007 0.00069713592529297
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0006 0.00060915946960449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00049209594726562
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00091099739074707
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 
48 0.0007 0.00065398216247559
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 
49 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 (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0006 0.00055289268493652
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00058507919311523
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00078892707824707
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
53 0.0005 0.00054502487182617
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0005 0.00048089027404785
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00049209594726562
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00084614753723145
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 
57 0.0006 0.00064516067504883
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 
58 0.0007 0.00066113471984863
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
59 0.0006 0.00062704086303711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00064206123352051
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00074481964111328
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
62 0.0005 0.00049209594726562
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.0004119873046875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00045394897460938
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00073909759521484
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 
66 0.0005 0.00048398971557617
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 
67 0.0005 0.00052809715270996
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
68 0.0005 0.00048995018005371
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00043797492980957
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00052809715270996
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0031 0.0031108856201172
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0017 0.0017271041870117
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00067496299743652
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
74 0.0016 0.0015978813171387
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0012080669403076
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0013 0.0012571811676025
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5655 0.5654718875885
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.172.206') >= INET_ATON(ip_start) AND INET_ATON('3.145.172.206') <= INET_ATON(ip_end)
78 0.0024 0.0024449825286865
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0014338493347168
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00069618225097656
SELECT * FROM products WHERE pagename = 'heath-heather-organic-green-rooibos-30g'
81 0.0005 0.00049209594726562
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1258
82 0.0007 0.00074601173400879
SELECT * FROM manufacturers WHERE id = '294'
83 0.0006 0.00056695938110352
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
84 0.0024 0.0023610591888428
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '294' LIMIT 1
85 0.0026 0.0026350021362305
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '294' ORDER BY RAND() LIMIT 1
86 0.0006 0.00059008598327637
SELECT * FROM productimages WHERE product_id = '2517' ORDER BY sortorder ASC
87 0.0006 0.0006098747253418
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
88 0.0006 0.00058698654174805
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '294'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0006 0.0005648136138916
SELECT * FROM manufacturerimages WHERE manufacturer_id = '294'
90 0.0006 0.00059413909912109
SELECT category_id FROM products_categories WHERE product_id = '1258'
91 0.0007 0.00074100494384766
SELECT * FROM categories WHERE id = '27'
92 0.0055 0.005518913269043
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
93 0.0006 0.00057315826416016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.0004119873046875
SELECT id FROM categories WHERE parent_id = '27'
95 0.0053 0.0053260326385498
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 
96 0.0006 0.00057101249694824
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 
97 0.0006 0.00060796737670898
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
98 0.0005 0.00051116943359375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00048589706420898
SELECT * FROM productimages WHERE product_id = '1258' ORDER BY sortorder ASC
100 0.0023 0.0023410320281982
SELECT * FROM product_image_select WHERE product_id = '1258'
101 0.0014 0.0013809204101562
SELECT * FROM productcustomimages WHERE product_id = '1258'
102 0.0014 0.0013699531555176
SELECT * FROM productfeeds WHERE product_id = '1258' ORDER BY item_date DESC
103 0.0025 0.0025379657745361
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0024 0.0024490356445312
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1258' AND t.hidden = 0 AND display_product = 1
105 0.0015 0.0014510154724121
SELECT * FROM productamazoncontent WHERE product_id = '1258'
106 0.0009 0.0009160041809082
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname
107 0.0017 0.0016539096832275
SELECT * FROM productoffers WHERE product_id = '1258' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00041604042053223
SELECT * FROM productoffers
                WHERE product_id = '1258' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = 1258
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00053787231445312
SELECT value FROM productattributes
                WHERE product_id = '1258'
                AND name = 'ListPriceAmount'
111 0.0005 0.00045418739318848
SELECT value FROM productattributes WHERE product_id = '1258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.00054216384887695
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
113 0.0095 0.0094978809356689
SELECT *, MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AND 1258 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0007 0.0007171630859375
SELECT *, MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AND 1258 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00070381164550781
SELECT *, MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('andamp heather organic' IN BOOLEAN MODE) AND 1258 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0006 0.0005640983581543
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
117 0.0007 0.00065302848815918
SELECT * FROM product_image_select WHERE product_id = '938'
118 0.0005 0.00048303604125977
SELECT * FROM productcustomimages WHERE product_id = '938'
119 0.0009 0.00093889236450195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
120 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0007 0.0006711483001709
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0006 0.00058412551879883
SELECT * FROM productimages WHERE product_id = '1089' ORDER BY sortorder ASC
124 0.0007 0.00073909759521484
SELECT * FROM product_image_select WHERE product_id = '1089'
125 0.0005 0.00049209594726562
SELECT * FROM productcustomimages WHERE product_id = '1089'
126 0.0011 0.0010621547698975
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1089' AND a.name = n.originalname
127 0.0005 0.0005490779876709
SELECT * FROM productoffers WHERE product_id = '1089' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '1089' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0004 0.00043988227844238
SELECT value FROM productattributes WHERE product_id = '1089' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0101 0.010145902633667
SELECT *, MATCH (description, title) AGAINST ('organic green rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('organic green rooibos' IN BOOLEAN MODE) AND 1258 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
131 0.0007 0.00072312355041504
SELECT *, MATCH (description, title) AGAINST ('organic green rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('organic green rooibos' IN BOOLEAN MODE) AND 1258 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
132 0.0008 0.00076508522033691
SELECT *, MATCH (description, title) AGAINST ('organic green rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('organic green rooibos' IN BOOLEAN MODE) AND 1258 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
133 0.0006 0.00062203407287598
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
134 0.0006 0.00063800811767578
SELECT * FROM product_image_select WHERE product_id = '858'
135 0.0005 0.00048112869262695
SELECT * FROM productcustomimages WHERE product_id = '858'
136 0.0012 0.0012168884277344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
137 0.0005 0.00053119659423828
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0007 0.00065803527832031
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0005 0.00046706199645996
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0005 0.00053095817565918
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
141 0.0007 0.00065183639526367
SELECT * FROM product_image_select WHERE product_id = '865'
142 0.0005 0.00047492980957031
SELECT * FROM productcustomimages WHERE product_id = '865'
143 0.0009 0.0008540153503418
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
144 0.0006 0.00057291984558105
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0007 0.00065803527832031
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0006 0.00062084197998047
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
148 0.0006 0.00062990188598633
SELECT * FROM product_image_select WHERE product_id = '862'
149 0.0005 0.00049805641174316
SELECT * FROM productcustomimages WHERE product_id = '862'
150 0.0009 0.00094103813171387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
151 0.0005 0.00052285194396973
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0005 0.0004730224609375
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0006 0.00057697296142578
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
155 0.0007 0.00068306922912598
SELECT * FROM product_image_select WHERE product_id = '878'
156 0.0005 0.00054383277893066
SELECT * FROM productcustomimages WHERE product_id = '878'
157 0.0010 0.0010209083557129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
158 0.0005 0.00052714347839355
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0006 0.00064992904663086
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0005 0.00048303604125977
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00051307678222656
SELECT id,asin FROM products WHERE parent_id = 1258
162 0.0018 0.0018050670623779
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1258' ORDER BY timestamp DESC
163 0.0005 0.00052094459533691
SELECT category_id FROM products_categories WHERE product_id = '1258'
164 0.0005 0.00052785873413086
SELECT * FROM categories WHERE id = '27'
165 0.0040 0.0040490627288818
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
166 0.0006 0.00055289268493652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0004 0.00038504600524902
SELECT id FROM categories WHERE parent_id = '27'
168 0.0038 0.0037660598754883
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 
169 0.0006 0.00062799453735352
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 
170 0.0006 0.00064802169799805
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
171 0.0005 0.00049710273742676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0009 0.00088405609130859
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname
173 0.0005 0.00054311752319336
SELECT * FROM productoffers WHERE product_id = '1258' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.0004570484161377
SELECT * FROM productoffers
                WHERE product_id = '1258' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = 1258
                ORDER BY price ASC LIMIT 1
176 0.0004 0.00044703483581543
SELECT value FROM productattributes
                WHERE product_id = '1258'
                AND name = 'ListPriceAmount'
177 0.0006 0.0006401538848877
SELECT * FROM products WHERE id = '1258'
178 0.0006 0.00057482719421387
SELECT value FROM productattributes WHERE product_id = '1258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179 0.0008 0.00084590911865234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1258' AND a.name = n.originalname
180 0.0004 0.00044107437133789
SELECT * FROM productoffers WHERE product_id = '1258' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0004 0.00042915344238281
SELECT * FROM productoffers
                WHERE product_id = '1258' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = 1258
                ORDER BY price ASC LIMIT 1
183 0.0005 0.0004580020904541
SELECT value FROM productattributes
                WHERE product_id = '1258'
                AND name = 'ListPriceAmount'
184 0.0005 0.00052809715270996
SELECT category_id FROM products_categories WHERE product_id = '1258' AND prod_type = 'amz'
185 0.0004 0.00044798851013184
SELECT parent_id FROM categories WHERE id = '27'
186 0.0004 0.00037407875061035
SELECT * FROM categories WHERE id = '27'
187 0.0035 0.0035200119018555
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
188 0.0005 0.00049400329589844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
189 0.0004 0.00035786628723145
SELECT id FROM categories WHERE parent_id = '27'
190 0.0034 0.0034389495849609
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 
191 0.0006 0.00061798095703125
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 
192 0.0006 0.00061607360839844
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
193 0.0005 0.00049686431884766
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
194 0.0019 0.001910924911499
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
195 0.0014 0.0013751983642578
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
196 0.0005 0.00049781799316406
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
197 0.0128 0.012835025787354
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
198 0.0023 0.0023078918457031
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
199 0.0007 0.00070285797119141
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
200 0.0007 0.00067806243896484
SELECT * FROM products WHERE id = 1626
201 0.0005 0.00050806999206543
SELECT * FROM products WHERE id = 4041
202 0.0005 0.00046992301940918
SELECT * FROM products WHERE id = 4312
203 0.0005 0.00047898292541504
SELECT * FROM products WHERE id = 777
204 0.0005 0.00047802925109863
SELECT * FROM products WHERE id = 3881
205 0.0005 0.00050497055053711
SELECT * FROM products WHERE id = 4213
206 0.0004 0.00043892860412598
SELECT * FROM products WHERE id = '1626'
207 0.0006 0.00056910514831543
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
208 0.0015 0.0015411376953125
SELECT * FROM product_image_select WHERE product_id = '1626'
209 0.0005 0.00048708915710449
SELECT * FROM productcustomimages WHERE product_id = '1626'
210 0.0009 0.00094103813171387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
211 0.0006 0.00060200691223145
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0007 0.00066781044006348
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0006 0.00063991546630859
SELECT * FROM products WHERE id = '4041'
215 0.0005 0.00052499771118164
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
216 0.0006 0.00064587593078613
SELECT * FROM product_image_select WHERE product_id = '4041'
217 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '4041'
218 0.0012 0.0012261867523193
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
219 0.0005 0.0005490779876709
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0007 0.00066804885864258
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0005 0.00051403045654297
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0006 0.00064301490783691
SELECT * FROM products WHERE id = '4312'
223 0.0006 0.00055217742919922
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
224 0.0007 0.00072908401489258
SELECT * FROM product_image_select WHERE product_id = '4312'
225 0.0005 0.00049614906311035
SELECT * FROM productcustomimages WHERE product_id = '4312'
226 0.0012 0.0012109279632568
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
227 0.0005 0.00050783157348633
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0007 0.00068807601928711
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0006 0.00062203407287598
SELECT * FROM products WHERE id = '777'
231 0.0005 0.00053906440734863
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
232 0.0008 0.00078105926513672
SELECT * FROM product_image_select WHERE product_id = '777'
233 0.0004 0.00043916702270508
SELECT * FROM productcustomimages WHERE product_id = '777'
234 0.0011 0.0010998249053955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
235 0.0006 0.00055384635925293
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0006 0.00064492225646973
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0005 0.00049209594726562
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0006 0.00062894821166992
SELECT * FROM products WHERE id = '3881'
239 0.0006 0.00059986114501953
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
240 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '3881'
241 0.0006 0.0005791187286377
SELECT * FROM productcustomimages WHERE product_id = '3881'
242 0.0012 0.0011990070343018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
243 0.0006 0.00056290626525879
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0007 0.0006861686706543
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0006 0.00064301490783691
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0007 0.00069785118103027
SELECT * FROM products WHERE id = '4213'
247 0.0007 0.00068402290344238
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
248 0.0007 0.00068092346191406
SELECT * FROM product_image_select WHERE product_id = '4213'
249 0.0005 0.00048089027404785
SELECT * FROM productcustomimages WHERE product_id = '4213'
250 0.0013 0.0013449192047119
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
251 0.0006 0.00058794021606445
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
252 0.0006 0.0005800724029541
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
253 0.0005 0.00050497055053711
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254 0.0025 0.0024650096893311
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
255 0.0008 0.0007779598236084
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
256 0.0030 0.0030021667480469
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
257 0.0020 0.0019950866699219
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
258 0.0006 0.00061798095703125
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0012 0.0011658668518066
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'