Search Results for "4"

boîte à thé, recouvert de papier de soie...

View to See Price

View

Add to Cart

Alice de la collection Boîte en bois ave...

View to See Price

View

Add to Cart

LUNA VOW Luna Vœu Japonais Céramique Boî...

View to See Price

View

Add to Cart

CARMANI - Motif inspiré de la nature, Co...

View to See Price

View

Add to Cart

Dragonfly Rooibos Breakfast Tea 40 per p...

View to See Price

View

Add to Cart

Elephant - The Rooibos Pomme Cannelle 40...

View to See Price

View

Add to Cart

Ocun Eternal Pants

View to See Price

View

Add to Cart

Neuf en bois Blanc 9 Compartiment Sachet...

View to See Price

View

Add to Cart

Elephant - The Rooibos Pomme Cannelle 40...

View to See Price

View

Add to Cart

Alter Éco - Thé Rooibos Au Caramel 40G -...

only €30,61

View

Add to Cart

Alter Éco - Thé Rooibos Bio 40G - Prix U...

only €28,51

View

Add to Cart

Mason Cash Authority Thé café Sucre Boît...

View to See Price

View

Add to Cart

Alter Éco - Thé Rooibos Bio 40G - Lot De...

View to See Price

View

Add to Cart

Alter Éco - Thé Rooibos Bio 40G - Lot De...

only €36,84

View

Add to Cart

Alter Éco - Thé Rooibos Au Caramel 40G -...

only €39,22

View

Add to Cart

GLQ Boîtes à thé/Boîtes métalliques Rond...

View to See Price

View

Add to Cart

SoBuy FRG259-N Boîte de rangement Boîte ...

View to See Price

View

Add to Cart

MK447B Boîte à thé en bambou 12 comparti...

View to See Price

View

Add to Cart

289 to 306 of 336 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.591295003891	387	1.1797	0

No Amazon API Requests Made.

App Debug - Total Time 1.591295003891 seconds

Number	Time From Start	Name	Description
1	0.39578700065613	Initialise	Initialise FSB Function
2	0.39881491661072	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.44896507263184	Start of getCategoryListByGroup Function	Before first category groups query
4	0.45008707046509	After initial query	Before first category groups query
5	0.4500880241394	Get Category List for Group	Before the call to getCategoryList function
6	0.45008993148804	Start of GetCategoryList function	Start of the function
7	0.45009303092957	Before getting categories	Query to get specific category list
8	0.45091891288757	After getting categories	Query to get specific category list
9	0.45092010498047	Before getting category custom	Before call to function getCategoryCustom
10	0.46611094474792	After getting category custom	After call to function getCategoryCustom
11	0.46611499786377	Before getting category custom	Before call to function getCategoryCustom
12	0.47498393058777	After getting category custom	After call to function getCategoryCustom
13	0.4749870300293	Before getting category custom	Before call to function getCategoryCustom
14	0.47969794273376	After getting category custom	After call to function getCategoryCustom
15	0.47970008850098	Before getting category custom	Before call to function getCategoryCustom
16	0.4828770160675	After getting category custom	After call to function getCategoryCustom
17	0.48287892341614	Before getting category custom	Before call to function getCategoryCustom
18	0.48621511459351	After getting category custom	After call to function getCategoryCustom
19	0.48621702194214	Before getting category custom	Before call to function getCategoryCustom
20	0.48941802978516	After getting category custom	After call to function getCategoryCustom
21	0.48941993713379	End of GetCategoryList function	End of the function
22	0.48942589759827	Get Category List for Group	Before the call to getCategoryList function
23	0.48942804336548	Start of GetCategoryList function	Start of the function
24	0.48942899703979	Before getting categories	Query to get specific category list
25	0.48984408378601	End of getCategoryListByGroup Function	Before return()
26	1.3321809768677	App Controller End	End of the App controller (called before the controller of every page)
27	1.5179359912872	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.5188820362091	Before Get Options	Before the call to getOptions in the tpl class
29	1.5693950653076	After Get Options	After the call to getOptions in the tpl class
30	1.5694210529327	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.5912868976593	Finalizing debug	Before the debug is output to the page.
32	1.5912940502167	End of App	This is the end of the app logging, final timestamp

Query Debug - 387 Database Queries. Total time 1.1797 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:12:\"216.73.217.7\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751357838'
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.217.7') >= INET_ATON(ip_start) AND INET_ATON('216.73.217.7') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'search'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '216.73.217.7'
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 = '3124'
SELECT * FROM productimages WHERE product_id = '3124' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3124'
SELECT * FROM productcustomimages WHERE product_id = '3124'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3124' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3124' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3124' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3124
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3124'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3124' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3129'
SELECT * FROM productimages WHERE product_id = '3129' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3129'
SELECT * FROM productcustomimages WHERE product_id = '3129'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3129' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3129' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3129' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3129
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3129'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3129' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3175'
SELECT * FROM productimages WHERE product_id = '3175' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3175'
SELECT * FROM productcustomimages WHERE product_id = '3175'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3175' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3175' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3175' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3175
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3175'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3601'
SELECT * FROM productimages WHERE product_id = '3601' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3601'
SELECT * FROM productcustomimages WHERE product_id = '3601'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3601' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3601' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3601' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3601
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3601'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3252'
SELECT * FROM productimages WHERE product_id = '3252' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3252'
SELECT * FROM productcustomimages WHERE product_id = '3252'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3252' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3252' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3252' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3252
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3252'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3590'
SELECT * FROM productimages WHERE product_id = '3590' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3590'
SELECT * FROM productcustomimages WHERE product_id = '3590'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3590' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3590' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3590' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3590
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3590'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3590' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3434'
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3434'
SELECT * FROM productcustomimages WHERE product_id = '3434'
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 = '3434'
                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     = '3434'
                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 = 3434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3434'
                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 = '3434'
                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     = '3434'
                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 = 3434
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '3472'
SELECT * FROM productimages WHERE product_id = '3472' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3472'
SELECT * FROM productcustomimages WHERE product_id = '3472'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3472' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3472' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3472' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3472
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3472'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3523'
SELECT * FROM productimages WHERE product_id = '3523' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3523' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3523'
SELECT * FROM productcustomimages WHERE product_id = '3523'
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 = '3523'
                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     = '3523'
                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 = 3523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3523' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3523' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3523' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3523
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3523'
                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 = '3523'
                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     = '3523'
                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 = 3523
SELECT value FROM productattributes WHERE product_id = '3523' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '3523'
SELECT * FROM products WHERE id = '3524'
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3524'
SELECT * FROM productcustomimages WHERE product_id = '3524'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3524' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3525'
SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3525'
SELECT * FROM productcustomimages WHERE product_id = '3525'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3525' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3856'
SELECT * FROM productimages WHERE product_id = '3856' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3856'
SELECT * FROM productcustomimages WHERE product_id = '3856'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3856' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3856' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3856' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3856
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3856'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3856' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3578'
SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3578'
SELECT * FROM productcustomimages WHERE product_id = '3578'
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 = '3578'
                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     = '3578'
                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 = 3578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3578' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3578
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3578'
                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 = '3578'
                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     = '3578'
                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 = 3578
SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '3578'
SELECT * FROM products WHERE id = '3587'
SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3587'
SELECT * FROM productcustomimages WHERE product_id = '3587'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3588'
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3588'
SELECT * FROM productcustomimages WHERE product_id = '3588'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3600'
SELECT * FROM productimages WHERE product_id = '3600' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3600'
SELECT * FROM productcustomimages WHERE product_id = '3600'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3600' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3600' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3600' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3600
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3600'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3738'
SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3738'
SELECT * FROM productcustomimages WHERE product_id = '3738'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3738' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3738
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3738'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3623'
SELECT * FROM productimages WHERE product_id = '3623' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3623'
SELECT * FROM productcustomimages WHERE product_id = '3623'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3623' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3623' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3623' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3623
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3623'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3623' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3124' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3129' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3175' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3601' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3252' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3590' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3472' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3523' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3524' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3525' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3856' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3578' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3587' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3588' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3600' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3623' 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.0015	0.0014500617980957	SELECT parameter, value FROM parameters
2	0.0054	0.0054390430450439	SELECT * FROM `bad_bots`
3	0.0003	0.00028610229492188	SET time_zone = 'Europe/London'
4	0.0014	0.0013630390167236	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0014	0.0013759136199951	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"216.73.217.7\";}'
6	0.0014	0.0014150142669678	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751357838'
7	0.0016	0.0016498565673828	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0005	0.00050902366638184	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0015	0.001453161239624	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10	0.0004	0.00041294097900391	SELECT * FROM pages WHERE id = 52
11	0.0031	0.0030701160430908	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0460	0.046046018600464	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0005	0.00053215026855469	SELECT * FROM pages WHERE pagename = 'search'
14	0.0011	0.0011119842529297	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0008	0.00081014633178711	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0056	0.0056009292602539	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.0010	0.0010008811950684	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.0007	0.00067901611328125	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0003	0.00033402442932129	SELECT id FROM categories WHERE parent_id = '26'
20	0.0047	0.0046811103820801	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.0009	0.00092005729675293	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.0008	0.00078701972961426	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.0008	0.00076985359191895	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0003	0.0003049373626709	SELECT * FROM categorygroups WHERE id = '1'
25	0.0032	0.0031521320343018	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.0004	0.0003819465637207	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.0003	0.00028419494628906	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0003	0.00032711029052734	SELECT id FROM categories WHERE parent_id = '27'
29	0.0033	0.0032799243927002	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.0004	0.00036406517028809	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.0004	0.00037693977355957	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.0003	0.0003201961517334	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0003	0.00030398368835449	SELECT * FROM categorygroups WHERE id = '1'
34	0.0011	0.0011420249938965	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.0003	0.0003209114074707	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.0003	0.00028705596923828	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0003	0.00030207633972168	SELECT id FROM categories WHERE parent_id = '28'
38	0.0012	0.0012390613555908	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.0004	0.00035214424133301	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.0004	0.00036311149597168	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.0003	0.00033307075500488	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0003	0.00030112266540527	SELECT * FROM categorygroups WHERE id = '1'
43	0.0004	0.00040197372436523	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.0003	0.00031089782714844	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.0003	0.00028419494628906	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0003	0.00029993057250977	SELECT id FROM categories WHERE parent_id = '29'
47	0.0005	0.00046706199645996	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.0003	0.00033998489379883	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.0004	0.00037407875061035	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.0003	0.00034594535827637	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0003	0.00029397010803223	SELECT * FROM categorygroups WHERE id = '1'
52	0.0004	0.00041890144348145	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.0003	0.00031399726867676	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.0003	0.00033116340637207	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0003	0.00034093856811523	SELECT id FROM categories WHERE parent_id = '30'
56	0.0005	0.00049901008605957	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.0004	0.00037288665771484	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.0004	0.00037002563476562	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.0003	0.00032711029052734	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0003	0.00029897689819336	SELECT * FROM categorygroups WHERE id = '1'
61	0.0004	0.00042510032653809	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.0003	0.00032210350036621	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.0003	0.0002739429473877	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0003	0.00032305717468262	SELECT id FROM categories WHERE parent_id = '31'
65	0.0005	0.00051283836364746	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.0003	0.00032901763916016	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.0003	0.00033903121948242	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.0003	0.00031614303588867	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0003	0.00029611587524414	SELECT * FROM categorygroups WHERE id = '1'
70	0.0004	0.00039815902709961	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0018	0.0018489360809326	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0008	0.00081992149353027	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0004	0.00038981437683105	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.0006	0.00061583518981934	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0009	0.0009000301361084	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0006	0.00058984756469727	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.8336	0.83359408378601	SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.217.7') >= INET_ATON(ip_start) AND INET_ATON('216.73.217.7') <= INET_ATON(ip_end)
78	0.0014	0.00136399269104	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0007	0.0006568431854248	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0003	0.00034213066101074	SELECT * FROM pages WHERE pagename = 'search'
81	0.0055	0.0055320262908936	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82	0.0013	0.0013470649719238	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83	0.0009	0.00088715553283691	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
84	0.0052	0.0052289962768555	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0016	0.0016319751739502	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0005	0.00050091743469238	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
87	0.0010	0.0010340213775635	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '216.73.217.7'
88	0.0005	0.00053215026855469	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
89	0.0013	0.0012848377227783	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
90	0.0078	0.0078461170196533	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
91	0.0007	0.00070619583129883	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
92	0.0006	0.00055813789367676	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
93	0.0006	0.00058388710021973	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
94	0.0090	0.0090060234069824	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
95	0.0004	0.00035810470581055	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
96	0.0003	0.00030612945556641	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
97	0.0006	0.00056791305541992	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
98	0.0006	0.00055503845214844	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
99	0.0075	0.0075311660766602	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
100	0.0004	0.00037884712219238	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
101	0.0003	0.00031685829162598	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
102	0.0005	0.00054001808166504	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
103	0.0088	0.0088441371917725	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
104	0.0004	0.0003659725189209	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
105	0.0009	0.00089287757873535	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
106	0.0004	0.00042605400085449	SELECT * FROM products WHERE id = '3124'
107	0.0028	0.0027790069580078	SELECT * FROM productimages WHERE product_id = '3124' ORDER BY sortorder ASC
108	0.0018	0.0017831325531006	SELECT * FROM product_image_select WHERE product_id = '3124'
109	0.0014	0.0013577938079834	SELECT * FROM productcustomimages WHERE product_id = '3124'
110	0.0030	0.0029749870300293	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3124' AND a.name = n.originalname
111	0.0017	0.0017468929290771	SELECT * FROM productoffers WHERE product_id = '3124' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0004	0.00044512748718262	SELECT * FROM productoffers WHERE product_id = '3124' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0004	0.00037503242492676	SELECT * FROM productoffers WHERE product_id = 3124 ORDER BY price ASC LIMIT 1
114	0.0009	0.00088000297546387	SELECT value FROM productattributes WHERE product_id = '3124' AND name = 'ListPriceAmount'
115	0.0006	0.00058221817016602	SELECT value FROM productattributes WHERE product_id = '3124' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
116	0.0007	0.00073099136352539	SELECT * FROM products WHERE id = '3129'
117	0.0006	0.00061917304992676	SELECT * FROM productimages WHERE product_id = '3129' ORDER BY sortorder ASC
118	0.0009	0.00090599060058594	SELECT * FROM product_image_select WHERE product_id = '3129'
119	0.0004	0.00044512748718262	SELECT * FROM productcustomimages WHERE product_id = '3129'
120	0.0015	0.0015051364898682	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3129' AND a.name = n.originalname
121	0.0005	0.00052690505981445	SELECT * FROM productoffers WHERE product_id = '3129' AND merchantid = 'A1X6FK5RDHNB96'
122	0.0004	0.0004429817199707	SELECT * FROM productoffers WHERE product_id = '3129' AND price > 0 ORDER BY price ASC LIMIT 1
123	0.0004	0.00043487548828125	SELECT * FROM productoffers WHERE product_id = 3129 ORDER BY price ASC LIMIT 1
124	0.0005	0.00053906440734863	SELECT value FROM productattributes WHERE product_id = '3129' AND name = 'ListPriceAmount'
125	0.0005	0.00053310394287109	SELECT value FROM productattributes WHERE product_id = '3129' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126	0.0007	0.00069594383239746	SELECT * FROM products WHERE id = '3175'
127	0.0008	0.00083279609680176	SELECT * FROM productimages WHERE product_id = '3175' ORDER BY sortorder ASC
128	0.0010	0.00096797943115234	SELECT * FROM product_image_select WHERE product_id = '3175'
129	0.0005	0.00049686431884766	SELECT * FROM productcustomimages WHERE product_id = '3175'
130	0.0022	0.0021750926971436	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3175' AND a.name = n.originalname
131	0.0006	0.00060200691223145	SELECT * FROM productoffers WHERE product_id = '3175' AND merchantid = 'A1X6FK5RDHNB96'
132	0.0005	0.00045108795166016	SELECT * FROM productoffers WHERE product_id = '3175' AND price > 0 ORDER BY price ASC LIMIT 1
133	0.0004	0.00036501884460449	SELECT * FROM productoffers WHERE product_id = 3175 ORDER BY price ASC LIMIT 1
134	0.0005	0.00046110153198242	SELECT value FROM productattributes WHERE product_id = '3175' AND name = 'ListPriceAmount'
135	0.0004	0.00044703483581543	SELECT value FROM productattributes WHERE product_id = '3175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
136	0.0006	0.0006248950958252	SELECT * FROM products WHERE id = '3601'
137	0.0005	0.00054192543029785	SELECT * FROM productimages WHERE product_id = '3601' ORDER BY sortorder ASC
138	0.0009	0.00094699859619141	SELECT * FROM product_image_select WHERE product_id = '3601'
139	0.0006	0.00060486793518066	SELECT * FROM productcustomimages WHERE product_id = '3601'
140	0.0021	0.00205397605896	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3601' AND a.name = n.originalname
141	0.0006	0.00057291984558105	SELECT * FROM productoffers WHERE product_id = '3601' AND merchantid = 'A1X6FK5RDHNB96'
142	0.0004	0.00041580200195312	SELECT * FROM productoffers WHERE product_id = '3601' AND price > 0 ORDER BY price ASC LIMIT 1
143	0.0005	0.00052690505981445	SELECT * FROM productoffers WHERE product_id = 3601 ORDER BY price ASC LIMIT 1
144	0.0005	0.00052905082702637	SELECT value FROM productattributes WHERE product_id = '3601' AND name = 'ListPriceAmount'
145	0.0005	0.00050997734069824	SELECT value FROM productattributes WHERE product_id = '3601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146	0.0011	0.0010650157928467	SELECT * FROM products WHERE id = '3252'
147	0.0006	0.00057196617126465	SELECT * FROM productimages WHERE product_id = '3252' ORDER BY sortorder ASC
148	0.0009	0.0008997917175293	SELECT * FROM product_image_select WHERE product_id = '3252'
149	0.0005	0.00046086311340332	SELECT * FROM productcustomimages WHERE product_id = '3252'
150	0.0011	0.0011389255523682	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3252' AND a.name = n.originalname
151	0.0005	0.00052499771118164	SELECT * FROM productoffers WHERE product_id = '3252' AND merchantid = 'A1X6FK5RDHNB96'
152	0.0010	0.00098180770874023	SELECT * FROM productoffers WHERE product_id = '3252' AND price > 0 ORDER BY price ASC LIMIT 1
153	0.0004	0.00039887428283691	SELECT * FROM productoffers WHERE product_id = 3252 ORDER BY price ASC LIMIT 1
154	0.0004	0.00040507316589355	SELECT value FROM productattributes WHERE product_id = '3252' AND name = 'ListPriceAmount'
155	0.0004	0.00043296813964844	SELECT value FROM productattributes WHERE product_id = '3252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
156	0.0006	0.00059819221496582	SELECT * FROM products WHERE id = '3590'
157	0.0006	0.00060200691223145	SELECT * FROM productimages WHERE product_id = '3590' ORDER BY sortorder ASC
158	0.0011	0.0011169910430908	SELECT * FROM product_image_select WHERE product_id = '3590'
159	0.0009	0.00091099739074707	SELECT * FROM productcustomimages WHERE product_id = '3590'
160	0.0021	0.0020999908447266	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3590' AND a.name = n.originalname
161	0.0006	0.00061202049255371	SELECT * FROM productoffers WHERE product_id = '3590' AND merchantid = 'A1X6FK5RDHNB96'
162	0.0004	0.00042009353637695	SELECT * FROM productoffers WHERE product_id = '3590' AND price > 0 ORDER BY price ASC LIMIT 1
163	0.0004	0.00037598609924316	SELECT * FROM productoffers WHERE product_id = 3590 ORDER BY price ASC LIMIT 1
164	0.0005	0.00047802925109863	SELECT value FROM productattributes WHERE product_id = '3590' AND name = 'ListPriceAmount'
165	0.0006	0.00056099891662598	SELECT value FROM productattributes WHERE product_id = '3590' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
166	0.0007	0.00069117546081543	SELECT * FROM products WHERE id = '3434'
167	0.0012	0.0011570453643799	SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
168	0.0012	0.0011658668518066	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
169	0.0009	0.00092911720275879	SELECT * FROM product_image_select WHERE product_id = '3434'
170	0.0005	0.00047707557678223	SELECT * FROM productcustomimages WHERE product_id = '3434'
171	0.0009	0.00093913078308105	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 = '3434' GROUP BY o.product_id
172	0.0040	0.0040378570556641	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 = '3434' GROUP BY n.displayname ORDER BY n.displayname DESC
173	0.0008	0.00080513954162598	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
174	0.0018	0.0017960071563721	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
175	0.0005	0.0004730224609375	SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
176	0.0004	0.00041413307189941	SELECT * FROM productoffers WHERE product_id = '3434' AND price > 0 ORDER BY price ASC LIMIT 1
177	0.0004	0.00043416023254395	SELECT * FROM productoffers WHERE product_id = 3434 ORDER BY price ASC LIMIT 1
178	0.0004	0.00043702125549316	SELECT value FROM productattributes WHERE product_id = '3434' AND name = 'ListPriceAmount'
179	0.0006	0.00064992904663086	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 = '3434' GROUP BY o.product_id
180	0.0018	0.0017540454864502	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 = '3434' GROUP BY n.displayname ORDER BY n.displayname DESC
181	0.0007	0.00070285797119141	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
182	0.0007	0.00065898895263672	SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183	0.0012	0.001194953918457	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3434' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
184	0.0011	0.0011281967163086	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3434' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
185	0.0004	0.00042104721069336	SELECT * FROM products WHERE id = '3472'
186	0.0006	0.00057888031005859	SELECT * FROM productimages WHERE product_id = '3472' ORDER BY sortorder ASC
187	0.0009	0.00092387199401855	SELECT * FROM product_image_select WHERE product_id = '3472'
188	0.0005	0.00045013427734375	SELECT * FROM productcustomimages WHERE product_id = '3472'
189	0.0015	0.0015199184417725	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3472' AND a.name = n.originalname
190	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '3472' AND merchantid = 'A1X6FK5RDHNB96'
191	0.0004	0.00040411949157715	SELECT * FROM productoffers WHERE product_id = '3472' AND price > 0 ORDER BY price ASC LIMIT 1
192	0.0004	0.00035595893859863	SELECT * FROM productoffers WHERE product_id = 3472 ORDER BY price ASC LIMIT 1
193	0.0004	0.00040316581726074	SELECT value FROM productattributes WHERE product_id = '3472' AND name = 'ListPriceAmount'
194	0.0004	0.0004420280456543	SELECT value FROM productattributes WHERE product_id = '3472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195	0.0006	0.00058078765869141	SELECT * FROM products WHERE id = '3523'
196	0.0007	0.00068783760070801	SELECT * FROM productimages WHERE product_id = '3523' ORDER BY sortorder ASC
197	0.0005	0.00050783157348633	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3523' AND p.id = pi.product_id ORDER BY pi.sortorder
198	0.0010	0.00095796585083008	SELECT * FROM product_image_select WHERE product_id = '3523'
199	0.0005	0.0004570484161377	SELECT * FROM productcustomimages WHERE product_id = '3523'
200	0.0006	0.00060009956359863	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 = '3523' GROUP BY o.product_id
201	0.0007	0.00069308280944824	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 = '3523' GROUP BY n.displayname ORDER BY n.displayname DESC
202	0.0004	0.00039410591125488	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3523
203	0.0011	0.00111985206604	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3523' AND a.name = n.originalname
204	0.0004	0.00044894218444824	SELECT * FROM productoffers WHERE product_id = '3523' AND merchantid = 'A1X6FK5RDHNB96'
205	0.0003	0.00034713745117188	SELECT * FROM productoffers WHERE product_id = '3523' AND price > 0 ORDER BY price ASC LIMIT 1
206	0.0003	0.00030708312988281	SELECT * FROM productoffers WHERE product_id = 3523 ORDER BY price ASC LIMIT 1
207	0.0004	0.00044012069702148	SELECT value FROM productattributes WHERE product_id = '3523' AND name = 'ListPriceAmount'
208	0.0004	0.00041699409484863	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 = '3523' GROUP BY o.product_id
209	0.0007	0.00066995620727539	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 = '3523' GROUP BY n.displayname ORDER BY n.displayname DESC
210	0.0005	0.00045108795166016	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3523
211	0.0006	0.00062799453735352	SELECT value FROM productattributes WHERE product_id = '3523' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
212	0.0004	0.00037288665771484	SELECT * FROM products WHERE parent_id = '3523'
213	0.0004	0.00036406517028809	SELECT * FROM products WHERE id = '3524'
214	0.0005	0.00051712989807129	SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
215	0.0008	0.00080394744873047	SELECT * FROM product_image_select WHERE product_id = '3524'
216	0.0004	0.00038886070251465	SELECT * FROM productcustomimages WHERE product_id = '3524'
217	0.0011	0.0011329650878906	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
218	0.0006	0.00055313110351562	SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
219	0.0006	0.00055193901062012	SELECT * FROM productoffers WHERE product_id = '3524' AND price > 0 ORDER BY price ASC LIMIT 1
220	0.0005	0.00047898292541504	SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221	0.0006	0.00055599212646484	SELECT * FROM products WHERE id = '3525'
222	0.0006	0.00059199333190918	SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
223	0.0009	0.00088906288146973	SELECT * FROM product_image_select WHERE product_id = '3525'
224	0.0004	0.00043702125549316	SELECT * FROM productcustomimages WHERE product_id = '3525'
225	0.0011	0.0010600090026855	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
226	0.0004	0.0003669261932373	SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
227	0.0003	0.00029087066650391	SELECT * FROM productoffers WHERE product_id = '3525' AND price > 0 ORDER BY price ASC LIMIT 1
228	0.0003	0.00029301643371582	SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229	0.0003	0.00034189224243164	SELECT * FROM products WHERE id = '3856'
230	0.0003	0.00030899047851562	SELECT * FROM productimages WHERE product_id = '3856' ORDER BY sortorder ASC
231	0.0004	0.00043797492980957	SELECT * FROM product_image_select WHERE product_id = '3856'
232	0.0003	0.00026202201843262	SELECT * FROM productcustomimages WHERE product_id = '3856'
233	0.0007	0.00073409080505371	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3856' AND a.name = n.originalname
234	0.0003	0.00029683113098145	SELECT * FROM productoffers WHERE product_id = '3856' AND merchantid = 'A1X6FK5RDHNB96'
235	0.0003	0.00026202201843262	SELECT * FROM productoffers WHERE product_id = '3856' AND price > 0 ORDER BY price ASC LIMIT 1
236	0.0002	0.00022983551025391	SELECT * FROM productoffers WHERE product_id = 3856 ORDER BY price ASC LIMIT 1
237	0.0002	0.00024890899658203	SELECT value FROM productattributes WHERE product_id = '3856' AND name = 'ListPriceAmount'
238	0.0003	0.00027108192443848	SELECT value FROM productattributes WHERE product_id = '3856' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
239	0.0004	0.00037693977355957	SELECT * FROM products WHERE id = '3578'
240	0.0003	0.00031399726867676	SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
241	0.0003	0.00025606155395508	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
242	0.0004	0.00043082237243652	SELECT * FROM product_image_select WHERE product_id = '3578'
243	0.0003	0.00027585029602051	SELECT * FROM productcustomimages WHERE product_id = '3578'
244	0.0003	0.00032782554626465	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 = '3578' GROUP BY o.product_id
245	0.0004	0.0003659725189209	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 = '3578' GROUP BY n.displayname ORDER BY n.displayname DESC
246	0.0002	0.00023722648620605	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
247	0.0005	0.00054192543029785	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
248	0.0003	0.00025796890258789	SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
249	0.0002	0.00024104118347168	SELECT * FROM productoffers WHERE product_id = '3578' AND price > 0 ORDER BY price ASC LIMIT 1
250	0.0002	0.00022697448730469	SELECT * FROM productoffers WHERE product_id = 3578 ORDER BY price ASC LIMIT 1
251	0.0002	0.00023388862609863	SELECT value FROM productattributes WHERE product_id = '3578' AND name = 'ListPriceAmount'
252	0.0003	0.00025105476379395	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 = '3578' GROUP BY o.product_id
253	0.0004	0.00036001205444336	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 = '3578' GROUP BY n.displayname ORDER BY n.displayname DESC
254	0.0002	0.00024008750915527	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
255	0.0003	0.00032520294189453	SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
256	0.0002	0.000244140625	SELECT * FROM products WHERE parent_id = '3578'
257	0.0003	0.00026512145996094	SELECT * FROM products WHERE id = '3587'
258	0.0003	0.00033283233642578	SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
259	0.0004	0.00043702125549316	SELECT * FROM product_image_select WHERE product_id = '3587'
260	0.0003	0.0002598762512207	SELECT * FROM productcustomimages WHERE product_id = '3587'
261	0.0006	0.00055909156799316	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
262	0.0003	0.00030684471130371	SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
263	0.0003	0.0002589225769043	SELECT * FROM productoffers WHERE product_id = '3587' AND price > 0 ORDER BY price ASC LIMIT 1
264	0.0003	0.00028514862060547	SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265	0.0003	0.00034999847412109	SELECT * FROM products WHERE id = '3588'
266	0.0003	0.00032496452331543	SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
267	0.0004	0.0004420280456543	SELECT * FROM product_image_select WHERE product_id = '3588'
268	0.0003	0.00027918815612793	SELECT * FROM productcustomimages WHERE product_id = '3588'
269	0.0005	0.00054717063903809	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
270	0.0003	0.00030899047851562	SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
271	0.0003	0.00033998489379883	SELECT * FROM productoffers WHERE product_id = '3588' AND price > 0 ORDER BY price ASC LIMIT 1
272	0.0003	0.00030779838562012	SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
273	0.0003	0.00034093856811523	SELECT * FROM products WHERE id = '3600'
274	0.0003	0.00034499168395996	SELECT * FROM productimages WHERE product_id = '3600' ORDER BY sortorder ASC
275	0.0004	0.00042390823364258	SELECT * FROM product_image_select WHERE product_id = '3600'
276	0.0003	0.0002899169921875	SELECT * FROM productcustomimages WHERE product_id = '3600'
277	0.0006	0.0005500316619873	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3600' AND a.name = n.originalname
278	0.0003	0.00030207633972168	SELECT * FROM productoffers WHERE product_id = '3600' AND merchantid = 'A1X6FK5RDHNB96'
279	0.0002	0.0002288818359375	SELECT * FROM productoffers WHERE product_id = '3600' AND price > 0 ORDER BY price ASC LIMIT 1
280	0.0002	0.00022482872009277	SELECT * FROM productoffers WHERE product_id = 3600 ORDER BY price ASC LIMIT 1
281	0.0002	0.00023794174194336	SELECT value FROM productattributes WHERE product_id = '3600' AND name = 'ListPriceAmount'
282	0.0003	0.00025320053100586	SELECT value FROM productattributes WHERE product_id = '3600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
283	0.0003	0.00030779838562012	SELECT * FROM products WHERE id = '3738'
284	0.0004	0.00036191940307617	SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
285	0.0004	0.00042891502380371	SELECT * FROM product_image_select WHERE product_id = '3738'
286	0.0003	0.00025200843811035	SELECT * FROM productcustomimages WHERE product_id = '3738'
287	0.0007	0.00067806243896484	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
288	0.0003	0.00029087066650391	SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
289	0.0002	0.00023078918457031	SELECT * FROM productoffers WHERE product_id = '3738' AND price > 0 ORDER BY price ASC LIMIT 1
290	0.0002	0.00021100044250488	SELECT * FROM productoffers WHERE product_id = 3738 ORDER BY price ASC LIMIT 1
291	0.0002	0.00022697448730469	SELECT value FROM productattributes WHERE product_id = '3738' AND name = 'ListPriceAmount'
292	0.0002	0.00024509429931641	SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
293	0.0003	0.00032687187194824	SELECT * FROM products WHERE id = '3623'
294	0.0003	0.00029802322387695	SELECT * FROM productimages WHERE product_id = '3623' ORDER BY sortorder ASC
295	0.0004	0.00043392181396484	SELECT * FROM product_image_select WHERE product_id = '3623'
296	0.0003	0.00026893615722656	SELECT * FROM productcustomimages WHERE product_id = '3623'
297	0.0005	0.00051999092102051	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3623' AND a.name = n.originalname
298	0.0003	0.00028896331787109	SELECT * FROM productoffers WHERE product_id = '3623' AND merchantid = 'A1X6FK5RDHNB96'
299	0.0002	0.00023102760314941	SELECT * FROM productoffers WHERE product_id = '3623' AND price > 0 ORDER BY price ASC LIMIT 1
300	0.0002	0.00022292137145996	SELECT * FROM productoffers WHERE product_id = 3623 ORDER BY price ASC LIMIT 1
301	0.0002	0.00024199485778809	SELECT value FROM productattributes WHERE product_id = '3623' AND name = 'ListPriceAmount'
302	0.0003	0.00025796890258789	SELECT value FROM productattributes WHERE product_id = '3623' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
303	0.0009	0.00088405609130859	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3124' ORDER BY timestamp DESC
304	0.0002	0.00022292137145996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3129' ORDER BY timestamp DESC
305	0.0003	0.00033092498779297	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3175' ORDER BY timestamp DESC
306	0.0004	0.0003669261932373	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3601' ORDER BY timestamp DESC
307	0.0002	0.00019383430480957	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3252' ORDER BY timestamp DESC
308	0.0002	0.00023007392883301	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3590' ORDER BY timestamp DESC
309	0.0002	0.00019311904907227	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
310	0.0002	0.00018501281738281	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3472' ORDER BY timestamp DESC
311	0.0002	0.0002140998840332	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3523' ORDER BY timestamp DESC
312	0.0002	0.00018715858459473	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3524' ORDER BY timestamp DESC
313	0.0002	0.00020003318786621	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3525' ORDER BY timestamp DESC
314	0.0002	0.00018692016601562	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3856' ORDER BY timestamp DESC
315	0.0002	0.00018596649169922	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3578' ORDER BY timestamp DESC
316	0.0002	0.00018882751464844	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3587' ORDER BY timestamp DESC
317	0.0002	0.00019001960754395	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3588' ORDER BY timestamp DESC
318	0.0002	0.0001981258392334	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3600' ORDER BY timestamp DESC
319	0.0002	0.00019693374633789	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
320	0.0002	0.00018787384033203	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3623' ORDER BY timestamp DESC
321	0.0014	0.0013511180877686	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
322	0.0007	0.00066304206848145	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
323	0.0002	0.00024986267089844	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
324	0.0172	0.017227172851562	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
325	0.0016	0.0015900135040283	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
326	0.0006	0.00056290626525879	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
327	0.0005	0.00049591064453125	SELECT * FROM products WHERE id = 1626
328	0.0003	0.00028705596923828	SELECT * FROM products WHERE id = 4041
329	0.0003	0.0002589225769043	SELECT * FROM products WHERE id = 4312
330	0.0003	0.00025320053100586	SELECT * FROM products WHERE id = 777
331	0.0003	0.00029397010803223	SELECT * FROM products WHERE id = 3881
332	0.0003	0.00025296211242676	SELECT * FROM products WHERE id = 4213
333	0.0002	0.00024604797363281	SELECT * FROM products WHERE id = '1626'
334	0.0003	0.00034499168395996	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
335	0.0005	0.00045394897460938	SELECT * FROM product_image_select WHERE product_id = '1626'
336	0.0003	0.00028491020202637	SELECT * FROM productcustomimages WHERE product_id = '1626'
337	0.0006	0.00056886672973633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
338	0.0003	0.00031208992004395	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
339	0.0003	0.00027179718017578	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
340	0.0003	0.00027799606323242	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
341	0.0003	0.00034785270690918	SELECT * FROM products WHERE id = '4041'
342	0.0003	0.00029611587524414	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
343	0.0006	0.00056099891662598	SELECT * FROM product_image_select WHERE product_id = '4041'
344	0.0003	0.00029993057250977	SELECT * FROM productcustomimages WHERE product_id = '4041'
345	0.0009	0.00093889236450195	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
346	0.0003	0.0003201961517334	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
347	0.0003	0.00027608871459961	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
348	0.0003	0.00026893615722656	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
349	0.0004	0.00038599967956543	SELECT * FROM products WHERE id = '4312'
350	0.0005	0.00048995018005371	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
351	0.0004	0.00044417381286621	SELECT * FROM product_image_select WHERE product_id = '4312'
352	0.0003	0.00026416778564453	SELECT * FROM productcustomimages WHERE product_id = '4312'
353	0.0007	0.00068998336791992	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
354	0.0003	0.00030803680419922	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
355	0.0003	0.0002589225769043	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
356	0.0003	0.00028395652770996	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
357	0.0003	0.00034308433532715	SELECT * FROM products WHERE id = '777'
358	0.0003	0.00032687187194824	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
359	0.0004	0.00044393539428711	SELECT * FROM product_image_select WHERE product_id = '777'
360	0.0003	0.00027298927307129	SELECT * FROM productcustomimages WHERE product_id = '777'
361	0.0007	0.00066089630126953	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
362	0.0003	0.0003049373626709	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
363	0.0003	0.00026702880859375	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
364	0.0003	0.00027608871459961	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
365	0.0003	0.00033402442932129	SELECT * FROM products WHERE id = '3881'
366	0.0003	0.00033903121948242	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
367	0.0005	0.00047111511230469	SELECT * FROM product_image_select WHERE product_id = '3881'
368	0.0003	0.0003049373626709	SELECT * FROM productcustomimages WHERE product_id = '3881'
369	0.0007	0.00069093704223633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
370	0.0003	0.00032711029052734	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
371	0.0003	0.00025796890258789	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
372	0.0003	0.00026106834411621	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
373	0.0003	0.00032496452331543	SELECT * FROM products WHERE id = '4213'
374	0.0003	0.00033783912658691	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
375	0.0005	0.00047492980957031	SELECT * FROM product_image_select WHERE product_id = '4213'
376	0.0003	0.00026297569274902	SELECT * FROM productcustomimages WHERE product_id = '4213'
377	0.0008	0.00077605247497559	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
378	0.0003	0.00034308433532715	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
379	0.0003	0.00028800964355469	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
380	0.0003	0.00028204917907715	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
381	0.0028	0.0028080940246582	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
382	0.0010	0.00095510482788086	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
383	0.0034	0.0034148693084717	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
384	0.0017	0.0017390251159668	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
385	0.0007	0.00066304206848145	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
386	0.0006	0.00063300132751465	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
387	0.0006	0.00063109397888184	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.591295003891 seconds

Query Debug - 387 Database Queries. Total time 1.1797 seconds