La Route Des Comptoirs - Rooïbos Safari Lot De 2 - BIO

Price: €13,35

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

Product prices and availability are accurate as of 2021-07-20 22:18:44 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.

Manufacturer Description

Ce mélange est constitué de morceaux de pomme, de cynorrhodon et d'arôme naturel de raisin, offre une infusion aux saveurs fruitées légèrement sucrées et très surprenantes.

Product Features

Rooïbos aromatisé Lot de 2 x 100g

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.8963479995728	276	1.0176	0

No Amazon API Requests Made.

App Debug - Total Time 1.8963479995728 seconds

Number	Time From Start	Name	Description
1	0.67161703109741	Initialise	Initialise FSB Function
2	0.6763379573822	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.71477603912354	Start of getCategoryListByGroup Function	Before first category groups query
4	0.71678113937378	After initial query	Before first category groups query
5	0.71678400039673	Get Category List for Group	Before the call to getCategoryList function
6	0.71678900718689	Start of GetCategoryList function	Start of the function
7	0.71679615974426	Before getting categories	Query to get specific category list
8	0.71901607513428	After getting categories	Query to get specific category list
9	0.71901917457581	Before getting category custom	Before call to function getCategoryCustom
10	0.74748206138611	After getting category custom	After call to function getCategoryCustom
11	0.74748802185059	Before getting category custom	Before call to function getCategoryCustom
12	0.75897598266602	After getting category custom	After call to function getCategoryCustom
13	0.75898218154907	Before getting category custom	Before call to function getCategoryCustom
14	0.7667920589447	After getting category custom	After call to function getCategoryCustom
15	0.76679801940918	Before getting category custom	Before call to function getCategoryCustom
16	0.78081107139587	After getting category custom	After call to function getCategoryCustom
17	0.78081703186035	Before getting category custom	Before call to function getCategoryCustom
18	0.78657603263855	After getting category custom	After call to function getCategoryCustom
19	0.78658103942871	Before getting category custom	Before call to function getCategoryCustom
20	0.79295706748962	After getting category custom	After call to function getCategoryCustom
21	0.79296207427979	End of GetCategoryList function	End of the function
22	0.79297304153442	Get Category List for Group	Before the call to getCategoryList function
23	0.79297709465027	Start of GetCategoryList function	Start of the function
24	0.79298114776611	Before getting categories	Query to get specific category list
25	0.79362201690674	End of getCategoryListByGroup Function	Before return()
26	1.3609700202942	App Controller End	End of the App controller (called before the controller of every page)
27	1.3619160652161	Product Start	Start of the product info controller
28	1.5093171596527	Cache file not found	Starting get product details
29	1.5611979961395	Related products	Start getting related products if enabled
30	1.5612010955811	Related Products Start	Before the related products are found
31	1.5612030029297	Related Products Keywords	Before the related product keywords are found
32	1.5612101554871	Create Keyword List Function	Start of function
33	1.561359167099	Create Keyword List Function	After looping provided content - 27 keywords found
34	1.5628039836884	Create Keyword List Function	After looping initial keyword list - 20 keywords remaining
35	1.562814950943	Create Keyword List Function	After reducing keyword list
36	1.5629041194916	Create Keyword List Function	After selecting by scoring keywords
37	1.5629100799561	Create Keyword List Function	After final loop of keywords
38	1.5629131793976	Related Products Keywords	After the related product keywords are found
39	1.6495909690857	Related Products End	After the related products are found
40	1.6959011554718	Product End	End of the product info controller (Product Info)
41	1.6994841098785	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.7022581100464	Before Get Options	Before the call to getOptions in the tpl class
43	1.8312010765076	After Get Options	After the call to getOptions in the tpl class
44	1.8314340114594	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.8314881324768	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.852126121521	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.8521339893341	Product Info: Before Template Display	Before the template is displayed
48	1.8962910175323	Product Info: After Template Display	After the template is displayed
49	1.896320104599	Finalizing debug	Before the debug is output to the page.
50	1.8963460922241	End of App	This is the end of the app logging, final timestamp

Query Debug - 276 Database Queries. Total time 1.0176 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.84\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1737603221'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-01-23 03:33:41' WHERE id = '16'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio' LIMIT 1
SELECT id FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio' 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 = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio'
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.84') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.84') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 761
SELECT * FROM manufacturers WHERE id = '183'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '183' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '183' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '183'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '183'
SELECT category_id FROM products_categories WHERE product_id = '761'
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 = '761' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '761'
SELECT * FROM productcustomimages WHERE product_id = '761'
SELECT * FROM productfeeds WHERE product_id = '761' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '761' 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 = '761' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '761'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '761' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 761
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '761'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '761' 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 ('comptoirs roo�bos safari' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AND 761 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AND 761 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AND 761 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1093'
SELECT * FROM productcustomimages WHERE product_id = '1093'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4905'
SELECT * FROM productcustomimages WHERE product_id = '4905'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4905' 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 = '761') 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 <> '761' 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 <> '761' 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 <> '761' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '1047' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1047'
SELECT * FROM productcustomimages WHERE product_id = '1047'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1047' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1047' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1047' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1047
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1047'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1047' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '874' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '874'
SELECT * FROM productcustomimages WHERE product_id = '874'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '874' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '874' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '874' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 874
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '874'
                AND name = 'ListPriceAmount'
SELECT * FROM productimages WHERE product_id = '1046' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1046' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1046'
SELECT * FROM productcustomimages WHERE product_id = '1046'
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 = '1046'
                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     = '1046'
                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 = 1046
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1046' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1046' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1046' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1046
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1046'
                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 = '1046'
                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     = '1046'
                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 = 1046
SELECT value FROM productattributes WHERE product_id = '1046' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '1046'
SELECT * FROM productimages WHERE product_id = '882' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '882'
SELECT * FROM productcustomimages WHERE product_id = '882'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '882' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '882' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '882' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 882
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '882'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 761
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '761' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '761'
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 = '761' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '761' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 761
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '761'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '761'
SELECT value FROM productattributes WHERE product_id = '761' 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 = '761' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '761' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 761
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '761'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '761' 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.0023	0.0022809505462646	SELECT parameter, value FROM parameters
2	0.0113	0.011327028274536	SELECT * FROM `bad_bots`
3	0.0006	0.00064396858215332	SET time_zone = 'Europe/London'
4	0.0034	0.0033700466156006	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0037	0.0036869049072266	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.14.84\";}'
6	0.0047	0.0047140121459961	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1737603221'
7	0.0019	0.0018949508666992	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0005	0.0004580020904541	UPDATE autorun SET lastrun = '2025-01-23 03:33:41' WHERE id = '16'
9	0.0005	0.0005180835723877	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0015	0.0014538764953613	SELECT id FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio' LIMIT 1
11	0.0016	0.0016458034515381	SELECT id FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio' AND hidden = 0 LIMIT 1
12	0.0022	0.0022180080413818	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0345	0.034494161605835	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0008	0.00083088874816895	SELECT * FROM pages WHERE pagename = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio'
15	0.0020	0.0019760131835938	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0022	0.0021800994873047	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0080	0.0079858303070068	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
18	0.0028	0.0027651786804199	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19	0.0015	0.0014619827270508	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0005	0.00052499771118164	SELECT id FROM categories WHERE parent_id = '26'
21	0.0079	0.0079290866851807	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
22	0.0027	0.0026748180389404	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
23	0.0016	0.0016160011291504	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
24	0.0015	0.0014581680297852	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0005	0.00050210952758789	SELECT * FROM categorygroups WHERE id = '1'
26	0.0038	0.0038111209869385	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
27	0.0005	0.00054216384887695	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0004	0.0004279613494873	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0004	0.00044083595275879	SELECT id FROM categories WHERE parent_id = '27'
30	0.0039	0.0038919448852539	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
31	0.0006	0.00055480003356934	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
32	0.0006	0.00056600570678711	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
33	0.0005	0.0005190372467041	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0005	0.00050902366638184	SELECT * FROM categorygroups WHERE id = '1'
35	0.0015	0.0014891624450684	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
36	0.0006	0.000579833984375	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0005	0.0004889965057373	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.00047206878662109	SELECT id FROM categories WHERE parent_id = '28'
39	0.0017	0.0017309188842773	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
40	0.0005	0.00053310394287109	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
41	0.0006	0.00064802169799805	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
42	0.0006	0.00060296058654785	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0010	0.0010499954223633	SELECT * FROM categorygroups WHERE id = '1'
44	0.0033	0.0033071041107178	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
45	0.0037	0.0036718845367432	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0020	0.0019528865814209	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0017	0.0016751289367676	SELECT id FROM categories WHERE parent_id = '29'
48	0.0009	0.00094914436340332	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
49	0.0006	0.00058984756469727	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
50	0.0006	0.00057291984558105	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
51	0.0005	0.00051498413085938	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0005	0.00050616264343262	SELECT * FROM categorygroups WHERE id = '1'
53	0.0007	0.00069499015808105	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
54	0.0006	0.00057005882263184	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55	0.0006	0.00059199333190918	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00054812431335449	SELECT id FROM categories WHERE parent_id = '30'
57	0.0008	0.00078201293945312	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
58	0.0006	0.00058197975158691	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
59	0.0006	0.00055599212646484	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
60	0.0007	0.00068879127502441	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0006	0.00056695938110352	SELECT * FROM categorygroups WHERE id = '1'
62	0.0008	0.00082015991210938	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
63	0.0006	0.00061988830566406	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64	0.0005	0.00050711631774902	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.00053691864013672	SELECT id FROM categories WHERE parent_id = '31'
66	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
67	0.0006	0.00060892105102539	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
68	0.0007	0.00070595741271973	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
69	0.0007	0.00065994262695312	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0007	0.00068116188049316	SELECT * FROM categorygroups WHERE id = '1'
71	0.0006	0.00062012672424316	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0039	0.0039329528808594	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0019	0.0019400119781494	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0013	0.0012710094451904	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
75	0.0015	0.0015428066253662	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0015	0.0015239715576172	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0013	0.0012760162353516	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.5491	0.54911303520203	SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.14.84') >= INET_ATON(ip_start) AND INET_ATON('18.97.14.84') <= INET_ATON(ip_end)
79	0.0023	0.0023410320281982	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0014	0.001439094543457	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0008	0.00084805488586426	SELECT * FROM products WHERE pagename = 'la-route-des-comptoirs-roobos-safari-lot-de-2-bio'
82	0.0005	0.00047898292541504	UPDATE products SET viewcount = viewcount + 1 WHERE id = 761
83	0.0011	0.0010781288146973	SELECT * FROM manufacturers WHERE id = '183'
84	0.0010	0.0010080337524414	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
85	0.0033	0.0033359527587891	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '183' LIMIT 1
86	0.0037	0.0036628246307373	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '183' ORDER BY RAND() LIMIT 1
87	0.0007	0.00072503089904785	SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
88	0.0009	0.00089502334594727	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '183'
89	0.0012	0.0011889934539795	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '183' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
90	0.0007	0.00073599815368652	SELECT * FROM manufacturerimages WHERE manufacturer_id = '183'
91	0.0012	0.0011820793151855	SELECT category_id FROM products_categories WHERE product_id = '761'
92	0.0008	0.00078511238098145	SELECT * FROM categories WHERE id = '27'
93	0.0075	0.0074911117553711	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
94	0.0006	0.00063490867614746	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95	0.0005	0.00046610832214355	SELECT id FROM categories WHERE parent_id = '27'
96	0.0059	0.0059430599212646	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
97	0.0007	0.00071215629577637	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
98	0.0024	0.0024218559265137	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
99	0.0006	0.00055193901062012	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100	0.0005	0.0005340576171875	SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
101	0.0018	0.001823902130127	SELECT * FROM product_image_select WHERE product_id = '761'
102	0.0015	0.0014660358428955	SELECT * FROM productcustomimages WHERE product_id = '761'
103	0.0013	0.0012838840484619	SELECT * FROM productfeeds WHERE product_id = '761' ORDER BY item_date DESC
104	0.0025	0.0025210380554199	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105	0.0021	0.00205397605896	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '761' AND t.hidden = 0 AND display_product = 1
106	0.0017	0.0016560554504395	SELECT * FROM productamazoncontent WHERE product_id = '761'
107	0.0025	0.002453088760376	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
108	0.0015	0.0015058517456055	SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
109	0.0005	0.00046920776367188	SELECT * FROM productoffers WHERE product_id = '761' AND price > 0 ORDER BY price ASC LIMIT 1
110	0.0005	0.00047707557678223	SELECT * FROM productoffers WHERE product_id = 761 ORDER BY price ASC LIMIT 1
111	0.0005	0.00049901008605957	SELECT value FROM productattributes WHERE product_id = '761' AND name = 'ListPriceAmount'
112	0.0004	0.0004270076751709	SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
113	0.0005	0.00052213668823242	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
114	0.0090	0.0090081691741943	SELECT *, MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AND 761 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
115	0.0008	0.00077319145202637	SELECT *, MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AND 761 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
116	0.0006	0.00058794021606445	SELECT *, MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('comptoirs roo�bos safari' IN BOOLEAN MODE) AND 761 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
117	0.0005	0.00050783157348633	SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
118	0.0007	0.00066900253295898	SELECT * FROM product_image_select WHERE product_id = '1093'
119	0.0004	0.00043320655822754	SELECT * FROM productcustomimages WHERE product_id = '1093'
120	0.0053	0.005281925201416	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
121	0.0007	0.00065803527832031	SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
122	0.0005	0.00048398971557617	SELECT * FROM productoffers WHERE product_id = '1093' AND price > 0 ORDER BY price ASC LIMIT 1
123	0.0006	0.00055193901062012	SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124	0.0005	0.00051116943359375	SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
125	0.0006	0.00062417984008789	SELECT * FROM product_image_select WHERE product_id = '4905'
126	0.0005	0.00049304962158203	SELECT * FROM productcustomimages WHERE product_id = '4905'
127	0.0013	0.0013279914855957	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
128	0.0006	0.00057315826416016	SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
129	0.0005	0.00046610832214355	SELECT * FROM productoffers WHERE product_id = '4905' AND price > 0 ORDER BY price ASC LIMIT 1
130	0.0005	0.00053215026855469	SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0010	0.0010099411010742	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '761') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
132	0.0100	0.0099589824676514	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 <> '761' ORDER BY RAND()
133	0.0009	0.00088906288146973	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 <> '761' ORDER BY RAND()
134	0.0007	0.0006561279296875	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 <> '761' ORDER BY RAND()
135	0.0005	0.00053501129150391	SELECT * FROM productimages WHERE product_id = '1047' ORDER BY sortorder ASC
136	0.0007	0.00066304206848145	SELECT * FROM product_image_select WHERE product_id = '1047'
137	0.0005	0.00045680999755859	SELECT * FROM productcustomimages WHERE product_id = '1047'
138	0.0011	0.0010509490966797	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1047' AND a.name = n.originalname
139	0.0007	0.00073099136352539	SELECT * FROM productoffers WHERE product_id = '1047' AND merchantid = 'A1X6FK5RDHNB96'
140	0.0005	0.00049209594726562	SELECT * FROM productoffers WHERE product_id = '1047' AND price > 0 ORDER BY price ASC LIMIT 1
141	0.0004	0.00041294097900391	SELECT * FROM productoffers WHERE product_id = 1047 ORDER BY price ASC LIMIT 1
142	0.0005	0.0004570484161377	SELECT value FROM productattributes WHERE product_id = '1047' AND name = 'ListPriceAmount'
143	0.0005	0.00049614906311035	SELECT value FROM productattributes WHERE product_id = '1047' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144	0.0011	0.0010650157928467	SELECT * FROM productimages WHERE product_id = '874' ORDER BY sortorder ASC
145	0.0007	0.00070095062255859	SELECT * FROM product_image_select WHERE product_id = '874'
146	0.0018	0.0018110275268555	SELECT * FROM productcustomimages WHERE product_id = '874'
147	0.0012	0.0011789798736572	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '874' AND a.name = n.originalname
148	0.0007	0.0007169246673584	SELECT * FROM productoffers WHERE product_id = '874' AND merchantid = 'A1X6FK5RDHNB96'
149	0.0006	0.00057697296142578	SELECT * FROM productoffers WHERE product_id = '874' AND price > 0 ORDER BY price ASC LIMIT 1
150	0.0005	0.00049090385437012	SELECT * FROM productoffers WHERE product_id = 874 ORDER BY price ASC LIMIT 1
151	0.0005	0.0004580020904541	SELECT value FROM productattributes WHERE product_id = '874' AND name = 'ListPriceAmount'
152	0.0006	0.00061798095703125	SELECT * FROM productimages WHERE product_id = '1046' ORDER BY sortorder ASC
153	0.0008	0.00076913833618164	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1046' AND p.id = pi.product_id ORDER BY pi.sortorder
154	0.0010	0.0009770393371582	SELECT * FROM product_image_select WHERE product_id = '1046'
155	0.0006	0.00058889389038086	SELECT * FROM productcustomimages WHERE product_id = '1046'
156	0.0008	0.00076508522033691	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 = '1046' GROUP BY o.product_id
157	0.0045	0.0044620037078857	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 = '1046' GROUP BY n.displayname ORDER BY n.displayname DESC
158	0.0012	0.0011529922485352	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1046
159	0.0035	0.0035278797149658	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1046' AND a.name = n.originalname
160	0.0013	0.0012660026550293	SELECT * FROM productoffers WHERE product_id = '1046' AND merchantid = 'A1X6FK5RDHNB96'
161	0.0010	0.00095701217651367	SELECT * FROM productoffers WHERE product_id = '1046' AND price > 0 ORDER BY price ASC LIMIT 1
162	0.0005	0.00052714347839355	SELECT * FROM productoffers WHERE product_id = 1046 ORDER BY price ASC LIMIT 1
163	0.0029	0.002885103225708	SELECT value FROM productattributes WHERE product_id = '1046' AND name = 'ListPriceAmount'
164	0.0007	0.00065493583679199	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 = '1046' GROUP BY o.product_id
165	0.0008	0.00077509880065918	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 = '1046' GROUP BY n.displayname ORDER BY n.displayname DESC
166	0.0005	0.00051283836364746	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1046
167	0.0007	0.00071907043457031	SELECT value FROM productattributes WHERE product_id = '1046' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168	0.0006	0.00055789947509766	SELECT * FROM products WHERE parent_id = '1046'
169	0.0035	0.0035398006439209	SELECT * FROM productimages WHERE product_id = '882' ORDER BY sortorder ASC
170	0.0020	0.0019729137420654	SELECT * FROM product_image_select WHERE product_id = '882'
171	0.0019	0.0018789768218994	SELECT * FROM productcustomimages WHERE product_id = '882'
172	0.0013	0.0013270378112793	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '882' AND a.name = n.originalname
173	0.0006	0.00059700012207031	SELECT * FROM productoffers WHERE product_id = '882' AND merchantid = 'A1X6FK5RDHNB96'
174	0.0005	0.0004730224609375	SELECT * FROM productoffers WHERE product_id = '882' AND price > 0 ORDER BY price ASC LIMIT 1
175	0.0005	0.00051283836364746	SELECT * FROM productoffers WHERE product_id = 882 ORDER BY price ASC LIMIT 1
176	0.0004	0.0004270076751709	SELECT value FROM productattributes WHERE product_id = '882' AND name = 'ListPriceAmount'
177	0.0005	0.0004570484161377	SELECT value FROM productattributes WHERE product_id = '882' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178	0.0011	0.0010941028594971	SELECT id,asin FROM products WHERE parent_id = 761
179	0.0019	0.0019130706787109	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '761' ORDER BY timestamp DESC
180	0.0005	0.00053191184997559	SELECT category_id FROM products_categories WHERE product_id = '761'
181	0.0006	0.0006248950958252	SELECT * FROM categories WHERE id = '27'
182	0.0045	0.0044529438018799	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
183	0.0008	0.00083017349243164	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
184	0.0006	0.00062394142150879	SELECT id FROM categories WHERE parent_id = '27'
185	0.0036	0.0036189556121826	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
186	0.0016	0.001568078994751	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
187	0.0012	0.0011520385742188	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
188	0.0022	0.0021629333496094	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
189	0.0010	0.0010318756103516	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
190	0.0011	0.0011179447174072	SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
191	0.0024	0.0023858547210693	SELECT * FROM productoffers WHERE product_id = '761' AND price > 0 ORDER BY price ASC LIMIT 1
192	0.0005	0.00052618980407715	SELECT * FROM productoffers WHERE product_id = 761 ORDER BY price ASC LIMIT 1
193	0.0005	0.00048494338989258	SELECT value FROM productattributes WHERE product_id = '761' AND name = 'ListPriceAmount'
194	0.0009	0.00094485282897949	SELECT * FROM products WHERE id = '761'
195	0.0027	0.002734899520874	SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196	0.0008	0.00082993507385254	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
197	0.0005	0.00045084953308105	SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
198	0.0005	0.00045609474182129	SELECT * FROM productoffers WHERE product_id = '761' AND price > 0 ORDER BY price ASC LIMIT 1
199	0.0004	0.00041604042053223	SELECT * FROM productoffers WHERE product_id = 761 ORDER BY price ASC LIMIT 1
200	0.0006	0.00060081481933594	SELECT value FROM productattributes WHERE product_id = '761' AND name = 'ListPriceAmount'
201	0.0006	0.00064611434936523	SELECT category_id FROM products_categories WHERE product_id = '761' AND prod_type = 'amz'
202	0.0005	0.00052380561828613	SELECT parent_id FROM categories WHERE id = '27'
203	0.0004	0.00043821334838867	SELECT * FROM categories WHERE id = '27'
204	0.0044	0.0044240951538086	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
205	0.0006	0.00056600570678711	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
206	0.0004	0.00037908554077148	SELECT id FROM categories WHERE parent_id = '27'
207	0.0054	0.0053670406341553	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
208	0.0006	0.00059700012207031	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
209	0.0006	0.00058197975158691	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
210	0.0005	0.00052094459533691	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
211	0.0027	0.0027158260345459	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
212	0.0019	0.0018680095672607	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
213	0.0007	0.00068211555480957	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
214	0.0159	0.015902042388916	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
215	0.0017	0.0017430782318115	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
216	0.0009	0.00086402893066406	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
217	0.0013	0.0013420581817627	SELECT * FROM products WHERE id = 1626
218	0.0006	0.00063991546630859	SELECT * FROM products WHERE id = 4041
219	0.0007	0.00072002410888672	SELECT * FROM products WHERE id = 4312
220	0.0007	0.00065898895263672	SELECT * FROM products WHERE id = 777
221	0.0007	0.0007479190826416	SELECT * FROM products WHERE id = 3881
222	0.0007	0.00070500373840332	SELECT * FROM products WHERE id = 4213
223	0.0008	0.00081300735473633	SELECT * FROM products WHERE id = '1626'
224	0.0006	0.00055384635925293	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
225	0.0007	0.00066208839416504	SELECT * FROM product_image_select WHERE product_id = '1626'
226	0.0005	0.00045895576477051	SELECT * FROM productcustomimages WHERE product_id = '1626'
227	0.0014	0.0014069080352783	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
228	0.0091	0.009066104888916	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
229	0.0064	0.0064280033111572	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
230	0.0016	0.0016300678253174	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231	0.0010	0.00098395347595215	SELECT * FROM products WHERE id = '4041'
232	0.0010	0.0010371208190918	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
233	0.0015	0.0015499591827393	SELECT * FROM product_image_select WHERE product_id = '4041'
234	0.0012	0.0012240409851074	SELECT * FROM productcustomimages WHERE product_id = '4041'
235	0.0028	0.0027649402618408	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
236	0.0010	0.00097489356994629	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
237	0.0007	0.00071191787719727	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
238	0.0039	0.00388503074646	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239	0.0015	0.0015089511871338	SELECT * FROM products WHERE id = '4312'
240	0.0012	0.0011630058288574	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
241	0.0015	0.0015389919281006	SELECT * FROM product_image_select WHERE product_id = '4312'
242	0.0013	0.0012609958648682	SELECT * FROM productcustomimages WHERE product_id = '4312'
243	0.0049	0.0048971176147461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
244	0.0015	0.0014760494232178	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
245	0.0009	0.00085210800170898	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
246	0.0009	0.00092101097106934	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247	0.0015	0.0015389919281006	SELECT * FROM products WHERE id = '777'
248	0.0010	0.00096678733825684	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
249	0.0014	0.0013809204101562	SELECT * FROM product_image_select WHERE product_id = '777'
250	0.0010	0.00097322463989258	SELECT * FROM productcustomimages WHERE product_id = '777'
251	0.0032	0.0031881332397461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
252	0.0011	0.0010900497436523	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
253	0.0012	0.0012378692626953	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
254	0.0009	0.00094389915466309	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255	0.0013	0.001305103302002	SELECT * FROM products WHERE id = '3881'
256	0.0014	0.0013809204101562	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
257	0.0016	0.0015659332275391	SELECT * FROM product_image_select WHERE product_id = '3881'
258	0.0008	0.00081300735473633	SELECT * FROM productcustomimages WHERE product_id = '3881'
259	0.0040	0.0039901733398438	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
260	0.0036	0.0035581588745117	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
261	0.0007	0.00073099136352539	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
262	0.0008	0.00077295303344727	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263	0.0010	0.0010309219360352	SELECT * FROM products WHERE id = '4213'
264	0.0010	0.0010368824005127	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
265	0.0010	0.0010349750518799	SELECT * FROM product_image_select WHERE product_id = '4213'
266	0.0007	0.0006709098815918	SELECT * FROM productcustomimages WHERE product_id = '4213'
267	0.0021	0.0021300315856934	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
268	0.0008	0.00081396102905273	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
269	0.0006	0.00062394142150879	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
270	0.0010	0.0010249614715576	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
271	0.0051	0.0051259994506836	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
272	0.0018	0.0017929077148438	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
273	0.0058	0.0058300495147705	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
274	0.0046	0.0045709609985352	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
275	0.0014	0.0014269351959229	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
276	0.0011	0.0010659694671631	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

La Route Des Comptoirs - Rooïbos Safari Lot De 2 - BIO

Manufacturer Description

Product Features

Coffret Rooibos Saveurs d'un Soir - La R...

Comptoirs Richard Thé Vert Jasmin Boîte ...

Thés & Traditions - Khayelitsha Bio ...

Thé Rooibos Cedarberg

Kusmi Tea - Rooibos vert - Boîte métal 1...

Naturela Thé Rooibos n° 13 Bio

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.8963479995728 seconds

Query Debug - 276 Database Queries. Total time 1.0176 seconds

La Route Des Comptoirs - Rooïbos Safari Lot De 2 - BIO

Manufacturer Description

Product Features

Related Products

Coffret Rooibos Saveurs d'un Soir - La R...

Comptoirs Richard Thé Vert Jasmin Boîte ...

Thés & Traditions - Khayelitsha Bio ...

Thé Rooibos Cedarberg

Kusmi Tea - Rooibos vert - Boîte métal 1...

Naturela Thé Rooibos n° 13 Bio

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.8963479995728 seconds

Query Debug - 276 Database Queries. Total time 1.0176 seconds