Search Results for "4"

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

View to See Price

View

Add to Cart

EIGENart Boîte à thé rectangulaire avec ...

View to See Price

View

Add to Cart

Blanc NEUF en bois 6 compartiments Sache...

View to See Price

View

Add to Cart

Store Indya, Boîte de Boîte à thé 6 comp...

View to See Price

View

Add to Cart

Kosma en acier inoxydable 4 Ensemble de ...

View to See Price

View

Add to Cart

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

View to See Price

View

Add to Cart

Dragonfly Rooibos Earl Grey Tea 40 per p...

View to See Price

View

Add to Cart

Dragonfly Rooibos Vanilla Tea 40 per pac...

View to See Price

View

Add to Cart

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

View to See Price

View

Add to Cart

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

View to See Price

View

Add to Cart

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

View to See Price

View

Add to Cart

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

only €40,19

View

Add to Cart

Fairtrade Libellule Sacs De Thé Rooibos ...

View to See Price

View

Add to Cart

SoBuy® FRG85-N Boîte à Capsules de Café ...

View to See Price

View

Add to Cart

Rétro deux tons 9 Compartiment Sachet de...

View to See Price

View

Add to Cart

FUNRUI Boîte à Café Hermétique, Coffee V...

View to See Price

View

Add to Cart

Rowan Summerlite à 4

from €5,10

View

Add to Cart

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

View to See Price

View

Add to Cart

217 to 234 of 336 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.721449136734	391	1.0242	0

No Amazon API Requests Made.

App Debug - Total Time 1.721449136734 seconds

Number	Time From Start	Name	Description
1	0.4502170085907	Initialise	Initialise FSB Function
2	0.45643401145935	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.49598598480225	Start of getCategoryListByGroup Function	Before first category groups query
4	0.49779200553894	After initial query	Before first category groups query
5	0.49779510498047	Get Category List for Group	Before the call to getCategoryList function
6	0.49779915809631	Start of GetCategoryList function	Start of the function
7	0.49780416488647	Before getting categories	Query to get specific category list
8	0.49976205825806	After getting categories	Query to get specific category list
9	0.49976396560669	Before getting category custom	Before call to function getCategoryCustom
10	0.53754496574402	After getting category custom	After call to function getCategoryCustom
11	0.53754901885986	Before getting category custom	Before call to function getCategoryCustom
12	0.55460214614868	After getting category custom	After call to function getCategoryCustom
13	0.55460596084595	Before getting category custom	Before call to function getCategoryCustom
14	0.56254315376282	After getting category custom	After call to function getCategoryCustom
15	0.56254601478577	Before getting category custom	Before call to function getCategoryCustom
16	0.56781816482544	After getting category custom	After call to function getCategoryCustom
17	0.56782007217407	Before getting category custom	Before call to function getCategoryCustom
18	0.57332110404968	After getting category custom	After call to function getCategoryCustom
19	0.57332301139832	Before getting category custom	Before call to function getCategoryCustom
20	0.57884216308594	After getting category custom	After call to function getCategoryCustom
21	0.5788459777832	End of GetCategoryList function	End of the function
22	0.57885313034058	Get Category List for Group	Before the call to getCategoryList function
23	0.57885503768921	Start of GetCategoryList function	Start of the function
24	0.57885909080505	Before getting categories	Query to get specific category list
25	0.57941508293152	End of getCategoryListByGroup Function	Before return()
26	1.1459131240845	App Controller End	End of the App controller (called before the controller of every page)
27	1.3972790241241	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.3992509841919	Before Get Options	Before the call to getOptions in the tpl class
29	1.4656929969788	After Get Options	After the call to getOptions in the tpl class
30	1.4657440185547	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.7214341163635	Finalizing debug	Before the debug is output to the page.
32	1.7214481830597	End of App	This is the end of the app logging, final timestamp

Query Debug - 391 Database Queries. Total time 1.0242 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:\"18.224.37.28\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738829268'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-06 08:07:48' WHERE id = '15'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.224.37.28') >= INET_ATON(ip_start) AND INET_ATON('18.224.37.28') <= 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(), '18.224.37.28'
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 = '1552'
SELECT * FROM productimages WHERE product_id = '1552' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1552'
SELECT * FROM productcustomimages WHERE product_id = '1552'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1552' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1552' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1552' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1552
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1552'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1552' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1553'
SELECT * FROM productimages WHERE product_id = '1553' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1553'
SELECT * FROM productcustomimages WHERE product_id = '1553'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1553' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1553' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1553' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1553
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1553'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1553' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1559'
SELECT * FROM productimages WHERE product_id = '1559' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1559'
SELECT * FROM productcustomimages WHERE product_id = '1559'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1559' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1559' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1559' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1559
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1559'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1559' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1573'
SELECT * FROM productimages WHERE product_id = '1573' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1573'
SELECT * FROM productcustomimages WHERE product_id = '1573'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1573' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1573' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1573' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1573
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1573'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1573' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1576'
SELECT * FROM productimages WHERE product_id = '1576' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1576'
SELECT * FROM productcustomimages WHERE product_id = '1576'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1576' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1576' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1576' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1576
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1576'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1576' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1587'
SELECT * FROM productimages WHERE product_id = '1587' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1587'
SELECT * FROM productcustomimages WHERE product_id = '1587'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1587' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1587' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1587' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1587
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1587'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1595'
SELECT * FROM productimages WHERE product_id = '1595' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1595'
SELECT * FROM productcustomimages WHERE product_id = '1595'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1595' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1595' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1595' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1595
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1595'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1596'
SELECT * FROM productimages WHERE product_id = '1596' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1596'
SELECT * FROM productcustomimages WHERE product_id = '1596'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1596' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1596' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1596' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1596
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1596'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1596' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1614'
SELECT * FROM productimages WHERE product_id = '1614' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1614'
SELECT * FROM productcustomimages WHERE product_id = '1614'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1614' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1614' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1614' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1614
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1614'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1631'
SELECT * FROM productimages WHERE product_id = '1631' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1631'
SELECT * FROM productcustomimages WHERE product_id = '1631'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1631' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1631' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1631' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1631
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1631'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1631' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1652'
SELECT * FROM productimages WHERE product_id = '1652' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1652'
SELECT * FROM productcustomimages WHERE product_id = '1652'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1652' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1652' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1652' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1652
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1652'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1652' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1673'
SELECT * FROM productimages WHERE product_id = '1673' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1673'
SELECT * FROM productcustomimages WHERE product_id = '1673'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1673' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1673' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1673' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1674'
SELECT * FROM productimages WHERE product_id = '1674' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1674'
SELECT * FROM productcustomimages WHERE product_id = '1674'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1674' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1674
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1674'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1809'
SELECT * FROM productimages WHERE product_id = '1809' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1809'
SELECT * FROM productcustomimages WHERE product_id = '1809'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1809' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1809' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1809' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1809
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1809'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1707'
SELECT * FROM productimages WHERE product_id = '1707' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1707'
SELECT * FROM productcustomimages WHERE product_id = '1707'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1707' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1707' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1707' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1707
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1707'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1707' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1712'
SELECT * FROM productimages WHERE product_id = '1712' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1712' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1712'
SELECT * FROM productcustomimages WHERE product_id = '1712'
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 = '1712'
                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     = '1712'
                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 = 1712
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1712' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1712' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1712' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1712
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1712'
                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 = '1712'
                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     = '1712'
                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 = 1712
SELECT value FROM productattributes WHERE product_id = '1712' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1712'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '1712'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2881
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2881'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '2986'
SELECT * FROM productimages WHERE product_id = '2986' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2986' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2986'
SELECT * FROM productcustomimages WHERE product_id = '2986'
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 = '2986'
                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     = '2986'
                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 = 2986
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2986' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2986' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2986' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2986
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2986'
                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 = '2986'
                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     = '2986'
                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 = 2986
SELECT value FROM productattributes WHERE product_id = '2986' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2986'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1718'
SELECT * FROM productimages WHERE product_id = '1718' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1718'
SELECT * FROM productcustomimages WHERE product_id = '1718'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1718' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1718' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1718' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1718
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1718'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1718' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1552' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1553' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1559' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1573' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1576' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1587' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1595' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1596' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1614' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1631' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1652' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1673' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1674' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1809' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1707' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1712' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2986' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1718' 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.0021	0.0021171569824219	SELECT parameter, value FROM parameters
2	0.0039	0.0039229393005371	SELECT * FROM `bad_bots`
3	0.0005	0.00049996376037598	SET time_zone = 'Europe/London'
4	0.0023	0.0023128986358643	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0067	0.0067379474639893	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"18.224.37.28\";}'
6	0.0023	0.0023360252380371	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738829268'
7	0.0035	0.0035059452056885	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0009	0.00094199180603027	UPDATE autorun SET lastrun = '2025-02-06 08:07:48' WHERE id = '15'
9	0.0009	0.00090789794921875	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0037	0.0037269592285156	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0009	0.00088000297546387	SELECT * FROM pages WHERE id = 52
12	0.0079	0.007936954498291	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0290	0.029049158096313	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0019	0.0018770694732666	SELECT * FROM pages WHERE pagename = 'search'
15	0.0018	0.0017879009246826	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0019	0.0019271373748779	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0092	0.0091710090637207	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18	0.0028	0.0028331279754639	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
19	0.0023	0.0022621154785156	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0005	0.00051689147949219	SELECT id FROM categories WHERE parent_id = '26'
21	0.0121	0.012128829956055	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
22	0.0044	0.004410982131958	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (26) AND p.disabled = 0
23	0.0031	0.0030758380889893	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (26) AND c.prod_type = 'custom' AND cp.hide = 0
24	0.0025	0.0025169849395752	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0007	0.00065708160400391	SELECT * FROM categorygroups WHERE id = '1'
26	0.0071	0.0070869922637939	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
27	0.0006	0.00062918663024902	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0005	0.00049090385437012	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0005	0.00048708915710449	SELECT id FROM categories WHERE parent_id = '27'
30	0.0060	0.0059630870819092	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
31	0.0007	0.00065398216247559	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
32	0.0006	0.00063300132751465	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
33	0.0005	0.0005340576171875	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0004	0.00044989585876465	SELECT * FROM categorygroups WHERE id = '1'
35	0.0020	0.0020060539245605	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36	0.0006	0.00061607360839844	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0004	0.00044894218444824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.00052189826965332	SELECT id FROM categories WHERE parent_id = '28'
39	0.0020	0.0020458698272705	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
40	0.0006	0.00059199333190918	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
41	0.0006	0.00060606002807617	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
42	0.0005	0.00053691864013672	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0004	0.00043797492980957	SELECT * FROM categorygroups WHERE id = '1'
44	0.0007	0.00070405006408691	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45	0.0005	0.0005340576171875	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0005	0.00048589706420898	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0005	0.00053596496582031	SELECT id FROM categories WHERE parent_id = '29'
48	0.0007	0.00072193145751953	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
49	0.0005	0.0004889965057373	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
50	0.0007	0.00069689750671387	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
51	0.0006	0.00055813789367676	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0005	0.00046491622924805	SELECT * FROM categorygroups WHERE id = '1'
53	0.0007	0.00069999694824219	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54	0.0005	0.00054192543029785	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55	0.0004	0.00043511390686035	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0004	0.00044798851013184	SELECT id FROM categories WHERE parent_id = '30'
57	0.0011	0.0011229515075684	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
58	0.0006	0.00058603286743164	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
59	0.0006	0.00059318542480469	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
60	0.0005	0.00054311752319336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0004	0.00044798851013184	SELECT * FROM categorygroups WHERE id = '1'
62	0.0007	0.00065302848815918	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63	0.0005	0.00052523612976074	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64	0.0005	0.00050806999206543	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.00050783157348633	SELECT id FROM categories WHERE parent_id = '31'
66	0.0012	0.0011529922485352	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
67	0.0007	0.00066900253295898	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
68	0.0005	0.0005190372467041	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
69	0.0005	0.00048613548278809	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0004	0.00040221214294434	SELECT * FROM categorygroups WHERE id = '1'
71	0.0005	0.00054192543029785	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0027	0.0027220249176025	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0015	0.0014879703521729	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0006	0.00063085556030273	SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
75	0.0013	0.0013020038604736	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0014	0.0014078617095947	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0011	0.0010619163513184	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.5524	0.5524320602417	SELECT * FROM ipgeocountries WHERE INET_ATON('18.224.37.28') >= INET_ATON(ip_start) AND INET_ATON('18.224.37.28') <= INET_ATON(ip_end)
79	0.0021	0.0021340847015381	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0014	0.0013909339904785	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0006	0.00055813789367676	SELECT * FROM pages WHERE pagename = 'search'
82	0.0059	0.0058960914611816	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0018	0.0017530918121338	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0021	0.0021200180053711	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0054	0.0053658485412598	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0029	0.0029280185699463	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0008	0.00076007843017578	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0029	0.0029480457305908	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '18.224.37.28'
89	0.0012	0.0011558532714844	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
90	0.0008	0.00079989433288574	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
91	0.0065	0.0064730644226074	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
92	0.0006	0.00059008598327637	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
93	0.0006	0.00056791305541992	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
94	0.0006	0.00064802169799805	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
95	0.0063	0.0062880516052246	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
96	0.0005	0.00045680999755859	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
97	0.0003	0.00034403800964355	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
98	0.0006	0.0005800724029541	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
99	0.0006	0.00061607360839844	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
100	0.0040	0.0040171146392822	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
101	0.0005	0.00053501129150391	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
102	0.0005	0.00047183036804199	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
103	0.0006	0.00060915946960449	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
104	0.0051	0.0051090717315674	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
105	0.0004	0.00039887428283691	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
106	0.0004	0.00039315223693848	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
107	0.0005	0.00052285194396973	SELECT * FROM products WHERE id = '1552'
108	0.0018	0.0018160343170166	SELECT * FROM productimages WHERE product_id = '1552' ORDER BY sortorder ASC
109	0.0015	0.001453161239624	SELECT * FROM product_image_select WHERE product_id = '1552'
110	0.0013	0.001270055770874	SELECT * FROM productcustomimages WHERE product_id = '1552'
111	0.0018	0.0018379688262939	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1552' AND a.name = n.originalname
112	0.0035	0.0034990310668945	SELECT * FROM productoffers WHERE product_id = '1552' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0008	0.00075721740722656	SELECT * FROM productoffers WHERE product_id = '1552' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0007	0.00067305564880371	SELECT * FROM productoffers WHERE product_id = 1552 ORDER BY price ASC LIMIT 1
115	0.0010	0.0010480880737305	SELECT value FROM productattributes WHERE product_id = '1552' AND name = 'ListPriceAmount'
116	0.0009	0.00086283683776855	SELECT value FROM productattributes WHERE product_id = '1552' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0010	0.00097393989562988	SELECT * FROM products WHERE id = '1553'
118	0.0009	0.00089812278747559	SELECT * FROM productimages WHERE product_id = '1553' ORDER BY sortorder ASC
119	0.0013	0.001255989074707	SELECT * FROM product_image_select WHERE product_id = '1553'
120	0.0006	0.00063800811767578	SELECT * FROM productcustomimages WHERE product_id = '1553'
121	0.0026	0.0025808811187744	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1553' AND a.name = n.originalname
122	0.0009	0.000885009765625	SELECT * FROM productoffers WHERE product_id = '1553' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0006	0.0006110668182373	SELECT * FROM productoffers WHERE product_id = '1553' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0006	0.0006260871887207	SELECT * FROM productoffers WHERE product_id = 1553 ORDER BY price ASC LIMIT 1
125	0.0007	0.00071096420288086	SELECT value FROM productattributes WHERE product_id = '1553' AND name = 'ListPriceAmount'
126	0.0008	0.000823974609375	SELECT value FROM productattributes WHERE product_id = '1553' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127	0.0010	0.0010290145874023	SELECT * FROM products WHERE id = '1559'
128	0.0008	0.00081992149353027	SELECT * FROM productimages WHERE product_id = '1559' ORDER BY sortorder ASC
129	0.0010	0.0010251998901367	SELECT * FROM product_image_select WHERE product_id = '1559'
130	0.0008	0.0007631778717041	SELECT * FROM productcustomimages WHERE product_id = '1559'
131	0.0014	0.0014309883117676	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1559' AND a.name = n.originalname
132	0.0007	0.00072312355041504	SELECT * FROM productoffers WHERE product_id = '1559' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0006	0.00058507919311523	SELECT * FROM productoffers WHERE product_id = '1559' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0005	0.00050806999206543	SELECT * FROM productoffers WHERE product_id = 1559 ORDER BY price ASC LIMIT 1
135	0.0006	0.00055909156799316	SELECT value FROM productattributes WHERE product_id = '1559' AND name = 'ListPriceAmount'
136	0.0007	0.00065302848815918	SELECT value FROM productattributes WHERE product_id = '1559' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137	0.0008	0.00083494186401367	SELECT * FROM products WHERE id = '1573'
138	0.0008	0.0007929801940918	SELECT * FROM productimages WHERE product_id = '1573' ORDER BY sortorder ASC
139	0.0009	0.00089192390441895	SELECT * FROM product_image_select WHERE product_id = '1573'
140	0.0006	0.00060892105102539	SELECT * FROM productcustomimages WHERE product_id = '1573'
141	0.0039	0.0038959980010986	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1573' AND a.name = n.originalname
142	0.0010	0.00098395347595215	SELECT * FROM productoffers WHERE product_id = '1573' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0006	0.00059795379638672	SELECT * FROM productoffers WHERE product_id = '1573' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0006	0.00056886672973633	SELECT * FROM productoffers WHERE product_id = 1573 ORDER BY price ASC LIMIT 1
145	0.0006	0.00063800811767578	SELECT value FROM productattributes WHERE product_id = '1573' AND name = 'ListPriceAmount'
146	0.0008	0.00075912475585938	SELECT value FROM productattributes WHERE product_id = '1573' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0011	0.0010850429534912	SELECT * FROM products WHERE id = '1576'
148	0.0009	0.00093197822570801	SELECT * FROM productimages WHERE product_id = '1576' ORDER BY sortorder ASC
149	0.0011	0.001054048538208	SELECT * FROM product_image_select WHERE product_id = '1576'
150	0.0005	0.00054812431335449	SELECT * FROM productcustomimages WHERE product_id = '1576'
151	0.0019	0.0018730163574219	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1576' AND a.name = n.originalname
152	0.0007	0.00074887275695801	SELECT * FROM productoffers WHERE product_id = '1576' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0006	0.00059700012207031	SELECT * FROM productoffers WHERE product_id = '1576' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0005	0.0005490779876709	SELECT * FROM productoffers WHERE product_id = 1576 ORDER BY price ASC LIMIT 1
155	0.0007	0.00069904327392578	SELECT value FROM productattributes WHERE product_id = '1576' AND name = 'ListPriceAmount'
156	0.0008	0.00075101852416992	SELECT value FROM productattributes WHERE product_id = '1576' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157	0.0010	0.00095295906066895	SELECT * FROM products WHERE id = '1587'
158	0.0011	0.0010669231414795	SELECT * FROM productimages WHERE product_id = '1587' ORDER BY sortorder ASC
159	0.0011	0.0010521411895752	SELECT * FROM product_image_select WHERE product_id = '1587'
160	0.0008	0.00078797340393066	SELECT * FROM productcustomimages WHERE product_id = '1587'
161	0.0024	0.0023617744445801	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1587' AND a.name = n.originalname
162	0.0008	0.00082111358642578	SELECT * FROM productoffers WHERE product_id = '1587' AND merchantid = 'A1X6FK5RDHNB96'
163	0.0005	0.00054287910461426	SELECT * FROM productoffers WHERE product_id = '1587' AND price > 0 ORDER BY price ASC LIMIT 1
164	0.0006	0.00062894821166992	SELECT * FROM productoffers WHERE product_id = 1587 ORDER BY price ASC LIMIT 1
165	0.0005	0.00050902366638184	SELECT value FROM productattributes WHERE product_id = '1587' AND name = 'ListPriceAmount'
166	0.0005	0.0005490779876709	SELECT value FROM productattributes WHERE product_id = '1587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167	0.0009	0.00089311599731445	SELECT * FROM products WHERE id = '1595'
168	0.0007	0.00066089630126953	SELECT * FROM productimages WHERE product_id = '1595' ORDER BY sortorder ASC
169	0.0010	0.00095200538635254	SELECT * FROM product_image_select WHERE product_id = '1595'
170	0.0005	0.00053000450134277	SELECT * FROM productcustomimages WHERE product_id = '1595'
171	0.0011	0.0011429786682129	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1595' AND a.name = n.originalname
172	0.0007	0.00065898895263672	SELECT * FROM productoffers WHERE product_id = '1595' AND merchantid = 'A1X6FK5RDHNB96'
173	0.0006	0.00056910514831543	SELECT * FROM productoffers WHERE product_id = '1595' AND price > 0 ORDER BY price ASC LIMIT 1
174	0.0004	0.00042605400085449	SELECT * FROM productoffers WHERE product_id = 1595 ORDER BY price ASC LIMIT 1
175	0.0007	0.00070595741271973	SELECT value FROM productattributes WHERE product_id = '1595' AND name = 'ListPriceAmount'
176	0.0007	0.00066399574279785	SELECT value FROM productattributes WHERE product_id = '1595' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177	0.0008	0.00081682205200195	SELECT * FROM products WHERE id = '1596'
178	0.0006	0.00061488151550293	SELECT * FROM productimages WHERE product_id = '1596' ORDER BY sortorder ASC
179	0.0008	0.00083112716674805	SELECT * FROM product_image_select WHERE product_id = '1596'
180	0.0005	0.00054311752319336	SELECT * FROM productcustomimages WHERE product_id = '1596'
181	0.0012	0.001154899597168	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1596' AND a.name = n.originalname
182	0.0006	0.00064206123352051	SELECT * FROM productoffers WHERE product_id = '1596' AND merchantid = 'A1X6FK5RDHNB96'
183	0.0006	0.00062799453735352	SELECT * FROM productoffers WHERE product_id = '1596' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0009	0.00089812278747559	SELECT * FROM productoffers WHERE product_id = 1596 ORDER BY price ASC LIMIT 1
185	0.0009	0.00087904930114746	SELECT value FROM productattributes WHERE product_id = '1596' AND name = 'ListPriceAmount'
186	0.0012	0.0011508464813232	SELECT value FROM productattributes WHERE product_id = '1596' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187	0.0012	0.0012490749359131	SELECT * FROM products WHERE id = '1614'
188	0.0011	0.0011358261108398	SELECT * FROM productimages WHERE product_id = '1614' ORDER BY sortorder ASC
189	0.0013	0.0013179779052734	SELECT * FROM product_image_select WHERE product_id = '1614'
190	0.0010	0.00097918510437012	SELECT * FROM productcustomimages WHERE product_id = '1614'
191	0.0029	0.0029308795928955	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1614' AND a.name = n.originalname
192	0.0010	0.00099921226501465	SELECT * FROM productoffers WHERE product_id = '1614' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0007	0.00068497657775879	SELECT * FROM productoffers WHERE product_id = '1614' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0006	0.000579833984375	SELECT * FROM productoffers WHERE product_id = 1614 ORDER BY price ASC LIMIT 1
195	0.0007	0.00067996978759766	SELECT value FROM productattributes WHERE product_id = '1614' AND name = 'ListPriceAmount'
196	0.0007	0.00073003768920898	SELECT value FROM productattributes WHERE product_id = '1614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197	0.0010	0.00095510482788086	SELECT * FROM products WHERE id = '1631'
198	0.0008	0.00080490112304688	SELECT * FROM productimages WHERE product_id = '1631' ORDER BY sortorder ASC
199	0.0012	0.0011920928955078	SELECT * FROM product_image_select WHERE product_id = '1631'
200	0.0006	0.00061988830566406	SELECT * FROM productcustomimages WHERE product_id = '1631'
201	0.0022	0.0022091865539551	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1631' AND a.name = n.originalname
202	0.0009	0.00092411041259766	SELECT * FROM productoffers WHERE product_id = '1631' AND merchantid = 'A1X6FK5RDHNB96'
203	0.0006	0.0005500316619873	SELECT * FROM productoffers WHERE product_id = '1631' AND price > 0 ORDER BY price ASC LIMIT 1
204	0.0005	0.00047492980957031	SELECT * FROM productoffers WHERE product_id = 1631 ORDER BY price ASC LIMIT 1
205	0.0006	0.00056219100952148	SELECT value FROM productattributes WHERE product_id = '1631' AND name = 'ListPriceAmount'
206	0.0006	0.0005950927734375	SELECT value FROM productattributes WHERE product_id = '1631' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207	0.0008	0.00076007843017578	SELECT * FROM products WHERE id = '1652'
208	0.0008	0.00078201293945312	SELECT * FROM productimages WHERE product_id = '1652' ORDER BY sortorder ASC
209	0.0010	0.0010230541229248	SELECT * FROM product_image_select WHERE product_id = '1652'
210	0.0005	0.00053501129150391	SELECT * FROM productcustomimages WHERE product_id = '1652'
211	0.0018	0.0018279552459717	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1652' AND a.name = n.originalname
212	0.0007	0.00072813034057617	SELECT * FROM productoffers WHERE product_id = '1652' AND merchantid = 'A1X6FK5RDHNB96'
213	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '1652' AND price > 0 ORDER BY price ASC LIMIT 1
214	0.0005	0.00051498413085938	SELECT * FROM productoffers WHERE product_id = 1652 ORDER BY price ASC LIMIT 1
215	0.0006	0.00055193901062012	SELECT value FROM productattributes WHERE product_id = '1652' AND name = 'ListPriceAmount'
216	0.0006	0.00056791305541992	SELECT value FROM productattributes WHERE product_id = '1652' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217	0.0007	0.00069212913513184	SELECT * FROM products WHERE id = '1673'
218	0.0008	0.00076508522033691	SELECT * FROM productimages WHERE product_id = '1673' ORDER BY sortorder ASC
219	0.0010	0.00097799301147461	SELECT * FROM product_image_select WHERE product_id = '1673'
220	0.0006	0.0005950927734375	SELECT * FROM productcustomimages WHERE product_id = '1673'
221	0.0015	0.0015377998352051	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1673' AND a.name = n.originalname
222	0.0006	0.00063920021057129	SELECT * FROM productoffers WHERE product_id = '1673' AND merchantid = 'A1X6FK5RDHNB96'
223	0.0006	0.00056910514831543	SELECT * FROM productoffers WHERE product_id = '1673' AND price > 0 ORDER BY price ASC LIMIT 1
224	0.0006	0.00063109397888184	SELECT value FROM productattributes WHERE product_id = '1673' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225	0.0007	0.00071406364440918	SELECT * FROM products WHERE id = '1674'
226	0.0007	0.00068020820617676	SELECT * FROM productimages WHERE product_id = '1674' ORDER BY sortorder ASC
227	0.0010	0.00096797943115234	SELECT * FROM product_image_select WHERE product_id = '1674'
228	0.0005	0.00054001808166504	SELECT * FROM productcustomimages WHERE product_id = '1674'
229	0.0014	0.0014040470123291	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1674' AND a.name = n.originalname
230	0.0006	0.00061988830566406	SELECT * FROM productoffers WHERE product_id = '1674' AND merchantid = 'A1X6FK5RDHNB96'
231	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '1674' AND price > 0 ORDER BY price ASC LIMIT 1
232	0.0005	0.00051522254943848	SELECT * FROM productoffers WHERE product_id = 1674 ORDER BY price ASC LIMIT 1
233	0.0005	0.00049591064453125	SELECT value FROM productattributes WHERE product_id = '1674' AND name = 'ListPriceAmount'
234	0.0006	0.00062799453735352	SELECT value FROM productattributes WHERE product_id = '1674' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235	0.0007	0.00072717666625977	SELECT * FROM products WHERE id = '1809'
236	0.0007	0.00067281723022461	SELECT * FROM productimages WHERE product_id = '1809' ORDER BY sortorder ASC
237	0.0008	0.00075006484985352	SELECT * FROM product_image_select WHERE product_id = '1809'
238	0.0004	0.00043201446533203	SELECT * FROM productcustomimages WHERE product_id = '1809'
239	0.0011	0.0011498928070068	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1809' AND a.name = n.originalname
240	0.0006	0.00055503845214844	SELECT * FROM productoffers WHERE product_id = '1809' AND merchantid = 'A1X6FK5RDHNB96'
241	0.0005	0.00045180320739746	SELECT * FROM productoffers WHERE product_id = '1809' AND price > 0 ORDER BY price ASC LIMIT 1
242	0.0004	0.00037693977355957	SELECT * FROM productoffers WHERE product_id = 1809 ORDER BY price ASC LIMIT 1
243	0.0004	0.00041294097900391	SELECT value FROM productattributes WHERE product_id = '1809' AND name = 'ListPriceAmount'
244	0.0006	0.00057888031005859	SELECT value FROM productattributes WHERE product_id = '1809' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245	0.0007	0.00068116188049316	SELECT * FROM products WHERE id = '1707'
246	0.0006	0.00062990188598633	SELECT * FROM productimages WHERE product_id = '1707' ORDER BY sortorder ASC
247	0.0007	0.00074410438537598	SELECT * FROM product_image_select WHERE product_id = '1707'
248	0.0004	0.00044608116149902	SELECT * FROM productcustomimages WHERE product_id = '1707'
249	0.0010	0.0010077953338623	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1707' AND a.name = n.originalname
250	0.0005	0.00054502487182617	SELECT * FROM productoffers WHERE product_id = '1707' AND merchantid = 'A1X6FK5RDHNB96'
251	0.0005	0.00051283836364746	SELECT * FROM productoffers WHERE product_id = '1707' AND price > 0 ORDER BY price ASC LIMIT 1
252	0.0004	0.0004270076751709	SELECT * FROM productoffers WHERE product_id = 1707 ORDER BY price ASC LIMIT 1
253	0.0005	0.00045084953308105	SELECT value FROM productattributes WHERE product_id = '1707' AND name = 'ListPriceAmount'
254	0.0005	0.00047111511230469	SELECT value FROM productattributes WHERE product_id = '1707' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255	0.0007	0.00068783760070801	SELECT * FROM products WHERE id = '1712'
256	0.0007	0.00070500373840332	SELECT * FROM productimages WHERE product_id = '1712' ORDER BY sortorder ASC
257	0.0005	0.00049281120300293	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1712' AND p.id = pi.product_id ORDER BY pi.sortorder
258	0.0007	0.000701904296875	SELECT * FROM product_image_select WHERE product_id = '1712'
259	0.0004	0.00044393539428711	SELECT * FROM productcustomimages WHERE product_id = '1712'
260	0.0006	0.00055694580078125	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 = '1712' GROUP BY o.product_id
261	0.0032	0.003209114074707	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 = '1712' GROUP BY n.displayname ORDER BY n.displayname DESC
262	0.0011	0.0011310577392578	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1712
263	0.0019	0.0018818378448486	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1712' AND a.name = n.originalname
264	0.0009	0.00088810920715332	SELECT * FROM productoffers WHERE product_id = '1712' AND merchantid = 'A1X6FK5RDHNB96'
265	0.0007	0.00068497657775879	SELECT * FROM productoffers WHERE product_id = '1712' AND price > 0 ORDER BY price ASC LIMIT 1
266	0.0007	0.00067806243896484	SELECT * FROM productoffers WHERE product_id = 1712 ORDER BY price ASC LIMIT 1
267	0.0016	0.0015830993652344	SELECT value FROM productattributes WHERE product_id = '1712' AND name = 'ListPriceAmount'
268	0.0012	0.0011599063873291	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 = '1712' GROUP BY o.product_id
269	0.0017	0.0017211437225342	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 = '1712' GROUP BY n.displayname ORDER BY n.displayname DESC
270	0.0011	0.0011451244354248	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1712
271	0.0014	0.001413106918335	SELECT value FROM productattributes WHERE product_id = '1712' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272	0.0016	0.0016231536865234	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1712' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
273	0.0009	0.000946044921875	SELECT * FROM products WHERE parent_id = '1712'
274	0.0015	0.0015199184417725	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2881' AND a.name = n.originalname
275	0.0009	0.00094294548034668	SELECT * FROM productoffers WHERE product_id = '2881' AND merchantid = 'A1X6FK5RDHNB96'
276	0.0007	0.00066113471984863	SELECT * FROM productoffers WHERE product_id = '2881' AND price > 0 ORDER BY price ASC LIMIT 1
277	0.0006	0.00061297416687012	SELECT * FROM productoffers WHERE product_id = 2881 ORDER BY price ASC LIMIT 1
278	0.0008	0.00080204010009766	SELECT value FROM productattributes WHERE product_id = '2881' AND name = 'ListPriceAmount'
279	0.0008	0.00081205368041992	SELECT * FROM products WHERE id = '2986'
280	0.0009	0.00090909004211426	SELECT * FROM productimages WHERE product_id = '2986' ORDER BY sortorder ASC
281	0.0011	0.0011348724365234	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2986' AND p.id = pi.product_id ORDER BY pi.sortorder
282	0.0013	0.0012989044189453	SELECT * FROM product_image_select WHERE product_id = '2986'
283	0.0008	0.00084805488586426	SELECT * FROM productcustomimages WHERE product_id = '2986'
284	0.0018	0.0017638206481934	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 = '2986' GROUP BY o.product_id
285	0.0019	0.00193190574646	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 = '2986' GROUP BY n.displayname ORDER BY n.displayname DESC
286	0.0010	0.00097417831420898	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2986
287	0.0017	0.0017480850219727	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2986' AND a.name = n.originalname
288	0.0006	0.00061798095703125	SELECT * FROM productoffers WHERE product_id = '2986' AND merchantid = 'A1X6FK5RDHNB96'
289	0.0006	0.00057101249694824	SELECT * FROM productoffers WHERE product_id = '2986' AND price > 0 ORDER BY price ASC LIMIT 1
290	0.0005	0.00050902366638184	SELECT * FROM productoffers WHERE product_id = 2986 ORDER BY price ASC LIMIT 1
291	0.0005	0.00053691864013672	SELECT value FROM productattributes WHERE product_id = '2986' AND name = 'ListPriceAmount'
292	0.0008	0.00081205368041992	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 = '2986' GROUP BY o.product_id
293	0.0013	0.0013048648834229	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 = '2986' GROUP BY n.displayname ORDER BY n.displayname DESC
294	0.0007	0.00068378448486328	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2986
295	0.0008	0.00077104568481445	SELECT value FROM productattributes WHERE product_id = '2986' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
296	0.0010	0.0010099411010742	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2986' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
297	0.0006	0.00060486793518066	SELECT * FROM products WHERE id = '1718'
298	0.0007	0.0006868839263916	SELECT * FROM productimages WHERE product_id = '1718' ORDER BY sortorder ASC
299	0.0009	0.00086617469787598	SELECT * FROM product_image_select WHERE product_id = '1718'
300	0.0005	0.0005190372467041	SELECT * FROM productcustomimages WHERE product_id = '1718'
301	0.0012	0.0011711120605469	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1718' AND a.name = n.originalname
302	0.0006	0.00061607360839844	SELECT * FROM productoffers WHERE product_id = '1718' AND merchantid = 'A1X6FK5RDHNB96'
303	0.0005	0.00053596496582031	SELECT * FROM productoffers WHERE product_id = '1718' AND price > 0 ORDER BY price ASC LIMIT 1
304	0.0005	0.00050497055053711	SELECT * FROM productoffers WHERE product_id = 1718 ORDER BY price ASC LIMIT 1
305	0.0005	0.00051784515380859	SELECT value FROM productattributes WHERE product_id = '1718' AND name = 'ListPriceAmount'
306	0.0005	0.00051593780517578	SELECT value FROM productattributes WHERE product_id = '1718' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307	0.0019	0.0018751621246338	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1552' ORDER BY timestamp DESC
308	0.0004	0.00037693977355957	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1553' ORDER BY timestamp DESC
309	0.0004	0.00035595893859863	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1559' ORDER BY timestamp DESC
310	0.0004	0.00037598609924316	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1573' ORDER BY timestamp DESC
311	0.0003	0.00033688545227051	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1576' ORDER BY timestamp DESC
312	0.0003	0.00033092498779297	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1587' ORDER BY timestamp DESC
313	0.0003	0.00032901763916016	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1595' ORDER BY timestamp DESC
314	0.0004	0.00035500526428223	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1596' ORDER BY timestamp DESC
315	0.0003	0.00032997131347656	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1614' ORDER BY timestamp DESC
316	0.0004	0.00038504600524902	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1631' ORDER BY timestamp DESC
317	0.0004	0.00037908554077148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1652' ORDER BY timestamp DESC
318	0.0003	0.0003359317779541	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1673' ORDER BY timestamp DESC
319	0.0003	0.00034284591674805	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1674' ORDER BY timestamp DESC
320	0.0004	0.00040197372436523	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1809' ORDER BY timestamp DESC
321	0.0003	0.00032305717468262	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1707' ORDER BY timestamp DESC
322	0.0004	0.00041913986206055	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1712' ORDER BY timestamp DESC
323	0.0003	0.00034379959106445	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2986' ORDER BY timestamp DESC
324	0.0003	0.00034403800964355	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1718' ORDER BY timestamp DESC
325	0.0017	0.0017299652099609	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
326	0.0014	0.0014481544494629	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
327	0.0004	0.00042510032653809	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
328	0.0160	0.016010999679565	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
329	0.0018	0.0017831325531006	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
330	0.0007	0.00068283081054688	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
331	0.0006	0.00059795379638672	SELECT * FROM products WHERE id = 1626
332	0.0005	0.00048685073852539	SELECT * FROM products WHERE id = 4041
333	0.0005	0.00048708915710449	SELECT * FROM products WHERE id = 4312
334	0.0005	0.00047802925109863	SELECT * FROM products WHERE id = 777
335	0.0005	0.00049805641174316	SELECT * FROM products WHERE id = 3881
336	0.0005	0.00048017501831055	SELECT * FROM products WHERE id = 4213
337	0.0005	0.00045609474182129	SELECT * FROM products WHERE id = '1626'
338	0.0005	0.00047397613525391	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
339	0.0006	0.00061297416687012	SELECT * FROM product_image_select WHERE product_id = '1626'
340	0.0004	0.00041317939758301	SELECT * FROM productcustomimages WHERE product_id = '1626'
341	0.0008	0.00081706047058105	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
342	0.0005	0.0005028247833252	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
343	0.0004	0.00042915344238281	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
344	0.0005	0.00053811073303223	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345	0.0006	0.00057601928710938	SELECT * FROM products WHERE id = '4041'
346	0.0006	0.00058197975158691	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
347	0.0007	0.00066614151000977	SELECT * FROM product_image_select WHERE product_id = '4041'
348	0.0004	0.00043892860412598	SELECT * FROM productcustomimages WHERE product_id = '4041'
349	0.0014	0.0013728141784668	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
350	0.0006	0.00058984756469727	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
351	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
352	0.0005	0.00047683715820312	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
353	0.0006	0.00063800811767578	SELECT * FROM products WHERE id = '4312'
354	0.0005	0.00049018859863281	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
355	0.0009	0.00086712837219238	SELECT * FROM product_image_select WHERE product_id = '4312'
356	0.0006	0.00057196617126465	SELECT * FROM productcustomimages WHERE product_id = '4312'
357	0.0014	0.0014269351959229	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
358	0.0007	0.00072193145751953	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
359	0.0006	0.00057387351989746	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
360	0.0006	0.00058507919311523	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
361	0.0007	0.00068187713623047	SELECT * FROM products WHERE id = '777'
362	0.0006	0.00058412551879883	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
363	0.0007	0.00070500373840332	SELECT * FROM product_image_select WHERE product_id = '777'
364	0.0005	0.00048112869262695	SELECT * FROM productcustomimages WHERE product_id = '777'
365	0.0014	0.0013577938079834	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
366	0.0006	0.00056576728820801	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
367	0.0005	0.0005340576171875	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
368	0.0006	0.00059700012207031	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
369	0.0006	0.00062990188598633	SELECT * FROM products WHERE id = '3881'
370	0.0008	0.00082802772521973	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
371	0.0008	0.00077986717224121	SELECT * FROM product_image_select WHERE product_id = '3881'
372	0.0005	0.00050711631774902	SELECT * FROM productcustomimages WHERE product_id = '3881'
373	0.0017	0.0017149448394775	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
374	0.0006	0.00063514709472656	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
375	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
376	0.0006	0.00062108039855957	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
377	0.0007	0.0006861686706543	SELECT * FROM products WHERE id = '4213'
378	0.0006	0.00060701370239258	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
379	0.0007	0.00068902969360352	SELECT * FROM product_image_select WHERE product_id = '4213'
380	0.0005	0.00046610832214355	SELECT * FROM productcustomimages WHERE product_id = '4213'
381	0.0016	0.0016379356384277	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
382	0.0006	0.00056791305541992	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
383	0.0005	0.00046110153198242	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
384	0.0005	0.00046896934509277	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
385	0.0026	0.002601146697998	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
386	0.0008	0.00084805488586426	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
387	0.0030	0.0029609203338623	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
388	0.0019	0.0018739700317383	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
389	0.0007	0.00073099136352539	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
390	0.0013	0.0012979507446289	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
391	0.0015	0.0014889240264893	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.721449136734 seconds

Query Debug - 391 Database Queries. Total time 1.0242 seconds