Search Results for "3"

La Fourmi 305 x 205 x 75 mm Boîte à thé ...

View to See Price

View

Add to Cart

Chocolat Chaud "Luxury" - 350g

only €25,20

View

Add to Cart

Yogi Tea - Bedtime Rooibos Vanilla - 30....

only €11,86

View

Add to Cart

SoBuy® FRG179-WN Boîte de rangement à ti...

only €32,95

View

Add to Cart

Tchibo 410137 Rooibos Bos Caramel de thé...

only €15,03

View

Add to Cart

Classique à thé en métal, coloré, boîtes...

View to See Price

View

Add to Cart

Tetley Boîte de 30 Sachets TIR PRESS sou...

only €7,96

View

Add to Cart

Jardin Bio Rooibos Rouge d'Afrique du Su...

only €3,15

View

Add to Cart

Infusettes de Rooibos Nature - boîte 30g...

only €5,76

View

Add to Cart

Thé vert DETOX BIO 200g - avec menthe, m...

€13,99 €10,99

View

Add to Cart

Marque Amazon - Happy Belly Café torréfi...

View to See Price

View

Add to Cart

Infusettes de Rooibos Honeybush - boîte ...

only €5,76

View

Add to Cart

Français style vintage thé en bois Porte...

View to See Price

View

Add to Cart

Mariage Frères - MARCO POLO ROUGE - Boît...

only €35,99

View

Add to Cart

Relaxdays Boîte à thé bambou sachets thé...

€29,99 €27,14

View

Add to Cart

SoBuy FRG280-Sch Boîte de Rangement à Ti...

only €32,95

View

Add to Cart

Betteros Boîte de Rangement en Bois pour...

only €32,28

View

Add to Cart

Xshelley rétro double Coque Home de cuis...

€19,99 €18,97

View

Add to Cart

19 to 36 of 360 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
2.0374081134796	372	1.0132	0

No Amazon API Requests Made.

App Debug - Total Time 2.0374081134796 seconds

Number	Time From Start	Name	Description
1	0.97084712982178	Initialise	Initialise FSB Function
2	0.97671413421631	App Controller Start	Start of the App controller (called before the controller of every page)
3	1.0131461620331	Start of getCategoryListByGroup Function	Before first category groups query
4	1.0157630443573	After initial query	Before first category groups query
5	1.0157670974731	Get Category List for Group	Before the call to getCategoryList function
6	1.0157730579376	Start of GetCategoryList function	Start of the function
7	1.0157790184021	Before getting categories	Query to get specific category list
8	1.0182700157166	After getting categories	Query to get specific category list
9	1.0182740688324	Before getting category custom	Before call to function getCategoryCustom
10	1.0518531799316	After getting category custom	After call to function getCategoryCustom
11	1.0518600940704	Before getting category custom	Before call to function getCategoryCustom
12	1.0666980743408	After getting category custom	After call to function getCategoryCustom
13	1.0667040348053	Before getting category custom	Before call to function getCategoryCustom
14	1.0745351314545	After getting category custom	After call to function getCategoryCustom
15	1.0745401382446	Before getting category custom	Before call to function getCategoryCustom
16	1.080048084259	After getting category custom	After call to function getCategoryCustom
17	1.0800530910492	Before getting category custom	Before call to function getCategoryCustom
18	1.0852980613708	After getting category custom	After call to function getCategoryCustom
19	1.0853040218353	Before getting category custom	Before call to function getCategoryCustom
20	1.0916450023651	After getting category custom	After call to function getCategoryCustom
21	1.091649055481	End of GetCategoryList function	End of the function
22	1.091658115387	Get Category List for Group	Before the call to getCategoryList function
23	1.0916600227356	Start of GetCategoryList function	Start of the function
24	1.0916640758514	Before getting categories	Query to get specific category list
25	1.0923581123352	End of getCategoryListByGroup Function	Before return()
26	1.5782811641693	App Controller End	End of the App controller (called before the controller of every page)
27	1.8743422031403	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.8768429756165	Before Get Options	Before the call to getOptions in the tpl class
29	1.9761440753937	After Get Options	After the call to getOptions in the tpl class
30	1.9761991500854	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	2.0373840332031	Finalizing debug	Before the debug is output to the page.
32	2.0374071598053	End of App	This is the end of the app logging, final timestamp

Query Debug - 372 Database Queries. Total time 1.0132 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.145.158.111\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738791902'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.158.111') >= INET_ATON(ip_start) AND INET_ATON('3.145.158.111') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'search'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '3.145.158.111'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

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

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

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

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT * FROM products WHERE id = '3938'
SELECT * FROM productimages WHERE product_id = '3938' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3938'
SELECT * FROM productcustomimages WHERE product_id = '3938'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3938' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3938' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3938' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3938
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3938'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4949'
SELECT * FROM productimages WHERE product_id = '4949' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4949'
SELECT * FROM productcustomimages WHERE product_id = '4949'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4949' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4949' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4949' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '890'
SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '890'
SELECT * FROM productcustomimages WHERE product_id = '890'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '890' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '810'
SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '810'
SELECT * FROM productcustomimages WHERE product_id = '810'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '810' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3546'
SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3546'
SELECT * FROM productcustomimages WHERE product_id = '3546'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3546' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3204'
SELECT * FROM productimages WHERE product_id = '3204' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3204' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3204'
SELECT * FROM productcustomimages WHERE product_id = '3204'
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 = '3204'
                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     = '3204'
                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 = 3204
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3204' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3204' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3204' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3204
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3204'
                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 = '3204'
                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     = '3204'
                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 = 3204
SELECT value FROM productattributes WHERE product_id = '3204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3204'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '931'
SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '931'
SELECT * FROM productcustomimages WHERE product_id = '931'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '931' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '931' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4505'
SELECT * FROM productimages WHERE product_id = '4505' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4505' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4505'
SELECT * FROM productcustomimages WHERE product_id = '4505'
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 = '4505'
                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     = '4505'
                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 = 4505
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4505' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4505' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4505' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4505
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4505'
                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 = '4505'
                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     = '4505'
                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 = 4505
SELECT value FROM productattributes WHERE product_id = '4505' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4505'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '4505'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4506' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4506' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM products WHERE id = '1017'
SELECT * FROM productimages WHERE product_id = '1017' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1017'
SELECT * FROM productcustomimages WHERE product_id = '1017'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1017' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1017' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1217'
SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1217'
SELECT * FROM productcustomimages WHERE product_id = '1217'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1217' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4928'
SELECT * FROM productimages WHERE product_id = '4928' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4928'
SELECT * FROM productcustomimages WHERE product_id = '4928'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4928' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4928' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4928' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4928
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4928'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4928' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1200'
SELECT * FROM productimages WHERE product_id = '1200' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1200'
SELECT * FROM productcustomimages WHERE product_id = '1200'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1200' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1200' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1200' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1200' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2213'
SELECT * FROM productimages WHERE product_id = '2213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2213'
SELECT * FROM productcustomimages WHERE product_id = '2213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2213
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2213'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1344'
SELECT * FROM productimages WHERE product_id = '1344' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1344'
SELECT * FROM productcustomimages WHERE product_id = '1344'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1344' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1344' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1344' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1344' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '923'
SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '923'
SELECT * FROM productcustomimages WHERE product_id = '923'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '923' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2271'
SELECT * FROM productimages WHERE product_id = '2271' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2271'
SELECT * FROM productcustomimages WHERE product_id = '2271'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2271' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2271' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2271' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2271' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3878'
SELECT * FROM productimages WHERE product_id = '3878' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3878' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3878'
SELECT * FROM productcustomimages WHERE product_id = '3878'
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 = '3878'
                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     = '3878'
                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 = 3878
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3878' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3878' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3878' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3878
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3878'
                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 = '3878'
                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     = '3878'
                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 = 3878
SELECT * FROM products WHERE parent_id = '3878'
SELECT * FROM products WHERE id = '1364'
SELECT * FROM productimages WHERE product_id = '1364' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1364'
SELECT * FROM productcustomimages WHERE product_id = '1364'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1364' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1364' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1364' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1364' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3938' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4949' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '890' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '810' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3546' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3204' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '931' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4505' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1017' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1217' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4928' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1200' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2213' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1344' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '923' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2271' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3878' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1364' 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.0022	0.0022289752960205	SELECT parameter, value FROM parameters
2	0.0093	0.0092899799346924	SELECT * FROM `bad_bots`
3	0.0038	0.0037679672241211	SET time_zone = 'Europe/London'
4	0.0040	0.004033088684082	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0039	0.0039181709289551	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.145.158.111\";}'
6	0.0037	0.0036559104919434	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738791902'
7	0.0041	0.004072904586792	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0010	0.00096392631530762	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0032	0.0031938552856445	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0007	0.0006721019744873	SELECT * FROM pages WHERE id = 52
11	0.0047	0.0046899318695068	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0301	0.030132055282593	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0009	0.0009160041809082	SELECT * FROM pages WHERE pagename = 'search'
14	0.0026	0.0025789737701416	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0024	0.0024380683898926	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0088	0.0087730884552002	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.0032	0.0032210350036621	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.0017	0.0016658306121826	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0013	0.001338005065918	SELECT id FROM categories WHERE parent_id = '26'
20	0.0066	0.0065548419952393	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.0023	0.002331018447876	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.0033	0.0032930374145508	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.0049	0.0048680305480957	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0012	0.001166820526123	SELECT * FROM categorygroups WHERE id = '1'
25	0.0055	0.0054681301116943	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.0008	0.00078082084655762	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.0005	0.00054383277893066	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0006	0.00061202049255371	SELECT id FROM categories WHERE parent_id = '27'
29	0.0041	0.0040922164916992	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.0008	0.00078988075256348	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0007	0.00069499015808105	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.0010	0.0009770393371582	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0006	0.0006260871887207	SELECT * FROM categorygroups WHERE id = '1'
34	0.0019	0.0018670558929443	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.00065112113952637	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.00052404403686523	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0005	0.00053596496582031	SELECT id FROM categories WHERE parent_id = '28'
38	0.0018	0.0018351078033447	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.00061392784118652	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.00057101249694824	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.00051999092102051	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.0004880428314209	SELECT * FROM categorygroups WHERE id = '1'
43	0.0007	0.00070285797119141	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.00053596496582031	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.0005	0.00046086311340332	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00049996376037598	SELECT id FROM categories WHERE parent_id = '29'
47	0.0009	0.00085997581481934	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.0006	0.00060510635375977	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.0007	0.00069999694824219	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.0005180835723877	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0005	0.00046205520629883	SELECT * FROM categorygroups WHERE id = '1'
52	0.0007	0.00066208839416504	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.00049209594726562	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.0003969669342041	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00050783157348633	SELECT id FROM categories WHERE parent_id = '30'
56	0.0008	0.00079989433288574	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.0005	0.00054621696472168	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.0006	0.00060510635375977	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.0005490779876709	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0005	0.00052690505981445	SELECT * FROM categorygroups WHERE id = '1'
61	0.0008	0.00082612037658691	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62	0.0006	0.00061297416687012	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0005	0.00050806999206543	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.00048589706420898	SELECT id FROM categories WHERE parent_id = '31'
65	0.0010	0.0010411739349365	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.0006	0.00063204765319824	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
67	0.0008	0.00075602531433105	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
68	0.0008	0.00075197219848633	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0006	0.00056195259094238	SELECT * FROM categorygroups WHERE id = '1'
70	0.0007	0.00068116188049316	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0037	0.0037150382995605	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0021	0.0020689964294434	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0007	0.00072693824768066	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.0015	0.0014748573303223	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0012	0.0011768341064453	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0012	0.0011870861053467	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.4692	0.4692370891571	SELECT * FROM ipgeocountries WHERE INET_ATON('3.145.158.111') >= INET_ATON(ip_start) AND INET_ATON('3.145.158.111') <= INET_ATON(ip_end)
78	0.0023	0.0023000240325928	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0014	0.001399040222168	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0006	0.00057792663574219	SELECT * FROM pages WHERE pagename = 'search'
81	0.0053	0.0052919387817383	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0017	0.0016889572143555	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0018	0.0018291473388672	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0054	0.0053689479827881	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0017	0.0017149448394775	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0005	0.00052213668823242	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0017	0.0016560554504395	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '3.145.158.111'
88	0.0009	0.00089311599731445	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
89	0.0006	0.00057697296142578	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0041	0.0041179656982422	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
91	0.0006	0.00061178207397461	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
92	0.0005	0.00052499771118164	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
93	0.0006	0.00059604644775391	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
94	0.0047	0.0047399997711182	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
95	0.0004	0.00042104721069336	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
96	0.0003	0.0003359317779541	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
97	0.0006	0.00055408477783203	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0005	0.00052595138549805	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0038	0.0037579536437988	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0005	0.00048518180847168	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
101	0.0004	0.0003809928894043	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
102	0.0006	0.00060319900512695	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
103	0.0049	0.0048799514770508	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0005	0.00045680999755859	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
105	0.0004	0.00038719177246094	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
106	0.0006	0.00057291984558105	SELECT * FROM products WHERE id = '3938'
107	0.0018	0.0017609596252441	SELECT * FROM productimages WHERE product_id = '3938' ORDER BY sortorder ASC
108	0.0015	0.0014729499816895	SELECT * FROM product_image_select WHERE product_id = '3938'
109	0.0012	0.0011529922485352	SELECT * FROM productcustomimages WHERE product_id = '3938'
110	0.0025	0.0024821758270264	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3938' AND a.name = n.originalname
111	0.0014	0.0014059543609619	SELECT * FROM productoffers WHERE product_id = '3938' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0006	0.0006108283996582	SELECT * FROM productoffers WHERE product_id = '3938' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0011	0.0010998249053955	SELECT * FROM productoffers WHERE product_id = 3938 ORDER BY price ASC LIMIT 1
114	0.0015	0.0015308856964111	SELECT value FROM productattributes WHERE product_id = '3938' AND name = 'ListPriceAmount'
115	0.0011	0.0011420249938965	SELECT value FROM productattributes WHERE product_id = '3938' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116	0.0007	0.00066900253295898	SELECT * FROM products WHERE id = '4949'
117	0.0005	0.00053691864013672	SELECT * FROM productimages WHERE product_id = '4949' ORDER BY sortorder ASC
118	0.0006	0.0006108283996582	SELECT * FROM product_image_select WHERE product_id = '4949'
119	0.0004	0.00044798851013184	SELECT * FROM productcustomimages WHERE product_id = '4949'
120	0.0010	0.0010168552398682	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4949' AND a.name = n.originalname
121	0.0006	0.0005800724029541	SELECT * FROM productoffers WHERE product_id = '4949' AND merchantid = 'A1X6FK5RDHNB96'
122	0.0005	0.00045394897460938	SELECT * FROM productoffers WHERE product_id = '4949' AND price > 0 ORDER BY price ASC LIMIT 1
123	0.0005	0.00052905082702637	SELECT value FROM productattributes WHERE product_id = '4949' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124	0.0006	0.00063204765319824	SELECT * FROM products WHERE id = '890'
125	0.0005	0.00054597854614258	SELECT * FROM productimages WHERE product_id = '890' ORDER BY sortorder ASC
126	0.0007	0.00066399574279785	SELECT * FROM product_image_select WHERE product_id = '890'
127	0.0004	0.00041580200195312	SELECT * FROM productcustomimages WHERE product_id = '890'
128	0.0013	0.0012869834899902	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '890' AND a.name = n.originalname
129	0.0005	0.00052595138549805	SELECT * FROM productoffers WHERE product_id = '890' AND merchantid = 'A1X6FK5RDHNB96'
130	0.0005	0.00045108795166016	SELECT * FROM productoffers WHERE product_id = '890' AND price > 0 ORDER BY price ASC LIMIT 1
131	0.0005	0.00045680999755859	SELECT value FROM productattributes WHERE product_id = '890' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132	0.0006	0.00061297416687012	SELECT * FROM products WHERE id = '810'
133	0.0006	0.00057697296142578	SELECT * FROM productimages WHERE product_id = '810' ORDER BY sortorder ASC
134	0.0007	0.00066590309143066	SELECT * FROM product_image_select WHERE product_id = '810'
135	0.0004	0.00043702125549316	SELECT * FROM productcustomimages WHERE product_id = '810'
136	0.0012	0.0011978149414062	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '810' AND a.name = n.originalname
137	0.0006	0.00055313110351562	SELECT * FROM productoffers WHERE product_id = '810' AND merchantid = 'A1X6FK5RDHNB96'
138	0.0005	0.00054407119750977	SELECT * FROM productoffers WHERE product_id = '810' AND price > 0 ORDER BY price ASC LIMIT 1
139	0.0005	0.00049114227294922	SELECT value FROM productattributes WHERE product_id = '810' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
140	0.0007	0.00065302848815918	SELECT * FROM products WHERE id = '3546'
141	0.0005	0.00054192543029785	SELECT * FROM productimages WHERE product_id = '3546' ORDER BY sortorder ASC
142	0.0007	0.00069189071655273	SELECT * FROM product_image_select WHERE product_id = '3546'
143	0.0004	0.00042581558227539	SELECT * FROM productcustomimages WHERE product_id = '3546'
144	0.0012	0.001162052154541	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3546' AND a.name = n.originalname
145	0.0006	0.00060081481933594	SELECT * FROM productoffers WHERE product_id = '3546' AND merchantid = 'A1X6FK5RDHNB96'
146	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '3546' AND price > 0 ORDER BY price ASC LIMIT 1
147	0.0005	0.00050210952758789	SELECT value FROM productattributes WHERE product_id = '3546' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
148	0.0009	0.00094985961914062	SELECT * FROM products WHERE id = '3204'
149	0.0017	0.0016632080078125	SELECT * FROM productimages WHERE product_id = '3204' ORDER BY sortorder ASC
150	0.0015	0.001507043838501	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3204' AND p.id = pi.product_id ORDER BY pi.sortorder
151	0.0022	0.0021870136260986	SELECT * FROM product_image_select WHERE product_id = '3204'
152	0.0016	0.0016000270843506	SELECT * FROM productcustomimages WHERE product_id = '3204'
153	0.0020	0.0019910335540771	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 = '3204' GROUP BY o.product_id
154	0.0052	0.005216121673584	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 = '3204' GROUP BY n.displayname ORDER BY n.displayname DESC
155	0.0016	0.0016019344329834	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3204
156	0.0031	0.00307297706604	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3204' AND a.name = n.originalname
157	0.0006	0.00059103965759277	SELECT * FROM productoffers WHERE product_id = '3204' AND merchantid = 'A1X6FK5RDHNB96'
158	0.0006	0.00060701370239258	SELECT * FROM productoffers WHERE product_id = '3204' AND price > 0 ORDER BY price ASC LIMIT 1
159	0.0006	0.00064897537231445	SELECT * FROM productoffers WHERE product_id = 3204 ORDER BY price ASC LIMIT 1
160	0.0007	0.00071907043457031	SELECT value FROM productattributes WHERE product_id = '3204' AND name = 'ListPriceAmount'
161	0.0008	0.00080513954162598	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 = '3204' GROUP BY o.product_id
162	0.0014	0.0014119148254395	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 = '3204' GROUP BY n.displayname ORDER BY n.displayname DESC
163	0.0007	0.00070500373840332	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3204
164	0.0009	0.00093412399291992	SELECT value FROM productattributes WHERE product_id = '3204' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165	0.0010	0.0010199546813965	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3204' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
166	0.0006	0.00064396858215332	SELECT * FROM products WHERE id = '931'
167	0.0008	0.0008399486541748	SELECT * FROM productimages WHERE product_id = '931' ORDER BY sortorder ASC
168	0.0021	0.0021321773529053	SELECT * FROM product_image_select WHERE product_id = '931'
169	0.0006	0.00063085556030273	SELECT * FROM productcustomimages WHERE product_id = '931'
170	0.0022	0.0021681785583496	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '931' AND a.name = n.originalname
171	0.0033	0.0032761096954346	SELECT * FROM productoffers WHERE product_id = '931' AND merchantid = 'A1X6FK5RDHNB96'
172	0.0007	0.00068211555480957	SELECT * FROM productoffers WHERE product_id = '931' AND price > 0 ORDER BY price ASC LIMIT 1
173	0.0006	0.0006401538848877	SELECT value FROM productattributes WHERE product_id = '931' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174	0.0008	0.00078082084655762	SELECT * FROM products WHERE id = '4505'
175	0.0008	0.00078105926513672	SELECT * FROM productimages WHERE product_id = '4505' ORDER BY sortorder ASC
176	0.0007	0.000701904296875	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4505' AND p.id = pi.product_id ORDER BY pi.sortorder
177	0.0010	0.00096297264099121	SELECT * FROM product_image_select WHERE product_id = '4505'
178	0.0006	0.0006110668182373	SELECT * FROM productcustomimages WHERE product_id = '4505'
179	0.0009	0.00085902214050293	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 = '4505' GROUP BY o.product_id
180	0.0011	0.0011088848114014	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 = '4505' GROUP BY n.displayname ORDER BY n.displayname DESC
181	0.0006	0.00061798095703125	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4505
182	0.0021	0.0021259784698486	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4505' AND a.name = n.originalname
183	0.0016	0.0015578269958496	SELECT * FROM productoffers WHERE product_id = '4505' AND merchantid = 'A1X6FK5RDHNB96'
184	0.0009	0.00088000297546387	SELECT * FROM productoffers WHERE product_id = '4505' AND price > 0 ORDER BY price ASC LIMIT 1
185	0.0005	0.00051283836364746	SELECT * FROM productoffers WHERE product_id = 4505 ORDER BY price ASC LIMIT 1
186	0.0035	0.0035030841827393	SELECT value FROM productattributes WHERE product_id = '4505' AND name = 'ListPriceAmount'
187	0.0008	0.00082707405090332	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 = '4505' GROUP BY o.product_id
188	0.0037	0.0037178993225098	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 = '4505' GROUP BY n.displayname ORDER BY n.displayname DESC
189	0.0022	0.0022180080413818	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4505
190	0.0012	0.0012378692626953	SELECT value FROM productattributes WHERE product_id = '4505' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
191	0.0012	0.001248836517334	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4505' AND p.id = o.product_id AND o.name = 'PackageQuantity' GROUP BY o.value ORDER BY o.value ASC
192	0.0008	0.00079917907714844	SELECT * FROM products WHERE parent_id = '4505'
193	0.0010	0.0010027885437012	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4506' AND a.name = n.originalname
194	0.0008	0.00081396102905273	SELECT * FROM productoffers WHERE product_id = '4506' AND merchantid = 'A1X6FK5RDHNB96'
195	0.0032	0.0032279491424561	SELECT * FROM products WHERE id = '1017'
196	0.0009	0.00093698501586914	SELECT * FROM productimages WHERE product_id = '1017' ORDER BY sortorder ASC
197	0.0013	0.0012519359588623	SELECT * FROM product_image_select WHERE product_id = '1017'
198	0.0006	0.00055503845214844	SELECT * FROM productcustomimages WHERE product_id = '1017'
199	0.0009	0.00091791152954102	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1017' AND a.name = n.originalname
200	0.0009	0.00089001655578613	SELECT * FROM productoffers WHERE product_id = '1017' AND merchantid = 'A1X6FK5RDHNB96'
201	0.0008	0.00075793266296387	SELECT * FROM productoffers WHERE product_id = '1017' AND price > 0 ORDER BY price ASC LIMIT 1
202	0.0005	0.00045299530029297	SELECT value FROM productattributes WHERE product_id = '1017' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203	0.0033	0.0032801628112793	SELECT * FROM products WHERE id = '1217'
204	0.0009	0.00085878372192383	SELECT * FROM productimages WHERE product_id = '1217' ORDER BY sortorder ASC
205	0.0008	0.00076198577880859	SELECT * FROM product_image_select WHERE product_id = '1217'
206	0.0005	0.0004580020904541	SELECT * FROM productcustomimages WHERE product_id = '1217'
207	0.0022	0.0021870136260986	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1217' AND a.name = n.originalname
208	0.0007	0.00073003768920898	SELECT * FROM productoffers WHERE product_id = '1217' AND merchantid = 'A1X6FK5RDHNB96'
209	0.0006	0.00061392784118652	SELECT * FROM productoffers WHERE product_id = '1217' AND price > 0 ORDER BY price ASC LIMIT 1
210	0.0010	0.0010371208190918	SELECT value FROM productattributes WHERE product_id = '1217' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211	0.0008	0.00082206726074219	SELECT * FROM products WHERE id = '4928'
212	0.0007	0.00072693824768066	SELECT * FROM productimages WHERE product_id = '4928' ORDER BY sortorder ASC
213	0.0008	0.0007779598236084	SELECT * FROM product_image_select WHERE product_id = '4928'
214	0.0005	0.00048398971557617	SELECT * FROM productcustomimages WHERE product_id = '4928'
215	0.0017	0.0016918182373047	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4928' AND a.name = n.originalname
216	0.0006	0.00058102607727051	SELECT * FROM productoffers WHERE product_id = '4928' AND merchantid = 'A1X6FK5RDHNB96'
217	0.0005	0.00046682357788086	SELECT * FROM productoffers WHERE product_id = '4928' AND price > 0 ORDER BY price ASC LIMIT 1
218	0.0004	0.00042819976806641	SELECT * FROM productoffers WHERE product_id = 4928 ORDER BY price ASC LIMIT 1
219	0.0005	0.0004730224609375	SELECT value FROM productattributes WHERE product_id = '4928' AND name = 'ListPriceAmount'
220	0.0007	0.00066018104553223	SELECT value FROM productattributes WHERE product_id = '4928' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221	0.0007	0.00071811676025391	SELECT * FROM products WHERE id = '1200'
222	0.0007	0.00068998336791992	SELECT * FROM productimages WHERE product_id = '1200' ORDER BY sortorder ASC
223	0.0011	0.0011329650878906	SELECT * FROM product_image_select WHERE product_id = '1200'
224	0.0005	0.0004878044128418	SELECT * FROM productcustomimages WHERE product_id = '1200'
225	0.0011	0.0010941028594971	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1200' AND a.name = n.originalname
226	0.0006	0.00063204765319824	SELECT * FROM productoffers WHERE product_id = '1200' AND merchantid = 'A1X6FK5RDHNB96'
227	0.0040	0.0039818286895752	SELECT * FROM productoffers WHERE product_id = '1200' AND price > 0 ORDER BY price ASC LIMIT 1
228	0.0039	0.0038530826568604	SELECT value FROM productattributes WHERE product_id = '1200' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229	0.0040	0.0040099620819092	SELECT * FROM products WHERE id = '2213'
230	0.0016	0.0015828609466553	SELECT * FROM productimages WHERE product_id = '2213' ORDER BY sortorder ASC
231	0.0016	0.0015840530395508	SELECT * FROM product_image_select WHERE product_id = '2213'
232	0.0008	0.00077700614929199	SELECT * FROM productcustomimages WHERE product_id = '2213'
233	0.0024	0.0024049282073975	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2213' AND a.name = n.originalname
234	0.0013	0.0012800693511963	SELECT * FROM productoffers WHERE product_id = '2213' AND merchantid = 'A1X6FK5RDHNB96'
235	0.0026	0.0026271343231201	SELECT * FROM productoffers WHERE product_id = '2213' AND price > 0 ORDER BY price ASC LIMIT 1
236	0.0009	0.00085806846618652	SELECT * FROM productoffers WHERE product_id = 2213 ORDER BY price ASC LIMIT 1
237	0.0009	0.00092315673828125	SELECT value FROM productattributes WHERE product_id = '2213' AND name = 'ListPriceAmount'
238	0.0010	0.0010261535644531	SELECT value FROM productattributes WHERE product_id = '2213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239	0.0011	0.001107931137085	SELECT * FROM products WHERE id = '1344'
240	0.0010	0.0010058879852295	SELECT * FROM productimages WHERE product_id = '1344' ORDER BY sortorder ASC
241	0.0012	0.0012309551239014	SELECT * FROM product_image_select WHERE product_id = '1344'
242	0.0026	0.0025670528411865	SELECT * FROM productcustomimages WHERE product_id = '1344'
243	0.0028	0.0027849674224854	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1344' AND a.name = n.originalname
244	0.0016	0.0016179084777832	SELECT * FROM productoffers WHERE product_id = '1344' AND merchantid = 'A1X6FK5RDHNB96'
245	0.0017	0.0016670227050781	SELECT * FROM productoffers WHERE product_id = '1344' AND price > 0 ORDER BY price ASC LIMIT 1
246	0.0029	0.0029358863830566	SELECT value FROM productattributes WHERE product_id = '1344' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247	0.0035	0.0034849643707275	SELECT * FROM products WHERE id = '923'
248	0.0030	0.0030210018157959	SELECT * FROM productimages WHERE product_id = '923' ORDER BY sortorder ASC
249	0.0016	0.0015859603881836	SELECT * FROM product_image_select WHERE product_id = '923'
250	0.0009	0.00092697143554688	SELECT * FROM productcustomimages WHERE product_id = '923'
251	0.0028	0.0027530193328857	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '923' AND a.name = n.originalname
252	0.0012	0.0011959075927734	SELECT * FROM productoffers WHERE product_id = '923' AND merchantid = 'A1X6FK5RDHNB96'
253	0.0015	0.0014698505401611	SELECT * FROM productoffers WHERE product_id = '923' AND price > 0 ORDER BY price ASC LIMIT 1
254	0.0027	0.0026841163635254	SELECT value FROM productattributes WHERE product_id = '923' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255	0.0017	0.0016560554504395	SELECT * FROM products WHERE id = '2271'
256	0.0019	0.0019409656524658	SELECT * FROM productimages WHERE product_id = '2271' ORDER BY sortorder ASC
257	0.0016	0.0015938282012939	SELECT * FROM product_image_select WHERE product_id = '2271'
258	0.0006	0.00063419342041016	SELECT * FROM productcustomimages WHERE product_id = '2271'
259	0.0019	0.0018579959869385	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2271' AND a.name = n.originalname
260	0.0014	0.0013971328735352	SELECT * FROM productoffers WHERE product_id = '2271' AND merchantid = 'A1X6FK5RDHNB96'
261	0.0009	0.00087499618530273	SELECT * FROM productoffers WHERE product_id = '2271' AND price > 0 ORDER BY price ASC LIMIT 1
262	0.0008	0.00076699256896973	SELECT value FROM productattributes WHERE product_id = '2271' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263	0.0009	0.0009458065032959	SELECT * FROM products WHERE id = '3878'
264	0.0011	0.0011229515075684	SELECT * FROM productimages WHERE product_id = '3878' ORDER BY sortorder ASC
265	0.0007	0.00067496299743652	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3878' AND p.id = pi.product_id ORDER BY pi.sortorder
266	0.0011	0.0010840892791748	SELECT * FROM product_image_select WHERE product_id = '3878'
267	0.0006	0.00057196617126465	SELECT * FROM productcustomimages WHERE product_id = '3878'
268	0.0019	0.001878023147583	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 = '3878' GROUP BY o.product_id
269	0.0020	0.0019829273223877	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 = '3878' GROUP BY n.displayname ORDER BY n.displayname DESC
270	0.0016	0.0016350746154785	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3878
271	0.0036	0.0035631656646729	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3878' AND a.name = n.originalname
272	0.0006	0.00056314468383789	SELECT * FROM productoffers WHERE product_id = '3878' AND merchantid = 'A1X6FK5RDHNB96'
273	0.0011	0.001107931137085	SELECT * FROM productoffers WHERE product_id = '3878' AND price > 0 ORDER BY price ASC LIMIT 1
274	0.0005	0.00052189826965332	SELECT * FROM productoffers WHERE product_id = 3878 ORDER BY price ASC LIMIT 1
275	0.0011	0.0010979175567627	SELECT value FROM productattributes WHERE product_id = '3878' AND name = 'ListPriceAmount'
276	0.0007	0.00070881843566895	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 = '3878' GROUP BY o.product_id
277	0.0011	0.0010950565338135	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 = '3878' GROUP BY n.displayname ORDER BY n.displayname DESC
278	0.0008	0.00084805488586426	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3878
279	0.0015	0.0015249252319336	SELECT * FROM products WHERE parent_id = '3878'
280	0.0008	0.00076603889465332	SELECT * FROM products WHERE id = '1364'
281	0.0024	0.0024008750915527	SELECT * FROM productimages WHERE product_id = '1364' ORDER BY sortorder ASC
282	0.0010	0.00098991394042969	SELECT * FROM product_image_select WHERE product_id = '1364'
283	0.0006	0.00059986114501953	SELECT * FROM productcustomimages WHERE product_id = '1364'
284	0.0012	0.0012459754943848	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1364' AND a.name = n.originalname
285	0.0010	0.00096392631530762	SELECT * FROM productoffers WHERE product_id = '1364' AND merchantid = 'A1X6FK5RDHNB96'
286	0.0006	0.00064992904663086	SELECT * FROM productoffers WHERE product_id = '1364' AND price > 0 ORDER BY price ASC LIMIT 1
287	0.0013	0.0012800693511963	SELECT value FROM productattributes WHERE product_id = '1364' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288	0.0025	0.002485990524292	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3938' ORDER BY timestamp DESC
289	0.0005	0.00045180320739746	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4949' ORDER BY timestamp DESC
290	0.0004	0.00040793418884277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '890' ORDER BY timestamp DESC
291	0.0004	0.00039386749267578	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '810' ORDER BY timestamp DESC
292	0.0004	0.00041413307189941	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3546' ORDER BY timestamp DESC
293	0.0005	0.00047397613525391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3204' ORDER BY timestamp DESC
294	0.0004	0.00039315223693848	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '931' ORDER BY timestamp DESC
295	0.0004	0.00039982795715332	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4505' ORDER BY timestamp DESC
296	0.0005	0.0005190372467041	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1017' ORDER BY timestamp DESC
297	0.0004	0.00037407875061035	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1217' ORDER BY timestamp DESC
298	0.0004	0.00042200088500977	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4928' ORDER BY timestamp DESC
299	0.0004	0.00040793418884277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1200' ORDER BY timestamp DESC
300	0.0004	0.00038504600524902	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2213' ORDER BY timestamp DESC
301	0.0004	0.0003809928894043	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1344' ORDER BY timestamp DESC
302	0.0006	0.0005791187286377	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '923' ORDER BY timestamp DESC
303	0.0004	0.00039792060852051	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2271' ORDER BY timestamp DESC
304	0.0004	0.00037908554077148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3878' ORDER BY timestamp DESC
305	0.0004	0.00039291381835938	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1364' ORDER BY timestamp DESC
306	0.0025	0.0024750232696533	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
307	0.0018	0.0018310546875	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
308	0.0005	0.00051712989807129	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
309	0.0223	0.022290945053101	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
310	0.0043	0.0043091773986816	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
311	0.0039	0.0039379596710205	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
312	0.0011	0.0010831356048584	SELECT * FROM products WHERE id = 1626
313	0.0008	0.00075602531433105	SELECT * FROM products WHERE id = 4041
314	0.0006	0.00060582160949707	SELECT * FROM products WHERE id = 4312
315	0.0006	0.00061798095703125	SELECT * FROM products WHERE id = 777
316	0.0005	0.0004570484161377	SELECT * FROM products WHERE id = 3881
317	0.0007	0.00067591667175293	SELECT * FROM products WHERE id = 4213
318	0.0006	0.00057816505432129	SELECT * FROM products WHERE id = '1626'
319	0.0007	0.00072193145751953	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
320	0.0020	0.002025842666626	SELECT * FROM product_image_select WHERE product_id = '1626'
321	0.0005	0.00053787231445312	SELECT * FROM productcustomimages WHERE product_id = '1626'
322	0.0009	0.00091195106506348	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
323	0.0015	0.0015230178833008	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
324	0.0006	0.00057506561279297	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
325	0.0007	0.00067687034606934	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326	0.0008	0.0008389949798584	SELECT * FROM products WHERE id = '4041'
327	0.0005	0.0005040168762207	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
328	0.0006	0.00064897537231445	SELECT * FROM product_image_select WHERE product_id = '4041'
329	0.0004	0.00044393539428711	SELECT * FROM productcustomimages WHERE product_id = '4041'
330	0.0012	0.0012118816375732	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
331	0.0005	0.00050806999206543	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
332	0.0005	0.00045895576477051	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
333	0.0005	0.00048685073852539	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334	0.0010	0.0010111331939697	SELECT * FROM products WHERE id = '4312'
335	0.0005	0.00054001808166504	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
336	0.0017	0.0017240047454834	SELECT * FROM product_image_select WHERE product_id = '4312'
337	0.0009	0.00085210800170898	SELECT * FROM productcustomimages WHERE product_id = '4312'
338	0.0021	0.0020740032196045	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
339	0.0012	0.0011889934539795	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
340	0.0006	0.00055313110351562	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
341	0.0006	0.00059103965759277	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342	0.0008	0.00078201293945312	SELECT * FROM products WHERE id = '777'
343	0.0006	0.00062894821166992	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
344	0.0018	0.0017709732055664	SELECT * FROM product_image_select WHERE product_id = '777'
345	0.0008	0.00075316429138184	SELECT * FROM productcustomimages WHERE product_id = '777'
346	0.0012	0.0012490749359131	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
347	0.0007	0.00066399574279785	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
348	0.0006	0.00062179565429688	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
349	0.0008	0.00081896781921387	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350	0.0020	0.0019559860229492	SELECT * FROM products WHERE id = '3881'
351	0.0024	0.0023751258850098	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
352	0.0008	0.00078296661376953	SELECT * FROM product_image_select WHERE product_id = '3881'
353	0.0010	0.00099706649780273	SELECT * FROM productcustomimages WHERE product_id = '3881'
354	0.0028	0.0027608871459961	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
355	0.0007	0.00069904327392578	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
356	0.0013	0.0012710094451904	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
357	0.0017	0.0016989707946777	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358	0.0015	0.001474142074585	SELECT * FROM products WHERE id = '4213'
359	0.0017	0.0017180442810059	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
360	0.0009	0.00090289115905762	SELECT * FROM product_image_select WHERE product_id = '4213'
361	0.0006	0.00058293342590332	SELECT * FROM productcustomimages WHERE product_id = '4213'
362	0.0023	0.0022599697113037	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
363	0.0007	0.00068521499633789	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
364	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
365	0.0009	0.00085902214050293	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
366	0.0027	0.0026659965515137	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
367	0.0008	0.00076889991760254	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
368	0.0028	0.0028128623962402	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
369	0.0022	0.0022468566894531	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
370	0.0008	0.00076508522033691	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
371	0.0009	0.00088191032409668	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
372	0.0011	0.0011489391326904	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "3"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 2.0374081134796 seconds

Query Debug - 372 Database Queries. Total time 1.0132 seconds