Novastyl - 8010072 - Earl - Boîte à Thé - Gris/Blanc

Price: Click Button for Price

As of 2022-06-24 16:49:58 UTC (more info)

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

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

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

Product Features

NOVAStyl 3164229855906. Couleur: Blanc Matériau du boîtier/corps: Bois. Largeur: 26 cm Profondeur: 17,8 cm Hauteur: 7,5 cm Boîte à thé pour ranger et présenter les sachets de thé Six compartiments Matière : bois

Customer Reviews

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

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.6618361473083	289	0.9846	0

No Amazon API Requests Made.

App Debug - Total Time 1.6618361473083 seconds

Number	Time From Start	Name	Description
1	0.65495896339417	Initialise	Initialise FSB Function
2	0.65683603286743	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.68192315101624	Start of getCategoryListByGroup Function	Before first category groups query
4	0.68273901939392	After initial query	Before first category groups query
5	0.68274116516113	Get Category List for Group	Before the call to getCategoryList function
6	0.68274402618408	Start of GetCategoryList function	Start of the function
7	0.68274807929993	Before getting categories	Query to get specific category list
8	0.68378901481628	After getting categories	Query to get specific category list
9	0.6837899684906	Before getting category custom	Before call to function getCategoryCustom
10	0.70343708992004	After getting category custom	After call to function getCategoryCustom
11	0.70344305038452	Before getting category custom	Before call to function getCategoryCustom
12	0.71611309051514	After getting category custom	After call to function getCategoryCustom
13	0.7161180973053	Before getting category custom	Before call to function getCategoryCustom
14	0.72405600547791	After getting category custom	After call to function getCategoryCustom
15	0.72406005859375	Before getting category custom	Before call to function getCategoryCustom
16	0.72997903823853	After getting category custom	After call to function getCategoryCustom
17	0.72998094558716	Before getting category custom	Before call to function getCategoryCustom
18	0.73623108863831	After getting category custom	After call to function getCategoryCustom
19	0.73623299598694	Before getting category custom	Before call to function getCategoryCustom
20	0.74262499809265	After getting category custom	After call to function getCategoryCustom
21	0.74262714385986	End of GetCategoryList function	End of the function
22	0.74263405799866	Get Category List for Group	Before the call to getCategoryList function
23	0.74263715744019	Start of GetCategoryList function	Start of the function
24	0.74263906478882	Before getting categories	Query to get specific category list
25	0.74338006973267	End of getCategoryListByGroup Function	Before return()
26	1.3139390945435	App Controller End	End of the App controller (called before the controller of every page)
27	1.3144481182098	Product Start	Start of the product info controller
28	1.3162310123444	Cache file not found	Starting get product details
29	1.3599591255188	Related products	Start getting related products if enabled
30	1.3599610328674	Related Products Start	Before the related products are found
31	1.3599629402161	Related Products Keywords	Before the related product keywords are found
32	1.3599669933319	Create Keyword List Function	Start of function
33	1.3600039482117	Create Keyword List Function	After looping provided content - 18 keywords found
34	1.3609001636505	Create Keyword List Function	After looping initial keyword list - 16 keywords remaining
35	1.3609070777893	Create Keyword List Function	After reducing keyword list
36	1.3609530925751	Create Keyword List Function	After selecting by scoring keywords
37	1.3609571456909	Create Keyword List Function	After final loop of keywords
38	1.3609600067139	Related Products Keywords	After the related product keywords are found
39	1.5086400508881	Related Products End	After the related products are found
40	1.5771131515503	Product End	End of the product info controller (Product Info)
41	1.5784909725189	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.5797951221466	Before Get Options	Before the call to getOptions in the tpl class
43	1.6403141021729	After Get Options	After the call to getOptions in the tpl class
44	1.6404531002045	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.6404941082001	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.6468210220337	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.6468269824982	Product Info: Before Template Display	Before the template is displayed
48	1.6618130207062	Product Info: After Template Display	After the template is displayed
49	1.6618249416351	Finalizing debug	Before the debug is output to the page.
50	1.6618349552155	End of App	This is the end of the app logging, final timestamp

Query Debug - 289 Database Queries. Total time 0.9846 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.116.15.3\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722058121'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'novastyl-8010072-earl-bote-the-grisblanc' LIMIT 1
SELECT id FROM products WHERE pagename = 'novastyl-8010072-earl-bote-the-grisblanc' 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 = 'novastyl-8010072-earl-bote-the-grisblanc'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.116.15.3') >= INET_ATON(ip_start) AND INET_ATON('18.116.15.3') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'novastyl-8010072-earl-bote-the-grisblanc'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 773
SELECT * FROM manufacturers WHERE id = '193'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '193'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '193' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '193' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '773' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '193'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '193'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '193'
SELECT category_id FROM products_categories WHERE product_id = '773'
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 = '773' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '773'
SELECT * FROM productcustomimages WHERE product_id = '773'
SELECT * FROM productfeeds WHERE product_id = '773' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '773' 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 = '773' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '773'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '773' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '773' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '773' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 773
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '773'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT *, MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AND 773 <> 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é grisblanc' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AND 773 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '1014' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1014'
SELECT * FROM productcustomimages WHERE product_id = '1014'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1014' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1014' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1014' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1014' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1115' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1115'
SELECT * FROM productcustomimages WHERE product_id = '1115'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1115' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1115' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1115' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1115' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2290'
SELECT * FROM productcustomimages WHERE product_id = '2290'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2290' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '773') 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 <> '773' 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 <> '773' 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 <> '773' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1418'
SELECT * FROM productcustomimages WHERE product_id = '1418'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1418' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '3749' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3749' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3749'
SELECT * FROM productcustomimages WHERE product_id = '3749'
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 = '3749'
                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     = '3749'
                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 = 3749
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3749' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3749' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3749' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3749
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3749'
                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 = '3749'
                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     = '3749'
                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 = 3749
SELECT value FROM productattributes WHERE product_id = '3749' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3749'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3749'
                  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 = '3077' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3077' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3077'
SELECT * FROM productcustomimages WHERE product_id = '3077'
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 = '3077'
                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     = '3077'
                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 = 3077
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3077' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3077' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3077' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3077
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3077'
                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 = '3077'
                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     = '3077'
                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 = 3077
SELECT value FROM productattributes WHERE product_id = '3077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3077'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT id,asin FROM products WHERE parent_id = 773
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '773' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '773'
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 = '773' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '773' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '773' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 773
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '773'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '773'
SELECT value FROM productattributes WHERE product_id = '773' 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 = '773' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '773' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '773' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 773
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '773'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '773' 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.0031	0.0031149387359619	SELECT parameter, value FROM parameters
2	0.0054	0.0054488182067871	SELECT * FROM `bad_bots`
3	0.0007	0.00069403648376465	SET time_zone = 'Europe/London'
4	0.0015	0.0014641284942627	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0011	0.0011298656463623	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.116.15.3\";}'
6	0.0010	0.0010139942169189	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722058121'
7	0.0008	0.00078892707824707	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0004	0.00040316581726074	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0006	0.00056600570678711	SELECT id FROM pages WHERE pagename = 'novastyl-8010072-earl-bote-the-grisblanc' LIMIT 1
10	0.0006	0.00059604644775391	SELECT id FROM products WHERE pagename = 'novastyl-8010072-earl-bote-the-grisblanc' AND hidden = 0 LIMIT 1
11	0.0014	0.0013759136199951	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0224	0.022393941879272	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0009	0.00093388557434082	SELECT * FROM pages WHERE pagename = 'novastyl-8010072-earl-bote-the-grisblanc'
14	0.0008	0.00080299377441406	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0010	0.0010230541229248	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0067	0.0067250728607178	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17	0.0008	0.00079083442687988	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0006	0.0005638599395752	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0006	0.00058293342590332	SELECT id FROM categories WHERE parent_id = '26'
20	0.0075	0.00748610496521	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0009	0.00086784362792969	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0009	0.00091099739074707	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0007	0.00074100494384766	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0008	0.00079989433288574	SELECT * FROM categorygroups WHERE id = '1'
25	0.0039	0.0038928985595703	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0007	0.0007479190826416	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0006	0.00059294700622559	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0006	0.00060296058654785	SELECT id FROM categories WHERE parent_id = '27'
29	0.0041	0.0040988922119141	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
30	0.0008	0.00075411796569824	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0007	0.00070619583129883	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0006	0.00059080123901367	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00053715705871582	SELECT * FROM categorygroups WHERE id = '1'
34	0.0016	0.0016491413116455	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0008	0.00075101852416992	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0006	0.00058984756469727	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0006	0.00056290626525879	SELECT id FROM categories WHERE parent_id = '28'
38	0.0019	0.0018510818481445	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0007	0.00066494941711426	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0007	0.00067400932312012	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0005	0.00053095817565918	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.00054287910461426	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00078797340393066	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0006	0.00055289268493652	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0005	0.00046515464782715	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00049495697021484	SELECT id FROM categories WHERE parent_id = '29'
47	0.0008	0.00083208084106445	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0007	0.00071001052856445	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0007	0.00073409080505371	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0007	0.00066781044006348	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0006	0.00058603286743164	SELECT * FROM categorygroups WHERE id = '1'
52	0.0008	0.00078701972961426	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53	0.0007	0.00068807601928711	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0005	0.00053501129150391	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0006	0.00059700012207031	SELECT id FROM categories WHERE parent_id = '30'
56	0.0009	0.00091099739074707	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0007	0.00067687034606934	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0007	0.00073099136352539	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0006	0.00063896179199219	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0006	0.00059604644775391	SELECT * FROM categorygroups WHERE id = '1'
61	0.0008	0.0008399486541748	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0007	0.00068187713623047	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0006	0.00060296058654785	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0006	0.00056600570678711	SELECT id FROM categories WHERE parent_id = '31'
65	0.0009	0.00094008445739746	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0007	0.00068998336791992	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0008	0.00077104568481445	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0006	0.00063800811767578	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0006	0.00057482719421387	SELECT * FROM categorygroups WHERE id = '1'
70	0.0007	0.00072884559631348	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0019	0.0019159317016602	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0007	0.0007021427154541	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0016	0.0016241073608398	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
74	0.0011	0.0011358261108398	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0034	0.0033860206604004	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0026	0.0026400089263916	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.5565	0.55649280548096	SELECT * FROM ipgeocountries WHERE INET_ATON('18.116.15.3') >= INET_ATON(ip_start) AND INET_ATON('18.116.15.3') <= INET_ATON(ip_end)
78	0.0011	0.0011491775512695	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0004	0.00044417381286621	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0007	0.00067901611328125	SELECT * FROM products WHERE pagename = 'novastyl-8010072-earl-bote-the-grisblanc'
81	0.0004	0.00043582916259766	UPDATE products SET viewcount = viewcount + 1 WHERE id = 773
82	0.0005	0.00051283836364746	SELECT * FROM manufacturers WHERE id = '193'
83	0.0004	0.00043797492980957	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '193'
84	0.0004	0.00042605400085449	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '193' LIMIT 1
85	0.0005	0.00052785873413086	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '193' ORDER BY RAND() LIMIT 1
86	0.0004	0.0004270076751709	SELECT * FROM productimages WHERE product_id = '773' ORDER BY sortorder ASC
87	0.0005	0.00046396255493164	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '193'
88	0.0004	0.00044679641723633	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '193' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0003	0.00033688545227051	SELECT * FROM manufacturerimages WHERE manufacturer_id = '193'
90	0.0004	0.00043511390686035	SELECT category_id FROM products_categories WHERE product_id = '773'
91	0.0005	0.00050783157348633	SELECT * FROM categories WHERE id = '26'
92	0.0054	0.0053820610046387	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
93	0.0005	0.00047516822814941	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
94	0.0004	0.00037503242492676	SELECT id FROM categories WHERE parent_id = '26'
95	0.0059	0.005885124206543	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
96	0.0006	0.00063085556030273	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
97	0.0006	0.00058317184448242	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
98	0.0005	0.00049495697021484	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
99	0.0005	0.00049996376037598	SELECT * FROM productimages WHERE product_id = '773' ORDER BY sortorder ASC
100	0.0007	0.00066900253295898	SELECT * FROM product_image_select WHERE product_id = '773'
101	0.0004	0.00042080879211426	SELECT * FROM productcustomimages WHERE product_id = '773'
102	0.0005	0.00046205520629883	SELECT * FROM productfeeds WHERE product_id = '773' ORDER BY item_date DESC
103	0.0007	0.0007481575012207	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '773' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104	0.0007	0.00069594383239746	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '773' AND t.hidden = 0 AND display_product = 1
105	0.0004	0.00042510032653809	SELECT * FROM tags WHERE id = '81'
106	0.0027	0.0026960372924805	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
107	0.0030	0.002979040145874	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
108	0.0024	0.002446174621582	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109	0.0006	0.00063300132751465	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
110	0.0006	0.00056600570678711	SELECT * FROM productamazoncontent WHERE product_id = '773'
111	0.0009	0.00091218948364258	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '773' AND a.name = n.originalname
112	0.0010	0.00098705291748047	SELECT * FROM productoffers WHERE product_id = '773' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0017	0.0016958713531494	SELECT * FROM productoffers WHERE product_id = '773' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0018	0.0017650127410889	SELECT * FROM productoffers WHERE product_id = 773 ORDER BY price ASC LIMIT 1
115	0.0016	0.0016469955444336	SELECT value FROM productattributes WHERE product_id = '773' AND name = 'ListPriceAmount'
116	0.0022	0.0022258758544922	SELECT value FROM productattributes WHERE product_id = '773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0022	0.0022118091583252	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
118	0.0161	0.016083002090454	SELECT *, MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AND 773 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119	0.0024	0.0023930072784424	SELECT *, MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
120	0.0023	0.002269983291626	SELECT *, MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('� thé grisblanc' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
121	0.0125	0.012481927871704	SELECT *, MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AND 773 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
122	0.0023	0.0022809505462646	SELECT *, MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
123	0.0023	0.002255916595459	SELECT *, MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('novastyl 8010072 earl' IN BOOLEAN MODE) AND 773 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
124	0.0021	0.0020599365234375	SELECT * FROM productimages WHERE product_id = '1014' ORDER BY sortorder ASC
125	0.0022	0.0022330284118652	SELECT * FROM product_image_select WHERE product_id = '1014'
126	0.0023	0.0023140907287598	SELECT * FROM productcustomimages WHERE product_id = '1014'
127	0.0024	0.002396821975708	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1014' AND a.name = n.originalname
128	0.0020	0.0019888877868652	SELECT * FROM productoffers WHERE product_id = '1014' AND merchantid = 'A1X6FK5RDHNB96'
129	0.0023	0.0022749900817871	SELECT * FROM productoffers WHERE product_id = '1014' AND price > 0 ORDER BY price ASC LIMIT 1
130	0.0022	0.002234935760498	SELECT value FROM productattributes WHERE product_id = '1014' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0023	0.0022721290588379	SELECT * FROM productimages WHERE product_id = '1115' ORDER BY sortorder ASC
132	0.0022	0.0022339820861816	SELECT * FROM product_image_select WHERE product_id = '1115'
133	0.0022	0.002249002456665	SELECT * FROM productcustomimages WHERE product_id = '1115'
134	0.0035	0.0035490989685059	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1115' AND a.name = n.originalname
135	0.0022	0.0022439956665039	SELECT * FROM productoffers WHERE product_id = '1115' AND merchantid = 'A1X6FK5RDHNB96'
136	0.0023	0.0022640228271484	SELECT * FROM productoffers WHERE product_id = '1115' AND price > 0 ORDER BY price ASC LIMIT 1
137	0.0010	0.0010209083557129	SELECT value FROM productattributes WHERE product_id = '1115' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138	0.0010	0.00095295906066895	SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
139	0.0014	0.0013859272003174	SELECT * FROM product_image_select WHERE product_id = '2290'
140	0.0008	0.00077414512634277	SELECT * FROM productcustomimages WHERE product_id = '2290'
141	0.0025	0.0025031566619873	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
142	0.0012	0.0012049674987793	SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0007	0.00074410438537598	SELECT * FROM productoffers WHERE product_id = '2290' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0010	0.00095891952514648	SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
145	0.0027	0.0026519298553467	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '773') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
146	0.0267	0.026692152023315	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 <> '773' ORDER BY RAND()
147	0.0012	0.0011639595031738	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 <> '773' ORDER BY RAND()
148	0.0007	0.00066494941711426	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 <> '773' ORDER BY RAND()
149	0.0006	0.00061607360839844	SELECT * FROM productimages WHERE product_id = '1418' ORDER BY sortorder ASC
150	0.0008	0.00081205368041992	SELECT * FROM product_image_select WHERE product_id = '1418'
151	0.0005	0.00049495697021484	SELECT * FROM productcustomimages WHERE product_id = '1418'
152	0.0013	0.001291036605835	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1418' AND a.name = n.originalname
153	0.0006	0.00060200691223145	SELECT * FROM productoffers WHERE product_id = '1418' AND merchantid = 'A1X6FK5RDHNB96'
154	0.0005	0.00050902366638184	SELECT * FROM productoffers WHERE product_id = '1418' AND price > 0 ORDER BY price ASC LIMIT 1
155	0.0005	0.00053906440734863	SELECT value FROM productattributes WHERE product_id = '1418' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156	0.0006	0.00064897537231445	SELECT * FROM productimages WHERE product_id = '3749' ORDER BY sortorder ASC
157	0.0010	0.0010230541229248	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3749' AND p.id = pi.product_id ORDER BY pi.sortorder
158	0.0008	0.00083208084106445	SELECT * FROM product_image_select WHERE product_id = '3749'
159	0.0007	0.00067591667175293	SELECT * FROM productcustomimages WHERE product_id = '3749'
160	0.0007	0.00073599815368652	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 = '3749' GROUP BY o.product_id
161	0.0010	0.00099802017211914	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 = '3749' GROUP BY n.displayname ORDER BY n.displayname DESC
162	0.0007	0.00066304206848145	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3749
163	0.0011	0.0010981559753418	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3749' AND a.name = n.originalname
164	0.0006	0.00057697296142578	SELECT * FROM productoffers WHERE product_id = '3749' AND merchantid = 'A1X6FK5RDHNB96'
165	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '3749' AND price > 0 ORDER BY price ASC LIMIT 1
166	0.0005	0.00054502487182617	SELECT * FROM productoffers WHERE product_id = 3749 ORDER BY price ASC LIMIT 1
167	0.0005	0.00046706199645996	SELECT value FROM productattributes WHERE product_id = '3749' AND name = 'ListPriceAmount'
168	0.0006	0.00061893463134766	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '3749' GROUP BY o.product_id
169	0.0009	0.00093388557434082	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 = '3749' GROUP BY n.displayname ORDER BY n.displayname DESC
170	0.0007	0.00067877769470215	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3749
171	0.0008	0.00076198577880859	SELECT value FROM productattributes WHERE product_id = '3749' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172	0.0009	0.00093889236450195	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3749' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
173	0.0008	0.00083804130554199	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3749' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
174	0.0007	0.00073695182800293	SELECT * FROM productimages WHERE product_id = '3077' ORDER BY sortorder ASC
175	0.0008	0.0007929801940918	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3077' AND p.id = pi.product_id ORDER BY pi.sortorder
176	0.0009	0.00086021423339844	SELECT * FROM product_image_select WHERE product_id = '3077'
177	0.0007	0.00065898895263672	SELECT * FROM productcustomimages WHERE product_id = '3077'
178	0.0008	0.00078797340393066	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 = '3077' GROUP BY o.product_id
179	0.0010	0.00098991394042969	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 = '3077' GROUP BY n.displayname ORDER BY n.displayname DESC
180	0.0007	0.00066900253295898	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3077
181	0.0017	0.0017199516296387	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3077' AND a.name = n.originalname
182	0.0007	0.0006568431854248	SELECT * FROM productoffers WHERE product_id = '3077' AND merchantid = 'A1X6FK5RDHNB96'
183	0.0007	0.00068902969360352	SELECT * FROM productoffers WHERE product_id = '3077' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0007	0.0007481575012207	SELECT * FROM productoffers WHERE product_id = 3077 ORDER BY price ASC LIMIT 1
185	0.0008	0.00078296661376953	SELECT value FROM productattributes WHERE product_id = '3077' AND name = 'ListPriceAmount'
186	0.0008	0.00076603889465332	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 = '3077' GROUP BY o.product_id
187	0.0011	0.0010769367218018	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 = '3077' GROUP BY n.displayname ORDER BY n.displayname DESC
188	0.0006	0.00062394142150879	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3077
189	0.0010	0.0010221004486084	SELECT value FROM productattributes WHERE product_id = '3077' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190	0.0011	0.0010941028594971	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3077' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
191	0.0006	0.00060319900512695	SELECT id,asin FROM products WHERE parent_id = 773
192	0.0007	0.00072717666625977	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '773' ORDER BY timestamp DESC
193	0.0008	0.00084996223449707	SELECT category_id FROM products_categories WHERE product_id = '773'
194	0.0016	0.0016288757324219	SELECT * FROM categories WHERE id = '26'
195	0.0082	0.0082089900970459	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
196	0.0007	0.00073695182800293	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
197	0.0006	0.00060296058654785	SELECT id FROM categories WHERE parent_id = '26'
198	0.0065	0.0065429210662842	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
199	0.0008	0.00081706047058105	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
200	0.0010	0.00097393989562988	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
201	0.0007	0.00074410438537598	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
202	0.0011	0.0011169910430908	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '773' AND a.name = n.originalname
203	0.0007	0.00073504447937012	SELECT * FROM productoffers WHERE product_id = '773' AND merchantid = 'A1X6FK5RDHNB96'
204	0.0006	0.00057697296142578	SELECT * FROM productoffers WHERE product_id = '773' AND price > 0 ORDER BY price ASC LIMIT 1
205	0.0005	0.00053691864013672	SELECT * FROM productoffers WHERE product_id = 773 ORDER BY price ASC LIMIT 1
206	0.0005	0.0005488395690918	SELECT value FROM productattributes WHERE product_id = '773' AND name = 'ListPriceAmount'
207	0.0010	0.00098705291748047	SELECT * FROM products WHERE id = '773'
208	0.0007	0.0007171630859375	SELECT value FROM productattributes WHERE product_id = '773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209	0.0014	0.0014429092407227	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '773' AND a.name = n.originalname
210	0.0006	0.00064206123352051	SELECT * FROM productoffers WHERE product_id = '773' AND merchantid = 'A1X6FK5RDHNB96'
211	0.0005	0.00053095817565918	SELECT * FROM productoffers WHERE product_id = '773' AND price > 0 ORDER BY price ASC LIMIT 1
212	0.0010	0.0010120868682861	SELECT * FROM productoffers WHERE product_id = 773 ORDER BY price ASC LIMIT 1
213	0.0009	0.00092482566833496	SELECT value FROM productattributes WHERE product_id = '773' AND name = 'ListPriceAmount'
214	0.0012	0.0012249946594238	SELECT category_id FROM products_categories WHERE product_id = '773' AND prod_type = 'amz'
215	0.0011	0.0011248588562012	SELECT parent_id FROM categories WHERE id = '26'
216	0.0007	0.0007479190826416	SELECT * FROM categories WHERE id = '26'
217	0.0182	0.018172979354858	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
218	0.0010	0.00096392631530762	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
219	0.0008	0.00076198577880859	SELECT id FROM categories WHERE parent_id = '26'
220	0.0092	0.0091609954833984	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
221	0.0009	0.00085186958312988	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
222	0.0009	0.00089097023010254	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
223	0.0007	0.00069999694824219	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
224	0.0008	0.00077104568481445	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
225	0.0008	0.00078606605529785	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
226	0.0004	0.00042200088500977	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
227	0.0131	0.013082981109619	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
228	0.0011	0.0010600090026855	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
229	0.0012	0.0011639595031738	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
230	0.0007	0.00070905685424805	SELECT * FROM products WHERE id = 1626
231	0.0007	0.00070500373840332	SELECT * FROM products WHERE id = 4041
232	0.0006	0.00063610076904297	SELECT * FROM products WHERE id = 4312
233	0.0006	0.00061416625976562	SELECT * FROM products WHERE id = 777
234	0.0006	0.00059604644775391	SELECT * FROM products WHERE id = 3881
235	0.0008	0.00082206726074219	SELECT * FROM products WHERE id = 4213
236	0.0007	0.00068783760070801	SELECT * FROM products WHERE id = '1626'
237	0.0006	0.00056815147399902	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
238	0.0007	0.00071001052856445	SELECT * FROM product_image_select WHERE product_id = '1626'
239	0.0005	0.00049400329589844	SELECT * FROM productcustomimages WHERE product_id = '1626'
240	0.0010	0.0010099411010742	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
241	0.0006	0.00060796737670898	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
242	0.0005	0.0004730224609375	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
243	0.0005	0.00054812431335449	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244	0.0007	0.00069999694824219	SELECT * FROM products WHERE id = '4041'
245	0.0006	0.00060701370239258	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
246	0.0007	0.00069904327392578	SELECT * FROM product_image_select WHERE product_id = '4041'
247	0.0004	0.00043416023254395	SELECT * FROM productcustomimages WHERE product_id = '4041'
248	0.0013	0.0012941360473633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
249	0.0005	0.00053787231445312	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
250	0.0007	0.00072097778320312	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
251	0.0005	0.00052809715270996	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252	0.0007	0.00069212913513184	SELECT * FROM products WHERE id = '4312'
253	0.0006	0.00057697296142578	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
254	0.0007	0.00071096420288086	SELECT * FROM product_image_select WHERE product_id = '4312'
255	0.0005	0.00053191184997559	SELECT * FROM productcustomimages WHERE product_id = '4312'
256	0.0011	0.0010900497436523	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
257	0.0005	0.00051712989807129	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
258	0.0005	0.00050497055053711	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
259	0.0005	0.00050902366638184	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260	0.0007	0.00070500373840332	SELECT * FROM products WHERE id = '777'
261	0.0005	0.00050997734069824	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
262	0.0006	0.00064992904663086	SELECT * FROM product_image_select WHERE product_id = '777'
263	0.0005	0.00046610832214355	SELECT * FROM productcustomimages WHERE product_id = '777'
264	0.0012	0.0011909008026123	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
265	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
266	0.0005	0.00045514106750488	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
267	0.0005	0.00050091743469238	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268	0.0007	0.00066399574279785	SELECT * FROM products WHERE id = '3881'
269	0.0008	0.00079488754272461	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
270	0.0007	0.0006558895111084	SELECT * FROM product_image_select WHERE product_id = '3881'
271	0.0005	0.00046491622924805	SELECT * FROM productcustomimages WHERE product_id = '3881'
272	0.0011	0.0010781288146973	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
273	0.0005	0.00049304962158203	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
274	0.0005	0.00053191184997559	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
275	0.0006	0.00058197975158691	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276	0.0012	0.0011999607086182	SELECT * FROM products WHERE id = '4213'
277	0.0010	0.0010001659393311	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
278	0.0009	0.00090813636779785	SELECT * FROM product_image_select WHERE product_id = '4213'
279	0.0004	0.00043702125549316	SELECT * FROM productcustomimages WHERE product_id = '4213'
280	0.0012	0.0012350082397461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
281	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
282	0.0005	0.00045204162597656	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
283	0.0006	0.00058603286743164	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284	0.0009	0.00087094306945801	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
285	0.0009	0.00089192390441895	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
286	0.0017	0.0016739368438721	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
287	0.0009	0.00089907646179199	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
288	0.0019	0.0018701553344727	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
289	0.0016	0.0016429424285889	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Novastyl - 8010072 - Earl - Boîte à Thé - Gris/Blanc

Product Features

Thés & Traditions - Un Earl Grey com...

Rooibos Earl Grey Tea

Dragonfly Rooibos Earl Grey Tea 40 per p...

Out of the Blue Finest Selection Thé caf...

Coffret à Thé En Céramique,Conteneurs De...

Zerodis Boîte à Café 1,5 L,Récipient en ...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6618361473083 seconds

Query Debug - 289 Database Queries. Total time 0.9846 seconds

Novastyl - 8010072 - Earl - Boîte à Thé - Gris/Blanc

Product Features

Related Products

Thés & Traditions - Un Earl Grey com...

Rooibos Earl Grey Tea

Dragonfly Rooibos Earl Grey Tea 40 per p...

Out of the Blue Finest Selection Thé caf...

Coffret à Thé En Céramique,Conteneurs De...

Zerodis Boîte à Café 1,5 L,Récipient en ...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6618361473083 seconds

Query Debug - 289 Database Queries. Total time 0.9846 seconds