Search Results for "2"

Rusticity Boîte à thé en bois/organiseur...

View to See Price

View

Add to Cart

Japonais Boîte à Thé En Bois Fait Avec D...

View to See Price

View

Add to Cart

CARMANI - Motif inspiré de la cru roses,...

View to See Price

View

Add to Cart

Grande Boîte à Thé Japonaise en Rouge

View to See Price

View

Add to Cart

Blanc NEUF en bois 6 compartiments Sache...

View to See Price

View

Add to Cart

Vente sur boîte à thé en bois Cyber Lund...

View to See Price

View

Add to Cart

Boîte Chouette famille 250 g de thé Boît...

View to See Price

View

Add to Cart

Karla – Motif Géométrique Boîte à thé en...

View to See Price

View

Add to Cart

Boîtes à thé/café/sucre en porcelaine or...

only €36,99

View

Add to Cart

Assheuer & Pott ASS11776 Boîte à thé...

View to See Price

View

Add to Cart

NATIVES 211495 Confiseur Boîte à thé de ...

View to See Price

View

Add to Cart

Lot de boîtes en acier inoxydable - thé/...

View to See Price

View

Add to Cart

Excellent Houseware k911032 Boîte à thé ...

View to See Price

View

Add to Cart

Contento 866386 Tasse et Théière Boîte à...

only €22,84

View

Add to Cart

Boîte à Thé en Bois Non Peint - 2 Compar...

View to See Price

View

Add to Cart

Contento 866377 Tea Much Cheaper Than Th...

View to See Price

View

Add to Cart

PURE tea selection rooibos &caramel ...

View to See Price

View

Add to Cart

Assheuer & Pott ASS11574 Boîte à thé...

only €40,19

View

Add to Cart

379 to 396 of 532 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
3.2139818668365	373	0.9413	0

No Amazon API Requests Made.

App Debug - Total Time 3.2139818668365 seconds

Number	Time From Start	Name	Description
1	1.7446420192719	Initialise	Initialise FSB Function
2	1.7509329319	App Controller Start	Start of the App controller (called before the controller of every page)
3	1.7909209728241	Start of getCategoryListByGroup Function	Before first category groups query
4	1.7925188541412	After initial query	Before first category groups query
5	1.7925209999084	Get Category List for Group	Before the call to getCategoryList function
6	1.7925248146057	Start of GetCategoryList function	Start of the function
7	1.7925288677216	Before getting categories	Query to get specific category list
8	1.7940928936005	After getting categories	Query to get specific category list
9	1.7940948009491	Before getting category custom	Before call to function getCategoryCustom
10	1.8154909610748	After getting category custom	After call to function getCategoryCustom
11	1.8154938220978	Before getting category custom	Before call to function getCategoryCustom
12	1.8267838954926	After getting category custom	After call to function getCategoryCustom
13	1.8267858028412	Before getting category custom	Before call to function getCategoryCustom
14	1.8330569267273	After getting category custom	After call to function getCategoryCustom
15	1.8330588340759	Before getting category custom	Before call to function getCategoryCustom
16	1.8423910140991	After getting category custom	After call to function getCategoryCustom
17	1.8423929214478	Before getting category custom	Before call to function getCategoryCustom
18	1.8498718738556	After getting category custom	After call to function getCategoryCustom
19	1.8498740196228	Before getting category custom	Before call to function getCategoryCustom
20	1.8572659492493	After getting category custom	After call to function getCategoryCustom
21	1.8572678565979	End of GetCategoryList function	End of the function
22	1.8572738170624	Get Category List for Group	Before the call to getCategoryList function
23	1.8572769165039	Start of GetCategoryList function	Start of the function
24	1.8572800159454	Before getting categories	Query to get specific category list
25	1.8579158782959	End of getCategoryListByGroup Function	Before return()
26	2.3779318332672	App Controller End	End of the App controller (called before the controller of every page)
27	2.6034498214722	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	2.6056499481201	Before Get Options	Before the call to getOptions in the tpl class
29	2.6710228919983	After Get Options	After the call to getOptions in the tpl class
30	2.6710557937622	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	3.2139678001404	Finalizing debug	Before the debug is output to the page.
32	3.2139799594879	End of App	This is the end of the app logging, final timestamp

Query Debug - 373 Database Queries. Total time 0.9413 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.141.201.114\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738854291'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-06 15:04:51' WHERE id = '8'
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.141.201.114') >= INET_ATON(ip_start) AND INET_ATON('3.141.201.114') <= 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.141.201.114'
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 = '1547'
SELECT * FROM productimages WHERE product_id = '1547' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1547'
SELECT * FROM productcustomimages WHERE product_id = '1547'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1547' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1547' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1547' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1547
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1547'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1547' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1549'
SELECT * FROM productimages WHERE product_id = '1549' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1549'
SELECT * FROM productcustomimages WHERE product_id = '1549'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1549' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1549' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1549' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1549
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1549'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1549' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1552'
SELECT * FROM productimages WHERE product_id = '1552' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1552'
SELECT * FROM productcustomimages WHERE product_id = '1552'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1552' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1552' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1552' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1552
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1552'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1552' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1558'
SELECT * FROM productimages WHERE product_id = '1558' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1558'
SELECT * FROM productcustomimages WHERE product_id = '1558'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1558' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1558' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1558' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1558
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1558'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1558' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1559'
SELECT * FROM productimages WHERE product_id = '1559' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1559'
SELECT * FROM productcustomimages WHERE product_id = '1559'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1559' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1559' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1559' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1559
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1559'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1559' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1587'
SELECT * FROM productimages WHERE product_id = '1587' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1587'
SELECT * FROM productcustomimages WHERE product_id = '1587'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1587' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1587' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1587' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1587
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1587'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1872'
SELECT * FROM productimages WHERE product_id = '1872' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1872'
SELECT * FROM productcustomimages WHERE product_id = '1872'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1872' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1872' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1872' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1872
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1872'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1872' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1614'
SELECT * FROM productimages WHERE product_id = '1614' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1614'
SELECT * FROM productcustomimages WHERE product_id = '1614'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1614' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1614' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1614' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1614
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1614'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1616'
SELECT * FROM productimages WHERE product_id = '1616' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1616'
SELECT * FROM productcustomimages WHERE product_id = '1616'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1616' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1616' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1616' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1616' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1619'
SELECT * FROM productimages WHERE product_id = '1619' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1619' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1619'
SELECT * FROM productcustomimages WHERE product_id = '1619'
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 = '1619'
                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     = '1619'
                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 = 1619
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1619' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1619' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1619' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1619
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1619'
                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 = '1619'
                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     = '1619'
                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 = 1619
SELECT value FROM productattributes WHERE product_id = '1619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '1619'
SELECT * FROM products WHERE id = '1631'
SELECT * FROM productimages WHERE product_id = '1631' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1631'
SELECT * FROM productcustomimages WHERE product_id = '1631'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1631' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1631' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1631' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1631
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1631'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1631' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1634'
SELECT * FROM productimages WHERE product_id = '1634' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1634'
SELECT * FROM productcustomimages WHERE product_id = '1634'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1634' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1634' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1634' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1634
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1634'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1634' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1652'
SELECT * FROM productimages WHERE product_id = '1652' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1652'
SELECT * FROM productcustomimages WHERE product_id = '1652'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1652' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1652' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1652' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1652
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1652'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1652' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1661'
SELECT * FROM productimages WHERE product_id = '1661' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1661'
SELECT * FROM productcustomimages WHERE product_id = '1661'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1661' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1661' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1661' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1661' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1663'
SELECT * FROM productimages WHERE product_id = '1663' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1663'
SELECT * FROM productcustomimages WHERE product_id = '1663'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1663' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1663' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1663' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1663
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1663'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1667'
SELECT * FROM productimages WHERE product_id = '1667' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1667'
SELECT * FROM productcustomimages WHERE product_id = '1667'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1667' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1667
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1667'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1667' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1668'
SELECT * FROM productimages WHERE product_id = '1668' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1668'
SELECT * FROM productcustomimages WHERE product_id = '1668'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1668' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1668' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1668' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1668
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1668'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1668' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1673'
SELECT * FROM productimages WHERE product_id = '1673' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1673'
SELECT * FROM productcustomimages WHERE product_id = '1673'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1673' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1673' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1673' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1547' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1549' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1552' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1558' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1559' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1587' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1872' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1614' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1616' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1619' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1631' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1634' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1652' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1661' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1663' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1667' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1668' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1673' ORDER BY timestamp DESC
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0011	0.0011210441589355	SELECT parameter, value FROM parameters
2	0.0075	0.0075459480285645	SELECT * FROM `bad_bots`
3	0.0006	0.0006098747253418	SET time_zone = 'Europe/London'
4	0.0037	0.0037260055541992	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0051	0.0050580501556396	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.141.201.114\";}'
6	0.0040	0.0039520263671875	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738854291'
7	0.0034	0.0034091472625732	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00078511238098145	UPDATE autorun SET lastrun = '2025-02-06 15:04:51' WHERE id = '8'
9	0.0010	0.0010168552398682	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0037	0.00370192527771	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0007	0.00066590309143066	SELECT * FROM pages WHERE id = 52
12	0.0056	0.005579948425293	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0333	0.033299922943115	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0006	0.00061798095703125	SELECT * FROM pages WHERE pagename = 'search'
15	0.0016	0.0015850067138672	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0015	0.0015430450439453	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0075	0.0074551105499268	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.0017	0.0017108917236328	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.0011	0.0011389255523682	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0004	0.0004270076751709	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.0015	0.0015490055084229	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.0015	0.0015430450439453	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.0013	0.0012919902801514	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0004	0.00041580200195312	SELECT * FROM categorygroups WHERE id = '1'
26	0.0038	0.0038328170776367	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.0005	0.00053501129150391	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0004	0.00040197372436523	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0005	0.00045990943908691	SELECT id FROM categories WHERE parent_id = '27'
30	0.0038	0.0037901401519775	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.00055193901062012	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.0005	0.00054597854614258	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.00060701370239258	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0005	0.00047802925109863	SELECT * FROM categorygroups WHERE id = '1'
35	0.0014	0.0014078617095947	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.00047111511230469	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.0004	0.00042915344238281	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0004	0.00042605400085449	SELECT id FROM categories WHERE parent_id = '28'
39	0.0015	0.00152587890625	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.0005	0.00048685073852539	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.0005	0.00050187110900879	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.00046610832214355	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0005	0.00047588348388672	SELECT * FROM categorygroups WHERE id = '1'
44	0.0006	0.00055599212646484	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.0004	0.00043702125549316	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.0010	0.0010039806365967	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0009	0.00086188316345215	SELECT id FROM categories WHERE parent_id = '29'
48	0.0021	0.0021190643310547	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.0013	0.001349925994873	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.0012	0.0011711120605469	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.0009	0.00092291831970215	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0008	0.000823974609375	SELECT * FROM categorygroups WHERE id = '1'
53	0.0012	0.0012350082397461	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.0010	0.00095105171203613	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.00064396858215332	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0007	0.00073599815368652	SELECT id FROM categories WHERE parent_id = '30'
57	0.0013	0.0013270378112793	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.0006248950958252	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.0007	0.00073599815368652	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.0006	0.00060606002807617	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0005	0.00053286552429199	SELECT * FROM categorygroups WHERE id = '1'
62	0.0010	0.00095295906066895	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.00066304206848145	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.0005	0.00051712989807129	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0006	0.00061583518981934	SELECT id FROM categories WHERE parent_id = '31'
66	0.0012	0.0011630058288574	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.0010	0.0010201930999756	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.0009	0.00087213516235352	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.00072002410888672	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0008	0.00077509880065918	SELECT * FROM categorygroups WHERE id = '1'
71	0.0006	0.0006248950958252	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0043	0.0042769908905029	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0019	0.0018548965454102	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0008	0.00075912475585938	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.0017	0.0017099380493164	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0015	0.0015299320220947	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0012	0.0011849403381348	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.5031	0.50314497947693	SELECT * FROM ipgeocountries WHERE INET_ATON('3.141.201.114') >= INET_ATON(ip_start) AND INET_ATON('3.141.201.114') <= INET_ATON(ip_end)
79	0.0022	0.0021860599517822	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0012	0.0011539459228516	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0006	0.00064277648925781	SELECT * FROM pages WHERE pagename = 'search'
82	0.0067	0.0066649913787842	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0016	0.0016279220581055	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0028	0.0028371810913086	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0062	0.0061748027801514	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0041	0.0040900707244873	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0010	0.001011848449707	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0025	0.002514123916626	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '3.141.201.114'
89	0.0015	0.001533031463623	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.0009	0.0008540153503418	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.0070	0.0069708824157715	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.0007	0.00069999694824219	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.00059700012207031	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.0010	0.001007080078125	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.0105	0.0104820728302	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.0005	0.00045299530029297	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.0006	0.00055193901062012	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.00064706802368164	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.0006	0.00057697296142578	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.0114	0.011429071426392	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.00059199333190918	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.0006	0.00064396858215332	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.0010	0.0009768009185791	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.0097	0.009713888168335	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.00052499771118164	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.00041007995605469	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.0005	0.00051999092102051	SELECT * FROM products WHERE id = '1547'
108	0.0022	0.0022199153900146	SELECT * FROM productimages WHERE product_id = '1547' ORDER BY sortorder ASC
109	0.0018	0.0018310546875	SELECT * FROM product_image_select WHERE product_id = '1547'
110	0.0018	0.0017790794372559	SELECT * FROM productcustomimages WHERE product_id = '1547'
111	0.0023	0.0022618770599365	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1547' AND a.name = n.originalname
112	0.0039	0.003864049911499	SELECT * FROM productoffers WHERE product_id = '1547' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0008	0.00080394744873047	SELECT * FROM productoffers WHERE product_id = '1547' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0008	0.00079202651977539	SELECT * FROM productoffers WHERE product_id = 1547 ORDER BY price ASC LIMIT 1
115	0.0014	0.0014369487762451	SELECT value FROM productattributes WHERE product_id = '1547' AND name = 'ListPriceAmount'
116	0.0010	0.00098395347595215	SELECT value FROM productattributes WHERE product_id = '1547' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0010	0.001039981842041	SELECT * FROM products WHERE id = '1549'
118	0.0010	0.0010011196136475	SELECT * FROM productimages WHERE product_id = '1549' ORDER BY sortorder ASC
119	0.0014	0.0014209747314453	SELECT * FROM product_image_select WHERE product_id = '1549'
120	0.0007	0.00072503089904785	SELECT * FROM productcustomimages WHERE product_id = '1549'
121	0.0020	0.0020229816436768	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1549' AND a.name = n.originalname
122	0.0009	0.00091385841369629	SELECT * FROM productoffers WHERE product_id = '1549' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0005	0.00050997734069824	SELECT * FROM productoffers WHERE product_id = '1549' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0006	0.00055193901062012	SELECT * FROM productoffers WHERE product_id = 1549 ORDER BY price ASC LIMIT 1
125	0.0007	0.00071001052856445	SELECT value FROM productattributes WHERE product_id = '1549' AND name = 'ListPriceAmount'
126	0.0008	0.00084805488586426	SELECT value FROM productattributes WHERE product_id = '1549' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127	0.0009	0.00086784362792969	SELECT * FROM products WHERE id = '1552'
128	0.0007	0.00066208839416504	SELECT * FROM productimages WHERE product_id = '1552' ORDER BY sortorder ASC
129	0.0008	0.00077581405639648	SELECT * FROM product_image_select WHERE product_id = '1552'
130	0.0005	0.00049495697021484	SELECT * FROM productcustomimages WHERE product_id = '1552'
131	0.0012	0.0012080669403076	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1552' AND a.name = n.originalname
132	0.0007	0.00067806243896484	SELECT * FROM productoffers WHERE product_id = '1552' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0005	0.00054287910461426	SELECT * FROM productoffers WHERE product_id = '1552' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0005	0.00045084953308105	SELECT * FROM productoffers WHERE product_id = 1552 ORDER BY price ASC LIMIT 1
135	0.0005	0.00048279762268066	SELECT value FROM productattributes WHERE product_id = '1552' AND name = 'ListPriceAmount'
136	0.0007	0.00068402290344238	SELECT value FROM productattributes WHERE product_id = '1552' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137	0.0008	0.00076389312744141	SELECT * FROM products WHERE id = '1558'
138	0.0007	0.0006871223449707	SELECT * FROM productimages WHERE product_id = '1558' ORDER BY sortorder ASC
139	0.0009	0.00088906288146973	SELECT * FROM product_image_select WHERE product_id = '1558'
140	0.0005	0.00046014785766602	SELECT * FROM productcustomimages WHERE product_id = '1558'
141	0.0014	0.0014410018920898	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1558' AND a.name = n.originalname
142	0.0005	0.0005340576171875	SELECT * FROM productoffers WHERE product_id = '1558' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0004	0.00036001205444336	SELECT * FROM productoffers WHERE product_id = '1558' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0005	0.00045490264892578	SELECT * FROM productoffers WHERE product_id = 1558 ORDER BY price ASC LIMIT 1
145	0.0004	0.00044703483581543	SELECT value FROM productattributes WHERE product_id = '1558' AND name = 'ListPriceAmount'
146	0.0004	0.00043797492980957	SELECT value FROM productattributes WHERE product_id = '1558' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0006	0.00055599212646484	SELECT * FROM products WHERE id = '1559'
148	0.0005	0.00053906440734863	SELECT * FROM productimages WHERE product_id = '1559' ORDER BY sortorder ASC
149	0.0006	0.00058794021606445	SELECT * FROM product_image_select WHERE product_id = '1559'
150	0.0004	0.00039196014404297	SELECT * FROM productcustomimages WHERE product_id = '1559'
151	0.0010	0.00097203254699707	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1559' AND a.name = n.originalname
152	0.0005	0.00054287910461426	SELECT * FROM productoffers WHERE product_id = '1559' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0004	0.00039291381835938	SELECT * FROM productoffers WHERE product_id = '1559' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0006	0.00056695938110352	SELECT * FROM productoffers WHERE product_id = 1559 ORDER BY price ASC LIMIT 1
155	0.0004	0.00039196014404297	SELECT value FROM productattributes WHERE product_id = '1559' AND name = 'ListPriceAmount'
156	0.0005	0.00046300888061523	SELECT value FROM productattributes WHERE product_id = '1559' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157	0.0006	0.00056600570678711	SELECT * FROM products WHERE id = '1587'
158	0.0008	0.00076103210449219	SELECT * FROM productimages WHERE product_id = '1587' ORDER BY sortorder ASC
159	0.0008	0.00076913833618164	SELECT * FROM product_image_select WHERE product_id = '1587'
160	0.0004	0.00037908554077148	SELECT * FROM productcustomimages WHERE product_id = '1587'
161	0.0013	0.001291036605835	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1587' AND a.name = n.originalname
162	0.0004	0.00043797492980957	SELECT * FROM productoffers WHERE product_id = '1587' AND merchantid = 'A1X6FK5RDHNB96'
163	0.0004	0.00036883354187012	SELECT * FROM productoffers WHERE product_id = '1587' AND price > 0 ORDER BY price ASC LIMIT 1
164	0.0006	0.00056099891662598	SELECT * FROM productoffers WHERE product_id = 1587 ORDER BY price ASC LIMIT 1
165	0.0005	0.00048685073852539	SELECT value FROM productattributes WHERE product_id = '1587' AND name = 'ListPriceAmount'
166	0.0006	0.00063300132751465	SELECT value FROM productattributes WHERE product_id = '1587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167	0.0006	0.00061607360839844	SELECT * FROM products WHERE id = '1872'
168	0.0006	0.00056004524230957	SELECT * FROM productimages WHERE product_id = '1872' ORDER BY sortorder ASC
169	0.0006	0.00056695938110352	SELECT * FROM product_image_select WHERE product_id = '1872'
170	0.0005	0.00048494338989258	SELECT * FROM productcustomimages WHERE product_id = '1872'
171	0.0009	0.00085592269897461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1872' AND a.name = n.originalname
172	0.0005	0.00051712989807129	SELECT * FROM productoffers WHERE product_id = '1872' AND merchantid = 'A1X6FK5RDHNB96'
173	0.0005	0.00046205520629883	SELECT * FROM productoffers WHERE product_id = '1872' AND price > 0 ORDER BY price ASC LIMIT 1
174	0.0004	0.00043416023254395	SELECT * FROM productoffers WHERE product_id = 1872 ORDER BY price ASC LIMIT 1
175	0.0005	0.00050687789916992	SELECT value FROM productattributes WHERE product_id = '1872' AND name = 'ListPriceAmount'
176	0.0005	0.00046801567077637	SELECT value FROM productattributes WHERE product_id = '1872' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177	0.0006	0.00055503845214844	SELECT * FROM products WHERE id = '1614'
178	0.0006	0.00062680244445801	SELECT * FROM productimages WHERE product_id = '1614' ORDER BY sortorder ASC
179	0.0006	0.00064611434936523	SELECT * FROM product_image_select WHERE product_id = '1614'
180	0.0005	0.00045394897460938	SELECT * FROM productcustomimages WHERE product_id = '1614'
181	0.0012	0.0011780261993408	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1614' AND a.name = n.originalname
182	0.0005	0.00052809715270996	SELECT * FROM productoffers WHERE product_id = '1614' AND merchantid = 'A1X6FK5RDHNB96'
183	0.0004	0.00039100646972656	SELECT * FROM productoffers WHERE product_id = '1614' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0004	0.00036787986755371	SELECT * FROM productoffers WHERE product_id = 1614 ORDER BY price ASC LIMIT 1
185	0.0005	0.00046610832214355	SELECT value FROM productattributes WHERE product_id = '1614' AND name = 'ListPriceAmount'
186	0.0005	0.00051999092102051	SELECT value FROM productattributes WHERE product_id = '1614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187	0.0006	0.00064301490783691	SELECT * FROM products WHERE id = '1616'
188	0.0008	0.0007779598236084	SELECT * FROM productimages WHERE product_id = '1616' ORDER BY sortorder ASC
189	0.0007	0.00069093704223633	SELECT * FROM product_image_select WHERE product_id = '1616'
190	0.0005	0.00049901008605957	SELECT * FROM productcustomimages WHERE product_id = '1616'
191	0.0012	0.0011959075927734	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1616' AND a.name = n.originalname
192	0.0006	0.00062704086303711	SELECT * FROM productoffers WHERE product_id = '1616' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '1616' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0005	0.00054788589477539	SELECT value FROM productattributes WHERE product_id = '1616' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195	0.0005	0.00054192543029785	SELECT * FROM products WHERE id = '1619'
196	0.0005	0.00050997734069824	SELECT * FROM productimages WHERE product_id = '1619' ORDER BY sortorder ASC
197	0.0005	0.00051712989807129	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1619' AND p.id = pi.product_id ORDER BY pi.sortorder
198	0.0007	0.00073099136352539	SELECT * FROM product_image_select WHERE product_id = '1619'
199	0.0004	0.0003960132598877	SELECT * FROM productcustomimages WHERE product_id = '1619'
200	0.0005	0.00050616264343262	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 = '1619' GROUP BY o.product_id
201	0.0025	0.0025250911712646	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 = '1619' GROUP BY n.displayname ORDER BY n.displayname DESC
202	0.0005	0.00047898292541504	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1619
203	0.0013	0.0012791156768799	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1619' AND a.name = n.originalname
204	0.0004	0.00041508674621582	SELECT * FROM productoffers WHERE product_id = '1619' AND merchantid = 'A1X6FK5RDHNB96'
205	0.0004	0.00036907196044922	SELECT * FROM productoffers WHERE product_id = '1619' AND price > 0 ORDER BY price ASC LIMIT 1
206	0.0004	0.00035905838012695	SELECT * FROM productoffers WHERE product_id = 1619 ORDER BY price ASC LIMIT 1
207	0.0004	0.00036191940307617	SELECT value FROM productattributes WHERE product_id = '1619' AND name = 'ListPriceAmount'
208	0.0004	0.00039815902709961	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 = '1619' GROUP BY o.product_id
209	0.0006	0.00058698654174805	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 = '1619' GROUP BY n.displayname ORDER BY n.displayname DESC
210	0.0004	0.00043797492980957	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1619
211	0.0006	0.00058889389038086	SELECT value FROM productattributes WHERE product_id = '1619' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212	0.0005	0.00051593780517578	SELECT * FROM products WHERE parent_id = '1619'
213	0.0007	0.00071883201599121	SELECT * FROM products WHERE id = '1631'
214	0.0006	0.00061678886413574	SELECT * FROM productimages WHERE product_id = '1631' ORDER BY sortorder ASC
215	0.0007	0.0006561279296875	SELECT * FROM product_image_select WHERE product_id = '1631'
216	0.0004	0.00040698051452637	SELECT * FROM productcustomimages WHERE product_id = '1631'
217	0.0010	0.0010368824005127	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1631' AND a.name = n.originalname
218	0.0005	0.00054693222045898	SELECT * FROM productoffers WHERE product_id = '1631' AND merchantid = 'A1X6FK5RDHNB96'
219	0.0004	0.00041985511779785	SELECT * FROM productoffers WHERE product_id = '1631' AND price > 0 ORDER BY price ASC LIMIT 1
220	0.0003	0.00032711029052734	SELECT * FROM productoffers WHERE product_id = 1631 ORDER BY price ASC LIMIT 1
221	0.0004	0.00042915344238281	SELECT value FROM productattributes WHERE product_id = '1631' AND name = 'ListPriceAmount'
222	0.0004	0.00042605400085449	SELECT value FROM productattributes WHERE product_id = '1631' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223	0.0006	0.00060200691223145	SELECT * FROM products WHERE id = '1634'
224	0.0008	0.00082015991210938	SELECT * FROM productimages WHERE product_id = '1634' ORDER BY sortorder ASC
225	0.0007	0.00072908401489258	SELECT * FROM product_image_select WHERE product_id = '1634'
226	0.0005	0.00047087669372559	SELECT * FROM productcustomimages WHERE product_id = '1634'
227	0.0021	0.002147912979126	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1634' AND a.name = n.originalname
228	0.0006	0.00061488151550293	SELECT * FROM productoffers WHERE product_id = '1634' AND merchantid = 'A1X6FK5RDHNB96'
229	0.0006	0.00058603286743164	SELECT * FROM productoffers WHERE product_id = '1634' AND price > 0 ORDER BY price ASC LIMIT 1
230	0.0004	0.00040888786315918	SELECT * FROM productoffers WHERE product_id = 1634 ORDER BY price ASC LIMIT 1
231	0.0005	0.00046205520629883	SELECT value FROM productattributes WHERE product_id = '1634' AND name = 'ListPriceAmount'
232	0.0005	0.00048398971557617	SELECT value FROM productattributes WHERE product_id = '1634' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
233	0.0007	0.00072312355041504	SELECT * FROM products WHERE id = '1652'
234	0.0008	0.00080394744873047	SELECT * FROM productimages WHERE product_id = '1652' ORDER BY sortorder ASC
235	0.0008	0.00078606605529785	SELECT * FROM product_image_select WHERE product_id = '1652'
236	0.0006	0.0005791187286377	SELECT * FROM productcustomimages WHERE product_id = '1652'
237	0.0012	0.0011589527130127	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1652' AND a.name = n.originalname
238	0.0007	0.00071597099304199	SELECT * FROM productoffers WHERE product_id = '1652' AND merchantid = 'A1X6FK5RDHNB96'
239	0.0004	0.00043702125549316	SELECT * FROM productoffers WHERE product_id = '1652' AND price > 0 ORDER BY price ASC LIMIT 1
240	0.0004	0.00039196014404297	SELECT * FROM productoffers WHERE product_id = 1652 ORDER BY price ASC LIMIT 1
241	0.0004	0.00042104721069336	SELECT value FROM productattributes WHERE product_id = '1652' AND name = 'ListPriceAmount'
242	0.0005	0.00050997734069824	SELECT value FROM productattributes WHERE product_id = '1652' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
243	0.0007	0.00066614151000977	SELECT * FROM products WHERE id = '1661'
244	0.0005	0.00046300888061523	SELECT * FROM productimages WHERE product_id = '1661' ORDER BY sortorder ASC
245	0.0006	0.00055789947509766	SELECT * FROM product_image_select WHERE product_id = '1661'
246	0.0004	0.00044393539428711	SELECT * FROM productcustomimages WHERE product_id = '1661'
247	0.0009	0.00092601776123047	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1661' AND a.name = n.originalname
248	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '1661' AND merchantid = 'A1X6FK5RDHNB96'
249	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = '1661' AND price > 0 ORDER BY price ASC LIMIT 1
250	0.0005	0.00052905082702637	SELECT value FROM productattributes WHERE product_id = '1661' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
251	0.0007	0.00065207481384277	SELECT * FROM products WHERE id = '1663'
252	0.0006	0.00063300132751465	SELECT * FROM productimages WHERE product_id = '1663' ORDER BY sortorder ASC
253	0.0008	0.00075006484985352	SELECT * FROM product_image_select WHERE product_id = '1663'
254	0.0004	0.00044989585876465	SELECT * FROM productcustomimages WHERE product_id = '1663'
255	0.0011	0.0010709762573242	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1663' AND a.name = n.originalname
256	0.0005	0.00052881240844727	SELECT * FROM productoffers WHERE product_id = '1663' AND merchantid = 'A1X6FK5RDHNB96'
257	0.0004	0.00044608116149902	SELECT * FROM productoffers WHERE product_id = '1663' AND price > 0 ORDER BY price ASC LIMIT 1
258	0.0004	0.0004420280456543	SELECT * FROM productoffers WHERE product_id = 1663 ORDER BY price ASC LIMIT 1
259	0.0004	0.0004270076751709	SELECT value FROM productattributes WHERE product_id = '1663' AND name = 'ListPriceAmount'
260	0.0005	0.00046205520629883	SELECT value FROM productattributes WHERE product_id = '1663' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261	0.0006	0.00061893463134766	SELECT * FROM products WHERE id = '1667'
262	0.0006	0.00062298774719238	SELECT * FROM productimages WHERE product_id = '1667' ORDER BY sortorder ASC
263	0.0006	0.00064802169799805	SELECT * FROM product_image_select WHERE product_id = '1667'
264	0.0004	0.00041604042053223	SELECT * FROM productcustomimages WHERE product_id = '1667'
265	0.0015	0.0015199184417725	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1667' AND a.name = n.originalname
266	0.0005	0.00053596496582031	SELECT * FROM productoffers WHERE product_id = '1667' AND merchantid = 'A1X6FK5RDHNB96'
267	0.0004	0.00042319297790527	SELECT * FROM productoffers WHERE product_id = '1667' AND price > 0 ORDER BY price ASC LIMIT 1
268	0.0004	0.00041699409484863	SELECT * FROM productoffers WHERE product_id = 1667 ORDER BY price ASC LIMIT 1
269	0.0005	0.00046586990356445	SELECT value FROM productattributes WHERE product_id = '1667' AND name = 'ListPriceAmount'
270	0.0005	0.0004878044128418	SELECT value FROM productattributes WHERE product_id = '1667' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
271	0.0006	0.00062179565429688	SELECT * FROM products WHERE id = '1668'
272	0.0006	0.00058388710021973	SELECT * FROM productimages WHERE product_id = '1668' ORDER BY sortorder ASC
273	0.0008	0.00077104568481445	SELECT * FROM product_image_select WHERE product_id = '1668'
274	0.0004	0.00043010711669922	SELECT * FROM productcustomimages WHERE product_id = '1668'
275	0.0010	0.0010199546813965	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1668' AND a.name = n.originalname
276	0.0005	0.00052905082702637	SELECT * FROM productoffers WHERE product_id = '1668' AND merchantid = 'A1X6FK5RDHNB96'
277	0.0004	0.00043201446533203	SELECT * FROM productoffers WHERE product_id = '1668' AND price > 0 ORDER BY price ASC LIMIT 1
278	0.0004	0.0004270076751709	SELECT * FROM productoffers WHERE product_id = 1668 ORDER BY price ASC LIMIT 1
279	0.0005	0.00046586990356445	SELECT value FROM productattributes WHERE product_id = '1668' AND name = 'ListPriceAmount'
280	0.0005	0.00047707557678223	SELECT value FROM productattributes WHERE product_id = '1668' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
281	0.0006	0.00060200691223145	SELECT * FROM products WHERE id = '1673'
282	0.0005	0.00051093101501465	SELECT * FROM productimages WHERE product_id = '1673' ORDER BY sortorder ASC
283	0.0007	0.0006868839263916	SELECT * FROM product_image_select WHERE product_id = '1673'
284	0.0004	0.00040793418884277	SELECT * FROM productcustomimages WHERE product_id = '1673'
285	0.0011	0.0010612010955811	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1673' AND a.name = n.originalname
286	0.0005	0.00053906440734863	SELECT * FROM productoffers WHERE product_id = '1673' AND merchantid = 'A1X6FK5RDHNB96'
287	0.0005	0.00048112869262695	SELECT * FROM productoffers WHERE product_id = '1673' AND price > 0 ORDER BY price ASC LIMIT 1
288	0.0005	0.00049400329589844	SELECT value FROM productattributes WHERE product_id = '1673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
289	0.0020	0.0019690990447998	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1547' ORDER BY timestamp DESC
290	0.0004	0.00037407875061035	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1549' ORDER BY timestamp DESC
291	0.0004	0.00036406517028809	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1552' ORDER BY timestamp DESC
292	0.0003	0.00032591819763184	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1558' ORDER BY timestamp DESC
293	0.0003	0.00034403800964355	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1559' ORDER BY timestamp DESC
294	0.0003	0.00034117698669434	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1587' ORDER BY timestamp DESC
295	0.0004	0.0003669261932373	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1872' ORDER BY timestamp DESC
296	0.0003	0.00034904479980469	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1614' ORDER BY timestamp DESC
297	0.0003	0.00034499168395996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1616' ORDER BY timestamp DESC
298	0.0004	0.0003969669342041	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1619' ORDER BY timestamp DESC
299	0.0071	0.0070939064025879	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1631' ORDER BY timestamp DESC
300	0.0008	0.00076103210449219	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1634' ORDER BY timestamp DESC
301	0.0006	0.00056314468383789	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1652' ORDER BY timestamp DESC
302	0.0007	0.00067496299743652	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1661' ORDER BY timestamp DESC
303	0.0004	0.00038313865661621	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1663' ORDER BY timestamp DESC
304	0.0004	0.00044488906860352	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1667' ORDER BY timestamp DESC
305	0.0004	0.00037217140197754	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1668' ORDER BY timestamp DESC
306	0.0006	0.00059199333190918	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1673' ORDER BY timestamp DESC
307	0.0021	0.0020718574523926	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
308	0.0017	0.0017390251159668	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
309	0.0004	0.00038695335388184	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
310	0.0163	0.016311168670654	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
311	0.0022	0.0021729469299316	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
312	0.0006	0.00058889389038086	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
313	0.0007	0.00065779685974121	SELECT * FROM products WHERE id = 1626
314	0.0006	0.00064516067504883	SELECT * FROM products WHERE id = 4041
315	0.0006	0.00055098533630371	SELECT * FROM products WHERE id = 4312
316	0.0006	0.00061607360839844	SELECT * FROM products WHERE id = 777
317	0.0004	0.0004279613494873	SELECT * FROM products WHERE id = 3881
318	0.0004	0.00040912628173828	SELECT * FROM products WHERE id = 4213
319	0.0006	0.00058293342590332	SELECT * FROM products WHERE id = '1626'
320	0.0005	0.00048494338989258	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
321	0.0006	0.00055885314941406	SELECT * FROM product_image_select WHERE product_id = '1626'
322	0.0004	0.00044894218444824	SELECT * FROM productcustomimages WHERE product_id = '1626'
323	0.0010	0.00097990036010742	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
324	0.0005	0.00053501129150391	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
325	0.0004	0.00044894218444824	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
326	0.0006	0.00057291984558105	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
327	0.0006	0.00057506561279297	SELECT * FROM products WHERE id = '4041'
328	0.0006	0.00057101249694824	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
329	0.0007	0.00072002410888672	SELECT * FROM product_image_select WHERE product_id = '4041'
330	0.0005	0.00046396255493164	SELECT * FROM productcustomimages WHERE product_id = '4041'
331	0.0014	0.0014150142669678	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
332	0.0006	0.00059986114501953	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
333	0.0005	0.00050997734069824	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
334	0.0005	0.0004730224609375	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
335	0.0006	0.00058889389038086	SELECT * FROM products WHERE id = '4312'
336	0.0006	0.0005800724029541	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
337	0.0006	0.00058603286743164	SELECT * FROM product_image_select WHERE product_id = '4312'
338	0.0004	0.00041985511779785	SELECT * FROM productcustomimages WHERE product_id = '4312'
339	0.0010	0.0010240077972412	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
340	0.0005	0.00051283836364746	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
341	0.0006	0.00064301490783691	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
342	0.0005	0.00054287910461426	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
343	0.0008	0.00084710121154785	SELECT * FROM products WHERE id = '777'
344	0.0005	0.00048494338989258	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
345	0.0006	0.00056695938110352	SELECT * FROM product_image_select WHERE product_id = '777'
346	0.0005	0.00047898292541504	SELECT * FROM productcustomimages WHERE product_id = '777'
347	0.0011	0.0010569095611572	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
348	0.0005	0.00047206878662109	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
349	0.0004	0.00042009353637695	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
350	0.0004	0.0003969669342041	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
351	0.0006	0.00056195259094238	SELECT * FROM products WHERE id = '3881'
352	0.0007	0.0007469654083252	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
353	0.0010	0.0010180473327637	SELECT * FROM product_image_select WHERE product_id = '3881'
354	0.0005	0.00046801567077637	SELECT * FROM productcustomimages WHERE product_id = '3881'
355	0.0014	0.0014297962188721	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
356	0.0007	0.00074410438537598	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
357	0.0006	0.00062417984008789	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
358	0.0006	0.00059795379638672	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
359	0.0007	0.00071287155151367	SELECT * FROM products WHERE id = '4213'
360	0.0009	0.00086617469787598	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
361	0.0011	0.0011329650878906	SELECT * FROM product_image_select WHERE product_id = '4213'
362	0.0005	0.00046396255493164	SELECT * FROM productcustomimages WHERE product_id = '4213'
363	0.0014	0.0013778209686279	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
364	0.0005	0.00054812431335449	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
365	0.0004	0.0003969669342041	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
366	0.0005	0.00051403045654297	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
367	0.0021	0.0021300315856934	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
368	0.0009	0.00094699859619141	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
369	0.0032	0.0032379627227783	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
370	0.0019	0.0018727779388428	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
371	0.0008	0.00075697898864746	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
372	0.0012	0.0011749267578125	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
373	0.0013	0.0012638568878174	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.2139818668365 seconds

Query Debug - 373 Database Queries. Total time 0.9413 seconds