0

Lipton Thé Vert Marrakech Mint 20 Sachets 40 g

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-26 14:19:28 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.
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é Noir^SACHET MOUSSELINE^MENTHE^Tout le savoir-faire légendaire de Sir Thomas Lipton dans un sachet mousseline.^Marrakech Mint : Ce thé vert au goût frais de menthe vous révèlera toutes les saveurs du symbole ancestral de l'hospitalité marocaine.^Poids de l'article: 40 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
3.1171271800995 256 0.9366 0


No Amazon API Requests Made.


App Debug - Total Time 3.1171271800995 seconds

Number Time From Start Name Description
1 1.342912197113 Initialise Initialise FSB Function
2 1.3880250453949 App Controller Start Start of the App controller (called before the controller of every page)
3 1.4309420585632 Start of getCategoryListByGroup Function Before first category groups query
4 1.4326632022858 After initial query Before first category groups query
5 1.4326651096344 Get Category List for Group Before the call to getCategoryList function
6 1.4326682090759 Start of GetCategoryList function Start of the function
7 1.4326710700989 Before getting categories Query to get specific category list
8 1.4343481063843 After getting categories Query to get specific category list
9 1.4343490600586 Before getting category custom Before call to function getCategoryCustom
10 1.4559390544891 After getting category custom After call to function getCategoryCustom
11 1.4559421539307 Before getting category custom Before call to function getCategoryCustom
12 1.4696140289307 After getting category custom After call to function getCategoryCustom
13 1.4696171283722 Before getting category custom Before call to function getCategoryCustom
14 1.4760160446167 After getting category custom After call to function getCategoryCustom
15 1.4760191440582 Before getting category custom Before call to function getCategoryCustom
16 1.4840230941772 After getting category custom After call to function getCategoryCustom
17 1.4840250015259 Before getting category custom Before call to function getCategoryCustom
18 1.4981451034546 After getting category custom After call to function getCategoryCustom
19 1.4981470108032 Before getting category custom Before call to function getCategoryCustom
20 1.5065071582794 After getting category custom After call to function getCategoryCustom
21 1.5065100193024 End of GetCategoryList function End of the function
22 1.5065159797668 Get Category List for Group Before the call to getCategoryList function
23 1.5065190792084 Start of GetCategoryList function Start of the function
24 1.506520986557 Before getting categories Query to get specific category list
25 1.5078489780426 End of getCategoryListByGroup Function Before return()
26 2.1160521507263 App Controller End End of the App controller (called before the controller of every page)
27 2.116378068924 Product Start Start of the product info controller
28 2.1291921138763 Cache file not found Starting get product details
29 2.1764771938324 Related products Start getting related products if enabled
30 2.176479101181 Related Products Start Before the related products are found
31 2.1764800548553 Related Products Keywords Before the related product keywords are found
32 2.1764831542969 Create Keyword List Function Start of function
33 2.1765551567078 Create Keyword List Function After looping provided content - 24 keywords found
34 2.1774640083313 Create Keyword List Function After looping initial keyword list - 20 keywords remaining
35 2.1774711608887 Create Keyword List Function After reducing keyword list
36 2.1775140762329 Create Keyword List Function After selecting by scoring keywords
37 2.1775159835815 Create Keyword List Function After final loop of keywords
38 2.1775181293488 Related Products Keywords After the related product keywords are found
39 2.2192540168762 Related Products End After the related products are found
40 2.2437930107117 Product End End of the product info controller (Product Info)
41 2.2459809780121 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 2.2478342056274 Before Get Options Before the call to getOptions in the tpl class
43 2.3295540809631 After Get Options After the call to getOptions in the tpl class
44 2.3296680450439 App_after Controller End End of the App_after controller (called after the controller of every page)
45 2.3296871185303 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.5749981403351 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.5750041007996 Product Info: Before Template Display Before the template is displayed
48 3.1171071529388 Product Info: After Template Display After the template is displayed
49 3.1171131134033 Finalizing debug Before the debug is output to the page.
50 3.1171259880066 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 0.9366 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0071 0.0070700645446777
SELECT parameter, value FROM parameters
2 0.0089 0.0089190006256104
SELECT * FROM `bad_bots`
3 0.0005 0.00053715705871582
SET time_zone = 'Europe/London'
4 0.0032 0.0032129287719727
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0045 0.0045430660247803
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.81\";}'
6 0.0041 0.0040619373321533
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739322895'
7 0.0038 0.0037729740142822
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00090384483337402
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0033 0.003309965133667
SELECT id FROM pages WHERE pagename = 'lipton-the-vert-marrakech-mint-20-sachets-40-g' LIMIT 1
10 0.0038 0.0038330554962158
SELECT id FROM products WHERE pagename = 'lipton-the-vert-marrakech-mint-20-sachets-40-g' AND hidden = 0 LIMIT 1
11 0.0076 0.0075628757476807
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0342 0.034203052520752
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.0006108283996582
SELECT * FROM pages WHERE pagename = 'lipton-the-vert-marrakech-mint-20-sachets-40-g'
14 0.0017 0.0017099380493164
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0017 0.0016582012176514
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0069 0.0068938732147217
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.0020 0.0019900798797607
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.0012 0.0011899471282959
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.0004730224609375
SELECT id FROM categories WHERE parent_id = '26'
20 0.0056 0.0055840015411377
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.0018 0.0018119812011719
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.0017 0.0016908645629883
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.0013828277587891
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0004 0.00044012069702148
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0043609142303467
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.0020 0.0019800662994385
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.0009 0.00093722343444824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00050902366638184
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0036880970001221
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.0005 0.00049209594726562
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.00059604644775391
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.00052118301391602
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00049400329589844
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.001413106918335
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.0005 0.00049090385437012
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.0004 0.00040483474731445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00051498413085938
SELECT id FROM categories WHERE parent_id = '28'
38 0.0015 0.0015048980712891
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.0006 0.00057291984558105
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.00053191184997559
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.00046086311340332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00042295455932617
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00059103965759277
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.00049901008605957
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.0004570484161377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00049495697021484
SELECT id FROM categories WHERE parent_id = '29'
47 0.0009 0.00090408325195312
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.00061798095703125
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.0006 0.00062108039855957
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.0009 0.00087714195251465
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0028 0.0028438568115234
SELECT * FROM categorygroups WHERE id = '1'
52 0.0024 0.0024120807647705
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.0010 0.00096797943115234
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.0014 0.0013589859008789
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0019 0.0019190311431885
SELECT id FROM categories WHERE parent_id = '30'
56 0.0026 0.0026290416717529
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.0013 0.0012760162353516
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.0014 0.0014262199401855
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.0011 0.0010790824890137
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0009 0.00094103813171387
SELECT * FROM categorygroups WHERE id = '1'
61 0.0013 0.0013420581817627
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.0009 0.00086021423339844
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.0006 0.0005950927734375
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0006 0.00060200691223145
SELECT id FROM categories WHERE parent_id = '31'
65 0.0016 0.0016398429870605
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.0008 0.0008080005645752
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.0009 0.00087594985961914
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.0008 0.00084805488586426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0007 0.00071096420288086
SELECT * FROM categorygroups WHERE id = '1'
70 0.0013 0.0013179779052734
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0076 0.0075740814208984
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0039 0.0038571357727051
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0020 0.0019598007202148
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.0042 0.0042099952697754
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0037 0.003695011138916
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0025 0.0025160312652588
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5531 0.55313611030579
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.81') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.81') <= INET_ATON(ip_end)
78 0.0023 0.0023119449615479
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.001288890838623
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00080299377441406
SELECT * FROM products WHERE pagename = 'lipton-the-vert-marrakech-mint-20-sachets-40-g'
81 0.0005 0.00048422813415527
UPDATE products SET viewcount = viewcount + 1 WHERE id = 951
82 0.0008 0.00078701972961426
SELECT * FROM manufacturers WHERE id = '220'
83 0.0010 0.0010139942169189
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
84 0.0017 0.0016930103302002
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '220' LIMIT 1
85 0.0024 0.0024318695068359
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
86 0.0008 0.00075101852416992
SELECT * FROM productimages WHERE product_id = '1151' ORDER BY sortorder ASC
87 0.0007 0.0007469654083252
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
88 0.0009 0.00085306167602539
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 
89 0.0007 0.00071310997009277
SELECT * FROM manufacturerimages WHERE manufacturer_id = '220'
90 0.0007 0.00065398216247559
SELECT category_id FROM products_categories WHERE product_id = '951'
91 0.0007 0.00069904327392578
SELECT * FROM categories WHERE id = '28'
92 0.0023 0.0023469924926758
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.00067305564880371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
94 0.0007 0.00067400932312012
SELECT id FROM categories WHERE parent_id = '28'
95 0.0022 0.0021748542785645
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.0009 0.0009310245513916
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.0008 0.00076198577880859
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.0007 0.00068283081054688
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
99 0.0008 0.00083398818969727
SELECT * FROM productimages WHERE product_id = '951' ORDER BY sortorder ASC
100 0.0027 0.0026531219482422
SELECT * FROM product_image_select WHERE product_id = '951'
101 0.0018 0.0017969608306885
SELECT * FROM productcustomimages WHERE product_id = '951'
102 0.0032 0.0031919479370117
SELECT * FROM productfeeds WHERE product_id = '951' ORDER BY item_date DESC
103 0.0047 0.0047049522399902
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '951' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0048 0.00484299659729
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '951' AND t.hidden = 0 AND display_product = 1
105 0.0027 0.0027220249176025
SELECT * FROM productamazoncontent WHERE product_id = '951'
106 0.0021 0.0020990371704102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '951' AND a.name = n.originalname
107 0.0022 0.0021991729736328
SELECT * FROM productoffers WHERE product_id = '951' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0006 0.0006401538848877
SELECT * FROM productoffers
                WHERE product_id = '951' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00044894218444824
SELECT * FROM productoffers
                WHERE product_id = 951
                ORDER BY price ASC LIMIT 1
110 0.0007 0.00067901611328125
SELECT value FROM productattributes
                WHERE product_id = '951'
                AND name = 'ListPriceAmount'
111 0.0006 0.00057315826416016
SELECT value FROM productattributes WHERE product_id = '951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0007 0.00070905685424805
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
113 0.0135 0.013546943664551
SELECT *, MATCH (description, title) AGAINST ('vert marrakech mint' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vert marrakech mint' IN BOOLEAN MODE) AND 951 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0010 0.0009620189666748
SELECT *, MATCH (description, title) AGAINST ('vert marrakech mint' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vert marrakech mint' IN BOOLEAN MODE) AND 951 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00067591667175293
SELECT *, MATCH (description, title) AGAINST ('vert marrakech mint' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vert marrakech mint' IN BOOLEAN MODE) AND 951 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0006 0.00059914588928223
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC
117 0.0007 0.00070691108703613
SELECT * FROM product_image_select WHERE product_id = '866'
118 0.0005 0.00049400329589844
SELECT * FROM productcustomimages WHERE product_id = '866'
119 0.0012 0.001162052154541
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname
120 0.0006 0.00057721138000488
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0005 0.00048708915710449
SELECT * FROM productoffers
                WHERE product_id = '866' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0005 0.00049710273742676
SELECT value FROM productattributes WHERE product_id = '866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0006 0.00061297416687012
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
124 0.0006 0.00057888031005859
SELECT * FROM product_image_select WHERE product_id = '868'
125 0.0004 0.00043797492980957
SELECT * FROM productcustomimages WHERE product_id = '868'
126 0.0009 0.00089311599731445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
127 0.0005 0.00050997734069824
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0005 0.00045204162597656
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0005 0.00045585632324219
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0006 0.00056791305541992
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
131 0.0006 0.00060081481933594
SELECT * FROM product_image_select WHERE product_id = '853'
132 0.0004 0.0004420280456543
SELECT * FROM productcustomimages WHERE product_id = '853'
133 0.0009 0.00094199180603027
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
134 0.0006 0.00057888031005859
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00047588348388672
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00043082237243652
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0006 0.00061511993408203
SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC
138 0.0007 0.00066399574279785
SELECT * FROM product_image_select WHERE product_id = '931'
139 0.0005 0.00046300888061523
SELECT * FROM productcustomimages WHERE product_id = '931'
140 0.0010 0.00095415115356445
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname
141 0.0006 0.0005650520324707
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0005 0.00052905082702637
SELECT * FROM productoffers
                WHERE product_id = '931' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '931' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0006 0.0005800724029541
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
145 0.0006 0.00062203407287598
SELECT * FROM product_image_select WHERE product_id = '857'
146 0.0005 0.00046014785766602
SELECT * FROM productcustomimages WHERE product_id = '857'
147 0.0010 0.0010120868682861
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
148 0.0005 0.00053596496582031
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0005 0.00049805641174316
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0005 0.00052905082702637
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0006 0.00057196617126465
SELECT * FROM productimages WHERE product_id = '842' ORDER BY sortorder ASC
152 0.0007 0.00070595741271973
SELECT * FROM product_image_select WHERE product_id = '842'
153 0.0005 0.00049805641174316
SELECT * FROM productcustomimages WHERE product_id = '842'
154 0.0012 0.0011749267578125
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '842' AND a.name = n.originalname
155 0.0006 0.0006101131439209
SELECT * FROM productoffers WHERE product_id = '842' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0005 0.0004880428314209
SELECT * FROM productoffers
                WHERE product_id = '842' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0005 0.00049495697021484
SELECT value FROM productattributes WHERE product_id = '842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0005 0.00054597854614258
SELECT id,asin FROM products WHERE parent_id = 951
159 0.0019 0.0018599033355713
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '951' ORDER BY timestamp DESC
160 0.0005 0.00054812431335449
SELECT category_id FROM products_categories WHERE product_id = '951'
161 0.0005 0.00052714347839355
SELECT * FROM categories WHERE id = '28'
162 0.0017 0.0017020702362061
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
163 0.0005 0.00052905082702637
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
164 0.0004 0.00040888786315918
SELECT id FROM categories WHERE parent_id = '28'
165 0.0015 0.0015158653259277
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 
166 0.0006 0.00060391426086426
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 
167 0.0006 0.00062704086303711
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
168 0.0007 0.00066184997558594
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
169 0.0011 0.0011019706726074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '951' AND a.name = n.originalname
170 0.0006 0.00057196617126465
SELECT * FROM productoffers WHERE product_id = '951' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0005 0.00045299530029297
SELECT * FROM productoffers
                WHERE product_id = '951' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.00044488906860352
SELECT * FROM productoffers
                WHERE product_id = 951
                ORDER BY price ASC LIMIT 1
173 0.0005 0.00050091743469238
SELECT value FROM productattributes
                WHERE product_id = '951'
                AND name = 'ListPriceAmount'
174 0.0008 0.00076198577880859
SELECT * FROM products WHERE id = '951'
175 0.0006 0.00055813789367676
SELECT value FROM productattributes WHERE product_id = '951' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0009 0.0009300708770752
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '951' AND a.name = n.originalname
177 0.0006 0.00057101249694824
SELECT * FROM productoffers WHERE product_id = '951' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0005 0.00049090385437012
SELECT * FROM productoffers
                WHERE product_id = '951' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00042414665222168
SELECT * FROM productoffers
                WHERE product_id = 951
                ORDER BY price ASC LIMIT 1
180 0.0004 0.00042200088500977
SELECT value FROM productattributes
                WHERE product_id = '951'
                AND name = 'ListPriceAmount'
181 0.0005 0.00053191184997559
SELECT category_id FROM products_categories WHERE product_id = '951' AND prod_type = 'amz'
182 0.0006 0.00059700012207031
SELECT parent_id FROM categories WHERE id = '28'
183 0.0004 0.00043082237243652
SELECT * FROM categories WHERE id = '28'
184 0.0016 0.0015690326690674
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
185 0.0005 0.00050997734069824
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
186 0.0004 0.00038504600524902
SELECT id FROM categories WHERE parent_id = '28'
187 0.0014 0.0014369487762451
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 
188 0.0006 0.00057792663574219
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 
189 0.0006 0.00059604644775391
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
190 0.0008 0.00080490112304688
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
191 0.0019 0.0018830299377441
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
192 0.0013 0.0013411045074463
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
193 0.0004 0.00043296813964844
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0136 0.0136399269104
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
195 0.0018 0.0017719268798828
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
196 0.0006 0.00064492225646973
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
197 0.0008 0.00075912475585938
SELECT * FROM products WHERE id = 1626
198 0.0007 0.0007178783416748
SELECT * FROM products WHERE id = 4041
199 0.0007 0.00071620941162109
SELECT * FROM products WHERE id = 4312
200 0.0007 0.00074100494384766
SELECT * FROM products WHERE id = 777
201 0.0006 0.00064301490783691
SELECT * FROM products WHERE id = 3881
202 0.0007 0.00073385238647461
SELECT * FROM products WHERE id = 4213
203 0.0007 0.00068187713623047
SELECT * FROM products WHERE id = '1626'
204 0.0007 0.00074195861816406
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
205 0.0007 0.00073719024658203
SELECT * FROM product_image_select WHERE product_id = '1626'
206 0.0006 0.00056600570678711
SELECT * FROM productcustomimages WHERE product_id = '1626'
207 0.0009 0.00090813636779785
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
208 0.0005 0.00054502487182617
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0005 0.00052022933959961
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0005 0.00051593780517578
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0008 0.00080299377441406
SELECT * FROM products WHERE id = '4041'
212 0.0008 0.00084495544433594
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
213 0.0008 0.00076699256896973
SELECT * FROM product_image_select WHERE product_id = '4041'
214 0.0005 0.0005340576171875
SELECT * FROM productcustomimages WHERE product_id = '4041'
215 0.0015 0.001511812210083
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
216 0.0006 0.00061511993408203
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0005 0.00050806999206543
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0006 0.00056791305541992
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0007 0.00068497657775879
SELECT * FROM products WHERE id = '4312'
220 0.0011 0.0010678768157959
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
221 0.0013 0.0012810230255127
SELECT * FROM product_image_select WHERE product_id = '4312'
222 0.0008 0.00076508522033691
SELECT * FROM productcustomimages WHERE product_id = '4312'
223 0.0030 0.0030169486999512
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
224 0.0015 0.0014669895172119
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0010 0.0010039806365967
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0011 0.0010628700256348
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0011 0.0011119842529297
SELECT * FROM products WHERE id = '777'
228 0.0011 0.0011260509490967
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
229 0.0016 0.0016391277313232
SELECT * FROM product_image_select WHERE product_id = '777'
230 0.0010 0.0010149478912354
SELECT * FROM productcustomimages WHERE product_id = '777'
231 0.0027 0.0026619434356689
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
232 0.0009 0.0009300708770752
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0007 0.00074219703674316
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0009 0.00090789794921875
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0011 0.0010550022125244
SELECT * FROM products WHERE id = '3881'
236 0.0011 0.0010650157928467
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
237 0.0013 0.0012969970703125
SELECT * FROM product_image_select WHERE product_id = '3881'
238 0.0008 0.00081992149353027
SELECT * FROM productcustomimages WHERE product_id = '3881'
239 0.0023 0.0022928714752197
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
240 0.0009 0.00089097023010254
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0007 0.0006861686706543
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0008 0.00077605247497559
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0009 0.00090217590332031
SELECT * FROM products WHERE id = '4213'
244 0.0009 0.000946044921875
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
245 0.0011 0.0010759830474854
SELECT * FROM product_image_select WHERE product_id = '4213'
246 0.0006 0.00056600570678711
SELECT * FROM productcustomimages WHERE product_id = '4213'
247 0.0021 0.0020890235900879
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
248 0.0007 0.000701904296875
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0007 0.00067520141601562
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0007 0.00065708160400391
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0030 0.0029869079589844
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
252 0.0011 0.0010850429534912
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
253 0.0037 0.0036978721618652
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
254 0.0022 0.0022499561309814
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0009 0.00087809562683105
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0011 0.0010972023010254
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'