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.5364871025085	350	0.9331	0

No Amazon API Requests Made.

App Debug - Total Time 1.5364871025085 seconds

Number	Time From Start	Name	Description
1	0.48488616943359	Initialise	Initialise FSB Function
2	0.49383497238159	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.53383994102478	Start of getCategoryListByGroup Function	Before first category groups query
4	0.5353729724884	After initial query	Before first category groups query
5	0.53537511825562	Get Category List for Group	Before the call to getCategoryList function
6	0.53538012504578	Start of GetCategoryList function	Start of the function
7	0.53538608551025	Before getting categories	Query to get specific category list
8	0.53708696365356	After getting categories	Query to get specific category list
9	0.53709006309509	Before getting category custom	Before call to function getCategoryCustom
10	0.57139706611633	After getting category custom	After call to function getCategoryCustom
11	0.57140207290649	Before getting category custom	Before call to function getCategoryCustom
12	0.59217000007629	After getting category custom	After call to function getCategoryCustom
13	0.59217500686646	Before getting category custom	Before call to function getCategoryCustom
14	0.60089802742004	After getting category custom	After call to function getCategoryCustom
15	0.60090208053589	Before getting category custom	Before call to function getCategoryCustom
16	0.61328411102295	After getting category custom	After call to function getCategoryCustom
17	0.61329007148743	Before getting category custom	Before call to function getCategoryCustom
18	0.62296009063721	After getting category custom	After call to function getCategoryCustom
19	0.62296509742737	Before getting category custom	Before call to function getCategoryCustom
20	0.63203501701355	After getting category custom	After call to function getCategoryCustom
21	0.63204002380371	End of GetCategoryList function	End of the function
22	0.63205099105835	Get Category List for Group	Before the call to getCategoryList function
23	0.63205504417419	Start of GetCategoryList function	Start of the function
24	0.63205909729004	Before getting categories	Query to get specific category list
25	0.6327531337738	End of getCategoryListByGroup Function	Before return()
26	1.1182510852814	App Controller End	End of the App controller (called before the controller of every page)
27	1.3102090358734	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.3138451576233	Before Get Options	Before the call to getOptions in the tpl class
29	1.4061751365662	After Get Options	After the call to getOptions in the tpl class
30	1.4062321186066	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.5364639759064	Finalizing debug	Before the debug is output to the page.
32	1.5364849567413	End of App	This is the end of the app logging, final timestamp

Query Debug - 350 Database Queries. Total time 0.9331 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.137.211.169\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738770921'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('3.137.211.169') >= INET_ATON(ip_start) AND INET_ATON('3.137.211.169') <= 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(), '3.137.211.169'
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.0012	0.0012288093566895	SELECT parameter, value FROM parameters
2	0.0061	0.0061080455780029	SELECT * FROM `bad_bots`
3	0.0013	0.001298189163208	SET time_zone = 'Europe/London'
4	0.0042	0.0041542053222656	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0048	0.0047988891601562	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.137.211.169\";}'
6	0.0111	0.011124134063721	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738770921'
7	0.0039	0.0039429664611816	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0011	0.0011391639709473	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0061	0.0060679912567139	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0008	0.00080108642578125	SELECT * FROM pages WHERE id = 52
11	0.0103	0.010328054428101	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0281	0.028146028518677	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0006	0.00062894821166992	SELECT * FROM pages WHERE pagename = 'search'
14	0.0015	0.0015089511871338	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0017	0.0016651153564453	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0156	0.015604972839355	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.0021	0.0020780563354492	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.0016	0.0015828609466553	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0006	0.00064897537231445	SELECT id FROM categories WHERE parent_id = '26'
20	0.0079	0.0079360008239746	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.0021	0.0020921230316162	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.0020	0.0020120143890381	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.0016	0.0015749931335449	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00050806999206543	SELECT * FROM categorygroups WHERE id = '1'
25	0.0040	0.0040180683135986	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.0007	0.00065994262695312	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.00044012069702148	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.00048494338989258	SELECT id FROM categories WHERE parent_id = '27'
29	0.0046	0.0046439170837402	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.00057601928710938	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0006	0.0006101131439209	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.0012	0.0012350082397461	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0079	0.0078790187835693	SELECT * FROM categorygroups WHERE id = '1'
34	0.0020	0.001986026763916	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0006	0.0006101131439209	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.00043702125549316	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00050210952758789	SELECT id FROM categories WHERE parent_id = '28'
38	0.0023	0.0023188591003418	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.0008	0.00080394744873047	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0007	0.00071215629577637	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0006	0.00063800811767578	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.00053501129150391	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00078701972961426	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.0016	0.0015509128570557	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.0010249614715576	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0010	0.00097918510437012	SELECT id FROM categories WHERE parent_id = '29'
47	0.0019	0.0018541812896729	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.0013	0.0012898445129395	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.0014	0.0014040470123291	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.0013179779052734	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0020	0.0019769668579102	SELECT * FROM categorygroups WHERE id = '1'
52	0.0018	0.0017731189727783	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.0012	0.0011849403381348	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.0008	0.00080990791320801	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0008	0.0008080005645752	SELECT id FROM categories WHERE parent_id = '30'
56	0.0014	0.0013508796691895	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.0009150505065918	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.0009	0.00091814994812012	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.0009911060333252	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0007	0.00073599815368652	SELECT * FROM categorygroups WHERE id = '1'
61	0.0015	0.0014879703521729	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.0006	0.00063300132751465	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.0005	0.00046205520629883	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0006	0.00058102607727051	SELECT id FROM categories WHERE parent_id = '31'
65	0.0013	0.0012710094451904	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.0009	0.00091290473937988	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.0008	0.0007779598236084	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.0016	0.0015630722045898	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0012	0.0011861324310303	SELECT * FROM categorygroups WHERE id = '1'
70	0.0007	0.00067615509033203	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0033	0.0033190250396729	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0017	0.0017468929290771	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0011	0.0011138916015625	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.0030291080474854	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0032	0.0032281875610352	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0025	0.0025300979614258	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4641	0.4641170501709	SELECT * FROM ipgeocountries WHERE INET_ATON('3.137.211.169') >= INET_ATON(ip_start) AND INET_ATON('3.137.211.169') <= INET_ATON(ip_end)
78	0.0022	0.0022380352020264	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0012	0.0012400150299072	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0007	0.00067305564880371	SELECT * FROM pages WHERE pagename = 'search'
81	0.0053	0.0052628517150879	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0017	0.0016598701477051	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0017	0.0016739368438721	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0053	0.0052871704101562	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0016	0.0016260147094727	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0005	0.0005040168762207	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0014	0.001370906829834	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '3.137.211.169'
88	0.0008	0.00075292587280273	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.0005	0.00052714347839355	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.0037	0.0036768913269043	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.0005	0.00051593780517578	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.00054097175598145	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.00064706802368164	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.0048	0.0047681331634521	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.0005	0.00047492980957031	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.00038003921508789	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.00053191184997559	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.0005	0.00053787231445312	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.0036778450012207	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.0004	0.00041007995605469	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.0004	0.00035500526428223	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.00063419342041016	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.0055	0.0054969787597656	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.00051116943359375	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.00037097930908203	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.0005	0.00048613548278809	SELECT * FROM products WHERE id = '4950'
107	0.0016	0.0016391277313232	SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
108	0.0015	0.0014569759368896	SELECT * FROM product_image_select WHERE product_id = '4950'
109	0.0011	0.0011398792266846	SELECT * FROM productcustomimages WHERE product_id = '4950'
110	0.0018	0.0018100738525391	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
111	0.0013	0.001345157623291	SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0005	0.00045490264892578	SELECT * FROM productoffers WHERE product_id = '4950' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0006	0.00058603286743164	SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114	0.0006	0.0006110668182373	SELECT * FROM products WHERE id = '4926'
115	0.0005	0.0004880428314209	SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
116	0.0006	0.00063204765319824	SELECT * FROM product_image_select WHERE product_id = '4926'
117	0.0005	0.00050091743469238	SELECT * FROM productcustomimages WHERE product_id = '4926'
118	0.0011	0.0011389255523682	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.00050997734069824	SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
120	0.0005	0.00048398971557617	SELECT * FROM productoffers WHERE product_id = '4926' AND price > 0 ORDER BY price ASC LIMIT 1
121	0.0006	0.00055313110351562	SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122	0.0006	0.00062417984008789	SELECT * FROM products WHERE id = '868'
123	0.0007	0.00072503089904785	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
124	0.0007	0.00069594383239746	SELECT * FROM product_image_select WHERE product_id = '868'
125	0.0004	0.00043106079101562	SELECT * FROM productcustomimages WHERE product_id = '868'
126	0.0009	0.00092101097106934	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
127	0.0006	0.00055599212646484	SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
128	0.0006	0.00055599212646484	SELECT * FROM productoffers WHERE product_id = '868' AND price > 0 ORDER BY price ASC LIMIT 1
129	0.0005	0.00045680999755859	SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130	0.0007	0.00065803527832031	SELECT * FROM products WHERE id = '2165'
131	0.0007	0.0007481575012207	SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
132	0.0006	0.00064587593078613	SELECT * FROM product_image_select WHERE product_id = '2165'
133	0.0004	0.00042200088500977	SELECT * FROM productcustomimages WHERE product_id = '2165'
134	0.0011	0.0010631084442139	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.00055909156799316	SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
136	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '2165' AND price > 0 ORDER BY price ASC LIMIT 1
137	0.0005	0.00047898292541504	SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138	0.0007	0.00068998336791992	SELECT * FROM products WHERE id = '4930'
139	0.0008	0.00084710121154785	SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
140	0.0007	0.00070810317993164	SELECT * FROM product_image_select WHERE product_id = '4930'
141	0.0005	0.00049710273742676	SELECT * FROM productcustomimages WHERE product_id = '4930'
142	0.0014	0.0013511180877686	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
143	0.0006	0.00056004524230957	SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0005	0.00051498413085938	SELECT * FROM productoffers WHERE product_id = '4930' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0006	0.00057792663574219	SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146	0.0028	0.0027849674224854	SELECT * FROM products WHERE id = '4948'
147	0.0007	0.00073099136352539	SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
148	0.0008	0.00081014633178711	SELECT * FROM product_image_select WHERE product_id = '4948'
149	0.0007	0.00065803527832031	SELECT * FROM productcustomimages WHERE product_id = '4948'
150	0.0013	0.0012550354003906	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
151	0.0006	0.0006110668182373	SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
152	0.0005	0.00053501129150391	SELECT * FROM productoffers WHERE product_id = '4948' AND price > 0 ORDER BY price ASC LIMIT 1
153	0.0005	0.00053000450134277	SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154	0.0007	0.00071620941162109	SELECT * FROM products WHERE id = '4941'
155	0.0006	0.00057005882263184	SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
156	0.0008	0.00075292587280273	SELECT * FROM product_image_select WHERE product_id = '4941'
157	0.0005	0.00047087669372559	SELECT * FROM productcustomimages WHERE product_id = '4941'
158	0.0022	0.0022268295288086	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
159	0.0007	0.00066494941711426	SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
160	0.0006	0.00056600570678711	SELECT * FROM productoffers WHERE product_id = '4941' AND price > 0 ORDER BY price ASC LIMIT 1
161	0.0006	0.00057196617126465	SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0008	0.00078892707824707	SELECT * FROM products WHERE id = '3809'
163	0.0006	0.00062990188598633	SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
164	0.0008	0.00083303451538086	SELECT * FROM product_image_select WHERE product_id = '3809'
165	0.0005	0.00054597854614258	SELECT * FROM productcustomimages WHERE product_id = '3809'
166	0.0016	0.0015599727630615	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.00070786476135254	SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0006	0.00055694580078125	SELECT * FROM productoffers WHERE product_id = '3809' AND price > 0 ORDER BY price ASC LIMIT 1
169	0.0006	0.00057506561279297	SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170	0.0008	0.00077605247497559	SELECT * FROM products WHERE id = '4934'
171	0.0006	0.00063705444335938	SELECT * FROM productimages WHERE product_id = '4934' ORDER BY sortorder ASC
172	0.0009	0.00086307525634766	SELECT * FROM product_image_select WHERE product_id = '4934'
173	0.0005	0.00050210952758789	SELECT * FROM productcustomimages WHERE product_id = '4934'
174	0.0021	0.0020790100097656	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4934' AND a.name = n.originalname
175	0.0007	0.00069499015808105	SELECT * FROM productoffers WHERE product_id = '4934' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0006	0.00060510635375977	SELECT * FROM productoffers WHERE product_id = '4934' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0007	0.00066184997558594	SELECT value FROM productattributes WHERE product_id = '4934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178	0.0010	0.00095486640930176	SELECT * FROM products WHERE id = '4952'
179	0.0009	0.0009160041809082	SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
180	0.0011	0.0010650157928467	SELECT * FROM product_image_select WHERE product_id = '4952'
181	0.0005	0.00051283836364746	SELECT * FROM productcustomimages WHERE product_id = '4952'
182	0.0011	0.0010991096496582	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
183	0.0006	0.00063109397888184	SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
184	0.0005	0.00053620338439941	SELECT * FROM productoffers WHERE product_id = '4952' AND price > 0 ORDER BY price ASC LIMIT 1
185	0.0006	0.00057005882263184	SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186	0.0008	0.00077700614929199	SELECT * FROM products WHERE id = '4924'
187	0.0006	0.0006401538848877	SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
188	0.0008	0.00077700614929199	SELECT * FROM product_image_select WHERE product_id = '4924'
189	0.0005	0.00049400329589844	SELECT * FROM productcustomimages WHERE product_id = '4924'
190	0.0015	0.0014889240264893	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
191	0.0006	0.00060296058654785	SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0005	0.00052118301391602	SELECT * FROM productoffers WHERE product_id = '4924' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0006	0.00058102607727051	SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
194	0.0007	0.00069499015808105	SELECT * FROM products WHERE id = '2698'
195	0.0010	0.00095486640930176	SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
196	0.0008	0.00078296661376953	SELECT * FROM product_image_select WHERE product_id = '2698'
197	0.0005	0.00050687789916992	SELECT * FROM productcustomimages WHERE product_id = '2698'
198	0.0015	0.001474142074585	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.00065302848815918	SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
200	0.0005	0.00051999092102051	SELECT * FROM productoffers WHERE product_id = '2698' AND price > 0 ORDER BY price ASC LIMIT 1
201	0.0005	0.00052309036254883	SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
202	0.0007	0.0007331371307373	SELECT * FROM products WHERE id = '1036'
203	0.0008	0.0007941722869873	SELECT * FROM productimages WHERE product_id = '1036' ORDER BY sortorder ASC
204	0.0007	0.0007321834564209	SELECT * FROM product_image_select WHERE product_id = '1036'
205	0.0005	0.00049495697021484	SELECT * FROM productcustomimages WHERE product_id = '1036'
206	0.0013	0.0013489723205566	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.00058794021606445	SELECT * FROM productoffers WHERE product_id = '1036' AND merchantid = 'A1X6FK5RDHNB96'
208	0.0005	0.00046205520629883	SELECT * FROM productoffers WHERE product_id = '1036' AND price > 0 ORDER BY price ASC LIMIT 1
209	0.0005	0.0005338191986084	SELECT * FROM productoffers WHERE product_id = 1036 ORDER BY price ASC LIMIT 1
210	0.0005	0.00046205520629883	SELECT value FROM productattributes WHERE product_id = '1036' AND name = 'ListPriceAmount'
211	0.0006	0.00055813789367676	SELECT value FROM productattributes WHERE product_id = '1036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212	0.0007	0.00069999694824219	SELECT * FROM products WHERE id = '4932'
213	0.0006	0.00063800811767578	SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
214	0.0008	0.00076198577880859	SELECT * FROM product_image_select WHERE product_id = '4932'
215	0.0005	0.00053691864013672	SELECT * FROM productcustomimages WHERE product_id = '4932'
216	0.0015	0.0014839172363281	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
217	0.0006	0.00062203407287598	SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
218	0.0005	0.00053119659423828	SELECT * FROM productoffers WHERE product_id = '4932' AND price > 0 ORDER BY price ASC LIMIT 1
219	0.0005	0.00054311752319336	SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
220	0.0011	0.0011441707611084	SELECT * FROM products WHERE id = '1274'
221	0.0011	0.0011489391326904	SELECT * FROM productimages WHERE product_id = '1274' ORDER BY sortorder ASC
222	0.0011	0.0010850429534912	SELECT * FROM product_image_select WHERE product_id = '1274'
223	0.0006	0.00058794021606445	SELECT * FROM productcustomimages WHERE product_id = '1274'
224	0.0017	0.0016608238220215	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1274' AND a.name = n.originalname
225	0.0006	0.00063514709472656	SELECT * FROM productoffers WHERE product_id = '1274' AND merchantid = 'A1X6FK5RDHNB96'
226	0.0006	0.00055313110351562	SELECT * FROM productoffers WHERE product_id = '1274' AND price > 0 ORDER BY price ASC LIMIT 1
227	0.0005	0.00054001808166504	SELECT value FROM productattributes WHERE product_id = '1274' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
228	0.0024	0.0024189949035645	SELECT * FROM products WHERE id = '850'
229	0.0011	0.0011420249938965	SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
230	0.0007	0.00068092346191406	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.0008	0.00076699256896973	SELECT * FROM product_image_select WHERE product_id = '850'
232	0.0012	0.0011880397796631	SELECT * FROM productcustomimages WHERE product_id = '850'
233	0.0009	0.00094485282897949	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.0033	0.0033211708068848	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.00065302848815918	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.0010	0.0010409355163574	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
237	0.0006	0.00061202049255371	SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
238	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '850' AND price > 0 ORDER BY price ASC LIMIT 1
239	0.0004	0.00042080879211426	SELECT * FROM productoffers WHERE product_id = 850 ORDER BY price ASC LIMIT 1
240	0.0005	0.0004580020904541	SELECT value FROM productattributes WHERE product_id = '850' AND name = 'ListPriceAmount'
241	0.0008	0.00077319145202637	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.0007	0.00070500373840332	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.00046181678771973	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.0006	0.00061297416687012	SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245	0.0007	0.00072002410888672	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.0006	0.00057387351989746	SELECT * FROM products WHERE parent_id = '850'
247	0.0006	0.00062298774719238	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
248	0.0005	0.00053119659423828	SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
249	0.0005	0.00049304962158203	SELECT * FROM productoffers WHERE product_id = '4891' AND price > 0 ORDER BY price ASC LIMIT 1
250	0.0005	0.00054192543029785	SELECT * FROM products WHERE id = '4946'
251	0.0005	0.00054287910461426	SELECT * FROM productimages WHERE product_id = '4946' ORDER BY sortorder ASC
252	0.0008	0.00081181526184082	SELECT * FROM product_image_select WHERE product_id = '4946'
253	0.0005	0.00048494338989258	SELECT * FROM productcustomimages WHERE product_id = '4946'
254	0.0010	0.0010490417480469	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.00059890747070312	SELECT * FROM productoffers WHERE product_id = '4946' AND merchantid = 'A1X6FK5RDHNB96'
256	0.0005	0.00049185752868652	SELECT * FROM productoffers WHERE product_id = '4946' AND price > 0 ORDER BY price ASC LIMIT 1
257	0.0005	0.00052785873413086	SELECT value FROM productattributes WHERE product_id = '4946' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258	0.0007	0.00072383880615234	SELECT * FROM products WHERE id = '4947'
259	0.0006	0.0005791187286377	SELECT * FROM productimages WHERE product_id = '4947' ORDER BY sortorder ASC
260	0.0008	0.00075888633728027	SELECT * FROM product_image_select WHERE product_id = '4947'
261	0.0005	0.00049591064453125	SELECT * FROM productcustomimages WHERE product_id = '4947'
262	0.0011	0.0010838508605957	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.00063204765319824	SELECT * FROM productoffers WHERE product_id = '4947' AND merchantid = 'A1X6FK5RDHNB96'
264	0.0005	0.00049209594726562	SELECT * FROM productoffers WHERE product_id = '4947' AND price > 0 ORDER BY price ASC LIMIT 1
265	0.0005	0.00053811073303223	SELECT value FROM productattributes WHERE product_id = '4947' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266	0.0018	0.0018241405487061	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
267	0.0004	0.00044393539428711	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
268	0.0004	0.0004119873046875	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
269	0.0004	0.00037002563476562	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
270	0.0004	0.0003659725189209	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
271	0.0005	0.00046896934509277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
272	0.0006	0.00058293342590332	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
273	0.0004	0.0003819465637207	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
274	0.0004	0.00044703483581543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4934' ORDER BY timestamp DESC
275	0.0005	0.00046205520629883	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
276	0.0005	0.00047707557678223	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4924' ORDER BY timestamp DESC
277	0.0005	0.00046801567077637	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2698' ORDER BY timestamp DESC
278	0.0005	0.00047397613525391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1036' ORDER BY timestamp DESC
279	0.0004	0.00043988227844238	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
280	0.0006	0.0005650520324707	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1274' ORDER BY timestamp DESC
281	0.0004	0.00039386749267578	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
282	0.0005	0.00051498413085938	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4946' ORDER BY timestamp DESC
283	0.0004	0.00041294097900391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4947' ORDER BY timestamp DESC
284	0.0020	0.0020051002502441	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
285	0.0029	0.0029211044311523	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
286	0.0006	0.00058102607727051	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
287	0.0182	0.018176794052124	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.0018	0.001798152923584	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.0006	0.00057506561279297	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.0006	0.00061678886413574	SELECT * FROM products WHERE id = 1626
291	0.0006	0.00064802169799805	SELECT * FROM products WHERE id = 4041
292	0.0007	0.00066995620727539	SELECT * FROM products WHERE id = 4312
293	0.0006	0.00057196617126465	SELECT * FROM products WHERE id = 777
294	0.0005	0.00047183036804199	SELECT * FROM products WHERE id = 3881
295	0.0006	0.00058698654174805	SELECT * FROM products WHERE id = 4213
296	0.0006	0.00059008598327637	SELECT * FROM products WHERE id = '1626'
297	0.0005	0.00047087669372559	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
298	0.0007	0.00065422058105469	SELECT * FROM product_image_select WHERE product_id = '1626'
299	0.0004	0.0004270076751709	SELECT * FROM productcustomimages WHERE product_id = '1626'
300	0.0008	0.00084114074707031	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
301	0.0005	0.00052213668823242	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
302	0.0005	0.00053715705871582	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
303	0.0005	0.00047612190246582	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304	0.0007	0.00068497657775879	SELECT * FROM products WHERE id = '4041'
305	0.0005	0.00050806999206543	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
306	0.0007	0.00066804885864258	SELECT * FROM product_image_select WHERE product_id = '4041'
307	0.0005	0.00045394897460938	SELECT * FROM productcustomimages WHERE product_id = '4041'
308	0.0012	0.0011551380157471	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.00055289268493652	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
310	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
311	0.0005	0.00046801567077637	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
312	0.0007	0.00066590309143066	SELECT * FROM products WHERE id = '4312'
313	0.0006	0.00055789947509766	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
314	0.0007	0.00067782402038574	SELECT * FROM product_image_select WHERE product_id = '4312'
315	0.0005	0.00048303604125977	SELECT * FROM productcustomimages WHERE product_id = '4312'
316	0.0013	0.0012609958648682	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
317	0.0005	0.00053715705871582	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
318	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
319	0.0005	0.00050497055053711	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
320	0.0006	0.00063800811767578	SELECT * FROM products WHERE id = '777'
321	0.0005	0.0005338191986084	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
322	0.0007	0.00069379806518555	SELECT * FROM product_image_select WHERE product_id = '777'
323	0.0005	0.00047993659973145	SELECT * FROM productcustomimages WHERE product_id = '777'
324	0.0011	0.0011310577392578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
325	0.0005	0.00052690505981445	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
326	0.0005	0.00046205520629883	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
327	0.0005	0.00052881240844727	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
328	0.0008	0.00077199935913086	SELECT * FROM products WHERE id = '3881'
329	0.0008	0.00079202651977539	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
330	0.0007	0.00072693824768066	SELECT * FROM product_image_select WHERE product_id = '3881'
331	0.0005	0.00048589706420898	SELECT * FROM productcustomimages WHERE product_id = '3881'
332	0.0014	0.0014441013336182	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.00061702728271484	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
334	0.0033	0.0033149719238281	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
335	0.0012	0.0011589527130127	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336	0.0017	0.0016860961914062	SELECT * FROM products WHERE id = '4213'
337	0.0021	0.002126932144165	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
338	0.0021	0.0021228790283203	SELECT * FROM product_image_select WHERE product_id = '4213'
339	0.0100	0.010039091110229	SELECT * FROM productcustomimages WHERE product_id = '4213'
340	0.0047	0.0047180652618408	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
341	0.0021	0.0021259784698486	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
342	0.0006	0.00063085556030273	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
343	0.0007	0.00072097778320312	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344	0.0027	0.0026729106903076	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
345	0.0009	0.00091195106506348	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
346	0.0034	0.0033831596374512	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
347	0.0025	0.0024900436401367	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
348	0.0010	0.0009620189666748	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
349	0.0015	0.0014870166778564	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
350	0.0009	0.00087094306945801	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.5364871025085 seconds

Query Debug - 350 Database Queries. Total time 0.9331 seconds