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.8956689834595	402	1.0184	0

No Amazon API Requests Made.

App Debug - Total Time 1.8956689834595 seconds

Number	Time From Start	Name	Description
1	0.7125780582428	Initialise	Initialise FSB Function
2	0.71795511245728	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.7528829574585	Start of getCategoryListByGroup Function	Before first category groups query
4	0.75846695899963	After initial query	Before first category groups query
5	0.75846910476685	Get Category List for Group	Before the call to getCategoryList function
6	0.75847411155701	Start of GetCategoryList function	Start of the function
7	0.75847792625427	Before getting categories	Query to get specific category list
8	0.76294994354248	After getting categories	Query to get specific category list
9	0.76295304298401	Before getting category custom	Before call to function getCategoryCustom
10	0.79751205444336	After getting category custom	After call to function getCategoryCustom
11	0.79751706123352	Before getting category custom	Before call to function getCategoryCustom
12	0.81037497520447	After getting category custom	After call to function getCategoryCustom
13	0.81038093566895	Before getting category custom	Before call to function getCategoryCustom
14	0.8192880153656	After getting category custom	After call to function getCategoryCustom
15	0.81929397583008	Before getting category custom	Before call to function getCategoryCustom
16	0.82438707351685	After getting category custom	After call to function getCategoryCustom
17	0.82439112663269	Before getting category custom	Before call to function getCategoryCustom
18	0.82991409301758	After getting category custom	After call to function getCategoryCustom
19	0.82991695404053	Before getting category custom	Before call to function getCategoryCustom
20	0.83609294891357	After getting category custom	After call to function getCategoryCustom
21	0.83609795570374	End of GetCategoryList function	End of the function
22	0.83610892295837	Get Category List for Group	Before the call to getCategoryList function
23	0.8361120223999	Start of GetCategoryList function	Start of the function
24	0.83611512184143	Before getting categories	Query to get specific category list
25	0.83673810958862	End of getCategoryListByGroup Function	Before return()
26	1.3639769554138	App Controller End	End of the App controller (called before the controller of every page)
27	1.6267139911652	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.6291749477386	Before Get Options	Before the call to getOptions in the tpl class
29	1.7293829917908	After Get Options	After the call to getOptions in the tpl class
30	1.7294199466705	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.8956530094147	Finalizing debug	Before the debug is output to the page.
32	1.8956680297852	End of App	This is the end of the app logging, final timestamp

Query Debug - 402 Database Queries. Total time 1.0184 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.222.20.252\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738814403'
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.222.20.252') >= INET_ATON(ip_start) AND INET_ATON('18.222.20.252') <= 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.222.20.252'
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.0020	0.0019659996032715	SELECT parameter, value FROM parameters
2	0.0044	0.0043950080871582	SELECT * FROM `bad_bots`
3	0.0004	0.00037598609924316	SET time_zone = 'Europe/London'
4	0.0028	0.0027861595153809	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0021	0.0021369457244873	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.222.20.252\";}'
6	0.0021	0.0021171569824219	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738814403'
7	0.0033	0.0032699108123779	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0009	0.00085902214050293	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0033	0.0032839775085449	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0007	0.0006561279296875	SELECT * FROM pages WHERE id = 52
11	0.0039	0.0038659572601318	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0288	0.028801918029785	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0013	0.0012688636779785	SELECT * FROM pages WHERE pagename = 'search'
14	0.0056	0.0055530071258545	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0044	0.0044300556182861	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0168	0.016751050949097	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.0028	0.0028080940246582	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.0017	0.0016899108886719	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0006	0.00059294700622559	SELECT id FROM categories WHERE parent_id = '26'
20	0.0070	0.0069761276245117	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.0018439292907715	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.0017	0.0016500949859619	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.0015	0.0015299320220947	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00046706199645996	SELECT * FROM categorygroups WHERE id = '1'
25	0.0040	0.003972053527832	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0006	0.00062894821166992	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.00043201446533203	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0007	0.00072002410888672	SELECT id FROM categories WHERE parent_id = '27'
29	0.0044	0.0043680667877197	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.00063610076904297	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.00061893463134766	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.00059700012207031	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0007	0.00071215629577637	SELECT * FROM categorygroups WHERE id = '1'
34	0.0022	0.002216100692749	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.0006	0.00064706802368164	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.00047421455383301	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0006	0.00059914588928223	SELECT id FROM categories WHERE parent_id = '28'
38	0.0023	0.002324104309082	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0007	0.00067496299743652	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.0007	0.00068211555480957	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.0006	0.00058794021606445	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.00054001808166504	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00076198577880859	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.00049495697021484	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.00042891502380371	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00045585632324219	SELECT id FROM categories WHERE parent_id = '29'
47	0.0007	0.00069618225097656	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.00053191184997559	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.00057387351989746	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0005	0.00048613548278809	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0005	0.00051188468933105	SELECT * FROM categorygroups WHERE id = '1'
52	0.0006	0.00060701370239258	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.0004570484161377	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.0003659725189209	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00045680999755859	SELECT id FROM categories WHERE parent_id = '30'
56	0.0007	0.00071287155151367	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0005	0.00054001808166504	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.0012	0.0012309551239014	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.00052905082702637	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00048708915710449	SELECT * FROM categorygroups WHERE id = '1'
61	0.0007	0.00072908401489258	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.0005040168762207	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0004	0.00044393539428711	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.00053811073303223	SELECT id FROM categories WHERE parent_id = '31'
65	0.0009	0.00090384483337402	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.00056600570678711	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.0013	0.0012788772583008	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.00059103965759277	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0005	0.00047802925109863	SELECT * FROM categorygroups WHERE id = '1'
70	0.0006	0.00060510635375977	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0040	0.0040318965911865	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0020	0.0019891262054443	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.00065302848815918	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74	0.0017	0.0017189979553223	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0014	0.0014159679412842	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0012	0.0012071132659912	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.5106	0.51063394546509	SELECT * FROM ipgeocountries WHERE INET_ATON('18.222.20.252') >= INET_ATON(ip_start) AND INET_ATON('18.222.20.252') <= INET_ATON(ip_end)
78	0.0022	0.0021688938140869	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0013	0.0013060569763184	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0005	0.00054383277893066	SELECT * FROM pages WHERE pagename = 'search'
81	0.0055	0.0054769515991211	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0019	0.0018699169158936	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0017	0.0017259120941162	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0055	0.0055010318756104	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0016	0.0015730857849121	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0005	0.00047993659973145	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0015	0.0015270709991455	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '18.222.20.252'
88	0.0008	0.00077009201049805	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.00050616264343262	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.0037	0.003680944442749	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.0005	0.0004889965057373	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.0004	0.00043511390686035	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.00055098533630371	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.0051	0.0051469802856445	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.0004	0.0003821849822998	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.0003	0.00031900405883789	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.0005	0.00051116943359375	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.0005	0.00052499771118164	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.0037	0.0036511421203613	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.0003	0.00034999847412109	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.0003	0.00029683113098145	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.0005	0.00049686431884766	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.0052	0.0052380561828613	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.00038599967956543	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.0003	0.00030207633972168	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.00045490264892578	SELECT * FROM products WHERE id = '780'
107	0.0017	0.001662015914917	SELECT * FROM productimages WHERE product_id = '780' ORDER BY sortorder ASC
108	0.0014	0.0013999938964844	SELECT * FROM product_image_select WHERE product_id = '780'
109	0.0013	0.0013008117675781	SELECT * FROM productcustomimages WHERE product_id = '780'
110	0.0019	0.0019359588623047	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '780' AND a.name = n.originalname
111	0.0014	0.0013701915740967	SELECT * FROM productoffers WHERE product_id = '780' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0004	0.00043511390686035	SELECT * FROM productoffers WHERE product_id = '780' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0005	0.00052690505981445	SELECT value FROM productattributes WHERE product_id = '780' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114	0.0008	0.0008399486541748	SELECT * FROM products WHERE id = '4581'
115	0.0005	0.00053310394287109	SELECT * FROM productimages WHERE product_id = '4581' ORDER BY sortorder ASC
116	0.0005	0.00049901008605957	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.0006	0.00059890747070312	SELECT * FROM product_image_select WHERE product_id = '4581'
118	0.0004	0.00039315223693848	SELECT * FROM productcustomimages WHERE product_id = '4581'
119	0.0006	0.00063896179199219	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.0027	0.002701997756958	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.00062704086303711	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.0009	0.00092291831970215	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4581' AND a.name = n.originalname
123	0.0004	0.00039887428283691	SELECT * FROM productoffers WHERE product_id = '4581' AND merchantid = 'A1X6FK5RDHNB96'
124	0.0004	0.00040984153747559	SELECT * FROM productoffers WHERE product_id = '4581' AND price > 0 ORDER BY price ASC LIMIT 1
125	0.0003	0.00034904479980469	SELECT * FROM productoffers WHERE product_id = 4581 ORDER BY price ASC LIMIT 1
126	0.0004	0.00037097930908203	SELECT value FROM productattributes WHERE product_id = '4581' AND name = 'ListPriceAmount'
127	0.0005	0.00046610832214355	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.0010	0.001025915145874	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.0004	0.00043702125549316	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.0006	0.00057411193847656	SELECT value FROM productattributes WHERE product_id = '4581' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0007	0.00068807601928711	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.0006	0.00059294700622559	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.0004	0.00044989585876465	SELECT * FROM products WHERE id = '1099'
134	0.0005	0.00047397613525391	SELECT * FROM productimages WHERE product_id = '1099' ORDER BY sortorder ASC
135	0.0004	0.00039196014404297	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.0006	0.00062918663024902	SELECT * FROM product_image_select WHERE product_id = '1099'
137	0.0004	0.00039887428283691	SELECT * FROM productcustomimages WHERE product_id = '1099'
138	0.0005	0.00053787231445312	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.0006	0.00059890747070312	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.0004	0.00036382675170898	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.0013	0.0012950897216797	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1099' AND a.name = n.originalname
142	0.0004	0.00043296813964844	SELECT * FROM productoffers WHERE product_id = '1099' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0004	0.00042390823364258	SELECT * FROM productoffers WHERE product_id = '1099' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0005	0.00048589706420898	SELECT * FROM productoffers WHERE product_id = 1099 ORDER BY price ASC LIMIT 1
145	0.0005	0.00048398971557617	SELECT value FROM productattributes WHERE product_id = '1099' AND name = 'ListPriceAmount'
146	0.0006	0.00056982040405273	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.00071597099304199	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.0004	0.00041890144348145	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.0007	0.00065898895263672	SELECT value FROM productattributes WHERE product_id = '1099' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150	0.0005	0.00052094459533691	SELECT * FROM products WHERE parent_id = '1099'
151	0.0007	0.00065994262695312	SELECT * FROM products WHERE id = '1075'
152	0.0005	0.00053000450134277	SELECT * FROM productimages WHERE product_id = '1075' ORDER BY sortorder ASC
153	0.0007	0.00073099136352539	SELECT * FROM product_image_select WHERE product_id = '1075'
154	0.0005	0.00048398971557617	SELECT * FROM productcustomimages WHERE product_id = '1075'
155	0.0012	0.0012030601501465	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.00059890747070312	SELECT * FROM productoffers WHERE product_id = '1075' AND merchantid = 'A1X6FK5RDHNB96'
157	0.0009	0.00089502334594727	SELECT * FROM productoffers WHERE product_id = '1075' AND price > 0 ORDER BY price ASC LIMIT 1
158	0.0006	0.00055789947509766	SELECT * FROM productoffers WHERE product_id = 1075 ORDER BY price ASC LIMIT 1
159	0.0005	0.00050616264343262	SELECT value FROM productattributes WHERE product_id = '1075' AND name = 'ListPriceAmount'
160	0.0006	0.00062108039855957	SELECT value FROM productattributes WHERE product_id = '1075' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161	0.0008	0.00082683563232422	SELECT * FROM products WHERE id = '4560'
162	0.0008	0.0007939338684082	SELECT * FROM productimages WHERE product_id = '4560' ORDER BY sortorder ASC
163	0.0006	0.00059390068054199	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.0009	0.00086593627929688	SELECT * FROM product_image_select WHERE product_id = '4560'
165	0.0005	0.00052189826965332	SELECT * FROM productcustomimages WHERE product_id = '4560'
166	0.0009	0.00085997581481934	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.0011	0.0010740756988525	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.0006	0.00057506561279297	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.0021	0.0021100044250488	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.00054788589477539	SELECT * FROM productoffers WHERE product_id = '4560' AND merchantid = 'A1X6FK5RDHNB96'
171	0.0006	0.00056600570678711	SELECT * FROM productoffers WHERE product_id = '4560' AND price > 0 ORDER BY price ASC LIMIT 1
172	0.0009	0.00089097023010254	SELECT * FROM productoffers WHERE product_id = 4560 ORDER BY price ASC LIMIT 1
173	0.0005	0.00051498413085938	SELECT value FROM productattributes WHERE product_id = '4560' AND name = 'ListPriceAmount'
174	0.0006	0.00059008598327637	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.0010	0.0009610652923584	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.0006	0.00058102607727051	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.0009	0.00085115432739258	SELECT value FROM productattributes WHERE product_id = '4560' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178	0.0010	0.0010099411010742	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.0012	0.0012450218200684	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.0006	0.00064396858215332	SELECT * FROM products WHERE parent_id = '4560'
181	0.0018	0.0018138885498047	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4561' AND a.name = n.originalname
182	0.0006	0.00064492225646973	SELECT * FROM productoffers WHERE product_id = '4561' AND merchantid = 'A1X6FK5RDHNB96'
183	0.0005	0.00050711631774902	SELECT * FROM productoffers WHERE product_id = '4561' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0006	0.0005638599395752	SELECT * FROM productoffers WHERE product_id = 4561 ORDER BY price ASC LIMIT 1
185	0.0006	0.00058412551879883	SELECT value FROM productattributes WHERE product_id = '4561' AND name = 'ListPriceAmount'
186	0.0007	0.00069808959960938	SELECT * FROM products WHERE id = '3772'
187	0.0006	0.00064492225646973	SELECT * FROM productimages WHERE product_id = '3772' ORDER BY sortorder ASC
188	0.0008	0.00084710121154785	SELECT * FROM product_image_select WHERE product_id = '3772'
189	0.0005	0.00052213668823242	SELECT * FROM productcustomimages WHERE product_id = '3772'
190	0.0018	0.0017929077148438	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3772' AND a.name = n.originalname
191	0.0006	0.00059986114501953	SELECT * FROM productoffers WHERE product_id = '3772' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '3772' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0005	0.00051093101501465	SELECT value FROM productattributes WHERE product_id = '3772' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194	0.0007	0.00069999694824219	SELECT * FROM products WHERE id = '1238'
195	0.0006	0.00058698654174805	SELECT * FROM productimages WHERE product_id = '1238' ORDER BY sortorder ASC
196	0.0005	0.00052404403686523	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.0007	0.00074505805969238	SELECT * FROM product_image_select WHERE product_id = '1238'
198	0.0005	0.00052809715270996	SELECT * FROM productcustomimages WHERE product_id = '1238'
199	0.0009	0.00087904930114746	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.0007	0.00069713592529297	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.0014	0.0013859272003174	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.0010	0.0010440349578857	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1238' AND a.name = n.originalname
203	0.0005	0.00046682357788086	SELECT * FROM productoffers WHERE product_id = '1238' AND merchantid = 'A1X6FK5RDHNB96'
204	0.0004	0.00044798851013184	SELECT * FROM productoffers WHERE product_id = '1238' AND price > 0 ORDER BY price ASC LIMIT 1
205	0.0004	0.00040698051452637	SELECT * FROM productoffers WHERE product_id = 1238 ORDER BY price ASC LIMIT 1
206	0.0005	0.00052595138549805	SELECT value FROM productattributes WHERE product_id = '1238' AND name = 'ListPriceAmount'
207	0.0005	0.0004880428314209	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.0008	0.0008080005645752	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.0005	0.0004880428314209	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.0007	0.00065088272094727	SELECT value FROM productattributes WHERE product_id = '1238' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211	0.0005	0.00051093101501465	SELECT * FROM products WHERE parent_id = '1238'
212	0.0006	0.00061988830566406	SELECT * FROM products WHERE id = '1261'
213	0.0007	0.00066590309143066	SELECT * FROM productimages WHERE product_id = '1261' ORDER BY sortorder ASC
214	0.0008	0.00076103210449219	SELECT * FROM product_image_select WHERE product_id = '1261'
215	0.0005	0.00047492980957031	SELECT * FROM productcustomimages WHERE product_id = '1261'
216	0.0022	0.0021979808807373	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1261' AND a.name = n.originalname
217	0.0037	0.003695011138916	SELECT * FROM productoffers WHERE product_id = '1261' AND merchantid = 'A1X6FK5RDHNB96'
218	0.0012	0.0011880397796631	SELECT * FROM productoffers WHERE product_id = '1261' AND price > 0 ORDER BY price ASC LIMIT 1
219	0.0007	0.00072288513183594	SELECT * FROM productoffers WHERE product_id = 1261 ORDER BY price ASC LIMIT 1
220	0.0008	0.00077605247497559	SELECT value FROM productattributes WHERE product_id = '1261' AND name = 'ListPriceAmount'
221	0.0009	0.000885009765625	SELECT value FROM productattributes WHERE product_id = '1261' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222	0.0016	0.0015549659729004	SELECT * FROM products WHERE id = '4007'
223	0.0011	0.0011410713195801	SELECT * FROM productimages WHERE product_id = '4007' ORDER BY sortorder ASC
224	0.0020	0.0019841194152832	SELECT * FROM product_image_select WHERE product_id = '4007'
225	0.0008	0.00084686279296875	SELECT * FROM productcustomimages WHERE product_id = '4007'
226	0.0036	0.0035610198974609	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4007' AND a.name = n.originalname
227	0.0016	0.0015640258789062	SELECT * FROM productoffers WHERE product_id = '4007' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0009	0.00090503692626953	SELECT * FROM productoffers WHERE product_id = '4007' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0012	0.0012350082397461	SELECT value FROM productattributes WHERE product_id = '4007' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230	0.0014	0.0013577938079834	SELECT * FROM products WHERE id = '1638'
231	0.0008	0.00079703330993652	SELECT * FROM productimages WHERE product_id = '1638' ORDER BY sortorder ASC
232	0.0010	0.0010340213775635	SELECT * FROM product_image_select WHERE product_id = '1638'
233	0.0007	0.00072312355041504	SELECT * FROM productcustomimages WHERE product_id = '1638'
234	0.0019	0.001924991607666	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1638' AND a.name = n.originalname
235	0.0008	0.000762939453125	SELECT * FROM productoffers WHERE product_id = '1638' AND merchantid = 'A1X6FK5RDHNB96'
236	0.0006	0.00064897537231445	SELECT * FROM productoffers WHERE product_id = '1638' AND price > 0 ORDER BY price ASC LIMIT 1
237	0.0008	0.00075006484985352	SELECT value FROM productattributes WHERE product_id = '1638' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238	0.0008	0.00079798698425293	SELECT * FROM products WHERE id = '2683'
239	0.0008	0.00077199935913086	SELECT * FROM productimages WHERE product_id = '2683' ORDER BY sortorder ASC
240	0.0018	0.0018298625946045	SELECT * FROM product_image_select WHERE product_id = '2683'
241	0.0006	0.00060391426086426	SELECT * FROM productcustomimages WHERE product_id = '2683'
242	0.0018	0.0018250942230225	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.00067496299743652	SELECT * FROM productoffers WHERE product_id = '2683' AND merchantid = 'A1X6FK5RDHNB96'
244	0.0007	0.00066208839416504	SELECT * FROM productoffers WHERE product_id = '2683' AND price > 0 ORDER BY price ASC LIMIT 1
245	0.0006	0.00061798095703125	SELECT * FROM productoffers WHERE product_id = 2683 ORDER BY price ASC LIMIT 1
246	0.0007	0.0006721019744873	SELECT value FROM productattributes WHERE product_id = '2683' AND name = 'ListPriceAmount'
247	0.0006	0.00061202049255371	SELECT value FROM productattributes WHERE product_id = '2683' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248	0.0008	0.00078797340393066	SELECT * FROM products WHERE id = '1508'
249	0.0007	0.00067996978759766	SELECT * FROM productimages WHERE product_id = '1508' ORDER BY sortorder ASC
250	0.0011	0.0011398792266846	SELECT * FROM product_image_select WHERE product_id = '1508'
251	0.0006	0.00058889389038086	SELECT * FROM productcustomimages WHERE product_id = '1508'
252	0.0019	0.0019471645355225	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.00072503089904785	SELECT * FROM productoffers WHERE product_id = '1508' AND merchantid = 'A1X6FK5RDHNB96'
254	0.0005	0.00054597854614258	SELECT * FROM productoffers WHERE product_id = '1508' AND price > 0 ORDER BY price ASC LIMIT 1
255	0.0005	0.00049400329589844	SELECT * FROM productoffers WHERE product_id = 1508 ORDER BY price ASC LIMIT 1
256	0.0006	0.00059890747070312	SELECT value FROM productattributes WHERE product_id = '1508' AND name = 'ListPriceAmount'
257	0.0007	0.00068783760070801	SELECT value FROM productattributes WHERE product_id = '1508' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258	0.0009	0.00087714195251465	SELECT * FROM products WHERE id = '1382'
259	0.0013	0.001255989074707	SELECT * FROM productimages WHERE product_id = '1382' ORDER BY sortorder ASC
260	0.0009	0.00092196464538574	SELECT * FROM product_image_select WHERE product_id = '1382'
261	0.0007	0.000701904296875	SELECT * FROM productcustomimages WHERE product_id = '1382'
262	0.0056	0.0056478977203369	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1382' AND a.name = n.originalname
263	0.0014	0.0014338493347168	SELECT * FROM productoffers WHERE product_id = '1382' AND merchantid = 'A1X6FK5RDHNB96'
264	0.0006	0.0006260871887207	SELECT * FROM productoffers WHERE product_id = '1382' AND price > 0 ORDER BY price ASC LIMIT 1
265	0.0006	0.00055503845214844	SELECT * FROM productoffers WHERE product_id = 1382 ORDER BY price ASC LIMIT 1
266	0.0006	0.00059008598327637	SELECT value FROM productattributes WHERE product_id = '1382' AND name = 'ListPriceAmount'
267	0.0008	0.0008089542388916	SELECT value FROM productattributes WHERE product_id = '1382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268	0.0008	0.00076007843017578	SELECT * FROM products WHERE id = '3664'
269	0.0007	0.00070595741271973	SELECT * FROM productimages WHERE product_id = '3664' ORDER BY sortorder ASC
270	0.0009	0.00087809562683105	SELECT * FROM product_image_select WHERE product_id = '3664'
271	0.0005	0.0005488395690918	SELECT * FROM productcustomimages WHERE product_id = '3664'
272	0.0013	0.0013179779052734	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3664' AND a.name = n.originalname
273	0.0007	0.00066995620727539	SELECT * FROM productoffers WHERE product_id = '3664' AND merchantid = 'A1X6FK5RDHNB96'
274	0.0007	0.00067901611328125	SELECT * FROM productoffers WHERE product_id = '3664' AND price > 0 ORDER BY price ASC LIMIT 1
275	0.0013	0.0012588500976562	SELECT * FROM productoffers WHERE product_id = 3664 ORDER BY price ASC LIMIT 1
276	0.0008	0.00082612037658691	SELECT value FROM productattributes WHERE product_id = '3664' AND name = 'ListPriceAmount'
277	0.0007	0.00066804885864258	SELECT value FROM productattributes WHERE product_id = '3664' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
278	0.0009	0.00093793869018555	SELECT * FROM products WHERE id = '3748'
279	0.0008	0.00084114074707031	SELECT * FROM productimages WHERE product_id = '3748' ORDER BY sortorder ASC
280	0.0010	0.00097990036010742	SELECT * FROM product_image_select WHERE product_id = '3748'
281	0.0008	0.00080394744873047	SELECT * FROM productcustomimages WHERE product_id = '3748'
282	0.0020	0.0019850730895996	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3748' AND a.name = n.originalname
283	0.0007	0.0007169246673584	SELECT * FROM productoffers WHERE product_id = '3748' AND merchantid = 'A1X6FK5RDHNB96'
284	0.0006	0.000640869140625	SELECT * FROM productoffers WHERE product_id = '3748' AND price > 0 ORDER BY price ASC LIMIT 1
285	0.0005	0.00054693222045898	SELECT * FROM productoffers WHERE product_id = 3748 ORDER BY price ASC LIMIT 1
286	0.0006	0.00061392784118652	SELECT value FROM productattributes WHERE product_id = '3748' AND name = 'ListPriceAmount'
287	0.0008	0.00076413154602051	SELECT value FROM productattributes WHERE product_id = '3748' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288	0.0010	0.0010180473327637	SELECT * FROM products WHERE id = '1098'
289	0.0007	0.00069212913513184	SELECT * FROM productimages WHERE product_id = '1098' ORDER BY sortorder ASC
290	0.0014	0.0013680458068848	SELECT * FROM product_image_select WHERE product_id = '1098'
291	0.0007	0.00073719024658203	SELECT * FROM productcustomimages WHERE product_id = '1098'
292	0.0028	0.0027720928192139	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1098' AND a.name = n.originalname
293	0.0010	0.001007080078125	SELECT * FROM productoffers WHERE product_id = '1098' AND merchantid = 'A1X6FK5RDHNB96'
294	0.0008	0.00075101852416992	SELECT * FROM productoffers WHERE product_id = '1098' AND price > 0 ORDER BY price ASC LIMIT 1
295	0.0014	0.0013539791107178	SELECT * FROM productoffers WHERE product_id = 1098 ORDER BY price ASC LIMIT 1
296	0.0016	0.0016298294067383	SELECT value FROM productattributes WHERE product_id = '1098' AND name = 'ListPriceAmount'
297	0.0020	0.0019540786743164	SELECT value FROM productattributes WHERE product_id = '1098' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298	0.0012	0.0011940002441406	SELECT * FROM products WHERE id = '925'
299	0.0025	0.0024919509887695	SELECT * FROM productimages WHERE product_id = '925' ORDER BY sortorder ASC
300	0.0018	0.0017759799957275	SELECT * FROM product_image_select WHERE product_id = '925'
301	0.0008	0.00078606605529785	SELECT * FROM productcustomimages WHERE product_id = '925'
302	0.0102	0.010190010070801	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '925' AND a.name = n.originalname
303	0.0009	0.00093197822570801	SELECT * FROM productoffers WHERE product_id = '925' AND merchantid = 'A1X6FK5RDHNB96'
304	0.0005	0.00053691864013672	SELECT * FROM productoffers WHERE product_id = '925' AND price > 0 ORDER BY price ASC LIMIT 1
305	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = 925 ORDER BY price ASC LIMIT 1
306	0.0005	0.00045418739318848	SELECT value FROM productattributes WHERE product_id = '925' AND name = 'ListPriceAmount'
307	0.0005	0.00052785873413086	SELECT value FROM productattributes WHERE product_id = '925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
308	0.0008	0.00082302093505859	SELECT * FROM products WHERE id = '761'
309	0.0006	0.00064802169799805	SELECT * FROM productimages WHERE product_id = '761' ORDER BY sortorder ASC
310	0.0008	0.00083208084106445	SELECT * FROM product_image_select WHERE product_id = '761'
311	0.0005	0.00048208236694336	SELECT * FROM productcustomimages WHERE product_id = '761'
312	0.0016	0.0016031265258789	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '761' AND a.name = n.originalname
313	0.0007	0.0006711483001709	SELECT * FROM productoffers WHERE product_id = '761' AND merchantid = 'A1X6FK5RDHNB96'
314	0.0005	0.00050497055053711	SELECT * FROM productoffers WHERE product_id = '761' AND price > 0 ORDER BY price ASC LIMIT 1
315	0.0005	0.00050210952758789	SELECT * FROM productoffers WHERE product_id = 761 ORDER BY price ASC LIMIT 1
316	0.0005	0.00051403045654297	SELECT value FROM productattributes WHERE product_id = '761' AND name = 'ListPriceAmount'
317	0.0004	0.00044703483581543	SELECT value FROM productattributes WHERE product_id = '761' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318	0.0020	0.0020060539245605	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '780' ORDER BY timestamp DESC
319	0.0004	0.00043010711669922	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4581' ORDER BY timestamp DESC
320	0.0004	0.00042414665222168	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1099' ORDER BY timestamp DESC
321	0.0004	0.00038886070251465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1075' ORDER BY timestamp DESC
322	0.0004	0.00040006637573242	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4560' ORDER BY timestamp DESC
323	0.0004	0.00040102005004883	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3772' ORDER BY timestamp DESC
324	0.0004	0.00043320655822754	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1238' ORDER BY timestamp DESC
325	0.0005	0.00047707557678223	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1261' ORDER BY timestamp DESC
326	0.0004	0.00043201446533203	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4007' ORDER BY timestamp DESC
327	0.0005	0.00049996376037598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1638' ORDER BY timestamp DESC
328	0.0004	0.00038814544677734	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2683' ORDER BY timestamp DESC
329	0.0006	0.00056910514831543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1508' ORDER BY timestamp DESC
330	0.0005	0.00048089027404785	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1382' ORDER BY timestamp DESC
331	0.0005	0.00046396255493164	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3664' ORDER BY timestamp DESC
332	0.0004	0.0003659725189209	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3748' ORDER BY timestamp DESC
333	0.0006	0.00059890747070312	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1098' ORDER BY timestamp DESC
334	0.0006	0.00057721138000488	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '925' ORDER BY timestamp DESC
335	0.0005	0.00045990943908691	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '761' ORDER BY timestamp DESC
336	0.0023	0.0023360252380371	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
337	0.0019	0.0018699169158936	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
338	0.0005	0.00046610832214355	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
339	0.0172	0.017232894897461	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.0020	0.0019550323486328	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.0006110668182373	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.00060391426086426	SELECT * FROM products WHERE id = 1626
343	0.0007	0.00065708160400391	SELECT * FROM products WHERE id = 4041
344	0.0006	0.0006101131439209	SELECT * FROM products WHERE id = 4312
345	0.0012	0.0012009143829346	SELECT * FROM products WHERE id = 777
346	0.0006	0.0005650520324707	SELECT * FROM products WHERE id = 3881
347	0.0026	0.002579927444458	SELECT * FROM products WHERE id = 4213
348	0.0009	0.00091218948364258	SELECT * FROM products WHERE id = '1626'
349	0.0009	0.00092291831970215	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
350	0.0020	0.0019679069519043	SELECT * FROM product_image_select WHERE product_id = '1626'
351	0.0010	0.00098204612731934	SELECT * FROM productcustomimages WHERE product_id = '1626'
352	0.0040	0.004004955291748	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
353	0.0011	0.0011138916015625	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
354	0.0012	0.0012249946594238	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
355	0.0010	0.00097489356994629	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356	0.0011	0.0010881423950195	SELECT * FROM products WHERE id = '4041'
357	0.0008	0.00078892707824707	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
358	0.0012	0.0012128353118896	SELECT * FROM product_image_select WHERE product_id = '4041'
359	0.0006	0.00064706802368164	SELECT * FROM productcustomimages WHERE product_id = '4041'
360	0.0025	0.0024590492248535	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
361	0.0010	0.0010268688201904	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
362	0.0013	0.0012831687927246	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
363	0.0011	0.0010678768157959	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364	0.0013	0.0012650489807129	SELECT * FROM products WHERE id = '4312'
365	0.0011	0.0010740756988525	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
366	0.0016	0.0016000270843506	SELECT * FROM product_image_select WHERE product_id = '4312'
367	0.0008	0.00080204010009766	SELECT * FROM productcustomimages WHERE product_id = '4312'
368	0.0021	0.002072811126709	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
369	0.0007	0.00071382522583008	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
370	0.0007	0.00070595741271973	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
371	0.0009	0.00089192390441895	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372	0.0009	0.00088095664978027	SELECT * FROM products WHERE id = '777'
373	0.0006	0.00064492225646973	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
374	0.0008	0.00078582763671875	SELECT * FROM product_image_select WHERE product_id = '777'
375	0.0008	0.00080299377441406	SELECT * FROM productcustomimages WHERE product_id = '777'
376	0.0022	0.0022270679473877	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
377	0.0008	0.00080680847167969	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
378	0.0007	0.00066804885864258	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
379	0.0007	0.0007469654083252	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
380	0.0011	0.0011050701141357	SELECT * FROM products WHERE id = '3881'
381	0.0013	0.0013339519500732	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
382	0.0015	0.0014901161193848	SELECT * FROM product_image_select WHERE product_id = '3881'
383	0.0007	0.00074100494384766	SELECT * FROM productcustomimages WHERE product_id = '3881'
384	0.0028	0.002795934677124	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
385	0.0010	0.00097799301147461	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
386	0.0007	0.00071406364440918	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
387	0.0008	0.00079488754272461	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
388	0.0011	0.0011072158813477	SELECT * FROM products WHERE id = '4213'
389	0.0012	0.0011758804321289	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
390	0.0013	0.0013449192047119	SELECT * FROM product_image_select WHERE product_id = '4213'
391	0.0008	0.00080108642578125	SELECT * FROM productcustomimages WHERE product_id = '4213'
392	0.0035	0.0034949779510498	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
393	0.0010	0.001046895980835	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
394	0.0007	0.00070905685424805	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
395	0.0009	0.00086688995361328	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
396	0.0036	0.0035791397094727	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
397	0.0012	0.0011980533599854	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
398	0.0041	0.0040819644927979	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
399	0.0026	0.0025589466094971	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
400	0.0009	0.0009000301361084	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
401	0.0011	0.0010731220245361	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
402	0.0014	0.001431941986084	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.8956689834595 seconds

Query Debug - 402 Database Queries. Total time 1.0184 seconds