matches21 Licorne Thé Lot de 2 Stk. Licorne Magie & funkelzauber Thé/Rooibos Fruits Bos Thé par 100 gr.

(cliquez sur les images pour élargir)

Bouton de clic pour le prix

En date du 2021-07-20 23:34:51 UTC (plus d'infos)

Non Disponible Épuisé

Achetez maintenant sur Amazon

Informations Produit (plus d'infos)

Voir les Détails du Produit
Lire les Avis d'Utilisateurs postés sur Amazon

Caractéristiques du Produit

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. funkelzauber avec expérience de note est d'un goût de vanille crème fine pur, directement depuis le bout de l'arc-en-ciel crée il des moments magiques. 2 variétés de 100 gr. Aroma sac fermé

Avis Amazon du Produit

Produits Connexes

Backbayia Boîtes de Rangement avec Couvercle Pots ...

seulement €15,99

Disponible

Voir Ajouter au Panier

Teatox thé aux herbes bio décaféiné avec Rooibos P...

Voir pour voir le prix

Voir Ajouter au Panier

Lipton Exclusive Selection Infusion Rooibos 25 Sac...

Voir pour voir le prix

Voir Ajouter au Panier

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
0.83662104606628	263	0.1474	0

No Amazon API Requests Made.

Total time 0.83662104606628 seconds

Number	Time From Start	Name	Description
1	0.606684923172	Initialise	Initialise FSB Function
2	0.60877704620361	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.61117100715637	Start of getCategoryListByGroup Function	Before first category groups query
4	0.61136484146118	After initial query	Before first category groups query
5	0.61136698722839	Get Category List for Group	Before the call to getCategoryList function
6	0.61137104034424	Start of GetCategoryList function	Start of the function
7	0.61137390136719	Before getting categories	Query to get specific category list
8	0.61173582077026	After getting categories	Query to get specific category list
9	0.61173701286316	Before getting category custom	Before call to function getCategoryCustom
10	0.61327886581421	After getting category custom	After call to function getCategoryCustom
11	0.61328196525574	Before getting category custom	Before call to function getCategoryCustom
12	0.6240918636322	After getting category custom	After call to function getCategoryCustom
13	0.62409496307373	Before getting category custom	Before call to function getCategoryCustom
14	0.62844085693359	After getting category custom	After call to function getCategoryCustom
15	0.62844395637512	Before getting category custom	Before call to function getCategoryCustom
16	0.63079285621643	After getting category custom	After call to function getCategoryCustom
17	0.63079500198364	Before getting category custom	Before call to function getCategoryCustom
18	0.63300395011902	After getting category custom	After call to function getCategoryCustom
19	0.63300585746765	Before getting category custom	Before call to function getCategoryCustom
20	0.63548588752747	After getting category custom	After call to function getCategoryCustom
21	0.63548898696899	End of GetCategoryList function	End of the function
22	0.635498046875	End of getCategoryListByGroup Function	Before return()
23	0.64017796516418	App Controller End	End of the App controller (called before the controller of every page)
24	0.64089703559875	Product Start	Start of the product info controller
25	0.64397883415222	Cache file not found	Starting get product details
26	0.66297602653503	Related products	Start getting related products if enabled
27	0.66297698020935	Related Products Start	Before the related products are found
28	0.66297888755798	Related Products Keywords	Before the related product keywords are found
29	0.66298389434814	Create Keyword List Function	Start of function
30	0.66307997703552	Create Keyword List Function	After looping provided content - 41 keywords found
31	0.66476082801819	Create Keyword List Function	After looping initial keyword list - 37 keywords remaining
32	0.66476988792419	Create Keyword List Function	After reducing keyword list
33	0.6649329662323	Create Keyword List Function	After selecting by scoring keywords
34	0.66493701934814	Create Keyword List Function	After final loop of keywords
35	0.66493892669678	Related Products Keywords	After the related product keywords are found
36	0.72834801673889	Related Products End	After the related products are found
37	0.73564600944519	Product End	End of the product info controller (Product Info)
38	0.73661684989929	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
39	0.73703002929688	Before Get Options	Before the call to getOptions in the tpl class
40	0.76407384872437	After Get Options	After the call to getOptions in the tpl class
41	0.76418805122375	App_after Controller End	End of the App_after controller (called after the controller of every page)
42	0.76421904563904	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
43	0.79260396957397	Product Info: After Smarty Fetch	After the product.tpl template is fetched
44	0.79261088371277	Product Info: Before Template Display	Before the template is displayed
45	0.83658790588379	Product Info: After Template Display	After the template is displayed
46	0.83660483360291	Finalizing debug	Before the debug is output to the page.
47	0.83661985397339	End of App	This is the end of the app logging, final timestamp

Query Debug - 263 Database Queries. Total time 0.1474 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.229.142.104\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627930046'
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-funkelzauber' LIMIT 1
SELECT id FROM products WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-funkelzauber' AND hidden = 0 LIMIT 1
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
SELECT * FROM pages WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-funkelzauber'
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 manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' 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-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('3.229.142.104') >= INET_ATON(ip_start) AND INET_ATON('3.229.142.104') <= 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-funkelzauber'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 2377
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 = '2375' 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 = '2377'
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 = '2377' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2377'
SELECT * FROM productcustomimages WHERE product_id = '2377'
SELECT * FROM productfeeds WHERE product_id = '2377' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2377' 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 = '2377' AND t.hidden = 0 AND display_product = 1
SELECT * FROM productamazoncontent WHERE product_id = '2377'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2377' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2377' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2377
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2377'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2377' 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 ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AND 2377 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
SELECT *, MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AND 2377 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
SELECT *, MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AND 2377 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 3
SELECT * FROM productimages WHERE product_id = '3407' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3407'
SELECT * FROM productcustomimages WHERE product_id = '3407'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3407' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3407' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3407' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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 2377 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
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 2377 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
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 2377 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
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 2377 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
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 2377 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
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 2377 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 2
SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '2377') 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 <> '2377' 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 <> '2377' 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 <> '2377' ORDER BY RAND()
SELECT * FROM productimages WHERE product_id = '2243' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2243'
SELECT * FROM productcustomimages WHERE product_id = '2243'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2243' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2243' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2243' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2243
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2243'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2243' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4648' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4648' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4648'
SELECT * FROM productcustomimages WHERE product_id = '4648'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4648'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4648'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4648
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4648' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4648' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4648' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4648
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4648'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4648'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4648'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4648
SELECT value FROM productattributes WHERE product_id = '4648' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4648'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4648'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2309' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2309' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2309' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2309
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2309'
                AND name = 'ListPriceAmount'
SELECT id,asin FROM products WHERE parent_id = 2377
SELECT category_id FROM products_categories WHERE product_id = '2377'
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 = '2377' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2377' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2377
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2377'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '2377'
SELECT value FROM productattributes WHERE product_id = '2377' 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 = '2377' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2377' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2377
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2377'
                AND name = 'ListPriceAmount'
SELECT category_id FROM products_categories WHERE product_id = '2377' 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-smoothstore'
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 * FROM pages WHERE id = 38
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1627930046;s:8:\"products\";a:6:{i:0;s:10:\"790|amazon\";i:1;s:10:\"788|amazon\";i:2;s:10:\"787|amazon\";i:3;s:11:\"1287|amazon\";i:4;s:10:\"777|amazon\";i:5;s:10:\"776|amazon\";}}' WHERE id = '160'
SELECT * FROM products WHERE id = 790
SELECT * FROM products WHERE id = 788
SELECT * FROM products WHERE id = 787
SELECT * FROM products WHERE id = 1287
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 776
SELECT * FROM products WHERE id = '790'
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '790'
SELECT * FROM productcustomimages WHERE product_id = '790'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '788'
SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '788'
SELECT * FROM productcustomimages WHERE product_id = '788'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '788' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '787'
SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '787'
SELECT * FROM productcustomimages WHERE product_id = '787'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '787' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1287'
SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1287'
SELECT * FROM productcustomimages WHERE product_id = '1287'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1287' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1287' 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 = '776'
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '776'
SELECT * FROM productcustomimages WHERE product_id = '776'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0004	0.0003809928894043	SELECT parameter, value FROM parameters
2	0.0008	0.00084590911865234	SELECT * FROM `bad_bots`
3	0.0002	0.00021910667419434	SET time_zone = 'Europe/London'
4	0.0002	0.00019693374633789	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0014	0.0014379024505615	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.229.142.104\";}'
6	0.0007	0.00068998336791992	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1627930046'
7	0.0003	0.00027704238891602	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0002	0.00018715858459473	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0005	0.00050210952758789	SELECT id FROM pages WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-funkelzauber' LIMIT 1
10	0.0004	0.00040006637573242	SELECT id FROM products WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-funkelzauber' AND hidden = 0 LIMIT 1
11	0.0008	0.00075602531433105	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
12	0.0008	0.00079202651977539	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
13	0.0004	0.00039291381835938	SELECT * FROM pages WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-funkelzauber'
14	0.0002	0.0001828670501709	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0003	0.00034189224243164	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0002	0.0001530647277832	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.0002	0.00017905235290527	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.0002	0.00015687942504883	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0002	0.00015091896057129	SELECT id FROM categories WHERE parent_id = '26'
20	0.0002	0.00018000602722168	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.0001	0.00014996528625488	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.0002	0.00015377998352051	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.0001	0.00014710426330566	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0002	0.00015807151794434	SELECT * FROM categorygroups WHERE id = '1'
25	0.0046	0.0045731067657471	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.0006411075592041	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.0002	0.00021100044250488	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0002	0.00017714500427246	SELECT id FROM categories WHERE parent_id = '27'
29	0.0043	0.0043430328369141	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.0002	0.00020384788513184	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.0002	0.00023698806762695	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.0002	0.00015807151794434	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0002	0.00015592575073242	SELECT * FROM categorygroups WHERE id = '1'
34	0.0015	0.001507043838501	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.0002	0.00024986267089844	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.0002	0.00018882751464844	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0002	0.00016498565673828	SELECT id FROM categories WHERE parent_id = '28'
38	0.0014	0.0014429092407227	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.0002	0.00018787384033203	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.0002	0.00017404556274414	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.0002	0.00015807151794434	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0002	0.00016188621520996	SELECT * FROM categorygroups WHERE id = '1'
43	0.0004	0.00043177604675293	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.0002	0.0002129077911377	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.0002	0.00018000602722168	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0001	0.00014996528625488	SELECT id FROM categories WHERE parent_id = '29'
47	0.0004	0.00042486190795898	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.0002	0.00023603439331055	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.0002	0.00020790100097656	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.0002	0.00023698806762695	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0002	0.00016593933105469	SELECT * FROM categorygroups WHERE id = '1'
52	0.0005	0.00046586990356445	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.0002	0.0001521110534668	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.0002	0.00016212463378906	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0002	0.0001978874206543	SELECT id FROM categories WHERE parent_id = '30'
56	0.0005	0.00045490264892578	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.0002	0.00018095970153809	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.0002	0.00016689300537109	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.0002	0.00015592575073242	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0002	0.00017905235290527	SELECT * FROM categorygroups WHERE id = '1'
61	0.0006	0.00059390068054199	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.0002	0.00018405914306641	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.0002	0.00017905235290527	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0002	0.00016593933105469	SELECT id FROM categories WHERE parent_id = '31'
65	0.0006	0.00057482719421387	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.0002	0.00016689300537109	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.0002	0.00016903877258301	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.0002	0.00017595291137695	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0002	0.00017094612121582	SELECT * FROM categorygroups WHERE id = '1'
70	0.0002	0.00017881393432617	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71	0.0002	0.00024294853210449	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72	0.0002	0.00021982192993164	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
73	0.0002	0.00022506713867188	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74	0.0005	0.00046086311340332	SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
75	0.0006	0.00055289268493652	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76	0.0002	0.00017595291137695	SELECT * FROM ipgeocountries WHERE INET_ATON('3.229.142.104') >= INET_ATON(ip_start) AND INET_ATON('3.229.142.104') <= INET_ATON(ip_end)
77	0.0002	0.0001680850982666	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78	0.0002	0.00015091896057129	SELECT * FROM countryredirects WHERE countrycode = 'US'
79	0.0006	0.00058889389038086	SELECT * FROM products WHERE pagename = 'matches21licorne-the-lot-de-2stk-licorne-magie-funkelzauber'
80	0.0014	0.001378059387207	UPDATE products SET viewcount = viewcount + 1 WHERE id = 2377
81	0.0004	0.00041890144348145	SELECT * FROM manufacturers WHERE id = '442'
82	0.0004	0.00043201446533203	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '442'
83	0.0002	0.00018596649169922	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '442' LIMIT 1
84	0.0006	0.00062894821166992	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
85	0.0002	0.00018906593322754	SELECT * FROM productimages WHERE product_id = '2375' ORDER BY sortorder ASC
86	0.0002	0.0001530647277832	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '442'
87	0.0005	0.00046396255493164	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
88	0.0002	0.00020217895507812	SELECT * FROM manufacturerimages WHERE manufacturer_id = '442'
89	0.0002	0.00023102760314941	SELECT category_id FROM products_categories WHERE product_id = '2377'
90	0.0002	0.00018405914306641	SELECT * FROM categories WHERE id = '27'
91	0.0044	0.0044209957122803	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
92	0.0003	0.00033998489379883	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
93	0.0002	0.00016283988952637	SELECT id FROM categories WHERE parent_id = '27'
94	0.0043	0.0042879581451416	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
95	0.0002	0.00023007392883301	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
96	0.0002	0.00015711784362793	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
97	0.0001	0.00014877319335938	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
98	0.0002	0.00018000602722168	SELECT * FROM productimages WHERE product_id = '2377' ORDER BY sortorder ASC
99	0.0002	0.00016093254089355	SELECT * FROM product_image_select WHERE product_id = '2377'
100	0.0002	0.0001530647277832	SELECT * FROM productcustomimages WHERE product_id = '2377'
101	0.0003	0.00032997131347656	SELECT * FROM productfeeds WHERE product_id = '2377' ORDER BY item_date DESC
102	0.0021	0.0020861625671387	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '2377' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
103	0.0005	0.00054216384887695	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '2377' AND t.hidden = 0 AND display_product = 1
104	0.0007	0.00072407722473145	SELECT * FROM productamazoncontent WHERE product_id = '2377'
105	0.0002	0.00017595291137695	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2377' AND a.name = n.originalname
106	0.0002	0.00018787384033203	SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
107	0.0002	0.00018405914306641	SELECT * FROM productoffers WHERE product_id = '2377' AND price > 0 ORDER BY price ASC LIMIT 1
108	0.0002	0.00019097328186035	SELECT * FROM productoffers WHERE product_id = 2377 ORDER BY price ASC LIMIT 1
109	0.0002	0.00020289421081543	SELECT value FROM productattributes WHERE product_id = '2377' AND name = 'ListPriceAmount'
110	0.0002	0.00017809867858887	SELECT value FROM productattributes WHERE product_id = '2377' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
111	0.0002	0.00020480155944824	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
112	0.0074	0.0073609352111816	SELECT *, MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AND 2377 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 3
113	0.0005	0.00053000450134277	SELECT *, MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AND 2377 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 3
114	0.0005	0.00050210952758789	SELECT *, MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('funkelzauber thérooibos fruits' IN BOOLEAN MODE) AND 2377 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 3
115	0.0004	0.00039482116699219	SELECT * FROM productimages WHERE product_id = '3407' ORDER BY sortorder ASC
116	0.0002	0.00018191337585449	SELECT * FROM product_image_select WHERE product_id = '3407'
117	0.0002	0.0002140998840332	SELECT * FROM productcustomimages WHERE product_id = '3407'
118	0.0002	0.00020194053649902	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3407' AND a.name = n.originalname
119	0.0002	0.00018000602722168	SELECT * FROM productoffers WHERE product_id = '3407' AND merchantid = 'A1X6FK5RDHNB96'
120	0.0002	0.0002129077911377	SELECT * FROM productoffers WHERE product_id = '3407' AND price > 0 ORDER BY price ASC LIMIT 1
121	0.0002	0.00018000602722168	SELECT value FROM productattributes WHERE product_id = '3407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122	0.0069	0.0069029331207275	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 2377 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
123	0.0006	0.00057411193847656	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 2377 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 2
124	0.0005	0.00052404403686523	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 2377 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 2
125	0.0078	0.0077900886535645	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 2377 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 2
126	0.0007	0.00066900253295898	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 2377 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 2
127	0.0005	0.00054097175598145	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 2377 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 2
128	0.0015	0.001450777053833	SELECT categories.id, COUNT(*) as productcount FROM products_categories, categories WHERE categories.id IN (SELECT category_id FROM products_categories WHERE product_id = '2377') AND products_categories.category_id = categories.id GROUP BY categories.id ORDER BY productcount ASC
129	0.0123	0.012273073196411	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 <> '2377' ORDER BY RAND()
130	0.0005	0.00053000450134277	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 <> '2377' ORDER BY RAND()
131	0.0005	0.00051712989807129	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 <> '2377' ORDER BY RAND()
132	0.0013	0.0013391971588135	SELECT * FROM productimages WHERE product_id = '2243' ORDER BY sortorder ASC
133	0.0013	0.0012929439544678	SELECT * FROM product_image_select WHERE product_id = '2243'
134	0.0004	0.00041699409484863	SELECT * FROM productcustomimages WHERE product_id = '2243'
135	0.0017	0.0017459392547607	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2243' AND a.name = n.originalname
136	0.0010	0.00099802017211914	SELECT * FROM productoffers WHERE product_id = '2243' AND merchantid = 'A1X6FK5RDHNB96'
137	0.0003	0.00034904479980469	SELECT * FROM productoffers WHERE product_id = '2243' AND price > 0 ORDER BY price ASC LIMIT 1
138	0.0005	0.00051212310791016	SELECT * FROM productoffers WHERE product_id = 2243 ORDER BY price ASC LIMIT 1
139	0.0003	0.00028681755065918	SELECT value FROM productattributes WHERE product_id = '2243' AND name = 'ListPriceAmount'
140	0.0007	0.00066399574279785	SELECT value FROM productattributes WHERE product_id = '2243' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141	0.0005	0.00047016143798828	SELECT * FROM productimages WHERE product_id = '4648' ORDER BY sortorder ASC
142	0.0009	0.00093412399291992	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4648' AND p.id = pi.product_id ORDER BY pi.sortorder
143	0.0002	0.00017309188842773	SELECT * FROM product_image_select WHERE product_id = '4648'
144	0.0002	0.00018715858459473	SELECT * FROM productcustomimages WHERE product_id = '4648'
145	0.0004	0.00036883354187012	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '4648' GROUP BY o.product_id
146	0.0012	0.0011579990386963	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '4648' GROUP BY n.displayname ORDER BY n.displayname DESC
147	0.0004	0.00039982795715332	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4648
148	0.0018	0.0017938613891602	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4648' AND a.name = n.originalname
149	0.0004	0.00039291381835938	SELECT * FROM productoffers WHERE product_id = '4648' AND merchantid = 'A1X6FK5RDHNB96'
150	0.0005	0.0005497932434082	SELECT * FROM productoffers WHERE product_id = '4648' AND price > 0 ORDER BY price ASC LIMIT 1
151	0.0003	0.00027990341186523	SELECT * FROM productoffers WHERE product_id = 4648 ORDER BY price ASC LIMIT 1
152	0.0004	0.00035715103149414	SELECT value FROM productattributes WHERE product_id = '4648' AND name = 'ListPriceAmount'
153	0.0002	0.00020599365234375	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '4648' GROUP BY o.product_id
154	0.0002	0.00017118453979492	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '4648' GROUP BY n.displayname ORDER BY n.displayname DESC
155	0.0001	0.00014185905456543	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4648
156	0.0004	0.00039505958557129	SELECT value FROM productattributes WHERE product_id = '4648' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157	0.0008	0.00082612037658691	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4648' AND p.id = o.product_id AND o.name = 'PackageQuantity' GROUP BY o.value ORDER BY o.value ASC
158	0.0004	0.00041103363037109	SELECT * FROM products WHERE parent_id = '4648'
159	0.0010	0.0010380744934082	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2309' AND a.name = n.originalname
160	0.0004	0.00043487548828125	SELECT * FROM productoffers WHERE product_id = '2309' AND merchantid = 'A1X6FK5RDHNB96'
161	0.0004	0.00037121772766113	SELECT * FROM productoffers WHERE product_id = '2309' AND price > 0 ORDER BY price ASC LIMIT 1
162	0.0005	0.00052189826965332	SELECT * FROM productoffers WHERE product_id = 2309 ORDER BY price ASC LIMIT 1
163	0.0003	0.00032305717468262	SELECT value FROM productattributes WHERE product_id = '2309' AND name = 'ListPriceAmount'
164	0.0004	0.00041508674621582	SELECT id,asin FROM products WHERE parent_id = 2377
165	0.0002	0.00024294853210449	SELECT category_id FROM products_categories WHERE product_id = '2377'
166	0.0002	0.00021100044250488	SELECT * FROM categories WHERE id = '27'
167	0.0002	0.00018811225891113	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
168	0.0002	0.00020480155944824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
169	0.0002	0.00018000602722168	SELECT id FROM categories WHERE parent_id = '27'
170	0.0002	0.00017595291137695	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
171	0.0002	0.00021696090698242	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
172	0.0002	0.00021982192993164	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
173	0.0002	0.00018000602722168	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
174	0.0002	0.00020503997802734	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2377' AND a.name = n.originalname
175	0.0002	0.00018811225891113	SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0002	0.0001978874206543	SELECT * FROM productoffers WHERE product_id = '2377' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0002	0.00018000602722168	SELECT * FROM productoffers WHERE product_id = 2377 ORDER BY price ASC LIMIT 1
178	0.0002	0.0001680850982666	SELECT value FROM productattributes WHERE product_id = '2377' AND name = 'ListPriceAmount'
179	0.0007	0.00074100494384766	SELECT * FROM products WHERE id = '2377'
180	0.0002	0.00015902519226074	SELECT value FROM productattributes WHERE product_id = '2377' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181	0.0002	0.00018000602722168	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2377' AND a.name = n.originalname
182	0.0002	0.00018596649169922	SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
183	0.0002	0.0001678466796875	SELECT * FROM productoffers WHERE product_id = '2377' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0002	0.00017380714416504	SELECT * FROM productoffers WHERE product_id = 2377 ORDER BY price ASC LIMIT 1
185	0.0002	0.00016689300537109	SELECT value FROM productattributes WHERE product_id = '2377' AND name = 'ListPriceAmount'
186	0.0004	0.00044894218444824	SELECT category_id FROM products_categories WHERE product_id = '2377' AND prod_type = 'amz'
187	0.0002	0.00017189979553223	SELECT parent_id FROM categories WHERE id = '27'
188	0.0002	0.00017404556274414	SELECT * FROM categories WHERE id = '27'
189	0.0001	0.0001380443572998	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
190	0.0001	0.00013899803161621	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
191	0.0001	0.00014114379882812	SELECT id FROM categories WHERE parent_id = '27'
192	0.0001	0.00014781951904297	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
193	0.0001	0.00013899803161621	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
194	0.0001	0.00014090538024902	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
195	0.0001	0.0001380443572998	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
196	0.0002	0.00023412704467773	SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
197	0.0002	0.0001521110534668	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
198	0.0002	0.00018119812011719	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
199	0.0003	0.00025582313537598	SELECT * FROM pages WHERE id = 38
200	0.0043	0.0042939186096191	SELECT DISTINCT p.id FROM products p, productoffers o WHERE p.id IN (SELECT product_id FROM productoffers WHERE 1 ) OR p.parent_id IN (SELECT product_id FROM productoffers WHERE 1 ) AND p.parent_id = 0 LIMIT 6
201	0.0009	0.00092601776123047	UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"6\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1627930046;s:8:\"products\";a:6:{i:0;s:10:\"790\|amazon\";i:1;s:10:\"788\|amazon\";i:2;s:10:\"787\|amazon\";i:3;s:11:\"1287\|amazon\";i:4;s:10:\"777\|amazon\";i:5;s:10:\"776\|amazon\";}}' WHERE id = '160'
202	0.0005	0.00052785873413086	SELECT * FROM products WHERE id = 790
203	0.0007	0.00066804885864258	SELECT * FROM products WHERE id = 788
204	0.0005	0.00052905082702637	SELECT * FROM products WHERE id = 787
205	0.0005	0.0004889965057373	SELECT * FROM products WHERE id = 1287
206	0.0006	0.00060510635375977	SELECT * FROM products WHERE id = 777
207	0.0012	0.0011968612670898	SELECT * FROM products WHERE id = 776
208	0.0006	0.00064301490783691	SELECT * FROM products WHERE id = '790'
209	0.0004	0.0003960132598877	SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
210	0.0002	0.00020503997802734	SELECT * FROM product_image_select WHERE product_id = '790'
211	0.0002	0.00018000602722168	SELECT * FROM productcustomimages WHERE product_id = '790'
212	0.0002	0.00020503997802734	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
213	0.0002	0.00017094612121582	SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
214	0.0002	0.00020194053649902	SELECT * FROM productoffers WHERE product_id = '790' AND price > 0 ORDER BY price ASC LIMIT 1
215	0.0003	0.00030088424682617	SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216	0.0005	0.00048995018005371	SELECT * FROM products WHERE id = '788'
217	0.0004	0.0003509521484375	SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
218	0.0002	0.00023007392883301	SELECT * FROM product_image_select WHERE product_id = '788'
219	0.0002	0.00020098686218262	SELECT * FROM productcustomimages WHERE product_id = '788'
220	0.0002	0.00018501281738281	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
221	0.0002	0.00017595291137695	SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
222	0.0002	0.00018501281738281	SELECT * FROM productoffers WHERE product_id = '788' AND price > 0 ORDER BY price ASC LIMIT 1
223	0.0002	0.00023078918457031	SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224	0.0004	0.00038981437683105	SELECT * FROM products WHERE id = '787'
225	0.0002	0.00017285346984863	SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
226	0.0002	0.00018501281738281	SELECT * FROM product_image_select WHERE product_id = '787'
227	0.0002	0.00017595291137695	SELECT * FROM productcustomimages WHERE product_id = '787'
228	0.0002	0.00018191337585449	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
229	0.0002	0.00019192695617676	SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
230	0.0002	0.00019979476928711	SELECT * FROM productoffers WHERE product_id = '787' AND price > 0 ORDER BY price ASC LIMIT 1
231	0.0002	0.00020098686218262	SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232	0.0004	0.00040078163146973	SELECT * FROM products WHERE id = '1287'
233	0.0004	0.00037693977355957	SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
234	0.0002	0.00020790100097656	SELECT * FROM product_image_select WHERE product_id = '1287'
235	0.0002	0.00018000602722168	SELECT * FROM productcustomimages WHERE product_id = '1287'
236	0.0002	0.00023388862609863	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
237	0.0002	0.00019407272338867	SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
238	0.0003	0.00028300285339355	SELECT * FROM productoffers WHERE product_id = '1287' AND price > 0 ORDER BY price ASC LIMIT 1
239	0.0003	0.00033688545227051	SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240	0.0005	0.00051212310791016	SELECT * FROM products WHERE id = '777'
241	0.0002	0.00018191337585449	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
242	0.0002	0.00023508071899414	SELECT * FROM product_image_select WHERE product_id = '777'
243	0.0002	0.00017189979553223	SELECT * FROM productcustomimages WHERE product_id = '777'
244	0.0002	0.00019979476928711	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
245	0.0002	0.00020599365234375	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
246	0.0002	0.00019097328186035	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
247	0.0003	0.00032687187194824	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248	0.0004	0.00044393539428711	SELECT * FROM products WHERE id = '776'
249	0.0004	0.00040197372436523	SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
250	0.0002	0.00024890899658203	SELECT * FROM product_image_select WHERE product_id = '776'
251	0.0002	0.00018692016601562	SELECT * FROM productcustomimages WHERE product_id = '776'
252	0.0002	0.0002140998840332	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
253	0.0002	0.00020813941955566	SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
254	0.0002	0.00023603439331055	SELECT * FROM productoffers WHERE product_id = '776' AND price > 0 ORDER BY price ASC LIMIT 1
255	0.0002	0.00021910667419434	SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256	0.0003	0.00031900405883789	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
257	0.0005	0.00049018859863281	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
258	0.0005	0.00049495697021484	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
259	0.0005	0.00045990943908691	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
260	0.0004	0.00043010711669922	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
261	0.0006	0.00062394142150879	SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
262	0.0004	0.00044798851013184	SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
263	0.0003	0.00026106834411621	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'

matches21 Licorne Thé Lot de 2 Stk. Licorne Magie & funkelzauber Thé/Rooibos Fruits Bos Thé par 100 gr.

Caractéristiques du Produit

Produits Connexes

Backbayia Boîtes de Rangement avec Couvercle Pots ...

Teatox thé aux herbes bio décaféiné avec Rooibos P...

Lipton Exclusive Selection Infusion Rooibos 25 Sac...

Votre panier

Par Catégories

Debug Overview

No Amazon API Requests Made.

Total time 0.83662104606628 seconds

Query Debug - 263 Database Queries. Total time 0.1474 seconds