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.3707778453827 250 0.9881 0


No Amazon API Requests Made.


App Debug - Total Time 1.3707778453827 seconds

Number Time From Start Name Description
1 0.30989694595337 Initialise Initialise FSB Function
2 0.31902599334717 App Controller Start Start of the App controller (called before the controller of every page)
3 0.36020183563232 Start of getCategoryListByGroup Function Before first category groups query
4 0.36373901367188 After initial query Before first category groups query
5 0.36374092102051 Get Category List for Group Before the call to getCategoryList function
6 0.36374402046204 Start of GetCategoryList function Start of the function
7 0.3637478351593 Before getting categories Query to get specific category list
8 0.36868596076965 After getting categories Query to get specific category list
9 0.36868786811829 Before getting category custom Before call to function getCategoryCustom
10 0.40085887908936 After getting category custom After call to function getCategoryCustom
11 0.40086197853088 Before getting category custom Before call to function getCategoryCustom
12 0.41216588020325 After getting category custom After call to function getCategoryCustom
13 0.41216802597046 Before getting category custom Before call to function getCategoryCustom
14 0.41936588287354 After getting category custom After call to function getCategoryCustom
15 0.41936802864075 Before getting category custom Before call to function getCategoryCustom
16 0.42597389221191 After getting category custom After call to function getCategoryCustom
17 0.42597603797913 Before getting category custom Before call to function getCategoryCustom
18 0.43139004707336 After getting category custom After call to function getCategoryCustom
19 0.431391954422 Before getting category custom Before call to function getCategoryCustom
20 0.43651294708252 After getting category custom After call to function getCategoryCustom
21 0.43651485443115 End of GetCategoryList function End of the function
22 0.43652200698853 Get Category List for Group Before the call to getCategoryList function
23 0.43652391433716 Start of GetCategoryList function Start of the function
24 0.43652701377869 Before getting categories Query to get specific category list
25 0.4371440410614 End of getCategoryListByGroup Function Before return()
26 1.0141990184784 App Controller End End of the App controller (called before the controller of every page)
27 1.0149519443512 Product Start Start of the product info controller
28 1.0260248184204 Cache file not found Starting get product details
29 1.082023859024 Related products Start getting related products if enabled
30 1.0820260047913 Related Products Start Before the related products are found
31 1.0820269584656 Related Products Keywords Before the related product keywords are found
32 1.0820329189301 Create Keyword List Function Start of function
33 1.0821149349213 Create Keyword List Function After looping provided content - 18 keywords found
34 1.0831849575043 Create Keyword List Function After looping initial keyword list - 16 keywords remaining
35 1.0831940174103 Create Keyword List Function After reducing keyword list
36 1.0832629203796 Create Keyword List Function After selecting by scoring keywords
37 1.0832688808441 Create Keyword List Function After final loop of keywords
38 1.0832719802856 Related Products Keywords After the related product keywords are found
39 1.1365849971771 Related Products End After the related products are found
40 1.1877880096436 Product End End of the product info controller (Product Info)
41 1.1916010379791 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.1932969093323 Before Get Options Before the call to getOptions in the tpl class
43 1.294802904129 After Get Options After the call to getOptions in the tpl class
44 1.294960975647 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.2949919700623 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.3409938812256 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.3409998416901 Product Info: Before Template Display Before the template is displayed
48 1.3707559108734 Product Info: After Template Display After the template is displayed
49 1.3707668781281 Finalizing debug Before the debug is output to the page.
50 1.3707768917084 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 0.9881 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0014 0.00136399269104
SELECT parameter, value FROM parameters
2 0.0083 0.0083179473876953
SELECT * FROM `bad_bots`
3 0.0005 0.00045204162597656
SET time_zone = 'Europe/London'
4 0.0038 0.0037899017333984
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0041 0.0041210651397705
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6 0.0037 0.0036649703979492
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739261923'
7 0.0036 0.0036118030548096
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00085902214050293
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0034 0.0034370422363281
SELECT id FROM pages WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g' LIMIT 1
10 0.0042 0.004180908203125
SELECT id FROM products WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g' AND hidden = 0 LIMIT 1
11 0.0058 0.0058050155639648
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0336 0.033626079559326
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0012 0.0011868476867676
SELECT * FROM pages WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g'
14 0.0035 0.0035240650177002
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0049 0.004918098449707
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0145 0.014463186264038
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.0027 0.0027368068695068
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.0020608901977539
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00058484077453613
SELECT id FROM categories WHERE parent_id = '26'
20 0.0066 0.00661301612854
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.0019969940185547
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.0016 0.0016131401062012
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.0014 0.0014481544494629
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00052618980407715
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0037550926208496
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.0005 0.00054717063903809
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.00046515464782715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00047492980957031
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0036840438842773
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.00066304206848145
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.00058698654174805
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.00057220458984375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00045990943908691
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0015251636505127
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.00058722496032715
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0006 0.00058913230895996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.00057196617126465
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0015528202056885
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.0005 0.0005490779876709
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.0007 0.00070810317993164
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.00056195259094238
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00046586990356445
SELECT * FROM categorygroups WHERE id = '1'
43 0.0014 0.0013880729675293
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0007 0.00066900253295898
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.00045204162597656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0007 0.00072288513183594
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00093483924865723
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.00056600570678711
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.00074481964111328
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.00056886672973633
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00046992301940918
SELECT * FROM categorygroups WHERE id = '1'
52 0.0009 0.00088596343994141
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.0005030632019043
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.00041794776916504
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00053882598876953
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00085616111755371
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.00052309036254883
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.0005 0.0005497932434082
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.00056815147399902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00048303604125977
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00070905685424805
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00049901008605957
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.00044012069702148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00042915344238281
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00074410438537598
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.0007 0.00066494941711426
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.0006 0.00058889389038086
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.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0004 0.00044989585876465
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00060510635375977
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0029 0.0028741359710693
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0017 0.0017058849334717
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.0006260871887207
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.0014 0.0014100074768066
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0013 0.0013048648834229
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0013 0.0013298988342285
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5624 0.56240487098694
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.0021 0.0020508766174316
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0012 0.0012369155883789
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0007 0.00069117546081543
SELECT * FROM products WHERE pagename = 'infusettes-de-rooibos-fruits-rouges-bote-30g'
81 0.0005 0.00045895576477051
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1060
82 0.0008 0.00075697898864746
SELECT * FROM manufacturers WHERE id = '261'
83 0.0006 0.00058889389038086
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
84 0.0019 0.0018742084503174
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '261' LIMIT 1
85 0.0021 0.0021059513092041
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.0010 0.00098180770874023
SELECT * FROM productimages WHERE product_id = '1073' ORDER BY sortorder ASC
87 0.0011 0.001054048538208
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '261'
88 0.0006 0.00064897537231445
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.0006 0.00058507919311523
SELECT * FROM manufacturerimages WHERE manufacturer_id = '261'
90 0.0006 0.00056290626525879
SELECT category_id FROM products_categories WHERE product_id = '1060'
91 0.0007 0.00066494941711426
SELECT * FROM categories WHERE id = '27'
92 0.0065 0.0065100193023682
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.0005340576171875
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00043916702270508
SELECT id FROM categories WHERE parent_id = '27'
95 0.0091 0.0090720653533936
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.0013 0.0013189315795898
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.0015 0.0014832019805908
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.0012 0.0011658668518066
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0011 0.0010941028594971
SELECT * FROM productimages WHERE product_id = '1060' ORDER BY sortorder ASC
100 0.0040 0.0039668083190918
SELECT * FROM product_image_select WHERE product_id = '1060'
101 0.0025 0.0025219917297363
SELECT * FROM productcustomimages WHERE product_id = '1060'
102 0.0020 0.002039909362793
SELECT * FROM productfeeds WHERE product_id = '1060' ORDER BY item_date DESC
103 0.0041 0.0041129589080811
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.0036 0.0035920143127441
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.0023 0.0022659301757812
SELECT * FROM productamazoncontent WHERE product_id = '1060'
106 0.0011 0.0010859966278076
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1060' AND a.name = n.originalname
107 0.0019 0.0018589496612549
SELECT * FROM productoffers WHERE product_id = '1060' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0007 0.00066709518432617
SELECT * FROM productoffers
                WHERE product_id = '1060' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0007 0.0007021427154541
SELECT value FROM productattributes WHERE product_id = '1060' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0007 0.0006709098815918
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.0112 0.011176824569702
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.0009 0.00089693069458008
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.00084614753723145
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.0007 0.00071191787719727
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
115 0.0007 0.00068902969360352
SELECT * FROM product_image_select WHERE product_id = '890'
116 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '890'
117 0.0012 0.0012350082397461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
118 0.0006 0.00059199333190918
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00046515464782715
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00046586990356445
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0007 0.0006558895111084
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
122 0.0006 0.00062084197998047
SELECT * FROM product_image_select WHERE product_id = '858'
123 0.0004 0.0004279613494873
SELECT * FROM productcustomimages WHERE product_id = '858'
124 0.0011 0.0011398792266846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
125 0.0006 0.00055384635925293
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00046896934509277
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00043892860412598
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0005 0.0004727840423584
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
129 0.0007 0.00065398216247559
SELECT * FROM product_image_select WHERE product_id = '878'
130 0.0005 0.00048112869262695
SELECT * FROM productcustomimages WHERE product_id = '878'
131 0.0011 0.0011138916015625
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
132 0.0006 0.00055289268493652
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00046896934509277
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00050997734069824
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00062203407287598
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
136 0.0007 0.00065493583679199
SELECT * FROM product_image_select WHERE product_id = '862'
137 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '862'
138 0.0034 0.0034458637237549
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
139 0.0014 0.0013539791107178
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0009 0.00089907646179199
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0010 0.0010480880737305
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0014 0.0013837814331055
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
143 0.0017 0.0016529560089111
SELECT * FROM product_image_select WHERE product_id = '869'
144 0.0009 0.00089788436889648
SELECT * FROM productcustomimages WHERE product_id = '869'
145 0.0020 0.0019829273223877
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
146 0.0009 0.00085306167602539
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0014 0.0013530254364014
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0010 0.00095415115356445
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0011 0.0011041164398193
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
150 0.0017 0.0016829967498779
SELECT * FROM product_image_select WHERE product_id = '865'
151 0.0008 0.00084304809570312
SELECT * FROM productcustomimages WHERE product_id = '865'
152 0.0017 0.0016868114471436
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
153 0.0008 0.00078606605529785
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0006 0.00063514709472656
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0011 0.0010640621185303
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0009 0.00092506408691406
SELECT id,asin FROM products WHERE parent_id = 1060
157 0.0034 0.0034010410308838
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1060' ORDER BY timestamp DESC
158 0.0010 0.00097489356994629
SELECT category_id FROM products_categories WHERE product_id = '1060'
159 0.0009 0.00088596343994141
SELECT * FROM categories WHERE id = '27'
160 0.0114 0.011402130126953
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.0008 0.00078678131103516
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
162 0.0005 0.0005030632019043
SELECT id FROM categories WHERE parent_id = '27'
163 0.0084 0.0084221363067627
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.0010 0.00096321105957031
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.00083804130554199
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.0006248950958252
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
167 0.0011 0.0011129379272461
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1060' AND a.name = n.originalname
168 0.0007 0.00071001052856445
SELECT * FROM productoffers WHERE product_id = '1060' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0005 0.00054812431335449
SELECT * FROM productoffers
                WHERE product_id = '1060' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0008 0.00084495544433594
SELECT * FROM products WHERE id = '1060'
171 0.0009 0.00086784362792969
SELECT value FROM productattributes WHERE product_id = '1060' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0010 0.00097894668579102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1060' AND a.name = n.originalname
173 0.0005 0.00052809715270996
SELECT * FROM productoffers WHERE product_id = '1060' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.00051188468933105
SELECT * FROM productoffers
                WHERE product_id = '1060' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0006 0.00056600570678711
SELECT category_id FROM products_categories WHERE product_id = '1060' AND prod_type = 'amz'
176 0.0005 0.00053691864013672
SELECT parent_id FROM categories WHERE id = '27'
177 0.0004 0.00043988227844238
SELECT * FROM categories WHERE id = '27'
178 0.0059 0.0059239864349365
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.0006 0.00058507919311523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
180 0.0004 0.00038409233093262
SELECT id FROM categories WHERE parent_id = '27'
181 0.0044 0.0044481754302979
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.0007 0.0006568431854248
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.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 (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
184 0.0005 0.00054311752319336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
185 0.0030 0.0030210018157959
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
186 0.0012 0.0012469291687012
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0003 0.00034999847412109
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0330 0.032977819442749
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.0028 0.0027899742126465
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.0007 0.00068092346191406
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.0008 0.00084710121154785
SELECT * FROM products WHERE id = 1626
192 0.0007 0.00066995620727539
SELECT * FROM products WHERE id = 4041
193 0.0006 0.00057697296142578
SELECT * FROM products WHERE id = 4312
194 0.0007 0.00073003768920898
SELECT * FROM products WHERE id = 777
195 0.0006 0.00063705444335938
SELECT * FROM products WHERE id = 3881
196 0.0007 0.00066709518432617
SELECT * FROM products WHERE id = 4213
197 0.0008 0.00076603889465332
SELECT * FROM products WHERE id = '1626'
198 0.0006 0.00060105323791504
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
199 0.0007 0.00067996978759766
SELECT * FROM product_image_select WHERE product_id = '1626'
200 0.0005 0.00051784515380859
SELECT * FROM productcustomimages WHERE product_id = '1626'
201 0.0010 0.0010480880737305
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
202 0.0009 0.00085186958312988
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0004 0.00044083595275879
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.00060391426086426
SELECT * FROM products WHERE id = '4041'
206 0.0005 0.00050711631774902
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
207 0.0007 0.00071001052856445
SELECT * FROM product_image_select WHERE product_id = '4041'
208 0.0005 0.00048089027404785
SELECT * FROM productcustomimages WHERE product_id = '4041'
209 0.0022 0.002202033996582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
210 0.0008 0.00083303451538086
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0006 0.00063085556030273
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0007 0.00072908401489258
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0008 0.00084805488586426
SELECT * FROM products WHERE id = '4312'
214 0.0014 0.0014479160308838
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
215 0.0019 0.0018999576568604
SELECT * FROM product_image_select WHERE product_id = '4312'
216 0.0010 0.0009918212890625
SELECT * FROM productcustomimages WHERE product_id = '4312'
217 0.0037 0.0036540031433105
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
218 0.0010 0.00098490715026855
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0008 0.00084400177001953
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0009 0.00087904930114746
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0010 0.0010380744934082
SELECT * FROM products WHERE id = '777'
222 0.0009 0.0009009838104248
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0012 0.0012080669403076
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0007 0.0006721019744873
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0022 0.0022380352020264
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
226 0.0009 0.00085210800170898
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0008 0.00080108642578125
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0007 0.00073003768920898
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0009 0.00088715553283691
SELECT * FROM products WHERE id = '3881'
230 0.0010 0.0010120868682861
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
231 0.0010 0.0010168552398682
SELECT * FROM product_image_select WHERE product_id = '3881'
232 0.0007 0.00066995620727539
SELECT * FROM productcustomimages WHERE product_id = '3881'
233 0.0019 0.001945972442627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
234 0.0007 0.00073885917663574
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0006 0.00057792663574219
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0006 0.00062704086303711
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0008 0.0007779598236084
SELECT * FROM products WHERE id = '4213'
238 0.0011 0.001086950302124
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
239 0.0009 0.00089097023010254
SELECT * FROM product_image_select WHERE product_id = '4213'
240 0.0005 0.00054001808166504
SELECT * FROM productcustomimages WHERE product_id = '4213'
241 0.0019 0.0018899440765381
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.00065803527832031
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0006 0.00061297416687012
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0007 0.00067400932312012
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0028 0.0027821063995361
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
246 0.0011 0.0010750293731689
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
247 0.0041 0.0041229724884033
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
248 0.0024 0.0023860931396484
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
249 0.0013 0.0013082027435303
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0009 0.00093793869018555
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'