KUNSE Tea Bag Stores Boîte À Thé en Bois 3 Compartments Hinged Verre Lid Tea Organizer Jewelery Box Stockage

Price: €23,79

As of 2022-06-26 15:25:46 UTC (more info)

Product prices and availability are accurate as of 2022-06-26 15:25:46 UTC and are subject to change. Any price and availability information displayed on https://www.amazon.fr/ at the time of purchase will apply to the purchase of this product.

Availability: In Stock

Click and Choose Options

Buy Now from Amazon

Product Information (more info)

See All Customer Reviews
View Product Details

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED 'AS IS' AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.

Product Features

Finition en bois lisse et couvercle en verre, beau et durable 3 Compartments pour le stockage de vos sachets de thé préférés, garde vos thés frais et savoureux pour plus longtemps Vous pouvez stocker quelque chose que vous avez besoin ou comme, comme le thé, bijoux, accessoires et ainsi de suite Convient également pour les affichages de magasin, boîtes de cadeau, stockage général Peut comme cadeaux pour vos amis ou votre famille qui sont des amateurs de thé

Customer Reviews

There are no customer reviews yet. Be the first to Write a Review!

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.6956939697266	341	1.0098	0

No Amazon API Requests Made.

App Debug - Total Time 1.6956939697266 seconds

Number	Time From Start	Name	Description
1	0.62160301208496	Initialise	Initialise FSB Function
2	0.63486814498901	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.67148900032043	Start of getCategoryListByGroup Function	Before first category groups query
4	0.67309093475342	After initial query	Before first category groups query
5	0.67309403419495	Get Category List for Group	Before the call to getCategoryList function
6	0.67309808731079	Start of GetCategoryList function	Start of the function
7	0.67310309410095	Before getting categories	Query to get specific category list
8	0.67476916313171	After getting categories	Query to get specific category list
9	0.67477107048035	Before getting category custom	Before call to function getCategoryCustom
10	0.71501302719116	After getting category custom	After call to function getCategoryCustom
11	0.71501803398132	Before getting category custom	Before call to function getCategoryCustom
12	0.72885298728943	After getting category custom	After call to function getCategoryCustom
13	0.72885799407959	Before getting category custom	Before call to function getCategoryCustom
14	0.73688006401062	After getting category custom	After call to function getCategoryCustom
15	0.73688411712646	Before getting category custom	Before call to function getCategoryCustom
16	0.74240612983704	After getting category custom	After call to function getCategoryCustom
17	0.7424111366272	Before getting category custom	Before call to function getCategoryCustom
18	0.74882006645203	After getting category custom	After call to function getCategoryCustom
19	0.74882316589355	Before getting category custom	Before call to function getCategoryCustom
20	0.75506615638733	After getting category custom	After call to function getCategoryCustom
21	0.75506997108459	End of GetCategoryList function	End of the function
22	0.75507712364197	Get Category List for Group	Before the call to getCategoryList function
23	0.75507998466492	Start of GetCategoryList function	Start of the function
24	0.75508308410645	Before getting categories	Query to get specific category list
25	0.75565409660339	End of getCategoryListByGroup Function	Before return()
26	1.2697319984436	App Controller End	End of the App controller (called before the controller of every page)
27	1.2704660892487	Product Start	Start of the product info controller
28	1.2962429523468	Cache file not found	Starting get product details
29	1.3719940185547	Related products	Start getting related products if enabled
30	1.3719971179962	Related Products Start	Before the related products are found
31	1.3719990253448	Related Products Keywords	Before the related product keywords are found
32	1.3720049858093	Create Keyword List Function	Start of function
33	1.3721790313721	Create Keyword List Function	After looping provided content - 53 keywords found
34	1.3752961158752	Create Keyword List Function	After looping initial keyword list - 46 keywords remaining
35	1.3753111362457	Create Keyword List Function	After reducing keyword list
36	1.3757519721985	Create Keyword List Function	After selecting by scoring keywords
37	1.3757591247559	Create Keyword List Function	After final loop of keywords
38	1.3757629394531	Related Products Keywords	After the related product keywords are found
39	1.4792590141296	Related Products End	After the related products are found
40	1.5332300662994	Product End	End of the product info controller (Product Info)
41	1.5372140407562	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
42	1.5405020713806	Before Get Options	Before the call to getOptions in the tpl class
43	1.6459839344025	After Get Options	After the call to getOptions in the tpl class
44	1.6463160514832	App_after Controller End	End of the App_after controller (called after the controller of every page)
45	1.6463651657104	Product Info: Before Smarty Fetch	Before the product.tpl template is fetched
46	1.667042016983	Product Info: After Smarty Fetch	After the product.tpl template is fetched
47	1.6670479774475	Product Info: Before Template Display	Before the template is displayed
48	1.6956470012665	Product Info: After Template Display	After the template is displayed
49	1.695671081543	Finalizing debug	Before the debug is output to the page.
50	1.6956930160522	End of App	This is the end of the app logging, final timestamp

Query Debug - 341 Database Queries. Total time 1.0098 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.175\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1737123201'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid' LIMIT 1
SELECT id FROM products WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid' AND hidden = 0 LIMIT 1
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.175') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.175') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM products WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid'
UPDATE products SET viewcount = viewcount + 1 WHERE id = 4232
SELECT * FROM manufacturers WHERE id = '617'
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '617'
SELECT filename FROM manufacturerimages WHERE manufacturer_id = '617' LIMIT 1
SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '617' ORDER BY RAND() LIMIT 1
SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '617'
SELECT COUNT(DISTINCT(p.id)) FROM products p
				WHERE p.manufacturer_id = '617'
				  AND p.hidden = 0
				  AND p.enabled = 1
				  AND p.parent_id = 0 
SELECT * FROM manufacturerimages WHERE manufacturer_id = '617'
SELECT category_id FROM products_categories WHERE product_id = '4232'
SELECT * FROM categories WHERE id = '26'
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(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 productimages WHERE product_id = '4232' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4232'
SELECT * FROM productcustomimages WHERE product_id = '4232'
SELECT * FROM productfeeds WHERE product_id = '4232' ORDER BY item_date DESC
SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4232' AND t.hidden = 0 AND display_product = 1
SELECT * FROM tags WHERE id = '58'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '58'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM tags WHERE id = '81'
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND p.enabled = 1
				  AND p.hidden = 0
SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t
				WHERE p.id = t.product_id
				  AND t.tag_id = '81'
				  AND p.parent_id = 0
				  AND hidden = 0
				  AND enabled = 1 
SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM productamazoncontent WHERE product_id = '4232'
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 = '4232'
                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     = '4232'
                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 = 4232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4232'
                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 = '4232'
                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     = '4232'
                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 = 4232
SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4232'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value 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 *, MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AND 4232 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4232'
SELECT * FROM productcustomimages WHERE product_id = '4232'
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 = '4232'
                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     = '4232'
                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 = 4232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4232'
                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 = '4232'
                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     = '4232'
                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 = 4232
SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4232'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT *, MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AND 4232 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT *, MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 6
SELECT * FROM productimages WHERE product_id = '4211' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4211' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4211'
SELECT * FROM productcustomimages WHERE product_id = '4211'
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 = '4211'
                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     = '4211'
                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 = 4211
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4211' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4211' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4211' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4211
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4211'
                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 = '4211'
                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     = '4211'
                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 = 4211
SELECT value FROM productattributes WHERE product_id = '4211' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4211'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4211'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4212' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4212' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4212' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '4609' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4609'
SELECT * FROM productcustomimages WHERE product_id = '4609'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4609' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4609' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4609' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4609' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4232'
SELECT * FROM productcustomimages WHERE product_id = '4232'
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 = '4232'
                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     = '4232'
                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 = 4232
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4232'
                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 = '4232'
                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     = '4232'
                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 = 4232
SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4232'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT *, MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AND 4232 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
SELECT *, MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
SELECT *, MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0  ORDER BY `searchrelevance` LIMIT 4
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 productimages WHERE product_id = '780' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '780'
SELECT * FROM productcustomimages WHERE product_id = '780'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
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 productimages WHERE product_id = '770' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '770'
SELECT * FROM productcustomimages WHERE product_id = '770'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT id,asin FROM products WHERE parent_id = 4232
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4233
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4233
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4234
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4234
SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4235
SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4235
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4232' ORDER BY timestamp DESC
SELECT category_id FROM products_categories WHERE product_id = '4232'
SELECT * FROM categories WHERE id = '26'
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(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 a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4232'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '4232'
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 = '4232'
                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     = '4232'
                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 = 4232
SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4232' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4232
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4232'
                AND name = 'ListPriceAmount'
SELECT DISTINCT (name) FROM productoptions
SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4232))
SELECT	o.value, o.name
			FROM	products			p,
					productoptions		o
			WHERE	p.parent_id		= 4232
			  AND	p.id			= o.product_id 
			GROUP BY o.value ORDER BY o.value ASC
SELECT * FROM translationsfilter
SELECT category_id FROM products_categories WHERE product_id = '4232' AND prod_type = 'amz'
SELECT parent_id FROM categories WHERE id = '26'
SELECT * FROM categories WHERE id = '26'
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(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 template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0028	0.0027551651000977	SELECT parameter, value FROM parameters
2	0.0093	0.0092980861663818	SELECT * FROM `bad_bots`
3	0.0007	0.00066590309143066	SET time_zone = 'Europe/London'
4	0.0036	0.0036330223083496	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0042	0.0041511058807373	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"18.97.9.175\";}'
6	0.0041	0.004101037979126	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1737123201'
7	0.0046	0.004612922668457	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0022	0.00217604637146	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0046	0.0046100616455078	SELECT id FROM pages WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid' LIMIT 1
10	0.0056	0.0055539608001709	SELECT id FROM products WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid' AND hidden = 0 LIMIT 1
11	0.0060	0.0059969425201416	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0292	0.029237031936646	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0007	0.00068902969360352	SELECT * FROM pages WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid'
14	0.0016	0.0015828609466553	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0016	0.0016410350799561	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0171	0.017091035842896	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17	0.0036	0.0035960674285889	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0024	0.0023930072784424	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0008	0.00081586837768555	SELECT id FROM categories WHERE parent_id = '26'
20	0.0097	0.0097310543060303	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0022	0.0022428035736084	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0020	0.0019800662994385	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0016	0.0016088485717773	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0006	0.00057005882263184	SELECT * FROM categorygroups WHERE id = '1'
25	0.0037	0.0037219524383545	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0006	0.00060606002807617	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.00042414665222168	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.0005180835723877	SELECT id FROM categories WHERE parent_id = '27'
29	0.0053	0.0053179264068604	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
30	0.0009	0.00094294548034668	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0007	0.00071215629577637	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0009	0.00087499618530273	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0006	0.00055789947509766	SELECT * FROM categorygroups WHERE id = '1'
34	0.0018	0.0018479824066162	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0007	0.00066304206848145	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0005	0.00046515464782715	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00049781799316406	SELECT id FROM categories WHERE parent_id = '28'
38	0.0017	0.0017380714416504	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0007	0.00071191787719727	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0009	0.00093698501586914	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0005	0.00052905082702637	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.00047707557678223	SELECT * FROM categorygroups WHERE id = '1'
43	0.0007	0.00067996978759766	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0005	0.00053215026855469	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0006	0.00063180923461914	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0006	0.00056791305541992	SELECT id FROM categories WHERE parent_id = '29'
47	0.0007	0.00072717666625977	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0006	0.00058507919311523	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0006	0.00061702728271484	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0005	0.00054407119750977	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0004	0.00044918060302734	SELECT * FROM categorygroups WHERE id = '1'
52	0.0008	0.00078082084655762	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53	0.0006	0.00061583518981934	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0004	0.00042915344238281	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00054597854614258	SELECT id FROM categories WHERE parent_id = '30'
56	0.0008	0.00075483322143555	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0005	0.00052285194396973	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0007	0.00065803527832031	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0008	0.00078415870666504	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0012	0.0011579990386963	SELECT * FROM categorygroups WHERE id = '1'
61	0.0009	0.00093412399291992	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0005	0.00052285194396973	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0004	0.00044107437133789	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0006	0.00059294700622559	SELECT id FROM categories WHERE parent_id = '31'
65	0.0012	0.0012171268463135	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0007	0.00070905685424805	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0006	0.00058197975158691	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0006	0.00057005882263184	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0005	0.00054788589477539	SELECT * FROM categorygroups WHERE id = '1'
70	0.0006	0.00055599212646484	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0028	0.0028359889984131	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0023	0.0022549629211426	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.00072288513183594	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74	0.0017	0.0016970634460449	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0020	0.0019741058349609	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0016	0.0015900135040283	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4968	0.4967930316925	SELECT * FROM ipgeocountries WHERE INET_ATON('18.97.9.175') >= INET_ATON(ip_start) AND INET_ATON('18.97.9.175') <= INET_ATON(ip_end)
78	0.0023	0.002338171005249	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0014	0.0013999938964844	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0007	0.00073599815368652	SELECT * FROM products WHERE pagename = 'kunse-tea-bag-stores-bote-the-en-bois-3-compartments-hinged-verre-lid'
81	0.0005	0.00052595138549805	UPDATE products SET viewcount = viewcount + 1 WHERE id = 4232
82	0.0009	0.00087404251098633	SELECT * FROM manufacturers WHERE id = '617'
83	0.0009	0.00088810920715332	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '617'
84	0.0027	0.0026700496673584	SELECT filename FROM manufacturerimages WHERE manufacturer_id = '617' LIMIT 1
85	0.0047	0.0047299861907959	SELECT p.pagename, p.id FROM products p, productimages i WHERE p.id = i.product_id AND manufacturer_id = '617' ORDER BY RAND() LIMIT 1
86	0.0012	0.0012011528015137	SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
87	0.0010	0.00098800659179688	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.parent_id = 0 AND p.manufacturer_id = '617'
88	0.0009	0.00093698501586914	SELECT COUNT(DISTINCT(p.id)) FROM products p WHERE p.manufacturer_id = '617' AND p.hidden = 0 AND p.enabled = 1 AND p.parent_id = 0
89	0.0008	0.00077199935913086	SELECT * FROM manufacturerimages WHERE manufacturer_id = '617'
90	0.0008	0.00079584121704102	SELECT category_id FROM products_categories WHERE product_id = '4232'
91	0.0008	0.00078892707824707	SELECT * FROM categories WHERE id = '26'
92	0.0099	0.0098910331726074	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
93	0.0005	0.00054287910461426	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
94	0.0004	0.00039815902709961	SELECT id FROM categories WHERE parent_id = '26'
95	0.0063	0.0062921047210693	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
96	0.0006	0.00059103965759277	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
97	0.0006	0.00064301490783691	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
98	0.0006	0.00055408477783203	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
99	0.0006	0.00061202049255371	SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
100	0.0008	0.00080394744873047	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
101	0.0023	0.0023200511932373	SELECT * FROM product_image_select WHERE product_id = '4232'
102	0.0019	0.001878023147583	SELECT * FROM productcustomimages WHERE product_id = '4232'
103	0.0017	0.0016779899597168	SELECT * FROM productfeeds WHERE product_id = '4232' ORDER BY item_date DESC
104	0.0025	0.0024740695953369	SELECT a.name, n.displayname, a.value, n.units, n.valuetype FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname AND n.display = 1 AND n.hidden = 0
105	0.0023	0.0022969245910645	SELECT DISTINCT(pt.tag_id) FROM product_tags pt, tags t WHERE pt.tag_id = t.id AND pt.product_id = '4232' AND t.hidden = 0 AND display_product = 1
106	0.0004	0.00038790702819824	SELECT * FROM tags WHERE id = '58'
107	0.0020	0.0019979476928711	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
108	0.0018	0.0018041133880615	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
109	0.0017	0.0017440319061279	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '58' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
110	0.0007	0.0006861686706543	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
111	0.0004	0.00039505958557129	SELECT * FROM tags WHERE id = '81'
112	0.0030	0.0029640197753906	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND p.enabled = 1 AND p.hidden = 0
113	0.0026	0.0026099681854248	SELECT COUNT(DISTINCT(p.id)) FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.parent_id = 0 AND hidden = 0 AND enabled = 1
114	0.0025	0.0024669170379639	SELECT p.id FROM products p, product_tags t WHERE p.id = t.product_id AND t.tag_id = '81' AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
115	0.0005	0.00054001808166504	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
116	0.0021	0.0020759105682373	SELECT * FROM productamazoncontent WHERE product_id = '4232'
117	0.0018	0.0017921924591064	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 = '4232' GROUP BY o.product_id
118	0.0024	0.0024211406707764	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 = '4232' GROUP BY n.displayname ORDER BY n.displayname DESC
119	0.0006	0.00064206123352051	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
120	0.0010	0.00095200538635254	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
121	0.0004	0.00042104721069336	SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
122	0.0005	0.00046801567077637	SELECT * FROM productoffers WHERE product_id = '4232' AND price > 0 ORDER BY price ASC LIMIT 1
123	0.0004	0.00036096572875977	SELECT * FROM productoffers WHERE product_id = 4232 ORDER BY price ASC LIMIT 1
124	0.0005	0.0005190372467041	SELECT value FROM productattributes WHERE product_id = '4232' AND name = 'ListPriceAmount'
125	0.0005	0.00047707557678223	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 = '4232' GROUP BY o.product_id
126	0.0008	0.00075697898864746	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 = '4232' GROUP BY n.displayname ORDER BY n.displayname DESC
127	0.0005	0.00045585632324219	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
128	0.0007	0.00065898895263672	SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
129	0.0006	0.00064396858215332	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4232' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
130	0.0006	0.00057315826416016	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
131	0.0101	0.010061979293823	SELECT *, MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AND 4232 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
132	0.0020	0.0019919872283936	SELECT *, MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
133	0.0009	0.00092911720275879	SELECT *, MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('bag stores bo�te' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
134	0.0006	0.00055217742919922	SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
135	0.0006	0.00064492225646973	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
136	0.0007	0.00071191787719727	SELECT * FROM product_image_select WHERE product_id = '4232'
137	0.0005	0.00046586990356445	SELECT * FROM productcustomimages WHERE product_id = '4232'
138	0.0007	0.00071597099304199	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 = '4232' GROUP BY o.product_id
139	0.0007	0.00068497657775879	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 = '4232' GROUP BY n.displayname ORDER BY n.displayname DESC
140	0.0005	0.00051784515380859	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
141	0.0010	0.0010180473327637	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
142	0.0005	0.00045108795166016	SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0005	0.00046896934509277	SELECT * FROM productoffers WHERE product_id = '4232' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0005	0.00046801567077637	SELECT * FROM productoffers WHERE product_id = 4232 ORDER BY price ASC LIMIT 1
145	0.0006	0.00060200691223145	SELECT value FROM productattributes WHERE product_id = '4232' AND name = 'ListPriceAmount'
146	0.0006	0.0006110668182373	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 = '4232' GROUP BY o.product_id
147	0.0008	0.00080513954162598	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 = '4232' GROUP BY n.displayname ORDER BY n.displayname DESC
148	0.0005	0.00050902366638184	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
149	0.0006	0.00064778327941895	SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150	0.0007	0.00069808959960938	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4232' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
151	0.0112	0.011248111724854	SELECT *, MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AND 4232 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 6
152	0.0009	0.00088691711425781	SELECT *, MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
153	0.0008	0.00084686279296875	SELECT *, MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('compartments hinged verre' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 6
154	0.0006	0.00061798095703125	SELECT * FROM productimages WHERE product_id = '4211' ORDER BY sortorder ASC
155	0.0005	0.00050187110900879	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4211' AND p.id = pi.product_id ORDER BY pi.sortorder
156	0.0007	0.00066399574279785	SELECT * FROM product_image_select WHERE product_id = '4211'
157	0.0004	0.00044393539428711	SELECT * FROM productcustomimages WHERE product_id = '4211'
158	0.0007	0.00067019462585449	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 = '4211' GROUP BY o.product_id
159	0.0008	0.00083494186401367	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 = '4211' GROUP BY n.displayname ORDER BY n.displayname DESC
160	0.0044	0.0044238567352295	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4211
161	0.0010	0.0010030269622803	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4211' AND a.name = n.originalname
162	0.0005	0.00050902366638184	SELECT * FROM productoffers WHERE product_id = '4211' AND merchantid = 'A1X6FK5RDHNB96'
163	0.0006	0.00057291984558105	SELECT * FROM productoffers WHERE product_id = '4211' AND price > 0 ORDER BY price ASC LIMIT 1
164	0.0005	0.00047993659973145	SELECT * FROM productoffers WHERE product_id = 4211 ORDER BY price ASC LIMIT 1
165	0.0007	0.00067806243896484	SELECT value FROM productattributes WHERE product_id = '4211' AND name = 'ListPriceAmount'
166	0.0005	0.00050806999206543	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 = '4211' GROUP BY o.product_id
167	0.0007	0.00070500373840332	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 = '4211' GROUP BY n.displayname ORDER BY n.displayname DESC
168	0.0007	0.00068116188049316	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4211
169	0.0007	0.00066399574279785	SELECT value FROM productattributes WHERE product_id = '4211' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170	0.0007	0.00069403648376465	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4211' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
171	0.0005	0.00053000450134277	SELECT * FROM products WHERE parent_id = '4211'
172	0.0007	0.00066804885864258	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4212' AND a.name = n.originalname
173	0.0005	0.00053215026855469	SELECT * FROM productoffers WHERE product_id = '4212' AND merchantid = 'A1X6FK5RDHNB96'
174	0.0005	0.00051999092102051	SELECT * FROM productoffers WHERE product_id = '4212' AND price > 0 ORDER BY price ASC LIMIT 1
175	0.0005	0.00052499771118164	SELECT * FROM productimages WHERE product_id = '4609' ORDER BY sortorder ASC
176	0.0007	0.0007021427154541	SELECT * FROM product_image_select WHERE product_id = '4609'
177	0.0005	0.00047111511230469	SELECT * FROM productcustomimages WHERE product_id = '4609'
178	0.0010	0.001007080078125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4609' AND a.name = n.originalname
179	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '4609' AND merchantid = 'A1X6FK5RDHNB96'
180	0.0006	0.0005650520324707	SELECT * FROM productoffers WHERE product_id = '4609' AND price > 0 ORDER BY price ASC LIMIT 1
181	0.0005	0.00053596496582031	SELECT value FROM productattributes WHERE product_id = '4609' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
182	0.0006	0.00058603286743164	SELECT * FROM productimages WHERE product_id = '4232' ORDER BY sortorder ASC
183	0.0008	0.00083088874816895	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4232' AND p.id = pi.product_id ORDER BY pi.sortorder
184	0.0012	0.001244068145752	SELECT * FROM product_image_select WHERE product_id = '4232'
185	0.0005	0.00049591064453125	SELECT * FROM productcustomimages WHERE product_id = '4232'
186	0.0007	0.00066590309143066	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 = '4232' GROUP BY o.product_id
187	0.0008	0.00078296661376953	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 = '4232' GROUP BY n.displayname ORDER BY n.displayname DESC
188	0.0005	0.00048089027404785	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
189	0.0010	0.0010061264038086	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
190	0.0005	0.00046896934509277	SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
191	0.0005	0.00049090385437012	SELECT * FROM productoffers WHERE product_id = '4232' AND price > 0 ORDER BY price ASC LIMIT 1
192	0.0005	0.00046610832214355	SELECT * FROM productoffers WHERE product_id = 4232 ORDER BY price ASC LIMIT 1
193	0.0005	0.00047802925109863	SELECT value FROM productattributes WHERE product_id = '4232' AND name = 'ListPriceAmount'
194	0.0007	0.00069785118103027	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 = '4232' GROUP BY o.product_id
195	0.0009	0.0009160041809082	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 = '4232' GROUP BY n.displayname ORDER BY n.displayname DESC
196	0.0005	0.00050687789916992	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
197	0.0007	0.00071191787719727	SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198	0.0008	0.00082588195800781	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4232' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
199	0.0120	0.011996984481812	SELECT *, MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AS `searchrelevance` FROM products WHERE MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AND 4232 <> 0 AND enabled = 1 AND hidden = 0 AND offers > 0 AND parent_id = 0 ORDER BY `searchrelevance` LIMIT 4
200	0.0009	0.00090312957763672	SELECT *, MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AS `searchrelevance` FROM ebay_products WHERE MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
201	0.0008	0.0007929801940918	SELECT *, MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AS `searchrelevance` FROM custom_products WHERE MATCH (description, title) AGAINST ('thé en bois' IN BOOLEAN MODE) AND 4232 <> 0 AND hide = 0 ORDER BY `searchrelevance` LIMIT 4
202	0.0007	0.0007479190826416	SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
203	0.0007	0.00067591667175293	SELECT * FROM product_image_select WHERE product_id = '776'
204	0.0005	0.00047183036804199	SELECT * FROM productcustomimages WHERE product_id = '776'
205	0.0011	0.0010738372802734	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
206	0.0005	0.00051784515380859	SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
207	0.0005	0.00046110153198242	SELECT * FROM productoffers WHERE product_id = '776' AND price > 0 ORDER BY price ASC LIMIT 1
208	0.0005	0.00048303604125977	SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
209	0.0005	0.00050091743469238	SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
210	0.0006	0.00063800811767578	SELECT * FROM product_image_select WHERE product_id = '780'
211	0.0004	0.00040888786315918	SELECT * FROM productcustomimages WHERE product_id = '780'
212	0.0008	0.00084996223449707	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
213	0.0005	0.00054621696472168	SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
214	0.0004	0.00044608116149902	SELECT * FROM productoffers WHERE product_id = '780' AND price > 0 ORDER BY price ASC LIMIT 1
215	0.0004	0.00043702125549316	SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216	0.0005	0.00051498413085938	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
217	0.0006	0.00062108039855957	SELECT * FROM product_image_select WHERE product_id = '777'
218	0.0004	0.00041699409484863	SELECT * FROM productcustomimages WHERE product_id = '777'
219	0.0011	0.0010619163513184	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
220	0.0006	0.00055289268493652	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
221	0.0006	0.00056099891662598	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
222	0.0005	0.00047516822814941	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223	0.0006	0.000640869140625	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
224	0.0007	0.00073695182800293	SELECT * FROM product_image_select WHERE product_id = '770'
225	0.0004	0.00043678283691406	SELECT * FROM productcustomimages WHERE product_id = '770'
226	0.0011	0.0010809898376465	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
227	0.0006	0.00058102607727051	SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0005	0.00046491622924805	SELECT * FROM productoffers WHERE product_id = '770' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0005	0.0005180835723877	SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230	0.0005	0.00052189826965332	SELECT id,asin FROM products WHERE parent_id = 4232
231	0.0005	0.00054097175598145	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4233
232	0.0006	0.00058698654174805	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4233
233	0.0004	0.0004420280456543	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4234
234	0.0005	0.00053191184997559	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4234
235	0.0005	0.00049686431884766	SELECT baseurl FROM productimages WHERE sortorder = 1 AND source = "amazon" AND product_id = 4235
236	0.0006	0.00064802169799805	SELECT name,value FROM productoptions WHERE name="color_name" AND product_id = 4235
237	0.0021	0.0021429061889648	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4232' ORDER BY timestamp DESC
238	0.0006	0.00056695938110352	SELECT category_id FROM products_categories WHERE product_id = '4232'
239	0.0006	0.00062298774719238	SELECT * FROM categories WHERE id = '26'
240	0.0063	0.0063028335571289	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
241	0.0005	0.00048398971557617	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
242	0.0004	0.00038886070251465	SELECT id FROM categories WHERE parent_id = '26'
243	0.0057	0.0056769847869873	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
244	0.0006	0.00063085556030273	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
245	0.0006	0.00055193901062012	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
246	0.0005	0.00054001808166504	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
247	0.0009	0.00089812278747559	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
248	0.0008	0.00082802772521973	SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
249	0.0005	0.00053691864013672	SELECT * FROM productoffers WHERE product_id = '4232' AND price > 0 ORDER BY price ASC LIMIT 1
250	0.0004	0.00042986869812012	SELECT * FROM productoffers WHERE product_id = 4232 ORDER BY price ASC LIMIT 1
251	0.0005	0.00054097175598145	SELECT value FROM productattributes WHERE product_id = '4232' AND name = 'ListPriceAmount'
252	0.0008	0.00079107284545898	SELECT * FROM products WHERE id = '4232'
253	0.0006	0.00058197975158691	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 = '4232' GROUP BY o.product_id
254	0.0011	0.001079797744751	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 = '4232' GROUP BY n.displayname ORDER BY n.displayname DESC
255	0.0005	0.00045609474182129	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4232
256	0.0006	0.00056982040405273	SELECT value FROM productattributes WHERE product_id = '4232' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257	0.0008	0.00080490112304688	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4232' AND a.name = n.originalname
258	0.0004	0.00040698051452637	SELECT * FROM productoffers WHERE product_id = '4232' AND merchantid = 'A1X6FK5RDHNB96'
259	0.0004	0.00040507316589355	SELECT * FROM productoffers WHERE product_id = '4232' AND price > 0 ORDER BY price ASC LIMIT 1
260	0.0005	0.0004880428314209	SELECT * FROM productoffers WHERE product_id = 4232 ORDER BY price ASC LIMIT 1
261	0.0004	0.0004119873046875	SELECT value FROM productattributes WHERE product_id = '4232' AND name = 'ListPriceAmount'
262	0.0006	0.00057101249694824	SELECT DISTINCT (name) FROM productoptions
263	0.0008	0.00078797340393066	SELECT * FROM productoptions WHERE product_id IN (SELECT product_id FROM productoffers WHERE product_id IN (SELECT id from products WHERE parent_id = 4232))
264	0.0005	0.00050806999206543	SELECT o.value, o.name FROM products p, productoptions o WHERE p.parent_id = 4232 AND p.id = o.product_id GROUP BY o.value ORDER BY o.value ASC
265	0.0017	0.0016870498657227	SELECT * FROM translationsfilter
266	0.0005	0.00054001808166504	SELECT category_id FROM products_categories WHERE product_id = '4232' AND prod_type = 'amz'
267	0.0005	0.00045680999755859	SELECT parent_id FROM categories WHERE id = '26'
268	0.0004	0.0004119873046875	SELECT * FROM categories WHERE id = '26'
269	0.0074	0.0073521137237549	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
270	0.0008	0.00075387954711914	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
271	0.0005	0.00046300888061523	SELECT id FROM categories WHERE parent_id = '26'
272	0.0056	0.0055651664733887	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
273	0.0007	0.00069808959960938	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
274	0.0009	0.00094699859619141	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
275	0.0012	0.0011880397796631	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
276	0.0031	0.0030949115753174	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
277	0.0016	0.0016329288482666	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
278	0.0015	0.0015201568603516	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
279	0.0272	0.027184963226318	SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
280	0.0020	0.0020480155944824	SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
281	0.0007	0.0007178783416748	SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
282	0.0008	0.00077581405639648	SELECT * FROM products WHERE id = 1626
283	0.0006	0.00064611434936523	SELECT * FROM products WHERE id = 4041
284	0.0005	0.00049996376037598	SELECT * FROM products WHERE id = 4312
285	0.0013	0.0012960433959961	SELECT * FROM products WHERE id = 777
286	0.0008	0.0008080005645752	SELECT * FROM products WHERE id = 3881
287	0.0007	0.00068092346191406	SELECT * FROM products WHERE id = 4213
288	0.0006	0.00059700012207031	SELECT * FROM products WHERE id = '1626'
289	0.0005	0.00051021575927734	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
290	0.0007	0.00065994262695312	SELECT * FROM product_image_select WHERE product_id = '1626'
291	0.0005	0.00048685073852539	SELECT * FROM productcustomimages WHERE product_id = '1626'
292	0.0010	0.00099301338195801	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
293	0.0006	0.00059986114501953	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
294	0.0005	0.00051403045654297	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
295	0.0005	0.00048208236694336	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296	0.0007	0.00066018104553223	SELECT * FROM products WHERE id = '4041'
297	0.0005	0.00052213668823242	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
298	0.0008	0.00079894065856934	SELECT * FROM product_image_select WHERE product_id = '4041'
299	0.0005	0.00049614906311035	SELECT * FROM productcustomimages WHERE product_id = '4041'
300	0.0014	0.0014369487762451	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
301	0.0007	0.00066184997558594	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
302	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
303	0.0011	0.0011370182037354	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304	0.0012	0.0011677742004395	SELECT * FROM products WHERE id = '4312'
305	0.0008	0.00083613395690918	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
306	0.0011	0.00111985206604	SELECT * FROM product_image_select WHERE product_id = '4312'
307	0.0007	0.0006561279296875	SELECT * FROM productcustomimages WHERE product_id = '4312'
308	0.0025	0.0024878978729248	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
309	0.0010	0.00097012519836426	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
310	0.0006	0.00063800811767578	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
311	0.0006	0.00062799453735352	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312	0.0009	0.0009310245513916	SELECT * FROM products WHERE id = '777'
313	0.0025	0.0024950504302979	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
314	0.0010	0.00099587440490723	SELECT * FROM product_image_select WHERE product_id = '777'
315	0.0006	0.00061488151550293	SELECT * FROM productcustomimages WHERE product_id = '777'
316	0.0019	0.0019350051879883	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
317	0.0008	0.00079703330993652	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
318	0.0006	0.00063896179199219	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
319	0.0006	0.0006098747253418	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320	0.0008	0.00083708763122559	SELECT * FROM products WHERE id = '3881'
321	0.0010	0.0010330677032471	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
322	0.0010	0.00095701217651367	SELECT * FROM product_image_select WHERE product_id = '3881'
323	0.0006	0.00061798095703125	SELECT * FROM productcustomimages WHERE product_id = '3881'
324	0.0022	0.002234935760498	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
325	0.0007	0.00071215629577637	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
326	0.0006	0.00061988830566406	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
327	0.0008	0.00077915191650391	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328	0.0011	0.0011200904846191	SELECT * FROM products WHERE id = '4213'
329	0.0009	0.00091910362243652	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
330	0.0009	0.00085711479187012	SELECT * FROM product_image_select WHERE product_id = '4213'
331	0.0006	0.00055408477783203	SELECT * FROM productcustomimages WHERE product_id = '4213'
332	0.0021	0.0021331310272217	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
333	0.0008	0.00083708763122559	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
334	0.0006	0.00060105323791504	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
335	0.0008	0.00077915191650391	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336	0.0113	0.011289119720459	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
337	0.0016	0.0016140937805176	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
338	0.0052	0.0051629543304443	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
339	0.0034	0.0034241676330566	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
340	0.0011	0.001086950302124	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
341	0.0014	0.0013890266418457	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

KUNSE Tea Bag Stores Boîte À Thé en Bois 3 Compartments Hinged Verre Lid Tea Organizer Jewelery Box Stockage

Product Features

Sac Boîte à thé en bois boîte à capsules...

Boîte à thé 9 compartiments en bois et v...

Kitchen craft le'xpress boîte à thé en ...

Boîte à thé en bois "Compagnie des ...

Zeller 15115 Boîte à thé Bois de Polonia...

Artemio 14001011 Boîte à Thé à 4 Compart...

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6956939697266 seconds

Query Debug - 341 Database Queries. Total time 1.0098 seconds

KUNSE Tea Bag Stores Boîte À Thé en Bois 3 Compartments Hinged Verre Lid Tea Organizer Jewelery Box Stockage

Product Features

Related Products

Sac Boîte à thé en bois boîte à capsules...

Boîte à thé 9 compartiments en bois et v...

Kitchen craft le'xpress boîte à thé en ...

Boîte à thé en bois "Compagnie des ...

Zeller 15115 Boîte à thé Bois de Polonia...

Artemio 14001011 Boîte à Thé à 4 Compart...

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6956939697266 seconds

Query Debug - 341 Database Queries. Total time 1.0098 seconds