Jardin Bio Thé Vert Gingembre Citron Vert 30 g parent

Price: €2,78

As of 2022-06-26 02:57:16 UTC (more info)

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

Availability: In Stock

Click and Choose Options

Buy Now from Amazon

En stock.

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.3607120513916	285	0.8306	0

No Amazon API Requests Made.

App Debug - Total Time 1.3607120513916 seconds

Number	Time From Start	Name	Description
1	0.51971006393433	Initialise	Initialise FSB Function
2	0.52425503730774	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.5594539642334	Start of getCategoryListByGroup Function	Before first category groups query
4	0.56016206741333	After initial query	Before first category groups query
5	0.56016397476196	Get Category List for Group	Before the call to getCategoryList function
6	0.56016707420349	Start of GetCategoryList function	Start of the function
7	0.56016993522644	Before getting categories	Query to get specific category list
8	0.56093692779541	After getting categories	Query to get specific category list
9	0.56094002723694	Before getting category custom	Before call to function getCategoryCustom
10	0.57779908180237	After getting category custom	After call to function getCategoryCustom
11	0.577800989151	Before getting category custom	Before call to function getCategoryCustom
12	0.58962297439575	After getting category custom	After call to function getCategoryCustom
13	0.58962512016296	Before getting category custom	Before call to function getCategoryCustom
14	0.59698104858398	After getting category custom	After call to function getCategoryCustom
15	0.59698510169983	Before getting category custom	Before call to function getCategoryCustom
16	0.60345411300659	After getting category custom	After call to function getCategoryCustom
17	0.60345792770386	Before getting category custom	Before call to function getCategoryCustom
18	0.61034798622131	After getting category custom	After call to function getCategoryCustom
19	0.61035299301147	Before getting category custom	Before call to function getCategoryCustom
20	0.61615300178528	After getting category custom	After call to function getCategoryCustom
21	0.61615705490112	End of GetCategoryList function	End of the function
22	0.61616492271423	Get Category List for Group	Before the call to getCategoryList function
23	0.61616706848145	Start of GetCategoryList function	Start of the function
24	0.61616992950439	Before getting categories	Query to get specific category list
25	0.61674308776855	End of getCategoryListByGroup Function	Before return()
26	1.1234500408173	App Controller End	End of the App controller (called before the controller of every page)
27	1.1239449977875	Product Start	Start of the product info controller
28	1.1258361339569	Cache file not found	Starting get product details
29	1.165050983429	Related products	Start getting related products if enabled
30	1.1650531291962	Related Products Start	Before the related products are found
31	1.1650540828705	Related Products Keywords	Before the related product keywords are found
32	1.1650590896606	Create Keyword List Function	Start of function
33	1.1650941371918	Create Keyword List Function	After looping provided content - 26 keywords found
34	1.1660671234131	Create Keyword List Function	After looping initial keyword list - 21 keywords remaining
35	1.1660759449005	Create Keyword List Function	After reducing keyword list
36	1.1661479473114	Create Keyword List Function	After selecting by scoring keywords
37	1.1661529541016	Create Keyword List Function	After final loop of keywords
38	1.1661541461945	Related Products Keywords	After the related product keywords are found
39	1.2377800941467	Related Products End	After the related products are found
40	1.2671790122986	Product End	End of the product info controller (Product Info)
41	1.2682950496674	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.269268989563	Before Get Options	Before the call to getOptions in the tpl class
43	1.3450779914856	After Get Options	After the call to getOptions in the tpl class
44	1.3451910018921	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.3452219963074	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.3496749401093	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.3496789932251	Product Info: Before Template Display	Before the template is displayed
48	1.3606870174408	Product Info: After Template Display	After the template is displayed
49	1.3607001304626	Finalizing debug	Before the debug is output to the page.
50	1.360710144043	End of App	This is the end of the app logging, final timestamp

Query Debug - 285 Database Queries. Total time 0.8306 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:\"18.118.207.183\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722057502'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent' LIMIT 1
SELECT id FROM products WHERE pagename = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent' 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 = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.118.207.183') >= INET_ATON(ip_start) AND INET_ATON('18.118.207.183') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4474
SELECT * FROM manufacturers WHERE id = '639'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '3019' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '639'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
SELECT category_id FROM products_categories WHERE product_id = '4474'
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 = '4474' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4474' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4474'
SELECT * FROM productcustomimages WHERE product_id = '4474'
SELECT * FROM productfeeds WHERE product_id = '4474' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4474' 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 = '4474' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '4474'
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 = '4474'
                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     = '4474'
                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 = 4474
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4474' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4474
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4474'
                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 = '4474'
                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     = '4474'
                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 = 4474
SELECT value FROM productattributes WHERE product_id = '4474' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4474'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4474'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4697' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4697' AND merchantid = 'A1X6FK5RDHNB96'
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT *, MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AND 4474 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AND 4474 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AND 4474 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '853'
SELECT * FROM productcustomimages WHERE product_id = '853'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '868'
SELECT * FROM productcustomimages WHERE product_id = '868'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '857'
SELECT * FROM productcustomimages WHERE product_id = '857'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4498' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4498' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4498'
SELECT * FROM productcustomimages WHERE product_id = '4498'
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 = '4498'
                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     = '4498'
                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 = 4498
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4498' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4498' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4498' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4498
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4498'
                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 = '4498'
                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     = '4498'
                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 = 4498
SELECT value FROM productattributes WHERE product_id = '4498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4498'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4498'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4499' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4499' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productimages WHERE product_id = '911' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '911'
SELECT * FROM productcustomimages WHERE product_id = '911'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '911' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '911' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '911' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '911' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '842' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '842'
SELECT * FROM productcustomimages WHERE product_id = '842'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '842' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '842' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '842' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 4474
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4697
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4697
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4474' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '4474'
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 = '4474' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4474' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4474
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4474'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '4474'
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 = '4474'
                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     = '4474'
                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 = 4474
SELECT value FROM productattributes WHERE product_id = '4474' 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 = '4474' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4474' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4474
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4474'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '4474' 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.0022	0.0021569728851318	SELECT parameter, value FROM parameters
2	0.0060	0.0059809684753418	SELECT * FROM `bad_bots`
3	0.0010	0.00096988677978516	SET time_zone = 'Europe/London'
4	0.0011	0.0011429786682129	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0010	0.0010421276092529	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.118.207.183\";}'
6	0.0010	0.00098013877868652	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722057502'
7	0.0018	0.0017831325531006	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0012	0.0011811256408691	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0015	0.001474142074585	SELECT id FROM pages WHERE pagename = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent' LIMIT 1
10	0.0015	0.0015220642089844	SELECT id FROM products WHERE pagename = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent' AND hidden = 0 LIMIT 1
11	0.0044	0.0043509006500244	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0297	0.029674053192139	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0006	0.00061392784118652	SELECT * FROM pages WHERE pagename = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent'
14	0.0007	0.00069499015808105	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0007	0.00074386596679688	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0060	0.0059521198272705	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.0007	0.00069808959960938	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.0005	0.00052499771118164	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00054311752319336	SELECT id FROM categories WHERE parent_id = '26'
20	0.0062	0.0062189102172852	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.0007	0.00074481964111328	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.0007	0.00074219703674316	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.0006	0.00061702728271484	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0007	0.00070786476135254	SELECT * FROM categorygroups WHERE id = '1'
25	0.0038	0.0038189888000488	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.0006	0.00064396858215332	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0005	0.00052499771118164	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.00052309036254883	SELECT id FROM categories WHERE parent_id = '27'
29	0.0038	0.003803014755249	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.0007	0.00066399574279785	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0007	0.00068020820617676	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.00057792663574219	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00050187110900879	SELECT * FROM categorygroups WHERE id = '1'
34	0.0017	0.0016989707946777	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.00063896179199219	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.0004730224609375	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00048208236694336	SELECT id FROM categories WHERE parent_id = '28'
38	0.0016	0.0016012191772461	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.00059890747070312	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.00069999694824219	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.0006	0.00059890747070312	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.00046491622924805	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00076603889465332	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.0007	0.00069022178649902	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0005	0.00054693222045898	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0006	0.00059700012207031	SELECT id FROM categories WHERE parent_id = '29'
47	0.0010	0.0009770393371582	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0007	0.00066804885864258	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.0008	0.00081205368041992	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0007	0.0006709098815918	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0006	0.00061798095703125	SELECT * FROM categorygroups WHERE id = '1'
52	0.0007	0.00074410438537598	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.0012	0.0012459754943848	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.0006	0.00055384635925293	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0006	0.00055599212646484	SELECT id FROM categories WHERE parent_id = '30'
56	0.0011	0.0011439323425293	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.0006	0.0006101131439209	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.00062298774719238	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.0007	0.00065016746520996	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0006	0.00059008598327637	SELECT * FROM categorygroups WHERE id = '1'
61	0.0007	0.00073814392089844	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.0006	0.00056886672973633	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.0005	0.00048589706420898	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.00047993659973145	SELECT id FROM categories WHERE parent_id = '31'
65	0.0009	0.0008699893951416	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0007	0.00068211555480957	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.0007	0.0007021427154541	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0006	0.0006411075592041	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0005	0.00049018859863281	SELECT * FROM categorygroups WHERE id = '1'
70	0.0006	0.00056195259094238	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0016	0.0015828609466553	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0007	0.00071096420288086	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.00068092346191406	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.0005	0.00052499771118164	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0014	0.0013570785522461	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0012	0.0012149810791016	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4977	0.49765491485596	SELECT * FROM ipgeocountries WHERE INET_ATON('18.118.207.183') >= INET_ATON(ip_start) AND INET_ATON('18.118.207.183') <= INET_ATON(ip_end)
78	0.0013	0.0013220310211182	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0006	0.00058984756469727	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0009	0.00091195106506348	SELECT * FROM products WHERE pagename = 'jardin-bio-the-vert-gingembre-citron-vert-30-g-parent'
81	0.0005	0.00049805641174316	UPDATE products SET viewcount = viewcount + 1 WHERE id = 4474
82	0.0007	0.00072598457336426	SELECT * FROM manufacturers WHERE id = '639'
83	0.0012	0.0011508464813232	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
84	0.0007	0.00066089630126953	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '639' LIMIT 1
85	0.0013	0.0013151168823242	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '639' ORDER BY RAND() LIMIT 1
86	0.0005	0.0005190372467041	SELECT * FROM productimages WHERE product_id = '3019' ORDER BY sortorder ASC
87	0.0011	0.0010690689086914	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '639'
88	0.0012	0.0011970996856689	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '639' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0005	0.00052595138549805	SELECT * FROM manufacturerimages WHERE manufacturer_id = '639'
90	0.0006	0.00055885314941406	SELECT category_id FROM products_categories WHERE product_id = '4474'
91	0.0007	0.0007011890411377	SELECT * FROM categories WHERE id = '28'
92	0.0016	0.001568078994751	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
93	0.0005	0.00052189826965332	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
94	0.0005	0.0004580020904541	SELECT id FROM categories WHERE parent_id = '28'
95	0.0015	0.001533031463623	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
96	0.0007	0.00066804885864258	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
97	0.0007	0.00066900253295898	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
98	0.0006	0.00060081481933594	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
99	0.0006	0.00060009956359863	SELECT * FROM productimages WHERE product_id = '4474' ORDER BY sortorder ASC
100	0.0007	0.00072813034057617	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4474' AND p.id = pi.product_id ORDER BY pi.sortorder
101	0.0008	0.00076985359191895	SELECT * FROM product_image_select WHERE product_id = '4474'
102	0.0006	0.00057601928710938	SELECT * FROM productcustomimages WHERE product_id = '4474'
103	0.0005	0.00052905082702637	SELECT * FROM productfeeds WHERE product_id = '4474' ORDER BY item_date DESC
104	0.0009	0.00094389915466309	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105	0.0007	0.0007469654083252	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4474' AND t.hidden = 0 AND display_product = 1
106	0.0006	0.00059604644775391	SELECT * FROM productamazoncontent WHERE product_id = '4474'
107	0.0013	0.0013189315795898	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 = '4474' GROUP BY o.product_id
108	0.0015	0.0014729499816895	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 = '4474' GROUP BY n.displayname ORDER BY n.displayname DESC
109	0.0012	0.0011990070343018	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
110	0.0017	0.0016500949859619	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname
111	0.0005	0.00048208236694336	SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0008	0.00075697898864746	SELECT * FROM productoffers WHERE product_id = '4474' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0004	0.00044798851013184	SELECT * FROM productoffers WHERE product_id = 4474 ORDER BY price ASC LIMIT 1
114	0.0005	0.00053715705871582	SELECT value FROM productattributes WHERE product_id = '4474' AND name = 'ListPriceAmount'
115	0.0013	0.0012588500976562	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 = '4474' GROUP BY o.product_id
116	0.0015	0.0014820098876953	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 = '4474' GROUP BY n.displayname ORDER BY n.displayname DESC
117	0.0009	0.00086688995361328	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
118	0.0012	0.0012121200561523	SELECT value FROM productattributes WHERE product_id = '4474' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119	0.0015	0.0015029907226562	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4474' AND p.id = o.product_id AND o.name = 'PackageQuantity' GROUP BY o.value ORDER BY o.value ASC
120	0.0010	0.00099897384643555	SELECT * FROM products WHERE parent_id = '4474'
121	0.0013	0.0012619495391846	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4697' AND a.name = n.originalname
122	0.0010	0.00099396705627441	SELECT * FROM productoffers WHERE product_id = '4697' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0011	0.0011241436004639	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
124	0.0197	0.019714117050171	SELECT *, MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AND 4474 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
125	0.0010	0.0010099411010742	SELECT *, MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AND 4474 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
126	0.0009	0.00088405609130859	SELECT *, MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vert gingembre citron' IN BOOLEAN MODE) AND 4474 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
127	0.0009	0.0008540153503418	SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
128	0.0008	0.00079202651977539	SELECT * FROM product_image_select WHERE product_id = '853'
129	0.0006	0.00057101249694824	SELECT * FROM productcustomimages WHERE product_id = '853'
130	0.0013	0.0013229846954346	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
131	0.0006	0.000579833984375	SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
132	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '853' AND price > 0 ORDER BY price ASC LIMIT 1
133	0.0004	0.00044918060302734	SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134	0.0007	0.00069499015808105	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
135	0.0008	0.00081300735473633	SELECT * FROM product_image_select WHERE product_id = '868'
136	0.0005	0.0005030632019043	SELECT * FROM productcustomimages WHERE product_id = '868'
137	0.0009	0.00093698501586914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
138	0.0005	0.00052905082702637	SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0004	0.00044107437133789	SELECT * FROM productoffers WHERE product_id = '868' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0005	0.00046110153198242	SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141	0.0006	0.00062918663024902	SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
142	0.0016	0.0015799999237061	SELECT * FROM product_image_select WHERE product_id = '857'
143	0.0008	0.00083303451538086	SELECT * FROM productcustomimages WHERE product_id = '857'
144	0.0025	0.0025100708007812	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
145	0.0010	0.0010249614715576	SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
146	0.0009	0.00093603134155273	SELECT * FROM productoffers WHERE product_id = '857' AND price > 0 ORDER BY price ASC LIMIT 1
147	0.0010	0.00095200538635254	SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148	0.0010	0.0010480880737305	SELECT * FROM productimages WHERE product_id = '4498' ORDER BY sortorder ASC
149	0.0013	0.0012681484222412	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4498' AND p.id = pi.product_id ORDER BY pi.sortorder
150	0.0015	0.0015010833740234	SELECT * FROM product_image_select WHERE product_id = '4498'
151	0.0009	0.0008690357208252	SELECT * FROM productcustomimages WHERE product_id = '4498'
152	0.0013	0.0012578964233398	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 = '4498' GROUP BY o.product_id
153	0.0012	0.0011639595031738	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 = '4498' GROUP BY n.displayname ORDER BY n.displayname DESC
154	0.0007	0.0007021427154541	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4498
155	0.0017	0.0017249584197998	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4498' AND a.name = n.originalname
156	0.0006	0.00063419342041016	SELECT * FROM productoffers WHERE product_id = '4498' AND merchantid = 'A1X6FK5RDHNB96'
157	0.0007	0.00072693824768066	SELECT * FROM productoffers WHERE product_id = '4498' AND price > 0 ORDER BY price ASC LIMIT 1
158	0.0006	0.00064611434936523	SELECT * FROM productoffers WHERE product_id = 4498 ORDER BY price ASC LIMIT 1
159	0.0007	0.00071096420288086	SELECT value FROM productattributes WHERE product_id = '4498' AND name = 'ListPriceAmount'
160	0.0008	0.00076389312744141	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 = '4498' GROUP BY o.product_id
161	0.0012	0.001183032989502	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 = '4498' GROUP BY n.displayname ORDER BY n.displayname DESC
162	0.0007	0.00070500373840332	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4498
163	0.0011	0.0010910034179688	SELECT value FROM productattributes WHERE product_id = '4498' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164	0.0010	0.00096797943115234	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4498' AND p.id = o.product_id AND o.name = 'PackageQuantity' GROUP BY o.value ORDER BY o.value ASC
165	0.0007	0.00074481964111328	SELECT * FROM products WHERE parent_id = '4498'
166	0.0008	0.00084710121154785	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4499' AND a.name = n.originalname
167	0.0007	0.00074505805969238	SELECT * FROM productoffers WHERE product_id = '4499' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0008	0.00076794624328613	SELECT * FROM productimages WHERE product_id = '911' ORDER BY sortorder ASC
169	0.0009	0.00090909004211426	SELECT * FROM product_image_select WHERE product_id = '911'
170	0.0010	0.00095105171203613	SELECT * FROM productcustomimages WHERE product_id = '911'
171	0.0013	0.0012710094451904	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '911' AND a.name = n.originalname
172	0.0008	0.00081706047058105	SELECT * FROM productoffers WHERE product_id = '911' AND merchantid = 'A1X6FK5RDHNB96'
173	0.0006	0.00062084197998047	SELECT * FROM productoffers WHERE product_id = '911' AND price > 0 ORDER BY price ASC LIMIT 1
174	0.0006	0.00064396858215332	SELECT value FROM productattributes WHERE product_id = '911' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175	0.0007	0.00073099136352539	SELECT * FROM productimages WHERE product_id = '842' ORDER BY sortorder ASC
176	0.0008	0.00084519386291504	SELECT * FROM product_image_select WHERE product_id = '842'
177	0.0005	0.00053501129150391	SELECT * FROM productcustomimages WHERE product_id = '842'
178	0.0014	0.0014429092407227	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '842' AND a.name = n.originalname
179	0.0007	0.00066709518432617	SELECT * FROM productoffers WHERE product_id = '842' AND merchantid = 'A1X6FK5RDHNB96'
180	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '842' AND price > 0 ORDER BY price ASC LIMIT 1
181	0.0006	0.00059103965759277	SELECT value FROM productattributes WHERE product_id = '842' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182	0.0007	0.00073719024658203	SELECT id,asin FROM products WHERE parent_id = 4474
183	0.0007	0.00074100494384766	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4697
184	0.0009	0.00085210800170898	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4697
185	0.0006	0.00063419342041016	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4474' ORDER BY timestamp DESC
186	0.0007	0.00066018104553223	SELECT category_id FROM products_categories WHERE product_id = '4474'
187	0.0007	0.00071501731872559	SELECT * FROM categories WHERE id = '28'
188	0.0020	0.0019710063934326	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
189	0.0006	0.00057411193847656	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
190	0.0004	0.00041699409484863	SELECT id FROM categories WHERE parent_id = '28'
191	0.0016	0.0015509128570557	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
192	0.0007	0.000701904296875	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
193	0.0007	0.00073909759521484	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
194	0.0006	0.00061702728271484	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
195	0.0011	0.0010740756988525	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname
196	0.0007	0.00065922737121582	SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
197	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '4474' AND price > 0 ORDER BY price ASC LIMIT 1
198	0.0005	0.00047111511230469	SELECT * FROM productoffers WHERE product_id = 4474 ORDER BY price ASC LIMIT 1
199	0.0005	0.00049519538879395	SELECT value FROM productattributes WHERE product_id = '4474' AND name = 'ListPriceAmount'
200	0.0008	0.00081205368041992	SELECT * FROM products WHERE id = '4474'
201	0.0005	0.00051307678222656	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 = '4474' GROUP BY o.product_id
202	0.0008	0.00081586837768555	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 = '4474' GROUP BY n.displayname ORDER BY n.displayname DESC
203	0.0005	0.00052404403686523	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
204	0.0006	0.00063991546630859	SELECT value FROM productattributes WHERE product_id = '4474' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205	0.0009	0.00090193748474121	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname
206	0.0005	0.00046014785766602	SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
207	0.0005	0.00046896934509277	SELECT * FROM productoffers WHERE product_id = '4474' AND price > 0 ORDER BY price ASC LIMIT 1
208	0.0005	0.00046396255493164	SELECT * FROM productoffers WHERE product_id = 4474 ORDER BY price ASC LIMIT 1
209	0.0005	0.00046277046203613	SELECT value FROM productattributes WHERE product_id = '4474' AND name = 'ListPriceAmount'
210	0.0010	0.00099515914916992	SELECT category_id FROM products_categories WHERE product_id = '4474' AND prod_type = 'amz'
211	0.0007	0.00071191787719727	SELECT parent_id FROM categories WHERE id = '28'
212	0.0006	0.0005650520324707	SELECT * FROM categories WHERE id = '28'
213	0.0019	0.0018661022186279	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
214	0.0005	0.00053691864013672	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
215	0.0004	0.00044798851013184	SELECT id FROM categories WHERE parent_id = '28'
216	0.0016	0.0015828609466553	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
217	0.0007	0.00074410438537598	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
218	0.0007	0.00066804885864258	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
219	0.0006	0.000640869140625	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
220	0.0007	0.00072479248046875	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
221	0.0005	0.00049400329589844	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
222	0.0004	0.00040698051452637	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
223	0.0155	0.015498876571655	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
224	0.0011	0.0011260509490967	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
225	0.0008	0.00079512596130371	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
226	0.0007	0.00071096420288086	SELECT * FROM products WHERE id = 1626
227	0.0007	0.00069808959960938	SELECT * FROM products WHERE id = 4041
228	0.0007	0.00073099136352539	SELECT * FROM products WHERE id = 4312
229	0.0007	0.00066280364990234	SELECT * FROM products WHERE id = 777
230	0.0006	0.00064396858215332	SELECT * FROM products WHERE id = 3881
231	0.0007	0.00074505805969238	SELECT * FROM products WHERE id = 4213
232	0.0007	0.00067305564880371	SELECT * FROM products WHERE id = '1626'
233	0.0006	0.00061893463134766	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
234	0.0008	0.00078105926513672	SELECT * FROM product_image_select WHERE product_id = '1626'
235	0.0006	0.00056099891662598	SELECT * FROM productcustomimages WHERE product_id = '1626'
236	0.0011	0.0010850429534912	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
237	0.0006	0.00059390068054199	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
238	0.0006	0.00056195259094238	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
239	0.0006	0.00055694580078125	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240	0.0007	0.00071620941162109	SELECT * FROM products WHERE id = '4041'
241	0.0006	0.0005800724029541	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
242	0.0007	0.00071620941162109	SELECT * FROM product_image_select WHERE product_id = '4041'
243	0.0006	0.00055217742919922	SELECT * FROM productcustomimages WHERE product_id = '4041'
244	0.0012	0.0012259483337402	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
245	0.0006	0.0005638599395752	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
246	0.0005	0.00051593780517578	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
247	0.0005	0.00052785873413086	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248	0.0009	0.00093507766723633	SELECT * FROM products WHERE id = '4312'
249	0.0010	0.00097203254699707	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
250	0.0014	0.0014169216156006	SELECT * FROM product_image_select WHERE product_id = '4312'
251	0.0008	0.0007781982421875	SELECT * FROM productcustomimages WHERE product_id = '4312'
252	0.0026	0.0026450157165527	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
253	0.0010	0.00095295906066895	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
254	0.0009	0.00086307525634766	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
255	0.0010	0.00099921226501465	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256	0.0011	0.001068115234375	SELECT * FROM products WHERE id = '777'
257	0.0008	0.00078296661376953	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
258	0.0011	0.0011119842529297	SELECT * FROM product_image_select WHERE product_id = '777'
259	0.0007	0.00066900253295898	SELECT * FROM productcustomimages WHERE product_id = '777'
260	0.0020	0.0020060539245605	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
261	0.0008	0.00079584121704102	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
262	0.0007	0.0007169246673584	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
263	0.0010	0.00099301338195801	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264	0.0013	0.0013210773468018	SELECT * FROM products WHERE id = '3881'
265	0.0010	0.0010030269622803	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
266	0.0015	0.0014770030975342	SELECT * FROM product_image_select WHERE product_id = '3881'
267	0.0005	0.00051999092102051	SELECT * FROM productcustomimages WHERE product_id = '3881'
268	0.0013	0.0012907981872559	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
269	0.0006	0.00060200691223145	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
270	0.0007	0.0006561279296875	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
271	0.0006	0.00056195259094238	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272	0.0009	0.00089001655578613	SELECT * FROM products WHERE id = '4213'
273	0.0010	0.00098800659179688	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
274	0.0012	0.0011899471282959	SELECT * FROM product_image_select WHERE product_id = '4213'
275	0.0008	0.00078701972961426	SELECT * FROM productcustomimages WHERE product_id = '4213'
276	0.0024	0.0024290084838867	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
277	0.0008	0.00081896781921387	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
278	0.0006	0.00063896179199219	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
279	0.0008	0.00084185600280762	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280	0.0013	0.0013370513916016	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
281	0.0012	0.0012450218200684	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
282	0.0026	0.0026190280914307	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
283	0.0014	0.001399040222168	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
284	0.0010	0.0010159015655518	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
285	0.0012	0.0012161731719971	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Jardin Bio Thé Vert Gingembre Citron Vert 30 g parent

Lipton Thé Vert Menthe Intense

Kumiko Matcha - thé matcha premium bio d...

Lipton Tchaé Thé Vert Menthe 25 Sachets ...

Lipton Tchaé Thé Vert Orient 25 Sachets ...

Rooibos Canneberge Gingembre BIO | Sache...

Boîte à fenêtre Tisane Fée - Vert - DLP...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3607120513916 seconds

Query Debug - 285 Database Queries. Total time 0.8306 seconds

Jardin Bio Thé Vert Gingembre Citron Vert 30 g parent

Related Products

Lipton Thé Vert Menthe Intense

Kumiko Matcha - thé matcha premium bio d...

Lipton Tchaé Thé Vert Menthe 25 Sachets ...

Lipton Tchaé Thé Vert Orient 25 Sachets ...

Rooibos Canneberge Gingembre BIO | Sache...

Boîte à fenêtre Tisane Fée - Vert - DLP...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3607120513916 seconds

Query Debug - 285 Database Queries. Total time 0.8306 seconds