0

Thé en filtres rouge Rooibos 20 filtres

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

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

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.6289138793945 257 0.9888 0


No Amazon API Requests Made.


App Debug - Total Time 1.6289138793945 seconds

Number Time From Start Name Description
1 0.54339098930359 Initialise Initialise FSB Function
2 0.55552887916565 App Controller Start Start of the App controller (called before the controller of every page)
3 0.59779500961304 Start of getCategoryListByGroup Function Before first category groups query
4 0.5996630191803 After initial query Before first category groups query
5 0.59966588020325 Get Category List for Group Before the call to getCategoryList function
6 0.5996789932251 Start of GetCategoryList function Start of the function
7 0.59968495368958 Before getting categories Query to get specific category list
8 0.60148787498474 After getting categories Query to get specific category list
9 0.60149097442627 Before getting category custom Before call to function getCategoryCustom
10 0.62369704246521 After getting category custom After call to function getCategoryCustom
11 0.62370300292969 Before getting category custom Before call to function getCategoryCustom
12 0.63490605354309 After getting category custom After call to function getCategoryCustom
13 0.63491201400757 Before getting category custom Before call to function getCategoryCustom
14 0.64127087593079 After getting category custom After call to function getCategoryCustom
15 0.64127588272095 Before getting category custom Before call to function getCategoryCustom
16 0.64585399627686 After getting category custom After call to function getCategoryCustom
17 0.64585900306702 Before getting category custom Before call to function getCategoryCustom
18 0.65062093734741 After getting category custom After call to function getCategoryCustom
19 0.65062594413757 Before getting category custom Before call to function getCategoryCustom
20 0.65525102615356 After getting category custom After call to function getCategoryCustom
21 0.65525507926941 End of GetCategoryList function End of the function
22 0.65526604652405 Get Category List for Group Before the call to getCategoryList function
23 0.65526986122131 Start of GetCategoryList function Start of the function
24 0.65528988838196 Before getting categories Query to get specific category list
25 0.6558198928833 End of getCategoryListByGroup Function Before return()
26 1.1499948501587 App Controller End End of the App controller (called before the controller of every page)
27 1.150454044342 Product Start Start of the product info controller
28 1.1696200370789 Cache file not found Starting get product details
29 1.2865340709686 Related products Start getting related products if enabled
30 1.2865369319916 Related Products Start Before the related products are found
31 1.2865390777588 Related Products Keywords Before the related product keywords are found
32 1.2865459918976 Create Keyword List Function Start of function
33 1.2866790294647 Create Keyword List Function After looping provided content - 15 keywords found
34 1.287740945816 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 1.2877519130707 Create Keyword List Function After reducing keyword list
36 1.2877969741821 Create Keyword List Function After selecting by scoring keywords
37 1.2878019809723 Create Keyword List Function After final loop of keywords
38 1.2878050804138 Related Products Keywords After the related product keywords are found
39 1.3640198707581 Related Products End After the related products are found
40 1.4235608577728 Product End End of the product info controller (Product Info)
41 1.4263379573822 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4293630123138 Before Get Options Before the call to getOptions in the tpl class
43 1.5303180217743 After Get Options After the call to getOptions in the tpl class
44 1.5305728912354 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5306129455566 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5540778636932 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5540988445282 Product Info: Before Template Display Before the template is displayed
48 1.6288750171661 Product Info: After Template Display After the template is displayed
49 1.6288859844208 Finalizing debug Before the debug is output to the page.
50 1.6289119720459 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 0.9888 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.0011959075927734
SELECT parameter, value FROM parameters
2 0.0084 0.0084240436553955
SELECT * FROM `bad_bots`
3 0.0007 0.00070309638977051
SET time_zone = 'Europe/London'
4 0.0031 0.0030999183654785
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0043 0.0042750835418701
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.174\";}'
6 0.0035 0.0035371780395508
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738869610'
7 0.0115 0.011518955230713
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010600090026855
UPDATE autorun SET lastrun = '2025-02-06 19:20:11' WHERE id = '9'
9 0.0011 0.001060962677002
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0051 0.0050530433654785
SELECT id FROM pages WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres' LIMIT 1
11 0.0053 0.0053329467773438
SELECT id FROM products WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres' AND hidden = 0 LIMIT 1
12 0.0057 0.0056869983673096
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0348 0.034821033477783
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.0007319450378418
SELECT * FROM pages WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres'
15 0.0018 0.0018370151519775
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0018 0.0017549991607666
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0076 0.0076448917388916
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
18 0.0018 0.0018258094787598
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0011 0.001115083694458
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00047612190246582
SELECT id FROM categories WHERE parent_id = '26'
21 0.0056 0.005601167678833
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 
22 0.0019 0.001896858215332
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 
23 0.0015 0.0014729499816895
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
24 0.0014 0.0013818740844727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.0004429817199707
SELECT * FROM categorygroups WHERE id = '1'
26 0.0039 0.0038928985595703
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
27 0.0005 0.00053215026855469
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0004 0.00042605400085449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00043201446533203
SELECT id FROM categories WHERE parent_id = '27'
30 0.0037 0.0036690235137939
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 
31 0.0005 0.00048303604125977
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 
32 0.0005 0.00048303604125977
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
33 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00052189826965332
SELECT * FROM categorygroups WHERE id = '1'
35 0.0014 0.001410961151123
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
36 0.0005 0.00052094459533691
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00040984153747559
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00041818618774414
SELECT id FROM categories WHERE parent_id = '28'
39 0.0015 0.0015451908111572
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 
40 0.0005 0.00048494338989258
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 
41 0.0005 0.00052905082702637
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
42 0.0005 0.00046205520629883
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00039911270141602
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00063705444335938
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
45 0.0005 0.00049185752868652
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00039792060852051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0004 0.00040507316589355
SELECT id FROM categories WHERE parent_id = '29'
48 0.0007 0.00068092346191406
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 
49 0.0005 0.00045013427734375
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 
50 0.0005 0.00049400329589844
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
51 0.0004 0.00044608116149902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00040888786315918
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00059199333190918
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
54 0.0005 0.00050497055053711
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00040006637573242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00040483474731445
SELECT id FROM categories WHERE parent_id = '30'
57 0.0008 0.00076007843017578
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 
58 0.0005 0.00047779083251953
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 
59 0.0005 0.00049591064453125
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
60 0.0005 0.00054192543029785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00040817260742188
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.0005948543548584
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
63 0.0006 0.00056815147399902
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0004 0.00038003921508789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.0003969669342041
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00064206123352051
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 
67 0.0004 0.00044798851013184
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 
68 0.0005 0.00050497055053711
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
69 0.0005 0.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0004 0.00044107437133789
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00051188468933105
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0029 0.0028560161590576
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0014 0.0014259815216064
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.00061607360839844
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
75 0.0012 0.0011639595031738
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0011 0.0011270046234131
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0011 0.001068115234375
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.4797 0.47974109649658
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.174') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.174') <= INET_ATON(ip_end)
79 0.0024 0.0023629665374756
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0014 0.0013508796691895
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0038 0.0037539005279541
SELECT * FROM products WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres'
82 0.0037 0.0037479400634766
UPDATE products SET viewcount = viewcount + 1 WHERE id = 883
83 0.0045 0.0045239925384521
SELECT * FROM manufacturers WHERE id = '237'
84 0.0039 0.0039119720458984
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '237'
85 0.0036 0.0036101341247559
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '237' LIMIT 1
86 0.0083 0.0082950592041016
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '237' ORDER BY RAND() LIMIT 1
87 0.0018 0.0018129348754883
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
88 0.0024 0.0023949146270752
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '237'
89 0.0037 0.0036561489105225
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '237'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0019 0.0019481182098389
SELECT * FROM manufacturerimages WHERE manufacturer_id = '237'
91 0.0019 0.0019421577453613
SELECT category_id FROM products_categories WHERE product_id = '883'
92 0.0022 0.0022449493408203
SELECT * FROM categories WHERE id = '27'
93 0.0073 0.0073468685150146
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
94 0.0046 0.0045549869537354
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0022 0.0021917819976807
SELECT id FROM categories WHERE parent_id = '27'
96 0.0115 0.011515855789185
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 
97 0.0014 0.0013561248779297
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 
98 0.0007 0.00065803527832031
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
99 0.0006 0.00055503845214844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0006 0.00058412551879883
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
101 0.0026 0.0026099681854248
SELECT * FROM product_image_select WHERE product_id = '883'
102 0.0016 0.001600980758667
SELECT * FROM productcustomimages WHERE product_id = '883'
103 0.0043 0.0043280124664307
SELECT * FROM productfeeds WHERE product_id = '883' ORDER BY item_date DESC
104 0.0120 0.0119948387146
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0053 0.005267858505249
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '883' AND t.hidden = 0 AND display_product = 1
106 0.0050 0.0049731731414795
SELECT * FROM productamazoncontent WHERE product_id = '883'
107 0.0029 0.002885103225708
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
108 0.0058 0.0058329105377197
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0007 0.00069618225097656
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0081 0.0081081390380859
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
111 0.0019 0.0018668174743652
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
112 0.0009 0.00088000297546387
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0012 0.0011780261993408
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
114 0.0252 0.02517294883728
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AND 883 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115 0.0091 0.0091240406036377
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AND 883 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0010 0.0010240077972412
SELECT *, MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rouge rooibos 20filtres' IN BOOLEAN MODE) AND 883 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
117 0.0008 0.00077295303344727
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
118 0.0011 0.0010900497436523
SELECT * FROM product_image_select WHERE product_id = '869'
119 0.0007 0.00065803527832031
SELECT * FROM productcustomimages WHERE product_id = '869'
120 0.0018 0.0018200874328613
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
121 0.0008 0.00081896781921387
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0007 0.0007169246673584
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0008 0.00081300735473633
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0013 0.0013270378112793
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
125 0.0011 0.0010929107666016
SELECT * FROM product_image_select WHERE product_id = '858'
126 0.0006 0.00063705444335938
SELECT * FROM productcustomimages WHERE product_id = '858'
127 0.0023 0.0022878646850586
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
128 0.0008 0.00080013275146484
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0007 0.00071501731872559
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0009 0.00085091590881348
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0010 0.00097918510437012
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
132 0.0013 0.0012979507446289
SELECT * FROM product_image_select WHERE product_id = '862'
133 0.0006 0.00063896179199219
SELECT * FROM productcustomimages WHERE product_id = '862'
134 0.0018 0.0018179416656494
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
135 0.0007 0.00069499015808105
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0006 0.00056886672973633
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0007 0.00068092346191406
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0008 0.00084900856018066
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
139 0.0010 0.0009768009185791
SELECT * FROM product_image_select WHERE product_id = '890'
140 0.0007 0.00067305564880371
SELECT * FROM productcustomimages WHERE product_id = '890'
141 0.0017 0.0016589164733887
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
142 0.0007 0.00073099136352539
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0007 0.00071501731872559
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0008 0.00078296661376953
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0006 0.00058794021606445
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
146 0.0009 0.00087094306945801
SELECT * FROM product_image_select WHERE product_id = '878'
147 0.0005 0.00054597854614258
SELECT * FROM productcustomimages WHERE product_id = '878'
148 0.0016 0.0016040802001953
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
149 0.0007 0.00067877769470215
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0006 0.00058889389038086
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0006 0.00063395500183105
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0006 0.00058984756469727
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
153 0.0009 0.00089001655578613
SELECT * FROM product_image_select WHERE product_id = '865'
154 0.0007 0.00074100494384766
SELECT * FROM productcustomimages WHERE product_id = '865'
155 0.0010 0.00098109245300293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
156 0.0006 0.00062417984008789
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0006 0.0005650520324707
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0006 0.00055193901062012
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0006 0.00055122375488281
SELECT id,asin FROM products WHERE parent_id = 883
160 0.0020 0.0020020008087158
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '883' ORDER BY timestamp DESC
161 0.0007 0.00069808959960938
SELECT category_id FROM products_categories WHERE product_id = '883'
162 0.0006 0.00058197975158691
SELECT * FROM categories WHERE id = '27'
163 0.0080 0.0079550743103027
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
164 0.0008 0.00080609321594238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0006 0.00055193901062012
SELECT id FROM categories WHERE parent_id = '27'
166 0.0119 0.011884927749634
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 
167 0.0013 0.0012550354003906
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 
168 0.0010 0.00097107887268066
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
169 0.0007 0.00072717666625977
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
170 0.0015 0.0014588832855225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
171 0.0007 0.00073719024658203
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0010 0.0010108947753906
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0008 0.00075602531433105
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
174 0.0006 0.00064706802368164
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
175 0.0009 0.00093698501586914
SELECT * FROM products WHERE id = '883'
176 0.0007 0.00069904327392578
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0011 0.0011110305786133
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
178 0.0017 0.0017259120941162
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0006 0.00059700012207031
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0006 0.00064897537231445
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
181 0.0005 0.00048303604125977
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
182 0.0006 0.0006248950958252
SELECT category_id FROM products_categories WHERE product_id = '883' AND prod_type = 'amz'
183 0.0005 0.00052213668823242
SELECT parent_id FROM categories WHERE id = '27'
184 0.0005 0.00046491622924805
SELECT * FROM categories WHERE id = '27'
185 0.0073 0.007253885269165
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
186 0.0017 0.0016889572143555
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
187 0.0008 0.0008080005645752
SELECT id FROM categories WHERE parent_id = '27'
188 0.0052 0.0052142143249512
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 
189 0.0012 0.0011889934539795
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 
190 0.0012 0.0011909008026123
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
191 0.0008 0.00084590911865234
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
192 0.0024 0.0023510456085205
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0024 0.0023739337921143
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0005 0.00045490264892578
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0167 0.016672849655151
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
196 0.0018 0.0017960071563721
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
197 0.0006 0.00060009956359863
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
198 0.0006 0.00063896179199219
SELECT * FROM products WHERE id = 1626
199 0.0006 0.00059700012207031
SELECT * FROM products WHERE id = 4041
200 0.0005 0.00048613548278809
SELECT * FROM products WHERE id = 4312
201 0.0006 0.00055789947509766
SELECT * FROM products WHERE id = 777
202 0.0006 0.0006251335144043
SELECT * FROM products WHERE id = 3881
203 0.0006 0.00059390068054199
SELECT * FROM products WHERE id = 4213
204 0.0006 0.00056695938110352
SELECT * FROM products WHERE id = '1626'
205 0.0006 0.00058698654174805
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0006 0.00062203407287598
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0004 0.00043916702270508
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0016 0.0015571117401123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0012 0.001183032989502
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0007 0.0007319450378418
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0008 0.00083494186401367
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0009 0.00091099739074707
SELECT * FROM products WHERE id = '4041'
213 0.0008 0.00082993507385254
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0017 0.0016880035400391
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0008 0.00076007843017578
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0028 0.0028209686279297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0006 0.00064611434936523
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0005 0.0004880428314209
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0008 0.00076794624328613
SELECT * FROM products WHERE id = '4312'
221 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0008 0.00076103210449219
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0005 0.00047707557678223
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0020 0.0020170211791992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
225 0.0016 0.001615047454834
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0009 0.00094985961914062
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0007 0.00065898895263672
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0008 0.00077390670776367
SELECT * FROM products WHERE id = '777'
229 0.0007 0.00069713592529297
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0010 0.00098299980163574
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0005 0.00053501129150391
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0022 0.0022330284118652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
233 0.0016 0.001600980758667
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0006 0.00061893463134766
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0006 0.00056004524230957
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0007 0.0007479190826416
SELECT * FROM products WHERE id = '3881'
237 0.0009 0.00091791152954102
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
238 0.0011 0.0011241436004639
SELECT * FROM product_image_select WHERE product_id = '3881'
239 0.0005 0.00051689147949219
SELECT * FROM productcustomimages WHERE product_id = '3881'
240 0.0017 0.0017170906066895
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
241 0.0006 0.00060105323791504
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0005 0.00049090385437012
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0007 0.00070095062255859
SELECT * FROM products WHERE id = '4213'
245 0.0009 0.00085783004760742
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
246 0.0012 0.001194953918457
SELECT * FROM product_image_select WHERE product_id = '4213'
247 0.0005 0.00054001808166504
SELECT * FROM productcustomimages WHERE product_id = '4213'
248 0.0016 0.0015668869018555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
249 0.0028 0.0028471946716309
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0006 0.00058412551879883
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0005 0.00054788589477539
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0031 0.0031399726867676
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0024 0.0023930072784424
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0080 0.0079929828643799
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0038 0.0037951469421387
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0038 0.0038490295410156
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0039 0.0039498805999756
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'