Boîte à Café Hermétique, ASHATA Boîtes et Coffrets à thé et Café Alimentaire en Acier Inoxydable Coffee Vault Hermétique de Conservation pour Café/Haricots / Sucre/Thé

Price: €24,09

As of 2022-06-25 17:12:51 UTC (more info)

Product prices and availability are accurate as of 2022-06-25 17:12:51 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.

Availability: In Stock

Click and Choose Options

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

Fabriqué en acier inoxydable de haute qualité, résistant à la rouille, robuste et durable. Toutes les finitions sont non toxiques, sûres et écologiques. Conteneur de nourriture scellé parfait pour garder les haricots, le sucre et les noix frais pendant longtemps. Conception de grande capacité, peut contenir plus de grains de café, de thé ou de sucre, etc. La bague d'étanchéité en silice aide à garder les aliments dans le récipient à l'abri de l'air et de l'eau. Un couvercle transparent aide à voir les aliments dans le récipient facilement.

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.5697181224823	401	1.0274	0

No Amazon API Requests Made.

App Debug - Total Time 1.5697181224823 seconds

Number	Time From Start	Name	Description
1	0.44521498680115	Initialise	Initialise FSB Function
2	0.45230317115784	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.48575520515442	Start of getCategoryListByGroup Function	Before first category groups query
4	0.48726916313171	After initial query	Before first category groups query
5	0.48727107048035	Get Category List for Group	Before the call to getCategoryList function
6	0.48727512359619	Start of GetCategoryList function	Start of the function
7	0.48727917671204	Before getting categories	Query to get specific category list
8	0.48877215385437	After getting categories	Query to get specific category list
9	0.488774061203	Before getting category custom	Before call to function getCategoryCustom
10	0.5103440284729	After getting category custom	After call to function getCategoryCustom
11	0.51034903526306	Before getting category custom	Before call to function getCategoryCustom
12	0.52142310142517	After getting category custom	After call to function getCategoryCustom
13	0.52142810821533	Before getting category custom	Before call to function getCategoryCustom
14	0.52848410606384	After getting category custom	After call to function getCategoryCustom
15	0.528489112854	Before getting category custom	Before call to function getCategoryCustom
16	0.53352212905884	After getting category custom	After call to function getCategoryCustom
17	0.53352618217468	Before getting category custom	Before call to function getCategoryCustom
18	0.5396900177002	After getting category custom	After call to function getCategoryCustom
19	0.53969407081604	Before getting category custom	Before call to function getCategoryCustom
20	0.54483199119568	After getting category custom	After call to function getCategoryCustom
21	0.54483699798584	End of GetCategoryList function	End of the function
22	0.54485607147217	Get Category List for Group	Before the call to getCategoryList function
23	0.54486012458801	Start of GetCategoryList function	Start of the function
24	0.54486513137817	Before getting categories	Query to get specific category list
25	0.54546499252319	End of getCategoryListByGroup Function	Before return()
26	0.97435402870178	App Controller End	End of the App controller (called before the controller of every page)
27	0.97523522377014	Product Start	Start of the product info controller
28	0.99381399154663	Cache file not found	Starting get product details
29	1.0896601676941	Related products	Start getting related products if enabled
30	1.0896620750427	Related Products Start	Before the related products are found
31	1.0896642208099	Related Products Keywords	Before the related product keywords are found
32	1.0896711349487	Create Keyword List Function	Start of function
33	1.0898571014404	Create Keyword List Function	After looping provided content - 65 keywords found
34	1.0944230556488	Create Keyword List Function	After looping initial keyword list - 61 keywords remaining
35	1.0944440364838	Create Keyword List Function	After reducing keyword list
36	1.0952742099762	Create Keyword List Function	After selecting by scoring keywords
37	1.0952820777893	Create Keyword List Function	After final loop of keywords
38	1.0952870845795	Related Products Keywords	After the related product keywords are found
39	1.2950069904327	Related Products End	After the related products are found
40	1.3964672088623	Product End	End of the product info controller (Product Info)
41	1.3993420600891	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.4012281894684	Before Get Options	Before the call to getOptions in the tpl class
43	1.4934771060944	After Get Options	After the call to getOptions in the tpl class
44	1.4937160015106	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.4937620162964	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.5085401535034	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.5085461139679	Product Info: Before Template Display	Before the template is displayed
48	1.5696661472321	Product Info: After Template Display	After the template is displayed
49	1.5696921348572	Finalizing debug	Before the debug is output to the page.
50	1.5697162151337	End of App	This is the end of the app logging, final timestamp

Query Debug - 401 Database Queries. Total time 1.0274 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:11:\"3.144.26.47\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738778934'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-05 18:08:54' WHERE id = '17'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149' LIMIT 1
SELECT id FROM products WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149' 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-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149'
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('3.144.26.47') >= INET_ATON(ip_start) AND INET_ATON('3.144.26.47') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2960
SELECT * FROM manufacturers WHERE id = '461'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '461'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '461' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '461' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '2663' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '461'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '461'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '461'
SELECT category_id FROM products_categories WHERE product_id = '2960'
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 = '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 * FROM productfeeds WHERE product_id = '2960' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2960' 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 = '2960' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM tags WHERE id = '58'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent 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 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 ('bo�tes et coffrets' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AND 2960 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '3551' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3551' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3551'
SELECT * FROM productcustomimages WHERE product_id = '3551'
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 = '3551'
                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     = '3551'
                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 = 3551
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3551' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3551
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3551'
                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 = '3551'
                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     = '3551'
                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 = 3551
SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3551'
                  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 = '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 *, MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AND 2960 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 5
SELECT *, MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 5
SELECT *, MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 5
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 = '3551' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3551' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3551'
SELECT * FROM productcustomimages WHERE product_id = '3551'
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 = '3551'
                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     = '3551'
                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 = 3551
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3551' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3551
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3551'
                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 = '3551'
                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     = '3551'
                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 = 3551
SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3551'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT *, MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AND 2960 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 5
SELECT *, MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 5
SELECT *, MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 5
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 = '3821' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3821' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3821'
SELECT * FROM productcustomimages WHERE product_id = '3821'
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 = '3821'
                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     = '3821'
                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 = 3821
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3821' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3821' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3821' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3821
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3821'
                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 = '3821'
                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     = '3821'
                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 = 3821
SELECT value FROM productattributes WHERE product_id = '3821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3821'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
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 * 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 id,asin FROM products WHERE parent_id = 2960
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2961
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2961
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2962
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2962
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2963
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2963
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2964
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2964
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2960' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '2960'
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 = '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 * FROM products WHERE 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 value FROM productattributes WHERE product_id = '2960' 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 = '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 DISTINCT (name) FROM productoptions
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 2960))
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 2960
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
SELECT * FROM translationsfilter
SELECT category_id FROM products_categories WHERE product_id = '2960' 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.0026	0.002647876739502	SELECT parameter, value FROM parameters
2	0.0079	0.0078690052032471	SELECT * FROM `bad_bots`
3	0.0004	0.00041294097900391	SET time_zone = 'Europe/London'
4	0.0020	0.0019800662994385	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0032	0.0032429695129395	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.144.26.47\";}'
6	0.0030	0.0030181407928467	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738778934'
7	0.0029	0.0028538703918457	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0006	0.00059700012207031	UPDATE autorun SET lastrun = '2025-02-05 18:08:54' WHERE id = '17'
9	0.0007	0.00067400932312012	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0025	0.0025320053100586	SELECT id FROM pages WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149' LIMIT 1
11	0.0029	0.0028691291809082	SELECT id FROM products WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149' AND hidden = 0 LIMIT 1
12	0.0037	0.0037381649017334	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0282	0.028164148330688	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0007	0.00071215629577637	SELECT * FROM pages WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149'
15	0.0015	0.0014979839324951	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0015	0.0014700889587402	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	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
18	0.0024	0.0024340152740479	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.0012	0.0011889934539795	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0005	0.0005040168762207	SELECT id FROM categories WHERE parent_id = '26'
21	0.0057	0.0057017803192139	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.0016	0.0016241073608398	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.0015	0.0015249252319336	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.0013	0.0013461112976074	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0005	0.00048494338989258	SELECT * FROM categorygroups WHERE id = '1'
26	0.0037	0.0036780834197998	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.0005	0.0005028247833252	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.00039291381835938	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0004	0.00043606758117676	SELECT id FROM categories WHERE parent_id = '27'
30	0.0038	0.003817081451416	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.0005	0.00051212310791016	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.0006	0.00060510635375977	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.00047516822814941	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0005	0.00046491622924805	SELECT * FROM categorygroups WHERE id = '1'
35	0.0014	0.0014150142669678	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.0005	0.00048279762268066	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.0004	0.00043010711669922	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.00046992301940918	SELECT id FROM categories WHERE parent_id = '28'
39	0.0015	0.0015320777893066	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.0005	0.00052785873413086	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.00055193901062012	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.00048208236694336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0010	0.0010008811950684	SELECT * FROM categorygroups WHERE id = '1'
44	0.0007	0.00066995620727539	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.00050711631774902	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.0005	0.00046896934509277	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0005	0.00047397613525391	SELECT id FROM categories WHERE parent_id = '29'
48	0.0007	0.00071001052856445	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.0005	0.0005030632019043	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.0006	0.00058388710021973	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.0005	0.00047492980957031	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0005	0.00047397613525391	SELECT * FROM categorygroups WHERE id = '1'
53	0.0007	0.00073003768920898	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.0013	0.0013031959533691	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.0007	0.00073099136352539	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00045514106750488	SELECT id FROM categories WHERE parent_id = '30'
57	0.0007	0.00073099136352539	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.00058984756469727	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.0005	0.00053715705871582	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.0005	0.00049781799316406	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0004	0.00044798851013184	SELECT * FROM categorygroups WHERE id = '1'
62	0.0007	0.00069499015808105	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.0005	0.00045919418334961	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.0004	0.00043606758117676	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0004	0.0004420280456543	SELECT id FROM categories WHERE parent_id = '31'
66	0.0009	0.00085210800170898	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.0006	0.00055193901062012	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.0006	0.00057578086853027	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.0005	0.0005190372467041	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0004	0.00044584274291992	SELECT * FROM categorygroups WHERE id = '1'
71	0.0006	0.00058507919311523	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0031	0.0031030178070068	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0016	0.0015909671783447	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0006	0.00063514709472656	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.0013	0.0013217926025391	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0013	0.0013089179992676	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0013	0.0012638568878174	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.4131	0.41307902336121	SELECT * FROM ipgeocountries WHERE INET_ATON('3.144.26.47') >= INET_ATON(ip_start) AND INET_ATON('3.144.26.47') <= INET_ATON(ip_end)
79	0.0023	0.0022590160369873	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0015	0.0015370845794678	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0008	0.00080108642578125	SELECT * FROM products WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire-611519149'
82	0.0005	0.00047802925109863	UPDATE products SET viewcount = viewcount + 1 WHERE id = 2960
83	0.0008	0.00078678131103516	SELECT * FROM manufacturers WHERE id = '461'
84	0.0008	0.00075101852416992	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '461'
85	0.0028	0.0027990341186523	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '461' LIMIT 1
86	0.0028	0.0027890205383301	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '461' ORDER BY RAND() LIMIT 1
87	0.0007	0.000701904296875	SELECT * FROM productimages WHERE product_id = '2663' ORDER BY sortorder ASC
88	0.0008	0.00075197219848633	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '461'
89	0.0008	0.00079011917114258	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '461' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
90	0.0008	0.00077295303344727	SELECT * FROM manufacturerimages WHERE manufacturer_id = '461'
91	0.0007	0.00073719024658203	SELECT category_id FROM products_categories WHERE product_id = '2960'
92	0.0009	0.00087094306945801	SELECT * FROM categories WHERE id = '26'
93	0.0148	0.014808893203735	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.0011	0.0010650157928467	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95	0.0008	0.00076103210449219	SELECT id FROM categories WHERE parent_id = '26'
96	0.0117	0.011696100234985	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.0008	0.00080299377441406	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.00094699859619141	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.00064587593078613	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100	0.0008	0.00080490112304688	SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
101	0.0009	0.00092983245849609	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
102	0.0029	0.0028979778289795	SELECT * FROM product_image_select WHERE product_id = '2960'
103	0.0019	0.0018661022186279	SELECT * FROM productcustomimages WHERE product_id = '2960'
104	0.0015	0.0014569759368896	SELECT * FROM productfeeds WHERE product_id = '2960' ORDER BY item_date DESC
105	0.0027	0.0026559829711914	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106	0.0027	0.0026779174804688	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2960' AND t.hidden = 0 AND display_product = 1
107	0.0005	0.00045084953308105	SELECT * FROM tags WHERE id = '81'
108	0.0033	0.0033121109008789	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
109	0.0028	0.0028109550476074	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
110	0.0030	0.0029921531677246	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
111	0.0009	0.00087499618530273	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
112	0.0008	0.00078010559082031	SELECT * FROM tags WHERE id = '58'
113	0.0023	0.0023410320281982	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
114	0.0020	0.0019509792327881	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
115	0.0018	0.0018470287322998	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
116	0.0006	0.00062203407287598	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
117	0.0023	0.0022749900817871	SELECT * FROM productamazoncontent WHERE product_id = '2960'
118	0.0020	0.0020239353179932	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
119	0.0025	0.0024650096893311	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
120	0.0007	0.00067496299743652	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
121	0.0012	0.0012359619140625	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
122	0.0005	0.0004878044128418	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0010	0.00095605850219727	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0008	0.00075483322143555	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
125	0.0015	0.00148606300354	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
126	0.0012	0.0012331008911133	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
127	0.0017	0.0016860961914062	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
128	0.0008	0.00082516670227051	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
129	0.0013	0.0012779235839844	SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130	0.0016	0.0016288757324219	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
131	0.0011	0.0010750293731689	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
132	0.0233	0.023339986801147	SELECT *, MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AND 2960 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
133	0.0013	0.0012719631195068	SELECT *, MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
134	0.0009	0.00094318389892578	SELECT *, MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bo�tes et coffrets' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
135	0.0007	0.00072598457336426	SELECT * FROM productimages WHERE product_id = '3551' ORDER BY sortorder ASC
136	0.0008	0.00080990791320801	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3551' AND p.id = pi.product_id ORDER BY pi.sortorder
137	0.0009	0.00090408325195312	SELECT * FROM product_image_select WHERE product_id = '3551'
138	0.0007	0.00069308280944824	SELECT * FROM productcustomimages WHERE product_id = '3551'
139	0.0007	0.00072598457336426	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 = '3551' GROUP BY o.product_id
140	0.0009	0.0008699893951416	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 = '3551' GROUP BY n.displayname ORDER BY n.displayname DESC
141	0.0005	0.00054693222045898	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
142	0.0011	0.0010530948638916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
143	0.0007	0.00068902969360352	SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0006	0.0006101131439209	SELECT * FROM productoffers WHERE product_id = '3551' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0004	0.0004122257232666	SELECT * FROM productoffers WHERE product_id = 3551 ORDER BY price ASC LIMIT 1
146	0.0004	0.00044012069702148	SELECT value FROM productattributes WHERE product_id = '3551' AND name = 'ListPriceAmount'
147	0.0005	0.00052404403686523	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 = '3551' GROUP BY o.product_id
148	0.0007	0.00073790550231934	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 = '3551' GROUP BY n.displayname ORDER BY n.displayname DESC
149	0.0005	0.00046086311340332	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
150	0.0007	0.00072598457336426	SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0007	0.00072813034057617	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3551' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
152	0.0007	0.0007169246673584	SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
153	0.0008	0.00079512596130371	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
154	0.0007	0.00065493583679199	SELECT * FROM product_image_select WHERE product_id = '2960'
155	0.0005	0.00050210952758789	SELECT * FROM productcustomimages WHERE product_id = '2960'
156	0.0007	0.00070309638977051	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
157	0.0007	0.00070500373840332	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
158	0.0004	0.0004420280456543	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
159	0.0012	0.0012340545654297	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
160	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
161	0.0005	0.0004580020904541	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
162	0.0004	0.00039291381835938	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
163	0.0004	0.00040698051452637	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
164	0.0005	0.00054597854614258	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
165	0.0008	0.00075793266296387	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
166	0.0006	0.00058102607727051	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
167	0.0007	0.00073790550231934	SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168	0.0008	0.00080299377441406	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
169	0.0145	0.014472961425781	SELECT *, MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AND 2960 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 5
170	0.0014	0.0013580322265625	SELECT *, MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 5
171	0.0011	0.0010969638824463	SELECT *, MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('coffrets � thé' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 5
172	0.0008	0.00081086158752441	SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
173	0.0007	0.00074100494384766	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
174	0.0007	0.00072312355041504	SELECT * FROM product_image_select WHERE product_id = '2960'
175	0.0006	0.0006110668182373	SELECT * FROM productcustomimages WHERE product_id = '2960'
176	0.0007	0.00072908401489258	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
177	0.0008	0.00081896781921387	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
178	0.0005	0.00049209594726562	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
179	0.0014	0.0014169216156006	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
180	0.0005	0.00050997734069824	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
181	0.0004	0.00043797492980957	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
182	0.0004	0.0004417896270752	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
183	0.0004	0.00043892860412598	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
184	0.0005	0.00052094459533691	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
185	0.0009	0.00087118148803711	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
186	0.0005	0.00050497055053711	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
187	0.0007	0.00067806243896484	SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188	0.0008	0.00078701972961426	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
189	0.0006	0.0005791187286377	SELECT * FROM productimages WHERE product_id = '3551' ORDER BY sortorder ASC
190	0.0006	0.00063395500183105	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3551' AND p.id = pi.product_id ORDER BY pi.sortorder
191	0.0008	0.00079798698425293	SELECT * FROM product_image_select WHERE product_id = '3551'
192	0.0005	0.00050592422485352	SELECT * FROM productcustomimages WHERE product_id = '3551'
193	0.0007	0.00069618225097656	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 = '3551' GROUP BY o.product_id
194	0.0008	0.000762939453125	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 = '3551' GROUP BY n.displayname ORDER BY n.displayname DESC
195	0.0005	0.00046086311340332	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
196	0.0010	0.00096797943115234	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
197	0.0005	0.00049400329589844	SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
198	0.0005	0.00049209594726562	SELECT * FROM productoffers WHERE product_id = '3551' AND price > 0 ORDER BY price ASC LIMIT 1
199	0.0004	0.00038695335388184	SELECT * FROM productoffers WHERE product_id = 3551 ORDER BY price ASC LIMIT 1
200	0.0004	0.00043797492980957	SELECT value FROM productattributes WHERE product_id = '3551' AND name = 'ListPriceAmount'
201	0.0006	0.00056099891662598	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 = '3551' GROUP BY o.product_id
202	0.0008	0.00075411796569824	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 = '3551' GROUP BY n.displayname ORDER BY n.displayname DESC
203	0.0005	0.00047802925109863	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3551
204	0.0007	0.00071096420288086	SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205	0.0007	0.0006718635559082	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3551' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
206	0.0118	0.011780023574829	SELECT *, MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AND 2960 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 5
207	0.0010	0.00095796585083008	SELECT *, MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 5
208	0.0007	0.00068497657775879	SELECT *, MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('hermétique ashata bo�tes' IN BOOLEAN MODE) AND 2960 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 5
209	0.0007	0.00071406364440918	SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
210	0.0005	0.00050997734069824	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
211	0.0007	0.00072503089904785	SELECT * FROM product_image_select WHERE product_id = '1915'
212	0.0004	0.00043106079101562	SELECT * FROM productcustomimages WHERE product_id = '1915'
213	0.0006	0.00061297416687012	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
214	0.0007	0.00071597099304199	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
215	0.0004	0.00043487548828125	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
216	0.0010	0.00095295906066895	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
217	0.0004	0.00044012069702148	SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
218	0.0004	0.0003960132598877	SELECT * FROM productoffers WHERE product_id = '1915' AND price > 0 ORDER BY price ASC LIMIT 1
219	0.0004	0.00036406517028809	SELECT * FROM productoffers WHERE product_id = 1915 ORDER BY price ASC LIMIT 1
220	0.0004	0.00041413307189941	SELECT value FROM productattributes WHERE product_id = '1915' AND name = 'ListPriceAmount'
221	0.0004	0.00043892860412598	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
222	0.0006	0.00064492225646973	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
223	0.0005	0.00053977966308594	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
224	0.0007	0.00073814392089844	SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225	0.0006	0.00064492225646973	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
226	0.0005	0.00048494338989258	SELECT * FROM products WHERE parent_id = '1915'
227	0.0006	0.00064587593078613	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4901' AND a.name = n.originalname
228	0.0005	0.00054121017456055	SELECT * FROM productoffers WHERE product_id = '4901' AND merchantid = 'A1X6FK5RDHNB96'
229	0.0004	0.00044417381286621	SELECT * FROM productoffers WHERE product_id = '4901' AND price > 0 ORDER BY price ASC LIMIT 1
230	0.0009	0.00086617469787598	SELECT * FROM productimages WHERE product_id = '3821' ORDER BY sortorder ASC
231	0.0007	0.00066018104553223	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3821' AND p.id = pi.product_id ORDER BY pi.sortorder
232	0.0018	0.0017728805541992	SELECT * FROM product_image_select WHERE product_id = '3821'
233	0.0009	0.00086402893066406	SELECT * FROM productcustomimages WHERE product_id = '3821'
234	0.0013	0.0012929439544678	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 = '3821' GROUP BY o.product_id
235	0.0072	0.0071609020233154	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 = '3821' GROUP BY n.displayname ORDER BY n.displayname DESC
236	0.0010	0.0010020732879639	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3821
237	0.0041	0.0041100978851318	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3821' AND a.name = n.originalname
238	0.0010	0.0010318756103516	SELECT * FROM productoffers WHERE product_id = '3821' AND merchantid = 'A1X6FK5RDHNB96'
239	0.0007	0.00069713592529297	SELECT * FROM productoffers WHERE product_id = '3821' AND price > 0 ORDER BY price ASC LIMIT 1
240	0.0006	0.00059103965759277	SELECT * FROM productoffers WHERE product_id = 3821 ORDER BY price ASC LIMIT 1
241	0.0010	0.00097107887268066	SELECT value FROM productattributes WHERE product_id = '3821' AND name = 'ListPriceAmount'
242	0.0011	0.0011398792266846	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 = '3821' GROUP BY o.product_id
243	0.0015	0.0015318393707275	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 = '3821' GROUP BY n.displayname ORDER BY n.displayname DESC
244	0.0008	0.00083589553833008	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3821
245	0.0010	0.0010409355163574	SELECT value FROM productattributes WHERE product_id = '3821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246	0.0011	0.0011239051818848	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3821' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
247	0.0056	0.0055708885192871	SELECT * FROM productimages WHERE product_id = '829' ORDER BY sortorder ASC
248	0.0010	0.0010058879852295	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
249	0.0010	0.00095701217651367	SELECT * FROM product_image_select WHERE product_id = '829'
250	0.0006	0.00056099891662598	SELECT * FROM productcustomimages WHERE product_id = '829'
251	0.0009	0.00089812278747559	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
252	0.0010	0.0010180473327637	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
253	0.0006	0.00056982040405273	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
254	0.0013	0.0013120174407959	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '829' AND a.name = n.originalname
255	0.0006	0.00057601928710938	SELECT * FROM productoffers WHERE product_id = '829' AND merchantid = 'A1X6FK5RDHNB96'
256	0.0006	0.00058507919311523	SELECT * FROM productoffers WHERE product_id = '829' AND price > 0 ORDER BY price ASC LIMIT 1
257	0.0005	0.00048398971557617	SELECT * FROM productoffers WHERE product_id = 829 ORDER BY price ASC LIMIT 1
258	0.0078	0.0078308582305908	SELECT value FROM productattributes WHERE product_id = '829' AND name = 'ListPriceAmount'
259	0.0029	0.0028519630432129	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
260	0.0036	0.0035741329193115	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
261	0.0021	0.0021319389343262	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
262	0.0010	0.0010490417480469	SELECT value FROM productattributes WHERE product_id = '829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263	0.0012	0.001215934753418	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
264	0.0010	0.00098705291748047	SELECT * FROM productimages WHERE product_id = '2612' ORDER BY sortorder ASC
265	0.0008	0.00076985359191895	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
266	0.0012	0.0011899471282959	SELECT * FROM product_image_select WHERE product_id = '2612'
267	0.0008	0.00078415870666504	SELECT * FROM productcustomimages WHERE product_id = '2612'
268	0.0010	0.0010061264038086	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
269	0.0010	0.0010349750518799	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
270	0.0006	0.00060105323791504	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
271	0.0028	0.0027849674224854	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2612' AND a.name = n.originalname
272	0.0006	0.00058579444885254	SELECT * FROM productoffers WHERE product_id = '2612' AND merchantid = 'A1X6FK5RDHNB96'
273	0.0005	0.00054001808166504	SELECT * FROM productoffers WHERE product_id = '2612' AND price > 0 ORDER BY price ASC LIMIT 1
274	0.0005	0.00047898292541504	SELECT * FROM productoffers WHERE product_id = 2612 ORDER BY price ASC LIMIT 1
275	0.0006	0.00061893463134766	SELECT value FROM productattributes WHERE product_id = '2612' AND name = 'ListPriceAmount'
276	0.0008	0.00075101852416992	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
277	0.0010	0.0010368824005127	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
278	0.0006	0.00055909156799316	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
279	0.0008	0.00080204010009766	SELECT value FROM productattributes WHERE product_id = '2612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280	0.0009	0.00087714195251465	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
281	0.0008	0.00084900856018066	SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
282	0.0008	0.00081801414489746	SELECT * FROM product_image_select WHERE product_id = '1290'
283	0.0006	0.00059008598327637	SELECT * FROM productcustomimages WHERE product_id = '1290'
284	0.0023	0.0023248195648193	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
285	0.0011	0.0011098384857178	SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
286	0.0006	0.0005648136138916	SELECT * FROM productoffers WHERE product_id = '1290' AND price > 0 ORDER BY price ASC LIMIT 1
287	0.0007	0.00069999694824219	SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288	0.0014	0.0014340877532959	SELECT id,asin FROM products WHERE parent_id = 2960
289	0.0045	0.0045351982116699	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2961
290	0.0009	0.00090408325195312	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2961
291	0.0005	0.00048303604125977	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2962
292	0.0010	0.0010428428649902	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2962
293	0.0010	0.0010478496551514	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2963
294	0.0049	0.0048789978027344	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2963
295	0.0029	0.0028979778289795	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2964
296	0.0007	0.00071597099304199	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2964
297	0.0051	0.0051019191741943	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2960' ORDER BY timestamp DESC
298	0.0017	0.0017328262329102	SELECT category_id FROM products_categories WHERE product_id = '2960'
299	0.0012	0.0011658668518066	SELECT * FROM categories WHERE id = '26'
300	0.0109	0.010907888412476	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
301	0.0007	0.00068807601928711	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
302	0.0005	0.00049209594726562	SELECT id FROM categories WHERE parent_id = '26'
303	0.0072	0.0072410106658936	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
304	0.0098	0.0098228454589844	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
305	0.0012	0.001209020614624	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
306	0.0009	0.00092601776123047	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
307	0.0021	0.0021021366119385	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
308	0.0008	0.00084400177001953	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
309	0.0006	0.00063991546630859	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
310	0.0007	0.00074601173400879	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
311	0.0006	0.00063109397888184	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
312	0.0009	0.00094795227050781	SELECT * FROM products WHERE id = '2960'
313	0.0009	0.00094008445739746	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
314	0.0014	0.0013668537139893	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
315	0.0007	0.00069904327392578	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
316	0.0010	0.00096297264099121	SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317	0.0021	0.0021178722381592	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
318	0.0006	0.00060200691223145	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
319	0.0006	0.00059890747070312	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
320	0.0009	0.00088191032409668	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
321	0.0006	0.00062417984008789	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
322	0.0010	0.00096702575683594	SELECT DISTINCT (name) FROM productoptions
323	0.0009	0.0009310245513916	SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 2960))
324	0.0007	0.00074291229248047	SELECT o.value, o.name FROM products p, productoptions o WHERE p.parent_id = 2960 AND p.id = o.product_id GROUP BY o.value ORDER BY o.value ASC
325	0.0035	0.0034589767456055	SELECT * FROM translationsfilter
326	0.0008	0.00083088874816895	SELECT category_id FROM products_categories WHERE product_id = '2960' AND prod_type = 'amz'
327	0.0007	0.00068497657775879	SELECT parent_id FROM categories WHERE id = '26'
328	0.0010	0.00098490715026855	SELECT * FROM categories WHERE id = '26'
329	0.0104	0.010374069213867	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
330	0.0006	0.00061488151550293	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
331	0.0004	0.00038814544677734	SELECT id FROM categories WHERE parent_id = '26'
332	0.0060	0.0059950351715088	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
333	0.0007	0.0007469654083252	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
334	0.0007	0.00074005126953125	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
335	0.0006	0.00060200691223145	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
336	0.0019	0.0019299983978271	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
337	0.0013	0.001345157623291	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
338	0.0004	0.00038409233093262	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
339	0.0143	0.014272928237915	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
340	0.0022	0.0021500587463379	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
341	0.0006	0.00060510635375977	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
342	0.0006	0.00061297416687012	SELECT * FROM products WHERE id = 1626
343	0.0004	0.0004420280456543	SELECT * FROM products WHERE id = 4041
344	0.0005	0.00047588348388672	SELECT * FROM products WHERE id = 4312
345	0.0005	0.00047206878662109	SELECT * FROM products WHERE id = 777
346	0.0010	0.0010089874267578	SELECT * FROM products WHERE id = 3881
347	0.0009	0.0009009838104248	SELECT * FROM products WHERE id = 4213
348	0.0007	0.00071310997009277	SELECT * FROM products WHERE id = '1626'
349	0.0011	0.0011119842529297	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
350	0.0013	0.0012969970703125	SELECT * FROM product_image_select WHERE product_id = '1626'
351	0.0009	0.00088310241699219	SELECT * FROM productcustomimages WHERE product_id = '1626'
352	0.0022	0.0021791458129883	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
353	0.0010	0.0010359287261963	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
354	0.0008	0.00083494186401367	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
355	0.0010	0.0010430812835693	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356	0.0011	0.0010910034179688	SELECT * FROM products WHERE id = '4041'
357	0.0010	0.0010170936584473	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
358	0.0014	0.0013959407806396	SELECT * FROM product_image_select WHERE product_id = '4041'
359	0.0008	0.00077700614929199	SELECT * FROM productcustomimages WHERE product_id = '4041'
360	0.0024	0.0023798942565918	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
361	0.0008	0.00084400177001953	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
362	0.0007	0.00066900253295898	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
363	0.0008	0.00077009201049805	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364	0.0009	0.00087594985961914	SELECT * FROM products WHERE id = '4312'
365	0.0008	0.000823974609375	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
366	0.0023	0.0022809505462646	SELECT * FROM product_image_select WHERE product_id = '4312'
367	0.0008	0.00078082084655762	SELECT * FROM productcustomimages WHERE product_id = '4312'
368	0.0024	0.0023767948150635	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
369	0.0007	0.00071191787719727	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
370	0.0006	0.00058293342590332	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
371	0.0006	0.00057005882263184	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372	0.0008	0.00075292587280273	SELECT * FROM products WHERE id = '777'
373	0.0008	0.00075101852416992	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
374	0.0009	0.00090599060058594	SELECT * FROM product_image_select WHERE product_id = '777'
375	0.0005	0.0005497932434082	SELECT * FROM productcustomimages WHERE product_id = '777'
376	0.0016	0.0016090869903564	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
377	0.0007	0.00073909759521484	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
378	0.0006	0.00058388710021973	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
379	0.0005	0.0005340576171875	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
380	0.0007	0.00070405006408691	SELECT * FROM products WHERE id = '3881'
381	0.0012	0.0011970996856689	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
382	0.0014	0.0013689994812012	SELECT * FROM product_image_select WHERE product_id = '3881'
383	0.0005	0.0005488395690918	SELECT * FROM productcustomimages WHERE product_id = '3881'
384	0.0016	0.0016119480133057	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
385	0.0007	0.00065207481384277	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
386	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
387	0.0007	0.00065803527832031	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
388	0.0007	0.00072884559631348	SELECT * FROM products WHERE id = '4213'
389	0.0009	0.00093793869018555	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
390	0.0008	0.00076913833618164	SELECT * FROM product_image_select WHERE product_id = '4213'
391	0.0005	0.00051307678222656	SELECT * FROM productcustomimages WHERE product_id = '4213'
392	0.0015	0.0014879703521729	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
393	0.0006	0.00063085556030273	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
394	0.0005	0.00053095817565918	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
395	0.0006	0.00060105323791504	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
396	0.0029	0.0028729438781738	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
397	0.0010	0.00099897384643555	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
398	0.0116	0.011580944061279	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
399	0.0036	0.0035719871520996	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
400	0.0010	0.00098180770874023	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
401	0.0012	0.0012450218200684	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Boîte à Café Hermétique, ASHATA Boîtes et Coffrets à thé et Café Alimentaire en Acier Inoxydable Coffee Vault Hermétique de Conservation pour Café/Haricots / Sucre/Thé

Product Features

TAMUME Boîtes et Coffrets à Thé et Café...

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

Boite Hermetique pour Café en Acier Inox...

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

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

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

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5697181224823 seconds

Query Debug - 401 Database Queries. Total time 1.0274 seconds

Boîte à Café Hermétique, ASHATA Boîtes et Coffrets à thé et Café Alimentaire en Acier Inoxydable Coffee Vault Hermétique de Conservation pour Café/Haricots / Sucre/Thé

Product Features

Related Products

TAMUME Boîtes et Coffrets à Thé et Café...

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

Boite Hermetique pour Café en Acier Inox...

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

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

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

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5697181224823 seconds

Query Debug - 401 Database Queries. Total time 1.0274 seconds