Search Results for "2"

LUNA VOW Luna Vœu Japonais Céramique Boî...

View to See Price

View

Add to Cart

Thé hermétique peuvent, boîte à thé de s...

View to See Price

View

Add to Cart

CARMANI - Motif inspiré de la nature, Co...

View to See Price

View

Add to Cart

Portal Cool 20 Graines rares Aspalathus ...

only €9,78

View

Add to Cart

Backbayia Boîtes de Rangement avec Couve...

only €18,39

View

Add to Cart

Ocun Eternal Pants

View to See Price

View

Add to Cart

Lot de 2 boîtes de thé Miss miew Sandy +...

View to See Price

View

Add to Cart

Neuf en bois Blanc 9 Compartiment Sachet...

View to See Price

View

Add to Cart

VAN HOUTEN Boîte de 8 Sachets Individuel...

View to See Price

View

Add to Cart

GLQ Boîtes à thé/Boîtes métalliques Rond...

View to See Price

View

Add to Cart

SoBuy FRG259-N Boîte de rangement Boîte ...

View to See Price

View

Add to Cart

Dozili Tasse à café humoristique en céra...

View to See Price

View

Add to Cart

MK447B Boîte à thé en bambou 12 comparti...

View to See Price

View

Add to Cart

Kosma Lot de 3 Pièces en acier inoxydabl...

View to See Price

View

Add to Cart

Tedemecum Thé Rooibos Flor Del Desierto ...

only €6,90

View

Add to Cart

ParentCLIP20-ParentV3

View to See Price

View

Add to Cart

Tubayia Lot de 2 boîtes à thé en métal a...

only €19,71

View

Add to Cart

Tedemecum Rooorange Gourmet (25 x 2gr). ...

only €9,90

View

Add to Cart

469 to 486 of 532 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.3478791713715	403	1.0137	0

No Amazon API Requests Made.

App Debug - Total Time 1.3478791713715 seconds

Number	Time From Start	Name	Description
1	0.2937331199646	Initialise	Initialise FSB Function
2	0.29704308509827	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.33672499656677	Start of getCategoryListByGroup Function	Before first category groups query
4	0.33736515045166	After initial query	Before first category groups query
5	0.33736801147461	Get Category List for Group	Before the call to getCategoryList function
6	0.33737301826477	Start of GetCategoryList function	Start of the function
7	0.33737802505493	Before getting categories	Query to get specific category list
8	0.33810305595398	After getting categories	Query to get specific category list
9	0.33810615539551	Before getting category custom	Before call to function getCategoryCustom
10	0.35403513908386	After getting category custom	After call to function getCategoryCustom
11	0.35404014587402	Before getting category custom	Before call to function getCategoryCustom
12	0.36547613143921	After getting category custom	After call to function getCategoryCustom
13	0.36548209190369	Before getting category custom	Before call to function getCategoryCustom
14	0.37238121032715	After getting category custom	After call to function getCategoryCustom
15	0.37238621711731	Before getting category custom	Before call to function getCategoryCustom
16	0.38040113449097	After getting category custom	After call to function getCategoryCustom
17	0.38040709495544	Before getting category custom	Before call to function getCategoryCustom
18	0.39028120040894	After getting category custom	After call to function getCategoryCustom
19	0.3902862071991	Before getting category custom	Before call to function getCategoryCustom
20	0.39834403991699	After getting category custom	After call to function getCategoryCustom
21	0.39834809303284	End of GetCategoryList function	End of the function
22	0.39835500717163	Get Category List for Group	Before the call to getCategoryList function
23	0.39835715293884	Start of GetCategoryList function	Start of the function
24	0.39836001396179	Before getting categories	Query to get specific category list
25	0.39940905570984	End of getCategoryListByGroup Function	Before return()
26	1.0257740020752	App Controller End	End of the App controller (called before the controller of every page)
27	1.2465410232544	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.2474992275238	Before Get Options	Before the call to getOptions in the tpl class
29	1.308981180191	After Get Options	After the call to getOptions in the tpl class
30	1.3090150356293	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.3478569984436	Finalizing debug	Before the debug is output to the page.
32	1.3478770256042	End of App	This is the end of the app logging, final timestamp

Query Debug - 403 Database Queries. Total time 1.0137 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:\"3.133.120.119\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738873014'
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('3.133.120.119') >= INET_ATON(ip_start) AND INET_ATON('3.133.120.119') <= 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(), '3.133.120.119'
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 = '3175'
SELECT * FROM productimages WHERE product_id = '3175' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3175'
SELECT * FROM productcustomimages WHERE product_id = '3175'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3175' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3175' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3175' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3175
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3175'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3214'
SELECT * FROM productimages WHERE product_id = '3214' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3214' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3214'
SELECT * FROM productcustomimages WHERE product_id = '3214'
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 = '3214'
                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     = '3214'
                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 = 3214
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3214' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3214' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3214' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3214
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3214'
                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 = '3214'
                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     = '3214'
                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 = 3214
SELECT value FROM productattributes WHERE product_id = '3214' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3214'
                  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 = '3214'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4803' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4803' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4803' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4803
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4803'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3601'
SELECT * FROM productimages WHERE product_id = '3601' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3601'
SELECT * FROM productcustomimages WHERE product_id = '3601'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3601' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3601' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3601' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3601
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3601'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3281'
SELECT * FROM productimages WHERE product_id = '3281' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3281'
SELECT * FROM productcustomimages WHERE product_id = '3281'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3281' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3281' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3281' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3281
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3281'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3281' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3407'
SELECT * FROM productimages WHERE product_id = '3407' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3407'
SELECT * FROM productcustomimages WHERE product_id = '3407'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3407' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3407' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3407' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3434'
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3434'
SELECT * FROM productcustomimages WHERE product_id = '3434'
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 = '3434'
                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     = '3434'
                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 = 3434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3434'
                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 = '3434'
                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     = '3434'
                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 = 3434
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  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     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '3464'
SELECT * FROM productimages WHERE product_id = '3464' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3464'
SELECT * FROM productcustomimages WHERE product_id = '3464'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3464' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3464' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3464' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3464
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3464'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3464' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3472'
SELECT * FROM productimages WHERE product_id = '3472' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3472'
SELECT * FROM productcustomimages WHERE product_id = '3472'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3472' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3472' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3472' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3472
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3472'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4943'
SELECT * FROM productimages WHERE product_id = '4943' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4943'
SELECT * FROM productcustomimages WHERE product_id = '4943'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4943' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4943' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4943' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4943
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4943'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3600'
SELECT * FROM productimages WHERE product_id = '3600' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3600'
SELECT * FROM productcustomimages WHERE product_id = '3600'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3600' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3600' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3600' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3600
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3600'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3738'
SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3738'
SELECT * FROM productcustomimages WHERE product_id = '3738'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3738' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3738
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3738'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3613'
SELECT * FROM productimages WHERE product_id = '3613' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3613'
SELECT * FROM productcustomimages WHERE product_id = '3613'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3613' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3613' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3613' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3613
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3613'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3613' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3623'
SELECT * FROM productimages WHERE product_id = '3623' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3623'
SELECT * FROM productcustomimages WHERE product_id = '3623'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3623' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3623' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3623' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3623
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3623'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3623' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3658'
SELECT * FROM productimages WHERE product_id = '3658' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3658' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3658'
SELECT * FROM productcustomimages WHERE product_id = '3658'
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 = '3658'
                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     = '3658'
                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 = 3658
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3658' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3658' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3658' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3658
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3658'
                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 = '3658'
                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     = '3658'
                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 = 3658
SELECT value FROM productattributes WHERE product_id = '3658' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3658'
                  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 = '3658'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4518' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4518' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4518' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4518
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4518'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '3665'
SELECT * FROM productimages WHERE product_id = '3665' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3665'
SELECT * FROM productcustomimages WHERE product_id = '3665'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3665' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3665
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3665'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3676'
SELECT * FROM productimages WHERE product_id = '3676' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3676'
SELECT * FROM productcustomimages WHERE product_id = '3676'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3676' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3676' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3676' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3676
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3676'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3676' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3687'
SELECT * FROM productimages WHERE product_id = '3687' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3687'
SELECT * FROM productcustomimages WHERE product_id = '3687'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3687' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3687' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3687' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3687' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3704'
SELECT * FROM productimages WHERE product_id = '3704' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3704'
SELECT * FROM productcustomimages WHERE product_id = '3704'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3704' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3704' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3704' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3704
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3704'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3704' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3175' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3214' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3601' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3281' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3407' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3464' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3472' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4943' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3600' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3613' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3623' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3658' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3665' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3676' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3687' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3704' 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.0018	0.0018329620361328	SELECT parameter, value FROM parameters
2	0.0053	0.0053310394287109	SELECT * FROM `bad_bots`
3	0.0006	0.00057411193847656	SET time_zone = 'Europe/London'
4	0.0017	0.0017428398132324	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0015	0.0014698505401611	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.133.120.119\";}'
6	0.0010	0.0010490417480469	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738873014'
7	0.0014	0.0013930797576904	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0006	0.00061392784118652	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0010	0.0010299682617188	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0008	0.00079703330993652	SELECT * FROM pages WHERE id = 52
11	0.0042	0.0042350292205811	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0342	0.034219026565552	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0005	0.00054812431335449	SELECT * FROM pages WHERE pagename = 'search'
14	0.0006	0.00062108039855957	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0007	0.00069594383239746	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0059	0.0058860778808594	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.0006	0.00060606002807617	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0005	0.00046300888061523	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00052094459533691	SELECT id FROM categories WHERE parent_id = '26'
20	0.0058	0.0058128833770752	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.0006	0.000579833984375	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0006	0.0005800724029541	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.0007	0.00074982643127441	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.0005180835723877	SELECT * FROM categorygroups WHERE id = '1'
25	0.0038	0.0038168430328369	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0005	0.00053787231445312	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.0005	0.00047993659973145	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.00045299530029297	SELECT id FROM categories WHERE parent_id = '27'
29	0.0038	0.0038309097290039	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.00056886672973633	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.00059008598327637	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.0005	0.00051093101501465	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00045108795166016	SELECT * FROM categorygroups WHERE id = '1'
34	0.0016	0.0015928745269775	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0005	0.00053095817565918	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.00047492980957031	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00052809715270996	SELECT id FROM categories WHERE parent_id = '28'
38	0.0016	0.0015621185302734	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.0005	0.00053095817565918	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.0005	0.00054812431335449	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0005	0.00053191184997559	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0004	0.00044393539428711	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00078606605529785	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0006	0.00064396858215332	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.0005	0.00047707557678223	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00053691864013672	SELECT id FROM categories WHERE parent_id = '29'
47	0.0007	0.00069999694824219	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.0008	0.00078511238098145	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.0018	0.0018379688262939	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.0012	0.0012340545654297	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0009	0.00085091590881348	SELECT * FROM categorygroups WHERE id = '1'
52	0.0014	0.0014021396636963	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.0011	0.0010828971862793	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.0010	0.00098085403442383	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0011	0.0010509490966797	SELECT id FROM categories WHERE parent_id = '30'
56	0.0017	0.0016629695892334	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.0009	0.00092506408691406	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.0011	0.0011110305786133	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0008	0.00081396102905273	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0007	0.00069594383239746	SELECT * FROM categorygroups WHERE id = '1'
61	0.0012	0.0012130737304688	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.0008	0.00075387954711914	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.0007	0.00073003768920898	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0008	0.00078797340393066	SELECT id FROM categories WHERE parent_id = '31'
65	0.0014	0.0013818740844727	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.0008	0.00080394744873047	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.0009	0.0008549690246582	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.0008	0.00077605247497559	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0006	0.00062012672424316	SELECT * FROM categorygroups WHERE id = '1'
70	0.0010	0.0010368824005127	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0041	0.0040860176086426	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0025	0.002532958984375	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0013	0.0012679100036621	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.0006	0.00059103965759277	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0020	0.0019540786743164	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0015	0.0015389919281006	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.6100	0.6099898815155	SELECT * FROM ipgeocountries WHERE INET_ATON('3.133.120.119') >= INET_ATON(ip_start) AND INET_ATON('3.133.120.119') <= INET_ATON(ip_end)
78	0.0015	0.0014920234680176	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0009	0.00087809562683105	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0005	0.00052905082702637	SELECT * FROM pages WHERE pagename = 'search'
81	0.0072	0.0072000026702881	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0019	0.0019140243530273	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0008	0.00080084800720215	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0069	0.0069038867950439	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0018	0.0018281936645508	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0005	0.00051498413085938	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0034	0.0034210681915283	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '3.133.120.119'
88	0.0011	0.0011391639709473	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.0006	0.00058889389038086	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.0067	0.0067100524902344	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
91	0.0007	0.00073790550231934	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.0006	0.00058317184448242	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.0007	0.00065994262695312	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.0061	0.0060510635375977	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.00039386749267578	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.00033903121948242	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.0007	0.00065279006958008	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0006	0.00057601928710938	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.0053	0.0052931308746338	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.00033116340637207	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.0006	0.00058817863464355	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.0015	0.0015158653259277	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.0071	0.0070950984954834	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.00041890144348145	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
105	0.0004	0.00037884712219238	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.0006	0.00059795379638672	SELECT * FROM products WHERE id = '3175'
107	0.0007	0.00074386596679688	SELECT * FROM productimages WHERE product_id = '3175' ORDER BY sortorder ASC
108	0.0007	0.00072717666625977	SELECT * FROM product_image_select WHERE product_id = '3175'
109	0.0005	0.00046110153198242	SELECT * FROM productcustomimages WHERE product_id = '3175'
110	0.0015	0.0015377998352051	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3175' AND a.name = n.originalname
111	0.0006	0.000579833984375	SELECT * FROM productoffers WHERE product_id = '3175' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0005	0.00045585632324219	SELECT * FROM productoffers WHERE product_id = '3175' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0005	0.00048589706420898	SELECT * FROM productoffers WHERE product_id = 3175 ORDER BY price ASC LIMIT 1
114	0.0005	0.00046801567077637	SELECT value FROM productattributes WHERE product_id = '3175' AND name = 'ListPriceAmount'
115	0.0006	0.00055503845214844	SELECT value FROM productattributes WHERE product_id = '3175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116	0.0007	0.00068306922912598	SELECT * FROM products WHERE id = '3214'
117	0.0006	0.00060510635375977	SELECT * FROM productimages WHERE product_id = '3214' ORDER BY sortorder ASC
118	0.0005	0.00054812431335449	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3214' AND p.id = pi.product_id ORDER BY pi.sortorder
119	0.0007	0.00074005126953125	SELECT * FROM product_image_select WHERE product_id = '3214'
120	0.0012	0.0011529922485352	SELECT * FROM productcustomimages WHERE product_id = '3214'
121	0.0014	0.0013809204101562	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 = '3214' GROUP BY o.product_id
122	0.0017	0.0017268657684326	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 = '3214' GROUP BY n.displayname ORDER BY n.displayname DESC
123	0.0009	0.00091004371643066	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3214
124	0.0039	0.0039288997650146	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3214' AND a.name = n.originalname
125	0.0009	0.00087094306945801	SELECT * FROM productoffers WHERE product_id = '3214' AND merchantid = 'A1X6FK5RDHNB96'
126	0.0008	0.00082087516784668	SELECT * FROM productoffers WHERE product_id = '3214' AND price > 0 ORDER BY price ASC LIMIT 1
127	0.0007	0.00071287155151367	SELECT * FROM productoffers WHERE product_id = 3214 ORDER BY price ASC LIMIT 1
128	0.0008	0.00084114074707031	SELECT value FROM productattributes WHERE product_id = '3214' AND name = 'ListPriceAmount'
129	0.0009	0.00094985961914062	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 = '3214' GROUP BY o.product_id
130	0.0020	0.0019619464874268	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 = '3214' GROUP BY n.displayname ORDER BY n.displayname DESC
131	0.0005	0.00054502487182617	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3214
132	0.0007	0.00066709518432617	SELECT value FROM productattributes WHERE product_id = '3214' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0007	0.00074887275695801	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3214' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
134	0.0006	0.00060391426086426	SELECT * FROM products WHERE parent_id = '3214'
135	0.0007	0.00067400932312012	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4803' AND a.name = n.originalname
136	0.0006	0.00064182281494141	SELECT * FROM productoffers WHERE product_id = '4803' AND merchantid = 'A1X6FK5RDHNB96'
137	0.0005	0.00054192543029785	SELECT * FROM productoffers WHERE product_id = '4803' AND price > 0 ORDER BY price ASC LIMIT 1
138	0.0005	0.00045299530029297	SELECT * FROM productoffers WHERE product_id = 4803 ORDER BY price ASC LIMIT 1
139	0.0005	0.0005190372467041	SELECT value FROM productattributes WHERE product_id = '4803' AND name = 'ListPriceAmount'
140	0.0006	0.00056815147399902	SELECT * FROM products WHERE id = '3601'
141	0.0006	0.00062298774719238	SELECT * FROM productimages WHERE product_id = '3601' ORDER BY sortorder ASC
142	0.0007	0.00072598457336426	SELECT * FROM product_image_select WHERE product_id = '3601'
143	0.0005	0.00050497055053711	SELECT * FROM productcustomimages WHERE product_id = '3601'
144	0.0010	0.0010089874267578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3601' AND a.name = n.originalname
145	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '3601' AND merchantid = 'A1X6FK5RDHNB96'
146	0.0005	0.00050711631774902	SELECT * FROM productoffers WHERE product_id = '3601' AND price > 0 ORDER BY price ASC LIMIT 1
147	0.0005	0.00045490264892578	SELECT * FROM productoffers WHERE product_id = 3601 ORDER BY price ASC LIMIT 1
148	0.0005	0.00049185752868652	SELECT value FROM productattributes WHERE product_id = '3601' AND name = 'ListPriceAmount'
149	0.0006	0.00057792663574219	SELECT value FROM productattributes WHERE product_id = '3601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
150	0.0007	0.0007319450378418	SELECT * FROM products WHERE id = '3281'
151	0.0007	0.00070405006408691	SELECT * FROM productimages WHERE product_id = '3281' ORDER BY sortorder ASC
152	0.0009	0.00086188316345215	SELECT * FROM product_image_select WHERE product_id = '3281'
153	0.0006	0.00055599212646484	SELECT * FROM productcustomimages WHERE product_id = '3281'
154	0.0014	0.001399040222168	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3281' AND a.name = n.originalname
155	0.0006	0.00060892105102539	SELECT * FROM productoffers WHERE product_id = '3281' AND merchantid = 'A1X6FK5RDHNB96'
156	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = '3281' AND price > 0 ORDER BY price ASC LIMIT 1
157	0.0005	0.00050997734069824	SELECT * FROM productoffers WHERE product_id = 3281 ORDER BY price ASC LIMIT 1
158	0.0005	0.00049996376037598	SELECT value FROM productattributes WHERE product_id = '3281' AND name = 'ListPriceAmount'
159	0.0005	0.0004880428314209	SELECT value FROM productattributes WHERE product_id = '3281' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
160	0.0007	0.0006718635559082	SELECT * FROM products WHERE id = '3407'
161	0.0007	0.00070881843566895	SELECT * FROM productimages WHERE product_id = '3407' ORDER BY sortorder ASC
162	0.0008	0.00078082084655762	SELECT * FROM product_image_select WHERE product_id = '3407'
163	0.0006	0.00057315826416016	SELECT * FROM productcustomimages WHERE product_id = '3407'
164	0.0011	0.001060962677002	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3407' AND a.name = n.originalname
165	0.0006	0.00062918663024902	SELECT * FROM productoffers WHERE product_id = '3407' AND merchantid = 'A1X6FK5RDHNB96'
166	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '3407' AND price > 0 ORDER BY price ASC LIMIT 1
167	0.0006	0.00057697296142578	SELECT value FROM productattributes WHERE product_id = '3407' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
168	0.0007	0.00070405006408691	SELECT * FROM products WHERE id = '3434'
169	0.0009	0.00092601776123047	SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
170	0.0010	0.0010001659393311	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
171	0.0007	0.00074887275695801	SELECT * FROM product_image_select WHERE product_id = '3434'
172	0.0005	0.00049710273742676	SELECT * FROM productcustomimages WHERE product_id = '3434'
173	0.0008	0.00084280967712402	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 = '3434' GROUP BY o.product_id
174	0.0015	0.001471996307373	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 = '3434' GROUP BY n.displayname ORDER BY n.displayname DESC
175	0.0007	0.00070500373840332	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
176	0.0013	0.0013420581817627	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
177	0.0006	0.00060701370239258	SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
178	0.0005	0.00049304962158203	SELECT * FROM productoffers WHERE product_id = '3434' AND price > 0 ORDER BY price ASC LIMIT 1
179	0.0005	0.0005040168762207	SELECT * FROM productoffers WHERE product_id = 3434 ORDER BY price ASC LIMIT 1
180	0.0006	0.00061488151550293	SELECT value FROM productattributes WHERE product_id = '3434' AND name = 'ListPriceAmount'
181	0.0009	0.00094199180603027	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 = '3434' GROUP BY o.product_id
182	0.0015	0.0014820098876953	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 = '3434' GROUP BY n.displayname ORDER BY n.displayname DESC
183	0.0006	0.00057601928710938	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
184	0.0006	0.00064277648925781	SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185	0.0009	0.00092291831970215	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3434' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
186	0.0008	0.00075197219848633	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3434' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
187	0.0005	0.00051403045654297	SELECT * FROM products WHERE id = '3464'
188	0.0005	0.00051999092102051	SELECT * FROM productimages WHERE product_id = '3464' ORDER BY sortorder ASC
189	0.0006	0.00063610076904297	SELECT * FROM product_image_select WHERE product_id = '3464'
190	0.0004	0.00040507316589355	SELECT * FROM productcustomimages WHERE product_id = '3464'
191	0.0008	0.00083398818969727	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3464' AND a.name = n.originalname
192	0.0005	0.00052404403686523	SELECT * FROM productoffers WHERE product_id = '3464' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0005	0.00049710273742676	SELECT * FROM productoffers WHERE product_id = '3464' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0005	0.00048398971557617	SELECT * FROM productoffers WHERE product_id = 3464 ORDER BY price ASC LIMIT 1
195	0.0004	0.0003969669342041	SELECT value FROM productattributes WHERE product_id = '3464' AND name = 'ListPriceAmount'
196	0.0004	0.00041508674621582	SELECT value FROM productattributes WHERE product_id = '3464' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197	0.0007	0.00067281723022461	SELECT * FROM products WHERE id = '3472'
198	0.0005	0.00052499771118164	SELECT * FROM productimages WHERE product_id = '3472' ORDER BY sortorder ASC
199	0.0006	0.00060606002807617	SELECT * FROM product_image_select WHERE product_id = '3472'
200	0.0006	0.00057101249694824	SELECT * FROM productcustomimages WHERE product_id = '3472'
201	0.0011	0.0011279582977295	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3472' AND a.name = n.originalname
202	0.0006	0.00057792663574219	SELECT * FROM productoffers WHERE product_id = '3472' AND merchantid = 'A1X6FK5RDHNB96'
203	0.0004	0.00039792060852051	SELECT * FROM productoffers WHERE product_id = '3472' AND price > 0 ORDER BY price ASC LIMIT 1
204	0.0004	0.00043320655822754	SELECT * FROM productoffers WHERE product_id = 3472 ORDER BY price ASC LIMIT 1
205	0.0004	0.00041604042053223	SELECT value FROM productattributes WHERE product_id = '3472' AND name = 'ListPriceAmount'
206	0.0005	0.00049614906311035	SELECT value FROM productattributes WHERE product_id = '3472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207	0.0006	0.00060701370239258	SELECT * FROM products WHERE id = '4943'
208	0.0006	0.00059103965759277	SELECT * FROM productimages WHERE product_id = '4943' ORDER BY sortorder ASC
209	0.0007	0.00070714950561523	SELECT * FROM product_image_select WHERE product_id = '4943'
210	0.0004	0.00044798851013184	SELECT * FROM productcustomimages WHERE product_id = '4943'
211	0.0010	0.00095200538635254	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4943' AND a.name = n.originalname
212	0.0005	0.00052094459533691	SELECT * FROM productoffers WHERE product_id = '4943' AND merchantid = 'A1X6FK5RDHNB96'
213	0.0004	0.0003969669342041	SELECT * FROM productoffers WHERE product_id = '4943' AND price > 0 ORDER BY price ASC LIMIT 1
214	0.0004	0.00037097930908203	SELECT * FROM productoffers WHERE product_id = 4943 ORDER BY price ASC LIMIT 1
215	0.0004	0.00041103363037109	SELECT value FROM productattributes WHERE product_id = '4943' AND name = 'ListPriceAmount'
216	0.0005	0.0005040168762207	SELECT value FROM productattributes WHERE product_id = '4943' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217	0.0006	0.00057792663574219	SELECT * FROM products WHERE id = '3600'
218	0.0005	0.00052189826965332	SELECT * FROM productimages WHERE product_id = '3600' ORDER BY sortorder ASC
219	0.0006	0.00063705444335938	SELECT * FROM product_image_select WHERE product_id = '3600'
220	0.0005	0.00047707557678223	SELECT * FROM productcustomimages WHERE product_id = '3600'
221	0.0009	0.00091719627380371	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3600' AND a.name = n.originalname
222	0.0006	0.00055599212646484	SELECT * FROM productoffers WHERE product_id = '3600' AND merchantid = 'A1X6FK5RDHNB96'
223	0.0006	0.00062298774719238	SELECT * FROM productoffers WHERE product_id = '3600' AND price > 0 ORDER BY price ASC LIMIT 1
224	0.0005	0.00049090385437012	SELECT * FROM productoffers WHERE product_id = 3600 ORDER BY price ASC LIMIT 1
225	0.0005	0.0005338191986084	SELECT value FROM productattributes WHERE product_id = '3600' AND name = 'ListPriceAmount'
226	0.0006	0.00063705444335938	SELECT value FROM productattributes WHERE product_id = '3600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
227	0.0006	0.00064301490783691	SELECT * FROM products WHERE id = '3738'
228	0.0007	0.00067996978759766	SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
229	0.0007	0.0007469654083252	SELECT * FROM product_image_select WHERE product_id = '3738'
230	0.0006	0.0005638599395752	SELECT * FROM productcustomimages WHERE product_id = '3738'
231	0.0023	0.0023078918457031	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
232	0.0009	0.00090217590332031	SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
233	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = '3738' AND price > 0 ORDER BY price ASC LIMIT 1
234	0.0005	0.00045895576477051	SELECT * FROM productoffers WHERE product_id = 3738 ORDER BY price ASC LIMIT 1
235	0.0005	0.00046586990356445	SELECT value FROM productattributes WHERE product_id = '3738' AND name = 'ListPriceAmount'
236	0.0005	0.00050592422485352	SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237	0.0015	0.001478910446167	SELECT * FROM products WHERE id = '3613'
238	0.0006	0.00062799453735352	SELECT * FROM productimages WHERE product_id = '3613' ORDER BY sortorder ASC
239	0.0007	0.00070309638977051	SELECT * FROM product_image_select WHERE product_id = '3613'
240	0.0005	0.00052618980407715	SELECT * FROM productcustomimages WHERE product_id = '3613'
241	0.0012	0.0011899471282959	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3613' AND a.name = n.originalname
242	0.0006	0.00064301490783691	SELECT * FROM productoffers WHERE product_id = '3613' AND merchantid = 'A1X6FK5RDHNB96'
243	0.0005	0.00045084953308105	SELECT * FROM productoffers WHERE product_id = '3613' AND price > 0 ORDER BY price ASC LIMIT 1
244	0.0004	0.00043201446533203	SELECT * FROM productoffers WHERE product_id = 3613 ORDER BY price ASC LIMIT 1
245	0.0005	0.00051403045654297	SELECT value FROM productattributes WHERE product_id = '3613' AND name = 'ListPriceAmount'
246	0.0006	0.00061488151550293	SELECT value FROM productattributes WHERE product_id = '3613' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247	0.0006	0.00063586235046387	SELECT * FROM products WHERE id = '3623'
248	0.0005	0.00054407119750977	SELECT * FROM productimages WHERE product_id = '3623' ORDER BY sortorder ASC
249	0.0008	0.00080299377441406	SELECT * FROM product_image_select WHERE product_id = '3623'
250	0.0004	0.0004420280456543	SELECT * FROM productcustomimages WHERE product_id = '3623'
251	0.0009	0.00086808204650879	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3623' AND a.name = n.originalname
252	0.0005	0.00053191184997559	SELECT * FROM productoffers WHERE product_id = '3623' AND merchantid = 'A1X6FK5RDHNB96'
253	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '3623' AND price > 0 ORDER BY price ASC LIMIT 1
254	0.0004	0.00043106079101562	SELECT * FROM productoffers WHERE product_id = 3623 ORDER BY price ASC LIMIT 1
255	0.0006	0.00055718421936035	SELECT value FROM productattributes WHERE product_id = '3623' AND name = 'ListPriceAmount'
256	0.0007	0.00070405006408691	SELECT value FROM productattributes WHERE product_id = '3623' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257	0.0007	0.00069499015808105	SELECT * FROM products WHERE id = '3658'
258	0.0006	0.00058817863464355	SELECT * FROM productimages WHERE product_id = '3658' ORDER BY sortorder ASC
259	0.0006	0.00055193901062012	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3658' AND p.id = pi.product_id ORDER BY pi.sortorder
260	0.0007	0.00072288513183594	SELECT * FROM product_image_select WHERE product_id = '3658'
261	0.0005	0.00053691864013672	SELECT * FROM productcustomimages WHERE product_id = '3658'
262	0.0008	0.0007939338684082	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 = '3658' GROUP BY o.product_id
263	0.0009	0.00092101097106934	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 = '3658' GROUP BY n.displayname ORDER BY n.displayname DESC
264	0.0006	0.00057601928710938	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3658
265	0.0015	0.0014660358428955	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3658' AND a.name = n.originalname
266	0.0006	0.00060606002807617	SELECT * FROM productoffers WHERE product_id = '3658' AND merchantid = 'A1X6FK5RDHNB96'
267	0.0006	0.00061416625976562	SELECT * FROM productoffers WHERE product_id = '3658' AND price > 0 ORDER BY price ASC LIMIT 1
268	0.0005	0.00046682357788086	SELECT * FROM productoffers WHERE product_id = 3658 ORDER BY price ASC LIMIT 1
269	0.0006	0.00059294700622559	SELECT value FROM productattributes WHERE product_id = '3658' AND name = 'ListPriceAmount'
270	0.0005	0.0004889965057373	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 = '3658' GROUP BY o.product_id
271	0.0008	0.00078988075256348	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 = '3658' GROUP BY n.displayname ORDER BY n.displayname DESC
272	0.0005	0.00052595138549805	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3658
273	0.0009	0.00086712837219238	SELECT value FROM productattributes WHERE product_id = '3658' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274	0.0010	0.00099992752075195	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3658' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
275	0.0006	0.00059318542480469	SELECT * FROM products WHERE parent_id = '3658'
276	0.0008	0.00077414512634277	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4518' AND a.name = n.originalname
277	0.0006	0.00056290626525879	SELECT * FROM productoffers WHERE product_id = '4518' AND merchantid = 'A1X6FK5RDHNB96'
278	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '4518' AND price > 0 ORDER BY price ASC LIMIT 1
279	0.0004	0.00040698051452637	SELECT * FROM productoffers WHERE product_id = 4518 ORDER BY price ASC LIMIT 1
280	0.0004	0.00039792060852051	SELECT value FROM productattributes WHERE product_id = '4518' AND name = 'ListPriceAmount'
281	0.0005	0.00048613548278809	SELECT * FROM products WHERE id = '3665'
282	0.0006	0.00056695938110352	SELECT * FROM productimages WHERE product_id = '3665' ORDER BY sortorder ASC
283	0.0007	0.00072002410888672	SELECT * FROM product_image_select WHERE product_id = '3665'
284	0.0005	0.00045895576477051	SELECT * FROM productcustomimages WHERE product_id = '3665'
285	0.0010	0.00097084045410156	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3665' AND a.name = n.originalname
286	0.0005	0.00054121017456055	SELECT * FROM productoffers WHERE product_id = '3665' AND merchantid = 'A1X6FK5RDHNB96'
287	0.0005	0.00046586990356445	SELECT * FROM productoffers WHERE product_id = '3665' AND price > 0 ORDER BY price ASC LIMIT 1
288	0.0004	0.00041699409484863	SELECT * FROM productoffers WHERE product_id = 3665 ORDER BY price ASC LIMIT 1
289	0.0004	0.00044107437133789	SELECT value FROM productattributes WHERE product_id = '3665' AND name = 'ListPriceAmount'
290	0.0005	0.0004570484161377	SELECT value FROM productattributes WHERE product_id = '3665' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
291	0.0006	0.00063896179199219	SELECT * FROM products WHERE id = '3676'
292	0.0006	0.00055217742919922	SELECT * FROM productimages WHERE product_id = '3676' ORDER BY sortorder ASC
293	0.0009	0.00087809562683105	SELECT * FROM product_image_select WHERE product_id = '3676'
294	0.0006	0.00055599212646484	SELECT * FROM productcustomimages WHERE product_id = '3676'
295	0.0013	0.0012519359588623	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3676' AND a.name = n.originalname
296	0.0007	0.0006711483001709	SELECT * FROM productoffers WHERE product_id = '3676' AND merchantid = 'A1X6FK5RDHNB96'
297	0.0006	0.00056791305541992	SELECT * FROM productoffers WHERE product_id = '3676' AND price > 0 ORDER BY price ASC LIMIT 1
298	0.0005	0.00045013427734375	SELECT * FROM productoffers WHERE product_id = 3676 ORDER BY price ASC LIMIT 1
299	0.0005	0.00051784515380859	SELECT value FROM productattributes WHERE product_id = '3676' AND name = 'ListPriceAmount'
300	0.0006	0.00064301490783691	SELECT value FROM productattributes WHERE product_id = '3676' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301	0.0007	0.00066709518432617	SELECT * FROM products WHERE id = '3687'
302	0.0007	0.00073122978210449	SELECT * FROM productimages WHERE product_id = '3687' ORDER BY sortorder ASC
303	0.0008	0.00078487396240234	SELECT * FROM product_image_select WHERE product_id = '3687'
304	0.0006	0.00058412551879883	SELECT * FROM productcustomimages WHERE product_id = '3687'
305	0.0010	0.0010108947753906	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3687' AND a.name = n.originalname
306	0.0007	0.00065112113952637	SELECT * FROM productoffers WHERE product_id = '3687' AND merchantid = 'A1X6FK5RDHNB96'
307	0.0005	0.00054001808166504	SELECT * FROM productoffers WHERE product_id = '3687' AND price > 0 ORDER BY price ASC LIMIT 1
308	0.0006	0.00063800811767578	SELECT value FROM productattributes WHERE product_id = '3687' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309	0.0007	0.00071382522583008	SELECT * FROM products WHERE id = '3704'
310	0.0006	0.00055289268493652	SELECT * FROM productimages WHERE product_id = '3704' ORDER BY sortorder ASC
311	0.0006	0.00064897537231445	SELECT * FROM product_image_select WHERE product_id = '3704'
312	0.0004	0.00043702125549316	SELECT * FROM productcustomimages WHERE product_id = '3704'
313	0.0009	0.0009160041809082	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3704' AND a.name = n.originalname
314	0.0005	0.00051188468933105	SELECT * FROM productoffers WHERE product_id = '3704' AND merchantid = 'A1X6FK5RDHNB96'
315	0.0005	0.0004730224609375	SELECT * FROM productoffers WHERE product_id = '3704' AND price > 0 ORDER BY price ASC LIMIT 1
316	0.0004	0.00038313865661621	SELECT * FROM productoffers WHERE product_id = 3704 ORDER BY price ASC LIMIT 1
317	0.0004	0.00043797492980957	SELECT value FROM productattributes WHERE product_id = '3704' AND name = 'ListPriceAmount'
318	0.0004	0.00043296813964844	SELECT value FROM productattributes WHERE product_id = '3704' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
319	0.0004	0.00044608116149902	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3175' ORDER BY timestamp DESC
320	0.0004	0.00037908554077148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3214' ORDER BY timestamp DESC
321	0.0004	0.00035500526428223	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3601' ORDER BY timestamp DESC
322	0.0003	0.00032687187194824	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3281' ORDER BY timestamp DESC
323	0.0004	0.00043201446533203	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3407' ORDER BY timestamp DESC
324	0.0004	0.00037789344787598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
325	0.0004	0.00042104721069336	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3464' ORDER BY timestamp DESC
326	0.0003	0.00033092498779297	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3472' ORDER BY timestamp DESC
327	0.0003	0.00034189224243164	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4943' ORDER BY timestamp DESC
328	0.0004	0.00039792060852051	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3600' ORDER BY timestamp DESC
329	0.0003	0.00032591819763184	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
330	0.0003	0.00033712387084961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3613' ORDER BY timestamp DESC
331	0.0004	0.00035905838012695	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3623' ORDER BY timestamp DESC
332	0.0004	0.00039100646972656	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3658' ORDER BY timestamp DESC
333	0.0004	0.00035190582275391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3665' ORDER BY timestamp DESC
334	0.0003	0.00034189224243164	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3676' ORDER BY timestamp DESC
335	0.0004	0.0003659725189209	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3687' ORDER BY timestamp DESC
336	0.0004	0.00036191940307617	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3704' ORDER BY timestamp DESC
337	0.0006	0.00057315826416016	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
338	0.0005	0.00051712989807129	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
339	0.0004	0.00036001205444336	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
340	0.0189	0.018898010253906	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
341	0.0008	0.00079488754272461	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
342	0.0006	0.00061917304992676	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
343	0.0007	0.00066018104553223	SELECT * FROM products WHERE id = 1626
344	0.0006	0.00060415267944336	SELECT * FROM products WHERE id = 4041
345	0.0005	0.00050711631774902	SELECT * FROM products WHERE id = 4312
346	0.0005	0.00052905082702637	SELECT * FROM products WHERE id = 777
347	0.0005	0.00049495697021484	SELECT * FROM products WHERE id = 3881
348	0.0004	0.00043392181396484	SELECT * FROM products WHERE id = 4213
349	0.0005	0.00047397613525391	SELECT * FROM products WHERE id = '1626'
350	0.0007	0.00066399574279785	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
351	0.0007	0.0006859302520752	SELECT * FROM product_image_select WHERE product_id = '1626'
352	0.0005	0.00047802925109863	SELECT * FROM productcustomimages WHERE product_id = '1626'
353	0.0010	0.0010490417480469	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
354	0.0007	0.00066494941711426	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
355	0.0005	0.00054192543029785	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
356	0.0006	0.00061392784118652	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357	0.0007	0.00066614151000977	SELECT * FROM products WHERE id = '4041'
358	0.0006	0.00064802169799805	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
359	0.0007	0.00072097778320312	SELECT * FROM product_image_select WHERE product_id = '4041'
360	0.0005	0.00050091743469238	SELECT * FROM productcustomimages WHERE product_id = '4041'
361	0.0013	0.0012979507446289	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
362	0.0006	0.00056815147399902	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
363	0.0005	0.00046801567077637	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
364	0.0004	0.00041604042053223	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365	0.0006	0.00064301490783691	SELECT * FROM products WHERE id = '4312'
366	0.0005	0.00046896934509277	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
367	0.0006	0.00061678886413574	SELECT * FROM product_image_select WHERE product_id = '4312'
368	0.0005	0.00051307678222656	SELECT * FROM productcustomimages WHERE product_id = '4312'
369	0.0015	0.0014550685882568	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
370	0.0006	0.00059390068054199	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
371	0.0004	0.00043487548828125	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
372	0.0004	0.00039100646972656	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373	0.0007	0.00065398216247559	SELECT * FROM products WHERE id = '777'
374	0.0005	0.00049996376037598	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
375	0.0006	0.00057196617126465	SELECT * FROM product_image_select WHERE product_id = '777'
376	0.0004	0.00044703483581543	SELECT * FROM productcustomimages WHERE product_id = '777'
377	0.0010	0.001039981842041	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
378	0.0005	0.00048184394836426	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
379	0.0004	0.00041794776916504	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
380	0.0004	0.0004432201385498	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
381	0.0006	0.00059103965759277	SELECT * FROM products WHERE id = '3881'
382	0.0008	0.00075602531433105	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
383	0.0007	0.0007328987121582	SELECT * FROM product_image_select WHERE product_id = '3881'
384	0.0005	0.00045299530029297	SELECT * FROM productcustomimages WHERE product_id = '3881'
385	0.0013	0.0013217926025391	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
386	0.0005	0.00052309036254883	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
387	0.0004	0.00039482116699219	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
388	0.0004	0.00039291381835938	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
389	0.0006	0.00060582160949707	SELECT * FROM products WHERE id = '4213'
390	0.0005	0.00053691864013672	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
391	0.0006	0.00057005882263184	SELECT * FROM product_image_select WHERE product_id = '4213'
392	0.0005	0.00051093101501465	SELECT * FROM productcustomimages WHERE product_id = '4213'
393	0.0016	0.0016131401062012	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
394	0.0006	0.00059986114501953	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
395	0.0005	0.00051498413085938	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
396	0.0005	0.00046300888061523	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
397	0.0010	0.00098013877868652	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
398	0.0007	0.0007169246673584	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
399	0.0015	0.0014698505401611	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
400	0.0007	0.00073504447937012	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
401	0.0006	0.00056910514831543	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
402	0.0012	0.0011529922485352	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
403	0.0009	0.00093197822570801	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.3478791713715 seconds

Query Debug - 403 Database Queries. Total time 1.0137 seconds