0

Quertee® - Thé vert – Thé au jasmin de Chine riche en fleurs - 250 g

Price: €12,90
Product prices and availability are accurate as of 2022-06-16 06:37:46 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

Quertee - Thé vert – Thé au jasmin de Chine riche en fleurs - 250 g Thé vert - Thé au jasmin de Chine riche en fleurs Saveur : Délicate de jasmin La feuille est régulière et la couleur du breuvage est jaune clair à orange. La saveur est pure et rappelle les fleurs délicates et raffinées du jasmin.

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.5032370090485 261 1.0315 0


No Amazon API Requests Made.


App Debug - Total Time 2.5032370090485 seconds

Number Time From Start Name Description
1 1.4027390480042 Initialise Initialise FSB Function
2 1.4119801521301 App Controller Start Start of the App controller (called before the controller of every page)
3 1.4448580741882 Start of getCategoryListByGroup Function Before first category groups query
4 1.446408033371 After initial query Before first category groups query
5 1.446408033371 Get Category List for Group Before the call to getCategoryList function
6 1.4464101791382 Start of GetCategoryList function Start of the function
7 1.4464120864868 Before getting categories Query to get specific category list
8 1.4478311538696 After getting categories Query to get specific category list
9 1.4478321075439 Before getting category custom Before call to function getCategoryCustom
10 1.4686319828033 After getting category custom After call to function getCategoryCustom
11 1.4686331748962 Before getting category custom Before call to function getCategoryCustom
12 1.4809381961823 After getting category custom After call to function getCategoryCustom
13 1.4809391498566 Before getting category custom Before call to function getCategoryCustom
14 1.4888670444489 After getting category custom After call to function getCategoryCustom
15 1.4888679981232 Before getting category custom Before call to function getCategoryCustom
16 1.4939720630646 After getting category custom After call to function getCategoryCustom
17 1.4939730167389 Before getting category custom Before call to function getCategoryCustom
18 1.4986200332642 After getting category custom After call to function getCategoryCustom
19 1.4986209869385 Before getting category custom Before call to function getCategoryCustom
20 1.5038549900055 After getting category custom After call to function getCategoryCustom
21 1.5038561820984 End of GetCategoryList function End of the function
22 1.5038599967957 Get Category List for Group Before the call to getCategoryList function
23 1.5038621425629 Start of GetCategoryList function Start of the function
24 1.5038630962372 Before getting categories Query to get specific category list
25 1.5043501853943 End of getCategoryListByGroup Function Before return()
26 2.2621071338654 App Controller End End of the App controller (called before the controller of every page)
27 2.262598991394 Product Start Start of the product info controller
28 2.2836930751801 Cache file not found Starting get product details
29 2.319393157959 Related products Start getting related products if enabled
30 2.3193941116333 Related Products Start Before the related products are found
31 2.3193950653076 Related Products Keywords Before the related product keywords are found
32 2.319402217865 Create Keyword List Function Start of function
33 2.3194320201874 Create Keyword List Function After looping provided content - 35 keywords found
34 2.3201761245728 Create Keyword List Function After looping initial keyword list - 30 keywords remaining
35 2.3201801776886 Create Keyword List Function After reducing keyword list
36 2.3202340602875 Create Keyword List Function After selecting by scoring keywords
37 2.320237159729 Create Keyword List Function After final loop of keywords
38 2.3202381134033 Related Products Keywords After the related product keywords are found
39 2.3651900291443 Related Products End After the related products are found
40 2.3895211219788 Product End End of the product info controller (Product Info)
41 2.3918271064758 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.3935451507568 Before Get Options Before the call to getOptions in the tpl class
43 2.4435691833496 After Get Options After the call to getOptions in the tpl class
44 2.4436480998993 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.4436671733856 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.4685502052307 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.4685530662537 Product Info: Before Template Display Before the template is displayed
48 2.5032181739807 Product Info: After Template Display After the template is displayed
49 2.5032269954681 Finalizing debug Before the debug is output to the page.
50 2.5032370090485 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 1.0315 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0021941661834717
SELECT parameter, value FROM parameters
2 0.0042 0.0041999816894531
SELECT * FROM `bad_bots`
3 0.0003 0.0003359317779541
SET time_zone = 'Europe/London'
4 0.0018 0.0017659664154053
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0017 0.0017449855804443
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.89\";}'
6 0.0019 0.0018661022186279
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745025873'
7 0.0040 0.0039920806884766
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00075101852416992
UPDATE autorun SET lastrun = '2025-04-19 01:24:34' WHERE id = '13'
9 0.0008 0.00081396102905273
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0041 0.0040750503540039
SELECT id FROM pages WHERE pagename = 'quertee-the-vert-the-au-jasmin-de-chine-riche-en-fleurs-250-g' LIMIT 1
11 0.0038 0.0037798881530762
SELECT id FROM products WHERE pagename = 'quertee-the-vert-the-au-jasmin-de-chine-riche-en-fleurs-250-g' AND hidden = 0 LIMIT 1
12 0.0039 0.0038919448852539
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0281 0.028052091598511
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0006 0.00059604644775391
SELECT * FROM pages WHERE pagename = 'quertee-the-vert-the-au-jasmin-de-chine-riche-en-fleurs-250-g'
15 0.0015 0.0015449523925781
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0014 0.0014090538024902
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0062 0.0062258243560791
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.0017 0.001701831817627
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.0013 0.0012729167938232
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0004 0.00044012069702148
SELECT id FROM categories WHERE parent_id = '26'
21 0.0060 0.0060470104217529
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.0017 0.0016541481018066
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.0016 0.0015771389007568
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.0014 0.0013899803161621
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0004 0.00044012069702148
SELECT * FROM categorygroups WHERE id = '1'
26 0.0037 0.00370192527771
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.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 = 27
28 0.0004 0.0003809928894043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0004 0.00039005279541016
SELECT id FROM categories WHERE parent_id = '27'
30 0.0045 0.0045499801635742
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.0008 0.00081586837768555
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.0009 0.00087690353393555
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.0006 0.00058984756469727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00047898292541504
SELECT * FROM categorygroups WHERE id = '1'
35 0.0020 0.0020089149475098
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.0006 0.00055503845214844
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.0005 0.00046205520629883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0005 0.00050187110900879
SELECT id FROM categories WHERE parent_id = '28'
39 0.0022 0.0021500587463379
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.00061798095703125
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.00060915946960449
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.00050497055053711
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0005 0.00049304962158203
SELECT * FROM categorygroups WHERE id = '1'
44 0.0007 0.00070500373840332
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.00056004524230957
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.0005 0.00045204162597656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00046491622924805
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.0008389949798584
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.0006 0.00056195259094238
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.0005958080291748
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.0005 0.00046014785766602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0004 0.00043821334838867
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00061583518981934
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.0005 0.00050497055053711
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.0003960132598877
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00042581558227539
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00073099136352539
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.00050997734069824
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.0005 0.00051403045654297
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.00046086311340332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00046801567077637
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00072097778320312
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.00049304962158203
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.00048518180847168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0005 0.00048995018005371
SELECT id FROM categories WHERE parent_id = '31'
66 0.0008 0.00083398818969727
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.0005 0.0004580020904541
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.00066304206848145
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.00055885314941406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00051093101501465
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00048494338989258
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0030 0.0030021667480469
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0018 0.0018172264099121
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0006 0.0006411075592041
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.0013 0.001276969909668
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0012 0.0011999607086182
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0009 0.00086712837219238
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 0.7445 0.7445170879364
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.89') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.89') <= INET_ATON(ip_end)
79 0.0019 0.0019431114196777
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0011 0.0010859966278076
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0006 0.0006411075592041
SELECT * FROM products WHERE pagename = 'quertee-the-vert-the-au-jasmin-de-chine-riche-en-fleurs-250-g'
82 0.0004 0.00036787986755371
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4909
83 0.0010 0.00098991394042969
SELECT * FROM manufacturers WHERE id = '646'
84 0.0008 0.00077700614929199
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '646'
85 0.0032 0.0031700134277344
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '646' LIMIT 1
86 0.0033 0.0033159255981445
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '646' ORDER BY RAND() LIMIT 1
87 0.0006 0.00063705444335938
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
88 0.0007 0.00066089630126953
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '646'
89 0.0007 0.00067710876464844
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '646'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0006 0.00060892105102539
SELECT * FROM manufacturerimages WHERE manufacturer_id = '646'
91 0.0007 0.00074195861816406
SELECT category_id FROM products_categories WHERE product_id = '4909'
92 0.0007 0.00071001052856445
SELECT * FROM categories WHERE id = '28'
93 0.0022 0.0021698474884033
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
94 0.0005 0.00051498413085938
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
95 0.0004 0.00039291381835938
SELECT id FROM categories WHERE parent_id = '28'
96 0.0021 0.0021488666534424
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 
97 0.0006 0.00060296058654785
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 
98 0.0006 0.00064301490783691
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
99 0.0006 0.00056815147399902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
100 0.0007 0.00065302848815918
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
101 0.0023 0.0022649765014648
SELECT * FROM product_image_select WHERE product_id = '4909'
102 0.0012 0.0012249946594238
SELECT * FROM productcustomimages WHERE product_id = '4909'
103 0.0013 0.0012879371643066
SELECT * FROM productfeeds WHERE product_id = '4909' ORDER BY item_date DESC
104 0.0027 0.0026500225067139
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0024 0.0024299621582031
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4909' AND t.hidden = 0 AND display_product = 1
106 0.0018 0.0017681121826172
SELECT * FROM productamazoncontent WHERE product_id = '4909'
107 0.0011 0.001072883605957
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
108 0.0013 0.0012688636779785
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0004 0.00038886070251465
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0005 0.00046992301940918
SELECT value FROM productattributes WHERE product_id = '4909' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0005 0.00048303604125977
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.0087 0.008713960647583
SELECT *, MATCH (description, title) AGAINST ('jasmin de chine' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('jasmin de chine' IN BOOLEAN MODE) AND 4909 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
113 0.0005 0.0005190372467041
SELECT *, MATCH (description, title) AGAINST ('jasmin de chine' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('jasmin de chine' IN BOOLEAN MODE) AND 4909 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0005 0.00046992301940918
SELECT *, MATCH (description, title) AGAINST ('jasmin de chine' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('jasmin de chine' IN BOOLEAN MODE) AND 4909 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0004 0.00041699409484863
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
116 0.0006 0.0005500316619873
SELECT * FROM product_image_select WHERE product_id = '4909'
117 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '4909'
118 0.0010 0.0010120868682861
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
119 0.0004 0.00043082237243652
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0004 0.00036382675170898
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '4909' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0004 0.00041985511779785
SELECT * FROM productimages WHERE product_id = '1056' ORDER BY sortorder ASC
123 0.0005 0.00052881240844727
SELECT * FROM product_image_select WHERE product_id = '1056'
124 0.0003 0.00034284591674805
SELECT * FROM productcustomimages WHERE product_id = '1056'
125 0.0009 0.00089192390441895
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1056' AND a.name = n.originalname
126 0.0004 0.00044512748718262
SELECT * FROM productoffers WHERE product_id = '1056' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00037193298339844
SELECT * FROM productoffers
                WHERE product_id = '1056' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0004 0.00038599967956543
SELECT value FROM productattributes WHERE product_id = '1056' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0004 0.00042390823364258
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
130 0.0005 0.00054693222045898
SELECT * FROM product_image_select WHERE product_id = '4905'
131 0.0004 0.00038599967956543
SELECT * FROM productcustomimages WHERE product_id = '4905'
132 0.0010 0.0010190010070801
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
133 0.0004 0.00043201446533203
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.0003659725189209
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0004 0.00039410591125488
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0005 0.00048112869262695
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
137 0.0006 0.00055503845214844
SELECT * FROM product_image_select WHERE product_id = '1160'
138 0.0003 0.00034403800964355
SELECT * FROM productcustomimages WHERE product_id = '1160'
139 0.0009 0.00092720985412598
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
140 0.0004 0.0004122257232666
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0003 0.00034403800964355
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0004 0.00036501884460449
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0090 0.0090060234069824
SELECT *, MATCH (description, title) AGAINST ('quertee thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('quertee thé vert' IN BOOLEAN MODE) AND 4909 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
144 0.0005 0.00050520896911621
SELECT *, MATCH (description, title) AGAINST ('quertee thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('quertee thé vert' IN BOOLEAN MODE) AND 4909 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
145 0.0005 0.00048995018005371
SELECT *, MATCH (description, title) AGAINST ('quertee thé vert' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('quertee thé vert' IN BOOLEAN MODE) AND 4909 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
146 0.0005 0.00053596496582031
SELECT * FROM productimages WHERE product_id = '842' ORDER BY sortorder ASC
147 0.0006 0.00057291984558105
SELECT * FROM product_image_select WHERE product_id = '842'
148 0.0004 0.00038814544677734
SELECT * FROM productcustomimages WHERE product_id = '842'
149 0.0011 0.0010709762573242
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '842' AND a.name = n.originalname
150 0.0004 0.0004420280456543
SELECT * FROM productoffers WHERE product_id = '842' AND merchantid = 'A1X6FK5RDHNB96'
151 0.0004 0.00035405158996582
SELECT * FROM productoffers
                WHERE product_id = '842' AND price > 0
                ORDER BY price ASC LIMIT 1
152 0.0004 0.00038790702819824
SELECT value FROM productattributes WHERE product_id = '842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
153 0.0005 0.00047397613525391
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
154 0.0006 0.00060796737670898
SELECT * FROM product_image_select WHERE product_id = '853'
155 0.0004 0.00037884712219238
SELECT * FROM productcustomimages WHERE product_id = '853'
156 0.0008 0.00078392028808594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
157 0.0004 0.00040316581726074
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0003 0.00033307075500488
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0003 0.0003349781036377
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0005 0.00047612190246582
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
161 0.0005 0.00052189826965332
SELECT * FROM product_image_select WHERE product_id = '857'
162 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '857'
163 0.0009 0.00087404251098633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
164 0.0004 0.00041007995605469
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0003 0.00033402442932129
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0004 0.00035500526428223
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0004 0.00037217140197754
SELECT id,asin FROM products WHERE parent_id = 4909
168 0.0014 0.0014400482177734
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4909' ORDER BY timestamp DESC
169 0.0004 0.0003819465637207
SELECT category_id FROM products_categories WHERE product_id = '4909'
170 0.0004 0.00044012069702148
SELECT * FROM categories WHERE id = '28'
171 0.0014 0.0014398097991943
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
172 0.0004 0.00035810470581055
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
173 0.0003 0.00027680397033691
SELECT id FROM categories WHERE parent_id = '28'
174 0.0013 0.0012960433959961
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 
175 0.0005 0.00045299530029297
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 
176 0.0011 0.0011200904846191
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
177 0.0012 0.001201868057251
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
178 0.0025 0.0025219917297363
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
179 0.0006 0.00064682960510254
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0005 0.00049114227294922
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0006 0.00063610076904297
SELECT * FROM products WHERE id = '4909'
182 0.0006 0.00055599212646484
SELECT value FROM productattributes WHERE product_id = '4909' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0015 0.0014879703521729
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
184 0.0005 0.00046586990356445
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0006 0.00058388710021973
SELECT category_id FROM products_categories WHERE product_id = '4909' AND prod_type = 'amz'
187 0.0005 0.00049209594726562
SELECT parent_id FROM categories WHERE id = '28'
188 0.0004 0.00036406517028809
SELECT * FROM categories WHERE id = '28'
189 0.0026 0.0025899410247803
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
190 0.0005 0.00050187110900879
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
191 0.0004 0.00037693977355957
SELECT id FROM categories WHERE parent_id = '28'
192 0.0017 0.0016870498657227
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 
193 0.0005 0.00052094459533691
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 
194 0.0005 0.00053977966308594
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
195 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
196 0.0019 0.0018560886383057
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0013 0.0013411045074463
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0003 0.00034213066101074
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0134 0.013379096984863
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
200 0.0015 0.0014538764953613
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
201 0.0005 0.00052213668823242
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
202 0.0005 0.00045990943908691
SELECT * FROM products WHERE id = 1626
203 0.0003 0.00034499168395996
SELECT * FROM products WHERE id = 4041
204 0.0003 0.00029993057250977
SELECT * FROM products WHERE id = 4312
205 0.0003 0.00028109550476074
SELECT * FROM products WHERE id = 777
206 0.0004 0.00037693977355957
SELECT * FROM products WHERE id = 3881
207 0.0005 0.00045299530029297
SELECT * FROM products WHERE id = 4213
208 0.0003 0.00032401084899902
SELECT * FROM products WHERE id = '1626'
209 0.0004 0.00041413307189941
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0005 0.00052809715270996
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0004 0.00035500526428223
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0008 0.00078010559082031
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0004 0.00042295455932617
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0004 0.00035405158996582
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0004 0.00042605400085449
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0005 0.0005040168762207
SELECT * FROM products WHERE id = '4041'
217 0.0004 0.00040793418884277
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0005 0.0005180835723877
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0004 0.00037312507629395
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0011 0.0010678768157959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0004 0.00043177604675293
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0004 0.00035500526428223
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '4312'
225 0.0004 0.0004119873046875
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0005 0.00053095817565918
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0004 0.00040698051452637
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0009 0.00093507766723633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0005 0.00047111511230469
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0004 0.00037217140197754
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0004 0.00041699409484863
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '777'
233 0.0004 0.0003960132598877
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0005 0.00050711631774902
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0003 0.00032305717468262
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0010 0.00097393989562988
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0004 0.00043392181396484
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0005 0.00050902366638184
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0004 0.00040698051452637
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '3881'
241 0.0006 0.00056314468383789
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0006 0.00060105323791504
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0004 0.00035309791564941
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0010 0.0010499954223633
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0004 0.00043678283691406
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00040102005004883
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0004 0.00040602684020996
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0005 0.00046491622924805
SELECT * FROM products WHERE id = '4213'
249 0.0004 0.00043606758117676
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0005 0.00049996376037598
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0003 0.00032901763916016
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0011 0.001060962677002
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
253 0.0005 0.00049495697021484
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0005 0.00049495697021484
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0004 0.00040507316589355
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0019 0.0018901824951172
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0006 0.00062990188598633
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0023 0.0022749900817871
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0016 0.0015718936920166
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0005 0.00046706199645996
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0013 0.0012688636779785
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'