0

Thés & Traditions - Blue Downs : Rooibos orange - mangue | 100g

Price: €9,39
Product prices and availability are accurate as of 2022-06-22 03:39:49 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

Rooibos bio issus des meilleurs plantations biologique. Vendu en sachet zip fraicheur de 100 grammes refermable Temps d'infusions : 7-10 min | température d'infusion : 100° | dosage : 15-20g / l Ingrédients: rooibos naturel*, arôme naturel, souci*, écorces d'orange*, fleurs de bleuet*, pétales de rose*, abricot*. *issu de l'agriculture biologique Bio : tout les thés de la maison thés & traditions sont certifié bio par l'organisme français ecocert

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
0.98988199234009 260 0.2017 0


No Amazon API Requests Made.


App Debug - Total Time 0.98988199234009 seconds

Number Time From Start Name Description
1 0.68528389930725 Initialise Initialise FSB Function
2 0.68857598304749 App Controller Start Start of the App controller (called before the controller of every page)
3 0.69175696372986 Start of getCategoryListByGroup Function Before first category groups query
4 0.69214296340942 After initial query Before first category groups query
5 0.69214487075806 Get Category List for Group Before the call to getCategoryList function
6 0.69214797019958 Start of GetCategoryList function Start of the function
7 0.69215083122253 Before getting categories Query to get specific category list
8 0.69259691238403 After getting categories Query to get specific category list
9 0.69259786605835 Before getting category custom Before call to function getCategoryCustom
10 0.71919202804565 After getting category custom After call to function getCategoryCustom
11 0.7191948890686 Before getting category custom Before call to function getCategoryCustom
12 0.72193694114685 After getting category custom After call to function getCategoryCustom
13 0.72193884849548 Before getting category custom Before call to function getCategoryCustom
14 0.72787690162659 After getting category custom After call to function getCategoryCustom
15 0.7278790473938 Before getting category custom Before call to function getCategoryCustom
16 0.73128795623779 After getting category custom After call to function getCategoryCustom
17 0.73128986358643 Before getting category custom Before call to function getCategoryCustom
18 0.73456287384033 After getting category custom After call to function getCategoryCustom
19 0.73456501960754 Before getting category custom Before call to function getCategoryCustom
20 0.73868489265442 After getting category custom After call to function getCategoryCustom
21 0.73868703842163 End of GetCategoryList function End of the function
22 0.73868989944458 Get Category List for Group Before the call to getCategoryList function
23 0.73869204521179 Start of GetCategoryList function Start of the function
24 0.73869395256042 Before getting categories Query to get specific category list
25 0.73925399780273 End of getCategoryListByGroup Function Before return()
26 0.74594283103943 App Controller End End of the App controller (called before the controller of every page)
27 0.74654793739319 Product Start Start of the product info controller
28 0.76386499404907 Cache file not found Starting get product details
29 0.80266094207764 Related products Start getting related products if enabled
30 0.80266284942627 Related Products Start Before the related products are found
31 0.80266404151917 Related Products Keywords Before the related product keywords are found
32 0.80266690254211 Create Keyword List Function Start of function
33 0.80273389816284 Create Keyword List Function After looping provided content - 24 keywords found
34 0.80369591712952 Create Keyword List Function After looping initial keyword list - 24 keywords remaining
35 0.80370283126831 Create Keyword List Function After reducing keyword list
36 0.80375790596008 Create Keyword List Function After selecting by scoring keywords
37 0.80376100540161 Create Keyword List Function After final loop of keywords
38 0.80376195907593 Related Products Keywords After the related product keywords are found
39 0.83624696731567 Related Products End After the related products are found
40 0.84994888305664 Product End End of the product info controller (Product Info)
41 0.85100889205933 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 0.85189604759216 Before Get Options Before the call to getOptions in the tpl class
43 0.90588903427124 After Get Options After the call to getOptions in the tpl class
44 0.90600800514221 App_after Controller End End of the App_after controller (called after the controller of every page)
45 0.90602993965149 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 0.92023301124573 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 0.92023682594299 Product Info: Before Template Display Before the template is displayed
48 0.98986101150513 Product Info: After Template Display After the template is displayed
49 0.98986983299255 Finalizing debug Before the debug is output to the page.
50 0.98988103866577 End of App This is the end of the app logging, final timestamp


Query Debug - 260 Database Queries. Total time 0.2017 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0007 0.00072312355041504
SELECT parameter, value FROM parameters
2 0.0012 0.0012071132659912
SELECT * FROM `bad_bots`
3 0.0006 0.00064587593078613
SET time_zone = 'Europe/London'
4 0.0004 0.00038814544677734
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0009 0.00092601776123047
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.236.65.63\";}'
6 0.0008 0.00079607963562012
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1670344725'
7 0.0013 0.0012528896331787
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00053215026855469
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0011 0.0010709762573242
SELECT id FROM pages WHERE pagename = 'thes-traditions-blue-downs-rooibos-orange-mangue-100g' LIMIT 1
10 0.0010 0.0009620189666748
SELECT id FROM products WHERE pagename = 'thes-traditions-blue-downs-rooibos-orange-mangue-100g' AND hidden = 0 LIMIT 1
11 0.0011 0.0010790824890137
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0009 0.00093507766723633
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00069618225097656
SELECT * FROM pages WHERE pagename = 'thes-traditions-blue-downs-rooibos-orange-mangue-100g'
14 0.0004 0.00037407875061035
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00042510032653809
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0109 0.010943174362183
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.0004 0.00043296813964844
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.0003 0.00030684471130371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0007 0.0007331371307373
SELECT id FROM categories WHERE parent_id = '26'
20 0.0125 0.01250696182251
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.0004 0.00043177604675293
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.0004 0.00040411949157715
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.0003 0.00027298927307129
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00039887428283691
SELECT * FROM categorygroups WHERE id = '1'
25 0.0004 0.00040388107299805
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.0003 0.00032711029052734
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.0003 0.00026798248291016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0003 0.0002751350402832
SELECT id FROM categories WHERE parent_id = '27'
29 0.0003 0.00025296211242676
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.0003 0.00027298927307129
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.0003 0.00028300285339355
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.0003 0.00028204917907715
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00027608871459961
SELECT * FROM categorygroups WHERE id = '1'
34 0.0019 0.0019149780273438
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.0003 0.00026583671569824
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.0003 0.00026798248291016
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00027203559875488
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.0004 0.00036501884460449
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.0003 0.00026488304138184
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.0003 0.00025510787963867
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00026798248291016
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00065398216247559
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.0003 0.00028586387634277
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.0003 0.00026202201843262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00025486946105957
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00061893463134766
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.0003 0.00029206275939941
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.0003 0.00027203559875488
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.0004 0.00038909912109375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0003 0.00028705596923828
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00054693222045898
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.0003 0.00030994415283203
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.0003 0.00026392936706543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0003 0.0002589225769043
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00066590309143066
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.0003 0.00032591819763184
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.0003 0.00027108192443848
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.0003 0.00026607513427734
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0003 0.00026798248291016
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00067496299743652
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.0004 0.00039911270141602
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.0003 0.00028204917907715
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0003 0.00026202201843262
SELECT id FROM categories WHERE parent_id = '31'
65 0.0007 0.00066995620727539
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.0003 0.00026702880859375
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.0003 0.00031018257141113
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.00069689750671387
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00047588348388672
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00054407119750977
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0004 0.00044918060302734
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0005 0.00053310394287109
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0005 0.00051999092102051
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.00042200088500977
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0005 0.00047397613525391
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010190010070801
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0004 0.00037598609924316
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.65.63') >= INET_ATON(ip_start) AND INET_ATON('3.236.65.63') <= INET_ATON(ip_end)
78 0.0004 0.00044798851013184
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0005 0.00046300888061523
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00081396102905273
SELECT * FROM products WHERE pagename = 'thes-traditions-blue-downs-rooibos-orange-mangue-100g'
81 0.0018 0.0017969608306885
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1268
82 0.0006 0.00060009956359863
SELECT * FROM manufacturers WHERE id = '245'
83 0.0009 0.00093793869018555
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '245'
84 0.0004 0.00043201446533203
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '245' LIMIT 1
85 0.0015 0.0015110969543457
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '245' ORDER BY RAND() LIMIT 1
86 0.0005 0.00051307678222656
SELECT * FROM productimages WHERE product_id = '1121' ORDER BY sortorder ASC
87 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '245'
88 0.0010 0.0010170936584473
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '245'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0004 0.00043392181396484
SELECT * FROM manufacturerimages WHERE manufacturer_id = '245'
90 0.0019 0.0019230842590332
SELECT category_id FROM products_categories WHERE product_id = '1268'
91 0.0004 0.0004279613494873
SELECT * FROM categories WHERE id = '27'
92 0.0076 0.0076320171356201
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.0004 0.00035285949707031
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94 0.0004 0.00036811828613281
SELECT id FROM categories WHERE parent_id = '27'
95 0.0055 0.0054941177368164
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.0004 0.00041484832763672
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.0004 0.0004270076751709
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.00048494338989258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99 0.0005 0.00048494338989258
SELECT * FROM productimages WHERE product_id = '1268' ORDER BY sortorder ASC
100 0.0004 0.00042510032653809
SELECT * FROM product_image_select WHERE product_id = '1268'
101 0.0004 0.0004119873046875
SELECT * FROM productcustomimages WHERE product_id = '1268'
102 0.0007 0.0007469654083252
SELECT * FROM productfeeds WHERE product_id = '1268' ORDER BY item_date DESC
103 0.0009 0.00092506408691406
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1268' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0009 0.00092005729675293
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1268' AND t.hidden = 0 AND display_product = 1
105 0.0005 0.00052404403686523
SELECT * FROM tags WHERE id = '771'
106 0.0011 0.0011441707611084
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '771'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
107 0.0008 0.00083684921264648
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '771'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
108 0.0009 0.00090312957763672
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '771' 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.0004 0.00041508674621582
SELECT * FROM productimages WHERE product_id = '1232' ORDER BY sortorder ASC
110 0.0004 0.0003809928894043
SELECT * FROM tags WHERE id = '775'
111 0.0010 0.0010020732879639
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '775'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
112 0.0010 0.00099492073059082
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '775'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
113 0.0009 0.00088596343994141
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '775' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
114 0.0005 0.00045680999755859
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
115 0.0009 0.00090694427490234
SELECT * FROM productamazoncontent WHERE product_id = '1268'
116 0.0005 0.0004727840423584
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1268' AND a.name = n.originalname
117 0.0006 0.0006411075592041
SELECT * FROM productoffers WHERE product_id = '1268' AND merchantid = 'A1X6FK5RDHNB96'
118 0.0004 0.00040912628173828
SELECT * FROM productoffers
                WHERE product_id = '1268' AND price > 0
                ORDER BY price ASC LIMIT 1
119 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '1268' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0003 0.00029301643371582
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
121 0.0081 0.0080761909484863
SELECT *, MATCH (description, title) AGAINST ('thés andamp traditions' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thés andamp traditions' IN BOOLEAN MODE) AND 1268 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
122 0.0010 0.00096893310546875
SELECT *, MATCH (description, title) AGAINST ('thés andamp traditions' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thés andamp traditions' IN BOOLEAN MODE) AND 1268 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
123 0.0009 0.00089621543884277
SELECT *, MATCH (description, title) AGAINST ('thés andamp traditions' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thés andamp traditions' IN BOOLEAN MODE) AND 1268 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
124 0.0006 0.00055098533630371
SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
125 0.0004 0.00041508674621582
SELECT * FROM product_image_select WHERE product_id = '998'
126 0.0004 0.00043201446533203
SELECT * FROM productcustomimages WHERE product_id = '998'
127 0.0005 0.00048279762268066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
128 0.0005 0.0004730224609375
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
129 0.0005 0.00054693222045898
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
130 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0005 0.00046396255493164
SELECT * FROM productimages WHERE product_id = '2803' ORDER BY sortorder ASC
132 0.0005 0.00054311752319336
SELECT * FROM product_image_select WHERE product_id = '2803'
133 0.0006 0.0006098747253418
SELECT * FROM productcustomimages WHERE product_id = '2803'
134 0.0006 0.00060820579528809
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2803' AND a.name = n.originalname
135 0.0004 0.00041103363037109
SELECT * FROM productoffers WHERE product_id = '2803' AND merchantid = 'A1X6FK5RDHNB96'
136 0.0004 0.00037312507629395
SELECT * FROM productoffers
                WHERE product_id = '2803' AND price > 0
                ORDER BY price ASC LIMIT 1
137 0.0003 0.00028705596923828
SELECT value FROM productattributes WHERE product_id = '2803' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138 0.0005 0.00045204162597656
SELECT * FROM productimages WHERE product_id = '1543' ORDER BY sortorder ASC
139 0.0005 0.00046491622924805
SELECT * FROM product_image_select WHERE product_id = '1543'
140 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '1543'
141 0.0004 0.00043392181396484
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1543' AND a.name = n.originalname
142 0.0005 0.00053095817565918
SELECT * FROM productoffers WHERE product_id = '1543' AND merchantid = 'A1X6FK5RDHNB96'
143 0.0005 0.00048089027404785
SELECT * FROM productoffers
                WHERE product_id = '1543' AND price > 0
                ORDER BY price ASC LIMIT 1
144 0.0003 0.00028181076049805
SELECT value FROM productattributes WHERE product_id = '1543' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145 0.0007 0.00071811676025391
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
146 0.0007 0.00069499015808105
SELECT * FROM product_image_select WHERE product_id = '780'
147 0.0006 0.00056314468383789
SELECT * FROM productcustomimages WHERE product_id = '780'
148 0.0016 0.0015649795532227
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
149 0.0009 0.00085091590881348
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
150 0.0008 0.00075411796569824
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
151 0.0008 0.00076794624328613
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0004 0.0004279613494873
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
153 0.0003 0.00030994415283203
SELECT * FROM product_image_select WHERE product_id = '4919'
154 0.0003 0.00034999847412109
SELECT * FROM productcustomimages WHERE product_id = '4919'
155 0.0004 0.00039005279541016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
156 0.0003 0.00033783912658691
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0004 0.00038695335388184
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0004 0.00042986869812012
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159 0.0003 0.00033688545227051
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
160 0.0004 0.00037908554077148
SELECT * FROM product_image_select WHERE product_id = '4924'
161 0.0004 0.00043392181396484
SELECT * FROM productcustomimages WHERE product_id = '4924'
162 0.0005 0.00054383277893066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
163 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0004 0.00038504600524902
SELECT * FROM productoffers
                WHERE product_id = '4924' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0004 0.00035905838012695
SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166 0.0009 0.00087904930114746
SELECT id,asin FROM products WHERE parent_id = 1268
167 0.0006 0.00058507919311523
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1268' ORDER BY timestamp DESC
168 0.0005 0.00051212310791016
SELECT category_id FROM products_categories WHERE product_id = '1268'
169 0.0005 0.00053596496582031
SELECT * FROM categories WHERE id = '27'
170 0.0005 0.00045394897460938
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.0004 0.00040888786315918
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
172 0.0005 0.00046896934509277
SELECT id FROM categories WHERE parent_id = '27'
173 0.0004 0.00042605400085449
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.0005 0.00045108795166016
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.0004 0.00039815902709961
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.0004 0.00035881996154785
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
177 0.0005 0.00045108795166016
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1268' AND a.name = n.originalname
178 0.0004 0.00043392181396484
SELECT * FROM productoffers WHERE product_id = '1268' AND merchantid = 'A1X6FK5RDHNB96'
179 0.0004 0.00044608116149902
SELECT * FROM productoffers
                WHERE product_id = '1268' AND price > 0
                ORDER BY price ASC LIMIT 1
180 0.0007 0.00068306922912598
SELECT * FROM products WHERE id = '1268'
181 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '1268' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182 0.0003 0.00032305717468262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1268' AND a.name = n.originalname
183 0.0003 0.00029802322387695
SELECT * FROM productoffers WHERE product_id = '1268' AND merchantid = 'A1X6FK5RDHNB96'
184 0.0004 0.00044012069702148
SELECT * FROM productoffers
                WHERE product_id = '1268' AND price > 0
                ORDER BY price ASC LIMIT 1
185 0.0006 0.00060510635375977
SELECT category_id FROM products_categories WHERE product_id = '1268' AND prod_type = 'amz'
186 0.0004 0.00040698051452637
SELECT parent_id FROM categories WHERE id = '27'
187 0.0005 0.00050592422485352
SELECT * FROM categories WHERE id = '27'
188 0.0004 0.00040411949157715
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.0005 0.00049114227294922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190 0.0004 0.00044918060302734
SELECT id FROM categories WHERE parent_id = '27'
191 0.0003 0.00034022331237793
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.0003 0.00034999847412109
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.0004 0.00042200088500977
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.0004 0.00036311149597168
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195 0.0005 0.0005190372467041
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
196 0.0004 0.00036883354187012
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
197 0.0005 0.00045895576477051
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
198 0.0206 0.020611047744751
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.0005 0.00045013427734375
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.0004 0.00042390823364258
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.0007 0.00069212913513184
SELECT * FROM products WHERE id = 1626
202 0.0006 0.00057005882263184
SELECT * FROM products WHERE id = 4041
203 0.0006 0.00055289268493652
SELECT * FROM products WHERE id = 4312
204 0.0007 0.00069594383239746
SELECT * FROM products WHERE id = 777
205 0.0006 0.00055193901062012
SELECT * FROM products WHERE id = 4213
206 0.0006 0.00060009956359863
SELECT * FROM products WHERE id = 3881
207 0.0006 0.00060081481933594
SELECT * FROM products WHERE id = '1626'
208 0.0004 0.0004420280456543
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
209 0.0004 0.00040888786315918
SELECT * FROM product_image_select WHERE product_id = '1626'
210 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '1626'
211 0.0004 0.0004429817199707
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
212 0.0005 0.00046610832214355
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0006 0.00064492225646973
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0004 0.00043201446533203
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0007 0.00070905685424805
SELECT * FROM products WHERE id = '4041'
216 0.0003 0.00034594535827637
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
217 0.0004 0.00041294097900391
SELECT * FROM product_image_select WHERE product_id = '4041'
218 0.0004 0.00043892860412598
SELECT * FROM productcustomimages WHERE product_id = '4041'
219 0.0006 0.00063300132751465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
220 0.0005 0.00046896934509277
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0004 0.00038409233093262
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0007 0.00065898895263672
SELECT * FROM products WHERE id = '4312'
224 0.0004 0.00035977363586426
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
225 0.0004 0.00041794776916504
SELECT * FROM product_image_select WHERE product_id = '4312'
226 0.0004 0.00040006637573242
SELECT * FROM productcustomimages WHERE product_id = '4312'
227 0.0004 0.00041508674621582
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
228 0.0005 0.00046706199645996
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0006 0.00064206123352051
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0005 0.00047993659973145
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0008 0.00083303451538086
SELECT * FROM products WHERE id = '777'
232 0.0005 0.00048398971557617
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
233 0.0005 0.00051403045654297
SELECT * FROM product_image_select WHERE product_id = '777'
234 0.0005 0.00052905082702637
SELECT * FROM productcustomimages WHERE product_id = '777'
235 0.0006 0.00061392784118652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
236 0.0006 0.00063395500183105
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0007 0.00065898895263672
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0005 0.00050210952758789
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0008 0.00082492828369141
SELECT * FROM products WHERE id = '4213'
240 0.0004 0.00044703483581543
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
241 0.0004 0.0004119873046875
SELECT * FROM product_image_select WHERE product_id = '4213'
242 0.0004 0.00037789344787598
SELECT * FROM productcustomimages WHERE product_id = '4213'
243 0.0006 0.00056600570678711
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
244 0.0005 0.00051712989807129
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0006 0.00057101249694824
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0004 0.00039100646972656
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0008 0.00080084800720215
SELECT * FROM products WHERE id = '3881'
248 0.0005 0.00054287910461426
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
249 0.0004 0.00044107437133789
SELECT * FROM product_image_select WHERE product_id = '3881'
250 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '3881'
251 0.0005 0.00046896934509277
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
252 0.0004 0.00037407875061035
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
253 0.0004 0.00037407875061035
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
254 0.0003 0.00032997131347656
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255 0.0005 0.0005028247833252
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
256 0.0005 0.00045895576477051
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
257 0.0006 0.00056695938110352
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
258 0.0005 0.00045394897460938
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
259 0.0004 0.00043797492980957
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0007 0.00071597099304199
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'