0

Lipton Tchaé Thé Vert Menthe 25 Sachets 50 g

Price: €19,90
Product prices and availability are accurate as of 2022-06-26 14:56:16 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^SACHET PYRAMID ®^MENTHE^Un sachet en forme pyramidale : plus d'espace pour de longues feuilles de thé et une meilleure infusion pour plus de goût

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.2562639713287 261 1.7933 0


No Amazon API Requests Made.


App Debug - Total Time 2.2562639713287 seconds

Number Time From Start Name Description
1 0.41927099227905 Initialise Initialise FSB Function
2 0.43107795715332 App Controller Start Start of the App controller (called before the controller of every page)
3 0.48056697845459 Start of getCategoryListByGroup Function Before first category groups query
4 0.48317193984985 After initial query Before first category groups query
5 0.48317193984985 Get Category List for Group Before the call to getCategoryList function
6 0.48317408561707 Start of GetCategoryList function Start of the function
7 0.4831759929657 Before getting categories Query to get specific category list
8 0.48499393463135 After getting categories Query to get specific category list
9 0.48499393463135 Before getting category custom Before call to function getCategoryCustom
10 0.51163697242737 After getting category custom After call to function getCategoryCustom
11 0.5116400718689 Before getting category custom Before call to function getCategoryCustom
12 0.52534890174866 After getting category custom After call to function getCategoryCustom
13 0.52535104751587 Before getting category custom Before call to function getCategoryCustom
14 0.53222894668579 After getting category custom After call to function getCategoryCustom
15 0.532231092453 Before getting category custom Before call to function getCategoryCustom
16 0.53717994689941 After getting category custom After call to function getCategoryCustom
17 0.53718209266663 Before getting category custom Before call to function getCategoryCustom
18 0.54229497909546 After getting category custom After call to function getCategoryCustom
19 0.54229593276978 Before getting category custom Before call to function getCategoryCustom
20 0.54771709442139 After getting category custom After call to function getCategoryCustom
21 0.54771900177002 End of GetCategoryList function End of the function
22 0.54772305488586 Get Category List for Group Before the call to getCategoryList function
23 0.5477249622345 Start of GetCategoryList function Start of the function
24 0.54772591590881 Before getting categories Query to get specific category list
25 0.54824304580688 End of getCategoryListByGroup Function Before return()
26 1.9910519123077 App Controller End End of the App controller (called before the controller of every page)
27 1.9916920661926 Product Start Start of the product info controller
28 2.0205750465393 Cache file not found Starting get product details
29 2.0652749538422 Related products Start getting related products if enabled
30 2.0652770996094 Related Products Start Before the related products are found
31 2.0652770996094 Related Products Keywords Before the related product keywords are found
32 2.0652799606323 Create Keyword List Function Start of function
33 2.0653629302979 Create Keyword List Function After looping provided content - 24 keywords found
34 2.0657320022583 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 2.0657370090485 Create Keyword List Function After reducing keyword list
36 2.0657670497894 Create Keyword List Function After selecting by scoring keywords
37 2.0657689571381 Create Keyword List Function After final loop of keywords
38 2.0657699108124 Related Products Keywords After the related product keywords are found
39 2.1322340965271 Related Products End After the related products are found
40 2.1544370651245 Product End End of the product info controller (Product Info)
41 2.1571159362793 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.1590659618378 Before Get Options Before the call to getOptions in the tpl class
43 2.2193510532379 After Get Options After the call to getOptions in the tpl class
44 2.2194640636444 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.2194900512695 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.2290720939636 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.2290749549866 Product Info: Before Template Display Before the template is displayed
48 2.256245136261 Product Info: After Template Display After the template is displayed
49 2.2562539577484 Finalizing debug Before the debug is output to the page.
50 2.2562639713287 End of App This is the end of the app logging, final timestamp


Query Debug - 261 Database Queries. Total time 1.7933 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0010 0.001021146774292
SELECT parameter, value FROM parameters
2 0.0065 0.0065069198608398
SELECT * FROM `bad_bots`
3 0.0004 0.00039505958557129
SET time_zone = 'Europe/London'
4 0.0040 0.0040109157562256
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0061 0.0061180591583252
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.218.169.79\";}'
6 0.0034 0.0034201145172119
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746013603'
7 0.0055 0.0054988861083984
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0011 0.0010769367218018
UPDATE autorun SET lastrun = '2025-04-30 11:46:43' WHERE id = '13'
9 0.0011 0.0011360645294189
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0055 0.0055270195007324
SELECT id FROM pages WHERE pagename = 'lipton-tchae-the-vert-menthe-25-sachets-50-g' LIMIT 1
11 0.0043 0.0043458938598633
SELECT id FROM products WHERE pagename = 'lipton-tchae-the-vert-menthe-25-sachets-50-g' AND hidden = 0 LIMIT 1
12 0.0053 0.0052700042724609
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13 0.0432 0.043176174163818
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14 0.0007 0.00072002410888672
SELECT * FROM pages WHERE pagename = 'lipton-tchae-the-vert-menthe-25-sachets-50-g'
15 0.0026 0.0025980472564697
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0018 0.0018081665039062
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0070 0.0070409774780273
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.0026 0.0026209354400635
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.0016 0.0016481876373291
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20 0.0005 0.00051689147949219
SELECT id FROM categories WHERE parent_id = '26'
21 0.0076 0.0075829029083252
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.0027 0.0027120113372803
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.0020 0.0020439624786377
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.0019 0.0019068717956543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25 0.0005 0.00048613548278809
SELECT * FROM categorygroups WHERE id = '1'
26 0.0041 0.0040631294250488
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.0007 0.00067591667175293
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28 0.0005 0.00054597854614258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29 0.0006 0.0005500316619873
SELECT id FROM categories WHERE parent_id = '27'
30 0.0053 0.0052728652954102
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.0007 0.00067806243896484
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.0008 0.00075006484985352
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.00058698654174805
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34 0.0005 0.00052881240844727
SELECT * FROM categorygroups WHERE id = '1'
35 0.0016 0.0016050338745117
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36 0.0005 0.0005490779876709
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37 0.0004 0.00043201446533203
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38 0.0004 0.00044488906860352
SELECT id FROM categories WHERE parent_id = '28'
39 0.0017 0.0016880035400391
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.00057196617126465
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.00059413909912109
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.00049400329589844
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43 0.0004 0.00044822692871094
SELECT * FROM categorygroups WHERE id = '1'
44 0.0006 0.00063610076904297
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.00057101249694824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46 0.0004 0.00043296813964844
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47 0.0005 0.00045013427734375
SELECT id FROM categories WHERE parent_id = '29'
48 0.0008 0.00075817108154297
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
49 0.0005 0.00052189826965332
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.00055313110351562
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.00049090385437012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52 0.0005 0.00048089027404785
SELECT * FROM categorygroups WHERE id = '1'
53 0.0006 0.00064587593078613
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54 0.0006 0.00061798095703125
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.00041508674621582
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56 0.0004 0.00043892860412598
SELECT id FROM categories WHERE parent_id = '30'
57 0.0007 0.00070810317993164
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.0006 0.0005948543548584
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
59 0.0006 0.00061583518981934
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.00049996376037598
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61 0.0005 0.00051307678222656
SELECT * FROM categorygroups WHERE id = '1'
62 0.0007 0.00070595741271973
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.00050687789916992
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.00050020217895508
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65 0.0004 0.00042295455932617
SELECT id FROM categories WHERE parent_id = '31'
66 0.0009 0.00088906288146973
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.00053596496582031
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.0006 0.00058913230895996
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.0007 0.00072216987609863
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70 0.0005 0.00048017501831055
SELECT * FROM categorygroups WHERE id = '1'
71 0.0005 0.00050997734069824
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
72 0.0053 0.0053160190582275
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73 0.0021 0.002094030380249
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74 0.0054 0.005424976348877
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.0022 0.0022461414337158
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76 0.0014 0.0013799667358398
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77 0.0011 0.0010750293731689
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78 1.4191 1.4190731048584
SELECT * FROM ipgeocountries WHERE INET_ATON('18.218.169.79') >= INET_ATON(ip_start) AND INET_ATON('18.218.169.79') <= INET_ATON(ip_end)
79 0.0029 0.0029101371765137
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80 0.0017 0.0017180442810059
SELECT * FROM countryredirects WHERE countrycode = 'US'
81 0.0007 0.00066590309143066
SELECT * FROM products WHERE pagename = 'lipton-tchae-the-vert-menthe-25-sachets-50-g'
82 0.0005 0.00045299530029297
UPDATE products SET viewcount = viewcount + 1 WHERE id = 857
83 0.0015 0.0015048980712891
SELECT * FROM manufacturers WHERE id = '220'
84 0.0013 0.0013160705566406
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
85 0.0047 0.0046789646148682
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '220' LIMIT 1
86 0.0051 0.0051360130310059
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '220' ORDER BY RAND() LIMIT 1
87 0.0012 0.0011639595031738
SELECT * FROM productimages WHERE product_id = '1218' ORDER BY sortorder ASC
88 0.0012 0.0011551380157471
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
89 0.0011 0.0010709762573242
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '220'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
90 0.0007 0.00065302848815918
SELECT * FROM manufacturerimages WHERE manufacturer_id = '220'
91 0.0006 0.0005800724029541
SELECT category_id FROM products_categories WHERE product_id = '857'
92 0.0006 0.00063109397888184
SELECT * FROM categories WHERE id = '28'
93 0.0023 0.0022709369659424
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.0006 0.00063514709472656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
95 0.0004 0.0004432201385498
SELECT id FROM categories WHERE parent_id = '28'
96 0.0025 0.0024540424346924
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.0009 0.00087499618530273
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.0009 0.00093913078308105
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.0006098747253418
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
100 0.0006 0.00058293342590332
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
101 0.0024 0.0023930072784424
SELECT * FROM product_image_select WHERE product_id = '857'
102 0.0018 0.0018019676208496
SELECT * FROM productcustomimages WHERE product_id = '857'
103 0.0016 0.0016191005706787
SELECT * FROM productfeeds WHERE product_id = '857' ORDER BY item_date DESC
104 0.0032 0.0032010078430176
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105 0.0027 0.0027320384979248
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '857' AND t.hidden = 0 AND display_product = 1
106 0.0014 0.0014269351959229
SELECT * FROM productamazoncontent WHERE product_id = '857'
107 0.0012 0.0011780261993408
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
108 0.0016 0.0015609264373779
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
109 0.0004 0.00042104721069336
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
110 0.0006 0.00056910514831543
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111 0.0005 0.00052404403686523
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.0093 0.0092999935150146
SELECT *, MATCH (description, title) AGAINST ('lipton tchaé thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('lipton tchaé thé' IN BOOLEAN MODE) AND 857 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
113 0.0008 0.00082087516784668
SELECT *, MATCH (description, title) AGAINST ('lipton tchaé thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('lipton tchaé thé' IN BOOLEAN MODE) AND 857 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0006 0.00063395500183105
SELECT *, MATCH (description, title) AGAINST ('lipton tchaé thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('lipton tchaé thé' IN BOOLEAN MODE) AND 857 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0006 0.00060796737670898
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
116 0.0007 0.0006558895111084
SELECT * FROM product_image_select WHERE product_id = '4919'
117 0.0005 0.00052285194396973
SELECT * FROM productcustomimages WHERE product_id = '4919'
118 0.0013 0.001323938369751
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
119 0.0005 0.00054097175598145
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
120 0.0005 0.00046992301940918
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
121 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
123 0.0008 0.00080394744873047
SELECT * FROM product_image_select WHERE product_id = '853'
124 0.0009 0.00092196464538574
SELECT * FROM productcustomimages WHERE product_id = '853'
125 0.0012 0.0012338161468506
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
126 0.0005 0.00053811073303223
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0004 0.00039982795715332
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0006 0.0005650520324707
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129 0.0005 0.00051593780517578
SELECT * FROM productimages WHERE product_id = '1218' ORDER BY sortorder ASC
130 0.0007 0.0006711483001709
SELECT * FROM product_image_select WHERE product_id = '1218'
131 0.0006 0.00056695938110352
SELECT * FROM productcustomimages WHERE product_id = '1218'
132 0.0012 0.0011651515960693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1218' AND a.name = n.originalname
133 0.0007 0.00070309638977051
SELECT * FROM productoffers WHERE product_id = '1218' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0010 0.00097489356994629
SELECT * FROM productoffers
                WHERE product_id = '1218' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0046 0.0045938491821289
SELECT value FROM productattributes WHERE product_id = '1218' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0007 0.00070881843566895
SELECT * FROM productimages WHERE product_id = '4500' ORDER BY sortorder ASC
137 0.0024 0.0024430751800537
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4500' AND p.id = pi.product_id ORDER BY pi.sortorder
138 0.0020 0.002032995223999
SELECT * FROM product_image_select WHERE product_id = '4500'
139 0.0013 0.0013129711151123
SELECT * FROM productcustomimages WHERE product_id = '4500'
140 0.0021 0.0020639896392822
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4500'
                GROUP BY o.product_id
141 0.0104 0.010372161865234
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4500'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
142 0.0011 0.0011191368103027
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4500
143 0.0014 0.0014200210571289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4500' AND a.name = n.originalname
144 0.0005 0.00054597854614258
SELECT * FROM productoffers WHERE product_id = '4500' AND merchantid = 'A1X6FK5RDHNB96'
145 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '4500' AND price > 0
                ORDER BY price ASC LIMIT 1
146 0.0004 0.00036406517028809
SELECT * FROM productoffers
                WHERE product_id = 4500
                ORDER BY price ASC LIMIT 1
147 0.0006 0.00055193901062012
SELECT value FROM productattributes
                WHERE product_id = '4500'
                AND name = 'ListPriceAmount'
148 0.0005 0.00051498413085938
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4500'
                GROUP BY o.product_id
149 0.0008 0.00077414512634277
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4500'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
150 0.0005 0.0004889965057373
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4500
151 0.0007 0.0006721019744873
SELECT value FROM productattributes WHERE product_id = '4500' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152 0.0012 0.0012269020080566
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4500'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
153 0.0007 0.00067806243896484
SELECT * FROM productimages WHERE product_id = '1250' ORDER BY sortorder ASC
154 0.0008 0.00075197219848633
SELECT * FROM product_image_select WHERE product_id = '1250'
155 0.0004 0.00042891502380371
SELECT * FROM productcustomimages WHERE product_id = '1250'
156 0.0012 0.0012490749359131
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1250' AND a.name = n.originalname
157 0.0007 0.00067996978759766
SELECT * FROM productoffers WHERE product_id = '1250' AND merchantid = 'A1X6FK5RDHNB96'
158 0.0005 0.00046396255493164
SELECT * FROM productoffers
                WHERE product_id = '1250' AND price > 0
                ORDER BY price ASC LIMIT 1
159 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '1250' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160 0.0005 0.00051283836364746
SELECT * FROM productimages WHERE product_id = '4907' ORDER BY sortorder ASC
161 0.0006 0.00060200691223145
SELECT * FROM product_image_select WHERE product_id = '4907'
162 0.0004 0.00042605400085449
SELECT * FROM productcustomimages WHERE product_id = '4907'
163 0.0012 0.0012011528015137
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4907' AND a.name = n.originalname
164 0.0006 0.00055694580078125
SELECT * FROM productoffers WHERE product_id = '4907' AND merchantid = 'A1X6FK5RDHNB96'
165 0.0005 0.00048112869262695
SELECT * FROM productoffers
                WHERE product_id = '4907' AND price > 0
                ORDER BY price ASC LIMIT 1
166 0.0006 0.00056600570678711
SELECT value FROM productattributes WHERE product_id = '4907' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167 0.0006 0.00056004524230957
SELECT id,asin FROM products WHERE parent_id = 857
168 0.0023 0.0022540092468262
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '857' ORDER BY timestamp DESC
169 0.0005 0.00051498413085938
SELECT category_id FROM products_categories WHERE product_id = '857'
170 0.0005 0.00052595138549805
SELECT * FROM categories WHERE id = '28'
171 0.0018 0.0018110275268555
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.0005 0.00046586990356445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
173 0.0003 0.00032186508178711
SELECT id FROM categories WHERE parent_id = '28'
174 0.0015 0.0014760494232178
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.0006 0.00059103965759277
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.0006 0.00063109397888184
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.0005 0.00050592422485352
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
178 0.0012 0.0012021064758301
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
179 0.0006 0.00060892105102539
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
180 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
181 0.0006 0.00055313110351562
SELECT * FROM products WHERE id = '857'
182 0.0005 0.00047206878662109
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183 0.0010 0.00098395347595215
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
184 0.0004 0.0004417896270752
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
185 0.0005 0.00046491622924805
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
186 0.0007 0.00067901611328125
SELECT category_id FROM products_categories WHERE product_id = '857' AND prod_type = 'amz'
187 0.0005 0.00051307678222656
SELECT parent_id FROM categories WHERE id = '28'
188 0.0004 0.00037193298339844
SELECT * FROM categories WHERE id = '28'
189 0.0016 0.00160813331604
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.0004 0.00044703483581543
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
191 0.0003 0.00034904479980469
SELECT id FROM categories WHERE parent_id = '28'
192 0.0014 0.0013878345489502
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.0006 0.00058412551879883
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
194 0.0006 0.00059390068054199
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.0006 0.00058293342590332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
196 0.0022 0.0021719932556152
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
197 0.0015 0.001539945602417
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198 0.0004 0.00037097930908203
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199 0.0139 0.013890981674194
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.0031 0.00313401222229
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.0007 0.00073504447937012
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.0007 0.00066900253295898
SELECT * FROM products WHERE id = 1626
203 0.0006 0.00061416625976562
SELECT * FROM products WHERE id = 4041
204 0.0005 0.00047397613525391
SELECT * FROM products WHERE id = 4312
205 0.0005 0.00046586990356445
SELECT * FROM products WHERE id = 777
206 0.0004 0.00040912628173828
SELECT * FROM products WHERE id = 3881
207 0.0004 0.00037407875061035
SELECT * FROM products WHERE id = 4213
208 0.0005 0.00046110153198242
SELECT * FROM products WHERE id = '1626'
209 0.0005 0.0005030632019043
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
210 0.0007 0.00066804885864258
SELECT * FROM product_image_select WHERE product_id = '1626'
211 0.0005 0.00046110153198242
SELECT * FROM productcustomimages WHERE product_id = '1626'
212 0.0009 0.00089597702026367
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
213 0.0006 0.00055098533630371
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0005 0.00046610832214355
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0007 0.00073599815368652
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0006 0.00064420700073242
SELECT * FROM products WHERE id = '4041'
217 0.0006 0.00061798095703125
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
218 0.0007 0.00066804885864258
SELECT * FROM product_image_select WHERE product_id = '4041'
219 0.0005 0.00045204162597656
SELECT * FROM productcustomimages WHERE product_id = '4041'
220 0.0012 0.001244068145752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
221 0.0005 0.00054097175598145
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0004 0.00043487548828125
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0005 0.00051283836364746
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0006 0.00061798095703125
SELECT * FROM products WHERE id = '4312'
225 0.0005 0.00047707557678223
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
226 0.0006 0.00064611434936523
SELECT * FROM product_image_select WHERE product_id = '4312'
227 0.0006 0.0005640983581543
SELECT * FROM productcustomimages WHERE product_id = '4312'
228 0.0011 0.00111985206604
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
229 0.0006 0.0005800724029541
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0006 0.00056004524230957
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0005 0.00046896934509277
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0006 0.00060796737670898
SELECT * FROM products WHERE id = '777'
233 0.0006 0.00060510635375977
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
234 0.0006 0.00064301490783691
SELECT * FROM product_image_select WHERE product_id = '777'
235 0.0004 0.00042414665222168
SELECT * FROM productcustomimages WHERE product_id = '777'
236 0.0012 0.0011630058288574
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
237 0.0005 0.00049901008605957
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
238 0.0004 0.0004279613494873
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
239 0.0005 0.00052189826965332
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0007 0.00066709518432617
SELECT * FROM products WHERE id = '3881'
241 0.0005 0.00053715705871582
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
242 0.0006 0.00064277648925781
SELECT * FROM product_image_select WHERE product_id = '3881'
243 0.0004 0.00043392181396484
SELECT * FROM productcustomimages WHERE product_id = '3881'
244 0.0012 0.0011708736419678
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
245 0.0005 0.00053501129150391
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
246 0.0004 0.00042891502380371
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
247 0.0004 0.0004420280456543
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248 0.0006 0.00057601928710938
SELECT * FROM products WHERE id = '4213'
249 0.0006 0.00058794021606445
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
250 0.0007 0.00071096420288086
SELECT * FROM product_image_select WHERE product_id = '4213'
251 0.0005 0.00048112869262695
SELECT * FROM productcustomimages WHERE product_id = '4213'
252 0.0012 0.0011990070343018
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.00047707557678223
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
254 0.0004 0.00044393539428711
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
255 0.0004 0.00044894218444824
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256 0.0022 0.0022339820861816
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
257 0.0007 0.0006868839263916
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
258 0.0027 0.0027339458465576
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
259 0.0021 0.002112865447998
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
260 0.0006 0.00063586235046387
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
261 0.0008 0.0008089542388916
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'