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
2.1343779563904 260 1.7634 0


No Amazon API Requests Made.


App Debug - Total Time 2.1343779563904 seconds

Number Time From Start Name Description
1 0.3467800617218 Initialise Initialise FSB Function
2 0.34928202629089 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38216710090637 Start of getCategoryListByGroup Function Before first category groups query
4 0.38272309303284 After initial query Before first category groups query
5 0.38272404670715 Get Category List for Group Before the call to getCategoryList function
6 0.38272595405579 Start of GetCategoryList function Start of the function
7 0.382728099823 Before getting categories Query to get specific category list
8 0.38330411911011 After getting categories Query to get specific category list
9 0.38330411911011 Before getting category custom Before call to function getCategoryCustom
10 0.39938902854919 After getting category custom After call to function getCategoryCustom
11 0.39939093589783 Before getting category custom Before call to function getCategoryCustom
12 0.410404920578 After getting category custom After call to function getCategoryCustom
13 0.41040706634521 Before getting category custom Before call to function getCategoryCustom
14 0.42372798919678 After getting category custom After call to function getCategoryCustom
15 0.42372894287109 Before getting category custom Before call to function getCategoryCustom
16 0.43149709701538 After getting category custom After call to function getCategoryCustom
17 0.4314980506897 Before getting category custom Before call to function getCategoryCustom
18 0.43756794929504 After getting category custom After call to function getCategoryCustom
19 0.43756914138794 Before getting category custom Before call to function getCategoryCustom
20 0.44288802146912 After getting category custom After call to function getCategoryCustom
21 0.44288897514343 End of GetCategoryList function End of the function
22 0.44289302825928 Get Category List for Group Before the call to getCategoryList function
23 0.44289398193359 Start of GetCategoryList function Start of the function
24 0.44289493560791 Before getting categories Query to get specific category list
25 0.44382309913635 End of getCategoryListByGroup Function Before return()
26 1.8827359676361 App Controller End End of the App controller (called before the controller of every page)
27 1.883064031601 Product Start Start of the product info controller
28 1.8976700305939 Cache file not found Starting get product details
29 1.9279720783234 Related products Start getting related products if enabled
30 1.9279730319977 Related Products Start Before the related products are found
31 1.9279730319977 Related Products Keywords Before the related product keywords are found
32 1.9279761314392 Create Keyword List Function Start of function
33 1.927994966507 Create Keyword List Function After looping provided content - 24 keywords found
34 1.9283900260925 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 1.9283931255341 Create Keyword List Function After reducing keyword list
36 1.9284191131592 Create Keyword List Function After selecting by scoring keywords
37 1.9284219741821 Create Keyword List Function After final loop of keywords
38 1.9284219741821 Related Products Keywords After the related product keywords are found
39 2.002347946167 Related Products End After the related products are found
40 2.0478420257568 Product End End of the product info controller (Product Info)
41 2.0486660003662 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.0495710372925 Before Get Options Before the call to getOptions in the tpl class
43 2.1200411319733 After Get Options After the call to getOptions in the tpl class
44 2.1201190948486 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.1201400756836 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.1232039928436 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.1232061386108 Product Info: Before Template Display Before the template is displayed
48 2.1343629360199 Product Info: After Template Display After the template is displayed
49 2.1343710422516 Finalizing debug Before the debug is output to the page.
50 2.1343779563904 End of App This is the end of the app logging, final timestamp


Query Debug - 260 Database Queries. Total time 1.7634 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0018 0.0018138885498047
SELECT parameter, value FROM parameters
2 0.0028 0.0027680397033691
SELECT * FROM `bad_bots`
3 0.0004 0.00037407875061035
SET time_zone = 'Europe/London'
4 0.0007 0.00071811676025391
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00079584121704102
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.224.37.168\";}'
6 0.0007 0.00066184997558594
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746027700'
7 0.0010 0.0009920597076416
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047612190246582
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00089311599731445
SELECT id FROM pages WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g' LIMIT 1
10 0.0008 0.00077414512634277
SELECT id FROM products WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g' AND hidden = 0 LIMIT 1
11 0.0023 0.0023128986358643
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0298 0.029812097549438
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0005 0.00054287910461426
SELECT * FROM pages WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g'
14 0.0006 0.00055098533630371
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.00056695938110352
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0064 0.0063850879669189
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0006 0.00059700012207031
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0005 0.00050115585327148
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00052499771118164
SELECT id FROM categories WHERE parent_id = '26'
20 0.0060 0.0059840679168701
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0006 0.00060200691223145
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.0005 0.00051093101501465
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.0005 0.0004580020904541
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00047397613525391
SELECT * FROM categorygroups WHERE id = '1'
25 0.0037 0.0036859512329102
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00054192543029785
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00037312507629395
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0004 0.00042915344238281
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0038440227508545
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.0005 0.0005340576171875
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0006 0.00055313110351562
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0006 0.0005638599395752
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00045108795166016
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0015311241149902
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.0010 0.00099396705627441
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.0013 0.001349925994873
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0010 0.00099396705627441
SELECT id FROM categories WHERE parent_id = '28'
38 0.0046 0.0045568943023682
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.0010 0.001039981842041
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.0011 0.0011301040649414
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.0009 0.00094103813171387
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0008 0.00075507164001465
SELECT * FROM categorygroups WHERE id = '1'
43 0.0013 0.0012509822845459
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.0010 0.00096511840820312
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.0007 0.00071811676025391
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0007 0.0006859302520752
SELECT id FROM categories WHERE parent_id = '29'
47 0.0011 0.0010678768157959
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.0007 0.00074887275695801
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.0010 0.0010080337524414
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.0007 0.00071597099304199
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.0005800724029541
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.00082898139953613
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.0006 0.00060701370239258
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.0005 0.0005030632019043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0006 0.00058412551879883
SELECT id FROM categories WHERE parent_id = '30'
56 0.0009 0.00094199180603027
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0006 0.00064897537231445
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.0008 0.00078392028808594
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.00070381164550781
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0004 0.00044703483581543
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.0006718635559082
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00049996376037598
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0005 0.00050592422485352
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00081896781921387
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0005 0.00054192543029785
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0006 0.00062084197998047
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.0007 0.00071501731872559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00045895576477051
SELECT * FROM categorygroups WHERE id = '1'
70 0.0009 0.00092291831970215
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0022 0.0022351741790771
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.0006260871887207
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.0005338191986084
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.0004 0.00036382675170898
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0012209415435791
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0009 0.00089693069458008
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 1.4300 1.4299890995026
SELECT * FROM ipgeocountries WHERE INET_ATON('18.224.37.168') >= INET_ATON(ip_start) AND INET_ATON('18.224.37.168') <= INET_ATON(ip_end)
78 0.0015 0.0014629364013672
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0004 0.00041890144348145
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0005 0.00053906440734863
SELECT * FROM products WHERE pagename = 'tchibo-410137rooibos-bos-caramel-de-the-orange-25x-3g'
81 0.0004 0.00036787986755371
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3546
82 0.0010 0.0010230541229248
SELECT * FROM manufacturers WHERE id = '329'
83 0.0017 0.0016729831695557
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '329'
84 0.0017 0.0016839504241943
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '329' LIMIT 1
85 0.0008 0.00082302093505859
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.0006 0.00061511993408203
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
87 0.0006 0.00059795379638672
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '329'
88 0.0005 0.00046801567077637
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.0003 0.00033211708068848
SELECT * FROM manufacturerimages WHERE manufacturer_id = '329'
90 0.0005 0.00050687789916992
SELECT category_id FROM products_categories WHERE product_id = '3546'
91 0.0005 0.00048398971557617
SELECT * FROM categories WHERE id = '27'
92 0.0056 0.0055618286132812
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
93 0.0005 0.0004889965057373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00039196014404297
SELECT id FROM categories WHERE parent_id = '27'
95 0.0056 0.0056068897247314
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.0006 0.00064206123352051
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.0007 0.0006718635559082
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.0005 0.00048089027404785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00053000450134277
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
100 0.0007 0.00071406364440918
SELECT * FROM product_image_select WHERE product_id = '3546'
101 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '3546'
102 0.0005 0.00051999092102051
SELECT * FROM productfeeds WHERE product_id = '3546' ORDER BY item_date DESC
103 0.0009 0.00088286399841309
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.0007 0.00073409080505371
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.0008 0.00081896781921387
SELECT * FROM productamazoncontent WHERE product_id = '3546'
106 0.0012 0.0011990070343018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
107 0.0005 0.00049591064453125
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0004 0.00043582916259766
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0005 0.00054788589477539
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0006 0.00058579444885254
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.0176 0.017590045928955
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.0008 0.00081801414489746
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.0009 0.00086402893066406
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.00052404403686523
SELECT * FROM productimages WHERE product_id = '1077' ORDER BY sortorder ASC
115 0.0007 0.00069022178649902
SELECT * FROM product_image_select WHERE product_id = '1077'
116 0.0004 0.00037503242492676
SELECT * FROM productcustomimages WHERE product_id = '1077'
117 0.0033 0.0033309459686279
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1077' AND a.name = n.originalname
118 0.0013 0.0012779235839844
SELECT * FROM productoffers WHERE product_id = '1077' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0007 0.00074887275695801
SELECT * FROM productoffers
                WHERE product_id = '1077' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0011 0.001101016998291
SELECT value FROM productattributes WHERE product_id = '1077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0011 0.0011069774627686
SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
122 0.0014 0.0013689994812012
SELECT * FROM product_image_select WHERE product_id = '4946'
123 0.0009 0.00085711479187012
SELECT * FROM productcustomimages WHERE product_id = '4946'
124 0.0018 0.00177001953125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4946' AND a.name = n.originalname
125 0.0008 0.00075292587280273
SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0007 0.00065803527832031
SELECT * FROM productoffers
                WHERE product_id = '4946' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0008 0.00081396102905273
SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0009 0.00088882446289062
SELECT * FROM productimages WHERE product_id = '994' ORDER BY sortorder ASC
129 0.0019 0.0019230842590332
SELECT * FROM product_image_select WHERE product_id = '994'
130 0.0007 0.00072908401489258
SELECT * FROM productcustomimages WHERE product_id = '994'
131 0.0019 0.0018949508666992
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '994' AND a.name = n.originalname
132 0.0007 0.00065207481384277
SELECT * FROM productoffers WHERE product_id = '994' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.00049710273742676
SELECT * FROM productoffers
                WHERE product_id = '994' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00049901008605957
SELECT value FROM productattributes WHERE product_id = '994' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00060105323791504
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
136 0.0009 0.00089406967163086
SELECT * FROM product_image_select WHERE product_id = '3546'
137 0.0004 0.0004417896270752
SELECT * FROM productcustomimages WHERE product_id = '3546'
138 0.0014 0.0014290809631348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
139 0.0006 0.00059390068054199
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00045323371887207
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0006 0.0006260871887207
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0006 0.00060606002807617
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
143 0.0009 0.00088906288146973
SELECT * FROM product_image_select WHERE product_id = '3524'
144 0.0004 0.00041604042053223
SELECT * FROM productcustomimages WHERE product_id = '3524'
145 0.0010 0.00097799301147461
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.00053215026855469
SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '3524' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0006 0.00056099891662598
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
150 0.0007 0.00065803527832031
SELECT * FROM product_image_select WHERE product_id = '3588'
151 0.0004 0.00035691261291504
SELECT * FROM productcustomimages WHERE product_id = '3588'
152 0.0008 0.00078821182250977
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
153 0.0004 0.00040817260742188
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00054097175598145
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0104 0.010377168655396
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.0006 0.00058388710021973
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.0005 0.00048279762268066
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.0005 0.00050187110900879
SELECT * FROM productimages WHERE product_id = '1111' ORDER BY sortorder ASC
160 0.0006 0.00062799453735352
SELECT * FROM product_image_select WHERE product_id = '1111'
161 0.0004 0.00044703483581543
SELECT * FROM productcustomimages WHERE product_id = '1111'
162 0.0030 0.0030448436737061
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1111' AND a.name = n.originalname
163 0.0009 0.00092315673828125
SELECT * FROM productoffers WHERE product_id = '1111' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0009 0.00086212158203125
SELECT * FROM productoffers
                WHERE product_id = '1111' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0008 0.00083708763122559
SELECT value FROM productattributes WHERE product_id = '1111' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0009 0.0008549690246582
SELECT id,asin FROM products WHERE parent_id = 3546
167 0.0007 0.00068402290344238
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3546' ORDER BY timestamp DESC
168 0.0007 0.00067996978759766
SELECT category_id FROM products_categories WHERE product_id = '3546'
169 0.0008 0.00077104568481445
SELECT * FROM categories WHERE id = '27'
170 0.0116 0.011567831039429
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.00081300735473633
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0006 0.00059795379638672
SELECT id FROM categories WHERE parent_id = '27'
173 0.0084 0.0083692073822021
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.0009 0.00091195106506348
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.00078392028808594
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.00055289268493652
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0013 0.0012969970703125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
178 0.0006 0.00060606002807617
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00054693222045898
SELECT * FROM products WHERE id = '3546'
181 0.0005 0.00049185752868652
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0011 0.0011179447174072
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.0005040168762207
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00040292739868164
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0005 0.0005340576171875
SELECT category_id FROM products_categories WHERE product_id = '3546' AND prod_type = 'amz'
186 0.0005 0.00051403045654297
SELECT parent_id FROM categories WHERE id = '27'
187 0.0004 0.00040197372436523
SELECT * FROM categories WHERE id = '27'
188 0.0048 0.004796028137207
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.0006 0.00060510635375977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190 0.0005 0.00045490264892578
SELECT id FROM categories WHERE parent_id = '27'
191 0.0041 0.0040900707244873
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.0006 0.00059294700622559
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.0008 0.0007939338684082
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.0005 0.00050997734069824
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195 0.0005 0.00053787231445312
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
196 0.0005 0.00048303604125977
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
197 0.0004 0.00039196014404297
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
198 0.0127 0.012711048126221
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.0006 0.00061488151550293
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.0006 0.00060486793518066
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.0005 0.00051403045654297
SELECT * FROM products WHERE id = 1626
202 0.0003 0.0003352165222168
SELECT * FROM products WHERE id = 4041
203 0.0004 0.00035309791564941
SELECT * FROM products WHERE id = 4312
204 0.0003 0.00030088424682617
SELECT * FROM products WHERE id = 777
205 0.0004 0.00038909912109375
SELECT * FROM products WHERE id = 3881
206 0.0004 0.00035691261291504
SELECT * FROM products WHERE id = 4213
207 0.0003 0.00031709671020508
SELECT * FROM products WHERE id = '1626'
208 0.0004 0.00042295455932617
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
209 0.0006 0.0005500316619873
SELECT * FROM product_image_select WHERE product_id = '1626'
210 0.0004 0.0003809928894043
SELECT * FROM productcustomimages WHERE product_id = '1626'
211 0.0008 0.000823974609375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
212 0.0004 0.00043606758117676
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0004 0.00038409233093262
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0004 0.00039911270141602
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = '4041'
216 0.0005 0.00051999092102051
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
217 0.0006 0.00055193901062012
SELECT * FROM product_image_select WHERE product_id = '4041'
218 0.0004 0.00041913986206055
SELECT * FROM productcustomimages WHERE product_id = '4041'
219 0.0011 0.0011081695556641
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
220 0.0004 0.00043201446533203
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0004 0.00038599967956543
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0005 0.00046205520629883
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0004 0.00044798851013184
SELECT * FROM products WHERE id = '4312'
224 0.0004 0.00039219856262207
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
225 0.0006 0.00055480003356934
SELECT * FROM product_image_select WHERE product_id = '4312'
226 0.0004 0.00035786628723145
SELECT * FROM productcustomimages WHERE product_id = '4312'
227 0.0009 0.00092506408691406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
228 0.0004 0.00039196014404297
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0003 0.00033187866210938
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0004 0.00044107437133789
SELECT * FROM products WHERE id = '777'
232 0.0005 0.00045680999755859
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0006 0.00062108039855957
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0003 0.0003361701965332
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0010 0.0009610652923584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0005 0.00047397613525391
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0005 0.00049591064453125
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0030 0.0030021667480469
SELECT * FROM products WHERE id = '3881'
240 0.0013 0.001251220703125
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
241 0.0014 0.00142502784729
SELECT * FROM product_image_select WHERE product_id = '3881'
242 0.0007 0.00065088272094727
SELECT * FROM productcustomimages WHERE product_id = '3881'
243 0.0037 0.0037391185760498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
244 0.0012 0.0011768341064453
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0007 0.0007319450378418
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0012 0.0011889934539795
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0013 0.0012760162353516
SELECT * FROM products WHERE id = '4213'
248 0.0012 0.0012118816375732
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
249 0.0013 0.001255989074707
SELECT * FROM product_image_select WHERE product_id = '4213'
250 0.0006 0.00064992904663086
SELECT * FROM productcustomimages WHERE product_id = '4213'
251 0.0032 0.003173828125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
252 0.0009 0.00090599060058594
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0006 0.00064301490783691
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0008 0.00078701972961426
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0018 0.0017669200897217
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
256 0.0016 0.0016391277313232
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
257 0.0062 0.0061769485473633
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
258 0.0037 0.003709077835083
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0008 0.00081896781921387
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0006 0.00060796737670898
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'