0

Tchibo 410137 Rooibos Bos Caramel de thé Orange 25 x 3g

Price: €15,03
Product prices and availability are accurate as of 2022-06-21 16:32:39 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
Habituellement expédié sous 2 à 3 jours.
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

& # x2022?; emballage?: carton distributeur & # x2022?; sous emballage?: 25 x 3 g

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.4505140781403 260 0.9884 0


No Amazon API Requests Made.


App Debug - Total Time 1.4505140781403 seconds

Number Time From Start Name Description
1 0.41750192642212 Initialise Initialise FSB Function
2 0.42555785179138 App Controller Start Start of the App controller (called before the controller of every page)
3 0.46374607086182 Start of getCategoryListByGroup Function Before first category groups query
4 0.46567797660828 After initial query Before first category groups query
5 0.46567988395691 Get Category List for Group Before the call to getCategoryList function
6 0.46568393707275 Start of GetCategoryList function Start of the function
7 0.4656879901886 Before getting categories Query to get specific category list
8 0.46748805046082 After getting categories Query to get specific category list
9 0.46748995780945 Before getting category custom Before call to function getCategoryCustom
10 0.49296903610229 After getting category custom After call to function getCategoryCustom
11 0.49297499656677 Before getting category custom Before call to function getCategoryCustom
12 0.50857305526733 After getting category custom After call to function getCategoryCustom
13 0.5085780620575 Before getting category custom Before call to function getCategoryCustom
14 0.52424192428589 After getting category custom After call to function getCategoryCustom
15 0.52424788475037 Before getting category custom Before call to function getCategoryCustom
16 0.53534007072449 After getting category custom After call to function getCategoryCustom
17 0.53534507751465 Before getting category custom Before call to function getCategoryCustom
18 0.54389190673828 After getting category custom After call to function getCategoryCustom
19 0.54389500617981 Before getting category custom Before call to function getCategoryCustom
20 0.5517098903656 After getting category custom After call to function getCategoryCustom
21 0.55171298980713 End of GetCategoryList function End of the function
22 0.55172204971313 Get Category List for Group Before the call to getCategoryList function
23 0.55172491073608 Start of GetCategoryList function Start of the function
24 0.55172896385193 Before getting categories Query to get specific category list
25 0.55276703834534 End of getCategoryListByGroup Function Before return()
26 1.1614670753479 App Controller End End of the App controller (called before the controller of every page)
27 1.1621458530426 Product Start Start of the product info controller
28 1.1694579124451 Cache file not found Starting get product details
29 1.228688955307 Related products Start getting related products if enabled
30 1.2286908626556 Related Products Start Before the related products are found
31 1.2286930084229 Related Products Keywords Before the related product keywords are found
32 1.2286970615387 Create Keyword List Function Start of function
33 1.2287809848785 Create Keyword List Function After looping provided content - 24 keywords found
34 1.2298419475555 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 1.2298500537872 Create Keyword List Function After reducing keyword list
36 1.2299029827118 Create Keyword List Function After selecting by scoring keywords
37 1.2299070358276 Create Keyword List Function After final loop of keywords
38 1.2299089431763 Related Products Keywords After the related product keywords are found
39 1.2872140407562 Related Products End After the related products are found
40 1.3395490646362 Product End End of the product info controller (Product Info)
41 1.3425478935242 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3444790840149 Before Get Options Before the call to getOptions in the tpl class
43 1.4063539505005 After Get Options After the call to getOptions in the tpl class
44 1.406525850296 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4065570831299 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4184050559998 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4184100627899 Product Info: Before Template Display Before the template is displayed
48 1.4504659175873 Product Info: After Template Display After the template is displayed
49 1.4504899978638 Finalizing debug Before the debug is output to the page.
50 1.4505128860474 End of App This is the end of the app logging, final timestamp


Query Debug - 260 Database Queries. Total time 0.9884 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0013 0.0012800693511963
SELECT parameter, value FROM parameters
2 0.0048 0.0048348903656006
SELECT * FROM `bad_bots`
3 0.0003 0.00033807754516602
SET time_zone = 'Europe/London'
4 0.0021 0.0020530223846436
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0022 0.0021529197692871
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6 0.0025 0.0025410652160645
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739265260'
7 0.0040 0.0039970874786377
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00075793266296387
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0029 0.0029289722442627
SELECT id FROM pages WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g' LIMIT 1
10 0.0034 0.0033550262451172
SELECT id FROM products WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g' AND hidden = 0 LIMIT 1
11 0.0033 0.0033001899719238
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0336 0.033567905426025
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00064802169799805
SELECT * FROM pages WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g'
14 0.0019 0.0019168853759766
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0018 0.0017781257629395
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0083 0.0082821846008301
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.0022 0.0021710395812988
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.0015 0.0015289783477783
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00044488906860352
SELECT id FROM categories WHERE parent_id = '26'
20 0.0067 0.0066769123077393
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.0022 0.0021770000457764
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0019 0.0018839836120605
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.0016 0.0015859603881836
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.0005030632019043
SELECT * FROM categorygroups WHERE id = '1'
25 0.0050 0.0049550533294678
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0006 0.00064420700073242
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.00046896934509277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0006 0.00055694580078125
SELECT id FROM categories WHERE parent_id = '27'
29 0.0060 0.0060298442840576
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0006 0.00062894821166992
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.0007 0.00066089630126953
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.0009 0.0009150505065918
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00053310394287109
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0016098022460938
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.0005 0.00054502487182617
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0004 0.00042104721069336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0020 0.0019600391387939
SELECT id FROM categories WHERE parent_id = '28'
38 0.0054 0.0053579807281494
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.0012 0.00118088722229
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.0014 0.0014021396636963
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.0022 0.0021719932556152
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0008 0.00083804130554199
SELECT * FROM categorygroups WHERE id = '1'
43 0.0015 0.0014560222625732
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.0009 0.00091791152954102
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.0011 0.0011138916015625
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0013 0.0012969970703125
SELECT id FROM categories WHERE parent_id = '29'
47 0.0016 0.0015571117401123
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.0009 0.00094914436340332
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.0011 0.0010800361633301
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.0017 0.0017280578613281
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0008 0.00084114074707031
SELECT * FROM categorygroups WHERE id = '1'
52 0.0013 0.0013320446014404
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.0011 0.00111985206604
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.0009 0.00085091590881348
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0007 0.0006709098815918
SELECT id FROM categories WHERE parent_id = '30'
56 0.0013 0.0012748241424561
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.0009 0.00091886520385742
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.0009 0.00092387199401855
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.0007 0.00072312355041504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00060009956359863
SELECT * FROM categorygroups WHERE id = '1'
61 0.0011 0.0010838508605957
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0008 0.00075507164001465
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0006 0.00056195259094238
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.00055384635925293
SELECT id FROM categories WHERE parent_id = '31'
65 0.0010 0.0009758472442627
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.0010 0.0010368824005127
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0007 0.00074601173400879
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.0009 0.00093507766723633
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0010 0.0010361671447754
SELECT * FROM categorygroups WHERE id = '1'
70 0.0010 0.0010240077972412
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0044 0.0043890476226807
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0019 0.0018680095672607
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00067996978759766
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.0016 0.0015511512756348
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0017 0.0017120838165283
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.001230001449585
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5900 0.58998084068298
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.0027 0.002734899520874
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0021 0.0021069049835205
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0012 0.0011940002441406
SELECT * FROM products WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g'
81 0.0007 0.0007331371307373
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3546
82 0.0013 0.001305103302002
SELECT * FROM manufacturers WHERE id = '329'
83 0.0010 0.0010321140289307
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '329'
84 0.0032 0.0032429695129395
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '329' LIMIT 1
85 0.0036 0.0036318302154541
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '329' ORDER BY RAND() LIMIT 1
86 0.0009 0.00090289115905762
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
87 0.0008 0.00080204010009766
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '329'
88 0.0010 0.00099706649780273
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '329'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0007 0.00072383880615234
SELECT * FROM manufacturerimages WHERE manufacturer_id = '329'
90 0.0007 0.00065088272094727
SELECT category_id FROM products_categories WHERE product_id = '3546'
91 0.0011 0.0011088848114014
SELECT * FROM categories WHERE id = '27'
92 0.0080 0.0079782009124756
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0006 0.00058102607727051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.0004279613494873
SELECT id FROM categories WHERE parent_id = '27'
95 0.0060 0.0060029029846191
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0007 0.00072789192199707
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.0010 0.0010409355163574
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.0008 0.000762939453125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0011 0.0011279582977295
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
100 0.0062 0.0061848163604736
SELECT * FROM product_image_select WHERE product_id = '3546'
101 0.0035 0.0034890174865723
SELECT * FROM productcustomimages WHERE product_id = '3546'
102 0.0020 0.0019879341125488
SELECT * FROM productfeeds WHERE product_id = '3546' ORDER BY item_date DESC
103 0.0038 0.0038180351257324
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0036 0.0036067962646484
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3546' AND t.hidden = 0 AND display_product = 1
105 0.0018 0.0018060207366943
SELECT * FROM productamazoncontent WHERE product_id = '3546'
106 0.0011 0.0011229515075684
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
107 0.0015 0.0015480518341064
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0006 0.00056195259094238
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0007 0.00067400932312012
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0006 0.0005800724029541
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.0183 0.018280029296875
SELECT *, MATCH (description, title) AGAINST ('caramel de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('caramel de thé' IN BOOLEAN MODE) AND 3546 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0007 0.00071883201599121
SELECT *, MATCH (description, title) AGAINST ('caramel de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('caramel de thé' IN BOOLEAN MODE) AND 3546 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0006 0.00057816505432129
SELECT *, MATCH (description, title) AGAINST ('caramel de thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('caramel de thé' IN BOOLEAN MODE) AND 3546 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0005 0.00050497055053711
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
115 0.0006 0.00058102607727051
SELECT * FROM product_image_select WHERE product_id = '3546'
116 0.0004 0.00039911270141602
SELECT * FROM productcustomimages WHERE product_id = '3546'
117 0.0009 0.000946044921875
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
118 0.0005 0.00050806999206543
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00049114227294922
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0004 0.00042390823364258
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0004 0.00044918060302734
SELECT * FROM productimages WHERE product_id = '994' ORDER BY sortorder ASC
122 0.0006 0.00062298774719238
SELECT * FROM product_image_select WHERE product_id = '994'
123 0.0004 0.00036382675170898
SELECT * FROM productcustomimages WHERE product_id = '994'
124 0.0009 0.00089287757873535
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname
125 0.0005 0.00047707557678223
SELECT * FROM productoffers WHERE product_id = '994' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '994' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00041413307189941
SELECT value FROM productattributes WHERE product_id = '994' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0005 0.00047993659973145
SELECT * FROM productimages WHERE product_id = '1077' ORDER BY sortorder ASC
129 0.0006 0.00055599212646484
SELECT * FROM product_image_select WHERE product_id = '1077'
130 0.0004 0.00037097930908203
SELECT * FROM productcustomimages WHERE product_id = '1077'
131 0.0009 0.0008549690246582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1077' AND a.name = n.originalname
132 0.0005 0.00045680999755859
SELECT * FROM productoffers WHERE product_id = '1077' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '1077' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00039887428283691
SELECT value FROM productattributes WHERE product_id = '1077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00053095817565918
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
136 0.0006 0.00055098533630371
SELECT * FROM product_image_select WHERE product_id = '3588'
137 0.0004 0.00037598609924316
SELECT * FROM productcustomimages WHERE product_id = '3588'
138 0.0008 0.00075221061706543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
139 0.0005 0.00049209594726562
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.0003960132598877
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00049400329589844
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
143 0.0005 0.00053787231445312
SELECT * FROM product_image_select WHERE product_id = '3524'
144 0.0004 0.00041699409484863
SELECT * FROM productcustomimages WHERE product_id = '3524'
145 0.0007 0.00072312355041504
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
146 0.0005 0.00046014785766602
SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00043797492980957
SELECT * FROM productoffers
                WHERE product_id = '3524' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.0004279613494873
SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0004 0.0004270076751709
SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
150 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '4946'
151 0.0004 0.00037217140197754
SELECT * FROM productcustomimages WHERE product_id = '4946'
152 0.0007 0.00074315071105957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4946' AND a.name = n.originalname
153 0.0005 0.00048112869262695
SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0006 0.00064206123352051
SELECT * FROM productoffers
                WHERE product_id = '4946' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00040292739868164
SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0092 0.0092380046844482
SELECT *, MATCH (description, title) AGAINST ('thé orange 25x' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé orange 25x' IN BOOLEAN MODE) AND 3546 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 1
157 0.0008 0.00078105926513672
SELECT *, MATCH (description, title) AGAINST ('thé orange 25x' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé orange 25x' IN BOOLEAN MODE) AND 3546 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
158 0.0006 0.00056290626525879
SELECT *, MATCH (description, title) AGAINST ('thé orange 25x' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé orange 25x' IN BOOLEAN MODE) AND 3546 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 1
159 0.0007 0.00066304206848145
SELECT * FROM productimages WHERE product_id = '1111' ORDER BY sortorder ASC
160 0.0006 0.00056195259094238
SELECT * FROM product_image_select WHERE product_id = '1111'
161 0.0004 0.00040102005004883
SELECT * FROM productcustomimages WHERE product_id = '1111'
162 0.0010 0.0010349750518799
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1111' AND a.name = n.originalname
163 0.0004 0.00043106079101562
SELECT * FROM productoffers WHERE product_id = '1111' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0004 0.00038480758666992
SELECT * FROM productoffers
                WHERE product_id = '1111' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '1111' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0004 0.00042605400085449
SELECT id,asin FROM products WHERE parent_id = 3546
167 0.0015 0.0015130043029785
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3546' ORDER BY timestamp DESC
168 0.0008 0.00078511238098145
SELECT category_id FROM products_categories WHERE product_id = '3546'
169 0.0011 0.0010900497436523
SELECT * FROM categories WHERE id = '27'
170 0.0092 0.0091738700866699
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
171 0.0008 0.00076007843017578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0006 0.00057196617126465
SELECT id FROM categories WHERE parent_id = '27'
173 0.0059 0.0059449672698975
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 
174 0.0007 0.00072312355041504
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 
175 0.0008 0.00075793266296387
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
176 0.0006 0.00064897537231445
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0014 0.0014340877532959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
178 0.0007 0.00065708160400391
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0007 0.00065493583679199
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0009 0.00093317031860352
SELECT * FROM products WHERE id = '3546'
181 0.0008 0.00079107284545898
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0012 0.0012280941009521
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
183 0.0005 0.00050806999206543
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0010 0.0009610652923584
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0017 0.0016570091247559
SELECT category_id FROM products_categories WHERE product_id = '3546' AND prod_type = 'amz'
186 0.0009 0.00086617469787598
SELECT parent_id FROM categories WHERE id = '27'
187 0.0006 0.00062704086303711
SELECT * FROM categories WHERE id = '27'
188 0.0096 0.0096111297607422
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
189 0.0007 0.00072097778320312
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190 0.0006 0.00056815147399902
SELECT id FROM categories WHERE parent_id = '27'
191 0.0061 0.006101131439209
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 
192 0.0007 0.00072479248046875
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 
193 0.0007 0.00073099136352539
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
194 0.0006 0.00062918663024902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195 0.0023 0.0023069381713867
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
196 0.0015 0.0014960765838623
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
197 0.0004 0.00035881996154785
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
198 0.0149 0.014928102493286
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
199 0.0017 0.0016770362854004
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
200 0.0005 0.00052285194396973
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
201 0.0006 0.00062179565429688
SELECT * FROM products WHERE id = 1626
202 0.0004 0.00041699409484863
SELECT * FROM products WHERE id = 4041
203 0.0006 0.00064301490783691
SELECT * FROM products WHERE id = 4312
204 0.0007 0.00069117546081543
SELECT * FROM products WHERE id = 777
205 0.0007 0.00069808959960938
SELECT * FROM products WHERE id = 3881
206 0.0006 0.00059604644775391
SELECT * FROM products WHERE id = 4213
207 0.0005 0.0004570484161377
SELECT * FROM products WHERE id = '1626'
208 0.0005 0.00051784515380859
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
209 0.0006 0.00061321258544922
SELECT * FROM product_image_select WHERE product_id = '1626'
210 0.0004 0.00044107437133789
SELECT * FROM productcustomimages WHERE product_id = '1626'
211 0.0009 0.00093889236450195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
212 0.0006 0.00055408477783203
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0005 0.00048184394836426
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0005 0.00050711631774902
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0006 0.00060915946960449
SELECT * FROM products WHERE id = '4041'
216 0.0005 0.00049209594726562
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
217 0.0006 0.00063705444335938
SELECT * FROM product_image_select WHERE product_id = '4041'
218 0.0004 0.00044894218444824
SELECT * FROM productcustomimages WHERE product_id = '4041'
219 0.0014 0.0013880729675293
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
220 0.0006 0.00060200691223145
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0007 0.00067400932312012
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0006 0.00059080123901367
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0007 0.00066304206848145
SELECT * FROM products WHERE id = '4312'
224 0.0006 0.00056719779968262
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
225 0.0007 0.00069499015808105
SELECT * FROM product_image_select WHERE product_id = '4312'
226 0.0004 0.00044012069702148
SELECT * FROM productcustomimages WHERE product_id = '4312'
227 0.0011 0.0010790824890137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
228 0.0005 0.00049495697021484
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0005 0.00045990943908691
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0005 0.00049185752868652
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0007 0.00067806243896484
SELECT * FROM products WHERE id = '777'
232 0.0006 0.00057482719421387
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0007 0.00074291229248047
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0005 0.00045490264892578
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0013 0.001291036605835
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0006 0.00055503845214844
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0005 0.00046300888061523
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0006 0.00056600570678711
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0007 0.00066590309143066
SELECT * FROM products WHERE id = '3881'
240 0.0006 0.00064802169799805
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
241 0.0008 0.00077104568481445
SELECT * FROM product_image_select WHERE product_id = '3881'
242 0.0004 0.00043797492980957
SELECT * FROM productcustomimages WHERE product_id = '3881'
243 0.0013 0.0013480186462402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
244 0.0005 0.00054597854614258
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0005 0.00049090385437012
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0007 0.00066900253295898
SELECT * FROM products WHERE id = '4213'
248 0.0006 0.00061392784118652
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
249 0.0007 0.0006868839263916
SELECT * FROM product_image_select WHERE product_id = '4213'
250 0.0004 0.00044894218444824
SELECT * FROM productcustomimages WHERE product_id = '4213'
251 0.0015 0.0014588832855225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
252 0.0006 0.00056695938110352
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0004 0.00042295455932617
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0019 0.0018901824951172
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
256 0.0007 0.0006721019744873
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
257 0.0029 0.0028560161590576
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
258 0.0017 0.0016880035400391
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0006 0.00059294700622559
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0009 0.00092291831970215
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'