Rooibos pack

Price: Click Button for Price

As of 2022-06-12 01:48:12 UTC (more info)

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

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

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

Customer Reviews

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

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.6991498470306	289	0.9417	0

No Amazon API Requests Made.

App Debug - Total Time 1.6991498470306 seconds

Number	Time From Start	Name	Description
1	0.71620297431946	Initialise	Initialise FSB Function
2	0.72367095947266	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.76433181762695	Start of getCategoryListByGroup Function	Before first category groups query
4	0.7665958404541	After initial query	Before first category groups query
5	0.76659893989563	Get Category List for Group	Before the call to getCategoryList function
6	0.76660490036011	Start of GetCategoryList function	Start of the function
7	0.76661086082458	Before getting categories	Query to get specific category list
8	0.76844382286072	After getting categories	Query to get specific category list
9	0.76844692230225	Before getting category custom	Before call to function getCategoryCustom
10	0.79889297485352	After getting category custom	After call to function getCategoryCustom
11	0.79889702796936	Before getting category custom	Before call to function getCategoryCustom
12	0.82106399536133	After getting category custom	After call to function getCategoryCustom
13	0.82106995582581	Before getting category custom	Before call to function getCategoryCustom
14	0.83185195922852	After getting category custom	After call to function getCategoryCustom
15	0.83185791969299	Before getting category custom	Before call to function getCategoryCustom
16	0.83858585357666	After getting category custom	After call to function getCategoryCustom
17	0.83859086036682	Before getting category custom	Before call to function getCategoryCustom
18	0.84533786773682	After getting category custom	After call to function getCategoryCustom
19	0.84534382820129	Before getting category custom	Before call to function getCategoryCustom
20	0.85152101516724	After getting category custom	After call to function getCategoryCustom
21	0.8515260219574	End of GetCategoryList function	End of the function
22	0.85153698921204	Get Category List for Group	Before the call to getCategoryList function
23	0.85153985023499	Start of GetCategoryList function	Start of the function
24	0.85154390335083	Before getting categories	Query to get specific category list
25	0.8524329662323	End of getCategoryListByGroup Function	Before return()
26	1.4438788890839	App Controller End	End of the App controller (called before the controller of every page)
27	1.4455559253693	Product Start	Start of the product info controller
28	1.460620880127	Cache file not found	Starting get product details
29	1.5120739936829	Related products	Start getting related products if enabled
30	1.5120759010315	Related Products Start	Before the related products are found
31	1.5120768547058	Related Products Keywords	Before the related product keywords are found
32	1.5120828151703	Create Keyword List Function	Start of function
33	1.5121688842773	Create Keyword List Function	After looping provided content - 3 keywords found
34	1.5123329162598	Create Keyword List Function	After looping initial keyword list - 3 keywords remaining
35	1.5123388767242	Create Keyword List Function	After reducing keyword list
36	1.5123448371887	Create Keyword List Function	After selecting by scoring keywords
37	1.5123488903046	Create Keyword List Function	After final loop of keywords
38	1.5123510360718	Related Products Keywords	After the related product keywords are found
39	1.5507588386536	Related Products End	After the related products are found
40	1.5961399078369	Product End	End of the product info controller (Product Info)
41	1.5983538627625	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.5999698638916	Before Get Options	Before the call to getOptions in the tpl class
43	1.6647109985352	After Get Options	After the call to getOptions in the tpl class
44	1.6649479866028	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.6650018692017	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.6775319576263	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.6775369644165	Product Info: Before Template Display	Before the template is displayed
48	1.6991219520569	Product Info: After Template Display	After the template is displayed
49	1.6991360187531	Finalizing debug	Before the debug is output to the page.
50	1.6991488933563	End of App	This is the end of the app logging, final timestamp

Query Debug - 289 Database Queries. Total time 0.9417 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.119.141.115\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734785561'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'rooibos-pack' LIMIT 1
SELECT id FROM products WHERE pagename = 'rooibos-pack' 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 = 'rooibos-pack'
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.119.141.115') >= INET_ATON(ip_start) AND INET_ATON('18.119.141.115') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'rooibos-pack'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1206
SELECT * FROM manufacturers WHERE id = '285'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '285'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '285' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '285' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '1207' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '285'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '285'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '285'
SELECT category_id FROM products_categories WHERE product_id = '1206'
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 = '1206' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1206' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1206'
SELECT * FROM productcustomimages WHERE product_id = '1206'
SELECT * FROM productfeeds WHERE product_id = '1206' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1206' 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 = '1206' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '198'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '198'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '198'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '198' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
SELECT * FROM tags WHERE id = '500'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '500'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '500'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '500' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '1206'
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 = '1206'
                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     = '1206'
                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 = 1206
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1206' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1206' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1206' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1206
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1206'
                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 = '1206'
                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     = '1206'
                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 = 1206
SELECT value FROM productattributes WHERE product_id = '1206' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1206'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT *, MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AND 1206 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AND 1206 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AND 1206 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
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 = '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 = '4814' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4814'
SELECT * FROM productcustomimages WHERE product_id = '4814'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '869'
SELECT * FROM productcustomimages WHERE product_id = '869'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '869' 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 * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '890'
SELECT * FROM productcustomimages WHERE product_id = '890'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 1206
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1207
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1207
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1209
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1209
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1483
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1483
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1721
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1721
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1206' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '1206'
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 = '1206' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1206' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1206' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1206
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1206'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1206'
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 = '1206'
                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     = '1206'
                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 = 1206
SELECT value FROM productattributes WHERE product_id = '1206' 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 = '1206' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1206' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1206' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1206
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1206'
                AND name = 'ListPriceAmount'
SELECT DISTINCT (name) FROM productoptions
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 1206))
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 1206
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
SELECT * FROM translationsfilter
SELECT category_id FROM products_categories WHERE product_id = '1206' 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.0022	0.0022039413452148	SELECT parameter, value FROM parameters
2	0.0045	0.0045368671417236	SELECT * FROM `bad_bots`
3	0.0005	0.00050711631774902	SET time_zone = 'Europe/London'
4	0.0033	0.0033071041107178	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0034	0.0034399032592773	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.119.141.115\";}'
6	0.0033	0.0032989978790283	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1734785561'
7	0.0027	0.0027198791503906	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0007	0.00070786476135254	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0024	0.0024349689483643	SELECT id FROM pages WHERE pagename = 'rooibos-pack' LIMIT 1
10	0.0033	0.0033400058746338	SELECT id FROM products WHERE pagename = 'rooibos-pack' AND hidden = 0 LIMIT 1
11	0.0054	0.0053741931915283	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0318	0.031835079193115	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0025	0.0025010108947754	SELECT * FROM pages WHERE pagename = 'rooibos-pack'
14	0.0022	0.0022389888763428	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0018	0.0017991065979004	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0119	0.011925935745239	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.0027	0.0027279853820801	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.0016	0.0015690326690674	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0007	0.00073409080505371	SELECT id FROM categories WHERE parent_id = '26'
20	0.0076	0.0075891017913818	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.0017	0.0017180442810059	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.0018	0.0017518997192383	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.0016	0.0016422271728516	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00054407119750977	SELECT * FROM categorygroups WHERE id = '1'
25	0.0037	0.0037109851837158	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.00056695938110352	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.0009	0.00090789794921875	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0009	0.00087594985961914	SELECT id FROM categories WHERE parent_id = '27'
29	0.0110	0.01097297668457	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.0013	0.001305103302002	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.0015	0.001533031463623	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.0012	0.0011591911315918	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0009	0.0009310245513916	SELECT * FROM categorygroups WHERE id = '1'
34	0.0027	0.0027458667755127	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.0007	0.00069499015808105	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.00053620338439941	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0006	0.00058102607727051	SELECT id FROM categories WHERE parent_id = '28'
38	0.0028	0.0027730464935303	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.0009	0.00090503692626953	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.00079607963562012	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.0010	0.00099301338195801	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0006	0.00058984756469727	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00082612037658691	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0006	0.00063085556030273	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.0007	0.00066399574279785	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0008	0.00081682205200195	SELECT id FROM categories WHERE parent_id = '29'
47	0.0010	0.0010190010070801	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.00076007843017578	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.0006558895111084	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.00057196617126465	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0006	0.00063109397888184	SELECT * FROM categorygroups WHERE id = '1'
52	0.0008	0.00081515312194824	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53	0.0007	0.00070595741271973	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.00056290626525879	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00054192543029785	SELECT id FROM categories WHERE parent_id = '30'
56	0.0013	0.0012929439544678	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0007	0.00070500373840332	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.0008	0.00078105926513672	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0006	0.00060606002807617	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0006	0.00057101249694824	SELECT * FROM categorygroups WHERE id = '1'
61	0.0008	0.00075912475585938	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.00056290626525879	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.0004730224609375	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.0005180835723877	SELECT id FROM categories WHERE parent_id = '31'
65	0.0009	0.00086307525634766	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0006	0.00058579444885254	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.0006718635559082	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.0009	0.0009310245513916	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0006	0.00064611434936523	SELECT * FROM categorygroups WHERE id = '1'
70	0.0009	0.00087189674377441	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0048	0.0047919750213623	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0019	0.0018770694732666	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.00073003768920898	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74	0.0014	0.0013711452484131	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0013	0.0012919902801514	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0012	0.0012161731719971	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.5726	0.57261991500854	SELECT * FROM ipgeocountries WHERE INET_ATON('18.119.141.115') >= INET_ATON(ip_start) AND INET_ATON('18.119.141.115') <= INET_ATON(ip_end)
78	0.0027	0.0027499198913574	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0022	0.0022060871124268	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0018	0.0017890930175781	SELECT * FROM products WHERE pagename = 'rooibos-pack'
81	0.0006	0.00058817863464355	UPDATE products SET viewcount = viewcount + 1 WHERE id = 1206
82	0.0007	0.00067305564880371	SELECT * FROM manufacturers WHERE id = '285'
83	0.0006	0.00059294700622559	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '285'
84	0.0016	0.0015730857849121	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '285' LIMIT 1
85	0.0016	0.0015628337860107	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '285' ORDER BY RAND() LIMIT 1
86	0.0006	0.00056290626525879	SELECT * FROM productimages WHERE product_id = '1207' ORDER BY sortorder ASC
87	0.0007	0.00067782402038574	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '285'
88	0.0006	0.00057697296142578	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '285' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0005	0.00054812431335449	SELECT * FROM manufacturerimages WHERE manufacturer_id = '285'
90	0.0005	0.00051403045654297	SELECT category_id FROM products_categories WHERE product_id = '1206'
91	0.0006	0.00061511993408203	SELECT * FROM categories WHERE id = '27'
92	0.0054	0.0054359436035156	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.0006	0.00055098533630371	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94	0.0005	0.00045609474182129	SELECT id FROM categories WHERE parent_id = '27'
95	0.0046	0.0046069622039795	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.0007	0.00074100494384766	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.00066089630126953	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.00059390068054199	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99	0.0005	0.00053000450134277	SELECT * FROM productimages WHERE product_id = '1206' ORDER BY sortorder ASC
100	0.0009	0.00093889236450195	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1206' AND p.id = pi.product_id ORDER BY pi.sortorder
101	0.0019	0.0019190311431885	SELECT * FROM product_image_select WHERE product_id = '1206'
102	0.0013	0.0012650489807129	SELECT * FROM productcustomimages WHERE product_id = '1206'
103	0.0013	0.0013158321380615	SELECT * FROM productfeeds WHERE product_id = '1206' ORDER BY item_date DESC
104	0.0023	0.0023119449615479	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1206' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105	0.0023	0.0022690296173096	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1206' AND t.hidden = 0 AND display_product = 1
106	0.0021	0.0020558834075928	SELECT * FROM tags WHERE id = '198'
107	0.0008	0.00083613395690918	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '198' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
108	0.0006	0.0006098747253418	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '198' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
109	0.0006	0.00062298774719238	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '198' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110	0.0006	0.00060701370239258	SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
111	0.0004	0.0003509521484375	SELECT * FROM tags WHERE id = '500'
112	0.0006	0.00060296058654785	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '500' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
113	0.0006	0.00060200691223145	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '500' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
114	0.0006	0.00057196617126465	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '500' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
115	0.0005	0.00051689147949219	SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
116	0.0014	0.0013628005981445	SELECT * FROM productamazoncontent WHERE product_id = '1206'
117	0.0015	0.0014710426330566	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 = '1206' GROUP BY o.product_id
118	0.0022	0.0021588802337646	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 = '1206' GROUP BY n.displayname ORDER BY n.displayname DESC
119	0.0005	0.00052499771118164	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1206
120	0.0008	0.00080013275146484	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1206' AND a.name = n.originalname
121	0.0004	0.00043797492980957	SELECT * FROM productoffers WHERE product_id = '1206' AND merchantid = 'A1X6FK5RDHNB96'
122	0.0004	0.00041508674621582	SELECT * FROM productoffers WHERE product_id = '1206' AND price > 0 ORDER BY price ASC LIMIT 1
123	0.0004	0.00038003921508789	SELECT * FROM productoffers WHERE product_id = 1206 ORDER BY price ASC LIMIT 1
124	0.0004	0.0003819465637207	SELECT value FROM productattributes WHERE product_id = '1206' AND name = 'ListPriceAmount'
125	0.0005	0.00048708915710449	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 = '1206' GROUP BY o.product_id
126	0.0007	0.00067996978759766	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 = '1206' GROUP BY n.displayname ORDER BY n.displayname DESC
127	0.0006	0.00060319900512695	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1206
128	0.0006	0.00061702728271484	SELECT value FROM productattributes WHERE product_id = '1206' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129	0.0007	0.00067806243896484	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1206' AND p.id = o.product_id AND o.name = 'FlavorName' GROUP BY o.value ORDER BY o.value ASC
130	0.0005	0.00052595138549805	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
131	0.0098	0.0098381042480469	SELECT *, MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AND 1206 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
132	0.0009	0.00086808204650879	SELECT *, MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AND 1206 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
133	0.0008	0.00084400177001953	SELECT *, MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('rooibos pack' IN BOOLEAN MODE) AND 1206 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
134	0.0005	0.00050878524780273	SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
135	0.0007	0.00073409080505371	SELECT * FROM product_image_select WHERE product_id = '865'
136	0.0006	0.00060009956359863	SELECT * FROM productcustomimages WHERE product_id = '865'
137	0.0009	0.00091290473937988	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
138	0.0005	0.0005490779876709	SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0005	0.0005190372467041	SELECT * FROM productoffers WHERE product_id = '865' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0004	0.00043797492980957	SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141	0.0005	0.00050497055053711	SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
142	0.0006	0.00064516067504883	SELECT * FROM product_image_select WHERE product_id = '878'
143	0.0004	0.00044989585876465	SELECT * FROM productcustomimages WHERE product_id = '878'
144	0.0010	0.0010409355163574	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
145	0.0005	0.00050115585327148	SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
146	0.0004	0.00043416023254395	SELECT * FROM productoffers WHERE product_id = '878' AND price > 0 ORDER BY price ASC LIMIT 1
147	0.0004	0.00043296813964844	SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148	0.0005	0.0004878044128418	SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
149	0.0006	0.00060796737670898	SELECT * FROM product_image_select WHERE product_id = '4814'
150	0.0004	0.00040698051452637	SELECT * FROM productcustomimages WHERE product_id = '4814'
151	0.0010	0.00099992752075195	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
152	0.0005	0.00054597854614258	SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0005	0.00048112869262695	SELECT * FROM productoffers WHERE product_id = '4814' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0004	0.00044417381286621	SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155	0.0006	0.00062894821166992	SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
156	0.0006	0.00060391426086426	SELECT * FROM product_image_select WHERE product_id = '869'
157	0.0004	0.00042295455932617	SELECT * FROM productcustomimages WHERE product_id = '869'
158	0.0009	0.0009160041809082	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
159	0.0005	0.00050902366638184	SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
160	0.0007	0.0006709098815918	SELECT * FROM productoffers WHERE product_id = '869' AND price > 0 ORDER BY price ASC LIMIT 1
161	0.0005	0.00049209594726562	SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0006	0.00063800811767578	SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
163	0.0006	0.00061821937561035	SELECT * FROM product_image_select WHERE product_id = '862'
164	0.0004	0.00041794776916504	SELECT * FROM productcustomimages WHERE product_id = '862'
165	0.0009	0.00093793869018555	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
166	0.0005	0.00051307678222656	SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
167	0.0005	0.00054478645324707	SELECT * FROM productoffers WHERE product_id = '862' AND price > 0 ORDER BY price ASC LIMIT 1
168	0.0005	0.00049090385437012	SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169	0.0006	0.0005800724029541	SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
170	0.0007	0.00068998336791992	SELECT * FROM product_image_select WHERE product_id = '890'
171	0.0004	0.00043416023254395	SELECT * FROM productcustomimages WHERE product_id = '890'
172	0.0012	0.0011899471282959	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
173	0.0005	0.00054812431335449	SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
174	0.0005	0.00047993659973145	SELECT * FROM productoffers WHERE product_id = '890' AND price > 0 ORDER BY price ASC LIMIT 1
175	0.0005	0.00053095817565918	SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176	0.0005	0.00054693222045898	SELECT id,asin FROM products WHERE parent_id = 1206
177	0.0005	0.00052189826965332	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1207
178	0.0006	0.00060391426086426	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1207
179	0.0004	0.00041103363037109	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1209
180	0.0005	0.00047492980957031	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1209
181	0.0005	0.0005030632019043	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1483
182	0.0006	0.00055503845214844	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1483
183	0.0005	0.00049090385437012	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 1721
184	0.0005	0.000518798828125	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 1721
185	0.0019	0.0018689632415771	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1206' ORDER BY timestamp DESC
186	0.0005	0.0005338191986084	SELECT category_id FROM products_categories WHERE product_id = '1206'
187	0.0005	0.00054407119750977	SELECT * FROM categories WHERE id = '27'
188	0.0052	0.0051829814910889	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
189	0.0005	0.00054311752319336	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
190	0.0004	0.00044608116149902	SELECT id FROM categories WHERE parent_id = '27'
191	0.0042	0.0041990280151367	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
192	0.0018	0.0017611980438232	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
193	0.0006	0.0006401538848877	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
194	0.0005	0.00050997734069824	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
195	0.0009	0.00091886520385742	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1206' AND a.name = n.originalname
196	0.0005	0.00053882598876953	SELECT * FROM productoffers WHERE product_id = '1206' AND merchantid = 'A1X6FK5RDHNB96'
197	0.0004	0.00044107437133789	SELECT * FROM productoffers WHERE product_id = '1206' AND price > 0 ORDER BY price ASC LIMIT 1
198	0.0004	0.00039792060852051	SELECT * FROM productoffers WHERE product_id = 1206 ORDER BY price ASC LIMIT 1
199	0.0004	0.00042295455932617	SELECT value FROM productattributes WHERE product_id = '1206' AND name = 'ListPriceAmount'
200	0.0008	0.00080013275146484	SELECT * FROM products WHERE id = '1206'
201	0.0005	0.00048089027404785	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 = '1206' GROUP BY o.product_id
202	0.0007	0.000701904296875	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 = '1206' GROUP BY n.displayname ORDER BY n.displayname DESC
203	0.0005	0.0005030632019043	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1206
204	0.0006	0.00064206123352051	SELECT value FROM productattributes WHERE product_id = '1206' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205	0.0009	0.00087094306945801	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1206' AND a.name = n.originalname
206	0.0004	0.00044488906860352	SELECT * FROM productoffers WHERE product_id = '1206' AND merchantid = 'A1X6FK5RDHNB96'
207	0.0004	0.00041389465332031	SELECT * FROM productoffers WHERE product_id = '1206' AND price > 0 ORDER BY price ASC LIMIT 1
208	0.0004	0.00037598609924316	SELECT * FROM productoffers WHERE product_id = 1206 ORDER BY price ASC LIMIT 1
209	0.0004	0.00040698051452637	SELECT value FROM productattributes WHERE product_id = '1206' AND name = 'ListPriceAmount'
210	0.0006	0.00057315826416016	SELECT DISTINCT (name) FROM productoptions
211	0.0006	0.00057482719421387	SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 1206))
212	0.0005	0.00048303604125977	SELECT o.value, o.name FROM products p, productoptions o WHERE p.parent_id = 1206 AND p.id = o.product_id GROUP BY o.value ORDER BY o.value ASC
213	0.0017	0.0016598701477051	SELECT * FROM translationsfilter
214	0.0006	0.00058078765869141	SELECT category_id FROM products_categories WHERE product_id = '1206' AND prod_type = 'amz'
215	0.0005	0.00045204162597656	SELECT parent_id FROM categories WHERE id = '27'
216	0.0004	0.00040602684020996	SELECT * FROM categories WHERE id = '27'
217	0.0041	0.0040829181671143	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
218	0.0005	0.00049591064453125	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
219	0.0004	0.00037693977355957	SELECT id FROM categories WHERE parent_id = '27'
220	0.0040	0.0040080547332764	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
221	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 (27) AND p.disabled = 0
222	0.0006	0.00056600570678711	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
223	0.0005	0.00052213668823242	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
224	0.0015	0.0014889240264893	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
225	0.0011	0.0011451244354248	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
226	0.0004	0.00037717819213867	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
227	0.0125	0.01249098777771	SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
228	0.0014	0.0014050006866455	SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
229	0.0006	0.00056099891662598	SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
230	0.0007	0.00065016746520996	SELECT * FROM products WHERE id = 1626
231	0.0006	0.00063109397888184	SELECT * FROM products WHERE id = 4041
232	0.0007	0.000701904296875	SELECT * FROM products WHERE id = 4312
233	0.0006	0.00059914588928223	SELECT * FROM products WHERE id = 777
234	0.0006	0.0006110668182373	SELECT * FROM products WHERE id = 3881
235	0.0007	0.00072789192199707	SELECT * FROM products WHERE id = 4213
236	0.0006	0.00064802169799805	SELECT * FROM products WHERE id = '1626'
237	0.0005	0.00049400329589844	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
238	0.0006	0.00062394142150879	SELECT * FROM product_image_select WHERE product_id = '1626'
239	0.0004	0.00044703483581543	SELECT * FROM productcustomimages WHERE product_id = '1626'
240	0.0009	0.00088405609130859	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
241	0.0005	0.00054693222045898	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
242	0.0006	0.00055217742919922	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
243	0.0005	0.00047707557678223	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244	0.0007	0.00066304206848145	SELECT * FROM products WHERE id = '4041'
245	0.0005	0.00048398971557617	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
246	0.0006	0.00064706802368164	SELECT * FROM product_image_select WHERE product_id = '4041'
247	0.0005	0.00045394897460938	SELECT * FROM productcustomimages WHERE product_id = '4041'
248	0.0012	0.001230001449585	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
249	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
250	0.0005	0.00045990943908691	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
251	0.0005	0.00045919418334961	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252	0.0007	0.00065398216247559	SELECT * FROM products WHERE id = '4312'
253	0.0005	0.00052404403686523	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
254	0.0007	0.00067591667175293	SELECT * FROM product_image_select WHERE product_id = '4312'
255	0.0005	0.00050997734069824	SELECT * FROM productcustomimages WHERE product_id = '4312'
256	0.0012	0.0011970996856689	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
257	0.0005	0.00052404403686523	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
258	0.0005	0.00051307678222656	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
259	0.0005	0.00048398971557617	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260	0.0007	0.00066304206848145	SELECT * FROM products WHERE id = '777'
261	0.0005	0.00049901008605957	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
262	0.0007	0.00069689750671387	SELECT * FROM product_image_select WHERE product_id = '777'
263	0.0005	0.00048089027404785	SELECT * FROM productcustomimages WHERE product_id = '777'
264	0.0014	0.0013589859008789	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
265	0.0006	0.00057721138000488	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
266	0.0005	0.00052905082702637	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
267	0.0005	0.00049185752868652	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268	0.0007	0.00072193145751953	SELECT * FROM products WHERE id = '3881'
269	0.0008	0.00081896781921387	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
270	0.0007	0.00072193145751953	SELECT * FROM product_image_select WHERE product_id = '3881'
271	0.0005	0.00046610832214355	SELECT * FROM productcustomimages WHERE product_id = '3881'
272	0.0014	0.0013868808746338	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
273	0.0006	0.0005640983581543	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
274	0.0005	0.00048184394836426	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
275	0.0005	0.0005028247833252	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276	0.0007	0.00069904327392578	SELECT * FROM products WHERE id = '4213'
277	0.0008	0.0008399486541748	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
278	0.0007	0.00074505805969238	SELECT * FROM product_image_select WHERE product_id = '4213'
279	0.0005	0.00050997734069824	SELECT * FROM productcustomimages WHERE product_id = '4213'
280	0.0016	0.0015678405761719	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
281	0.0008	0.00082516670227051	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
282	0.0006	0.00057101249694824	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
283	0.0006	0.00059294700622559	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284	0.0026	0.0025880336761475	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
285	0.0011	0.0011289119720459	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
286	0.0035	0.0035390853881836	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
287	0.0029	0.0028538703918457	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
288	0.0010	0.0010411739349365	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
289	0.0012	0.0011520385742188	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Rooibos pack

HolyCup Rooibos Tea Nespresso® Capsules ...

Rooibos INFUSION 17 SACHETS

Dammann Frères - Rooibos l'Oriental-100g...

Mesh Rooibos Vanille Thé 16sticks-Thé ap...

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

Yogi Tea - Bedtime Rooibos Vanilla - 30....

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6991498470306 seconds

Query Debug - 289 Database Queries. Total time 0.9417 seconds

Rooibos pack

Related Products

HolyCup Rooibos Tea Nespresso® Capsules ...

Rooibos INFUSION 17 SACHETS

Dammann Frères - Rooibos l'Oriental-100g...

Mesh Rooibos Vanille Thé 16sticks-Thé ap...

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

Yogi Tea - Bedtime Rooibos Vanilla - 30....

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6991498470306 seconds

Query Debug - 289 Database Queries. Total time 0.9417 seconds