Search Results for "2"

matches21 Pomme cuite Noël thé Licorne d...

View to See Price

View

Add to Cart

Blanc/naturel à thé en bois Boîte de ran...

View to See Price

View

Add to Cart

Boîte train d'hiver Noël Boîte à thé Boî...

View to See Price

View

Add to Cart

matches21 Licorne Thé Lot de 2 Stk. pail...

View to See Price

View

Add to Cart

matches21 Licorne Thé Lot de 2 Stk. Lico...

View to See Price

View

Add to Cart

Bois naturel Thé Boîte de rangement/boît...

only €19,80

View

Add to Cart

matches21 Licorne Thé Lot de 2 Stk. funk...

View to See Price

View

Add to Cart

matches21 Licorne Thé Lot de 2 Stk. Lico...

View to See Price

View

Add to Cart

matches21 Rooibos Bos Thé mélange de cit...

View to See Price

View

Add to Cart

matches21 oranges de cannelle Thé hiver ...

View to See Price

View

Add to Cart

matches21 Thé Licorne Diva de thé moyen ...

View to See Price

View

Add to Cart

matches21 Thé hiver Wölkchen de thé moye...

View to See Price

View

Add to Cart

Boîte à thé et à café 19 cm-lot de 2...

only €32,68

View

Add to Cart

Boîte pour sachets de thé en bois 6 plac...

View to See Price

View

Add to Cart

Kinghoff Rangement de cuisine de 4 pièce...

View to See Price

View

Add to Cart

Boîte à thé en verre 800 g avec couvercl...

View to See Price

View

Add to Cart

Heath & Heather | Organic Rooibos Te...

View to See Price

View

Add to Cart

Heath & Heather | Organic Rooibos Te...

View to See Price

View

Add to Cart

433 to 450 of 532 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.675479888916	385	1.0111	0

No Amazon API Requests Made.

App Debug - Total Time 1.675479888916 seconds

Number	Time From Start	Name	Description
1	0.43426394462585	Initialise	Initialise FSB Function
2	0.4404399394989	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.48056602478027	Start of getCategoryListByGroup Function	Before first category groups query
4	0.48206400871277	After initial query	Before first category groups query
5	0.4820659160614	Get Category List for Group	Before the call to getCategoryList function
6	0.48206901550293	Start of GetCategoryList function	Start of the function
7	0.48207306861877	Before getting categories	Query to get specific category list
8	0.48366093635559	After getting categories	Query to get specific category list
9	0.4836630821228	Before getting category custom	Before call to function getCategoryCustom
10	0.50854587554932	After getting category custom	After call to function getCategoryCustom
11	0.50854992866516	Before getting category custom	Before call to function getCategoryCustom
12	0.52003788948059	After getting category custom	After call to function getCategoryCustom
13	0.52004098892212	Before getting category custom	Before call to function getCategoryCustom
14	0.52644109725952	After getting category custom	After call to function getCategoryCustom
15	0.52644300460815	Before getting category custom	Before call to function getCategoryCustom
16	0.5317690372467	After getting category custom	After call to function getCategoryCustom
17	0.53177094459534	Before getting category custom	Before call to function getCategoryCustom
18	0.53883695602417	After getting category custom	After call to function getCategoryCustom
19	0.53883910179138	Before getting category custom	Before call to function getCategoryCustom
20	0.54923605918884	After getting category custom	After call to function getCategoryCustom
21	0.54923892021179	End of GetCategoryList function	End of the function
22	0.54924607276917	Get Category List for Group	Before the call to getCategoryList function
23	0.54924893379211	Start of GetCategoryList function	Start of the function
24	0.54925203323364	Before getting categories	Query to get specific category list
25	0.5501720905304	End of getCategoryListByGroup Function	Before return()
26	1.0928180217743	App Controller End	End of the App controller (called before the controller of every page)
27	1.3434588909149	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.3461039066315	Before Get Options	Before the call to getOptions in the tpl class
29	1.4354379177094	After Get Options	After the call to getOptions in the tpl class
30	1.4354910850525	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.6754620075226	Finalizing debug	Before the debug is output to the page.
32	1.6754779815674	End of App	This is the end of the app logging, final timestamp

Query Debug - 385 Database Queries. Total time 1.0111 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.141.197.120\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738855380'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-06 15:23:00' WHERE id = '13'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('3.141.197.120') >= INET_ATON(ip_start) AND INET_ATON('3.141.197.120') <= 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(), '3.141.197.120'
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 = '2379'
SELECT * FROM productimages WHERE product_id = '2379' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2379'
SELECT * FROM productcustomimages WHERE product_id = '2379'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2379' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2379' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2379' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2379
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2379'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2379' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2360'
SELECT * FROM productimages WHERE product_id = '2360' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2360'
SELECT * FROM productcustomimages WHERE product_id = '2360'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2360' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2360' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2360' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2360
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2360'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2360' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2361'
SELECT * FROM productimages WHERE product_id = '2361' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2361'
SELECT * FROM productcustomimages WHERE product_id = '2361'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2361' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2361' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2361' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2361
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2361'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2361' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2376'
SELECT * FROM productimages WHERE product_id = '2376' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2376'
SELECT * FROM productcustomimages WHERE product_id = '2376'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2376' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2376' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2376' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2376
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2376'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2376' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2377'
SELECT * FROM productimages WHERE product_id = '2377' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2377'
SELECT * FROM productcustomimages WHERE product_id = '2377'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2377' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2377' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2377
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2377'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2377' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2378'
SELECT * FROM productimages WHERE product_id = '2378' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2378'
SELECT * FROM productcustomimages WHERE product_id = '2378'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2378' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2378' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2378' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2378' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2381'
SELECT * FROM productimages WHERE product_id = '2381' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2381'
SELECT * FROM productcustomimages WHERE product_id = '2381'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2381' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2381' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2381' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2381
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2381'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2381' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2382'
SELECT * FROM productimages WHERE product_id = '2382' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2382'
SELECT * FROM productcustomimages WHERE product_id = '2382'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2382' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2382' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2382
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2382'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2383'
SELECT * FROM productimages WHERE product_id = '2383' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2383'
SELECT * FROM productcustomimages WHERE product_id = '2383'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2383' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2383' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2383' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2383
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2383'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2383' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2384'
SELECT * FROM productimages WHERE product_id = '2384' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2384'
SELECT * FROM productcustomimages WHERE product_id = '2384'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2384' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2384' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2384' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2384
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2384'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2384' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2385'
SELECT * FROM productimages WHERE product_id = '2385' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2385'
SELECT * FROM productcustomimages WHERE product_id = '2385'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2385' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2385' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2385' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2385
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2385'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2385' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2386'
SELECT * FROM productimages WHERE product_id = '2386' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2386'
SELECT * FROM productcustomimages WHERE product_id = '2386'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2386' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2386' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2386
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2386'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2386' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2440'
SELECT * FROM productimages WHERE product_id = '2440' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2440'
SELECT * FROM productcustomimages WHERE product_id = '2440'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2440' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2440' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2440' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2440
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2440'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2440' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2420'
SELECT * FROM productimages WHERE product_id = '2420' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2420'
SELECT * FROM productcustomimages WHERE product_id = '2420'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2420' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2420' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2420' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2420
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2420'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2420' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2447'
SELECT * FROM productimages WHERE product_id = '2447' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2447'
SELECT * FROM productcustomimages WHERE product_id = '2447'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2447' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2447' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2447' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2447
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2447'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2447' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2461'
SELECT * FROM productimages WHERE product_id = '2461' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2461'
SELECT * FROM productcustomimages WHERE product_id = '2461'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2461' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2461' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2461' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2461
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2461'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '2461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2519'
SELECT * FROM productimages WHERE product_id = '2519' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2519' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2519'
SELECT * FROM productcustomimages WHERE product_id = '2519'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2519'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2519'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2519' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2519' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2519' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2519
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2519'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2519'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2519'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
SELECT value FROM productattributes WHERE product_id = '2519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2519'
SELECT * FROM products WHERE id = '2520'
SELECT * FROM productimages WHERE product_id = '2520' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2520' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2520'
SELECT * FROM productcustomimages WHERE product_id = '2520'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2520'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2520'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2520' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2520' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2520' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2520
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2520'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '2520'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '2520'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
SELECT value FROM productattributes WHERE product_id = '2520' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '2520'
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2379' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2360' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2361' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2376' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2377' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2378' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2381' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2382' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2383' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2384' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2385' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2386' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2440' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2420' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2447' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2461' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2519' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2520' ORDER BY timestamp DESC
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0022	0.0022439956665039	SELECT parameter, value FROM parameters
2	0.0072	0.0072450637817383	SELECT * FROM `bad_bots`
3	0.0004	0.00042009353637695	SET time_zone = 'Europe/London'
4	0.0027	0.0027449131011963	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0040	0.003993034362793	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.141.197.120\";}'
6	0.0035	0.0034620761871338	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738855380'
7	0.0046	0.0045571327209473	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00076103210449219	UPDATE autorun SET lastrun = '2025-02-06 15:23:00' WHERE id = '13'
9	0.0010	0.00095796585083008	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0039	0.0038678646087646	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0006	0.00064396858215332	SELECT * FROM pages WHERE id = 52
12	0.0055	0.0055351257324219	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0334	0.033422946929932	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0006	0.00061607360839844	SELECT * FROM pages WHERE pagename = 'search'
15	0.0015	0.0014870166778564	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0016	0.001568078994751	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0073	0.0072691440582275	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.0024	0.0024211406707764	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.0019	0.0019118785858154	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0005	0.00051188468933105	SELECT id FROM categories WHERE parent_id = '26'
21	0.0071	0.0071229934692383	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.0017	0.0016720294952393	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.0017	0.0017030239105225	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.0017	0.0016930103302002	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0005	0.00046110153198242	SELECT * FROM categorygroups WHERE id = '1'
26	0.0037	0.0036709308624268	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.00057005882263184	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.0004	0.0004429817199707	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0007	0.00066184997558594	SELECT id FROM categories WHERE parent_id = '27'
30	0.0040	0.0040409564971924	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.0005	0.00051999092102051	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.0005	0.00052213668823242	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.00054097175598145	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0004	0.00042510032653809	SELECT * FROM categorygroups WHERE id = '1'
35	0.0015	0.001492977142334	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.0005	0.00047492980957031	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.00042390823364258	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.0004880428314209	SELECT id FROM categories WHERE parent_id = '28'
39	0.0015	0.0015418529510498	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.0005	0.00046682357788086	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
41	0.0006	0.00057411193847656	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.0004	0.00044417381286621	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0004	0.00040817260742188	SELECT * FROM categorygroups WHERE id = '1'
44	0.0006	0.00061297416687012	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.0004	0.00042605400085449	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.0004	0.00038003921508789	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0004	0.00042200088500977	SELECT id FROM categories WHERE parent_id = '29'
48	0.0006	0.00062704086303711	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.0008	0.00079512596130371	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
50	0.0007	0.0007021427154541	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.0007	0.00067400932312012	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0006	0.00060796737670898	SELECT * FROM categorygroups WHERE id = '1'
53	0.0007	0.00072097778320312	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.0007	0.00068807601928711	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.00039291381835938	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00045394897460938	SELECT id FROM categories WHERE parent_id = '30'
57	0.0007	0.0006871223449707	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.0005	0.00048303604125977	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.00049781799316406	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.0004	0.00044107437133789	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0026	0.0026090145111084	SELECT * FROM categorygroups WHERE id = '1'
62	0.0015	0.0014591217041016	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.0009	0.0009310245513916	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.0007	0.00067496299743652	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0008	0.00078701972961426	SELECT id FROM categories WHERE parent_id = '31'
66	0.0022	0.0022070407867432	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.0011	0.001140832901001	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.0013	0.0012929439544678	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.0010	0.00098800659179688	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0008	0.00082802772521973	SELECT * FROM categorygroups WHERE id = '1'
71	0.0009	0.00091004371643066	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0076	0.0075647830963135	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0034	0.0033631324768066	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0008	0.00082707405090332	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.0026	0.0025730133056641	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0018	0.00177001953125	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0014	0.0013649463653564	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.5185	0.51846694946289	SELECT * FROM ipgeocountries WHERE INET_ATON('3.141.197.120') >= INET_ATON(ip_start) AND INET_ATON('3.141.197.120') <= INET_ATON(ip_end)
79	0.0030	0.0029780864715576	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0017	0.0017180442810059	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0007	0.00069999694824219	SELECT * FROM pages WHERE pagename = 'search'
82	0.0076	0.007594108581543	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0024	0.002357006072998	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0025	0.0025029182434082	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0070	0.0069708824157715	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0023	0.0022869110107422	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0007	0.00072097778320312	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0021	0.0021219253540039	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '2', NOW(), '3.141.197.120'
89	0.0010	0.0010311603546143	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.0008	0.00076413154602051	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.0055	0.0055270195007324	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.0009	0.0008690357208252	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.0009	0.00089097023010254	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.0007	0.00069880485534668	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.0066	0.0066359043121338	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.0005	0.00045490264892578	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.0004	0.00043892860412598	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.0007	0.00065803527832031	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.0007	0.00065183639526367	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.0051	0.0051050186157227	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.0006	0.00064396858215332	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.0008	0.00078296661376953	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.0013	0.0013470649719238	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.0069	0.0069370269775391	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.0009	0.00087094306945801	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.0014	0.0014231204986572	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.0007	0.00068807601928711	SELECT * FROM products WHERE id = '2379'
108	0.0030	0.0030388832092285	SELECT * FROM productimages WHERE product_id = '2379' ORDER BY sortorder ASC
109	0.0024	0.0023510456085205	SELECT * FROM product_image_select WHERE product_id = '2379'
110	0.0017	0.0017411708831787	SELECT * FROM productcustomimages WHERE product_id = '2379'
111	0.0023	0.0022950172424316	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2379' AND a.name = n.originalname
112	0.0021	0.0021090507507324	SELECT * FROM productoffers WHERE product_id = '2379' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0006	0.00061297416687012	SELECT * FROM productoffers WHERE product_id = '2379' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0005	0.00053095817565918	SELECT * FROM productoffers WHERE product_id = 2379 ORDER BY price ASC LIMIT 1
115	0.0006	0.0006108283996582	SELECT value FROM productattributes WHERE product_id = '2379' AND name = 'ListPriceAmount'
116	0.0005	0.00047397613525391	SELECT value FROM productattributes WHERE product_id = '2379' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0006	0.00064492225646973	SELECT * FROM products WHERE id = '2360'
118	0.0006	0.00059199333190918	SELECT * FROM productimages WHERE product_id = '2360' ORDER BY sortorder ASC
119	0.0012	0.0012319087982178	SELECT * FROM product_image_select WHERE product_id = '2360'
120	0.0005	0.00050783157348633	SELECT * FROM productcustomimages WHERE product_id = '2360'
121	0.0013	0.0013220310211182	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2360' AND a.name = n.originalname
122	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '2360' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0009	0.00089597702026367	SELECT * FROM productoffers WHERE product_id = '2360' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0010	0.00099515914916992	SELECT * FROM productoffers WHERE product_id = 2360 ORDER BY price ASC LIMIT 1
125	0.0005	0.00052309036254883	SELECT value FROM productattributes WHERE product_id = '2360' AND name = 'ListPriceAmount'
126	0.0007	0.00073099136352539	SELECT value FROM productattributes WHERE product_id = '2360' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127	0.0014	0.0014281272888184	SELECT * FROM products WHERE id = '2361'
128	0.0007	0.00066614151000977	SELECT * FROM productimages WHERE product_id = '2361' ORDER BY sortorder ASC
129	0.0008	0.0007939338684082	SELECT * FROM product_image_select WHERE product_id = '2361'
130	0.0005	0.00050997734069824	SELECT * FROM productcustomimages WHERE product_id = '2361'
131	0.0009	0.00093412399291992	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2361' AND a.name = n.originalname
132	0.0006	0.00059890747070312	SELECT * FROM productoffers WHERE product_id = '2361' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0004	0.00043892860412598	SELECT * FROM productoffers WHERE product_id = '2361' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0004	0.00038313865661621	SELECT * FROM productoffers WHERE product_id = 2361 ORDER BY price ASC LIMIT 1
135	0.0004	0.00039196014404297	SELECT value FROM productattributes WHERE product_id = '2361' AND name = 'ListPriceAmount'
136	0.0005	0.00053095817565918	SELECT value FROM productattributes WHERE product_id = '2361' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137	0.0006	0.00064396858215332	SELECT * FROM products WHERE id = '2376'
138	0.0006	0.00059008598327637	SELECT * FROM productimages WHERE product_id = '2376' ORDER BY sortorder ASC
139	0.0007	0.00071096420288086	SELECT * FROM product_image_select WHERE product_id = '2376'
140	0.0005	0.00046491622924805	SELECT * FROM productcustomimages WHERE product_id = '2376'
141	0.0011	0.0010669231414795	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2376' AND a.name = n.originalname
142	0.0006	0.000640869140625	SELECT * FROM productoffers WHERE product_id = '2376' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0005	0.00053000450134277	SELECT * FROM productoffers WHERE product_id = '2376' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0006	0.00057411193847656	SELECT * FROM productoffers WHERE product_id = 2376 ORDER BY price ASC LIMIT 1
145	0.0005	0.00053906440734863	SELECT value FROM productattributes WHERE product_id = '2376' AND name = 'ListPriceAmount'
146	0.0005	0.00047802925109863	SELECT value FROM productattributes WHERE product_id = '2376' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0011	0.0011098384857178	SELECT * FROM products WHERE id = '2377'
148	0.0006	0.00060296058654785	SELECT * FROM productimages WHERE product_id = '2377' ORDER BY sortorder ASC
149	0.0009	0.00094413757324219	SELECT * FROM product_image_select WHERE product_id = '2377'
150	0.0005	0.00048112869262695	SELECT * FROM productcustomimages WHERE product_id = '2377'
151	0.0011	0.0010740756988525	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2377' AND a.name = n.originalname
152	0.0006	0.00064682960510254	SELECT * FROM productoffers WHERE product_id = '2377' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0004	0.0004420280456543	SELECT * FROM productoffers WHERE product_id = '2377' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0004	0.00040102005004883	SELECT * FROM productoffers WHERE product_id = 2377 ORDER BY price ASC LIMIT 1
155	0.0004	0.00043582916259766	SELECT value FROM productattributes WHERE product_id = '2377' AND name = 'ListPriceAmount'
156	0.0005	0.00054097175598145	SELECT value FROM productattributes WHERE product_id = '2377' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157	0.0006	0.00059008598327637	SELECT * FROM products WHERE id = '2378'
158	0.0005	0.00054717063903809	SELECT * FROM productimages WHERE product_id = '2378' ORDER BY sortorder ASC
159	0.0006	0.00061607360839844	SELECT * FROM product_image_select WHERE product_id = '2378'
160	0.0004	0.00038886070251465	SELECT * FROM productcustomimages WHERE product_id = '2378'
161	0.0010	0.0010490417480469	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2378' AND a.name = n.originalname
162	0.0006	0.00064182281494141	SELECT * FROM productoffers WHERE product_id = '2378' AND merchantid = 'A1X6FK5RDHNB96'
163	0.0005	0.00051283836364746	SELECT * FROM productoffers WHERE product_id = '2378' AND price > 0 ORDER BY price ASC LIMIT 1
164	0.0005	0.0005030632019043	SELECT value FROM productattributes WHERE product_id = '2378' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
165	0.0006	0.0005950927734375	SELECT * FROM products WHERE id = '2381'
166	0.0008	0.00076699256896973	SELECT * FROM productimages WHERE product_id = '2381' ORDER BY sortorder ASC
167	0.0007	0.00069093704223633	SELECT * FROM product_image_select WHERE product_id = '2381'
168	0.0004	0.00043606758117676	SELECT * FROM productcustomimages WHERE product_id = '2381'
169	0.0009	0.00086188316345215	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2381' AND a.name = n.originalname
170	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = '2381' AND merchantid = 'A1X6FK5RDHNB96'
171	0.0004	0.00042915344238281	SELECT * FROM productoffers WHERE product_id = '2381' AND price > 0 ORDER BY price ASC LIMIT 1
172	0.0004	0.00043511390686035	SELECT * FROM productoffers WHERE product_id = 2381 ORDER BY price ASC LIMIT 1
173	0.0007	0.00066995620727539	SELECT value FROM productattributes WHERE product_id = '2381' AND name = 'ListPriceAmount'
174	0.0011	0.0011308193206787	SELECT value FROM productattributes WHERE product_id = '2381' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
175	0.0012	0.0011799335479736	SELECT * FROM products WHERE id = '2382'
176	0.0009	0.00090909004211426	SELECT * FROM productimages WHERE product_id = '2382' ORDER BY sortorder ASC
177	0.0015	0.0015189647674561	SELECT * FROM product_image_select WHERE product_id = '2382'
178	0.0008	0.00076413154602051	SELECT * FROM productcustomimages WHERE product_id = '2382'
179	0.0020	0.0020458698272705	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2382' AND a.name = n.originalname
180	0.0012	0.0012469291687012	SELECT * FROM productoffers WHERE product_id = '2382' AND merchantid = 'A1X6FK5RDHNB96'
181	0.0008	0.00079107284545898	SELECT * FROM productoffers WHERE product_id = '2382' AND price > 0 ORDER BY price ASC LIMIT 1
182	0.0006	0.00062799453735352	SELECT * FROM productoffers WHERE product_id = 2382 ORDER BY price ASC LIMIT 1
183	0.0009	0.00087499618530273	SELECT value FROM productattributes WHERE product_id = '2382' AND name = 'ListPriceAmount'
184	0.0011	0.0010731220245361	SELECT value FROM productattributes WHERE product_id = '2382' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185	0.0013	0.001255989074707	SELECT * FROM products WHERE id = '2383'
186	0.0009	0.0009000301361084	SELECT * FROM productimages WHERE product_id = '2383' ORDER BY sortorder ASC
187	0.0014	0.0014309883117676	SELECT * FROM product_image_select WHERE product_id = '2383'
188	0.0009	0.00090789794921875	SELECT * FROM productcustomimages WHERE product_id = '2383'
189	0.0021	0.0021369457244873	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2383' AND a.name = n.originalname
190	0.0010	0.00096797943115234	SELECT * FROM productoffers WHERE product_id = '2383' AND merchantid = 'A1X6FK5RDHNB96'
191	0.0013	0.0012979507446289	SELECT * FROM productoffers WHERE product_id = '2383' AND price > 0 ORDER BY price ASC LIMIT 1
192	0.0007	0.00069379806518555	SELECT * FROM productoffers WHERE product_id = 2383 ORDER BY price ASC LIMIT 1
193	0.0007	0.0007169246673584	SELECT value FROM productattributes WHERE product_id = '2383' AND name = 'ListPriceAmount'
194	0.0009	0.00087380409240723	SELECT value FROM productattributes WHERE product_id = '2383' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195	0.0017	0.0017380714416504	SELECT * FROM products WHERE id = '2384'
196	0.0013	0.0013070106506348	SELECT * FROM productimages WHERE product_id = '2384' ORDER BY sortorder ASC
197	0.0014	0.0013720989227295	SELECT * FROM product_image_select WHERE product_id = '2384'
198	0.0007	0.00066494941711426	SELECT * FROM productcustomimages WHERE product_id = '2384'
199	0.0012	0.0011940002441406	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2384' AND a.name = n.originalname
200	0.0006	0.00063300132751465	SELECT * FROM productoffers WHERE product_id = '2384' AND merchantid = 'A1X6FK5RDHNB96'
201	0.0005	0.00050878524780273	SELECT * FROM productoffers WHERE product_id = '2384' AND price > 0 ORDER BY price ASC LIMIT 1
202	0.0004	0.00044488906860352	SELECT * FROM productoffers WHERE product_id = 2384 ORDER BY price ASC LIMIT 1
203	0.0005	0.00054597854614258	SELECT value FROM productattributes WHERE product_id = '2384' AND name = 'ListPriceAmount'
204	0.0007	0.0006859302520752	SELECT value FROM productattributes WHERE product_id = '2384' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205	0.0009	0.00085806846618652	SELECT * FROM products WHERE id = '2385'
206	0.0006	0.00061511993408203	SELECT * FROM productimages WHERE product_id = '2385' ORDER BY sortorder ASC
207	0.0008	0.00078582763671875	SELECT * FROM product_image_select WHERE product_id = '2385'
208	0.0006	0.00058102607727051	SELECT * FROM productcustomimages WHERE product_id = '2385'
209	0.0013	0.0012979507446289	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2385' AND a.name = n.originalname
210	0.0007	0.0006868839263916	SELECT * FROM productoffers WHERE product_id = '2385' AND merchantid = 'A1X6FK5RDHNB96'
211	0.0006	0.00059008598327637	SELECT * FROM productoffers WHERE product_id = '2385' AND price > 0 ORDER BY price ASC LIMIT 1
212	0.0005	0.0004580020904541	SELECT * FROM productoffers WHERE product_id = 2385 ORDER BY price ASC LIMIT 1
213	0.0005	0.0004570484161377	SELECT value FROM productattributes WHERE product_id = '2385' AND name = 'ListPriceAmount'
214	0.0006	0.00057792663574219	SELECT value FROM productattributes WHERE product_id = '2385' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215	0.0008	0.00083398818969727	SELECT * FROM products WHERE id = '2386'
216	0.0008	0.000762939453125	SELECT * FROM productimages WHERE product_id = '2386' ORDER BY sortorder ASC
217	0.0009	0.00094985961914062	SELECT * FROM product_image_select WHERE product_id = '2386'
218	0.0007	0.00072693824768066	SELECT * FROM productcustomimages WHERE product_id = '2386'
219	0.0013	0.0013010501861572	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2386' AND a.name = n.originalname
220	0.0007	0.00073695182800293	SELECT * FROM productoffers WHERE product_id = '2386' AND merchantid = 'A1X6FK5RDHNB96'
221	0.0005	0.00053882598876953	SELECT * FROM productoffers WHERE product_id = '2386' AND price > 0 ORDER BY price ASC LIMIT 1
222	0.0028	0.0027530193328857	SELECT * FROM productoffers WHERE product_id = 2386 ORDER BY price ASC LIMIT 1
223	0.0013	0.0013301372528076	SELECT value FROM productattributes WHERE product_id = '2386' AND name = 'ListPriceAmount'
224	0.0018	0.0018250942230225	SELECT value FROM productattributes WHERE product_id = '2386' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
225	0.0007	0.00065898895263672	SELECT * FROM products WHERE id = '2440'
226	0.0006	0.00055098533630371	SELECT * FROM productimages WHERE product_id = '2440' ORDER BY sortorder ASC
227	0.0007	0.0006859302520752	SELECT * FROM product_image_select WHERE product_id = '2440'
228	0.0010	0.00095391273498535	SELECT * FROM productcustomimages WHERE product_id = '2440'
229	0.0010	0.00095391273498535	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2440' AND a.name = n.originalname
230	0.0006	0.00057506561279297	SELECT * FROM productoffers WHERE product_id = '2440' AND merchantid = 'A1X6FK5RDHNB96'
231	0.0005	0.00046706199645996	SELECT * FROM productoffers WHERE product_id = '2440' AND price > 0 ORDER BY price ASC LIMIT 1
232	0.0006	0.00060582160949707	SELECT * FROM productoffers WHERE product_id = 2440 ORDER BY price ASC LIMIT 1
233	0.0004	0.00043702125549316	SELECT value FROM productattributes WHERE product_id = '2440' AND name = 'ListPriceAmount'
234	0.0012	0.0011940002441406	SELECT value FROM productattributes WHERE product_id = '2440' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
235	0.0007	0.00065493583679199	SELECT * FROM products WHERE id = '2420'
236	0.0006	0.00058698654174805	SELECT * FROM productimages WHERE product_id = '2420' ORDER BY sortorder ASC
237	0.0007	0.00072789192199707	SELECT * FROM product_image_select WHERE product_id = '2420'
238	0.0005	0.00048089027404785	SELECT * FROM productcustomimages WHERE product_id = '2420'
239	0.0011	0.0010569095611572	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2420' AND a.name = n.originalname
240	0.0007	0.00073504447937012	SELECT * FROM productoffers WHERE product_id = '2420' AND merchantid = 'A1X6FK5RDHNB96'
241	0.0005	0.00050592422485352	SELECT * FROM productoffers WHERE product_id = '2420' AND price > 0 ORDER BY price ASC LIMIT 1
242	0.0005	0.00046396255493164	SELECT * FROM productoffers WHERE product_id = 2420 ORDER BY price ASC LIMIT 1
243	0.0006	0.0006258487701416	SELECT value FROM productattributes WHERE product_id = '2420' AND name = 'ListPriceAmount'
244	0.0005	0.00051593780517578	SELECT value FROM productattributes WHERE product_id = '2420' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245	0.0006	0.0006411075592041	SELECT * FROM products WHERE id = '2447'
246	0.0105	0.010497093200684	SELECT * FROM productimages WHERE product_id = '2447' ORDER BY sortorder ASC
247	0.0013	0.0013301372528076	SELECT * FROM product_image_select WHERE product_id = '2447'
248	0.0007	0.0007021427154541	SELECT * FROM productcustomimages WHERE product_id = '2447'
249	0.0014	0.0014159679412842	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2447' AND a.name = n.originalname
250	0.0008	0.000762939453125	SELECT * FROM productoffers WHERE product_id = '2447' AND merchantid = 'A1X6FK5RDHNB96'
251	0.0006	0.00056099891662598	SELECT * FROM productoffers WHERE product_id = '2447' AND price > 0 ORDER BY price ASC LIMIT 1
252	0.0007	0.00065493583679199	SELECT * FROM productoffers WHERE product_id = 2447 ORDER BY price ASC LIMIT 1
253	0.0006	0.00055098533630371	SELECT value FROM productattributes WHERE product_id = '2447' AND name = 'ListPriceAmount'
254	0.0007	0.00070309638977051	SELECT value FROM productattributes WHERE product_id = '2447' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255	0.0009	0.000946044921875	SELECT * FROM products WHERE id = '2461'
256	0.0007	0.00069117546081543	SELECT * FROM productimages WHERE product_id = '2461' ORDER BY sortorder ASC
257	0.0010	0.00098800659179688	SELECT * FROM product_image_select WHERE product_id = '2461'
258	0.0006	0.00056099891662598	SELECT * FROM productcustomimages WHERE product_id = '2461'
259	0.0014	0.001356840133667	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2461' AND a.name = n.originalname
260	0.0006	0.00061202049255371	SELECT * FROM productoffers WHERE product_id = '2461' AND merchantid = 'A1X6FK5RDHNB96'
261	0.0006	0.00059318542480469	SELECT * FROM productoffers WHERE product_id = '2461' AND price > 0 ORDER BY price ASC LIMIT 1
262	0.0005	0.00046706199645996	SELECT * FROM productoffers WHERE product_id = 2461 ORDER BY price ASC LIMIT 1
263	0.0005	0.00050592422485352	SELECT value FROM productattributes WHERE product_id = '2461' AND name = 'ListPriceAmount'
264	0.0007	0.00072097778320312	SELECT value FROM productattributes WHERE product_id = '2461' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
265	0.0007	0.00074100494384766	SELECT * FROM products WHERE id = '2519'
266	0.0006	0.00064897537231445	SELECT * FROM productimages WHERE product_id = '2519' ORDER BY sortorder ASC
267	0.0006	0.00055098533630371	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2519' AND p.id = pi.product_id ORDER BY pi.sortorder
268	0.0009	0.00085783004760742	SELECT * FROM product_image_select WHERE product_id = '2519'
269	0.0005	0.00048494338989258	SELECT * FROM productcustomimages WHERE product_id = '2519'
270	0.0007	0.00071907043457031	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2519' GROUP BY o.product_id
271	0.0035	0.0035009384155273	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2519' GROUP BY n.displayname ORDER BY n.displayname DESC
272	0.0006	0.0006101131439209	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
273	0.0014	0.0013809204101562	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2519' AND a.name = n.originalname
274	0.0005	0.00051593780517578	SELECT * FROM productoffers WHERE product_id = '2519' AND merchantid = 'A1X6FK5RDHNB96'
275	0.0005	0.00047516822814941	SELECT * FROM productoffers WHERE product_id = '2519' AND price > 0 ORDER BY price ASC LIMIT 1
276	0.0004	0.00042510032653809	SELECT * FROM productoffers WHERE product_id = 2519 ORDER BY price ASC LIMIT 1
277	0.0005	0.00051689147949219	SELECT value FROM productattributes WHERE product_id = '2519' AND name = 'ListPriceAmount'
278	0.0006	0.00055313110351562	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2519' GROUP BY o.product_id
279	0.0007	0.0007331371307373	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2519' GROUP BY n.displayname ORDER BY n.displayname DESC
280	0.0005	0.00047111511230469	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2519
281	0.0007	0.00071406364440918	SELECT value FROM productattributes WHERE product_id = '2519' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282	0.0006	0.00056910514831543	SELECT * FROM products WHERE parent_id = '2519'
283	0.0005	0.00054407119750977	SELECT * FROM products WHERE id = '2520'
284	0.0006	0.0005650520324707	SELECT * FROM productimages WHERE product_id = '2520' ORDER BY sortorder ASC
285	0.0005	0.00046300888061523	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2520' AND p.id = pi.product_id ORDER BY pi.sortorder
286	0.0009	0.00088691711425781	SELECT * FROM product_image_select WHERE product_id = '2520'
287	0.0013	0.0012660026550293	SELECT * FROM productcustomimages WHERE product_id = '2520'
288	0.0006	0.00062704086303711	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2520' GROUP BY o.product_id
289	0.0008	0.00075006484985352	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2520' GROUP BY n.displayname ORDER BY n.displayname DESC
290	0.0005	0.00046682357788086	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
291	0.0013	0.0013399124145508	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2520' AND a.name = n.originalname
292	0.0005	0.00047993659973145	SELECT * FROM productoffers WHERE product_id = '2520' AND merchantid = 'A1X6FK5RDHNB96'
293	0.0005	0.00051712989807129	SELECT * FROM productoffers WHERE product_id = '2520' AND price > 0 ORDER BY price ASC LIMIT 1
294	0.0004	0.00044703483581543	SELECT * FROM productoffers WHERE product_id = 2520 ORDER BY price ASC LIMIT 1
295	0.0005	0.00046706199645996	SELECT value FROM productattributes WHERE product_id = '2520' AND name = 'ListPriceAmount'
296	0.0005	0.00046300888061523	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '2520' GROUP BY o.product_id
297	0.0007	0.0006721019744873	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '2520' GROUP BY n.displayname ORDER BY n.displayname DESC
298	0.0004	0.00043797492980957	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2520
299	0.0008	0.00084805488586426	SELECT value FROM productattributes WHERE product_id = '2520' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
300	0.0005	0.00054788589477539	SELECT * FROM products WHERE parent_id = '2520'
301	0.0018	0.0017669200897217	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2379' ORDER BY timestamp DESC
302	0.0004	0.00039005279541016	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2360' ORDER BY timestamp DESC
303	0.0004	0.0003669261932373	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2361' ORDER BY timestamp DESC
304	0.0003	0.00034999847412109	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2376' ORDER BY timestamp DESC
305	0.0004	0.00038790702819824	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2377' ORDER BY timestamp DESC
306	0.0004	0.00040006637573242	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2378' ORDER BY timestamp DESC
307	0.0004	0.00040602684020996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2381' ORDER BY timestamp DESC
308	0.0004	0.0004429817199707	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2382' ORDER BY timestamp DESC
309	0.0004	0.00037312507629395	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2383' ORDER BY timestamp DESC
310	0.0004	0.00035405158996582	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2384' ORDER BY timestamp DESC
311	0.0004	0.00035595893859863	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2385' ORDER BY timestamp DESC
312	0.0004	0.00035190582275391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2386' ORDER BY timestamp DESC
313	0.0003	0.0003058910369873	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2440' ORDER BY timestamp DESC
314	0.0005	0.00054311752319336	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2420' ORDER BY timestamp DESC
315	0.0005	0.00048613548278809	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2447' ORDER BY timestamp DESC
316	0.0004	0.00037789344787598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2461' ORDER BY timestamp DESC
317	0.0003	0.00032782554626465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2519' ORDER BY timestamp DESC
318	0.0004	0.00036811828613281	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2520' ORDER BY timestamp DESC
319	0.0026	0.0026030540466309	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
320	0.0020	0.0019519329071045	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
321	0.0006	0.00057411193847656	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
322	0.0195	0.019504070281982	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
323	0.0019	0.0019209384918213	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
324	0.0006	0.00060105323791504	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
325	0.0007	0.00066113471984863	SELECT * FROM products WHERE id = 1626
326	0.0004	0.00044488906860352	SELECT * FROM products WHERE id = 4041
327	0.0006	0.00064706802368164	SELECT * FROM products WHERE id = 4312
328	0.0007	0.00065708160400391	SELECT * FROM products WHERE id = 777
329	0.0006	0.00060105323791504	SELECT * FROM products WHERE id = 3881
330	0.0014	0.0014078617095947	SELECT * FROM products WHERE id = 4213
331	0.0005	0.00047898292541504	SELECT * FROM products WHERE id = '1626'
332	0.0006	0.00055503845214844	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
333	0.0010	0.00096893310546875	SELECT * FROM product_image_select WHERE product_id = '1626'
334	0.0007	0.00065112113952637	SELECT * FROM productcustomimages WHERE product_id = '1626'
335	0.0027	0.0026860237121582	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
336	0.0012	0.0012469291687012	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
337	0.0013	0.001255989074707	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
338	0.0014	0.0014200210571289	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339	0.0009	0.00085687637329102	SELECT * FROM products WHERE id = '4041'
340	0.0013	0.0013229846954346	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
341	0.0019	0.0019221305847168	SELECT * FROM product_image_select WHERE product_id = '4041'
342	0.0010	0.00097799301147461	SELECT * FROM productcustomimages WHERE product_id = '4041'
343	0.0034	0.0034031867980957	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
344	0.0009	0.0008549690246582	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
345	0.0011	0.0010678768157959	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
346	0.0011	0.0010581016540527	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
347	0.0010	0.00096607208251953	SELECT * FROM products WHERE id = '4312'
348	0.0010	0.00099992752075195	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
349	0.0010	0.0010318756103516	SELECT * FROM product_image_select WHERE product_id = '4312'
350	0.0007	0.00070595741271973	SELECT * FROM productcustomimages WHERE product_id = '4312'
351	0.0020	0.0020108222961426	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
352	0.0008	0.00075006484985352	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
353	0.0006	0.00063300132751465	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
354	0.0007	0.00066399574279785	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355	0.0008	0.00078010559082031	SELECT * FROM products WHERE id = '777'
356	0.0008	0.00075697898864746	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
357	0.0010	0.00098991394042969	SELECT * FROM product_image_select WHERE product_id = '777'
358	0.0007	0.00067687034606934	SELECT * FROM productcustomimages WHERE product_id = '777'
359	0.0020	0.0019872188568115	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
360	0.0009	0.00090718269348145	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
361	0.0007	0.00065398216247559	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
362	0.0006	0.00063180923461914	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363	0.0008	0.00080204010009766	SELECT * FROM products WHERE id = '3881'
364	0.0008	0.00077414512634277	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
365	0.0008	0.00083613395690918	SELECT * FROM product_image_select WHERE product_id = '3881'
366	0.0009	0.00087404251098633	SELECT * FROM productcustomimages WHERE product_id = '3881'
367	0.0018	0.0017509460449219	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
368	0.0007	0.00065279006958008	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
369	0.0006	0.00057697296142578	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
370	0.0006	0.00061297416687012	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
371	0.0007	0.00073480606079102	SELECT * FROM products WHERE id = '4213'
372	0.0007	0.00074601173400879	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
373	0.0008	0.00081491470336914	SELECT * FROM product_image_select WHERE product_id = '4213'
374	0.0005	0.00050091743469238	SELECT * FROM productcustomimages WHERE product_id = '4213'
375	0.0016	0.0015959739685059	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
376	0.0006	0.00062417984008789	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
377	0.0005	0.00052714347839355	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
378	0.0006	0.00059914588928223	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
379	0.0029	0.0029251575469971	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
380	0.0009	0.00088787078857422	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
381	0.0035	0.0034830570220947	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
382	0.0022	0.002223014831543	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
383	0.0007	0.000701904296875	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
384	0.0012	0.0012459754943848	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
385	0.0014	0.0013608932495117	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 1.675479888916 seconds

Query Debug - 385 Database Queries. Total time 1.0111 seconds