Search Results for "4"

Boîte à thé – Il est toujours temps de t...

only €16,76

View

Add to Cart

Boîte métal KITCHEN café thé sucre 3 cou...

View to See Price

View

Add to Cart

REVIMPORT - Boîte à thé 9 cases bois laq...

View to See Price

View

Add to Cart

Boîte à thé – 113,4 gram – Petit carré –...

View to See Price

View

Add to Cart

boîte de rangement COM Four® pour les sa...

View to See Price

View

Add to Cart

VAHDAM, Thé Vert Matcha| Poudre de thé m...

only €9,99

View

Add to Cart

toujours du temps pour boîte à thé (Hear...

View to See Price

View

Add to Cart

'ToCi Boîte à thé "Tea – Boîte à th...

View to See Price

View

Add to Cart

Atmosphera Boîte à thé

View to See Price

View

Add to Cart

Jd Diffusion K4446CHA Charlie Boîte à Th...

only €12,90

View

Add to Cart

Half Moon Bay Boîte de thé PG Tips - Gra...

View to See Price

View

Add to Cart

Novastyl 5145108 Boîte à Thé, Autre, Cre...

View to See Price

View

Add to Cart

Argent uni à thé/cuisine Boîte de rangem...

View to See Price

View

Add to Cart

Heath & Heather | Organic Rooibos Te...

View to See Price

View

Add to Cart

Natives 211235 Miss Fifties Boîte à Thé ...

View to See Price

View

Add to Cart

Dragonfly Rooibos Earl Grey Tea 40 per p...

only €7,79

View

Add to Cart

P & T Cederberg Chai, Master Blend d...

View to See Price

View

Add to Cart

Tick?? Tock origine Rooibos bio sacs de ...

View to See Price

View

Add to Cart

235 to 252 of 336 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.356477022171	386	1.1321	0

No Amazon API Requests Made.

App Debug - Total Time 1.356477022171 seconds

Number	Time From Start	Name	Description
1	0.21856307983398	Initialise	Initialise FSB Function
2	0.22139310836792	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.26084303855896	Start of getCategoryListByGroup Function	Before first category groups query
4	0.26141095161438	After initial query	Before first category groups query
5	0.2614119052887	Get Category List for Group	Before the call to getCategoryList function
6	0.26141500473022	Start of GetCategoryList function	Start of the function
7	0.26141691207886	Before getting categories	Query to get specific category list
8	0.26198196411133	After getting categories	Query to get specific category list
9	0.26198196411133	Before getting category custom	Before call to function getCategoryCustom
10	0.27672410011292	After getting category custom	After call to function getCategoryCustom
11	0.27672600746155	Before getting category custom	Before call to function getCategoryCustom
12	0.28761911392212	After getting category custom	After call to function getCategoryCustom
13	0.28762006759644	Before getting category custom	Before call to function getCategoryCustom
14	0.29358005523682	After getting category custom	After call to function getCategoryCustom
15	0.29358100891113	Before getting category custom	Before call to function getCategoryCustom
16	0.29811191558838	After getting category custom	After call to function getCategoryCustom
17	0.29811406135559	Before getting category custom	Before call to function getCategoryCustom
18	0.30277109146118	After getting category custom	After call to function getCategoryCustom
19	0.30277299880981	Before getting category custom	Before call to function getCategoryCustom
20	0.3072988986969	After getting category custom	After call to function getCategoryCustom
21	0.30730104446411	End of GetCategoryList function	End of the function
22	0.30730795860291	Get Category List for Group	Before the call to getCategoryList function
23	0.30730891227722	Start of GetCategoryList function	Start of the function
24	0.30731105804443	Before getting categories	Query to get specific category list
25	0.30784201622009	End of getCategoryListByGroup Function	Before return()
26	1.0962359905243	App Controller End	End of the App controller (called before the controller of every page)
27	1.2825970649719	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.2834730148315	Before Get Options	Before the call to getOptions in the tpl class
29	1.3419461250305	After Get Options	After the call to getOptions in the tpl class
30	1.3419740200043	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.3564701080322	Finalizing debug	Before the debug is output to the page.
32	1.356477022171	End of App	This is the end of the app logging, final timestamp

Query Debug - 386 Database Queries. Total time 1.1321 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:\"216.73.216.91\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747381644'
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('216.73.216.91') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.91') <= INET_ATON(ip_end)
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 '4', NOW(), '216.73.216.91'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 '4') OR (keyfeatures LIKE '4') OR (title LIKE '4'))

		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 '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%'))

		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 '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+4' 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 ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 '4') OR (keyfeatures LIKE '4') OR (title LIKE '4'))

		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 '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '4') OR (title LIKE '4'))
		AND hide = 0
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%'))

		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 '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT * FROM products WHERE id = '2025'
SELECT * FROM productimages WHERE product_id = '2025' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2025'
SELECT * FROM productcustomimages WHERE product_id = '2025'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2025' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2025' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2025' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2025
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2025'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2025' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1769'
SELECT * FROM productimages WHERE product_id = '1769' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1769'
SELECT * FROM productcustomimages WHERE product_id = '1769'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1769' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1769' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1769' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1769
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1769'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1803'
SELECT * FROM productimages WHERE product_id = '1803' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1803'
SELECT * FROM productcustomimages WHERE product_id = '1803'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1803' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1803' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1803' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1803
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1803'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1803' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2342'
SELECT * FROM productimages WHERE product_id = '2342' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2342'
SELECT * FROM productcustomimages WHERE product_id = '2342'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2342' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2342' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2342' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2342
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2342'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2342' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1899'
SELECT * FROM productimages WHERE product_id = '1899' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1899' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1899'
SELECT * FROM productcustomimages WHERE product_id = '1899'
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 = '1899'
                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     = '1899'
                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 = 1899
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1899' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1899' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1899' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1899
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1899'
                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 = '1899'
                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     = '1899'
                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 = 1899
SELECT value FROM productattributes WHERE product_id = '1899' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1899'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '4904'
SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4904'
SELECT * FROM productcustomimages WHERE product_id = '4904'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4904' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4904' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1993'
SELECT * FROM productimages WHERE product_id = '1993' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1993'
SELECT * FROM productcustomimages WHERE product_id = '1993'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1993' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1993' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1993' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1993
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1993'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1993' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2021'
SELECT * FROM productimages WHERE product_id = '2021' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2021'
SELECT * FROM productcustomimages WHERE product_id = '2021'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2021' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2021' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2021' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2021
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2021'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2021' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2134'
SELECT * FROM productimages WHERE product_id = '2134' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2134'
SELECT * FROM productcustomimages WHERE product_id = '2134'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2134' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2134' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2134' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2134
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2134'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2102'
SELECT * FROM productimages WHERE product_id = '2102' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2102'
SELECT * FROM productcustomimages WHERE product_id = '2102'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2102' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2102' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2102' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2102' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2103'
SELECT * FROM productimages WHERE product_id = '2103' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2103' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2103'
SELECT * FROM productcustomimages WHERE product_id = '2103'
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 = '2103'
                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     = '2103'
                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 = 2103
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2103' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2103' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2103' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2103
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2103'
                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 = '2103'
                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     = '2103'
                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 = 2103
SELECT value FROM productattributes WHERE product_id = '2103' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2103'
SELECT * FROM products WHERE id = '2104'
SELECT * FROM productimages WHERE product_id = '2104' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2104'
SELECT * FROM productcustomimages WHERE product_id = '2104'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2104' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2104' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2104' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2104
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2104'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2104' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2109'
SELECT * FROM productimages WHERE product_id = '2109' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2109'
SELECT * FROM productcustomimages WHERE product_id = '2109'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2109' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2109' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2109' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2109
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2109'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2518'
SELECT * FROM productimages WHERE product_id = '2518' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2518' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2518'
SELECT * FROM productcustomimages WHERE product_id = '2518'
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 = '2518'
                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     = '2518'
                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 = 2518
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2518' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2518
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2518'
                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 = '2518'
                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     = '2518'
                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 = 2518
SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2518'
SELECT * FROM products WHERE id = '2183'
SELECT * FROM productimages WHERE product_id = '2183' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2183'
SELECT * FROM productcustomimages WHERE product_id = '2183'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2183' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2183' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2183' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2183
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2183'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2290'
SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2290'
SELECT * FROM productcustomimages WHERE product_id = '2290'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2290' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2225'
SELECT * FROM productimages WHERE product_id = '2225' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2225'
SELECT * FROM productcustomimages WHERE product_id = '2225'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2225' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2225' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2225' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2225
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2225'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2225' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2235'
SELECT * FROM productimages WHERE product_id = '2235' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2235'
SELECT * FROM productcustomimages WHERE product_id = '2235'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2235' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2235' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2235' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2235
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2235'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2235' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2025' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1769' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1803' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2342' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1899' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4904' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1993' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2021' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2134' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2102' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2103' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2104' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2109' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2518' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2183' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2290' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2225' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2235' 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.0023	0.0022680759429932	SELECT parameter, value FROM parameters
2	0.0052	0.0052180290222168	SELECT * FROM `bad_bots`
3	0.0004	0.0004420280456543	SET time_zone = 'Europe/London'
4	0.0009	0.00092291831970215	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0018	0.0018148422241211	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.91\";}'
6	0.0009	0.00085783004760742	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1747381644'
7	0.0012	0.0011930465698242	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0010	0.0010039806365967	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0010	0.00099086761474609	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0006	0.00059700012207031	SELECT * FROM pages WHERE id = 52
11	0.0033	0.00331711769104	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0353	0.035344839096069	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0005	0.00049495697021484	SELECT * FROM pages WHERE pagename = 'search'
14	0.0006	0.00055813789367676	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0006	0.00055193901062012	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0056	0.0056130886077881	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.0005	0.00054597854614258	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.0005	0.00046586990356445	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00047707557678223	SELECT id FROM categories WHERE parent_id = '26'
20	0.0054	0.0054290294647217	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.0005	0.00052309036254883	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
22	0.0006	0.000579833984375	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.0005	0.00052285194396973	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00052213668823242	SELECT * FROM categorygroups WHERE id = '1'
25	0.0037	0.0037360191345215	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.0005	0.00052213668823242	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0004	0.00042295455932617	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0004	0.00042390823364258	SELECT id FROM categories WHERE parent_id = '27'
29	0.0035	0.0035150051116943	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.00075292587280273	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
31	0.0005	0.00051999092102051	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
32	0.0005	0.00048398971557617	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00046515464782715	SELECT * FROM categorygroups WHERE id = '1'
34	0.0014	0.0013589859008789	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.0005	0.00050115585327148	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0004	0.00037908554077148	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0004	0.00039505958557129	SELECT id FROM categories WHERE parent_id = '28'
38	0.0014	0.0013830661773682	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.0005	0.00048589706420898	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.0005	0.00051283836364746	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.00048208236694336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0004	0.00042891502380371	SELECT * FROM categorygroups WHERE id = '1'
43	0.0005	0.00054502487182617	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.00048494338989258	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0004	0.00042986869812012	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00047898292541504	SELECT id FROM categories WHERE parent_id = '29'
47	0.0006	0.00064802169799805	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
48	0.0005	0.00047087669372559	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
49	0.0005	0.00053095817565918	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.00047183036804199	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0004	0.00041699409484863	SELECT * FROM categorygroups WHERE id = '1'
52	0.0005	0.00053501129150391	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.00052094459533691	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.0006	0.00059413909912109	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00050711631774902	SELECT id FROM categories WHERE parent_id = '30'
56	0.0006	0.0006110668182373	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.00048589706420898	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
58	0.0005	0.00048685073852539	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.0004	0.00044488906860352	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0004	0.00040388107299805	SELECT * FROM categorygroups WHERE id = '1'
61	0.0006	0.00057315826416016	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.00057506561279297	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.00045609474182129	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0004	0.00041484832763672	SELECT id FROM categories WHERE parent_id = '31'
65	0.0006	0.00062990188598633	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
66	0.0005	0.0004580020904541	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.0005	0.0004730224609375	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.0004	0.00044894218444824	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0004	0.0004279613494873	SELECT * FROM categorygroups WHERE id = '1'
70	0.0005	0.00052213668823242	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0015	0.0015089511871338	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0006	0.00061988830566406	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0006	0.00055599212646484	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.0005	0.00046110153198242	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0012	0.0012071132659912	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0008	0.00083303451538086	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.7823	0.78232717514038	SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.91') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.91') <= INET_ATON(ip_end)
78	0.0007	0.00072789192199707	SELECT * FROM pages WHERE pagename = 'search'
79	0.0057	0.0056641101837158	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
80	0.0018	0.0018389225006104	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
81	0.0014	0.0014188289642334	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
82	0.0052	0.0052328109741211	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0015	0.0015261173248291	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0004	0.00043416023254395	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
85	0.0017	0.0016939640045166	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '216.73.216.91'
86	0.0008	0.0007779598236084	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
87	0.0005	0.00052809715270996	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
88	0.0034	0.0033550262451172	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
89	0.0005	0.00049114227294922	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
90	0.0004	0.00043511390686035	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
91	0.0005	0.00048613548278809	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
92	0.0045	0.0045149326324463	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
93	0.0003	0.00033688545227051	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
94	0.0003	0.00029802322387695	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
95	0.0005	0.00046992301940918	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
96	0.0005	0.00049281120300293	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
97	0.0036	0.0035719871520996	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
98	0.0004	0.00037312507629395	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
99	0.0003	0.00034308433532715	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
100	0.0005	0.0004880428314209	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' 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 ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
101	0.0044	0.0043549537658691	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
102	0.0003	0.00034999847412109	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
103	0.0003	0.00028610229492188	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
104	0.0004	0.00037598609924316	SELECT * FROM products WHERE id = '2025'
105	0.0005	0.00046706199645996	SELECT * FROM productimages WHERE product_id = '2025' ORDER BY sortorder ASC
106	0.0006	0.00056695938110352	SELECT * FROM product_image_select WHERE product_id = '2025'
107	0.0004	0.00043296813964844	SELECT * FROM productcustomimages WHERE product_id = '2025'
108	0.0008	0.00080609321594238	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2025' AND a.name = n.originalname
109	0.0005	0.00046896934509277	SELECT * FROM productoffers WHERE product_id = '2025' AND merchantid = 'A1X6FK5RDHNB96'
110	0.0004	0.00036382675170898	SELECT * FROM productoffers WHERE product_id = '2025' AND price > 0 ORDER BY price ASC LIMIT 1
111	0.0003	0.00032877922058105	SELECT * FROM productoffers WHERE product_id = 2025 ORDER BY price ASC LIMIT 1
112	0.0007	0.00068902969360352	SELECT value FROM productattributes WHERE product_id = '2025' AND name = 'ListPriceAmount'
113	0.0004	0.00037813186645508	SELECT value FROM productattributes WHERE product_id = '2025' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114	0.0005	0.0004580020904541	SELECT * FROM products WHERE id = '1769'
115	0.0005	0.00051498413085938	SELECT * FROM productimages WHERE product_id = '1769' ORDER BY sortorder ASC
116	0.0006	0.00058293342590332	SELECT * FROM product_image_select WHERE product_id = '1769'
117	0.0004	0.00037598609924316	SELECT * FROM productcustomimages WHERE product_id = '1769'
118	0.0009	0.0009160041809082	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1769' AND a.name = n.originalname
119	0.0005	0.00048112869262695	SELECT * FROM productoffers WHERE product_id = '1769' AND merchantid = 'A1X6FK5RDHNB96'
120	0.0004	0.00039982795715332	SELECT * FROM productoffers WHERE product_id = '1769' AND price > 0 ORDER BY price ASC LIMIT 1
121	0.0003	0.00032901763916016	SELECT * FROM productoffers WHERE product_id = 1769 ORDER BY price ASC LIMIT 1
122	0.0004	0.0003809928894043	SELECT value FROM productattributes WHERE product_id = '1769' AND name = 'ListPriceAmount'
123	0.0005	0.00049185752868652	SELECT value FROM productattributes WHERE product_id = '1769' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
124	0.0005	0.00046491622924805	SELECT * FROM products WHERE id = '1803'
125	0.0004	0.00044989585876465	SELECT * FROM productimages WHERE product_id = '1803' ORDER BY sortorder ASC
126	0.0006	0.00058507919311523	SELECT * FROM product_image_select WHERE product_id = '1803'
127	0.0004	0.00035309791564941	SELECT * FROM productcustomimages WHERE product_id = '1803'
128	0.0007	0.00069212913513184	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1803' AND a.name = n.originalname
129	0.0004	0.00042986869812012	SELECT * FROM productoffers WHERE product_id = '1803' AND merchantid = 'A1X6FK5RDHNB96'
130	0.0004	0.00041294097900391	SELECT * FROM productoffers WHERE product_id = '1803' AND price > 0 ORDER BY price ASC LIMIT 1
131	0.0004	0.00035500526428223	SELECT * FROM productoffers WHERE product_id = 1803 ORDER BY price ASC LIMIT 1
132	0.0003	0.0003349781036377	SELECT value FROM productattributes WHERE product_id = '1803' AND name = 'ListPriceAmount'
133	0.0004	0.00042510032653809	SELECT value FROM productattributes WHERE product_id = '1803' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134	0.0006	0.00057387351989746	SELECT * FROM products WHERE id = '2342'
135	0.0005	0.00046801567077637	SELECT * FROM productimages WHERE product_id = '2342' ORDER BY sortorder ASC
136	0.0006	0.00059199333190918	SELECT * FROM product_image_select WHERE product_id = '2342'
137	0.0006	0.00064682960510254	SELECT * FROM productcustomimages WHERE product_id = '2342'
138	0.0011	0.0010578632354736	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2342' AND a.name = n.originalname
139	0.0009	0.00087618827819824	SELECT * FROM productoffers WHERE product_id = '2342' AND merchantid = 'A1X6FK5RDHNB96'
140	0.0006	0.00061416625976562	SELECT * FROM productoffers WHERE product_id = '2342' AND price > 0 ORDER BY price ASC LIMIT 1
141	0.0006	0.00055408477783203	SELECT * FROM productoffers WHERE product_id = 2342 ORDER BY price ASC LIMIT 1
142	0.0007	0.00071001052856445	SELECT value FROM productattributes WHERE product_id = '2342' AND name = 'ListPriceAmount'
143	0.0007	0.00072193145751953	SELECT value FROM productattributes WHERE product_id = '2342' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
144	0.0008	0.00084400177001953	SELECT * FROM products WHERE id = '1899'
145	0.0011	0.0010900497436523	SELECT * FROM productimages WHERE product_id = '1899' ORDER BY sortorder ASC
146	0.0010	0.00097084045410156	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1899' AND p.id = pi.product_id ORDER BY pi.sortorder
147	0.0013	0.0013349056243896	SELECT * FROM product_image_select WHERE product_id = '1899'
148	0.0008	0.0007779598236084	SELECT * FROM productcustomimages WHERE product_id = '1899'
149	0.0011	0.0011191368103027	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 = '1899' GROUP BY o.product_id
150	0.0013	0.0012531280517578	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 = '1899' GROUP BY n.displayname ORDER BY n.displayname DESC
151	0.0006	0.00062918663024902	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1899
152	0.0014	0.0014119148254395	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1899' AND a.name = n.originalname
153	0.0007	0.00068998336791992	SELECT * FROM productoffers WHERE product_id = '1899' AND merchantid = 'A1X6FK5RDHNB96'
154	0.0005	0.0005488395690918	SELECT * FROM productoffers WHERE product_id = '1899' AND price > 0 ORDER BY price ASC LIMIT 1
155	0.0014	0.0013577938079834	SELECT * FROM productoffers WHERE product_id = 1899 ORDER BY price ASC LIMIT 1
156	0.0007	0.00073099136352539	SELECT value FROM productattributes WHERE product_id = '1899' AND name = 'ListPriceAmount'
157	0.0007	0.00066089630126953	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 = '1899' GROUP BY o.product_id
158	0.0011	0.0011460781097412	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 = '1899' GROUP BY n.displayname ORDER BY n.displayname DESC
159	0.0006	0.00062918663024902	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1899
160	0.0009	0.0008540153503418	SELECT value FROM productattributes WHERE product_id = '1899' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161	0.0013	0.0013458728790283	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1899' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
162	0.0009	0.00085186958312988	SELECT * FROM products WHERE id = '4904'
163	0.0010	0.00097799301147461	SELECT * FROM productimages WHERE product_id = '4904' ORDER BY sortorder ASC
164	0.0010	0.001039981842041	SELECT * FROM product_image_select WHERE product_id = '4904'
165	0.0008	0.00075483322143555	SELECT * FROM productcustomimages WHERE product_id = '4904'
166	0.0030	0.0030038356781006	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4904' AND a.name = n.originalname
167	0.0011	0.001068115234375	SELECT * FROM productoffers WHERE product_id = '4904' AND merchantid = 'A1X6FK5RDHNB96'
168	0.0006	0.00056314468383789	SELECT * FROM productoffers WHERE product_id = '4904' AND price > 0 ORDER BY price ASC LIMIT 1
169	0.0006	0.0006248950958252	SELECT value FROM productattributes WHERE product_id = '4904' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
170	0.0007	0.00073504447937012	SELECT * FROM products WHERE id = '1993'
171	0.0006	0.00064611434936523	SELECT * FROM productimages WHERE product_id = '1993' ORDER BY sortorder ASC
172	0.0010	0.001025915145874	SELECT * FROM product_image_select WHERE product_id = '1993'
173	0.0006	0.00057721138000488	SELECT * FROM productcustomimages WHERE product_id = '1993'
174	0.0017	0.0016660690307617	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1993' AND a.name = n.originalname
175	0.0007	0.00068497657775879	SELECT * FROM productoffers WHERE product_id = '1993' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0006	0.00057411193847656	SELECT * FROM productoffers WHERE product_id = '1993' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0005	0.00052905082702637	SELECT * FROM productoffers WHERE product_id = 1993 ORDER BY price ASC LIMIT 1
178	0.0006	0.00060415267944336	SELECT value FROM productattributes WHERE product_id = '1993' AND name = 'ListPriceAmount'
179	0.0007	0.00073790550231934	SELECT value FROM productattributes WHERE product_id = '1993' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180	0.0008	0.00076699256896973	SELECT * FROM products WHERE id = '2021'
181	0.0008	0.00081586837768555	SELECT * FROM productimages WHERE product_id = '2021' ORDER BY sortorder ASC
182	0.0010	0.0010039806365967	SELECT * FROM product_image_select WHERE product_id = '2021'
183	0.0005	0.00050616264343262	SELECT * FROM productcustomimages WHERE product_id = '2021'
184	0.0015	0.0015199184417725	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2021' AND a.name = n.originalname
185	0.0008	0.00078797340393066	SELECT * FROM productoffers WHERE product_id = '2021' AND merchantid = 'A1X6FK5RDHNB96'
186	0.0005	0.00045585632324219	SELECT * FROM productoffers WHERE product_id = '2021' AND price > 0 ORDER BY price ASC LIMIT 1
187	0.0005	0.00053095817565918	SELECT * FROM productoffers WHERE product_id = 2021 ORDER BY price ASC LIMIT 1
188	0.0005	0.00049901008605957	SELECT value FROM productattributes WHERE product_id = '2021' AND name = 'ListPriceAmount'
189	0.0005	0.00054717063903809	SELECT value FROM productattributes WHERE product_id = '2021' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
190	0.0006	0.00064706802368164	SELECT * FROM products WHERE id = '2134'
191	0.0006	0.00058078765869141	SELECT * FROM productimages WHERE product_id = '2134' ORDER BY sortorder ASC
192	0.0007	0.00070405006408691	SELECT * FROM product_image_select WHERE product_id = '2134'
193	0.0004	0.00042605400085449	SELECT * FROM productcustomimages WHERE product_id = '2134'
194	0.0017	0.001727819442749	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2134' AND a.name = n.originalname
195	0.0026	0.0026259422302246	SELECT * FROM productoffers WHERE product_id = '2134' AND merchantid = 'A1X6FK5RDHNB96'
196	0.0024	0.0023798942565918	SELECT * FROM productoffers WHERE product_id = '2134' AND price > 0 ORDER BY price ASC LIMIT 1
197	0.0024	0.0024199485778809	SELECT * FROM productoffers WHERE product_id = 2134 ORDER BY price ASC LIMIT 1
198	0.0016	0.0015890598297119	SELECT value FROM productattributes WHERE product_id = '2134' AND name = 'ListPriceAmount'
199	0.0005	0.00049209594726562	SELECT value FROM productattributes WHERE product_id = '2134' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200	0.0006	0.00060200691223145	SELECT * FROM products WHERE id = '2102'
201	0.0006	0.00058197975158691	SELECT * FROM productimages WHERE product_id = '2102' ORDER BY sortorder ASC
202	0.0007	0.00065398216247559	SELECT * FROM product_image_select WHERE product_id = '2102'
203	0.0004	0.00042510032653809	SELECT * FROM productcustomimages WHERE product_id = '2102'
204	0.0010	0.0010149478912354	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2102' AND a.name = n.originalname
205	0.0006	0.00056290626525879	SELECT * FROM productoffers WHERE product_id = '2102' AND merchantid = 'A1X6FK5RDHNB96'
206	0.0004	0.00044584274291992	SELECT * FROM productoffers WHERE product_id = '2102' AND price > 0 ORDER BY price ASC LIMIT 1
207	0.0005	0.00049400329589844	SELECT value FROM productattributes WHERE product_id = '2102' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208	0.0006	0.00061511993408203	SELECT * FROM products WHERE id = '2103'
209	0.0005	0.00045514106750488	SELECT * FROM productimages WHERE product_id = '2103' ORDER BY sortorder ASC
210	0.0005	0.00046586990356445	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2103' AND p.id = pi.product_id ORDER BY pi.sortorder
211	0.0007	0.00072693824768066	SELECT * FROM product_image_select WHERE product_id = '2103'
212	0.0005	0.0005028247833252	SELECT * FROM productcustomimages WHERE product_id = '2103'
213	0.0006	0.00056099891662598	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 = '2103' GROUP BY o.product_id
214	0.0007	0.00072503089904785	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 = '2103' GROUP BY n.displayname ORDER BY n.displayname DESC
215	0.0004	0.0004417896270752	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2103
216	0.0012	0.0012121200561523	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2103' AND a.name = n.originalname
217	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '2103' AND merchantid = 'A1X6FK5RDHNB96'
218	0.0007	0.00069284439086914	SELECT * FROM productoffers WHERE product_id = '2103' AND price > 0 ORDER BY price ASC LIMIT 1
219	0.0004	0.00035309791564941	SELECT * FROM productoffers WHERE product_id = 2103 ORDER BY price ASC LIMIT 1
220	0.0004	0.00040006637573242	SELECT value FROM productattributes WHERE product_id = '2103' AND name = 'ListPriceAmount'
221	0.0005	0.00046205520629883	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 = '2103' GROUP BY o.product_id
222	0.0007	0.00065302848815918	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 = '2103' GROUP BY n.displayname ORDER BY n.displayname DESC
223	0.0005	0.00045013427734375	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2103
224	0.0006	0.00061392784118652	SELECT value FROM productattributes WHERE product_id = '2103' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225	0.0005	0.00046300888061523	SELECT * FROM products WHERE parent_id = '2103'
226	0.0004	0.00041103363037109	SELECT * FROM products WHERE id = '2104'
227	0.0006	0.00056600570678711	SELECT * FROM productimages WHERE product_id = '2104' ORDER BY sortorder ASC
228	0.0007	0.00067806243896484	SELECT * FROM product_image_select WHERE product_id = '2104'
229	0.0005	0.00046205520629883	SELECT * FROM productcustomimages WHERE product_id = '2104'
230	0.0012	0.0011930465698242	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2104' AND a.name = n.originalname
231	0.0005	0.00047016143798828	SELECT * FROM productoffers WHERE product_id = '2104' AND merchantid = 'A1X6FK5RDHNB96'
232	0.0004	0.0004119873046875	SELECT * FROM productoffers WHERE product_id = '2104' AND price > 0 ORDER BY price ASC LIMIT 1
233	0.0004	0.00041913986206055	SELECT * FROM productoffers WHERE product_id = 2104 ORDER BY price ASC LIMIT 1
234	0.0004	0.00041484832763672	SELECT value FROM productattributes WHERE product_id = '2104' AND name = 'ListPriceAmount'
235	0.0005	0.00053882598876953	SELECT value FROM productattributes WHERE product_id = '2104' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236	0.0006	0.00057816505432129	SELECT * FROM products WHERE id = '2109'
237	0.0011	0.0011169910430908	SELECT * FROM productimages WHERE product_id = '2109' ORDER BY sortorder ASC
238	0.0007	0.00073599815368652	SELECT * FROM product_image_select WHERE product_id = '2109'
239	0.0004	0.00043392181396484	SELECT * FROM productcustomimages WHERE product_id = '2109'
240	0.0013	0.0012800693511963	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2109' AND a.name = n.originalname
241	0.0006	0.00060415267944336	SELECT * FROM productoffers WHERE product_id = '2109' AND merchantid = 'A1X6FK5RDHNB96'
242	0.0004	0.00037407875061035	SELECT * FROM productoffers WHERE product_id = '2109' AND price > 0 ORDER BY price ASC LIMIT 1
243	0.0004	0.00037908554077148	SELECT * FROM productoffers WHERE product_id = 2109 ORDER BY price ASC LIMIT 1
244	0.0004	0.00044488906860352	SELECT value FROM productattributes WHERE product_id = '2109' AND name = 'ListPriceAmount'
245	0.0005	0.00049901008605957	SELECT value FROM productattributes WHERE product_id = '2109' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
246	0.0007	0.00065708160400391	SELECT * FROM products WHERE id = '2518'
247	0.0006	0.00061988830566406	SELECT * FROM productimages WHERE product_id = '2518' ORDER BY sortorder ASC
248	0.0005	0.00050711631774902	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2518' AND p.id = pi.product_id ORDER BY pi.sortorder
249	0.0007	0.00070500373840332	SELECT * FROM product_image_select WHERE product_id = '2518'
250	0.0004	0.0004279613494873	SELECT * FROM productcustomimages WHERE product_id = '2518'
251	0.0007	0.00069999694824219	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 = '2518' GROUP BY o.product_id
252	0.0007	0.0007479190826416	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 = '2518' GROUP BY n.displayname ORDER BY n.displayname DESC
253	0.0005	0.00049686431884766	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
254	0.0013	0.0013449192047119	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2518' AND a.name = n.originalname
255	0.0004	0.00043702125549316	SELECT * FROM productoffers WHERE product_id = '2518' AND merchantid = 'A1X6FK5RDHNB96'
256	0.0004	0.00042200088500977	SELECT * FROM productoffers WHERE product_id = '2518' AND price > 0 ORDER BY price ASC LIMIT 1
257	0.0005	0.00046086311340332	SELECT * FROM productoffers WHERE product_id = 2518 ORDER BY price ASC LIMIT 1
258	0.0004	0.00041890144348145	SELECT value FROM productattributes WHERE product_id = '2518' AND name = 'ListPriceAmount'
259	0.0005	0.00054407119750977	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 = '2518' GROUP BY o.product_id
260	0.0007	0.00066208839416504	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 = '2518' GROUP BY n.displayname ORDER BY n.displayname DESC
261	0.0005	0.00051712989807129	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2518
262	0.0006	0.00062704086303711	SELECT value FROM productattributes WHERE product_id = '2518' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
263	0.0004	0.00041818618774414	SELECT * FROM products WHERE parent_id = '2518'
264	0.0005	0.00051021575927734	SELECT * FROM products WHERE id = '2183'
265	0.0005	0.00054407119750977	SELECT * FROM productimages WHERE product_id = '2183' ORDER BY sortorder ASC
266	0.0007	0.0006568431854248	SELECT * FROM product_image_select WHERE product_id = '2183'
267	0.0004	0.00042200088500977	SELECT * FROM productcustomimages WHERE product_id = '2183'
268	0.0012	0.0011758804321289	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2183' AND a.name = n.originalname
269	0.0005	0.00051116943359375	SELECT * FROM productoffers WHERE product_id = '2183' AND merchantid = 'A1X6FK5RDHNB96'
270	0.0004	0.00041794776916504	SELECT * FROM productoffers WHERE product_id = '2183' AND price > 0 ORDER BY price ASC LIMIT 1
271	0.0004	0.00038790702819824	SELECT * FROM productoffers WHERE product_id = 2183 ORDER BY price ASC LIMIT 1
272	0.0006	0.00056815147399902	SELECT value FROM productattributes WHERE product_id = '2183' AND name = 'ListPriceAmount'
273	0.0006	0.00055193901062012	SELECT value FROM productattributes WHERE product_id = '2183' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274	0.0006	0.00056099891662598	SELECT * FROM products WHERE id = '2290'
275	0.0005	0.00053596496582031	SELECT * FROM productimages WHERE product_id = '2290' ORDER BY sortorder ASC
276	0.0007	0.00065803527832031	SELECT * FROM product_image_select WHERE product_id = '2290'
277	0.0004	0.00042200088500977	SELECT * FROM productcustomimages WHERE product_id = '2290'
278	0.0011	0.001121997833252	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2290' AND a.name = n.originalname
279	0.0005	0.00050997734069824	SELECT * FROM productoffers WHERE product_id = '2290' AND merchantid = 'A1X6FK5RDHNB96'
280	0.0005	0.00046396255493164	SELECT * FROM productoffers WHERE product_id = '2290' AND price > 0 ORDER BY price ASC LIMIT 1
281	0.0005	0.00049400329589844	SELECT value FROM productattributes WHERE product_id = '2290' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282	0.0006	0.00058102607727051	SELECT * FROM products WHERE id = '2225'
283	0.0006	0.00055289268493652	SELECT * FROM productimages WHERE product_id = '2225' ORDER BY sortorder ASC
284	0.0007	0.00066709518432617	SELECT * FROM product_image_select WHERE product_id = '2225'
285	0.0004	0.00042200088500977	SELECT * FROM productcustomimages WHERE product_id = '2225'
286	0.0014	0.0014050006866455	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2225' AND a.name = n.originalname
287	0.0006	0.00059604644775391	SELECT * FROM productoffers WHERE product_id = '2225' AND merchantid = 'A1X6FK5RDHNB96'
288	0.0004	0.00038290023803711	SELECT * FROM productoffers WHERE product_id = '2225' AND price > 0 ORDER BY price ASC LIMIT 1
289	0.0004	0.00036501884460449	SELECT * FROM productoffers WHERE product_id = 2225 ORDER BY price ASC LIMIT 1
290	0.0004	0.00041294097900391	SELECT value FROM productattributes WHERE product_id = '2225' AND name = 'ListPriceAmount'
291	0.0005	0.00049686431884766	SELECT value FROM productattributes WHERE product_id = '2225' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
292	0.0006	0.00055480003356934	SELECT * FROM products WHERE id = '2235'
293	0.0005	0.00045299530029297	SELECT * FROM productimages WHERE product_id = '2235' ORDER BY sortorder ASC
294	0.0006	0.00063800811767578	SELECT * FROM product_image_select WHERE product_id = '2235'
295	0.0005	0.00046396255493164	SELECT * FROM productcustomimages WHERE product_id = '2235'
296	0.0010	0.00095796585083008	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2235' AND a.name = n.originalname
297	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '2235' AND merchantid = 'A1X6FK5RDHNB96'
298	0.0004	0.00040388107299805	SELECT * FROM productoffers WHERE product_id = '2235' AND price > 0 ORDER BY price ASC LIMIT 1
299	0.0003	0.00034809112548828	SELECT * FROM productoffers WHERE product_id = 2235 ORDER BY price ASC LIMIT 1
300	0.0004	0.00043797492980957	SELECT value FROM productattributes WHERE product_id = '2235' AND name = 'ListPriceAmount'
301	0.0005	0.00052809715270996	SELECT value FROM productattributes WHERE product_id = '2235' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
302	0.0005	0.00046801567077637	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2025' ORDER BY timestamp DESC
303	0.0003	0.00034189224243164	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1769' ORDER BY timestamp DESC
304	0.0003	0.00032687187194824	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1803' ORDER BY timestamp DESC
305	0.0003	0.00033092498779297	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2342' ORDER BY timestamp DESC
306	0.0003	0.00032591819763184	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1899' ORDER BY timestamp DESC
307	0.0003	0.00032401084899902	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4904' ORDER BY timestamp DESC
308	0.0003	0.0003199577331543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1993' ORDER BY timestamp DESC
309	0.0003	0.00031709671020508	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2021' ORDER BY timestamp DESC
310	0.0004	0.00037503242492676	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2134' ORDER BY timestamp DESC
311	0.0003	0.00034213066101074	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2102' ORDER BY timestamp DESC
312	0.0003	0.00030303001403809	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2103' ORDER BY timestamp DESC
313	0.0004	0.0003659725189209	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2104' ORDER BY timestamp DESC
314	0.0003	0.00033783912658691	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2109' ORDER BY timestamp DESC
315	0.0004	0.0003819465637207	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2518' ORDER BY timestamp DESC
316	0.0004	0.00036501884460449	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2183' ORDER BY timestamp DESC
317	0.0003	0.00033807754516602	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2290' ORDER BY timestamp DESC
318	0.0003	0.00033712387084961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2225' ORDER BY timestamp DESC
319	0.0003	0.00034904479980469	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2235' ORDER BY timestamp DESC
320	0.0005	0.00053501129150391	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
321	0.0005	0.00046992301940918	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
322	0.0004	0.00037312507629395	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
323	0.0172	0.017220020294189	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
324	0.0008	0.00081300735473633	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
325	0.0007	0.00070500373840332	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
326	0.0006	0.00061321258544922	SELECT * FROM products WHERE id = 1626
327	0.0005	0.00048708915710449	SELECT * FROM products WHERE id = 4041
328	0.0005	0.00052094459533691	SELECT * FROM products WHERE id = 4312
329	0.0005	0.00045609474182129	SELECT * FROM products WHERE id = 777
330	0.0005	0.0004880428314209	SELECT * FROM products WHERE id = 3881
331	0.0004	0.00044989585876465	SELECT * FROM products WHERE id = 4213
332	0.0005	0.00050497055053711	SELECT * FROM products WHERE id = '1626'
333	0.0006	0.00063085556030273	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
334	0.0007	0.00068402290344238	SELECT * FROM product_image_select WHERE product_id = '1626'
335	0.0005	0.00049901008605957	SELECT * FROM productcustomimages WHERE product_id = '1626'
336	0.0011	0.0011060237884521	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
337	0.0005	0.00054502487182617	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
338	0.0005	0.00046396255493164	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
339	0.0006	0.00059008598327637	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
340	0.0006	0.00059080123901367	SELECT * FROM products WHERE id = '4041'
341	0.0006	0.00055694580078125	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
342	0.0007	0.00074410438537598	SELECT * FROM product_image_select WHERE product_id = '4041'
343	0.0004	0.00043702125549316	SELECT * FROM productcustomimages WHERE product_id = '4041'
344	0.0014	0.0014438629150391	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
345	0.0006	0.00056099891662598	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
346	0.0005	0.00051403045654297	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
347	0.0005	0.00054097175598145	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
348	0.0005	0.00054407119750977	SELECT * FROM products WHERE id = '4312'
349	0.0007	0.00067496299743652	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
350	0.0007	0.00066614151000977	SELECT * FROM product_image_select WHERE product_id = '4312'
351	0.0004	0.00044894218444824	SELECT * FROM productcustomimages WHERE product_id = '4312'
352	0.0010	0.00098991394042969	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
353	0.0005	0.0005030632019043	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
354	0.0004	0.00044798851013184	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
355	0.0005	0.00047397613525391	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
356	0.0006	0.00057482719421387	SELECT * FROM products WHERE id = '777'
357	0.0006	0.00057601928710938	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
358	0.0007	0.00071907043457031	SELECT * FROM product_image_select WHERE product_id = '777'
359	0.0005	0.00050902366638184	SELECT * FROM productcustomimages WHERE product_id = '777'
360	0.0013	0.0012779235839844	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
361	0.0005	0.00053191184997559	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
362	0.0005	0.0004889965057373	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
363	0.0005	0.00048685073852539	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
364	0.0005	0.00049090385437012	SELECT * FROM products WHERE id = '3881'
365	0.0006	0.00060200691223145	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
366	0.0008	0.00077390670776367	SELECT * FROM product_image_select WHERE product_id = '3881'
367	0.0005	0.00048613548278809	SELECT * FROM productcustomimages WHERE product_id = '3881'
368	0.0014	0.0014331340789795	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
369	0.0005	0.00052285194396973	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
370	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
371	0.0006	0.00059819221496582	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
372	0.0006	0.00062203407287598	SELECT * FROM products WHERE id = '4213'
373	0.0006	0.00060009956359863	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
374	0.0007	0.0006868839263916	SELECT * FROM product_image_select WHERE product_id = '4213'
375	0.0004	0.00044488906860352	SELECT * FROM productcustomimages WHERE product_id = '4213'
376	0.0016	0.0015599727630615	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
377	0.0006	0.00056791305541992	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
378	0.0005	0.00048995018005371	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
379	0.0005	0.00051498413085938	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
380	0.0009	0.00087189674377441	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
381	0.0008	0.00081801414489746	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
382	0.0017	0.0016639232635498	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
383	0.0007	0.00068402290344238	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
384	0.0006	0.00059413909912109	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
385	0.0011	0.0010678768157959	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
386	0.0010	0.00095009803771973	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "4"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.356477022171 seconds

Query Debug - 386 Database Queries. Total time 1.1321 seconds