matches21 Licorne Thé Lot de 2 Stk. Licorne Magie & Or de la poussière püpse Thé/Rooibos Fruits Bos Thé par 100 gr.

Price: Click Button for Price

As of 2022-06-24 09:17:29 UTC (more info)

Product prices and availability are accurate as of 2022-06-24 09:17:29 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

Licorne magique de moments avec nos aromatisés variétés de thé en lot de 2. Des ingrédients, fabriqué en Allemagne Licorne magie avec paillettes poussière d'étoile est extrait de la queue de einhörnern. Ce thé avec fin goût framboise/vanille et de marche wellow wölkchen est tout simplement Himmlisch bien et magenmild. Or de la poussière püpse se composent de reflet doré et sont difficiles à collectionner. Pour les amateurs de truffe un doit - son doux crémeux Note umschmeichelt vos papilles. 2 variétés de 100 gr. Aroma sac fermé

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.4713249206543	278	1.1780	0

No Amazon API Requests Made.

App Debug - Total Time 1.4713249206543 seconds

Number	Time From Start	Name	Description
1	0.2833788394928	Initialise	Initialise FSB Function
2	0.29457783699036	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.3314368724823	Start of getCategoryListByGroup Function	Before first category groups query
4	0.33370995521545	After initial query	Before first category groups query
5	0.33371090888977	Get Category List for Group	Before the call to getCategoryList function
6	0.3337128162384	Start of GetCategoryList function	Start of the function
7	0.33371591567993	Before getting categories	Query to get specific category list
8	0.33612394332886	After getting categories	Query to get specific category list
9	0.33612489700317	Before getting category custom	Before call to function getCategoryCustom
10	0.36461400985718	After getting category custom	After call to function getCategoryCustom
11	0.36461591720581	Before getting category custom	Before call to function getCategoryCustom
12	0.37906289100647	After getting category custom	After call to function getCategoryCustom
13	0.3790647983551	Before getting category custom	Before call to function getCategoryCustom
14	0.38694882392883	After getting category custom	After call to function getCategoryCustom
15	0.38694977760315	Before getting category custom	Before call to function getCategoryCustom
16	0.39237689971924	After getting category custom	After call to function getCategoryCustom
17	0.39237785339355	Before getting category custom	Before call to function getCategoryCustom
18	0.39747786521912	After getting category custom	After call to function getCategoryCustom
19	0.39747786521912	Before getting category custom	Before call to function getCategoryCustom
20	0.4024178981781	After getting category custom	After call to function getCategoryCustom
21	0.40241885185242	End of GetCategoryList function	End of the function
22	0.40242290496826	Get Category List for Group	Before the call to getCategoryList function
23	0.40242385864258	Start of GetCategoryList function	Start of the function
24	0.40242481231689	Before getting categories	Query to get specific category list
25	0.40303182601929	End of getCategoryListByGroup Function	Before return()
26	1.1804327964783	App Controller End	End of the App controller (called before the controller of every page)
27	1.1809778213501	Product Start	Start of the product info controller
28	1.1830129623413	Cache file not found	Starting get product details
29	1.218270778656	Related products	Start getting related products if enabled
30	1.2182719707489	Related Products Start	Before the related products are found
31	1.2182719707489	Related Products Keywords	Before the related product keywords are found
32	1.2182748317719	Create Keyword List Function	Start of function
33	1.2183439731598	Create Keyword List Function	After looping provided content - 52 keywords found
34	1.2192118167877	Create Keyword List Function	After looping initial keyword list - 46 keywords remaining
35	1.2192177772522	Create Keyword List Function	After reducing keyword list
36	1.2193248271942	Create Keyword List Function	After selecting by scoring keywords
37	1.2193269729614	Create Keyword List Function	After final loop of keywords
38	1.2193279266357	Related Products Keywords	After the related product keywords are found
39	1.3389868736267	Related Products End	After the related products are found
40	1.3855848312378	Product End	End of the product info controller (Product Info)
41	1.3864238262177	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.3871178627014	Before Get Options	Before the call to getOptions in the tpl class
43	1.4364528656006	After Get Options	After the call to getOptions in the tpl class
44	1.436558008194	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.4365768432617	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.4459879398346	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.4459898471832	Product Info: Before Template Display	Before the template is displayed
48	1.4713089466095	Product Info: After Template Display	After the template is displayed
49	1.4713168144226	Finalizing debug	Before the debug is output to the page.
50	1.4713249206543	End of App	This is the end of the app logging, final timestamp

Query Debug - 278 Database Queries. Total time 1.1780 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:9:\"3.15.1.45\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745153561'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire' LIMIT 1
SELECT id FROM products WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire' 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 = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire'
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.15.1.45') >= INET_ATON(ip_start) AND INET_ATON('3.15.1.45') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2382
SELECT * FROM manufacturers WHERE id = '443'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '443'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '443' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '443' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '2381' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '443'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '443'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '443'
SELECT category_id FROM products_categories WHERE product_id = '2382'
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 = '2382' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2382'
SELECT * FROM productcustomimages WHERE product_id = '2382'
SELECT * FROM productfeeds WHERE product_id = '2382' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2382' 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 = '2382' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '2382'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2382' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2382' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2382
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2382'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2382' 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 ('andamp or de' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AND 2382 <> 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é par 100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4814'
SELECT * FROM productcustomimages WHERE product_id = '4814'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4814' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '998'
SELECT * FROM productcustomimages WHERE product_id = '998'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '998' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '992' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '992'
SELECT * FROM productcustomimages WHERE product_id = '992'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '992' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '992' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '992' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '992' 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 = '2382') 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 <> '2382' 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 <> '2382' 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 <> '2382' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '3590' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3590'
SELECT * FROM productcustomimages WHERE product_id = '3590'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3590' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3590' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3590' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3590
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3590'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3590' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1254' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1254'
SELECT * FROM productcustomimages WHERE product_id = '1254'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1254' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1254' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1254' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1254
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1254'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1254' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1098'
SELECT * FROM productcustomimages WHERE product_id = '1098'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1098' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1098' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1098' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1098
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1098'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1098' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 2382
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2382' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '2382'
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 = '2382' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2382' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2382
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2382'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '2382'
SELECT value FROM productattributes WHERE product_id = '2382' 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 = '2382' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2382' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2382
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2382'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '2382' 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.0019	0.0018501281738281	SELECT parameter, value FROM parameters
2	0.0087	0.0086610317230225	SELECT * FROM `bad_bots`
3	0.0005	0.00053000450134277	SET time_zone = 'Europe/London'
4	0.0035	0.0034520626068115	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0038	0.00382399559021	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:9:\"3.15.1.45\";}'
6	0.0037	0.0037088394165039	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1745153561'
7	0.0104	0.010420083999634	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0020	0.0019500255584717	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0037	0.0037291049957275	SELECT id FROM pages WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire' LIMIT 1
10	0.0049	0.0049359798431396	SELECT id FROM products WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire' AND hidden = 0 LIMIT 1
11	0.0050	0.0049910545349121	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0306	0.030551910400391	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0008	0.00078105926513672	SELECT * FROM pages WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire'
14	0.0023	0.0022602081298828	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0024	0.0023889541625977	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0091	0.0090529918670654	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.0024	0.0023748874664307	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0019	0.0019299983978271	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0007	0.00071597099304199	SELECT id FROM categories WHERE parent_id = '26'
20	0.0075	0.0075299739837646	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.0026	0.0026061534881592	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.0017	0.0017039775848389	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.0020	0.002018928527832	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00048494338989258	SELECT * FROM categorygroups WHERE id = '1'
25	0.0045	0.0044901371002197	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0006	0.00064301490783691	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0005	0.00050187110900879	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.00054001808166504	SELECT id FROM categories WHERE parent_id = '27'
29	0.0047	0.0047421455383301	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.0008	0.00077509880065918	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.0007	0.00066304206848145	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.0014	0.0014190673828125	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0006	0.00064492225646973	SELECT * FROM categorygroups WHERE id = '1'
34	0.0020	0.002004861831665	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0006	0.00055599212646484	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0005	0.00053691864013672	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00047516822814941	SELECT id FROM categories WHERE parent_id = '28'
38	0.0020	0.0020020008087158	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.0006	0.00057005882263184	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.0006	0.00063395500183105	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.0005	0.00051116943359375	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0006	0.00056719779968262	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00075984001159668	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0006	0.00058603286743164	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.0006	0.00055789947509766	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00050997734069824	SELECT id FROM categories WHERE parent_id = '29'
47	0.0008	0.00081300735473633	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.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
49	0.0007	0.00066494941711426	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.0005	0.00049901008605957	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0004	0.00042390823364258	SELECT * FROM categorygroups WHERE id = '1'
52	0.0006	0.00064516067504883	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.0006	0.0005800724029541	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0005	0.00047016143798828	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.0004580020904541	SELECT id FROM categories WHERE parent_id = '30'
56	0.0007	0.00072908401489258	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.0006	0.00060701370239258	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.0006	0.00058412551879883	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.0005	0.00051712989807129	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00048112869262695	SELECT * FROM categorygroups WHERE id = '1'
61	0.0007	0.00067806243896484	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.0005	0.00051498413085938	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.0004	0.00041699409484863	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.00045609474182129	SELECT id FROM categories WHERE parent_id = '31'
65	0.0007	0.00072598457336426	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.0005	0.0005190372467041	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0007	0.00065398216247559	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.0005	0.00050497055053711	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0005	0.00045084953308105	SELECT * FROM categorygroups WHERE id = '1'
70	0.0006	0.00060296058654785	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0034	0.0033838748931885	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0020	0.0019950866699219	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0008	0.00082206726074219	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.0016	0.001594066619873	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0015	0.0014629364013672	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0010	0.0010478496551514	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.7581	0.75805592536926	SELECT * FROM ipgeocountries WHERE INET_ATON('3.15.1.45') >= INET_ATON(ip_start) AND INET_ATON('3.15.1.45') <= INET_ATON(ip_end)
78	0.0032	0.0031800270080566	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0042	0.0041840076446533	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0006	0.00059795379638672	SELECT * FROM products WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-or-de-la-poussire'
81	0.0008	0.00080084800720215	UPDATE products SET viewcount = viewcount + 1 WHERE id = 2382
82	0.0005	0.00049519538879395	SELECT * FROM manufacturers WHERE id = '443'
83	0.0004	0.00042915344238281	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '443'
84	0.0015	0.0014979839324951	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '443' LIMIT 1
85	0.0020	0.0019550323486328	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '443' ORDER BY RAND() LIMIT 1
86	0.0004	0.00041890144348145	SELECT * FROM productimages WHERE product_id = '2381' ORDER BY sortorder ASC
87	0.0004	0.00037598609924316	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '443'
88	0.0004	0.00037193298339844	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '443' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0003	0.00034379959106445	SELECT * FROM manufacturerimages WHERE manufacturer_id = '443'
90	0.0003	0.00034904479980469	SELECT category_id FROM products_categories WHERE product_id = '2382'
91	0.0004	0.00044798851013184	SELECT * FROM categories WHERE id = '27'
92	0.0040	0.0039820671081543	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.00044894218444824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
94	0.0005	0.00045299530029297	SELECT id FROM categories WHERE parent_id = '27'
95	0.0053	0.0052921772003174	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.0006	0.00056195259094238	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.0005	0.0005040168762207	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.00045299530029297	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
99	0.0004	0.00039792060852051	SELECT * FROM productimages WHERE product_id = '2382' ORDER BY sortorder ASC
100	0.0017	0.0017068386077881	SELECT * FROM product_image_select WHERE product_id = '2382'
101	0.0012	0.0012109279632568	SELECT * FROM productcustomimages WHERE product_id = '2382'
102	0.0014	0.0014050006866455	SELECT * FROM productfeeds WHERE product_id = '2382' ORDER BY item_date DESC
103	0.0024	0.0024130344390869	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2382' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
104	0.0026	0.0026040077209473	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2382' AND t.hidden = 0 AND display_product = 1
105	0.0015	0.0014500617980957	SELECT * FROM productamazoncontent WHERE product_id = '2382'
106	0.0008	0.00081992149353027	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2382' AND a.name = n.originalname
107	0.0025	0.002528190612793	SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
108	0.0004	0.0003819465637207	SELECT * FROM productoffers WHERE product_id = '2382' AND price > 0 ORDER BY price ASC LIMIT 1
109	0.0003	0.00033402442932129	SELECT * FROM productoffers WHERE product_id = 2382 ORDER BY price ASC LIMIT 1
110	0.0005	0.00051307678222656	SELECT value FROM productattributes WHERE product_id = '2382' AND name = 'ListPriceAmount'
111	0.0004	0.00037407875061035	SELECT value FROM productattributes WHERE product_id = '2382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
112	0.0005	0.00046014785766602	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
113	0.0119	0.011913061141968	SELECT *, MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
114	0.0007	0.00071501731872559	SELECT *, MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
115	0.0008	0.00078606605529785	SELECT *, MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('andamp or de' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
116	0.0130	0.012986183166504	SELECT *, MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
117	0.0006	0.00060796737670898	SELECT *, MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
118	0.0004	0.00043487548828125	SELECT *, MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('poussi�re püpse thérooibos' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
119	0.0126	0.01256799697876	SELECT *, MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
120	0.0004	0.00043296813964844	SELECT *, MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
121	0.0004	0.00038790702819824	SELECT *, MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('matches21licorne thé lot' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
122	0.0114	0.011350154876709	SELECT *, MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
123	0.0004	0.00040507316589355	SELECT *, MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
124	0.0004	0.00040698051452637	SELECT *, MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('licorne magie andamp' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
125	0.0100	0.0099549293518066	SELECT *, MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AND 2382 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
126	0.0004	0.00041913986206055	SELECT *, MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
127	0.0005	0.00053000450134277	SELECT *, MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé par 100gr' IN BOOLEAN MODE) AND 2382 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
128	0.0004	0.00043416023254395	SELECT * FROM productimages WHERE product_id = '4814' ORDER BY sortorder ASC
129	0.0006	0.00055503845214844	SELECT * FROM product_image_select WHERE product_id = '4814'
130	0.0003	0.00032401084899902	SELECT * FROM productcustomimages WHERE product_id = '4814'
131	0.0014	0.0013830661773682	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4814' AND a.name = n.originalname
132	0.0008	0.00078105926513672	SELECT * FROM productoffers WHERE product_id = '4814' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0005	0.00051999092102051	SELECT * FROM productoffers WHERE product_id = '4814' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0008	0.00079083442687988	SELECT value FROM productattributes WHERE product_id = '4814' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
135	0.0004	0.00042986869812012	SELECT * FROM productimages WHERE product_id = '998' ORDER BY sortorder ASC
136	0.0015	0.0014750957489014	SELECT * FROM product_image_select WHERE product_id = '998'
137	0.0003	0.00033211708068848	SELECT * FROM productcustomimages WHERE product_id = '998'
138	0.0090	0.009019136428833	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '998' AND a.name = n.originalname
139	0.0006	0.00057601928710938	SELECT * FROM productoffers WHERE product_id = '998' AND merchantid = 'A1X6FK5RDHNB96'
140	0.0004	0.00041413307189941	SELECT * FROM productoffers WHERE product_id = '998' AND price > 0 ORDER BY price ASC LIMIT 1
141	0.0005	0.00047802925109863	SELECT value FROM productattributes WHERE product_id = '998' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142	0.0006	0.00058889389038086	SELECT * FROM productimages WHERE product_id = '992' ORDER BY sortorder ASC
143	0.0008	0.00078797340393066	SELECT * FROM product_image_select WHERE product_id = '992'
144	0.0005	0.00047111511230469	SELECT * FROM productcustomimages WHERE product_id = '992'
145	0.0018	0.0017540454864502	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '992' AND a.name = n.originalname
146	0.0007	0.00074481964111328	SELECT * FROM productoffers WHERE product_id = '992' AND merchantid = 'A1X6FK5RDHNB96'
147	0.0005	0.00045585632324219	SELECT * FROM productoffers WHERE product_id = '992' AND price > 0 ORDER BY price ASC LIMIT 1
148	0.0006	0.00057005882263184	SELECT value FROM productattributes WHERE product_id = '992' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149	0.0012	0.0011999607086182	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '2382') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
150	0.0129	0.012941837310791	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 <> '2382' ORDER BY RAND()
151	0.0006	0.00060391426086426	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 <> '2382' ORDER BY RAND()
152	0.0006	0.0006248950958252	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 <> '2382' ORDER BY RAND()
153	0.0007	0.00069999694824219	SELECT * FROM productimages WHERE product_id = '3590' ORDER BY sortorder ASC
154	0.0007	0.00067901611328125	SELECT * FROM product_image_select WHERE product_id = '3590'
155	0.0005	0.00054502487182617	SELECT * FROM productcustomimages WHERE product_id = '3590'
156	0.0012	0.0012030601501465	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3590' AND a.name = n.originalname
157	0.0006	0.00064492225646973	SELECT * FROM productoffers WHERE product_id = '3590' AND merchantid = 'A1X6FK5RDHNB96'
158	0.0005	0.00046086311340332	SELECT * FROM productoffers WHERE product_id = '3590' AND price > 0 ORDER BY price ASC LIMIT 1
159	0.0005	0.00048303604125977	SELECT * FROM productoffers WHERE product_id = 3590 ORDER BY price ASC LIMIT 1
160	0.0004	0.00040006637573242	SELECT value FROM productattributes WHERE product_id = '3590' AND name = 'ListPriceAmount'
161	0.0005	0.0005347728729248	SELECT value FROM productattributes WHERE product_id = '3590' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0006	0.00057792663574219	SELECT * FROM productimages WHERE product_id = '1254' ORDER BY sortorder ASC
163	0.0006	0.00064897537231445	SELECT * FROM product_image_select WHERE product_id = '1254'
164	0.0005	0.0005338191986084	SELECT * FROM productcustomimages WHERE product_id = '1254'
165	0.0015	0.0014870166778564	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1254' AND a.name = n.originalname
166	0.0006	0.00057697296142578	SELECT * FROM productoffers WHERE product_id = '1254' AND merchantid = 'A1X6FK5RDHNB96'
167	0.0005	0.00048589706420898	SELECT * FROM productoffers WHERE product_id = '1254' AND price > 0 ORDER BY price ASC LIMIT 1
168	0.0005	0.00050616264343262	SELECT * FROM productoffers WHERE product_id = 1254 ORDER BY price ASC LIMIT 1
169	0.0006	0.00062704086303711	SELECT value FROM productattributes WHERE product_id = '1254' AND name = 'ListPriceAmount'
170	0.0005	0.00049304962158203	SELECT value FROM productattributes WHERE product_id = '1254' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171	0.0005	0.00048208236694336	SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
172	0.0006	0.00062203407287598	SELECT * FROM product_image_select WHERE product_id = '1098'
173	0.0004	0.00035881996154785	SELECT * FROM productcustomimages WHERE product_id = '1098'
174	0.0009	0.00089311599731445	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1098' AND a.name = n.originalname
175	0.0004	0.00043892860412598	SELECT * FROM productoffers WHERE product_id = '1098' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0004	0.00039005279541016	SELECT * FROM productoffers WHERE product_id = '1098' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0003	0.00030899047851562	SELECT * FROM productoffers WHERE product_id = 1098 ORDER BY price ASC LIMIT 1
178	0.0004	0.0003511905670166	SELECT value FROM productattributes WHERE product_id = '1098' AND name = 'ListPriceAmount'
179	0.0004	0.00037503242492676	SELECT value FROM productattributes WHERE product_id = '1098' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180	0.0005	0.00045013427734375	SELECT id,asin FROM products WHERE parent_id = 2382
181	0.0015	0.0015201568603516	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2382' ORDER BY timestamp DESC
182	0.0005	0.00045394897460938	SELECT category_id FROM products_categories WHERE product_id = '2382'
183	0.0005	0.00045394897460938	SELECT * FROM categories WHERE id = '27'
184	0.0041	0.0041048526763916	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
185	0.0004	0.0003969669342041	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
186	0.0003	0.00028300285339355	SELECT id FROM categories WHERE parent_id = '27'
187	0.0051	0.0051248073577881	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
188	0.0005	0.00050592422485352	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
189	0.0005	0.00050806999206543	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
190	0.0005	0.00051498413085938	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
191	0.0008	0.00081586837768555	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2382' AND a.name = n.originalname
192	0.0005	0.00046205520629883	SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0004	0.00035691261291504	SELECT * FROM productoffers WHERE product_id = '2382' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0004	0.00039792060852051	SELECT * FROM productoffers WHERE product_id = 2382 ORDER BY price ASC LIMIT 1
195	0.0015	0.0015251636505127	SELECT value FROM productattributes WHERE product_id = '2382' AND name = 'ListPriceAmount'
196	0.0050	0.0050029754638672	SELECT * FROM products WHERE id = '2382'
197	0.0051	0.0051100254058838	SELECT value FROM productattributes WHERE product_id = '2382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198	0.0024	0.0023949146270752	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2382' AND a.name = n.originalname
199	0.0019	0.0019049644470215	SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
200	0.0005	0.00049090385437012	SELECT * FROM productoffers WHERE product_id = '2382' AND price > 0 ORDER BY price ASC LIMIT 1
201	0.0004	0.00043916702270508	SELECT * FROM productoffers WHERE product_id = 2382 ORDER BY price ASC LIMIT 1
202	0.0005	0.00049400329589844	SELECT value FROM productattributes WHERE product_id = '2382' AND name = 'ListPriceAmount'
203	0.0006	0.00062179565429688	SELECT category_id FROM products_categories WHERE product_id = '2382' AND prod_type = 'amz'
204	0.0006	0.00055694580078125	SELECT parent_id FROM categories WHERE id = '27'
205	0.0005	0.00046014785766602	SELECT * FROM categories WHERE id = '27'
206	0.0048	0.0047941207885742	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
207	0.0004	0.00043797492980957	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
208	0.0003	0.00027084350585938	SELECT id FROM categories WHERE parent_id = '27'
209	0.0037	0.0037169456481934	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
210	0.0006	0.00059604644775391	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
211	0.0006	0.00059700012207031	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
212	0.0005	0.0005490779876709	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
213	0.0005	0.00052690505981445	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
214	0.0004	0.00039100646972656	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
215	0.0003	0.00026607513427734	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
216	0.0129	0.012922048568726	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
217	0.0009	0.00091695785522461	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
218	0.0005	0.00046610832214355	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
219	0.0004	0.00044918060302734	SELECT * FROM products WHERE id = 1626
220	0.0004	0.00037288665771484	SELECT * FROM products WHERE id = 4041
221	0.0004	0.00040197372436523	SELECT * FROM products WHERE id = 4312
222	0.0004	0.00036907196044922	SELECT * FROM products WHERE id = 777
223	0.0003	0.00034403800964355	SELECT * FROM products WHERE id = 3881
224	0.0004	0.00039315223693848	SELECT * FROM products WHERE id = 4213
225	0.0003	0.00033807754516602	SELECT * FROM products WHERE id = '1626'
226	0.0005	0.00045990943908691	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
227	0.0008	0.00083279609680176	SELECT * FROM product_image_select WHERE product_id = '1626'
228	0.0004	0.00041985511779785	SELECT * FROM productcustomimages WHERE product_id = '1626'
229	0.0011	0.0010559558868408	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
230	0.0004	0.00039815902709961	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
231	0.0003	0.00031590461730957	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
232	0.0003	0.00034713745117188	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233	0.0004	0.00041794776916504	SELECT * FROM products WHERE id = '4041'
234	0.0004	0.00036811828613281	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
235	0.0006	0.00057101249694824	SELECT * FROM product_image_select WHERE product_id = '4041'
236	0.0003	0.0002748966217041	SELECT * FROM productcustomimages WHERE product_id = '4041'
237	0.0013	0.0012979507446289	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
238	0.0004	0.00043892860412598	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
239	0.0004	0.0003659725189209	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
240	0.0004	0.00040602684020996	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
241	0.0005	0.00048184394836426	SELECT * FROM products WHERE id = '4312'
242	0.0004	0.00040388107299805	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
243	0.0005	0.00052714347839355	SELECT * FROM product_image_select WHERE product_id = '4312'
244	0.0003	0.00029706954956055	SELECT * FROM productcustomimages WHERE product_id = '4312'
245	0.0009	0.00092196464538574	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
246	0.0004	0.00036501884460449	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
247	0.0004	0.00041508674621582	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
248	0.0005	0.00046086311340332	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
249	0.0005	0.00050210952758789	SELECT * FROM products WHERE id = '777'
250	0.0005	0.00047206878662109	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
251	0.0005	0.00053501129150391	SELECT * FROM product_image_select WHERE product_id = '777'
252	0.0003	0.00032997131347656	SELECT * FROM productcustomimages WHERE product_id = '777'
253	0.0009	0.0009009838104248	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
254	0.0004	0.00040102005004883	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
255	0.0003	0.00034499168395996	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
256	0.0004	0.0004420280456543	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257	0.0005	0.00048613548278809	SELECT * FROM products WHERE id = '3881'
258	0.0005	0.00051403045654297	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
259	0.0006	0.00057005882263184	SELECT * FROM product_image_select WHERE product_id = '3881'
260	0.0003	0.00032496452331543	SELECT * FROM productcustomimages WHERE product_id = '3881'
261	0.0012	0.0012490749359131	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
262	0.0005	0.00045299530029297	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
263	0.0004	0.00035309791564941	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
264	0.0006	0.00059390068054199	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265	0.0007	0.00071597099304199	SELECT * FROM products WHERE id = '4213'
266	0.0006	0.0006251335144043	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
267	0.0006	0.00055193901062012	SELECT * FROM product_image_select WHERE product_id = '4213'
268	0.0003	0.00030612945556641	SELECT * FROM productcustomimages WHERE product_id = '4213'
269	0.0010	0.00096893310546875	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
270	0.0004	0.00038599967956543	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
271	0.0003	0.0003201961517334	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
272	0.0003	0.00034594535827637	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273	0.0019	0.0018510818481445	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
274	0.0006	0.00055503845214844	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
275	0.0021	0.002108097076416	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
276	0.0016	0.0015740394592285	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
277	0.0005	0.00048089027404785	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
278	0.0017	0.0016570091247559	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

matches21 Licorne Thé Lot de 2 Stk. Licorne Magie & Or de la poussière püpse Thé/Rooibos Fruits Bos Thé par 100 gr.

Product Features

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

Thés de la Pagode rooibos Vanille Amande...

Dammann Frères - Thé Rooibos Citrus -100...

Elephant - The Rooibos Pomme Cannelle 40...

Désir de Vrai Rooibos Nature Afrique du ...

La Route Des Comptoirs - Rooïbos Nature ...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.4713249206543 seconds

Query Debug - 278 Database Queries. Total time 1.1780 seconds

matches21 Licorne Thé Lot de 2 Stk. Licorne Magie & Or de la poussière püpse Thé/Rooibos Fruits Bos Thé par 100 gr.

Product Features

Related Products

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

Thés de la Pagode rooibos Vanille Amande...

Dammann Frères - Thé Rooibos Citrus -100...

Elephant - The Rooibos Pomme Cannelle 40...

Désir de Vrai Rooibos Nature Afrique du ...

La Route Des Comptoirs - Rooïbos Nature ...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.4713249206543 seconds

Query Debug - 278 Database Queries. Total time 1.1780 seconds