Search Results for "3"

Fontaine à chocolat Princess 292994 – 3 ...

only €30,47

View

Add to Cart

Marque Amazon Solimo café en grains 2 kg...

only €23,99

View

Add to Cart

Kumiko Matcha - thé matcha premium bio d...

only €35,00

View

Add to Cart

Dongsuh Food Rôti de Rooibos thé d’orge ...

only €17,29

View

Add to Cart

?? CAFE GRAIN 1kg BIO | Café en Grain Ar...

only €32,97

View

Add to Cart

Callebaut N° 70-30-38 (70,5%) - Chocolat...

only €11,35

View

Add to Cart

NICKS Chocodrink, chocolat chaud instant...

only €9,99

View

Add to Cart

MegaCrea Boîte à Sachet thé/Tisane 31,5 ...

only €19,99

View

Add to Cart

Marque Amazon Solimo Café moulu Aroma co...

only €15,77

View

Add to Cart

Caotina blanc, Poudre de Cacao avec du C...

only €27,98

View

Add to Cart

Thés de la Pagode - Coffret Thés Bio, Ro...

only €19,50

View

Add to Cart

Kitchencraft Lovteawht Boîte à thé, Blan...

€15,05 €13,45

View

Add to Cart

Ethiquable Rooibos Afrique du Sud Bio et...

View to See Price

View

Add to Cart

Marque Amazon Solimo Café moulu compatib...

€23,58 €14,69

View

Add to Cart

Boîte de Rangement Beauté C'EST MOI LA P...

only €21,00

View

Add to Cart

SoBuy FRG Porte-Capsules, Boîte de range...

only €29,95

View

Add to Cart

Chocolat Chaud Caramel beurre salé - 350...

only €9,50

View

Add to Cart

Whittard Luxe Blanc Chaud 350G De Chocol...

only €26,15

View

Add to Cart

1 to 18 of 360 products

1
2
3
4
Next ›

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.3285949230194	350	0.8766	0

No Amazon API Requests Made.

App Debug - Total Time 1.3285949230194 seconds

Number	Time From Start	Name	Description
1	0.38776588439941	Initialise	Initialise FSB Function
2	0.3945369720459	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.43387484550476	Start of getCategoryListByGroup Function	Before first category groups query
4	0.43566298484802	After initial query	Before first category groups query
5	0.43566489219666	Get Category List for Group	Before the call to getCategoryList function
6	0.4356689453125	Start of GetCategoryList function	Start of the function
7	0.43567299842834	Before getting categories	Query to get specific category list
8	0.43731594085693	After getting categories	Query to get specific category list
9	0.43731689453125	Before getting category custom	Before call to function getCategoryCustom
10	0.45907282829285	After getting category custom	After call to function getCategoryCustom
11	0.45907783508301	Before getting category custom	Before call to function getCategoryCustom
12	0.47119188308716	After getting category custom	After call to function getCategoryCustom
13	0.47119498252869	Before getting category custom	Before call to function getCategoryCustom
14	0.47791981697083	After getting category custom	After call to function getCategoryCustom
15	0.47792291641235	Before getting category custom	Before call to function getCategoryCustom
16	0.4896879196167	After getting category custom	After call to function getCategoryCustom
17	0.48969101905823	Before getting category custom	Before call to function getCategoryCustom
18	0.49904203414917	After getting category custom	After call to function getCategoryCustom
19	0.4990439414978	Before getting category custom	Before call to function getCategoryCustom
20	0.50709390640259	After getting category custom	After call to function getCategoryCustom
21	0.50709581375122	End of GetCategoryList function	End of the function
22	0.50710296630859	Get Category List for Group	Before the call to getCategoryList function
23	0.50710487365723	Start of GetCategoryList function	Start of the function
24	0.50710797309875	Before getting categories	Query to get specific category list
25	0.50806593894958	End of getCategoryListByGroup Function	Before return()
26	0.96196985244751	App Controller End	End of the App controller (called before the controller of every page)
27	1.1943039894104	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.1968688964844	Before Get Options	Before the call to getOptions in the tpl class
29	1.2732720375061	After Get Options	After the call to getOptions in the tpl class
30	1.2733228206635	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.3285729885101	Finalizing debug	Before the debug is output to the page.
32	1.3285930156708	End of App	This is the end of the app logging, final timestamp

Query Debug - 350 Database Queries. Total time 0.8766 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:\"52.15.110.198\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738792874'
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('52.15.110.198') >= INET_ATON(ip_start) AND INET_ATON('52.15.110.198') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'search'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '52.15.110.198'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

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

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

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

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT * FROM products WHERE id = '4950'
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4950'
SELECT * FROM productcustomimages WHERE product_id = '4950'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4926'
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4926'
SELECT * FROM productcustomimages WHERE product_id = '4926'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '868'
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '868'
SELECT * FROM productcustomimages WHERE product_id = '868'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2165'
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2165'
SELECT * FROM productcustomimages WHERE product_id = '2165'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4930'
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4930'
SELECT * FROM productcustomimages WHERE product_id = '4930'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4948'
SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4948'
SELECT * FROM productcustomimages WHERE product_id = '4948'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4948' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4941'
SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4941'
SELECT * FROM productcustomimages WHERE product_id = '4941'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4941' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3809'
SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3809'
SELECT * FROM productcustomimages WHERE product_id = '3809'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3809' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3809' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4934'
SELECT * FROM productimages WHERE product_id = '4934' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4934'
SELECT * FROM productcustomimages WHERE product_id = '4934'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4934' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4934' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4934' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4952'
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4952'
SELECT * FROM productcustomimages WHERE product_id = '4952'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4924'
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4924'
SELECT * FROM productcustomimages WHERE product_id = '4924'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4924' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2698'
SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2698'
SELECT * FROM productcustomimages WHERE product_id = '2698'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2698' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2698' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1036'
SELECT * FROM productimages WHERE product_id = '1036' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1036'
SELECT * FROM productcustomimages WHERE product_id = '1036'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1036' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1036' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1036' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1036
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1036'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4932'
SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4932'
SELECT * FROM productcustomimages WHERE product_id = '4932'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4932' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1274'
SELECT * FROM productimages WHERE product_id = '1274' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1274'
SELECT * FROM productcustomimages WHERE product_id = '1274'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1274' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1274' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1274' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1274' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '850'
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '850'
SELECT * FROM productcustomimages WHERE product_id = '850'
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 = '850'
                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     = '850'
                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 = 850
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '850'
                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 = '850'
                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     = '850'
                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 = 850
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '850'
                  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 = '850'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM products WHERE id = '4946'
SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4946'
SELECT * FROM productcustomimages WHERE product_id = '4946'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4946' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4946' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4947'
SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4947'
SELECT * FROM productcustomimages WHERE product_id = '4947'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4947' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4934' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4924' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2698' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1036' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1274' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4946' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4947' 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.0011	0.0010628700256348	SELECT parameter, value FROM parameters
2	0.0037	0.0037438869476318	SELECT * FROM `bad_bots`
3	0.0003	0.00028896331787109	SET time_zone = 'Europe/London'
4	0.0006	0.00060606002807617	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0019	0.0018758773803711	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"52.15.110.198\";}'
6	0.0017	0.0017149448394775	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738792874'
7	0.0039	0.0039329528808594	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0012	0.0011768341064453	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0038	0.0038058757781982	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0010	0.00098705291748047	SELECT * FROM pages WHERE id = 52
11	0.0054	0.0054140090942383	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0327	0.032694101333618	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0007	0.00074195861816406	SELECT * FROM pages WHERE pagename = 'search'
14	0.0018	0.0017738342285156	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0016	0.0016191005706787	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0066	0.0065608024597168	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.0020	0.0020358562469482	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0013	0.0013470649719238	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.0004580020904541	SELECT id FROM categories WHERE parent_id = '26'
20	0.0056	0.0056459903717041	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0018	0.0017859935760498	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.0016	0.0016119480133057	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0015	0.0014710426330566	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0007	0.00068211555480957	SELECT * FROM categorygroups WHERE id = '1'
25	0.0043	0.0043411254882812	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.00053501129150391	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.00044393539428711	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0004	0.00044894218444824	SELECT id FROM categories WHERE parent_id = '27'
29	0.0039	0.0038511753082275	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.00060415267944336	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.0007	0.00065302848815918	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0006	0.00060391426086426	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00051498413085938	SELECT * FROM categorygroups WHERE id = '1'
34	0.0015	0.0014791488647461	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.0005028247833252	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.0004	0.00043010711669922	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00045394897460938	SELECT id FROM categories WHERE parent_id = '28'
38	0.0017	0.0016708374023438	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.00051712989807129	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0006	0.00058889389038086	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.00050687789916992	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.0004730224609375	SELECT * FROM categorygroups WHERE id = '1'
43	0.0006	0.00064182281494141	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.0015	0.0015370845794678	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.0010	0.00097298622131348	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0009	0.00090599060058594	SELECT id FROM categories WHERE parent_id = '29'
47	0.0027	0.0027070045471191	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.0011	0.0010850429534912	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.0017	0.001708984375	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.0013	0.0013039112091064	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0008	0.00080299377441406	SELECT * FROM categorygroups WHERE id = '1'
52	0.0015	0.0015170574188232	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.0009	0.00092911720275879	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.0007	0.00072407722473145	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0008	0.00076818466186523	SELECT id FROM categories WHERE parent_id = '30'
56	0.0014	0.0014140605926514	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.00090622901916504	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.0013	0.0012850761413574	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.0010	0.001046895980835	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0007	0.00067806243896484	SELECT * FROM categorygroups WHERE id = '1'
61	0.0010	0.00097990036010742	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.0007	0.0007469654083252	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0006	0.0005650520324707	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0007	0.0006568431854248	SELECT id FROM categories WHERE parent_id = '31'
65	0.0015	0.0015149116516113	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.00075507164001465	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.0011	0.0011060237884521	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.00083804130554199	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0008	0.00080680847167969	SELECT * FROM categorygroups WHERE id = '1'
70	0.0009	0.00094795227050781	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0046	0.004612922668457	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0033	0.0032849311828613	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0012	0.0012459754943848	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.0030	0.003046989440918	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0026	0.0025949478149414	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0018	0.0018200874328613	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4284	0.42840194702148	SELECT * FROM ipgeocountries WHERE INET_ATON('52.15.110.198') >= INET_ATON(ip_start) AND INET_ATON('52.15.110.198') <= INET_ATON(ip_end)
78	0.0025	0.0024590492248535	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0014	0.0013952255249023	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0013	0.0013370513916016	SELECT * FROM pages WHERE pagename = 'search'
81	0.0054	0.0054290294647217	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0021	0.0020971298217773	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0017	0.0017209053039551	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0055	0.005511999130249	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0017	0.0017259120941162	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0006	0.00055193901062012	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0015	0.0014760494232178	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '52.15.110.198'
88	0.0009	0.00094509124755859	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
89	0.0007	0.000701904296875	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0038	0.0037851333618164	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
91	0.0006	0.00060081481933594	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
92	0.0005	0.00052595138549805	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
93	0.0006	0.00062799453735352	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
94	0.0049	0.0048770904541016	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
95	0.0004	0.00042009353637695	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
96	0.0004	0.0003960132598877	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
97	0.0005	0.00053596496582031	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0008	0.00078487396240234	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0037	0.0036840438842773	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0006	0.00057220458984375	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
101	0.0005	0.00051617622375488	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
102	0.0006	0.00055408477783203	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
103	0.0050	0.0050101280212402	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0005	0.00045299530029297	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
105	0.0004	0.0003809928894043	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
106	0.0007	0.00068497657775879	SELECT * FROM products WHERE id = '4950'
107	0.0023	0.0023119449615479	SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
108	0.0018	0.0017960071563721	SELECT * FROM product_image_select WHERE product_id = '4950'
109	0.0013	0.0013439655303955	SELECT * FROM productcustomimages WHERE product_id = '4950'
110	0.0019	0.0019099712371826	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
111	0.0015	0.0014879703521729	SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0005	0.00053286552429199	SELECT * FROM productoffers WHERE product_id = '4950' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0006	0.00064611434936523	SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114	0.0009	0.0008549690246582	SELECT * FROM products WHERE id = '4926'
115	0.0006	0.00055217742919922	SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
116	0.0006	0.0006411075592041	SELECT * FROM product_image_select WHERE product_id = '4926'
117	0.0005	0.00045418739318848	SELECT * FROM productcustomimages WHERE product_id = '4926'
118	0.0012	0.0011818408966064	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
119	0.0005	0.00054693222045898	SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
120	0.0005	0.00047492980957031	SELECT * FROM productoffers WHERE product_id = '4926' AND price > 0 ORDER BY price ASC LIMIT 1
121	0.0005	0.00045299530029297	SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122	0.0006	0.0006411075592041	SELECT * FROM products WHERE id = '868'
123	0.0008	0.00079011917114258	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
124	0.0007	0.00072193145751953	SELECT * FROM product_image_select WHERE product_id = '868'
125	0.0005	0.00049686431884766	SELECT * FROM productcustomimages WHERE product_id = '868'
126	0.0011	0.0010750293731689	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
127	0.0005	0.00053906440734863	SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
128	0.0005	0.0005040168762207	SELECT * FROM productoffers WHERE product_id = '868' AND price > 0 ORDER BY price ASC LIMIT 1
129	0.0005	0.00054693222045898	SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130	0.0007	0.00069999694824219	SELECT * FROM products WHERE id = '2165'
131	0.0008	0.00082707405090332	SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
132	0.0007	0.00073385238647461	SELECT * FROM product_image_select WHERE product_id = '2165'
133	0.0005	0.00054788589477539	SELECT * FROM productcustomimages WHERE product_id = '2165'
134	0.0011	0.0010600090026855	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
135	0.0006	0.0006401538848877	SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
136	0.0005	0.00047707557678223	SELECT * FROM productoffers WHERE product_id = '2165' AND price > 0 ORDER BY price ASC LIMIT 1
137	0.0005	0.00051784515380859	SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138	0.0007	0.00070285797119141	SELECT * FROM products WHERE id = '4930'
139	0.0008	0.00078797340393066	SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
140	0.0019	0.0018739700317383	SELECT * FROM product_image_select WHERE product_id = '4930'
141	0.0010	0.00095009803771973	SELECT * FROM productcustomimages WHERE product_id = '4930'
142	0.0039	0.0038750171661377	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
143	0.0013	0.0013430118560791	SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0010	0.0010240077972412	SELECT * FROM productoffers WHERE product_id = '4930' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0010	0.0010359287261963	SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146	0.0013	0.001276969909668	SELECT * FROM products WHERE id = '4948'
147	0.0012	0.0011770725250244	SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
148	0.0013	0.0012528896331787	SELECT * FROM product_image_select WHERE product_id = '4948'
149	0.0007	0.00073909759521484	SELECT * FROM productcustomimages WHERE product_id = '4948'
150	0.0024	0.0024340152740479	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
151	0.0010	0.001025915145874	SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
152	0.0008	0.00077390670776367	SELECT * FROM productoffers WHERE product_id = '4948' AND price > 0 ORDER BY price ASC LIMIT 1
153	0.0009	0.00092387199401855	SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154	0.0012	0.0012128353118896	SELECT * FROM products WHERE id = '4941'
155	0.0009	0.00094199180603027	SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
156	0.0012	0.001230001449585	SELECT * FROM product_image_select WHERE product_id = '4941'
157	0.0008	0.00078415870666504	SELECT * FROM productcustomimages WHERE product_id = '4941'
158	0.0022	0.0022299289703369	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
159	0.0008	0.00083494186401367	SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
160	0.0007	0.0007328987121582	SELECT * FROM productoffers WHERE product_id = '4941' AND price > 0 ORDER BY price ASC LIMIT 1
161	0.0010	0.00096702575683594	SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0011	0.0011310577392578	SELECT * FROM products WHERE id = '3809'
163	0.0009	0.00092506408691406	SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
164	0.0014	0.0014431476593018	SELECT * FROM product_image_select WHERE product_id = '3809'
165	0.0014	0.0014040470123291	SELECT * FROM productcustomimages WHERE product_id = '3809'
166	0.0018	0.0018069744110107	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3809' AND a.name = n.originalname
167	0.0007	0.00073909759521484	SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0015	0.0014641284942627	SELECT * FROM productoffers WHERE product_id = '3809' AND price > 0 ORDER BY price ASC LIMIT 1
169	0.0007	0.00069999694824219	SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170	0.0009	0.00093603134155273	SELECT * FROM products WHERE id = '4934'
171	0.0009	0.00090694427490234	SELECT * FROM productimages WHERE product_id = '4934' ORDER BY sortorder ASC
172	0.0017	0.0016918182373047	SELECT * FROM product_image_select WHERE product_id = '4934'
173	0.0015	0.0015339851379395	SELECT * FROM productcustomimages WHERE product_id = '4934'
174	0.0038	0.003809928894043	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4934' AND a.name = n.originalname
175	0.0016	0.0015690326690674	SELECT * FROM productoffers WHERE product_id = '4934' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0007	0.00074195861816406	SELECT * FROM productoffers WHERE product_id = '4934' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0008	0.00078201293945312	SELECT value FROM productattributes WHERE product_id = '4934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178	0.0012	0.0011711120605469	SELECT * FROM products WHERE id = '4952'
179	0.0009	0.00091695785522461	SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
180	0.0010	0.0010302066802979	SELECT * FROM product_image_select WHERE product_id = '4952'
181	0.0006	0.00064992904663086	SELECT * FROM productcustomimages WHERE product_id = '4952'
182	0.0016	0.0016298294067383	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
183	0.0008	0.00080704689025879	SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
184	0.0007	0.0007328987121582	SELECT * FROM productoffers WHERE product_id = '4952' AND price > 0 ORDER BY price ASC LIMIT 1
185	0.0009	0.00087499618530273	SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186	0.0011	0.0010788440704346	SELECT * FROM products WHERE id = '4924'
187	0.0009	0.00091814994812012	SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
188	0.0012	0.0012152194976807	SELECT * FROM product_image_select WHERE product_id = '4924'
189	0.0007	0.00072884559631348	SELECT * FROM productcustomimages WHERE product_id = '4924'
190	0.0023	0.0023138523101807	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
191	0.0009	0.00094699859619141	SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0007	0.00073099136352539	SELECT * FROM productoffers WHERE product_id = '4924' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0008	0.00076508522033691	SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194	0.0013	0.0012600421905518	SELECT * FROM products WHERE id = '2698'
195	0.0011	0.0011489391326904	SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
196	0.0010	0.0010490417480469	SELECT * FROM product_image_select WHERE product_id = '2698'
197	0.0006	0.00063109397888184	SELECT * FROM productcustomimages WHERE product_id = '2698'
198	0.0020	0.001986026763916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2698' AND a.name = n.originalname
199	0.0007	0.00065898895263672	SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
200	0.0005	0.00048017501831055	SELECT * FROM productoffers WHERE product_id = '2698' AND price > 0 ORDER BY price ASC LIMIT 1
201	0.0006	0.00058197975158691	SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202	0.0011	0.0011129379272461	SELECT * FROM products WHERE id = '1036'
203	0.0009	0.00088191032409668	SELECT * FROM productimages WHERE product_id = '1036' ORDER BY sortorder ASC
204	0.0008	0.00080180168151855	SELECT * FROM product_image_select WHERE product_id = '1036'
205	0.0006	0.00055098533630371	SELECT * FROM productcustomimages WHERE product_id = '1036'
206	0.0022	0.002234935760498	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1036' AND a.name = n.originalname
207	0.0006	0.0005791187286377	SELECT * FROM productoffers WHERE product_id = '1036' AND merchantid = 'A1X6FK5RDHNB96'
208	0.0006	0.00060582160949707	SELECT * FROM productoffers WHERE product_id = '1036' AND price > 0 ORDER BY price ASC LIMIT 1
209	0.0004	0.00042986869812012	SELECT * FROM productoffers WHERE product_id = 1036 ORDER BY price ASC LIMIT 1
210	0.0004	0.0004420280456543	SELECT value FROM productattributes WHERE product_id = '1036' AND name = 'ListPriceAmount'
211	0.0007	0.00073003768920898	SELECT value FROM productattributes WHERE product_id = '1036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212	0.0007	0.00065493583679199	SELECT * FROM products WHERE id = '4932'
213	0.0017	0.0016958713531494	SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
214	0.0016	0.0016400814056396	SELECT * FROM product_image_select WHERE product_id = '4932'
215	0.0017	0.0016560554504395	SELECT * FROM productcustomimages WHERE product_id = '4932'
216	0.0022	0.0021669864654541	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
217	0.0009	0.00086212158203125	SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
218	0.0006	0.00061702728271484	SELECT * FROM productoffers WHERE product_id = '4932' AND price > 0 ORDER BY price ASC LIMIT 1
219	0.0006	0.00057387351989746	SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220	0.0007	0.00073599815368652	SELECT * FROM products WHERE id = '1274'
221	0.0010	0.00098013877868652	SELECT * FROM productimages WHERE product_id = '1274' ORDER BY sortorder ASC
222	0.0010	0.00096297264099121	SELECT * FROM product_image_select WHERE product_id = '1274'
223	0.0006	0.00064897537231445	SELECT * FROM productcustomimages WHERE product_id = '1274'
224	0.0017	0.0017058849334717	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1274' AND a.name = n.originalname
225	0.0008	0.00081086158752441	SELECT * FROM productoffers WHERE product_id = '1274' AND merchantid = 'A1X6FK5RDHNB96'
226	0.0008	0.00076413154602051	SELECT * FROM productoffers WHERE product_id = '1274' AND price > 0 ORDER BY price ASC LIMIT 1
227	0.0006	0.00057601928710938	SELECT value FROM productattributes WHERE product_id = '1274' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228	0.0008	0.00084114074707031	SELECT * FROM products WHERE id = '850'
229	0.0011	0.0010571479797363	SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
230	0.0007	0.00074982643127441	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
231	0.0009	0.00091910362243652	SELECT * FROM product_image_select WHERE product_id = '850'
232	0.0010	0.00096487998962402	SELECT * FROM productcustomimages WHERE product_id = '850'
233	0.0009	0.00090909004211426	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 = '850' GROUP BY o.product_id
234	0.0040	0.0039620399475098	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 = '850' GROUP BY n.displayname ORDER BY n.displayname DESC
235	0.0007	0.00069308280944824	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
236	0.0016	0.0016038417816162	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
237	0.0005	0.00050902366638184	SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
238	0.0006	0.00056910514831543	SELECT * FROM productoffers WHERE product_id = '850' AND price > 0 ORDER BY price ASC LIMIT 1
239	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = 850 ORDER BY price ASC LIMIT 1
240	0.0005	0.00047993659973145	SELECT value FROM productattributes WHERE product_id = '850' AND name = 'ListPriceAmount'
241	0.0006	0.00057601928710938	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 = '850' GROUP BY o.product_id
242	0.0009	0.00089788436889648	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 = '850' GROUP BY n.displayname ORDER BY n.displayname DESC
243	0.0005	0.00054597854614258	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
244	0.0037	0.0037300586700439	SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245	0.0010	0.00095081329345703	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '850' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
246	0.0008	0.00078606605529785	SELECT * FROM products WHERE parent_id = '850'
247	0.0008	0.0008089542388916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
248	0.0008	0.00076508522033691	SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
249	0.0006	0.00061607360839844	SELECT * FROM productoffers WHERE product_id = '4891' AND price > 0 ORDER BY price ASC LIMIT 1
250	0.0006	0.00064301490783691	SELECT * FROM products WHERE id = '4946'
251	0.0007	0.00071001052856445	SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
252	0.0009	0.00088000297546387	SELECT * FROM product_image_select WHERE product_id = '4946'
253	0.0006	0.00060296058654785	SELECT * FROM productcustomimages WHERE product_id = '4946'
254	0.0012	0.0011699199676514	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4946' AND a.name = n.originalname
255	0.0006	0.00062894821166992	SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
256	0.0006	0.00057506561279297	SELECT * FROM productoffers WHERE product_id = '4946' AND price > 0 ORDER BY price ASC LIMIT 1
257	0.0006	0.0005948543548584	SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258	0.0008	0.00077986717224121	SELECT * FROM products WHERE id = '4947'
259	0.0007	0.0007319450378418	SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
260	0.0007	0.00073385238647461	SELECT * FROM product_image_select WHERE product_id = '4947'
261	0.0005	0.00051593780517578	SELECT * FROM productcustomimages WHERE product_id = '4947'
262	0.0010	0.0010230541229248	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4947' AND a.name = n.originalname
263	0.0006	0.00057601928710938	SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
264	0.0005	0.00052189826965332	SELECT * FROM productoffers WHERE product_id = '4947' AND price > 0 ORDER BY price ASC LIMIT 1
265	0.0006	0.00055193901062012	SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266	0.0020	0.0020349025726318	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
267	0.0005	0.00053691864013672	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
268	0.0004	0.00041604042053223	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
269	0.0004	0.00044703483581543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
270	0.0004	0.00043606758117676	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
271	0.0004	0.00043892860412598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
272	0.0005	0.00053000450134277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
273	0.0004	0.00038409233093262	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
274	0.0004	0.00044393539428711	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4934' ORDER BY timestamp DESC
275	0.0005	0.00045895576477051	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
276	0.0004	0.0004279613494873	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4924' ORDER BY timestamp DESC
277	0.0005	0.0004880428314209	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2698' ORDER BY timestamp DESC
278	0.0005	0.00046801567077637	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1036' ORDER BY timestamp DESC
279	0.0004	0.00039887428283691	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
280	0.0004	0.00041413307189941	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1274' ORDER BY timestamp DESC
281	0.0004	0.00037193298339844	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
282	0.0004	0.00036096572875977	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4946' ORDER BY timestamp DESC
283	0.0004	0.00036382675170898	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4947' ORDER BY timestamp DESC
284	0.0022	0.0021581649780273	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
285	0.0018	0.0018041133880615	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
286	0.0006	0.00058197975158691	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
287	0.0187	0.018739938735962	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
288	0.0027	0.0026628971099854	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
289	0.0009	0.00085687637329102	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
290	0.0007	0.00068807601928711	SELECT * FROM products WHERE id = 1626
291	0.0007	0.00074005126953125	SELECT * FROM products WHERE id = 4041
292	0.0008	0.00077199935913086	SELECT * FROM products WHERE id = 4312
293	0.0007	0.00067782402038574	SELECT * FROM products WHERE id = 777
294	0.0006	0.00063014030456543	SELECT * FROM products WHERE id = 3881
295	0.0007	0.00067305564880371	SELECT * FROM products WHERE id = 4213
296	0.0008	0.00082302093505859	SELECT * FROM products WHERE id = '1626'
297	0.0006	0.00061202049255371	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
298	0.0007	0.00066995620727539	SELECT * FROM product_image_select WHERE product_id = '1626'
299	0.0005	0.00054097175598145	SELECT * FROM productcustomimages WHERE product_id = '1626'
300	0.0010	0.00098395347595215	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
301	0.0006	0.00057411193847656	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
302	0.0005	0.00053811073303223	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
303	0.0007	0.00072407722473145	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304	0.0008	0.00084185600280762	SELECT * FROM products WHERE id = '4041'
305	0.0008	0.00075602531433105	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
306	0.0008	0.00079989433288574	SELECT * FROM product_image_select WHERE product_id = '4041'
307	0.0006	0.00055909156799316	SELECT * FROM productcustomimages WHERE product_id = '4041'
308	0.0015	0.0014960765838623	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
309	0.0006	0.00061488151550293	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
310	0.0005	0.00046205520629883	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
311	0.0006	0.00058603286743164	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312	0.0007	0.00065302848815918	SELECT * FROM products WHERE id = '4312'
313	0.0006	0.00058197975158691	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
314	0.0007	0.00071406364440918	SELECT * FROM product_image_select WHERE product_id = '4312'
315	0.0005	0.00051116943359375	SELECT * FROM productcustomimages WHERE product_id = '4312'
316	0.0017	0.0016739368438721	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
317	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
318	0.0005	0.00051999092102051	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
319	0.0006	0.00061392784118652	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320	0.0007	0.0007328987121582	SELECT * FROM products WHERE id = '777'
321	0.0006	0.00059604644775391	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
322	0.0007	0.00069999694824219	SELECT * FROM product_image_select WHERE product_id = '777'
323	0.0005	0.00046110153198242	SELECT * FROM productcustomimages WHERE product_id = '777'
324	0.0012	0.0012340545654297	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
325	0.0006	0.00059294700622559	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
326	0.0005	0.00051188468933105	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
327	0.0005	0.00053191184997559	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328	0.0007	0.00071001052856445	SELECT * FROM products WHERE id = '3881'
329	0.0008	0.00081419944763184	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
330	0.0008	0.00078988075256348	SELECT * FROM product_image_select WHERE product_id = '3881'
331	0.0005	0.00047397613525391	SELECT * FROM productcustomimages WHERE product_id = '3881'
332	0.0016	0.0016219615936279	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
333	0.0006	0.00057196617126465	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
334	0.0005	0.00049400329589844	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
335	0.0005	0.00053000450134277	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336	0.0008	0.00077199935913086	SELECT * FROM products WHERE id = '4213'
337	0.0008	0.00083398818969727	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
338	0.0007	0.00067782402038574	SELECT * FROM product_image_select WHERE product_id = '4213'
339	0.0004	0.00043702125549316	SELECT * FROM productcustomimages WHERE product_id = '4213'
340	0.0022	0.0022201538085938	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
341	0.0009	0.00089097023010254	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
342	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
343	0.0005	0.00048995018005371	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344	0.0030	0.0030021667480469	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
345	0.0009	0.0008699893951416	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
346	0.0032	0.0031650066375732	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
347	0.0023	0.0023078918457031	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
348	0.0008	0.00078797340393066	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
349	0.0010	0.00097990036010742	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
350	0.0010	0.001039981842041	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "3"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3285949230194 seconds

Query Debug - 350 Database Queries. Total time 0.8766 seconds