Ocun Eternal Pants Men Rooibos Tea| S

Price: Click Button for Price

As of 2022-06-13 18:42:46 UTC (more info)

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

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

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

Product Features

Ocun eternal pants men rooibos tea| s

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
2.3569509983063	275	1.1269	0

No Amazon API Requests Made.

App Debug - Total Time 2.3569509983063 seconds

Number	Time From Start	Name	Description
1	0.91676688194275	Initialise	Initialise FSB Function
2	0.9244270324707	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.97868585586548	Start of getCategoryListByGroup Function	Before first category groups query
4	0.98384785652161	After initial query	Before first category groups query
5	0.98385190963745	Get Category List for Group	Before the call to getCategoryList function
6	0.98385906219482	Start of GetCategoryList function	Start of the function
7	0.98386597633362	Before getting categories	Query to get specific category list
8	0.98870801925659	After getting categories	Query to get specific category list
9	0.98871207237244	Before getting category custom	Before call to function getCategoryCustom
10	1.0337629318237	After getting category custom	After call to function getCategoryCustom
11	1.0337688922882	Before getting category custom	Before call to function getCategoryCustom
12	1.0495779514313	After getting category custom	After call to function getCategoryCustom
13	1.0495829582214	Before getting category custom	Before call to function getCategoryCustom
14	1.0608818531036	After getting category custom	After call to function getCategoryCustom
15	1.0608880519867	Before getting category custom	Before call to function getCategoryCustom
16	1.0707750320435	After getting category custom	After call to function getCategoryCustom
17	1.0711879730225	Before getting category custom	Before call to function getCategoryCustom
18	1.087965965271	After getting category custom	After call to function getCategoryCustom
19	1.0879719257355	Before getting category custom	Before call to function getCategoryCustom
20	1.1074559688568	After getting category custom	After call to function getCategoryCustom
21	1.1074619293213	End of GetCategoryList function	End of the function
22	1.1074910163879	Get Category List for Group	Before the call to getCategoryList function
23	1.1074950695038	Start of GetCategoryList function	Start of the function
24	1.1074998378754	Before getting categories	Query to get specific category list
25	1.1082949638367	End of getCategoryListByGroup Function	Before return()
26	1.7627029418945	App Controller End	End of the App controller (called before the controller of every page)
27	1.7657890319824	Product Start	Start of the product info controller
28	1.7835729122162	Cache file not found	Starting get product details
29	1.8314919471741	Related products	Start getting related products if enabled
30	1.8314960002899	Related Products Start	Before the related products are found
31	1.8314979076385	Related Products Keywords	Before the related product keywords are found
32	1.8315088748932	Create Keyword List Function	Start of function
33	1.831670999527	Create Keyword List Function	After looping provided content - 18 keywords found
34	1.8332488536835	Create Keyword List Function	After looping initial keyword list - 15 keywords remaining
35	1.833281993866	Create Keyword List Function	After reducing keyword list
36	1.8333990573883	Create Keyword List Function	After selecting by scoring keywords
37	1.8334078788757	Create Keyword List Function	After final loop of keywords
38	1.8334159851074	Related Products Keywords	After the related product keywords are found
39	1.9198739528656	Related Products End	After the related products are found
40	1.9801819324493	Product End	End of the product info controller (Product Info)
41	1.9836509227753	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.9859478473663	Before Get Options	Before the call to getOptions in the tpl class
43	2.0696139335632	After Get Options	After the call to getOptions in the tpl class
44	2.0698919296265	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	2.069944858551	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	2.1950688362122	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	2.1950778961182	Product Info: Before Template Display	Before the template is displayed
48	2.3569009304047	Product Info: After Template Display	After the template is displayed
49	2.3569259643555	Finalizing debug	Before the debug is output to the page.
50	2.3569488525391	End of App	This is the end of the app logging, final timestamp

Query Debug - 275 Database Queries. Total time 1.1269 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:13:\"98.82.120.188\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1725942516'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s' LIMIT 1
SELECT id FROM products WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s' 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 = 'ocun-eternal-pants-men-rooibos-tea-s'
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('98.82.120.188') >= INET_ATON(ip_start) AND INET_ATON('98.82.120.188') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 3744
SELECT * FROM manufacturers WHERE id = '438'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '438' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '438' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '438'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '438'
SELECT category_id FROM products_categories WHERE product_id = '3744'
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 = '3744' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3744'
SELECT * FROM productcustomimages WHERE product_id = '3744'
SELECT * FROM productfeeds WHERE product_id = '3744' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3744' 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 = '3744' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '3744'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3744' 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 ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3744') 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 <> '3744' 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 <> '3744' 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 <> '3744' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '896' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '896'
SELECT * FROM productcustomimages WHERE product_id = '896'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '896' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '896' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '896' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '896' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '993' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '993'
SELECT * FROM productcustomimages WHERE product_id = '993'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '993' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '993' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '993' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 993
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '993'
                AND name = 'ListPriceAmount'
SELECT * FROM productimages WHERE product_id = '1513' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1513'
SELECT * FROM productcustomimages WHERE product_id = '1513'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1513' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1513
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1513'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '911' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '911'
SELECT * FROM productcustomimages WHERE product_id = '911'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '911' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '911' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '911' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '911' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1075' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1075'
SELECT * FROM productcustomimages WHERE product_id = '1075'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1075' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1075' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1075' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1075
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1075'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1075' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4201'
SELECT * FROM productcustomimages WHERE product_id = '4201'
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 = '4201'
                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     = '4201'
                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 = 4201
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4201' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4201
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4201'
                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 = '4201'
                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     = '4201'
                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 = 4201
SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '4201'
SELECT id,asin FROM products WHERE parent_id = 3744
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3744' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '3744'
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 = '3744' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3744'
SELECT value FROM productattributes WHERE product_id = '3744' 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 = '3744' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3744' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3744
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3744'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '3744' 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.0021579265594482	SELECT parameter, value FROM parameters
2	0.0098	0.0098280906677246	SELECT * FROM `bad_bots`
3	0.0007	0.00068807601928711	SET time_zone = 'Europe/London'
4	0.0041	0.0040631294250488	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0061	0.0061459541320801	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"98.82.120.188\";}'
6	0.0060	0.006011962890625	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1725942516'
7	0.0038	0.0038411617279053	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0009	0.00089693069458008	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0026	0.0025880336761475	SELECT id FROM pages WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s' LIMIT 1
10	0.0025	0.0024960041046143	SELECT id FROM products WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s' AND hidden = 0 LIMIT 1
11	0.0040	0.0040490627288818	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0483	0.048343181610107	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0010	0.00095200538635254	SELECT * FROM pages WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s'
14	0.0051	0.0051209926605225	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0048	0.0047919750213623	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0176	0.017616033554077	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.0036	0.0036330223083496	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.0028	0.0028228759765625	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0018	0.0018289089202881	SELECT id FROM categories WHERE parent_id = '26'
20	0.0081	0.0081140995025635	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.0036	0.0035629272460938	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.0031	0.0031070709228516	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.0032	0.0031659603118896	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0007	0.00074219703674316	SELECT * FROM categorygroups WHERE id = '1'
25	0.0048	0.0047740936279297	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.0008	0.00081682205200195	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0005	0.00050020217895508	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0006	0.0006101131439209	SELECT id FROM categories WHERE parent_id = '27'
29	0.0051	0.0050590038299561	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.0010	0.00099897384643555	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.0010	0.00095200538635254	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.0008	0.00078296661376953	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00053095817565918	SELECT * FROM categorygroups WHERE id = '1'
34	0.0021	0.0021021366119385	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0006	0.00059604644775391	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.0016	0.0015521049499512	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0007	0.00068402290344238	SELECT id FROM categories WHERE parent_id = '28'
38	0.0030	0.0030090808868408	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.0008	0.00076794624328613	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0007	0.00072813034057617	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.0008	0.00080990791320801	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0008	0.00083518028259277	SELECT * FROM categorygroups WHERE id = '1'
43	0.0010	0.00095391273498535	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0007	0.00069594383239746	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.0013	0.0013360977172852	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0007	0.00068402290344238	SELECT id FROM categories WHERE parent_id = '29'
47	0.0014	0.0014059543609619	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.0015	0.0014538764953613	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.0013	0.0013232231140137	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.0009	0.00088691711425781	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0009	0.00092792510986328	SELECT * FROM categorygroups WHERE id = '1'
52	0.0025	0.0025250911712646	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.0016	0.0015668869018555	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.0010	0.00097298622131348	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0010	0.0009610652923584	SELECT id FROM categories WHERE parent_id = '30'
56	0.0051	0.0050528049468994	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.0014	0.0014359951019287	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.0016	0.0016391277313232	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.0014	0.0013518333435059	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0010	0.0010228157043457	SELECT * FROM categorygroups WHERE id = '1'
61	0.0021	0.0021240711212158	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.0017	0.0017261505126953	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.0010	0.00095796585083008	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0015	0.0014638900756836	SELECT id FROM categories WHERE parent_id = '31'
65	0.0039	0.0039429664611816	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.0016	0.0015799999237061	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.0017	0.001680850982666	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.0013	0.0013351440429688	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0008	0.00076603889465332	SELECT * FROM categorygroups WHERE id = '1'
70	0.0008	0.00077199935913086	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0054	0.0053579807281494	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0044	0.004371166229248	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0024	0.0023789405822754	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.0027	0.0027139186859131	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0022	0.0021929740905762	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0043	0.0043349266052246	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.6185	0.61853504180908	SELECT * FROM ipgeocountries WHERE INET_ATON('98.82.120.188') >= INET_ATON(ip_start) AND INET_ATON('98.82.120.188') <= INET_ATON(ip_end)
78	0.0028	0.0028071403503418	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0025	0.002525806427002	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0009	0.00091290473937988	SELECT * FROM products WHERE pagename = 'ocun-eternal-pants-men-rooibos-tea-s'
81	0.0006	0.00056195259094238	UPDATE products SET viewcount = viewcount + 1 WHERE id = 3744
82	0.0009	0.00085997581481934	SELECT * FROM manufacturers WHERE id = '438'
83	0.0009	0.00090384483337402	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
84	0.0031	0.0030920505523682	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '438' LIMIT 1
85	0.0029	0.002918004989624	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '438' ORDER BY RAND() LIMIT 1
86	0.0008	0.00075292587280273	SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
87	0.0009	0.00092601776123047	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '438'
88	0.0007	0.00065207481384277	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '438' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0005	0.00052905082702637	SELECT * FROM manufacturerimages WHERE manufacturer_id = '438'
90	0.0005	0.00050902366638184	SELECT category_id FROM products_categories WHERE product_id = '3744'
91	0.0006	0.00060486793518066	SELECT * FROM categories WHERE id = '27'
92	0.0036	0.0036189556121826	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.0005	0.00048708915710449	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94	0.0005	0.00046300888061523	SELECT id FROM categories WHERE parent_id = '27'
95	0.0039	0.0038671493530273	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.0009	0.00091099739074707	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.00070810317993164	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.0020	0.0020217895507812	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99	0.0012	0.001227855682373	SELECT * FROM productimages WHERE product_id = '3744' ORDER BY sortorder ASC
100	0.0021	0.0021088123321533	SELECT * FROM product_image_select WHERE product_id = '3744'
101	0.0027	0.0027339458465576	SELECT * FROM productcustomimages WHERE product_id = '3744'
102	0.0014	0.0013799667358398	SELECT * FROM productfeeds WHERE product_id = '3744' ORDER BY item_date DESC
103	0.0028	0.0027709007263184	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104	0.0028	0.0027890205383301	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '3744' AND t.hidden = 0 AND display_product = 1
105	0.0017	0.0016880035400391	SELECT * FROM productamazoncontent WHERE product_id = '3744'
106	0.0012	0.0012168884277344	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
107	0.0015	0.0014569759368896	SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
108	0.0005	0.00051188468933105	SELECT * FROM productoffers WHERE product_id = '3744' AND price > 0 ORDER BY price ASC LIMIT 1
109	0.0010	0.0010018348693848	SELECT * FROM productoffers WHERE product_id = 3744 ORDER BY price ASC LIMIT 1
110	0.0017	0.0017330646514893	SELECT value FROM productattributes WHERE product_id = '3744' AND name = 'ListPriceAmount'
111	0.0008	0.00075411796569824	SELECT value FROM productattributes WHERE product_id = '3744' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112	0.0012	0.0011749267578125	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.0109	0.01090407371521	SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114	0.0013	0.0013349056243896	SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
115	0.0030	0.0030219554901123	SELECT *, MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('ocun eternal pants' IN BOOLEAN MODE) AND 3744 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
116	0.0025	0.0025441646575928	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '3744') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
117	0.0121	0.012082099914551	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 <> '3744' ORDER BY RAND()
118	0.0009	0.00088381767272949	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 <> '3744' ORDER BY RAND()
119	0.0009	0.00088405609130859	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 <> '3744' ORDER BY RAND()
120	0.0007	0.00072813034057617	SELECT * FROM productimages WHERE product_id = '896' ORDER BY sortorder ASC
121	0.0015	0.0015459060668945	SELECT * FROM product_image_select WHERE product_id = '896'
122	0.0008	0.00079607963562012	SELECT * FROM productcustomimages WHERE product_id = '896'
123	0.0022	0.0022029876708984	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '896' AND a.name = n.originalname
124	0.0008	0.00077486038208008	SELECT * FROM productoffers WHERE product_id = '896' AND merchantid = 'A1X6FK5RDHNB96'
125	0.0006	0.00057601928710938	SELECT * FROM productoffers WHERE product_id = '896' AND price > 0 ORDER BY price ASC LIMIT 1
126	0.0005	0.00054407119750977	SELECT value FROM productattributes WHERE product_id = '896' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127	0.0007	0.00066804885864258	SELECT * FROM productimages WHERE product_id = '993' ORDER BY sortorder ASC
128	0.0012	0.0011858940124512	SELECT * FROM product_image_select WHERE product_id = '993'
129	0.0006	0.00059199333190918	SELECT * FROM productcustomimages WHERE product_id = '993'
130	0.0018	0.001823902130127	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '993' AND a.name = n.originalname
131	0.0008	0.00076007843017578	SELECT * FROM productoffers WHERE product_id = '993' AND merchantid = 'A1X6FK5RDHNB96'
132	0.0006	0.00057792663574219	SELECT * FROM productoffers WHERE product_id = '993' AND price > 0 ORDER BY price ASC LIMIT 1
133	0.0006	0.00062179565429688	SELECT * FROM productoffers WHERE product_id = 993 ORDER BY price ASC LIMIT 1
134	0.0006	0.00060319900512695	SELECT value FROM productattributes WHERE product_id = '993' AND name = 'ListPriceAmount'
135	0.0008	0.00075197219848633	SELECT * FROM productimages WHERE product_id = '1513' ORDER BY sortorder ASC
136	0.0010	0.00096511840820312	SELECT * FROM product_image_select WHERE product_id = '1513'
137	0.0014	0.0013508796691895	SELECT * FROM productcustomimages WHERE product_id = '1513'
138	0.0016	0.0015528202056885	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1513' AND a.name = n.originalname
139	0.0009	0.00085306167602539	SELECT * FROM productoffers WHERE product_id = '1513' AND merchantid = 'A1X6FK5RDHNB96'
140	0.0006	0.00064206123352051	SELECT * FROM productoffers WHERE product_id = '1513' AND price > 0 ORDER BY price ASC LIMIT 1
141	0.0005	0.00054001808166504	SELECT * FROM productoffers WHERE product_id = 1513 ORDER BY price ASC LIMIT 1
142	0.0007	0.0006721019744873	SELECT value FROM productattributes WHERE product_id = '1513' AND name = 'ListPriceAmount'
143	0.0013	0.0013039112091064	SELECT value FROM productattributes WHERE product_id = '1513' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144	0.0008	0.0008399486541748	SELECT * FROM productimages WHERE product_id = '911' ORDER BY sortorder ASC
145	0.0008	0.00078010559082031	SELECT * FROM product_image_select WHERE product_id = '911'
146	0.0006	0.00057792663574219	SELECT * FROM productcustomimages WHERE product_id = '911'
147	0.0015	0.0014679431915283	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '911' AND a.name = n.originalname
148	0.0005	0.00054383277893066	SELECT * FROM productoffers WHERE product_id = '911' AND merchantid = 'A1X6FK5RDHNB96'
149	0.0005	0.00045990943908691	SELECT * FROM productoffers WHERE product_id = '911' AND price > 0 ORDER BY price ASC LIMIT 1
150	0.0004	0.0004417896270752	SELECT value FROM productattributes WHERE product_id = '911' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0006	0.00061607360839844	SELECT * FROM productimages WHERE product_id = '1075' ORDER BY sortorder ASC
152	0.0007	0.00067591667175293	SELECT * FROM product_image_select WHERE product_id = '1075'
153	0.0004	0.00042986869812012	SELECT * FROM productcustomimages WHERE product_id = '1075'
154	0.0010	0.0010461807250977	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1075' AND a.name = n.originalname
155	0.0005	0.00048995018005371	SELECT * FROM productoffers WHERE product_id = '1075' AND merchantid = 'A1X6FK5RDHNB96'
156	0.0005	0.00046491622924805	SELECT * FROM productoffers WHERE product_id = '1075' AND price > 0 ORDER BY price ASC LIMIT 1
157	0.0004	0.00043201446533203	SELECT * FROM productoffers WHERE product_id = 1075 ORDER BY price ASC LIMIT 1
158	0.0005	0.00045108795166016	SELECT value FROM productattributes WHERE product_id = '1075' AND name = 'ListPriceAmount'
159	0.0008	0.0007779598236084	SELECT value FROM productattributes WHERE product_id = '1075' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160	0.0007	0.00066781044006348	SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
161	0.0007	0.00071406364440918	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
162	0.0010	0.0010490417480469	SELECT * FROM product_image_select WHERE product_id = '4201'
163	0.0016	0.0015659332275391	SELECT * FROM productcustomimages WHERE product_id = '4201'
164	0.0007	0.0006709098815918	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 = '4201' GROUP BY o.product_id
165	0.0037	0.0036890506744385	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 = '4201' GROUP BY n.displayname ORDER BY n.displayname DESC
166	0.0006	0.0006098747253418	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
167	0.0010	0.0010139942169189	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
168	0.0005	0.0004880428314209	SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
169	0.0008	0.00081706047058105	SELECT * FROM productoffers WHERE product_id = '4201' AND price > 0 ORDER BY price ASC LIMIT 1
170	0.0006	0.00061917304992676	SELECT * FROM productoffers WHERE product_id = 4201 ORDER BY price ASC LIMIT 1
171	0.0006	0.00058913230895996	SELECT value FROM productattributes WHERE product_id = '4201' AND name = 'ListPriceAmount'
172	0.0006	0.00056600570678711	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 = '4201' GROUP BY o.product_id
173	0.0009	0.00092101097106934	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 = '4201' GROUP BY n.displayname ORDER BY n.displayname DESC
174	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 = 4201
175	0.0009	0.00088191032409668	SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176	0.0012	0.0012290477752686	SELECT * FROM products WHERE parent_id = '4201'
177	0.0005	0.00048398971557617	SELECT id,asin FROM products WHERE parent_id = 3744
178	0.0025	0.0025169849395752	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3744' ORDER BY timestamp DESC
179	0.0015	0.0015189647674561	SELECT category_id FROM products_categories WHERE product_id = '3744'
180	0.0008	0.00075912475585938	SELECT * FROM categories WHERE id = '27'
181	0.0067	0.0066678524017334	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
182	0.0006	0.00057506561279297	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
183	0.0004	0.00043892860412598	SELECT id FROM categories WHERE parent_id = '27'
184	0.0061	0.006119966506958	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
185	0.0009	0.00093317031860352	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
186	0.0012	0.0011730194091797	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
187	0.0007	0.00066518783569336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
188	0.0016	0.0016288757324219	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
189	0.0007	0.00072503089904785	SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
190	0.0005	0.00052094459533691	SELECT * FROM productoffers WHERE product_id = '3744' AND price > 0 ORDER BY price ASC LIMIT 1
191	0.0005	0.00045084953308105	SELECT * FROM productoffers WHERE product_id = 3744 ORDER BY price ASC LIMIT 1
192	0.0005	0.00050210952758789	SELECT value FROM productattributes WHERE product_id = '3744' AND name = 'ListPriceAmount'
193	0.0008	0.00075888633728027	SELECT * FROM products WHERE id = '3744'
194	0.0008	0.00076818466186523	SELECT value FROM productattributes WHERE product_id = '3744' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195	0.0026	0.0025758743286133	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3744' AND a.name = n.originalname
196	0.0008	0.00083804130554199	SELECT * FROM productoffers WHERE product_id = '3744' AND merchantid = 'A1X6FK5RDHNB96'
197	0.0009	0.00094008445739746	SELECT * FROM productoffers WHERE product_id = '3744' AND price > 0 ORDER BY price ASC LIMIT 1
198	0.0008	0.00077009201049805	SELECT * FROM productoffers WHERE product_id = 3744 ORDER BY price ASC LIMIT 1
199	0.0010	0.0010368824005127	SELECT value FROM productattributes WHERE product_id = '3744' AND name = 'ListPriceAmount'
200	0.0011	0.0011482238769531	SELECT category_id FROM products_categories WHERE product_id = '3744' AND prod_type = 'amz'
201	0.0010	0.00097203254699707	SELECT parent_id FROM categories WHERE id = '27'
202	0.0011	0.0010750293731689	SELECT * FROM categories WHERE id = '27'
203	0.0104	0.010365962982178	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
204	0.0010	0.00095891952514648	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
205	0.0006	0.0005650520324707	SELECT id FROM categories WHERE parent_id = '27'
206	0.0072	0.0072400569915771	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
207	0.0009	0.00093889236450195	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
208	0.0011	0.0010850429534912	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
209	0.0008	0.00078296661376953	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
210	0.0020	0.0020110607147217	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
211	0.0016	0.001619815826416	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
212	0.0005	0.0005190372467041	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
213	0.0144	0.014435052871704	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
214	0.0020	0.0019640922546387	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
215	0.0015	0.0015161037445068	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
216	0.0010	0.0010008811950684	SELECT * FROM products WHERE id = 1626
217	0.0004	0.00044083595275879	SELECT * FROM products WHERE id = 4041
218	0.0006	0.00056004524230957	SELECT * FROM products WHERE id = 4312
219	0.0006	0.00061488151550293	SELECT * FROM products WHERE id = 777
220	0.0005	0.0005190372467041	SELECT * FROM products WHERE id = 3881
221	0.0006	0.00057792663574219	SELECT * FROM products WHERE id = 4213
222	0.0006	0.0005640983581543	SELECT * FROM products WHERE id = '1626'
223	0.0007	0.00067806243896484	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
224	0.0010	0.0010042190551758	SELECT * FROM product_image_select WHERE product_id = '1626'
225	0.0006	0.00057101249694824	SELECT * FROM productcustomimages WHERE product_id = '1626'
226	0.0010	0.0010180473327637	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
227	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0005	0.00049781799316406	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0006	0.00056195259094238	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230	0.0014	0.0014369487762451	SELECT * FROM products WHERE id = '4041'
231	0.0008	0.00084590911865234	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
232	0.0014	0.0013530254364014	SELECT * FROM product_image_select WHERE product_id = '4041'
233	0.0005	0.0005340576171875	SELECT * FROM productcustomimages WHERE product_id = '4041'
234	0.0016	0.0015530586242676	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
235	0.0006	0.00060892105102539	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
236	0.0005	0.00054001808166504	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
237	0.0007	0.00072598457336426	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238	0.0009	0.00089788436889648	SELECT * FROM products WHERE id = '4312'
239	0.0007	0.00073099136352539	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
240	0.0010	0.0010178089141846	SELECT * FROM product_image_select WHERE product_id = '4312'
241	0.0007	0.00069499015808105	SELECT * FROM productcustomimages WHERE product_id = '4312'
242	0.0021	0.0021431446075439	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
243	0.0013	0.0012519359588623	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
244	0.0008	0.00081992149353027	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
245	0.0009	0.00093889236450195	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246	0.0008	0.00077295303344727	SELECT * FROM products WHERE id = '777'
247	0.0007	0.00066804885864258	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
248	0.0009	0.0008699893951416	SELECT * FROM product_image_select WHERE product_id = '777'
249	0.0005	0.00052595138549805	SELECT * FROM productcustomimages WHERE product_id = '777'
250	0.0019	0.0019011497497559	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
251	0.0007	0.00070405006408691	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
252	0.0005	0.00052404403686523	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
253	0.0006	0.00062918663024902	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254	0.0009	0.00090694427490234	SELECT * FROM products WHERE id = '3881'
255	0.0008	0.00077509880065918	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
256	0.0008	0.00080704689025879	SELECT * FROM product_image_select WHERE product_id = '3881'
257	0.0007	0.0006721019744873	SELECT * FROM productcustomimages WHERE product_id = '3881'
258	0.0024	0.002357006072998	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
259	0.0007	0.00070285797119141	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
260	0.0005	0.00050616264343262	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
261	0.0005	0.00054597854614258	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262	0.0007	0.00073909759521484	SELECT * FROM products WHERE id = '4213'
263	0.0007	0.0007169246673584	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
264	0.0006	0.00063800811767578	SELECT * FROM product_image_select WHERE product_id = '4213'
265	0.0006	0.00055885314941406	SELECT * FROM productcustomimages WHERE product_id = '4213'
266	0.0015	0.0014760494232178	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
267	0.0007	0.00070691108703613	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
268	0.0006	0.00055694580078125	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
269	0.0005	0.00049209594726562	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270	0.0026	0.0025708675384521	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
271	0.0010	0.00096297264099121	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
272	0.0034	0.0033929347991943	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
273	0.0022	0.002234935760498	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
274	0.0008	0.00083684921264648	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
275	0.0016	0.0016419887542725	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Ocun Eternal Pants Men Rooibos Tea| S

Product Features

Faith | Pomegranate/Rooibos Conditionr |...

Rooibos Thé spécial feuilles en vrac Thé...

Dragonfly Organic Rooibos Chai Tea Bags ...

Rooibos Canneberge Gingembre BIO | Sache...

Thé "Coba Cabana" - Rooibos Bi...

Alter Éco - Thé Rooibos Au Caramel 40G -...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 2.3569509983063 seconds

Query Debug - 275 Database Queries. Total time 1.1269 seconds

Ocun Eternal Pants Men Rooibos Tea| S

Product Features

Related Products

Faith | Pomegranate/Rooibos Conditionr |...

Rooibos Thé spécial feuilles en vrac Thé...

Dragonfly Organic Rooibos Chai Tea Bags ...

Rooibos Canneberge Gingembre BIO | Sache...

Thé "Coba Cabana" - Rooibos Bi...

Alter Éco - Thé Rooibos Au Caramel 40G -...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 2.3569509983063 seconds

Query Debug - 275 Database Queries. Total time 1.1269 seconds