Search Results for "4"

UNHO Boîte à Thé Verticale en Bambou ave...

View to See Price

View

Add to Cart

Tè Rooibos | Pickwick | Pickwick Rooibos...

View to See Price

View

Add to Cart

Stockage Boîtes 4PCS / Ensemble Organisa...

View to See Price

View

Add to Cart

Boîtes De Thé Scellé, Céramique Boîtes T...

only €15,99

View

Add to Cart

Global Village Bazaar Boîte à thé en Boi...

View to See Price

View

Add to Cart

Infuseur à thé en vrac - La Passoire à t...

View to See Price

View

Add to Cart

QDO Boîte à thé Birdie 400ml-Orange, Por...

only €15,46

View

Add to Cart

9 plats Blanc shabby Boîte à thé

View to See Price

View

Add to Cart

WANDIC Boîte à thé en Papier Kraft pour ...

from €17,19

View

Add to Cart

Typhoon Living Mastic en acier Lot de th...

View to See Price

View

Add to Cart

[Vert foncé] Boîte à thé en céramique Bo...

only €28,77

View

Add to Cart

SUPERLOVE Capsules À Double Couverture P...

View to See Price

View

Add to Cart

Boîtes De Thé Scellé, Céramique Boîtes T...

only €15,99

View

Add to Cart

Black Temptation [Oiseau] Boîte à thé en...

only €31,58

View

Add to Cart

Alter Éco - Thé Rooibos Au Caramel 40G -...

View to See Price

View

Add to Cart

Alter Éco - Thé Rooibos Bio 40G - Lot De...

only €33,90

View

Add to Cart

Dragonfly Rooibos Vanilla Tea 40 per pac...

only €10,28

View

Add to Cart

Vivaraise Couvre lit Stonewash Swami Roo...

only €109,90

View

Add to Cart

307 to 324 of 336 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.3468849658966	400	0.9265	0

No Amazon API Requests Made.

App Debug - Total Time 1.3468849658966 seconds

Number	Time From Start	Name	Description
1	0.40091609954834	Initialise	Initialise FSB Function
2	0.40618395805359	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.44274592399597	Start of getCategoryListByGroup Function	Before first category groups query
4	0.44425702095032	After initial query	Before first category groups query
5	0.44425797462463	Get Category List for Group	Before the call to getCategoryList function
6	0.44426202774048	Start of GetCategoryList function	Start of the function
7	0.44426512718201	Before getting categories	Query to get specific category list
8	0.44576597213745	After getting categories	Query to get specific category list
9	0.44576692581177	Before getting category custom	Before call to function getCategoryCustom
10	0.46784901618958	After getting category custom	After call to function getCategoryCustom
11	0.46785306930542	Before getting category custom	Before call to function getCategoryCustom
12	0.47920203208923	After getting category custom	After call to function getCategoryCustom
13	0.47920703887939	Before getting category custom	Before call to function getCategoryCustom
14	0.48597812652588	After getting category custom	After call to function getCategoryCustom
15	0.48598194122314	Before getting category custom	Before call to function getCategoryCustom
16	0.49100399017334	After getting category custom	After call to function getCategoryCustom
17	0.4910089969635	Before getting category custom	Before call to function getCategoryCustom
18	0.49688911437988	After getting category custom	After call to function getCategoryCustom
19	0.49689292907715	Before getting category custom	Before call to function getCategoryCustom
20	0.50228810310364	After getting category custom	After call to function getCategoryCustom
21	0.5022919178009	End of GetCategoryList function	End of the function
22	0.50229907035828	Get Category List for Group	Before the call to getCategoryList function
23	0.50230097770691	Start of GetCategoryList function	Start of the function
24	0.50230407714844	Before getting categories	Query to get specific category list
25	0.50292301177979	End of getCategoryListByGroup Function	Before return()
26	1.0147409439087	App Controller End	End of the App controller (called before the controller of every page)
27	1.2412919998169	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.2448830604553	Before Get Options	Before the call to getOptions in the tpl class
29	1.3140659332275	After Get Options	After the call to getOptions in the tpl class
30	1.314110994339	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.346862077713	Finalizing debug	Before the debug is output to the page.
32	1.346883058548	End of App	This is the end of the app logging, final timestamp

Query Debug - 400 Database Queries. Total time 0.9265 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.216.253.53\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738835574'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
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 = 'search'
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.216.253.53') >= INET_ATON(ip_start) AND INET_ATON('18.216.253.53') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'search'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '18.216.253.53'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT * FROM products WHERE id = '3622'
SELECT * FROM productimages WHERE product_id = '3622' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3622'
SELECT * FROM productcustomimages WHERE product_id = '3622'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3622' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3622' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3622' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3622
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3622'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3622' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3626'
SELECT * FROM productimages WHERE product_id = '3626' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3626' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3626'
SELECT * FROM productcustomimages WHERE product_id = '3626'
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 = '3626'
                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     = '3626'
                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 = 3626
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3626
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3626'
                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 = '3626'
                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     = '3626'
                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 = 3626
SELECT value FROM productattributes WHERE product_id = '3626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3626'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'FlavorName'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '3682'
SELECT * FROM productimages WHERE product_id = '3682' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3682' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3682'
SELECT * FROM productcustomimages WHERE product_id = '3682'
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 = '3682'
                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     = '3682'
                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 = 3682
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3682' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3682' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3682' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3682
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3682'
                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 = '3682'
                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     = '3682'
                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 = 3682
SELECT value FROM productattributes WHERE product_id = '3682' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3682'
                  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 = '3682'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4890' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4890' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4890' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4890
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4890'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3733'
SELECT * FROM productimages WHERE product_id = '3733' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3733'
SELECT * FROM productcustomimages WHERE product_id = '3733'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3733' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3733' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3733' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3733' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3741'
SELECT * FROM productimages WHERE product_id = '3741' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3741'
SELECT * FROM productcustomimages WHERE product_id = '3741'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3741' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3741' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3741' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3741
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3741'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3741' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3739'
SELECT * FROM productimages WHERE product_id = '3739' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3739'
SELECT * FROM productcustomimages WHERE product_id = '3739'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3739' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3739' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3739' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3739
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3739'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3773'
SELECT * FROM productimages WHERE product_id = '3773' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3773'
SELECT * FROM productcustomimages WHERE product_id = '3773'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3773' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3773' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3773' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3775'
SELECT * FROM productimages WHERE product_id = '3775' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3775'
SELECT * FROM productcustomimages WHERE product_id = '3775'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3775' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3775' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3775' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3775
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3775'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3916'
SELECT * FROM productimages WHERE product_id = '3916' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3916' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3916'
SELECT * FROM productcustomimages WHERE product_id = '3916'
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 = '3916'
                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     = '3916'
                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 = 3916
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3916' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3916' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3916' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3916
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3916'
                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 = '3916'
                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     = '3916'
                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 = 3916
SELECT value FROM productattributes WHERE product_id = '3916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3916'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '3827'
SELECT * FROM productimages WHERE product_id = '3827' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3827'
SELECT * FROM productcustomimages WHERE product_id = '3827'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3827' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3827' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3827' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3827
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3827'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3827' 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 = '3889'
SELECT * FROM productimages WHERE product_id = '3889' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3889' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3889'
SELECT * FROM productcustomimages WHERE product_id = '3889'
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 = '3889'
                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     = '3889'
                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 = 3889
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3889' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3889' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3889' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3889
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3889'
                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 = '3889'
                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     = '3889'
                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 = 3889
SELECT value FROM productattributes WHERE product_id = '3889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '3889'
SELECT * FROM products WHERE id = '3919'
SELECT * FROM productimages WHERE product_id = '3919' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3919'
SELECT * FROM productcustomimages WHERE product_id = '3919'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3919' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3919' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3919' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4311'
SELECT * FROM productimages WHERE product_id = '4311' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4311'
SELECT * FROM productcustomimages WHERE product_id = '4311'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4311' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4311' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4311' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4311' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4201'
SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4201'
SELECT * FROM productcustomimages WHERE product_id = '4201'
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 = '4201'
                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     = '4201'
                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 = 4201
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4201' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4201
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4201'
                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 = '4201'
                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     = '4201'
                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 = 4201
SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '4201'
SELECT * FROM products WHERE id = '4202'
SELECT * FROM productimages WHERE product_id = '4202' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4202'
SELECT * FROM productcustomimages WHERE product_id = '4202'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4202' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4202' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4202' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4202' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4222'
SELECT * FROM productimages WHERE product_id = '4222' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4222'
SELECT * FROM productcustomimages WHERE product_id = '4222'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4222' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4222' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4222' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4246'
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4246'
SELECT * FROM productcustomimages WHERE product_id = '4246'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3622' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3626' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3682' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3733' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3741' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3739' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3773' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3775' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3916' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3827' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4041' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3889' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3919' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4311' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4201' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4202' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4222' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4246' ORDER BY timestamp DESC
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 = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0022	0.0022239685058594	SELECT parameter, value FROM parameters
2	0.0085	0.0084800720214844	SELECT * FROM `bad_bots`
3	0.0005	0.00047898292541504	SET time_zone = 'Europe/London'
4	0.0031	0.0031430721282959	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0035	0.0034811496734619	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.216.253.53\";}'
6	0.0031	0.0031349658966064	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738835574'
7	0.0036	0.0035932064056396	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00083494186401367	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0033	0.0032908916473389	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0006	0.00063800811767578	SELECT * FROM pages WHERE id = 52
11	0.0043	0.0042891502380371	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0297	0.029655933380127	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0021	0.0020749568939209	SELECT * FROM pages WHERE pagename = 'search'
14	0.0015	0.0014970302581787	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0015	0.001478910446167	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0077	0.007659912109375	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.0018	0.0018100738525391	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.0013	0.0012719631195068	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0006	0.00055694580078125	SELECT id FROM categories WHERE parent_id = '26'
20	0.0057	0.0056731700897217	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0016	0.0015552043914795	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.0015	0.0015180110931396	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0014	0.001378059387207	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00046706199645996	SELECT * FROM categorygroups WHERE id = '1'
25	0.0036	0.0036349296569824	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.00057506561279297	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.00044894218444824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.00052094459533691	SELECT id FROM categories WHERE parent_id = '27'
29	0.0037	0.0037338733673096	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.0006	0.00059199333190918	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0006	0.00058197975158691	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.0006	0.00059986114501953	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00050115585327148	SELECT * FROM categorygroups WHERE id = '1'
34	0.0015	0.0014619827270508	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0005	0.00049090385437012	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.00046992301940918	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00049400329589844	SELECT id FROM categories WHERE parent_id = '28'
38	0.0016	0.0016119480133057	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0006	0.00057506561279297	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0006	0.00058293342590332	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.00049805641174316	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0004	0.00044107437133789	SELECT * FROM categorygroups WHERE id = '1'
43	0.0007	0.00068402290344238	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0006	0.00055718421936035	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0004	0.00039291381835938	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0004	0.00044488906860352	SELECT id FROM categories WHERE parent_id = '29'
47	0.0008	0.00083708763122559	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.0005	0.00054001808166504	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.00055098533630371	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.0004889965057373	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0004	0.00041294097900391	SELECT * FROM categorygroups WHERE id = '1'
52	0.0006	0.00060009956359863	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.0005	0.00053906440734863	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.0006	0.00062704086303711	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0006	0.00061607360839844	SELECT id FROM categories WHERE parent_id = '30'
56	0.0011	0.0011169910430908	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0006	0.00056695938110352	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0006	0.00064301490783691	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.0006	0.00056314468383789	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00047087669372559	SELECT * FROM categorygroups WHERE id = '1'
61	0.0006	0.00063514709472656	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0005	0.00054502487182617	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.0005	0.00049591064453125	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0006	0.0005650520324707	SELECT id FROM categories WHERE parent_id = '31'
65	0.0009	0.00087594985961914	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.0006	0.000579833984375	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.00055885314941406	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.00055217742919922	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0005	0.00046801567077637	SELECT * FROM categorygroups WHERE id = '1'
70	0.0006	0.00060796737670898	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0029	0.0028760433197021	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0016	0.0015981197357178	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0006	0.00059199333190918	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.0012	0.0011739730834961	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0011	0.0011007785797119	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0011	0.0010669231414795	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4965	0.49646997451782	SELECT * FROM ipgeocountries WHERE INET_ATON('18.216.253.53') >= INET_ATON(ip_start) AND INET_ATON('18.216.253.53') <= INET_ATON(ip_end)
78	0.0027	0.0026941299438477	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0026	0.0025999546051025	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0006	0.00059199333190918	SELECT * FROM pages WHERE pagename = 'search'
81	0.0062	0.0061988830566406	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0030	0.002957820892334	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0022	0.0021970272064209	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0129	0.012927055358887	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0019	0.0019490718841553	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0007	0.00071096420288086	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0020	0.0019800662994385	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '18.216.253.53'
88	0.0007	0.00073790550231934	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
89	0.0005	0.00054502487182617	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0037	0.0036909580230713	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
91	0.0005	0.00049805641174316	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
92	0.0004	0.00044512748718262	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
93	0.0005	0.00052809715270996	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
94	0.0047	0.0047440528869629	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
95	0.0004	0.00039291381835938	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
96	0.0003	0.00033807754516602	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
97	0.0005	0.00049901008605957	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0005	0.00053191184997559	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0037	0.0036811828613281	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0004	0.00042510032653809	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
101	0.0003	0.00034689903259277	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
102	0.0005	0.00054001808166504	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
103	0.0048	0.004767894744873	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0004	0.00044798851013184	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
105	0.0004	0.00037503242492676	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
106	0.0005	0.00050592422485352	SELECT * FROM products WHERE id = '3622'
107	0.0016	0.00164794921875	SELECT * FROM productimages WHERE product_id = '3622' ORDER BY sortorder ASC
108	0.0015	0.0014739036560059	SELECT * FROM product_image_select WHERE product_id = '3622'
109	0.0012	0.0011861324310303	SELECT * FROM productcustomimages WHERE product_id = '3622'
110	0.0023	0.0022730827331543	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3622' AND a.name = n.originalname
111	0.0017	0.0017039775848389	SELECT * FROM productoffers WHERE product_id = '3622' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0005	0.00053691864013672	SELECT * FROM productoffers WHERE product_id = '3622' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0004	0.00040793418884277	SELECT * FROM productoffers WHERE product_id = 3622 ORDER BY price ASC LIMIT 1
114	0.0006	0.0005650520324707	SELECT value FROM productattributes WHERE product_id = '3622' AND name = 'ListPriceAmount'
115	0.0005	0.00048589706420898	SELECT value FROM productattributes WHERE product_id = '3622' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116	0.0007	0.0007169246673584	SELECT * FROM products WHERE id = '3626'
117	0.0005	0.00048494338989258	SELECT * FROM productimages WHERE product_id = '3626' ORDER BY sortorder ASC
118	0.0009	0.00088286399841309	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3626' AND p.id = pi.product_id ORDER BY pi.sortorder
119	0.0007	0.00070595741271973	SELECT * FROM product_image_select WHERE product_id = '3626'
120	0.0005	0.00046515464782715	SELECT * FROM productcustomimages WHERE product_id = '3626'
121	0.0006	0.00056195259094238	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 = '3626' GROUP BY o.product_id
122	0.0025	0.002500057220459	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 = '3626' GROUP BY n.displayname ORDER BY n.displayname DESC
123	0.0008	0.00078392028808594	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
124	0.0016	0.0015909671783447	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3626' AND a.name = n.originalname
125	0.0005	0.00049710273742676	SELECT * FROM productoffers WHERE product_id = '3626' AND merchantid = 'A1X6FK5RDHNB96'
126	0.0005	0.00050115585327148	SELECT * FROM productoffers WHERE product_id = '3626' AND price > 0 ORDER BY price ASC LIMIT 1
127	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = 3626 ORDER BY price ASC LIMIT 1
128	0.0005	0.00047111511230469	SELECT value FROM productattributes WHERE product_id = '3626' AND name = 'ListPriceAmount'
129	0.0005	0.00050687789916992	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 = '3626' GROUP BY o.product_id
130	0.0007	0.00071406364440918	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 = '3626' GROUP BY n.displayname ORDER BY n.displayname DESC
131	0.0005	0.00049209594726562	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3626
132	0.0007	0.0006861686706543	SELECT value FROM productattributes WHERE product_id = '3626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0007	0.00073814392089844	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3626' AND p.id = o.product_id AND o.name = 'FlavorName' GROUP BY o.value ORDER BY o.value ASC
134	0.0005	0.0005490779876709	SELECT * FROM products WHERE id = '3682'
135	0.0006	0.000579833984375	SELECT * FROM productimages WHERE product_id = '3682' ORDER BY sortorder ASC
136	0.0006	0.0005648136138916	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3682' AND p.id = pi.product_id ORDER BY pi.sortorder
137	0.0007	0.00065302848815918	SELECT * FROM product_image_select WHERE product_id = '3682'
138	0.0004	0.00044107437133789	SELECT * FROM productcustomimages WHERE product_id = '3682'
139	0.0006	0.00055289268493652	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 = '3682' GROUP BY o.product_id
140	0.0007	0.00065207481384277	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 = '3682' GROUP BY n.displayname ORDER BY n.displayname DESC
141	0.0004	0.00043416023254395	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3682
142	0.0011	0.00105881690979	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3682' AND a.name = n.originalname
143	0.0005	0.00045895576477051	SELECT * FROM productoffers WHERE product_id = '3682' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0004	0.00041484832763672	SELECT * FROM productoffers WHERE product_id = '3682' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0004	0.00041103363037109	SELECT * FROM productoffers WHERE product_id = 3682 ORDER BY price ASC LIMIT 1
146	0.0006	0.00059199333190918	SELECT value FROM productattributes WHERE product_id = '3682' AND name = 'ListPriceAmount'
147	0.0006	0.00055313110351562	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 = '3682' GROUP BY o.product_id
148	0.0007	0.00072789192199707	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 = '3682' GROUP BY n.displayname ORDER BY n.displayname DESC
149	0.0005	0.00045394897460938	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3682
150	0.0007	0.00066304206848145	SELECT value FROM productattributes WHERE product_id = '3682' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0007	0.0006721019744873	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3682' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
152	0.0005	0.00052809715270996	SELECT * FROM products WHERE parent_id = '3682'
153	0.0007	0.00065302848815918	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4890' AND a.name = n.originalname
154	0.0005	0.0005180835723877	SELECT * FROM productoffers WHERE product_id = '4890' AND merchantid = 'A1X6FK5RDHNB96'
155	0.0005	0.00049781799316406	SELECT * FROM productoffers WHERE product_id = '4890' AND price > 0 ORDER BY price ASC LIMIT 1
156	0.0004	0.00041699409484863	SELECT * FROM productoffers WHERE product_id = 4890 ORDER BY price ASC LIMIT 1
157	0.0005	0.0004889965057373	SELECT value FROM productattributes WHERE product_id = '4890' AND name = 'ListPriceAmount'
158	0.0006	0.0005640983581543	SELECT * FROM products WHERE id = '3733'
159	0.0005	0.00054001808166504	SELECT * FROM productimages WHERE product_id = '3733' ORDER BY sortorder ASC
160	0.0011	0.0010950565338135	SELECT * FROM product_image_select WHERE product_id = '3733'
161	0.0005	0.00045895576477051	SELECT * FROM productcustomimages WHERE product_id = '3733'
162	0.0015	0.0014901161193848	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3733' AND a.name = n.originalname
163	0.0006	0.00063586235046387	SELECT * FROM productoffers WHERE product_id = '3733' AND merchantid = 'A1X6FK5RDHNB96'
164	0.0007	0.00073695182800293	SELECT * FROM productoffers WHERE product_id = '3733' AND price > 0 ORDER BY price ASC LIMIT 1
165	0.0007	0.00072598457336426	SELECT value FROM productattributes WHERE product_id = '3733' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166	0.0009	0.00086188316345215	SELECT * FROM products WHERE id = '3741'
167	0.0007	0.00068378448486328	SELECT * FROM productimages WHERE product_id = '3741' ORDER BY sortorder ASC
168	0.0009	0.00085806846618652	SELECT * FROM product_image_select WHERE product_id = '3741'
169	0.0005	0.0005190372467041	SELECT * FROM productcustomimages WHERE product_id = '3741'
170	0.0015	0.0014619827270508	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3741' AND a.name = n.originalname
171	0.0006	0.00063514709472656	SELECT * FROM productoffers WHERE product_id = '3741' AND merchantid = 'A1X6FK5RDHNB96'
172	0.0006	0.00057482719421387	SELECT * FROM productoffers WHERE product_id = '3741' AND price > 0 ORDER BY price ASC LIMIT 1
173	0.0005	0.0005190372467041	SELECT * FROM productoffers WHERE product_id = 3741 ORDER BY price ASC LIMIT 1
174	0.0006	0.00055503845214844	SELECT value FROM productattributes WHERE product_id = '3741' AND name = 'ListPriceAmount'
175	0.0006	0.00057792663574219	SELECT value FROM productattributes WHERE product_id = '3741' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
176	0.0007	0.00070500373840332	SELECT * FROM products WHERE id = '3739'
177	0.0008	0.00082302093505859	SELECT * FROM productimages WHERE product_id = '3739' ORDER BY sortorder ASC
178	0.0009	0.00094199180603027	SELECT * FROM product_image_select WHERE product_id = '3739'
179	0.0006	0.0006401538848877	SELECT * FROM productcustomimages WHERE product_id = '3739'
180	0.0010	0.0010139942169189	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3739' AND a.name = n.originalname
181	0.0006	0.00055789947509766	SELECT * FROM productoffers WHERE product_id = '3739' AND merchantid = 'A1X6FK5RDHNB96'
182	0.0005	0.00045585632324219	SELECT * FROM productoffers WHERE product_id = '3739' AND price > 0 ORDER BY price ASC LIMIT 1
183	0.0008	0.00083303451538086	SELECT * FROM productoffers WHERE product_id = 3739 ORDER BY price ASC LIMIT 1
184	0.0008	0.00077104568481445	SELECT value FROM productattributes WHERE product_id = '3739' AND name = 'ListPriceAmount'
185	0.0009	0.00087499618530273	SELECT value FROM productattributes WHERE product_id = '3739' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186	0.0022	0.0022480487823486	SELECT * FROM products WHERE id = '3773'
187	0.0014	0.0014150142669678	SELECT * FROM productimages WHERE product_id = '3773' ORDER BY sortorder ASC
188	0.0015	0.0015208721160889	SELECT * FROM product_image_select WHERE product_id = '3773'
189	0.0012	0.0012381076812744	SELECT * FROM productcustomimages WHERE product_id = '3773'
190	0.0028	0.0027740001678467	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3773' AND a.name = n.originalname
191	0.0009	0.00089406967163086	SELECT * FROM productoffers WHERE product_id = '3773' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0007	0.0006709098815918	SELECT * FROM productoffers WHERE product_id = '3773' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0007	0.00072598457336426	SELECT value FROM productattributes WHERE product_id = '3773' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194	0.0009	0.00088191032409668	SELECT * FROM products WHERE id = '3775'
195	0.0007	0.00071907043457031	SELECT * FROM productimages WHERE product_id = '3775' ORDER BY sortorder ASC
196	0.0012	0.0012061595916748	SELECT * FROM product_image_select WHERE product_id = '3775'
197	0.0008	0.00079202651977539	SELECT * FROM productcustomimages WHERE product_id = '3775'
198	0.0020	0.0020360946655273	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3775' AND a.name = n.originalname
199	0.0008	0.00076389312744141	SELECT * FROM productoffers WHERE product_id = '3775' AND merchantid = 'A1X6FK5RDHNB96'
200	0.0006	0.00059795379638672	SELECT * FROM productoffers WHERE product_id = '3775' AND price > 0 ORDER BY price ASC LIMIT 1
201	0.0005	0.00052309036254883	SELECT * FROM productoffers WHERE product_id = 3775 ORDER BY price ASC LIMIT 1
202	0.0006	0.00060200691223145	SELECT value FROM productattributes WHERE product_id = '3775' AND name = 'ListPriceAmount'
203	0.0007	0.00072693824768066	SELECT value FROM productattributes WHERE product_id = '3775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204	0.0009	0.00085091590881348	SELECT * FROM products WHERE id = '3916'
205	0.0008	0.00081396102905273	SELECT * FROM productimages WHERE product_id = '3916' ORDER BY sortorder ASC
206	0.0007	0.00066304206848145	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3916' AND p.id = pi.product_id ORDER BY pi.sortorder
207	0.0012	0.0011868476867676	SELECT * FROM product_image_select WHERE product_id = '3916'
208	0.0006	0.00062394142150879	SELECT * FROM productcustomimages WHERE product_id = '3916'
209	0.0009	0.00093388557434082	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 = '3916' GROUP BY o.product_id
210	0.0009	0.00088715553283691	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 = '3916' GROUP BY n.displayname ORDER BY n.displayname DESC
211	0.0005	0.00047898292541504	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
212	0.0009	0.00094413757324219	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3916' AND a.name = n.originalname
213	0.0004	0.00038599967956543	SELECT * FROM productoffers WHERE product_id = '3916' AND merchantid = 'A1X6FK5RDHNB96'
214	0.0004	0.0004270076751709	SELECT * FROM productoffers WHERE product_id = '3916' AND price > 0 ORDER BY price ASC LIMIT 1
215	0.0004	0.00038981437683105	SELECT * FROM productoffers WHERE product_id = 3916 ORDER BY price ASC LIMIT 1
216	0.0004	0.00040292739868164	SELECT value FROM productattributes WHERE product_id = '3916' AND name = 'ListPriceAmount'
217	0.0005	0.0004570484161377	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 = '3916' GROUP BY o.product_id
218	0.0011	0.0011119842529297	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 = '3916' GROUP BY n.displayname ORDER BY n.displayname DESC
219	0.0005	0.00049686431884766	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3916
220	0.0008	0.00082898139953613	SELECT value FROM productattributes WHERE product_id = '3916' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221	0.0013	0.0013291835784912	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3916' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
222	0.0006	0.00059008598327637	SELECT * FROM products WHERE id = '3827'
223	0.0007	0.00073909759521484	SELECT * FROM productimages WHERE product_id = '3827' ORDER BY sortorder ASC
224	0.0008	0.00078296661376953	SELECT * FROM product_image_select WHERE product_id = '3827'
225	0.0005	0.00047802925109863	SELECT * FROM productcustomimages WHERE product_id = '3827'
226	0.0010	0.0010089874267578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3827' AND a.name = n.originalname
227	0.0005	0.0005488395690918	SELECT * FROM productoffers WHERE product_id = '3827' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0004	0.00041890144348145	SELECT * FROM productoffers WHERE product_id = '3827' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0004	0.00036811828613281	SELECT * FROM productoffers WHERE product_id = 3827 ORDER BY price ASC LIMIT 1
230	0.0004	0.00041699409484863	SELECT value FROM productattributes WHERE product_id = '3827' AND name = 'ListPriceAmount'
231	0.0004	0.00044488906860352	SELECT value FROM productattributes WHERE product_id = '3827' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232	0.0006	0.00062918663024902	SELECT * FROM products WHERE id = '4041'
233	0.0005	0.00049901008605957	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
234	0.0006	0.00059890747070312	SELECT * FROM product_image_select WHERE product_id = '4041'
235	0.0004	0.00038599967956543	SELECT * FROM productcustomimages WHERE product_id = '4041'
236	0.0011	0.0011088848114014	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
237	0.0006	0.00058603286743164	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
238	0.0004	0.00041294097900391	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
239	0.0004	0.00041699409484863	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240	0.0006	0.00056982040405273	SELECT * FROM products WHERE id = '3889'
241	0.0004	0.00043797492980957	SELECT * FROM productimages WHERE product_id = '3889' ORDER BY sortorder ASC
242	0.0004	0.00041103363037109	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3889' AND p.id = pi.product_id ORDER BY pi.sortorder
243	0.0006	0.00057816505432129	SELECT * FROM product_image_select WHERE product_id = '3889'
244	0.0004	0.0004279613494873	SELECT * FROM productcustomimages WHERE product_id = '3889'
245	0.0006	0.000579833984375	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 = '3889' GROUP BY o.product_id
246	0.0007	0.0006868839263916	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 = '3889' GROUP BY n.displayname ORDER BY n.displayname DESC
247	0.0005	0.00049400329589844	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3889
248	0.0014	0.0013659000396729	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3889' AND a.name = n.originalname
249	0.0004	0.00043106079101562	SELECT * FROM productoffers WHERE product_id = '3889' AND merchantid = 'A1X6FK5RDHNB96'
250	0.0004	0.00042891502380371	SELECT * FROM productoffers WHERE product_id = '3889' AND price > 0 ORDER BY price ASC LIMIT 1
251	0.0004	0.00043988227844238	SELECT * FROM productoffers WHERE product_id = 3889 ORDER BY price ASC LIMIT 1
252	0.0005	0.00045394897460938	SELECT value FROM productattributes WHERE product_id = '3889' AND name = 'ListPriceAmount'
253	0.0005	0.00046992301940918	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 = '3889' GROUP BY o.product_id
254	0.0007	0.0006861686706543	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 = '3889' GROUP BY n.displayname ORDER BY n.displayname DESC
255	0.0005	0.00045490264892578	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3889
256	0.0006	0.00055789947509766	SELECT value FROM productattributes WHERE product_id = '3889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257	0.0005	0.00051689147949219	SELECT * FROM products WHERE parent_id = '3889'
258	0.0004	0.00044012069702148	SELECT * FROM products WHERE id = '3919'
259	0.0005	0.00049495697021484	SELECT * FROM productimages WHERE product_id = '3919' ORDER BY sortorder ASC
260	0.0006	0.00059199333190918	SELECT * FROM product_image_select WHERE product_id = '3919'
261	0.0005	0.00049614906311035	SELECT * FROM productcustomimages WHERE product_id = '3919'
262	0.0011	0.0010600090026855	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3919' AND a.name = n.originalname
263	0.0005	0.00054097175598145	SELECT * FROM productoffers WHERE product_id = '3919' AND merchantid = 'A1X6FK5RDHNB96'
264	0.0005	0.00047707557678223	SELECT * FROM productoffers WHERE product_id = '3919' AND price > 0 ORDER BY price ASC LIMIT 1
265	0.0004	0.00041317939758301	SELECT value FROM productattributes WHERE product_id = '3919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266	0.0006	0.00063800811767578	SELECT * FROM products WHERE id = '4311'
267	0.0005	0.00049495697021484	SELECT * FROM productimages WHERE product_id = '4311' ORDER BY sortorder ASC
268	0.0007	0.00068092346191406	SELECT * FROM product_image_select WHERE product_id = '4311'
269	0.0005	0.00045514106750488	SELECT * FROM productcustomimages WHERE product_id = '4311'
270	0.0011	0.0011379718780518	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4311' AND a.name = n.originalname
271	0.0005	0.00053191184997559	SELECT * FROM productoffers WHERE product_id = '4311' AND merchantid = 'A1X6FK5RDHNB96'
272	0.0005	0.00045895576477051	SELECT * FROM productoffers WHERE product_id = '4311' AND price > 0 ORDER BY price ASC LIMIT 1
273	0.0004	0.00044608116149902	SELECT value FROM productattributes WHERE product_id = '4311' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274	0.0006	0.0006401538848877	SELECT * FROM products WHERE id = '4201'
275	0.0005	0.00054311752319336	SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
276	0.0005	0.00045514106750488	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
277	0.0007	0.00066089630126953	SELECT * FROM product_image_select WHERE product_id = '4201'
278	0.0005	0.00046682357788086	SELECT * FROM productcustomimages WHERE product_id = '4201'
279	0.0006	0.00057411193847656	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 = '4201' GROUP BY o.product_id
280	0.0007	0.00067901611328125	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 = '4201' GROUP BY n.displayname ORDER BY n.displayname DESC
281	0.0005	0.00046586990356445	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
282	0.0010	0.001011848449707	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
283	0.0005	0.00047707557678223	SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
284	0.0004	0.00042319297790527	SELECT * FROM productoffers WHERE product_id = '4201' AND price > 0 ORDER BY price ASC LIMIT 1
285	0.0004	0.00037407875061035	SELECT * FROM productoffers WHERE product_id = 4201 ORDER BY price ASC LIMIT 1
286	0.0004	0.0003960132598877	SELECT value FROM productattributes WHERE product_id = '4201' AND name = 'ListPriceAmount'
287	0.0004	0.00041794776916504	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 = '4201' GROUP BY o.product_id
288	0.0007	0.00067400932312012	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 = '4201' GROUP BY n.displayname ORDER BY n.displayname DESC
289	0.0004	0.00043010711669922	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
290	0.0006	0.00057101249694824	SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291	0.0005	0.00053095817565918	SELECT * FROM products WHERE parent_id = '4201'
292	0.0004	0.00044798851013184	SELECT * FROM products WHERE id = '4202'
293	0.0005	0.00053000450134277	SELECT * FROM productimages WHERE product_id = '4202' ORDER BY sortorder ASC
294	0.0006	0.00061798095703125	SELECT * FROM product_image_select WHERE product_id = '4202'
295	0.0005	0.00047397613525391	SELECT * FROM productcustomimages WHERE product_id = '4202'
296	0.0010	0.00098299980163574	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4202' AND a.name = n.originalname
297	0.0005	0.00053191184997559	SELECT * FROM productoffers WHERE product_id = '4202' AND merchantid = 'A1X6FK5RDHNB96'
298	0.0005	0.00048708915710449	SELECT * FROM productoffers WHERE product_id = '4202' AND price > 0 ORDER BY price ASC LIMIT 1
299	0.0005	0.00046586990356445	SELECT value FROM productattributes WHERE product_id = '4202' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300	0.0006	0.00060701370239258	SELECT * FROM products WHERE id = '4222'
301	0.0006	0.00056600570678711	SELECT * FROM productimages WHERE product_id = '4222' ORDER BY sortorder ASC
302	0.0006	0.00062394142150879	SELECT * FROM product_image_select WHERE product_id = '4222'
303	0.0004	0.00041699409484863	SELECT * FROM productcustomimages WHERE product_id = '4222'
304	0.0012	0.001209020614624	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4222' AND a.name = n.originalname
305	0.0006	0.0005950927734375	SELECT * FROM productoffers WHERE product_id = '4222' AND merchantid = 'A1X6FK5RDHNB96'
306	0.0004	0.0004279613494873	SELECT * FROM productoffers WHERE product_id = '4222' AND price > 0 ORDER BY price ASC LIMIT 1
307	0.0005	0.00046896934509277	SELECT value FROM productattributes WHERE product_id = '4222' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
308	0.0006	0.00064492225646973	SELECT * FROM products WHERE id = '4246'
309	0.0005	0.00047492980957031	SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
310	0.0006	0.00059890747070312	SELECT * FROM product_image_select WHERE product_id = '4246'
311	0.0005	0.00045204162597656	SELECT * FROM productcustomimages WHERE product_id = '4246'
312	0.0011	0.0011200904846191	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
313	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
314	0.0004	0.00043320655822754	SELECT * FROM productoffers WHERE product_id = '4246' AND price > 0 ORDER BY price ASC LIMIT 1
315	0.0004	0.00043416023254395	SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
316	0.0054	0.0053880214691162	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3622' ORDER BY timestamp DESC
317	0.0008	0.00077414512634277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3626' ORDER BY timestamp DESC
318	0.0007	0.00068402290344238	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3682' ORDER BY timestamp DESC
319	0.0007	0.00068283081054688	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3733' ORDER BY timestamp DESC
320	0.0007	0.00069499015808105	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3741' ORDER BY timestamp DESC
321	0.0006	0.00064682960510254	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3739' ORDER BY timestamp DESC
322	0.0006	0.00057101249694824	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3773' ORDER BY timestamp DESC
323	0.0006	0.0006401538848877	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3775' ORDER BY timestamp DESC
324	0.0007	0.0006709098815918	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3916' ORDER BY timestamp DESC
325	0.0005	0.00052714347839355	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3827' ORDER BY timestamp DESC
326	0.0006	0.0005640983581543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4041' ORDER BY timestamp DESC
327	0.0006	0.00061798095703125	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3889' ORDER BY timestamp DESC
328	0.0007	0.0006568431854248	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3919' ORDER BY timestamp DESC
329	0.0006	0.00062203407287598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4311' ORDER BY timestamp DESC
330	0.0005	0.00052380561828613	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4201' ORDER BY timestamp DESC
331	0.0006	0.00063300132751465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4202' ORDER BY timestamp DESC
332	0.0006	0.00060892105102539	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4222' ORDER BY timestamp DESC
333	0.0006	0.00062203407287598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4246' ORDER BY timestamp DESC
334	0.0034	0.0034019947052002	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
335	0.0029	0.0028660297393799	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
336	0.0006	0.00063586235046387	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
337	0.0208	0.0208420753479	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
338	0.0019	0.0018999576568604	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
339	0.0006	0.00059103965759277	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
340	0.0006	0.00060081481933594	SELECT * FROM products WHERE id = 1626
341	0.0005	0.0004878044128418	SELECT * FROM products WHERE id = 4041
342	0.0004	0.0004279613494873	SELECT * FROM products WHERE id = 4312
343	0.0005	0.00045108795166016	SELECT * FROM products WHERE id = 777
344	0.0004	0.00043702125549316	SELECT * FROM products WHERE id = 3881
345	0.0005	0.00046801567077637	SELECT * FROM products WHERE id = 4213
346	0.0004	0.00042009353637695	SELECT * FROM products WHERE id = '1626'
347	0.0006	0.00059008598327637	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
348	0.0006	0.00063896179199219	SELECT * FROM product_image_select WHERE product_id = '1626'
349	0.0004	0.00041890144348145	SELECT * FROM productcustomimages WHERE product_id = '1626'
350	0.0009	0.00087499618530273	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
351	0.0005	0.00050902366638184	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
352	0.0005	0.00046586990356445	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
353	0.0005	0.00046896934509277	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
354	0.0006	0.00061607360839844	SELECT * FROM products WHERE id = '4041'
355	0.0005	0.00047612190246582	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
356	0.0007	0.00073814392089844	SELECT * FROM product_image_select WHERE product_id = '4041'
357	0.0005	0.00049495697021484	SELECT * FROM productcustomimages WHERE product_id = '4041'
358	0.0014	0.0013659000396729	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
359	0.0005	0.00054478645324707	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
360	0.0006	0.00059199333190918	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
361	0.0005	0.00048303604125977	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
362	0.0006	0.00060415267944336	SELECT * FROM products WHERE id = '4312'
363	0.0005	0.00049996376037598	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
364	0.0006	0.00062394142150879	SELECT * FROM product_image_select WHERE product_id = '4312'
365	0.0004	0.00040292739868164	SELECT * FROM productcustomimages WHERE product_id = '4312'
366	0.0012	0.001201868057251	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
367	0.0005	0.0005490779876709	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
368	0.0004	0.00043678283691406	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
369	0.0005	0.00052714347839355	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
370	0.0007	0.00073003768920898	SELECT * FROM products WHERE id = '777'
371	0.0005	0.00054287910461426	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
372	0.0007	0.00066494941711426	SELECT * FROM product_image_select WHERE product_id = '777'
373	0.0004	0.00040388107299805	SELECT * FROM productcustomimages WHERE product_id = '777'
374	0.0011	0.0010960102081299	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
375	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
376	0.0005	0.00047707557678223	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
377	0.0007	0.00066900253295898	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
378	0.0007	0.0006709098815918	SELECT * FROM products WHERE id = '3881'
379	0.0006	0.0006258487701416	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
380	0.0006	0.00062799453735352	SELECT * FROM product_image_select WHERE product_id = '3881'
381	0.0005	0.00046396255493164	SELECT * FROM productcustomimages WHERE product_id = '3881'
382	0.0012	0.0011930465698242	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
383	0.0005	0.00052881240844727	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
384	0.0005	0.000457763671875	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
385	0.0004	0.00043201446533203	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
386	0.0006	0.00062990188598633	SELECT * FROM products WHERE id = '4213'
387	0.0007	0.00066709518432617	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
388	0.0006	0.00059700012207031	SELECT * FROM product_image_select WHERE product_id = '4213'
389	0.0006	0.00056099891662598	SELECT * FROM productcustomimages WHERE product_id = '4213'
390	0.0017	0.0016789436340332	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
391	0.0006	0.00055313110351562	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
392	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
393	0.0005	0.00051093101501465	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
394	0.0024	0.0024151802062988	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
395	0.0009	0.00088620185852051	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
396	0.0027	0.0026512145996094	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
397	0.0026	0.0025789737701416	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
398	0.0012	0.0012128353118896	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
399	0.0014	0.0014090538024902	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
400	0.0015	0.0014889240264893	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "4"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3468849658966 seconds

Query Debug - 400 Database Queries. Total time 0.9265 seconds