Search Results for "2"

Grande boîte à thé en bois clair 12 comp...

only €23,99

View

Add to Cart

NICKS Chocodrink, chocolat chaud instant...

only €9,99

View

Add to Cart

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

only €19,99

View

Add to Cart

Senseo Café Corsé 200 dosettes (Lot de 5...

€48,49 €41,50

View

Add to Cart

Marque Amazon Solimo Café moulu Aroma co...

only €15,77

View

Add to Cart

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

only €27,98

View

Add to Cart

Thé vert Menthe poivrée BIO 200g

only €14,97

View

Add to Cart

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

only €19,50

View

Add to Cart

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

€15,05 €13,45

View

Add to Cart

Derrière La Porte DLP : Boîte de Rangeme...

View to See Price

View

Add to Cart

Relaxdays Boîte à thé en bambou 6 ou 8 c...

from €18,87

View

Add to Cart

Ethiquable Rooibos Afrique du Sud Bio et...

View to See Price

View

Add to Cart

Poudre de thé vert matcha biologique 250...

only €19,90

View

Add to Cart

Boîte à thé élégante avec 6 compartiment...

only €22,90

View

Add to Cart

Marque Amazon Solimo Café moulu compatib...

€23,58 €14,69

View

Add to Cart

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

only €22,90

View

Add to Cart

Quertee® - Thé vert – Thé au jasmin de C...

only €12,90

View

Add to Cart

Thé Rouge Rooibos Nature Afrique Bio 200...

€8,99 €7,90

View

Add to Cart

19 to 36 of 532 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
2.4254140853882	348	0.7978	0

No Amazon API Requests Made.

App Debug - Total Time 2.4254140853882 seconds

Number	Time From Start	Name	Description
1	1.6018481254578	Initialise	Initialise FSB Function
2	1.6055481433868	App Controller Start	Start of the App controller (called before the controller of every page)
3	1.6349029541016	Start of getCategoryListByGroup Function	Before first category groups query
4	1.6366410255432	After initial query	Before first category groups query
5	1.6366431713104	Get Category List for Group	Before the call to getCategoryList function
6	1.6366469860077	Start of GetCategoryList function	Start of the function
7	1.6366500854492	Before getting categories	Query to get specific category list
8	1.6390891075134	After getting categories	Query to get specific category list
9	1.6390910148621	Before getting category custom	Before call to function getCategoryCustom
10	1.6606891155243	After getting category custom	After call to function getCategoryCustom
11	1.6606931686401	Before getting category custom	Before call to function getCategoryCustom
12	1.6719930171967	After getting category custom	After call to function getCategoryCustom
13	1.6719951629639	Before getting category custom	Before call to function getCategoryCustom
14	1.6791210174561	After getting category custom	After call to function getCategoryCustom
15	1.6791231632233	Before getting category custom	Before call to function getCategoryCustom
16	1.6839289665222	After getting category custom	After call to function getCategoryCustom
17	1.6839311122894	Before getting category custom	Before call to function getCategoryCustom
18	1.6887211799622	After getting category custom	After call to function getCategoryCustom
19	1.6887230873108	Before getting category custom	Before call to function getCategoryCustom
20	1.6940240859985	After getting category custom	After call to function getCategoryCustom
21	1.6940271854401	End of GetCategoryList function	End of the function
22	1.6940331459045	Get Category List for Group	Before the call to getCategoryList function
23	1.6940350532532	Start of GetCategoryList function	Start of the function
24	1.6940381526947	Before getting categories	Query to get specific category list
25	1.6946930885315	End of getCategoryListByGroup Function	Before return()
26	2.1502721309662	App Controller End	End of the App controller (called before the controller of every page)
27	2.3323290348053	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	2.3340871334076	Before Get Options	Before the call to getOptions in the tpl class
29	2.398041009903	After Get Options	After the call to getOptions in the tpl class
30	2.3980770111084	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	2.4254021644592	Finalizing debug	Before the debug is output to the page.
32	2.4254131317139	End of App	This is the end of the app logging, final timestamp

Query Debug - 348 Database Queries. Total time 0.7978 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:\"18.216.110.63\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738781998'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.216.110.63') >= INET_ATON(ip_start) AND INET_ATON('18.216.110.63') <= 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(), '18.216.110.63'
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 = '2009'
SELECT * FROM productimages WHERE product_id = '2009' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2009'
SELECT * FROM productcustomimages WHERE product_id = '2009'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2009' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2009' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2009' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2009' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4941'
SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4941'
SELECT * FROM productcustomimages WHERE product_id = '4941'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4941' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3809'
SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3809'
SELECT * FROM productcustomimages WHERE product_id = '3809'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3809' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3809' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4937'
SELECT * FROM productimages WHERE product_id = '4937' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4937'
SELECT * FROM productcustomimages WHERE product_id = '4937'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4937' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4937' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4937' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4934'
SELECT * FROM productimages WHERE product_id = '4934' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4934'
SELECT * FROM productcustomimages WHERE product_id = '4934'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4934' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4934' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4934' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4952'
SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4952'
SELECT * FROM productcustomimages WHERE product_id = '4952'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4952' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '970'
SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '970'
SELECT * FROM productcustomimages WHERE product_id = '970'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '970' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '970' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4924'
SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4924'
SELECT * FROM productcustomimages WHERE product_id = '4924'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4924' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2698'
SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2698'
SELECT * FROM productcustomimages WHERE product_id = '2698'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2698' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2698' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1273'
SELECT * FROM productimages WHERE product_id = '1273' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1273'
SELECT * FROM productcustomimages WHERE product_id = '1273'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1273' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1273' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1273' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1273
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1273'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1273' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '822'
SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '822'
SELECT * FROM productcustomimages WHERE product_id = '822'
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 = '822'
                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     = '822'
                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 = 822
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '822' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 822
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '822'
                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 = '822'
                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     = '822'
                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 = 822
SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '822'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1036'
SELECT * FROM productimages WHERE product_id = '1036' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1036'
SELECT * FROM productcustomimages WHERE product_id = '1036'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1036' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1036' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1036' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1036
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1036'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1262'
SELECT * FROM productimages WHERE product_id = '1262' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1262'
SELECT * FROM productcustomimages WHERE product_id = '1262'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1262' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1262' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1262' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1262' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '836'
SELECT * FROM productimages WHERE product_id = '836' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '836'
SELECT * FROM productcustomimages WHERE product_id = '836'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '836' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '836' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '836' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4932'
SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4932'
SELECT * FROM productcustomimages WHERE product_id = '4932'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4932' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1979'
SELECT * FROM productimages WHERE product_id = '1979' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1979'
SELECT * FROM productcustomimages WHERE product_id = '1979'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1979' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1979' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1979' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1979' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4909'
SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4909'
SELECT * FROM productcustomimages WHERE product_id = '4909'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4909' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4909' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1100'
SELECT * FROM productimages WHERE product_id = '1100' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1100'
SELECT * FROM productcustomimages WHERE product_id = '1100'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1100' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1100' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1100' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2009' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4937' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4934' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '970' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4924' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2698' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1273' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '822' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1036' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1262' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '836' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1979' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4909' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1100' 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.0020	0.0019979476928711	SELECT parameter, value FROM parameters
2	0.0034	0.0033900737762451	SELECT * FROM `bad_bots`
3	0.0004	0.00036787986755371	SET time_zone = 'Europe/London'
4	0.0007	0.00069499015808105	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0018	0.0018069744110107	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"18.216.110.63\";}'
6	0.0015	0.0015151500701904	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738781998'
7	0.0025	0.0025110244750977	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0007	0.00065398216247559	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0019	0.0019369125366211	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0005	0.00045990943908691	SELECT * FROM pages WHERE id = 52
11	0.0027	0.0027079582214355	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0253	0.025256872177124	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0008	0.00084400177001953	SELECT * FROM pages WHERE pagename = 'search'
14	0.0017	0.001723051071167	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0024	0.0024158954620361	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0068	0.0067770481109619	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17	0.0012	0.0012409687042236	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0015	0.0014939308166504	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.0005180835723877	SELECT id FROM categories WHERE parent_id = '26'
20	0.0070	0.0069680213928223	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
21	0.0018	0.0017809867858887	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0006	0.0006260871887207	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
23	0.0015	0.0015239715576172	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00054407119750977	SELECT * FROM categorygroups WHERE id = '1'
25	0.0039	0.0038621425628662	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26	0.0006	0.00057196617126465	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.00043702125549316	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0004	0.00043296813964844	SELECT id FROM categories WHERE parent_id = '27'
29	0.0039	0.0038540363311768	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
30	0.0006	0.00059199333190918	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0005	0.00052189826965332	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0005	0.00050497055053711	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0004	0.00042986869812012	SELECT * FROM categorygroups WHERE id = '1'
34	0.0015	0.0014979839324951	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35	0.0007	0.00066804885864258	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0005	0.00046205520629883	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00049781799316406	SELECT id FROM categories WHERE parent_id = '28'
38	0.0017	0.0016798973083496	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
39	0.0006	0.0005640983581543	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
40	0.0006	0.0006108283996582	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0005	0.00050997734069824	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.0005488395690918	SELECT * FROM categorygroups WHERE id = '1'
43	0.0007	0.00070905685424805	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44	0.0005	0.00049400329589844	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0004	0.0004270076751709	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0004	0.00041604042053223	SELECT id FROM categories WHERE parent_id = '29'
47	0.0007	0.00071597099304199	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0005	0.00053095817565918	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0005	0.00051617622375488	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
50	0.0005	0.00048995018005371	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0004	0.00042009353637695	SELECT * FROM categorygroups WHERE id = '1'
52	0.0006	0.00057101249694824	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53	0.0005	0.00048708915710449	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0004	0.00039815902709961	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0004	0.00040698051452637	SELECT id FROM categories WHERE parent_id = '30'
56	0.0007	0.0007328987121582	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
57	0.0006	0.00056791305541992	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0005	0.0005340576171875	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
59	0.0005	0.00048613548278809	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00052213668823242	SELECT * FROM categorygroups WHERE id = '1'
61	0.0006	0.00058984756469727	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0005	0.00046801567077637	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0004	0.00039410591125488	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0004	0.00039005279541016	SELECT id FROM categories WHERE parent_id = '31'
65	0.0008	0.00075006484985352	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0005	0.00046992301940918	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0006	0.00058388710021973	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0010	0.0010278224945068	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0005	0.00053811073303223	SELECT * FROM categorygroups WHERE id = '1'
70	0.0006	0.00064492225646973	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0030	0.0029609203338623	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0017	0.0017240047454834	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0006	0.00063490867614746	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74	0.0013	0.0013020038604736	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0017	0.0016651153564453	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0011	0.0011470317840576	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4401	0.44007086753845	SELECT * FROM ipgeocountries WHERE INET_ATON('18.216.110.63') >= INET_ATON(ip_start) AND INET_ATON('18.216.110.63') <= INET_ATON(ip_end)
78	0.0027	0.0027120113372803	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0013	0.0012860298156738	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0006	0.00063514709472656	SELECT * FROM pages WHERE pagename = 'search'
81	0.0057	0.0056891441345215	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0017	0.0017030239105225	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0019	0.0019080638885498	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0055	0.0055480003356934	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0018	0.0017518997192383	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0006	0.00055599212646484	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0017	0.0017070770263672	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '18.216.110.63'
88	0.0008	0.00080299377441406	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
89	0.0006	0.00055408477783203	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0041	0.0041129589080811	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
91	0.0006	0.00058698654174805	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
92	0.0006	0.00060200691223145	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
93	0.0007	0.0006859302520752	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
94	0.0052	0.0051779747009277	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
95	0.0006	0.0005500316619873	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
96	0.0004	0.00036096572875977	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
97	0.0006	0.00055408477783203	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0005	0.00051093101501465	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0040	0.0039927959442139	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0003	0.00034594535827637	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
101	0.0003	0.00028705596923828	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
102	0.0005	0.00053596496582031	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
103	0.0070	0.0069739818572998	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0005	0.00052094459533691	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
105	0.0004	0.00039100646972656	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
106	0.0005	0.00052094459533691	SELECT * FROM products WHERE id = '2009'
107	0.0022	0.0021998882293701	SELECT * FROM productimages WHERE product_id = '2009' ORDER BY sortorder ASC
108	0.0018	0.0017850399017334	SELECT * FROM product_image_select WHERE product_id = '2009'
109	0.0014	0.0013861656188965	SELECT * FROM productcustomimages WHERE product_id = '2009'
110	0.0021	0.0021259784698486	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2009' AND a.name = n.originalname
111	0.0016	0.0016191005706787	SELECT * FROM productoffers WHERE product_id = '2009' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0006	0.00056815147399902	SELECT * FROM productoffers WHERE product_id = '2009' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0006	0.00064992904663086	SELECT value FROM productattributes WHERE product_id = '2009' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114	0.0007	0.00065898895263672	SELECT * FROM products WHERE id = '4941'
115	0.0006	0.00059008598327637	SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
116	0.0006	0.00064396858215332	SELECT * FROM product_image_select WHERE product_id = '4941'
117	0.0004	0.00043201446533203	SELECT * FROM productcustomimages WHERE product_id = '4941'
118	0.0016	0.0016419887542725	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
119	0.0006	0.0005950927734375	SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
120	0.0005	0.00051403045654297	SELECT * FROM productoffers WHERE product_id = '4941' AND price > 0 ORDER BY price ASC LIMIT 1
121	0.0005	0.00049185752868652	SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122	0.0008	0.00076198577880859	SELECT * FROM products WHERE id = '3809'
123	0.0006	0.00056600570678711	SELECT * FROM productimages WHERE product_id = '3809' ORDER BY sortorder ASC
124	0.0007	0.00068902969360352	SELECT * FROM product_image_select WHERE product_id = '3809'
125	0.0010	0.00098514556884766	SELECT * FROM productcustomimages WHERE product_id = '3809'
126	0.0012	0.0012321472167969	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3809' AND a.name = n.originalname
127	0.0007	0.00066399574279785	SELECT * FROM productoffers WHERE product_id = '3809' AND merchantid = 'A1X6FK5RDHNB96'
128	0.0008	0.00075888633728027	SELECT * FROM productoffers WHERE product_id = '3809' AND price > 0 ORDER BY price ASC LIMIT 1
129	0.0007	0.00073099136352539	SELECT value FROM productattributes WHERE product_id = '3809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130	0.0009	0.00088191032409668	SELECT * FROM products WHERE id = '4937'
131	0.0010	0.0010180473327637	SELECT * FROM productimages WHERE product_id = '4937' ORDER BY sortorder ASC
132	0.0008	0.00075411796569824	SELECT * FROM product_image_select WHERE product_id = '4937'
133	0.0006	0.00058197975158691	SELECT * FROM productcustomimages WHERE product_id = '4937'
134	0.0016	0.0016238689422607	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4937' AND a.name = n.originalname
135	0.0006	0.00058794021606445	SELECT * FROM productoffers WHERE product_id = '4937' AND merchantid = 'A1X6FK5RDHNB96'
136	0.0008	0.0007929801940918	SELECT * FROM productoffers WHERE product_id = '4937' AND price > 0 ORDER BY price ASC LIMIT 1
137	0.0016	0.0015718936920166	SELECT value FROM productattributes WHERE product_id = '4937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138	0.0020	0.0019629001617432	SELECT * FROM products WHERE id = '4934'
139	0.0013	0.0013020038604736	SELECT * FROM productimages WHERE product_id = '4934' ORDER BY sortorder ASC
140	0.0015	0.0015130043029785	SELECT * FROM product_image_select WHERE product_id = '4934'
141	0.0009	0.00087094306945801	SELECT * FROM productcustomimages WHERE product_id = '4934'
142	0.0037	0.0036969184875488	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4934' AND a.name = n.originalname
143	0.0011	0.0010919570922852	SELECT * FROM productoffers WHERE product_id = '4934' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0009	0.00090694427490234	SELECT * FROM productoffers WHERE product_id = '4934' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0009	0.00085210800170898	SELECT value FROM productattributes WHERE product_id = '4934' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146	0.0009	0.0008549690246582	SELECT * FROM products WHERE id = '4952'
147	0.0009	0.0009009838104248	SELECT * FROM productimages WHERE product_id = '4952' ORDER BY sortorder ASC
148	0.0010	0.00095415115356445	SELECT * FROM product_image_select WHERE product_id = '4952'
149	0.0006	0.0005650520324707	SELECT * FROM productcustomimages WHERE product_id = '4952'
150	0.0016	0.0015769004821777	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4952' AND a.name = n.originalname
151	0.0007	0.00070595741271973	SELECT * FROM productoffers WHERE product_id = '4952' AND merchantid = 'A1X6FK5RDHNB96'
152	0.0006	0.00055503845214844	SELECT * FROM productoffers WHERE product_id = '4952' AND price > 0 ORDER BY price ASC LIMIT 1
153	0.0007	0.00070691108703613	SELECT value FROM productattributes WHERE product_id = '4952' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154	0.0009	0.00090885162353516	SELECT * FROM products WHERE id = '970'
155	0.0010	0.00097203254699707	SELECT * FROM productimages WHERE product_id = '970' ORDER BY sortorder ASC
156	0.0010	0.00097489356994629	SELECT * FROM product_image_select WHERE product_id = '970'
157	0.0006	0.00058984756469727	SELECT * FROM productcustomimages WHERE product_id = '970'
158	0.0016	0.0016310214996338	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '970' AND a.name = n.originalname
159	0.0007	0.00068306922912598	SELECT * FROM productoffers WHERE product_id = '970' AND merchantid = 'A1X6FK5RDHNB96'
160	0.0006	0.00058102607727051	SELECT * FROM productoffers WHERE product_id = '970' AND price > 0 ORDER BY price ASC LIMIT 1
161	0.0006	0.00058913230895996	SELECT value FROM productattributes WHERE product_id = '970' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
162	0.0007	0.00074100494384766	SELECT * FROM products WHERE id = '4924'
163	0.0007	0.00067806243896484	SELECT * FROM productimages WHERE product_id = '4924' ORDER BY sortorder ASC
164	0.0011	0.0010781288146973	SELECT * FROM product_image_select WHERE product_id = '4924'
165	0.0006	0.0006260871887207	SELECT * FROM productcustomimages WHERE product_id = '4924'
166	0.0018	0.0017619132995605	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4924' AND a.name = n.originalname
167	0.0006	0.00064992904663086	SELECT * FROM productoffers WHERE product_id = '4924' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0005	0.00051498413085938	SELECT * FROM productoffers WHERE product_id = '4924' AND price > 0 ORDER BY price ASC LIMIT 1
169	0.0005	0.00053906440734863	SELECT value FROM productattributes WHERE product_id = '4924' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170	0.0007	0.00067400932312012	SELECT * FROM products WHERE id = '2698'
171	0.0008	0.00080299377441406	SELECT * FROM productimages WHERE product_id = '2698' ORDER BY sortorder ASC
172	0.0008	0.00075912475585938	SELECT * FROM product_image_select WHERE product_id = '2698'
173	0.0005	0.00051593780517578	SELECT * FROM productcustomimages WHERE product_id = '2698'
174	0.0015	0.0014908313751221	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2698' AND a.name = n.originalname
175	0.0006	0.00059795379638672	SELECT * FROM productoffers WHERE product_id = '2698' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '2698' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0005	0.00051403045654297	SELECT value FROM productattributes WHERE product_id = '2698' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
178	0.0007	0.00071310997009277	SELECT * FROM products WHERE id = '1273'
179	0.0006	0.00060391426086426	SELECT * FROM productimages WHERE product_id = '1273' ORDER BY sortorder ASC
180	0.0008	0.00082802772521973	SELECT * FROM product_image_select WHERE product_id = '1273'
181	0.0005	0.00046205520629883	SELECT * FROM productcustomimages WHERE product_id = '1273'
182	0.0013	0.0013260841369629	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1273' AND a.name = n.originalname
183	0.0005	0.00050616264343262	SELECT * FROM productoffers WHERE product_id = '1273' AND merchantid = 'A1X6FK5RDHNB96'
184	0.0004	0.00039505958557129	SELECT * FROM productoffers WHERE product_id = '1273' AND price > 0 ORDER BY price ASC LIMIT 1
185	0.0004	0.0004420280456543	SELECT * FROM productoffers WHERE product_id = 1273 ORDER BY price ASC LIMIT 1
186	0.0005	0.00045394897460938	SELECT value FROM productattributes WHERE product_id = '1273' AND name = 'ListPriceAmount'
187	0.0005	0.00046300888061523	SELECT value FROM productattributes WHERE product_id = '1273' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188	0.0007	0.00065517425537109	SELECT * FROM products WHERE id = '822'
189	0.0008	0.00083088874816895	SELECT * FROM productimages WHERE product_id = '822' ORDER BY sortorder ASC
190	0.0006	0.00060796737670898	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '822' AND p.id = pi.product_id ORDER BY pi.sortorder
191	0.0008	0.00076198577880859	SELECT * FROM product_image_select WHERE product_id = '822'
192	0.0004	0.00044703483581543	SELECT * FROM productcustomimages WHERE product_id = '822'
193	0.0006	0.00064396858215332	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 = '822' GROUP BY o.product_id
194	0.0033	0.0032801628112793	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 = '822' GROUP BY n.displayname ORDER BY n.displayname DESC
195	0.0005	0.00054502487182617	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
196	0.0010	0.00095891952514648	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '822' AND a.name = n.originalname
197	0.0004	0.00036501884460449	SELECT * FROM productoffers WHERE product_id = '822' AND merchantid = 'A1X6FK5RDHNB96'
198	0.0004	0.00036501884460449	SELECT * FROM productoffers WHERE product_id = '822' AND price > 0 ORDER BY price ASC LIMIT 1
199	0.0004	0.00035715103149414	SELECT * FROM productoffers WHERE product_id = 822 ORDER BY price ASC LIMIT 1
200	0.0004	0.0003809928894043	SELECT value FROM productattributes WHERE product_id = '822' AND name = 'ListPriceAmount'
201	0.0004	0.0004429817199707	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 = '822' GROUP BY o.product_id
202	0.0007	0.00068092346191406	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 = '822' GROUP BY n.displayname ORDER BY n.displayname DESC
203	0.0004	0.00039291381835938	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 822
204	0.0006	0.00056099891662598	SELECT value FROM productattributes WHERE product_id = '822' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205	0.0006	0.00064206123352051	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '822' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
206	0.0005	0.00049185752868652	SELECT * FROM products WHERE id = '1036'
207	0.0005	0.00051283836364746	SELECT * FROM productimages WHERE product_id = '1036' ORDER BY sortorder ASC
208	0.0006	0.00064992904663086	SELECT * FROM product_image_select WHERE product_id = '1036'
209	0.0005	0.00045418739318848	SELECT * FROM productcustomimages WHERE product_id = '1036'
210	0.0011	0.0011200904846191	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1036' AND a.name = n.originalname
211	0.0005	0.00048708915710449	SELECT * FROM productoffers WHERE product_id = '1036' AND merchantid = 'A1X6FK5RDHNB96'
212	0.0004	0.00035905838012695	SELECT * FROM productoffers WHERE product_id = '1036' AND price > 0 ORDER BY price ASC LIMIT 1
213	0.0004	0.00037789344787598	SELECT * FROM productoffers WHERE product_id = 1036 ORDER BY price ASC LIMIT 1
214	0.0004	0.00036907196044922	SELECT value FROM productattributes WHERE product_id = '1036' AND name = 'ListPriceAmount'
215	0.0004	0.00039100646972656	SELECT value FROM productattributes WHERE product_id = '1036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216	0.0006	0.0005800724029541	SELECT * FROM products WHERE id = '1262'
217	0.0005	0.00051212310791016	SELECT * FROM productimages WHERE product_id = '1262' ORDER BY sortorder ASC
218	0.0006	0.00058794021606445	SELECT * FROM product_image_select WHERE product_id = '1262'
219	0.0004	0.00043892860412598	SELECT * FROM productcustomimages WHERE product_id = '1262'
220	0.0010	0.00097298622131348	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1262' AND a.name = n.originalname
221	0.0005	0.00048422813415527	SELECT * FROM productoffers WHERE product_id = '1262' AND merchantid = 'A1X6FK5RDHNB96'
222	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '1262' AND price > 0 ORDER BY price ASC LIMIT 1
223	0.0005	0.00049185752868652	SELECT value FROM productattributes WHERE product_id = '1262' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224	0.0005	0.00054812431335449	SELECT * FROM products WHERE id = '836'
225	0.0006	0.00055193901062012	SELECT * FROM productimages WHERE product_id = '836' ORDER BY sortorder ASC
226	0.0006	0.00063800811767578	SELECT * FROM product_image_select WHERE product_id = '836'
227	0.0005	0.00048589706420898	SELECT * FROM productcustomimages WHERE product_id = '836'
228	0.0008	0.0008080005645752	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '836' AND a.name = n.originalname
229	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '836' AND merchantid = 'A1X6FK5RDHNB96'
230	0.0004	0.00042414665222168	SELECT * FROM productoffers WHERE product_id = '836' AND price > 0 ORDER BY price ASC LIMIT 1
231	0.0004	0.00040698051452637	SELECT value FROM productattributes WHERE product_id = '836' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232	0.0006	0.00059890747070312	SELECT * FROM products WHERE id = '4932'
233	0.0004	0.00044393539428711	SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
234	0.0006	0.00057315826416016	SELECT * FROM product_image_select WHERE product_id = '4932'
235	0.0004	0.00035691261291504	SELECT * FROM productcustomimages WHERE product_id = '4932'
236	0.0010	0.0010471343994141	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
237	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
238	0.0004	0.00038695335388184	SELECT * FROM productoffers WHERE product_id = '4932' AND price > 0 ORDER BY price ASC LIMIT 1
239	0.0004	0.0003972053527832	SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240	0.0006	0.00058221817016602	SELECT * FROM products WHERE id = '1979'
241	0.0005	0.00046300888061523	SELECT * FROM productimages WHERE product_id = '1979' ORDER BY sortorder ASC
242	0.0006	0.00055885314941406	SELECT * FROM product_image_select WHERE product_id = '1979'
243	0.0004	0.00040888786315918	SELECT * FROM productcustomimages WHERE product_id = '1979'
244	0.0009	0.00093412399291992	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1979' AND a.name = n.originalname
245	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '1979' AND merchantid = 'A1X6FK5RDHNB96'
246	0.0004	0.0003969669342041	SELECT * FROM productoffers WHERE product_id = '1979' AND price > 0 ORDER BY price ASC LIMIT 1
247	0.0004	0.00040102005004883	SELECT value FROM productattributes WHERE product_id = '1979' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
248	0.0005	0.00054287910461426	SELECT * FROM products WHERE id = '4909'
249	0.0006	0.00062394142150879	SELECT * FROM productimages WHERE product_id = '4909' ORDER BY sortorder ASC
250	0.0006	0.00056910514831543	SELECT * FROM product_image_select WHERE product_id = '4909'
251	0.0004	0.00038003921508789	SELECT * FROM productcustomimages WHERE product_id = '4909'
252	0.0011	0.0011260509490967	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4909' AND a.name = n.originalname
253	0.0005	0.00045299530029297	SELECT * FROM productoffers WHERE product_id = '4909' AND merchantid = 'A1X6FK5RDHNB96'
254	0.0004	0.00042605400085449	SELECT * FROM productoffers WHERE product_id = '4909' AND price > 0 ORDER BY price ASC LIMIT 1
255	0.0004	0.00041294097900391	SELECT value FROM productattributes WHERE product_id = '4909' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256	0.0005	0.00053000450134277	SELECT * FROM products WHERE id = '1100'
257	0.0007	0.00073885917663574	SELECT * FROM productimages WHERE product_id = '1100' ORDER BY sortorder ASC
258	0.0007	0.00072598457336426	SELECT * FROM product_image_select WHERE product_id = '1100'
259	0.0004	0.00038981437683105	SELECT * FROM productcustomimages WHERE product_id = '1100'
260	0.0012	0.0011720657348633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1100' AND a.name = n.originalname
261	0.0005	0.00049304962158203	SELECT * FROM productoffers WHERE product_id = '1100' AND merchantid = 'A1X6FK5RDHNB96'
262	0.0004	0.00041103363037109	SELECT * FROM productoffers WHERE product_id = '1100' AND price > 0 ORDER BY price ASC LIMIT 1
263	0.0004	0.00041508674621582	SELECT value FROM productattributes WHERE product_id = '1100' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
264	0.0018	0.0017580986022949	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2009' ORDER BY timestamp DESC
265	0.0003	0.00033688545227051	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
266	0.0003	0.00031709671020508	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3809' ORDER BY timestamp DESC
267	0.0003	0.00028395652770996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4937' ORDER BY timestamp DESC
268	0.0003	0.00033712387084961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4934' ORDER BY timestamp DESC
269	0.0003	0.00028085708618164	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4952' ORDER BY timestamp DESC
270	0.0003	0.00027799606323242	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '970' ORDER BY timestamp DESC
271	0.0003	0.00032591819763184	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4924' ORDER BY timestamp DESC
272	0.0004	0.0003819465637207	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2698' ORDER BY timestamp DESC
273	0.0003	0.00027704238891602	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1273' ORDER BY timestamp DESC
274	0.0004	0.00040197372436523	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '822' ORDER BY timestamp DESC
275	0.0003	0.00032782554626465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1036' ORDER BY timestamp DESC
276	0.0003	0.00028395652770996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1262' ORDER BY timestamp DESC
277	0.0004	0.00035190582275391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '836' ORDER BY timestamp DESC
278	0.0003	0.00032901763916016	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
279	0.0003	0.00032997131347656	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1979' ORDER BY timestamp DESC
280	0.0003	0.00028586387634277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4909' ORDER BY timestamp DESC
281	0.0003	0.00028395652770996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1100' ORDER BY timestamp DESC
282	0.0016	0.001615047454834	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
283	0.0013	0.0013010501861572	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
284	0.0004	0.00040006637573242	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
285	0.0140	0.014020919799805	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
286	0.0017	0.0017340183258057	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
287	0.0006	0.0005650520324707	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
288	0.0005	0.00054001808166504	SELECT * FROM products WHERE id = 1626
289	0.0005	0.00048089027404785	SELECT * FROM products WHERE id = 4041
290	0.0005	0.00053000450134277	SELECT * FROM products WHERE id = 4312
291	0.0005	0.00047612190246582	SELECT * FROM products WHERE id = 777
292	0.0004	0.00044798851013184	SELECT * FROM products WHERE id = 3881
293	0.0009	0.00088119506835938	SELECT * FROM products WHERE id = 4213
294	0.0005	0.00047898292541504	SELECT * FROM products WHERE id = '1626'
295	0.0005	0.00052404403686523	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
296	0.0006	0.0006260871887207	SELECT * FROM product_image_select WHERE product_id = '1626'
297	0.0004	0.00039505958557129	SELECT * FROM productcustomimages WHERE product_id = '1626'
298	0.0008	0.00083804130554199	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
299	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
300	0.0005	0.00048303604125977	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
301	0.0005	0.00046801567077637	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302	0.0005	0.00052714347839355	SELECT * FROM products WHERE id = '4041'
303	0.0005	0.00053501129150391	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
304	0.0006	0.00057601928710938	SELECT * FROM product_image_select WHERE product_id = '4041'
305	0.0004	0.00038981437683105	SELECT * FROM productcustomimages WHERE product_id = '4041'
306	0.0011	0.0011320114135742	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
307	0.0005	0.00049805641174316	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
308	0.0006	0.0005640983581543	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
309	0.0004	0.00041890144348145	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
310	0.0006	0.00064396858215332	SELECT * FROM products WHERE id = '4312'
311	0.0005	0.00051999092102051	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
312	0.0006	0.00059390068054199	SELECT * FROM product_image_select WHERE product_id = '4312'
313	0.0004	0.00039386749267578	SELECT * FROM productcustomimages WHERE product_id = '4312'
314	0.0011	0.0011250972747803	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
315	0.0005	0.00051593780517578	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
316	0.0005	0.00051784515380859	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
317	0.0005	0.00054287910461426	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
318	0.0006	0.00061702728271484	SELECT * FROM products WHERE id = '777'
319	0.0005	0.00049614906311035	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
320	0.0006	0.00058388710021973	SELECT * FROM product_image_select WHERE product_id = '777'
321	0.0004	0.00039982795715332	SELECT * FROM productcustomimages WHERE product_id = '777'
322	0.0012	0.0012149810791016	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
323	0.0005	0.0005490779876709	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
324	0.0005	0.00046277046203613	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
325	0.0004	0.00041508674621582	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326	0.0006	0.0005800724029541	SELECT * FROM products WHERE id = '3881'
327	0.0005	0.0005347728729248	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
328	0.0006	0.00055885314941406	SELECT * FROM product_image_select WHERE product_id = '3881'
329	0.0004	0.0003809928894043	SELECT * FROM productcustomimages WHERE product_id = '3881'
330	0.0013	0.0012509822845459	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
331	0.0009	0.00089883804321289	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
332	0.0008	0.00083804130554199	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
333	0.0009	0.00093507766723633	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334	0.0007	0.00073003768920898	SELECT * FROM products WHERE id = '4213'
335	0.0035	0.0035030841827393	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
336	0.0007	0.00069284439086914	SELECT * FROM product_image_select WHERE product_id = '4213'
337	0.0004	0.0004429817199707	SELECT * FROM productcustomimages WHERE product_id = '4213'
338	0.0012	0.0011639595031738	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
339	0.0006	0.00058794021606445	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
340	0.0005	0.00045490264892578	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
341	0.0005	0.00052118301391602	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342	0.0022	0.0021839141845703	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
343	0.0007	0.00072288513183594	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
344	0.0037	0.0037190914154053	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
345	0.0021	0.0021078586578369	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
346	0.0007	0.00070595741271973	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
347	0.0009	0.00091409683227539	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
348	0.0007	0.00072097778320312	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 2.4254140853882 seconds

Query Debug - 348 Database Queries. Total time 0.7978 seconds