Pot de café en acier inoxydable 21 onces,Boîte à Café Coffee,Hermétique en Acier Inoxydable pour Conserver le Café en Grain et Moulu,Récipient avec Couvercle et Cadran Dateur,café en grains, en poudre, thé, noix, Kakao

Pot de café en acier inoxydable 21 onces,Boîte à Café Coffee,Hermétique en Acier Inoxydable pour Conserver le Café en Grain et Moulu,Récipient avec Couvercle et Cadran Dateur,café en grains, en poudre, thé, noix, Kakao
Pot de café en acier inoxydable 21 onces,Boîte à Café Coffee,Hermétique en Acier Inoxydable pour Conserver le Café en Grain et Moulu,Récipient avec Couvercle et Cadran Dateur,café en grains, en poudre, thé, noix, Kakao Pot de café en acier inoxydable 21 onces,Boîte à Café Coffee,Hermétique en Acier Inoxydable pour Conserver le Café en Grain et Moulu,Récipient avec Couvercle et Cadran Dateur,café en grains, en poudre, thé, noix, Kakao Pot de café en acier inoxydable 21 onces,Boîte à Café Coffee,Hermétique en Acier Inoxydable pour Conserver le Café en Grain et Moulu,Récipient avec Couvercle et Cadran Dateur,café en grains, en poudre, thé, noix, Kakao Pot de café en acier inoxydable 21 onces,Boîte à Café Coffee,Hermétique en Acier Inoxydable pour Conserver le Café en Grain et Moulu,Récipient avec Couvercle et Cadran Dateur,café en grains, en poudre, thé, noix, Kakao Pot de café en acier inoxydable 21 onces,Boîte à Café Coffee,Hermétique en Acier Inoxydable pour Conserver le Café en Grain et Moulu,Récipient avec Couvercle et Cadran Dateur,café en grains, en poudre, thé, noix, Kakao (cliquez sur les images pour élargir)
Bouton de clic pour le prix
Non Disponible Épuisé
Le prix et la disponibilité du produit sont corrects en date du 2021-07-22 12:48:48 UTC et sont sujets à changements. Toute informaiton relative au prix ou à la disponibilité affichés pour https://www.amazon.fr/ au moment de la commande sera d'application lors de l'achat de ce produit.
CERTAINS ÉLÉMENTS DE CONTENU QUI APPARAISSENT SUR CE SITE PROVIENNENT DE AMAZON SERVICES LLC. CE CONTENU EST FOURNI TEL QUEL ET EST SUJET À CHANGEMENTS OU RETRAIT À TOUT MOMENT.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.64438509941101 254 0.1510 0


No Amazon API Requests Made.

Total time 0.64438509941101 seconds

Number Time From Start Name Description
1 0.42859387397766 Initialise Initialise FSB Function
2 0.43094706535339 App Controller Start Start of the App controller (called before the controller of every page)
3 0.4344220161438 Start of getCategoryListByGroup Function Before first category groups query
4 0.43480205535889 After initial query Before first category groups query
5 0.43480396270752 Get Category List for Group Before the call to getCategoryList function
6 0.43480706214905 Start of GetCategoryList function Start of the function
7 0.434809923172 Before getting categories Query to get specific category list
8 0.43527698516846 After getting categories Query to get specific category list
9 0.43527889251709 Before getting category custom Before call to function getCategoryCustom
10 0.45318007469177 After getting category custom After call to function getCategoryCustom
11 0.45318293571472 Before getting category custom Before call to function getCategoryCustom
12 0.46361708641052 After getting category custom After call to function getCategoryCustom
13 0.46361994743347 Before getting category custom Before call to function getCategoryCustom
14 0.46903204917908 After getting category custom After call to function getCategoryCustom
15 0.46903491020203 Before getting category custom Before call to function getCategoryCustom
16 0.47220087051392 After getting category custom After call to function getCategoryCustom
17 0.47220301628113 Before getting category custom Before call to function getCategoryCustom
18 0.47525095939636 After getting category custom After call to function getCategoryCustom
19 0.47525405883789 Before getting category custom Before call to function getCategoryCustom
20 0.47748589515686 After getting category custom After call to function getCategoryCustom
21 0.47748899459839 End of GetCategoryList function End of the function
22 0.47749710083008 End of getCategoryListByGroup Function Before return()
23 0.48316097259521 App Controller End End of the App controller (called before the controller of every page)
24 0.48405599594116 Product Start Start of the product info controller
25 0.48667597770691 Cache file not found Starting get product details
26 0.52546000480652 Related products Start getting related products if enabled
27 0.52546191215515 Related Products Start Before the related products are found
28 0.52546310424805 Related Products Keywords Before the related product keywords are found
29 0.52546787261963 Create Keyword List Function Start of function
30 0.52564787864685 Create Keyword List Function After looping provided content - 86 keywords found
31 0.53002786636353 Create Keyword List Function After looping initial keyword list - 79 keywords remaining
32 0.53004193305969 Create Keyword List Function After reducing keyword list
33 0.53062295913696 Create Keyword List Function After selecting by scoring keywords
34 0.53062987327576 Create Keyword List Function After final loop of keywords
35 0.53063297271729 Related Products Keywords After the related product keywords are found
36 0.55051589012146 Related Products End After the related products are found
37 0.56209397315979 Product End End of the product info controller (Product Info)
38 0.56329703330994 App_after Controller Start Start of the App_after controller (called after the controller of every page)
39 0.56389689445496 Before Get Options Before the call to getOptions in the tpl class
40 0.59182000160217 After Get Options After the call to getOptions in the tpl class
41 0.59197306632996 App_after Controller End End of the App_after controller (called after the controller of every page)
42 0.5920090675354 Product Info: Before Smarty Fetch Before the product.tpl template is fetched
43 0.61410403251648 Product Info: After Smarty Fetch After the product.tpl template is fetched
44 0.61410999298096 Product Info: Before Template Display Before the template is displayed
45 0.64435696601868 Product Info: After Template Display After the template is displayed
46 0.64437103271484 Finalizing debug Before the debug is output to the page.
47 0.64438390731812 End of App This is the end of the app logging, final timestamp


Query Debug - 254 Database Queries. Total time 0.1510 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0006 0.00055384635925293
SELECT parameter, value FROM parameters
2 0.0007 0.00069904327392578
SELECT * FROM `bad_bots`
3 0.0003 0.00025701522827148
SET time_zone = 'Europe/London'
4 0.0003 0.00027108192443848
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0019 0.0019328594207764
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.236.110.106\";}'
6 0.0013 0.0012609958648682
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627540745'
7 0.0007 0.0006868839263916
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00027084350585938
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0005 0.00054097175598145
SELECT id FROM pages WHERE pagename = 'pot-de-cafe-en-acier-inoxydable-21-oncesbote-cafe-coffeehermetique-en-1927415522' LIMIT 1
10 0.0006 0.00055599212646484
SELECT id FROM products WHERE pagename = 'pot-de-cafe-en-acier-inoxydable-21-oncesbote-cafe-coffeehermetique-en-1927415522' AND hidden = 0 LIMIT 1
11 0.0013 0.0013458728790283
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12 0.0009 0.00094485282897949
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13 0.0005 0.00052094459533691
SELECT * FROM pages WHERE pagename = 'pot-de-cafe-en-acier-inoxydable-21-oncesbote-cafe-coffeehermetique-en-1927415522'
14 0.0004 0.0003659725189209
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0004 0.00044488906860352
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0095 0.0094830989837646
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.0003 0.00025510787963867
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.0002 0.00024104118347168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '26'
20 0.0066 0.0066089630126953
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.0003 0.00030303001403809
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.0002 0.00022292137145996
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.0003 0.00025320053100586
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.00019407272338867
SELECT * FROM categorygroups WHERE id = '1'
25 0.0043 0.0042800903320312
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.0003 0.00028300285339355
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.0002 0.00018095970153809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00018191337585449
SELECT id FROM categories WHERE parent_id = '27'
29 0.0042 0.0042397975921631
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.0003 0.00031185150146484
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.0002 0.0001990795135498
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.0004 0.0003669261932373
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0003 0.00026297569274902
SELECT * FROM categorygroups WHERE id = '1'
34 0.0018 0.0017549991607666
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.0003 0.00029397010803223
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.0002 0.00021910667419434
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0003 0.00034308433532715
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016300678253174
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.0003 0.00029706954956055
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.0003 0.00025200843811035
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.0002 0.00020194053649902
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0003 0.00030088424682617
SELECT * FROM categorygroups WHERE id = '1'
43 0.0006 0.00057291984558105
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.0002 0.00022292137145996
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.0003 0.00030207633972168
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0003 0.00027608871459961
SELECT id FROM categories WHERE parent_id = '29'
47 0.0006 0.00055193901062012
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.0004 0.00041103363037109
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.0003 0.00028586387634277
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.0002 0.0002129077911377
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00021481513977051
SELECT * FROM categorygroups WHERE id = '1'
52 0.0006 0.00058412551879883
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.0002 0.00021195411682129
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.0003 0.00034499168395996
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.00024795532226562
SELECT id FROM categories WHERE parent_id = '30'
56 0.0005 0.00054621696472168
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.0003 0.00029492378234863
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.0003 0.0002751350402832
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.0002 0.00020694732666016
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00022315979003906
SELECT * FROM categorygroups WHERE id = '1'
61 0.0002 0.0002291202545166
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.0002 0.00021600723266602
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.0002 0.00021600723266602
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00019192695617676
SELECT id FROM categories WHERE parent_id = '31'
65 0.0002 0.00019407272338867
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.0002 0.0002129077911377
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.0004 0.00044703483581543
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.0002 0.00019598007202148
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00021100044250488
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.00023818016052246
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71 0.0003 0.00028204917907715
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72 0.0004 0.0004119873046875
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
73 0.0002 0.00022792816162109
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74 0.0005 0.00048995018005371
SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75 0.0006 0.00058197975158691
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76 0.0003 0.00029993057250977
SELECT * FROM ipgeocountries WHERE INET_ATON('3.236.110.106') >= INET_ATON(ip_start) AND INET_ATON('3.236.110.106') <= INET_ATON(ip_end)
77 0.0003 0.00026798248291016
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78 0.0002 0.0002129077911377
SELECT * FROM countryredirects WHERE countrycode = 'US'
79 0.0007 0.00073599815368652
SELECT * FROM products WHERE pagename = 'pot-de-cafe-en-acier-inoxydable-21-oncesbote-cafe-coffeehermetique-en-1927415522'
80 0.0007 0.00072097778320312
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1915
81 0.0003 0.00032305717468262
SELECT * FROM manufacturers WHERE id = '401'
82 0.0008 0.00080299377441406
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '401'
83 0.0005 0.00046896934509277
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '401' LIMIT 1
84 0.0009 0.00089693069458008
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '401' ORDER BY RAND() LIMIT 1
85 0.0003 0.00032901763916016
SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
86 0.0003 0.00032687187194824
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '401'
87 0.0005 0.00054597854614258
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '401'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
88 0.0006 0.00055289268493652
SELECT * FROM manufacturerimages WHERE manufacturer_id = '401'
89 0.0004 0.0003960132598877
SELECT category_id FROM products_categories WHERE product_id = '1915'
90 0.0003 0.00027799606323242
SELECT * FROM categories WHERE id = '26'
91 0.0080 0.0080158710479736
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
92 0.0003 0.00029110908508301
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
93 0.0002 0.00021791458129883
SELECT id FROM categories WHERE parent_id = '26'
94 0.0078 0.0077788829803467
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 
95 0.0005 0.00052595138549805
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 
96 0.0002 0.00023102760314941
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
97 0.0003 0.00034403800964355
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
98 0.0004 0.00043702125549316
SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
99 0.0006 0.00055980682373047
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1915' AND p.id = pi.product_id ORDER BY pi.sortorder
100 0.0002 0.00023198127746582
SELECT * FROM product_image_select WHERE product_id = '1915'
101 0.0002 0.00023007392883301
SELECT * FROM productcustomimages WHERE product_id = '1915'
102 0.0006 0.00056314468383789
SELECT * FROM productfeeds WHERE product_id = '1915' ORDER BY item_date DESC
103 0.0019 0.0018630027770996
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104 0.0005 0.00054502487182617
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1915' AND t.hidden = 0 AND display_product = 1
105 0.0008 0.00081992149353027
SELECT * FROM productamazoncontent WHERE product_id = '1915'
106 0.0005 0.00051498413085938
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1915'
                GROUP BY o.product_id
107 0.0009 0.00089907646179199
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1915'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
108 0.0004 0.0004279613494873
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1915
109 0.0013 0.0012810230255127
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
110 0.0006 0.00059103965759277
SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
111 0.0004 0.0004429817199707
SELECT * FROM productoffers
                WHERE product_id = '1915' AND price > 0
                ORDER BY price ASC LIMIT 1
112 0.0004 0.00035405158996582
SELECT * FROM productoffers
                WHERE product_id = 1915
                ORDER BY price ASC LIMIT 1
113 0.0004 0.00040411949157715
SELECT value FROM productattributes
                WHERE product_id = '1915'
                AND name = 'ListPriceAmount'
114 0.0003 0.00025796890258789
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1915'
                GROUP BY o.product_id
115 0.0002 0.0002129077911377
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1915'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
116 0.0003 0.00030994415283203
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1915
117 0.0004 0.00039291381835938
SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118 0.0007 0.0006868839263916
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1915'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
119 0.0005 0.00053787231445312
SELECT * FROM products WHERE parent_id = '1915'
120 0.0010 0.0010139942169189
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4901' AND a.name = n.originalname
121 0.0004 0.00040292739868164
SELECT * FROM productoffers WHERE product_id = '4901' AND merchantid = 'A1X6FK5RDHNB96'
122 0.0005 0.00045013427734375
SELECT * FROM productoffers
                WHERE product_id = '4901' AND price > 0
                ORDER BY price ASC LIMIT 1
123 0.0005 0.00048995018005371
SELECT * FROM productoffers
                WHERE product_id = 4901
                ORDER BY price ASC LIMIT 1
124 0.0003 0.00033307075500488
SELECT value FROM productattributes
                WHERE product_id = '4901'
                AND name = 'ListPriceAmount'
125 0.0002 0.00021910667419434
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
126 0.0101 0.010051965713501
SELECT *, MATCH (description, title) AGAINST ('café' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('café' IN BOOLEAN MODE) AND 1915 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
127 0.0005 0.00049495697021484
SELECT *, MATCH (description, title) AGAINST ('café' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('café' IN BOOLEAN MODE) AND 1915 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
128 0.0008 0.00084805488586426
SELECT *, MATCH (description, title) AGAINST ('café' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('café' IN BOOLEAN MODE) AND 1915 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
129 0.0005 0.0005180835723877
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
130 0.0004 0.00037097930908203
SELECT * FROM product_image_select WHERE product_id = '790'
131 0.0002 0.00022697448730469
SELECT * FROM productcustomimages WHERE product_id = '790'
132 0.0002 0.0002131462097168
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
133 0.0002 0.00023794174194336
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
134 0.0004 0.00042605400085449
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
135 0.0002 0.00022101402282715
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136 0.0003 0.00030016899108887
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
137 0.0004 0.00042009353637695
SELECT * FROM product_image_select WHERE product_id = '810'
138 0.0002 0.000244140625
SELECT * FROM productcustomimages WHERE product_id = '810'
139 0.0004 0.00036001205444336
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
140 0.0002 0.00024604797363281
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
141 0.0005 0.00048184394836426
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
142 0.0002 0.00021696090698242
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143 0.0002 0.00021886825561523
SELECT * FROM productimages WHERE product_id = '4929' ORDER BY sortorder ASC
144 0.0002 0.00021004676818848
SELECT * FROM product_image_select WHERE product_id = '4929'
145 0.0004 0.00036501884460449
SELECT * FROM productcustomimages WHERE product_id = '4929'
146 0.0010 0.00095987319946289
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4929' AND a.name = n.originalname
147 0.0004 0.00042891502380371
SELECT * FROM productoffers WHERE product_id = '4929' AND merchantid = 'A1X6FK5RDHNB96'
148 0.0004 0.00044703483581543
SELECT * FROM productoffers
                WHERE product_id = '4929' AND price > 0
                ORDER BY price ASC LIMIT 1
149 0.0004 0.00043106079101562
SELECT value FROM productattributes WHERE product_id = '4929' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150 0.0003 0.00034689903259277
SELECT id,asin FROM products WHERE parent_id = 1915
151 0.0005 0.00050687789916992
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4901
152 0.0006 0.00057792663574219
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4901
153 0.0003 0.00028395652770996
SELECT category_id FROM products_categories WHERE product_id = '1915'
154 0.0004 0.00037717819213867
SELECT * FROM categories WHERE id = '26'
155 0.0003 0.00031304359436035
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
156 0.0002 0.00022697448730469
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
157 0.0002 0.00023198127746582
SELECT id FROM categories WHERE parent_id = '26'
158 0.0003 0.00030303001403809
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 
159 0.0002 0.00021815299987793
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 
160 0.0002 0.00020098686218262
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
161 0.0002 0.00020599365234375
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
162 0.0004 0.00038599967956543
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
163 0.0002 0.00024795532226562
SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
164 0.0003 0.00025296211242676
SELECT * FROM productoffers
                WHERE product_id = '1915' AND price > 0
                ORDER BY price ASC LIMIT 1
165 0.0003 0.00029993057250977
SELECT * FROM productoffers
                WHERE product_id = 1915
                ORDER BY price ASC LIMIT 1
166 0.0002 0.00022792816162109
SELECT value FROM productattributes
                WHERE product_id = '1915'
                AND name = 'ListPriceAmount'
167 0.0005 0.00046396255493164
SELECT * FROM products WHERE id = '1915'
168 0.0003 0.00030803680419922
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1915'
                GROUP BY o.product_id
169 0.0002 0.00021886825561523
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1915'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
170 0.0003 0.00027203559875488
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1915
171 0.0003 0.00028395652770996
SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172 0.0002 0.0002291202545166
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
173 0.0002 0.0002131462097168
SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
174 0.0004 0.00040197372436523
SELECT * FROM productoffers
                WHERE product_id = '1915' AND price > 0
                ORDER BY price ASC LIMIT 1
175 0.0003 0.00029516220092773
SELECT * FROM productoffers
                WHERE product_id = 1915
                ORDER BY price ASC LIMIT 1
176 0.0002 0.0002129077911377
SELECT value FROM productattributes
                WHERE product_id = '1915'
                AND name = 'ListPriceAmount'
177 0.0004 0.00037312507629395
SELECT category_id FROM products_categories WHERE product_id = '1915' AND prod_type = 'amz'
178 0.0002 0.0002448558807373
SELECT parent_id FROM categories WHERE id = '26'
179 0.0003 0.0002739429473877
SELECT * FROM categories WHERE id = '26'
180 0.0003 0.00032711029052734
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
181 0.0003 0.00030684471130371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
182 0.0002 0.00022697448730469
SELECT id FROM categories WHERE parent_id = '26'
183 0.0004 0.00042200088500977
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 
184 0.0003 0.00029897689819336
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 
185 0.0002 0.00021791458129883
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
186 0.0002 0.00024509429931641
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
187 0.0003 0.00032210350036621
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
188 0.0003 0.00025081634521484
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
189 0.0002 0.00023603439331055
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
190 0.0008 0.0007789134979248
SELECT * FROM pages WHERE id = 38
191 0.0033 0.0033011436462402
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
192 0.0005 0.00054502487182617
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1627540745;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:10:\"808|amazon\";i:4;s:10:\"810|amazon\";i:5;s:11:\"4947|amazon\";}}' WHERE id = '160'
193 0.0005 0.00054597854614258
SELECT * FROM products WHERE id = 790
194 0.0005 0.00048089027404785
SELECT * FROM products WHERE id = 788
195 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = 787
196 0.0006 0.00061416625976562
SELECT * FROM products WHERE id = 808
197 0.0005 0.00051403045654297
SELECT * FROM products WHERE id = 810
198 0.0007 0.00066399574279785
SELECT * FROM products WHERE id = 4947
199 0.0007 0.00066804885864258
SELECT * FROM products WHERE id = '790'
200 0.0005 0.00052189826965332
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
201 0.0002 0.00022292137145996
SELECT * FROM product_image_select WHERE product_id = '790'
202 0.0002 0.00020980834960938
SELECT * FROM productcustomimages WHERE product_id = '790'
203 0.0004 0.00040602684020996
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
204 0.0003 0.00027799606323242
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
205 0.0005 0.00049877166748047
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
206 0.0003 0.00034499168395996
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0005 0.00045585632324219
SELECT * FROM products WHERE id = '788'
208 0.0002 0.00023794174194336
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
209 0.0003 0.00025200843811035
SELECT * FROM product_image_select WHERE product_id = '788'
210 0.0003 0.00028705596923828
SELECT * FROM productcustomimages WHERE product_id = '788'
211 0.0003 0.00025010108947754
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
212 0.0003 0.00025296211242676
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0002 0.00020694732666016
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0002 0.00022292137145996
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0004 0.0004429817199707
SELECT * FROM products WHERE id = '787'
216 0.0003 0.00034999847412109
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
217 0.0002 0.00019598007202148
SELECT * FROM product_image_select WHERE product_id = '787'
218 0.0002 0.00022196769714355
SELECT * FROM productcustomimages WHERE product_id = '787'
219 0.0002 0.00020599365234375
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
220 0.0002 0.00023412704467773
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0002 0.0002291202545166
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0002 0.00019407272338867
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0005 0.00046801567077637
SELECT * FROM products WHERE id = '808'
224 0.0002 0.00019407272338867
SELECT * FROM productimages WHERE product_id = '808' ORDER BY sortorder ASC
225 0.0003 0.00031399726867676
SELECT * FROM product_image_select WHERE product_id = '808'
226 0.0003 0.00029802322387695
SELECT * FROM productcustomimages WHERE product_id = '808'
227 0.0002 0.00022101402282715
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '808' AND a.name = n.originalname
228 0.0002 0.00020694732666016
SELECT * FROM productoffers WHERE product_id = '808' AND merchantid = 'A1X6FK5RDHNB96'
229 0.0003 0.0003199577331543
SELECT * FROM productoffers
                WHERE product_id = '808' AND price > 0
                ORDER BY price ASC LIMIT 1
230 0.0002 0.00021004676818848
SELECT value FROM productattributes WHERE product_id = '808' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231 0.0004 0.00038814544677734
SELECT * FROM products WHERE id = '810'
232 0.0003 0.00032401084899902
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
233 0.0002 0.00019192695617676
SELECT * FROM product_image_select WHERE product_id = '810'
234 0.0002 0.00020003318786621
SELECT * FROM productcustomimages WHERE product_id = '810'
235 0.0002 0.00021195411682129
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
236 0.0004 0.00040698051452637
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
237 0.0005 0.00045609474182129
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
238 0.0002 0.00022602081298828
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239 0.0005 0.00048398971557617
SELECT * FROM products WHERE id = '4947'
240 0.0003 0.0003361701965332
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
241 0.0002 0.00022196769714355
SELECT * FROM product_image_select WHERE product_id = '4947'
242 0.0002 0.00024795532226562
SELECT * FROM productcustomimages WHERE product_id = '4947'
243 0.0005 0.00045299530029297
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
244 0.0002 0.00022697448730469
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
245 0.0004 0.00035691261291504
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
246 0.0002 0.00019693374633789
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247 0.0003 0.00026798248291016
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
248 0.0003 0.0003361701965332
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
249 0.0007 0.0007479190826416
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
250 0.0004 0.00042915344238281
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
251 0.0004 0.00041604042053223
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
252 0.0004 0.00036406517028809
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
253 0.0005 0.00046014785766602
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
254 0.0004 0.00035905838012695
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'