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
1.470057964325 250 0.7468 0


No Amazon API Requests Made.


App Debug - Total Time 1.470057964325 seconds

Number Time From Start Name Description
1 0.65461111068726 Initialise Initialise FSB Function
2 0.66258096694946 App Controller Start Start of the App controller (called before the controller of every page)
3 0.69559097290039 Start of getCategoryListByGroup Function Before first category groups query
4 0.69714903831482 After initial query Before first category groups query
5 0.69715094566345 Get Category List for Group Before the call to getCategoryList function
6 0.69715404510498 Start of GetCategoryList function Start of the function
7 0.69716596603394 Before getting categories Query to get specific category list
8 0.69866704940796 After getting categories Query to get specific category list
9 0.69867014884949 Before getting category custom Before call to function getCategoryCustom
10 0.7241530418396 After getting category custom After call to function getCategoryCustom
11 0.72415900230408 Before getting category custom Before call to function getCategoryCustom
12 0.7365779876709 After getting category custom After call to function getCategoryCustom
13 0.73658299446106 Before getting category custom Before call to function getCategoryCustom
14 0.74921703338623 After getting category custom After call to function getCategoryCustom
15 0.74922204017639 Before getting category custom Before call to function getCategoryCustom
16 0.75818705558777 After getting category custom After call to function getCategoryCustom
17 0.75819301605225 Before getting category custom Before call to function getCategoryCustom
18 0.76577305793762 After getting category custom After call to function getCategoryCustom
19 0.76577711105347 Before getting category custom Before call to function getCategoryCustom
20 0.77386403083801 After getting category custom After call to function getCategoryCustom
21 0.77386903762817 End of GetCategoryList function End of the function
22 0.7738790512085 Get Category List for Group Before the call to getCategoryList function
23 0.77388215065002 Start of GetCategoryList function Start of the function
24 0.77388596534729 Before getting categories Query to get specific category list
25 0.77462315559387 End of getCategoryListByGroup Function Before return()
26 1.2134430408478 App Controller End End of the App controller (called before the controller of every page)
27 1.2143530845642 Product Start Start of the product info controller
28 1.2406511306763 Cache file not found Starting get product details
29 1.281702041626 Related products Start getting related products if enabled
30 1.2817051410675 Related Products Start Before the related products are found
31 1.2817070484161 Related Products Keywords Before the related product keywords are found
32 1.2817139625549 Create Keyword List Function Start of function
33 1.2818551063538 Create Keyword List Function After looping provided content - 30 keywords found
34 1.2838399410248 Create Keyword List Function After looping initial keyword list - 28 keywords remaining
35 1.2838530540466 Create Keyword List Function After reducing keyword list
36 1.2840139865875 Create Keyword List Function After selecting by scoring keywords
37 1.2840211391449 Create Keyword List Function After final loop of keywords
38 1.2840240001678 Related Products Keywords After the related product keywords are found
39 1.3260459899902 Related Products End After the related products are found
40 1.3478829860687 Product End End of the product info controller (Product Info)
41 1.3508169651031 App_after Controller Start Start of the App_after controller (called after the controller of every page)
42 1.3528220653534 Before Get Options Before the call to getOptions in the tpl class
43 1.4171280860901 After Get Options After the call to getOptions in the tpl class
44 1.4173130989075 App_after Controller End End of the App_after controller (called after the controller of every page)
45 1.4173491001129 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
46 1.4326250553131 Product Info: After Smarty Fetch After the product.tpl template is fetched
47 1.4326319694519 Product Info: Before Template Display Before the template is displayed
48 1.4700050354004 Product Info: After Template Display After the template is displayed
49 1.4700300693512 Finalizing debug Before the debug is output to the page.
50 1.4700560569763 End of App This is the end of the app logging, final timestamp


Query Debug - 250 Database Queries. Total time 0.7468 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0022 0.0022211074829102
SELECT parameter, value FROM parameters
2 0.0093 0.0093240737915039
SELECT * FROM `bad_bots`
3 0.0004 0.00039792060852051
SET time_zone = 'Europe/London'
4 0.0033 0.0033199787139893
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0039 0.0039350986480713
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"44.222.131.239\";}'
6 0.0045 0.0045168399810791
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1726111039'
7 0.0030 0.0030238628387451
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0009 0.00091218948364258
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0026 0.0026390552520752
SELECT id FROM pages WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff' LIMIT 1
10 0.0034 0.0033700466156006
SELECT id FROM products WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff' AND hidden = 0 LIMIT 1
11 0.0042 0.0041828155517578
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0276 0.027611017227173
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0006 0.00063395500183105
SELECT * FROM pages WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff'
14 0.0015 0.001539945602417
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0015 0.0014650821685791
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0066 0.0065810680389404
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.0019 0.0019419193267822
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.0013 0.001288890838623
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0005 0.00052499771118164
SELECT id FROM categories WHERE parent_id = '26'
20 0.0059 0.0059258937835693
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.0052 0.0052108764648438
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.0018 0.001798152923584
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.0013830661773682
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0006 0.00057196617126465
SELECT * FROM categorygroups WHERE id = '1'
25 0.0044 0.0043630599975586
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.0006101131439209
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.0005 0.00045204162597656
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00049495697021484
SELECT id FROM categories WHERE parent_id = '27'
29 0.0041 0.0040931701660156
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.0005640983581543
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.00055313110351562
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.00051403045654297
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0006 0.00058317184448242
SELECT * FROM categorygroups WHERE id = '1'
34 0.0015 0.0015490055084229
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.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 = 28
36 0.0005 0.00049591064453125
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0006 0.00055503845214844
SELECT id FROM categories WHERE parent_id = '28'
38 0.0050 0.0050308704376221
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.0011 0.0010521411895752
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.0012 0.001215934753418
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.0010 0.0010058879852295
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0010 0.00095200538635254
SELECT * FROM categorygroups WHERE id = '1'
43 0.0014 0.0013670921325684
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.0010 0.00095200538635254
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.0008 0.00078701972961426
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0008 0.00082683563232422
SELECT id FROM categories WHERE parent_id = '29'
47 0.0014 0.0014379024505615
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.0008 0.00082898139953613
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.0010 0.00099897384643555
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.00087690353393555
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0007 0.00067782402038574
SELECT * FROM categorygroups WHERE id = '1'
52 0.0010 0.0010280609130859
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.0008 0.00075602531433105
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.0007 0.00069403648376465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0007 0.00066900253295898
SELECT id FROM categories WHERE parent_id = '30'
56 0.0012 0.0011930465698242
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.0008 0.00079107284545898
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.0008 0.00084400177001953
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.0008 0.00078701972961426
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0006 0.00061392784118652
SELECT * FROM categorygroups WHERE id = '1'
61 0.0013 0.0013020038604736
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.0010 0.00097107887268066
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.00063395500183105
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0007 0.00069713592529297
SELECT id FROM categories WHERE parent_id = '31'
65 0.0012 0.0011699199676514
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.00083708763122559
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.0008 0.00079894065856934
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.00078201293945312
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0007 0.00068998336791992
SELECT * FROM categorygroups WHERE id = '1'
70 0.0007 0.00072002410888672
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0043 0.0042648315429688
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0022 0.002216100692749
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00076889991760254
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.0018 0.00177001953125
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0017 0.0016748905181885
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0017 0.0017240047454834
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.4200 0.42004489898682
SELECT * FROM ipgeocountries WHERE INET_ATON('44.222.131.239') >= INET_ATON(ip_start) AND INET_ATON('44.222.131.239') <= INET_ATON(ip_end)
78 0.0020 0.0019550323486328
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0013 0.0013401508331299
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0008 0.00078988075256348
SELECT * FROM products WHERE pagename = 'frhome-48-capsules-compatible-nescafe-dolce-gusto-chocolat-il-caff'
81 0.0004 0.00043797492980957
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4942
82 0.0009 0.00089788436889648
SELECT * FROM manufacturers WHERE id = '664'
83 0.0007 0.00068807601928711
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '664'
84 0.0026 0.0026340484619141
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '664' LIMIT 1
85 0.0025 0.0024819374084473
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.0008 0.00081086158752441
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
87 0.0007 0.00072193145751953
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '664'
88 0.0007 0.00073814392089844
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.0007 0.00074505805969238
SELECT * FROM manufacturerimages WHERE manufacturer_id = '664'
90 0.0007 0.0006859302520752
SELECT category_id FROM products_categories WHERE product_id = '4942'
91 0.0008 0.00075411796569824
SELECT * FROM categories WHERE id = '31'
92 0.0011 0.001147985458374
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.0007 0.00069403648376465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
94 0.0006 0.00064706802368164
SELECT id FROM categories WHERE parent_id = '31'
95 0.0010 0.00099897384643555
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.0010 0.00097799301147461
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.0010 0.001039981842041
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.0007 0.0007169246673584
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
99 0.0007 0.00070810317993164
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
100 0.0030 0.0029878616333008
SELECT * FROM product_image_select WHERE product_id = '4942'
101 0.0022 0.0022499561309814
SELECT * FROM productcustomimages WHERE product_id = '4942'
102 0.0023 0.0023341178894043
SELECT * FROM productfeeds WHERE product_id = '4942' ORDER BY item_date DESC
103 0.0036 0.0036239624023438
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.0032 0.0031650066375732
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.0019 0.0019228458404541
SELECT * FROM productamazoncontent WHERE product_id = '4942'
106 0.0018 0.0018370151519775
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
107 0.0017 0.0017321109771729
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
108 0.0006 0.00064516067504883
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
109 0.0007 0.00070500373840332
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110 0.0006 0.00059700012207031
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.0108 0.010792970657349
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.0008 0.0007779598236084
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.00060701370239258
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.00055289268493652
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
115 0.0007 0.00071215629577637
SELECT * FROM product_image_select WHERE product_id = '4940'
116 0.0005 0.00047898292541504
SELECT * FROM productcustomimages WHERE product_id = '4940'
117 0.0009 0.00090909004211426
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
118 0.0005 0.00051212310791016
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
119 0.0004 0.0004429817199707
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
120 0.0005 0.00049495697021484
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
121 0.0005 0.00054001808166504
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
122 0.0006 0.00060391426086426
SELECT * FROM product_image_select WHERE product_id = '4947'
123 0.0004 0.00040602684020996
SELECT * FROM productcustomimages WHERE product_id = '4947'
124 0.0009 0.00091385841369629
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
125 0.0005 0.00053215026855469
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
126 0.0005 0.00047898292541504
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
127 0.0006 0.00056004524230957
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128 0.0005 0.00047183036804199
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
129 0.0007 0.00067996978759766
SELECT * FROM product_image_select WHERE product_id = '4952'
130 0.0006 0.00055313110351562
SELECT * FROM productcustomimages WHERE product_id = '4952'
131 0.0008 0.00076389312744141
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
132 0.0006 0.00058507919311523
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
133 0.0005 0.0004889965057373
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
134 0.0005 0.00048708915710449
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135 0.0006 0.00057196617126465
SELECT * FROM productimages WHERE product_id = '4949' ORDER BY sortorder ASC
136 0.0006 0.00064802169799805
SELECT * FROM product_image_select WHERE product_id = '4949'
137 0.0004 0.00043702125549316
SELECT * FROM productcustomimages WHERE product_id = '4949'
138 0.0009 0.0009148120880127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4949' AND a.name = n.originalname
139 0.0006 0.00055193901062012
SELECT * FROM productoffers WHERE product_id = '4949' AND merchantid = 'A1X6FK5RDHNB96'
140 0.0005 0.00050902366638184
SELECT * FROM productoffers
                WHERE product_id = '4949' AND price > 0
                ORDER BY price ASC LIMIT 1
141 0.0005 0.00049114227294922
SELECT value FROM productattributes WHERE product_id = '4949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142 0.0007 0.000701904296875
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
143 0.0008 0.00084900856018066
SELECT * FROM product_image_select WHERE product_id = '4939'
144 0.0005 0.00049901008605957
SELECT * FROM productcustomimages WHERE product_id = '4939'
145 0.0014 0.0013518333435059
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
146 0.0006 0.00062179565429688
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0006 0.0005500316619873
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0006 0.00060796737670898
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149 0.0008 0.0008389949798584
SELECT * FROM productimages WHERE product_id = '980' ORDER BY sortorder ASC
150 0.0010 0.00098109245300293
SELECT * FROM product_image_select WHERE product_id = '980'
151 0.0007 0.00073480606079102
SELECT * FROM productcustomimages WHERE product_id = '980'
152 0.0012 0.0012199878692627
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '980' AND a.name = n.originalname
153 0.0007 0.00066709518432617
SELECT * FROM productoffers WHERE product_id = '980' AND merchantid = 'A1X6FK5RDHNB96'
154 0.0006 0.00063395500183105
SELECT * FROM productoffers
                WHERE product_id = '980' AND price > 0
                ORDER BY price ASC LIMIT 1
155 0.0007 0.00069689750671387
SELECT value FROM productattributes WHERE product_id = '980' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156 0.0006 0.00064492225646973
SELECT id,asin FROM products WHERE parent_id = 4942
157 0.0027 0.002701997756958
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
158 0.0007 0.00072717666625977
SELECT category_id FROM products_categories WHERE product_id = '4942'
159 0.0006 0.00063395500183105
SELECT * FROM categories WHERE id = '31'
160 0.0008 0.00080013275146484
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.00044918060302734
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
162 0.0004 0.00038385391235352
SELECT id FROM categories WHERE parent_id = '31'
163 0.0007 0.00065183639526367
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.0010 0.00095105171203613
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.0007 0.00072503089904785
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.0006 0.0006258487701416
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
167 0.0014 0.0014469623565674
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
168 0.0006 0.00055313110351562
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
169 0.0006 0.00056600570678711
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
170 0.0007 0.00069689750671387
SELECT * FROM products WHERE id = '4942'
171 0.0005 0.0005340576171875
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0013 0.0012581348419189
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
173 0.0005 0.00046300888061523
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0005 0.00047779083251953
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0006 0.00058102607727051
SELECT category_id FROM products_categories WHERE product_id = '4942' AND prod_type = 'amz'
176 0.0006 0.00060486793518066
SELECT parent_id FROM categories WHERE id = '31'
177 0.0005 0.00046300888061523
SELECT * FROM categories WHERE id = '31'
178 0.0008 0.0007779598236084
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.0005 0.00046586990356445
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
180 0.0004 0.00041985511779785
SELECT id FROM categories WHERE parent_id = '31'
181 0.0007 0.00066804885864258
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.0006 0.00057005882263184
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.00063300132751465
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.0006 0.0006101131439209
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
185 0.0021 0.0021440982818604
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
186 0.0014 0.0013949871063232
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
187 0.0005 0.00047898292541504
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
188 0.0143 0.014331102371216
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.0018 0.0018429756164551
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.0006 0.00058794021606445
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.0007 0.0007011890411377
SELECT * FROM products WHERE id = 1626
192 0.0005 0.00047612190246582
SELECT * FROM products WHERE id = 4041
193 0.0005 0.00050115585327148
SELECT * FROM products WHERE id = 4312
194 0.0005 0.00050187110900879
SELECT * FROM products WHERE id = 777
195 0.0005 0.00052404403686523
SELECT * FROM products WHERE id = 3881
196 0.0006 0.00058507919311523
SELECT * FROM products WHERE id = 4213
197 0.0006 0.00057721138000488
SELECT * FROM products WHERE id = '1626'
198 0.0006 0.00060105323791504
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
199 0.0007 0.00068211555480957
SELECT * FROM product_image_select WHERE product_id = '1626'
200 0.0005 0.00045585632324219
SELECT * FROM productcustomimages WHERE product_id = '1626'
201 0.0011 0.0011050701141357
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.00056600570678711
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0005 0.00048995018005371
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0005 0.00046396255493164
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205 0.0006 0.00058603286743164
SELECT * FROM products WHERE id = '4041'
206 0.0005 0.00048518180847168
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
207 0.0007 0.00070881843566895
SELECT * FROM product_image_select WHERE product_id = '4041'
208 0.0006 0.0006098747253418
SELECT * FROM productcustomimages WHERE product_id = '4041'
209 0.0012 0.0011539459228516
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
210 0.0006 0.00056099891662598
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
211 0.0005 0.00054311752319336
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
212 0.0006 0.00056290626525879
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213 0.0007 0.00072693824768066
SELECT * FROM products WHERE id = '4312'
214 0.0005 0.00053596496582031
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
215 0.0006 0.00062203407287598
SELECT * FROM product_image_select WHERE product_id = '4312'
216 0.0004 0.0004429817199707
SELECT * FROM productcustomimages WHERE product_id = '4312'
217 0.0011 0.0010731220245361
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
218 0.0005 0.00053596496582031
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
219 0.0005 0.00049996376037598
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
220 0.0005 0.00047492980957031
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221 0.0006 0.00062203407287598
SELECT * FROM products WHERE id = '777'
222 0.0005 0.00052785873413086
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
223 0.0007 0.00068211555480957
SELECT * FROM product_image_select WHERE product_id = '777'
224 0.0005 0.00048995018005371
SELECT * FROM productcustomimages WHERE product_id = '777'
225 0.0012 0.0011839866638184
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.00058698654174805
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
227 0.0006 0.00062894821166992
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
228 0.0005 0.00054287910461426
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229 0.0007 0.00069689750671387
SELECT * FROM products WHERE id = '3881'
230 0.0007 0.00073504447937012
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
231 0.0007 0.00066590309143066
SELECT * FROM product_image_select WHERE product_id = '3881'
232 0.0005 0.00054192543029785
SELECT * FROM productcustomimages WHERE product_id = '3881'
233 0.0011 0.0010919570922852
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.00061893463134766
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
235 0.0005 0.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
236 0.0007 0.00073385238647461
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237 0.0009 0.00086116790771484
SELECT * FROM products WHERE id = '4213'
238 0.0006 0.00064396858215332
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
239 0.0007 0.00067520141601562
SELECT * FROM product_image_select WHERE product_id = '4213'
240 0.0005 0.00049901008605957
SELECT * FROM productcustomimages WHERE product_id = '4213'
241 0.0013 0.001317024230957
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.00054001808166504
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
244 0.0005 0.0005190372467041
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245 0.0021 0.002140998840332
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
246 0.0008 0.00083589553833008
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
247 0.0032 0.0031628608703613
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
248 0.0020 0.0020289421081543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
249 0.0007 0.0006861686706543
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
250 0.0012 0.0011539459228516
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'