Search Results for "3"

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

only €22,90

View

Add to Cart

Boite Hermetique pour Café en Acier Inox...

from €28,79

View

Add to Cart

Boite à thé en bois coeur 3 compartiment...

View to See Price

View

Add to Cart

Boîte à thé 3 compartiments gravée d'un ...

only €15,90

View

Add to Cart

Black Temptation [A] Boîte à thé en céra...

View to See Price

View

Add to Cart

peint Motif feuille 6 Section Boîte à th...

View to See Price

View

Add to Cart

Vivaraise Rideau Stonewashed Zeff 140 x ...

from €109,90

View

Add to Cart

Boite à mouchoirs Délicats Derrière la P...

View to See Price

View

Add to Cart

Lipton Thé Vert Citron 25 Sachets 33 g

only €2,47

View

Add to Cart

Koala Superstore Conteneurs portatifs de...

only €23,74

View

Add to Cart

Boîte à thé 9 compartiments en bois et v...

only €32,19

View

Add to Cart

Boîte de Rangement À Biscottes Craquante...

View to See Price

View

Add to Cart

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

only €19,95

View

Add to Cart

FRHOME - 48 capsules compatible Nescafé ...

only €19,00

View

Add to Cart

Boîte à thé en métal orange 300 g motifs...

View to See Price

View

Add to Cart

Mariage Frères - RUSSIAN BREAKFAST - Boî...

only €34,99

View

Add to Cart

Boîte à Couture Fait Maison Empilable et...

only €21,00

View

Add to Cart

Thé rooïbos BADERs Cranberry plus Acerol...

only €7,90

View

Add to Cart

73 to 90 of 360 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.4538338184357	372	1.1334	0

No Amazon API Requests Made.

App Debug - Total Time 1.4538338184357 seconds

Number	Time From Start	Name	Description
1	0.30373787879944	Initialise	Initialise FSB Function
2	0.30961894989014	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.34605979919434	Start of getCategoryListByGroup Function	Before first category groups query
4	0.34760689735413	After initial query	Before first category groups query
5	0.34760689735413	Get Category List for Group	Before the call to getCategoryList function
6	0.34760880470276	Start of GetCategoryList function	Start of the function
7	0.34761095046997	Before getting categories	Query to get specific category list
8	0.34910583496094	After getting categories	Query to get specific category list
9	0.34910702705383	Before getting category custom	Before call to function getCategoryCustom
10	0.37183380126953	After getting category custom	After call to function getCategoryCustom
11	0.37183594703674	Before getting category custom	Before call to function getCategoryCustom
12	0.39636993408203	After getting category custom	After call to function getCategoryCustom
13	0.39637279510498	Before getting category custom	Before call to function getCategoryCustom
14	0.40481686592102	After getting category custom	After call to function getCategoryCustom
15	0.40481781959534	Before getting category custom	Before call to function getCategoryCustom
16	0.40932703018188	After getting category custom	After call to function getCategoryCustom
17	0.4093279838562	Before getting category custom	Before call to function getCategoryCustom
18	0.41353797912598	After getting category custom	After call to function getCategoryCustom
19	0.41353893280029	Before getting category custom	Before call to function getCategoryCustom
20	0.41786694526672	After getting category custom	After call to function getCategoryCustom
21	0.41786694526672	End of GetCategoryList function	End of the function
22	0.41787195205688	Get Category List for Group	Before the call to getCategoryList function
23	0.41787385940552	Start of GetCategoryList function	Start of the function
24	0.41787481307983	Before getting categories	Query to get specific category list
25	0.41827487945557	End of getCategoryListByGroup Function	Before return()
26	1.1677708625793	App Controller End	End of the App controller (called before the controller of every page)
27	1.3619818687439	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.3636379241943	Before Get Options	Before the call to getOptions in the tpl class
29	1.4168889522552	After Get Options	After the call to getOptions in the tpl class
30	1.4169178009033	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.4538249969482	Finalizing debug	Before the debug is output to the page.
32	1.4538338184357	End of App	This is the end of the app logging, final timestamp

Query Debug - 372 Database Queries. Total time 1.1334 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.144.103.205\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746961685'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-05-11 11:08:05' WHERE id = '15'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('3.144.103.205') >= INET_ATON(ip_start) AND INET_ATON('3.144.103.205') <= 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 '3', NOW(), '3.144.103.205'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

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

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

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

		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 '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
SELECT * FROM products WHERE id = '1070'
SELECT * FROM productimages WHERE product_id = '1070' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1070'
SELECT * FROM productcustomimages WHERE product_id = '1070'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1070' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1070' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1070' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3821'
SELECT * FROM productimages WHERE product_id = '3821' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3821' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3821'
SELECT * FROM productcustomimages WHERE product_id = '3821'
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 = '3821'
                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     = '3821'
                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 = 3821
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3821' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3821' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3821' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3821
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3821'
                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 = '3821'
                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     = '3821'
                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 = 3821
SELECT value FROM productattributes WHERE product_id = '3821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3821'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1269'
SELECT * FROM productimages WHERE product_id = '1269' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1269'
SELECT * FROM productcustomimages WHERE product_id = '1269'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1269' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1269' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1269' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1269
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1269'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1269' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2004'
SELECT * FROM productimages WHERE product_id = '2004' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2004'
SELECT * FROM productcustomimages WHERE product_id = '2004'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2004' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2004' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2004' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3760'
SELECT * FROM productimages WHERE product_id = '3760' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3760'
SELECT * FROM productcustomimages WHERE product_id = '3760'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3760' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3760' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3760' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3760
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3760'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3760' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4163'
SELECT * FROM productimages WHERE product_id = '4163' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4163'
SELECT * FROM productcustomimages WHERE product_id = '4163'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4163' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4163' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4163' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4163
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4163'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4322'
SELECT * FROM productimages WHERE product_id = '4322' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4322' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4322'
SELECT * FROM productcustomimages WHERE product_id = '4322'
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 = '4322'
                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     = '4322'
                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 = 4322
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4322' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4322' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4322' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4322
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4322'
                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 = '4322'
                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     = '4322'
                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 = 4322
SELECT value FROM productattributes WHERE product_id = '4322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4322'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1147'
SELECT * FROM productimages WHERE product_id = '1147' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1147'
SELECT * FROM productcustomimages WHERE product_id = '1147'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1147' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1147' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1147' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1147
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1147'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1147' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '913'
SELECT * FROM productimages WHERE product_id = '913' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '913'
SELECT * FROM productcustomimages WHERE product_id = '913'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '913' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '913' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '913' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 913
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '913'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3050'
SELECT * FROM productimages WHERE product_id = '3050' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3050'
SELECT * FROM productcustomimages WHERE product_id = '3050'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3050' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3050' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3050' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3050' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4609'
SELECT * FROM productimages WHERE product_id = '4609' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4609'
SELECT * FROM productcustomimages WHERE product_id = '4609'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4609' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4609' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4609' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4609' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1063'
SELECT * FROM productimages WHERE product_id = '1063' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1063'
SELECT * FROM productcustomimages WHERE product_id = '1063'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1063' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1063' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1063' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1063
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1063'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1063' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1422'
SELECT * FROM productimages WHERE product_id = '1422' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1422'
SELECT * FROM productcustomimages WHERE product_id = '1422'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1422' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1422' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1422' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1422' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4942'
SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4942'
SELECT * FROM productcustomimages WHERE product_id = '4942'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4942' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1505'
SELECT * FROM productimages WHERE product_id = '1505' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1505'
SELECT * FROM productcustomimages WHERE product_id = '1505'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1505' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1505' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1505' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1505
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1505'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1505' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1321'
SELECT * FROM productimages WHERE product_id = '1321' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1321'
SELECT * FROM productcustomimages WHERE product_id = '1321'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1321' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1321' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1321' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1128'
SELECT * FROM productimages WHERE product_id = '1128' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1128'
SELECT * FROM productcustomimages WHERE product_id = '1128'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1128' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1128' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1128' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1128
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1128'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1128' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1044'
SELECT * FROM productimages WHERE product_id = '1044' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1044'
SELECT * FROM productcustomimages WHERE product_id = '1044'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1044' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1044' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1044' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1070' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3821' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1269' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2004' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3760' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4163' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4322' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1147' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '913' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3050' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4609' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1063' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1422' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1505' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1321' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1128' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1044' 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.0018	0.0017750263214111	SELECT parameter, value FROM parameters
2	0.0080	0.0079529285430908	SELECT * FROM `bad_bots`
3	0.0005	0.00047993659973145	SET time_zone = 'Europe/London'
4	0.0029	0.0029168128967285	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0036	0.0035879611968994	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.144.103.205\";}'
6	0.0037	0.0036749839782715	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746961685'
7	0.0042	0.0041952133178711	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0007	0.00070881843566895	UPDATE autorun SET lastrun = '2025-05-11 11:08:05' WHERE id = '15'
9	0.0009	0.00092506408691406	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0038	0.0037760734558105	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0006	0.0005640983581543	SELECT * FROM pages WHERE id = 52
12	0.0048	0.0047979354858398	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0308	0.030768156051636	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0006	0.00057601928710938	SELECT * FROM pages WHERE pagename = 'search'
15	0.0015	0.0015418529510498	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0015	0.00148606300354	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0076	0.0075650215148926	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.0017	0.0016870498657227	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.0011	0.001147985458374	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0004	0.00044393539428711	SELECT id FROM categories WHERE parent_id = '26'
21	0.0055	0.0055110454559326	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.0015	0.0015289783477783	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.0019	0.0019211769104004	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.0016908645629883	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0012	0.001183032989502	SELECT * FROM categorygroups WHERE id = '1'
26	0.0117	0.011682987213135	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.0010	0.0010299682617188	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.0007	0.00065398216247559	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0007	0.00074195861816406	SELECT id FROM categories WHERE parent_id = '27'
30	0.0077	0.0076868534088135	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
31	0.0007	0.00066685676574707	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.0008	0.00082492828369141	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.0006	0.0006101131439209	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0006	0.00056195259094238	SELECT * FROM categorygroups WHERE id = '1'
35	0.0023	0.002349853515625	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36	0.0006	0.00055599212646484	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0005	0.00049996376037598	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0005	0.00053596496582031	SELECT id FROM categories WHERE parent_id = '28'
39	0.0024	0.0024480819702148	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
40	0.0006	0.0005800724029541	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.00057387351989746	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
42	0.0005	0.00046896934509277	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0004	0.00040912628173828	SELECT * FROM categorygroups WHERE id = '1'
44	0.0006	0.0005958080291748	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45	0.0005	0.00051498413085938	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.00044894218444824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0004	0.00044083595275879	SELECT id FROM categories WHERE parent_id = '29'
48	0.0007	0.00071191787719727	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
49	0.0005	0.00046801567077637	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
50	0.0005	0.00050902366638184	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.0004	0.00042104721069336	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0004	0.00035715103149414	SELECT * FROM categorygroups WHERE id = '1'
53	0.0006	0.00057196617126465	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
54	0.0005	0.00049185752868652	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.0003	0.0003359317779541	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0003	0.00034713745117188	SELECT id FROM categories WHERE parent_id = '30'
57	0.0007	0.00072503089904785	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.0004	0.00043201446533203	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.00045990943908691	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.0003960132598877	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0004	0.00040602684020996	SELECT * FROM categorygroups WHERE id = '1'
62	0.0006	0.00056099891662598	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.0004	0.00037693977355957	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.0003	0.00033283233642578	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0003	0.00033402442932129	SELECT id FROM categories WHERE parent_id = '31'
66	0.0008	0.00079822540283203	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
67	0.0006	0.0005638599395752	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
68	0.0005	0.00050997734069824	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.0004	0.00043106079101562	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0004	0.00039291381835938	SELECT * FROM categorygroups WHERE id = '1'
71	0.0004	0.0003969669342041	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0030	0.0029749870300293	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0014	0.0013611316680908	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0006	0.00060796737670898	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.0015	0.0014967918395996	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0014	0.0014069080352783	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0011	0.0011229515075684	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.7360	0.7359778881073	SELECT * FROM ipgeocountries WHERE INET_ATON('3.144.103.205') >= INET_ATON(ip_start) AND INET_ATON('3.144.103.205') <= INET_ATON(ip_end)
79	0.0020	0.0019528865814209	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0012	0.001183032989502	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0005	0.00052905082702637	SELECT * FROM pages WHERE pagename = 'search'
82	0.0053	0.0053339004516602	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0016	0.0016369819641113	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0017	0.0016739368438721	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0053	0.0052838325500488	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0019	0.0018601417541504	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0005	0.00052595138549805	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0019	0.0019049644470215	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '3', NOW(), '3.144.103.205'
89	0.0008	0.00083422660827637	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0006	0.00062298774719238	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
91	0.0042	0.0042111873626709	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
92	0.0005	0.00049209594726562	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
93	0.0004	0.00044512748718262	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
94	0.0006	0.00059795379638672	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
95	0.0045	0.0044829845428467	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
96	0.0004	0.00035214424133301	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
97	0.0003	0.00029611587524414	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
98	0.0005	0.00054502487182617	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0005	0.00053691864013672	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0037	0.003715991973877	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
101	0.0005	0.00050806999206543	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
102	0.0003	0.00034713745117188	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '3') OR (title LIKE '3')) AND hide = 0
103	0.0005	0.00053787231445312	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' 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 ('+3'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+3' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0055	0.0054628849029541	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
105	0.0004	0.00036287307739258	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
106	0.0003	0.00031113624572754	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%3%') OR (title LIKE '%3%')) AND hide = 0
107	0.0004	0.0003659725189209	SELECT * FROM products WHERE id = '1070'
108	0.0016	0.0016360282897949	SELECT * FROM productimages WHERE product_id = '1070' ORDER BY sortorder ASC
109	0.0014	0.0013558864593506	SELECT * FROM product_image_select WHERE product_id = '1070'
110	0.0011	0.0010960102081299	SELECT * FROM productcustomimages WHERE product_id = '1070'
111	0.0019	0.0018510818481445	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1070' AND a.name = n.originalname
112	0.0014	0.0013558864593506	SELECT * FROM productoffers WHERE product_id = '1070' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0004	0.00037193298339844	SELECT * FROM productoffers WHERE product_id = '1070' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0017	0.0017299652099609	SELECT value FROM productattributes WHERE product_id = '1070' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115	0.0012	0.0011529922485352	SELECT * FROM products WHERE id = '3821'
116	0.0014	0.0013740062713623	SELECT * FROM productimages WHERE product_id = '3821' ORDER BY sortorder ASC
117	0.0010	0.0010180473327637	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3821' AND p.id = pi.product_id ORDER BY pi.sortorder
118	0.0014	0.0014009475708008	SELECT * FROM product_image_select WHERE product_id = '3821'
119	0.0008	0.000823974609375	SELECT * FROM productcustomimages WHERE product_id = '3821'
120	0.0013	0.0012731552124023	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 = '3821' GROUP BY o.product_id
121	0.0077	0.0077128410339355	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 = '3821' GROUP BY n.displayname ORDER BY n.displayname DESC
122	0.0011	0.0010991096496582	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3821
123	0.0022	0.0021860599517822	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3821' AND a.name = n.originalname
124	0.0006	0.00057196617126465	SELECT * FROM productoffers WHERE product_id = '3821' AND merchantid = 'A1X6FK5RDHNB96'
125	0.0006	0.00060915946960449	SELECT * FROM productoffers WHERE product_id = '3821' AND price > 0 ORDER BY price ASC LIMIT 1
126	0.0006	0.00057387351989746	SELECT * FROM productoffers WHERE product_id = 3821 ORDER BY price ASC LIMIT 1
127	0.0006	0.00064897537231445	SELECT value FROM productattributes WHERE product_id = '3821' AND name = 'ListPriceAmount'
128	0.0007	0.00071406364440918	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 = '3821' GROUP BY o.product_id
129	0.0011	0.00111985206604	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 = '3821' GROUP BY n.displayname ORDER BY n.displayname DESC
130	0.0006	0.00061988830566406	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3821
131	0.0009	0.00092291831970215	SELECT value FROM productattributes WHERE product_id = '3821' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
132	0.0011	0.0010659694671631	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3821' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
133	0.0006	0.0005791187286377	SELECT * FROM products WHERE id = '1269'
134	0.0006	0.00056195259094238	SELECT * FROM productimages WHERE product_id = '1269' ORDER BY sortorder ASC
135	0.0008	0.00079202651977539	SELECT * FROM product_image_select WHERE product_id = '1269'
136	0.0004	0.00044989585876465	SELECT * FROM productcustomimages WHERE product_id = '1269'
137	0.0013	0.0012819766998291	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1269' AND a.name = n.originalname
138	0.0006	0.00064897537231445	SELECT * FROM productoffers WHERE product_id = '1269' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0006	0.00058317184448242	SELECT * FROM productoffers WHERE product_id = '1269' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0005	0.00047898292541504	SELECT * FROM productoffers WHERE product_id = 1269 ORDER BY price ASC LIMIT 1
141	0.0005	0.00054001808166504	SELECT value FROM productattributes WHERE product_id = '1269' AND name = 'ListPriceAmount'
142	0.0006	0.00061416625976562	SELECT value FROM productattributes WHERE product_id = '1269' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
143	0.0007	0.00070500373840332	SELECT * FROM products WHERE id = '2004'
144	0.0006	0.00060415267944336	SELECT * FROM productimages WHERE product_id = '2004' ORDER BY sortorder ASC
145	0.0010	0.0010139942169189	SELECT * FROM product_image_select WHERE product_id = '2004'
146	0.0005	0.0004889965057373	SELECT * FROM productcustomimages WHERE product_id = '2004'
147	0.0011	0.001115083694458	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2004' AND a.name = n.originalname
148	0.0007	0.00071001052856445	SELECT * FROM productoffers WHERE product_id = '2004' AND merchantid = 'A1X6FK5RDHNB96'
149	0.0006	0.00063490867614746	SELECT * FROM productoffers WHERE product_id = '2004' AND price > 0 ORDER BY price ASC LIMIT 1
150	0.0007	0.00065994262695312	SELECT value FROM productattributes WHERE product_id = '2004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151	0.0008	0.00080299377441406	SELECT * FROM products WHERE id = '3760'
152	0.0006	0.00061988830566406	SELECT * FROM productimages WHERE product_id = '3760' ORDER BY sortorder ASC
153	0.0008	0.00076007843017578	SELECT * FROM product_image_select WHERE product_id = '3760'
154	0.0005	0.00049209594726562	SELECT * FROM productcustomimages WHERE product_id = '3760'
155	0.0015	0.0015230178833008	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3760' AND a.name = n.originalname
156	0.0006	0.00056195259094238	SELECT * FROM productoffers WHERE product_id = '3760' AND merchantid = 'A1X6FK5RDHNB96'
157	0.0004	0.00044417381286621	SELECT * FROM productoffers WHERE product_id = '3760' AND price > 0 ORDER BY price ASC LIMIT 1
158	0.0004	0.00041890144348145	SELECT * FROM productoffers WHERE product_id = 3760 ORDER BY price ASC LIMIT 1
159	0.0005	0.00051593780517578	SELECT value FROM productattributes WHERE product_id = '3760' AND name = 'ListPriceAmount'
160	0.0006	0.00055480003356934	SELECT value FROM productattributes WHERE product_id = '3760' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161	0.0006	0.00061202049255371	SELECT * FROM products WHERE id = '4163'
162	0.0006	0.00061488151550293	SELECT * FROM productimages WHERE product_id = '4163' ORDER BY sortorder ASC
163	0.0007	0.00069499015808105	SELECT * FROM product_image_select WHERE product_id = '4163'
164	0.0006	0.00056290626525879	SELECT * FROM productcustomimages WHERE product_id = '4163'
165	0.0013	0.0012531280517578	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4163' AND a.name = n.originalname
166	0.0005	0.00050091743469238	SELECT * FROM productoffers WHERE product_id = '4163' AND merchantid = 'A1X6FK5RDHNB96'
167	0.0004	0.00044083595275879	SELECT * FROM productoffers WHERE product_id = '4163' AND price > 0 ORDER BY price ASC LIMIT 1
168	0.0003	0.00034713745117188	SELECT * FROM productoffers WHERE product_id = 4163 ORDER BY price ASC LIMIT 1
169	0.0004	0.00040197372436523	SELECT value FROM productattributes WHERE product_id = '4163' AND name = 'ListPriceAmount'
170	0.0005	0.00048184394836426	SELECT value FROM productattributes WHERE product_id = '4163' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171	0.0005	0.00053715705871582	SELECT * FROM products WHERE id = '4322'
172	0.0011	0.0011141300201416	SELECT * FROM productimages WHERE product_id = '4322' ORDER BY sortorder ASC
173	0.0027	0.0027430057525635	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4322' AND p.id = pi.product_id ORDER BY pi.sortorder
174	0.0013	0.0012979507446289	SELECT * FROM product_image_select WHERE product_id = '4322'
175	0.0007	0.00066089630126953	SELECT * FROM productcustomimages WHERE product_id = '4322'
176	0.0017	0.0017478466033936	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 = '4322' GROUP BY o.product_id
177	0.0037	0.0037088394165039	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 = '4322' GROUP BY n.displayname ORDER BY n.displayname DESC
178	0.0014	0.0014009475708008	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
179	0.0026	0.0026109218597412	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4322' AND a.name = n.originalname
180	0.0007	0.00069999694824219	SELECT * FROM productoffers WHERE product_id = '4322' AND merchantid = 'A1X6FK5RDHNB96'
181	0.0006	0.0006098747253418	SELECT * FROM productoffers WHERE product_id = '4322' AND price > 0 ORDER BY price ASC LIMIT 1
182	0.0005	0.00054192543029785	SELECT * FROM productoffers WHERE product_id = 4322 ORDER BY price ASC LIMIT 1
183	0.0006	0.00059700012207031	SELECT value FROM productattributes WHERE product_id = '4322' AND name = 'ListPriceAmount'
184	0.0012	0.001190185546875	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 = '4322' GROUP BY o.product_id
185	0.0026	0.0025849342346191	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 = '4322' GROUP BY n.displayname ORDER BY n.displayname DESC
186	0.0010	0.0010099411010742	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4322
187	0.0009	0.00085306167602539	SELECT value FROM productattributes WHERE product_id = '4322' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188	0.0017	0.0017399787902832	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4322' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
189	0.0038	0.003781795501709	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4322' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
190	0.0004	0.00044894218444824	SELECT * FROM products WHERE id = '1147'
191	0.0005	0.00052714347839355	SELECT * FROM productimages WHERE product_id = '1147' ORDER BY sortorder ASC
192	0.0007	0.00067615509033203	SELECT * FROM product_image_select WHERE product_id = '1147'
193	0.0005	0.00050711631774902	SELECT * FROM productcustomimages WHERE product_id = '1147'
194	0.0011	0.0010800361633301	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1147' AND a.name = n.originalname
195	0.0007	0.00067615509033203	SELECT * FROM productoffers WHERE product_id = '1147' AND merchantid = 'A1X6FK5RDHNB96'
196	0.0005	0.00049996376037598	SELECT * FROM productoffers WHERE product_id = '1147' AND price > 0 ORDER BY price ASC LIMIT 1
197	0.0004	0.00043296813964844	SELECT * FROM productoffers WHERE product_id = 1147 ORDER BY price ASC LIMIT 1
198	0.0005	0.00048518180847168	SELECT value FROM productattributes WHERE product_id = '1147' AND name = 'ListPriceAmount'
199	0.0005	0.00053215026855469	SELECT value FROM productattributes WHERE product_id = '1147' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200	0.0005	0.00051307678222656	SELECT * FROM products WHERE id = '913'
201	0.0006	0.00056886672973633	SELECT * FROM productimages WHERE product_id = '913' ORDER BY sortorder ASC
202	0.0007	0.0006568431854248	SELECT * FROM product_image_select WHERE product_id = '913'
203	0.0004	0.00042891502380371	SELECT * FROM productcustomimages WHERE product_id = '913'
204	0.0009	0.0009310245513916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '913' AND a.name = n.originalname
205	0.0005	0.00050687789916992	SELECT * FROM productoffers WHERE product_id = '913' AND merchantid = 'A1X6FK5RDHNB96'
206	0.0004	0.00038695335388184	SELECT * FROM productoffers WHERE product_id = '913' AND price > 0 ORDER BY price ASC LIMIT 1
207	0.0003	0.00033688545227051	SELECT * FROM productoffers WHERE product_id = 913 ORDER BY price ASC LIMIT 1
208	0.0004	0.00036001205444336	SELECT value FROM productattributes WHERE product_id = '913' AND name = 'ListPriceAmount'
209	0.0004	0.00040602684020996	SELECT value FROM productattributes WHERE product_id = '913' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210	0.0005	0.00050497055053711	SELECT * FROM products WHERE id = '3050'
211	0.0005	0.00047993659973145	SELECT * FROM productimages WHERE product_id = '3050' ORDER BY sortorder ASC
212	0.0007	0.00065708160400391	SELECT * FROM product_image_select WHERE product_id = '3050'
213	0.0004	0.00040292739868164	SELECT * FROM productcustomimages WHERE product_id = '3050'
214	0.0013	0.0013329982757568	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3050' AND a.name = n.originalname
215	0.0005	0.00049614906311035	SELECT * FROM productoffers WHERE product_id = '3050' AND merchantid = 'A1X6FK5RDHNB96'
216	0.0004	0.00040698051452637	SELECT * FROM productoffers WHERE product_id = '3050' AND price > 0 ORDER BY price ASC LIMIT 1
217	0.0004	0.00038695335388184	SELECT value FROM productattributes WHERE product_id = '3050' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
218	0.0005	0.00051283836364746	SELECT * FROM products WHERE id = '4609'
219	0.0005	0.00048494338989258	SELECT * FROM productimages WHERE product_id = '4609' ORDER BY sortorder ASC
220	0.0006	0.00060296058654785	SELECT * FROM product_image_select WHERE product_id = '4609'
221	0.0004	0.00039410591125488	SELECT * FROM productcustomimages WHERE product_id = '4609'
222	0.0008	0.0008089542388916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4609' AND a.name = n.originalname
223	0.0005	0.00048303604125977	SELECT * FROM productoffers WHERE product_id = '4609' AND merchantid = 'A1X6FK5RDHNB96'
224	0.0004	0.00041794776916504	SELECT * FROM productoffers WHERE product_id = '4609' AND price > 0 ORDER BY price ASC LIMIT 1
225	0.0004	0.0004420280456543	SELECT value FROM productattributes WHERE product_id = '4609' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
226	0.0005	0.00052499771118164	SELECT * FROM products WHERE id = '1063'
227	0.0005	0.00051212310791016	SELECT * FROM productimages WHERE product_id = '1063' ORDER BY sortorder ASC
228	0.0006	0.00060701370239258	SELECT * FROM product_image_select WHERE product_id = '1063'
229	0.0004	0.00039815902709961	SELECT * FROM productcustomimages WHERE product_id = '1063'
230	0.0010	0.0010330677032471	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1063' AND a.name = n.originalname
231	0.0005	0.00047802925109863	SELECT * FROM productoffers WHERE product_id = '1063' AND merchantid = 'A1X6FK5RDHNB96'
232	0.0004	0.00037002563476562	SELECT * FROM productoffers WHERE product_id = '1063' AND price > 0 ORDER BY price ASC LIMIT 1
233	0.0004	0.00038504600524902	SELECT * FROM productoffers WHERE product_id = 1063 ORDER BY price ASC LIMIT 1
234	0.0004	0.00038790702819824	SELECT value FROM productattributes WHERE product_id = '1063' AND name = 'ListPriceAmount'
235	0.0004	0.00043201446533203	SELECT value FROM productattributes WHERE product_id = '1063' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
236	0.0006	0.00055313110351562	SELECT * FROM products WHERE id = '1422'
237	0.0005	0.00052118301391602	SELECT * FROM productimages WHERE product_id = '1422' ORDER BY sortorder ASC
238	0.0006	0.00058102607727051	SELECT * FROM product_image_select WHERE product_id = '1422'
239	0.0004	0.00038695335388184	SELECT * FROM productcustomimages WHERE product_id = '1422'
240	0.0011	0.0010638236999512	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1422' AND a.name = n.originalname
241	0.0005	0.00052094459533691	SELECT * FROM productoffers WHERE product_id = '1422' AND merchantid = 'A1X6FK5RDHNB96'
242	0.0004	0.00038003921508789	SELECT * FROM productoffers WHERE product_id = '1422' AND price > 0 ORDER BY price ASC LIMIT 1
243	0.0004	0.00041890144348145	SELECT value FROM productattributes WHERE product_id = '1422' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
244	0.0005	0.00048303604125977	SELECT * FROM products WHERE id = '4942'
245	0.0004	0.00040197372436523	SELECT * FROM productimages WHERE product_id = '4942' ORDER BY sortorder ASC
246	0.0006	0.00055503845214844	SELECT * FROM product_image_select WHERE product_id = '4942'
247	0.0003	0.00032401084899902	SELECT * FROM productcustomimages WHERE product_id = '4942'
248	0.0011	0.0010569095611572	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4942' AND a.name = n.originalname
249	0.0004	0.00043702125549316	SELECT * FROM productoffers WHERE product_id = '4942' AND merchantid = 'A1X6FK5RDHNB96'
250	0.0004	0.00040292739868164	SELECT * FROM productoffers WHERE product_id = '4942' AND price > 0 ORDER BY price ASC LIMIT 1
251	0.0005	0.00045514106750488	SELECT value FROM productattributes WHERE product_id = '4942' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
252	0.0005	0.00046086311340332	SELECT * FROM products WHERE id = '1505'
253	0.0004	0.00044417381286621	SELECT * FROM productimages WHERE product_id = '1505' ORDER BY sortorder ASC
254	0.0006	0.00055384635925293	SELECT * FROM product_image_select WHERE product_id = '1505'
255	0.0003	0.00033879280090332	SELECT * FROM productcustomimages WHERE product_id = '1505'
256	0.0010	0.00096297264099121	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1505' AND a.name = n.originalname
257	0.0004	0.00039792060852051	SELECT * FROM productoffers WHERE product_id = '1505' AND merchantid = 'A1X6FK5RDHNB96'
258	0.0004	0.00038409233093262	SELECT * FROM productoffers WHERE product_id = '1505' AND price > 0 ORDER BY price ASC LIMIT 1
259	0.0003	0.00033688545227051	SELECT * FROM productoffers WHERE product_id = 1505 ORDER BY price ASC LIMIT 1
260	0.0003	0.00034284591674805	SELECT value FROM productattributes WHERE product_id = '1505' AND name = 'ListPriceAmount'
261	0.0004	0.00035810470581055	SELECT value FROM productattributes WHERE product_id = '1505' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
262	0.0004	0.0004279613494873	SELECT * FROM products WHERE id = '1321'
263	0.0004	0.00041294097900391	SELECT * FROM productimages WHERE product_id = '1321' ORDER BY sortorder ASC
264	0.0005	0.00053095817565918	SELECT * FROM product_image_select WHERE product_id = '1321'
265	0.0003	0.00032401084899902	SELECT * FROM productcustomimages WHERE product_id = '1321'
266	0.0008	0.00081300735473633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1321' AND a.name = n.originalname
267	0.0004	0.0004429817199707	SELECT * FROM productoffers WHERE product_id = '1321' AND merchantid = 'A1X6FK5RDHNB96'
268	0.0004	0.00035190582275391	SELECT * FROM productoffers WHERE product_id = '1321' AND price > 0 ORDER BY price ASC LIMIT 1
269	0.0004	0.00038290023803711	SELECT value FROM productattributes WHERE product_id = '1321' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270	0.0007	0.00066399574279785	SELECT * FROM products WHERE id = '1128'
271	0.0004	0.00044393539428711	SELECT * FROM productimages WHERE product_id = '1128' ORDER BY sortorder ASC
272	0.0005	0.0005340576171875	SELECT * FROM product_image_select WHERE product_id = '1128'
273	0.0004	0.00035715103149414	SELECT * FROM productcustomimages WHERE product_id = '1128'
274	0.0009	0.00086212158203125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1128' AND a.name = n.originalname
275	0.0005	0.00049090385437012	SELECT * FROM productoffers WHERE product_id = '1128' AND merchantid = 'A1X6FK5RDHNB96'
276	0.0003	0.00034499168395996	SELECT * FROM productoffers WHERE product_id = '1128' AND price > 0 ORDER BY price ASC LIMIT 1
277	0.0003	0.00029897689819336	SELECT * FROM productoffers WHERE product_id = 1128 ORDER BY price ASC LIMIT 1
278	0.0004	0.00037908554077148	SELECT value FROM productattributes WHERE product_id = '1128' AND name = 'ListPriceAmount'
279	0.0004	0.00039005279541016	SELECT value FROM productattributes WHERE product_id = '1128' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280	0.0005	0.00053191184997559	SELECT * FROM products WHERE id = '1044'
281	0.0005	0.00049304962158203	SELECT * FROM productimages WHERE product_id = '1044' ORDER BY sortorder ASC
282	0.0006	0.00055098533630371	SELECT * FROM product_image_select WHERE product_id = '1044'
283	0.0004	0.00037503242492676	SELECT * FROM productcustomimages WHERE product_id = '1044'
284	0.0011	0.0011138916015625	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1044' AND a.name = n.originalname
285	0.0004	0.00044417381286621	SELECT * FROM productoffers WHERE product_id = '1044' AND merchantid = 'A1X6FK5RDHNB96'
286	0.0004	0.00038695335388184	SELECT * FROM productoffers WHERE product_id = '1044' AND price > 0 ORDER BY price ASC LIMIT 1
287	0.0004	0.00038790702819824	SELECT value FROM productattributes WHERE product_id = '1044' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
288	0.0016	0.0015590190887451	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1070' ORDER BY timestamp DESC
289	0.0003	0.00030016899108887	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3821' ORDER BY timestamp DESC
290	0.0003	0.00027298927307129	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1269' ORDER BY timestamp DESC
291	0.0003	0.00028610229492188	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2004' ORDER BY timestamp DESC
292	0.0003	0.00029087066650391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3760' ORDER BY timestamp DESC
293	0.0003	0.00025701522827148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4163' ORDER BY timestamp DESC
294	0.0003	0.00026416778564453	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4322' ORDER BY timestamp DESC
295	0.0003	0.00026607513427734	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1147' ORDER BY timestamp DESC
296	0.0002	0.00023388862609863	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '913' ORDER BY timestamp DESC
297	0.0002	0.00024890899658203	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3050' ORDER BY timestamp DESC
298	0.0002	0.00023698806762695	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4609' ORDER BY timestamp DESC
299	0.0002	0.00024199485778809	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1063' ORDER BY timestamp DESC
300	0.0002	0.00023293495178223	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1422' ORDER BY timestamp DESC
301	0.0003	0.00025796890258789	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4942' ORDER BY timestamp DESC
302	0.0003	0.00026488304138184	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1505' ORDER BY timestamp DESC
303	0.0003	0.0002589225769043	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1321' ORDER BY timestamp DESC
304	0.0003	0.00027990341186523	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1128' ORDER BY timestamp DESC
305	0.0002	0.0002439022064209	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1044' ORDER BY timestamp DESC
306	0.0015	0.0014820098876953	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
307	0.0012	0.0012187957763672	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
308	0.0004	0.00039792060852051	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
309	0.0135	0.013473033905029	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
310	0.0017	0.0017280578613281	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
311	0.0006	0.0005791187286377	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
312	0.0007	0.00070595741271973	SELECT * FROM products WHERE id = 1626
313	0.0004	0.00043392181396484	SELECT * FROM products WHERE id = 4041
314	0.0004	0.00038886070251465	SELECT * FROM products WHERE id = 4312
315	0.0004	0.00040102005004883	SELECT * FROM products WHERE id = 777
316	0.0004	0.00042009353637695	SELECT * FROM products WHERE id = 3881
317	0.0005	0.00051712989807129	SELECT * FROM products WHERE id = 4213
318	0.0004	0.00042891502380371	SELECT * FROM products WHERE id = '1626'
319	0.0007	0.00066900253295898	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
320	0.0006	0.00059103965759277	SELECT * FROM product_image_select WHERE product_id = '1626'
321	0.0004	0.00042104721069336	SELECT * FROM productcustomimages WHERE product_id = '1626'
322	0.0008	0.00083208084106445	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
323	0.0005	0.00046205520629883	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
324	0.0004	0.00041794776916504	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
325	0.0004	0.00041699409484863	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
326	0.0005	0.00051999092102051	SELECT * FROM products WHERE id = '4041'
327	0.0005	0.00047111511230469	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
328	0.0007	0.00065779685974121	SELECT * FROM product_image_select WHERE product_id = '4041'
329	0.0004	0.00039291381835938	SELECT * FROM productcustomimages WHERE product_id = '4041'
330	0.0010	0.0010290145874023	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
331	0.0005	0.00045609474182129	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
332	0.0004	0.00041913986206055	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
333	0.0005	0.00047397613525391	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
334	0.0005	0.00047516822814941	SELECT * FROM products WHERE id = '4312'
335	0.0004	0.00041699409484863	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
336	0.0005	0.00053691864013672	SELECT * FROM product_image_select WHERE product_id = '4312'
337	0.0004	0.00038385391235352	SELECT * FROM productcustomimages WHERE product_id = '4312'
338	0.0011	0.0010709762573242	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
339	0.0005	0.00048494338989258	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
340	0.0004	0.0003669261932373	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
341	0.0004	0.00038909912109375	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342	0.0005	0.00048112869262695	SELECT * FROM products WHERE id = '777'
343	0.0005	0.0004570484161377	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
344	0.0006	0.00057196617126465	SELECT * FROM product_image_select WHERE product_id = '777'
345	0.0004	0.00039505958557129	SELECT * FROM productcustomimages WHERE product_id = '777'
346	0.0011	0.0010530948638916	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
347	0.0004	0.0004420280456543	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
348	0.0004	0.00037097930908203	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
349	0.0004	0.00042080879211426	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350	0.0005	0.0005340576171875	SELECT * FROM products WHERE id = '3881'
351	0.0005	0.00051522254943848	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
352	0.0006	0.00057792663574219	SELECT * FROM product_image_select WHERE product_id = '3881'
353	0.0004	0.00037002563476562	SELECT * FROM productcustomimages WHERE product_id = '3881'
354	0.0010	0.0010499954223633	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
355	0.0005	0.00047183036804199	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
356	0.0004	0.00039505958557129	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
357	0.0004	0.00043296813964844	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358	0.0005	0.00048303604125977	SELECT * FROM products WHERE id = '4213'
359	0.0005	0.00050783157348633	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
360	0.0005	0.00054597854614258	SELECT * FROM product_image_select WHERE product_id = '4213'
361	0.0003	0.00032496452331543	SELECT * FROM productcustomimages WHERE product_id = '4213'
362	0.0011	0.0011489391326904	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
363	0.0005	0.00048398971557617	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
364	0.0004	0.00042080879211426	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
365	0.0005	0.00046014785766602	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
366	0.0019	0.0019140243530273	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
367	0.0007	0.00069808959960938	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
368	0.0024	0.0024218559265137	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
369	0.0019	0.0018970966339111	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
370	0.0005	0.00051212310791016	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
371	0.0014	0.0013630390167236	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
372	0.0012	0.0011570453643799	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "3"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.4538338184357 seconds

Query Debug - 372 Database Queries. Total time 1.1334 seconds