Boîte à Café Hermétique, ASHATA Boîtes et Coffrets à thé et Café Alimentaire en Verre Borosilicate Coffee Vault Hermétique de Conservation pour Café/Haricots / Sucre/Thé (1000ML)

Price: Click Button for Price

As of 2022-06-26 15:24:28 UTC (more info)

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

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

Fait de verre borosilicate de haute qualité, respectueux de l'environnement, durable et facile à nettoyer Le couvercle en acier inoxydable brossé garde les aliments frais dans un style contemporain Le couvercle du joint semblable à un vide s'ouvre et se ferme au toucher d'un bouton. Aucune compression, torsion ou pompes Joint d'étanchéité en silicone étanche à l'air et à l'eau qui conserve la fraîcheur et bloque les odeurs, l'humidité, les animaux domestiques et les nuisibles 1000ml grande capacité. Idéal pour stocker des biscuits, du sucre, de la farine, des épices, du café et d'autres aliments de base

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.6222438812256	375	1.2630	0

No Amazon API Requests Made.

App Debug - Total Time 1.6222438812256 seconds

Number	Time From Start	Name	Description
1	0.34002685546875	Initialise	Initialise FSB Function
2	0.34230089187622	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.38737297058105	Start of getCategoryListByGroup Function	Before first category groups query
4	0.38785600662231	After initial query	Before first category groups query
5	0.38785600662231	Get Category List for Group	Before the call to getCategoryList function
6	0.38785791397095	Start of GetCategoryList function	Start of the function
7	0.38786005973816	Before getting categories	Query to get specific category list
8	0.3883810043335	After getting categories	Query to get specific category list
9	0.38838195800781	Before getting category custom	Before call to function getCategoryCustom
10	0.40429592132568	After getting category custom	After call to function getCategoryCustom
11	0.40429902076721	Before getting category custom	Before call to function getCategoryCustom
12	0.41561985015869	After getting category custom	After call to function getCategoryCustom
13	0.4156219959259	Before getting category custom	Before call to function getCategoryCustom
14	0.42657899856567	After getting category custom	After call to function getCategoryCustom
15	0.42657995223999	Before getting category custom	Before call to function getCategoryCustom
16	0.43597006797791	After getting category custom	After call to function getCategoryCustom
17	0.43597197532654	Before getting category custom	Before call to function getCategoryCustom
18	0.44244289398193	After getting category custom	After call to function getCategoryCustom
19	0.44244384765625	Before getting category custom	Before call to function getCategoryCustom
20	0.44840693473816	After getting category custom	After call to function getCategoryCustom
21	0.44840788841248	End of GetCategoryList function	End of the function
22	0.44841289520264	Get Category List for Group	Before the call to getCategoryList function
23	0.44841504096985	Start of GetCategoryList function	Start of the function
24	0.44841599464417	Before getting categories	Query to get specific category list
25	0.44891905784607	End of getCategoryListByGroup Function	Before return()
26	1.2502028942108	App Controller End	End of the App controller (called before the controller of every page)
27	1.2507848739624	Product Start	Start of the product info controller
28	1.2686669826508	Cache file not found	Starting get product details
29	1.3447799682617	Related products	Start getting related products if enabled
30	1.344780921936	Related Products Start	Before the related products are found
31	1.3447818756104	Related Products Keywords	Before the related product keywords are found
32	1.3447849750519	Create Keyword List Function	Start of function
33	1.3448679447174	Create Keyword List Function	After looping provided content - 68 keywords found
34	1.3460328578949	Create Keyword List Function	After looping initial keyword list - 64 keywords remaining
35	1.3460400104523	Create Keyword List Function	After reducing keyword list
36	1.3462469577789	Create Keyword List Function	After selecting by scoring keywords
37	1.3462500572205	Create Keyword List Function	After final loop of keywords
38	1.3462510108948	Related Products Keywords	After the related product keywords are found
39	1.492684841156	Related Products End	After the related products are found
40	1.5366649627686	Product End	End of the product info controller (Product Info)
41	1.5374920368195	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.5382850170135	Before Get Options	Before the call to getOptions in the tpl class
43	1.6108610630035	After Get Options	After the call to getOptions in the tpl class
44	1.6109528541565	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.6109738349915	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.6137449741364	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.6137478351593	Product Info: Before Template Display	Before the template is displayed
48	1.6222288608551	Product Info: After Template Display	After the template is displayed
49	1.6222360134125	Finalizing debug	Before the debug is output to the page.
50	1.6222438812256	End of App	This is the end of the app logging, final timestamp

Query Debug - 375 Database Queries. Total time 1.2630 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:12:\"3.21.125.194\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746275098'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-05-03 12:24:58' WHERE id = '8'
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' LIMIT 1
SELECT id FROM products WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire' 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'
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.21.125.194') >= INET_ATON(ip_start) AND INET_ATON('3.21.125.194') <= 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'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2663
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 = '2960' 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 = '2663'
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 = '2663' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2663' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2663'
SELECT * FROM productcustomimages WHERE product_id = '2663'
SELECT * FROM productfeeds WHERE product_id = '2663' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2663' 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 = '2663' AND t.hidden = 0 AND display_product = 1
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 = '2663'
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 = '2663'
                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     = '2663'
                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 = 2663
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2663' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2663
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2663'
                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 = '2663'
                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     = '2663'
                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 = 2663
SELECT value FROM productattributes WHERE product_id = '2663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2663'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '2663'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4887' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4887' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4887' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4887
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4887'
                AND name = 'ListPriceAmount'
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 2663 <> 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 2663 <> 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 2663 <> 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 2663 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
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 2663 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
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 2663 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
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 2663 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
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 2663 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
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 2663 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
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 = '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 = '1290' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1290'
SELECT * FROM productcustomimages WHERE product_id = '1290'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1290' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1915' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1915'
SELECT * FROM productcustomimages WHERE product_id = '1915'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1915'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1915'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1915
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1915' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1915
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1915'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '1915'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '1915'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1915
SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1915'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '1915'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4901' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4901' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4901' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 2663
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4887
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4887
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2663' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '2663'
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 = '2663' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2663' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2663
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2663'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '2663'
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 = '2663'
                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     = '2663'
                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 = 2663
SELECT value FROM productattributes WHERE product_id = '2663' 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 = '2663' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2663' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2663
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2663'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '2663' 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.0022	0.0021998882293701	SELECT parameter, value FROM parameters
2	0.0059	0.0058901309967041	SELECT * FROM `bad_bots`
3	0.0023	0.002316951751709	SET time_zone = 'Europe/London'
4	0.0013	0.0012929439544678	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0009	0.00089907646179199	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.21.125.194\";}'
6	0.0008	0.00084805488586426	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746275098'
7	0.0011	0.0010740756988525	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0006	0.00064301490783691	UPDATE autorun SET lastrun = '2025-05-03 12:24:58' WHERE id = '8'
9	0.0005	0.0004570484161377	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0008	0.00082588195800781	SELECT id FROM pages WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire' LIMIT 1
11	0.0008	0.00077486038208008	SELECT id FROM products WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire' AND hidden = 0 LIMIT 1
12	0.0123	0.01232385635376	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0321	0.032076120376587	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0004	0.00038003921508789	SELECT * FROM pages WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire'
15	0.0005	0.00047802925109863	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0005	0.00051093101501465	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0061	0.006065845489502	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.0005	0.00051498413085938	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.0004	0.00041079521179199	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0004	0.00041294097900391	SELECT id FROM categories WHERE parent_id = '26'
21	0.0065	0.0064821243286133	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.0005	0.0004880428314209	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.0005	0.00050497055053711	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.0005	0.00050997734069824	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0005	0.00047087669372559	SELECT * FROM categorygroups WHERE id = '1'
26	0.0038	0.0038418769836426	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.0004580020904541	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.00040411949157715	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0004	0.0004119873046875	SELECT id FROM categories WHERE parent_id = '27'
30	0.0043	0.0042898654937744	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.00051522254943848	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.0005	0.00051116943359375	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.00048303604125977	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0004	0.00037407875061035	SELECT * FROM categorygroups WHERE id = '1'
35	0.0014	0.001399040222168	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.00046420097351074	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.0006	0.0005800724029541	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0006	0.00063800811767578	SELECT id FROM categories WHERE parent_id = '28'
39	0.0026	0.0026030540466309	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.0012	0.0012450218200684	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.0019	0.0018999576568604	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.0012	0.0011799335479736	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0009	0.0009150505065918	SELECT * FROM categorygroups WHERE id = '1'
44	0.0018	0.0018410682678223	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.0011	0.0011179447174072	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.0008	0.00083804130554199	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0009	0.00085091590881348	SELECT id FROM categories WHERE parent_id = '29'
48	0.0016	0.0016489028930664	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.0010	0.00097084045410156	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.0009	0.00094509124755859	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
51	0.0006	0.0006110668182373	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0005	0.00053596496582031	SELECT * FROM categorygroups WHERE id = '1'
53	0.0010	0.0010099411010742	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.0007	0.00071096420288086	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.0006	0.00057506561279297	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00054693222045898	SELECT id FROM categories WHERE parent_id = '30'
57	0.0010	0.00095510482788086	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.00063514709472656	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.0008	0.00075292587280273	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.0007	0.00072002410888672	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0005	0.00054216384887695	SELECT * FROM categorygroups WHERE id = '1'
62	0.0010	0.00097990036010742	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.0006	0.00064396858215332	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.0005	0.00047898292541504	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.0005488395690918	SELECT id FROM categories WHERE parent_id = '31'
66	0.0010	0.0010190010070801	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
67	0.0005	0.00054717063903809	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.0007	0.00072002410888672	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
69	0.0006	0.00058507919311523	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0004	0.00041580200195312	SELECT * FROM categorygroups WHERE id = '1'
71	0.0005	0.00049996376037598	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0021	0.0021090507507324	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0006	0.00063896179199219	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0006	0.0005800724029541	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.0004	0.00044703483581543	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0013	0.0012969970703125	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0009	0.00094389915466309	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.7911	0.79107093811035	SELECT * FROM ipgeocountries WHERE INET_ATON('3.21.125.194') >= INET_ATON(ip_start) AND INET_ATON('3.21.125.194') <= INET_ATON(ip_end)
79	0.0023	0.0022518634796143	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0013	0.0012500286102295	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0006	0.00055599212646484	SELECT * FROM products WHERE pagename = 'bote-cafe-hermetique-ashata-botes-et-coffrets-the-et-cafe-alimentaire'
82	0.0004	0.00044894218444824	UPDATE products SET viewcount = viewcount + 1 WHERE id = 2663
83	0.0010	0.0010061264038086	SELECT * FROM manufacturers WHERE id = '461'
84	0.0009	0.00085902214050293	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '461'
85	0.0029	0.0028741359710693	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '461' LIMIT 1
86	0.0020	0.0019710063934326	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.0006	0.00055599212646484	SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
88	0.0005	0.00047802925109863	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '461'
89	0.0005	0.00046110153198242	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.0004	0.00043582916259766	SELECT * FROM manufacturerimages WHERE manufacturer_id = '461'
91	0.0005	0.00049996376037598	SELECT category_id FROM products_categories WHERE product_id = '2663'
92	0.0005	0.00051784515380859	SELECT * FROM categories WHERE id = '26'
93	0.0168	0.016788005828857	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.0006	0.00062084197998047	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95	0.0004	0.00041890144348145	SELECT id FROM categories WHERE parent_id = '26'
96	0.0093	0.009315013885498	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.0006	0.00064516067504883	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.0007	0.00066304206848145	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.00058603286743164	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100	0.0007	0.00068283081054688	SELECT * FROM productimages WHERE product_id = '2663' ORDER BY sortorder ASC
101	0.0007	0.00073909759521484	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2663' AND p.id = pi.product_id ORDER BY pi.sortorder
102	0.0007	0.0007021427154541	SELECT * FROM product_image_select WHERE product_id = '2663'
103	0.0004	0.00044989585876465	SELECT * FROM productcustomimages WHERE product_id = '2663'
104	0.0010	0.0010020732879639	SELECT * FROM productfeeds WHERE product_id = '2663' ORDER BY item_date DESC
105	0.0021	0.0020720958709717	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106	0.0028	0.0028390884399414	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2663' AND t.hidden = 0 AND display_product = 1
107	0.0004	0.0003669261932373	SELECT * FROM tags WHERE id = '58'
108	0.0023	0.0023419857025146	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
109	0.0021	0.0020661354064941	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
110	0.0018	0.001802921295166	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
111	0.0006	0.00056004524230957	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
112	0.0022	0.0021610260009766	SELECT * FROM productamazoncontent WHERE product_id = '2663'
113	0.0019	0.00193190574646	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 = '2663' GROUP BY o.product_id
114	0.0029	0.002856969833374	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 = '2663' GROUP BY n.displayname ORDER BY n.displayname DESC
115	0.0006	0.00056004524230957	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663
116	0.0011	0.0010719299316406	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname
117	0.0008	0.00078701972961426	SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
118	0.0008	0.00083613395690918	SELECT * FROM productoffers WHERE product_id = '2663' AND price > 0 ORDER BY price ASC LIMIT 1
119	0.0007	0.00068902969360352	SELECT * FROM productoffers WHERE product_id = 2663 ORDER BY price ASC LIMIT 1
120	0.0007	0.0006558895111084	SELECT value FROM productattributes WHERE product_id = '2663' AND name = 'ListPriceAmount'
121	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 = '2663' GROUP BY o.product_id
122	0.0013	0.0013301372528076	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 = '2663' GROUP BY n.displayname ORDER BY n.displayname DESC
123	0.0007	0.00072693824768066	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663
124	0.0012	0.0011510848999023	SELECT value FROM productattributes WHERE product_id = '2663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125	0.0012	0.0011990070343018	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2663' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
126	0.0008	0.00077009201049805	SELECT * FROM products WHERE parent_id = '2663'
127	0.0009	0.00087594985961914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4887' AND a.name = n.originalname
128	0.0006	0.00055599212646484	SELECT * FROM productoffers WHERE product_id = '4887' AND merchantid = 'A1X6FK5RDHNB96'
129	0.0006	0.00058102607727051	SELECT * FROM productoffers WHERE product_id = '4887' AND price > 0 ORDER BY price ASC LIMIT 1
130	0.0004	0.00042486190795898	SELECT * FROM productoffers WHERE product_id = 4887 ORDER BY price ASC LIMIT 1
131	0.0007	0.00065779685974121	SELECT value FROM productattributes WHERE product_id = '4887' AND name = 'ListPriceAmount'
132	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
133	0.0159	0.015922069549561	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 2663 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
134	0.0007	0.00074601173400879	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 2663 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
135	0.0006	0.00060296058654785	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 2663 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
136	0.0007	0.00066709518432617	SELECT * FROM productimages WHERE product_id = '3551' ORDER BY sortorder ASC
137	0.0005	0.00049686431884766	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
138	0.0006	0.00063800811767578	SELECT * FROM product_image_select WHERE product_id = '3551'
139	0.0004	0.0003972053527832	SELECT * FROM productcustomimages WHERE product_id = '3551'
140	0.0006	0.00061893463134766	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
141	0.0020	0.0019559860229492	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
142	0.0009	0.00090694427490234	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
143	0.0026	0.0025720596313477	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
144	0.0008	0.00075507164001465	SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
145	0.0010	0.00097990036010742	SELECT * FROM productoffers WHERE product_id = '3551' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0007	0.00072979927062988	SELECT * FROM productoffers WHERE product_id = 3551 ORDER BY price ASC LIMIT 1
147	0.0007	0.00072288513183594	SELECT value FROM productattributes WHERE product_id = '3551' AND name = 'ListPriceAmount'
148	0.0009	0.00086879730224609	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
149	0.0013	0.0012569427490234	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
150	0.0007	0.00071001052856445	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
151	0.0011	0.0010659694671631	SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152	0.0012	0.0012459754943848	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
153	0.0010	0.00099396705627441	SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
154	0.0011	0.00105881690979	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
155	0.0008	0.00078916549682617	SELECT * FROM product_image_select WHERE product_id = '2960'
156	0.0004	0.00043487548828125	SELECT * FROM productcustomimages WHERE product_id = '2960'
157	0.0007	0.00071597099304199	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
158	0.0009	0.00087285041809082	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
159	0.0006	0.00061488151550293	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
160	0.0020	0.002025842666626	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
161	0.0005	0.00052094459533691	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
162	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
163	0.0004	0.00038313865661621	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
164	0.0006	0.00063395500183105	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
165	0.0007	0.00069284439086914	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
166	0.0011	0.0011031627655029	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
167	0.0006	0.00059700012207031	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
168	0.0006	0.00058817863464355	SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169	0.0008	0.00075602531433105	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
170	0.0133	0.013303995132446	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 2663 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
171	0.0006	0.0005791187286377	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 2663 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
172	0.0006	0.00060105323791504	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 2663 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
173	0.0006	0.0005650520324707	SELECT * FROM productimages WHERE product_id = '2960' ORDER BY sortorder ASC
174	0.0006	0.00060677528381348	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
175	0.0007	0.0006561279296875	SELECT * FROM product_image_select WHERE product_id = '2960'
176	0.0004	0.00039911270141602	SELECT * FROM productcustomimages WHERE product_id = '2960'
177	0.0006	0.00056695938110352	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2960' GROUP BY o.product_id
178	0.0007	0.00067615509033203	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
179	0.0005	0.0005030632019043	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
180	0.0014	0.0014140605926514	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2960' AND a.name = n.originalname
181	0.0004	0.00038695335388184	SELECT * FROM productoffers WHERE product_id = '2960' AND merchantid = 'A1X6FK5RDHNB96'
182	0.0004	0.00035691261291504	SELECT * FROM productoffers WHERE product_id = '2960' AND price > 0 ORDER BY price ASC LIMIT 1
183	0.0004	0.00038504600524902	SELECT * FROM productoffers WHERE product_id = 2960 ORDER BY price ASC LIMIT 1
184	0.0004	0.00040602684020996	SELECT value FROM productattributes WHERE product_id = '2960' AND name = 'ListPriceAmount'
185	0.0005	0.00047588348388672	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
186	0.0007	0.00072193145751953	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
187	0.0004	0.0004119873046875	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
188	0.0007	0.00070476531982422	SELECT value FROM productattributes WHERE product_id = '2960' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189	0.0007	0.00072598457336426	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
190	0.0005	0.00049805641174316	SELECT * FROM productimages WHERE product_id = '3551' ORDER BY sortorder ASC
191	0.0005	0.00054192543029785	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
192	0.0007	0.00066018104553223	SELECT * FROM product_image_select WHERE product_id = '3551'
193	0.0004	0.00043010711669922	SELECT * FROM productcustomimages WHERE product_id = '3551'
194	0.0005	0.00053310394287109	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
195	0.0007	0.0006709098815918	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
196	0.0004	0.00038909912109375	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
197	0.0008	0.0008389949798584	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3551' AND a.name = n.originalname
198	0.0003	0.00032901763916016	SELECT * FROM productoffers WHERE product_id = '3551' AND merchantid = 'A1X6FK5RDHNB96'
199	0.0004	0.00043988227844238	SELECT * FROM productoffers WHERE product_id = '3551' AND price > 0 ORDER BY price ASC LIMIT 1
200	0.0003	0.00033879280090332	SELECT * FROM productoffers WHERE product_id = 3551 ORDER BY price ASC LIMIT 1
201	0.0003	0.00031685829162598	SELECT value FROM productattributes WHERE product_id = '3551' AND name = 'ListPriceAmount'
202	0.0004	0.0004429817199707	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
203	0.0007	0.00067520141601562	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
204	0.0003	0.00034809112548828	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
205	0.0005	0.00051212310791016	SELECT value FROM productattributes WHERE product_id = '3551' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206	0.0006	0.00061798095703125	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
207	0.0133	0.013323068618774	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 2663 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
208	0.0007	0.00070691108703613	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 2663 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
209	0.0007	0.00070095062255859	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 2663 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
210	0.0005	0.00046801567077637	SELECT * FROM productimages WHERE product_id = '2612' ORDER BY sortorder ASC
211	0.0005	0.00049090385437012	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
212	0.0006	0.00062108039855957	SELECT * FROM product_image_select WHERE product_id = '2612'
213	0.0005	0.00047516822814941	SELECT * FROM productcustomimages WHERE product_id = '2612'
214	0.0006	0.00061202049255371	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
215	0.0006	0.00062298774719238	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
216	0.0004	0.00040102005004883	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
217	0.0008	0.00081300735473633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2612' AND a.name = n.originalname
218	0.0004	0.00041699409484863	SELECT * FROM productoffers WHERE product_id = '2612' AND merchantid = 'A1X6FK5RDHNB96'
219	0.0004	0.0003659725189209	SELECT * FROM productoffers WHERE product_id = '2612' AND price > 0 ORDER BY price ASC LIMIT 1
220	0.0004	0.0003659725189209	SELECT * FROM productoffers WHERE product_id = 2612 ORDER BY price ASC LIMIT 1
221	0.0004	0.00043582916259766	SELECT value FROM productattributes WHERE product_id = '2612' AND name = 'ListPriceAmount'
222	0.0005	0.00046205520629883	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
223	0.0008	0.00079202651977539	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
224	0.0008	0.00081586837768555	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
225	0.0006	0.00059294700622559	SELECT value FROM productattributes WHERE product_id = '2612' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226	0.0007	0.00065302848815918	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
227	0.0005	0.0004880428314209	SELECT * FROM productimages WHERE product_id = '829' ORDER BY sortorder ASC
228	0.0005	0.00049400329589844	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
229	0.0006	0.00062894821166992	SELECT * FROM product_image_select WHERE product_id = '829'
230	0.0004	0.00039815902709961	SELECT * FROM productcustomimages WHERE product_id = '829'
231	0.0006	0.00057387351989746	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
232	0.0007	0.00073099136352539	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
233	0.0004	0.00041794776916504	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
234	0.0009	0.00093507766723633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '829' AND a.name = n.originalname
235	0.0004	0.0003509521484375	SELECT * FROM productoffers WHERE product_id = '829' AND merchantid = 'A1X6FK5RDHNB96'
236	0.0003	0.00033211708068848	SELECT * FROM productoffers WHERE product_id = '829' AND price > 0 ORDER BY price ASC LIMIT 1
237	0.0003	0.00028705596923828	SELECT * FROM productoffers WHERE product_id = 829 ORDER BY price ASC LIMIT 1
238	0.0003	0.00033402442932129	SELECT value FROM productattributes WHERE product_id = '829' AND name = 'ListPriceAmount'
239	0.0005	0.00046014785766602	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
240	0.0008	0.00075006484985352	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
241	0.0004	0.00037789344787598	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
242	0.0015	0.0015008449554443	SELECT value FROM productattributes WHERE product_id = '829' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243	0.0007	0.00069880485534668	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
244	0.0005	0.00053501129150391	SELECT * FROM productimages WHERE product_id = '1290' ORDER BY sortorder ASC
245	0.0017	0.0017220973968506	SELECT * FROM product_image_select WHERE product_id = '1290'
246	0.0009	0.00093483924865723	SELECT * FROM productcustomimages WHERE product_id = '1290'
247	0.0045	0.0044751167297363	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1290' AND a.name = n.originalname
248	0.0009	0.00089883804321289	SELECT * FROM productoffers WHERE product_id = '1290' AND merchantid = 'A1X6FK5RDHNB96'
249	0.0007	0.00068998336791992	SELECT * FROM productoffers WHERE product_id = '1290' AND price > 0 ORDER BY price ASC LIMIT 1
250	0.0008	0.00078201293945312	SELECT value FROM productattributes WHERE product_id = '1290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251	0.0013	0.0012898445129395	SELECT * FROM productimages WHERE product_id = '1915' ORDER BY sortorder ASC
252	0.0011	0.0010530948638916	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
253	0.0012	0.0012099742889404	SELECT * FROM product_image_select WHERE product_id = '1915'
254	0.0006	0.00064301490783691	SELECT * FROM productcustomimages WHERE product_id = '1915'
255	0.0010	0.00095796585083008	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
256	0.0038	0.0037860870361328	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
257	0.0007	0.00071907043457031	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
258	0.0017	0.0017139911651611	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1915' AND a.name = n.originalname
259	0.0006	0.00061392784118652	SELECT * FROM productoffers WHERE product_id = '1915' AND merchantid = 'A1X6FK5RDHNB96'
260	0.0006	0.00057697296142578	SELECT * FROM productoffers WHERE product_id = '1915' AND price > 0 ORDER BY price ASC LIMIT 1
261	0.0005	0.00046706199645996	SELECT * FROM productoffers WHERE product_id = 1915 ORDER BY price ASC LIMIT 1
262	0.0006	0.00055217742919922	SELECT value FROM productattributes WHERE product_id = '1915' AND name = 'ListPriceAmount'
263	0.0006	0.00064587593078613	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
264	0.0011	0.0010850429534912	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
265	0.0006	0.0006258487701416	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
266	0.0009	0.0009000301361084	SELECT value FROM productattributes WHERE product_id = '1915' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267	0.0011	0.0011370182037354	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
268	0.0006	0.00055694580078125	SELECT * FROM products WHERE parent_id = '1915'
269	0.0009	0.00090312957763672	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4901' AND a.name = n.originalname
270	0.0008	0.00080394744873047	SELECT * FROM productoffers WHERE product_id = '4901' AND merchantid = 'A1X6FK5RDHNB96'
271	0.0007	0.00070595741271973	SELECT * FROM productoffers WHERE product_id = '4901' AND price > 0 ORDER BY price ASC LIMIT 1
272	0.0005	0.00053095817565918	SELECT id,asin FROM products WHERE parent_id = 2663
273	0.0006	0.00056195259094238	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4887
274	0.0007	0.00069499015808105	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4887
275	0.0005	0.00051784515380859	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2663' ORDER BY timestamp DESC
276	0.0005	0.00053906440734863	SELECT category_id FROM products_categories WHERE product_id = '2663'
277	0.0006	0.00057101249694824	SELECT * FROM categories WHERE id = '26'
278	0.0088	0.0087728500366211	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
279	0.0005	0.00052404403686523	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
280	0.0003	0.00033903121948242	SELECT id FROM categories WHERE parent_id = '26'
281	0.0064	0.0063729286193848	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
282	0.0006	0.00056791305541992	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
283	0.0006	0.00055599212646484	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
284	0.0004	0.00043988227844238	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
285	0.0010	0.00095486640930176	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname
286	0.0004	0.00042605400085449	SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
287	0.0003	0.00031018257141113	SELECT * FROM productoffers WHERE product_id = '2663' AND price > 0 ORDER BY price ASC LIMIT 1
288	0.0003	0.00028586387634277	SELECT * FROM productoffers WHERE product_id = 2663 ORDER BY price ASC LIMIT 1
289	0.0004	0.00036096572875977	SELECT value FROM productattributes WHERE product_id = '2663' AND name = 'ListPriceAmount'
290	0.0006	0.00055408477783203	SELECT * FROM products WHERE id = '2663'
291	0.0004	0.00041294097900391	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 = '2663' GROUP BY o.product_id
292	0.0006	0.00060391426086426	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 = '2663' GROUP BY n.displayname ORDER BY n.displayname DESC
293	0.0004	0.00037884712219238	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2663
294	0.0005	0.00051593780517578	SELECT value FROM productattributes WHERE product_id = '2663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
295	0.0008	0.00083112716674805	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2663' AND a.name = n.originalname
296	0.0004	0.00037884712219238	SELECT * FROM productoffers WHERE product_id = '2663' AND merchantid = 'A1X6FK5RDHNB96'
297	0.0003	0.00032711029052734	SELECT * FROM productoffers WHERE product_id = '2663' AND price > 0 ORDER BY price ASC LIMIT 1
298	0.0003	0.00034093856811523	SELECT * FROM productoffers WHERE product_id = 2663 ORDER BY price ASC LIMIT 1
299	0.0003	0.00034809112548828	SELECT value FROM productattributes WHERE product_id = '2663' AND name = 'ListPriceAmount'
300	0.0005	0.00046896934509277	SELECT category_id FROM products_categories WHERE product_id = '2663' AND prod_type = 'amz'
301	0.0004	0.00039410591125488	SELECT parent_id FROM categories WHERE id = '26'
302	0.0004	0.0003809928894043	SELECT * FROM categories WHERE id = '26'
303	0.0061	0.0060598850250244	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
304	0.0004	0.00041103363037109	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
305	0.0003	0.0003209114074707	SELECT id FROM categories WHERE parent_id = '26'
306	0.0061	0.0061390399932861	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
307	0.0005	0.0005340576171875	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
308	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 (26) AND c.prod_type = 'custom' AND cp.hide = 0
309	0.0005	0.00049495697021484	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
310	0.0005	0.0005190372467041	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
311	0.0004	0.0004119873046875	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
312	0.0003	0.00034117698669434	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
313	0.0149	0.014916896820068	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
314	0.0074	0.0073549747467041	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
315	0.0006	0.00063896179199219	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
316	0.0005	0.00053286552429199	SELECT * FROM products WHERE id = 1626
317	0.0004	0.0003809928894043	SELECT * FROM products WHERE id = 4041
318	0.0004	0.00038385391235352	SELECT * FROM products WHERE id = 4312
319	0.0004	0.00040888786315918	SELECT * FROM products WHERE id = 777
320	0.0004	0.00040602684020996	SELECT * FROM products WHERE id = 3881
321	0.0004	0.00038790702819824	SELECT * FROM products WHERE id = 4213
322	0.0004	0.00041818618774414	SELECT * FROM products WHERE id = '1626'
323	0.0006	0.00056004524230957	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
324	0.0008	0.00078988075256348	SELECT * FROM product_image_select WHERE product_id = '1626'
325	0.0005	0.00047087669372559	SELECT * FROM productcustomimages WHERE product_id = '1626'
326	0.0010	0.0010230541229248	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
327	0.0006	0.0005648136138916	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
328	0.0005	0.00053191184997559	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
329	0.0006	0.00056195259094238	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
330	0.0007	0.00073003768920898	SELECT * FROM products WHERE id = '4041'
331	0.0009	0.00094008445739746	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
332	0.0009	0.0009310245513916	SELECT * FROM product_image_select WHERE product_id = '4041'
333	0.0006	0.0006098747253418	SELECT * FROM productcustomimages WHERE product_id = '4041'
334	0.0016	0.0015640258789062	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
335	0.0009	0.00085687637329102	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
336	0.0006	0.00057411193847656	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
337	0.0005	0.00049805641174316	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
338	0.0006	0.00059103965759277	SELECT * FROM products WHERE id = '4312'
339	0.0005	0.00050592422485352	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
340	0.0009	0.00089097023010254	SELECT * FROM product_image_select WHERE product_id = '4312'
341	0.0005	0.0004580020904541	SELECT * FROM productcustomimages WHERE product_id = '4312'
342	0.0023	0.0022850036621094	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
343	0.0006	0.00063800811767578	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
344	0.0005	0.00048685073852539	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
345	0.0006	0.00060200691223145	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
346	0.0008	0.00084304809570312	SELECT * FROM products WHERE id = '777'
347	0.0007	0.00074577331542969	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
348	0.0009	0.00086784362792969	SELECT * FROM product_image_select WHERE product_id = '777'
349	0.0005	0.00051999092102051	SELECT * FROM productcustomimages WHERE product_id = '777'
350	0.0016	0.0015761852264404	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
351	0.0005	0.00054383277893066	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
352	0.0004	0.00040602684020996	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
353	0.0005	0.00048184394836426	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
354	0.0006	0.00061202049255371	SELECT * FROM products WHERE id = '3881'
355	0.0006	0.0005958080291748	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
356	0.0015	0.0015430450439453	SELECT * FROM product_image_select WHERE product_id = '3881'
357	0.0007	0.00069999694824219	SELECT * FROM productcustomimages WHERE product_id = '3881'
358	0.0021	0.0021159648895264	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
359	0.0006	0.00055289268493652	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
360	0.0004	0.00039792060852051	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
361	0.0041	0.004115104675293	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
362	0.0006	0.00056695938110352	SELECT * FROM products WHERE id = '4213'
363	0.0006	0.00061821937561035	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
364	0.0007	0.00068998336791992	SELECT * FROM product_image_select WHERE product_id = '4213'
365	0.0004	0.00041794776916504	SELECT * FROM productcustomimages WHERE product_id = '4213'
366	0.0019	0.0018761157989502	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
367	0.0005	0.00051498413085938	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
368	0.0004	0.0004119873046875	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
369	0.0005	0.00051999092102051	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
370	0.0010	0.0010221004486084	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
371	0.0014	0.001366138458252	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
372	0.0021	0.0020520687103271	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
373	0.0008	0.00077414512634277	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
374	0.0007	0.0007021427154541	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
375	0.0008	0.00084304809570312	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 Verre Borosilicate Coffee Vault Hermétique de Conservation pour Café/Haricots / Sucre/Thé (1000ML)

Product Features

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

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

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

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

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

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

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6222438812256 seconds

Query Debug - 375 Database Queries. Total time 1.2630 seconds

Boîte à Café Hermétique, ASHATA Boîtes et Coffrets à thé et Café Alimentaire en Verre Borosilicate Coffee Vault Hermétique de Conservation pour Café/Haricots / Sucre/Thé (1000ML)

Product Features

Related Products

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

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

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

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

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

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

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6222438812256 seconds

Query Debug - 375 Database Queries. Total time 1.2630 seconds