Search Results for "4"

Thé Dammann Frères - Thé Rooibos Citrus ...

only €13,95

View

Add to Cart

Kinghoff Lot de 4 boîtes de conservation...

from €52,46

View

Add to Cart

Vivaraise Coussin uni Zeff

from €21,90

View

Add to Cart

Derrière La Porte DLP : Boîte de Rangeme...

only €18,90

View

Add to Cart

Boîte à Café Hermétique, Boite de Conser...

View to See Price

View

Add to Cart

Boite à thé en Bois - Style Bistrot - Co...

View to See Price

View

Add to Cart

ibili 748560 Boîte à thé avec 9 Comparti...

only €28,44

View

Add to Cart

NATIVES 211148 Lady cupcake Boîte à thé ...

only €9,68

View

Add to Cart

Zeller 15115 Boîte à thé Bois de Polonia...

only €26,84

View

Add to Cart

NATIVES 211147 Lord Brian Boîte à thé Mé...

only €8,17

View

Add to Cart

Tick Tock Vert Bio Rooibos 40 sachets

View to See Price

View

Add to Cart

Dammann Frères - Thé Rooibos CITRUS - 24...

only €19,99

View

Add to Cart

Buzz Boîte à thé en métal Style japonais...

only €37,03

View

Add to Cart

Thé Shangri-La - Népal (Boîte 24 sachets...

only €9,95

View

Add to Cart

Thé Siberian Blend - Imperial Russian (B...

only €9,95

View

Add to Cart

Boîte de conservation alimentaire en cér...

View to See Price

View

Add to Cart

Thé Red Star - Boîte 24 sachets - BIO

only €9,95

View

Add to Cart

Vivaraise Coussin Stonewash Swami Rooibo...

only €32,90

View

Add to Cart

91 to 108 of 336 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
2.1808788776398	401	1.0885	0

No Amazon API Requests Made.

App Debug - Total Time 2.1808788776398 seconds

Number	Time From Start	Name	Description
1	0.95912098884583	Initialise	Initialise FSB Function
2	0.96438479423523	App Controller Start	Start of the App controller (called before the controller of every page)
3	1.002228975296	Start of getCategoryListByGroup Function	Before first category groups query
4	1.0052127838135	After initial query	Before first category groups query
5	1.0052177906036	Get Category List for Group	Before the call to getCategoryList function
6	1.0052239894867	Start of GetCategoryList function	Start of the function
7	1.0052309036255	Before getting categories	Query to get specific category list
8	1.0078408718109	After getting categories	Query to get specific category list
9	1.0078449249268	Before getting category custom	Before call to function getCategoryCustom
10	1.0414760112762	After getting category custom	After call to function getCategoryCustom
11	1.0414807796478	Before getting category custom	Before call to function getCategoryCustom
12	1.0586848258972	After getting category custom	After call to function getCategoryCustom
13	1.0586898326874	Before getting category custom	Before call to function getCategoryCustom
14	1.0686810016632	After getting category custom	After call to function getCategoryCustom
15	1.0686869621277	Before getting category custom	Before call to function getCategoryCustom
16	1.0757110118866	After getting category custom	After call to function getCategoryCustom
17	1.0757157802582	Before getting category custom	Before call to function getCategoryCustom
18	1.0830228328705	After getting category custom	After call to function getCategoryCustom
19	1.083028793335	Before getting category custom	Before call to function getCategoryCustom
20	1.0899097919464	After getting category custom	After call to function getCategoryCustom
21	1.0899147987366	End of GetCategoryList function	End of the function
22	1.0899269580841	Get Category List for Group	Before the call to getCategoryList function
23	1.0899310112	Start of GetCategoryList function	Start of the function
24	1.0899348258972	Before getting categories	Query to get specific category list
25	1.0906047821045	End of getCategoryListByGroup Function	Before return()
26	1.5992369651794	App Controller End	End of the App controller (called before the controller of every page)
27	1.939651966095	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.9429399967194	Before Get Options	Before the call to getOptions in the tpl class
29	2.0562908649445	After Get Options	After the call to getOptions in the tpl class
30	2.0563478469849	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	2.1808569431305	Finalizing debug	Before the debug is output to the page.
32	2.1808769702911	End of App	This is the end of the app logging, final timestamp

Query Debug - 401 Database Queries. Total time 1.0885 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.220.160.162\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738791883'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-05 21:44:43' WHERE id = '13'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
SELECT * FROM pages WHERE id = 52
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'search'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('18.220.160.162') >= INET_ATON(ip_start) AND INET_ATON('18.220.160.162') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'search'
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '18.220.160.162'
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+4'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4'))

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

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

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

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%4%') OR (title LIKE '%4%'))
		AND hide = 0
SELECT * FROM products WHERE id = '4758'
SELECT * FROM productimages WHERE product_id = '4758' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4758'
SELECT * FROM productcustomimages WHERE product_id = '4758'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4758' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4758' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4758
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4758'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1396'
SELECT * FROM productimages WHERE product_id = '1396' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1396' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1396'
SELECT * FROM productcustomimages WHERE product_id = '1396'
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 = '1396'
                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     = '1396'
                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 = 1396
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1396' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1396' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1396' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1396
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1396'
                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 = '1396'
                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     = '1396'
                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 = 1396
SELECT value FROM productattributes WHERE product_id = '1396' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '1396'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '4614'
SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4614' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4614'
SELECT * FROM productcustomimages WHERE product_id = '4614'
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 = '4614'
                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     = '4614'
                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 = 4614
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4614' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4614
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4614'
                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 = '4614'
                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     = '4614'
                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 = 4614
SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4614'
                  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     = '4614'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1247'
SELECT * FROM productimages WHERE product_id = '1247' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1247'
SELECT * FROM productcustomimages WHERE product_id = '1247'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1247' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1247' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1247' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1247
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1247'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3797'
SELECT * FROM productimages WHERE product_id = '3797' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3797' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3797'
SELECT * FROM productcustomimages WHERE product_id = '3797'
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 = '3797'
                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     = '3797'
                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 = 3797
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3797' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3797' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3797' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3797
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3797'
                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 = '3797'
                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     = '3797'
                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 = 3797
SELECT value FROM productattributes WHERE product_id = '3797' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3797'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '3797'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4072' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4072' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4072' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4072
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4072'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '845'
SELECT * FROM productimages WHERE product_id = '845' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '845'
SELECT * FROM productcustomimages WHERE product_id = '845'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '845' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '845' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '845' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 845
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '845'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1404'
SELECT * FROM productimages WHERE product_id = '1404' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1404'
SELECT * FROM productcustomimages WHERE product_id = '1404'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1404' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1404' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1404' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1404' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1487'
SELECT * FROM productimages WHERE product_id = '1487' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1487'
SELECT * FROM productcustomimages WHERE product_id = '1487'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1487' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1487' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1487' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1487' 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 = '1308'
SELECT * FROM productimages WHERE product_id = '1308' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1308'
SELECT * FROM productcustomimages WHERE product_id = '1308'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1308' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1308' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1308' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1308
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1308'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1308' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3646'
SELECT * FROM productimages WHERE product_id = '3646' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3646'
SELECT * FROM productcustomimages WHERE product_id = '3646'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3646' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3646' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3646' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3646
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3646'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3646' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '975'
SELECT * FROM productimages WHERE product_id = '975' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '975'
SELECT * FROM productcustomimages WHERE product_id = '975'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '975' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '975' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '975' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '975' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1309'
SELECT * FROM productimages WHERE product_id = '1309' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1309'
SELECT * FROM productcustomimages WHERE product_id = '1309'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1309' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1309' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1309' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1309
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1309'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1309' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1395'
SELECT * FROM productimages WHERE product_id = '1395' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1395'
SELECT * FROM productcustomimages WHERE product_id = '1395'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1395' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1395' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1395' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1395
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1395'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1395' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1067'
SELECT * FROM productimages WHERE product_id = '1067' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1067'
SELECT * FROM productcustomimages WHERE product_id = '1067'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1067' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1067' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1067' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1067
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1067'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1067' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4206'
SELECT * FROM productimages WHERE product_id = '4206' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4206' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4206'
SELECT * FROM productcustomimages WHERE product_id = '4206'
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 = '4206'
                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     = '4206'
                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 = 4206
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4206' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4206' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4206' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4206
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4206'
                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 = '4206'
                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     = '4206'
                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 = 4206
SELECT value FROM productattributes WHERE product_id = '4206' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4206'
                  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     = '4206'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1479'
SELECT * FROM productimages WHERE product_id = '1479' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1479'
SELECT * FROM productcustomimages WHERE product_id = '1479'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1479' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1479' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1479' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1479
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1479'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1479' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4245'
SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4245'
SELECT * FROM productcustomimages WHERE product_id = '4245'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4245' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4758' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1396' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4614' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1247' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3797' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '845' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1404' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1487' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '777' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1308' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3646' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '975' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1309' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1395' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1067' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4206' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1479' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4245' 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.0030	0.003032922744751	SELECT parameter, value FROM parameters
2	0.0063	0.0063021183013916	SELECT * FROM `bad_bots`
3	0.0012	0.0012238025665283	SET time_zone = 'Europe/London'
4	0.0031	0.003093957901001	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0023	0.0022621154785156	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.220.160.162\";}'
6	0.0022	0.0021719932556152	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738791883'
7	0.0023	0.002255916595459	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00083518028259277	UPDATE autorun SET lastrun = '2025-02-05 21:44:43' WHERE id = '13'
9	0.0006	0.00060915946960449	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0019	0.0018861293792725	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0011	0.0010881423950195	SELECT * FROM pages WHERE id = 52
12	0.0036	0.0035979747772217	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0318	0.031786203384399	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0015	0.0014939308166504	SELECT * FROM pages WHERE pagename = 'search'
15	0.0029	0.0029451847076416	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0026	0.0025539398193359	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0107	0.010653018951416	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.0029	0.0029110908508301	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.0020	0.0019700527191162	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0007	0.00074386596679688	SELECT id FROM categories WHERE parent_id = '26'
21	0.0088	0.0088160037994385	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.0026	0.0025770664215088	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.0029	0.0029220581054688	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.0021	0.0021200180053711	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0006	0.00055193901062012	SELECT * FROM categorygroups WHERE id = '1'
26	0.0058	0.0058290958404541	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.0007	0.00074982643127441	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.0006	0.00060582160949707	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0006	0.00062799453735352	SELECT id FROM categories WHERE parent_id = '27'
30	0.0060	0.0060081481933594	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.00074195861816406	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.0007	0.00070500373840332	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.0007	0.00069403648376465	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0010	0.0010101795196533	SELECT * FROM categorygroups WHERE id = '1'
35	0.0022	0.002202033996582	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.0013	0.0013108253479004	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.0007	0.00070595741271973	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0006	0.00055885314941406	SELECT id FROM categories WHERE parent_id = '28'
39	0.0023	0.0022690296173096	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.00063610076904297	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.0008	0.000762939453125	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.0007	0.00068211555480957	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0007	0.00065994262695312	SELECT * FROM categorygroups WHERE id = '1'
44	0.0009	0.00086688995361328	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.0010	0.0010080337524414	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0005	0.00051188468933105	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0005	0.0005340576171875	SELECT id FROM categories WHERE parent_id = '29'
48	0.0010	0.00095319747924805	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.0007	0.00065398216247559	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
50	0.0007	0.000701904296875	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.0008	0.00077986717224121	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0006	0.00058698654174805	SELECT * FROM categorygroups WHERE id = '1'
53	0.0008	0.00081896781921387	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.0009	0.0009000301361084	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.0006	0.00061392784118652	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0006	0.00062680244445801	SELECT id FROM categories WHERE parent_id = '30'
57	0.0009	0.00094795227050781	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
58	0.0006	0.00061607360839844	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.0009	0.00093317031860352	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.0011	0.0011308193206787	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0005	0.00053906440734863	SELECT * FROM categorygroups WHERE id = '1'
62	0.0009	0.00085783004760742	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63	0.0006	0.00061988830566406	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.0006	0.00064897537231445	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0009	0.00088810920715332	SELECT id FROM categories WHERE parent_id = '31'
66	0.0011	0.0010550022125244	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
67	0.0007	0.00071287155151367	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.0008	0.00075006484985352	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
69	0.0006	0.00060820579528809	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0005	0.00054121017456055	SELECT * FROM categorygroups WHERE id = '1'
71	0.0007	0.00065207481384277	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0038	0.0038318634033203	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0026	0.0025708675384521	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0009	0.00093984603881836	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.0022	0.002249002456665	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0016	0.0016200542449951	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0014	0.001399040222168	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.4804	0.48037695884705	SELECT * FROM ipgeocountries WHERE INET_ATON('18.220.160.162') >= INET_ATON(ip_start) AND INET_ATON('18.220.160.162') <= INET_ATON(ip_end)
79	0.0064	0.0064308643341064	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0025	0.0024850368499756	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0021	0.0020520687103271	SELECT * FROM pages WHERE pagename = 'search'
82	0.0144	0.014439821243286	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0029	0.0029139518737793	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0031	0.0031349658966064	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0096	0.0095870494842529	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0020	0.0020449161529541	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0006	0.00055313110351562	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0027	0.0026600360870361	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '18.220.160.162'
89	0.0017	0.0017030239105225	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0005	0.00053811073303223	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
91	0.0042	0.0042369365692139	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
92	0.0006	0.00060009956359863	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
93	0.0005	0.00047087669372559	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
94	0.0007	0.00065207481384277	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
95	0.0058	0.0058169364929199	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
96	0.0005	0.00046300888061523	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
97	0.0004	0.0003819465637207	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
98	0.0006	0.00061416625976562	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0006	0.00056219100952148	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0060	0.0060129165649414	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '4') OR (keyfeatures LIKE '4') OR (title LIKE '4')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
101	0.0005	0.00049996376037598	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
102	0.0006	0.00056195259094238	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
103	0.0006	0.00058293342590332	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0050	0.004951000213623	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
105	0.0010	0.0009918212890625	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
106	0.0004	0.00036311149597168	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%4%') OR (title LIKE '%4%')) AND hide = 0
107	0.0005	0.00048208236694336	SELECT * FROM products WHERE id = '4758'
108	0.0018	0.0018329620361328	SELECT * FROM productimages WHERE product_id = '4758' ORDER BY sortorder ASC
109	0.0016	0.0015969276428223	SELECT * FROM product_image_select WHERE product_id = '4758'
110	0.0015	0.0014979839324951	SELECT * FROM productcustomimages WHERE product_id = '4758'
111	0.0028	0.0028219223022461	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4758' AND a.name = n.originalname
112	0.0015	0.0014889240264893	SELECT * FROM productoffers WHERE product_id = '4758' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0004	0.00041604042053223	SELECT * FROM productoffers WHERE product_id = '4758' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0005	0.0005190372467041	SELECT * FROM productoffers WHERE product_id = 4758 ORDER BY price ASC LIMIT 1
115	0.0006	0.00062799453735352	SELECT value FROM productattributes WHERE product_id = '4758' AND name = 'ListPriceAmount'
116	0.0005	0.00049805641174316	SELECT value FROM productattributes WHERE product_id = '4758' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0007	0.00068879127502441	SELECT * FROM products WHERE id = '1396'
118	0.0005	0.00047111511230469	SELECT * FROM productimages WHERE product_id = '1396' ORDER BY sortorder ASC
119	0.0007	0.00069594383239746	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1396' AND p.id = pi.product_id ORDER BY pi.sortorder
120	0.0007	0.00066113471984863	SELECT * FROM product_image_select WHERE product_id = '1396'
121	0.0004	0.00041580200195312	SELECT * FROM productcustomimages WHERE product_id = '1396'
122	0.0006	0.00060606002807617	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 = '1396' GROUP BY o.product_id
123	0.0025	0.0025179386138916	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 = '1396' GROUP BY n.displayname ORDER BY n.displayname DESC
124	0.0006	0.00056099891662598	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1396
125	0.0013	0.0012500286102295	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1396' AND a.name = n.originalname
126	0.0007	0.00074195861816406	SELECT * FROM productoffers WHERE product_id = '1396' AND merchantid = 'A1X6FK5RDHNB96'
127	0.0005	0.00049209594726562	SELECT * FROM productoffers WHERE product_id = '1396' AND price > 0 ORDER BY price ASC LIMIT 1
128	0.0005	0.00050783157348633	SELECT * FROM productoffers WHERE product_id = 1396 ORDER BY price ASC LIMIT 1
129	0.0005	0.00054597854614258	SELECT value FROM productattributes WHERE product_id = '1396' AND name = 'ListPriceAmount'
130	0.0006	0.00061202049255371	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 = '1396' GROUP BY o.product_id
131	0.0008	0.00076007843017578	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 = '1396' GROUP BY n.displayname ORDER BY n.displayname DESC
132	0.0005	0.0004730224609375	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1396
133	0.0014	0.0014400482177734	SELECT value FROM productattributes WHERE product_id = '1396' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134	0.0009	0.00087213516235352	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '1396' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
135	0.0007	0.00065803527832031	SELECT * FROM products WHERE id = '4614'
136	0.0009	0.000885009765625	SELECT * FROM productimages WHERE product_id = '4614' ORDER BY sortorder ASC
137	0.0011	0.0010628700256348	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4614' AND p.id = pi.product_id ORDER BY pi.sortorder
138	0.0007	0.00074315071105957	SELECT * FROM product_image_select WHERE product_id = '4614'
139	0.0004	0.00040698051452637	SELECT * FROM productcustomimages WHERE product_id = '4614'
140	0.0007	0.00068306922912598	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 = '4614' GROUP BY o.product_id
141	0.0014	0.001431941986084	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 = '4614' GROUP BY n.displayname ORDER BY n.displayname DESC
142	0.0009	0.00092816352844238	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
143	0.0016	0.0015780925750732	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4614' AND a.name = n.originalname
144	0.0006	0.00060391426086426	SELECT * FROM productoffers WHERE product_id = '4614' AND merchantid = 'A1X6FK5RDHNB96'
145	0.0008	0.00076007843017578	SELECT * FROM productoffers WHERE product_id = '4614' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0006	0.0005791187286377	SELECT * FROM productoffers WHERE product_id = 4614 ORDER BY price ASC LIMIT 1
147	0.0008	0.00079894065856934	SELECT value FROM productattributes WHERE product_id = '4614' AND name = 'ListPriceAmount'
148	0.0012	0.0011858940124512	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 = '4614' GROUP BY o.product_id
149	0.0015	0.0015428066253662	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 = '4614' GROUP BY n.displayname ORDER BY n.displayname DESC
150	0.0009	0.00091886520385742	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4614
151	0.0006	0.00062894821166992	SELECT value FROM productattributes WHERE product_id = '4614' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
152	0.0010	0.0010268688201904	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4614' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
153	0.0008	0.00075602531433105	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4614' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
154	0.0006	0.00057601928710938	SELECT * FROM products WHERE id = '1247'
155	0.0010	0.0010089874267578	SELECT * FROM productimages WHERE product_id = '1247' ORDER BY sortorder ASC
156	0.0011	0.0010530948638916	SELECT * FROM product_image_select WHERE product_id = '1247'
157	0.0009	0.0009009838104248	SELECT * FROM productcustomimages WHERE product_id = '1247'
158	0.0017	0.0016741752624512	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1247' AND a.name = n.originalname
159	0.0010	0.00095891952514648	SELECT * FROM productoffers WHERE product_id = '1247' AND merchantid = 'A1X6FK5RDHNB96'
160	0.0009	0.0008549690246582	SELECT * FROM productoffers WHERE product_id = '1247' AND price > 0 ORDER BY price ASC LIMIT 1
161	0.0004	0.00043392181396484	SELECT * FROM productoffers WHERE product_id = 1247 ORDER BY price ASC LIMIT 1
162	0.0005	0.00051689147949219	SELECT value FROM productattributes WHERE product_id = '1247' AND name = 'ListPriceAmount'
163	0.0008	0.00077700614929199	SELECT value FROM productattributes WHERE product_id = '1247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
164	0.0009	0.00093698501586914	SELECT * FROM products WHERE id = '3797'
165	0.0011	0.0011270046234131	SELECT * FROM productimages WHERE product_id = '3797' ORDER BY sortorder ASC
166	0.0010	0.00098800659179688	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3797' AND p.id = pi.product_id ORDER BY pi.sortorder
167	0.0013	0.0013279914855957	SELECT * FROM product_image_select WHERE product_id = '3797'
168	0.0016	0.0015552043914795	SELECT * FROM productcustomimages WHERE product_id = '3797'
169	0.0008	0.00078010559082031	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 = '3797' GROUP BY o.product_id
170	0.0008	0.0008389949798584	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 = '3797' GROUP BY n.displayname ORDER BY n.displayname DESC
171	0.0004	0.00043106079101562	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3797
172	0.0011	0.0011489391326904	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3797' AND a.name = n.originalname
173	0.0008	0.00076699256896973	SELECT * FROM productoffers WHERE product_id = '3797' AND merchantid = 'A1X6FK5RDHNB96'
174	0.0020	0.0020360946655273	SELECT * FROM productoffers WHERE product_id = '3797' AND price > 0 ORDER BY price ASC LIMIT 1
175	0.0009	0.00086188316345215	SELECT * FROM productoffers WHERE product_id = 3797 ORDER BY price ASC LIMIT 1
176	0.0013	0.0012619495391846	SELECT value FROM productattributes WHERE product_id = '3797' AND name = 'ListPriceAmount'
177	0.0030	0.003026008605957	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 = '3797' GROUP BY o.product_id
178	0.0015	0.0015490055084229	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 = '3797' GROUP BY n.displayname ORDER BY n.displayname DESC
179	0.0006	0.00064301490783691	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3797
180	0.0008	0.00081300735473633	SELECT value FROM productattributes WHERE product_id = '3797' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
181	0.0007	0.00074005126953125	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3797' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
182	0.0006	0.00059008598327637	SELECT * FROM products WHERE parent_id = '3797'
183	0.0015	0.0014610290527344	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4072' AND a.name = n.originalname
184	0.0005	0.00049304962158203	SELECT * FROM productoffers WHERE product_id = '4072' AND merchantid = 'A1X6FK5RDHNB96'
185	0.0005	0.00047516822814941	SELECT * FROM productoffers WHERE product_id = '4072' AND price > 0 ORDER BY price ASC LIMIT 1
186	0.0004	0.00037002563476562	SELECT * FROM productoffers WHERE product_id = 4072 ORDER BY price ASC LIMIT 1
187	0.0005	0.00046801567077637	SELECT value FROM productattributes WHERE product_id = '4072' AND name = 'ListPriceAmount'
188	0.0005	0.00047802925109863	SELECT * FROM products WHERE id = '845'
189	0.0006	0.0005500316619873	SELECT * FROM productimages WHERE product_id = '845' ORDER BY sortorder ASC
190	0.0017	0.0017399787902832	SELECT * FROM product_image_select WHERE product_id = '845'
191	0.0004	0.00042605400085449	SELECT * FROM productcustomimages WHERE product_id = '845'
192	0.0014	0.0013589859008789	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '845' AND a.name = n.originalname
193	0.0029	0.0029218196868896	SELECT * FROM productoffers WHERE product_id = '845' AND merchantid = 'A1X6FK5RDHNB96'
194	0.0011	0.0010931491851807	SELECT * FROM productoffers WHERE product_id = '845' AND price > 0 ORDER BY price ASC LIMIT 1
195	0.0004	0.00041389465332031	SELECT * FROM productoffers WHERE product_id = 845 ORDER BY price ASC LIMIT 1
196	0.0006	0.00060176849365234	SELECT value FROM productattributes WHERE product_id = '845' AND name = 'ListPriceAmount'
197	0.0006	0.00060200691223145	SELECT value FROM productattributes WHERE product_id = '845' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
198	0.0013	0.0013129711151123	SELECT * FROM products WHERE id = '1404'
199	0.0006	0.00061917304992676	SELECT * FROM productimages WHERE product_id = '1404' ORDER BY sortorder ASC
200	0.0011	0.0011100769042969	SELECT * FROM product_image_select WHERE product_id = '1404'
201	0.0015	0.0015289783477783	SELECT * FROM productcustomimages WHERE product_id = '1404'
202	0.0028	0.0028450489044189	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1404' AND a.name = n.originalname
203	0.0010	0.00095701217651367	SELECT * FROM productoffers WHERE product_id = '1404' AND merchantid = 'A1X6FK5RDHNB96'
204	0.0023	0.0023019313812256	SELECT * FROM productoffers WHERE product_id = '1404' AND price > 0 ORDER BY price ASC LIMIT 1
205	0.0027	0.0027470588684082	SELECT value FROM productattributes WHERE product_id = '1404' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
206	0.0008	0.00075888633728027	SELECT * FROM products WHERE id = '1487'
207	0.0006	0.00060296058654785	SELECT * FROM productimages WHERE product_id = '1487' ORDER BY sortorder ASC
208	0.0008	0.00075316429138184	SELECT * FROM product_image_select WHERE product_id = '1487'
209	0.0005	0.0005180835723877	SELECT * FROM productcustomimages WHERE product_id = '1487'
210	0.0025	0.0025351047515869	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1487' AND a.name = n.originalname
211	0.0023	0.0023260116577148	SELECT * FROM productoffers WHERE product_id = '1487' AND merchantid = 'A1X6FK5RDHNB96'
212	0.0015	0.00148606300354	SELECT * FROM productoffers WHERE product_id = '1487' AND price > 0 ORDER BY price ASC LIMIT 1
213	0.0022	0.0021889209747314	SELECT value FROM productattributes WHERE product_id = '1487' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
214	0.0015	0.0014798641204834	SELECT * FROM products WHERE id = '777'
215	0.0009	0.00091195106506348	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
216	0.0010	0.0010230541229248	SELECT * FROM product_image_select WHERE product_id = '777'
217	0.0006	0.00061488151550293	SELECT * FROM productcustomimages WHERE product_id = '777'
218	0.0017	0.0016741752624512	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
219	0.0007	0.00068783760070801	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
220	0.0011	0.001147985458374	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
221	0.0008	0.0007929801940918	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222	0.0007	0.0007178783416748	SELECT * FROM products WHERE id = '1308'
223	0.0007	0.00069785118103027	SELECT * FROM productimages WHERE product_id = '1308' ORDER BY sortorder ASC
224	0.0007	0.00073599815368652	SELECT * FROM product_image_select WHERE product_id = '1308'
225	0.0007	0.00073099136352539	SELECT * FROM productcustomimages WHERE product_id = '1308'
226	0.0020	0.0020241737365723	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1308' AND a.name = n.originalname
227	0.0006	0.00064897537231445	SELECT * FROM productoffers WHERE product_id = '1308' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0008	0.00078797340393066	SELECT * FROM productoffers WHERE product_id = '1308' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0005	0.00054287910461426	SELECT * FROM productoffers WHERE product_id = 1308 ORDER BY price ASC LIMIT 1
230	0.0005	0.00048995018005371	SELECT value FROM productattributes WHERE product_id = '1308' AND name = 'ListPriceAmount'
231	0.0005	0.00052881240844727	SELECT value FROM productattributes WHERE product_id = '1308' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232	0.0009	0.00088715553283691	SELECT * FROM products WHERE id = '3646'
233	0.0009	0.00086498260498047	SELECT * FROM productimages WHERE product_id = '3646' ORDER BY sortorder ASC
234	0.0009	0.00088405609130859	SELECT * FROM product_image_select WHERE product_id = '3646'
235	0.0008	0.00078487396240234	SELECT * FROM productcustomimages WHERE product_id = '3646'
236	0.0015	0.0015499591827393	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3646' AND a.name = n.originalname
237	0.0010	0.00095415115356445	SELECT * FROM productoffers WHERE product_id = '3646' AND merchantid = 'A1X6FK5RDHNB96'
238	0.0013	0.0013158321380615	SELECT * FROM productoffers WHERE product_id = '3646' AND price > 0 ORDER BY price ASC LIMIT 1
239	0.0005	0.0004730224609375	SELECT * FROM productoffers WHERE product_id = 3646 ORDER BY price ASC LIMIT 1
240	0.0006	0.00058388710021973	SELECT value FROM productattributes WHERE product_id = '3646' AND name = 'ListPriceAmount'
241	0.0006	0.00057888031005859	SELECT value FROM productattributes WHERE product_id = '3646' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
242	0.0030	0.0029971599578857	SELECT * FROM products WHERE id = '975'
243	0.0009	0.00089597702026367	SELECT * FROM productimages WHERE product_id = '975' ORDER BY sortorder ASC
244	0.0012	0.0011889934539795	SELECT * FROM product_image_select WHERE product_id = '975'
245	0.0013	0.0012850761413574	SELECT * FROM productcustomimages WHERE product_id = '975'
246	0.0021	0.0020971298217773	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '975' AND a.name = n.originalname
247	0.0023	0.0022850036621094	SELECT * FROM productoffers WHERE product_id = '975' AND merchantid = 'A1X6FK5RDHNB96'
248	0.0012	0.0012009143829346	SELECT * FROM productoffers WHERE product_id = '975' AND price > 0 ORDER BY price ASC LIMIT 1
249	0.0006	0.00062298774719238	SELECT value FROM productattributes WHERE product_id = '975' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250	0.0008	0.00082111358642578	SELECT * FROM products WHERE id = '1309'
251	0.0019	0.0019328594207764	SELECT * FROM productimages WHERE product_id = '1309' ORDER BY sortorder ASC
252	0.0009	0.00087308883666992	SELECT * FROM product_image_select WHERE product_id = '1309'
253	0.0006	0.00063204765319824	SELECT * FROM productcustomimages WHERE product_id = '1309'
254	0.0009	0.00087594985961914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1309' AND a.name = n.originalname
255	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = '1309' AND merchantid = 'A1X6FK5RDHNB96'
256	0.0004	0.00043582916259766	SELECT * FROM productoffers WHERE product_id = '1309' AND price > 0 ORDER BY price ASC LIMIT 1
257	0.0004	0.00039315223693848	SELECT * FROM productoffers WHERE product_id = 1309 ORDER BY price ASC LIMIT 1
258	0.0005	0.0004878044128418	SELECT value FROM productattributes WHERE product_id = '1309' AND name = 'ListPriceAmount'
259	0.0004	0.0004270076751709	SELECT value FROM productattributes WHERE product_id = '1309' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
260	0.0014	0.0013909339904785	SELECT * FROM products WHERE id = '1395'
261	0.0007	0.00068497657775879	SELECT * FROM productimages WHERE product_id = '1395' ORDER BY sortorder ASC
262	0.0008	0.0007789134979248	SELECT * FROM product_image_select WHERE product_id = '1395'
263	0.0006	0.00055599212646484	SELECT * FROM productcustomimages WHERE product_id = '1395'
264	0.0013	0.0013101100921631	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1395' AND a.name = n.originalname
265	0.0005	0.00052690505981445	SELECT * FROM productoffers WHERE product_id = '1395' AND merchantid = 'A1X6FK5RDHNB96'
266	0.0010	0.0010299682617188	SELECT * FROM productoffers WHERE product_id = '1395' AND price > 0 ORDER BY price ASC LIMIT 1
267	0.0004	0.00043892860412598	SELECT * FROM productoffers WHERE product_id = 1395 ORDER BY price ASC LIMIT 1
268	0.0005	0.00049209594726562	SELECT value FROM productattributes WHERE product_id = '1395' AND name = 'ListPriceAmount'
269	0.0009	0.00087594985961914	SELECT value FROM productattributes WHERE product_id = '1395' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
270	0.0013	0.0012729167938232	SELECT * FROM products WHERE id = '1067'
271	0.0013	0.0013489723205566	SELECT * FROM productimages WHERE product_id = '1067' ORDER BY sortorder ASC
272	0.0015	0.0014941692352295	SELECT * FROM product_image_select WHERE product_id = '1067'
273	0.0014	0.0013809204101562	SELECT * FROM productcustomimages WHERE product_id = '1067'
274	0.0020	0.0019848346710205	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1067' AND a.name = n.originalname
275	0.0009	0.00094985961914062	SELECT * FROM productoffers WHERE product_id = '1067' AND merchantid = 'A1X6FK5RDHNB96'
276	0.0005	0.00053691864013672	SELECT * FROM productoffers WHERE product_id = '1067' AND price > 0 ORDER BY price ASC LIMIT 1
277	0.0005	0.00052881240844727	SELECT * FROM productoffers WHERE product_id = 1067 ORDER BY price ASC LIMIT 1
278	0.0006	0.00057601928710938	SELECT value FROM productattributes WHERE product_id = '1067' AND name = 'ListPriceAmount'
279	0.0008	0.00082087516784668	SELECT value FROM productattributes WHERE product_id = '1067' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
280	0.0007	0.00071907043457031	SELECT * FROM products WHERE id = '4206'
281	0.0009	0.00086498260498047	SELECT * FROM productimages WHERE product_id = '4206' ORDER BY sortorder ASC
282	0.0011	0.001082181930542	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4206' AND p.id = pi.product_id ORDER BY pi.sortorder
283	0.0022	0.0022180080413818	SELECT * FROM product_image_select WHERE product_id = '4206'
284	0.0012	0.0011930465698242	SELECT * FROM productcustomimages WHERE product_id = '4206'
285	0.0015	0.001533031463623	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 = '4206' GROUP BY o.product_id
286	0.0023	0.0022618770599365	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 = '4206' GROUP BY n.displayname ORDER BY n.displayname DESC
287	0.0012	0.0011670589447021	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4206
288	0.0037	0.0037081241607666	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4206' AND a.name = n.originalname
289	0.0009	0.0009310245513916	SELECT * FROM productoffers WHERE product_id = '4206' AND merchantid = 'A1X6FK5RDHNB96'
290	0.0010	0.0010008811950684	SELECT * FROM productoffers WHERE product_id = '4206' AND price > 0 ORDER BY price ASC LIMIT 1
291	0.0013	0.0012519359588623	SELECT * FROM productoffers WHERE product_id = 4206 ORDER BY price ASC LIMIT 1
292	0.0013	0.0013198852539062	SELECT value FROM productattributes WHERE product_id = '4206' AND name = 'ListPriceAmount'
293	0.0012	0.0012459754943848	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 = '4206' GROUP BY o.product_id
294	0.0009	0.0009310245513916	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 = '4206' GROUP BY n.displayname ORDER BY n.displayname DESC
295	0.0006	0.00057697296142578	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4206
296	0.0011	0.0011119842529297	SELECT value FROM productattributes WHERE product_id = '4206' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
297	0.0014	0.0014400482177734	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4206' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
298	0.0011	0.0010981559753418	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4206' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
299	0.0006	0.00064897537231445	SELECT * FROM products WHERE id = '1479'
300	0.0010	0.0010471343994141	SELECT * FROM productimages WHERE product_id = '1479' ORDER BY sortorder ASC
301	0.0020	0.0019841194152832	SELECT * FROM product_image_select WHERE product_id = '1479'
302	0.0007	0.0006711483001709	SELECT * FROM productcustomimages WHERE product_id = '1479'
303	0.0042	0.0042459964752197	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1479' AND a.name = n.originalname
304	0.0101	0.010089874267578	SELECT * FROM productoffers WHERE product_id = '1479' AND merchantid = 'A1X6FK5RDHNB96'
305	0.0015	0.0014941692352295	SELECT * FROM productoffers WHERE product_id = '1479' AND price > 0 ORDER BY price ASC LIMIT 1
306	0.0010	0.00098681449890137	SELECT * FROM productoffers WHERE product_id = 1479 ORDER BY price ASC LIMIT 1
307	0.0012	0.0012381076812744	SELECT value FROM productattributes WHERE product_id = '1479' AND name = 'ListPriceAmount'
308	0.0014	0.001446008682251	SELECT value FROM productattributes WHERE product_id = '1479' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
309	0.0025	0.0025079250335693	SELECT * FROM products WHERE id = '4245'
310	0.0011	0.0010888576507568	SELECT * FROM productimages WHERE product_id = '4245' ORDER BY sortorder ASC
311	0.0014	0.0014340877532959	SELECT * FROM product_image_select WHERE product_id = '4245'
312	0.0008	0.00083112716674805	SELECT * FROM productcustomimages WHERE product_id = '4245'
313	0.0034	0.0034148693084717	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4245' AND a.name = n.originalname
314	0.0010	0.0009918212890625	SELECT * FROM productoffers WHERE product_id = '4245' AND merchantid = 'A1X6FK5RDHNB96'
315	0.0007	0.00072598457336426	SELECT * FROM productoffers WHERE product_id = '4245' AND price > 0 ORDER BY price ASC LIMIT 1
316	0.0008	0.00080204010009766	SELECT value FROM productattributes WHERE product_id = '4245' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
317	0.0034	0.0033621788024902	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4758' ORDER BY timestamp DESC
318	0.0006	0.00064492225646973	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1396' ORDER BY timestamp DESC
319	0.0007	0.0007479190826416	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4614' ORDER BY timestamp DESC
320	0.0010	0.0010199546813965	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1247' ORDER BY timestamp DESC
321	0.0008	0.0008389949798584	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3797' ORDER BY timestamp DESC
322	0.0009	0.00085711479187012	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '845' ORDER BY timestamp DESC
323	0.0011	0.0010750293731689	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1404' ORDER BY timestamp DESC
324	0.0007	0.00068020820617676	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1487' ORDER BY timestamp DESC
325	0.0007	0.00068306922912598	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '777' ORDER BY timestamp DESC
326	0.0017	0.0016880035400391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1308' ORDER BY timestamp DESC
327	0.0008	0.00080585479736328	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3646' ORDER BY timestamp DESC
328	0.0007	0.00068998336791992	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '975' ORDER BY timestamp DESC
329	0.0006	0.00064516067504883	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1309' ORDER BY timestamp DESC
330	0.0008	0.00076413154602051	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1395' ORDER BY timestamp DESC
331	0.0006	0.00061702728271484	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1067' ORDER BY timestamp DESC
332	0.0009	0.00087690353393555	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4206' ORDER BY timestamp DESC
333	0.0005	0.0004580020904541	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1479' ORDER BY timestamp DESC
334	0.0005	0.0004730224609375	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4245' ORDER BY timestamp DESC
335	0.0035	0.0034630298614502	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
336	0.0025	0.0025031566619873	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
337	0.0006	0.00062680244445801	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
338	0.0206	0.020629167556763	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
339	0.0022	0.0021629333496094	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
340	0.0006	0.00063490867614746	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
341	0.0009	0.00091290473937988	SELECT * FROM products WHERE id = 1626
342	0.0006	0.00057792663574219	SELECT * FROM products WHERE id = 4041
343	0.0005	0.0005040168762207	SELECT * FROM products WHERE id = 4312
344	0.0006	0.00061798095703125	SELECT * FROM products WHERE id = 777
345	0.0005	0.00049614906311035	SELECT * FROM products WHERE id = 3881
346	0.0009	0.00088882446289062	SELECT * FROM products WHERE id = 4213
347	0.0026	0.0026328563690186	SELECT * FROM products WHERE id = '1626'
348	0.0014	0.0014200210571289	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
349	0.0014	0.0014059543609619	SELECT * FROM product_image_select WHERE product_id = '1626'
350	0.0008	0.00081014633178711	SELECT * FROM productcustomimages WHERE product_id = '1626'
351	0.0037	0.0036518573760986	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
352	0.0030	0.0029928684234619	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
353	0.0015	0.0015270709991455	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
354	0.0014	0.0013649463653564	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
355	0.0015	0.0014579296112061	SELECT * FROM products WHERE id = '4041'
356	0.0014	0.0014281272888184	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
357	0.0024	0.002432107925415	SELECT * FROM product_image_select WHERE product_id = '4041'
358	0.0008	0.00082707405090332	SELECT * FROM productcustomimages WHERE product_id = '4041'
359	0.0053	0.005342960357666	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
360	0.0009	0.00092411041259766	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
361	0.0008	0.00082182884216309	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
362	0.0010	0.0010249614715576	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
363	0.0008	0.00084805488586426	SELECT * FROM products WHERE id = '4312'
364	0.0009	0.00088095664978027	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
365	0.0012	0.0012319087982178	SELECT * FROM product_image_select WHERE product_id = '4312'
366	0.0007	0.00074386596679688	SELECT * FROM productcustomimages WHERE product_id = '4312'
367	0.0037	0.0036978721618652	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
368	0.0011	0.0010790824890137	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
369	0.0014	0.0014259815216064	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
370	0.0013	0.0012907981872559	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
371	0.0014	0.0013918876647949	SELECT * FROM products WHERE id = '777'
372	0.0010	0.0010349750518799	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
373	0.0013	0.0012650489807129	SELECT * FROM product_image_select WHERE product_id = '777'
374	0.0006	0.00057005882263184	SELECT * FROM productcustomimages WHERE product_id = '777'
375	0.0027	0.0026788711547852	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
376	0.0010	0.0010080337524414	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
377	0.0010	0.0010199546813965	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
378	0.0017	0.0017130374908447	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
379	0.0015	0.0014729499816895	SELECT * FROM products WHERE id = '3881'
380	0.0011	0.0010600090026855	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
381	0.0013	0.001305103302002	SELECT * FROM product_image_select WHERE product_id = '3881'
382	0.0005	0.00046586990356445	SELECT * FROM productcustomimages WHERE product_id = '3881'
383	0.0017	0.0016789436340332	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
384	0.0007	0.00072693824768066	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
385	0.0006	0.00062799453735352	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
386	0.0015	0.0014569759368896	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
387	0.0026	0.0025820732116699	SELECT * FROM products WHERE id = '4213'
388	0.0008	0.00082898139953613	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
389	0.0008	0.00083088874816895	SELECT * FROM product_image_select WHERE product_id = '4213'
390	0.0007	0.00066304206848145	SELECT * FROM productcustomimages WHERE product_id = '4213'
391	0.0020	0.0019550323486328	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
392	0.0009	0.0008699893951416	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
393	0.0006	0.00063705444335938	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
394	0.0005	0.00049996376037598	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
395	0.0036	0.0036108493804932	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
396	0.0009	0.00093793869018555	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
397	0.0035	0.0034651756286621	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
398	0.0028	0.0027799606323242	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
399	0.0008	0.00077104568481445	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
400	0.0013	0.0013210773468018	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
401	0.0007	0.0006721019744873	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "4"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 2.1808788776398 seconds

Query Debug - 401 Database Queries. Total time 1.0885 seconds