Boîte à café/thé/café arabica – Style Vintage Noir Rectangulaire Kitchen Boîte de rangement/boîte à – Hermétique

Price: Click Button for Price

As of 2022-06-25 23:37:30 UTC (more info)

Product prices and availability are accurate as of 2022-06-25 23:37:30 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.

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

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

Boîte hermétique/boîte/boîte de la gamme noir café arabica. Décorées dans un noir avec détails Or et Argent. Produit de qualité idéal pour le thé, le café, les sachets de thé, les biscuits et autres aliments ou comme boîte cadeau. L'image sur la boîte représenter un pot à café moulin à café et cuillère à café avec différents types de café écritures dans la conception en argent. Attention?: café non inclus. Dimensions?: 19,5 x 15 x 8 cm. Boîte métallique se fondant aussi bien dans la cuisine, rétro, traditionnel que dans une cuisine moderne.

Customer Reviews

There are no customer reviews yet. Be the first to Write a Review!

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.6953549385071	301	1.1660	0

No Amazon API Requests Made.

App Debug - Total Time 1.6953549385071 seconds

Number	Time From Start	Name	Description
1	0.45970892906189	Initialise	Initialise FSB Function
2	0.47625803947449	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.51089191436768	Start of getCategoryListByGroup Function	Before first category groups query
4	0.51270604133606	After initial query	Before first category groups query
5	0.51270699501038	Get Category List for Group	Before the call to getCategoryList function
6	0.51270890235901	Start of GetCategoryList function	Start of the function
7	0.51270985603333	Before getting categories	Query to get specific category list
8	0.51460790634155	After getting categories	Query to get specific category list
9	0.51460886001587	Before getting category custom	Before call to function getCategoryCustom
10	0.54105186462402	After getting category custom	After call to function getCategoryCustom
11	0.54105496406555	Before getting category custom	Before call to function getCategoryCustom
12	0.55349493026733	After getting category custom	After call to function getCategoryCustom
13	0.55349802970886	Before getting category custom	Before call to function getCategoryCustom
14	0.56090402603149	After getting category custom	After call to function getCategoryCustom
15	0.56090688705444	Before getting category custom	Before call to function getCategoryCustom
16	0.56657695770264	After getting category custom	After call to function getCategoryCustom
17	0.56657886505127	Before getting category custom	Before call to function getCategoryCustom
18	0.57231402397156	After getting category custom	After call to function getCategoryCustom
19	0.57231688499451	Before getting category custom	Before call to function getCategoryCustom
20	0.57846188545227	After getting category custom	After call to function getCategoryCustom
21	0.5784649848938	End of GetCategoryList function	End of the function
22	0.57846999168396	Get Category List for Group	Before the call to getCategoryList function
23	0.57847094535828	Start of GetCategoryList function	Start of the function
24	0.57847189903259	Before getting categories	Query to get specific category list
25	0.57903790473938	End of getCategoryListByGroup Function	Before return()
26	1.3715269565582	App Controller End	End of the App controller (called before the controller of every page)
27	1.3720309734344	Product Start	Start of the product info controller
28	1.37415599823	Cache file not found	Starting get product details
29	1.4286160469055	Related products	Start getting related products if enabled
30	1.4286170005798	Related Products Start	Before the related products are found
31	1.4286179542542	Related Products Keywords	Before the related product keywords are found
32	1.4286210536957	Create Keyword List Function	Start of function
33	1.4286930561066	Create Keyword List Function	After looping provided content - 32 keywords found
34	1.4292900562286	Create Keyword List Function	After looping initial keyword list - 30 keywords remaining
35	1.4292938709259	Create Keyword List Function	After reducing keyword list
36	1.4293599128723	Create Keyword List Function	After selecting by scoring keywords
37	1.4293630123138	Create Keyword List Function	After final loop of keywords
38	1.4293639659882	Related Products Keywords	After the related product keywords are found
39	1.5192110538483	Related Products End	After the related products are found
40	1.5598478317261	Product End	End of the product info controller (Product Info)
41	1.5621469020844	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.5638349056244	Before Get Options	Before the call to getOptions in the tpl class
43	1.6278598308563	After Get Options	After the call to getOptions in the tpl class
44	1.6279690265656	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.6279909610748	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.6501998901367	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.6502039432526	Product Info: Before Template Display	Before the template is displayed
48	1.6953229904175	Product Info: After Template Display	After the template is displayed
49	1.6953389644623	Finalizing debug	Before the debug is output to the page.
50	1.6953539848328	End of App	This is the end of the app logging, final timestamp

Query Debug - 301 Database Queries. Total time 1.1660 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.217.230.80\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746808228'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-05-09 16:30:28' WHERE id = '8'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote' LIMIT 1
SELECT id FROM products WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote' AND hidden = 0 LIMIT 1
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
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
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
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
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.217.230.80') >= INET_ATON(ip_start) AND INET_ATON('18.217.230.80') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 826
SELECT * FROM manufacturers WHERE id = '213'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '213'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '213' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '213' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '1584' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '213'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '213'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '213'
SELECT category_id FROM products_categories WHERE product_id = '826'
SELECT * FROM categories WHERE id = '26'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM productimages WHERE product_id = '826' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '826'
SELECT * FROM productcustomimages WHERE product_id = '826'
SELECT * FROM productfeeds WHERE product_id = '826' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '826' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '826'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '826' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 826
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '826'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
SELECT *, MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AND 826 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AND 826 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AND 826 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '3747' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3747'
SELECT * FROM productcustomimages WHERE product_id = '3747'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3747' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3747' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3747' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3747' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2960' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2960'
SELECT * FROM productcustomimages WHERE product_id = '2960'
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 = '2960'
                GROUP BY o.product_id
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     = '2960'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2960
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2960' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2960
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2960'
                AND name = 'ListPriceAmount'
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 = '2960'
                GROUP BY o.product_id
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     = '2960'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2960
SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2960'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1290'
SELECT * FROM productcustomimages WHERE product_id = '1290'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1290' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
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
SELECT * FROM product_image_select WHERE product_id = '1915'
SELECT * FROM productcustomimages WHERE product_id = '1915'
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
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
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
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1915' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1915
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1915'
                AND name = 'ListPriceAmount'
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
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
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
SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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
SELECT * FROM products WHERE parent_id = '1915'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4901' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4901' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4901' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '829' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '829' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '829'
SELECT * FROM productcustomimages WHERE product_id = '829'
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 = '829'
                GROUP BY o.product_id
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     = '829'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 829
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '829' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '829' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '829' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 829
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '829'
                AND name = 'ListPriceAmount'
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 = '829'
                GROUP BY o.product_id
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     = '829'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 829
SELECT value FROM productattributes WHERE product_id = '829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '829'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Style'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM productimages WHERE product_id = '2612' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2612' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2612'
SELECT * FROM productcustomimages WHERE product_id = '2612'
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 = '2612'
                GROUP BY o.product_id
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     = '2612'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2612
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2612' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2612' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2612' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2612
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2612'
                AND name = 'ListPriceAmount'
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 = '2612'
                GROUP BY o.product_id
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     = '2612'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2612
SELECT value FROM productattributes WHERE product_id = '2612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2612'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT id,asin FROM products WHERE parent_id = 826
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '826' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '826'
SELECT * FROM categories WHERE id = '26'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '826' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 826
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '826'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '826'
SELECT value FROM productattributes WHERE product_id = '826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '826' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 826
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '826'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '826' AND prod_type = 'amz'
SELECT parent_id FROM categories WHERE id = '26'
SELECT * FROM categories WHERE id = '26'
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
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
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 
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 
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
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
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
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
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
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0019	0.0019419193267822	SELECT parameter, value FROM parameters
2	0.0048	0.0048370361328125	SELECT * FROM `bad_bots`
3	0.0004	0.00041007995605469	SET time_zone = 'Europe/London'
4	0.0020	0.0019750595092773	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0019	0.0018539428710938	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.217.230.80\";}'
6	0.0017	0.0016779899597168	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746808228'
7	0.0024	0.0024161338806152	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0005	0.00045990943908691	UPDATE autorun SET lastrun = '2025-05-09 16:30:28' WHERE id = '8'
9	0.0006	0.00056290626525879	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0024	0.0024259090423584	SELECT id FROM pages WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote' LIMIT 1
11	0.0028	0.0028440952301025	SELECT id FROM products WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote' AND hidden = 0 LIMIT 1
12	0.0034	0.0034289360046387	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0300	0.029973030090332	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0008	0.00077080726623535	SELECT * FROM pages WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote'
15	0.0018	0.0018060207366943	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0019	0.0018808841705322	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0070	0.0069630146026611	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
18	0.0020	0.0019791126251221	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19	0.0016	0.0016341209411621	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0005	0.00048398971557617	SELECT id FROM categories WHERE parent_id = '26'
21	0.0070	0.0070288181304932	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
22	0.0026	0.0026061534881592	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
23	0.0026	0.0026199817657471	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
24	0.0023	0.0023379325866699	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0007	0.00068306922912598	SELECT * FROM categorygroups WHERE id = '1'
26	0.0043	0.0042572021484375	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
27	0.0008	0.00084781646728516	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0004	0.00042605400085449	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0005	0.00046896934509277	SELECT id FROM categories WHERE parent_id = '27'
30	0.0041	0.004119873046875	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
31	0.0006	0.00055503845214844	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
32	0.0007	0.00066399574279785	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
33	0.0005	0.00049400329589844	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0005	0.00052499771118164	SELECT * FROM categorygroups WHERE id = '1'
35	0.0017	0.001676082611084	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
36	0.0006	0.00057387351989746	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0005	0.00053501129150391	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.00053691864013672	SELECT id FROM categories WHERE parent_id = '28'
39	0.0019	0.0018730163574219	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
40	0.0006	0.00060415267944336	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
41	0.0006	0.00055384635925293	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
42	0.0005	0.00049495697021484	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0005	0.00049686431884766	SELECT * FROM categorygroups WHERE id = '1'
44	0.0007	0.00066304206848145	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
45	0.0005	0.00054597854614258	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0004	0.0004270076751709	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0004	0.00043797492980957	SELECT id FROM categories WHERE parent_id = '29'
48	0.0009	0.00088286399841309	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
49	0.0008	0.00079703330993652	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
50	0.0007	0.00069403648376465	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
51	0.0006	0.00062394142150879	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0005	0.00054097175598145	SELECT * FROM categorygroups WHERE id = '1'
53	0.0007	0.0007469654083252	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
54	0.0005	0.00053000450134277	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55	0.0005	0.00045108795166016	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00051593780517578	SELECT id FROM categories WHERE parent_id = '30'
57	0.0009	0.00085091590881348	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
58	0.0006	0.00060415267944336	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
59	0.0009	0.00085210800170898	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
60	0.0006	0.0005950927734375	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0005	0.00050902366638184	SELECT * FROM categorygroups WHERE id = '1'
62	0.0008	0.00084686279296875	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
63	0.0008	0.00078296661376953	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64	0.0006	0.00061988830566406	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.00052285194396973	SELECT id FROM categories WHERE parent_id = '31'
66	0.0009	0.00091314315795898	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
67	0.0005	0.00052499771118164	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
68	0.0008	0.000762939453125	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
69	0.0006	0.00058603286743164	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0005	0.00049996376037598	SELECT * FROM categorygroups WHERE id = '1'
71	0.0006	0.00055694580078125	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0035	0.0035219192504883	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0017	0.0017199516296387	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0008	0.00076818466186523	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
75	0.0017	0.0016820430755615	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0015	0.001453161239624	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0012	0.0011630058288574	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.7752	0.77521586418152	SELECT * FROM ipgeocountries WHERE INET_ATON('18.217.230.80') >= INET_ATON(ip_start) AND INET_ATON('18.217.230.80') <= INET_ATON(ip_end)
79	0.0037	0.0037229061126709	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0016	0.0016140937805176	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0009	0.00094389915466309	SELECT * FROM products WHERE pagename = 'bote-cafethecafe-arabicastyle-vintage-noir-rectangulaire-kitchen-bote'
82	0.0005	0.00045013427734375	UPDATE products SET viewcount = viewcount + 1 WHERE id = 826
83	0.0006	0.0005500316619873	SELECT * FROM manufacturers WHERE id = '213'
84	0.0008	0.00082802772521973	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '213'
85	0.0015	0.0014698505401611	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '213' LIMIT 1
86	0.0020	0.0019829273223877	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '213' ORDER BY RAND() LIMIT 1
87	0.0004	0.0004429817199707	SELECT * FROM productimages WHERE product_id = '1584' ORDER BY sortorder ASC
88	0.0006	0.00056219100952148	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '213'
89	0.0005	0.00051999092102051	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '213' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
90	0.0005	0.00048518180847168	SELECT * FROM manufacturerimages WHERE manufacturer_id = '213'
91	0.0013	0.0012881755828857	SELECT category_id FROM products_categories WHERE product_id = '826'
92	0.0011	0.0010688304901123	SELECT * FROM categories WHERE id = '26'
93	0.0148	0.014753103256226	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
94	0.0010	0.0010480880737305	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95	0.0007	0.00068092346191406	SELECT id FROM categories WHERE parent_id = '26'
96	0.0087	0.0087049007415771	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
97	0.0009	0.0008540153503418	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
98	0.0009	0.00086188316345215	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
99	0.0006	0.00064802169799805	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100	0.0006	0.00064587593078613	SELECT * FROM productimages WHERE product_id = '826' ORDER BY sortorder ASC
101	0.0023	0.0022969245910645	SELECT * FROM product_image_select WHERE product_id = '826'
102	0.0014	0.0013549327850342	SELECT * FROM productcustomimages WHERE product_id = '826'
103	0.0013	0.0013229846954346	SELECT * FROM productfeeds WHERE product_id = '826' ORDER BY item_date DESC
104	0.0026	0.0026199817657471	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105	0.0025	0.0025100708007812	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '826' AND t.hidden = 0 AND display_product = 1
106	0.0016	0.0016047954559326	SELECT * FROM productamazoncontent WHERE product_id = '826'
107	0.0010	0.00098800659179688	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
108	0.0017	0.0016751289367676	SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'A1X6FK5RDHNB96'
109	0.0005	0.00049209594726562	SELECT * FROM productoffers WHERE product_id = '826' AND price > 0 ORDER BY price ASC LIMIT 1
110	0.0003	0.00033903121948242	SELECT * FROM productoffers WHERE product_id = 826 ORDER BY price ASC LIMIT 1
111	0.0005	0.0005490779876709	SELECT value FROM productattributes WHERE product_id = '826' AND name = 'ListPriceAmount'
112	0.0004	0.00040388107299805	SELECT value FROM productattributes WHERE product_id = '826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113	0.0005	0.00054788589477539	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
114	0.0090	0.0090429782867432	SELECT *, MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AND 826 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115	0.0007	0.00067782402038574	SELECT *, MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AND 826 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
116	0.0006	0.00058388710021973	SELECT *, MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('de rangementbo�te �hermétique' IN BOOLEAN MODE) AND 826 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
117	0.0006	0.00061392784118652	SELECT * FROM productimages WHERE product_id = '3747' ORDER BY sortorder ASC
118	0.0007	0.00070095062255859	SELECT * FROM product_image_select WHERE product_id = '3747'
119	0.0004	0.00041604042053223	SELECT * FROM productcustomimages WHERE product_id = '3747'
120	0.0009	0.00086808204650879	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3747' AND a.name = n.originalname
121	0.0005	0.00053596496582031	SELECT * FROM productoffers WHERE product_id = '3747' AND merchantid = 'A1X6FK5RDHNB96'
122	0.0005	0.00048685073852539	SELECT * FROM productoffers WHERE product_id = '3747' AND price > 0 ORDER BY price ASC LIMIT 1
123	0.0005	0.00054693222045898	SELECT value FROM productattributes WHERE product_id = '3747' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124	0.0006	0.00055217742919922	SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
125	0.0011	0.0010769367218018	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2960' AND p.id = pi.product_id ORDER BY pi.sortorder
126	0.0007	0.00072813034057617	SELECT * FROM product_image_select WHERE product_id = '2960'
127	0.0005	0.00047492980957031	SELECT * FROM productcustomimages WHERE product_id = '2960'
128	0.0005	0.00052595138549805	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 = '2960' GROUP BY o.product_id
129	0.0027	0.0027320384979248	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 = '2960' GROUP BY n.displayname ORDER BY n.displayname DESC
130	0.0006	0.00063991546630859	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2960
131	0.0038	0.0037951469421387	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
132	0.0008	0.00083398818969727	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0007	0.00071883201599121	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0006	0.00063300132751465	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
135	0.0008	0.00080990791320801	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
136	0.0009	0.00092697143554688	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 = '2960' GROUP BY o.product_id
137	0.0016	0.0015580654144287	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 = '2960' GROUP BY n.displayname ORDER BY n.displayname DESC
138	0.0010	0.00099921226501465	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2960
139	0.0013	0.0012891292572021	SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140	0.0014	0.0013599395751953	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2960' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
141	0.0013	0.0012619495391846	SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
142	0.0011	0.0010972023010254	SELECT * FROM product_image_select WHERE product_id = '1290'
143	0.0007	0.00071096420288086	SELECT * FROM productcustomimages WHERE product_id = '1290'
144	0.0024	0.0024428367614746	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
145	0.0008	0.00076198577880859	SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
146	0.0006	0.00063586235046387	SELECT * FROM productoffers WHERE product_id = '1290' AND price > 0 ORDER BY price ASC LIMIT 1
147	0.0007	0.00069785118103027	SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148	0.0009	0.00092601776123047	SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
149	0.0009	0.0009300708770752	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
150	0.0008	0.00083398818969727	SELECT * FROM product_image_select WHERE product_id = '1915'
151	0.0005	0.00053191184997559	SELECT * FROM productcustomimages WHERE product_id = '1915'
152	0.0008	0.00082111358642578	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
153	0.0010	0.0009770393371582	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
154	0.0006	0.00055313110351562	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
155	0.0012	0.0011701583862305	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
156	0.0005	0.00050902366638184	SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
157	0.0006	0.0005640983581543	SELECT * FROM productoffers WHERE product_id = '1915' AND price > 0 ORDER BY price ASC LIMIT 1
158	0.0004	0.00044894218444824	SELECT * FROM productoffers WHERE product_id = 1915 ORDER BY price ASC LIMIT 1
159	0.0005	0.00054001808166504	SELECT value FROM productattributes WHERE product_id = '1915' AND name = 'ListPriceAmount'
160	0.0007	0.0007169246673584	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
161	0.0009	0.00089001655578613	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
162	0.0006	0.00055789947509766	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
163	0.0007	0.00072717666625977	SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164	0.0007	0.00072002410888672	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
165	0.0005	0.00053095817565918	SELECT * FROM products WHERE parent_id = '1915'
166	0.0007	0.00068521499633789	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4901' AND a.name = n.originalname
167	0.0008	0.00075793266296387	SELECT * FROM productoffers WHERE product_id = '4901' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0006	0.00055193901062012	SELECT * FROM productoffers WHERE product_id = '4901' AND price > 0 ORDER BY price ASC LIMIT 1
169	0.0006	0.00064492225646973	SELECT * FROM productimages WHERE product_id = '829' ORDER BY sortorder ASC
170	0.0007	0.00068497657775879	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '829' AND p.id = pi.product_id ORDER BY pi.sortorder
171	0.0009	0.00088191032409668	SELECT * FROM product_image_select WHERE product_id = '829'
172	0.0006	0.00055098533630371	SELECT * FROM productcustomimages WHERE product_id = '829'
173	0.0018	0.0018148422241211	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 = '829' GROUP BY o.product_id
174	0.0019	0.0018877983093262	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 = '829' GROUP BY n.displayname ORDER BY n.displayname DESC
175	0.0009	0.00091314315795898	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 829
176	0.0023	0.00229811668396	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '829' AND a.name = n.originalname
177	0.0007	0.00073099136352539	SELECT * FROM productoffers WHERE product_id = '829' AND merchantid = 'A1X6FK5RDHNB96'
178	0.0008	0.00076198577880859	SELECT * FROM productoffers WHERE product_id = '829' AND price > 0 ORDER BY price ASC LIMIT 1
179	0.0007	0.00066494941711426	SELECT * FROM productoffers WHERE product_id = 829 ORDER BY price ASC LIMIT 1
180	0.0008	0.00077199935913086	SELECT value FROM productattributes WHERE product_id = '829' AND name = 'ListPriceAmount'
181	0.0009	0.00090599060058594	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 = '829' GROUP BY o.product_id
182	0.0016	0.0016200542449951	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 = '829' GROUP BY n.displayname ORDER BY n.displayname DESC
183	0.0009	0.00086021423339844	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 829
184	0.0011	0.0011141300201416	SELECT value FROM productattributes WHERE product_id = '829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185	0.0012	0.0011510848999023	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '829' AND p.id = o.product_id AND o.name = 'Style' GROUP BY o.value ORDER BY o.value ASC
186	0.0010	0.00096893310546875	SELECT * FROM productimages WHERE product_id = '2612' ORDER BY sortorder ASC
187	0.0008	0.00081205368041992	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2612' AND p.id = pi.product_id ORDER BY pi.sortorder
188	0.0012	0.0012450218200684	SELECT * FROM product_image_select WHERE product_id = '2612'
189	0.0007	0.00070500373840332	SELECT * FROM productcustomimages WHERE product_id = '2612'
190	0.0011	0.0010778903961182	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 = '2612' GROUP BY o.product_id
191	0.0011	0.0011498928070068	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 = '2612' GROUP BY n.displayname ORDER BY n.displayname DESC
192	0.0007	0.00073003768920898	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2612
193	0.0016	0.0015730857849121	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2612' AND a.name = n.originalname
194	0.0005	0.0004580020904541	SELECT * FROM productoffers WHERE product_id = '2612' AND merchantid = 'A1X6FK5RDHNB96'
195	0.0005	0.0005040168762207	SELECT * FROM productoffers WHERE product_id = '2612' AND price > 0 ORDER BY price ASC LIMIT 1
196	0.0004	0.00042390823364258	SELECT * FROM productoffers WHERE product_id = 2612 ORDER BY price ASC LIMIT 1
197	0.0005	0.00048398971557617	SELECT value FROM productattributes WHERE product_id = '2612' AND name = 'ListPriceAmount'
198	0.0006	0.00056695938110352	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 = '2612' GROUP BY o.product_id
199	0.0010	0.0010030269622803	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 = '2612' GROUP BY n.displayname ORDER BY n.displayname DESC
200	0.0006	0.0005948543548584	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2612
201	0.0008	0.00081491470336914	SELECT value FROM productattributes WHERE product_id = '2612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202	0.0008	0.00084304809570312	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2612' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
203	0.0005	0.00046896934509277	SELECT id,asin FROM products WHERE parent_id = 826
204	0.0026	0.0026330947875977	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '826' ORDER BY timestamp DESC
205	0.0007	0.00070095062255859	SELECT category_id FROM products_categories WHERE product_id = '826'
206	0.0007	0.00071191787719727	SELECT * FROM categories WHERE id = '26'
207	0.0065	0.0064618587493896	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
208	0.0006	0.00059795379638672	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
209	0.0004	0.00040698051452637	SELECT id FROM categories WHERE parent_id = '26'
210	0.0061	0.0061259269714355	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
211	0.0006	0.00056004524230957	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
212	0.0006	0.0006260871887207	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
213	0.0005	0.00046300888061523	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
214	0.0011	0.0010678768157959	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
215	0.0007	0.00068306922912598	SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'A1X6FK5RDHNB96'
216	0.0004	0.0004119873046875	SELECT * FROM productoffers WHERE product_id = '826' AND price > 0 ORDER BY price ASC LIMIT 1
217	0.0004	0.00035500526428223	SELECT * FROM productoffers WHERE product_id = 826 ORDER BY price ASC LIMIT 1
218	0.0004	0.00038790702819824	SELECT value FROM productattributes WHERE product_id = '826' AND name = 'ListPriceAmount'
219	0.0006	0.00062108039855957	SELECT * FROM products WHERE id = '826'
220	0.0004	0.00042510032653809	SELECT value FROM productattributes WHERE product_id = '826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221	0.0008	0.00080299377441406	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '826' AND a.name = n.originalname
222	0.0004	0.0003509521484375	SELECT * FROM productoffers WHERE product_id = '826' AND merchantid = 'A1X6FK5RDHNB96'
223	0.0004	0.00037908554077148	SELECT * FROM productoffers WHERE product_id = '826' AND price > 0 ORDER BY price ASC LIMIT 1
224	0.0004	0.00039505958557129	SELECT * FROM productoffers WHERE product_id = 826 ORDER BY price ASC LIMIT 1
225	0.0004	0.00036191940307617	SELECT value FROM productattributes WHERE product_id = '826' AND name = 'ListPriceAmount'
226	0.0004	0.00044894218444824	SELECT category_id FROM products_categories WHERE product_id = '826' AND prod_type = 'amz'
227	0.0004	0.00043606758117676	SELECT parent_id FROM categories WHERE id = '26'
228	0.0004	0.00036001205444336	SELECT * FROM categories WHERE id = '26'
229	0.0054	0.0054008960723877	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
230	0.0005	0.00050187110900879	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
231	0.0004	0.00040292739868164	SELECT id FROM categories WHERE parent_id = '26'
232	0.0054	0.0053548812866211	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
233	0.0005	0.0005490779876709	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
234	0.0006	0.00056695938110352	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
235	0.0004	0.00044798851013184	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
236	0.0018	0.0018260478973389	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
237	0.0013	0.0012881755828857	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
238	0.0004	0.00035619735717773	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
239	0.0133	0.013342142105103	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
240	0.0020	0.002007007598877	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
241	0.0006	0.00059294700622559	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
242	0.0005	0.0005338191986084	SELECT * FROM products WHERE id = 1626
243	0.0005	0.00045895576477051	SELECT * FROM products WHERE id = 4041
244	0.0005	0.00049996376037598	SELECT * FROM products WHERE id = 4312
245	0.0004	0.00037980079650879	SELECT * FROM products WHERE id = 777
246	0.0005	0.00046205520629883	SELECT * FROM products WHERE id = 3881
247	0.0005	0.0004570484161377	SELECT * FROM products WHERE id = 4213
248	0.0004	0.00043010711669922	SELECT * FROM products WHERE id = '1626'
249	0.0005	0.000518798828125	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
250	0.0006	0.00060606002807617	SELECT * FROM product_image_select WHERE product_id = '1626'
251	0.0004	0.00040221214294434	SELECT * FROM productcustomimages WHERE product_id = '1626'
252	0.0009	0.00093698501586914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
253	0.0005	0.00049614906311035	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
254	0.0004	0.00044989585876465	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
255	0.0005	0.00050020217895508	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256	0.0006	0.0005638599395752	SELECT * FROM products WHERE id = '4041'
257	0.0005	0.00046396255493164	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
258	0.0007	0.00065207481384277	SELECT * FROM product_image_select WHERE product_id = '4041'
259	0.0004	0.00038909912109375	SELECT * FROM productcustomimages WHERE product_id = '4041'
260	0.0011	0.0010688304901123	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
261	0.0005	0.00045299530029297	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
262	0.0004	0.00041699409484863	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
263	0.0004	0.00043511390686035	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264	0.0006	0.00064396858215332	SELECT * FROM products WHERE id = '4312'
265	0.0005	0.00046586990356445	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
266	0.0006	0.0006260871887207	SELECT * FROM product_image_select WHERE product_id = '4312'
267	0.0004	0.00041890144348145	SELECT * FROM productcustomimages WHERE product_id = '4312'
268	0.0010	0.0010190010070801	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
269	0.0005	0.0004889965057373	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
270	0.0004	0.00043892860412598	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
271	0.0004	0.00043201446533203	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272	0.0007	0.0007178783416748	SELECT * FROM products WHERE id = '777'
273	0.0005	0.0004580020904541	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
274	0.0006	0.00063586235046387	SELECT * FROM product_image_select WHERE product_id = '777'
275	0.0004	0.0003969669342041	SELECT * FROM productcustomimages WHERE product_id = '777'
276	0.0011	0.0011270046234131	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
277	0.0005	0.00053095817565918	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
278	0.0005	0.00046181678771973	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
279	0.0004	0.00044894218444824	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280	0.0006	0.00062799453735352	SELECT * FROM products WHERE id = '3881'
281	0.0005	0.0004889965057373	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
282	0.0006	0.00058698654174805	SELECT * FROM product_image_select WHERE product_id = '3881'
283	0.0036	0.0036220550537109	SELECT * FROM productcustomimages WHERE product_id = '3881'
284	0.0014	0.0014100074768066	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
285	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
286	0.0004	0.00041508674621582	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
287	0.0005	0.00048017501831055	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288	0.0005	0.00054407119750977	SELECT * FROM products WHERE id = '4213'
289	0.0006	0.00058388710021973	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
290	0.0006	0.00059604644775391	SELECT * FROM product_image_select WHERE product_id = '4213'
291	0.0004	0.00042891502380371	SELECT * FROM productcustomimages WHERE product_id = '4213'
292	0.0012	0.0011799335479736	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
293	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
294	0.0004	0.00043916702270508	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
295	0.0004	0.0004429817199707	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296	0.0022	0.0022139549255371	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
297	0.0008	0.00079202651977539	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
298	0.0029	0.0029370784759521	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
299	0.0019	0.0018930435180664	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
300	0.0049	0.0048689842224121	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
301	0.0013	0.0012650489807129	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Boîte à café/thé/café arabica – Style Vintage Noir Rectangulaire Kitchen Boîte de rangement/boîte à – Hermétique

Product Features

Shayson Boîte à café hermétique,Coffee V...

Boîte à Café Hermétique, ASHATA Boîtes e...

Relaxdays Boîte à café bambou boîte à th...

Pot de café en acier inoxydable 21 onces...

Master Class en grès et effet laiton Boî...

japonais Boîte à thé en étain Suzuko/dou...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6953549385071 seconds

Query Debug - 301 Database Queries. Total time 1.1660 seconds

Boîte à café/thé/café arabica – Style Vintage Noir Rectangulaire Kitchen Boîte de rangement/boîte à – Hermétique

Product Features

Related Products

Shayson Boîte à café hermétique,Coffee V...

Boîte à Café Hermétique, ASHATA Boîtes e...

Relaxdays Boîte à café bambou boîte à th...

Pot de café en acier inoxydable 21 onces...

Master Class en grès et effet laiton Boî...

japonais Boîte à thé en étain Suzuko/dou...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6953549385071 seconds

Query Debug - 301 Database Queries. Total time 1.1660 seconds