0

Lipton Thé Vert Marrakech Mint 10 Capsules 25g

Price: Click Button for Price
Product prices and availability are accurate as of 2022-06-26 00:36:45 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é vert aromatisé à la menthe^10 capsules de thé compatibles avec les machines Nespresso*^Comment préparer une délicieuse tasse de thé: 1.Rincez votre machine en faisant couler de l'eau pendant 3 à 5 secondes sans capsule, si vous avez préparé une tasse de café avant.^2. Retirez l'opercule qui recouvre la capsule pour découvrir le filtre papier. 3. Insérez la capsule dans votre machine.^4. Versez environ 200ml ou le volume d'eau que vous souhaitez pour une tasse de thé parfaitement à votre 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
1.4747779369354 256 0.8454 0


No Amazon API Requests Made.


App Debug - Total Time 1.4747779369354 seconds

Number Time From Start Name Description
1 0.60273098945618 Initialise Initialise FSB Function
2 0.60877203941345 App Controller Start Start of the App controller (called before the controller of every page)
3 0.64776301383972 Start of getCategoryListByGroup Function Before first category groups query
4 0.64906811714172 After initial query Before first category groups query
5 0.64907002449036 Get Category List for Group Before the call to getCategoryList function
6 0.64907312393188 Start of GetCategoryList function Start of the function
7 0.64907693862915 Before getting categories Query to get specific category list
8 0.65051412582397 After getting categories Query to get specific category list
9 0.65051603317261 Before getting category custom Before call to function getCategoryCustom
10 0.66826510429382 After getting category custom After call to function getCategoryCustom
11 0.66826891899109 Before getting category custom Before call to function getCategoryCustom
12 0.67931199073792 After getting category custom After call to function getCategoryCustom
13 0.67931509017944 Before getting category custom Before call to function getCategoryCustom
14 0.68613910675049 After getting category custom After call to function getCategoryCustom
15 0.68614196777344 Before getting category custom Before call to function getCategoryCustom
16 0.69060707092285 After getting category custom After call to function getCategoryCustom
17 0.69060897827148 Before getting category custom Before call to function getCategoryCustom
18 0.69502305984497 After getting category custom After call to function getCategoryCustom
19 0.6950249671936 Before getting category custom Before call to function getCategoryCustom
20 0.69995093345642 After getting category custom After call to function getCategoryCustom
21 0.69995498657227 End of GetCategoryList function End of the function
22 0.69996309280396 Get Category List for Group Before the call to getCategoryList function
23 0.6999659538269 Start of GetCategoryList function Start of the function
24 0.69996905326843 Before getting categories Query to get specific category list
25 0.70050406455994 End of getCategoryListByGroup Function Before return()
26 1.2505669593811 App Controller End End of the App controller (called before the controller of every page)
27 1.2510919570923 Product Start Start of the product info controller
28 1.2631781101227 Cache file not found Starting get product details
29 1.3021359443665 Related products Start getting related products if enabled
30 1.302139043808 Related Products Start Before the related products are found
31 1.3021409511566 Related Products Keywords Before the related product keywords are found
32 1.3021469116211 Create Keyword List Function Start of function
33 1.3021969795227 Create Keyword List Function After looping provided content - 21 keywords found
34 1.3036930561066 Create Keyword List Function After looping initial keyword list - 19 keywords remaining
35 1.3037030696869 Create Keyword List Function After reducing keyword list
36 1.3037719726562 Create Keyword List Function After selecting by scoring keywords
37 1.3037779331207 Create Keyword List Function After final loop of keywords
38 1.3037810325623 Related Products Keywords After the related product keywords are found
39 1.3433871269226 Related Products End After the related products are found
40 1.3657400608063 Product End End of the product info controller (Product Info)
41 1.3679721355438 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3697879314423 Before Get Options Before the call to getOptions in the tpl class
43 1.4459879398346 After Get Options After the call to getOptions in the tpl class
44 1.4460980892181 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4461290836334 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4519970417023 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4520010948181 Product Info: Before Template Display Before the template is displayed
48 1.4747309684753 Product Info: After Template Display After the template is displayed
49 1.4747550487518 Finalizing debug Before the debug is output to the page.
50 1.4747760295868 End of App This is the end of the app logging, final timestamp


Query Debug - 256 Database Queries. Total time 0.8454 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0020 0.002047061920166
SELECT parameter, value FROM parameters
2 0.0090 0.0089848041534424
SELECT * FROM `bad_bots`
3 0.0006 0.00059890747070312
SET time_zone = 'Europe/London'
4 0.0008 0.00084495544433594
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0034 0.0034360885620117
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"44.200.122.214\";}'
6 0.0035 0.0034830570220947
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1728674253'
7 0.0036 0.0035998821258545
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.0008699893951416
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0034 0.0034279823303223
SELECT id FROM pages WHERE pagename = 'lipton-the-vert-marrakech-mint-10-capsules-25g' LIMIT 1
10 0.0013 0.0013289451599121
SELECT id FROM products WHERE pagename = 'lipton-the-vert-marrakech-mint-10-capsules-25g' AND hidden = 0 LIMIT 1
11 0.0070 0.0069620609283447
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0310 0.030953884124756
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00057101249694824
SELECT * FROM pages WHERE pagename = 'lipton-the-vert-marrakech-mint-10-capsules-25g'
14 0.0013 0.0012907981872559
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0014 0.0014140605926514
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0060 0.0059981346130371
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.0006 0.00055909156799316
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.0005 0.0004570484161377
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0004 0.00040698051452637
SELECT id FROM categories WHERE parent_id = '26'
20 0.0061 0.0061061382293701
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0015 0.0015301704406738
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.0006 0.00055098533630371
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.0015 0.001507043838501
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00050091743469238
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0038449764251709
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0005 0.00050997734069824
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0004 0.00037503242492676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00050497055053711
SELECT id FROM categories WHERE parent_id = '27'
29 0.0037 0.0037009716033936
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.0005488395690918
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.0005 0.00051999092102051
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.000518798828125
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0004 0.00041604042053223
SELECT * FROM categorygroups WHERE id = '1'
34 0.0014 0.0014050006866455
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.00039410591125488
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0004 0.00043797492980957
SELECT id FROM categories WHERE parent_id = '28'
38 0.0021 0.0020918846130371
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0005 0.00048184394836426
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.00052595138549805
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.00049495697021484
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0004 0.00040912628173828
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.0005500316619873
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.00046515464782715
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.0004 0.00039505958557129
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00045299530029297
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.0006260871887207
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.0005 0.0004889965057373
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
49 0.0005 0.00053596496582031
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0005 0.0004570484161377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0004 0.00041294097900391
SELECT * FROM categorygroups WHERE id = '1'
52 0.0005 0.00052189826965332
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.0005 0.00046896934509277
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.0004 0.00042104721069336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0004 0.00041604042053223
SELECT id FROM categories WHERE parent_id = '30'
56 0.0006 0.00063610076904297
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.0005 0.00047111511230469
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
58 0.0005 0.0004730224609375
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0005 0.00046706199645996
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00046086311340332
SELECT * FROM categorygroups WHERE id = '1'
61 0.0006 0.00060081481933594
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0005 0.00047802925109863
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.0004 0.00043010711669922
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00044918060302734
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00075411796569824
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.0005 0.00049614906311035
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.0005 0.00053596496582031
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.0006 0.00055193901062012
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.0005190372467041
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.00052404403686523
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0029 0.0029308795928955
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0017 0.0016770362854004
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.0008089542388916
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.0014 0.0014021396636963
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0012 0.0012269020080566
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0011 0.0010871887207031
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5359 0.53588581085205
SELECT * FROM ipgeocountries WHERE INET_ATON('44.200.122.214') >= INET_ATON(ip_start) AND INET_ATON('44.200.122.214') <= INET_ATON(ip_end)
78 0.0021 0.0021460056304932
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0014 0.0013949871063232
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00064992904663086
SELECT * FROM products WHERE pagename = 'lipton-the-vert-marrakech-mint-10-capsules-25g'
81 0.0004 0.00043892860412598
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1094
82 0.0008 0.0007939338684082
SELECT * FROM manufacturers WHERE id = '220'
83 0.0007 0.00068092346191406
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
84 0.0019 0.0019171237945557
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '220' LIMIT 1
85 0.0025 0.0024871826171875
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.0012 0.0011520385742188
SELECT * FROM productimages WHERE product_id = '1250' ORDER BY sortorder ASC
87 0.0009 0.00086808204650879
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '220'
88 0.0008 0.00078487396240234
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.0006 0.00064706802368164
SELECT * FROM manufacturerimages WHERE manufacturer_id = '220'
90 0.0006 0.00055599212646484
SELECT category_id FROM products_categories WHERE product_id = '1094'
91 0.0008 0.00075411796569824
SELECT * FROM categories WHERE id = '28'
92 0.0025 0.0025079250335693
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.0006 0.0006251335144043
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
94 0.0006 0.00058507919311523
SELECT id FROM categories WHERE parent_id = '28'
95 0.0030 0.0030279159545898
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
96 0.0008 0.00080490112304688
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.0007 0.00073504447937012
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.0005 0.00054597854614258
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
99 0.0006 0.0006098747253418
SELECT * FROM productimages WHERE product_id = '1094' ORDER BY sortorder ASC
100 0.0021 0.00213623046875
SELECT * FROM product_image_select WHERE product_id = '1094'
101 0.0024 0.0024371147155762
SELECT * FROM productcustomimages WHERE product_id = '1094'
102 0.0017 0.001737117767334
SELECT * FROM productfeeds WHERE product_id = '1094' ORDER BY item_date DESC
103 0.0030 0.0029869079589844
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1094' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0024 0.002406120300293
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1094' AND t.hidden = 0 AND display_product = 1
105 0.0016 0.0015969276428223
SELECT * FROM productamazoncontent WHERE product_id = '1094'
106 0.0009 0.00094389915466309
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1094' AND a.name = n.originalname
107 0.0015 0.0014939308166504
SELECT * FROM productoffers WHERE product_id = '1094' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00048685073852539
SELECT * FROM productoffers
                WHERE product_id = '1094' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0004 0.00040197372436523
SELECT * FROM productoffers
                WHERE product_id = 1094
                ORDER BY price ASC LIMIT 1
110 0.0005 0.0004880428314209
SELECT value FROM productattributes
                WHERE product_id = '1094'
                AND name = 'ListPriceAmount'
111 0.0005 0.00045108795166016
SELECT value FROM productattributes WHERE product_id = '1094' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112 0.0005 0.00047802925109863
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.0100 0.01003885269165
SELECT *, MATCH (description, title) AGAINST ('thé vert marrakech' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé vert marrakech' IN BOOLEAN MODE) AND 1094 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114 0.0008 0.00077509880065918
SELECT *, MATCH (description, title) AGAINST ('thé vert marrakech' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé vert marrakech' IN BOOLEAN MODE) AND 1094 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
115 0.0007 0.00066399574279785
SELECT *, MATCH (description, title) AGAINST ('thé vert marrakech' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé vert marrakech' IN BOOLEAN MODE) AND 1094 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
116 0.0007 0.0006721019744873
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
117 0.0007 0.00066399574279785
SELECT * FROM product_image_select WHERE product_id = '857'
118 0.0005 0.00045609474182129
SELECT * FROM productcustomimages WHERE product_id = '857'
119 0.0012 0.0011639595031738
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
120 0.0006 0.00055789947509766
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
121 0.0005 0.00049018859863281
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
122 0.0004 0.00042200088500977
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123 0.0006 0.00063300132751465
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
124 0.0007 0.00067496299743652
SELECT * FROM product_image_select WHERE product_id = '853'
125 0.0005 0.00046896934509277
SELECT * FROM productcustomimages WHERE product_id = '853'
126 0.0010 0.00097107887268066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
127 0.0006 0.00059080123901367
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
128 0.0005 0.00052094459533691
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
129 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130 0.0005 0.00054597854614258
SELECT * FROM productimages WHERE product_id = '842' ORDER BY sortorder ASC
131 0.0007 0.00066018104553223
SELECT * FROM product_image_select WHERE product_id = '842'
132 0.0006 0.00059199333190918
SELECT * FROM productcustomimages WHERE product_id = '842'
133 0.0013 0.0013120174407959
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '842' AND a.name = n.originalname
134 0.0006 0.00063681602478027
SELECT * FROM productoffers WHERE product_id = '842' AND merchantid = 'A1X6FK5RDHNB96'
135 0.0005 0.00053596496582031
SELECT * FROM productoffers
                WHERE product_id = '842' AND price > 0
                ORDER BY price ASC LIMIT 1
136 0.0004 0.00041580200195312
SELECT value FROM productattributes WHERE product_id = '842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137 0.0005 0.00053596496582031
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
138 0.0007 0.00067806243896484
SELECT * FROM product_image_select WHERE product_id = '868'
139 0.0004 0.00042319297790527
SELECT * FROM productcustomimages WHERE product_id = '868'
140 0.0010 0.00096702575683594
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
141 0.0006 0.00058102607727051
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
142 0.0004 0.00044989585876465
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
143 0.0004 0.00043296813964844
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144 0.0005 0.00052094459533691
SELECT * FROM productimages WHERE product_id = '866' ORDER BY sortorder ASC
145 0.0007 0.00066995620727539
SELECT * FROM product_image_select WHERE product_id = '866'
146 0.0005 0.00054502487182617
SELECT * FROM productcustomimages WHERE product_id = '866'
147 0.0012 0.0011909008026123
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '866' AND a.name = n.originalname
148 0.0006 0.0005500316619873
SELECT * FROM productoffers WHERE product_id = '866' AND merchantid = 'A1X6FK5RDHNB96'
149 0.0005 0.00054693222045898
SELECT * FROM productoffers
                WHERE product_id = '866' AND price > 0
                ORDER BY price ASC LIMIT 1
150 0.0005 0.00048613548278809
SELECT value FROM productattributes WHERE product_id = '866' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0007 0.00067996978759766
SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC
152 0.0008 0.00084805488586426
SELECT * FROM product_image_select WHERE product_id = '931'
153 0.0005 0.00049400329589844
SELECT * FROM productcustomimages WHERE product_id = '931'
154 0.0010 0.0010089874267578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname
155 0.0005 0.0005340576171875
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96'
156 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '931' AND price > 0
                ORDER BY price ASC LIMIT 1
157 0.0004 0.00043606758117676
SELECT value FROM productattributes WHERE product_id = '931' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158 0.0005 0.00047707557678223
SELECT id,asin FROM products WHERE parent_id = 1094
159 0.0015 0.0015010833740234
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1094' ORDER BY timestamp DESC
160 0.0004 0.00044798851013184
SELECT category_id FROM products_categories WHERE product_id = '1094'
161 0.0006 0.00055503845214844
SELECT * FROM categories WHERE id = '28'
162 0.0015 0.0014951229095459
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.00048208236694336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
164 0.0004 0.00038290023803711
SELECT id FROM categories WHERE parent_id = '28'
165 0.0015 0.00148606300354
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.00058317184448242
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.00058698654174805
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.0005 0.00051498413085938
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
169 0.0009 0.00091004371643066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1094' AND a.name = n.originalname
170 0.0005 0.00054812431335449
SELECT * FROM productoffers WHERE product_id = '1094' AND merchantid = 'A1X6FK5RDHNB96'
171 0.0005 0.00047397613525391
SELECT * FROM productoffers
                WHERE product_id = '1094' AND price > 0
                ORDER BY price ASC LIMIT 1
172 0.0004 0.0003969669342041
SELECT * FROM productoffers
                WHERE product_id = 1094
                ORDER BY price ASC LIMIT 1
173 0.0004 0.00040698051452637
SELECT value FROM productattributes
                WHERE product_id = '1094'
                AND name = 'ListPriceAmount'
174 0.0005 0.00050902366638184
SELECT * FROM products WHERE id = '1094'
175 0.0005 0.00046801567077637
SELECT value FROM productattributes WHERE product_id = '1094' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176 0.0010 0.00097298622131348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1094' AND a.name = n.originalname
177 0.0004 0.00041103363037109
SELECT * FROM productoffers WHERE product_id = '1094' AND merchantid = 'A1X6FK5RDHNB96'
178 0.0004 0.00043296813964844
SELECT * FROM productoffers
                WHERE product_id = '1094' AND price > 0
                ORDER BY price ASC LIMIT 1
179 0.0004 0.00037693977355957
SELECT * FROM productoffers
                WHERE product_id = 1094
                ORDER BY price ASC LIMIT 1
180 0.0005 0.00054097175598145
SELECT value FROM productattributes
                WHERE product_id = '1094'
                AND name = 'ListPriceAmount'
181 0.0005 0.00047993659973145
SELECT category_id FROM products_categories WHERE product_id = '1094' AND prod_type = 'amz'
182 0.0004 0.00042009353637695
SELECT parent_id FROM categories WHERE id = '28'
183 0.0004 0.00043296813964844
SELECT * FROM categories WHERE id = '28'
184 0.0015 0.001478910446167
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.00046706199645996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
186 0.0004 0.00041103363037109
SELECT id FROM categories WHERE parent_id = '28'
187 0.0016 0.0016160011291504
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.0005 0.00053882598876953
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.0005 0.00054788589477539
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
190 0.0005 0.00053191184997559
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
191 0.0018 0.0017828941345215
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.00041413307189941
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
194 0.0133 0.013284921646118
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.0015 0.0015301704406738
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.0007 0.00066804885864258
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.0006 0.0005791187286377
SELECT * FROM products WHERE id = 1626
198 0.0004 0.00041389465332031
SELECT * FROM products WHERE id = 4041
199 0.0004 0.00044393539428711
SELECT * FROM products WHERE id = 4312
200 0.0004 0.00037193298339844
SELECT * FROM products WHERE id = 777
201 0.0004 0.00040316581726074
SELECT * FROM products WHERE id = 3881
202 0.0004 0.0004279613494873
SELECT * FROM products WHERE id = 4213
203 0.0004 0.00042319297790527
SELECT * FROM products WHERE id = '1626'
204 0.0005 0.00045680999755859
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
205 0.0006 0.00061297416687012
SELECT * FROM product_image_select WHERE product_id = '1626'
206 0.0005 0.00047492980957031
SELECT * FROM productcustomimages WHERE product_id = '1626'
207 0.0009 0.00085115432739258
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.00051093101501465
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
209 0.0004 0.00043296813964844
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
210 0.0005 0.00045585632324219
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0005 0.00053715705871582
SELECT * FROM products WHERE id = '4041'
212 0.0005 0.0004730224609375
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
213 0.0006 0.00058102607727051
SELECT * FROM product_image_select WHERE product_id = '4041'
214 0.0004 0.00035905838012695
SELECT * FROM productcustomimages WHERE product_id = '4041'
215 0.0011 0.0011348724365234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
216 0.0005 0.00053691864013672
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
217 0.0010 0.001032829284668
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
218 0.0010 0.0010161399841309
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
219 0.0017 0.0017149448394775
SELECT * FROM products WHERE id = '4312'
220 0.0012 0.0012140274047852
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
221 0.0014 0.0013809204101562
SELECT * FROM product_image_select WHERE product_id = '4312'
222 0.0008 0.00075912475585938
SELECT * FROM productcustomimages WHERE product_id = '4312'
223 0.0034 0.0034389495849609
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
224 0.0012 0.0011789798736572
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
225 0.0009 0.00086498260498047
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
226 0.0009 0.00091409683227539
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227 0.0011 0.0010950565338135
SELECT * FROM products WHERE id = '777'
228 0.0010 0.00095796585083008
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
229 0.0012 0.0011968612670898
SELECT * FROM product_image_select WHERE product_id = '777'
230 0.0006 0.00059890747070312
SELECT * FROM productcustomimages WHERE product_id = '777'
231 0.0022 0.0022270679473877
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.00087285041809082
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0007 0.00070905685424805
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0007 0.00074386596679688
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235 0.0009 0.00092983245849609
SELECT * FROM products WHERE id = '3881'
236 0.0009 0.00088405609130859
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
237 0.0012 0.0011780261993408
SELECT * FROM product_image_select WHERE product_id = '3881'
238 0.0006 0.00058984756469727
SELECT * FROM productcustomimages WHERE product_id = '3881'
239 0.0026 0.002554178237915
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
240 0.0008 0.00077986717224121
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
241 0.0006 0.0006098747253418
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
242 0.0007 0.0006561279296875
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243 0.0008 0.00075888633728027
SELECT * FROM products WHERE id = '4213'
244 0.0008 0.00084209442138672
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
245 0.0010 0.0010299682617188
SELECT * FROM product_image_select WHERE product_id = '4213'
246 0.0006 0.00062394142150879
SELECT * FROM productcustomimages WHERE product_id = '4213'
247 0.0022 0.0022029876708984
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
248 0.0008 0.00078010559082031
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
249 0.0006 0.00058102607727051
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
250 0.0007 0.00066685676574707
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251 0.0023 0.0023388862609863
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
252 0.0010 0.0010221004486084
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
253 0.0035 0.0035429000854492
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
254 0.0027 0.0026640892028809
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
255 0.0011 0.0010678768157959
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
256 0.0008 0.00084900856018066
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'