0

Infusettes de Rooibos Fruits rouges - boîte 30g

Price: €5,69
Product prices and availability are accurate as of 2022-06-23 22:43:24 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és et tisanes d'excellence 100% BIO Issu en majeure partie de commerce équitable et certains de biodynamie

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.5328829288483 250 0.8652 0


No Amazon API Requests Made.


App Debug - Total Time 1.5328829288483 seconds

Number Time From Start Name Description
1 0.65511894226074 Initialise Initialise FSB Function
2 0.65884399414062 App Controller Start Start of the App controller (called before the controller of every page)
3 0.6969039440155 Start of getCategoryListByGroup Function Before first category groups query
4 0.69989585876465 After initial query Before first category groups query
5 0.69989895820618 Get Category List for Group Before the call to getCategoryList function
6 0.69990301132202 Start of GetCategoryList function Start of the function
7 0.69990801811218 Before getting categories Query to get specific category list
8 0.7007908821106 After getting categories Query to get specific category list
9 0.70079398155212 Before getting category custom Before call to function getCategoryCustom
10 0.71622705459595 After getting category custom After call to function getCategoryCustom
11 0.7162299156189 Before getting category custom Before call to function getCategoryCustom
12 0.72768187522888 After getting category custom After call to function getCategoryCustom
13 0.72768402099609 Before getting category custom Before call to function getCategoryCustom
14 0.7354998588562 After getting category custom After call to function getCategoryCustom
15 0.73550295829773 Before getting category custom Before call to function getCategoryCustom
16 0.74147295951843 After getting category custom After call to function getCategoryCustom
17 0.74147605895996 Before getting category custom Before call to function getCategoryCustom
18 0.74700593948364 After getting category custom After call to function getCategoryCustom
19 0.74700903892517 Before getting category custom Before call to function getCategoryCustom
20 0.75247406959534 After getting category custom After call to function getCategoryCustom
21 0.75247693061829 End of GetCategoryList function End of the function
22 0.75248408317566 Get Category List for Group Before the call to getCategoryList function
23 0.75248599052429 Start of GetCategoryList function Start of the function
24 0.75248908996582 Before getting categories Query to get specific category list
25 0.75311088562012 End of getCategoryListByGroup Function Before return()
26 1.3284690380096 App Controller End End of the App controller (called before the controller of every page)
27 1.3289940357208 Product Start Start of the product info controller
28 1.3420250415802 Cache file not found Starting get product details
29 1.380126953125 Related products Start getting related products if enabled
30 1.3801288604736 Related Products Start Before the related products are found
31 1.3801300525665 Related Products Keywords Before the related product keywords are found
32 1.3801338672638 Create Keyword List Function Start of function
33 1.3801620006561 Create Keyword List Function After looping provided content - 18 keywords found
34 1.3808879852295 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
35 1.3808960914612 Create Keyword List Function After reducing keyword list
36 1.3809320926666 Create Keyword List Function After selecting by scoring keywords
37 1.3809349536896 Create Keyword List Function After final loop of keywords
38 1.3809368610382 Related Products Keywords After the related product keywords are found
39 1.4174339771271 Related Products End After the related products are found
40 1.44988489151 Product End End of the product info controller (Product Info)
41 1.4521169662476 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4538950920105 Before Get Options Before the call to getOptions in the tpl class
43 1.516942024231 After Get Options After the call to getOptions in the tpl class
44 1.5170509815216 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5170819759369 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5218839645386 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5218880176544 Product Info: Before Template Display Before the template is displayed
48 1.5328600406647 Product Info: After Template Display After the template is displayed
49 1.5328710079193 Finalizing debug Before the debug is output to the page.
50 1.532881975174 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 0.8652 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0022850036621094
SELECT parameter, value FROM parameters
2 0.0072 0.00724196434021
SELECT * FROM `bad_bots`
3 0.0005 0.00046706199645996
SET time_zone = 'Europe/London'
4 0.0008 0.00083017349243164
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0043 0.0042619705200195
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.147.44.153\";}'
6 0.0059 0.0059440135955811
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722095852'
7 0.0025 0.0025479793548584
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00063896179199219
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0019 0.0019049644470215
SELECT id FROM pages WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g' LIMIT 1
10 0.0007 0.00068402290344238
SELECT id FROM products WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g' AND hidden = 0 LIMIT 1
11 0.0033 0.0032811164855957
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0331 0.033063888549805
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0009 0.00087404251098633
SELECT * FROM pages WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g'
14 0.0030 0.0029740333557129
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0009 0.0008540153503418
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0061 0.0061209201812744
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.0006 0.00059986114501953
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.0005 0.00045299530029297
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00044417381286621
SELECT id FROM categories WHERE parent_id = '26'
20 0.0055 0.0055069923400879
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.0006 0.00061297416687012
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.0006 0.00057101249694824
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.0006 0.00055408477783203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00043606758117676
SELECT * FROM categorygroups WHERE id = '1'
25 0.0036 0.0035629272460938
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.00055909156799316
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.00043582916259766
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00050616264343262
SELECT id FROM categories WHERE parent_id = '27'
29 0.0041 0.0040609836578369
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.00061392784118652
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.00062298774719238
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.0004878044128418
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00050497055053711
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0015151500701904
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.0006 0.00056290626525879
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.0004 0.00042605400085449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00046110153198242
SELECT id FROM categories WHERE parent_id = '28'
38 0.0017 0.0017249584197998
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.00063419342041016
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.0012 0.0012040138244629
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.0006 0.00057697296142578
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0006 0.00061798095703125
SELECT * FROM categorygroups WHERE id = '1'
43 0.0009 0.00090622901916504
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.0006 0.00059914588928223
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.00046515464782715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0007 0.0007328987121582
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00081300735473633
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.00062990188598633
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.00063705444335938
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.00061488151550293
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.0004730224609375
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00079703330993652
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.00054311752319336
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.00042510032653809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00048089027404785
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00070500373840332
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.00061798095703125
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.0006868839263916
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.00062179565429688
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.0005500316619873
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00080013275146484
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.0006 0.00059199333190918
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.0005 0.00045490264892578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00080204010009766
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.00054192543029785
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.0007 0.00071597099304199
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.0006 0.00055813789367676
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00044393539428711
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.0006101131439209
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0021 0.0020790100097656
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0026 0.0026171207427979
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00084209442138672
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.0020 0.0020389556884766
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0018 0.0017850399017334
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0012459754943848
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5595 0.55954098701477
SELECT * FROM ipgeocountries WHERE INET_ATON('3.147.44.153') >= INET_ATON(ip_start) AND INET_ATON('3.147.44.153') <= INET_ATON(ip_end)
78 0.0026 0.0026180744171143
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0015 0.0014770030975342
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00072407722473145
SELECT * FROM products WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g'
81 0.0005 0.00051307678222656
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1060
82 0.0008 0.0008091926574707
SELECT * FROM manufacturers WHERE id = '261'
83 0.0008 0.00075006484985352
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
84 0.0026 0.0025599002838135
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
85 0.0012 0.001230001449585
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '261' ORDER BY RAND() LIMIT 1
86 0.0006 0.00058102607727051
SELECT * FROM productimages WHERE product_id = '1087' ORDER BY sortorder ASC
87 0.0007 0.00069999694824219
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
88 0.0007 0.00066900253295898
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '261'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0005 0.00047397613525391
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
90 0.0007 0.00072884559631348
SELECT category_id FROM products_categories WHERE product_id = '1060'
91 0.0008 0.00078797340393066
SELECT * FROM categories WHERE id = '27'
92 0.0078 0.0078310966491699
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.00057005882263184
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00038790702819824
SELECT id FROM categories WHERE parent_id = '27'
95 0.0047 0.0046849250793457
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.0006718635559082
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.0008 0.00076198577880859
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.0006 0.00060105323791504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00068283081054688
SELECT * FROM productimages WHERE product_id = '1060' ORDER BY sortorder ASC
100 0.0008 0.00083684921264648
SELECT * FROM product_image_select WHERE product_id = '1060'
101 0.0005 0.00052309036254883
SELECT * FROM productcustomimages WHERE product_id = '1060'
102 0.0020 0.0019810199737549
SELECT * FROM productfeeds WHERE product_id = '1060' ORDER BY item_date DESC
103 0.0010 0.00097990036010742
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1060' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0030 0.0030488967895508
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1060' AND t.hidden = 0 AND display_product = 1
105 0.0016 0.0016219615936279
SELECT * FROM productamazoncontent WHERE product_id = '1060'
106 0.0011 0.0010509490966797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1060' AND a.name = n.originalname
107 0.0005 0.00051498413085938
SELECT * FROM productoffers WHERE product_id = '1060' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00041794776916504
SELECT * FROM productoffers
                WHERE product_id = '1060' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00041890144348145
SELECT value FROM productattributes WHERE product_id = '1060' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00054502487182617
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.0100 0.009958028793335
SELECT *, MATCH (description, title) AGAINST ('rooibos fruits rouges' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos fruits rouges' IN BOOLEAN MODE) AND 1060 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0008 0.00084209442138672
SELECT *, MATCH (description, title) AGAINST ('rooibos fruits rouges' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos fruits rouges' IN BOOLEAN MODE) AND 1060 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0008 0.00075292587280273
SELECT *, MATCH (description, title) AGAINST ('rooibos fruits rouges' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos fruits rouges' IN BOOLEAN MODE) AND 1060 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0008 0.0007622241973877
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
115 0.0006 0.00062298774719238
SELECT * FROM product_image_select WHERE product_id = '862'
116 0.0004 0.00042319297790527
SELECT * FROM productcustomimages WHERE product_id = '862'
117 0.0010 0.00099992752075195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
118 0.0005 0.00048613548278809
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0004 0.00039386749267578
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0005 0.00047492980957031
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
122 0.0007 0.00065088272094727
SELECT * FROM product_image_select WHERE product_id = '865'
123 0.0005 0.00045299530029297
SELECT * FROM productcustomimages WHERE product_id = '865'
124 0.0008 0.00075006484985352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
125 0.0005 0.00051403045654297
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0006 0.00060200691223145
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
129 0.0006 0.0006098747253418
SELECT * FROM product_image_select WHERE product_id = '869'
130 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '869'
131 0.0009 0.0009148120880127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
132 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00040388107299805
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00037884712219238
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
136 0.0006 0.00058579444885254
SELECT * FROM product_image_select WHERE product_id = '858'
137 0.0004 0.00042009353637695
SELECT * FROM productcustomimages WHERE product_id = '858'
138 0.0010 0.0010318756103516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
139 0.0005 0.00047111511230469
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00048208236694336
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00047397613525391
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00048208236694336
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
143 0.0006 0.0006110668182373
SELECT * FROM product_image_select WHERE product_id = '878'
144 0.0004 0.00041103363037109
SELECT * FROM productcustomimages WHERE product_id = '878'
145 0.0010 0.00096917152404785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
146 0.0005 0.00048303604125977
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0005 0.00045609474182129
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0005 0.00050806999206543
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
150 0.0006 0.00058984756469727
SELECT * FROM product_image_select WHERE product_id = '890'
151 0.0007 0.00068497657775879
SELECT * FROM productcustomimages WHERE product_id = '890'
152 0.0010 0.0010421276092529
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
153 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00058388710021973
SELECT id,asin FROM products WHERE parent_id = 1060
157 0.0057 0.0057001113891602
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1060' ORDER BY timestamp DESC
158 0.0005 0.00049400329589844
SELECT category_id FROM products_categories WHERE product_id = '1060'
159 0.0005 0.00050783157348633
SELECT * FROM categories WHERE id = '27'
160 0.0039 0.0038840770721436
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.0005 0.00046300888061523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
162 0.0003 0.00032806396484375
SELECT id FROM categories WHERE parent_id = '27'
163 0.0035 0.0034840106964111
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.0005 0.00054502487182617
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.0006 0.00056290626525879
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.0005 0.00048089027404785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
167 0.0009 0.00085020065307617
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1060' AND a.name = n.originalname
168 0.0005 0.00049304962158203
SELECT * FROM productoffers WHERE product_id = '1060' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '1060' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0007 0.00071001052856445
SELECT * FROM products WHERE id = '1060'
171 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '1060' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0007 0.00066590309143066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1060' AND a.name = n.originalname
173 0.0004 0.00036716461181641
SELECT * FROM productoffers WHERE product_id = '1060' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00039505958557129
SELECT * FROM productoffers
                WHERE product_id = '1060' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00045895576477051
SELECT category_id FROM products_categories WHERE product_id = '1060' AND prod_type = 'amz'
176 0.0004 0.00039887428283691
SELECT parent_id FROM categories WHERE id = '27'
177 0.0003 0.00033807754516602
SELECT * FROM categories WHERE id = '27'
178 0.0036 0.0035841464996338
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.00045394897460938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
180 0.0003 0.00033807754516602
SELECT id FROM categories WHERE parent_id = '27'
181 0.0034 0.0034120082855225
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.0005 0.00051212310791016
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.00053095817565918
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.0006 0.00056099891662598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0018 0.00177001953125
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
186 0.0013 0.001338005065918
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0004 0.00036978721618652
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0128 0.012824058532715
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.0020 0.0019500255584717
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.00058412551879883
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.0006248950958252
SELECT * FROM products WHERE id = 1626
192 0.0006 0.00064206123352051
SELECT * FROM products WHERE id = 4041
193 0.0006 0.00059413909912109
SELECT * FROM products WHERE id = 4312
194 0.0006 0.0006251335144043
SELECT * FROM products WHERE id = 777
195 0.0006 0.0005640983581543
SELECT * FROM products WHERE id = 3881
196 0.0006 0.00056004524230957
SELECT * FROM products WHERE id = 4213
197 0.0007 0.00070714950561523
SELECT * FROM products WHERE id = '1626'
198 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
199 0.0006 0.00061893463134766
SELECT * FROM product_image_select WHERE product_id = '1626'
200 0.0004 0.00044393539428711
SELECT * FROM productcustomimages WHERE product_id = '1626'
201 0.0008 0.00082707405090332
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
202 0.0005 0.00051283836364746
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0004 0.00041890144348145
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0007 0.00073909759521484
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.0005950927734375
SELECT * FROM products WHERE id = '4041'
206 0.0005 0.0004730224609375
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
207 0.0007 0.00066590309143066
SELECT * FROM product_image_select WHERE product_id = '4041'
208 0.0004 0.00044393539428711
SELECT * FROM productcustomimages WHERE product_id = '4041'
209 0.0012 0.0012450218200684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
210 0.0005 0.00052905082702637
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0004 0.00043416023254395
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0006 0.00056004524230957
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0007 0.00069713592529297
SELECT * FROM products WHERE id = '4312'
214 0.0005 0.00053882598876953
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
215 0.0007 0.00068306922912598
SELECT * FROM product_image_select WHERE product_id = '4312'
216 0.0005 0.00050497055053711
SELECT * FROM productcustomimages WHERE product_id = '4312'
217 0.0012 0.0012190341949463
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
218 0.0006 0.00064897537231445
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0005 0.00051617622375488
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0007 0.00070595741271973
SELECT * FROM products WHERE id = '777'
222 0.0006 0.00057196617126465
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0007 0.00069999694824219
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0005 0.00046896934509277
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0012 0.0012331008911133
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.00055789947509766
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00048995018005371
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0007 0.00067400932312012
SELECT * FROM products WHERE id = '3881'
230 0.0008 0.0008389949798584
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
231 0.0007 0.00069403648376465
SELECT * FROM product_image_select WHERE product_id = '3881'
232 0.0005 0.00045919418334961
SELECT * FROM productcustomimages WHERE product_id = '3881'
233 0.0013 0.0012969970703125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
234 0.0006 0.00055384635925293
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.00048494338989258
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0006 0.00055813789367676
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0010 0.0010149478912354
SELECT * FROM products WHERE id = '4213'
238 0.0016 0.0015912055969238
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
239 0.0009 0.0009009838104248
SELECT * FROM product_image_select WHERE product_id = '4213'
240 0.0006 0.00058197975158691
SELECT * FROM productcustomimages WHERE product_id = '4213'
241 0.0014 0.0014269351959229
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
242 0.0007 0.00069904327392578
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0005 0.0005028247833252
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.00051689147949219
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0025 0.0025460720062256
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
246 0.0012 0.0011599063873291
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
247 0.0036 0.003587007522583
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
248 0.0010 0.0010409355163574
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
249 0.0009 0.00085687637329102
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0009 0.00088000297546387
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'