0

Thé Rouge Rooibos Afrique Bio 1 kg

Price: €29,97
Product prices and availability are accurate as of 2022-06-24 07:17:09 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.

Product Features

Thé rouge Rooibos nature issu de l'Agriculture Biologique d'une plantation en Afrique du Sud. Nom latin : Aspalathus Linearis Le Rooibos ne contient ni Caféine, ni Théine. Le Rooibos ne contient ni Caféine, ni Théine. Il est idéal à tout moment de la journée. Conditionné dans un double sachet zip transparent contenant au total 1 kg de Rooibos Les produits ChaBioThé sont certifiés Bio par Ecocert - Produit conditionné à Lyon et soigneusement sélectionné

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.3111970424652 255 0.9363 0


No Amazon API Requests Made.


App Debug - Total Time 1.3111970424652 seconds

Number Time From Start Name Description
1 0.33498096466064 Initialise Initialise FSB Function
2 0.35195088386536 App Controller Start Start of the App controller (called before the controller of every page)
3 0.3938410282135 Start of getCategoryListByGroup Function Before first category groups query
4 0.39560389518738 After initial query Before first category groups query
5 0.39560604095459 Get Category List for Group Before the call to getCategoryList function
6 0.39560985565186 Start of GetCategoryList function Start of the function
7 0.3956139087677 Before getting categories Query to get specific category list
8 0.39770889282227 After getting categories Query to get specific category list
9 0.39771103858948 Before getting category custom Before call to function getCategoryCustom
10 0.42123103141785 After getting category custom After call to function getCategoryCustom
11 0.42123603820801 Before getting category custom Before call to function getCategoryCustom
12 0.43491005897522 After getting category custom After call to function getCategoryCustom
13 0.43491506576538 Before getting category custom Before call to function getCategoryCustom
14 0.44259285926819 After getting category custom After call to function getCategoryCustom
15 0.44259691238403 Before getting category custom Before call to function getCategoryCustom
16 0.44837188720703 After getting category custom After call to function getCategoryCustom
17 0.44837594032288 Before getting category custom Before call to function getCategoryCustom
18 0.45486998558044 After getting category custom After call to function getCategoryCustom
19 0.45487499237061 Before getting category custom Before call to function getCategoryCustom
20 0.46242189407349 After getting category custom After call to function getCategoryCustom
21 0.46242690086365 End of GetCategoryList function End of the function
22 0.46243786811829 Get Category List for Group Before the call to getCategoryList function
23 0.46244192123413 Start of GetCategoryList function Start of the function
24 0.46244597434998 Before getting categories Query to get specific category list
25 0.4632260799408 End of getCategoryListByGroup Function Before return()
26 1.0206480026245 App Controller End End of the App controller (called before the controller of every page)
27 1.0213558673859 Product Start Start of the product info controller
28 1.0233390331268 Cache file not found Starting get product details
29 1.0720338821411 Related products Start getting related products if enabled
30 1.0720360279083 Related Products Start Before the related products are found
31 1.072037935257 Related Products Keywords Before the related product keywords are found
32 1.0720419883728 Create Keyword List Function Start of function
33 1.0721139907837 Create Keyword List Function After looping provided content - 18 keywords found
34 1.0727908611298 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.0727980136871 Create Keyword List Function After reducing keyword list
36 1.0728280544281 Create Keyword List Function After selecting by scoring keywords
37 1.0728318691254 Create Keyword List Function After final loop of keywords
38 1.0728340148926 Related Products Keywords After the related product keywords are found
39 1.1157109737396 Related Products End After the related products are found
40 1.1471049785614 Product End End of the product info controller (Product Info)
41 1.1498870849609 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.1516618728638 Before Get Options Before the call to getOptions in the tpl class
43 1.2527170181274 After Get Options After the call to getOptions in the tpl class
44 1.2528848648071 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.2529199123383 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.2648038864136 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.2648088932037 Product Info: Before Template Display Before the template is displayed
48 1.3111748695374 Product Info: After Template Display After the template is displayed
49 1.3111848831177 Finalizing debug Before the debug is output to the page.
50 1.311194896698 End of App This is the end of the app logging, final timestamp


Query Debug - 255 Database Queries. Total time 0.9363 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022017955780029
SELECT parameter, value FROM parameters
2 0.0110 0.011039018630981
SELECT * FROM `bad_bots`
3 0.0006 0.00062799453735352
SET time_zone = 'Europe/London'
4 0.0042 0.0041599273681641
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0042 0.0042130947113037
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6 0.0037 0.0036611557006836
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739262837'
7 0.0053 0.0053369998931885
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.0010058879852295
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0072 0.0072338581085205
SELECT id FROM pages WHERE pagename = 'the-rouge-rooibos-afrique-bio-1-kg' LIMIT 1
10 0.0078 0.0077571868896484
SELECT id FROM products WHERE pagename = 'the-rouge-rooibos-afrique-bio-1-kg' AND hidden = 0 LIMIT 1
11 0.0047 0.0047481060028076
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0357 0.035694122314453
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00073409080505371
SELECT * FROM pages WHERE pagename = 'the-rouge-rooibos-afrique-bio-1-kg'
14 0.0017 0.0017480850219727
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0021 0.0020749568939209
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0080 0.0080358982086182
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.0021 0.0020761489868164
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.0014 0.0013928413391113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00043606758117676
SELECT id FROM categories WHERE parent_id = '26'
20 0.0058 0.0057518482208252
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.0018 0.0017940998077393
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.0019 0.0018711090087891
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.0015 0.0014851093292236
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00050497055053711
SELECT * FROM categorygroups WHERE id = '1'
25 0.0048 0.0047540664672852
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.0007 0.00067400932312012
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.0004 0.0004429817199707
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0006 0.00056600570678711
SELECT id FROM categories WHERE parent_id = '27'
29 0.0047 0.0046579837799072
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.0007 0.00070619583129883
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.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
32 0.0006 0.00057697296142578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0006 0.0005500316619873
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016000270843506
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.0007 0.00068807601928711
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.00053095817565918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00053000450134277
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.0019500255584717
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.00061583518981934
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.0006 0.00058984756469727
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.0005 0.00051403045654297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00053310394287109
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00066995620727539
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.00052118301391602
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.00056099891662598
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00050902366638184
SELECT id FROM categories WHERE parent_id = '29'
47 0.0011 0.0011351108551025
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.0006 0.00060701370239258
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.0006 0.00058293342590332
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.00052499771118164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00050902366638184
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.0008089542388916
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.0006 0.0006411075592041
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.0006 0.00057196617126465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00050091743469238
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00085878372192383
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.0007 0.00069403648376465
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.0008 0.00075411796569824
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.00063991546630859
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0009 0.00086092948913574
SELECT * FROM categorygroups WHERE id = '1'
61 0.0011 0.0010750293731689
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.0008 0.00077390670776367
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.0006 0.00061297416687012
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.0006248950958252
SELECT id FROM categories WHERE parent_id = '31'
65 0.0012 0.001166820526123
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.0008 0.00078511238098145
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.0009 0.00089192390441895
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.0008 0.00080299377441406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0007 0.00065016746520996
SELECT * FROM categorygroups WHERE id = '1'
70 0.0008 0.00076198577880859
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0045 0.0045328140258789
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0027 0.0026700496673584
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0009 0.00085306167602539
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.0017 0.0016789436340332
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0014 0.0014369487762451
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0013 0.0012829303741455
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5377 0.53772211074829
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.0030 0.0030109882354736
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0017 0.0017309188842773
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00076007843017578
SELECT * FROM products WHERE pagename = 'the-rouge-rooibos-afrique-bio-1-kg'
81 0.0005 0.00046396255493164
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1061
82 0.0005 0.00053787231445312
SELECT * FROM manufacturers WHERE id = '255'
83 0.0005 0.00048708915710449
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255'
84 0.0016 0.0015590190887451
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '255' LIMIT 1
85 0.0018 0.0018219947814941
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.0006 0.00064611434936523
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
87 0.0006 0.00055313110351562
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '255'
88 0.0006 0.00057506561279297
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.0006 0.00062894821166992
SELECT * FROM manufacturerimages WHERE manufacturer_id = '255'
90 0.0007 0.000701904296875
SELECT category_id FROM products_categories WHERE product_id = '1061'
91 0.0007 0.00072503089904785
SELECT * FROM categories WHERE id = '27'
92 0.0038 0.0037710666656494
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.0005 0.00046706199645996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00035381317138672
SELECT id FROM categories WHERE parent_id = '27'
95 0.0125 0.012493133544922
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.0007 0.00069308280944824
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.00064897537231445
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.00052285194396973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.0006561279296875
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
100 0.0019 0.0018889904022217
SELECT * FROM product_image_select WHERE product_id = '1061'
101 0.0014 0.0014021396636963
SELECT * FROM productcustomimages WHERE product_id = '1061'
102 0.0012 0.0012309551239014
SELECT * FROM productfeeds WHERE product_id = '1061' ORDER BY item_date DESC
103 0.0024 0.0024499893188477
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0024 0.0023670196533203
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1061' AND t.hidden = 0 AND display_product = 1
105 0.0004 0.00040411949157715
SELECT * FROM tags WHERE id = '15'
106 0.0011 0.001101016998291
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0008 0.0008399486541748
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '15'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0008 0.00083804130554199
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '15' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0007 0.00066900253295898
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
110 0.0017 0.001680850982666
SELECT * FROM productamazoncontent WHERE product_id = '1061'
111 0.0011 0.0011439323425293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
112 0.0015 0.0014810562133789
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0007 0.00065898895263672
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0014 0.0013930797576904
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
116 0.0134 0.013367176055908
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos afrique' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rouge rooibos afrique' IN BOOLEAN MODE) AND 1061 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
117 0.0011 0.0010809898376465
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos afrique' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rouge rooibos afrique' IN BOOLEAN MODE) AND 1061 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
118 0.0008 0.00078988075256348
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos afrique' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rouge rooibos afrique' IN BOOLEAN MODE) AND 1061 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0008 0.00080299377441406
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
120 0.0008 0.00075817108154297
SELECT * FROM product_image_select WHERE product_id = '862'
121 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '862'
122 0.0010 0.00099396705627441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
123 0.0005 0.00052690505981445
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0005 0.00054788589477539
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0006 0.00055384635925293
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
127 0.0010 0.001007080078125
SELECT * FROM product_image_select WHERE product_id = '878'
128 0.0004 0.00044798851013184
SELECT * FROM productcustomimages WHERE product_id = '878'
129 0.0014 0.0013699531555176
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
130 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0004 0.00044894218444824
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0005 0.00051093101501465
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0007 0.00071191787719727
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
134 0.0006 0.00061893463134766
SELECT * FROM product_image_select WHERE product_id = '858'
135 0.0005 0.00046515464782715
SELECT * FROM productcustomimages WHERE product_id = '858'
136 0.0011 0.0010979175567627
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.00047898292541504
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0005 0.00047206878662109
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0005 0.0005340576171875
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0006 0.00055789947509766
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
141 0.0006 0.00064492225646973
SELECT * FROM product_image_select WHERE product_id = '890'
142 0.0004 0.00042319297790527
SELECT * FROM productcustomimages WHERE product_id = '890'
143 0.0010 0.0010139942169189
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
144 0.0005 0.00048184394836426
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.00041508674621582
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0005 0.00050187110900879
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0005 0.00049495697021484
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
148 0.0006 0.00059103965759277
SELECT * FROM product_image_select WHERE product_id = '865'
149 0.0004 0.00039410591125488
SELECT * FROM productcustomimages WHERE product_id = '865'
150 0.0008 0.00079584121704102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
151 0.0006 0.00055694580078125
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0008 0.00078797340393066
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0007 0.00065112113952637
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
155 0.0006 0.00062704086303711
SELECT * FROM product_image_select WHERE product_id = '869'
156 0.0005 0.00053787231445312
SELECT * FROM productcustomimages WHERE product_id = '869'
157 0.0009 0.00092697143554688
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
158 0.0006 0.00057291984558105
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0005 0.00049400329589844
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0005 0.00048995018005371
SELECT id,asin FROM products WHERE parent_id = 1061
162 0.0019 0.001924991607666
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
163 0.0005 0.00049185752868652
SELECT category_id FROM products_categories WHERE product_id = '1061'
164 0.0006 0.0005800724029541
SELECT * FROM categories WHERE id = '27'
165 0.0037 0.0036678314208984
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.0005 0.00045895576477051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0004 0.00035381317138672
SELECT id FROM categories WHERE parent_id = '27'
168 0.0036 0.0035851001739502
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.00059294700622559
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.00063896179199219
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.00053191184997559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0012 0.0011980533599854
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
173 0.0006 0.0006108283996582
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0006 0.00057291984558105
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0007 0.00068020820617676
SELECT * FROM products WHERE id = '1061'
176 0.0005 0.00049614906311035
SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0013 0.0012509822845459
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
178 0.0005 0.00050687789916992
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00052404403686523
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0006 0.00055909156799316
SELECT category_id FROM products_categories WHERE product_id = '1061' AND prod_type = 'amz'
181 0.0005 0.00049710273742676
SELECT parent_id FROM categories WHERE id = '27'
182 0.0004 0.00041604042053223
SELECT * FROM categories WHERE id = '27'
183 0.0037 0.0037000179290771
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
184 0.0005 0.00053906440734863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
185 0.0004 0.0003819465637207
SELECT id FROM categories WHERE parent_id = '27'
186 0.0037 0.0037291049957275
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 
187 0.0006 0.00058889389038086
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 
188 0.0006 0.00061917304992676
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
189 0.0005 0.00050806999206543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
190 0.0019 0.0018918514251709
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
191 0.0013 0.001284122467041
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
192 0.0004 0.00038599967956543
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
193 0.0144 0.014354944229126
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
194 0.0024 0.0024330615997314
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
195 0.0007 0.00072383880615234
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
196 0.0007 0.00068998336791992
SELECT * FROM products WHERE id = 1626
197 0.0006 0.00063085556030273
SELECT * FROM products WHERE id = 4041
198 0.0006 0.0006101131439209
SELECT * FROM products WHERE id = 4312
199 0.0006 0.00062417984008789
SELECT * FROM products WHERE id = 777
200 0.0006 0.00062298774719238
SELECT * FROM products WHERE id = 3881
201 0.0011 0.0010819435119629
SELECT * FROM products WHERE id = 4213
202 0.0009 0.00093698501586914
SELECT * FROM products WHERE id = '1626'
203 0.0010 0.00098109245300293
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
204 0.0015 0.001500129699707
SELECT * FROM product_image_select WHERE product_id = '1626'
205 0.0008 0.00082802772521973
SELECT * FROM productcustomimages WHERE product_id = '1626'
206 0.0021 0.0020551681518555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
207 0.0010 0.0010290145874023
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0008 0.00081110000610352
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0010 0.00098586082458496
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0011 0.0011069774627686
SELECT * FROM products WHERE id = '4041'
211 0.0013 0.0012509822845459
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
212 0.0018 0.0017731189727783
SELECT * FROM product_image_select WHERE product_id = '4041'
213 0.0010 0.0010011196136475
SELECT * FROM productcustomimages WHERE product_id = '4041'
214 0.0037 0.0036561489105225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
215 0.0010 0.00098490715026855
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0008 0.00078797340393066
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0010 0.00096487998962402
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0011 0.0011148452758789
SELECT * FROM products WHERE id = '4312'
219 0.0010 0.00095105171203613
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
220 0.0022 0.0022449493408203
SELECT * FROM product_image_select WHERE product_id = '4312'
221 0.0010 0.001039981842041
SELECT * FROM productcustomimages WHERE product_id = '4312'
222 0.0044 0.004378080368042
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
223 0.0017 0.0017411708831787
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0014 0.0013790130615234
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0010 0.0010209083557129
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0011 0.0011379718780518
SELECT * FROM products WHERE id = '777'
227 0.0010 0.0010421276092529
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0016 0.0015981197357178
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0008 0.00080990791320801
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0029 0.0029239654541016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0010 0.0010061264038086
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0008 0.00079703330993652
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0007 0.00071382522583008
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0009 0.0008699893951416
SELECT * FROM products WHERE id = '3881'
235 0.0011 0.001054048538208
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
236 0.0011 0.0010888576507568
SELECT * FROM product_image_select WHERE product_id = '3881'
237 0.0006 0.00060582160949707
SELECT * FROM productcustomimages WHERE product_id = '3881'
238 0.0022 0.002155065536499
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
239 0.0007 0.00072503089904785
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0006 0.00062203407287598
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0006 0.00063014030456543
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0083 0.0082759857177734
SELECT * FROM products WHERE id = '4213'
243 0.0008 0.00083780288696289
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
244 0.0009 0.00087881088256836
SELECT * FROM product_image_select WHERE product_id = '4213'
245 0.0005 0.00053906440734863
SELECT * FROM productcustomimages WHERE product_id = '4213'
246 0.0014 0.0013918876647949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
247 0.0005 0.00049400329589844
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0006 0.00056719779968262
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0022 0.0021998882293701
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
251 0.0010 0.0010480880737305
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
252 0.0037 0.003709077835083
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
253 0.0026 0.0025749206542969
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
254 0.0008 0.0008389949798584
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0020 0.0019872188568115
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'