0

FRHOME - 48 capsules compatible Nescafé Dolce Gusto - Chocolat - Il Caffè Italiano

Price: €19,00
Product prices and availability are accurate as of 2022-06-23 11:20:25 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

Paquet de 48 capsules compatibles Nescafé Dolce Gusto chocolat Le paquet contient 3 sachets de 16 capsules chacune Compatible avec toutes les machines Nescafé Dolce Gusto Greedy chocolat boisson aromatisée

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.0188798904419 250 1.6200 0


No Amazon API Requests Made.


App Debug - Total Time 2.0188798904419 seconds

Number Time From Start Name Description
1 0.36936283111572 Initialise Initialise FSB Function
2 0.37539100646973 App Controller Start Start of the App controller (called before the controller of every page)
3 0.40775084495544 Start of getCategoryListByGroup Function Before first category groups query
4 0.41015696525574 After initial query Before first category groups query
5 0.41015791893005 Get Category List for Group Before the call to getCategoryList function
6 0.410160779953 Start of GetCategoryList function Start of the function
7 0.41016387939453 Before getting categories Query to get specific category list
8 0.41244792938232 After getting categories Query to get specific category list
9 0.41244888305664 Before getting category custom Before call to function getCategoryCustom
10 0.4396448135376 After getting category custom After call to function getCategoryCustom
11 0.43964886665344 Before getting category custom Before call to function getCategoryCustom
12 0.4520947933197 After getting category custom After call to function getCategoryCustom
13 0.45209693908691 Before getting category custom Before call to function getCategoryCustom
14 0.46373295783997 After getting category custom After call to function getCategoryCustom
15 0.4637348651886 Before getting category custom Before call to function getCategoryCustom
16 0.46897196769714 After getting category custom After call to function getCategoryCustom
17 0.46897387504578 Before getting category custom Before call to function getCategoryCustom
18 0.47429299354553 After getting category custom After call to function getCategoryCustom
19 0.47429394721985 Before getting category custom Before call to function getCategoryCustom
20 0.47963500022888 After getting category custom After call to function getCategoryCustom
21 0.4796359539032 End of GetCategoryList function End of the function
22 0.47964000701904 Get Category List for Group Before the call to getCategoryList function
23 0.47964191436768 Start of GetCategoryList function Start of the function
24 0.47964286804199 Before getting categories Query to get specific category list
25 0.48013401031494 End of getCategoryListByGroup Function Before return()
26 1.8207709789276 App Controller End End of the App controller (called before the controller of every page)
27 1.8214809894562 Product Start Start of the product info controller
28 1.8341310024261 Cache file not found Starting get product details
29 1.8660190105438 Related products Start getting related products if enabled
30 1.8660199642181 Related Products Start Before the related products are found
31 1.8660199642181 Related Products Keywords Before the related product keywords are found
32 1.8660228252411 Create Keyword List Function Start of function
33 1.8660860061646 Create Keyword List Function After looping provided content - 30 keywords found
34 1.8666098117828 Create Keyword List Function After looping initial keyword list - 28 keywords remaining
35 1.866614818573 Create Keyword List Function After reducing keyword list
36 1.8666598796844 Create Keyword List Function After selecting by scoring keywords
37 1.8666617870331 Create Keyword List Function After final loop of keywords
38 1.866662979126 Related Products Keywords After the related product keywords are found
39 1.9022288322449 Related Products End After the related products are found
40 1.9194169044495 Product End End of the product info controller (Product Info)
41 1.9217519760132 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.923357963562 Before Get Options Before the call to getOptions in the tpl class
43 1.9898769855499 After Get Options After the call to getOptions in the tpl class
44 1.9900197982788 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.9900448322296 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 2.0008687973022 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 2.0008728504181 Product Info: Before Template Display Before the template is displayed
48 2.0188620090485 Product Info: After Template Display After the template is displayed
49 2.0188708305359 Finalizing debug Before the debug is output to the page.
50 2.0188789367676 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 1.6200 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0023 0.002316951751709
SELECT parameter, value FROM parameters
2 0.0061 0.0060710906982422
SELECT * FROM `bad_bots`
3 0.0008 0.00077414512634277
SET time_zone = 'Europe/London'
4 0.0027 0.0026760101318359
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0024 0.002439022064209
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.140.196.3\";}'
6 0.0021 0.0020580291748047
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746026273'
7 0.0029 0.0029289722442627
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0007 0.00069904327392578
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0024 0.002377986907959
SELECT id FROM pages WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff' LIMIT 1
10 0.0023 0.0023009777069092
SELECT id FROM products WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff' AND hidden = 0 LIMIT 1
11 0.0024 0.0024237632751465
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0286 0.028610944747925
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0007 0.00072813034057617
SELECT * FROM pages WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff'
14 0.0024 0.0023901462554932
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0023 0.0022590160369873
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0075 0.0075070858001709
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.0027 0.0027191638946533
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.0019 0.0018661022186279
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0007 0.00074100494384766
SELECT id FROM categories WHERE parent_id = '26'
20 0.0073 0.0072779655456543
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.0020 0.002000093460083
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.0024 0.0023641586303711
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.0021 0.0020971298217773
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0005 0.00049495697021484
SELECT * FROM categorygroups WHERE id = '1'
25 0.0042 0.0041899681091309
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.0006 0.00057816505432129
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.00043988227844238
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.0046 0.0045719146728516
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
30 0.0006 0.0005791187286377
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.00056910514831543
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.00048398971557617
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00047492980957031
SELECT * FROM categorygroups WHERE id = '1'
34 0.0017 0.0016570091247559
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.0005340576171875
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.0009 0.00091218948364258
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.00058913230895996
SELECT id FROM categories WHERE parent_id = '28'
38 0.0056 0.0056149959564209
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.00060796737670898
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.00051498413085938
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.0007 0.00070285797119141
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.00046300888061523
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00060510635375977
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.0006 0.0005640983581543
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.00048208236694336
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0004 0.00043511390686035
SELECT id FROM categories WHERE parent_id = '29'
47 0.0008 0.00076484680175781
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.00054621696472168
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.00059986114501953
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.0006 0.00064206123352051
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0006 0.00057506561279297
SELECT * FROM categorygroups WHERE id = '1'
52 0.0008 0.0008080005645752
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.0007 0.00066781044006348
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.00042486190795898
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00048685073852539
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00081205368041992
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.00054001808166504
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.0006 0.00057005882263184
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.00053691864013672
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00045108795166016
SELECT * FROM categorygroups WHERE id = '1'
61 0.0008 0.00076103210449219
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.0006 0.0005791187286377
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0005 0.00046706199645996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0004 0.00044012069702148
SELECT id FROM categories WHERE parent_id = '31'
65 0.0009 0.00089502334594727
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0006 0.00057411193847656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0006 0.0006110668182373
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.00052189826965332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00047111511230469
SELECT * FROM categorygroups WHERE id = '1'
70 0.0005 0.0004880428314209
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0039 0.0039370059967041
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0022 0.0021989345550537
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0006 0.0005640983581543
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.0016 0.0016310214996338
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011050701141357
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0008 0.00076794624328613
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 1.3250 1.3250460624695
SELECT * FROM ipgeocountries WHERE INET_ATON('3.140.196.3') >= INET_ATON(ip_start) AND INET_ATON('3.140.196.3') <= INET_ATON(ip_end)
78 0.0027 0.0026741027832031
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0012960433959961
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00055098533630371
SELECT * FROM products WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff'
81 0.0004 0.0004279613494873
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4942
82 0.0007 0.00067305564880371
SELECT * FROM manufacturers WHERE id = '664'
83 0.0006 0.00055289268493652
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '664'
84 0.0019 0.0019071102142334
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '664' LIMIT 1
85 0.0022 0.0022239685058594
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '664' ORDER BY RAND() LIMIT 1
86 0.0005 0.00051712989807129
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
87 0.0006 0.00063991546630859
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '664'
88 0.0007 0.00065803527832031
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '664'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
89 0.0005 0.00052905082702637
SELECT * FROM manufacturerimages WHERE manufacturer_id = '664'
90 0.0005 0.0005030632019043
SELECT category_id FROM products_categories WHERE product_id = '4942'
91 0.0007 0.00067996978759766
SELECT * FROM categories WHERE id = '31'
92 0.0010 0.00096797943115234
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
93 0.0006 0.00058913230895996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0005 0.00047683715820312
SELECT id FROM categories WHERE parent_id = '31'
95 0.0008 0.00078010559082031
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 
96 0.0008 0.00078415870666504
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
97 0.0009 0.00092291831970215
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
98 0.0008 0.00084900856018066
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0006 0.00058484077453613
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
100 0.0021 0.0021340847015381
SELECT * FROM product_image_select WHERE product_id = '4942'
101 0.0016 0.001554012298584
SELECT * FROM productcustomimages WHERE product_id = '4942'
102 0.0014 0.0014238357543945
SELECT * FROM productfeeds WHERE product_id = '4942' ORDER BY item_date DESC
103 0.0030 0.0029749870300293
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0027 0.0027339458465576
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4942' AND t.hidden = 0 AND display_product = 1
105 0.0014 0.00136399269104
SELECT * FROM productamazoncontent WHERE product_id = '4942'
106 0.0012 0.0012030601501465
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
107 0.0015 0.001521110534668
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0005 0.00054693222045898
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0006 0.0006401538848877
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0005 0.00050997734069824
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
111 0.0095 0.0095169544219971
SELECT *, MATCH (description, title) AGAINST ('dolce gusto chocolat' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('dolce gusto chocolat' IN BOOLEAN MODE) AND 4942 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
112 0.0007 0.00066518783569336
SELECT *, MATCH (description, title) AGAINST ('dolce gusto chocolat' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('dolce gusto chocolat' IN BOOLEAN MODE) AND 4942 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
113 0.0006 0.0005791187286377
SELECT *, MATCH (description, title) AGAINST ('dolce gusto chocolat' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('dolce gusto chocolat' IN BOOLEAN MODE) AND 4942 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
114 0.0006 0.00057888031005859
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
115 0.0007 0.00068402290344238
SELECT * FROM product_image_select WHERE product_id = '4952'
116 0.0004 0.00043201446533203
SELECT * FROM productcustomimages WHERE product_id = '4952'
117 0.0009 0.00088000297546387
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
118 0.0006 0.00056195259094238
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0004 0.00042200088500977
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0004 0.00042510032653809
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0005 0.00045490264892578
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
122 0.0006 0.00062394142150879
SELECT * FROM product_image_select WHERE product_id = '4939'
123 0.0004 0.00038290023803711
SELECT * FROM productcustomimages WHERE product_id = '4939'
124 0.0013 0.0013458728790283
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
125 0.0007 0.00066208839416504
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00045514106750488
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0005 0.00053286552429199
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0007 0.00065279006958008
SELECT * FROM productimages WHERE product_id = '4949' ORDER BY sortorder ASC
129 0.0007 0.00069093704223633
SELECT * FROM product_image_select WHERE product_id = '4949'
130 0.0005 0.0004580020904541
SELECT * FROM productcustomimages WHERE product_id = '4949'
131 0.0011 0.0011069774627686
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4949' AND a.name = n.originalname
132 0.0006 0.00059413909912109
SELECT * FROM productoffers WHERE product_id = '4949' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0004 0.00039291381835938
SELECT * FROM productoffers
                WHERE product_id = '4949' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00050187110900879
SELECT value FROM productattributes WHERE product_id = '4949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0005 0.00053787231445312
SELECT * FROM productimages WHERE product_id = '980' ORDER BY sortorder ASC
136 0.0006 0.00058197975158691
SELECT * FROM product_image_select WHERE product_id = '980'
137 0.0004 0.00035691261291504
SELECT * FROM productcustomimages WHERE product_id = '980'
138 0.0008 0.00076889991760254
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '980' AND a.name = n.originalname
139 0.0005 0.00048089027404785
SELECT * FROM productoffers WHERE product_id = '980' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0004 0.00040221214294434
SELECT * FROM productoffers
                WHERE product_id = '980' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00047802925109863
SELECT value FROM productattributes WHERE product_id = '980' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0005 0.00046181678771973
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
143 0.0006 0.00059103965759277
SELECT * FROM product_image_select WHERE product_id = '4947'
144 0.0005 0.00046205520629883
SELECT * FROM productcustomimages WHERE product_id = '4947'
145 0.0010 0.00095796585083008
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
146 0.0006 0.00057196617126465
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0005 0.00048398971557617
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0005 0.00047683715820312
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
150 0.0006 0.00055789947509766
SELECT * FROM product_image_select WHERE product_id = '4940'
151 0.0004 0.0004417896270752
SELECT * FROM productcustomimages WHERE product_id = '4940'
152 0.0007 0.00072884559631348
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
153 0.0006 0.00059890747070312
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0004 0.00039386749267578
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0004 0.00044488906860352
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00056099891662598
SELECT id,asin FROM products WHERE parent_id = 4942
157 0.0022 0.00217604637146
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
158 0.0004 0.00044608116149902
SELECT category_id FROM products_categories WHERE product_id = '4942'
159 0.0005 0.00046586990356445
SELECT * FROM categories WHERE id = '31'
160 0.0007 0.0007178783416748
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
161 0.0004 0.00043606758117676
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
162 0.0003 0.00031590461730957
SELECT id FROM categories WHERE parent_id = '31'
163 0.0006 0.00064182281494141
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 
164 0.0005 0.00048398971557617
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 
165 0.0006 0.00059795379638672
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
166 0.0005 0.00050687789916992
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
167 0.0012 0.0012259483337402
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
168 0.0005 0.00049781799316406
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0004 0.00040888786315918
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0005 0.00045299530029297
SELECT * FROM products WHERE id = '4942'
171 0.0004 0.00044012069702148
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0011 0.0011320114135742
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
173 0.0004 0.00037717819213867
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00042510032653809
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0004 0.00041913986206055
SELECT category_id FROM products_categories WHERE product_id = '4942' AND prod_type = 'amz'
176 0.0004 0.00043606758117676
SELECT parent_id FROM categories WHERE id = '31'
177 0.0003 0.00033402442932129
SELECT * FROM categories WHERE id = '31'
178 0.0006 0.00058698654174805
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
179 0.0004 0.00042605400085449
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
180 0.0003 0.00029706954956055
SELECT id FROM categories WHERE parent_id = '31'
181 0.0005 0.0004889965057373
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 
182 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 (31)
				  AND p.disabled = 0 
183 0.0006 0.00063204765319824
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
184 0.0005 0.00045919418334961
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
185 0.0018 0.0017781257629395
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
186 0.0012 0.001244068145752
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0003 0.00030517578125
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0194 0.019433975219727
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
189 0.0020 0.0019669532775879
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
190 0.0008 0.00075888633728027
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
191 0.0005 0.00053095817565918
SELECT * FROM products WHERE id = 1626
192 0.0004 0.00039982795715332
SELECT * FROM products WHERE id = 4041
193 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = 4312
194 0.0004 0.00039196014404297
SELECT * FROM products WHERE id = 777
195 0.0005 0.00045514106750488
SELECT * FROM products WHERE id = 3881
196 0.0004 0.00037717819213867
SELECT * FROM products WHERE id = 4213
197 0.0005 0.00049591064453125
SELECT * FROM products WHERE id = '1626'
198 0.0005 0.00049090385437012
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
199 0.0006 0.00061392784118652
SELECT * FROM product_image_select WHERE product_id = '1626'
200 0.0004 0.00039792060852051
SELECT * FROM productcustomimages WHERE product_id = '1626'
201 0.0009 0.00092101097106934
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
202 0.0006 0.00061416625976562
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0004 0.00044798851013184
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0005 0.00047087669372559
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.00055098533630371
SELECT * FROM products WHERE id = '4041'
206 0.0005 0.00046896934509277
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
207 0.0007 0.00066494941711426
SELECT * FROM product_image_select WHERE product_id = '4041'
208 0.0005 0.00047087669372559
SELECT * FROM productcustomimages WHERE product_id = '4041'
209 0.0011 0.0011000633239746
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
210 0.0005 0.00046515464782715
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0004 0.0004420280456543
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0004 0.00043797492980957
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0005 0.00050997734069824
SELECT * FROM products WHERE id = '4312'
214 0.0005 0.00050711631774902
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
215 0.0007 0.00067806243896484
SELECT * FROM product_image_select WHERE product_id = '4312'
216 0.0005 0.00046801567077637
SELECT * FROM productcustomimages WHERE product_id = '4312'
217 0.0015 0.0014519691467285
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
218 0.0007 0.0006718635559082
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0005 0.00051689147949219
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00051593780517578
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00056600570678711
SELECT * FROM products WHERE id = '777'
222 0.0005 0.0005040168762207
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0007 0.00065207481384277
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0004 0.00042510032653809
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0013 0.0012569427490234
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
226 0.0006 0.00055789947509766
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0005 0.0005028247833252
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00054597854614258
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0006 0.00061202049255371
SELECT * FROM products WHERE id = '3881'
230 0.0006 0.00059199333190918
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
231 0.0007 0.00073099136352539
SELECT * FROM product_image_select WHERE product_id = '3881'
232 0.0004 0.00044512748718262
SELECT * FROM productcustomimages WHERE product_id = '3881'
233 0.0014 0.0013749599456787
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
234 0.0006 0.00062704086303711
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.00047397613525391
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0005 0.00048089027404785
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0006 0.00058388710021973
SELECT * FROM products WHERE id = '4213'
238 0.0007 0.00067496299743652
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
239 0.0007 0.00073790550231934
SELECT * FROM product_image_select WHERE product_id = '4213'
240 0.0005 0.00047516822814941
SELECT * FROM productcustomimages WHERE product_id = '4213'
241 0.0015 0.0015358924865723
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
242 0.0006 0.00059700012207031
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
243 0.0005 0.00045919418334961
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.00048208236694336
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0025 0.0024731159210205
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
246 0.0008 0.00082206726074219
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
247 0.0030 0.0029759407043457
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
248 0.0024 0.0024359226226807
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
249 0.0006 0.00055718421936035
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0006 0.00063776969909668
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'