Search Results for "3"

Boîte à thé 4 compartiments 34 x 11 x 8 ...

only €5,65

View

Add to Cart

Derrière La Porte DLP : Boîtes Empilable...

only €13,00

View

Add to Cart

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

View to See Price

View

Add to Cart

Alister & Lloyd Soleil Rouge - Rooib...

only €4,95

View

Add to Cart

Loveinwinter Boîte À Thé en Bois - Boîte...

View to See Price

View

Add to Cart

Mariage Frères - ESPRIT DE NÖEL - Boîte ...

only €27,75

View

Add to Cart

FD Goods LTD Ensemble de 3 - Jouets Sens...

View to See Price

View

Add to Cart

Boîte À Thé En Bois Bambou 8 Compartimen...

only €25,78

View

Add to Cart

MERVY - Boîte à thé - Boîte multifonctio...

only €12,45

View

Add to Cart

Househome Boîte À Thé, Boîte À Thé, Cafe...

View to See Price

View

Add to Cart

Mariage Frères - WEDDING IMPERIAL - Boît...

only €26,75

View

Add to Cart

EZIZB Boîte à thé décorative en Bambou a...

only €22,19

View

Add to Cart

Vivaraise Tapis de Bain Etia

only €32,76

View

Add to Cart

Rowentauk Boîte De Bonbons Boîte À Bonbo...

View to See Price

View

Add to Cart

[Lotus Red] Boîte à thé en céramique Boî...

only €21,00

View

Add to Cart

[Gradient Rouge] Boîte à thé en céramiqu...

only €21,43

View

Add to Cart

Rétro ronde thé café boîte de rangement ...

View to See Price

View

Add to Cart

Bada Bing Boîte métal Boîte à café Boîte...

View to See Price

View

Add to Cart

145 to 162 of 360 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.535817861557	452	1.1270	0

No Amazon API Requests Made.

App Debug - Total Time 1.535817861557 seconds

Number	Time From Start	Name	Description
1	0.38822793960571	Initialise	Initialise FSB Function
2	0.39065480232239	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.41458082199097	Start of getCategoryListByGroup Function	Before first category groups query
4	0.41541385650635	After initial query	Before first category groups query
5	0.41541481018066	Get Category List for Group	Before the call to getCategoryList function
6	0.41541695594788	Start of GetCategoryList function	Start of the function
7	0.41541886329651	Before getting categories	Query to get specific category list
8	0.41626787185669	After getting categories	Query to get specific category list
9	0.41626882553101	Before getting category custom	Before call to function getCategoryCustom
10	0.43132281303406	After getting category custom	After call to function getCategoryCustom
11	0.43132495880127	Before getting category custom	Before call to function getCategoryCustom
12	0.43953990936279	After getting category custom	After call to function getCategoryCustom
13	0.43954086303711	Before getting category custom	Before call to function getCategoryCustom
14	0.443922996521	After getting category custom	After call to function getCategoryCustom
15	0.44392395019531	Before getting category custom	Before call to function getCategoryCustom
16	0.44690895080566	After getting category custom	After call to function getCategoryCustom
17	0.44690990447998	Before getting category custom	Before call to function getCategoryCustom
18	0.44986701011658	After getting category custom	After call to function getCategoryCustom
19	0.44986796379089	Before getting category custom	Before call to function getCategoryCustom
20	0.45301485061646	After getting category custom	After call to function getCategoryCustom
21	0.45301580429077	End of GetCategoryList function	End of the function
22	0.45301985740662	Get Category List for Group	Before the call to getCategoryList function
23	0.45302081108093	Start of GetCategoryList function	Start of the function
24	0.45302200317383	Before getting categories	Query to get specific category list
25	0.45339298248291	End of getCategoryListByGroup Function	Before return()
26	1.3381028175354	App Controller End	End of the App controller (called before the controller of every page)
27	1.4774868488312	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.4783430099487	Before Get Options	Before the call to getOptions in the tpl class
29	1.5148379802704	After Get Options	After the call to getOptions in the tpl class
30	1.5148749351501	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.5358078479767	Finalizing debug	Before the debug is output to the page.
32	1.535817861557	End of App	This is the end of the app logging, final timestamp

Query Debug - 452 Database Queries. Total time 1.1270 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.195\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751785283'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-07-06 07:01:23' WHERE id = '15'
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('216.73.216.195') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.195') <= 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 '3', NOW(), '216.73.216.195'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		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 '3') OR (title LIKE '3'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		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 '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+3' 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 ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		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 '3') OR (title LIKE '3'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		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 '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT * FROM products WHERE id = '1579'
SELECT * FROM productimages WHERE product_id = '1579' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1579' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1579'
SELECT * FROM productcustomimages WHERE product_id = '1579'
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 = '1579'
                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     = '1579'
                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 = 1579
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1579' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1579' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1579' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1579
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1579'
                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 = '1579'
                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     = '1579'
                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 = 1579
SELECT value FROM productattributes WHERE product_id = '1579' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1579'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '1579'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3430' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3430' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3430' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM products WHERE id = '1117'
SELECT * FROM productimages WHERE product_id = '1117' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1117'
SELECT * FROM productcustomimages WHERE product_id = '1117'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1117' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1117' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1117' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1117
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1117'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '4079'
SELECT * FROM productimages WHERE product_id = '4079' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4079'
SELECT * FROM productcustomimages WHERE product_id = '4079'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4079' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4079' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4079' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4079
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4079'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '854'
SELECT * FROM productimages WHERE product_id = '854' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '854'
SELECT * FROM productcustomimages WHERE product_id = '854'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '854' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 854
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '854'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4086'
SELECT * FROM productimages WHERE product_id = '4086' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4086' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4086'
SELECT * FROM productcustomimages WHERE product_id = '4086'
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 = '4086'
                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     = '4086'
                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 = 4086
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4086' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4086' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4086' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4086
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4086'
                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 = '4086'
                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     = '4086'
                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 = 4086
SELECT value FROM productattributes WHERE product_id = '4086' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4086'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '996'
SELECT * FROM productimages WHERE product_id = '996' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '996'
SELECT * FROM productcustomimages WHERE product_id = '996'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '996' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '996' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '996' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 996
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '996'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3628'
SELECT * FROM productimages WHERE product_id = '3628' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3628' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3628'
SELECT * FROM productcustomimages WHERE product_id = '3628'
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 = '3628'
                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     = '3628'
                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 = 3628
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3628' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3628' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3628' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3628
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3628'
                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 = '3628'
                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     = '3628'
                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 = 3628
SELECT value FROM productattributes WHERE product_id = '3628' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3628'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3628'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '3628'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3629' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3629' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3629' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3629
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3629'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3008'
SELECT * FROM productimages WHERE product_id = '3008' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3008'
SELECT * FROM productcustomimages WHERE product_id = '3008'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3008' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3008' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3008' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3008
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3008'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '775'
SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '775'
SELECT * FROM productcustomimages WHERE product_id = '775'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '775' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '775' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '775' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 775
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '775'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2652'
SELECT * FROM productimages WHERE product_id = '2652' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2652' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2652'
SELECT * FROM productcustomimages WHERE product_id = '2652'
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 = '2652'
                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     = '2652'
                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 = 2652
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2652' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2652' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2652' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2652
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2652'
                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 = '2652'
                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     = '2652'
                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 = 2652
SELECT value FROM productattributes WHERE product_id = '2652' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2652'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2652'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '2652'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2655' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2655' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2655' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2655
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2655'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1059'
SELECT * FROM productimages WHERE product_id = '1059' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1059'
SELECT * FROM productcustomimages WHERE product_id = '1059'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1059' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1059' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1059' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1059
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1059'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1059' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3972'
SELECT * FROM productimages WHERE product_id = '3972' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3972'
SELECT * FROM productcustomimages WHERE product_id = '3972'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3972' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3972' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3972' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3972
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3972'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3972' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4262'
SELECT * FROM productimages WHERE product_id = '4262' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4262' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4262'
SELECT * FROM productcustomimages WHERE product_id = '4262'
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 = '4262'
                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     = '4262'
                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 = 4262
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4262' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4262' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4262' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4262
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4262'
                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 = '4262'
                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     = '4262'
                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 = 4262
SELECT value FROM productattributes WHERE product_id = '4262' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4262'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4262'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4262'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4265' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4265' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4265' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM products WHERE id = '2955'
SELECT * FROM productimages WHERE product_id = '2955' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2955' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2955'
SELECT * FROM productcustomimages WHERE product_id = '2955'
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 = '2955'
                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     = '2955'
                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 = 2955
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2955' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2955' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2955' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2955
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2955'
                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 = '2955'
                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     = '2955'
                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 = 2955
SELECT value FROM productattributes WHERE product_id = '2955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2955'
SELECT * FROM products WHERE id = '1650'
SELECT * FROM productimages WHERE product_id = '1650' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1650'
SELECT * FROM productcustomimages WHERE product_id = '1650'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1650' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1650' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1650' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1650
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1650'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1465'
SELECT * FROM productimages WHERE product_id = '1465' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1465'
SELECT * FROM productcustomimages WHERE product_id = '1465'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1465' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1465' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1465' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1465
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1465'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '1884'
SELECT * FROM productimages WHERE product_id = '1884' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1884' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1884'
SELECT * FROM productcustomimages WHERE product_id = '1884'
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 = '1884'
                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     = '1884'
                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 = 1884
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1884' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1884' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1884' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1884
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1884'
                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 = '1884'
                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     = '1884'
                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 = 1884
SELECT value FROM productattributes WHERE product_id = '1884' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1884'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '1884'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1888' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1888' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1888' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1888
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1888'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '782'
SELECT * FROM productimages WHERE product_id = '782' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '782'
SELECT * FROM productcustomimages WHERE product_id = '782'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '782' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '782' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '782' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 782
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '782'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '782' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1579' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1117' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4079' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '854' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4086' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '996' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3628' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3008' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '775' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2652' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1059' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3972' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4262' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2955' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1650' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1465' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1884' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '782' 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.0008	0.00084090232849121	SELECT parameter, value FROM parameters
2	0.0026	0.0025761127471924	SELECT * FROM `bad_bots`
3	0.0002	0.00024676322937012	SET time_zone = 'Europe/London'
4	0.0011	0.0011119842529297	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0011	0.0011360645294189	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.195\";}'
6	0.0008	0.00081396102905273	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751785283'
7	0.0015	0.001533031463623	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0003	0.00033307075500488	UPDATE autorun SET lastrun = '2025-07-06 07:01:23' WHERE id = '15'
9	0.0004	0.00042295455932617	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0011	0.0010530948638916	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0003	0.00030398368835449	SELECT * FROM pages WHERE id = 52
12	0.0020	0.0020380020141602	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0210	0.021047830581665	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0004	0.00041294097900391	SELECT * FROM pages WHERE pagename = 'search'
15	0.0008	0.00083017349243164	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0008	0.00083708763122559	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0057	0.0056791305541992	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
18	0.0010	0.00095295906066895	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19	0.0007	0.00066709518432617	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0003	0.00030303001403809	SELECT id FROM categories WHERE parent_id = '26'
21	0.0049	0.0048611164093018	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
22	0.0008	0.00083613395690918	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
23	0.0007	0.00073385238647461	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
24	0.0007	0.00068402290344238	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0003	0.00028610229492188	SELECT * FROM categorygroups WHERE id = '1'
26	0.0030	0.0030379295349121	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
27	0.0003	0.00032210350036621	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0003	0.00026416778564453	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0003	0.00028896331787109	SELECT id FROM categories WHERE parent_id = '27'
30	0.0030	0.0030012130737305	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
31	0.0003	0.0003359317779541	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
32	0.0003	0.0003349781036377	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
33	0.0003	0.00031304359436035	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0003	0.00029301643371582	SELECT * FROM categorygroups WHERE id = '1'
35	0.0011	0.0010931491851807	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
36	0.0003	0.00031208992004395	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0003	0.00029206275939941	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0003	0.00029611587524414	SELECT id FROM categories WHERE parent_id = '28'
39	0.0012	0.0011579990386963	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
40	0.0003	0.00030994415283203	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
41	0.0003	0.00033187866210938	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
42	0.0003	0.00029802322387695	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0003	0.0002739429473877	SELECT * FROM categorygroups WHERE id = '1'
44	0.0004	0.00037407875061035	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
45	0.0003	0.00029993057250977	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0003	0.0002739429473877	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0003	0.00030803680419922	SELECT id FROM categories WHERE parent_id = '29'
48	0.0004	0.00043106079101562	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
49	0.0003	0.00031614303588867	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
50	0.0003	0.00034403800964355	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
51	0.0003	0.00034904479980469	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0003	0.00027179718017578	SELECT * FROM categorygroups WHERE id = '1'
53	0.0004	0.00036811828613281	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
54	0.0003	0.00030899047851562	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55	0.0003	0.00026106834411621	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0003	0.00030016899108887	SELECT id FROM categories WHERE parent_id = '30'
57	0.0005	0.00045084953308105	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
58	0.0003	0.00031304359436035	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
59	0.0004	0.00035190582275391	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
60	0.0003	0.00030994415283203	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0003	0.00027704238891602	SELECT * FROM categorygroups WHERE id = '1'
62	0.0004	0.0003969669342041	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
63	0.0003	0.0003199577331543	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64	0.0003	0.0002899169921875	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0003	0.00028395652770996	SELECT id FROM categories WHERE parent_id = '31'
66	0.0005	0.00048708915710449	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
67	0.0003	0.00032711029052734	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
68	0.0003	0.00034999847412109	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
69	0.0003	0.00031399726867676	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0003	0.00034689903259277	SELECT * FROM categorygroups WHERE id = '1'
71	0.0004	0.0003669261932373	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0019	0.0018761157989502	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0008	0.00084781646728516	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0004	0.00038385391235352	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
75	0.0007	0.00065302848815918	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0009	0.00091099739074707	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0005	0.00053310394287109	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.8757	0.87572121620178	SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.195') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.195') <= INET_ATON(ip_end)
79	0.0016	0.0015649795532227	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0006	0.0006260871887207	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0004	0.00036811828613281	SELECT * FROM pages WHERE pagename = 'search'
82	0.0047	0.004669189453125	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0014	0.0013570785522461	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0009	0.00086379051208496	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0046	0.0046439170837402	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0013	0.001331090927124	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0004	0.00037217140197754	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0008	0.0007631778717041	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '216.73.216.195'
89	0.0005	0.00046491622924805	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0003	0.00031900405883789	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
91	0.0031	0.0030720233917236	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
92	0.0003	0.00031399726867676	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
93	0.0003	0.00030303001403809	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
94	0.0003	0.00031495094299316	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
95	0.0036	0.0036249160766602	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
96	0.0002	0.0002288818359375	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
97	0.0002	0.0001988410949707	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
98	0.0003	0.0003049373626709	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0003	0.00032305717468262	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0031	0.0030560493469238	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
101	0.0002	0.00023913383483887	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
102	0.0002	0.00021004676818848	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
103	0.0003	0.00031304359436035	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0036	0.0036129951477051	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
105	0.0003	0.00027298927307129	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
106	0.0002	0.00022101402282715	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
107	0.0003	0.00031495094299316	SELECT * FROM products WHERE id = '1579'
108	0.0008	0.00077199935913086	SELECT * FROM productimages WHERE product_id = '1579' ORDER BY sortorder ASC
109	0.0004	0.00037503242492676	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1579' AND p.id = pi.product_id ORDER BY pi.sortorder
110	0.0008	0.00082087516784668	SELECT * FROM product_image_select WHERE product_id = '1579'
111	0.0006	0.00056195259094238	SELECT * FROM productcustomimages WHERE product_id = '1579'
112	0.0008	0.00079607963562012	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 = '1579' GROUP BY o.product_id
113	0.0011	0.0010948181152344	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 = '1579' GROUP BY n.displayname ORDER BY n.displayname DESC
114	0.0003	0.00033903121948242	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1579
115	0.0010	0.0010299682617188	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1579' AND a.name = n.originalname
116	0.0003	0.00033211708068848	SELECT * FROM productoffers WHERE product_id = '1579' AND merchantid = 'A1X6FK5RDHNB96'
117	0.0002	0.00024819374084473	SELECT * FROM productoffers WHERE product_id = '1579' AND price > 0 ORDER BY price ASC LIMIT 1
118	0.0002	0.0002288818359375	SELECT * FROM productoffers WHERE product_id = 1579 ORDER BY price ASC LIMIT 1
119	0.0003	0.00025486946105957	SELECT value FROM productattributes WHERE product_id = '1579' AND name = 'ListPriceAmount'
120	0.0004	0.00037193298339844	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 = '1579' GROUP BY o.product_id
121	0.0004	0.00040102005004883	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 = '1579' GROUP BY n.displayname ORDER BY n.displayname DESC
122	0.0003	0.00026392936706543	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1579
123	0.0003	0.00033903121948242	SELECT value FROM productattributes WHERE product_id = '1579' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124	0.0004	0.00036811828613281	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1579' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
125	0.0003	0.00025796890258789	SELECT * FROM products WHERE parent_id = '1579'
126	0.0004	0.00038504600524902	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3430' AND a.name = n.originalname
127	0.0003	0.00032210350036621	SELECT * FROM productoffers WHERE product_id = '3430' AND merchantid = 'A1X6FK5RDHNB96'
128	0.0003	0.00026702880859375	SELECT * FROM productoffers WHERE product_id = '3430' AND price > 0 ORDER BY price ASC LIMIT 1
129	0.0003	0.00028300285339355	SELECT * FROM products WHERE id = '1117'
130	0.0003	0.0003209114074707	SELECT * FROM productimages WHERE product_id = '1117' ORDER BY sortorder ASC
131	0.0004	0.00043201446533203	SELECT * FROM product_image_select WHERE product_id = '1117'
132	0.0003	0.00027918815612793	SELECT * FROM productcustomimages WHERE product_id = '1117'
133	0.0008	0.00077486038208008	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1117' AND a.name = n.originalname
134	0.0003	0.00031805038452148	SELECT * FROM productoffers WHERE product_id = '1117' AND merchantid = 'A1X6FK5RDHNB96'
135	0.0003	0.00025010108947754	SELECT * FROM productoffers WHERE product_id = '1117' AND price > 0 ORDER BY price ASC LIMIT 1
136	0.0002	0.00022506713867188	SELECT * FROM productoffers WHERE product_id = 1117 ORDER BY price ASC LIMIT 1
137	0.0002	0.000244140625	SELECT value FROM productattributes WHERE product_id = '1117' AND name = 'ListPriceAmount'
138	0.0003	0.00033378601074219	SELECT * FROM products WHERE id = '4079'
139	0.0004	0.00035190582275391	SELECT * FROM productimages WHERE product_id = '4079' ORDER BY sortorder ASC
140	0.0004	0.00042605400085449	SELECT * FROM product_image_select WHERE product_id = '4079'
141	0.0004	0.00037789344787598	SELECT * FROM productcustomimages WHERE product_id = '4079'
142	0.0010	0.0009911060333252	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4079' AND a.name = n.originalname
143	0.0003	0.00031495094299316	SELECT * FROM productoffers WHERE product_id = '4079' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0003	0.0002751350402832	SELECT * FROM productoffers WHERE product_id = '4079' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0002	0.00022792816162109	SELECT * FROM productoffers WHERE product_id = 4079 ORDER BY price ASC LIMIT 1
146	0.0002	0.00023984909057617	SELECT value FROM productattributes WHERE product_id = '4079' AND name = 'ListPriceAmount'
147	0.0003	0.00025796890258789	SELECT value FROM productattributes WHERE product_id = '4079' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148	0.0003	0.00032806396484375	SELECT * FROM products WHERE id = '854'
149	0.0003	0.0003049373626709	SELECT * FROM productimages WHERE product_id = '854' ORDER BY sortorder ASC
150	0.0004	0.00044894218444824	SELECT * FROM product_image_select WHERE product_id = '854'
151	0.0003	0.00026392936706543	SELECT * FROM productcustomimages WHERE product_id = '854'
152	0.0006	0.00063800811767578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '854' AND a.name = n.originalname
153	0.0003	0.00032186508178711	SELECT * FROM productoffers WHERE product_id = '854' AND merchantid = 'A1X6FK5RDHNB96'
154	0.0002	0.000244140625	SELECT * FROM productoffers WHERE product_id = '854' AND price > 0 ORDER BY price ASC LIMIT 1
155	0.0002	0.00022292137145996	SELECT * FROM productoffers WHERE product_id = 854 ORDER BY price ASC LIMIT 1
156	0.0002	0.00023293495178223	SELECT value FROM productattributes WHERE product_id = '854' AND name = 'ListPriceAmount'
157	0.0004	0.00038790702819824	SELECT value FROM productattributes WHERE product_id = '854' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
158	0.0004	0.00037002563476562	SELECT * FROM products WHERE id = '4086'
159	0.0004	0.00035381317138672	SELECT * FROM productimages WHERE product_id = '4086' ORDER BY sortorder ASC
160	0.0004	0.00039005279541016	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4086' AND p.id = pi.product_id ORDER BY pi.sortorder
161	0.0006	0.00055408477783203	SELECT * FROM product_image_select WHERE product_id = '4086'
162	0.0003	0.00031208992004395	SELECT * FROM productcustomimages WHERE product_id = '4086'
163	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 = '4086' GROUP BY o.product_id
164	0.0005	0.00048589706420898	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 = '4086' GROUP BY n.displayname ORDER BY n.displayname DESC
165	0.0003	0.00029993057250977	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4086
166	0.0007	0.00074601173400879	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4086' AND a.name = n.originalname
167	0.0002	0.00023388862609863	SELECT * FROM productoffers WHERE product_id = '4086' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0003	0.00025796890258789	SELECT * FROM productoffers WHERE product_id = '4086' AND price > 0 ORDER BY price ASC LIMIT 1
169	0.0002	0.00022792816162109	SELECT * FROM productoffers WHERE product_id = 4086 ORDER BY price ASC LIMIT 1
170	0.0003	0.00025200843811035	SELECT value FROM productattributes WHERE product_id = '4086' AND name = 'ListPriceAmount'
171	0.0003	0.0002741813659668	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 = '4086' GROUP BY o.product_id
172	0.0004	0.00040006637573242	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 = '4086' GROUP BY n.displayname ORDER BY n.displayname DESC
173	0.0003	0.00028491020202637	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4086
174	0.0003	0.00033402442932129	SELECT value FROM productattributes WHERE product_id = '4086' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175	0.0004	0.00036811828613281	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4086' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
176	0.0003	0.00025606155395508	SELECT * FROM products WHERE id = '996'
177	0.0003	0.00029802322387695	SELECT * FROM productimages WHERE product_id = '996' ORDER BY sortorder ASC
178	0.0005	0.00054287910461426	SELECT * FROM product_image_select WHERE product_id = '996'
179	0.0003	0.00028300285339355	SELECT * FROM productcustomimages WHERE product_id = '996'
180	0.0007	0.00068402290344238	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '996' AND a.name = n.originalname
181	0.0004	0.00035881996154785	SELECT * FROM productoffers WHERE product_id = '996' AND merchantid = 'A1X6FK5RDHNB96'
182	0.0003	0.00034809112548828	SELECT * FROM productoffers WHERE product_id = '996' AND price > 0 ORDER BY price ASC LIMIT 1
183	0.0003	0.00026297569274902	SELECT * FROM productoffers WHERE product_id = 996 ORDER BY price ASC LIMIT 1
184	0.0003	0.00031495094299316	SELECT value FROM productattributes WHERE product_id = '996' AND name = 'ListPriceAmount'
185	0.0004	0.0004270076751709	SELECT * FROM products WHERE id = '3628'
186	0.0004	0.00044107437133789	SELECT * FROM productimages WHERE product_id = '3628' ORDER BY sortorder ASC
187	0.0004	0.00036001205444336	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3628' AND p.id = pi.product_id ORDER BY pi.sortorder
188	0.0005	0.0005030632019043	SELECT * FROM product_image_select WHERE product_id = '3628'
189	0.0003	0.00027585029602051	SELECT * FROM productcustomimages WHERE product_id = '3628'
190	0.0004	0.00043702125549316	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 = '3628' GROUP BY o.product_id
191	0.0008	0.00079989433288574	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 = '3628' GROUP BY n.displayname ORDER BY n.displayname DESC
192	0.0004	0.0003969669342041	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3628
193	0.0008	0.00081300735473633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3628' AND a.name = n.originalname
194	0.0003	0.00030398368835449	SELECT * FROM productoffers WHERE product_id = '3628' AND merchantid = 'A1X6FK5RDHNB96'
195	0.0003	0.00030398368835449	SELECT * FROM productoffers WHERE product_id = '3628' AND price > 0 ORDER BY price ASC LIMIT 1
196	0.0005	0.00047206878662109	SELECT * FROM productoffers WHERE product_id = 3628 ORDER BY price ASC LIMIT 1
197	0.0002	0.00024819374084473	SELECT value FROM productattributes WHERE product_id = '3628' AND name = 'ListPriceAmount'
198	0.0003	0.00031495094299316	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 = '3628' GROUP BY o.product_id
199	0.0006	0.00063896179199219	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 = '3628' GROUP BY n.displayname ORDER BY n.displayname DESC
200	0.0003	0.00034499168395996	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3628
201	0.0006	0.00056195259094238	SELECT value FROM productattributes WHERE product_id = '3628' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202	0.0005	0.00047707557678223	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3628' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
203	0.0004	0.00039911270141602	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3628' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
204	0.0003	0.00033712387084961	SELECT * FROM products WHERE parent_id = '3628'
205	0.0006	0.00055694580078125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3629' AND a.name = n.originalname
206	0.0003	0.00032305717468262	SELECT * FROM productoffers WHERE product_id = '3629' AND merchantid = 'A1X6FK5RDHNB96'
207	0.0003	0.00031614303588867	SELECT * FROM productoffers WHERE product_id = '3629' AND price > 0 ORDER BY price ASC LIMIT 1
208	0.0003	0.00026702880859375	SELECT * FROM productoffers WHERE product_id = 3629 ORDER BY price ASC LIMIT 1
209	0.0002	0.00024700164794922	SELECT value FROM productattributes WHERE product_id = '3629' AND name = 'ListPriceAmount'
210	0.0003	0.00032401084899902	SELECT * FROM products WHERE id = '3008'
211	0.0004	0.00040388107299805	SELECT * FROM productimages WHERE product_id = '3008' ORDER BY sortorder ASC
212	0.0005	0.00048279762268066	SELECT * FROM product_image_select WHERE product_id = '3008'
213	0.0003	0.00029301643371582	SELECT * FROM productcustomimages WHERE product_id = '3008'
214	0.0009	0.00088906288146973	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3008' AND a.name = n.originalname
215	0.0003	0.00032591819763184	SELECT * FROM productoffers WHERE product_id = '3008' AND merchantid = 'A1X6FK5RDHNB96'
216	0.0002	0.00024795532226562	SELECT * FROM productoffers WHERE product_id = '3008' AND price > 0 ORDER BY price ASC LIMIT 1
217	0.0003	0.00026392936706543	SELECT * FROM productoffers WHERE product_id = 3008 ORDER BY price ASC LIMIT 1
218	0.0003	0.00025200843811035	SELECT value FROM productattributes WHERE product_id = '3008' AND name = 'ListPriceAmount'
219	0.0004	0.0003819465637207	SELECT value FROM productattributes WHERE product_id = '3008' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220	0.0004	0.00036001205444336	SELECT * FROM products WHERE id = '775'
221	0.0003	0.00030779838562012	SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
222	0.0004	0.00044584274291992	SELECT * FROM product_image_select WHERE product_id = '775'
223	0.0003	0.00026178359985352	SELECT * FROM productcustomimages WHERE product_id = '775'
224	0.0007	0.00067806243896484	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '775' AND a.name = n.originalname
225	0.0003	0.00032281875610352	SELECT * FROM productoffers WHERE product_id = '775' AND merchantid = 'A1X6FK5RDHNB96'
226	0.0003	0.00025486946105957	SELECT * FROM productoffers WHERE product_id = '775' AND price > 0 ORDER BY price ASC LIMIT 1
227	0.0002	0.0002291202545166	SELECT * FROM productoffers WHERE product_id = 775 ORDER BY price ASC LIMIT 1
228	0.0002	0.0002288818359375	SELECT value FROM productattributes WHERE product_id = '775' AND name = 'ListPriceAmount'
229	0.0002	0.0002439022064209	SELECT value FROM productattributes WHERE product_id = '775' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230	0.0003	0.0003349781036377	SELECT * FROM products WHERE id = '2652'
231	0.0004	0.0003509521484375	SELECT * FROM productimages WHERE product_id = '2652' ORDER BY sortorder ASC
232	0.0003	0.00032186508178711	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2652' AND p.id = pi.product_id ORDER BY pi.sortorder
233	0.0005	0.0004580020904541	SELECT * FROM product_image_select WHERE product_id = '2652'
234	0.0003	0.0002739429473877	SELECT * FROM productcustomimages WHERE product_id = '2652'
235	0.0003	0.00032997131347656	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 = '2652' GROUP BY o.product_id
236	0.0004	0.0003969669342041	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 = '2652' GROUP BY n.displayname ORDER BY n.displayname DESC
237	0.0003	0.00027894973754883	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2652
238	0.0008	0.00079488754272461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2652' AND a.name = n.originalname
239	0.0002	0.00023508071899414	SELECT * FROM productoffers WHERE product_id = '2652' AND merchantid = 'A1X6FK5RDHNB96'
240	0.0002	0.00024199485778809	SELECT * FROM productoffers WHERE product_id = '2652' AND price > 0 ORDER BY price ASC LIMIT 1
241	0.0002	0.00022387504577637	SELECT * FROM productoffers WHERE product_id = 2652 ORDER BY price ASC LIMIT 1
242	0.0003	0.00025105476379395	SELECT value FROM productattributes WHERE product_id = '2652' AND name = 'ListPriceAmount'
243	0.0004	0.00041484832763672	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 = '2652' GROUP BY o.product_id
244	0.0007	0.00069212913513184	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 = '2652' GROUP BY n.displayname ORDER BY n.displayname DESC
245	0.0003	0.00026798248291016	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2652
246	0.0003	0.0003359317779541	SELECT value FROM productattributes WHERE product_id = '2652' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247	0.0004	0.00039100646972656	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2652' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
248	0.0003	0.00033712387084961	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2652' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
249	0.0003	0.00030803680419922	SELECT * FROM products WHERE parent_id = '2652'
250	0.0003	0.00033712387084961	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2655' AND a.name = n.originalname
251	0.0003	0.00030207633972168	SELECT * FROM productoffers WHERE product_id = '2655' AND merchantid = 'A1X6FK5RDHNB96'
252	0.0002	0.0002439022064209	SELECT * FROM productoffers WHERE product_id = '2655' AND price > 0 ORDER BY price ASC LIMIT 1
253	0.0002	0.00023794174194336	SELECT * FROM productoffers WHERE product_id = 2655 ORDER BY price ASC LIMIT 1
254	0.0002	0.00023698806762695	SELECT value FROM productattributes WHERE product_id = '2655' AND name = 'ListPriceAmount'
255	0.0003	0.00025296211242676	SELECT * FROM products WHERE id = '1059'
256	0.0003	0.00028800964355469	SELECT * FROM productimages WHERE product_id = '1059' ORDER BY sortorder ASC
257	0.0004	0.00043296813964844	SELECT * FROM product_image_select WHERE product_id = '1059'
258	0.0003	0.00027108192443848	SELECT * FROM productcustomimages WHERE product_id = '1059'
259	0.0007	0.00068402290344238	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1059' AND a.name = n.originalname
260	0.0004	0.0003509521484375	SELECT * FROM productoffers WHERE product_id = '1059' AND merchantid = 'A1X6FK5RDHNB96'
261	0.0003	0.00026106834411621	SELECT * FROM productoffers WHERE product_id = '1059' AND price > 0 ORDER BY price ASC LIMIT 1
262	0.0002	0.00022697448730469	SELECT * FROM productoffers WHERE product_id = 1059 ORDER BY price ASC LIMIT 1
263	0.0002	0.00023388862609863	SELECT value FROM productattributes WHERE product_id = '1059' AND name = 'ListPriceAmount'
264	0.0003	0.00025510787963867	SELECT value FROM productattributes WHERE product_id = '1059' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265	0.0004	0.0003809928894043	SELECT * FROM products WHERE id = '3972'
266	0.0003	0.00031399726867676	SELECT * FROM productimages WHERE product_id = '3972' ORDER BY sortorder ASC
267	0.0005	0.00045514106750488	SELECT * FROM product_image_select WHERE product_id = '3972'
268	0.0003	0.00026798248291016	SELECT * FROM productcustomimages WHERE product_id = '3972'
269	0.0007	0.00066590309143066	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3972' AND a.name = n.originalname
270	0.0003	0.00029301643371582	SELECT * FROM productoffers WHERE product_id = '3972' AND merchantid = 'A1X6FK5RDHNB96'
271	0.0003	0.00026702880859375	SELECT * FROM productoffers WHERE product_id = '3972' AND price > 0 ORDER BY price ASC LIMIT 1
272	0.0003	0.00029301643371582	SELECT * FROM productoffers WHERE product_id = 3972 ORDER BY price ASC LIMIT 1
273	0.0003	0.0002601146697998	SELECT value FROM productattributes WHERE product_id = '3972' AND name = 'ListPriceAmount'
274	0.0003	0.00025415420532227	SELECT value FROM productattributes WHERE product_id = '3972' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275	0.0005	0.00051188468933105	SELECT * FROM products WHERE id = '4262'
276	0.0003	0.00031590461730957	SELECT * FROM productimages WHERE product_id = '4262' ORDER BY sortorder ASC
277	0.0003	0.00027608871459961	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4262' AND p.id = pi.product_id ORDER BY pi.sortorder
278	0.0006	0.00059199333190918	SELECT * FROM product_image_select WHERE product_id = '4262'
279	0.0003	0.00027585029602051	SELECT * FROM productcustomimages WHERE product_id = '4262'
280	0.0004	0.00037407875061035	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 = '4262' GROUP BY o.product_id
281	0.0004	0.00039505958557129	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 = '4262' GROUP BY n.displayname ORDER BY n.displayname DESC
282	0.0003	0.00027608871459961	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4262
283	0.0007	0.0007319450378418	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4262' AND a.name = n.originalname
284	0.0003	0.00025796890258789	SELECT * FROM productoffers WHERE product_id = '4262' AND merchantid = 'A1X6FK5RDHNB96'
285	0.0002	0.00024104118347168	SELECT * FROM productoffers WHERE product_id = '4262' AND price > 0 ORDER BY price ASC LIMIT 1
286	0.0002	0.00022506713867188	SELECT * FROM productoffers WHERE product_id = 4262 ORDER BY price ASC LIMIT 1
287	0.0003	0.00027704238891602	SELECT value FROM productattributes WHERE product_id = '4262' AND name = 'ListPriceAmount'
288	0.0003	0.00030303001403809	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 = '4262' GROUP BY o.product_id
289	0.0004	0.00039005279541016	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 = '4262' GROUP BY n.displayname ORDER BY n.displayname DESC
290	0.0003	0.0002748966217041	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4262
291	0.0004	0.00035285949707031	SELECT value FROM productattributes WHERE product_id = '4262' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292	0.0004	0.00038003921508789	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4262' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
293	0.0003	0.00030708312988281	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4262' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
294	0.0003	0.00030899047851562	SELECT * FROM products WHERE parent_id = '4262'
295	0.0003	0.00034093856811523	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4265' AND a.name = n.originalname
296	0.0003	0.00034594535827637	SELECT * FROM productoffers WHERE product_id = '4265' AND merchantid = 'A1X6FK5RDHNB96'
297	0.0003	0.00028300285339355	SELECT * FROM productoffers WHERE product_id = '4265' AND price > 0 ORDER BY price ASC LIMIT 1
298	0.0003	0.0002589225769043	SELECT * FROM products WHERE id = '2955'
299	0.0003	0.00031900405883789	SELECT * FROM productimages WHERE product_id = '2955' ORDER BY sortorder ASC
300	0.0003	0.00028109550476074	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2955' AND p.id = pi.product_id ORDER BY pi.sortorder
301	0.0004	0.00044798851013184	SELECT * FROM product_image_select WHERE product_id = '2955'
302	0.0004	0.00041913986206055	SELECT * FROM productcustomimages WHERE product_id = '2955'
303	0.0004	0.00036001205444336	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 = '2955' GROUP BY o.product_id
304	0.0006	0.00062394142150879	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 = '2955' GROUP BY n.displayname ORDER BY n.displayname DESC
305	0.0003	0.00029802322387695	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2955
306	0.0007	0.0006868839263916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2955' AND a.name = n.originalname
307	0.0002	0.00024509429931641	SELECT * FROM productoffers WHERE product_id = '2955' AND merchantid = 'A1X6FK5RDHNB96'
308	0.0003	0.00025510787963867	SELECT * FROM productoffers WHERE product_id = '2955' AND price > 0 ORDER BY price ASC LIMIT 1
309	0.0003	0.00026202201843262	SELECT * FROM productoffers WHERE product_id = 2955 ORDER BY price ASC LIMIT 1
310	0.0002	0.00024008750915527	SELECT value FROM productattributes WHERE product_id = '2955' AND name = 'ListPriceAmount'
311	0.0003	0.00025200843811035	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 = '2955' GROUP BY o.product_id
312	0.0004	0.00036501884460449	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 = '2955' GROUP BY n.displayname ORDER BY n.displayname DESC
313	0.0002	0.00023579597473145	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2955
314	0.0003	0.00032401084899902	SELECT value FROM productattributes WHERE product_id = '2955' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
315	0.0003	0.00025010108947754	SELECT * FROM products WHERE parent_id = '2955'
316	0.0002	0.00024509429931641	SELECT * FROM products WHERE id = '1650'
317	0.0003	0.00029397010803223	SELECT * FROM productimages WHERE product_id = '1650' ORDER BY sortorder ASC
318	0.0004	0.00044798851013184	SELECT * FROM product_image_select WHERE product_id = '1650'
319	0.0003	0.00029993057250977	SELECT * FROM productcustomimages WHERE product_id = '1650'
320	0.0007	0.0006868839263916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1650' AND a.name = n.originalname
321	0.0003	0.00032186508178711	SELECT * FROM productoffers WHERE product_id = '1650' AND merchantid = 'A1X6FK5RDHNB96'
322	0.0003	0.00026082992553711	SELECT * FROM productoffers WHERE product_id = '1650' AND price > 0 ORDER BY price ASC LIMIT 1
323	0.0002	0.00024294853210449	SELECT * FROM productoffers WHERE product_id = 1650 ORDER BY price ASC LIMIT 1
324	0.0002	0.000244140625	SELECT value FROM productattributes WHERE product_id = '1650' AND name = 'ListPriceAmount'
325	0.0003	0.00032806396484375	SELECT * FROM products WHERE id = '1465'
326	0.0003	0.00031185150146484	SELECT * FROM productimages WHERE product_id = '1465' ORDER BY sortorder ASC
327	0.0006	0.0005948543548584	SELECT * FROM product_image_select WHERE product_id = '1465'
328	0.0003	0.00028705596923828	SELECT * FROM productcustomimages WHERE product_id = '1465'
329	0.0008	0.00075912475585938	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1465' AND a.name = n.originalname
330	0.0003	0.00029587745666504	SELECT * FROM productoffers WHERE product_id = '1465' AND merchantid = 'A1X6FK5RDHNB96'
331	0.0003	0.00026702880859375	SELECT * FROM productoffers WHERE product_id = '1465' AND price > 0 ORDER BY price ASC LIMIT 1
332	0.0002	0.00023484230041504	SELECT * FROM productoffers WHERE product_id = 1465 ORDER BY price ASC LIMIT 1
333	0.0003	0.00025701522827148	SELECT value FROM productattributes WHERE product_id = '1465' AND name = 'ListPriceAmount'
334	0.0003	0.00033283233642578	SELECT * FROM products WHERE id = '1884'
335	0.0003	0.00028300285339355	SELECT * FROM productimages WHERE product_id = '1884' ORDER BY sortorder ASC
336	0.0003	0.00027108192443848	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1884' AND p.id = pi.product_id ORDER BY pi.sortorder
337	0.0005	0.00045204162597656	SELECT * FROM product_image_select WHERE product_id = '1884'
338	0.0003	0.00026893615722656	SELECT * FROM productcustomimages WHERE product_id = '1884'
339	0.0003	0.00034999847412109	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 = '1884' GROUP BY o.product_id
340	0.0004	0.00038385391235352	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 = '1884' GROUP BY n.displayname ORDER BY n.displayname DESC
341	0.0003	0.00026988983154297	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1884
342	0.0008	0.00084209442138672	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1884' AND a.name = n.originalname
343	0.0003	0.00032782554626465	SELECT * FROM productoffers WHERE product_id = '1884' AND merchantid = 'A1X6FK5RDHNB96'
344	0.0003	0.0002601146697998	SELECT * FROM productoffers WHERE product_id = '1884' AND price > 0 ORDER BY price ASC LIMIT 1
345	0.0002	0.00023198127746582	SELECT * FROM productoffers WHERE product_id = 1884 ORDER BY price ASC LIMIT 1
346	0.0002	0.00023794174194336	SELECT value FROM productattributes WHERE product_id = '1884' AND name = 'ListPriceAmount'
347	0.0003	0.00025796890258789	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 = '1884' GROUP BY o.product_id
348	0.0005	0.00050497055053711	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 = '1884' GROUP BY n.displayname ORDER BY n.displayname DESC
349	0.0010	0.0010349750518799	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1884
350	0.0009	0.00088095664978027	SELECT value FROM productattributes WHERE product_id = '1884' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
351	0.0004	0.00039005279541016	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1884' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
352	0.0003	0.00029492378234863	SELECT * FROM products WHERE parent_id = '1884'
353	0.0003	0.00034713745117188	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1888' AND a.name = n.originalname
354	0.0008	0.00083780288696289	SELECT * FROM productoffers WHERE product_id = '1888' AND merchantid = 'A1X6FK5RDHNB96'
355	0.0002	0.00024318695068359	SELECT * FROM productoffers WHERE product_id = '1888' AND price > 0 ORDER BY price ASC LIMIT 1
356	0.0002	0.00023794174194336	SELECT * FROM productoffers WHERE product_id = 1888 ORDER BY price ASC LIMIT 1
357	0.0002	0.00024890899658203	SELECT value FROM productattributes WHERE product_id = '1888' AND name = 'ListPriceAmount'
358	0.0003	0.00030708312988281	SELECT * FROM products WHERE id = '782'
359	0.0003	0.00032496452331543	SELECT * FROM productimages WHERE product_id = '782' ORDER BY sortorder ASC
360	0.0004	0.00042915344238281	SELECT * FROM product_image_select WHERE product_id = '782'
361	0.0003	0.00027108192443848	SELECT * FROM productcustomimages WHERE product_id = '782'
362	0.0015	0.0014748573303223	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '782' AND a.name = n.originalname
363	0.0003	0.00031113624572754	SELECT * FROM productoffers WHERE product_id = '782' AND merchantid = 'A1X6FK5RDHNB96'
364	0.0002	0.00023913383483887	SELECT * FROM productoffers WHERE product_id = '782' AND price > 0 ORDER BY price ASC LIMIT 1
365	0.0002	0.00023794174194336	SELECT * FROM productoffers WHERE product_id = 782 ORDER BY price ASC LIMIT 1
366	0.0003	0.0002598762512207	SELECT value FROM productattributes WHERE product_id = '782' AND name = 'ListPriceAmount'
367	0.0002	0.00024914741516113	SELECT value FROM productattributes WHERE product_id = '782' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368	0.0008	0.0008089542388916	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1579' ORDER BY timestamp DESC
369	0.0002	0.00021004676818848	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1117' ORDER BY timestamp DESC
370	0.0003	0.00025105476379395	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4079' ORDER BY timestamp DESC
371	0.0002	0.00023221969604492	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '854' ORDER BY timestamp DESC
372	0.0002	0.00021100044250488	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4086' ORDER BY timestamp DESC
373	0.0002	0.00019598007202148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '996' ORDER BY timestamp DESC
374	0.0002	0.00021505355834961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3628' ORDER BY timestamp DESC
375	0.0002	0.00020480155944824	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3008' ORDER BY timestamp DESC
376	0.0002	0.0001990795135498	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '775' ORDER BY timestamp DESC
377	0.0002	0.00019311904907227	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2652' ORDER BY timestamp DESC
378	0.0002	0.00019693374633789	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1059' ORDER BY timestamp DESC
379	0.0002	0.0001978874206543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3972' ORDER BY timestamp DESC
380	0.0002	0.00019001960754395	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4262' ORDER BY timestamp DESC
381	0.0002	0.00018906593322754	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2955' ORDER BY timestamp DESC
382	0.0002	0.00020098686218262	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1650' ORDER BY timestamp DESC
383	0.0002	0.00019001960754395	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1465' ORDER BY timestamp DESC
384	0.0002	0.00018906593322754	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1884' ORDER BY timestamp DESC
385	0.0002	0.00018715858459473	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '782' ORDER BY timestamp DESC
386	0.0008	0.00079107284545898	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
387	0.0006	0.00058102607727051	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
388	0.0002	0.00023913383483887	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
389	0.0114	0.011414051055908	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
390	0.0008	0.00084400177001953	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
391	0.0003	0.00034499168395996	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
392	0.0003	0.00033283233642578	SELECT * FROM products WHERE id = 1626
393	0.0002	0.00024104118347168	SELECT * FROM products WHERE id = 4041
394	0.0002	0.00022697448730469	SELECT * FROM products WHERE id = 4312
395	0.0002	0.00024008750915527	SELECT * FROM products WHERE id = 777
396	0.0002	0.00023198127746582	SELECT * FROM products WHERE id = 3881
397	0.0002	0.00022697448730469	SELECT * FROM products WHERE id = 4213
398	0.0002	0.00023007392883301	SELECT * FROM products WHERE id = '1626'
399	0.0003	0.00030708312988281	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
400	0.0004	0.00043106079101562	SELECT * FROM product_image_select WHERE product_id = '1626'
401	0.0003	0.00025510787963867	SELECT * FROM productcustomimages WHERE product_id = '1626'
402	0.0006	0.00055694580078125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
403	0.0003	0.00030708312988281	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
404	0.0003	0.0002601146697998	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
405	0.0003	0.00026917457580566	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
406	0.0003	0.00032210350036621	SELECT * FROM products WHERE id = '4041'
407	0.0003	0.00028800964355469	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
408	0.0004	0.00042414665222168	SELECT * FROM product_image_select WHERE product_id = '4041'
409	0.0002	0.00024890899658203	SELECT * FROM productcustomimages WHERE product_id = '4041'
410	0.0007	0.00072813034057617	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
411	0.0003	0.00031208992004395	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
412	0.0003	0.00025200843811035	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
413	0.0003	0.00025701522827148	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
414	0.0003	0.00030994415283203	SELECT * FROM products WHERE id = '4312'
415	0.0003	0.00029397010803223	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
416	0.0004	0.00041913986206055	SELECT * FROM product_image_select WHERE product_id = '4312'
417	0.0003	0.00025606155395508	SELECT * FROM productcustomimages WHERE product_id = '4312'
418	0.0006	0.00063610076904297	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
419	0.0003	0.00029301643371582	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
420	0.0003	0.00025391578674316	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
421	0.0003	0.0002589225769043	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
422	0.0003	0.00031113624572754	SELECT * FROM products WHERE id = '777'
423	0.0003	0.00029897689819336	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
424	0.0004	0.00041890144348145	SELECT * FROM product_image_select WHERE product_id = '777'
425	0.0002	0.00024890899658203	SELECT * FROM productcustomimages WHERE product_id = '777'
426	0.0006	0.00063204765319824	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
427	0.0003	0.00029706954956055	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
428	0.0002	0.00024986267089844	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
429	0.0002	0.00024986267089844	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
430	0.0003	0.00031113624572754	SELECT * FROM products WHERE id = '3881'
431	0.0003	0.0003349781036377	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
432	0.0004	0.00043487548828125	SELECT * FROM product_image_select WHERE product_id = '3881'
433	0.0003	0.00033903121948242	SELECT * FROM productcustomimages WHERE product_id = '3881'
434	0.0007	0.00072097778320312	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
435	0.0003	0.00034999847412109	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
436	0.0003	0.00027203559875488	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
437	0.0003	0.00026607513427734	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
438	0.0004	0.00036191940307617	SELECT * FROM products WHERE id = '4213'
439	0.0004	0.00038003921508789	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
440	0.0004	0.00043606758117676	SELECT * FROM product_image_select WHERE product_id = '4213'
441	0.0003	0.00029492378234863	SELECT * FROM productcustomimages WHERE product_id = '4213'
442	0.0007	0.0007021427154541	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
443	0.0003	0.0003049373626709	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
444	0.0003	0.00025701522827148	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
445	0.0003	0.00029802322387695	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
446	0.0010	0.00097107887268066	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
447	0.0005	0.00045895576477051	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
448	0.0014	0.0014269351959229	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
449	0.0008	0.00079798698425293	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
450	0.0003	0.00033211708068848	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
451	0.0004	0.00041007995605469	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
452	0.0004	0.00039005279541016	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "3"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.535817861557 seconds

Query Debug - 452 Database Queries. Total time 1.1270 seconds