Search Results for "2"

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

only €29,90

View

Add to Cart

Vivaraise Coussin Zeff Coco

from €20,90

View

Add to Cart

Coffret Rooibos Détente - La Route des C...

View to See Price

View

Add to Cart

Thé "Coba Cabana" - Rooibos Bi...

only €10,90

View

Add to Cart

Edredon Zeff Masai 80 x 180 cm Vivaraise

View to See Price

View

Add to Cart

mikken Boîte à café Expresso Boîte Boîte...

only €17,68

View

Add to Cart

Dragonfly Organic Tea Cape Malay Rooibos...

View to See Price

View

Add to Cart

Pagès Thé Vert BIO 20 sachets fraîcheur-...

only €4,80

View

Add to Cart

Red Espresso (250g Rooibos - thé Rouge -...

only €14,99

View

Add to Cart

Kesper 58901 Boîte pour Thé avec 10 Comp...

only €20,42

View

Add to Cart

Fleur d'Oranger – Carré de style rétro/v...

View to See Price

View

Add to Cart

Vintage bois flotté – Let's Have Thé – S...

only €14,63

View

Add to Cart

NATIVES 610180 Ton ami Boîte à thé de 6 ...

View to See Price

View

Add to Cart

Tedemecum Thé Rooibos Flor Del Desierto ...

only €9,90

View

Add to Cart

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

View to See Price

View

Add to Cart

La Route Des Comptoirs - Rooïbos Nature ...

only €12,55

View

Add to Cart

La Route Des Comptoirs - Thé Rooïbos Rev...

only €11,95

View

Add to Cart

La Route Des Comptoirs - Rooïbos Safari ...

only €13,35

View

Add to Cart

217 to 234 of 532 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.6965820789337	402	1.0505	0

No Amazon API Requests Made.

App Debug - Total Time 1.6965820789337 seconds

Number	Time From Start	Name	Description
1	0.36308598518372	Initialise	Initialise FSB Function
2	0.37074017524719	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.42730116844177	Start of getCategoryListByGroup Function	Before first category groups query
4	0.42908310890198	After initial query	Before first category groups query
5	0.42908406257629	Get Category List for Group	Before the call to getCategoryList function
6	0.42908716201782	Start of GetCategoryList function	Start of the function
7	0.42909002304077	Before getting categories	Query to get specific category list
8	0.43100094795227	After getting categories	Query to get specific category list
9	0.43100309371948	Before getting category custom	Before call to function getCategoryCustom
10	0.45420217514038	After getting category custom	After call to function getCategoryCustom
11	0.45420598983765	Before getting category custom	Before call to function getCategoryCustom
12	0.46729707717896	After getting category custom	After call to function getCategoryCustom
13	0.46730208396912	Before getting category custom	Before call to function getCategoryCustom
14	0.47431802749634	After getting category custom	After call to function getCategoryCustom
15	0.47432112693787	Before getting category custom	Before call to function getCategoryCustom
16	0.47950506210327	After getting category custom	After call to function getCategoryCustom
17	0.47950911521912	Before getting category custom	Before call to function getCategoryCustom
18	0.48490214347839	After getting category custom	After call to function getCategoryCustom
19	0.48490500450134	Before getting category custom	Before call to function getCategoryCustom
20	0.49046111106873	After getting category custom	After call to function getCategoryCustom
21	0.49046397209167	End of GetCategoryList function	End of the function
22	0.49047303199768	Get Category List for Group	Before the call to getCategoryList function
23	0.49047708511353	Start of GetCategoryList function	Start of the function
24	0.49047994613647	Before getting categories	Query to get specific category list
25	0.49099206924438	End of getCategoryListByGroup Function	Before return()
26	1.0039231777191	App Controller End	End of the App controller (called before the controller of every page)
27	1.2667050361633	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.2695989608765	Before Get Options	Before the call to getOptions in the tpl class
29	1.4079430103302	After Get Options	After the call to getOptions in the tpl class
30	1.4079871177673	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.6965639591217	Finalizing debug	Before the debug is output to the page.
32	1.6965801715851	End of App	This is the end of the app logging, final timestamp

Query Debug - 402 Database Queries. Total time 1.0505 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.191.167.138\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738825686'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.191.167.138') >= INET_ATON(ip_start) AND INET_ATON('18.191.167.138') <= 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 '2', NOW(), '18.191.167.138'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 '2') OR (keyfeatures LIKE '2') OR (title LIKE '2'))

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

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

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

		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 '%2%') OR (title LIKE '%2%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
SELECT * FROM products WHERE id = '780'
SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '780'
SELECT * FROM productcustomimages WHERE product_id = '780'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '780' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4581'
SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4581' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4581'
SELECT * FROM productcustomimages WHERE product_id = '4581'
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 = '4581'
                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     = '4581'
                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 = 4581
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4581' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4581
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4581'
                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 = '4581'
                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     = '4581'
                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 = 4581
SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4581'
                  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     = '4581'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1099'
SELECT * FROM productimages WHERE product_id = '1099' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1099' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1099'
SELECT * FROM productcustomimages WHERE product_id = '1099'
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 = '1099'
                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     = '1099'
                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 = 1099
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1099' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1099' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1099' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1099
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1099'
                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 = '1099'
                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     = '1099'
                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 = 1099
SELECT value FROM productattributes WHERE product_id = '1099' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '1099'
SELECT * FROM products WHERE id = '1075'
SELECT * FROM productimages WHERE product_id = '1075' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1075'
SELECT * FROM productcustomimages WHERE product_id = '1075'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1075' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1075' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1075' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1075
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1075'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1075' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4560'
SELECT * FROM productimages WHERE product_id = '4560' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4560' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4560'
SELECT * FROM productcustomimages WHERE product_id = '4560'
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 = '4560'
                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     = '4560'
                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 = 4560
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4560' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4560' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4560' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4560
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4560'
                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 = '4560'
                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     = '4560'
                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 = 4560
SELECT value FROM productattributes WHERE product_id = '4560' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4560'
                  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     = '4560'
                  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 = '4560'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4561' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4561' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4561' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4561
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4561'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3772'
SELECT * FROM productimages WHERE product_id = '3772' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3772'
SELECT * FROM productcustomimages WHERE product_id = '3772'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3772' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3772' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3772' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3772' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1238'
SELECT * FROM productimages WHERE product_id = '1238' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1238' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1238'
SELECT * FROM productcustomimages WHERE product_id = '1238'
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 = '1238'
                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     = '1238'
                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 = 1238
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1238' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1238' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1238' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1238
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1238'
                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 = '1238'
                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     = '1238'
                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 = 1238
SELECT value FROM productattributes WHERE product_id = '1238' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '1238'
SELECT * FROM products WHERE id = '1261'
SELECT * FROM productimages WHERE product_id = '1261' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1261'
SELECT * FROM productcustomimages WHERE product_id = '1261'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1261' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1261' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1261' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1261
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1261'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1261' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4007'
SELECT * FROM productimages WHERE product_id = '4007' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4007'
SELECT * FROM productcustomimages WHERE product_id = '4007'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4007' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4007' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1638'
SELECT * FROM productimages WHERE product_id = '1638' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1638'
SELECT * FROM productcustomimages WHERE product_id = '1638'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1638' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1638' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1638' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1638' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2683'
SELECT * FROM productimages WHERE product_id = '2683' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2683'
SELECT * FROM productcustomimages WHERE product_id = '2683'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2683' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2683' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2683' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2683
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2683'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2683' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1508'
SELECT * FROM productimages WHERE product_id = '1508' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1508'
SELECT * FROM productcustomimages WHERE product_id = '1508'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1508' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1508' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1508' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1508
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1508'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1508' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1382'
SELECT * FROM productimages WHERE product_id = '1382' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1382'
SELECT * FROM productcustomimages WHERE product_id = '1382'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1382' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1382' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1382' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1382
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1382'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3664'
SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3664'
SELECT * FROM productcustomimages WHERE product_id = '3664'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3664' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3664
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3664'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3748'
SELECT * FROM productimages WHERE product_id = '3748' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3748'
SELECT * FROM productcustomimages WHERE product_id = '3748'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3748' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3748' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3748' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3748
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3748'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1098'
SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1098'
SELECT * FROM productcustomimages WHERE product_id = '1098'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1098' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1098' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1098' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1098
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1098'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1098' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '925'
SELECT * FROM productimages WHERE product_id = '925' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '925'
SELECT * FROM productcustomimages WHERE product_id = '925'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '925' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '925' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '925' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 925
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '925'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '761'
SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '761'
SELECT * FROM productcustomimages WHERE product_id = '761'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '761' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 761
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '761'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '780' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4581' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1099' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1075' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4560' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3772' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1238' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1261' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4007' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1638' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2683' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1508' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1382' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3664' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3748' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1098' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '925' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '761' 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.0010	0.0010178089141846	SELECT parameter, value FROM parameters
2	0.0037	0.0036509037017822	SELECT * FROM `bad_bots`
3	0.0004	0.00042200088500977	SET time_zone = 'Europe/London'
4	0.0026	0.0025730133056641	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0042	0.0041759014129639	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.191.167.138\";}'
6	0.0044	0.0043778419494629	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738825686'
7	0.0052	0.0051729679107666	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0012	0.0011589527130127	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0050	0.0050041675567627	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0009	0.00093984603881836	SELECT * FROM pages WHERE id = 52
11	0.0071	0.0070681571960449	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0482	0.04817795753479	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0006	0.00064897537231445	SELECT * FROM pages WHERE pagename = 'search'
14	0.0018	0.0017690658569336	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0019	0.0018908977508545	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0076	0.0075747966766357	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17	0.0019	0.0019130706787109	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0013	0.0012979507446289	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00054693222045898	SELECT id FROM categories WHERE parent_id = '26'
20	0.0061	0.0061419010162354	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0018	0.0018110275268555	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0019	0.0018589496612549	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0014	0.0014359951019287	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0004	0.00043487548828125	SELECT * FROM categorygroups WHERE id = '1'
25	0.0040	0.0040440559387207	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0005	0.00051283836364746	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0006	0.0006251335144043	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0006	0.0005958080291748	SELECT id FROM categories WHERE parent_id = '27'
29	0.0049	0.0048758983612061	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
30	0.0006	0.00058889389038086	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0006	0.00063180923461914	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0006	0.00056695938110352	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00052499771118164	SELECT * FROM categorygroups WHERE id = '1'
34	0.0016	0.0015840530395508	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0005	0.00047707557678223	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0005	0.00045204162597656	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00048494338989258	SELECT id FROM categories WHERE parent_id = '28'
38	0.0018	0.0017518997192383	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0006	0.00058507919311523	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0006	0.00060200691223145	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0005	0.00052499771118164	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0004	0.00043606758117676	SELECT * FROM categorygroups WHERE id = '1'
43	0.0006	0.0006260871887207	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0005	0.0005190372467041	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0004	0.00041818618774414	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.0004580020904541	SELECT id FROM categories WHERE parent_id = '29'
47	0.0008	0.00078892707824707	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0005	0.00052714347839355	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0006	0.00061392784118652	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0006	0.00061202049255371	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0005	0.00050997734069824	SELECT * FROM categorygroups WHERE id = '1'
52	0.0008	0.00077414512634277	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53	0.0005	0.0005340576171875	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0004	0.00041484832763672	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00047087669372559	SELECT id FROM categories WHERE parent_id = '30'
56	0.0008	0.00083088874816895	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0006	0.00060319900512695	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0006	0.00059700012207031	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0005	0.00053811073303223	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00051307678222656	SELECT * FROM categorygroups WHERE id = '1'
61	0.0007	0.00073003768920898	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0005	0.00052189826965332	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0006	0.0005500316619873	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.00054311752319336	SELECT id FROM categories WHERE parent_id = '31'
65	0.0009	0.00092005729675293	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0006	0.00057697296142578	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0006	0.00056910514831543	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0006	0.00057101249694824	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0005	0.00046396255493164	SELECT * FROM categorygroups WHERE id = '1'
70	0.0005	0.00049805641174316	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0030	0.0029680728912354	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0014	0.0014321804046631	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0006	0.0005500316619873	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74	0.0011	0.0010690689086914	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0011	0.0011248588562012	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0010	0.0010421276092529	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4993	0.49933218955994	SELECT * FROM ipgeocountries WHERE INET_ATON('18.191.167.138') >= INET_ATON(ip_start) AND INET_ATON('18.191.167.138') <= INET_ATON(ip_end)
78	0.0021	0.0020580291748047	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0014	0.0013649463653564	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0006	0.00060510635375977	SELECT * FROM pages WHERE pagename = 'search'
81	0.0059	0.0059359073638916	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0019	0.0019018650054932	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0017	0.0017290115356445	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0057	0.0057258605957031	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0017	0.0017118453979492	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0006	0.00055909156799316	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0018	0.0018022060394287	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '18.191.167.138'
88	0.0008	0.0008080005645752	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
89	0.0005	0.00053811073303223	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0040	0.0040340423583984	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
91	0.0007	0.00068092346191406	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
92	0.0011	0.001060962677002	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
93	0.0006	0.00059604644775391	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
94	0.0068	0.0067601203918457	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
95	0.0005	0.00045895576477051	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
96	0.0004	0.00037193298339844	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
97	0.0006	0.00061416625976562	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0006	0.00060319900512695	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0051	0.0050828456878662	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0004	0.00041985511779785	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
101	0.0004	0.00039911270141602	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
102	0.0006	0.00061702728271484	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' 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 ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
103	0.0075	0.0075459480285645	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0004	0.00042200088500977	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
105	0.0004	0.00038313865661621	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
106	0.0005	0.00054311752319336	SELECT * FROM products WHERE id = '780'
107	0.0023	0.0022580623626709	SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
108	0.0021	0.002100944519043	SELECT * FROM product_image_select WHERE product_id = '780'
109	0.0017	0.0017240047454834	SELECT * FROM productcustomimages WHERE product_id = '780'
110	0.0027	0.0027308464050293	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
111	0.0018	0.0017650127410889	SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0005	0.0005180835723877	SELECT * FROM productoffers WHERE product_id = '780' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0006	0.00061392784118652	SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114	0.0007	0.00074005126953125	SELECT * FROM products WHERE id = '4581'
115	0.0006	0.00058293342590332	SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
116	0.0006	0.00058889389038086	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4581' AND p.id = pi.product_id ORDER BY pi.sortorder
117	0.0007	0.00070810317993164	SELECT * FROM product_image_select WHERE product_id = '4581'
118	0.0005	0.00046896934509277	SELECT * FROM productcustomimages WHERE product_id = '4581'
119	0.0007	0.00066304206848145	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 = '4581' GROUP BY o.product_id
120	0.0032	0.0031828880310059	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 = '4581' GROUP BY n.displayname ORDER BY n.displayname DESC
121	0.0006	0.00061511993408203	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4581
122	0.0010	0.0010268688201904	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
123	0.0012	0.0011589527130127	SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
124	0.0005	0.00046920776367188	SELECT * FROM productoffers WHERE product_id = '4581' AND price > 0 ORDER BY price ASC LIMIT 1
125	0.0004	0.00042605400085449	SELECT * FROM productoffers WHERE product_id = 4581 ORDER BY price ASC LIMIT 1
126	0.0005	0.00046801567077637	SELECT value FROM productattributes WHERE product_id = '4581' AND name = 'ListPriceAmount'
127	0.0006	0.00055789947509766	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 = '4581' GROUP BY o.product_id
128	0.0009	0.00091290473937988	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 = '4581' GROUP BY n.displayname ORDER BY n.displayname DESC
129	0.0005	0.00053501129150391	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4581
130	0.0007	0.00067806243896484	SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0008	0.00081992149353027	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4581' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
132	0.0007	0.00072717666625977	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4581' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
133	0.0006	0.00057506561279297	SELECT * FROM products WHERE id = '1099'
134	0.0006	0.00055694580078125	SELECT * FROM productimages WHERE product_id = '1099' ORDER BY sortorder ASC
135	0.0005	0.00051283836364746	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1099' AND p.id = pi.product_id ORDER BY pi.sortorder
136	0.0008	0.00083303451538086	SELECT * FROM product_image_select WHERE product_id = '1099'
137	0.0005	0.00047612190246582	SELECT * FROM productcustomimages WHERE product_id = '1099'
138	0.0006	0.00059795379638672	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 = '1099' GROUP BY o.product_id
139	0.0007	0.00072002410888672	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 = '1099' GROUP BY n.displayname ORDER BY n.displayname DESC
140	0.0005	0.00047898292541504	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1099
141	0.0011	0.0010659694671631	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1099' AND a.name = n.originalname
142	0.0005	0.00045895576477051	SELECT * FROM productoffers WHERE product_id = '1099' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0005	0.00049686431884766	SELECT * FROM productoffers WHERE product_id = '1099' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0004	0.00042414665222168	SELECT * FROM productoffers WHERE product_id = 1099 ORDER BY price ASC LIMIT 1
145	0.0005	0.00048589706420898	SELECT value FROM productattributes WHERE product_id = '1099' AND name = 'ListPriceAmount'
146	0.0005	0.00049996376037598	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 = '1099' GROUP BY o.product_id
147	0.0007	0.00069189071655273	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 = '1099' GROUP BY n.displayname ORDER BY n.displayname DESC
148	0.0005	0.00052213668823242	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1099
149	0.0006	0.00061416625976562	SELECT value FROM productattributes WHERE product_id = '1099' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150	0.0005	0.00053191184997559	SELECT * FROM products WHERE parent_id = '1099'
151	0.0006	0.00062680244445801	SELECT * FROM products WHERE id = '1075'
152	0.0005	0.0005338191986084	SELECT * FROM productimages WHERE product_id = '1075' ORDER BY sortorder ASC
153	0.0007	0.00072097778320312	SELECT * FROM product_image_select WHERE product_id = '1075'
154	0.0005	0.00046801567077637	SELECT * FROM productcustomimages WHERE product_id = '1075'
155	0.0013	0.0013101100921631	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1075' AND a.name = n.originalname
156	0.0006	0.00056099891662598	SELECT * FROM productoffers WHERE product_id = '1075' AND merchantid = 'A1X6FK5RDHNB96'
157	0.0005	0.00046277046203613	SELECT * FROM productoffers WHERE product_id = '1075' AND price > 0 ORDER BY price ASC LIMIT 1
158	0.0004	0.00043392181396484	SELECT * FROM productoffers WHERE product_id = 1075 ORDER BY price ASC LIMIT 1
159	0.0005	0.00048613548278809	SELECT value FROM productattributes WHERE product_id = '1075' AND name = 'ListPriceAmount'
160	0.0005	0.00051093101501465	SELECT value FROM productattributes WHERE product_id = '1075' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161	0.0009	0.0008690357208252	SELECT * FROM products WHERE id = '4560'
162	0.0005	0.00054812431335449	SELECT * FROM productimages WHERE product_id = '4560' ORDER BY sortorder ASC
163	0.0005	0.00048303604125977	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4560' AND p.id = pi.product_id ORDER BY pi.sortorder
164	0.0007	0.00067996978759766	SELECT * FROM product_image_select WHERE product_id = '4560'
165	0.0004	0.00044107437133789	SELECT * FROM productcustomimages WHERE product_id = '4560'
166	0.0006	0.00059294700622559	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 = '4560' GROUP BY o.product_id
167	0.0007	0.00071310997009277	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 = '4560' GROUP BY n.displayname ORDER BY n.displayname DESC
168	0.0005	0.00048208236694336	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4560
169	0.0014	0.001446008682251	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4560' AND a.name = n.originalname
170	0.0005	0.00045680999755859	SELECT * FROM productoffers WHERE product_id = '4560' AND merchantid = 'A1X6FK5RDHNB96'
171	0.0008	0.00079488754272461	SELECT * FROM productoffers WHERE product_id = '4560' AND price > 0 ORDER BY price ASC LIMIT 1
172	0.0008	0.0008392333984375	SELECT * FROM productoffers WHERE product_id = 4560 ORDER BY price ASC LIMIT 1
173	0.0008	0.00080490112304688	SELECT value FROM productattributes WHERE product_id = '4560' AND name = 'ListPriceAmount'
174	0.0008	0.000823974609375	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 = '4560' GROUP BY o.product_id
175	0.0016	0.0015509128570557	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 = '4560' GROUP BY n.displayname ORDER BY n.displayname DESC
176	0.0008	0.00078392028808594	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4560
177	0.0013	0.0012869834899902	SELECT value FROM productattributes WHERE product_id = '4560' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178	0.0014	0.001446008682251	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4560' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
179	0.0011	0.0011341571807861	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4560' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
180	0.0008	0.0008080005645752	SELECT * FROM products WHERE parent_id = '4560'
181	0.0036	0.0035560131072998	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4561' AND a.name = n.originalname
182	0.0010	0.0010318756103516	SELECT * FROM productoffers WHERE product_id = '4561' AND merchantid = 'A1X6FK5RDHNB96'
183	0.0007	0.0006721019744873	SELECT * FROM productoffers WHERE product_id = '4561' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0006	0.00059103965759277	SELECT * FROM productoffers WHERE product_id = 4561 ORDER BY price ASC LIMIT 1
185	0.0007	0.00069499015808105	SELECT value FROM productattributes WHERE product_id = '4561' AND name = 'ListPriceAmount'
186	0.0010	0.00098395347595215	SELECT * FROM products WHERE id = '3772'
187	0.0009	0.00089383125305176	SELECT * FROM productimages WHERE product_id = '3772' ORDER BY sortorder ASC
188	0.0014	0.0014040470123291	SELECT * FROM product_image_select WHERE product_id = '3772'
189	0.0008	0.00076794624328613	SELECT * FROM productcustomimages WHERE product_id = '3772'
190	0.0026	0.0026218891143799	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3772' AND a.name = n.originalname
191	0.0010	0.0010027885437012	SELECT * FROM productoffers WHERE product_id = '3772' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0006	0.00063705444335938	SELECT * FROM productoffers WHERE product_id = '3772' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0007	0.00067901611328125	SELECT value FROM productattributes WHERE product_id = '3772' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194	0.0008	0.00082802772521973	SELECT * FROM products WHERE id = '1238'
195	0.0007	0.00073122978210449	SELECT * FROM productimages WHERE product_id = '1238' ORDER BY sortorder ASC
196	0.0009	0.00089192390441895	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1238' AND p.id = pi.product_id ORDER BY pi.sortorder
197	0.0014	0.0013828277587891	SELECT * FROM product_image_select WHERE product_id = '1238'
198	0.0007	0.00069999694824219	SELECT * FROM productcustomimages WHERE product_id = '1238'
199	0.0009	0.00088620185852051	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 = '1238' GROUP BY o.product_id
200	0.0011	0.001107931137085	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 = '1238' GROUP BY n.displayname ORDER BY n.displayname DESC
201	0.0006	0.00060391426086426	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1238
202	0.0027	0.0026528835296631	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1238' AND a.name = n.originalname
203	0.0009	0.00088095664978027	SELECT * FROM productoffers WHERE product_id = '1238' AND merchantid = 'A1X6FK5RDHNB96'
204	0.0007	0.00073790550231934	SELECT * FROM productoffers WHERE product_id = '1238' AND price > 0 ORDER BY price ASC LIMIT 1
205	0.0007	0.00074195861816406	SELECT * FROM productoffers WHERE product_id = 1238 ORDER BY price ASC LIMIT 1
206	0.0007	0.00070691108703613	SELECT value FROM productattributes WHERE product_id = '1238' AND name = 'ListPriceAmount'
207	0.0008	0.00078701972961426	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 = '1238' GROUP BY o.product_id
208	0.0013	0.0012650489807129	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 = '1238' GROUP BY n.displayname ORDER BY n.displayname DESC
209	0.0006	0.00061416625976562	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1238
210	0.0010	0.0010099411010742	SELECT value FROM productattributes WHERE product_id = '1238' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211	0.0007	0.00067400932312012	SELECT * FROM products WHERE parent_id = '1238'
212	0.0009	0.00088381767272949	SELECT * FROM products WHERE id = '1261'
213	0.0008	0.00081515312194824	SELECT * FROM productimages WHERE product_id = '1261' ORDER BY sortorder ASC
214	0.0012	0.00124192237854	SELECT * FROM product_image_select WHERE product_id = '1261'
215	0.0013	0.0012941360473633	SELECT * FROM productcustomimages WHERE product_id = '1261'
216	0.0021	0.0020909309387207	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1261' AND a.name = n.originalname
217	0.0008	0.00075507164001465	SELECT * FROM productoffers WHERE product_id = '1261' AND merchantid = 'A1X6FK5RDHNB96'
218	0.0006	0.00057101249694824	SELECT * FROM productoffers WHERE product_id = '1261' AND price > 0 ORDER BY price ASC LIMIT 1
219	0.0005	0.00054001808166504	SELECT * FROM productoffers WHERE product_id = 1261 ORDER BY price ASC LIMIT 1
220	0.0005	0.00054621696472168	SELECT value FROM productattributes WHERE product_id = '1261' AND name = 'ListPriceAmount'
221	0.0011	0.0010559558868408	SELECT value FROM productattributes WHERE product_id = '1261' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222	0.0009	0.00090789794921875	SELECT * FROM products WHERE id = '4007'
223	0.0008	0.0007622241973877	SELECT * FROM productimages WHERE product_id = '4007' ORDER BY sortorder ASC
224	0.0011	0.0010898113250732	SELECT * FROM product_image_select WHERE product_id = '4007'
225	0.0007	0.00068402290344238	SELECT * FROM productcustomimages WHERE product_id = '4007'
226	0.0026	0.0026190280914307	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname
227	0.0008	0.00075507164001465	SELECT * FROM productoffers WHERE product_id = '4007' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0006	0.00058603286743164	SELECT * FROM productoffers WHERE product_id = '4007' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0006	0.00063395500183105	SELECT value FROM productattributes WHERE product_id = '4007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230	0.0010	0.00096988677978516	SELECT * FROM products WHERE id = '1638'
231	0.0007	0.00071287155151367	SELECT * FROM productimages WHERE product_id = '1638' ORDER BY sortorder ASC
232	0.0010	0.00096297264099121	SELECT * FROM product_image_select WHERE product_id = '1638'
233	0.0005	0.00052809715270996	SELECT * FROM productcustomimages WHERE product_id = '1638'
234	0.0017	0.0017290115356445	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1638' AND a.name = n.originalname
235	0.0007	0.0007319450378418	SELECT * FROM productoffers WHERE product_id = '1638' AND merchantid = 'A1X6FK5RDHNB96'
236	0.0007	0.00065398216247559	SELECT * FROM productoffers WHERE product_id = '1638' AND price > 0 ORDER BY price ASC LIMIT 1
237	0.0006	0.00060486793518066	SELECT value FROM productattributes WHERE product_id = '1638' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238	0.0008	0.00080418586730957	SELECT * FROM products WHERE id = '2683'
239	0.0006	0.00060391426086426	SELECT * FROM productimages WHERE product_id = '2683' ORDER BY sortorder ASC
240	0.0009	0.00093889236450195	SELECT * FROM product_image_select WHERE product_id = '2683'
241	0.0008	0.00076103210449219	SELECT * FROM productcustomimages WHERE product_id = '2683'
242	0.0018	0.0018019676208496	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2683' AND a.name = n.originalname
243	0.0007	0.00068783760070801	SELECT * FROM productoffers WHERE product_id = '2683' AND merchantid = 'A1X6FK5RDHNB96'
244	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = '2683' AND price > 0 ORDER BY price ASC LIMIT 1
245	0.0006	0.00061202049255371	SELECT * FROM productoffers WHERE product_id = 2683 ORDER BY price ASC LIMIT 1
246	0.0006	0.00063109397888184	SELECT value FROM productattributes WHERE product_id = '2683' AND name = 'ListPriceAmount'
247	0.0007	0.00068497657775879	SELECT value FROM productattributes WHERE product_id = '2683' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248	0.0008	0.00078511238098145	SELECT * FROM products WHERE id = '1508'
249	0.0006	0.00061178207397461	SELECT * FROM productimages WHERE product_id = '1508' ORDER BY sortorder ASC
250	0.0009	0.00086116790771484	SELECT * FROM product_image_select WHERE product_id = '1508'
251	0.0005	0.00051999092102051	SELECT * FROM productcustomimages WHERE product_id = '1508'
252	0.0020	0.002007007598877	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1508' AND a.name = n.originalname
253	0.0007	0.00070500373840332	SELECT * FROM productoffers WHERE product_id = '1508' AND merchantid = 'A1X6FK5RDHNB96'
254	0.0006	0.00062394142150879	SELECT * FROM productoffers WHERE product_id = '1508' AND price > 0 ORDER BY price ASC LIMIT 1
255	0.0005	0.00047087669372559	SELECT * FROM productoffers WHERE product_id = 1508 ORDER BY price ASC LIMIT 1
256	0.0006	0.00057196617126465	SELECT value FROM productattributes WHERE product_id = '1508' AND name = 'ListPriceAmount'
257	0.0006	0.00064611434936523	SELECT value FROM productattributes WHERE product_id = '1508' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258	0.0008	0.00082802772521973	SELECT * FROM products WHERE id = '1382'
259	0.0008	0.00081491470336914	SELECT * FROM productimages WHERE product_id = '1382' ORDER BY sortorder ASC
260	0.0020	0.0019669532775879	SELECT * FROM product_image_select WHERE product_id = '1382'
261	0.0010	0.0010330677032471	SELECT * FROM productcustomimages WHERE product_id = '1382'
262	0.0033	0.0033180713653564	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1382' AND a.name = n.originalname
263	0.0010	0.0010139942169189	SELECT * FROM productoffers WHERE product_id = '1382' AND merchantid = 'A1X6FK5RDHNB96'
264	0.0007	0.00068902969360352	SELECT * FROM productoffers WHERE product_id = '1382' AND price > 0 ORDER BY price ASC LIMIT 1
265	0.0009	0.00089287757873535	SELECT * FROM productoffers WHERE product_id = 1382 ORDER BY price ASC LIMIT 1
266	0.0007	0.00072407722473145	SELECT value FROM productattributes WHERE product_id = '1382' AND name = 'ListPriceAmount'
267	0.0009	0.00090718269348145	SELECT value FROM productattributes WHERE product_id = '1382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268	0.0010	0.0010430812835693	SELECT * FROM products WHERE id = '3664'
269	0.0009	0.0009160041809082	SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
270	0.0013	0.0013480186462402	SELECT * FROM product_image_select WHERE product_id = '3664'
271	0.0007	0.00068902969360352	SELECT * FROM productcustomimages WHERE product_id = '3664'
272	0.0020	0.0020220279693604	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
273	0.0010	0.0010271072387695	SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
274	0.0008	0.00078582763671875	SELECT * FROM productoffers WHERE product_id = '3664' AND price > 0 ORDER BY price ASC LIMIT 1
275	0.0008	0.00075984001159668	SELECT * FROM productoffers WHERE product_id = 3664 ORDER BY price ASC LIMIT 1
276	0.0008	0.00081205368041992	SELECT value FROM productattributes WHERE product_id = '3664' AND name = 'ListPriceAmount'
277	0.0008	0.00082683563232422	SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278	0.0010	0.00099492073059082	SELECT * FROM products WHERE id = '3748'
279	0.0009	0.00085091590881348	SELECT * FROM productimages WHERE product_id = '3748' ORDER BY sortorder ASC
280	0.0012	0.0011811256408691	SELECT * FROM product_image_select WHERE product_id = '3748'
281	0.0007	0.00068402290344238	SELECT * FROM productcustomimages WHERE product_id = '3748'
282	0.0024	0.0024399757385254	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3748' AND a.name = n.originalname
283	0.0009	0.00088810920715332	SELECT * FROM productoffers WHERE product_id = '3748' AND merchantid = 'A1X6FK5RDHNB96'
284	0.0006	0.00063300132751465	SELECT * FROM productoffers WHERE product_id = '3748' AND price > 0 ORDER BY price ASC LIMIT 1
285	0.0005	0.00051307678222656	SELECT * FROM productoffers WHERE product_id = 3748 ORDER BY price ASC LIMIT 1
286	0.0006	0.00062394142150879	SELECT value FROM productattributes WHERE product_id = '3748' AND name = 'ListPriceAmount'
287	0.0007	0.00065088272094727	SELECT value FROM productattributes WHERE product_id = '3748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288	0.0008	0.00080084800720215	SELECT * FROM products WHERE id = '1098'
289	0.0007	0.00072121620178223	SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
290	0.0011	0.0010519027709961	SELECT * FROM product_image_select WHERE product_id = '1098'
291	0.0006	0.0005650520324707	SELECT * FROM productcustomimages WHERE product_id = '1098'
292	0.0020	0.0019700527191162	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1098' AND a.name = n.originalname
293	0.0008	0.0007779598236084	SELECT * FROM productoffers WHERE product_id = '1098' AND merchantid = 'A1X6FK5RDHNB96'
294	0.0007	0.00068306922912598	SELECT * FROM productoffers WHERE product_id = '1098' AND price > 0 ORDER BY price ASC LIMIT 1
295	0.0006	0.00063800811767578	SELECT * FROM productoffers WHERE product_id = 1098 ORDER BY price ASC LIMIT 1
296	0.0006	0.00060200691223145	SELECT value FROM productattributes WHERE product_id = '1098' AND name = 'ListPriceAmount'
297	0.0006	0.00059986114501953	SELECT value FROM productattributes WHERE product_id = '1098' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298	0.0007	0.00073790550231934	SELECT * FROM products WHERE id = '925'
299	0.0006	0.00060200691223145	SELECT * FROM productimages WHERE product_id = '925' ORDER BY sortorder ASC
300	0.0010	0.0010390281677246	SELECT * FROM product_image_select WHERE product_id = '925'
301	0.0005	0.00050115585327148	SELECT * FROM productcustomimages WHERE product_id = '925'
302	0.0017	0.0017340183258057	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '925' AND a.name = n.originalname
303	0.0007	0.00067496299743652	SELECT * FROM productoffers WHERE product_id = '925' AND merchantid = 'A1X6FK5RDHNB96'
304	0.0006	0.00057601928710938	SELECT * FROM productoffers WHERE product_id = '925' AND price > 0 ORDER BY price ASC LIMIT 1
305	0.0005	0.0004570484161377	SELECT * FROM productoffers WHERE product_id = 925 ORDER BY price ASC LIMIT 1
306	0.0005	0.0005180835723877	SELECT value FROM productattributes WHERE product_id = '925' AND name = 'ListPriceAmount'
307	0.0006	0.00059890747070312	SELECT value FROM productattributes WHERE product_id = '925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
308	0.0009	0.00085306167602539	SELECT * FROM products WHERE id = '761'
309	0.0007	0.00067019462585449	SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
310	0.0016	0.0016210079193115	SELECT * FROM product_image_select WHERE product_id = '761'
311	0.0005	0.00049114227294922	SELECT * FROM productcustomimages WHERE product_id = '761'
312	0.0013	0.0012500286102295	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
313	0.0006	0.0005948543548584	SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
314	0.0005	0.00049400329589844	SELECT * FROM productoffers WHERE product_id = '761' AND price > 0 ORDER BY price ASC LIMIT 1
315	0.0004	0.00044584274291992	SELECT * FROM productoffers WHERE product_id = 761 ORDER BY price ASC LIMIT 1
316	0.0005	0.00050997734069824	SELECT value FROM productattributes WHERE product_id = '761' AND name = 'ListPriceAmount'
317	0.0005	0.00053286552429199	SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318	0.0021	0.0020999908447266	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '780' ORDER BY timestamp DESC
319	0.0004	0.00042009353637695	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4581' ORDER BY timestamp DESC
320	0.0005	0.00045990943908691	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1099' ORDER BY timestamp DESC
321	0.0004	0.00035691261291504	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1075' ORDER BY timestamp DESC
322	0.0005	0.00045609474182129	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4560' ORDER BY timestamp DESC
323	0.0004	0.00043892860412598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3772' ORDER BY timestamp DESC
324	0.0003	0.00033903121948242	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1238' ORDER BY timestamp DESC
325	0.0003	0.0003349781036377	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1261' ORDER BY timestamp DESC
326	0.0004	0.00036811828613281	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4007' ORDER BY timestamp DESC
327	0.0004	0.00043106079101562	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1638' ORDER BY timestamp DESC
328	0.0004	0.00035619735717773	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2683' ORDER BY timestamp DESC
329	0.0019	0.0018601417541504	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1508' ORDER BY timestamp DESC
330	0.0004	0.00041007995605469	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1382' ORDER BY timestamp DESC
331	0.0004	0.00036287307739258	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3664' ORDER BY timestamp DESC
332	0.0004	0.00036096572875977	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3748' ORDER BY timestamp DESC
333	0.0004	0.00040602684020996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1098' ORDER BY timestamp DESC
334	0.0004	0.00039815902709961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '925' ORDER BY timestamp DESC
335	0.0003	0.00033998489379883	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '761' ORDER BY timestamp DESC
336	0.0020	0.0019588470458984	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
337	0.0022	0.0021889209747314	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
338	0.0006	0.0005638599395752	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
339	0.0213	0.021343946456909	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
340	0.0024	0.0023531913757324	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
341	0.0006	0.00055503845214844	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
342	0.0006	0.00061297416687012	SELECT * FROM products WHERE id = 1626
343	0.0007	0.00070381164550781	SELECT * FROM products WHERE id = 4041
344	0.0006	0.00063014030456543	SELECT * FROM products WHERE id = 4312
345	0.0006	0.00055980682373047	SELECT * FROM products WHERE id = 777
346	0.0006	0.00060009956359863	SELECT * FROM products WHERE id = 3881
347	0.0006	0.0006251335144043	SELECT * FROM products WHERE id = 4213
348	0.0007	0.00072193145751953	SELECT * FROM products WHERE id = '1626'
349	0.0005	0.00047087669372559	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
350	0.0006	0.00056886672973633	SELECT * FROM product_image_select WHERE product_id = '1626'
351	0.0004	0.00041103363037109	SELECT * FROM productcustomimages WHERE product_id = '1626'
352	0.0008	0.00079703330993652	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
353	0.0005	0.00049281120300293	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
354	0.0004	0.00040984153747559	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
355	0.0004	0.00043201446533203	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356	0.0006	0.00057601928710938	SELECT * FROM products WHERE id = '4041'
357	0.0005	0.00050783157348633	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
358	0.0006	0.00060296058654785	SELECT * FROM product_image_select WHERE product_id = '4041'
359	0.0004	0.00041389465332031	SELECT * FROM productcustomimages WHERE product_id = '4041'
360	0.0011	0.0011050701141357	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
361	0.0008	0.00083804130554199	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
362	0.0042	0.0042388439178467	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
363	0.0079	0.0079169273376465	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364	0.0040	0.0039718151092529	SELECT * FROM products WHERE id = '4312'
365	0.0007	0.00071001052856445	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
366	0.0033	0.0032780170440674	SELECT * FROM product_image_select WHERE product_id = '4312'
367	0.0038	0.003842830657959	SELECT * FROM productcustomimages WHERE product_id = '4312'
368	0.0023	0.0022759437561035	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
369	0.0008	0.00079989433288574	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
370	0.0006	0.00060296058654785	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
371	0.0007	0.00070905685424805	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372	0.0008	0.00084185600280762	SELECT * FROM products WHERE id = '777'
373	0.0007	0.00071501731872559	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
374	0.0012	0.0012071132659912	SELECT * FROM product_image_select WHERE product_id = '777'
375	0.0010	0.0010039806365967	SELECT * FROM productcustomimages WHERE product_id = '777'
376	0.0029	0.0029189586639404	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
377	0.0012	0.0011630058288574	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
378	0.0009	0.0008540153503418	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
379	0.0021	0.0021121501922607	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
380	0.0081	0.0081470012664795	SELECT * FROM products WHERE id = '3881'
381	0.0016	0.0015909671783447	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
382	0.0018	0.0017850399017334	SELECT * FROM product_image_select WHERE product_id = '3881'
383	0.0008	0.00079607963562012	SELECT * FROM productcustomimages WHERE product_id = '3881'
384	0.0034	0.0034170150756836	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
385	0.0040	0.003964900970459	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
386	0.0040	0.0039899349212646	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
387	0.0040	0.0040009021759033	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
388	0.0014	0.0013649463653564	SELECT * FROM products WHERE id = '4213'
389	0.0014	0.0013830661773682	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
390	0.0090	0.0089950561523438	SELECT * FROM product_image_select WHERE product_id = '4213'
391	0.0039	0.0039360523223877	SELECT * FROM productcustomimages WHERE product_id = '4213'
392	0.0026	0.0026371479034424	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
393	0.0007	0.00072884559631348	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
394	0.0006	0.00061392784118652	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
395	0.0007	0.00073695182800293	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
396	0.0031	0.0030558109283447	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
397	0.0011	0.0010550022125244	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
398	0.0034	0.0034010410308838	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
399	0.0024	0.0023629665374756	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
400	0.0008	0.00083494186401367	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
401	0.0010	0.001025915145874	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
402	0.0010	0.0010099411010742	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "2"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.6965820789337 seconds

Query Debug - 402 Database Queries. Total time 1.0505 seconds