Premier Housewares Boîte à thé Liberty

Price: €11,79

As of 2022-06-18 09:19:37 UTC (more info)

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

Availability: In Stock

Click and Choose Options

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

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

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
2.3117690086365	350	1.9275	0

No Amazon API Requests Made.

App Debug - Total Time 2.3117690086365 seconds

Number	Time From Start	Name	Description
1	0.37669706344604	Initialise	Initialise FSB Function
2	0.38270998001099	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.42230916023254	Start of getCategoryListByGroup Function	Before first category groups query
4	0.42433500289917	After initial query	Before first category groups query
5	0.42433619499207	Get Category List for Group	Before the call to getCategoryList function
6	0.42434215545654	Start of GetCategoryList function	Start of the function
7	0.42434406280518	Before getting categories	Query to get specific category list
8	0.42632412910461	After getting categories	Query to get specific category list
9	0.42632508277893	Before getting category custom	Before call to function getCategoryCustom
10	0.46423816680908	After getting category custom	After call to function getCategoryCustom
11	0.46424007415771	Before getting category custom	Before call to function getCategoryCustom
12	0.48175811767578	After getting category custom	After call to function getCategoryCustom
13	0.4817590713501	Before getting category custom	Before call to function getCategoryCustom
14	0.49544715881348	After getting category custom	After call to function getCategoryCustom
15	0.49544906616211	Before getting category custom	Before call to function getCategoryCustom
16	0.50195503234863	After getting category custom	After call to function getCategoryCustom
17	0.50195598602295	Before getting category custom	Before call to function getCategoryCustom
18	0.50814604759216	After getting category custom	After call to function getCategoryCustom
19	0.50814700126648	Before getting category custom	Before call to function getCategoryCustom
20	0.51443409919739	After getting category custom	After call to function getCategoryCustom
21	0.51443600654602	End of GetCategoryList function	End of the function
22	0.51444005966187	Get Category List for Group	Before the call to getCategoryList function
23	0.5144419670105	Start of GetCategoryList function	Start of the function
24	0.51444315910339	Before getting categories	Query to get specific category list
25	0.51500201225281	End of getCategoryListByGroup Function	Before return()
26	1.9952449798584	App Controller End	End of the App controller (called before the controller of every page)
27	1.995619058609	Product Start	Start of the product info controller
28	2.0119411945343	Cache file not found	Starting get product details
29	2.0963590145111	Related products	Start getting related products if enabled
30	2.0963599681854	Related Products Start	Before the related products are found
31	2.0963599681854	Related Products Keywords	Before the related product keywords are found
32	2.0963640213013	Create Keyword List Function	Start of function
33	2.0964231491089	Create Keyword List Function	After looping provided content - 15 keywords found
34	2.0966830253601	Create Keyword List Function	After looping initial keyword list - 14 keywords remaining
35	2.0966880321503	Create Keyword List Function	After reducing keyword list
36	2.0967030525208	Create Keyword List Function	After selecting by scoring keywords
37	2.0967061519623	Create Keyword List Function	After final loop of keywords
38	2.0967071056366	Related Products Keywords	After the related product keywords are found
39	2.1889569759369	Related Products End	After the related products are found
40	2.2503521442413	Product End	End of the product info controller (Product Info)
41	2.251228094101	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	2.2520980834961	Before Get Options	Before the call to getOptions in the tpl class
43	2.3020601272583	After Get Options	After the call to getOptions in the tpl class
44	2.3021371364594	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	2.3021581172943	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	2.3047971725464	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	2.3048000335693	Product Info: Before Template Display	Before the template is displayed
48	2.3117551803589	Product Info: After Template Display	After the template is displayed
49	2.3117611408234	Finalizing debug	Before the debug is output to the page.
50	2.3117690086365	End of App	This is the end of the app logging, final timestamp

Query Debug - 350 Database Queries. Total time 1.9275 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.17.175.182\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746030294'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-04-30 16:24:54' WHERE id = '16'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'premier-housewares-bote-the-liberty' LIMIT 1
SELECT id FROM products WHERE pagename = 'premier-housewares-bote-the-liberty' 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 = 'premier-housewares-bote-the-liberty'
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.17.175.182') >= INET_ATON(ip_start) AND INET_ATON('3.17.175.182') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'premier-housewares-bote-the-liberty'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3643
SELECT * FROM manufacturers WHERE id = '639'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '4500' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
SELECT category_id FROM products_categories WHERE product_id = '3643'
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 = '3643' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3643'
SELECT * FROM productcustomimages WHERE product_id = '3643'
SELECT * FROM productfeeds WHERE product_id = '3643' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3643' 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 = '3643' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '216'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '216'
				  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 = '216'
				  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 = '216' 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 = '4122' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '3643'
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 = '3643'
                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     = '3643'
                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 = 3643
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3643'
                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 = '3643'
                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     = '3643'
                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 = 3643
SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3643'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT *, MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AND 3643 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3643'
SELECT * FROM productcustomimages WHERE product_id = '3643'
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 = '3643'
                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     = '3643'
                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 = 3643
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3643'
                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 = '3643'
                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     = '3643'
                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 = 3643
SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3643'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT *, MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AND 3643 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3643'
SELECT * FROM productcustomimages WHERE product_id = '3643'
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 = '3643'
                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     = '3643'
                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 = 3643
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3643'
                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 = '3643'
                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     = '3643'
                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 = 3643
SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3643'
                  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 = '837' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '837' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '837'
SELECT * FROM productcustomimages WHERE product_id = '837'
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 = '837'
                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     = '837'
                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 = 837
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '837' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '837' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 837
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '837'
                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 = '837'
                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     = '837'
                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 = 837
SELECT value FROM productattributes WHERE product_id = '837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '837'
                  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 = '3699' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3699' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3699'
SELECT * FROM productcustomimages WHERE product_id = '3699'
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 = '3699'
                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     = '3699'
                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 = 3699
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3699' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3699' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3699' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3699
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3699'
                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 = '3699'
                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     = '3699'
                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 = 3699
SELECT value FROM productattributes WHERE product_id = '3699' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3699'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3643') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'amz'  AND p.id <> '3643' ORDER BY RAND()
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'ebay' AND p.id <> '3643' ORDER BY RAND()
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'custom' AND p.id <> '3643' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '4114' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4114'
SELECT * FROM productcustomimages WHERE product_id = '4114'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4114' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4114' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4114' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4114
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4114'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4114' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '775'
SELECT * FROM productcustomimages WHERE product_id = '775'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '775' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '775' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '775' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 775
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '775'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3531' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3531'
SELECT * FROM productcustomimages WHERE product_id = '3531'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3531' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3531' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3531' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3531
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3531'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3531' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '927' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '927'
SELECT * FROM productcustomimages WHERE product_id = '927'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '927' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '927' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '927' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 927
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '927'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 3643
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3644
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3644
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3645
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3645
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3643' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '3643'
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 = '3643' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3643'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3643'
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 = '3643'
                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     = '3643'
                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 = 3643
SELECT value FROM productattributes WHERE product_id = '3643' 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 = '3643' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3643' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3643
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3643'
                AND name = 'ListPriceAmount'
SELECT DISTINCT (name) FROM productoptions
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3643))
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 3643
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
SELECT * FROM translationsfilter
SELECT category_id FROM products_categories WHERE product_id = '3643' AND prod_type = 'amz'
SELECT parent_id FROM categories WHERE id = '26'
SELECT * FROM categories WHERE id = '26'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0019	0.0018811225891113	SELECT parameter, value FROM parameters
2	0.0087	0.0087158679962158	SELECT * FROM `bad_bots`
3	0.0005	0.00047588348388672	SET time_zone = 'Europe/London'
4	0.0035	0.0035090446472168	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0026	0.002640962600708	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.17.175.182\";}'
6	0.0027	0.0027010440826416	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746030294'
7	0.0023	0.0022740364074707	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0009	0.00088000297546387	UPDATE autorun SET lastrun = '2025-04-30 16:24:54' WHERE id = '16'
9	0.0005	0.00053787231445312	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0024	0.0023748874664307	SELECT id FROM pages WHERE pagename = 'premier-housewares-bote-the-liberty' LIMIT 1
11	0.0025	0.0025129318237305	SELECT id FROM products WHERE pagename = 'premier-housewares-bote-the-liberty' AND hidden = 0 LIMIT 1
12	0.0032	0.0032169818878174	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0354	0.03540301322937	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0007	0.00073099136352539	SELECT * FROM pages WHERE pagename = 'premier-housewares-bote-the-liberty'
15	0.0020	0.0020198822021484	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0020	0.0019710063934326	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0115	0.011463165283203	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.0071	0.0071041584014893	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.0022	0.0021538734436035	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0004	0.00043487548828125	SELECT id FROM categories WHERE parent_id = '26'
21	0.0066	0.0066499710083008	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.0053	0.0052649974822998	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.0025	0.0025279521942139	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.0017	0.0016698837280273	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0006	0.00059103965759277	SELECT * FROM categorygroups WHERE id = '1'
26	0.0087	0.0086510181427002	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.0006	0.00056004524230957	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.00044918060302734	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0005	0.00045108795166016	SELECT id FROM categories WHERE parent_id = '27'
30	0.0043	0.0042788982391357	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.00050091743469238	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
32	0.0006	0.00057387351989746	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.0012	0.0011889934539795	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0008	0.00083088874816895	SELECT * FROM categorygroups WHERE id = '1'
35	0.0039	0.0039491653442383	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.0010	0.00096487998962402	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.0006258487701416	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0008	0.00084304809570312	SELECT id FROM categories WHERE parent_id = '28'
39	0.0044	0.0044159889221191	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.0009	0.00092077255249023	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.0007	0.00071620941162109	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.0007	0.00069308280944824	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0005	0.00050497055053711	SELECT * FROM categorygroups WHERE id = '1'
44	0.0009	0.00087714195251465	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.0006	0.00061607360839844	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.0006	0.00063014030456543	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0005	0.00051093101501465	SELECT id FROM categories WHERE parent_id = '29'
48	0.0012	0.0011858940124512	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.0006	0.0005950927734375	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
50	0.0007	0.0007169246673584	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.0008	0.00077295303344727	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0006	0.00057482719421387	SELECT * FROM categorygroups WHERE id = '1'
53	0.0010	0.00095081329345703	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.0006	0.0005650520324707	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.0004	0.00043606758117676	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00051712989807129	SELECT id FROM categories WHERE parent_id = '30'
57	0.0011	0.0010650157928467	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.00064516067504883	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.0007	0.00072598457336426	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.00066709518432617	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0006	0.00059413909912109	SELECT * FROM categorygroups WHERE id = '1'
62	0.0009	0.00091886520385742	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.00062680244445801	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.00050210952758789	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0006	0.0005640983581543	SELECT id FROM categories WHERE parent_id = '31'
66	0.0010	0.0010139942169189	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.0007	0.00071501731872559	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.00073504447937012	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.00064611434936523	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0005	0.00053882598876953	SELECT * FROM categorygroups WHERE id = '1'
71	0.0006	0.00055599212646484	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0015	0.0015220642089844	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0006	0.00057411193847656	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0006	0.00060296058654785	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.00037598609924316	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0010	0.0010299682617188	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0008	0.00077295303344727	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	1.4715	1.4714748859406	SELECT * FROM ipgeocountries WHERE INET_ATON('3.17.175.182') >= INET_ATON(ip_start) AND INET_ATON('3.17.175.182') <= INET_ATON(ip_end)
79	0.0026	0.0026228427886963	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0006	0.00060296058654785	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0008	0.00080299377441406	SELECT * FROM products WHERE pagename = 'premier-housewares-bote-the-liberty'
82	0.0004	0.00044393539428711	UPDATE products SET viewcount = viewcount + 1 WHERE id = 3643
83	0.0016	0.0016040802001953	SELECT * FROM manufacturers WHERE id = '639'
84	0.0016	0.0016188621520996	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
85	0.0005	0.0004889965057373	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
86	0.0015	0.0014541149139404	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
87	0.0005	0.00049591064453125	SELECT * FROM productimages WHERE product_id = '4500' ORDER BY sortorder ASC
88	0.0009	0.00091385841369629	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
89	0.0011	0.0010850429534912	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '639' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
90	0.0003	0.00027894973754883	SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
91	0.0004	0.00044083595275879	SELECT category_id FROM products_categories WHERE product_id = '3643'
92	0.0006	0.00059103965759277	SELECT * FROM categories WHERE id = '26'
93	0.0079	0.007896900177002	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.00060105323791504	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
95	0.0005	0.00052714347839355	SELECT id FROM categories WHERE parent_id = '26'
96	0.0098	0.0098328590393066	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.0016	0.0015890598297119	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.0018	0.0018129348754883	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.0016	0.0015809535980225	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
100	0.0018	0.0018291473388672	SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
101	0.0024	0.0024409294128418	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
102	0.0032	0.0032129287719727	SELECT * FROM product_image_select WHERE product_id = '3643'
103	0.0017	0.0016930103302002	SELECT * FROM productcustomimages WHERE product_id = '3643'
104	0.0008	0.00076794624328613	SELECT * FROM productfeeds WHERE product_id = '3643' ORDER BY item_date DESC
105	0.0016	0.001615047454834	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
106	0.0011	0.0011131763458252	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3643' AND t.hidden = 0 AND display_product = 1
107	0.0006	0.0005650520324707	SELECT * FROM tags WHERE id = '216'
108	0.0071	0.0071091651916504	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '216' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
109	0.0049	0.0049009323120117	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '216' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
110	0.0040	0.0040090084075928	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '216' 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.0013	0.0013449192047119	SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
112	0.0011	0.0010709762573242	SELECT * FROM productamazoncontent WHERE product_id = '3643'
113	0.0012	0.0012431144714355	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 = '3643' GROUP BY o.product_id
114	0.0085	0.0085000991821289	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 = '3643' GROUP BY n.displayname ORDER BY n.displayname DESC
115	0.0010	0.001007080078125	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
116	0.0020	0.0020468235015869	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
117	0.0006	0.00063896179199219	SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
118	0.0006	0.0006110668182373	SELECT * FROM productoffers WHERE product_id = '3643' AND price > 0 ORDER BY price ASC LIMIT 1
119	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = 3643 ORDER BY price ASC LIMIT 1
120	0.0008	0.00076198577880859	SELECT value FROM productattributes WHERE product_id = '3643' AND name = 'ListPriceAmount'
121	0.0006	0.00063610076904297	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 = '3643' GROUP BY o.product_id
122	0.0010	0.0009760856628418	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 = '3643' GROUP BY n.displayname ORDER BY n.displayname DESC
123	0.0005	0.0004570484161377	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
124	0.0007	0.00066995620727539	SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125	0.0007	0.00071978569030762	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3643' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
126	0.0006	0.00061202049255371	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
127	0.0112	0.011229038238525	SELECT *, MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AND 3643 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
128	0.0006	0.00057387351989746	SELECT *, MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
129	0.0005	0.00045895576477051	SELECT *, MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('� thé liberty' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
130	0.0004	0.00043511390686035	SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
131	0.0004	0.00037908554077148	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
132	0.0005	0.00053095817565918	SELECT * FROM product_image_select WHERE product_id = '3643'
133	0.0004	0.00037693977355957	SELECT * FROM productcustomimages WHERE product_id = '3643'
134	0.0005	0.00048184394836426	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 = '3643' GROUP BY o.product_id
135	0.0006	0.00060009956359863	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 = '3643' GROUP BY n.displayname ORDER BY n.displayname DESC
136	0.0004	0.0003960132598877	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
137	0.0008	0.00081992149353027	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
138	0.0004	0.00040888786315918	SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0003	0.00031685829162598	SELECT * FROM productoffers WHERE product_id = '3643' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0003	0.00026583671569824	SELECT * FROM productoffers WHERE product_id = 3643 ORDER BY price ASC LIMIT 1
141	0.0004	0.00040602684020996	SELECT value FROM productattributes WHERE product_id = '3643' AND name = 'ListPriceAmount'
142	0.0005	0.00047492980957031	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 = '3643' GROUP BY o.product_id
143	0.0006	0.00055408477783203	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 = '3643' GROUP BY n.displayname ORDER BY n.displayname DESC
144	0.0004	0.00037097930908203	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
145	0.0006	0.00056004524230957	SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146	0.0006	0.00062394142150879	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3643' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
147	0.0089	0.008864164352417	SELECT *, MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AND 3643 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
148	0.0005	0.00049901008605957	SELECT *, MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
149	0.0004	0.00043797492980957	SELECT *, MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('premier housewares bo�te' IN BOOLEAN MODE) AND 3643 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
150	0.0004	0.00042200088500977	SELECT * FROM productimages WHERE product_id = '3643' ORDER BY sortorder ASC
151	0.0004	0.00039100646972656	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3643' AND p.id = pi.product_id ORDER BY pi.sortorder
152	0.0005	0.0005338191986084	SELECT * FROM product_image_select WHERE product_id = '3643'
153	0.0003	0.00034594535827637	SELECT * FROM productcustomimages WHERE product_id = '3643'
154	0.0005	0.00045299530029297	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 = '3643' GROUP BY o.product_id
155	0.0006	0.00055384635925293	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 = '3643' GROUP BY n.displayname ORDER BY n.displayname DESC
156	0.0003	0.00033903121948242	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
157	0.0007	0.00072383880615234	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
158	0.0003	0.00032711029052734	SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
159	0.0003	0.00034809112548828	SELECT * FROM productoffers WHERE product_id = '3643' AND price > 0 ORDER BY price ASC LIMIT 1
160	0.0003	0.00028896331787109	SELECT * FROM productoffers WHERE product_id = 3643 ORDER BY price ASC LIMIT 1
161	0.0003	0.00033092498779297	SELECT value FROM productattributes WHERE product_id = '3643' AND name = 'ListPriceAmount'
162	0.0004	0.00038814544677734	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 = '3643' GROUP BY o.product_id
163	0.0006	0.00055909156799316	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 = '3643' GROUP BY n.displayname ORDER BY n.displayname DESC
164	0.0003	0.00033307075500488	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
165	0.0005	0.00045299530029297	SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166	0.0005	0.00052595138549805	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3643' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
167	0.0004	0.00042295455932617	SELECT * FROM productimages WHERE product_id = '837' ORDER BY sortorder ASC
168	0.0004	0.00044894218444824	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '837' AND p.id = pi.product_id ORDER BY pi.sortorder
169	0.0005	0.00049304962158203	SELECT * FROM product_image_select WHERE product_id = '837'
170	0.0003	0.00034785270690918	SELECT * FROM productcustomimages WHERE product_id = '837'
171	0.0005	0.00050616264343262	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 = '837' GROUP BY o.product_id
172	0.0006	0.00056099891662598	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 = '837' GROUP BY n.displayname ORDER BY n.displayname DESC
173	0.0004	0.00039005279541016	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
174	0.0007	0.00071620941162109	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '837' AND a.name = n.originalname
175	0.0003	0.00029897689819336	SELECT * FROM productoffers WHERE product_id = '837' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0003	0.00031590461730957	SELECT * FROM productoffers WHERE product_id = '837' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0003	0.00026607513427734	SELECT * FROM productoffers WHERE product_id = 837 ORDER BY price ASC LIMIT 1
178	0.0003	0.00029397010803223	SELECT value FROM productattributes WHERE product_id = '837' AND name = 'ListPriceAmount'
179	0.0003	0.00033307075500488	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 = '837' GROUP BY o.product_id
180	0.0006	0.0005500316619873	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 = '837' GROUP BY n.displayname ORDER BY n.displayname DESC
181	0.0003	0.00033903121948242	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 837
182	0.0004	0.00044083595275879	SELECT value FROM productattributes WHERE product_id = '837' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183	0.0007	0.00065302848815918	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '837' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
184	0.0005	0.00050902366638184	SELECT * FROM productimages WHERE product_id = '3699' ORDER BY sortorder ASC
185	0.0004	0.00039196014404297	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3699' AND p.id = pi.product_id ORDER BY pi.sortorder
186	0.0006	0.00055694580078125	SELECT * FROM product_image_select WHERE product_id = '3699'
187	0.0004	0.00038504600524902	SELECT * FROM productcustomimages WHERE product_id = '3699'
188	0.0005	0.00053787231445312	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 = '3699' GROUP BY o.product_id
189	0.0006	0.00056910514831543	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 = '3699' GROUP BY n.displayname ORDER BY n.displayname DESC
190	0.0003	0.00034689903259277	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3699
191	0.0009	0.00087594985961914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3699' AND a.name = n.originalname
192	0.0003	0.00032401084899902	SELECT * FROM productoffers WHERE product_id = '3699' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0003	0.00034403800964355	SELECT * FROM productoffers WHERE product_id = '3699' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0003	0.00027298927307129	SELECT * FROM productoffers WHERE product_id = 3699 ORDER BY price ASC LIMIT 1
195	0.0003	0.00034689903259277	SELECT value FROM productattributes WHERE product_id = '3699' AND name = 'ListPriceAmount'
196	0.0004	0.0003960132598877	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 = '3699' GROUP BY o.product_id
197	0.0006	0.0005791187286377	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 = '3699' GROUP BY n.displayname ORDER BY n.displayname DESC
198	0.0003	0.00034308433532715	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3699
199	0.0005	0.00045204162597656	SELECT value FROM productattributes WHERE product_id = '3699' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200	0.0007	0.00065398216247559	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3699' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
201	0.0015	0.001474142074585	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3643') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
202	0.0163	0.016270160675049	SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'amz' AND p.id <> '3643' ORDER BY RAND()
203	0.0006	0.00061893463134766	SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'ebay' AND p.id <> '3643' ORDER BY RAND()
204	0.0005	0.00052618980407715	SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '26' AND pc.prod_type = 'custom' AND p.id <> '3643' ORDER BY RAND()
205	0.0005	0.00046420097351074	SELECT * FROM productimages WHERE product_id = '4114' ORDER BY sortorder ASC
206	0.0006	0.00063300132751465	SELECT * FROM product_image_select WHERE product_id = '4114'
207	0.0004	0.00037598609924316	SELECT * FROM productcustomimages WHERE product_id = '4114'
208	0.0010	0.00096988677978516	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4114' AND a.name = n.originalname
209	0.0005	0.0004580020904541	SELECT * FROM productoffers WHERE product_id = '4114' AND merchantid = 'A1X6FK5RDHNB96'
210	0.0004	0.00037288665771484	SELECT * FROM productoffers WHERE product_id = '4114' AND price > 0 ORDER BY price ASC LIMIT 1
211	0.0003	0.00031399726867676	SELECT * FROM productoffers WHERE product_id = 4114 ORDER BY price ASC LIMIT 1
212	0.0004	0.00039792060852051	SELECT value FROM productattributes WHERE product_id = '4114' AND name = 'ListPriceAmount'
213	0.0004	0.00042104721069336	SELECT value FROM productattributes WHERE product_id = '4114' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214	0.0005	0.00046801567077637	SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
215	0.0006	0.00058507919311523	SELECT * FROM product_image_select WHERE product_id = '775'
216	0.0004	0.00039100646972656	SELECT * FROM productcustomimages WHERE product_id = '775'
217	0.0010	0.00095891952514648	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '775' AND a.name = n.originalname
218	0.0005	0.00045514106750488	SELECT * FROM productoffers WHERE product_id = '775' AND merchantid = 'A1X6FK5RDHNB96'
219	0.0004	0.00042915344238281	SELECT * FROM productoffers WHERE product_id = '775' AND price > 0 ORDER BY price ASC LIMIT 1
220	0.0005	0.00049400329589844	SELECT * FROM productoffers WHERE product_id = 775 ORDER BY price ASC LIMIT 1
221	0.0005	0.00045204162597656	SELECT value FROM productattributes WHERE product_id = '775' AND name = 'ListPriceAmount'
222	0.0004	0.00035190582275391	SELECT value FROM productattributes WHERE product_id = '775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223	0.0004	0.00043392181396484	SELECT * FROM productimages WHERE product_id = '3531' ORDER BY sortorder ASC
224	0.0006	0.00061678886413574	SELECT * FROM product_image_select WHERE product_id = '3531'
225	0.0004	0.00044488906860352	SELECT * FROM productcustomimages WHERE product_id = '3531'
226	0.0011	0.0011210441589355	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3531' AND a.name = n.originalname
227	0.0005	0.00048995018005371	SELECT * FROM productoffers WHERE product_id = '3531' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0004	0.00040483474731445	SELECT * FROM productoffers WHERE product_id = '3531' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0004	0.0004429817199707	SELECT * FROM productoffers WHERE product_id = 3531 ORDER BY price ASC LIMIT 1
230	0.0006	0.00057506561279297	SELECT value FROM productattributes WHERE product_id = '3531' AND name = 'ListPriceAmount'
231	0.0005	0.00054311752319336	SELECT value FROM productattributes WHERE product_id = '3531' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232	0.0005	0.00048708915710449	SELECT * FROM productimages WHERE product_id = '927' ORDER BY sortorder ASC
233	0.0007	0.00066184997558594	SELECT * FROM product_image_select WHERE product_id = '927'
234	0.0005	0.00046586990356445	SELECT * FROM productcustomimages WHERE product_id = '927'
235	0.0008	0.00078797340393066	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '927' AND a.name = n.originalname
236	0.0007	0.00070595741271973	SELECT * FROM productoffers WHERE product_id = '927' AND merchantid = 'A1X6FK5RDHNB96'
237	0.0004	0.00040507316589355	SELECT * FROM productoffers WHERE product_id = '927' AND price > 0 ORDER BY price ASC LIMIT 1
238	0.0006	0.00063204765319824	SELECT * FROM productoffers WHERE product_id = 927 ORDER BY price ASC LIMIT 1
239	0.0005	0.00046300888061523	SELECT value FROM productattributes WHERE product_id = '927' AND name = 'ListPriceAmount'
240	0.0004	0.00038599967956543	SELECT value FROM productattributes WHERE product_id = '927' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241	0.0009	0.00094914436340332	SELECT id,asin FROM products WHERE parent_id = 3643
242	0.0008	0.00084114074707031	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3644
243	0.0007	0.00069999694824219	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3644
244	0.0004	0.00038480758666992	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3645
245	0.0004	0.0003819465637207	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3645
246	0.0004	0.0003972053527832	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3643' ORDER BY timestamp DESC
247	0.0004	0.0003809928894043	SELECT category_id FROM products_categories WHERE product_id = '3643'
248	0.0005	0.00047206878662109	SELECT * FROM categories WHERE id = '26'
249	0.0058	0.0057728290557861	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
250	0.0004	0.00038003921508789	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
251	0.0003	0.00031590461730957	SELECT id FROM categories WHERE parent_id = '26'
252	0.0053	0.0052788257598877	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
253	0.0006	0.00055789947509766	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
254	0.0006	0.00058293342590332	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
255	0.0004	0.00041699409484863	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
256	0.0008	0.00081586837768555	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
257	0.0005	0.00050497055053711	SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
258	0.0003	0.0003209114074707	SELECT * FROM productoffers WHERE product_id = '3643' AND price > 0 ORDER BY price ASC LIMIT 1
259	0.0004	0.00037908554077148	SELECT * FROM productoffers WHERE product_id = 3643 ORDER BY price ASC LIMIT 1
260	0.0004	0.00037813186645508	SELECT value FROM productattributes WHERE product_id = '3643' AND name = 'ListPriceAmount'
261	0.0005	0.0004730224609375	SELECT * FROM products WHERE id = '3643'
262	0.0004	0.00044989585876465	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 = '3643' GROUP BY o.product_id
263	0.0006	0.00059199333190918	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 = '3643' GROUP BY n.displayname ORDER BY n.displayname DESC
264	0.0004	0.00043702125549316	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3643
265	0.0005	0.00053095817565918	SELECT value FROM productattributes WHERE product_id = '3643' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266	0.0022	0.0022108554840088	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3643' AND a.name = n.originalname
267	0.0006	0.00057506561279297	SELECT * FROM productoffers WHERE product_id = '3643' AND merchantid = 'A1X6FK5RDHNB96'
268	0.0006	0.00063490867614746	SELECT * FROM productoffers WHERE product_id = '3643' AND price > 0 ORDER BY price ASC LIMIT 1
269	0.0007	0.00066280364990234	SELECT * FROM productoffers WHERE product_id = 3643 ORDER BY price ASC LIMIT 1
270	0.0006	0.00064802169799805	SELECT value FROM productattributes WHERE product_id = '3643' AND name = 'ListPriceAmount'
271	0.0015	0.0014910697937012	SELECT DISTINCT (name) FROM productoptions
272	0.0012	0.0012431144714355	SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 3643))
273	0.0010	0.00099301338195801	SELECT o.value, o.name FROM products p, productoptions o WHERE p.parent_id = 3643 AND p.id = o.product_id GROUP BY o.value ORDER BY o.value ASC
274	0.0045	0.0045459270477295	SELECT * FROM translationsfilter
275	0.0008	0.00079011917114258	SELECT category_id FROM products_categories WHERE product_id = '3643' AND prod_type = 'amz'
276	0.0006	0.00062799453735352	SELECT parent_id FROM categories WHERE id = '26'
277	0.0005	0.00047802925109863	SELECT * FROM categories WHERE id = '26'
278	0.0121	0.012110948562622	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.0007	0.00065994262695312	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
280	0.0005	0.00045394897460938	SELECT id FROM categories WHERE parent_id = '26'
281	0.0079	0.0079391002655029	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.0009	0.00086593627929688	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.0008	0.00076794624328613	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.0005	0.00047111511230469	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
285	0.0005	0.00054812431335449	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
286	0.0005	0.00045895576477051	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
287	0.0004	0.00037097930908203	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
288	0.0147	0.014704942703247	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
289	0.0009	0.00094008445739746	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
290	0.0006	0.00058889389038086	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
291	0.0007	0.00066709518432617	SELECT * FROM products WHERE id = 1626
292	0.0005	0.0004730224609375	SELECT * FROM products WHERE id = 4041
293	0.0005	0.00053977966308594	SELECT * FROM products WHERE id = 4312
294	0.0008	0.00077509880065918	SELECT * FROM products WHERE id = 777
295	0.0005	0.00054812431335449	SELECT * FROM products WHERE id = 3881
296	0.0004	0.00042295455932617	SELECT * FROM products WHERE id = 4213
297	0.0005	0.00046396255493164	SELECT * FROM products WHERE id = '1626'
298	0.0006	0.0005638599395752	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
299	0.0007	0.00071310997009277	SELECT * FROM product_image_select WHERE product_id = '1626'
300	0.0004	0.00042009353637695	SELECT * FROM productcustomimages WHERE product_id = '1626'
301	0.0008	0.00082492828369141	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
302	0.0005	0.00052905082702637	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
303	0.0004	0.00037717819213867	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
304	0.0005	0.00050711631774902	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305	0.0005	0.00050497055053711	SELECT * FROM products WHERE id = '4041'
306	0.0005	0.00054407119750977	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
307	0.0006	0.00058293342590332	SELECT * FROM product_image_select WHERE product_id = '4041'
308	0.0003	0.00034403800964355	SELECT * FROM productcustomimages WHERE product_id = '4041'
309	0.0010	0.0010249614715576	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
310	0.0004	0.00040078163146973	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
311	0.0003	0.00033688545227051	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
312	0.0005	0.00051712989807129	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313	0.0004	0.00042486190795898	SELECT * FROM products WHERE id = '4312'
314	0.0005	0.00048589706420898	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
315	0.0005	0.00049304962158203	SELECT * FROM product_image_select WHERE product_id = '4312'
316	0.0003	0.00033092498779297	SELECT * FROM productcustomimages WHERE product_id = '4312'
317	0.0010	0.00098514556884766	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
318	0.0004	0.00042414665222168	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
319	0.0003	0.00033187866210938	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
320	0.0004	0.00035309791564941	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321	0.0005	0.00048494338989258	SELECT * FROM products WHERE id = '777'
322	0.0005	0.00050997734069824	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
323	0.0006	0.00057697296142578	SELECT * FROM product_image_select WHERE product_id = '777'
324	0.0004	0.0003509521484375	SELECT * FROM productcustomimages WHERE product_id = '777'
325	0.0011	0.0010809898376465	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
326	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
327	0.0004	0.0003669261932373	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
328	0.0004	0.00039982795715332	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329	0.0004	0.00042510032653809	SELECT * FROM products WHERE id = '3881'
330	0.0004	0.00043606758117676	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
331	0.0006	0.00056195259094238	SELECT * FROM product_image_select WHERE product_id = '3881'
332	0.0003	0.00032401084899902	SELECT * FROM productcustomimages WHERE product_id = '3881'
333	0.0010	0.00097799301147461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
334	0.0004	0.00041103363037109	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
335	0.0004	0.00035905838012695	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
336	0.0004	0.00035405158996582	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337	0.0005	0.0004880428314209	SELECT * FROM products WHERE id = '4213'
338	0.0005	0.00049090385437012	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
339	0.0006	0.00060105323791504	SELECT * FROM product_image_select WHERE product_id = '4213'
340	0.0004	0.00037598609924316	SELECT * FROM productcustomimages WHERE product_id = '4213'
341	0.0010	0.0010318756103516	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
342	0.0004	0.00040698051452637	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
343	0.0004	0.00036907196044922	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
344	0.0004	0.00040411949157715	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345	0.0008	0.00081300735473633	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
346	0.0008	0.00079798698425293	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
347	0.0019	0.0019049644470215	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
348	0.0007	0.00066995620727539	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
349	0.0005	0.0004730224609375	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
350	0.0005	0.00052690505981445	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Premier Housewares Boîte à thé Liberty

Premier Housewares émail Boîte à thé, Pu...

Maison by Premier - Boîte à thé Madison ...

TOPBATHY Boîte de Rangement à café en Bo...

MERVY - Boîte à thé - Boîte multifonctio...

MOTZU 5 Pièces Boîte à Thé Mini Boîte de...

Boîte à thé moderne grise avec poignées ...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 2.3117690086365 seconds

Query Debug - 350 Database Queries. Total time 1.9275 seconds

Premier Housewares Boîte à thé Liberty

Related Products

Premier Housewares émail Boîte à thé, Pu...

Maison by Premier - Boîte à thé Madison ...

TOPBATHY Boîte de Rangement à café en Bo...

MERVY - Boîte à thé - Boîte multifonctio...

MOTZU 5 Pièces Boîte à Thé Mini Boîte de...

Boîte à thé moderne grise avec poignées ...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 2.3117690086365 seconds

Query Debug - 350 Database Queries. Total time 1.9275 seconds