0

Rooibos Capetown Bio 200g

Price: €14,99
Product prices and availability are accurate as of 2022-06-22 16:55:30 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.
Availability: In Stock
En stock.
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
1.460305929184 250 0.9714 0


No Amazon API Requests Made.


App Debug - Total Time 1.460305929184 seconds

Number Time From Start Name Description
1 0.42273497581482 Initialise Initialise FSB Function
2 0.43377780914307 App Controller Start Start of the App controller (called before the controller of every page)
3 0.46799087524414 Start of getCategoryListByGroup Function Before first category groups query
4 0.46950101852417 After initial query Before first category groups query
5 0.46950197219849 Get Category List for Group Before the call to getCategoryList function
6 0.46950483322144 Start of GetCategoryList function Start of the function
7 0.46950888633728 Before getting categories Query to get specific category list
8 0.47196888923645 After getting categories Query to get specific category list
9 0.47196984291077 Before getting category custom Before call to function getCategoryCustom
10 0.49825286865234 After getting category custom After call to function getCategoryCustom
11 0.4982578754425 Before getting category custom Before call to function getCategoryCustom
12 0.51165294647217 After getting category custom After call to function getCategoryCustom
13 0.51165795326233 Before getting category custom Before call to function getCategoryCustom
14 0.51922392845154 After getting category custom After call to function getCategoryCustom
15 0.51922798156738 Before getting category custom Before call to function getCategoryCustom
16 0.52426481246948 After getting category custom After call to function getCategoryCustom
17 0.52426886558533 Before getting category custom Before call to function getCategoryCustom
18 0.52976584434509 After getting category custom After call to function getCategoryCustom
19 0.52977085113525 Before getting category custom Before call to function getCategoryCustom
20 0.53504490852356 After getting category custom After call to function getCategoryCustom
21 0.5350489616394 End of GetCategoryList function End of the function
22 0.53505682945251 Get Category List for Group Before the call to getCategoryList function
23 0.53505992889404 Start of GetCategoryList function Start of the function
24 0.53506302833557 Before getting categories Query to get specific category list
25 0.53561997413635 End of getCategoryListByGroup Function Before return()
26 1.1158969402313 App Controller End End of the App controller (called before the controller of every page)
27 1.1165969371796 Product Start Start of the product info controller
28 1.1552510261536 Cache file not found Starting get product details
29 1.2213459014893 Related products Start getting related products if enabled
30 1.2213490009308 Related Products Start Before the related products are found
31 1.2213499546051 Related Products Keywords Before the related product keywords are found
32 1.2213568687439 Create Keyword List Function Start of function
33 1.2214868068695 Create Keyword List Function After looping provided content - 9 keywords found
34 1.2220499515533 Create Keyword List Function After looping initial keyword list - 8 keywords remaining
35 1.2220590114594 Create Keyword List Function After reducing keyword list
36 1.2220778465271 Create Keyword List Function After selecting by scoring keywords
37 1.2220828533173 Create Keyword List Function After final loop of keywords
38 1.2220849990845 Related Products Keywords After the related product keywords are found
39 1.2861390113831 Related Products End After the related products are found
40 1.3324298858643 Product End End of the product info controller (Product Info)
41 1.3351140022278 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.337208032608 Before Get Options Before the call to getOptions in the tpl class
43 1.4172878265381 After Get Options After the call to getOptions in the tpl class
44 1.4174518585205 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4174838066101 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4281499385834 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4281549453735 Product Info: Before Template Display Before the template is displayed
48 1.4602718353271 Product Info: After Template Display After the template is displayed
49 1.4602890014648 Finalizing debug Before the debug is output to the page.
50 1.4603040218353 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 0.9714 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0018 0.0018458366394043
SELECT parameter, value FROM parameters
2 0.0084 0.0083630084991455
SELECT * FROM `bad_bots`
3 0.0005 0.00050997734069824
SET time_zone = 'Europe/London'
4 0.0038 0.0038039684295654
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0033 0.0032620429992676
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6 0.0034 0.0033500194549561
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739267243'
7 0.0039 0.0039088726043701
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00092792510986328
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0038 0.003777027130127
SELECT id FROM pages WHERE pagename = 'rooibos-capetown-bio-200g' LIMIT 1
10 0.0056 0.0056450366973877
SELECT id FROM products WHERE pagename = 'rooibos-capetown-bio-200g' AND hidden = 0 LIMIT 1
11 0.0045 0.0045418739318848
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0285 0.028537034988403
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00069904327392578
SELECT * FROM pages WHERE pagename = 'rooibos-capetown-bio-200g'
14 0.0015 0.0014991760253906
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0024 0.0024399757385254
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0070 0.0069839954376221
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.0026 0.002565860748291
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.0021 0.0020751953125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0008 0.00076603889465332
SELECT id FROM categories WHERE parent_id = '26'
20 0.0076 0.007551908493042
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.0020 0.0020401477813721
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.0020 0.0019710063934326
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.0016 0.0015559196472168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0006 0.00056314468383789
SELECT * FROM categorygroups WHERE id = '1'
25 0.0040 0.0039520263671875
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.0006 0.00064492225646973
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.0005 0.00052189826965332
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0006 0.00057601928710938
SELECT id FROM categories WHERE parent_id = '27'
29 0.0054 0.0054330825805664
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.0006 0.00055909156799316
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.0005 0.00053596496582031
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.0005 0.0005190372467041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.0004889965057373
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0017309188842773
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.0005 0.00054001808166504
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.0005 0.00046110153198242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00044798851013184
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.002047061920166
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.0006 0.00055098533630371
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.0005 0.00052213668823242
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.00069713592529297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00043106079101562
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00059318542480469
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.0005 0.00047802925109863
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.0005 0.00050020217895508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00052094459533691
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00066804885864258
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.0005 0.00051689147949219
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.00070405006408691
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.0005 0.00051593780517578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00043392181396484
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00058603286743164
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.0007 0.00069093704223633
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.0004 0.0003819465637207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0006 0.00061798095703125
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00094199180603027
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.0005 0.00054001808166504
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.0006 0.00063800811767578
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.0005 0.00053501129150391
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.0004570484161377
SELECT * FROM categorygroups WHERE id = '1'
61 0.0009 0.00090193748474121
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.0007 0.00068402290344238
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.00040507316589355
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00043082237243652
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.0007178783416748
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.00051307678222656
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.00049495697021484
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.00045490264892578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0006 0.00056290626525879
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00054502487182617
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0034 0.0033988952636719
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0014 0.0014419555664062
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00060391426086426
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.0013 0.0013470649719238
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0010 0.0010449886322021
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010828971862793
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5618 0.56177091598511
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.85') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.85') <= INET_ATON(ip_end)
78 0.0053 0.0053451061248779
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0021 0.0020589828491211
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0010 0.0010011196136475
SELECT * FROM products WHERE pagename = 'rooibos-capetown-bio-200g'
81 0.0009 0.0009150505065918
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1011
82 0.0013 0.0012569427490234
SELECT * FROM manufacturers WHERE id = '255'
83 0.0012 0.0011789798736572
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255'
84 0.0034 0.0033609867095947
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '255' LIMIT 1
85 0.0052 0.0052030086517334
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '255' ORDER BY RAND() LIMIT 1
86 0.0010 0.0010299682617188
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
87 0.0007 0.00065803527832031
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255'
88 0.0007 0.00074481964111328
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '255'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0008 0.00075292587280273
SELECT * FROM manufacturerimages WHERE manufacturer_id = '255'
90 0.0006 0.00061798095703125
SELECT category_id FROM products_categories WHERE product_id = '1011'
91 0.0007 0.00073504447937012
SELECT * FROM categories WHERE id = '27'
92 0.0070 0.0070490837097168
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.00056791305541992
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0005 0.00054693222045898
SELECT id FROM categories WHERE parent_id = '27'
95 0.0065 0.0064530372619629
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.0008 0.00077295303344727
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.0007 0.00071001052856445
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.0007 0.00067496299743652
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00070786476135254
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
100 0.0055 0.0054688453674316
SELECT * FROM product_image_select WHERE product_id = '1011'
101 0.0046 0.0045959949493408
SELECT * FROM productcustomimages WHERE product_id = '1011'
102 0.0028 0.0027811527252197
SELECT * FROM productfeeds WHERE product_id = '1011' ORDER BY item_date DESC
103 0.0075 0.0074620246887207
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0036 0.0035989284515381
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1011' AND t.hidden = 0 AND display_product = 1
105 0.0029 0.0028729438781738
SELECT * FROM productamazoncontent WHERE product_id = '1011'
106 0.0017 0.0016880035400391
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
107 0.0017 0.0017039775848389
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.0005490779876709
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0006 0.00064516067504883
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0007 0.00065898895263672
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
111 0.0129 0.012885093688965
SELECT *, MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AND 1011 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0011 0.0010659694671631
SELECT *, MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AND 1011 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0011 0.0011239051818848
SELECT *, MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos capetown bio' IN BOOLEAN MODE) AND 1011 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0018 0.0017910003662109
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
115 0.0016 0.00164794921875
SELECT * FROM product_image_select WHERE product_id = '858'
116 0.0009 0.00094008445739746
SELECT * FROM productcustomimages WHERE product_id = '858'
117 0.0051 0.0050899982452393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
118 0.0011 0.0010569095611572
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0008 0.00084495544433594
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0009 0.00092005729675293
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0012 0.0011918544769287
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
122 0.0013 0.0013229846954346
SELECT * FROM product_image_select WHERE product_id = '869'
123 0.0008 0.00075697898864746
SELECT * FROM productcustomimages WHERE product_id = '869'
124 0.0023 0.0022580623626709
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
125 0.0010 0.0010151863098145
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0008 0.00079011917114258
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0009 0.00088381767272949
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0011 0.001068115234375
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
129 0.0013 0.0013008117675781
SELECT * FROM product_image_select WHERE product_id = '862'
130 0.0017 0.0016579627990723
SELECT * FROM productcustomimages WHERE product_id = '862'
131 0.0024 0.0024139881134033
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
132 0.0008 0.0008080005645752
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0007 0.00066900253295898
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0007 0.00066995620727539
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0008 0.00081586837768555
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
136 0.0009 0.00086092948913574
SELECT * FROM product_image_select WHERE product_id = '890'
137 0.0006 0.00062298774719238
SELECT * FROM productcustomimages WHERE product_id = '890'
138 0.0017 0.0016510486602783
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
139 0.0007 0.00066804885864258
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00053906440734863
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0007 0.00065112113952637
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0007 0.00071597099304199
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0009 0.00092911720275879
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0006 0.00061893463134766
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0015 0.0015270709991455
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0006 0.00062704086303711
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0007 0.00065302848815918
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00052690505981445
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0006 0.00061607360839844
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
150 0.0009 0.00085115432739258
SELECT * FROM product_image_select WHERE product_id = '865'
151 0.0006 0.00058603286743164
SELECT * FROM productcustomimages WHERE product_id = '865'
152 0.0015 0.001539945602417
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
153 0.0007 0.00072097778320312
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0012 0.0011711120605469
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0011 0.0011031627655029
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0011 0.0011498928070068
SELECT id,asin FROM products WHERE parent_id = 1011
157 0.0059 0.0058591365814209
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
158 0.0010 0.00096607208251953
SELECT category_id FROM products_categories WHERE product_id = '1011'
159 0.0010 0.00097203254699707
SELECT * FROM categories WHERE id = '27'
160 0.0095 0.0094659328460693
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
161 0.0007 0.00069999694824219
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
162 0.0005 0.00052785873413086
SELECT id FROM categories WHERE parent_id = '27'
163 0.0064 0.0063619613647461
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 
164 0.0007 0.0007319450378418
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 
165 0.0008 0.00075387954711914
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
166 0.0006 0.00062179565429688
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
167 0.0015 0.0014708042144775
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
168 0.0007 0.00072693824768066
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0006 0.00060296058654785
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0007 0.0007021427154541
SELECT * FROM products WHERE id = '1011'
171 0.0006 0.00059390068054199
SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0009 0.00089788436889648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
173 0.0005 0.00045990943908691
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.0004267692565918
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00049901008605957
SELECT category_id FROM products_categories WHERE product_id = '1011' AND prod_type = 'amz'
176 0.0005 0.00047683715820312
SELECT parent_id FROM categories WHERE id = '27'
177 0.0004 0.00038695335388184
SELECT * FROM categories WHERE id = '27'
178 0.0041 0.0041060447692871
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
179 0.0005 0.00049495697021484
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
180 0.0005 0.00048995018005371
SELECT id FROM categories WHERE parent_id = '27'
181 0.0037 0.0036749839782715
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 
182 0.0006 0.00058698654174805
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 
183 0.0005 0.0005488395690918
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
184 0.0005 0.00053882598876953
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0019 0.0018589496612549
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
186 0.0016 0.0015740394592285
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0004 0.00041413307189941
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0142 0.014187812805176
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
189 0.0018 0.0018019676208496
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
190 0.0006 0.00055909156799316
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
191 0.0006 0.00059390068054199
SELECT * FROM products WHERE id = 1626
192 0.0007 0.00069689750671387
SELECT * FROM products WHERE id = 4041
193 0.0006 0.00058603286743164
SELECT * FROM products WHERE id = 4312
194 0.0006 0.00060796737670898
SELECT * FROM products WHERE id = 777
195 0.0007 0.00072813034057617
SELECT * FROM products WHERE id = 3881
196 0.0011 0.0010581016540527
SELECT * FROM products WHERE id = 4213
197 0.0006 0.00062394142150879
SELECT * FROM products WHERE id = '1626'
198 0.0008 0.00078892707824707
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
199 0.0007 0.00072503089904785
SELECT * FROM product_image_select WHERE product_id = '1626'
200 0.0005 0.00047397613525391
SELECT * FROM productcustomimages WHERE product_id = '1626'
201 0.0011 0.0010848045349121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
202 0.0006 0.00057506561279297
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0005 0.00053691864013672
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0008 0.00082588195800781
SELECT * FROM products WHERE id = '4041'
206 0.0006 0.00058507919311523
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
207 0.0007 0.00069093704223633
SELECT * FROM product_image_select WHERE product_id = '4041'
208 0.0006 0.00063705444335938
SELECT * FROM productcustomimages WHERE product_id = '4041'
209 0.0012 0.0011560916900635
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
210 0.0006 0.00061583518981934
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0007 0.00072598457336426
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0007 0.00067305564880371
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0006 0.0005950927734375
SELECT * FROM products WHERE id = '4312'
214 0.0019 0.001924991607666
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
215 0.0012 0.0011551380157471
SELECT * FROM product_image_select WHERE product_id = '4312'
216 0.0006 0.00061607360839844
SELECT * FROM productcustomimages WHERE product_id = '4312'
217 0.0012 0.001227855682373
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
218 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0006 0.00057506561279297
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00054812431335449
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00057792663574219
SELECT * FROM products WHERE id = '777'
222 0.0005 0.00048589706420898
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0006 0.00063705444335938
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0005 0.00052785873413086
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0011 0.0011000633239746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
226 0.0006 0.00057387351989746
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0004 0.00044393539428711
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0006 0.00062990188598633
SELECT * FROM products WHERE id = '3881'
230 0.0007 0.00071907043457031
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
231 0.0016 0.0015828609466553
SELECT * FROM product_image_select WHERE product_id = '3881'
232 0.0009 0.00089597702026367
SELECT * FROM productcustomimages WHERE product_id = '3881'
233 0.0032 0.003197193145752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
234 0.0013 0.001305103302002
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0009 0.00091814994812012
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0009 0.00091981887817383
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0019 0.0019040107727051
SELECT * FROM products WHERE id = '4213'
238 0.0016 0.0015759468078613
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
239 0.0015 0.0014870166778564
SELECT * FROM product_image_select WHERE product_id = '4213'
240 0.0008 0.0008389949798584
SELECT * FROM productcustomimages WHERE product_id = '4213'
241 0.0025 0.0025439262390137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
242 0.0008 0.00084400177001953
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0007 0.00065302848815918
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0007 0.00070500373840332
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0039 0.0038769245147705
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
246 0.0014 0.0014231204986572
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
247 0.0039 0.0039470195770264
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
248 0.0028 0.0027861595153809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
249 0.0009 0.00089120864868164
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0010 0.0010480880737305
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'