Thés verts

Trier par:

Afficher

Matcha Premium 200 gr

Voir pour voir le prix

Voir Ajouter au Panier

Thé Matcha de Cuisine Bio Japonais 50 g | Thé Vert...

seulement €8,99

Disponible

Voir Ajouter au Panier

Thé vert au Jasmin Bio 200g

seulement €13,95

Disponible

Voir Ajouter au Panier

Thé vert DETOX BIO 200g - avec menthe, maté, pisse...

€11,90 €9,99

Disponible

Voir Ajouter au Panier

Thé vert nature Sencha Bio 200 gr

seulement €13,97

Voir Ajouter au Panier

Thé vert Sencha organique (1000g) - Haut Style Jap...

seulement €20,90

Disponible

Voir Ajouter au Panier

Kumiko Matcha - thé matcha premium bio du Japon - ...

seulement €35,00

Disponible

Voir Ajouter au Panier

VAHDAM, Thé Vert Matcha| Poudre de thé matcha | 10...

seulement €9,99

Voir Ajouter au Panier

Kusmi Tea - Assortiment Miniatures – Les Verts

seulement €16,43

Voir Ajouter au Panier

Quertee® - Thé vert – Thé au jasmin de Chine riche...

seulement €12,90

Voir Ajouter au Panier

Florisens thé vert sencha bio - Sachet de 85 g

€10,85 €9,99

Disponible

Voir Ajouter au Panier

Jardin Bio Thé Vert Detox 30 g parent

Voir pour voir le prix

Voir Ajouter au Panier

Thé vert Menthe poivrée BIO 200g

seulement €13,97

Voir Ajouter au Panier

Thé vert à la menthe Touareg - Dammann frères

seulement €19,99

Disponible

Voir Ajouter au Panier

Thé vert sencha et riz grillé - Genmaicha - 100g

seulement €9,99

Voir Ajouter au Panier

Comptoirs Richard Thé Vert Jasmin Boîte Métal Vrac...

€12,00 €11,21

Disponible

Voir Ajouter au Panier

thé matcha de cuisine bio du Japon - 100g - idéal ...

Voir pour voir le prix

Voir Ajouter au Panier

Lipton Thé Vert Menthe Intense

Voir pour voir le prix

Voir Ajouter au Panier

1 to 18 de 66 produits

1 2 3 4

Suivant ›

Filtres Produits (plus)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.1571118831635	390	0.1750	0

No Amazon API Requests Made.

Total time 1.1571118831635 seconds

Number	Time From Start	Name	Description
1	0.67992496490479	Initialise	Initialise FSB Function
2	0.68465280532837	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.7007098197937	App Controller End	End of the App controller (called before the controller of every page)
4	0.70152401924133	Category Start	Start of the category controller
5	0.70152688026428	Before Get Category	Before getting the category information
6	0.71305990219116	After Get Category	After getting the category information
7	0.71306180953979	Before Get Category List	Before getting the updated category list
8	0.7132568359375	Start of getCategoryListByGroup Function	Before first category groups query
9	0.71345591545105	After initial query	Before first category groups query
10	0.71345901489258	Get Category List for Group	Before the call to getCategoryList function
11	0.71346187591553	Start of GetCategoryList function	Start of the function
12	0.71346592903137	Before getting categories	Query to get specific category list
13	0.71372294425964	After getting categories	Query to get specific category list
14	0.71372485160828	Before getting category custom	Before call to function getCategoryCustom
15	0.71538186073303	After getting category custom	After call to function getCategoryCustom
16	0.71538591384888	Before getting category custom	Before call to function getCategoryCustom
17	0.72465491294861	After getting category custom	After call to function getCategoryCustom
18	0.72465801239014	Before getting category custom	Before call to function getCategoryCustom
19	0.72623896598816	After getting category custom	After call to function getCategoryCustom
20	0.72624087333679	Before getting sub category list	Before call to recursive function getCategoryList
21	0.72624397277832	Start of GetCategoryList function	Start of the function
22	0.72624588012695	Before getting categories	Query to get specific category list
23	0.72662901878357	After getting sub category list	After call to recursive function getCategoryList
24	0.7266309261322	Before getting category custom	Before call to function getCategoryCustom
25	0.72876596450806	After getting category custom	After call to function getCategoryCustom
26	0.72876787185669	Before getting category custom	Before call to function getCategoryCustom
27	0.73092103004456	After getting category custom	After call to function getCategoryCustom
28	0.73092293739319	Before getting category custom	Before call to function getCategoryCustom
29	0.73329496383667	After getting category custom	After call to function getCategoryCustom
30	0.73329782485962	End of GetCategoryList function	End of the function
31	0.73330497741699	End of getCategoryListByGroup Function	Before return()
32	0.73330688476562	After Get Category List	After getting the updated category list
33	0.73330783843994	Before Category Images	Before getting the category images
34	0.73356699943542	After Category Images	After getting the category images
35	0.73390197753906	Before Sub Category Check	Before checking for sub category or products category
36	0.73421692848206	Before Category Products Controller	Before loading the category products controller
37	0.7355329990387	Start Category Products	Start of Category Products Controller
38	0.73555397987366	After Pagination Options	After pagination options in Category Products Controller
39	0.73631501197815	After Cache	After Cache checking in Category Products Controller
40	0.74420595169067	After Filter Options	After getting filter options and SQL in Category Products Controller
41	0.74649500846863	After Counting Products	After counting products in the Category Products Controller
42	0.74711894989014	After Counting Bundles	After counting bundles in the Category Products Controller
43	0.74743580818176	After Counting Products	After counting products in the Category Products Controller
44	0.75049901008606	After Getting Products	After getting products and bundles in the Category Products Controller
45	0.75055193901062	After Pagination Links	After getting pagination listing links in the Category Products Controller
46	0.75055384635925	After Getting Bundle Details	After getting full details for the bundles in the Category Products Controller
47	0.8407609462738	After Getting Product Details	After getting full product details in the Category Products Controller
48	0.84682393074036	After Getting Product/Bundle Reviews	After getting full product/bundle customer review in the Category Products Controller
49	0.84852385520935	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
50	0.84902501106262	Before Get Options	Before the call to getOptions in the tpl class
51	0.87190389633179	After Get Options	After the call to getOptions in the tpl class
52	0.87208700180054	App_after Controller End	End of the App_after controller (called after the controller of every page)
53	0.87211585044861	Before Smarty	Before passing everything over to Smarty in the Category Products Controller
54	1.1570899486542	After Loading sub/product controller	After checking for sub category or products category and then loading the relevant controller
55	1.157096862793	Finalizing debug	Before the debug is output to the page.
56	1.1571109294891	End of App	This is the end of the app logging, final timestamp

Query Debug - 390 Database Queries. Total time 0.1750 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:14:\"18.205.192.201\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628124735'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'thes-verts' LIMIT 1
SELECT id FROM products WHERE pagename = 'thes-verts' AND hidden = 0 LIMIT 1
SELECT id FROM ebay_products WHERE pagename = 'thes-verts'
SELECT id FROM custom_products WHERE pagename = 'thes-verts'
SELECT id FROM categories WHERE pagename = 'thes-verts' 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 = 'thes-verts'
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('18.205.192.201') >= INET_ATON(ip_start) AND INET_ATON('18.205.192.201') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM categories WHERE pagename = 'thes-verts'
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(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 id FROM categories WHERE parent_id = '28'
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 28
SELECT * FROM categorygroups WHERE id = '1'
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '28'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
SELECT parent_id FROM categories WHERE id = '28'
SELECT parent_id FROM categories WHERE id = '28'
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 * FROM categories WHERE parent_id = '28'  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 = 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 categoryimages WHERE category_id = 28
SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
SELECT * FROM categories WHERE parent_id = '28'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
		WHERE p.id = c.product_id AND parent_id = 0
		AND c.category_id = 28
		AND (c.prod_type = '' OR c.prod_type = 'amz')
		AND hidden = 0
		AND enabled = 1
		
		AND 1 = 1
SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND hide = 0
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id AND parent_id = 0
			AND c.category_id = 28
			AND p.disabled = 0
			
			AND 1 = 1
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
		WHERE cp.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'custom'
		AND hide = 0
SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c
			WHERE p.id = c.product_id
			AND p.parent_id = 0
			AND c.category_id = 28
			AND hidden = 0
			AND enabled = 1
			
			AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c
		WHERE p.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'custom'
		AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c
			WHERE p.id = c.bundle_id
			AND c.category_id = 28
			AND disabled = 0
			
			AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
SELECT * FROM products WHERE id = '2029'
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2029'
SELECT * FROM productcustomimages WHERE product_id = '2029'
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 = '2029'
                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     = '2029'
                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 = 2029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2029'
                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 = '2029'
                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     = '2029'
                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 = 2029
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2029'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
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 = '1160'
SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1160'
SELECT * FROM productcustomimages WHERE product_id = '1160'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1160' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1217'
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1217'
SELECT * FROM productcustomimages WHERE product_id = '1217'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1217' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1110'
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1110' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1110'
SELECT * FROM productcustomimages WHERE product_id = '1110'
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 = '1110'
                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     = '1110'
                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 = 1110
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1110
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1110'
                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 = '1110'
                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     = '1110'
                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 = 1110
SELECT * FROM products WHERE parent_id = '1110'
SELECT * FROM products WHERE id = '4906'
SELECT * FROM productimages WHERE product_id = '4906' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4906'
SELECT * FROM productcustomimages WHERE product_id = '4906'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4906' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4906' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4906' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4906' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '868'
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '868'
SELECT * FROM productcustomimages WHERE product_id = '868'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4904'
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4904'
SELECT * FROM productcustomimages WHERE product_id = '4904'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4904' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4904
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4904'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1201'
SELECT * FROM productimages WHERE product_id = '1201' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1201'
SELECT * FROM productcustomimages WHERE product_id = '1201'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1201' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1201' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1201' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1201
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1201'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '4909'
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4909'
SELECT * FROM productcustomimages WHERE product_id = '4909'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4909
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4909'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1237'
SELECT * FROM productimages WHERE product_id = '1237' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1237'
SELECT * FROM productcustomimages WHERE product_id = '1237'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1237' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1237' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3925'
SELECT * FROM productimages WHERE product_id = '3925' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3925' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3925'
SELECT * FROM productcustomimages WHERE product_id = '3925'
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 = '3925'
                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     = '3925'
                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 = 3925
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3925' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3925' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3925' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3925
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3925'
                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 = '3925'
                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     = '3925'
                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 = 3925
SELECT value FROM productattributes WHERE product_id = '3925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3925'
                  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 = '3925'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3926' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3926' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3926' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3926
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3926'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '970'
SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '970'
SELECT * FROM productcustomimages WHERE product_id = '970'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '970' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 970
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '970'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1152'
SELECT * FROM productimages WHERE product_id = '1152' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1152'
SELECT * FROM productcustomimages WHERE product_id = '1152'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1152' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1152' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1152' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1152' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1145'
SELECT * FROM productimages WHERE product_id = '1145' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1145'
SELECT * FROM productcustomimages WHERE product_id = '1145'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1145' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1145' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1145' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1145
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1145'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '4905'
SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4905'
SELECT * FROM productcustomimages WHERE product_id = '4905'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4905' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1090'
SELECT * FROM productimages WHERE product_id = '1090' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1090'
SELECT * FROM productcustomimages WHERE product_id = '1090'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1090' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1090' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1090' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1090
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1090'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1090' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '853'
SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '853'
SELECT * FROM productcustomimages WHERE product_id = '853'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '853' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 853
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '853'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1287' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1217' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4906' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4904' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1201' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4909' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1237' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3925' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '970' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1152' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1145' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4905' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1090' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '853' ORDER BY timestamp DESC
SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c
		WHERE ep.id = c.product_id
		AND c.category_id = 28
		AND c.prod_type = 'ebay'
		AND hide = 0
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 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:1628124736;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 = 'ICON_RSS_FEED'
SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
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.0006	0.00061511993408203	SELECT parameter, value FROM parameters
2	0.0010	0.0010390281677246	SELECT * FROM `bad_bots`
3	0.0003	0.00034713745117188	SET time_zone = 'Europe/London'
4	0.0005	0.00049686431884766	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0021	0.0021460056304932	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.205.192.201\";}'
6	0.0016	0.0015640258789062	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1628124735'
7	0.0005	0.00046896934509277	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0004	0.00035810470581055	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0007	0.00072693824768066	SELECT id FROM pages WHERE pagename = 'thes-verts' LIMIT 1
10	0.0006	0.00056099891662598	SELECT id FROM products WHERE pagename = 'thes-verts' AND hidden = 0 LIMIT 1
11	0.0006	0.00060701370239258	SELECT id FROM ebay_products WHERE pagename = 'thes-verts'
12	0.0005	0.00053596496582031	SELECT id FROM custom_products WHERE pagename = 'thes-verts'
13	0.0005	0.00053501129150391	SELECT id FROM categories WHERE pagename = 'thes-verts' LIMIT 1
14	0.0015	0.0014500617980957	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
15	0.0009	0.0009458065032959	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND language = 'fr'
16	0.0008	0.00079703330993652	SELECT * FROM pages WHERE pagename = 'thes-verts'
17	0.0003	0.00032997131347656	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
18	0.0004	0.00042510032653809	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-smoothstore' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
19	0.0003	0.00025296211242676	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
20	0.0002	0.0002281665802002	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
21	0.0006	0.00059103965759277	SELECT value FROM template_options WHERE templateuid = 'fsb-smoothstore' AND optionuid = 'DISPLAY_CREDIT_ICON'
22	0.0006	0.00055599212646484	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
23	0.0002	0.0002448558807373	SELECT * FROM ipgeocountries WHERE INET_ATON('18.205.192.201') >= INET_ATON(ip_start) AND INET_ATON('18.205.192.201') <= INET_ATON(ip_end)
24	0.0002	0.0002138614654541	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
25	0.0002	0.00020503997802734	SELECT * FROM countryredirects WHERE countrycode = 'US'
26	0.0004	0.00044012069702148	SELECT * FROM categories WHERE pagename = 'thes-verts'
27	0.0028	0.0027689933776855	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
28	0.0004	0.00044989585876465	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
29	0.0002	0.00021004676818848	SELECT id FROM categories WHERE parent_id = '28'
30	0.0019	0.0018551349639893	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
31	0.0003	0.00034284591674805	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
32	0.0003	0.00026297569274902	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
33	0.0002	0.00019216537475586	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
34	0.0002	0.00018692016601562	SELECT id FROM categories WHERE parent_id = '28'
35	0.0019	0.0019450187683105	SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
36	0.0003	0.00030803680419922	SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
37	0.0003	0.00034403800964355	SELECT * FROM categoryimages WHERE category_id = 28
38	0.0002	0.00023198127746582	SELECT * FROM categorygroups WHERE id = '1'
39	0.0015	0.0015459060668945	SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id = '28' AND p.offers > 0 AND p.hidden = 0 AND p.enabled = 1 AND p.parent = 0 AND p.price > 0
40	0.0002	0.00020098686218262	SELECT parent_id FROM categories WHERE id = '28'
41	0.0002	0.00018095970153809	SELECT parent_id FROM categories WHERE id = '28'
42	0.0002	0.00018596649169922	SELECT * FROM categorygroups ORDER BY sortorder ASC
43	0.0002	0.00023698806762695	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
44	0.0002	0.00017213821411133	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
45	0.0002	0.00019407272338867	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
46	0.0002	0.00017809867858887	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
47	0.0002	0.00017690658569336	SELECT id FROM categories WHERE parent_id = '26'
48	0.0002	0.00016093254089355	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
49	0.0002	0.00016903877258301	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
50	0.0002	0.00016188621520996	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
51	0.0002	0.00016903877258301	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
52	0.0002	0.00017094612121582	SELECT * FROM categorygroups WHERE id = '1'
53	0.0042	0.0041601657867432	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
54	0.0002	0.00019598007202148	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
55	0.0002	0.00018596649169922	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
56	0.0002	0.00016403198242188	SELECT id FROM categories WHERE parent_id = '27'
57	0.0037	0.0037381649017334	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
58	0.0002	0.00018811225891113	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
59	0.0002	0.00017786026000977	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
60	0.0002	0.00018501281738281	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
61	0.0002	0.00016903877258301	SELECT * FROM categorygroups WHERE id = '1'
62	0.0002	0.00017714500427246	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
63	0.0002	0.00018095970153809	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
64	0.0002	0.00017285346984863	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
65	0.0002	0.00015115737915039	SELECT id FROM categories WHERE parent_id = '28'
66	0.0002	0.0001521110534668	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
67	0.0002	0.0001528263092041	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
68	0.0002	0.00017189979553223	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
69	0.0002	0.00015497207641602	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
70	0.0002	0.00017499923706055	SELECT * FROM categorygroups WHERE id = '1'
71	0.0004	0.00037097930908203	SELECT * FROM categories WHERE parent_id = '28' AND hidden = 0 ORDER BY sortorder ASC
72	0.0004	0.00041913986206055	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
73	0.0002	0.00020003318786621	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
74	0.0002	0.00015878677368164	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
75	0.0002	0.00016117095947266	SELECT id FROM categories WHERE parent_id = '29'
76	0.0004	0.00041413307189941	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
77	0.0002	0.0001671314239502	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
78	0.0002	0.00018095970153809	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
79	0.0002	0.00015997886657715	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
80	0.0002	0.00018501281738281	SELECT * FROM categorygroups WHERE id = '1'
81	0.0004	0.00039887428283691	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
82	0.0002	0.00017189979553223	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
83	0.0002	0.00016021728515625	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
84	0.0002	0.0001680850982666	SELECT id FROM categories WHERE parent_id = '30'
85	0.0005	0.00046300888061523	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
86	0.0002	0.00019693374633789	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
87	0.0002	0.00016403198242188	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
88	0.0002	0.00017690658569336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
89	0.0002	0.00016403198242188	SELECT * FROM categorygroups WHERE id = '1'
90	0.0005	0.00047206878662109	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
91	0.0002	0.00017809867858887	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
92	0.0002	0.00017786026000977	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
93	0.0002	0.00015807151794434	SELECT id FROM categories WHERE parent_id = '31'
94	0.0004	0.00044894218444824	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
95	0.0003	0.00027298927307129	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
96	0.0002	0.0001988410949707	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
97	0.0002	0.00018787384033203	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
98	0.0002	0.00017499923706055	SELECT * FROM categorygroups WHERE id = '1'
99	0.0002	0.00024795532226562	SELECT * FROM categoryimages WHERE category_id = 28
100	0.0003	0.00029516220092773	SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
101	0.0003	0.00030207633972168	SELECT * FROM categories WHERE parent_id = '28'
102	0.0065	0.0065150260925293	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
103	0.0003	0.00033712387084961	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
104	0.0002	0.00020909309387207	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
105	0.0002	0.00017595291137695	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
106	0.0002	0.00020289421081543	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
107	0.0002	0.0002129077911377	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
108	0.0019	0.00187087059021	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND parent_id = 0 AND c.category_id = 28 AND (c.prod_type = '' OR c.prod_type = 'amz') AND hidden = 0 AND enabled = 1 AND 1 = 1
109	0.0004	0.0003821849822998	SELECT COUNT(DISTINCT(ep.id)) FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id = 28 AND c.prod_type = 'ebay' AND hide = 0
110	0.0006	0.00060510635375977	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND parent_id = 0 AND c.category_id = 28 AND p.disabled = 0 AND 1 = 1
111	0.0003	0.00030303001403809	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id = 28 AND c.prod_type = 'custom' AND hide = 0
112	0.0030	0.0030078887939453	SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'product' AS type FROM products p, products_categories c WHERE p.id = c.product_id AND p.parent_id = 0 AND c.category_id = 28 AND hidden = 0 AND enabled = 1 AND 1 = 1 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'ebay' AS type FROM ebay_products p, products_categories c WHERE p.id = c.product_id AND c.category_id = 28 AND c.prod_type = 'ebay' AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'custom' AS type FROM custom_products p, products_categories c WHERE p.id = c.product_id AND c.category_id = 28 AND c.prod_type = 'custom' AND p.hide = 0 UNION SELECT DISTINCT (p.id), IF(p.salesrank <> 0, p.salesrank, 100000) AS salesrank, p.price, p.linktitle, p.pagename, 'bundle' AS type FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id = 28 AND disabled = 0 AND 1 = 1 ORDER BY salesrank ASC LIMIT 0, 18
113	0.0004	0.00043988227844238	SELECT * FROM products WHERE id = '2029'
114	0.0004	0.0004420280456543	SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
115	0.0008	0.00080704689025879	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
116	0.0002	0.00023388862609863	SELECT * FROM product_image_select WHERE product_id = '2029'
117	0.0002	0.00021886825561523	SELECT * FROM productcustomimages WHERE product_id = '2029'
118	0.0005	0.0004889965057373	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 = '2029' GROUP BY o.product_id
119	0.0008	0.00080490112304688	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 = '2029' GROUP BY n.displayname ORDER BY n.displayname DESC
120	0.0003	0.00034284591674805	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
121	0.0003	0.0003058910369873	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
122	0.0002	0.00023698806762695	SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0002	0.00020289421081543	SELECT * FROM productoffers WHERE product_id = '2029' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0002	0.00021004676818848	SELECT * FROM productoffers WHERE product_id = 2029 ORDER BY price ASC LIMIT 1
125	0.0002	0.00019121170043945	SELECT value FROM productattributes WHERE product_id = '2029' AND name = 'ListPriceAmount'
126	0.0002	0.00017809867858887	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 = '2029' GROUP BY o.product_id
127	0.0002	0.00021505355834961	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 = '2029' GROUP BY n.displayname ORDER BY n.displayname DESC
128	0.0002	0.00017309188842773	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
129	0.0002	0.00015592575073242	SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130	0.0005	0.00048518180847168	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2029' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
131	0.0003	0.00029611587524414	SELECT * FROM products WHERE id = '1287'
132	0.0004	0.00041890144348145	SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
133	0.0003	0.00028204917907715	SELECT * FROM product_image_select WHERE product_id = '1287'
134	0.0002	0.00020599365234375	SELECT * FROM productcustomimages WHERE product_id = '1287'
135	0.0002	0.00020217895507812	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
136	0.0002	0.00020980834960938	SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
137	0.0002	0.00022602081298828	SELECT * FROM productoffers WHERE product_id = '1287' AND price > 0 ORDER BY price ASC LIMIT 1
138	0.0003	0.00033211708068848	SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139	0.0005	0.00049400329589844	SELECT * FROM products WHERE id = '1160'
140	0.0014	0.0014481544494629	SELECT * FROM productimages WHERE product_id = '1160' ORDER BY sortorder ASC
141	0.0004	0.00044107437133789	SELECT * FROM product_image_select WHERE product_id = '1160'
142	0.0004	0.00038599967956543	SELECT * FROM productcustomimages WHERE product_id = '1160'
143	0.0009	0.00093698501586914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1160' AND a.name = n.originalname
144	0.0004	0.00037097930908203	SELECT * FROM productoffers WHERE product_id = '1160' AND merchantid = 'A1X6FK5RDHNB96'
145	0.0005	0.00047707557678223	SELECT * FROM productoffers WHERE product_id = '1160' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0004	0.0003809928894043	SELECT value FROM productattributes WHERE product_id = '1160' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0004	0.00039196014404297	SELECT * FROM products WHERE id = '1217'
148	0.0004	0.00042200088500977	SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
149	0.0002	0.0001828670501709	SELECT * FROM product_image_select WHERE product_id = '1217'
150	0.0002	0.00018787384033203	SELECT * FROM productcustomimages WHERE product_id = '1217'
151	0.0002	0.00021004676818848	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
152	0.0003	0.00029492378234863	SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0004	0.0003960132598877	SELECT * FROM productoffers WHERE product_id = '1217' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0002	0.00018405914306641	SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155	0.0004	0.00041699409484863	SELECT * FROM products WHERE id = '1110'
156	0.0008	0.0008399486541748	SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
157	0.0003	0.00030517578125	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1110' AND p.id = pi.product_id ORDER BY pi.sortorder
158	0.0003	0.00025582313537598	SELECT * FROM product_image_select WHERE product_id = '1110'
159	0.0002	0.00023007392883301	SELECT * FROM productcustomimages WHERE product_id = '1110'
160	0.0003	0.00033998489379883	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 = '1110' GROUP BY o.product_id
161	0.0004	0.00037598609924316	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 = '1110' GROUP BY n.displayname ORDER BY n.displayname DESC
162	0.0005	0.00045084953308105	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1110
163	0.0007	0.00068998336791992	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
164	0.0003	0.00030899047851562	SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
165	0.0004	0.00040602684020996	SELECT * FROM productoffers WHERE product_id = '1110' AND price > 0 ORDER BY price ASC LIMIT 1
166	0.0004	0.00037717819213867	SELECT * FROM productoffers WHERE product_id = 1110 ORDER BY price ASC LIMIT 1
167	0.0003	0.00033903121948242	SELECT value FROM productattributes WHERE product_id = '1110' AND name = 'ListPriceAmount'
168	0.0002	0.00019001960754395	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 = '1110' GROUP BY o.product_id
169	0.0002	0.00019001960754395	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 = '1110' GROUP BY n.displayname ORDER BY n.displayname DESC
170	0.0002	0.0001680850982666	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1110
171	0.0004	0.0003511905670166	SELECT * FROM products WHERE parent_id = '1110'
172	0.0005	0.00051403045654297	SELECT * FROM products WHERE id = '4906'
173	0.0004	0.00043201446533203	SELECT * FROM productimages WHERE product_id = '4906' ORDER BY sortorder ASC
174	0.0002	0.00022506713867188	SELECT * FROM product_image_select WHERE product_id = '4906'
175	0.0002	0.00018501281738281	SELECT * FROM productcustomimages WHERE product_id = '4906'
176	0.0002	0.00021886825561523	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4906' AND a.name = n.originalname
177	0.0002	0.00019001960754395	SELECT * FROM productoffers WHERE product_id = '4906' AND merchantid = 'A1X6FK5RDHNB96'
178	0.0002	0.00019693374633789	SELECT * FROM productoffers WHERE product_id = '4906' AND price > 0 ORDER BY price ASC LIMIT 1
179	0.0003	0.0003349781036377	SELECT value FROM productattributes WHERE product_id = '4906' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180	0.0004	0.00040602684020996	SELECT * FROM products WHERE id = '868'
181	0.0004	0.00040078163146973	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
182	0.0002	0.00018000602722168	SELECT * FROM product_image_select WHERE product_id = '868'
183	0.0002	0.00018215179443359	SELECT * FROM productcustomimages WHERE product_id = '868'
184	0.0002	0.00018692016601562	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
185	0.0002	0.00018906593322754	SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
186	0.0002	0.00023102760314941	SELECT * FROM productoffers WHERE product_id = '868' AND price > 0 ORDER BY price ASC LIMIT 1
187	0.0003	0.00032496452331543	SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188	0.0004	0.00043892860412598	SELECT * FROM products WHERE id = '4904'
189	0.0013	0.001276969909668	SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
190	0.0004	0.00037908554077148	SELECT * FROM product_image_select WHERE product_id = '4904'
191	0.0003	0.00026202201843262	SELECT * FROM productcustomimages WHERE product_id = '4904'
192	0.0011	0.0010569095611572	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
193	0.0004	0.00040507316589355	SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
194	0.0005	0.00046801567077637	SELECT * FROM productoffers WHERE product_id = '4904' AND price > 0 ORDER BY price ASC LIMIT 1
195	0.0004	0.00043702125549316	SELECT * FROM productoffers WHERE product_id = 4904 ORDER BY price ASC LIMIT 1
196	0.0004	0.00040888786315918	SELECT value FROM productattributes WHERE product_id = '4904' AND name = 'ListPriceAmount'
197	0.0005	0.00049400329589844	SELECT * FROM products WHERE id = '1201'
198	0.0013	0.0012779235839844	SELECT * FROM productimages WHERE product_id = '1201' ORDER BY sortorder ASC
199	0.0004	0.00038790702819824	SELECT * FROM product_image_select WHERE product_id = '1201'
200	0.0003	0.00025296211242676	SELECT * FROM productcustomimages WHERE product_id = '1201'
201	0.0009	0.00086402893066406	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1201' AND a.name = n.originalname
202	0.0004	0.00041294097900391	SELECT * FROM productoffers WHERE product_id = '1201' AND merchantid = 'A1X6FK5RDHNB96'
203	0.0004	0.00042200088500977	SELECT * FROM productoffers WHERE product_id = '1201' AND price > 0 ORDER BY price ASC LIMIT 1
204	0.0003	0.00033807754516602	SELECT * FROM productoffers WHERE product_id = 1201 ORDER BY price ASC LIMIT 1
205	0.0005	0.00047397613525391	SELECT value FROM productattributes WHERE product_id = '1201' AND name = 'ListPriceAmount'
206	0.0006	0.00059700012207031	SELECT * FROM products WHERE id = '4909'
207	0.0012	0.0011940002441406	SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
208	0.0003	0.00028705596923828	SELECT * FROM product_image_select WHERE product_id = '4909'
209	0.0003	0.0002589225769043	SELECT * FROM productcustomimages WHERE product_id = '4909'
210	0.0009	0.00089406967163086	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
211	0.0003	0.00033998489379883	SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
212	0.0003	0.0003349781036377	SELECT * FROM productoffers WHERE product_id = '4909' AND price > 0 ORDER BY price ASC LIMIT 1
213	0.0004	0.00040292739868164	SELECT * FROM productoffers WHERE product_id = 4909 ORDER BY price ASC LIMIT 1
214	0.0004	0.00039315223693848	SELECT value FROM productattributes WHERE product_id = '4909' AND name = 'ListPriceAmount'
215	0.0007	0.00069093704223633	SELECT * FROM products WHERE id = '1237'
216	0.0002	0.00018906593322754	SELECT * FROM productimages WHERE product_id = '1237' ORDER BY sortorder ASC
217	0.0002	0.00020194053649902	SELECT * FROM product_image_select WHERE product_id = '1237'
218	0.0002	0.00017690658569336	SELECT * FROM productcustomimages WHERE product_id = '1237'
219	0.0002	0.0001990795135498	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1237' AND a.name = n.originalname
220	0.0002	0.00019502639770508	SELECT * FROM productoffers WHERE product_id = '1237' AND merchantid = 'A1X6FK5RDHNB96'
221	0.0003	0.00026988983154297	SELECT * FROM productoffers WHERE product_id = '1237' AND price > 0 ORDER BY price ASC LIMIT 1
222	0.0002	0.00023102760314941	SELECT value FROM productattributes WHERE product_id = '1237' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223	0.0004	0.00040698051452637	SELECT * FROM products WHERE id = '3925'
224	0.0014	0.001384973526001	SELECT * FROM productimages WHERE product_id = '3925' ORDER BY sortorder ASC
225	0.0008	0.00081491470336914	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3925' AND p.id = pi.product_id ORDER BY pi.sortorder
226	0.0003	0.00034189224243164	SELECT * FROM product_image_select WHERE product_id = '3925'
227	0.0004	0.0003809928894043	SELECT * FROM productcustomimages WHERE product_id = '3925'
228	0.0005	0.00046205520629883	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 = '3925' GROUP BY o.product_id
229	0.0006	0.00062990188598633	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 = '3925' GROUP BY n.displayname ORDER BY n.displayname DESC
230	0.0005	0.00050806999206543	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3925
231	0.0021	0.0021431446075439	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3925' AND a.name = n.originalname
232	0.0004	0.0003960132598877	SELECT * FROM productoffers WHERE product_id = '3925' AND merchantid = 'A1X6FK5RDHNB96'
233	0.0005	0.00049400329589844	SELECT * FROM productoffers WHERE product_id = '3925' AND price > 0 ORDER BY price ASC LIMIT 1
234	0.0005	0.00053191184997559	SELECT * FROM productoffers WHERE product_id = 3925 ORDER BY price ASC LIMIT 1
235	0.0005	0.00049209594726562	SELECT value FROM productattributes WHERE product_id = '3925' AND name = 'ListPriceAmount'
236	0.0003	0.00030088424682617	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 = '3925' GROUP BY o.product_id
237	0.0002	0.0001990795135498	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 = '3925' GROUP BY n.displayname ORDER BY n.displayname DESC
238	0.0002	0.00020289421081543	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3925
239	0.0004	0.00039315223693848	SELECT value FROM productattributes WHERE product_id = '3925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240	0.0009	0.00086808204650879	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3925' AND p.id = o.product_id AND o.name = 'PackageQuantity' GROUP BY o.value ORDER BY o.value ASC
241	0.0004	0.0004279613494873	SELECT * FROM products WHERE parent_id = '3925'
242	0.0018	0.0017712116241455	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3926' AND a.name = n.originalname
243	0.0003	0.00033283233642578	SELECT * FROM productoffers WHERE product_id = '3926' AND merchantid = 'A1X6FK5RDHNB96'
244	0.0004	0.00040817260742188	SELECT * FROM productoffers WHERE product_id = '3926' AND price > 0 ORDER BY price ASC LIMIT 1
245	0.0003	0.00032687187194824	SELECT * FROM productoffers WHERE product_id = 3926 ORDER BY price ASC LIMIT 1
246	0.0003	0.00033998489379883	SELECT value FROM productattributes WHERE product_id = '3926' AND name = 'ListPriceAmount'
247	0.0006	0.00056099891662598	SELECT * FROM products WHERE id = '970'
248	0.0014	0.001431941986084	SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
249	0.0004	0.0003809928894043	SELECT * FROM product_image_select WHERE product_id = '970'
250	0.0003	0.00031208992004395	SELECT * FROM productcustomimages WHERE product_id = '970'
251	0.0008	0.00075292587280273	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
252	0.0003	0.00031185150146484	SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
253	0.0004	0.00037503242492676	SELECT * FROM productoffers WHERE product_id = '970' AND price > 0 ORDER BY price ASC LIMIT 1
254	0.0004	0.00042104721069336	SELECT * FROM productoffers WHERE product_id = 970 ORDER BY price ASC LIMIT 1
255	0.0004	0.00037598609924316	SELECT value FROM productattributes WHERE product_id = '970' AND name = 'ListPriceAmount'
256	0.0004	0.00043487548828125	SELECT * FROM products WHERE id = '1152'
257	0.0012	0.0011560916900635	SELECT * FROM productimages WHERE product_id = '1152' ORDER BY sortorder ASC
258	0.0003	0.00026798248291016	SELECT * FROM product_image_select WHERE product_id = '1152'
259	0.0003	0.00025510787963867	SELECT * FROM productcustomimages WHERE product_id = '1152'
260	0.0008	0.00077700614929199	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1152' AND a.name = n.originalname
261	0.0003	0.00033092498779297	SELECT * FROM productoffers WHERE product_id = '1152' AND merchantid = 'A1X6FK5RDHNB96'
262	0.0004	0.00040388107299805	SELECT * FROM productoffers WHERE product_id = '1152' AND price > 0 ORDER BY price ASC LIMIT 1
263	0.0004	0.00037384033203125	SELECT value FROM productattributes WHERE product_id = '1152' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264	0.0004	0.00041103363037109	SELECT * FROM products WHERE id = '1145'
265	0.0011	0.0011169910430908	SELECT * FROM productimages WHERE product_id = '1145' ORDER BY sortorder ASC
266	0.0004	0.00037908554077148	SELECT * FROM product_image_select WHERE product_id = '1145'
267	0.0003	0.0002589225769043	SELECT * FROM productcustomimages WHERE product_id = '1145'
268	0.0009	0.00089597702026367	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1145' AND a.name = n.originalname
269	0.0004	0.00035500526428223	SELECT * FROM productoffers WHERE product_id = '1145' AND merchantid = 'A1X6FK5RDHNB96'
270	0.0005	0.00046205520629883	SELECT * FROM productoffers WHERE product_id = '1145' AND price > 0 ORDER BY price ASC LIMIT 1
271	0.0004	0.00043296813964844	SELECT * FROM productoffers WHERE product_id = 1145 ORDER BY price ASC LIMIT 1
272	0.0003	0.00031709671020508	SELECT value FROM productattributes WHERE product_id = '1145' AND name = 'ListPriceAmount'
273	0.0006	0.00061511993408203	SELECT * FROM products WHERE id = '4905'
274	0.0010	0.0010249614715576	SELECT * FROM productimages WHERE product_id = '4905' ORDER BY sortorder ASC
275	0.0003	0.00027894973754883	SELECT * FROM product_image_select WHERE product_id = '4905'
276	0.0002	0.00024890899658203	SELECT * FROM productcustomimages WHERE product_id = '4905'
277	0.0009	0.00087904930114746	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4905' AND a.name = n.originalname
278	0.0004	0.00042605400085449	SELECT * FROM productoffers WHERE product_id = '4905' AND merchantid = 'A1X6FK5RDHNB96'
279	0.0004	0.00038480758666992	SELECT * FROM productoffers WHERE product_id = '4905' AND price > 0 ORDER BY price ASC LIMIT 1
280	0.0004	0.00043487548828125	SELECT value FROM productattributes WHERE product_id = '4905' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281	0.0005	0.00052285194396973	SELECT * FROM products WHERE id = '1090'
282	0.0013	0.0013298988342285	SELECT * FROM productimages WHERE product_id = '1090' ORDER BY sortorder ASC
283	0.0003	0.00033187866210938	SELECT * FROM product_image_select WHERE product_id = '1090'
284	0.0003	0.0002598762512207	SELECT * FROM productcustomimages WHERE product_id = '1090'
285	0.0008	0.00077009201049805	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1090' AND a.name = n.originalname
286	0.0004	0.0003669261932373	SELECT * FROM productoffers WHERE product_id = '1090' AND merchantid = 'A1X6FK5RDHNB96'
287	0.0003	0.00033712387084961	SELECT * FROM productoffers WHERE product_id = '1090' AND price > 0 ORDER BY price ASC LIMIT 1
288	0.0003	0.00031018257141113	SELECT * FROM productoffers WHERE product_id = 1090 ORDER BY price ASC LIMIT 1
289	0.0004	0.00043082237243652	SELECT value FROM productattributes WHERE product_id = '1090' AND name = 'ListPriceAmount'
290	0.0004	0.00038695335388184	SELECT value FROM productattributes WHERE product_id = '1090' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291	0.0004	0.00040292739868164	SELECT * FROM products WHERE id = '853'
292	0.0014	0.0014481544494629	SELECT * FROM productimages WHERE product_id = '853' ORDER BY sortorder ASC
293	0.0003	0.00032401084899902	SELECT * FROM product_image_select WHERE product_id = '853'
294	0.0003	0.00030303001403809	SELECT * FROM productcustomimages WHERE product_id = '853'
295	0.0007	0.00069308280944824	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '853' AND a.name = n.originalname
296	0.0004	0.00036406517028809	SELECT * FROM productoffers WHERE product_id = '853' AND merchantid = 'A1X6FK5RDHNB96'
297	0.0004	0.00035810470581055	SELECT * FROM productoffers WHERE product_id = '853' AND price > 0 ORDER BY price ASC LIMIT 1
298	0.0004	0.00040507316589355	SELECT * FROM productoffers WHERE product_id = 853 ORDER BY price ASC LIMIT 1
299	0.0004	0.00036501884460449	SELECT value FROM productattributes WHERE product_id = '853' AND name = 'ListPriceAmount'
300	0.0005	0.00051093101501465	SELECT value FROM productattributes WHERE product_id = '853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301	0.0006	0.00060415267944336	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
302	0.0003	0.00031709671020508	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1287' ORDER BY timestamp DESC
303	0.0003	0.0003058910369873	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1160' ORDER BY timestamp DESC
304	0.0003	0.00025701522827148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1217' ORDER BY timestamp DESC
305	0.0002	0.00024199485778809	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
306	0.0003	0.00028300285339355	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4906' ORDER BY timestamp DESC
307	0.0003	0.00027108192443848	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
308	0.0004	0.00037717819213867	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4904' ORDER BY timestamp DESC
309	0.0003	0.00027894973754883	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1201' ORDER BY timestamp DESC
310	0.0004	0.00038290023803711	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4909' ORDER BY timestamp DESC
311	0.0004	0.00042605400085449	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1237' ORDER BY timestamp DESC
312	0.0003	0.00032615661621094	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3925' ORDER BY timestamp DESC
313	0.0003	0.00030398368835449	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '970' ORDER BY timestamp DESC
314	0.0003	0.00032901763916016	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1152' ORDER BY timestamp DESC
315	0.0003	0.0003049373626709	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1145' ORDER BY timestamp DESC
316	0.0003	0.00027108192443848	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4905' ORDER BY timestamp DESC
317	0.0003	0.0002751350402832	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1090' ORDER BY timestamp DESC
318	0.0003	0.00025796890258789	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '853' ORDER BY timestamp DESC
319	0.0003	0.0003349781036377	SELECT linktitle,pagename,ep.id,price,buylink,image FROM ebay_products ep, products_categories c WHERE ep.id = c.product_id AND c.category_id = 28 AND c.prod_type = 'ebay' AND hide = 0
320	0.0002	0.00018906593322754	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
321	0.0003	0.00030899047851562	SELECT * FROM template_info WHERE templateuid = 'fsb-smoothstore'
322	0.0003	0.00025200843811035	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
323	0.0002	0.00018000602722168	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
324	0.0003	0.00026488304138184	SELECT * FROM pages WHERE id = 38
325	0.0002	0.00018811225891113	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
326	0.0004	0.00036501884460449	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:1628124736;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'
327	0.0003	0.00029206275939941	SELECT * FROM products WHERE id = 790
328	0.0004	0.00040197372436523	SELECT * FROM products WHERE id = 788
329	0.0004	0.00042581558227539	SELECT * FROM products WHERE id = 787
330	0.0005	0.00046801567077637	SELECT * FROM products WHERE id = 1287
331	0.0004	0.0004119873046875	SELECT * FROM products WHERE id = 777
332	0.0004	0.00041699409484863	SELECT * FROM products WHERE id = 776
333	0.0004	0.00041985511779785	SELECT * FROM products WHERE id = '790'
334	0.0004	0.0004279613494873	SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
335	0.0002	0.00022292137145996	SELECT * FROM product_image_select WHERE product_id = '790'
336	0.0002	0.00024294853210449	SELECT * FROM productcustomimages WHERE product_id = '790'
337	0.0002	0.00022292137145996	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
338	0.0002	0.00021004676818848	SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
339	0.0003	0.00027084350585938	SELECT * FROM productoffers WHERE product_id = '790' AND price > 0 ORDER BY price ASC LIMIT 1
340	0.0003	0.00030684471130371	SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341	0.0003	0.00028610229492188	SELECT * FROM products WHERE id = '788'
342	0.0003	0.0002589225769043	SELECT * FROM productimages WHERE product_id = '788' ORDER BY sortorder ASC
343	0.0003	0.00025486946105957	SELECT * FROM product_image_select WHERE product_id = '788'
344	0.0002	0.0002138614654541	SELECT * FROM productcustomimages WHERE product_id = '788'
345	0.0002	0.00022387504577637	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '788' AND a.name = n.originalname
346	0.0002	0.00024509429931641	SELECT * FROM productoffers WHERE product_id = '788' AND merchantid = 'A1X6FK5RDHNB96'
347	0.0003	0.00025415420532227	SELECT * FROM productoffers WHERE product_id = '788' AND price > 0 ORDER BY price ASC LIMIT 1
348	0.0002	0.00023007392883301	SELECT value FROM productattributes WHERE product_id = '788' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349	0.0003	0.0003049373626709	SELECT * FROM products WHERE id = '787'
350	0.0002	0.00023484230041504	SELECT * FROM productimages WHERE product_id = '787' ORDER BY sortorder ASC
351	0.0002	0.00020623207092285	SELECT * FROM product_image_select WHERE product_id = '787'
352	0.0002	0.00020408630371094	SELECT * FROM productcustomimages WHERE product_id = '787'
353	0.0002	0.00021886825561523	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '787' AND a.name = n.originalname
354	0.0003	0.00025796890258789	SELECT * FROM productoffers WHERE product_id = '787' AND merchantid = 'A1X6FK5RDHNB96'
355	0.0002	0.00022697448730469	SELECT * FROM productoffers WHERE product_id = '787' AND price > 0 ORDER BY price ASC LIMIT 1
356	0.0002	0.00020599365234375	SELECT value FROM productattributes WHERE product_id = '787' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357	0.0003	0.00029802322387695	SELECT * FROM products WHERE id = '1287'
358	0.0004	0.00041007995605469	SELECT * FROM productimages WHERE product_id = '1287' ORDER BY sortorder ASC
359	0.0002	0.00023412704467773	SELECT * FROM product_image_select WHERE product_id = '1287'
360	0.0002	0.00019621849060059	SELECT * FROM productcustomimages WHERE product_id = '1287'
361	0.0003	0.0002748966217041	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1287' AND a.name = n.originalname
362	0.0002	0.00020599365234375	SELECT * FROM productoffers WHERE product_id = '1287' AND merchantid = 'A1X6FK5RDHNB96'
363	0.0002	0.00022792816162109	SELECT * FROM productoffers WHERE product_id = '1287' AND price > 0 ORDER BY price ASC LIMIT 1
364	0.0003	0.0003349781036377	SELECT value FROM productattributes WHERE product_id = '1287' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365	0.0003	0.00030612945556641	SELECT * FROM products WHERE id = '777'
366	0.0002	0.00021696090698242	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
367	0.0002	0.00020599365234375	SELECT * FROM product_image_select WHERE product_id = '777'
368	0.0002	0.00022292137145996	SELECT * FROM productcustomimages WHERE product_id = '777'
369	0.0002	0.00023794174194336	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
370	0.0003	0.0002901554107666	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
371	0.0002	0.00021815299987793	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
372	0.0003	0.00031208992004395	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373	0.0003	0.0002739429473877	SELECT * FROM products WHERE id = '776'
374	0.0004	0.00038814544677734	SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
375	0.0002	0.00020790100097656	SELECT * FROM product_image_select WHERE product_id = '776'
376	0.0002	0.00018596649169922	SELECT * FROM productcustomimages WHERE product_id = '776'
377	0.0002	0.00020003318786621	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
378	0.0002	0.00021100044250488	SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
379	0.0002	0.00020909309387207	SELECT * FROM productoffers WHERE product_id = '776' AND price > 0 ORDER BY price ASC LIMIT 1
380	0.0002	0.00022006034851074	SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
381	0.0003	0.00027298927307129	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'header' ORDER BY sortorder ASC
382	0.0005	0.00054502487182617	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND area = 'footer' ORDER BY sortorder ASC
383	0.0009	0.00086188316345215	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND skinuid = ''
384	0.0004	0.00043201446533203	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
385	0.0004	0.00043511390686035	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-smoothstore'
386	0.0006	0.00060892105102539	SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'ICON_RSS_FEED'
387	0.0006	0.00058317184448242	SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
388	0.0005	0.00045204162597656	SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
389	0.0005	0.00048017501831055	SELECT * FROM template_images WHERE templateuid = 'fsb-smoothstore' AND imageuid = 'HEAD_LOGO'
390	0.0004	0.0003809928894043	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-smoothstore' AND textuid = 'SIDEBAR_BASKET_TITLE' AND language = 'en'

Thés verts

Matcha Premium 200 gr

Thé Matcha de Cuisine Bio Japonais 50 g | Thé Vert...

Thé vert au Jasmin Bio 200g

Thé vert DETOX BIO 200g - avec menthe, maté, pisse...

Thé vert nature Sencha Bio 200 gr

Thé vert Sencha organique (1000g) - Haut Style Jap...

Kumiko Matcha - thé matcha premium bio du Japon - ...

VAHDAM, Thé Vert Matcha| Poudre de thé matcha | 10...

Kusmi Tea - Assortiment Miniatures – Les Verts

Quertee® - Thé vert – Thé au jasmin de Chine riche...

Florisens thé vert sencha bio - Sachet de 85 g

Jardin Bio Thé Vert Detox 30 g parent

Thé vert Menthe poivrée BIO 200g

Thé vert à la menthe Touareg - Dammann frères

Thé vert sencha et riz grillé - Genmaicha - 100g

Comptoirs Richard Thé Vert Jasmin Boîte Métal Vrac...

thé matcha de cuisine bio du Japon - 100g - idéal ...

Lipton Thé Vert Menthe Intense

Votre panier

Filtres Produits (plus)

Par Catégories

Debug Overview

No Amazon API Requests Made.

Total time 1.1571118831635 seconds

Query Debug - 390 Database Queries. Total time 0.1750 seconds