matches21 Thé hiver Wölkchen de thé moyen de Noël/Noël Crème de Vanille Rooibos Bos Thé 100 gr. d'hiver Thé fabriqué en Allemagne

Price: Click Button for Price

As of 2022-06-19 05:42:24 UTC (more info)

Product prices and availability are accurate as of 2022-06-19 05:42:24 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

Délicieux desserts thé rooibos Bos la théière & période de Noël d'Hiver/hiver/Noël Thé. Pour nasch chats et fuite - savoureux à la folie de thé avec une note de vanille crème fine. Des ingrédients, fabriqué en Allemagne 100 g dans un sachet verschlossenen Aroma Beaucoup d'autres thés, Tasse à Thé et de nombreux accessoires découvrir dans matches21.

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.5366449356079	270	1.1437	0

No Amazon API Requests Made.

App Debug - Total Time 1.5366449356079 seconds

Number	Time From Start	Name	Description
1	0.36714506149292	Initialise	Initialise FSB Function
2	0.37531089782715	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.41083097457886	Start of getCategoryListByGroup Function	Before first category groups query
4	0.41485905647278	After initial query	Before first category groups query
5	0.41486001014709	Get Category List for Group	Before the call to getCategoryList function
6	0.41486287117004	Start of GetCategoryList function	Start of the function
7	0.41486597061157	Before getting categories	Query to get specific category list
8	0.4181969165802	After getting categories	Query to get specific category list
9	0.41819787025452	Before getting category custom	Before call to function getCategoryCustom
10	0.44959902763367	After getting category custom	After call to function getCategoryCustom
11	0.44960188865662	Before getting category custom	Before call to function getCategoryCustom
12	0.46044588088989	After getting category custom	After call to function getCategoryCustom
13	0.46044683456421	Before getting category custom	Before call to function getCategoryCustom
14	0.46689891815186	After getting category custom	After call to function getCategoryCustom
15	0.46689987182617	Before getting category custom	Before call to function getCategoryCustom
16	0.47118091583252	After getting category custom	After call to function getCategoryCustom
17	0.47118186950684	Before getting category custom	Before call to function getCategoryCustom
18	0.47530603408813	After getting category custom	After call to function getCategoryCustom
19	0.47530698776245	Before getting category custom	Before call to function getCategoryCustom
20	0.47940897941589	After getting category custom	After call to function getCategoryCustom
21	0.47940993309021	End of GetCategoryList function	End of the function
22	0.47941398620605	Get Category List for Group	Before the call to getCategoryList function
23	0.47941493988037	Start of GetCategoryList function	Start of the function
24	0.47941589355469	Before getting categories	Query to get specific category list
25	0.47984790802002	End of getCategoryListByGroup Function	Before return()
26	1.24631690979	App Controller End	End of the App controller (called before the controller of every page)
27	1.2469079494476	Product Start	Start of the product info controller
28	1.2487950325012	Cache file not found	Starting get product details
29	1.2871649265289	Related products	Start getting related products if enabled
30	1.2871658802032	Related Products Start	Before the related products are found
31	1.2871658802032	Related Products Keywords	Before the related product keywords are found
32	1.2871739864349	Create Keyword List Function	Start of function
33	1.287260055542	Create Keyword List Function	After looping provided content - 53 keywords found
34	1.288183927536	Create Keyword List Function	After looping initial keyword list - 50 keywords remaining
35	1.2881908416748	Create Keyword List Function	After reducing keyword list
36	1.2883379459381	Create Keyword List Function	After selecting by scoring keywords
37	1.2883398532867	Create Keyword List Function	After final loop of keywords
38	1.2883410453796	Related Products Keywords	After the related product keywords are found
39	1.3879170417786	Related Products End	After the related products are found
40	1.424633026123	Product End	End of the product info controller (Product Info)
41	1.4268460273743	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.4285309314728	Before Get Options	Before the call to getOptions in the tpl class
43	1.5032880306244	After Get Options	After the call to getOptions in the tpl class
44	1.5034039020538	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.5034239292145	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.5141768455505	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.5141789913177	Product Info: Before Template Display	Before the template is displayed
48	1.5366289615631	Product Info: After Template Display	After the template is displayed
49	1.5366368293762	Finalizing debug	Before the debug is output to the page.
50	1.5366439819336	End of App	This is the end of the app logging, final timestamp

Query Debug - 270 Database Queries. Total time 1.1437 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:\"3.144.149.217\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746109835'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille' LIMIT 1
SELECT id FROM products WHERE pagename = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille' 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 = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille'
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('3.144.149.217') >= INET_ATON(ip_start) AND INET_ATON('3.144.149.217') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2386
SELECT * FROM manufacturers WHERE id = '442'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '442'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '442' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '442' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '2384' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '442'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '442'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '442'
SELECT category_id FROM products_categories WHERE product_id = '2386'
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 = '2386' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2386'
SELECT * FROM productcustomimages WHERE product_id = '2386'
SELECT * FROM productfeeds WHERE product_id = '2386' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2386' 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 = '2386' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '2386'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2386' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2386' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2386
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2386'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2386' 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 ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '858'
SELECT * FROM productcustomimages WHERE product_id = '858'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '862'
SELECT * FROM productcustomimages WHERE product_id = '862'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '865'
SELECT * FROM productcustomimages WHERE product_id = '865'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '865' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '890'
SELECT * FROM productcustomimages WHERE product_id = '890'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '878'
SELECT * FROM productcustomimages WHERE product_id = '878'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '878' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4814'
SELECT * FROM productcustomimages WHERE product_id = '4814'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 2386
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2386' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '2386'
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 = '2386' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2386' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2386
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2386'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '2386'
SELECT value FROM productattributes WHERE product_id = '2386' 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 = '2386' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2386' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2386
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2386'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '2386' 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.0016	0.0015759468078613	SELECT parameter, value FROM parameters
2	0.0040	0.0039629936218262	SELECT * FROM `bad_bots`
3	0.0003	0.00025200843811035	SET time_zone = 'Europe/London'
4	0.0017	0.0016789436340332	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0021	0.0020620822906494	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.144.149.217\";}'
6	0.0023	0.0023300647735596	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746109835'
7	0.0033	0.0033421516418457	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0006	0.00063395500183105	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0036	0.0036489963531494	SELECT id FROM pages WHERE pagename = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille' LIMIT 1
10	0.0034	0.0033509731292725	SELECT id FROM products WHERE pagename = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille' AND hidden = 0 LIMIT 1
11	0.0035	0.0035209655761719	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0309	0.030895948410034	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0006	0.00060796737670898	SELECT * FROM pages WHERE pagename = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille'
14	0.0040	0.0040149688720703	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0033	0.0033190250396729	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0144	0.014375925064087	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17	0.0027	0.0026590824127197	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0016	0.001554012298584	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00053000450134277	SELECT id FROM categories WHERE parent_id = '26'
20	0.0075	0.007451057434082	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.0016	0.0015959739685059	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.0014	0.0014181137084961	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.0014	0.001378059387207	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0004	0.00037908554077148	SELECT * FROM categorygroups WHERE id = '1'
25	0.0037	0.0036640167236328	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.0005	0.00046086311340332	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.00040316581726074	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0004	0.00039219856262207	SELECT id FROM categories WHERE parent_id = '27'
29	0.0038	0.0037550926208496	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.0005	0.00053000450134277	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.0006	0.00061917304992676	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.0005	0.00053095817565918	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00045895576477051	SELECT * FROM categorygroups WHERE id = '1'
34	0.0015	0.0014798641204834	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.0005	0.00053691864013672	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.0004	0.00040793418884277	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00052595138549805	SELECT id FROM categories WHERE parent_id = '28'
38	0.0015	0.0015039443969727	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.0005	0.00050687789916992	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.0005	0.00048685073852539	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.0006	0.00056195259094238	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0004	0.00042200088500977	SELECT * FROM categorygroups WHERE id = '1'
43	0.0006	0.00063514709472656	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.0005	0.0004570484161377	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.0004	0.0003509521484375	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0004	0.00039100646972656	SELECT id FROM categories WHERE parent_id = '29'
47	0.0007	0.00065207481384277	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.0004	0.0004270076751709	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.0004	0.00044584274291992	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.0004	0.00043606758117676	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0005	0.00045919418334961	SELECT * FROM categorygroups WHERE id = '1'
52	0.0006	0.00055193901062012	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.0004	0.00040602684020996	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.0004	0.00035214424133301	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0004	0.00038814544677734	SELECT id FROM categories WHERE parent_id = '30'
56	0.0007	0.00067591667175293	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.0005	0.00047612190246582	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.0005	0.0004570484161377	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.0004	0.0004119873046875	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0004	0.0003819465637207	SELECT * FROM categorygroups WHERE id = '1'
61	0.0006	0.00058603286743164	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.0004	0.00042104721069336	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.0003	0.0003361701965332	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0003	0.00033402442932129	SELECT id FROM categories WHERE parent_id = '31'
65	0.0007	0.00066399574279785	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.0004	0.00043201446533203	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.0005	0.00046300888061523	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.0004	0.00043010711669922	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0004	0.00041890144348145	SELECT * FROM categorygroups WHERE id = '1'
70	0.0004	0.00042819976806641	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0029	0.0028939247131348	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0015	0.0015230178833008	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.0006718635559082	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74	0.0015	0.0014729499816895	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0011	0.0010790824890137	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0008	0.00077605247497559	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.7527	0.75267601013184	SELECT * FROM ipgeocountries WHERE INET_ATON('3.144.149.217') >= INET_ATON(ip_start) AND INET_ATON('3.144.149.217') <= INET_ATON(ip_end)
78	0.0023	0.0022890567779541	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0015	0.0014841556549072	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0006	0.00061488151550293	SELECT * FROM products WHERE pagename = 'matches21the-hiver-wolkchen-de-the-moyen-de-noelnoel-crme-de-vanille'
81	0.0004	0.00039219856262207	UPDATE products SET viewcount = viewcount + 1 WHERE id = 2386
82	0.0005	0.00046205520629883	SELECT * FROM manufacturers WHERE id = '442'
83	0.0004	0.00041890144348145	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '442'
84	0.0015	0.0015428066253662	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '442' LIMIT 1
85	0.0016	0.0016050338745117	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '442' ORDER BY RAND() LIMIT 1
86	0.0004	0.00035881996154785	SELECT * FROM productimages WHERE product_id = '2384' ORDER BY sortorder ASC
87	0.0007	0.00066995620727539	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '442'
88	0.0005	0.00049304962158203	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '442' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0004	0.00040102005004883	SELECT * FROM manufacturerimages WHERE manufacturer_id = '442'
90	0.0004	0.00041317939758301	SELECT category_id FROM products_categories WHERE product_id = '2386'
91	0.0004	0.00042200088500977	SELECT * FROM categories WHERE id = '27'
92	0.0034	0.0033731460571289	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.0004	0.0003969669342041	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94	0.0003	0.00030207633972168	SELECT id FROM categories WHERE parent_id = '27'
95	0.0033	0.0033330917358398	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.0005	0.00049901008605957	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.0006	0.00055313110351562	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.0005	0.00048494338989258	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99	0.0005	0.00047588348388672	SELECT * FROM productimages WHERE product_id = '2386' ORDER BY sortorder ASC
100	0.0016	0.0015730857849121	SELECT * FROM product_image_select WHERE product_id = '2386'
101	0.0012	0.0011749267578125	SELECT * FROM productcustomimages WHERE product_id = '2386'
102	0.0011	0.0010988712310791	SELECT * FROM productfeeds WHERE product_id = '2386' ORDER BY item_date DESC
103	0.0022	0.0021679401397705	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2386' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104	0.0021	0.0021059513092041	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2386' AND t.hidden = 0 AND display_product = 1
105	0.0003	0.0003209114074707	SELECT * FROM tags WHERE id = '81'
106	0.0027	0.0026779174804688	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
107	0.0024	0.0023808479309082	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
108	0.0023	0.0022830963134766	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
109	0.0005	0.0005028247833252	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
110	0.0014	0.0014171600341797	SELECT * FROM productamazoncontent WHERE product_id = '2386'
111	0.0008	0.0007929801940918	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2386' AND a.name = n.originalname
112	0.0013	0.0013251304626465	SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0004	0.00035309791564941	SELECT * FROM productoffers WHERE product_id = '2386' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0003	0.00030207633972168	SELECT * FROM productoffers WHERE product_id = 2386 ORDER BY price ASC LIMIT 1
115	0.0005	0.00045394897460938	SELECT value FROM productattributes WHERE product_id = '2386' AND name = 'ListPriceAmount'
116	0.0004	0.00037598609924316	SELECT value FROM productattributes WHERE product_id = '2386' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0005	0.00048589706420898	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
118	0.0039	0.0039348602294922	SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
119	0.0005	0.00054597854614258	SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
120	0.0037	0.0036580562591553	SELECT *, MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
121	0.0157	0.015726089477539	SELECT *, MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
122	0.0008	0.00075316429138184	SELECT *, MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
123	0.0008	0.00075411796569824	SELECT *, MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('de no�lno�l cr�me' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
124	0.0172	0.017168998718262	SELECT *, MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
125	0.0006	0.00064802169799805	SELECT *, MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
126	0.0006	0.00056290626525879	SELECT *, MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('no�lno�l cr�me de' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
127	0.0218	0.021754026412964	SELECT *, MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AND 2386 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
128	0.0006	0.00055503845214844	SELECT *, MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
129	0.0005	0.00045204162597656	SELECT *, MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('vanille rooibos bos' IN BOOLEAN MODE) AND 2386 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
130	0.0007	0.0007021427154541	SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
131	0.0007	0.00066184997558594	SELECT * FROM product_image_select WHERE product_id = '858'
132	0.0004	0.00041699409484863	SELECT * FROM productcustomimages WHERE product_id = '858'
133	0.0018	0.0017731189727783	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
134	0.0005	0.00052499771118164	SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
135	0.0004	0.00041007995605469	SELECT * FROM productoffers WHERE product_id = '858' AND price > 0 ORDER BY price ASC LIMIT 1
136	0.0005	0.00054001808166504	SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137	0.0006	0.00060200691223145	SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
138	0.0007	0.00068902969360352	SELECT * FROM product_image_select WHERE product_id = '862'
139	0.0004	0.00040912628173828	SELECT * FROM productcustomimages WHERE product_id = '862'
140	0.0013	0.0013179779052734	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
141	0.0005	0.00050497055053711	SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
142	0.0005	0.00046491622924805	SELECT * FROM productoffers WHERE product_id = '862' AND price > 0 ORDER BY price ASC LIMIT 1
143	0.0004	0.00044488906860352	SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144	0.0005	0.00050687789916992	SELECT * FROM productimages WHERE product_id = '865' ORDER BY sortorder ASC
145	0.0007	0.00069689750671387	SELECT * FROM product_image_select WHERE product_id = '865'
146	0.0004	0.00039505958557129	SELECT * FROM productcustomimages WHERE product_id = '865'
147	0.0010	0.00098896026611328	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '865' AND a.name = n.originalname
148	0.0005	0.00049281120300293	SELECT * FROM productoffers WHERE product_id = '865' AND merchantid = 'A1X6FK5RDHNB96'
149	0.0004	0.00037503242492676	SELECT * FROM productoffers WHERE product_id = '865' AND price > 0 ORDER BY price ASC LIMIT 1
150	0.0005	0.00054001808166504	SELECT value FROM productattributes WHERE product_id = '865' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0005	0.00054001808166504	SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
152	0.0007	0.00068092346191406	SELECT * FROM product_image_select WHERE product_id = '890'
153	0.0005	0.0004580020904541	SELECT * FROM productcustomimages WHERE product_id = '890'
154	0.0014	0.0013790130615234	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
155	0.0006	0.00055789947509766	SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
156	0.0005	0.00045394897460938	SELECT * FROM productoffers WHERE product_id = '890' AND price > 0 ORDER BY price ASC LIMIT 1
157	0.0006	0.00056910514831543	SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158	0.0005	0.0004580020904541	SELECT * FROM productimages WHERE product_id = '878' ORDER BY sortorder ASC
159	0.0008	0.00076198577880859	SELECT * FROM product_image_select WHERE product_id = '878'
160	0.0007	0.00068283081054688	SELECT * FROM productcustomimages WHERE product_id = '878'
161	0.0025	0.0025360584259033	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '878' AND a.name = n.originalname
162	0.0009	0.00085997581481934	SELECT * FROM productoffers WHERE product_id = '878' AND merchantid = 'A1X6FK5RDHNB96'
163	0.0007	0.00072813034057617	SELECT * FROM productoffers WHERE product_id = '878' AND price > 0 ORDER BY price ASC LIMIT 1
164	0.0008	0.00078487396240234	SELECT value FROM productattributes WHERE product_id = '878' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165	0.0009	0.00087785720825195	SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
166	0.0012	0.001183032989502	SELECT * FROM product_image_select WHERE product_id = '4814'
167	0.0007	0.00065112113952637	SELECT * FROM productcustomimages WHERE product_id = '4814'
168	0.0024	0.0023789405822754	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
169	0.0008	0.0008389949798584	SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
170	0.0007	0.00066781044006348	SELECT * FROM productoffers WHERE product_id = '4814' AND price > 0 ORDER BY price ASC LIMIT 1
171	0.0008	0.00079512596130371	SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
172	0.0008	0.0007929801940918	SELECT id,asin FROM products WHERE parent_id = 2386
173	0.0036	0.0035510063171387	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2386' ORDER BY timestamp DESC
174	0.0006	0.00063109397888184	SELECT category_id FROM products_categories WHERE product_id = '2386'
175	0.0007	0.00068807601928711	SELECT * FROM categories WHERE id = '27'
176	0.0075	0.0074598789215088	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
177	0.0005	0.00052309036254883	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
178	0.0003	0.0003349781036377	SELECT id FROM categories WHERE parent_id = '27'
179	0.0047	0.0046920776367188	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
180	0.0006	0.00062704086303711	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
181	0.0006	0.00063300132751465	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
182	0.0005	0.00051999092102051	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
183	0.0010	0.0010130405426025	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2386' AND a.name = n.originalname
184	0.0006	0.00056195259094238	SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
185	0.0004	0.00042605400085449	SELECT * FROM productoffers WHERE product_id = '2386' AND price > 0 ORDER BY price ASC LIMIT 1
186	0.0003	0.00034904479980469	SELECT * FROM productoffers WHERE product_id = 2386 ORDER BY price ASC LIMIT 1
187	0.0005	0.00045299530029297	SELECT value FROM productattributes WHERE product_id = '2386' AND name = 'ListPriceAmount'
188	0.0005	0.00050091743469238	SELECT * FROM products WHERE id = '2386'
189	0.0004	0.00038290023803711	SELECT value FROM productattributes WHERE product_id = '2386' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190	0.0006	0.00059986114501953	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2386' AND a.name = n.originalname
191	0.0004	0.00035214424133301	SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0003	0.00031089782714844	SELECT * FROM productoffers WHERE product_id = '2386' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0003	0.00030112266540527	SELECT * FROM productoffers WHERE product_id = 2386 ORDER BY price ASC LIMIT 1
194	0.0003	0.00034904479980469	SELECT value FROM productattributes WHERE product_id = '2386' AND name = 'ListPriceAmount'
195	0.0004	0.0004429817199707	SELECT category_id FROM products_categories WHERE product_id = '2386' AND prod_type = 'amz'
196	0.0004	0.00039982795715332	SELECT parent_id FROM categories WHERE id = '27'
197	0.0003	0.00034809112548828	SELECT * FROM categories WHERE id = '27'
198	0.0037	0.0036649703979492	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
199	0.0004	0.00044512748718262	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
200	0.0003	0.00029706954956055	SELECT id FROM categories WHERE parent_id = '27'
201	0.0035	0.0034720897674561	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
202	0.0005	0.0004889965057373	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
203	0.0005	0.00050592422485352	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
204	0.0005	0.00046014785766602	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
205	0.0017	0.0016980171203613	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
206	0.0013	0.0013329982757568	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
207	0.0003	0.00031614303588867	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
208	0.0126	0.012624025344849	SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
209	0.0015	0.0015430450439453	SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
210	0.0006	0.00060510635375977	SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
211	0.0005	0.00048494338989258	SELECT * FROM products WHERE id = 1626
212	0.0003	0.00034999847412109	SELECT * FROM products WHERE id = 4041
213	0.0003	0.00034594535827637	SELECT * FROM products WHERE id = 4312
214	0.0003	0.00031208992004395	SELECT * FROM products WHERE id = 777
215	0.0004	0.00036501884460449	SELECT * FROM products WHERE id = 3881
216	0.0003	0.00034594535827637	SELECT * FROM products WHERE id = 4213
217	0.0003	0.00030183792114258	SELECT * FROM products WHERE id = '1626'
218	0.0004	0.00040006637573242	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
219	0.0006	0.0005650520324707	SELECT * FROM product_image_select WHERE product_id = '1626'
220	0.0004	0.0004119873046875	SELECT * FROM productcustomimages WHERE product_id = '1626'
221	0.0008	0.00079512596130371	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
222	0.0011	0.0011088848114014	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
223	0.0008	0.00080394744873047	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
224	0.0008	0.00084495544433594	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225	0.0011	0.0010509490966797	SELECT * FROM products WHERE id = '4041'
226	0.0005	0.00050687789916992	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
227	0.0006	0.00061392784118652	SELECT * FROM product_image_select WHERE product_id = '4041'
228	0.0004	0.00036096572875977	SELECT * FROM productcustomimages WHERE product_id = '4041'
229	0.0028	0.0027768611907959	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
230	0.0013	0.0012550354003906	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
231	0.0008	0.00084614753723145	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
232	0.0010	0.0010130405426025	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233	0.0011	0.0010879039764404	SELECT * FROM products WHERE id = '4312'
234	0.0010	0.0010068416595459	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
235	0.0016	0.0016219615936279	SELECT * FROM product_image_select WHERE product_id = '4312'
236	0.0008	0.00080609321594238	SELECT * FROM productcustomimages WHERE product_id = '4312'
237	0.0026	0.0026350021362305	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
238	0.0010	0.00098800659179688	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
239	0.0009	0.00085091590881348	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
240	0.0009	0.00092101097106934	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241	0.0010	0.0010240077972412	SELECT * FROM products WHERE id = '777'
242	0.0010	0.0010099411010742	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
243	0.0010	0.0009760856628418	SELECT * FROM product_image_select WHERE product_id = '777'
244	0.0006	0.00058913230895996	SELECT * FROM productcustomimages WHERE product_id = '777'
245	0.0021	0.0021018981933594	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
246	0.0008	0.00076985359191895	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
247	0.0006	0.00057601928710938	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
248	0.0007	0.00072884559631348	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
249	0.0008	0.00076389312744141	SELECT * FROM products WHERE id = '3881'
250	0.0009	0.0008699893951416	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
251	0.0010	0.0010130405426025	SELECT * FROM product_image_select WHERE product_id = '3881'
252	0.0010	0.0009620189666748	SELECT * FROM productcustomimages WHERE product_id = '3881'
253	0.0025	0.0024850368499756	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
254	0.0007	0.00073790550231934	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
255	0.0006	0.00056195259094238	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
256	0.0008	0.00078606605529785	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257	0.0010	0.00099706649780273	SELECT * FROM products WHERE id = '4213'
258	0.0010	0.00098514556884766	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
259	0.0010	0.0009620189666748	SELECT * FROM product_image_select WHERE product_id = '4213'
260	0.0006	0.00056695938110352	SELECT * FROM productcustomimages WHERE product_id = '4213'
261	0.0022	0.0021789073944092	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
262	0.0006	0.00058913230895996	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
263	0.0004	0.00043606758117676	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
264	0.0007	0.00066709518432617	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265	0.0027	0.0027470588684082	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
266	0.0008	0.00084686279296875	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
267	0.0030	0.0030410289764404	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
268	0.0021	0.0020699501037598	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
269	0.0007	0.00066494941711426	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
270	0.0011	0.0011401176452637	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

matches21 Thé hiver Wölkchen de thé moyen de Noël/Noël Crème de Vanille Rooibos Bos Thé 100 gr. d'hiver Thé fabriqué en Allemagne

Product Features

BADERs Cynarin Artischocke. Thé rooibos ...

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

HolyCup Rooibos Tea Nespresso® Capsules ...

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

Rooibos INFUSION 17 SACHETS

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

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5366449356079 seconds

Query Debug - 270 Database Queries. Total time 1.1437 seconds

matches21 Thé hiver Wölkchen de thé moyen de Noël/Noël Crème de Vanille Rooibos Bos Thé 100 gr. d'hiver Thé fabriqué en Allemagne

Product Features

Related Products

BADERs Cynarin Artischocke. Thé rooibos ...

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

HolyCup Rooibos Tea Nespresso® Capsules ...

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

Rooibos INFUSION 17 SACHETS

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

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.5366449356079 seconds

Query Debug - 270 Database Queries. Total time 1.1437 seconds