Dragonfly Teas | Rooibos Breakfast | 4 x 40 Bags

Price: Click Button for Price

As of 2022-06-24 21:03:35 UTC (more info)

Product prices and availability are accurate as of 2022-06-24 21:03:35 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.5832440853119	270	1.1337	0

No Amazon API Requests Made.

App Debug - Total Time 1.5832440853119 seconds

Number	Time From Start	Name	Description
1	0.32314801216125	Initialise	Initialise FSB Function
2	0.33521509170532	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.37337303161621	Start of getCategoryListByGroup Function	Before first category groups query
4	0.37690711021423	After initial query	Before first category groups query
5	0.37692213058472	Get Category List for Group	Before the call to getCategoryList function
6	0.37692904472351	Start of GetCategoryList function	Start of the function
7	0.3769359588623	Before getting categories	Query to get specific category list
8	0.38071012496948	After getting categories	Query to get specific category list
9	0.38071393966675	Before getting category custom	Before call to function getCategoryCustom
10	0.41885614395142	After getting category custom	After call to function getCategoryCustom
11	0.41886115074158	Before getting category custom	Before call to function getCategoryCustom
12	0.43423700332642	After getting category custom	After call to function getCategoryCustom
13	0.43424296379089	Before getting category custom	Before call to function getCategoryCustom
14	0.45820498466492	After getting category custom	After call to function getCategoryCustom
15	0.45820999145508	Before getting category custom	Before call to function getCategoryCustom
16	0.46760201454163	After getting category custom	After call to function getCategoryCustom
17	0.4676079750061	Before getting category custom	Before call to function getCategoryCustom
18	0.4747109413147	After getting category custom	After call to function getCategoryCustom
19	0.47471594810486	Before getting category custom	Before call to function getCategoryCustom
20	0.4813380241394	After getting category custom	After call to function getCategoryCustom
21	0.48134303092957	End of GetCategoryList function	End of the function
22	0.4813539981842	Get Category List for Group	Before the call to getCategoryList function
23	0.48135709762573	Start of GetCategoryList function	Start of the function
24	0.48136115074158	Before getting categories	Query to get specific category list
25	0.48202610015869	End of getCategoryListByGroup Function	Before return()
26	1.0925130844116	App Controller End	End of the App controller (called before the controller of every page)
27	1.0937311649323	Product Start	Start of the product info controller
28	1.1177229881287	Cache file not found	Starting get product details
29	1.1690731048584	Related products	Start getting related products if enabled
30	1.169075012207	Related Products Start	Before the related products are found
31	1.1690771579742	Related Products Keywords	Before the related product keywords are found
32	1.1690831184387	Create Keyword List Function	Start of function
33	1.1692130565643	Create Keyword List Function	After looping provided content - 21 keywords found
34	1.1703591346741	Create Keyword List Function	After looping initial keyword list - 16 keywords remaining
35	1.1703691482544	Create Keyword List Function	After reducing keyword list
36	1.1704461574554	Create Keyword List Function	After selecting by scoring keywords
37	1.1704511642456	Create Keyword List Function	After final loop of keywords
38	1.1704540252686	Related Products Keywords	After the related product keywords are found
39	1.2999410629272	Related Products End	After the related products are found
40	1.3380260467529	Product End	End of the product info controller (Product Info)
41	1.3410029411316	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.3431429862976	Before Get Options	Before the call to getOptions in the tpl class
43	1.4861769676208	After Get Options	After the call to getOptions in the tpl class
44	1.4864110946655	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.4864571094513	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.5118761062622	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.5118839740753	Product Info: Before Template Display	Before the template is displayed
48	1.5831999778748	Product Info: After Template Display	After the template is displayed
49	1.5832240581512	Finalizing debug	Before the debug is output to the page.
50	1.5832419395447	End of App	This is the end of the app logging, final timestamp

Query Debug - 270 Database Queries. Total time 1.1337 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739265821'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags' LIMIT 1
SELECT id FROM products WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags' 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 = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags'
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.97.14.85') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.85') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 1038
SELECT * FROM manufacturers WHERE id = '263'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '263'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '263' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '263' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '1009' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '263'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '263'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '263'
SELECT category_id FROM products_categories WHERE product_id = '1038'
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 = '1038' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1038'
SELECT * FROM productcustomimages WHERE product_id = '1038'
SELECT * FROM productfeeds WHERE product_id = '1038' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1038' 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 = '1038' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '1038'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1038' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1038
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1038'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1038' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 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 ('dragonfly teas rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AND 1038 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
SELECT *, MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
SELECT *, MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
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 = '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 = '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 categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1038') 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 <> '1038' 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 <> '1038' 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 <> '1038' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1204'
SELECT * FROM productcustomimages WHERE product_id = '1204'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1204' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 1038
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1038' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '1038'
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 = '1038' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1038' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1038
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1038'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1038'
SELECT value FROM productattributes WHERE product_id = '1038' 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 = '1038' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1038' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1038
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1038'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '1038' 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.0020	0.0019750595092773	SELECT parameter, value FROM parameters
2	0.0041	0.004148006439209	SELECT * FROM `bad_bots`
3	0.0004	0.0003659725189209	SET time_zone = 'Europe/London'
4	0.0022	0.0021588802337646	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0019	0.0018999576568604	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.85\";}'
6	0.0020	0.0019609928131104	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1739265821'
7	0.0039	0.0038979053497314	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0018	0.0017991065979004	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0035	0.0035078525543213	SELECT id FROM pages WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags' LIMIT 1
10	0.0038	0.0037519931793213	SELECT id FROM products WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags' AND hidden = 0 LIMIT 1
11	0.0031	0.0030710697174072	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0320	0.032027006149292	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0010	0.0010471343994141	SELECT * FROM pages WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags'
14	0.0035	0.0034940242767334	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0037	0.0037240982055664	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0165	0.016515016555786	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.0051	0.0050559043884277	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.0019	0.001945972442627	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00053596496582031	SELECT id FROM categories WHERE parent_id = '26'
20	0.0074	0.0074219703674316	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.0020	0.0020439624786377	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.0017969608306885	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.0019	0.0019450187683105	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0006	0.00057816505432129	SELECT * FROM categorygroups WHERE id = '1'
25	0.0035	0.003547191619873	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.0005800724029541	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.0004420280456543	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0004	0.00043106079101562	SELECT id FROM categories WHERE parent_id = '27'
29	0.0058	0.0057518482208252	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.0014	0.0013749599456787	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.0011060237884521	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.0011	0.0010640621185303	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0009	0.00088405609130859	SELECT * FROM categorygroups WHERE id = '1'
34	0.0050	0.0049641132354736	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.0013	0.0012879371643066	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.0071	0.0071320533752441	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0008	0.00078606605529785	SELECT id FROM categories WHERE parent_id = '28'
38	0.0029	0.0028622150421143	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.0017	0.0017352104187012	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.0026	0.0025508403778076	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.0018	0.0017809867858887	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0006	0.00063514709472656	SELECT * FROM categorygroups WHERE id = '1'
43	0.0011	0.0011160373687744	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.0010	0.00095295906066895	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.0008	0.00084090232849121	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0009	0.00088191032409668	SELECT id FROM categories WHERE parent_id = '29'
47	0.0016	0.0016109943389893	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.0009	0.00090694427490234	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.0010	0.00096297264099121	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.0012	0.0011861324310303	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0008	0.00075292587280273	SELECT * FROM categorygroups WHERE id = '1'
52	0.0012	0.0012469291687012	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.0008	0.00078797340393066	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.00056004524230957	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0006	0.00057291984558105	SELECT id FROM categories WHERE parent_id = '30'
56	0.0010	0.0010302066802979	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.00071406364440918	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.0007779598236084	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0007	0.0006711483001709	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0006	0.0005650520324707	SELECT * FROM categorygroups WHERE id = '1'
61	0.0009	0.00094509124755859	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0007	0.00065183639526367	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.00054597854614258	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0006	0.00062012672424316	SELECT id FROM categories WHERE parent_id = '31'
65	0.0010	0.0010440349578857	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.0008	0.00075507164001465	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.00068187713623047	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0006	0.00061893463134766	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0006	0.00057601928710938	SELECT * FROM categorygroups WHERE id = '1'
70	0.0006	0.00064706802368164	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0048	0.0048470497131348	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0026	0.0025579929351807	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0006	0.00063300132751465	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.0015	0.0015170574188232	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0012	0.0012280941009521	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0011	0.0011239051818848	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.5923	0.59232306480408	SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.85') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.85') <= INET_ATON(ip_end)
78	0.0021	0.0021190643310547	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0012	0.0011990070343018	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0007	0.0007169246673584	SELECT * FROM products WHERE pagename = 'dragonfly-teas-rooibos-breakfast-4-x-40-bags'
81	0.0005	0.00045680999755859	UPDATE products SET viewcount = viewcount + 1 WHERE id = 1038
82	0.0010	0.0010058879852295	SELECT * FROM manufacturers WHERE id = '263'
83	0.0009	0.00088691711425781	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '263'
84	0.0030	0.003046989440918	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '263' LIMIT 1
85	0.0028	0.0028450489044189	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '263' ORDER BY RAND() LIMIT 1
86	0.0006	0.00063109397888184	SELECT * FROM productimages WHERE product_id = '1009' ORDER BY sortorder ASC
87	0.0006	0.00059604644775391	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '263'
88	0.0006	0.00063705444335938	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '263' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0005	0.00052213668823242	SELECT * FROM manufacturerimages WHERE manufacturer_id = '263'
90	0.0005	0.00054311752319336	SELECT category_id FROM products_categories WHERE product_id = '1038'
91	0.0006	0.00060701370239258	SELECT * FROM categories WHERE id = '27'
92	0.0057	0.0057270526885986	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.00061702728271484	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94	0.0004	0.00044512748718262	SELECT id FROM categories WHERE parent_id = '27'
95	0.0047	0.0047399997711182	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.0006561279296875	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.00067305564880371	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.00061488151550293	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99	0.0009	0.00093579292297363	SELECT * FROM productimages WHERE product_id = '1038' ORDER BY sortorder ASC
100	0.0019	0.0019090175628662	SELECT * FROM product_image_select WHERE product_id = '1038'
101	0.0024	0.0024020671844482	SELECT * FROM productcustomimages WHERE product_id = '1038'
102	0.0021	0.0020890235900879	SELECT * FROM productfeeds WHERE product_id = '1038' ORDER BY item_date DESC
103	0.0029	0.0029230117797852	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104	0.0038	0.0037569999694824	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '1038' AND t.hidden = 0 AND display_product = 1
105	0.0019	0.0018830299377441	SELECT * FROM productamazoncontent WHERE product_id = '1038'
106	0.0030	0.0029568672180176	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname
107	0.0025	0.0025010108947754	SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
108	0.0009	0.0009000301361084	SELECT * FROM productoffers WHERE product_id = '1038' AND price > 0 ORDER BY price ASC LIMIT 1
109	0.0004	0.00044488906860352	SELECT * FROM productoffers WHERE product_id = 1038 ORDER BY price ASC LIMIT 1
110	0.0017	0.0016961097717285	SELECT value FROM productattributes WHERE product_id = '1038' AND name = 'ListPriceAmount'
111	0.0005	0.0005190372467041	SELECT value FROM productattributes WHERE product_id = '1038' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112	0.0006	0.00059199333190918	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
113	0.0144	0.014364957809448	SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114	0.0008	0.00083589553833008	SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
115	0.0008	0.00076603889465332	SELECT *, MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('x 40 bags' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
116	0.0008	0.00080490112304688	SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
117	0.0007	0.00065088272094727	SELECT * FROM product_image_select WHERE product_id = '862'
118	0.0006	0.00060296058654785	SELECT * FROM productcustomimages WHERE product_id = '862'
119	0.0010	0.001032829284668	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
120	0.0009	0.00091004371643066	SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
121	0.0007	0.00065302848815918	SELECT * FROM productoffers WHERE product_id = '862' AND price > 0 ORDER BY price ASC LIMIT 1
122	0.0010	0.00097203254699707	SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123	0.0012	0.0011520385742188	SELECT * FROM productimages WHERE product_id = '938' ORDER BY sortorder ASC
124	0.0021	0.0021359920501709	SELECT * FROM product_image_select WHERE product_id = '938'
125	0.0018	0.0018000602722168	SELECT * FROM productcustomimages WHERE product_id = '938'
126	0.0019	0.0018770694732666	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '938' AND a.name = n.originalname
127	0.0012	0.0011899471282959	SELECT * FROM productoffers WHERE product_id = '938' AND merchantid = 'A1X6FK5RDHNB96'
128	0.0011	0.0010809898376465	SELECT * FROM productoffers WHERE product_id = '938' AND price > 0 ORDER BY price ASC LIMIT 1
129	0.0019	0.0019378662109375	SELECT value FROM productattributes WHERE product_id = '938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130	0.0245	0.024549007415771	SELECT *, MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AND 1038 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
131	0.0013	0.0012650489807129	SELECT *, MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
132	0.0021	0.0021400451660156	SELECT *, MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('dragonfly teas rooibos' IN BOOLEAN MODE) AND 1038 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
133	0.0012	0.0011699199676514	SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
134	0.0013	0.0012869834899902	SELECT * FROM product_image_select WHERE product_id = '862'
135	0.0006	0.00056910514831543	SELECT * FROM productcustomimages WHERE product_id = '862'
136	0.0012	0.0012199878692627	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
137	0.0025	0.0025379657745361	SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
138	0.0080	0.0080099105834961	SELECT * FROM productoffers WHERE product_id = '862' AND price > 0 ORDER BY price ASC LIMIT 1
139	0.0007	0.00069212913513184	SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140	0.0010	0.00097203254699707	SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
141	0.0009	0.00088381767272949	SELECT * FROM product_image_select WHERE product_id = '865'
142	0.0005	0.00054407119750977	SELECT * FROM productcustomimages WHERE product_id = '865'
143	0.0011	0.0011179447174072	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
144	0.0007	0.0006721019744873	SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
145	0.0006	0.00060391426086426	SELECT * FROM productoffers WHERE product_id = '865' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0006	0.00060105323791504	SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0006	0.00064206123352051	SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
148	0.0010	0.0010280609130859	SELECT * FROM product_image_select WHERE product_id = '878'
149	0.0006	0.00063490867614746	SELECT * FROM productcustomimages WHERE product_id = '878'
150	0.0019	0.0018858909606934	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
151	0.0008	0.00076794624328613	SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
152	0.0007	0.00066590309143066	SELECT * FROM productoffers WHERE product_id = '878' AND price > 0 ORDER BY price ASC LIMIT 1
153	0.0008	0.00075912475585938	SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154	0.0011	0.0010919570922852	SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
155	0.0010	0.0010180473327637	SELECT * FROM product_image_select WHERE product_id = '858'
156	0.0007	0.00074219703674316	SELECT * FROM productcustomimages WHERE product_id = '858'
157	0.0022	0.0021531581878662	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
158	0.0017	0.0016541481018066	SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
159	0.0016	0.0015850067138672	SELECT * FROM productoffers WHERE product_id = '858' AND price > 0 ORDER BY price ASC LIMIT 1
160	0.0011	0.001107931137085	SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161	0.0020	0.0020480155944824	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '1038') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
162	0.0181	0.018054962158203	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 <> '1038' ORDER BY RAND()
163	0.0010	0.00098085403442383	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 <> '1038' ORDER BY RAND()
164	0.0007	0.00068187713623047	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 <> '1038' ORDER BY RAND()
165	0.0007	0.00072097778320312	SELECT * FROM productimages WHERE product_id = '1204' ORDER BY sortorder ASC
166	0.0009	0.00086712837219238	SELECT * FROM product_image_select WHERE product_id = '1204'
167	0.0005	0.00053215026855469	SELECT * FROM productcustomimages WHERE product_id = '1204'
168	0.0009	0.00091910362243652	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1204' AND a.name = n.originalname
169	0.0005	0.00053715705871582	SELECT * FROM productoffers WHERE product_id = '1204' AND merchantid = 'A1X6FK5RDHNB96'
170	0.0005	0.00052499771118164	SELECT * FROM productoffers WHERE product_id = '1204' AND price > 0 ORDER BY price ASC LIMIT 1
171	0.0009	0.00094485282897949	SELECT value FROM productattributes WHERE product_id = '1204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172	0.0007	0.00065207481384277	SELECT id,asin FROM products WHERE parent_id = 1038
173	0.0017	0.001741886138916	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1038' ORDER BY timestamp DESC
174	0.0005	0.00046992301940918	SELECT category_id FROM products_categories WHERE product_id = '1038'
175	0.0005	0.00047516822814941	SELECT * FROM categories WHERE id = '27'
176	0.0038	0.0037660598754883	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
177	0.0005	0.00045084953308105	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
178	0.0003	0.00033402442932129	SELECT id FROM categories WHERE parent_id = '27'
179	0.0041	0.0041189193725586	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
180	0.0008	0.00079607963562012	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
181	0.0006	0.00061297416687012	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
182	0.0006	0.00062203407287598	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
183	0.0009	0.00088381767272949	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname
184	0.0005	0.0005490779876709	SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
185	0.0005	0.0004730224609375	SELECT * FROM productoffers WHERE product_id = '1038' AND price > 0 ORDER BY price ASC LIMIT 1
186	0.0004	0.00040698051452637	SELECT * FROM productoffers WHERE product_id = 1038 ORDER BY price ASC LIMIT 1
187	0.0004	0.00040578842163086	SELECT value FROM productattributes WHERE product_id = '1038' AND name = 'ListPriceAmount'
188	0.0008	0.00075697898864746	SELECT * FROM products WHERE id = '1038'
189	0.0008	0.00083112716674805	SELECT value FROM productattributes WHERE product_id = '1038' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190	0.0009	0.00094008445739746	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1038' AND a.name = n.originalname
191	0.0004	0.00040102005004883	SELECT * FROM productoffers WHERE product_id = '1038' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0004	0.00041508674621582	SELECT * FROM productoffers WHERE product_id = '1038' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0004	0.00037693977355957	SELECT * FROM productoffers WHERE product_id = 1038 ORDER BY price ASC LIMIT 1
194	0.0004	0.0003809928894043	SELECT value FROM productattributes WHERE product_id = '1038' AND name = 'ListPriceAmount'
195	0.0005	0.00046300888061523	SELECT category_id FROM products_categories WHERE product_id = '1038' AND prod_type = 'amz'
196	0.0005	0.00052213668823242	SELECT parent_id FROM categories WHERE id = '27'
197	0.0004	0.00038695335388184	SELECT * FROM categories WHERE id = '27'
198	0.0068	0.0068159103393555	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
199	0.0007	0.00065398216247559	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
200	0.0004	0.00043916702270508	SELECT id FROM categories WHERE parent_id = '27'
201	0.0046	0.0046041011810303	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
202	0.0006	0.00058603286743164	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
203	0.0006	0.00059604644775391	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
204	0.0005	0.00051999092102051	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
205	0.0018	0.0017728805541992	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
206	0.0013	0.0013289451599121	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
207	0.0006	0.000640869140625	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
208	0.0187	0.018688917160034	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
209	0.0026	0.0026490688323975	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
210	0.0008	0.00077199935913086	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
211	0.0007	0.00070691108703613	SELECT * FROM products WHERE id = 1626
212	0.0007	0.00070977210998535	SELECT * FROM products WHERE id = 4041
213	0.0007	0.00073814392089844	SELECT * FROM products WHERE id = 4312
214	0.0007	0.00068783760070801	SELECT * FROM products WHERE id = 777
215	0.0007	0.00067400932312012	SELECT * FROM products WHERE id = 3881
216	0.0007	0.00071096420288086	SELECT * FROM products WHERE id = 4213
217	0.0007	0.00072097778320312	SELECT * FROM products WHERE id = '1626'
218	0.0006	0.00061416625976562	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
219	0.0007	0.00071597099304199	SELECT * FROM product_image_select WHERE product_id = '1626'
220	0.0005	0.00048303604125977	SELECT * FROM productcustomimages WHERE product_id = '1626'
221	0.0010	0.0010120868682861	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
222	0.0007	0.0006859302520752	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
223	0.0005	0.0004889965057373	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
224	0.0007	0.00066804885864258	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225	0.0007	0.00069904327392578	SELECT * FROM products WHERE id = '4041'
226	0.0006	0.00057387351989746	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
227	0.0008	0.00076794624328613	SELECT * FROM product_image_select WHERE product_id = '4041'
228	0.0005	0.00045084953308105	SELECT * FROM productcustomimages WHERE product_id = '4041'
229	0.0013	0.0012819766998291	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
230	0.0006	0.00058889389038086	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
231	0.0005	0.00048685073852539	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
232	0.0063	0.0062718391418457	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233	0.0040	0.0039949417114258	SELECT * FROM products WHERE id = '4312'
234	0.0039	0.003896951675415	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
235	0.0039	0.0039379596710205	SELECT * FROM product_image_select WHERE product_id = '4312'
236	0.0040	0.0039758682250977	SELECT * FROM productcustomimages WHERE product_id = '4312'
237	0.0031	0.0030920505523682	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
238	0.0054	0.0054261684417725	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
239	0.0010	0.0010440349578857	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
240	0.0012	0.0012469291687012	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241	0.0015	0.0015411376953125	SELECT * FROM products WHERE id = '777'
242	0.0014	0.0013649463653564	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
243	0.0059	0.0059130191802979	SELECT * FROM product_image_select WHERE product_id = '777'
244	0.0006	0.00063300132751465	SELECT * FROM productcustomimages WHERE product_id = '777'
245	0.0014	0.0013518333435059	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
246	0.0017	0.0016629695892334	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
247	0.0007	0.00072693824768066	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
248	0.0007	0.00066494941711426	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
249	0.0008	0.00075602531433105	SELECT * FROM products WHERE id = '3881'
250	0.0010	0.00099492073059082	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
251	0.0043	0.0043020248413086	SELECT * FROM product_image_select WHERE product_id = '3881'
252	0.0033	0.0032551288604736	SELECT * FROM productcustomimages WHERE product_id = '3881'
253	0.0024	0.0024290084838867	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
254	0.0008	0.00078392028808594	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
255	0.0006	0.00060510635375977	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
256	0.0007	0.00067782402038574	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257	0.0010	0.0010371208190918	SELECT * FROM products WHERE id = '4213'
258	0.0012	0.0011970996856689	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
259	0.0010	0.00095009803771973	SELECT * FROM product_image_select WHERE product_id = '4213'
260	0.0015	0.0015451908111572	SELECT * FROM productcustomimages WHERE product_id = '4213'
261	0.0072	0.0072360038757324	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
262	0.0040	0.0039701461791992	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
263	0.0038	0.003849983215332	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
264	0.0010	0.00097417831420898	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265	0.0046	0.0046119689941406	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
266	0.0018	0.0017578601837158	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
267	0.0061	0.0061399936676025	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
268	0.0053	0.0053000450134277	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
269	0.0027	0.0027298927307129	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
270	0.0031	0.0031230449676514	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Dragonfly Teas | Rooibos Breakfast | 4 x 40 Bags

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

Tick Tock Original Organic Rooibos Tea B...

HolyCup Rooibos Tea Nespresso® Capsules ...

Rooibos INFUSION 17 SACHETS

BADERs Cynarin Artischocke. Thé rooibos ...

Jardins De GaÏa - JARDINS DE GAÏA - Elix...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5832440853119 seconds

Query Debug - 270 Database Queries. Total time 1.1337 seconds

Dragonfly Teas | Rooibos Breakfast | 4 x 40 Bags

Related Products

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

Tick Tock Original Organic Rooibos Tea B...

HolyCup Rooibos Tea Nespresso® Capsules ...

Rooibos INFUSION 17 SACHETS

BADERs Cynarin Artischocke. Thé rooibos ...

Jardins De GaÏa - JARDINS DE GAÏA - Elix...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5832440853119 seconds

Query Debug - 270 Database Queries. Total time 1.1337 seconds