Heath & Heather | Organic Rooibos Tea | 2 x 20 bags (FR)

Price: Click Button for Price

As of 2021-07-20 18:23:23 UTC (more info)

Product prices and availability are accurate as of 2021-07-20 18:23:23 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

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

Product Features

Organic Rooibos Tea Gluten Free Vegan Organic Known Barcodes: 5060123609547, 5060123609547

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.5224099159241	281	0.9370	0

No Amazon API Requests Made.

App Debug - Total Time 1.5224099159241 seconds

Number	Time From Start	Name	Description
1	0.53493595123291	Initialise	Initialise FSB Function
2	0.53837490081787	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.59160804748535	Start of getCategoryListByGroup Function	Before first category groups query
4	0.59214305877686	After initial query	Before first category groups query
5	0.5921459197998	Get Category List for Group	Before the call to getCategoryList function
6	0.59215092658997	Start of GetCategoryList function	Start of the function
7	0.59215593338013	Before getting categories	Query to get specific category list
8	0.59291410446167	After getting categories	Query to get specific category list
9	0.5929160118103	Before getting category custom	Before call to function getCategoryCustom
10	0.61947298049927	After getting category custom	After call to function getCategoryCustom
11	0.61947798728943	Before getting category custom	Before call to function getCategoryCustom
12	0.64135408401489	After getting category custom	After call to function getCategoryCustom
13	0.64136004447937	Before getting category custom	Before call to function getCategoryCustom
14	0.65408301353455	After getting category custom	After call to function getCategoryCustom
15	0.65408706665039	Before getting category custom	Before call to function getCategoryCustom
16	0.66099190711975	After getting category custom	After call to function getCategoryCustom
17	0.66099500656128	Before getting category custom	Before call to function getCategoryCustom
18	0.66632795333862	After getting category custom	After call to function getCategoryCustom
19	0.66633200645447	Before getting category custom	Before call to function getCategoryCustom
20	0.67231893539429	After getting category custom	After call to function getCategoryCustom
21	0.67232298851013	End of GetCategoryList function	End of the function
22	0.67233204841614	Get Category List for Group	Before the call to getCategoryList function
23	0.67233610153198	Start of GetCategoryList function	Start of the function
24	0.67233991622925	Before getting categories	Query to get specific category list
25	0.6729040145874	End of getCategoryListByGroup Function	Before return()
26	1.1803359985352	App Controller End	End of the App controller (called before the controller of every page)
27	1.1810491085052	Product Start	Start of the product info controller
28	1.2029321193695	Cache file not found	Starting get product details
29	1.2532091140747	Related products	Start getting related products if enabled
30	1.2532110214233	Related Products Start	Before the related products are found
31	1.2532119750977	Related Products Keywords	Before the related product keywords are found
32	1.2532169818878	Create Keyword List Function	Start of function
33	1.2532548904419	Create Keyword List Function	After looping provided content - 30 keywords found
34	1.2543239593506	Create Keyword List Function	After looping initial keyword list - 23 keywords remaining
35	1.2543320655823	Create Keyword List Function	After reducing keyword list
36	1.2543959617615	Create Keyword List Function	After selecting by scoring keywords
37	1.2544000148773	Create Keyword List Function	After final loop of keywords
38	1.254401922226	Related Products Keywords	After the related product keywords are found
39	1.3412039279938	Related Products End	After the related products are found
40	1.4052429199219	Product End	End of the product info controller (Product Info)
41	1.4063470363617	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.4073159694672	Before Get Options	Before the call to getOptions in the tpl class
43	1.4912259578705	After Get Options	After the call to getOptions in the tpl class
44	1.491329908371	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.4913609027863	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.4964029788971	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.4964070320129	Product Info: Before Template Display	Before the template is displayed
48	1.5223889350891	Product Info: After Template Display	After the template is displayed
49	1.5223989486694	Finalizing debug	Before the debug is output to the page.
50	1.5224089622498	End of App	This is the end of the app logging, final timestamp

Query Debug - 281 Database Queries. Total time 0.9370 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.117.70.24\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722060567'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr' LIMIT 1
SELECT id FROM products WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr' 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 = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr'
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.117.70.24') >= INET_ATON(ip_start) AND INET_ATON('18.117.70.24') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2518
SELECT * FROM manufacturers WHERE id = '294'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '294' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '294' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '2517' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '294'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '294'
SELECT category_id FROM products_categories WHERE product_id = '2518'
SELECT * FROM categories WHERE id = '27'
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(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 productimages WHERE product_id = '2518' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2518' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2518'
SELECT * FROM productcustomimages WHERE product_id = '2518'
SELECT * FROM productfeeds WHERE product_id = '2518' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2518' 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 = '2518' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '2518'
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 = '2518'
                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     = '2518'
                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 = 2518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2518'
                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 = '2518'
                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     = '2518'
                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 = 2518
SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2518'
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 ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '862'
SELECT * FROM productcustomimages WHERE product_id = '862'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '938'
SELECT * FROM productcustomimages WHERE product_id = '938'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '938' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT *, MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AND 2518 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
SELECT *, MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
SELECT *, MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '858'
SELECT * FROM productcustomimages WHERE product_id = '858'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '878'
SELECT * FROM productcustomimages WHERE product_id = '878'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '865'
SELECT * FROM productcustomimages WHERE product_id = '865'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '862'
SELECT * FROM productcustomimages WHERE product_id = '862'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '2518') 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 = '27' AND pc.prod_type = 'amz'  AND p.id <> '2518' ORDER BY RAND()
SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '2518' ORDER BY RAND()
SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '2518' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '4258' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4258'
SELECT * FROM productcustomimages WHERE product_id = '4258'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4258' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4258' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4258' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 2518
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2518' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '2518'
SELECT * FROM categories WHERE id = '27'
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(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 a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2518'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '2518'
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 = '2518'
                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     = '2518'
                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 = 2518
SELECT value FROM productattributes WHERE product_id = '2518' 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 = '2518' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2518'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '2518' AND prod_type = 'amz'
SELECT parent_id FROM categories WHERE id = '27'
SELECT * FROM categories WHERE id = '27'
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(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 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.0026	0.0025899410247803	SELECT parameter, value FROM parameters
2	0.0046	0.0045809745788574	SELECT * FROM `bad_bots`
3	0.0004	0.00041913986206055	SET time_zone = 'Europe/London'
4	0.0008	0.0007789134979248	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0011	0.0010900497436523	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.117.70.24\";}'
6	0.0009	0.00087189674377441	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722060567'
7	0.0014	0.0013809204101562	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0007	0.00072789192199707	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0011	0.0010719299316406	SELECT id FROM pages WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr' LIMIT 1
10	0.0012	0.0011591911315918	SELECT id FROM products WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr' AND hidden = 0 LIMIT 1
11	0.0041	0.0040709972381592	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0480	0.047960042953491	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0005	0.00048208236694336	SELECT * FROM pages WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr'
14	0.0005	0.00051712989807129	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0007	0.00072908401489258	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0057	0.0056989192962646	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.0005	0.00054001808166504	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.0004	0.0004429817199707	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00046086311340332	SELECT id FROM categories WHERE parent_id = '26'
20	0.0157	0.015669107437134	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0009	0.0008540153503418	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0009	0.00086808204650879	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.0011	0.0011439323425293	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0007	0.00069904327392578	SELECT * FROM categorygroups WHERE id = '1'
25	0.0071	0.0071210861206055	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0007	0.00074887275695801	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.0006	0.00055980682373047	SELECT id FROM categories WHERE parent_id = '27'
29	0.0087	0.0086979866027832	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.0012	0.0012178421020508	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.0011	0.0011429786682129	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.0009	0.00094199180603027	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0007	0.0007469654083252	SELECT * FROM categorygroups WHERE id = '1'
34	0.0035	0.0034539699554443	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.0010	0.00095200538635254	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.0014	0.0014219284057617	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0008	0.00080084800720215	SELECT id FROM categories WHERE parent_id = '28'
38	0.0032	0.0031521320343018	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0007	0.00072598457336426	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.0008	0.00075006484985352	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.00068187713623047	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0006	0.00063300132751465	SELECT * FROM categorygroups WHERE id = '1'
43	0.0010	0.00097393989562988	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.0008	0.00077700614929199	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.0006	0.00060701370239258	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0007	0.000701904296875	SELECT id FROM categories WHERE parent_id = '29'
47	0.0010	0.001039981842041	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.0008	0.00076699256896973	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0007	0.00072002410888672	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.0006	0.00062012672424316	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0006	0.00055980682373047	SELECT * FROM categorygroups WHERE id = '1'
52	0.0007	0.00070905685424805	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.0005	0.00054597854614258	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0005	0.0004730224609375	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00049304962158203	SELECT id FROM categories WHERE parent_id = '30'
56	0.0008	0.00082087516784668	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.00056910514831543	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.00058984756469727	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.00051999092102051	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00047898292541504	SELECT * FROM categorygroups WHERE id = '1'
61	0.0007	0.00073385238647461	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.00062012672424316	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.00052905082702637	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0006	0.0005948543548584	SELECT id FROM categories WHERE parent_id = '31'
65	0.0010	0.0010390281677246	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.00065398216247559	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.00069785118103027	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.00054502487182617	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0004	0.00044417381286621	SELECT * FROM categorygroups WHERE id = '1'
70	0.0005	0.00054693222045898	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0022	0.0022320747375488	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0008	0.00079488754272461	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.00066304206848145	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.00050187110900879	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0013	0.0012850761413574	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0011	0.0011439323425293	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4974	0.4974319934845	SELECT * FROM ipgeocountries WHERE INET_ATON('18.117.70.24') >= INET_ATON(ip_start) AND INET_ATON('18.117.70.24') <= INET_ATON(ip_end)
78	0.0011	0.0010919570922852	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0007	0.00065898895263672	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0011	0.0011179447174072	SELECT * FROM products WHERE pagename = 'heath-heather-organic-rooibos-tea-2-x-20-bags-fr'
81	0.0005	0.00050902366638184	UPDATE products SET viewcount = viewcount + 1 WHERE id = 2518
82	0.0043	0.0043380260467529	SELECT * FROM manufacturers WHERE id = '294'
83	0.0011	0.0010600090026855	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
84	0.0009	0.00090312957763672	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '294' LIMIT 1
85	0.0016	0.0015609264373779	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '294' ORDER BY RAND() LIMIT 1
86	0.0008	0.00078392028808594	SELECT * FROM productimages WHERE product_id = '2517' ORDER BY sortorder ASC
87	0.0009	0.00090217590332031	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '294'
88	0.0011	0.0010647773742676	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '294' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0006	0.00064802169799805	SELECT * FROM manufacturerimages WHERE manufacturer_id = '294'
90	0.0009	0.00094890594482422	SELECT category_id FROM products_categories WHERE product_id = '2518'
91	0.0009	0.00085806846618652	SELECT * FROM categories WHERE id = '27'
92	0.0104	0.010397911071777	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
93	0.0007	0.00072407722473145	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94	0.0005	0.00048398971557617	SELECT id FROM categories WHERE parent_id = '27'
95	0.0066	0.0066449642181396	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
96	0.0008	0.00079894065856934	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
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 (27) AND c.prod_type = 'custom' AND cp.hide = 0
98	0.0006	0.00059199333190918	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99	0.0006	0.00059819221496582	SELECT * FROM productimages WHERE product_id = '2518' ORDER BY sortorder ASC
100	0.0007	0.00072002410888672	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2518' AND p.id = pi.product_id ORDER BY pi.sortorder
101	0.0008	0.00079607963562012	SELECT * FROM product_image_select WHERE product_id = '2518'
102	0.0016	0.0016171932220459	SELECT * FROM productcustomimages WHERE product_id = '2518'
103	0.0007	0.00065779685974121	SELECT * FROM productfeeds WHERE product_id = '2518' ORDER BY item_date DESC
104	0.0010	0.0010302066802979	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105	0.0009	0.00087094306945801	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2518' AND t.hidden = 0 AND display_product = 1
106	0.0006	0.00060105323791504	SELECT * FROM productamazoncontent WHERE product_id = '2518'
107	0.0008	0.00076794624328613	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 = '2518' GROUP BY o.product_id
108	0.0008	0.00079703330993652	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 = '2518' GROUP BY n.displayname ORDER BY n.displayname DESC
109	0.0005	0.0005190372467041	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
110	0.0015	0.0014698505401611	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
111	0.0005	0.00052118301391602	SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0005	0.00049209594726562	SELECT * FROM productoffers WHERE product_id = '2518' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0005	0.00045299530029297	SELECT * FROM productoffers WHERE product_id = 2518 ORDER BY price ASC LIMIT 1
114	0.0005	0.0005030632019043	SELECT value FROM productattributes WHERE product_id = '2518' AND name = 'ListPriceAmount'
115	0.0005	0.00052285194396973	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 = '2518' GROUP BY o.product_id
116	0.0008	0.0008080005645752	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 = '2518' GROUP BY n.displayname ORDER BY n.displayname DESC
117	0.0005	0.0005040168762207	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
118	0.0007	0.00068283081054688	SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
119	0.0005	0.00050783157348633	SELECT * FROM products WHERE parent_id = '2518'
120	0.0007	0.00065803527832031	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
121	0.0143	0.01433801651001	SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
122	0.0010	0.00099301338195801	SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
123	0.0008	0.00083494186401367	SELECT *, MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('20 bags fr' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
124	0.0007	0.00072979927062988	SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
125	0.0008	0.00076699256896973	SELECT * FROM product_image_select WHERE product_id = '862'
126	0.0006	0.00055885314941406	SELECT * FROM productcustomimages WHERE product_id = '862'
127	0.0014	0.0013880729675293	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
128	0.0007	0.00071477890014648	SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
129	0.0005	0.00049591064453125	SELECT * FROM productoffers WHERE product_id = '862' AND price > 0 ORDER BY price ASC LIMIT 1
130	0.0005	0.00049805641174316	SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0006	0.00056099891662598	SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
132	0.0007	0.00071597099304199	SELECT * FROM product_image_select WHERE product_id = '938'
133	0.0005	0.00050091743469238	SELECT * FROM productcustomimages WHERE product_id = '938'
134	0.0010	0.0010488033294678	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
135	0.0006	0.00060701370239258	SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
136	0.0005	0.00049304962158203	SELECT * FROM productoffers WHERE product_id = '938' AND price > 0 ORDER BY price ASC LIMIT 1
137	0.0006	0.00064301490783691	SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138	0.0154	0.015420913696289	SELECT *, MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AND 2518 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
139	0.0010	0.00096487998962402	SELECT *, MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
140	0.0006	0.0006110668182373	SELECT *, MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('heather organic rooibos' IN BOOLEAN MODE) AND 2518 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
141	0.0008	0.00079894065856934	SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
142	0.0006	0.00061798095703125	SELECT * FROM product_image_select WHERE product_id = '858'
143	0.0005	0.0005490779876709	SELECT * FROM productcustomimages WHERE product_id = '858'
144	0.0012	0.001168966293335	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
145	0.0006	0.00058889389038086	SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
146	0.0005	0.00050997734069824	SELECT * FROM productoffers WHERE product_id = '858' AND price > 0 ORDER BY price ASC LIMIT 1
147	0.0006	0.00057291984558105	SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148	0.0005	0.00049901008605957	SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
149	0.0006	0.00062108039855957	SELECT * FROM product_image_select WHERE product_id = '878'
150	0.0005	0.00047111511230469	SELECT * FROM productcustomimages WHERE product_id = '878'
151	0.0011	0.0010988712310791	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
152	0.0006	0.00055384635925293	SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0004	0.00044894218444824	SELECT * FROM productoffers WHERE product_id = '878' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0004	0.00040698051452637	SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155	0.0005	0.00051999092102051	SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
156	0.0006	0.0006248950958252	SELECT * FROM product_image_select WHERE product_id = '865'
157	0.0004	0.00044703483581543	SELECT * FROM productcustomimages WHERE product_id = '865'
158	0.0008	0.00079083442687988	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
159	0.0006	0.00055599212646484	SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
160	0.0004	0.00044012069702148	SELECT * FROM productoffers WHERE product_id = '865' AND price > 0 ORDER BY price ASC LIMIT 1
161	0.0006	0.00062894821166992	SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0007	0.00072717666625977	SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
163	0.0007	0.00074577331542969	SELECT * FROM product_image_select WHERE product_id = '862'
164	0.0005	0.00052499771118164	SELECT * FROM productcustomimages WHERE product_id = '862'
165	0.0014	0.0013539791107178	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
166	0.0007	0.0006721019744873	SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
167	0.0005	0.00052595138549805	SELECT * FROM productoffers WHERE product_id = '862' AND price > 0 ORDER BY price ASC LIMIT 1
168	0.0006	0.00055694580078125	SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169	0.0019	0.0018558502197266	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '2518') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
170	0.0139	0.013922929763794	SELECT p.* FROM products p, products_categories pc WHERE p.parent_id = 0 AND p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'amz' AND p.id <> '2518' ORDER BY RAND()
171	0.0011	0.0010931491851807	SELECT p.* FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'ebay' AND p.id <> '2518' ORDER BY RAND()
172	0.0009	0.00091910362243652	SELECT p.* FROM custom_products p, products_categories pc WHERE p.id = pc.product_id AND pc.category_id = '27' AND pc.prod_type = 'custom' AND p.id <> '2518' ORDER BY RAND()
173	0.0006	0.00063800811767578	SELECT * FROM productimages WHERE product_id = '4258' ORDER BY sortorder ASC
174	0.0008	0.00076413154602051	SELECT * FROM product_image_select WHERE product_id = '4258'
175	0.0006	0.00055408477783203	SELECT * FROM productcustomimages WHERE product_id = '4258'
176	0.0017	0.0016601085662842	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4258' AND a.name = n.originalname
177	0.0006	0.000640869140625	SELECT * FROM productoffers WHERE product_id = '4258' AND merchantid = 'A1X6FK5RDHNB96'
178	0.0007	0.00069308280944824	SELECT * FROM productoffers WHERE product_id = '4258' AND price > 0 ORDER BY price ASC LIMIT 1
179	0.0006	0.00055694580078125	SELECT value FROM productattributes WHERE product_id = '4258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180	0.0007	0.0006871223449707	SELECT id,asin FROM products WHERE parent_id = 2518
181	0.0010	0.00097012519836426	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2518' ORDER BY timestamp DESC
182	0.0008	0.00081586837768555	SELECT category_id FROM products_categories WHERE product_id = '2518'
183	0.0008	0.00082802772521973	SELECT * FROM categories WHERE id = '27'
184	0.0102	0.010169982910156	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
185	0.0009	0.00087213516235352	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186	0.0006	0.00056886672973633	SELECT id FROM categories WHERE parent_id = '27'
187	0.0070	0.0069901943206787	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
188	0.0010	0.00096011161804199	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
189	0.0008	0.00084400177001953	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
190	0.0008	0.00078701972961426	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
191	0.0014	0.0013930797576904	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
192	0.0007	0.00072622299194336	SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0004	0.00043797492980957	SELECT * FROM productoffers WHERE product_id = '2518' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0004	0.00044488906860352	SELECT * FROM productoffers WHERE product_id = 2518 ORDER BY price ASC LIMIT 1
195	0.0005	0.00049591064453125	SELECT value FROM productattributes WHERE product_id = '2518' AND name = 'ListPriceAmount'
196	0.0008	0.00080394744873047	SELECT * FROM products WHERE id = '2518'
197	0.0005	0.00050997734069824	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 = '2518' GROUP BY o.product_id
198	0.0013	0.0013208389282227	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 = '2518' GROUP BY n.displayname ORDER BY n.displayname DESC
199	0.0005	0.0005190372467041	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
200	0.0011	0.0011019706726074	SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
201	0.0013	0.0012869834899902	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
202	0.0005	0.00045585632324219	SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
203	0.0004	0.00044012069702148	SELECT * FROM productoffers WHERE product_id = '2518' AND price > 0 ORDER BY price ASC LIMIT 1
204	0.0004	0.00041294097900391	SELECT * FROM productoffers WHERE product_id = 2518 ORDER BY price ASC LIMIT 1
205	0.0037	0.0037031173706055	SELECT value FROM productattributes WHERE product_id = '2518' AND name = 'ListPriceAmount'
206	0.0014	0.0014231204986572	SELECT category_id FROM products_categories WHERE product_id = '2518' AND prod_type = 'amz'
207	0.0008	0.00083303451538086	SELECT parent_id FROM categories WHERE id = '27'
208	0.0007	0.00066804885864258	SELECT * FROM categories WHERE id = '27'
209	0.0122	0.012229919433594	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
210	0.0018	0.0017960071563721	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
211	0.0004	0.00044703483581543	SELECT id FROM categories WHERE parent_id = '27'
212	0.0055	0.0055379867553711	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
213	0.0007	0.00067996978759766	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
214	0.0007	0.0006709098815918	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
215	0.0006	0.00056195259094238	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
216	0.0006	0.00063705444335938	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
217	0.0005	0.00053882598876953	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
218	0.0004	0.00035595893859863	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
219	0.0134	0.013370990753174	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
220	0.0008	0.00080394744873047	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
221	0.0007	0.00071120262145996	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
222	0.0013	0.0012528896331787	SELECT * FROM products WHERE id = 1626
223	0.0005	0.00054383277893066	SELECT * FROM products WHERE id = 4041
224	0.0015	0.0014669895172119	SELECT * FROM products WHERE id = 4312
225	0.0004	0.00042891502380371	SELECT * FROM products WHERE id = 777
226	0.0006	0.00060606002807617	SELECT * FROM products WHERE id = 3881
227	0.0006	0.00058722496032715	SELECT * FROM products WHERE id = 4213
228	0.0006	0.00057888031005859	SELECT * FROM products WHERE id = '1626'
229	0.0012	0.0011768341064453	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
230	0.0014	0.001410961151123	SELECT * FROM product_image_select WHERE product_id = '1626'
231	0.0008	0.00078892707824707	SELECT * FROM productcustomimages WHERE product_id = '1626'
232	0.0020	0.001971960067749	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
233	0.0010	0.0009620189666748	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
234	0.0009	0.00087308883666992	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
235	0.0010	0.00097012519836426	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236	0.0011	0.0010709762573242	SELECT * FROM products WHERE id = '4041'
237	0.0013	0.0012822151184082	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
238	0.0023	0.0022540092468262	SELECT * FROM product_image_select WHERE product_id = '4041'
239	0.0010	0.0010199546813965	SELECT * FROM productcustomimages WHERE product_id = '4041'
240	0.0031	0.0030660629272461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
241	0.0013	0.0012578964233398	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
242	0.0008	0.00083398818969727	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
243	0.0009	0.00086617469787598	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244	0.0011	0.0010628700256348	SELECT * FROM products WHERE id = '4312'
245	0.0009	0.00094079971313477	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
246	0.0013	0.0013158321380615	SELECT * FROM product_image_select WHERE product_id = '4312'
247	0.0009	0.00086688995361328	SELECT * FROM productcustomimages WHERE product_id = '4312'
248	0.0030	0.0030221939086914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
249	0.0014	0.0014140605926514	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
250	0.0007	0.00069594383239746	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
251	0.0008	0.00075387954711914	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252	0.0009	0.00090694427490234	SELECT * FROM products WHERE id = '777'
253	0.0008	0.00084114074707031	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
254	0.0011	0.0010850429534912	SELECT * FROM product_image_select WHERE product_id = '777'
255	0.0008	0.00075316429138184	SELECT * FROM productcustomimages WHERE product_id = '777'
256	0.0023	0.0023159980773926	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
257	0.0010	0.0010001659393311	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
258	0.0007	0.00068998336791992	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
259	0.0009	0.00085616111755371	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260	0.0008	0.00081610679626465	SELECT * FROM products WHERE id = '3881'
261	0.0009	0.00087904930114746	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
262	0.0011	0.0011060237884521	SELECT * FROM product_image_select WHERE product_id = '3881'
263	0.0007	0.00069808959960938	SELECT * FROM productcustomimages WHERE product_id = '3881'
264	0.0021	0.0020971298217773	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
265	0.0008	0.00078701972961426	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
266	0.0007	0.00067400932312012	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
267	0.0007	0.00069308280944824	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268	0.0009	0.00090694427490234	SELECT * FROM products WHERE id = '4213'
269	0.0008	0.0008389949798584	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
270	0.0012	0.001183032989502	SELECT * FROM product_image_select WHERE product_id = '4213'
271	0.0007	0.00066280364990234	SELECT * FROM productcustomimages WHERE product_id = '4213'
272	0.0021	0.0020759105682373	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
273	0.0007	0.00072813034057617	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
274	0.0006	0.00058102607727051	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
275	0.0006	0.0006401538848877	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276	0.0012	0.0012052059173584	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
277	0.0015	0.0015020370483398	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
278	0.0030	0.0030059814453125	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
279	0.0012	0.0011880397796631	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
280	0.0011	0.0011460781097412	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
281	0.0014	0.0013728141784668	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Heath & Heather | Organic Rooibos Tea | 2 x 20 bags (FR)

Product Features

English Tea Shop Rooibos - 1 x 20 Tea Ba...

Tick Tock Original Organic Rooibos Tea B...

BADERs Cynarin Artischocke. Thé rooibos ...

Rooibos INFUSION 17 SACHETS

HolyCup Rooibos Tea Nespresso® Capsules ...

Vivaraise Couvre lit Stonewash Swami Roo...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5224099159241 seconds

Query Debug - 281 Database Queries. Total time 0.9370 seconds

Heath & Heather | Organic Rooibos Tea | 2 x 20 bags (FR)

Product Features

Related Products

English Tea Shop Rooibos - 1 x 20 Tea Ba...

Tick Tock Original Organic Rooibos Tea B...

BADERs Cynarin Artischocke. Thé rooibos ...

Rooibos INFUSION 17 SACHETS

HolyCup Rooibos Tea Nespresso® Capsules ...

Vivaraise Couvre lit Stonewash Swami Roo...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5224099159241 seconds

Query Debug - 281 Database Queries. Total time 0.9370 seconds