0

Florisens thé vert sencha bio - Sachet de 85 g

Price: €9,90
Product prices and availability are accurate as of 2022-06-22 02:46:43 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

Thé vert japonais Sencha Bio - Sachet de 85 g.

There are no customer reviews yet. Be the first to Write a Review!

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5927789211273 250 0.8726 0


No Amazon API Requests Made.


App Debug - Total Time 1.5927789211273 seconds

Number Time From Start Name Description
1 0.68770289421082 Initialise Initialise FSB Function
2 0.69754695892334 App Controller Start Start of the App controller (called before the controller of every page)
3 0.7351758480072 Start of getCategoryListByGroup Function Before first category groups query
4 0.7370228767395 After initial query Before first category groups query
5 0.73702478408813 Get Category List for Group Before the call to getCategoryList function
6 0.73702883720398 Start of GetCategoryList function Start of the function
7 0.73703289031982 Before getting categories Query to get specific category list
8 0.73853492736816 After getting categories Query to get specific category list
9 0.73853588104248 Before getting category custom Before call to function getCategoryCustom
10 0.76409983634949 After getting category custom After call to function getCategoryCustom
11 0.76410484313965 Before getting category custom Before call to function getCategoryCustom
12 0.77512383460999 After getting category custom After call to function getCategoryCustom
13 0.77512884140015 Before getting category custom Before call to function getCategoryCustom
14 0.78232789039612 After getting category custom After call to function getCategoryCustom
15 0.78233289718628 Before getting category custom Before call to function getCategoryCustom
16 0.78719282150269 After getting category custom After call to function getCategoryCustom
17 0.78719687461853 Before getting category custom Before call to function getCategoryCustom
18 0.79241299629211 After getting category custom After call to function getCategoryCustom
19 0.79242491722107 Before getting category custom Before call to function getCategoryCustom
20 0.79783177375793 After getting category custom After call to function getCategoryCustom
21 0.7978367805481 End of GetCategoryList function End of the function
22 0.79784679412842 Get Category List for Group Before the call to getCategoryList function
23 0.79785084724426 Start of GetCategoryList function Start of the function
24 0.79785394668579 Before getting categories Query to get specific category list
25 0.79839897155762 End of getCategoryListByGroup Function Before return()
26 1.3455259799957 App Controller End End of the App controller (called before the controller of every page)
27 1.3462147712708 Product Start Start of the product info controller
28 1.3587989807129 Cache file not found Starting get product details
29 1.4087588787079 Related products Start getting related products if enabled
30 1.4087607860565 Related Products Start Before the related products are found
31 1.4087629318237 Related Products Keywords Before the related product keywords are found
32 1.4087669849396 Create Keyword List Function Start of function
33 1.4087989330292 Create Keyword List Function After looping provided content - 24 keywords found
34 1.4096989631653 Create Keyword List Function After looping initial keyword list - 19 keywords remaining
35 1.4097068309784 Create Keyword List Function After reducing keyword list
36 1.4097669124603 Create Keyword List Function After selecting by scoring keywords
37 1.4097719192505 Create Keyword List Function After final loop of keywords
38 1.4097738265991 Related Products Keywords After the related product keywords are found
39 1.4540898799896 Related Products End After the related products are found
40 1.4746208190918 Product End End of the product info controller (Product Info)
41 1.4779617786407 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.4797778129578 Before Get Options Before the call to getOptions in the tpl class
43 1.5599818229675 After Get Options After the call to getOptions in the tpl class
44 1.5601058006287 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.5601408481598 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.5713667869568 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.5713717937469 Product Info: Before Template Display Before the template is displayed
48 1.592750787735 Product Info: After Template Display After the template is displayed
49 1.5927648544312 Finalizing debug Before the debug is output to the page.
50 1.592777967453 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 0.8726 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0012 0.001230001449585
SELECT parameter, value FROM parameters
2 0.0075 0.0074710845947266
SELECT * FROM `bad_bots`
3 0.0005 0.0005040168762207
SET time_zone = 'Europe/London'
4 0.0025 0.002467155456543
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0032 0.0031759738922119
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.90\";}'
6 0.0028 0.0028181076049805
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1733081554'
7 0.0041 0.0041050910949707
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0010 0.00096583366394043
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0039 0.003943920135498
SELECT id FROM pages WHERE pagename = 'florisens-the-vert-sencha-bio-sachet-de-85-g' LIMIT 1
10 0.0042 0.0041561126708984
SELECT id FROM products WHERE pagename = 'florisens-the-vert-sencha-bio-sachet-de-85-g' AND hidden = 0 LIMIT 1
11 0.0052 0.0051999092102051
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0313 0.031335115432739
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00061583518981934
SELECT * FROM pages WHERE pagename = 'florisens-the-vert-sencha-bio-sachet-de-85-g'
14 0.0018 0.0018329620361328
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0015 0.0014820098876953
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0086 0.0086030960083008
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0022 0.0021908283233643
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.0016 0.001600980758667
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0006 0.00057506561279297
SELECT id FROM categories WHERE parent_id = '26'
20 0.0075 0.0075030326843262
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.0015 0.00154709815979
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.0015 0.0014781951904297
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.0014 0.0013558864593506
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00053286552429199
SELECT * FROM categorygroups WHERE id = '1'
25 0.0037 0.0036599636077881
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00053882598876953
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00044512748718262
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00046515464782715
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0036659240722656
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.00060892105102539
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
31 0.0006 0.00055599212646484
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.0005 0.0004889965057373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00042200088500977
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014469623565674
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.0009 0.00085687637329102
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.0005 0.00046491622924805
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00046181678771973
SELECT id FROM categories WHERE parent_id = '28'
38 0.0018 0.0017859935760498
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.0005 0.00051498413085938
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.0005 0.00050997734069824
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.0005 0.00050091743469238
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00050711631774902
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00061607360839844
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.0005 0.0005338191986084
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.0005 0.00046586990356445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043606758117676
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.0007021427154541
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.00056886672973633
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.0005 0.00050806999206543
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.00046396255493164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00042390823364258
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00071191787719727
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.00057697296142578
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0005 0.00048685073852539
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00044798851013184
SELECT id FROM categories WHERE parent_id = '30'
56 0.0007 0.00070905685424805
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
57 0.0006 0.0005800724029541
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.0005 0.00053095817565918
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.00053310394287109
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00050187110900879
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00070786476135254
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00051498413085938
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.00046896934509277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00052404403686523
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00083303451538086
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.0006 0.00061202049255371
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.00057601928710938
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.00052499771118164
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00050091743469238
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00052595138549805
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0029 0.0029129981994629
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0016 0.0015661716461182
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.00055909156799316
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.0012 0.001209020614624
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011270046234131
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0010 0.0010170936584473
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5324 0.53244113922119
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.90') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.90') <= INET_ATON(ip_end)
78 0.0022 0.0022449493408203
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0013711452484131
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0009 0.00092792510986328
SELECT * FROM products WHERE pagename = 'florisens-the-vert-sencha-bio-sachet-de-85-g'
81 0.0004 0.00043201446533203
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1237
82 0.0006 0.00064396858215332
SELECT * FROM manufacturers WHERE id = '290'
83 0.0015 0.001460075378418
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '290'
84 0.0035 0.0035009384155273
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '290' LIMIT 1
85 0.0039 0.0039181709289551
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '290' ORDER BY RAND() LIMIT 1
86 0.0008 0.00080490112304688
SELECT * FROM productimages WHERE product_id = '1237' ORDER BY sortorder ASC
87 0.0008 0.00080990791320801
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '290'
88 0.0009 0.00094819068908691
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '290'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0009 0.00092005729675293
SELECT * FROM manufacturerimages WHERE manufacturer_id = '290'
90 0.0008 0.00077414512634277
SELECT category_id FROM products_categories WHERE product_id = '1237'
91 0.0008 0.00083804130554199
SELECT * FROM categories WHERE id = '28'
92 0.0037 0.0037338733673096
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
93 0.0007 0.00071310997009277
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
94 0.0005 0.00052905082702637
SELECT id FROM categories WHERE parent_id = '28'
95 0.0027 0.0027070045471191
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 
96 0.0008 0.00078415870666504
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 
97 0.0009 0.0008699893951416
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
98 0.0009 0.00092506408691406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
99 0.0009 0.0009160041809082
SELECT * FROM productimages WHERE product_id = '1237' ORDER BY sortorder ASC
100 0.0036 0.0036160945892334
SELECT * FROM product_image_select WHERE product_id = '1237'
101 0.0024 0.0024440288543701
SELECT * FROM productcustomimages WHERE product_id = '1237'
102 0.0019 0.0018980503082275
SELECT * FROM productfeeds WHERE product_id = '1237' ORDER BY item_date DESC
103 0.0048 0.0048210620880127
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0034 0.0033578872680664
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1237' AND t.hidden = 0 AND display_product = 1
105 0.0020 0.0020248889923096
SELECT * FROM productamazoncontent WHERE product_id = '1237'
106 0.0016 0.0015950202941895
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname
107 0.0020 0.0019800662994385
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00052404403686523
SELECT * FROM productoffers
                WHERE product_id = '1237' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0007 0.00066781044006348
SELECT value FROM productattributes WHERE product_id = '1237' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0006 0.00057315826416016
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
111 0.0160 0.015991926193237
SELECT *, MATCH (description, title) AGAINST ('florisens thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('florisens thé vert' IN BOOLEAN MODE) AND 1237 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0007 0.00073885917663574
SELECT *, MATCH (description, title) AGAINST ('florisens thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('florisens thé vert' IN BOOLEAN MODE) AND 1237 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0008 0.000762939453125
SELECT *, MATCH (description, title) AGAINST ('florisens thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('florisens thé vert' IN BOOLEAN MODE) AND 1237 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0005 0.00050592422485352
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC
115 0.0006 0.00064206123352051
SELECT * FROM product_image_select WHERE product_id = '866'
116 0.0004 0.00040316581726074
SELECT * FROM productcustomimages WHERE product_id = '866'
117 0.0014 0.0014278888702393
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname
118 0.0006 0.00058579444885254
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0005 0.00052404403686523
SELECT * FROM productoffers
                WHERE product_id = '866' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00052309036254883
SELECT value FROM productattributes WHERE product_id = '866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0006 0.00064301490783691
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
122 0.0008 0.00078201293945312
SELECT * FROM product_image_select WHERE product_id = '853'
123 0.0004 0.00044608116149902
SELECT * FROM productcustomimages WHERE product_id = '853'
124 0.0010 0.00099015235900879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
125 0.0005 0.00050592422485352
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00045394897460938
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0004 0.00044393539428711
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0006 0.00056600570678711
SELECT * FROM productimages WHERE product_id = '842' ORDER BY sortorder ASC
129 0.0006 0.00064706802368164
SELECT * FROM product_image_select WHERE product_id = '842'
130 0.0004 0.00041985511779785
SELECT * FROM productcustomimages WHERE product_id = '842'
131 0.0012 0.0011661052703857
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '842' AND a.name = n.originalname
132 0.0005 0.00052094459533691
SELECT * FROM productoffers WHERE product_id = '842' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '842' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0004 0.00041389465332031
SELECT value FROM productattributes WHERE product_id = '842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.0005500316619873
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
136 0.0007 0.00071597099304199
SELECT * FROM product_image_select WHERE product_id = '857'
137 0.0004 0.00043296813964844
SELECT * FROM productcustomimages WHERE product_id = '857'
138 0.0010 0.0010130405426025
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
139 0.0005 0.00046110153198242
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0007 0.00067496299743652
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
143 0.0006 0.00059890747070312
SELECT * FROM product_image_select WHERE product_id = '868'
144 0.0004 0.00041007995605469
SELECT * FROM productcustomimages WHERE product_id = '868'
145 0.0009 0.00088095664978027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
146 0.0005 0.0004570484161377
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0004 0.0003809928894043
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00043392181396484
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0007 0.00070309638977051
SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC
150 0.0007 0.00069689750671387
SELECT * FROM product_image_select WHERE product_id = '931'
151 0.0004 0.00040912628173828
SELECT * FROM productcustomimages WHERE product_id = '931'
152 0.0013 0.0012710094451904
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname
153 0.0005 0.00049090385437012
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0006 0.00057005882263184
SELECT * FROM productoffers
                WHERE product_id = '931' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0005 0.00053596496582031
SELECT value FROM productattributes WHERE product_id = '931' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0005 0.00047707557678223
SELECT id,asin FROM products WHERE parent_id = 1237
157 0.0018 0.0017731189727783
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1237' ORDER BY timestamp DESC
158 0.0004 0.00044608116149902
SELECT category_id FROM products_categories WHERE product_id = '1237'
159 0.0005 0.00046896934509277
SELECT * FROM categories WHERE id = '28'
160 0.0016 0.0015959739685059
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
161 0.0004 0.00040221214294434
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
162 0.0003 0.0003049373626709
SELECT id FROM categories WHERE parent_id = '28'
163 0.0016 0.0015928745269775
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 
164 0.0005 0.00052499771118164
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 
165 0.0005 0.00052404403686523
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
166 0.0005 0.00047588348388672
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
167 0.0013 0.0013210773468018
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname
168 0.0005 0.00047206878662109
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0004 0.00044083595275879
SELECT * FROM productoffers
                WHERE product_id = '1237' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0006 0.0005800724029541
SELECT * FROM products WHERE id = '1237'
171 0.0005 0.00051403045654297
SELECT value FROM productattributes WHERE product_id = '1237' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0010 0.00095200538635254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname
173 0.0004 0.00035810470581055
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00041985511779785
SELECT * FROM productoffers
                WHERE product_id = '1237' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0005 0.00045299530029297
SELECT category_id FROM products_categories WHERE product_id = '1237' AND prod_type = 'amz'
176 0.0004 0.00042819976806641
SELECT parent_id FROM categories WHERE id = '28'
177 0.0004 0.00035810470581055
SELECT * FROM categories WHERE id = '28'
178 0.0015 0.0014870166778564
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
179 0.0004 0.00043797492980957
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
180 0.0003 0.00032687187194824
SELECT id FROM categories WHERE parent_id = '28'
181 0.0015 0.0015079975128174
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 
182 0.0005 0.00046896934509277
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 
183 0.0005 0.00054788589477539
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
184 0.0005 0.00046801567077637
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
185 0.0027 0.002701997756958
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
186 0.0014 0.0014040470123291
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0003 0.00034189224243164
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0141 0.014079093933105
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
189 0.0016 0.0016469955444336
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
190 0.0006 0.0005500316619873
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
191 0.0006 0.000579833984375
SELECT * FROM products WHERE id = 1626
192 0.0006 0.00063920021057129
SELECT * FROM products WHERE id = 4041
193 0.0006 0.00061511993408203
SELECT * FROM products WHERE id = 4312
194 0.0006 0.00059008598327637
SELECT * FROM products WHERE id = 777
195 0.0006 0.00055694580078125
SELECT * FROM products WHERE id = 3881
196 0.0006 0.00061607360839844
SELECT * FROM products WHERE id = 4213
197 0.0006 0.00057506561279297
SELECT * FROM products WHERE id = '1626'
198 0.0005 0.00047802925109863
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
199 0.0007 0.00072813034057617
SELECT * FROM product_image_select WHERE product_id = '1626'
200 0.0005 0.00046396255493164
SELECT * FROM productcustomimages WHERE product_id = '1626'
201 0.0010 0.00099897384643555
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
202 0.0005 0.00052309036254883
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0005 0.00046110153198242
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0005 0.00052809715270996
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.0005800724029541
SELECT * FROM products WHERE id = '4041'
206 0.0005 0.0005040168762207
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
207 0.0006 0.00058507919311523
SELECT * FROM product_image_select WHERE product_id = '4041'
208 0.0004 0.00039482116699219
SELECT * FROM productcustomimages WHERE product_id = '4041'
209 0.0011 0.0011200904846191
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
210 0.0005 0.00047588348388672
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0005 0.00052595138549805
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0005 0.00051188468933105
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0006 0.00060606002807617
SELECT * FROM products WHERE id = '4312'
214 0.0005 0.0004880428314209
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
215 0.0007 0.00070500373840332
SELECT * FROM product_image_select WHERE product_id = '4312'
216 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '4312'
217 0.0015 0.0015130043029785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
218 0.0006 0.00063610076904297
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0006 0.00062203407287598
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0006 0.00055813789367676
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.0006401538848877
SELECT * FROM products WHERE id = '777'
222 0.0006 0.00057196617126465
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0011 0.0011489391326904
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0005 0.00048208236694336
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0016 0.0016179084777832
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
226 0.0006 0.00060892105102539
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0006 0.00057482719421387
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0007 0.00068402290344238
SELECT * FROM products WHERE id = '3881'
230 0.0008 0.00078487396240234
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
231 0.0007 0.00070405006408691
SELECT * FROM product_image_select WHERE product_id = '3881'
232 0.0004 0.00044393539428711
SELECT * FROM productcustomimages WHERE product_id = '3881'
233 0.0018 0.00177001953125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
234 0.0008 0.00084304809570312
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.00052404403686523
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0018 0.0017809867858887
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0014 0.001413106918335
SELECT * FROM products WHERE id = '4213'
238 0.0015 0.001492977142334
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
239 0.0017 0.0016951560974121
SELECT * FROM product_image_select WHERE product_id = '4213'
240 0.0022 0.0021729469299316
SELECT * FROM productcustomimages WHERE product_id = '4213'
241 0.0036 0.003587007522583
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
242 0.0009 0.00091195106506348
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0007 0.00072407722473145
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0008 0.00084900856018066
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0056 0.0055520534515381
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
246 0.0011 0.0011200904846191
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
247 0.0035 0.0035419464111328
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
248 0.0049 0.0048720836639404
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
249 0.0014 0.0014069080352783
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0017 0.0017249584197998
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'