Search Results for "2"

Boite à thé en Bois - Style Scandinave -...

View to See Price

View

Add to Cart

Thé Boîte de rangement, boîte à café, th...

View to See Price

View

Add to Cart

Boîte à thé avec couvercle en bois avec ...

only €30,79

View

Add to Cart

NATIVES 511720 Circus Parade-funambule B...

View to See Price

View

Add to Cart

Acrylique Boîte à thé 6 sections

View to See Price

View

Add to Cart

NATIVES 211372 Thé fantastique Lot de 3 ...

View to See Price

View

Add to Cart

Bois LaquÉ - BoÎte En Bois Coffret À ThÉ...

only €16,55

View

Add to Cart

Boite à Thé en Bois - 9 compartiments - ...

View to See Price

View

Add to Cart

matches21 Licorne Rooibos Bos Thé funkel...

View to See Price

View

Add to Cart

matches21 Licorne Rooibos Bos Thé Or de ...

View to See Price

View

Add to Cart

Alter Eco Thé Blanc Rooibos Caramel Bio ...

View to See Price

View

Add to Cart

Mesh Rooibos Vanille Thé 16sticks-Thé ap...

only €10,90

View

Add to Cart

Teapigs Organic Honey Bush and Rooibos T...

only €11,94

View

Add to Cart

Thé en filtres rouge Rooibos 20 filtres...

View to See Price

View

Add to Cart

Terre d 'Oc thé rooibos bio – Coffret No...

View to See Price

View

Add to Cart

Palais Des Thés - Thé Vert Sencha De Mai...

View to See Price

View

Add to Cart

Libellule Rooibos Chai Sachets De Thé 20...

View to See Price

View

Add to Cart

Dragonfly Organic Rooibos Chai Tea Bags ...

View to See Price

View

Add to Cart

253 to 270 of 532 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
3.1877961158752	369	1.0229	0

No Amazon API Requests Made.

App Debug - Total Time 3.1877961158752 seconds

Number	Time From Start	Name	Description
1	1.9065141677856	Initialise	Initialise FSB Function
2	1.913419008255	App Controller Start	Start of the App controller (called before the controller of every page)
3	1.9530711174011	Start of getCategoryListByGroup Function	Before first category groups query
4	1.9548110961914	After initial query	Before first category groups query
5	1.9548139572144	Get Category List for Group	Before the call to getCategoryList function
6	1.9548189640045	Start of GetCategoryList function	Start of the function
7	1.9548239707947	Before getting categories	Query to get specific category list
8	1.956698179245	After getting categories	Query to get specific category list
9	1.9567000865936	Before getting category custom	Before call to function getCategoryCustom
10	1.9797570705414	After getting category custom	After call to function getCategoryCustom
11	1.9797611236572	Before getting category custom	Before call to function getCategoryCustom
12	1.9913501739502	After getting category custom	After call to function getCategoryCustom
13	1.9913539886475	Before getting category custom	Before call to function getCategoryCustom
14	2.001293182373	After getting category custom	After call to function getCategoryCustom
15	2.0012981891632	Before getting category custom	Before call to function getCategoryCustom
16	2.0063140392303	After getting category custom	After call to function getCategoryCustom
17	2.0063171386719	Before getting category custom	Before call to function getCategoryCustom
18	2.0111651420593	After getting category custom	After call to function getCategoryCustom
19	2.011167049408	Before getting category custom	Before call to function getCategoryCustom
20	2.0164551734924	After getting category custom	After call to function getCategoryCustom
21	2.0164589881897	End of GetCategoryList function	End of the function
22	2.0164661407471	Get Category List for Group	Before the call to getCategoryList function
23	2.01646900177	Start of GetCategoryList function	Start of the function
24	2.0164721012115	Before getting categories	Query to get specific category list
25	2.0171060562134	End of getCategoryListByGroup Function	Before return()
26	2.6050300598145	App Controller End	End of the App controller (called before the controller of every page)
27	2.8874571323395	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	2.8895871639252	Before Get Options	Before the call to getOptions in the tpl class
29	3.0063240528107	After Get Options	After the call to getOptions in the tpl class
30	3.0063619613647	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	3.1877791881561	Finalizing debug	Before the debug is output to the page.
32	3.1877951622009	End of App	This is the end of the app logging, final timestamp

Query Debug - 369 Database Queries. Total time 1.0229 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:14:\"18.190.176.187\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738823252'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-06 06:27:32' WHERE id = '8'
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.190.176.187') >= INET_ATON(ip_start) AND INET_ATON('18.190.176.187') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'search'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '18.190.176.187'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+2'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2'))

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

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

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

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%2%') OR (title LIKE '%2%'))
		AND hide = 0
SELECT * FROM products WHERE id = '791'
SELECT * FROM productimages WHERE product_id = '791' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '791'
SELECT * FROM productcustomimages WHERE product_id = '791'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '791' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '791' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '791' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 791
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '791'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '791' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '793'
SELECT * FROM productimages WHERE product_id = '793' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '793'
SELECT * FROM productcustomimages WHERE product_id = '793'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '793' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '793' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '793' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 793
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '793'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '793' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1326'
SELECT * FROM productimages WHERE product_id = '1326' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1326'
SELECT * FROM productcustomimages WHERE product_id = '1326'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1326' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1326' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1326' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1326
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1326'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1326' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '811'
SELECT * FROM productimages WHERE product_id = '811' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '811'
SELECT * FROM productcustomimages WHERE product_id = '811'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '811' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '811' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '811' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 811
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '811'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '811' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '812'
SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '812'
SELECT * FROM productcustomimages WHERE product_id = '812'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '812' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '812' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '812' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 812
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '812'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '825'
SELECT * FROM productimages WHERE product_id = '825' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '825'
SELECT * FROM productcustomimages WHERE product_id = '825'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '825' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '825' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '825' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 825
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '825'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '833'
SELECT * FROM productimages WHERE product_id = '833' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '833'
SELECT * FROM productcustomimages WHERE product_id = '833'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '833' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '833' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '833' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 833
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '833'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '833' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '834'
SELECT * FROM productimages WHERE product_id = '834' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '834'
SELECT * FROM productcustomimages WHERE product_id = '834'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '834' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '834' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '834' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 834
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '834'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '834' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2374'
SELECT * FROM productimages WHERE product_id = '2374' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2374'
SELECT * FROM productcustomimages WHERE product_id = '2374'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2374' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2374' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2374' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2374
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2374'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2374' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2375'
SELECT * FROM productimages WHERE product_id = '2375' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2375'
SELECT * FROM productcustomimages WHERE product_id = '2375'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2375' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2375' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2375' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2375
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2375'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2375' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '867'
SELECT * FROM productimages WHERE product_id = '867' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '867'
SELECT * FROM productcustomimages WHERE product_id = '867'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '867' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '867' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '867' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 867
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '867'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '867' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '869'
SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '869'
SELECT * FROM productcustomimages WHERE product_id = '869'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '869' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '879'
SELECT * FROM productimages WHERE product_id = '879' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '879'
SELECT * FROM productcustomimages WHERE product_id = '879'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '879' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '879' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '879' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 879
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '879'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '879' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '883'
SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '883'
SELECT * FROM productcustomimages WHERE product_id = '883'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '883' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 883
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '883'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '885'
SELECT * FROM productimages WHERE product_id = '885' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '885'
SELECT * FROM productcustomimages WHERE product_id = '885'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '885' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '885' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '885' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 885
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '885'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '889'
SELECT * FROM productimages WHERE product_id = '889' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '889'
SELECT * FROM productcustomimages WHERE product_id = '889'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '889' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '889' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '889' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 889
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '889'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '899'
SELECT * FROM productimages WHERE product_id = '899' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '899'
SELECT * FROM productcustomimages WHERE product_id = '899'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '899' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '899' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '899' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 899
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '899'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '899' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '902'
SELECT * FROM productimages WHERE product_id = '902' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '902'
SELECT * FROM productcustomimages WHERE product_id = '902'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '902' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 902
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '902'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '791' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '793' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1326' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '811' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '812' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '825' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '833' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '834' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2374' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2375' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '867' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '869' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '879' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '883' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '885' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '889' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '899' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '902' 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.0012	0.0012149810791016	SELECT parameter, value FROM parameters
2	0.0037	0.0036969184875488	SELECT * FROM `bad_bots`
3	0.0004	0.00037503242492676	SET time_zone = 'Europe/London'
4	0.0047	0.0047440528869629	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0037	0.0036909580230713	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.190.176.187\";}'
6	0.0031	0.0030710697174072	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738823252'
7	0.0044	0.0043559074401855	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00083208084106445	UPDATE autorun SET lastrun = '2025-02-06 06:27:32' WHERE id = '8'
9	0.0011	0.0011210441589355	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0039	0.0039069652557373	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0007	0.00067901611328125	SELECT * FROM pages WHERE id = 52
12	0.0051	0.0050539970397949	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0332	0.03324294090271	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0007	0.00069403648376465	SELECT * FROM pages WHERE pagename = 'search'
15	0.0017	0.0017211437225342	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0019	0.0018501281738281	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0085	0.0085461139678955	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.0018	0.0017721652984619	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.0014	0.0013999938964844	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0005	0.00050187110900879	SELECT id FROM categories WHERE parent_id = '26'
21	0.0057	0.0057499408721924	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.0016	0.0016281604766846	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.0015	0.001521110534668	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.0013	0.0013198852539062	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0005	0.00045204162597656	SELECT * FROM categorygroups WHERE id = '1'
26	0.0039	0.0038650035858154	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.00064611434936523	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.0004889965057373	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0004	0.00044798851013184	SELECT id FROM categories WHERE parent_id = '27'
30	0.0038	0.0038480758666992	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.0006	0.00060892105102539	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.0006248950958252	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.0005030632019043	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0004	0.00042986869812012	SELECT * FROM categorygroups WHERE id = '1'
35	0.0017	0.0016720294952393	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.00055599212646484	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.00041389465332031	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.00052499771118164	SELECT id FROM categories WHERE parent_id = '28'
39	0.0017	0.0017149448394775	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.0008	0.0007789134979248	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.0020	0.0019669532775879	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.0017	0.0017340183258057	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0005	0.00045895576477051	SELECT * FROM categorygroups WHERE id = '1'
44	0.0007	0.00069212913513184	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.0006	0.00056195259094238	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.00046586990356445	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0005	0.00046896934509277	SELECT id FROM categories WHERE parent_id = '29'
48	0.0007	0.00073003768920898	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.00053215026855469	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.0005	0.00053906440734863	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.0005	0.00049281120300293	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0004	0.00043296813964844	SELECT * FROM categorygroups WHERE id = '1'
53	0.0006	0.00057792663574219	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.00047397613525391	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.00043392181396484	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0004	0.00044488906860352	SELECT id FROM categories WHERE parent_id = '30'
57	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 (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
58	0.0006	0.00056290626525879	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.0005	0.00052404403686523	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.00049996376037598	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0005	0.00052094459533691	SELECT * FROM categorygroups WHERE id = '1'
62	0.0007	0.00069594383239746	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.0006	0.00055885314941406	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.0004	0.00044894218444824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.00050210952758789	SELECT id FROM categories WHERE parent_id = '31'
66	0.0008	0.00078988075256348	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.0006	0.00055694580078125	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.0006	0.00056982040405273	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.0006	0.00060296058654785	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0005	0.00047087669372559	SELECT * FROM categorygroups WHERE id = '1'
71	0.0006	0.00062298774719238	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0033	0.003309965133667	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0018	0.0017621517181396	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0014	0.0013980865478516	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.0033	0.0032880306243896	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0016	0.0016319751739502	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0025	0.0024881362915039	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.5343	0.53431797027588	SELECT * FROM ipgeocountries WHERE INET_ATON('18.190.176.187') >= INET_ATON(ip_start) AND INET_ATON('18.190.176.187') <= INET_ATON(ip_end)
79	0.0029	0.0028769969940186	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0016	0.0015969276428223	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0009	0.00094389915466309	SELECT * FROM pages WHERE pagename = 'search'
82	0.0123	0.012250900268555	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0036	0.0036191940307617	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0019	0.0019161701202393	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0071	0.0071260929107666	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0017	0.0017051696777344	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0005	0.00050997734069824	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0014	0.0014331340789795	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '18.190.176.187'
89	0.0012	0.001201868057251	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0005	0.00053215026855469	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
91	0.0041	0.0041401386260986	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
92	0.0005	0.00048995018005371	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
93	0.0005	0.00048208236694336	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
94	0.0006	0.00059294700622559	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
95	0.0131	0.013078927993774	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
96	0.0007	0.00066685676574707	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
97	0.0005	0.00049686431884766	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
98	0.0011	0.0011458396911621	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0011	0.0010662078857422	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0094	0.0093750953674316	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '2') OR (keyfeatures LIKE '2') OR (title LIKE '2')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
101	0.0005	0.0005340576171875	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
102	0.0004	0.00042009353637695	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '2') OR (title LIKE '2')) AND hide = 0
103	0.0007	0.00072002410888672	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+2' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0142	0.01418399810791	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%2%') OR (keyfeatures LIKE '%2%') OR (title LIKE '%2%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
105	0.0007	0.00071191787719727	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
106	0.0005	0.00047588348388672	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%2%') OR (title LIKE '%2%')) AND hide = 0
107	0.0008	0.00081515312194824	SELECT * FROM products WHERE id = '791'
108	0.0028	0.0028150081634521	SELECT * FROM productimages WHERE product_id = '791' ORDER BY sortorder ASC
109	0.0026	0.0026240348815918	SELECT * FROM product_image_select WHERE product_id = '791'
110	0.0017	0.0016839504241943	SELECT * FROM productcustomimages WHERE product_id = '791'
111	0.0061	0.006065845489502	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '791' AND a.name = n.originalname
112	0.0038	0.0038290023803711	SELECT * FROM productoffers WHERE product_id = '791' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0010	0.0010089874267578	SELECT * FROM productoffers WHERE product_id = '791' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0009	0.00086188316345215	SELECT * FROM productoffers WHERE product_id = 791 ORDER BY price ASC LIMIT 1
115	0.0018	0.0018119812011719	SELECT value FROM productattributes WHERE product_id = '791' AND name = 'ListPriceAmount'
116	0.0013	0.0013060569763184	SELECT value FROM productattributes WHERE product_id = '791' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0014	0.0013511180877686	SELECT * FROM products WHERE id = '793'
118	0.0011	0.0010979175567627	SELECT * FROM productimages WHERE product_id = '793' ORDER BY sortorder ASC
119	0.0014	0.0014181137084961	SELECT * FROM product_image_select WHERE product_id = '793'
120	0.0007	0.00066184997558594	SELECT * FROM productcustomimages WHERE product_id = '793'
121	0.0015	0.0014710426330566	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '793' AND a.name = n.originalname
122	0.0007	0.00074505805969238	SELECT * FROM productoffers WHERE product_id = '793' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0006	0.00063300132751465	SELECT * FROM productoffers WHERE product_id = '793' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0005	0.00052189826965332	SELECT * FROM productoffers WHERE product_id = 793 ORDER BY price ASC LIMIT 1
125	0.0008	0.0007941722869873	SELECT value FROM productattributes WHERE product_id = '793' AND name = 'ListPriceAmount'
126	0.0007	0.00070619583129883	SELECT value FROM productattributes WHERE product_id = '793' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127	0.0010	0.00095415115356445	SELECT * FROM products WHERE id = '1326'
128	0.0011	0.0011179447174072	SELECT * FROM productimages WHERE product_id = '1326' ORDER BY sortorder ASC
129	0.0013	0.0013411045074463	SELECT * FROM product_image_select WHERE product_id = '1326'
130	0.0008	0.00075197219848633	SELECT * FROM productcustomimages WHERE product_id = '1326'
131	0.0019	0.0019090175628662	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1326' AND a.name = n.originalname
132	0.0007	0.00066494941711426	SELECT * FROM productoffers WHERE product_id = '1326' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0006	0.0005500316619873	SELECT * FROM productoffers WHERE product_id = '1326' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0006	0.00055384635925293	SELECT * FROM productoffers WHERE product_id = 1326 ORDER BY price ASC LIMIT 1
135	0.0006	0.00056982040405273	SELECT value FROM productattributes WHERE product_id = '1326' AND name = 'ListPriceAmount'
136	0.0008	0.00075793266296387	SELECT value FROM productattributes WHERE product_id = '1326' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137	0.0009	0.00092887878417969	SELECT * FROM products WHERE id = '811'
138	0.0007	0.00074410438537598	SELECT * FROM productimages WHERE product_id = '811' ORDER BY sortorder ASC
139	0.0012	0.0011651515960693	SELECT * FROM product_image_select WHERE product_id = '811'
140	0.0007	0.0007021427154541	SELECT * FROM productcustomimages WHERE product_id = '811'
141	0.0018	0.0017569065093994	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '811' AND a.name = n.originalname
142	0.0008	0.00076413154602051	SELECT * FROM productoffers WHERE product_id = '811' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0005	0.00053000450134277	SELECT * FROM productoffers WHERE product_id = '811' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0005	0.0004889965057373	SELECT * FROM productoffers WHERE product_id = 811 ORDER BY price ASC LIMIT 1
145	0.0005	0.00054597854614258	SELECT value FROM productattributes WHERE product_id = '811' AND name = 'ListPriceAmount'
146	0.0007	0.000701904296875	SELECT value FROM productattributes WHERE product_id = '811' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0008	0.0008091926574707	SELECT * FROM products WHERE id = '812'
148	0.0009	0.00093698501586914	SELECT * FROM productimages WHERE product_id = '812' ORDER BY sortorder ASC
149	0.0015	0.0015480518341064	SELECT * FROM product_image_select WHERE product_id = '812'
150	0.0011	0.0010719299316406	SELECT * FROM productcustomimages WHERE product_id = '812'
151	0.0025	0.0025339126586914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '812' AND a.name = n.originalname
152	0.0010	0.0009620189666748	SELECT * FROM productoffers WHERE product_id = '812' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0006	0.000640869140625	SELECT * FROM productoffers WHERE product_id = '812' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0007	0.00066304206848145	SELECT * FROM productoffers WHERE product_id = 812 ORDER BY price ASC LIMIT 1
155	0.0007	0.00066113471984863	SELECT value FROM productattributes WHERE product_id = '812' AND name = 'ListPriceAmount'
156	0.0007	0.00067901611328125	SELECT value FROM productattributes WHERE product_id = '812' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157	0.0010	0.0010280609130859	SELECT * FROM products WHERE id = '825'
158	0.0008	0.00084209442138672	SELECT * FROM productimages WHERE product_id = '825' ORDER BY sortorder ASC
159	0.0029	0.0028610229492188	SELECT * FROM product_image_select WHERE product_id = '825'
160	0.0023	0.0022990703582764	SELECT * FROM productcustomimages WHERE product_id = '825'
161	0.0034	0.0034470558166504	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '825' AND a.name = n.originalname
162	0.0019	0.0019209384918213	SELECT * FROM productoffers WHERE product_id = '825' AND merchantid = 'A1X6FK5RDHNB96'
163	0.0011	0.0011050701141357	SELECT * FROM productoffers WHERE product_id = '825' AND price > 0 ORDER BY price ASC LIMIT 1
164	0.0006	0.00064992904663086	SELECT * FROM productoffers WHERE product_id = 825 ORDER BY price ASC LIMIT 1
165	0.0008	0.00081205368041992	SELECT value FROM productattributes WHERE product_id = '825' AND name = 'ListPriceAmount'
166	0.0008	0.00078010559082031	SELECT value FROM productattributes WHERE product_id = '825' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167	0.0012	0.0012180805206299	SELECT * FROM products WHERE id = '833'
168	0.0009	0.0009000301361084	SELECT * FROM productimages WHERE product_id = '833' ORDER BY sortorder ASC
169	0.0015	0.0014541149139404	SELECT * FROM product_image_select WHERE product_id = '833'
170	0.0008	0.00076007843017578	SELECT * FROM productcustomimages WHERE product_id = '833'
171	0.0028	0.0028059482574463	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '833' AND a.name = n.originalname
172	0.0009	0.00088310241699219	SELECT * FROM productoffers WHERE product_id = '833' AND merchantid = 'A1X6FK5RDHNB96'
173	0.0006	0.00060200691223145	SELECT * FROM productoffers WHERE product_id = '833' AND price > 0 ORDER BY price ASC LIMIT 1
174	0.0006	0.00060105323791504	SELECT * FROM productoffers WHERE product_id = 833 ORDER BY price ASC LIMIT 1
175	0.0006	0.00064182281494141	SELECT value FROM productattributes WHERE product_id = '833' AND name = 'ListPriceAmount'
176	0.0007	0.00065803527832031	SELECT value FROM productattributes WHERE product_id = '833' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
177	0.0010	0.00095009803771973	SELECT * FROM products WHERE id = '834'
178	0.0007	0.00070810317993164	SELECT * FROM productimages WHERE product_id = '834' ORDER BY sortorder ASC
179	0.0011	0.0010662078857422	SELECT * FROM product_image_select WHERE product_id = '834'
180	0.0006	0.00055313110351562	SELECT * FROM productcustomimages WHERE product_id = '834'
181	0.0013	0.001323938369751	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '834' AND a.name = n.originalname
182	0.0008	0.00081586837768555	SELECT * FROM productoffers WHERE product_id = '834' AND merchantid = 'A1X6FK5RDHNB96'
183	0.0006	0.00055480003356934	SELECT * FROM productoffers WHERE product_id = '834' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0010	0.00098490715026855	SELECT * FROM productoffers WHERE product_id = 834 ORDER BY price ASC LIMIT 1
185	0.0007	0.00065279006958008	SELECT value FROM productattributes WHERE product_id = '834' AND name = 'ListPriceAmount'
186	0.0007	0.00065898895263672	SELECT value FROM productattributes WHERE product_id = '834' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187	0.0007	0.00068306922912598	SELECT * FROM products WHERE id = '2374'
188	0.0006	0.00061893463134766	SELECT * FROM productimages WHERE product_id = '2374' ORDER BY sortorder ASC
189	0.0008	0.00078296661376953	SELECT * FROM product_image_select WHERE product_id = '2374'
190	0.0005	0.00047707557678223	SELECT * FROM productcustomimages WHERE product_id = '2374'
191	0.0011	0.0011458396911621	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2374' AND a.name = n.originalname
192	0.0006	0.00057101249694824	SELECT * FROM productoffers WHERE product_id = '2374' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0005	0.00053095817565918	SELECT * FROM productoffers WHERE product_id = '2374' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0004	0.00044584274291992	SELECT * FROM productoffers WHERE product_id = 2374 ORDER BY price ASC LIMIT 1
195	0.0005	0.0004878044128418	SELECT value FROM productattributes WHERE product_id = '2374' AND name = 'ListPriceAmount'
196	0.0005	0.00052499771118164	SELECT value FROM productattributes WHERE product_id = '2374' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197	0.0007	0.00068902969360352	SELECT * FROM products WHERE id = '2375'
198	0.0006	0.0005650520324707	SELECT * FROM productimages WHERE product_id = '2375' ORDER BY sortorder ASC
199	0.0007	0.00072503089904785	SELECT * FROM product_image_select WHERE product_id = '2375'
200	0.0005	0.00053000450134277	SELECT * FROM productcustomimages WHERE product_id = '2375'
201	0.0011	0.0010750293731689	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2375' AND a.name = n.originalname
202	0.0013	0.0012898445129395	SELECT * FROM productoffers WHERE product_id = '2375' AND merchantid = 'A1X6FK5RDHNB96'
203	0.0009	0.00085902214050293	SELECT * FROM productoffers WHERE product_id = '2375' AND price > 0 ORDER BY price ASC LIMIT 1
204	0.0009	0.00085091590881348	SELECT * FROM productoffers WHERE product_id = 2375 ORDER BY price ASC LIMIT 1
205	0.0010	0.00098991394042969	SELECT value FROM productattributes WHERE product_id = '2375' AND name = 'ListPriceAmount'
206	0.0009	0.00094008445739746	SELECT value FROM productattributes WHERE product_id = '2375' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207	0.0012	0.0011601448059082	SELECT * FROM products WHERE id = '867'
208	0.0026	0.0025539398193359	SELECT * FROM productimages WHERE product_id = '867' ORDER BY sortorder ASC
209	0.0023	0.0022869110107422	SELECT * FROM product_image_select WHERE product_id = '867'
210	0.0008	0.0008089542388916	SELECT * FROM productcustomimages WHERE product_id = '867'
211	0.0025	0.0024840831756592	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '867' AND a.name = n.originalname
212	0.0018	0.0018179416656494	SELECT * FROM productoffers WHERE product_id = '867' AND merchantid = 'A1X6FK5RDHNB96'
213	0.0009	0.00089812278747559	SELECT * FROM productoffers WHERE product_id = '867' AND price > 0 ORDER BY price ASC LIMIT 1
214	0.0007	0.00067019462585449	SELECT * FROM productoffers WHERE product_id = 867 ORDER BY price ASC LIMIT 1
215	0.0012	0.0012319087982178	SELECT value FROM productattributes WHERE product_id = '867' AND name = 'ListPriceAmount'
216	0.0011	0.0010528564453125	SELECT value FROM productattributes WHERE product_id = '867' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
217	0.0014	0.0013720989227295	SELECT * FROM products WHERE id = '869'
218	0.0013	0.0012791156768799	SELECT * FROM productimages WHERE product_id = '869' ORDER BY sortorder ASC
219	0.0015	0.0015320777893066	SELECT * FROM product_image_select WHERE product_id = '869'
220	0.0008	0.00083088874816895	SELECT * FROM productcustomimages WHERE product_id = '869'
221	0.0024	0.0024099349975586	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '869' AND a.name = n.originalname
222	0.0009	0.00091385841369629	SELECT * FROM productoffers WHERE product_id = '869' AND merchantid = 'A1X6FK5RDHNB96'
223	0.0007	0.00070500373840332	SELECT * FROM productoffers WHERE product_id = '869' AND price > 0 ORDER BY price ASC LIMIT 1
224	0.0007	0.00069904327392578	SELECT value FROM productattributes WHERE product_id = '869' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225	0.0010	0.0010240077972412	SELECT * FROM products WHERE id = '879'
226	0.0009	0.00088000297546387	SELECT * FROM productimages WHERE product_id = '879' ORDER BY sortorder ASC
227	0.0012	0.0012209415435791	SELECT * FROM product_image_select WHERE product_id = '879'
228	0.0007	0.00067400932312012	SELECT * FROM productcustomimages WHERE product_id = '879'
229	0.0025	0.0024571418762207	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '879' AND a.name = n.originalname
230	0.0008	0.00084900856018066	SELECT * FROM productoffers WHERE product_id = '879' AND merchantid = 'A1X6FK5RDHNB96'
231	0.0007	0.00066399574279785	SELECT * FROM productoffers WHERE product_id = '879' AND price > 0 ORDER BY price ASC LIMIT 1
232	0.0005	0.00052595138549805	SELECT * FROM productoffers WHERE product_id = 879 ORDER BY price ASC LIMIT 1
233	0.0006	0.00059080123901367	SELECT value FROM productattributes WHERE product_id = '879' AND name = 'ListPriceAmount'
234	0.0006	0.0005950927734375	SELECT value FROM productattributes WHERE product_id = '879' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235	0.0009	0.00086116790771484	SELECT * FROM products WHERE id = '883'
236	0.0009	0.00092291831970215	SELECT * FROM productimages WHERE product_id = '883' ORDER BY sortorder ASC
237	0.0010	0.00096797943115234	SELECT * FROM product_image_select WHERE product_id = '883'
238	0.0006	0.00062108039855957	SELECT * FROM productcustomimages WHERE product_id = '883'
239	0.0013	0.0013298988342285	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '883' AND a.name = n.originalname
240	0.0007	0.00070881843566895	SELECT * FROM productoffers WHERE product_id = '883' AND merchantid = 'A1X6FK5RDHNB96'
241	0.0007	0.00065898895263672	SELECT * FROM productoffers WHERE product_id = '883' AND price > 0 ORDER BY price ASC LIMIT 1
242	0.0005	0.00052595138549805	SELECT * FROM productoffers WHERE product_id = 883 ORDER BY price ASC LIMIT 1
243	0.0007	0.00066685676574707	SELECT value FROM productattributes WHERE product_id = '883' AND name = 'ListPriceAmount'
244	0.0006	0.0006248950958252	SELECT value FROM productattributes WHERE product_id = '883' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245	0.0008	0.00075101852416992	SELECT * FROM products WHERE id = '885'
246	0.0005	0.00053000450134277	SELECT * FROM productimages WHERE product_id = '885' ORDER BY sortorder ASC
247	0.0008	0.00082707405090332	SELECT * FROM product_image_select WHERE product_id = '885'
248	0.0005	0.00051712989807129	SELECT * FROM productcustomimages WHERE product_id = '885'
249	0.0013	0.0013320446014404	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '885' AND a.name = n.originalname
250	0.0006	0.00056195259094238	SELECT * FROM productoffers WHERE product_id = '885' AND merchantid = 'A1X6FK5RDHNB96'
251	0.0006	0.00060296058654785	SELECT * FROM productoffers WHERE product_id = '885' AND price > 0 ORDER BY price ASC LIMIT 1
252	0.0004	0.00042915344238281	SELECT * FROM productoffers WHERE product_id = 885 ORDER BY price ASC LIMIT 1
253	0.0005	0.00048589706420898	SELECT value FROM productattributes WHERE product_id = '885' AND name = 'ListPriceAmount'
254	0.0005	0.00046205520629883	SELECT value FROM productattributes WHERE product_id = '885' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255	0.0007	0.0006568431854248	SELECT * FROM products WHERE id = '889'
256	0.0006	0.00055789947509766	SELECT * FROM productimages WHERE product_id = '889' ORDER BY sortorder ASC
257	0.0008	0.00083398818969727	SELECT * FROM product_image_select WHERE product_id = '889'
258	0.0005	0.00050187110900879	SELECT * FROM productcustomimages WHERE product_id = '889'
259	0.0010	0.0010180473327637	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '889' AND a.name = n.originalname
260	0.0005	0.00047492980957031	SELECT * FROM productoffers WHERE product_id = '889' AND merchantid = 'A1X6FK5RDHNB96'
261	0.0004	0.00042510032653809	SELECT * FROM productoffers WHERE product_id = '889' AND price > 0 ORDER BY price ASC LIMIT 1
262	0.0004	0.00038886070251465	SELECT * FROM productoffers WHERE product_id = 889 ORDER BY price ASC LIMIT 1
263	0.0004	0.00043487548828125	SELECT value FROM productattributes WHERE product_id = '889' AND name = 'ListPriceAmount'
264	0.0005	0.00050592422485352	SELECT value FROM productattributes WHERE product_id = '889' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265	0.0005	0.0005497932434082	SELECT * FROM products WHERE id = '899'
266	0.0005	0.00050091743469238	SELECT * FROM productimages WHERE product_id = '899' ORDER BY sortorder ASC
267	0.0006	0.00061583518981934	SELECT * FROM product_image_select WHERE product_id = '899'
268	0.0004	0.0004279613494873	SELECT * FROM productcustomimages WHERE product_id = '899'
269	0.0015	0.0015020370483398	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '899' AND a.name = n.originalname
270	0.0005	0.00051522254943848	SELECT * FROM productoffers WHERE product_id = '899' AND merchantid = 'A1X6FK5RDHNB96'
271	0.0004	0.00041007995605469	SELECT * FROM productoffers WHERE product_id = '899' AND price > 0 ORDER BY price ASC LIMIT 1
272	0.0004	0.0003969669342041	SELECT * FROM productoffers WHERE product_id = 899 ORDER BY price ASC LIMIT 1
273	0.0004	0.00043320655822754	SELECT value FROM productattributes WHERE product_id = '899' AND name = 'ListPriceAmount'
274	0.0005	0.00047993659973145	SELECT value FROM productattributes WHERE product_id = '899' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
275	0.0005	0.00053095817565918	SELECT * FROM products WHERE id = '902'
276	0.0004	0.00044894218444824	SELECT * FROM productimages WHERE product_id = '902' ORDER BY sortorder ASC
277	0.0006	0.00058507919311523	SELECT * FROM product_image_select WHERE product_id = '902'
278	0.0004	0.00040507316589355	SELECT * FROM productcustomimages WHERE product_id = '902'
279	0.0008	0.0008389949798584	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '902' AND a.name = n.originalname
280	0.0005	0.00047087669372559	SELECT * FROM productoffers WHERE product_id = '902' AND merchantid = 'A1X6FK5RDHNB96'
281	0.0004	0.00037193298339844	SELECT * FROM productoffers WHERE product_id = '902' AND price > 0 ORDER BY price ASC LIMIT 1
282	0.0004	0.0003809928894043	SELECT * FROM productoffers WHERE product_id = 902 ORDER BY price ASC LIMIT 1
283	0.0004	0.00037384033203125	SELECT value FROM productattributes WHERE product_id = '902' AND name = 'ListPriceAmount'
284	0.0004	0.00042009353637695	SELECT value FROM productattributes WHERE product_id = '902' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
285	0.0016	0.001561164855957	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '791' ORDER BY timestamp DESC
286	0.0004	0.00039482116699219	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '793' ORDER BY timestamp DESC
287	0.0003	0.00034403800964355	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1326' ORDER BY timestamp DESC
288	0.0003	0.00031495094299316	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '811' ORDER BY timestamp DESC
289	0.0003	0.00033283233642578	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '812' ORDER BY timestamp DESC
290	0.0003	0.00029587745666504	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '825' ORDER BY timestamp DESC
291	0.0003	0.00030803680419922	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '833' ORDER BY timestamp DESC
292	0.0003	0.00030207633972168	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '834' ORDER BY timestamp DESC
293	0.0003	0.00029802322387695	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2374' ORDER BY timestamp DESC
294	0.0003	0.00027608871459961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2375' ORDER BY timestamp DESC
295	0.0003	0.00029802322387695	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '867' ORDER BY timestamp DESC
296	0.0003	0.00029611587524414	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '869' ORDER BY timestamp DESC
297	0.0003	0.00030088424682617	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '879' ORDER BY timestamp DESC
298	0.0003	0.00030684471130371	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '883' ORDER BY timestamp DESC
299	0.0003	0.00027298927307129	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '885' ORDER BY timestamp DESC
300	0.0003	0.00029277801513672	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '889' ORDER BY timestamp DESC
301	0.0003	0.00028014183044434	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '899' ORDER BY timestamp DESC
302	0.0003	0.00028896331787109	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '902' ORDER BY timestamp DESC
303	0.0020	0.0019540786743164	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
304	0.0016	0.0016129016876221	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
305	0.0004	0.0004429817199707	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
306	0.0217	0.021731853485107	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
307	0.0017	0.0017139911651611	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
308	0.0005	0.00054383277893066	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
309	0.0006	0.00058579444885254	SELECT * FROM products WHERE id = 1626
310	0.0006	0.00059413909912109	SELECT * FROM products WHERE id = 4041
311	0.0006	0.00060701370239258	SELECT * FROM products WHERE id = 4312
312	0.0006	0.00056815147399902	SELECT * FROM products WHERE id = 777
313	0.0006	0.0006101131439209	SELECT * FROM products WHERE id = 3881
314	0.0006	0.00055193901062012	SELECT * FROM products WHERE id = 4213
315	0.0006	0.00058889389038086	SELECT * FROM products WHERE id = '1626'
316	0.0005	0.00047397613525391	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
317	0.0006	0.00058293342590332	SELECT * FROM product_image_select WHERE product_id = '1626'
318	0.0004	0.00042080879211426	SELECT * FROM productcustomimages WHERE product_id = '1626'
319	0.0009	0.00085783004760742	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
320	0.0005	0.00049710273742676	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
321	0.0004	0.00041389465332031	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
322	0.0004	0.00042819976806641	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
323	0.0006	0.00057387351989746	SELECT * FROM products WHERE id = '4041'
324	0.0005	0.00047898292541504	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
325	0.0006	0.00058507919311523	SELECT * FROM product_image_select WHERE product_id = '4041'
326	0.0004	0.00038814544677734	SELECT * FROM productcustomimages WHERE product_id = '4041'
327	0.0012	0.0012338161468506	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
328	0.0005	0.00052595138549805	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
329	0.0004	0.00042390823364258	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
330	0.0005	0.00045204162597656	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
331	0.0006	0.00060915946960449	SELECT * FROM products WHERE id = '4312'
332	0.0005	0.00047516822814941	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
333	0.0006	0.0006108283996582	SELECT * FROM product_image_select WHERE product_id = '4312'
334	0.0004	0.00043892860412598	SELECT * FROM productcustomimages WHERE product_id = '4312'
335	0.0012	0.0011539459228516	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
336	0.0005	0.00050592422485352	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
337	0.0004	0.00044512748718262	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
338	0.0004	0.00044608116149902	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339	0.0006	0.00060009956359863	SELECT * FROM products WHERE id = '777'
340	0.0006	0.00055503845214844	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
341	0.0007	0.00070500373840332	SELECT * FROM product_image_select WHERE product_id = '777'
342	0.0004	0.00043702125549316	SELECT * FROM productcustomimages WHERE product_id = '777'
343	0.0011	0.0011379718780518	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
344	0.0006	0.0005500316619873	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
345	0.0005	0.00047802925109863	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
346	0.0005	0.00053596496582031	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
347	0.0006	0.0006101131439209	SELECT * FROM products WHERE id = '3881'
348	0.0007	0.00074410438537598	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
349	0.0006	0.00064587593078613	SELECT * FROM product_image_select WHERE product_id = '3881'
350	0.0005	0.00054192543029785	SELECT * FROM productcustomimages WHERE product_id = '3881'
351	0.0012	0.0012049674987793	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
352	0.0005	0.00052285194396973	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
353	0.0004	0.00041604042053223	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
354	0.0004	0.0004420280456543	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355	0.0006	0.00059294700622559	SELECT * FROM products WHERE id = '4213'
356	0.0007	0.00074601173400879	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
357	0.0006	0.00062084197998047	SELECT * FROM product_image_select WHERE product_id = '4213'
358	0.0004	0.0004270076751709	SELECT * FROM productcustomimages WHERE product_id = '4213'
359	0.0016	0.0015730857849121	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
360	0.0006	0.00058794021606445	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
361	0.0005	0.00048303604125977	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
362	0.0005	0.00046110153198242	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363	0.0027	0.0026881694793701	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
364	0.0015	0.0014691352844238	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
365	0.0069	0.0069398880004883	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
366	0.0044	0.0043938159942627	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
367	0.0010	0.0010190010070801	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
368	0.0008	0.0007789134979248	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
369	0.0011	0.0010998249053955	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "2"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 3.1877961158752 seconds

Query Debug - 369 Database Queries. Total time 1.0229 seconds