0

Alter Éco - Thé Rooibos Bio 40G - Lot De 4 - Vendu Par Lot - Livraison Gratuite En France

Price: €36,84
Product prices and availability are accurate as of 2022-06-23 22:44:10 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

Epicerie Salée Diététique Biologique Alter Éco Thé Rooibos Bio 40G

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.5080289840698 251 1.0641 0


No Amazon API Requests Made.


App Debug - Total Time 2.5080289840698 seconds

Number Time From Start Name Description
1 0.98008394241333 Initialise Initialise FSB Function
2 0.98757100105286 App Controller Start Start of the App controller (called before the controller of every page)
3 1.0258910655975 Start of getCategoryListByGroup Function Before first category groups query
4 1.0276598930359 After initial query Before first category groups query
5 1.0276639461517 Get Category List for Group Before the call to getCategoryList function
6 1.0276689529419 Start of GetCategoryList function Start of the function
7 1.0276761054993 Before getting categories Query to get specific category list
8 1.0293021202087 After getting categories Query to get specific category list
9 1.0293049812317 Before getting category custom Before call to function getCategoryCustom
10 1.0531659126282 After getting category custom After call to function getCategoryCustom
11 1.0531730651855 Before getting category custom Before call to function getCategoryCustom
12 1.0747010707855 After getting category custom After call to function getCategoryCustom
13 1.0747060775757 Before getting category custom Before call to function getCategoryCustom
14 1.0817620754242 After getting category custom After call to function getCategoryCustom
15 1.0817680358887 Before getting category custom Before call to function getCategoryCustom
16 1.0879859924316 After getting category custom After call to function getCategoryCustom
17 1.0879919528961 Before getting category custom Before call to function getCategoryCustom
18 1.0930700302124 After getting category custom After call to function getCategoryCustom
19 1.0930759906769 Before getting category custom Before call to function getCategoryCustom
20 1.0986909866333 After getting category custom After call to function getCategoryCustom
21 1.0986959934235 End of GetCategoryList function End of the function
22 1.0987050533295 Get Category List for Group Before the call to getCategoryList function
23 1.0987079143524 Start of GetCategoryList function Start of the function
24 1.0987119674683 Before getting categories Query to get specific category list
25 1.0993630886078 End of getCategoryListByGroup Function Before return()
26 1.6963279247284 App Controller End End of the App controller (called before the controller of every page)
27 1.7067120075226 Product Start Start of the product info controller
28 1.7276639938354 Cache file not found Starting get product details
29 1.7888550758362 Related products Start getting related products if enabled
30 1.7888579368591 Related Products Start Before the related products are found
31 1.7888600826263 Related Products Keywords Before the related product keywords are found
32 1.7888679504395 Create Keyword List Function Start of function
33 1.7890079021454 Create Keyword List Function After looping provided content - 44 keywords found
34 1.7915210723877 Create Keyword List Function After looping initial keyword list - 35 keywords remaining
35 1.7915370464325 Create Keyword List Function After reducing keyword list
36 1.7918310165405 Create Keyword List Function After selecting by scoring keywords
37 1.7918379306793 Create Keyword List Function After final loop of keywords
38 1.7918419837952 Related Products Keywords After the related product keywords are found
39 1.8915500640869 Related Products End After the related products are found
40 1.9546270370483 Product End End of the product info controller (Product Info)
41 1.9587829113007 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.9611110687256 Before Get Options Before the call to getOptions in the tpl class
43 2.060436964035 After Get Options After the call to getOptions in the tpl class
44 2.0607149600983 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.0607690811157 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.2544920444489 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.2545020580292 Product Info: Before Template Display Before the template is displayed
48 2.5079739093781 Product Info: After Template Display After the template is displayed
49 2.5080010890961 Finalizing debug Before the debug is output to the page.
50 2.5080270767212 End of App This is the end of the app logging, final timestamp


Query Debug - 251 Database Queries. Total time 1.0641 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0032 0.0031850337982178
SELECT parameter, value FROM parameters
2 0.0045 0.0045011043548584
SELECT * FROM `bad_bots`
3 0.0005 0.00046706199645996
SET time_zone = 'Europe/London'
4 0.0060 0.0059828758239746
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0036 0.0035979747772217
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"98.82.120.188\";}'
6 0.0027 0.0026760101318359
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1725937658'
7 0.0029 0.0028870105743408
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0006 0.0006101131439209
UPDATE autorun SET lastrun = '2024-09-10 03:07:38' WHERE id = '13'
9 0.0007 0.00067710876464844
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0027 0.0027079582214355
SELECT id FROM pages WHERE pagename = 'alter-Eco-the-rooibos-bio-40g-lot-de-4-vendu-par-lot-livraison' LIMIT 1
11 0.0026 0.0026218891143799
SELECT id FROM products WHERE pagename = 'alter-Eco-the-rooibos-bio-40g-lot-de-4-vendu-par-lot-livraison' AND hidden = 0 LIMIT 1
12 0.0104 0.010351896286011
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0265 0.02649188041687
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00066304206848145
SELECT * FROM pages WHERE pagename = 'alter-Eco-the-rooibos-bio-40g-lot-de-4-vendu-par-lot-livraison'
15 0.0017 0.0017421245574951
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0016 0.0015890598297119
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0064 0.0064470767974854
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18 0.0021 0.0020830631256104
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19 0.0022 0.0021531581878662
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0008 0.00076889991760254
SELECT id FROM categories WHERE parent_id = '26'
21 0.0065 0.0065019130706787
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
22 0.0019 0.0018661022186279
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
23 0.0017 0.0017480850219727
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
24 0.0015 0.0014700889587402
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00049304962158203
SELECT * FROM categorygroups WHERE id = '1'
26 0.0138 0.01382303237915
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27 0.0006 0.00064897537231445
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00045013427734375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0005 0.00047707557678223
SELECT id FROM categories WHERE parent_id = '27'
30 0.0039 0.0038571357727051
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
31 0.0006 0.00057315826416016
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
32 0.0005 0.00052905082702637
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
33 0.0005 0.00050187110900879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00045585632324219
SELECT * FROM categorygroups WHERE id = '1'
35 0.0015 0.001535177230835
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.00049400329589844
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00043797492980957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.0004880428314209
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0016741752624512
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
40 0.0006 0.00059890747070312
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
41 0.0006 0.0006411075592041
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
42 0.0005 0.00051689147949219
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00049710273742676
SELECT * FROM categorygroups WHERE id = '1'
44 0.0008 0.00076198577880859
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45 0.0006 0.00059008598327637
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00041007995605469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0012 0.0011610984802246
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00084304809570312
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0005 0.00054097175598145
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
50 0.0006 0.00055789947509766
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
51 0.0006 0.00055718421936035
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0006 0.00062298774719238
SELECT * FROM categorygroups WHERE id = '1'
53 0.0008 0.00075316429138184
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0006 0.00056004524230957
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55 0.0004 0.00040888786315918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0005 0.00046992301940918
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.000701904296875
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
58 0.0005 0.00051093101501465
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0006 0.00056219100952148
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
60 0.0005 0.00052404403686523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0004 0.00042200088500977
SELECT * FROM categorygroups WHERE id = '1'
62 0.0006 0.0006411075592041
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63 0.0005 0.00049614906311035
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64 0.0005 0.00046110153198242
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00045299530029297
SELECT id FROM categories WHERE parent_id = '31'
66 0.0010 0.00097084045410156
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
67 0.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 (31)
				  AND p.disabled = 0 
68 0.0007 0.00068211555480957
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
69 0.0006 0.00060105323791504
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00051498413085938
SELECT * FROM categorygroups WHERE id = '1'
71 0.0006 0.00063300132751465
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0033 0.0032799243927002
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0017 0.0017061233520508
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0008 0.00076103210449219
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75 0.0046 0.0046150684356689
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0021 0.0020899772644043
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0014 0.001446008682251
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.5744 0.57435917854309
SELECT * FROM ipgeocountries WHERE INET_ATON('98.82.120.188') >= INET_ATON(ip_start) AND INET_ATON('98.82.120.188') <= INET_ATON(ip_end)
79 0.0033 0.0033140182495117
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0022 0.0022389888763428
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0104 0.010386943817139
SELECT * FROM products WHERE pagename = 'alter-Eco-the-rooibos-bio-40g-lot-de-4-vendu-par-lot-livraison'
82 0.0010 0.00099706649780273
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3587
83 0.0010 0.00096607208251953
SELECT * FROM manufacturers WHERE id = '519'
84 0.0014 0.001399040222168
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '519'
85 0.0041 0.0041248798370361
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '519' LIMIT 1
86 0.0065 0.0065469741821289
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '519' ORDER BY RAND() LIMIT 1
87 0.0014 0.0013840198516846
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
88 0.0035 0.0035262107849121
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '519'
89 0.0020 0.0019629001617432
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '519'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0008 0.00081396102905273
SELECT * FROM manufacturerimages WHERE manufacturer_id = '519'
91 0.0006 0.00055694580078125
SELECT category_id FROM products_categories WHERE product_id = '3587'
92 0.0007 0.00065207481384277
SELECT * FROM categories WHERE id = '27'
93 0.0083 0.0082828998565674
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
94 0.0007 0.0007178783416748
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0004 0.00037503242492676
SELECT id FROM categories WHERE parent_id = '27'
96 0.0055 0.0055301189422607
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
97 0.0011 0.0011498928070068
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
98 0.0007 0.000701904296875
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
99 0.0006 0.00064611434936523
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0017 0.0016560554504395
SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
101 0.0026 0.0026249885559082
SELECT * FROM product_image_select WHERE product_id = '3587'
102 0.0021 0.0021300315856934
SELECT * FROM productcustomimages WHERE product_id = '3587'
103 0.0016 0.0015959739685059
SELECT * FROM productfeeds WHERE product_id = '3587' ORDER BY item_date DESC
104 0.0029 0.0029311180114746
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0044 0.0044019222259521
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3587' AND t.hidden = 0 AND display_product = 1
106 0.0014 0.0013751983642578
SELECT * FROM productamazoncontent WHERE product_id = '3587'
107 0.0008 0.00084805488586426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
108 0.0014 0.0013880729675293
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0006 0.00057792663574219
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0006 0.00063180923461914
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
112 0.0124 0.012403964996338
SELECT *, MATCH (description, title) AGAINST ('Ãco thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('Ãco thé rooibos' IN BOOLEAN MODE) AND 3587 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
113 0.0009 0.00088906288146973
SELECT *, MATCH (description, title) AGAINST ('Ãco thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('Ãco thé rooibos' IN BOOLEAN MODE) AND 3587 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0007 0.00074291229248047
SELECT *, MATCH (description, title) AGAINST ('Ãco thé rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('Ãco thé rooibos' IN BOOLEAN MODE) AND 3587 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00066399574279785
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
116 0.0007 0.00070905685424805
SELECT * FROM product_image_select WHERE product_id = '878'
117 0.0005 0.00050902366638184
SELECT * FROM productcustomimages WHERE product_id = '878'
118 0.0015 0.0015249252319336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
119 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0007 0.000701904296875
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00054287910461426
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0027 0.0027141571044922
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
123 0.0019 0.0018777847290039
SELECT * FROM product_image_select WHERE product_id = '865'
124 0.0006 0.00058603286743164
SELECT * FROM productcustomimages WHERE product_id = '865'
125 0.0013 0.0013370513916016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
126 0.0014 0.0013790130615234
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0006 0.00064897537231445
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0009 0.00089406967163086
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0020 0.0019640922546387
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
130 0.0010 0.00096797943115234
SELECT * FROM product_image_select WHERE product_id = '858'
131 0.0054 0.0054459571838379
SELECT * FROM productcustomimages WHERE product_id = '858'
132 0.0031 0.003122091293335
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
133 0.0014 0.0013880729675293
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0009 0.00088810920715332
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0010 0.0010421276092529
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0011 0.0010828971862793
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
137 0.0013 0.0013191699981689
SELECT * FROM product_image_select WHERE product_id = '890'
138 0.0009 0.00088191032409668
SELECT * FROM productcustomimages WHERE product_id = '890'
139 0.0027 0.0026941299438477
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
140 0.0009 0.00088286399841309
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0007 0.00074386596679688
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0009 0.00085592269897461
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0011 0.0011329650878906
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
144 0.0012 0.0012109279632568
SELECT * FROM product_image_select WHERE product_id = '869'
145 0.0007 0.00072503089904785
SELECT * FROM productcustomimages WHERE product_id = '869'
146 0.0017 0.0017368793487549
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
147 0.0057 0.0057308673858643
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0011 0.0010709762573242
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0008 0.00083708763122559
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0099 0.0099248886108398
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
151 0.0030 0.0029921531677246
SELECT * FROM product_image_select WHERE product_id = '862'
152 0.0009 0.00091814994812012
SELECT * FROM productcustomimages WHERE product_id = '862'
153 0.0158 0.015789985656738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
154 0.0010 0.0010380744934082
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
155 0.0009 0.000946044921875
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
156 0.0011 0.001147985458374
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157 0.0046 0.0046408176422119
SELECT id,asin FROM products WHERE parent_id = 3587
158 0.0097 0.0097229480743408
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3587' ORDER BY timestamp DESC
159 0.0062 0.006152868270874
SELECT category_id FROM products_categories WHERE product_id = '3587'
160 0.0040 0.0039570331573486
SELECT * FROM categories WHERE id = '27'
161 0.0080 0.007951021194458
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
162 0.0007 0.00074315071105957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
163 0.0006 0.00055694580078125
SELECT id FROM categories WHERE parent_id = '27'
164 0.0044 0.0043849945068359
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 
165 0.0006 0.00064277648925781
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 
166 0.0010 0.00096797943115234
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
167 0.0007 0.00070810317993164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
168 0.0014 0.0013959407806396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
169 0.0007 0.00071811676025391
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
170 0.0006 0.00058484077453613
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
171 0.0007 0.00065803527832031
SELECT * FROM products WHERE id = '3587'
172 0.0009 0.00093388557434082
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
173 0.0011 0.0010700225830078
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
174 0.0005 0.00052499771118164
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
175 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
176 0.0008 0.00078487396240234
SELECT category_id FROM products_categories WHERE product_id = '3587' AND prod_type = 'amz'
177 0.0006 0.00059199333190918
SELECT parent_id FROM categories WHERE id = '27'
178 0.0005 0.0004889965057373
SELECT * FROM categories WHERE id = '27'
179 0.0046 0.0045640468597412
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
180 0.0013 0.0012800693511963
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
181 0.0005 0.00047111511230469
SELECT id FROM categories WHERE parent_id = '27'
182 0.0050 0.0049898624420166
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 
183 0.0007 0.00069689750671387
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 
184 0.0008 0.00076508522033691
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
185 0.0006 0.00061678886413574
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
186 0.0026 0.0026040077209473
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
187 0.0018 0.0018091201782227
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
188 0.0004 0.00039100646972656
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
189 0.0204 0.020418882369995
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
190 0.0042 0.0041840076446533
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
191 0.0011 0.0011019706726074
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
192 0.0011 0.0010619163513184
SELECT * FROM products WHERE id = 1626
193 0.0007 0.00072288513183594
SELECT * FROM products WHERE id = 4041
194 0.0009 0.00091814994812012
SELECT * FROM products WHERE id = 4312
195 0.0023 0.002255916595459
SELECT * FROM products WHERE id = 777
196 0.0023 0.0023379325866699
SELECT * FROM products WHERE id = 3881
197 0.0027 0.0026659965515137
SELECT * FROM products WHERE id = 4213
198 0.0007 0.00072908401489258
SELECT * FROM products WHERE id = '1626'
199 0.0008 0.00082111358642578
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
200 0.0008 0.00082516670227051
SELECT * FROM product_image_select WHERE product_id = '1626'
201 0.0006 0.00055193901062012
SELECT * FROM productcustomimages WHERE product_id = '1626'
202 0.0012 0.0011739730834961
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
203 0.0008 0.00081181526184082
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
204 0.0006 0.00056314468383789
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0007 0.00069999694824219
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206 0.0007 0.00072789192199707
SELECT * FROM products WHERE id = '4041'
207 0.0006 0.00058412551879883
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
208 0.0011 0.0010719299316406
SELECT * FROM product_image_select WHERE product_id = '4041'
209 0.0013 0.001305103302002
SELECT * FROM productcustomimages WHERE product_id = '4041'
210 0.0021 0.0020568370819092
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
211 0.0008 0.00076699256896973
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
212 0.0011 0.0011169910430908
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
213 0.0007 0.00071096420288086
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214 0.0011 0.0010759830474854
SELECT * FROM products WHERE id = '4312'
215 0.0006 0.00062012672424316
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
216 0.0007 0.00069308280944824
SELECT * FROM product_image_select WHERE product_id = '4312'
217 0.0005 0.000518798828125
SELECT * FROM productcustomimages WHERE product_id = '4312'
218 0.0013 0.0012991428375244
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
219 0.0007 0.00068116188049316
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
220 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
221 0.0009 0.00092482566833496
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222 0.0010 0.0009620189666748
SELECT * FROM products WHERE id = '777'
223 0.0007 0.00069022178649902
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
224 0.0009 0.00090599060058594
SELECT * FROM product_image_select WHERE product_id = '777'
225 0.0013 0.0012688636779785
SELECT * FROM productcustomimages WHERE product_id = '777'
226 0.0014 0.0014469623565674
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
227 0.0077 0.0076758861541748
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
228 0.0005 0.00050497055053711
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
229 0.0005 0.00050806999206543
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230 0.0007 0.00069999694824219
SELECT * FROM products WHERE id = '3881'
231 0.0008 0.00078916549682617
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
232 0.0007 0.00067806243896484
SELECT * FROM product_image_select WHERE product_id = '3881'
233 0.0010 0.0010030269622803
SELECT * FROM productcustomimages WHERE product_id = '3881'
234 0.0014 0.0013830661773682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
235 0.0005 0.00054097175598145
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
236 0.0004 0.00043892860412598
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
237 0.0005 0.00054502487182617
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238 0.0007 0.00066590309143066
SELECT * FROM products WHERE id = '4213'
239 0.0008 0.0007929801940918
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
240 0.0008 0.00075292587280273
SELECT * FROM product_image_select WHERE product_id = '4213'
241 0.0010 0.00098490715026855
SELECT * FROM productcustomimages WHERE product_id = '4213'
242 0.0016 0.001615047454834
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
243 0.0006 0.00064802169799805
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
244 0.0005 0.00047588348388672
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
245 0.0009 0.00089788436889648
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246 0.0036 0.0035789012908936
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
247 0.0008 0.00083708763122559
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
248 0.0030 0.0030410289764404
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
249 0.0025 0.002467155456543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0007 0.00072002410888672
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
251 0.0014 0.0014228820800781
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'