Search Results for "2"

Thé rooïbos BADERs Cranberry plus Acerol...

only €7,90

View

Add to Cart

Lipton Lipton Infusion Rooibos Vanille 1...

View to See Price

View

Add to Cart

Boîte à thé en métal - blanc

only €8,99

View

Add to Cart

DERRIERE LA PORTE - Boite à boucles d'or...

only €18,00

View

Add to Cart

Lot de boîtes en métal - thé/café/sucre ...

€18,86 €15,99

View

Add to Cart

Lipton Tchaé Thé Vert Menthe 25 Sachets ...

only €19,90

View

Add to Cart

[Boîte à Café] Luxebell 1.2 L/500g Récip...

only €24,99

View

Add to Cart

Petite boîte de rangement rétro Boîte de...

View to See Price

View

Add to Cart

Petite boîte de rangement rétro Boîte de...

View to See Price

View

Add to Cart

Grains de café péruvien, biologique, fai...

only €25,96

View

Add to Cart

Kitchen craft le'xpress boîte à thé en ...

only €18,79

View

Add to Cart

Boîte à thé 12 compartiments gravée d'un...

only €22,90

View

Add to Cart

BADERs Cynarin Artischocke. Thé rooibos ...

only €14,90

View

Add to Cart

[Multicolor-3] Boîte à thé en céramique ...

only €24,77

View

Add to Cart

Boîte à thé double couvercle

View to See Price

View

Add to Cart

Sunny jours boîtes Thé Café et sucre

View to See Price

View

Add to Cart

Lot de boîtes en métal - thé/café/sucre ...

only €15,99

View

Add to Cart

Boîte à thé en acier inoxydable

only €6,99

View

Add to Cart

145 to 162 of 532 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
3.0078001022339	388	1.0794	0

No Amazon API Requests Made.

App Debug - Total Time 3.0078001022339 seconds

Number	Time From Start	Name	Description
1	1.8023180961609	Initialise	Initialise FSB Function
2	1.8087420463562	App Controller Start	Start of the App controller (called before the controller of every page)
3	1.8618061542511	Start of getCategoryListByGroup Function	Before first category groups query
4	1.8650431632996	After initial query	Before first category groups query
5	1.8650450706482	Get Category List for Group	Before the call to getCategoryList function
6	1.8650481700897	Start of GetCategoryList function	Start of the function
7	1.8650510311127	Before getting categories	Query to get specific category list
8	1.8686640262604	After getting categories	Query to get specific category list
9	1.8686661720276	Before getting category custom	Before call to function getCategoryCustom
10	1.9061150550842	After getting category custom	After call to function getCategoryCustom
11	1.9061181545258	Before getting category custom	Before call to function getCategoryCustom
12	1.9176790714264	After getting category custom	After call to function getCategoryCustom
13	1.9176812171936	Before getting category custom	Before call to function getCategoryCustom
14	1.9250340461731	After getting category custom	After call to function getCategoryCustom
15	1.9250361919403	Before getting category custom	Before call to function getCategoryCustom
16	1.9303150177002	After getting category custom	After call to function getCategoryCustom
17	1.9303162097931	Before getting category custom	Before call to function getCategoryCustom
18	1.9355330467224	After getting category custom	After call to function getCategoryCustom
19	1.9355351924896	Before getting category custom	Before call to function getCategoryCustom
20	1.9416060447693	After getting category custom	After call to function getCategoryCustom
21	1.9416081905365	End of GetCategoryList function	End of the function
22	1.9416131973267	Get Category List for Group	Before the call to getCategoryList function
23	1.9416151046753	Start of GetCategoryList function	Start of the function
24	1.9416170120239	Before getting categories	Query to get specific category list
25	1.9423069953918	End of getCategoryListByGroup Function	Before return()
26	2.5158581733704	App Controller End	End of the App controller (called before the controller of every page)
27	2.8071579933167	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	2.8106741905212	Before Get Options	Before the call to getOptions in the tpl class
29	2.8924200534821	After Get Options	After the call to getOptions in the tpl class
30	2.8924610614777	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	3.0077810287476	Finalizing debug	Before the debug is output to the page.
32	3.0077981948853	End of App	This is the end of the app logging, final timestamp

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

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

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

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

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
SELECT * FROM products WHERE id = '1044'
SELECT * FROM productimages WHERE product_id = '1044' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1044'
SELECT * FROM productcustomimages WHERE product_id = '1044'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1044' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1044' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1044' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1267'
SELECT * FROM productimages WHERE product_id = '1267' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1267'
SELECT * FROM productcustomimages WHERE product_id = '1267'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1267' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1267' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1267' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1267
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1267'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1267' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1574'
SELECT * FROM productimages WHERE product_id = '1574' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1574'
SELECT * FROM productcustomimages WHERE product_id = '1574'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1574' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1574' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1574' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1574' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1291'
SELECT * FROM productimages WHERE product_id = '1291' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1291'
SELECT * FROM productcustomimages WHERE product_id = '1291'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1291' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1291' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1291
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1291'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1601'
SELECT * FROM productimages WHERE product_id = '1601' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1601'
SELECT * FROM productcustomimages WHERE product_id = '1601'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1601' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1601' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1601' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '857'
SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '857'
SELECT * FROM productcustomimages WHERE product_id = '857'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '857' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '790'
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '790'
SELECT * FROM productcustomimages WHERE product_id = '790'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '790' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 790
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '790'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2941'
SELECT * FROM productimages WHERE product_id = '2941' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2941' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2941'
SELECT * FROM productcustomimages WHERE product_id = '2941'
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 = '2941'
                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     = '2941'
                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 = 2941
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2941' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2941' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2941' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2941
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2941'
                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 = '2941'
                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     = '2941'
                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 = 2941
SELECT value FROM productattributes WHERE product_id = '2941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2941'
SELECT * FROM products WHERE id = '2942'
SELECT * FROM productimages WHERE product_id = '2942' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2942' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2942'
SELECT * FROM productcustomimages WHERE product_id = '2942'
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 = '2942'
                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     = '2942'
                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 = 2942
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2942' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2942' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2942' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2942
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2942'
                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 = '2942'
                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     = '2942'
                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 = 2942
SELECT value FROM productattributes WHERE product_id = '2942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2942'
SELECT * FROM products WHERE id = '4935'
SELECT * FROM productimages WHERE product_id = '4935' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4935'
SELECT * FROM productcustomimages WHERE product_id = '4935'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4935' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4935' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4935' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4935
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4935'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4935' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '776'
SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '776'
SELECT * FROM productcustomimages WHERE product_id = '776'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '776' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2358'
SELECT * FROM productimages WHERE product_id = '2358' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2358'
SELECT * FROM productcustomimages WHERE product_id = '2358'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2358' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2358' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2358' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2358' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '858'
SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '858'
SELECT * FROM productcustomimages WHERE product_id = '858'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '858' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1462'
SELECT * FROM productimages WHERE product_id = '1462' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1462' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1462'
SELECT * FROM productcustomimages WHERE product_id = '1462'
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 = '1462'
                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     = '1462'
                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 = 1462
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1462' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1462' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1462' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1462
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1462'
                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 = '1462'
                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     = '1462'
                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 = 1462
SELECT * FROM products WHERE parent_id = '1462'
SELECT * FROM products WHERE id = '846'
SELECT * FROM productimages WHERE product_id = '846' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '846' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '846'
SELECT * FROM productcustomimages WHERE product_id = '846'
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 = '846'
                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     = '846'
                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 = 846
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '846' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '846' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '846' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 846
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '846'
                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 = '846'
                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     = '846'
                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 = 846
SELECT value FROM productattributes WHERE product_id = '846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '846'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1669'
SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1669'
SELECT * FROM productcustomimages WHERE product_id = '1669'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1669' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1669
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1669'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1629'
SELECT * FROM productimages WHERE product_id = '1629' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1629'
SELECT * FROM productcustomimages WHERE product_id = '1629'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1629' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1629' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1629' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1629
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1629'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1629' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1562'
SELECT * FROM productimages WHERE product_id = '1562' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1562'
SELECT * FROM productcustomimages WHERE product_id = '1562'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1562' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1562' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1562' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1562
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1562'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1562' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1044' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1267' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1574' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1291' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1601' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '857' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '790' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2941' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2942' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4935' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '776' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2358' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '858' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1462' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '846' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1669' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1629' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1562' 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.0014	0.0013558864593506	SELECT parameter, value FROM parameters
2	0.0045	0.0044639110565186	SELECT * FROM `bad_bots`
3	0.0004	0.00038886070251465	SET time_zone = 'Europe/London'
4	0.0038	0.0038309097290039	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0040	0.0039501190185547	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.12.74.180\";}'
6	0.0034	0.0034379959106445	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738813781'
7	0.0058	0.0058188438415527	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00075101852416992	UPDATE autorun SET lastrun = '2025-02-06 03:49:41' WHERE id = '9'
9	0.0008	0.0008399486541748	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0042	0.0042269229888916	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0006	0.00064420700073242	SELECT * FROM pages WHERE id = 52
12	0.0057	0.0056769847869873	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0457	0.045737981796265	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0011	0.0011460781097412	SELECT * FROM pages WHERE pagename = 'search'
15	0.0032	0.0032250881195068	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0036	0.003593921661377	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0181	0.018111944198608	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
18	0.0034	0.0034379959106445	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19	0.0034	0.0033638477325439	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0006	0.00064301490783691	SELECT id FROM categories WHERE parent_id = '26'
21	0.0057	0.005748987197876	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
22	0.0021	0.0021378993988037	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
23	0.0017	0.0017049312591553	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
24	0.0015	0.0014698505401611	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0007	0.00069403648376465	SELECT * FROM categorygroups WHERE id = '1'
26	0.0037	0.0036680698394775	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
27	0.0006	0.00060105323791504	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0005	0.00047993659973145	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0006	0.00064396858215332	SELECT id FROM categories WHERE parent_id = '27'
30	0.0038	0.0038001537322998	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
31	0.0006	0.00057506561279297	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
32	0.0007	0.0006561279296875	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
33	0.0006	0.00059604644775391	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0005	0.00045680999755859	SELECT * FROM categorygroups WHERE id = '1'
35	0.0016	0.0016310214996338	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
36	0.0005	0.00054216384887695	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0007	0.00066208839416504	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.00049519538879395	SELECT id FROM categories WHERE parent_id = '28'
39	0.0017	0.0016710758209229	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
40	0.0006	0.00056695938110352	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
41	0.0006	0.00056290626525879	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
42	0.0005	0.00054192543029785	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0006	0.00060701370239258	SELECT * FROM categorygroups WHERE id = '1'
44	0.0007	0.00067305564880371	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
45	0.0008	0.00075507164001465	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0005	0.00051188468933105	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0005	0.00046181678771973	SELECT id FROM categories WHERE parent_id = '29'
48	0.0008	0.00075101852416992	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
49	0.0006	0.00055098533630371	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
50	0.0005	0.00051379203796387	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
51	0.0005	0.00051498413085938	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0005	0.00045609474182129	SELECT * FROM categorygroups WHERE id = '1'
53	0.0006	0.00062203407287598	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
54	0.0005	0.00051999092102051	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55	0.0006	0.00060701370239258	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00046515464782715	SELECT id FROM categories WHERE parent_id = '30'
57	0.0007	0.00073003768920898	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
58	0.0006	0.00059294700622559	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
59	0.0006	0.00057888031005859	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
60	0.0005	0.00053095817565918	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0005	0.00048017501831055	SELECT * FROM categorygroups WHERE id = '1'
62	0.0008	0.00082707405090332	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
63	0.0007	0.00073409080505371	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64	0.0004	0.00043416023254395	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0007	0.00072097778320312	SELECT id FROM categories WHERE parent_id = '31'
66	0.0008	0.00078892707824707	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
67	0.0006	0.00056886672973633	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
68	0.0007	0.0007178783416748	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
69	0.0007	0.00067305564880371	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0005	0.00052714347839355	SELECT * FROM categorygroups WHERE id = '1'
71	0.0007	0.00067996978759766	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0030	0.0029981136322021	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0020	0.0020229816436768	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0006	0.00060796737670898	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
75	0.0013	0.0013480186462402	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0011	0.0010719299316406	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0011	0.0010950565338135	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.5589	0.55893707275391	SELECT * FROM ipgeocountries WHERE INET_ATON('3.12.74.180') >= INET_ATON(ip_start) AND INET_ATON('3.12.74.180') <= INET_ATON(ip_end)
79	0.0021	0.0021288394927979	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0013	0.0013360977172852	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0009	0.00091099739074707	SELECT * FROM pages WHERE pagename = 'search'
82	0.0098	0.0097908973693848	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0024	0.0024411678314209	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0022	0.002190113067627	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0072	0.0072469711303711	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0016	0.0016369819641113	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0006	0.00057697296142578	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0018	0.0017859935760498	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '3.12.74.180'
89	0.0009	0.00087380409240723	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0006	0.00062084197998047	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
91	0.0046	0.0045769214630127	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
92	0.0006	0.00061607360839844	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
93	0.0006	0.00055885314941406	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
94	0.0006	0.00064992904663086	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
95	0.0050	0.0050129890441895	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
96	0.0004	0.00038790702819824	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
97	0.0004	0.00038599967956543	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
98	0.0006	0.00058603286743164	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0005	0.00052809715270996	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0042	0.0042030811309814	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
101	0.0006	0.00058412551879883	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
102	0.0005	0.00048708915710449	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
103	0.0007	0.00072598457336426	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0057	0.0057029724121094	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
105	0.0005	0.0004880428314209	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
106	0.0004	0.00044488906860352	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
107	0.0006	0.00056600570678711	SELECT * FROM products WHERE id = '1044'
108	0.0018	0.0018110275268555	SELECT * FROM productimages WHERE product_id = '1044' ORDER BY sortorder ASC
109	0.0015	0.0015349388122559	SELECT * FROM product_image_select WHERE product_id = '1044'
110	0.0013	0.0012609958648682	SELECT * FROM productcustomimages WHERE product_id = '1044'
111	0.0022	0.0022139549255371	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1044' AND a.name = n.originalname
112	0.0017	0.0017039775848389	SELECT * FROM productoffers WHERE product_id = '1044' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0005	0.00048398971557617	SELECT * FROM productoffers WHERE product_id = '1044' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0008	0.00084185600280762	SELECT value FROM productattributes WHERE product_id = '1044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115	0.0007	0.00068497657775879	SELECT * FROM products WHERE id = '1267'
116	0.0006	0.00062417984008789	SELECT * FROM productimages WHERE product_id = '1267' ORDER BY sortorder ASC
117	0.0007	0.00070309638977051	SELECT * FROM product_image_select WHERE product_id = '1267'
118	0.0005	0.00050091743469238	SELECT * FROM productcustomimages WHERE product_id = '1267'
119	0.0011	0.0011310577392578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1267' AND a.name = n.originalname
120	0.0006	0.00055789947509766	SELECT * FROM productoffers WHERE product_id = '1267' AND merchantid = 'A1X6FK5RDHNB96'
121	0.0005	0.00050115585327148	SELECT * FROM productoffers WHERE product_id = '1267' AND price > 0 ORDER BY price ASC LIMIT 1
122	0.0004	0.00038909912109375	SELECT * FROM productoffers WHERE product_id = 1267 ORDER BY price ASC LIMIT 1
123	0.0005	0.00048494338989258	SELECT value FROM productattributes WHERE product_id = '1267' AND name = 'ListPriceAmount'
124	0.0005	0.00050187110900879	SELECT value FROM productattributes WHERE product_id = '1267' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125	0.0006	0.00064516067504883	SELECT * FROM products WHERE id = '1574'
126	0.0008	0.000823974609375	SELECT * FROM productimages WHERE product_id = '1574' ORDER BY sortorder ASC
127	0.0008	0.00075006484985352	SELECT * FROM product_image_select WHERE product_id = '1574'
128	0.0005	0.00046920776367188	SELECT * FROM productcustomimages WHERE product_id = '1574'
129	0.0013	0.0013458728790283	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1574' AND a.name = n.originalname
130	0.0006	0.00058603286743164	SELECT * FROM productoffers WHERE product_id = '1574' AND merchantid = 'A1X6FK5RDHNB96'
131	0.0006	0.00060701370239258	SELECT * FROM productoffers WHERE product_id = '1574' AND price > 0 ORDER BY price ASC LIMIT 1
132	0.0006	0.00055289268493652	SELECT value FROM productattributes WHERE product_id = '1574' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0007	0.00074911117553711	SELECT * FROM products WHERE id = '1291'
134	0.0006	0.00055694580078125	SELECT * FROM productimages WHERE product_id = '1291' ORDER BY sortorder ASC
135	0.0007	0.00073003768920898	SELECT * FROM product_image_select WHERE product_id = '1291'
136	0.0005	0.00052905082702637	SELECT * FROM productcustomimages WHERE product_id = '1291'
137	0.0022	0.0021920204162598	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1291' AND a.name = n.originalname
138	0.0008	0.00083589553833008	SELECT * FROM productoffers WHERE product_id = '1291' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = '1291' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0004	0.00039315223693848	SELECT * FROM productoffers WHERE product_id = 1291 ORDER BY price ASC LIMIT 1
141	0.0006	0.00055789947509766	SELECT value FROM productattributes WHERE product_id = '1291' AND name = 'ListPriceAmount'
142	0.0005	0.00048494338989258	SELECT value FROM productattributes WHERE product_id = '1291' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143	0.0009	0.00090789794921875	SELECT * FROM products WHERE id = '1601'
144	0.0007	0.00069904327392578	SELECT * FROM productimages WHERE product_id = '1601' ORDER BY sortorder ASC
145	0.0006	0.00061798095703125	SELECT * FROM product_image_select WHERE product_id = '1601'
146	0.0006	0.0006411075592041	SELECT * FROM productcustomimages WHERE product_id = '1601'
147	0.0019	0.00187087059021	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1601' AND a.name = n.originalname
148	0.0006	0.00058102607727051	SELECT * FROM productoffers WHERE product_id = '1601' AND merchantid = 'A1X6FK5RDHNB96'
149	0.0005	0.00048995018005371	SELECT * FROM productoffers WHERE product_id = '1601' AND price > 0 ORDER BY price ASC LIMIT 1
150	0.0007	0.00068402290344238	SELECT value FROM productattributes WHERE product_id = '1601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0007	0.00065803527832031	SELECT * FROM products WHERE id = '857'
152	0.0016	0.0016329288482666	SELECT * FROM productimages WHERE product_id = '857' ORDER BY sortorder ASC
153	0.0015	0.0014679431915283	SELECT * FROM product_image_select WHERE product_id = '857'
154	0.0008	0.0007939338684082	SELECT * FROM productcustomimages WHERE product_id = '857'
155	0.0029	0.0028650760650635	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '857' AND a.name = n.originalname
156	0.0015	0.0014700889587402	SELECT * FROM productoffers WHERE product_id = '857' AND merchantid = 'A1X6FK5RDHNB96'
157	0.0009	0.00094389915466309	SELECT * FROM productoffers WHERE product_id = '857' AND price > 0 ORDER BY price ASC LIMIT 1
158	0.0009	0.00087523460388184	SELECT value FROM productattributes WHERE product_id = '857' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
159	0.0014	0.0013659000396729	SELECT * FROM products WHERE id = '790'
160	0.0022	0.0021989345550537	SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
161	0.0016	0.0015718936920166	SELECT * FROM product_image_select WHERE product_id = '790'
162	0.0010	0.0009610652923584	SELECT * FROM productcustomimages WHERE product_id = '790'
163	0.0080	0.0079669952392578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '790' AND a.name = n.originalname
164	0.0018	0.0018479824066162	SELECT * FROM productoffers WHERE product_id = '790' AND merchantid = 'A1X6FK5RDHNB96'
165	0.0008	0.00083780288696289	SELECT * FROM productoffers WHERE product_id = '790' AND price > 0 ORDER BY price ASC LIMIT 1
166	0.0009	0.00092697143554688	SELECT * FROM productoffers WHERE product_id = 790 ORDER BY price ASC LIMIT 1
167	0.0014	0.0014300346374512	SELECT value FROM productattributes WHERE product_id = '790' AND name = 'ListPriceAmount'
168	0.0008	0.00081300735473633	SELECT value FROM productattributes WHERE product_id = '790' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
169	0.0009	0.00093412399291992	SELECT * FROM products WHERE id = '2941'
170	0.0011	0.0011098384857178	SELECT * FROM productimages WHERE product_id = '2941' ORDER BY sortorder ASC
171	0.0007	0.00070595741271973	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2941' AND p.id = pi.product_id ORDER BY pi.sortorder
172	0.0011	0.0010991096496582	SELECT * FROM product_image_select WHERE product_id = '2941'
173	0.0006	0.00058913230895996	SELECT * FROM productcustomimages WHERE product_id = '2941'
174	0.0012	0.001194953918457	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 = '2941' GROUP BY o.product_id
175	0.0058	0.0058391094207764	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 = '2941' GROUP BY n.displayname ORDER BY n.displayname DESC
176	0.0006	0.00059199333190918	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2941
177	0.0014	0.0014431476593018	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2941' AND a.name = n.originalname
178	0.0005	0.0004880428314209	SELECT * FROM productoffers WHERE product_id = '2941' AND merchantid = 'A1X6FK5RDHNB96'
179	0.0006	0.00062799453735352	SELECT * FROM productoffers WHERE product_id = '2941' AND price > 0 ORDER BY price ASC LIMIT 1
180	0.0004	0.00043392181396484	SELECT * FROM productoffers WHERE product_id = 2941 ORDER BY price ASC LIMIT 1
181	0.0004	0.00043392181396484	SELECT value FROM productattributes WHERE product_id = '2941' AND name = 'ListPriceAmount'
182	0.0005	0.00048208236694336	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 = '2941' GROUP BY o.product_id
183	0.0007	0.00066709518432617	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 = '2941' GROUP BY n.displayname ORDER BY n.displayname DESC
184	0.0004	0.00040006637573242	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2941
185	0.0006	0.0006260871887207	SELECT value FROM productattributes WHERE product_id = '2941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
186	0.0007	0.00068211555480957	SELECT * FROM products WHERE parent_id = '2941'
187	0.0005	0.00054216384887695	SELECT * FROM products WHERE id = '2942'
188	0.0006	0.00063109397888184	SELECT * FROM productimages WHERE product_id = '2942' ORDER BY sortorder ASC
189	0.0006	0.00055599212646484	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2942' AND p.id = pi.product_id ORDER BY pi.sortorder
190	0.0007	0.00074219703674316	SELECT * FROM product_image_select WHERE product_id = '2942'
191	0.0004	0.0004429817199707	SELECT * FROM productcustomimages WHERE product_id = '2942'
192	0.0006	0.00059199333190918	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 = '2942' GROUP BY o.product_id
193	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 = '2942' GROUP BY n.displayname ORDER BY n.displayname DESC
194	0.0004	0.00042605400085449	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2942
195	0.0015	0.0015189647674561	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2942' AND a.name = n.originalname
196	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '2942' AND merchantid = 'A1X6FK5RDHNB96'
197	0.0005	0.00045514106750488	SELECT * FROM productoffers WHERE product_id = '2942' AND price > 0 ORDER BY price ASC LIMIT 1
198	0.0004	0.00040006637573242	SELECT * FROM productoffers WHERE product_id = 2942 ORDER BY price ASC LIMIT 1
199	0.0005	0.00049304962158203	SELECT value FROM productattributes WHERE product_id = '2942' AND name = 'ListPriceAmount'
200	0.0005	0.00049710273742676	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 = '2942' GROUP BY o.product_id
201	0.0007	0.00074505805969238	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 = '2942' GROUP BY n.displayname ORDER BY n.displayname DESC
202	0.0005	0.00046682357788086	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2942
203	0.0010	0.00098609924316406	SELECT value FROM productattributes WHERE product_id = '2942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
204	0.0006	0.00055408477783203	SELECT * FROM products WHERE parent_id = '2942'
205	0.0006	0.00056982040405273	SELECT * FROM products WHERE id = '4935'
206	0.0007	0.00065302848815918	SELECT * FROM productimages WHERE product_id = '4935' ORDER BY sortorder ASC
207	0.0006	0.00064587593078613	SELECT * FROM product_image_select WHERE product_id = '4935'
208	0.0004	0.00042009353637695	SELECT * FROM productcustomimages WHERE product_id = '4935'
209	0.0019	0.0018908977508545	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4935' AND a.name = n.originalname
210	0.0007	0.00070786476135254	SELECT * FROM productoffers WHERE product_id = '4935' AND merchantid = 'A1X6FK5RDHNB96'
211	0.0006	0.00055599212646484	SELECT * FROM productoffers WHERE product_id = '4935' AND price > 0 ORDER BY price ASC LIMIT 1
212	0.0005	0.00049686431884766	SELECT * FROM productoffers WHERE product_id = 4935 ORDER BY price ASC LIMIT 1
213	0.0005	0.00045394897460938	SELECT value FROM productattributes WHERE product_id = '4935' AND name = 'ListPriceAmount'
214	0.0005	0.00045013427734375	SELECT value FROM productattributes WHERE product_id = '4935' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215	0.0006	0.00059700012207031	SELECT * FROM products WHERE id = '776'
216	0.0007	0.00068902969360352	SELECT * FROM productimages WHERE product_id = '776' ORDER BY sortorder ASC
217	0.0006	0.00062108039855957	SELECT * FROM product_image_select WHERE product_id = '776'
218	0.0004	0.00042510032653809	SELECT * FROM productcustomimages WHERE product_id = '776'
219	0.0011	0.0010528564453125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '776' AND a.name = n.originalname
220	0.0006	0.00064516067504883	SELECT * FROM productoffers WHERE product_id = '776' AND merchantid = 'A1X6FK5RDHNB96'
221	0.0005	0.00046396255493164	SELECT * FROM productoffers WHERE product_id = '776' AND price > 0 ORDER BY price ASC LIMIT 1
222	0.0005	0.00053000450134277	SELECT value FROM productattributes WHERE product_id = '776' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223	0.0009	0.00092101097106934	SELECT * FROM products WHERE id = '2358'
224	0.0005	0.00053286552429199	SELECT * FROM productimages WHERE product_id = '2358' ORDER BY sortorder ASC
225	0.0007	0.00068497657775879	SELECT * FROM product_image_select WHERE product_id = '2358'
226	0.0005	0.00053906440734863	SELECT * FROM productcustomimages WHERE product_id = '2358'
227	0.0011	0.0011060237884521	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2358' AND a.name = n.originalname
228	0.0006	0.0006108283996582	SELECT * FROM productoffers WHERE product_id = '2358' AND merchantid = 'A1X6FK5RDHNB96'
229	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = '2358' AND price > 0 ORDER BY price ASC LIMIT 1
230	0.0005	0.00053000450134277	SELECT value FROM productattributes WHERE product_id = '2358' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
231	0.0007	0.0007328987121582	SELECT * FROM products WHERE id = '858'
232	0.0014	0.001417875289917	SELECT * FROM productimages WHERE product_id = '858' ORDER BY sortorder ASC
233	0.0013	0.0012969970703125	SELECT * FROM product_image_select WHERE product_id = '858'
234	0.0008	0.00083398818969727	SELECT * FROM productcustomimages WHERE product_id = '858'
235	0.0029	0.0028691291809082	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '858' AND a.name = n.originalname
236	0.0010	0.0010368824005127	SELECT * FROM productoffers WHERE product_id = '858' AND merchantid = 'A1X6FK5RDHNB96'
237	0.0008	0.00082206726074219	SELECT * FROM productoffers WHERE product_id = '858' AND price > 0 ORDER BY price ASC LIMIT 1
238	0.0008	0.00083398818969727	SELECT value FROM productattributes WHERE product_id = '858' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239	0.0013	0.0013148784637451	SELECT * FROM products WHERE id = '1462'
240	0.0010	0.00098991394042969	SELECT * FROM productimages WHERE product_id = '1462' ORDER BY sortorder ASC
241	0.0009	0.00087189674377441	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1462' AND p.id = pi.product_id ORDER BY pi.sortorder
242	0.0018	0.0018081665039062	SELECT * FROM product_image_select WHERE product_id = '1462'
243	0.0010	0.00095415115356445	SELECT * FROM productcustomimages WHERE product_id = '1462'
244	0.0012	0.0012259483337402	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 = '1462' GROUP BY o.product_id
245	0.0013	0.0013198852539062	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 = '1462' GROUP BY n.displayname ORDER BY n.displayname DESC
246	0.0006	0.00063490867614746	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1462
247	0.0024	0.0023858547210693	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1462' AND a.name = n.originalname
248	0.0006	0.00059199333190918	SELECT * FROM productoffers WHERE product_id = '1462' AND merchantid = 'A1X6FK5RDHNB96'
249	0.0006	0.00055217742919922	SELECT * FROM productoffers WHERE product_id = '1462' AND price > 0 ORDER BY price ASC LIMIT 1
250	0.0005	0.00051498413085938	SELECT * FROM productoffers WHERE product_id = 1462 ORDER BY price ASC LIMIT 1
251	0.0006	0.00059008598327637	SELECT value FROM productattributes WHERE product_id = '1462' AND name = 'ListPriceAmount'
252	0.0006	0.00058722496032715	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 = '1462' GROUP BY o.product_id
253	0.0009	0.00091791152954102	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 = '1462' GROUP BY n.displayname ORDER BY n.displayname DESC
254	0.0005	0.00054407119750977	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1462
255	0.0006	0.00059700012207031	SELECT * FROM products WHERE parent_id = '1462'
256	0.0006	0.00059199333190918	SELECT * FROM products WHERE id = '846'
257	0.0008	0.00083303451538086	SELECT * FROM productimages WHERE product_id = '846' ORDER BY sortorder ASC
258	0.0010	0.00098991394042969	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '846' AND p.id = pi.product_id ORDER BY pi.sortorder
259	0.0011	0.0010671615600586	SELECT * FROM product_image_select WHERE product_id = '846'
260	0.0007	0.0006711483001709	SELECT * FROM productcustomimages WHERE product_id = '846'
261	0.0008	0.00077199935913086	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 = '846' GROUP BY o.product_id
262	0.0009	0.00093698501586914	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 = '846' GROUP BY n.displayname ORDER BY n.displayname DESC
263	0.0006	0.0005640983581543	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 846
264	0.0013	0.0012698173522949	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '846' AND a.name = n.originalname
265	0.0005	0.00050497055053711	SELECT * FROM productoffers WHERE product_id = '846' AND merchantid = 'A1X6FK5RDHNB96'
266	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '846' AND price > 0 ORDER BY price ASC LIMIT 1
267	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = 846 ORDER BY price ASC LIMIT 1
268	0.0005	0.00051212310791016	SELECT value FROM productattributes WHERE product_id = '846' AND name = 'ListPriceAmount'
269	0.0006	0.0005800724029541	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 = '846' GROUP BY o.product_id
270	0.0009	0.00094103813171387	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 = '846' GROUP BY n.displayname ORDER BY n.displayname DESC
271	0.0005	0.00053310394287109	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 846
272	0.0007	0.000701904296875	SELECT value FROM productattributes WHERE product_id = '846' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273	0.0009	0.00092887878417969	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '846' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
274	0.0005	0.00054788589477539	SELECT * FROM products WHERE id = '1669'
275	0.0006	0.00058698654174805	SELECT * FROM productimages WHERE product_id = '1669' ORDER BY sortorder ASC
276	0.0009	0.00088214874267578	SELECT * FROM product_image_select WHERE product_id = '1669'
277	0.0005	0.00054407119750977	SELECT * FROM productcustomimages WHERE product_id = '1669'
278	0.0015	0.0015020370483398	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1669' AND a.name = n.originalname
279	0.0007	0.00069403648376465	SELECT * FROM productoffers WHERE product_id = '1669' AND merchantid = 'A1X6FK5RDHNB96'
280	0.0005	0.00048923492431641	SELECT * FROM productoffers WHERE product_id = '1669' AND price > 0 ORDER BY price ASC LIMIT 1
281	0.0006	0.00057196617126465	SELECT * FROM productoffers WHERE product_id = 1669 ORDER BY price ASC LIMIT 1
282	0.0005	0.00049495697021484	SELECT value FROM productattributes WHERE product_id = '1669' AND name = 'ListPriceAmount'
283	0.0006	0.00058722496032715	SELECT value FROM productattributes WHERE product_id = '1669' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284	0.0008	0.00075292587280273	SELECT * FROM products WHERE id = '1629'
285	0.0007	0.00073885917663574	SELECT * FROM productimages WHERE product_id = '1629' ORDER BY sortorder ASC
286	0.0009	0.00090312957763672	SELECT * FROM product_image_select WHERE product_id = '1629'
287	0.0005	0.00054001808166504	SELECT * FROM productcustomimages WHERE product_id = '1629'
288	0.0018	0.0018379688262939	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1629' AND a.name = n.originalname
289	0.0006	0.00058698654174805	SELECT * FROM productoffers WHERE product_id = '1629' AND merchantid = 'A1X6FK5RDHNB96'
290	0.0005	0.00045895576477051	SELECT * FROM productoffers WHERE product_id = '1629' AND price > 0 ORDER BY price ASC LIMIT 1
291	0.0010	0.0010099411010742	SELECT * FROM productoffers WHERE product_id = 1629 ORDER BY price ASC LIMIT 1
292	0.0010	0.0010159015655518	SELECT value FROM productattributes WHERE product_id = '1629' AND name = 'ListPriceAmount'
293	0.0008	0.00081491470336914	SELECT value FROM productattributes WHERE product_id = '1629' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294	0.0017	0.0016751289367676	SELECT * FROM products WHERE id = '1562'
295	0.0028	0.0028181076049805	SELECT * FROM productimages WHERE product_id = '1562' ORDER BY sortorder ASC
296	0.0029	0.0028800964355469	SELECT * FROM product_image_select WHERE product_id = '1562'
297	0.0021	0.0020971298217773	SELECT * FROM productcustomimages WHERE product_id = '1562'
298	0.0036	0.0035638809204102	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1562' AND a.name = n.originalname
299	0.0012	0.0011720657348633	SELECT * FROM productoffers WHERE product_id = '1562' AND merchantid = 'A1X6FK5RDHNB96'
300	0.0010	0.0010302066802979	SELECT * FROM productoffers WHERE product_id = '1562' AND price > 0 ORDER BY price ASC LIMIT 1
301	0.0011	0.0011460781097412	SELECT * FROM productoffers WHERE product_id = 1562 ORDER BY price ASC LIMIT 1
302	0.0010	0.00097894668579102	SELECT value FROM productattributes WHERE product_id = '1562' AND name = 'ListPriceAmount'
303	0.0016	0.0016028881072998	SELECT value FROM productattributes WHERE product_id = '1562' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304	0.0050	0.0049810409545898	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1044' ORDER BY timestamp DESC
305	0.0007	0.00070285797119141	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1267' ORDER BY timestamp DESC
306	0.0005	0.00054502487182617	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1574' ORDER BY timestamp DESC
307	0.0006	0.0006098747253418	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1291' ORDER BY timestamp DESC
308	0.0007	0.00066184997558594	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1601' ORDER BY timestamp DESC
309	0.0007	0.00069403648376465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '857' ORDER BY timestamp DESC
310	0.0006	0.00056099891662598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '790' ORDER BY timestamp DESC
311	0.0008	0.00078701972961426	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2941' ORDER BY timestamp DESC
312	0.0006	0.00063705444335938	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2942' ORDER BY timestamp DESC
313	0.0006	0.00064206123352051	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4935' ORDER BY timestamp DESC
314	0.0006	0.00057601928710938	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '776' ORDER BY timestamp DESC
315	0.0005	0.000518798828125	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2358' ORDER BY timestamp DESC
316	0.0006	0.00055718421936035	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '858' ORDER BY timestamp DESC
317	0.0005	0.00049805641174316	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1462' ORDER BY timestamp DESC
318	0.0005	0.00054192543029785	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '846' ORDER BY timestamp DESC
319	0.0005	0.0005028247833252	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1669' ORDER BY timestamp DESC
320	0.0006	0.00057792663574219	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1629' ORDER BY timestamp DESC
321	0.0005	0.00047898292541504	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1562' ORDER BY timestamp DESC
322	0.0038	0.003760814666748	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
323	0.0028	0.0028140544891357	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
324	0.0006	0.00062084197998047	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
325	0.0232	0.023248910903931	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
326	0.0020	0.0019769668579102	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
327	0.0006	0.00061988830566406	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
328	0.0006	0.00060892105102539	SELECT * FROM products WHERE id = 1626
329	0.0005	0.00048708915710449	SELECT * FROM products WHERE id = 4041
330	0.0005	0.00053000450134277	SELECT * FROM products WHERE id = 4312
331	0.0005	0.00051617622375488	SELECT * FROM products WHERE id = 777
332	0.0005	0.00052404403686523	SELECT * FROM products WHERE id = 3881
333	0.0005	0.00054097175598145	SELECT * FROM products WHERE id = 4213
334	0.0006	0.00057101249694824	SELECT * FROM products WHERE id = '1626'
335	0.0007	0.00065517425537109	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
336	0.0008	0.00077605247497559	SELECT * FROM product_image_select WHERE product_id = '1626'
337	0.0005	0.00053095817565918	SELECT * FROM productcustomimages WHERE product_id = '1626'
338	0.0011	0.0010559558868408	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
339	0.0005	0.00054788589477539	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
340	0.0005	0.00051283836364746	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
341	0.0005	0.00054597854614258	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342	0.0006	0.00062799453735352	SELECT * FROM products WHERE id = '4041'
343	0.0007	0.00071120262145996	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
344	0.0006	0.00063419342041016	SELECT * FROM product_image_select WHERE product_id = '4041'
345	0.0006	0.00059700012207031	SELECT * FROM productcustomimages WHERE product_id = '4041'
346	0.0012	0.001237154006958	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
347	0.0005	0.00054001808166504	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
348	0.0006	0.00061488151550293	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
349	0.0006	0.00055599212646484	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350	0.0006	0.00060319900512695	SELECT * FROM products WHERE id = '4312'
351	0.0005	0.0005340576171875	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
352	0.0007	0.00066018104553223	SELECT * FROM product_image_select WHERE product_id = '4312'
353	0.0005	0.00047898292541504	SELECT * FROM productcustomimages WHERE product_id = '4312'
354	0.0010	0.0010390281677246	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
355	0.0005	0.00054502487182617	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
356	0.0007	0.00068306922912598	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
357	0.0005	0.00051617622375488	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358	0.0006	0.00059795379638672	SELECT * FROM products WHERE id = '777'
359	0.0005	0.00047397613525391	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
360	0.0008	0.00075888633728027	SELECT * FROM product_image_select WHERE product_id = '777'
361	0.0005	0.00046181678771973	SELECT * FROM productcustomimages WHERE product_id = '777'
362	0.0010	0.001011848449707	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
363	0.0005	0.00051212310791016	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
364	0.0005	0.00045609474182129	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
365	0.0005	0.0004570484161377	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
366	0.0010	0.0010249614715576	SELECT * FROM products WHERE id = '3881'
367	0.0007	0.00065803527832031	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
368	0.0007	0.00067591667175293	SELECT * FROM product_image_select WHERE product_id = '3881'
369	0.0005	0.00045299530029297	SELECT * FROM productcustomimages WHERE product_id = '3881'
370	0.0013	0.0012550354003906	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
371	0.0006	0.00059700012207031	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
372	0.0005	0.00049495697021484	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
373	0.0005	0.00050997734069824	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
374	0.0007	0.0006558895111084	SELECT * FROM products WHERE id = '4213'
375	0.0006	0.00059199333190918	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
376	0.0007	0.00068306922912598	SELECT * FROM product_image_select WHERE product_id = '4213'
377	0.0005	0.00050497055053711	SELECT * FROM productcustomimages WHERE product_id = '4213'
378	0.0016	0.0016219615936279	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
379	0.0006	0.00057411193847656	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
380	0.0015	0.0014691352844238	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
381	0.0010	0.00098609924316406	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
382	0.0051	0.0051329135894775	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
383	0.0017	0.0017399787902832	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
384	0.0055	0.0054819583892822	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
385	0.0036	0.003572940826416	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
386	0.0011	0.0010530948638916	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
387	0.0009	0.0009009838104248	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
388	0.0012	0.0012490749359131	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "2"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 3.0078001022339 seconds

Query Debug - 388 Database Queries. Total time 1.0794 seconds