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.2767119407654 257 0.3437 0


No Amazon API Requests Made.


App Debug - Total Time 1.2767119407654 seconds

Number Time From Start Name Description
1 0.66662406921387 Initialise Initialise FSB Function
2 0.67106008529663 App Controller Start Start of the App controller (called before the controller of every page)
3 0.68154907226562 Start of getCategoryListByGroup Function Before first category groups query
4 0.6823890209198 After initial query Before first category groups query
5 0.68239092826843 Get Category List for Group Before the call to getCategoryList function
6 0.68239498138428 Start of GetCategoryList function Start of the function
7 0.68239808082581 Before getting categories Query to get specific category list
8 0.68311405181885 After getting categories Query to get specific category list
9 0.68311595916748 Before getting category custom Before call to function getCategoryCustom
10 0.71036005020142 After getting category custom After call to function getCategoryCustom
11 0.71036410331726 Before getting category custom Before call to function getCategoryCustom
12 0.72465705871582 After getting category custom After call to function getCategoryCustom
13 0.72466206550598 Before getting category custom Before call to function getCategoryCustom
14 0.73208594322205 After getting category custom After call to function getCategoryCustom
15 0.73208904266357 Before getting category custom Before call to function getCategoryCustom
16 0.73623013496399 After getting category custom After call to function getCategoryCustom
17 0.73623204231262 Before getting category custom Before call to function getCategoryCustom
18 0.73988008499146 After getting category custom After call to function getCategoryCustom
19 0.73988199234009 Before getting category custom Before call to function getCategoryCustom
20 0.74345707893372 After getting category custom After call to function getCategoryCustom
21 0.74345993995667 End of GetCategoryList function End of the function
22 0.74346613883972 Get Category List for Group Before the call to getCategoryList function
23 0.74346899986267 Start of GetCategoryList function Start of the function
24 0.74347114562988 Before getting categories Query to get specific category list
25 0.7439661026001 End of getCategoryListByGroup Function Before return()
26 0.88319706916809 App Controller End End of the App controller (called before the controller of every page)
27 0.88408899307251 Product Start Start of the product info controller
28 0.90729308128357 Cache file not found Starting get product details
29 0.94349694252014 Related products Start getting related products if enabled
30 0.94349908828735 Related Products Start Before the related products are found
31 0.94350004196167 Related Products Keywords Before the related product keywords are found
32 0.94350409507751 Create Keyword List Function Start of function
33 0.94359493255615 Create Keyword List Function After looping provided content - 15 keywords found
34 0.94422292709351 Create Keyword List Function After looping initial keyword list - 14 keywords remaining
35 0.94423007965088 Create Keyword List Function After reducing keyword list
36 0.94425511360168 Create Keyword List Function After selecting by scoring keywords
37 0.94425797462463 Create Keyword List Function After final loop of keywords
38 0.94426012039185 Related Products Keywords After the related product keywords are found
39 0.99366402626038 Related Products End After the related products are found
40 1.0037231445312 Product End End of the product info controller (Product Info)
41 1.0053510665894 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.0064671039581 Before Get Options Before the call to getOptions in the tpl class
43 1.0960490703583 After Get Options After the call to getOptions in the tpl class
44 1.0962989330292 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.096342086792 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.1895320415497 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.1895380020142 Product Info: Before Template Display Before the template is displayed
48 1.2766709327698 Product Info: After Template Display After the template is displayed
49 1.2766890525818 Finalizing debug Before the debug is output to the page.
50 1.2767109870911 End of App This is the end of the app logging, final timestamp


Query Debug - 257 Database Queries. Total time 0.3437 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0015 0.0014529228210449
SELECT parameter, value FROM parameters
2 0.0021 0.0020608901977539
SELECT * FROM `bad_bots`
3 0.0003 0.00029301643371582
SET time_zone = 'Europe/London'
4 0.0008 0.00083804130554199
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0012 0.0011839866638184
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.218.184.214\";}'
6 0.0010 0.00095701217651367
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1715127604'
7 0.0012 0.00124192237854
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.00059890747070312
UPDATE autorun SET lastrun = '2024-05-08 00:20:05' WHERE id = '13'
9 0.0006 0.00060200691223145
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0014 0.0013809204101562
SELECT id FROM pages WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres' LIMIT 1
11 0.0014 0.001446008682251
SELECT id FROM products WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres' AND hidden = 0 LIMIT 1
12 0.0016 0.0016219615936279
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0079 0.0078890323638916
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0004 0.00041699409484863
SELECT * FROM pages WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres'
15 0.0008 0.00082993507385254
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0007 0.00069713592529297
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0123 0.012264013290405
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.0013 0.001270055770874
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.0005 0.00052690505981445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00044798851013184
SELECT id FROM categories WHERE parent_id = '26'
21 0.0094 0.0094170570373535
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.0009 0.00087499618530273
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.0012 0.0011959075927734
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.0006 0.00056290626525879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00052905082702637
SELECT * FROM categorygroups WHERE id = '1'
26 0.0063 0.0063321590423584
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.00051093101501465
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.00039792060852051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00038790702819824
SELECT id FROM categories WHERE parent_id = '27'
30 0.0049 0.0048820972442627
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.00046896934509277
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.00046205520629883
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.00045108795166016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0003 0.00027298927307129
SELECT * FROM categorygroups WHERE id = '1'
35 0.0019 0.0019328594207764
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.00049495697021484
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.00037884712219238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00040912628173828
SELECT id FROM categories WHERE parent_id = '28'
39 0.0024 0.0024189949035645
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.00049304962158203
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.00053000450134277
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.0004 0.00044488906860352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0002 0.0002129077911377
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00062918663024902
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.00047612190246582
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.00036716461181641
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00046491622924805
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.0004 0.0004119873046875
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.0004 0.00040793418884277
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.00036001205444336
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0002 0.00023913383483887
SELECT * FROM categorygroups WHERE id = '1'
53 0.0005 0.00052690505981445
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.0004 0.00041294097900391
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.0003 0.00030708312988281
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0003 0.00033116340637207
SELECT id FROM categories WHERE parent_id = '30'
57 0.0006 0.00060200691223145
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.0004 0.00044703483581543
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.0004 0.00040912628173828
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.0003 0.00033903121948242
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0002 0.00018405914306641
SELECT * FROM categorygroups WHERE id = '1'
62 0.0005 0.00052905082702637
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.0004 0.00035691261291504
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.0003 0.0003349781036377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0003 0.00028896331787109
SELECT id FROM categories WHERE parent_id = '31'
66 0.0006 0.00055885314941406
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.00037980079650879
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.0004 0.00039005279541016
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.0004 0.00040507316589355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0002 0.00024199485778809
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00048398971557617
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0013 0.001338005065918
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0008 0.00078606605529785
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0007 0.00073790550231934
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.0005 0.00049400329589844
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0007 0.00068807601928711
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0017 0.0016510486602783
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.0901 0.090062141418457
SELECT * FROM ipgeocountries WHERE INET_ATON('18.218.184.214') >= INET_ATON(ip_start) AND INET_ATON('18.218.184.214') <= INET_ATON(ip_end)
79 0.0007 0.00070500373840332
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0005 0.00049591064453125
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00072979927062988
SELECT * FROM products WHERE pagename = 'the-en-filtres-rouge-rooibos-20filtres'
82 0.0006 0.00058484077453613
UPDATE products SET viewcount = viewcount + 1 WHERE id = 883
83 0.0008 0.00083398818969727
SELECT * FROM manufacturers WHERE id = '237'
84 0.0006 0.00062799453735352
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '237'
85 0.0008 0.00081515312194824
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '237' LIMIT 1
86 0.0011 0.0011019706726074
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.0007 0.00065088272094727
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
88 0.0003 0.0002892017364502
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '237'
89 0.0006 0.00064396858215332
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.0004 0.00040507316589355
SELECT * FROM manufacturerimages WHERE manufacturer_id = '237'
91 0.0005 0.00047993659973145
SELECT category_id FROM products_categories WHERE product_id = '883'
92 0.0005 0.00050687789916992
SELECT * FROM categories WHERE id = '27'
93 0.0072 0.0072169303894043
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.0003 0.0002591609954834
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0002 0.0002291202545166
SELECT id FROM categories WHERE parent_id = '27'
96 0.0083 0.0083038806915283
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.0004 0.00037217140197754
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.0002 0.00024199485778809
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.0002 0.00023818016052246
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0003 0.00026583671569824
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
101 0.0007 0.00072813034057617
SELECT * FROM product_image_select WHERE product_id = '883'
102 0.0006 0.00060415267944336
SELECT * FROM productcustomimages WHERE product_id = '883'
103 0.0008 0.00081801414489746
SELECT * FROM productfeeds WHERE product_id = '883' ORDER BY item_date DESC
104 0.0013 0.0013461112976074
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.0025 0.0024991035461426
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.0010 0.00098514556884766
SELECT * FROM productamazoncontent WHERE product_id = '883'
107 0.0017 0.0017180442810059
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
108 0.0008 0.00076079368591309
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0006 0.00057411193847656
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0003 0.00032711029052734
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
111 0.0004 0.00035691261291504
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
112 0.0004 0.00037789344787598
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113 0.0010 0.00098991394042969
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.0104 0.01043701171875
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.0007 0.0006868839263916
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.0009 0.00093197822570801
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.0006 0.00063300132751465
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
118 0.0061 0.0060818195343018
SELECT * FROM product_image_select WHERE product_id = '858'
119 0.0004 0.00040793418884277
SELECT * FROM productcustomimages WHERE product_id = '858'
120 0.0028 0.002830982208252
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
121 0.0005 0.00053906440734863
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0004 0.0004270076751709
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0006 0.0005650520324707
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124 0.0007 0.00066804885864258
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
125 0.0005 0.00048589706420898
SELECT * FROM product_image_select WHERE product_id = '869'
126 0.0004 0.00042104721069336
SELECT * FROM productcustomimages WHERE product_id = '869'
127 0.0021 0.00211501121521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
128 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0005 0.00053882598876953
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0009 0.0008540153503418
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0010 0.00095701217651367
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
132 0.0005 0.00045919418334961
SELECT * FROM product_image_select WHERE product_id = '890'
133 0.0006 0.00056791305541992
SELECT * FROM productcustomimages WHERE product_id = '890'
134 0.0020 0.0020411014556885
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
135 0.0005 0.0005190372467041
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0006 0.00062394142150879
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0005 0.00054311752319336
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00051784515380859
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
139 0.0005 0.00045299530029297
SELECT * FROM product_image_select WHERE product_id = '865'
140 0.0004 0.00039196014404297
SELECT * FROM productcustomimages WHERE product_id = '865'
141 0.0013 0.001262903213501
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
142 0.0005 0.00052905082702637
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0004 0.0004429817199707
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0004 0.0004279613494873
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
146 0.0004 0.00042390823364258
SELECT * FROM product_image_select WHERE product_id = '878'
147 0.0004 0.00035190582275391
SELECT * FROM productcustomimages WHERE product_id = '878'
148 0.0019 0.001863956451416
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
149 0.0005 0.00046896934509277
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0004 0.00040793418884277
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0004 0.00042915344238281
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0006 0.00055193901062012
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
153 0.0004 0.00039315223693848
SELECT * FROM product_image_select WHERE product_id = '862'
154 0.0003 0.00034713745117188
SELECT * FROM productcustomimages WHERE product_id = '862'
155 0.0019 0.0019209384918213
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
156 0.0007 0.00069904327392578
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0005 0.00053620338439941
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0005 0.00054192543029785
SELECT id,asin FROM products WHERE parent_id = 883
160 0.0009 0.00085186958312988
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '883' ORDER BY timestamp DESC
161 0.0003 0.00025200843811035
SELECT category_id FROM products_categories WHERE product_id = '883'
162 0.0003 0.00025606155395508
SELECT * FROM categories WHERE id = '27'
163 0.0002 0.00021600723266602
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.0002 0.00020503997802734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
165 0.0002 0.00020098686218262
SELECT id FROM categories WHERE parent_id = '27'
166 0.0002 0.00019407272338867
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.0002 0.00023698806762695
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.0002 0.00020813941955566
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.0003 0.0002748966217041
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
170 0.0002 0.00020885467529297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
171 0.0002 0.00023698806762695
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
172 0.0002 0.00023293495178223
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
173 0.0003 0.0002748966217041
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
174 0.0002 0.00021791458129883
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
175 0.0005 0.00049901008605957
SELECT * FROM products WHERE id = '883'
176 0.0003 0.00031089782714844
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0002 0.00024104118347168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
178 0.0002 0.00024700164794922
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0002 0.00021910667419434
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0002 0.00022292137145996
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
181 0.0002 0.00021886825561523
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
182 0.0005 0.00046420097351074
SELECT category_id FROM products_categories WHERE product_id = '883' AND prod_type = 'amz'
183 0.0004 0.00038313865661621
SELECT parent_id FROM categories WHERE id = '27'
184 0.0002 0.00024795532226562
SELECT * FROM categories WHERE id = '27'
185 0.0005 0.00048995018005371
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.0003 0.00030899047851562
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
187 0.0002 0.00021195411682129
SELECT id FROM categories WHERE parent_id = '27'
188 0.0002 0.00024890899658203
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.0002 0.00024199485778809
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.0002 0.00024795532226562
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.0003 0.00026297569274902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
192 0.0008 0.00081181526184082
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
193 0.0007 0.00069403648376465
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
194 0.0003 0.0003349781036377
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
195 0.0206 0.020553827285767
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.0007 0.00072193145751953
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.0005 0.00047087669372559
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.0005 0.00052690505981445
SELECT * FROM products WHERE id = 1626
199 0.0004 0.00040817260742188
SELECT * FROM products WHERE id = 4041
200 0.0004 0.00039386749267578
SELECT * FROM products WHERE id = 4312
201 0.0004 0.00040197372436523
SELECT * FROM products WHERE id = 777
202 0.0004 0.00042200088500977
SELECT * FROM products WHERE id = 4213
203 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = 3881
204 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = '1626'
205 0.0005 0.00046706199645996
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
206 0.0004 0.00040698051452637
SELECT * FROM product_image_select WHERE product_id = '1626'
207 0.0004 0.00037217140197754
SELECT * FROM productcustomimages WHERE product_id = '1626'
208 0.0007 0.0006861686706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
209 0.0005 0.00046014785766602
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
210 0.0004 0.00044107437133789
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
211 0.0006 0.00055122375488281
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '4041'
213 0.0004 0.00042819976806641
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
214 0.0004 0.00042200088500977
SELECT * FROM product_image_select WHERE product_id = '4041'
215 0.0004 0.0004119873046875
SELECT * FROM productcustomimages WHERE product_id = '4041'
216 0.0014 0.0014419555664062
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
217 0.0005 0.00046801567077637
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
218 0.0004 0.00041294097900391
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
219 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220 0.0005 0.00053691864013672
SELECT * FROM products WHERE id = '4312'
221 0.0007 0.00065898895263672
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
222 0.0004 0.00039887428283691
SELECT * FROM product_image_select WHERE product_id = '4312'
223 0.0004 0.00036501884460449
SELECT * FROM productcustomimages WHERE product_id = '4312'
224 0.0017 0.0016961097717285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
225 0.0006 0.00062108039855957
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
226 0.0005 0.00047516822814941
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
227 0.0005 0.00052905082702637
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228 0.0006 0.00061798095703125
SELECT * FROM products WHERE id = '777'
229 0.0006 0.00061488151550293
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
230 0.0005 0.00052094459533691
SELECT * FROM product_image_select WHERE product_id = '777'
231 0.0004 0.00044512748718262
SELECT * FROM productcustomimages WHERE product_id = '777'
232 0.0030 0.0029881000518799
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.001619815826416
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
234 0.0006 0.00058698654174805
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
235 0.0006 0.00059700012207031
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236 0.0007 0.0007481575012207
SELECT * FROM products WHERE id = '4213'
237 0.0009 0.0009000301361084
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
238 0.0006 0.00055789947509766
SELECT * FROM product_image_select WHERE product_id = '4213'
239 0.0005 0.00047707557678223
SELECT * FROM productcustomimages WHERE product_id = '4213'
240 0.0019 0.0018830299377441
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
241 0.0020 0.0020129680633545
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
242 0.0009 0.00089693069458008
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
243 0.0007 0.00068187713623047
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244 0.0010 0.00098681449890137
SELECT * FROM products WHERE id = '3881'
245 0.0009 0.0008549690246582
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
246 0.0006 0.0005650520324707
SELECT * FROM product_image_select WHERE product_id = '3881'
247 0.0005 0.00051283836364746
SELECT * FROM productcustomimages WHERE product_id = '3881'
248 0.0014 0.0013852119445801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
249 0.0006 0.00060296058654785
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
250 0.0005 0.00047397613525391
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
251 0.0006 0.00060892105102539
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252 0.0012 0.0012211799621582
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
253 0.0009 0.00085115432739258
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
254 0.0018 0.0018470287322998
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
255 0.0012 0.0012228488922119
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0003 0.00031495094299316
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
257 0.0009 0.00088191032409668
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'