Tea

Price: Click Button for Price

As of 2021-07-21 11:55:21 UTC (more info)

Product prices and availability are accurate as of 2021-07-21 11:55:21 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.

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.5358180999756	482	0.9171	0

No Amazon API Requests Made.

App Debug - Total Time 1.5358180999756 seconds

Number	Time From Start	Name	Description
1	0.55915999412537	Initialise	Initialise FSB Function
2	0.56783604621887	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.6046290397644	Start of getCategoryListByGroup Function	Before first category groups query
4	0.60627102851868	After initial query	Before first category groups query
5	0.60627388954163	Get Category List for Group	Before the call to getCategoryList function
6	0.60627794265747	Start of GetCategoryList function	Start of the function
7	0.60628390312195	Before getting categories	Query to get specific category list
8	0.60833406448364	After getting categories	Query to get specific category list
9	0.60833692550659	Before getting category custom	Before call to function getCategoryCustom
10	0.66116690635681	After getting category custom	After call to function getCategoryCustom
11	0.66117191314697	Before getting category custom	Before call to function getCategoryCustom
12	0.67299294471741	After getting category custom	After call to function getCategoryCustom
13	0.67299795150757	Before getting category custom	Before call to function getCategoryCustom
14	0.680330991745	After getting category custom	After call to function getCategoryCustom
15	0.68033599853516	Before getting category custom	Before call to function getCategoryCustom
16	0.68558311462402	After getting category custom	After call to function getCategoryCustom
17	0.68558597564697	Before getting category custom	Before call to function getCategoryCustom
18	0.69071388244629	After getting category custom	After call to function getCategoryCustom
19	0.69071888923645	Before getting category custom	Before call to function getCategoryCustom
20	0.69578194618225	After getting category custom	After call to function getCategoryCustom
21	0.69578695297241	End of GetCategoryList function	End of the function
22	0.69579911231995	Get Category List for Group	Before the call to getCategoryList function
23	0.69580292701721	Start of GetCategoryList function	Start of the function
24	0.69580793380737	Before getting categories	Query to get specific category list
25	0.69637393951416	End of getCategoryListByGroup Function	Before return()
26	1.1434750556946	App Controller End	End of the App controller (called before the controller of every page)
27	1.1441869735718	Product Start	Start of the product info controller
28	1.195611000061	Cache file not found	Starting get product details
29	1.2690908908844	Related products	Start getting related products if enabled
30	1.2690939903259	Related Products Start	Before the related products are found
31	1.2690949440002	Related Products Keywords	Before the related product keywords are found
32	1.2691020965576	Create Keyword List Function	Start of function
33	1.2691249847412	Create Keyword List Function	After looping provided content - 1 keywords found
34	1.2691299915314	Create Keyword List Function	After looping initial keyword list - 0 keywords remaining
35	1.2691349983215	Create Keyword List Function	After reducing keyword list
36	1.2691369056702	Create Keyword List Function	After selecting by scoring keywords
37	1.2691400051117	Create Keyword List Function	After final loop of keywords
38	1.2691431045532	Related Products Keywords	After the related product keywords are found
39	1.3086750507355	Related Products End	After the related products are found
40	1.4500970840454	Product End	End of the product info controller (Product Info)
41	1.452271938324	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.453861951828	Before Get Options	Before the call to getOptions in the tpl class
43	1.5151040554047	After Get Options	After the call to getOptions in the tpl class
44	1.5152189731598	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.5152580738068	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.5246119499207	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.5246179103851	Product Info: Before Template Display	Before the template is displayed
48	1.5357880592346	Product Info: After Template Display	After the template is displayed
49	1.5358018875122	Finalizing debug	Before the debug is output to the page.
50	1.5358159542084	End of App	This is the end of the app logging, final timestamp

Query Debug - 482 Database Queries. Total time 0.9171 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:14:\"44.222.131.239\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1726104590'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'tea' LIMIT 1
SELECT id FROM products WHERE pagename = 'tea' 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 = 'tea'
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('44.222.131.239') >= INET_ATON(ip_start) AND INET_ATON('44.222.131.239') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'tea'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1167
SELECT * FROM manufacturers WHERE id = '0'
SELECT category_id FROM products_categories WHERE product_id = '1167'
SELECT * FROM categories WHERE id = '28'
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(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 productimages WHERE product_id = '1167' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1167' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1167'
SELECT * FROM productcustomimages WHERE product_id = '1167'
SELECT * FROM productfeeds WHERE product_id = '1167' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1167' 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 = '1167' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '1167'
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 = '1167'
                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     = '1167'
                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 = 1167
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1167' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1167
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1167'
                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 = '1167'
                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     = '1167'
                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 = 1167
SELECT value FROM productattributes WHERE product_id = '1167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1167'
                  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     = '1167'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                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 categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1167') 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 = '28' AND pc.prod_type = 'amz'  AND p.id <> '1167' ORDER BY RAND()
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '28' AND pc.prod_type = 'ebay' AND p.id <> '1167' ORDER BY RAND()
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '28' AND pc.prod_type = 'custom' AND p.id <> '1167' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '875' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '875'
SELECT * FROM productcustomimages WHERE product_id = '875'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '875' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '875' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '875' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 875
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '875'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '875' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1112' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1112'
SELECT * FROM productcustomimages WHERE product_id = '1112'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1112' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1112' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1112' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1112
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1112'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1112' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1225' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1225'
SELECT * FROM productcustomimages WHERE product_id = '1225'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1225' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1225' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1225' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1225
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1225'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1225' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '889' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '889'
SELECT * FROM productcustomimages WHERE product_id = '889'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '889' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '889' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '889' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 889
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '889'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1245' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1245'
SELECT * FROM productcustomimages WHERE product_id = '1245'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1245' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1245' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1245' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1151' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1151'
SELECT * FROM productcustomimages WHERE product_id = '1151'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1151' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1151' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1151' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1151
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1151'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1151' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 1167
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1751
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1751
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1857
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1857
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2033
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2033
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2034
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2034
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2035
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2035
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2036
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2036
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2037
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2037
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2041
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2041
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2047
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2047
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2114
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2114
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2253
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2253
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2158
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2158
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2174
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2174
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2362
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2362
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2387
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2387
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2468
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2468
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2470
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2470
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2473
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2473
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2481
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2481
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2603
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2603
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2617
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2617
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2627
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2627
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2700
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2700
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2701
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2701
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2706
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2706
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2752
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2752
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2771
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2771
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2817
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2817
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2860
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2860
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2886
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2886
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2937
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2937
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2947
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2947
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2965
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2965
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2966
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2966
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3219
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3219
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3040
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3040
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3054
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3054
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3062
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3062
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3084
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3084
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3100
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3100
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3101
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3101
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3103
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3103
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3109
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3109
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3111
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3111
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3115
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3115
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3149
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3149
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3150
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3150
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3199
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3199
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3212
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3212
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3231
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3231
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3232
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3232
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3233
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3233
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3245
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3245
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3247
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3247
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3248
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3248
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3250
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3250
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3265
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3265
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3268
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3268
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3271
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3271
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3284
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3284
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3316
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3316
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3323
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3323
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3474
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3474
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3371
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3371
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3373
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3373
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3374
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3374
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3375
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3375
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3397
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3397
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3398
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3398
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3402
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3402
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3403
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3403
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3404
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3404
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3405
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3405
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3408
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3408
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3409
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3409
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3418
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3418
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3419
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3419
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3420
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3420
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3450
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3450
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3451
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3451
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3452
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3452
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3453
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3453
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3454
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3454
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3455
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3455
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3456
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3456
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3457
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3457
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3458
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3458
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3459
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3459
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3480
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3480
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3479
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3479
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3475
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3475
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3476
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3476
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3477
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3477
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3482
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3482
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3483
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3483
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3499
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3499
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3501
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3501
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3504
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3504
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3522
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3522
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3537
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3537
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3538
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3538
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3539
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3539
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3541
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3541
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1167' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '1167'
SELECT * FROM categories WHERE id = '28'
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(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 a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1167' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1167
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1167'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1167'
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 = '1167'
                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     = '1167'
                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 = 1167
SELECT value FROM productattributes WHERE product_id = '1167' 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 = '1167' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1167' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1167
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1167'
                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 = 1167))
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 1167
			  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 = '1167' AND prod_type = 'amz'
SELECT parent_id FROM categories WHERE id = '28'
SELECT * FROM categories WHERE id = '28'
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(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 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.0019209384918213	SELECT parameter, value FROM parameters
2	0.0063	0.0063009262084961	SELECT * FROM `bad_bots`
3	0.0005	0.00048494338989258	SET time_zone = 'Europe/London'
4	0.0031	0.0031070709228516	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0037	0.003666877746582	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"44.222.131.239\";}'
6	0.0033	0.0033018589019775	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1726104590'
7	0.0048	0.0048270225524902	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00084614753723145	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0036	0.0036029815673828	SELECT id FROM pages WHERE pagename = 'tea' LIMIT 1
10	0.0038	0.0037870407104492	SELECT id FROM products WHERE pagename = 'tea' AND hidden = 0 LIMIT 1
11	0.0062	0.0061728954315186	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0293	0.029276132583618	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0007	0.00066113471984863	SELECT * FROM pages WHERE pagename = 'tea'
14	0.0016	0.0016231536865234	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0020	0.0020129680633545	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0238	0.023845911026001	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.0047	0.0047421455383301	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.0033	0.003303050994873	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0008	0.00083804130554199	SELECT id FROM categories WHERE parent_id = '26'
20	0.0128	0.012759923934937	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.0024	0.002432107925415	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.0021	0.0021090507507324	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.0020	0.0019710063934326	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0006	0.00055980682373047	SELECT * FROM categorygroups WHERE id = '1'
25	0.0042	0.0042471885681152	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.0005	0.00052309036254883	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.0004	0.00043201446533203	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.000518798828125	SELECT id FROM categories WHERE parent_id = '27'
29	0.0037	0.0037229061126709	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.0005	0.00054812431335449	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.0005	0.00054788589477539	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.00059700012207031	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00051498413085938	SELECT * FROM categorygroups WHERE id = '1'
34	0.0016	0.0015590190887451	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.0006	0.00055384635925293	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.0005	0.00048398971557617	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00048089027404785	SELECT id FROM categories WHERE parent_id = '28'
38	0.0016	0.0016260147094727	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.0006	0.00056290626525879	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.00065207481384277	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.0007	0.00067996978759766	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0006	0.00058507919311523	SELECT * FROM categorygroups WHERE id = '1'
43	0.0007	0.00069689750671387	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.0005	0.00052118301391602	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.0004	0.0004279613494873	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.0004889965057373	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.0006	0.00057315826416016	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.0006	0.00057506561279297	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.0005	0.00050806999206543	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0005	0.00047588348388672	SELECT * FROM categorygroups WHERE id = '1'
52	0.0006	0.00063514709472656	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.0006	0.00057792663574219	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.0004	0.00044393539428711	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00046610832214355	SELECT id FROM categories WHERE parent_id = '30'
56	0.0007	0.00073790550231934	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.0005	0.00053191184997559	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.0006	0.00058698654174805	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.0005	0.00052094459533691	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00047397613525391	SELECT * FROM categorygroups WHERE id = '1'
61	0.0007	0.00065803527832031	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.0005	0.00046396255493164	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.0004	0.00040221214294434	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.00047588348388672	SELECT id FROM categories WHERE parent_id = '31'
65	0.0007	0.00074505805969238	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.0006	0.00058197975158691	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.0006	0.00062108039855957	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.0005	0.00049901008605957	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0004	0.00044918060302734	SELECT * FROM categorygroups WHERE id = '1'
70	0.0005	0.0005490779876709	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0031	0.0030770301818848	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0015	0.0015370845794678	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.0006721019744873	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.0014	0.0013799667358398	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0013	0.0012669563293457	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0012	0.0011820793151855	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4321	0.43210506439209	SELECT * FROM ipgeocountries WHERE INET_ATON('44.222.131.239') >= INET_ATON(ip_start) AND INET_ATON('44.222.131.239') <= INET_ATON(ip_end)
78	0.0025	0.0024759769439697	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0017	0.0016958713531494	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0008	0.00077104568481445	SELECT * FROM products WHERE pagename = 'tea'
81	0.0005	0.00046706199645996	UPDATE products SET viewcount = viewcount + 1 WHERE id = 1167
82	0.0011	0.0010919570922852	SELECT * FROM manufacturers WHERE id = '0'
83	0.0008	0.00079011917114258	SELECT category_id FROM products_categories WHERE product_id = '1167'
84	0.0010	0.0010228157043457	SELECT * FROM categories WHERE id = '28'
85	0.0038	0.0038130283355713	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
86	0.0009	0.00091409683227539	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
87	0.0005	0.00051617622375488	SELECT id FROM categories WHERE parent_id = '28'
88	0.0036	0.0036070346832275	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
89	0.0008	0.00080990791320801	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
90	0.0009	0.00089216232299805	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
91	0.0012	0.0011520385742188	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
92	0.0046	0.0046329498291016	SELECT * FROM productimages WHERE product_id = '1167' ORDER BY sortorder ASC
93	0.0094	0.0093810558319092	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1167' AND p.id = pi.product_id ORDER BY pi.sortorder
94	0.0042	0.0041589736938477	SELECT * FROM product_image_select WHERE product_id = '1167'
95	0.0022	0.002202033996582	SELECT * FROM productcustomimages WHERE product_id = '1167'
96	0.0023	0.0023078918457031	SELECT * FROM productfeeds WHERE product_id = '1167' ORDER BY item_date DESC
97	0.0050	0.0050299167633057	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
98	0.0034	0.0033969879150391	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1167' AND t.hidden = 0 AND display_product = 1
99	0.0026	0.0026118755340576	SELECT * FROM productamazoncontent WHERE product_id = '1167'
100	0.0032	0.0032060146331787	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 = '1167' GROUP BY o.product_id
101	0.0046	0.0046079158782959	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 = '1167' GROUP BY n.displayname ORDER BY n.displayname DESC
102	0.0011	0.0011360645294189	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167
103	0.0011	0.0010600090026855	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
104	0.0005	0.00046086311340332	SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
105	0.0005	0.00048112869262695	SELECT * FROM productoffers WHERE product_id = '1167' AND price > 0 ORDER BY price ASC LIMIT 1
106	0.0005	0.00047087669372559	SELECT * FROM productoffers WHERE product_id = 1167 ORDER BY price ASC LIMIT 1
107	0.0005	0.00052189826965332	SELECT value FROM productattributes WHERE product_id = '1167' AND name = 'ListPriceAmount'
108	0.0011	0.0010650157928467	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 = '1167' GROUP BY o.product_id
109	0.0026	0.0025849342346191	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 = '1167' GROUP BY n.displayname ORDER BY n.displayname DESC
110	0.0009	0.00090193748474121	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167
111	0.0007	0.00071191787719727	SELECT value FROM productattributes WHERE product_id = '1167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112	0.0040	0.0040340423583984	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1167' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
113	0.0016	0.0016438961029053	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1167' AND p.id = o.product_id AND o.name = 'FlavorName' GROUP BY o.value ORDER BY o.value ASC
114	0.0006	0.00061798095703125	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
115	0.0011	0.001054048538208	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1167') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
116	0.0034	0.0033509731292725	SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '28' AND pc.prod_type = 'amz' AND p.id <> '1167' ORDER BY RAND()
117	0.0008	0.00081014633178711	SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '28' AND pc.prod_type = 'ebay' AND p.id <> '1167' ORDER BY RAND()
118	0.0006	0.00060319900512695	SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '28' AND pc.prod_type = 'custom' AND p.id <> '1167' ORDER BY RAND()
119	0.0006	0.00061607360839844	SELECT * FROM productimages WHERE product_id = '875' ORDER BY sortorder ASC
120	0.0007	0.00074887275695801	SELECT * FROM product_image_select WHERE product_id = '875'
121	0.0004	0.00043582916259766	SELECT * FROM productcustomimages WHERE product_id = '875'
122	0.0010	0.00095295906066895	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '875' AND a.name = n.originalname
123	0.0006	0.0006110668182373	SELECT * FROM productoffers WHERE product_id = '875' AND merchantid = 'A1X6FK5RDHNB96'
124	0.0005	0.00054502487182617	SELECT * FROM productoffers WHERE product_id = '875' AND price > 0 ORDER BY price ASC LIMIT 1
125	0.0004	0.00044393539428711	SELECT * FROM productoffers WHERE product_id = 875 ORDER BY price ASC LIMIT 1
126	0.0004	0.00043511390686035	SELECT value FROM productattributes WHERE product_id = '875' AND name = 'ListPriceAmount'
127	0.0005	0.00045204162597656	SELECT value FROM productattributes WHERE product_id = '875' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
128	0.0005	0.00052905082702637	SELECT * FROM productimages WHERE product_id = '1112' ORDER BY sortorder ASC
129	0.0007	0.00065016746520996	SELECT * FROM product_image_select WHERE product_id = '1112'
130	0.0005	0.00046491622924805	SELECT * FROM productcustomimages WHERE product_id = '1112'
131	0.0013	0.0012919902801514	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1112' AND a.name = n.originalname
132	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '1112' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0004	0.00043606758117676	SELECT * FROM productoffers WHERE product_id = '1112' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0004	0.00042200088500977	SELECT * FROM productoffers WHERE product_id = 1112 ORDER BY price ASC LIMIT 1
135	0.0007	0.0007479190826416	SELECT value FROM productattributes WHERE product_id = '1112' AND name = 'ListPriceAmount'
136	0.0005	0.00048398971557617	SELECT value FROM productattributes WHERE product_id = '1112' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137	0.0005	0.00052595138549805	SELECT * FROM productimages WHERE product_id = '1225' ORDER BY sortorder ASC
138	0.0006	0.00064301490783691	SELECT * FROM product_image_select WHERE product_id = '1225'
139	0.0004	0.0004429817199707	SELECT * FROM productcustomimages WHERE product_id = '1225'
140	0.0014	0.00136399269104	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1225' AND a.name = n.originalname
141	0.0006	0.00056600570678711	SELECT * FROM productoffers WHERE product_id = '1225' AND merchantid = 'A1X6FK5RDHNB96'
142	0.0004	0.00043916702270508	SELECT * FROM productoffers WHERE product_id = '1225' AND price > 0 ORDER BY price ASC LIMIT 1
143	0.0004	0.00043487548828125	SELECT * FROM productoffers WHERE product_id = 1225 ORDER BY price ASC LIMIT 1
144	0.0005	0.00045990943908691	SELECT value FROM productattributes WHERE product_id = '1225' AND name = 'ListPriceAmount'
145	0.0006	0.00056004524230957	SELECT value FROM productattributes WHERE product_id = '1225' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146	0.0005	0.0005488395690918	SELECT * FROM productimages WHERE product_id = '889' ORDER BY sortorder ASC
147	0.0006	0.00062799453735352	SELECT * FROM product_image_select WHERE product_id = '889'
148	0.0005	0.00048398971557617	SELECT * FROM productcustomimages WHERE product_id = '889'
149	0.0009	0.00086712837219238	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '889' AND a.name = n.originalname
150	0.0006	0.0005950927734375	SELECT * FROM productoffers WHERE product_id = '889' AND merchantid = 'A1X6FK5RDHNB96'
151	0.0007	0.0006711483001709	SELECT * FROM productoffers WHERE product_id = '889' AND price > 0 ORDER BY price ASC LIMIT 1
152	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = 889 ORDER BY price ASC LIMIT 1
153	0.0004	0.0003819465637207	SELECT value FROM productattributes WHERE product_id = '889' AND name = 'ListPriceAmount'
154	0.0005	0.00054788589477539	SELECT value FROM productattributes WHERE product_id = '889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155	0.0007	0.00069713592529297	SELECT * FROM productimages WHERE product_id = '1245' ORDER BY sortorder ASC
156	0.0009	0.00088691711425781	SELECT * FROM product_image_select WHERE product_id = '1245'
157	0.0005	0.0005030632019043	SELECT * FROM productcustomimages WHERE product_id = '1245'
158	0.0011	0.0011448860168457	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1245' AND a.name = n.originalname
159	0.0006	0.000579833984375	SELECT * FROM productoffers WHERE product_id = '1245' AND merchantid = 'A1X6FK5RDHNB96'
160	0.0006	0.000579833984375	SELECT * FROM productoffers WHERE product_id = '1245' AND price > 0 ORDER BY price ASC LIMIT 1
161	0.0005	0.00049304962158203	SELECT value FROM productattributes WHERE product_id = '1245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0006	0.00057291984558105	SELECT * FROM productimages WHERE product_id = '1151' ORDER BY sortorder ASC
163	0.0008	0.00078010559082031	SELECT * FROM product_image_select WHERE product_id = '1151'
164	0.0005	0.00050520896911621	SELECT * FROM productcustomimages WHERE product_id = '1151'
165	0.0010	0.0010068416595459	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1151' AND a.name = n.originalname
166	0.0008	0.00075483322143555	SELECT * FROM productoffers WHERE product_id = '1151' AND merchantid = 'A1X6FK5RDHNB96'
167	0.0004	0.0004420280456543	SELECT * FROM productoffers WHERE product_id = '1151' AND price > 0 ORDER BY price ASC LIMIT 1
168	0.0004	0.00044107437133789	SELECT * FROM productoffers WHERE product_id = 1151 ORDER BY price ASC LIMIT 1
169	0.0006	0.00059390068054199	SELECT value FROM productattributes WHERE product_id = '1151' AND name = 'ListPriceAmount'
170	0.0006	0.00055909156799316	SELECT value FROM productattributes WHERE product_id = '1151' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171	0.0010	0.00098991394042969	SELECT id,asin FROM products WHERE parent_id = 1167
172	0.0006	0.0005650520324707	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1751
173	0.0007	0.00074911117553711	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1751
174	0.0004	0.00044918060302734	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1857
175	0.0006	0.00055193901062012	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1857
176	0.0005	0.00047993659973145	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2033
177	0.0006	0.00060486793518066	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2033
178	0.0005	0.00050806999206543	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2034
179	0.0006	0.00059294700622559	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2034
180	0.0005	0.00053715705871582	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2035
181	0.0006	0.00062298774719238	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2035
182	0.0005	0.00051283836364746	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2036
183	0.0005	0.0005030632019043	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2036
184	0.0004	0.00037002563476562	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2037
185	0.0005	0.00046515464782715	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2037
186	0.0004	0.0003809928894043	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2041
187	0.0005	0.00049495697021484	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2041
188	0.0004	0.00041699409484863	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2047
189	0.0004	0.00044107437133789	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2047
190	0.0004	0.00036811828613281	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2114
191	0.0004	0.00044512748718262	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2114
192	0.0004	0.00044894218444824	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2253
193	0.0004	0.0004429817199707	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2253
194	0.0004	0.00037813186645508	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2158
195	0.0005	0.00048303604125977	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2158
196	0.0004	0.00041890144348145	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2174
197	0.0004	0.00042390823364258	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2174
198	0.0003	0.00034403800964355	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2362
199	0.0005	0.00047898292541504	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2362
200	0.0004	0.00035715103149414	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2387
201	0.0004	0.00043392181396484	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2387
202	0.0004	0.00035190582275391	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2468
203	0.0005	0.00045490264892578	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2468
204	0.0004	0.00036001205444336	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2470
205	0.0006	0.00057411193847656	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2470
206	0.0004	0.00043606758117676	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2473
207	0.0004	0.00043606758117676	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2473
208	0.0004	0.0003960132598877	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2481
209	0.0004	0.0004420280456543	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2481
210	0.0004	0.00039792060852051	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2603
211	0.0005	0.00050210952758789	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2603
212	0.0004	0.00039100646972656	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2617
213	0.0005	0.00048613548278809	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2617
214	0.0004	0.00036716461181641	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2627
215	0.0005	0.00049591064453125	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2627
216	0.0004	0.00039505958557129	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2700
217	0.0005	0.00046396255493164	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2700
218	0.0004	0.00036096572875977	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2701
219	0.0005	0.0005028247833252	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2701
220	0.0004	0.00040698051452637	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2706
221	0.0004	0.00044703483581543	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2706
222	0.0004	0.00043892860412598	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2752
223	0.0006	0.00056982040405273	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2752
224	0.0005	0.0004730224609375	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2771
225	0.0007	0.0006711483001709	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2771
226	0.0004	0.00041985511779785	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2817
227	0.0006	0.00058817863464355	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2817
228	0.0004	0.0004270076751709	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2860
229	0.0005	0.00049901008605957	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2860
230	0.0004	0.00043296813964844	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2886
231	0.0006	0.0005800724029541	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2886
232	0.0004	0.00044512748718262	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2937
233	0.0005	0.00051999092102051	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2937
234	0.0004	0.0003960132598877	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2947
235	0.0005	0.00054216384887695	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2947
236	0.0004	0.00044798851013184	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2965
237	0.0005	0.00052785873413086	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2965
238	0.0005	0.00046491622924805	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 2966
239	0.0005	0.00053787231445312	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 2966
240	0.0004	0.0004279613494873	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3219
241	0.0005	0.00049018859863281	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3219
242	0.0004	0.00044989585876465	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3040
243	0.0005	0.00052905082702637	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3040
244	0.0004	0.00039505958557129	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3054
245	0.0006	0.0005650520324707	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3054
246	0.0004	0.00042486190795898	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3062
247	0.0006	0.00059199333190918	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3062
248	0.0005	0.0004889965057373	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3084
249	0.0005	0.00052690505981445	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3084
250	0.0004	0.00035309791564941	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3100
251	0.0005	0.00049781799316406	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3100
252	0.0004	0.0003960132598877	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3101
253	0.0006	0.00057315826416016	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3101
254	0.0004	0.00043106079101562	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3103
255	0.0005	0.00050687789916992	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3103
256	0.0004	0.00038790702819824	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3109
257	0.0005	0.00049781799316406	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3109
258	0.0004	0.00037693977355957	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3111
259	0.0005	0.0005030632019043	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3111
260	0.0004	0.00040411949157715	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3115
261	0.0006	0.00055599212646484	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3115
262	0.0004	0.00043988227844238	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3149
263	0.0005	0.00051093101501465	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3149
264	0.0004	0.00042080879211426	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3150
265	0.0006	0.00060606002807617	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3150
266	0.0006	0.00055503845214844	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3199
267	0.0009	0.00085616111755371	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3199
268	0.0008	0.0008080005645752	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3212
269	0.0008	0.00075292587280273	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3212
270	0.0006	0.00062298774719238	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3231
271	0.0008	0.00080204010009766	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3231
272	0.0005	0.00049996376037598	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3232
273	0.0006	0.00064992904663086	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3232
274	0.0004	0.00040888786315918	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3233
275	0.0005	0.00051593780517578	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3233
276	0.0004	0.00044584274291992	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3245
277	0.0006	0.00059103965759277	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3245
278	0.0005	0.00046801567077637	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3247
279	0.0005	0.00052118301391602	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3247
280	0.0004	0.0004270076751709	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3248
281	0.0005	0.00054788589477539	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3248
282	0.0005	0.0004730224609375	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3250
283	0.0005	0.00050210952758789	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3250
284	0.0005	0.00046992301940918	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3265
285	0.0006	0.00063300132751465	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3265
286	0.0004	0.00040698051452637	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3268
287	0.0005	0.00051999092102051	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3268
288	0.0004	0.00041699409484863	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3271
289	0.0005	0.00050210952758789	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3271
290	0.0005	0.00048112869262695	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3284
291	0.0006	0.00058913230895996	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3284
292	0.0004	0.00040888786315918	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3316
293	0.0006	0.00062799453735352	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3316
294	0.0005	0.00046110153198242	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3323
295	0.0006	0.00060582160949707	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3323
296	0.0004	0.0003960132598877	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3474
297	0.0006	0.00057291984558105	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3474
298	0.0004	0.00040483474731445	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3371
299	0.0005	0.00052499771118164	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3371
300	0.0004	0.0003960132598877	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3373
301	0.0006	0.00060105323791504	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3373
302	0.0005	0.0005338191986084	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3374
303	0.0006	0.00055408477783203	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3374
304	0.0007	0.0007011890411377	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3375
305	0.0005	0.00053501129150391	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3375
306	0.0005	0.00046300888061523	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3397
307	0.0005	0.00054216384887695	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3397
308	0.0005	0.0004880428314209	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3398
309	0.0006	0.0005800724029541	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3398
310	0.0005	0.00047898292541504	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3402
311	0.0005	0.00054287910461426	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3402
312	0.0004	0.00041294097900391	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3403
313	0.0005	0.00052499771118164	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3403
314	0.0004	0.00039815902709961	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3404
315	0.0006	0.00057411193847656	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3404
316	0.0004	0.0004432201385498	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3405
317	0.0007	0.00067710876464844	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3405
318	0.0006	0.00055909156799316	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3408
319	0.0007	0.00069212913513184	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3408
320	0.0005	0.00048995018005371	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3409
321	0.0008	0.0007789134979248	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3409
322	0.0005	0.00054192543029785	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3418
323	0.0006	0.00058889389038086	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3418
324	0.0005	0.00048422813415527	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3419
325	0.0007	0.00065112113952637	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3419
326	0.0005	0.00053906440734863	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3420
327	0.0009	0.00086498260498047	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3420
328	0.0006	0.00059008598327637	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3450
329	0.0008	0.000762939453125	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3450
330	0.0005	0.00046896934509277	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3451
331	0.0006	0.00059199333190918	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3451
332	0.0005	0.00047802925109863	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3452
333	0.0006	0.00055313110351562	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3452
334	0.0005	0.00045895576477051	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3453
335	0.0006	0.00061202049255371	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3453
336	0.0005	0.0005030632019043	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3454
337	0.0006	0.00055193901062012	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3454
338	0.0005	0.00045108795166016	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3455
339	0.0006	0.00062704086303711	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3455
340	0.0004	0.00042080879211426	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3456
341	0.0005	0.00050210952758789	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3456
342	0.0005	0.00047588348388672	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3457
343	0.0007	0.00073480606079102	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3457
344	0.0005	0.00045990943908691	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3458
345	0.0006	0.0006101131439209	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3458
346	0.0005	0.0005030632019043	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3459
347	0.0007	0.00066304206848145	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3459
348	0.0005	0.00049400329589844	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3480
349	0.0005	0.00052809715270996	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3480
350	0.0005	0.00053310394287109	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3479
351	0.0005	0.00054192543029785	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3479
352	0.0005	0.00050616264343262	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3475
353	0.0005	0.00053596496582031	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3475
354	0.0006	0.00056600570678711	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3476
355	0.0006	0.00058102607727051	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3476
356	0.0005	0.00048184394836426	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3477
357	0.0007	0.00072908401489258	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3477
358	0.0005	0.00049114227294922	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3482
359	0.0008	0.00075697898864746	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3482
360	0.0004	0.00040411949157715	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3483
361	0.0006	0.0005500316619873	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3483
362	0.0004	0.00041890144348145	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3499
363	0.0006	0.00060200691223145	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3499
364	0.0004	0.00040507316589355	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3501
365	0.0006	0.00059008598327637	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3501
366	0.0004	0.00039911270141602	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3504
367	0.0005	0.00049304962158203	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3504
368	0.0004	0.00038504600524902	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3522
369	0.0006	0.00055408477783203	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3522
370	0.0004	0.00039100646972656	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3537
371	0.0005	0.00052404403686523	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3537
372	0.0004	0.00038814544677734	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3538
373	0.0006	0.00064206123352051	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3538
374	0.0004	0.00042200088500977	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3539
375	0.0005	0.00054192543029785	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3539
376	0.0004	0.00043082237243652	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 3541
377	0.0006	0.0005500316619873	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 3541
378	0.0021	0.0020580291748047	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1167' ORDER BY timestamp DESC
379	0.0006	0.00056290626525879	SELECT category_id FROM products_categories WHERE product_id = '1167'
380	0.0006	0.00063896179199219	SELECT * FROM categories WHERE id = '28'
381	0.0019	0.0019359588623047	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
382	0.0006	0.0005650520324707	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
383	0.0004	0.00040793418884277	SELECT id FROM categories WHERE parent_id = '28'
384	0.0017	0.0017139911651611	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
385	0.0007	0.00067305564880371	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
386	0.0007	0.00067591667175293	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
387	0.0007	0.00065302848815918	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
388	0.0010	0.0010190010070801	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
389	0.0007	0.00067901611328125	SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
390	0.0005	0.00054502487182617	SELECT * FROM productoffers WHERE product_id = '1167' AND price > 0 ORDER BY price ASC LIMIT 1
391	0.0005	0.00045108795166016	SELECT * FROM productoffers WHERE product_id = 1167 ORDER BY price ASC LIMIT 1
392	0.0006	0.00055813789367676	SELECT value FROM productattributes WHERE product_id = '1167' AND name = 'ListPriceAmount'
393	0.0007	0.00071811676025391	SELECT * FROM products WHERE id = '1167'
394	0.0009	0.00094199180603027	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 = '1167' GROUP BY o.product_id
395	0.0025	0.0024590492248535	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 = '1167' GROUP BY n.displayname ORDER BY n.displayname DESC
396	0.0009	0.00091290473937988	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1167
397	0.0007	0.00069284439086914	SELECT value FROM productattributes WHERE product_id = '1167' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
398	0.0008	0.00083708763122559	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1167' AND a.name = n.originalname
399	0.0005	0.00049495697021484	SELECT * FROM productoffers WHERE product_id = '1167' AND merchantid = 'A1X6FK5RDHNB96'
400	0.0005	0.0004570484161377	SELECT * FROM productoffers WHERE product_id = '1167' AND price > 0 ORDER BY price ASC LIMIT 1
401	0.0004	0.00039887428283691	SELECT * FROM productoffers WHERE product_id = 1167 ORDER BY price ASC LIMIT 1
402	0.0005	0.00046086311340332	SELECT value FROM productattributes WHERE product_id = '1167' AND name = 'ListPriceAmount'
403	0.0006	0.00061297416687012	SELECT DISTINCT (name) FROM productoptions
404	0.0010	0.00098896026611328	SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 1167))
405	0.0015	0.0014541149139404	SELECT o.value, o.name FROM products p, productoptions o WHERE p.parent_id = 1167 AND p.id = o.product_id GROUP BY o.value ORDER BY o.value ASC
406	0.0017	0.0016899108886719	SELECT * FROM translationsfilter
407	0.0005	0.00053000450134277	SELECT category_id FROM products_categories WHERE product_id = '1167' AND prod_type = 'amz'
408	0.0005	0.00049090385437012	SELECT parent_id FROM categories WHERE id = '28'
409	0.0004	0.00041317939758301	SELECT * FROM categories WHERE id = '28'
410	0.0016	0.0016191005706787	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
411	0.0005	0.00045204162597656	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
412	0.0003	0.00034284591674805	SELECT id FROM categories WHERE parent_id = '28'
413	0.0013	0.0013480186462402	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
414	0.0005	0.00050187110900879	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
415	0.0006	0.0006110668182373	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
416	0.0006	0.00055599212646484	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
417	0.0017	0.0017168521881104	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
418	0.0011	0.0011389255523682	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
419	0.0004	0.00037598609924316	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
420	0.0135	0.013512849807739	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
421	0.0016	0.0015950202941895	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
422	0.0007	0.00067591667175293	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
423	0.0006	0.0006411075592041	SELECT * FROM products WHERE id = 1626
424	0.0005	0.00047993659973145	SELECT * FROM products WHERE id = 4041
425	0.0006	0.00063800811767578	SELECT * FROM products WHERE id = 4312
426	0.0006	0.00059103965759277	SELECT * FROM products WHERE id = 777
427	0.0006	0.00063705444335938	SELECT * FROM products WHERE id = 3881
428	0.0006	0.00056886672973633	SELECT * FROM products WHERE id = 4213
429	0.0006	0.00057792663574219	SELECT * FROM products WHERE id = '1626'
430	0.0005	0.00049901008605957	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
431	0.0006	0.00060200691223145	SELECT * FROM product_image_select WHERE product_id = '1626'
432	0.0005	0.00047183036804199	SELECT * FROM productcustomimages WHERE product_id = '1626'
433	0.0010	0.00099587440490723	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
434	0.0006	0.00061392784118652	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
435	0.0004	0.00044107437133789	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
436	0.0005	0.00047516822814941	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
437	0.0007	0.0006558895111084	SELECT * FROM products WHERE id = '4041'
438	0.0005	0.00050783157348633	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
439	0.0007	0.00069499015808105	SELECT * FROM product_image_select WHERE product_id = '4041'
440	0.0004	0.00044798851013184	SELECT * FROM productcustomimages WHERE product_id = '4041'
441	0.0013	0.0013289451599121	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
442	0.0006	0.00060820579528809	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
443	0.0006	0.00056290626525879	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
444	0.0005	0.00047588348388672	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
445	0.0006	0.00059604644775391	SELECT * FROM products WHERE id = '4312'
446	0.0005	0.00052595138549805	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
447	0.0006	0.00064516067504883	SELECT * FROM product_image_select WHERE product_id = '4312'
448	0.0005	0.00050210952758789	SELECT * FROM productcustomimages WHERE product_id = '4312'
449	0.0011	0.0010659694671631	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
450	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
451	0.0004	0.00042581558227539	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
452	0.0004	0.0004279613494873	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
453	0.0007	0.00069808959960938	SELECT * FROM products WHERE id = '777'
454	0.0006	0.00055599212646484	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
455	0.0007	0.00068998336791992	SELECT * FROM product_image_select WHERE product_id = '777'
456	0.0006	0.00058293342590332	SELECT * FROM productcustomimages WHERE product_id = '777'
457	0.0011	0.0011229515075684	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
458	0.0005	0.00052809715270996	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
459	0.0005	0.00052499771118164	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
460	0.0004	0.00044012069702148	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
461	0.0006	0.0006110668182373	SELECT * FROM products WHERE id = '3881'
462	0.0008	0.00076103210449219	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
463	0.0008	0.00075101852416992	SELECT * FROM product_image_select WHERE product_id = '3881'
464	0.0005	0.00046706199645996	SELECT * FROM productcustomimages WHERE product_id = '3881'
465	0.0011	0.0010919570922852	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
466	0.0005	0.00051999092102051	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
467	0.0004	0.00043797492980957	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
468	0.0004	0.0004429817199707	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
469	0.0007	0.00066399574279785	SELECT * FROM products WHERE id = '4213'
470	0.0008	0.00076103210449219	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
471	0.0008	0.00076699256896973	SELECT * FROM product_image_select WHERE product_id = '4213'
472	0.0005	0.00047993659973145	SELECT * FROM productcustomimages WHERE product_id = '4213'
473	0.0012	0.0011718273162842	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
474	0.0005	0.00049805641174316	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
475	0.0005	0.0004570484161377	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
476	0.0005	0.00049591064453125	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
477	0.0027	0.0027270317077637	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
478	0.0012	0.0011751651763916	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
479	0.0031	0.003093957901001	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
480	0.0019	0.001884937286377	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
481	0.0007	0.00074100494384766	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
482	0.0010	0.0010161399841309	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Tea

Thé Vert Casbah - Sachet de 100g

Poudre de Thé Vert Matcha Bio - Qualité ...

Palais des Thés - Thé vert LES PLAISIRS ...

Palais Des Thés - Thé Vert Sencha De Mai...

Kusmi Tea - Thé vert à la rose - Boîte 2...

Lipton Thé Vert Pomme Menthe 20 Sachets ...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5358180999756 seconds

Query Debug - 482 Database Queries. Total time 0.9171 seconds

Tea

Related Products

Thé Vert Casbah - Sachet de 100g

Poudre de Thé Vert Matcha Bio - Qualité ...

Palais des Thés - Thé vert LES PLAISIRS ...

Palais Des Thés - Thé Vert Sencha De Mai...

Kusmi Tea - Thé vert à la rose - Boîte 2...

Lipton Thé Vert Pomme Menthe 20 Sachets ...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5358180999756 seconds

Query Debug - 482 Database Queries. Total time 0.9171 seconds