0

Red Espresso (250g Rooibos - thé Rouge - végétalien thé Rooibos café pour Les Cappuccino, Les Latte

Price: €14,99
Product prices and availability are accurate as of 2022-06-26 02:47:23 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.
Availability: In Stock
En stock.
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

100 % naturel de rooibos

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.5030720233917 255 0.8274 0


No Amazon API Requests Made.


App Debug - Total Time 1.5030720233917 seconds

Number Time From Start Name Description
1 0.63386607170105 Initialise Initialise FSB Function
2 0.63724493980408 App Controller Start Start of the App controller (called before the controller of every page)
3 0.67649102210999 Start of getCategoryListByGroup Function Before first category groups query
4 0.67718505859375 After initial query Before first category groups query
5 0.67718601226807 Get Category List for Group Before the call to getCategoryList function
6 0.67718911170959 Start of GetCategoryList function Start of the function
7 0.67719197273254 Before getting categories Query to get specific category list
8 0.6779990196228 After getting categories Query to get specific category list
9 0.67800092697144 Before getting category custom Before call to function getCategoryCustom
10 0.6937530040741 After getting category custom After call to function getCategoryCustom
11 0.69375610351562 Before getting category custom Before call to function getCategoryCustom
12 0.70546102523804 After getting category custom After call to function getCategoryCustom
13 0.70546293258667 Before getting category custom Before call to function getCategoryCustom
14 0.7189199924469 After getting category custom After call to function getCategoryCustom
15 0.71892189979553 Before getting category custom Before call to function getCategoryCustom
16 0.72841811180115 After getting category custom After call to function getCategoryCustom
17 0.72842001914978 Before getting category custom Before call to function getCategoryCustom
18 0.73367595672607 After getting category custom After call to function getCategoryCustom
19 0.73367810249329 Before getting category custom Before call to function getCategoryCustom
20 0.73899006843567 After getting category custom After call to function getCategoryCustom
21 0.7389919757843 End of GetCategoryList function End of the function
22 0.73899793624878 Get Category List for Group Before the call to getCategoryList function
23 0.73900008201599 Start of GetCategoryList function Start of the function
24 0.73900198936462 Before getting categories Query to get specific category list
25 0.73960208892822 End of getCategoryListByGroup Function Before return()
26 1.2263300418854 App Controller End End of the App controller (called before the controller of every page)
27 1.226793050766 Product Start Start of the product info controller
28 1.2372529506683 Cache file not found Starting get product details
29 1.2880849838257 Related products Start getting related products if enabled
30 1.2880880832672 Related Products Start Before the related products are found
31 1.2880890369415 Related Products Keywords Before the related product keywords are found
32 1.2881050109863 Create Keyword List Function Start of function
33 1.2881720066071 Create Keyword List Function After looping provided content - 39 keywords found
34 1.2904391288757 Create Keyword List Function After looping initial keyword list - 37 keywords remaining
35 1.2904529571533 Create Keyword List Function After reducing keyword list
36 1.2906489372253 Create Keyword List Function After selecting by scoring keywords
37 1.2906589508057 Create Keyword List Function After final loop of keywords
38 1.2906610965729 Related Products Keywords After the related product keywords are found
39 1.3536510467529 Related Products End After the related products are found
40 1.3874549865723 Product End End of the product info controller (Product Info)
41 1.388603925705 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3897030353546 Before Get Options Before the call to getOptions in the tpl class
43 1.4726629257202 After Get Options After the call to getOptions in the tpl class
44 1.4727830886841 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4728150367737 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4780750274658 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.478080034256 Product Info: Before Template Display Before the template is displayed
48 1.5030310153961 Product Info: After Template Display After the template is displayed
49 1.5030529499054 Finalizing debug Before the debug is output to the page.
50 1.5030701160431 End of App This is the end of the app logging, final timestamp


Query Debug - 255 Database Queries. Total time 0.8274 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.0023050308227539
SELECT parameter, value FROM parameters
2 0.0029 0.0028719902038574
SELECT * FROM `bad_bots`
3 0.0004 0.00037002563476562
SET time_zone = 'Europe/London'
4 0.0008 0.00078511238098145
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0008 0.00075101852416992
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.145.204.140\";}'
6 0.0007 0.00066590309143066
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722071896'
7 0.0013 0.0013420581817627
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.0008080005645752
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0012 0.0011589527130127
SELECT id FROM pages WHERE pagename = 'red-espresso-250g-rooibos-the-rouge-vegetalien-the-rooibos-cafe-pour' LIMIT 1
10 0.0011 0.0010950565338135
SELECT id FROM products WHERE pagename = 'red-espresso-250g-rooibos-the-rouge-vegetalien-the-rooibos-cafe-pour' AND hidden = 0 LIMIT 1
11 0.0035 0.0034520626068115
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0348 0.03476095199585
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00065517425537109
SELECT * FROM pages WHERE pagename = 'red-espresso-250g-rooibos-the-rouge-vegetalien-the-rooibos-cafe-pour'
14 0.0007 0.00068211555480957
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00078988075256348
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0058 0.0057780742645264
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.0007 0.00068902969360352
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.00048303604125977
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00048398971557617
SELECT id FROM categories WHERE parent_id = '26'
20 0.0056 0.0056300163269043
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.0007 0.00071215629577637
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.0007 0.00072097778320312
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.0006 0.00064492225646973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00050806999206543
SELECT * FROM categorygroups WHERE id = '1'
25 0.0036 0.0036089420318604
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.0007 0.00067710876464844
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.0006 0.00058507919311523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00052714347839355
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0037491321563721
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.00064396858215332
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.00066900253295898
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.00058698654174805
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00053095817565918
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0014579296112061
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0006 0.0005500316619873
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.0031 0.0031139850616455
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00048995018005371
SELECT id FROM categories WHERE parent_id = '28'
38 0.0020 0.001978874206543
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.0006 0.00057005882263184
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.0025 0.0024881362915039
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.0008 0.00080418586730957
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0019 0.0018532276153564
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00070905685424805
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0040 0.0040462017059326
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.0006 0.00064301490783691
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0006 0.00055098533630371
SELECT id FROM categories WHERE parent_id = '29'
47 0.0012 0.0011980533599854
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
48 0.0006 0.00058412551879883
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.0006 0.00061798095703125
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.0005 0.00049304962158203
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00055718421936035
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00069189071655273
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.00055694580078125
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00043082237243652
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00045418739318848
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00076007843017578
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0005 0.00054311752319336
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.0006 0.00061607360839844
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.0005 0.00054121017456055
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00054216384887695
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00068497657775879
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.0006 0.00058794021606445
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.00045490264892578
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00048685073852539
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00081491470336914
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.00054502487182617
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.00055694580078125
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.00048398971557617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0006 0.00055718421936035
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00059008598327637
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0017 0.0016632080078125
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0007 0.00067305564880371
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0007 0.00065493583679199
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.0005 0.00049591064453125
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011138916015625
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0011060237884521
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4783 0.47829508781433
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.204.140') >= INET_ATON(ip_start) AND INET_ATON('3.145.204.140') <= INET_ATON(ip_end)
78 0.0012 0.0011990070343018
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00051093101501465
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.0007789134979248
SELECT * FROM products WHERE pagename = 'red-espresso-250g-rooibos-the-rouge-vegetalien-the-rooibos-cafe-pour'
81 0.0005 0.00051689147949219
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4007
82 0.0014 0.00136399269104
SELECT * FROM manufacturers WHERE id = '587'
83 0.0013 0.0013339519500732
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '587'
84 0.0012 0.0011680126190186
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '587' LIMIT 1
85 0.0019 0.0019259452819824
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '587' ORDER BY RAND() LIMIT 1
86 0.0013 0.0013110637664795
SELECT * FROM productimages WHERE product_id = '4011' ORDER BY sortorder ASC
87 0.0012 0.0012290477752686
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '587'
88 0.0014 0.0013649463653564
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '587'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0009 0.00087094306945801
SELECT * FROM manufacturerimages WHERE manufacturer_id = '587'
90 0.0012 0.00118088722229
SELECT category_id FROM products_categories WHERE product_id = '4007'
91 0.0016 0.001568078994751
SELECT * FROM categories WHERE id = '27'
92 0.0070 0.0069930553436279
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.0008 0.00083494186401367
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0006 0.00056982040405273
SELECT id FROM categories WHERE parent_id = '27'
95 0.0051 0.0050530433654785
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.0008 0.00078201293945312
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.0008 0.00080108642578125
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.0006 0.00057792663574219
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0007 0.00073814392089844
SELECT * FROM productimages WHERE product_id = '4007' ORDER BY sortorder ASC
100 0.0008 0.00082898139953613
SELECT * FROM product_image_select WHERE product_id = '4007'
101 0.0006 0.00055408477783203
SELECT * FROM productcustomimages WHERE product_id = '4007'
102 0.0006 0.0005800724029541
SELECT * FROM productfeeds WHERE product_id = '4007' ORDER BY item_date DESC
103 0.0009 0.00094819068908691
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0009 0.00087714195251465
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4007' AND t.hidden = 0 AND display_product = 1
105 0.0005 0.00048995018005371
SELECT * FROM tags WHERE id = '81'
106 0.0037 0.0037450790405273
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0039 0.0039348602294922
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0031 0.0031030178070068
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109 0.0008 0.00079584121704102
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
110 0.0006 0.00064897537231445
SELECT * FROM productamazoncontent WHERE product_id = '4007'
111 0.0014 0.0013561248779297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname
112 0.0006 0.00057315826416016
SELECT * FROM productoffers WHERE product_id = '4007' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0005 0.00051593780517578
SELECT * FROM productoffers
                WHERE product_id = '4007' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0005 0.00052499771118164
SELECT value FROM productattributes WHERE product_id = '4007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115 0.0006 0.00064802169799805
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
116 0.0132 0.013215065002441
SELECT *, MATCH (description, title) AGAINST ('végétalien thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('végétalien thé rooibos' IN BOOLEAN MODE) AND 4007 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
117 0.0012 0.0011961460113525
SELECT *, MATCH (description, title) AGAINST ('végétalien thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('végétalien thé rooibos' IN BOOLEAN MODE) AND 4007 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
118 0.0010 0.00098896026611328
SELECT *, MATCH (description, title) AGAINST ('végétalien thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('végétalien thé rooibos' IN BOOLEAN MODE) AND 4007 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
119 0.0009 0.00087904930114746
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
120 0.0008 0.00078105926513672
SELECT * FROM product_image_select WHERE product_id = '869'
121 0.0020 0.0020208358764648
SELECT * FROM productcustomimages WHERE product_id = '869'
122 0.0027 0.0027151107788086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
123 0.0010 0.0010449886322021
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
124 0.0009 0.00091099739074707
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
125 0.0010 0.00099802017211914
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126 0.0013 0.0012731552124023
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
127 0.0016 0.0016391277313232
SELECT * FROM product_image_select WHERE product_id = '858'
128 0.0010 0.0010101795196533
SELECT * FROM productcustomimages WHERE product_id = '858'
129 0.0030 0.0030159950256348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
130 0.0009 0.00086188316345215
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
131 0.0007 0.00073885917663574
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
132 0.0008 0.00084686279296875
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133 0.0010 0.0010490417480469
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
134 0.0013 0.0012779235839844
SELECT * FROM product_image_select WHERE product_id = '890'
135 0.0007 0.00067901611328125
SELECT * FROM productcustomimages WHERE product_id = '890'
136 0.0024 0.0024220943450928
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
137 0.0009 0.00092983245849609
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
138 0.0008 0.00078415870666504
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
139 0.0009 0.00086712837219238
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140 0.0010 0.00099015235900879
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
141 0.0014 0.0014090538024902
SELECT * FROM product_image_select WHERE product_id = '865'
142 0.0008 0.00082898139953613
SELECT * FROM productcustomimages WHERE product_id = '865'
143 0.0014 0.0014150142669678
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
144 0.0011 0.0010731220245361
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0007 0.00072097778320312
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0007 0.00072383880615234
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147 0.0009 0.00089287757873535
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
148 0.0009 0.00092387199401855
SELECT * FROM product_image_select WHERE product_id = '862'
149 0.0006 0.00060486793518066
SELECT * FROM productcustomimages WHERE product_id = '862'
150 0.0014 0.0013852119445801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
151 0.0007 0.0007469654083252
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
152 0.0007 0.00066685676574707
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
153 0.0007 0.00066304206848145
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154 0.0008 0.00075292587280273
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
155 0.0009 0.00091004371643066
SELECT * FROM product_image_select WHERE product_id = '878'
156 0.0006 0.00058984756469727
SELECT * FROM productcustomimages WHERE product_id = '878'
157 0.0016 0.0016360282897949
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
158 0.0009 0.00091004371643066
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
159 0.0006 0.00061702728271484
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
160 0.0006 0.00057196617126465
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0006 0.0006258487701416
SELECT id,asin FROM products WHERE parent_id = 4007
162 0.0007 0.00071191787719727
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4007' ORDER BY timestamp DESC
163 0.0006 0.00062298774719238
SELECT category_id FROM products_categories WHERE product_id = '4007'
164 0.0008 0.00081181526184082
SELECT * FROM categories WHERE id = '27'
165 0.0050 0.0049529075622559
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
166 0.0006 0.00063586235046387
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
167 0.0006 0.00055789947509766
SELECT id FROM categories WHERE parent_id = '27'
168 0.0043 0.0043208599090576
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 
169 0.0007 0.00073909759521484
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 
170 0.0007 0.00072503089904785
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
171 0.0006 0.00061488151550293
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
172 0.0013 0.0013289451599121
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname
173 0.0006 0.00064611434936523
SELECT * FROM productoffers WHERE product_id = '4007' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.00053691864013672
SELECT * FROM productoffers
                WHERE product_id = '4007' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0008 0.0007779598236084
SELECT * FROM products WHERE id = '4007'
176 0.0005 0.00051999092102051
SELECT value FROM productattributes WHERE product_id = '4007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177 0.0010 0.00099992752075195
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname
178 0.0004 0.00043511390686035
SELECT * FROM productoffers WHERE product_id = '4007' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0006 0.00055217742919922
SELECT * FROM productoffers
                WHERE product_id = '4007' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0006 0.00055694580078125
SELECT category_id FROM products_categories WHERE product_id = '4007' AND prod_type = 'amz'
181 0.0005 0.00048112869262695
SELECT parent_id FROM categories WHERE id = '27'
182 0.0006 0.00055098533630371
SELECT * FROM categories WHERE id = '27'
183 0.0038 0.0037810802459717
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
184 0.0006 0.00058102607727051
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
185 0.0005 0.00046300888061523
SELECT id FROM categories WHERE parent_id = '27'
186 0.0036 0.0035898685455322
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 
187 0.0006 0.00064492225646973
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 
188 0.0007 0.00065016746520996
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
189 0.0007 0.00069403648376465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
190 0.0006 0.00062990188598633
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
191 0.0006 0.00058603286743164
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
192 0.0004 0.00041604042053223
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
193 0.0140 0.014033079147339
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
194 0.0012 0.0011520385742188
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
195 0.0007 0.00074219703674316
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
196 0.0006 0.00064897537231445
SELECT * FROM products WHERE id = 1626
197 0.0006 0.00060701370239258
SELECT * FROM products WHERE id = 4041
198 0.0007 0.00068283081054688
SELECT * FROM products WHERE id = 4312
199 0.0007 0.00069499015808105
SELECT * FROM products WHERE id = 777
200 0.0005 0.00049614906311035
SELECT * FROM products WHERE id = 3881
201 0.0006 0.00064587593078613
SELECT * FROM products WHERE id = 4213
202 0.0005 0.00048208236694336
SELECT * FROM products WHERE id = '1626'
203 0.0006 0.00060796737670898
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
204 0.0008 0.00079703330993652
SELECT * FROM product_image_select WHERE product_id = '1626'
205 0.0006 0.00055623054504395
SELECT * FROM productcustomimages WHERE product_id = '1626'
206 0.0028 0.0027611255645752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
207 0.0013 0.0012919902801514
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
208 0.0009 0.00088095664978027
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
209 0.0013 0.0013468265533447
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210 0.0012 0.0012259483337402
SELECT * FROM products WHERE id = '4041'
211 0.0012 0.0011780261993408
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
212 0.0019 0.0019421577453613
SELECT * FROM product_image_select WHERE product_id = '4041'
213 0.0009 0.00093698501586914
SELECT * FROM productcustomimages WHERE product_id = '4041'
214 0.0035 0.0034909248352051
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
215 0.0014 0.0013730525970459
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
216 0.0010 0.00099492073059082
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
217 0.0011 0.0010921955108643
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218 0.0012 0.0011720657348633
SELECT * FROM products WHERE id = '4312'
219 0.0012 0.0011990070343018
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
220 0.0016 0.0016319751739502
SELECT * FROM product_image_select WHERE product_id = '4312'
221 0.0008 0.00084781646728516
SELECT * FROM productcustomimages WHERE product_id = '4312'
222 0.0026 0.0026471614837646
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
223 0.0010 0.0010311603546143
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
224 0.0008 0.00084900856018066
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
225 0.0009 0.0009160041809082
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226 0.0011 0.001147985458374
SELECT * FROM products WHERE id = '777'
227 0.0011 0.0010621547698975
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
228 0.0011 0.0011270046234131
SELECT * FROM product_image_select WHERE product_id = '777'
229 0.0006 0.00064897537231445
SELECT * FROM productcustomimages WHERE product_id = '777'
230 0.0030 0.0029840469360352
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
231 0.0008 0.00080299377441406
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
232 0.0006 0.00064611434936523
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
233 0.0008 0.00083804130554199
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
234 0.0011 0.0011050701141357
SELECT * FROM products WHERE id = '3881'
235 0.0009 0.00089406967163086
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
236 0.0010 0.0010180473327637
SELECT * FROM product_image_select WHERE product_id = '3881'
237 0.0006 0.00058889389038086
SELECT * FROM productcustomimages WHERE product_id = '3881'
238 0.0017 0.0017030239105225
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
239 0.0007 0.0007469654083252
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
240 0.0006 0.00058603286743164
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
241 0.0009 0.00092005729675293
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242 0.0008 0.00081920623779297
SELECT * FROM products WHERE id = '4213'
243 0.0008 0.00077605247497559
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
244 0.0010 0.0009617805480957
SELECT * FROM product_image_select WHERE product_id = '4213'
245 0.0006 0.00055313110351562
SELECT * FROM productcustomimages WHERE product_id = '4213'
246 0.0018 0.0017678737640381
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
247 0.0007 0.00066614151000977
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0006 0.00061392784118652
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0011 0.0010929107666016
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
251 0.0011 0.0010950565338135
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
252 0.0021 0.0021059513092041
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
253 0.0009 0.00090479850769043
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
254 0.0007 0.000701904296875
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0009 0.00093388557434082
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'