Search Results for "4"

Fontaine à chocolat Princess 292994 – 3 ...

only €30,47

View

Add to Cart

Cémoi Présentoir l'Authentique Petit Our...

€16,50 €12,95

View

Add to Cart

YOGI - Infusion BIO Défenses Immunitaire...

only €2,21

View

Add to Cart

Boîte à Thé à 9 Compartiments Décorative...

only €19,90

View

Add to Cart

Dongsuh Food Rôti de Rooibos thé d’orge ...

only €17,29

View

Add to Cart

Tassimo T-discMilka Chocolat 40 dosettes...

only €36,62

View

Add to Cart

?? CAFE GRAIN 1kg BIO | Café en Grain Ar...

only €32,97

View

Add to Cart

Intense Chocolat Chaud pour Nespresso. I...

only €19,00

View

Add to Cart

Tassimo Dosette Cafe - L'OR Cafe Long Cl...

only €44,90

View

Add to Cart

Artemio 14001011 Boîte à Thé à 4 Compart...

only €8,99

View

Add to Cart

Callebaut N° 70-30-38 (70,5%) - Chocolat...

only €11,35

View

Add to Cart

NICKS Chocodrink, chocolat chaud instant...

only €9,99

View

Add to Cart

Senseo Café Corsé 200 dosettes (Lot de 5...

€48,49 €41,50

View

Add to Cart

Ethiquable Rooibos Afrique du Sud Bio et...

View to See Price

View

Add to Cart

Marque Amazon Solimo Café moulu compatib...

€23,58 €14,69

View

Add to Cart

Boîte de Rangement Beauté C'EST MOI LA P...

only €21,00

View

Add to Cart

SoBuy FRG Porte-Capsules, Boîte de range...

only €29,95

View

Add to Cart

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

only €16,68

View

Add to Cart

1 to 18 of 336 products

1
2
3
4
Next ›

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.7600197792053	351	1.0818	0

No Amazon API Requests Made.

App Debug - Total Time 1.7600197792053 seconds

Number	Time From Start	Name	Description
1	0.48571681976318	Initialise	Initialise FSB Function
2	0.49104499816895	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.52376794815063	Start of getCategoryListByGroup Function	Before first category groups query
4	0.52576994895935	After initial query	Before first category groups query
5	0.52577185630798	Get Category List for Group	Before the call to getCategoryList function
6	0.52577686309814	Start of GetCategoryList function	Start of the function
7	0.52578091621399	Before getting categories	Query to get specific category list
8	0.52854084968567	After getting categories	Query to get specific category list
9	0.5285439491272	Before getting category custom	Before call to function getCategoryCustom
10	0.56782793998718	After getting category custom	After call to function getCategoryCustom
11	0.56783294677734	Before getting category custom	Before call to function getCategoryCustom
12	0.58079099655151	After getting category custom	After call to function getCategoryCustom
13	0.58079481124878	Before getting category custom	Before call to function getCategoryCustom
14	0.5875449180603	After getting category custom	After call to function getCategoryCustom
15	0.58754777908325	Before getting category custom	Before call to function getCategoryCustom
16	0.59258890151978	After getting category custom	After call to function getCategoryCustom
17	0.59259080886841	Before getting category custom	Before call to function getCategoryCustom
18	0.59767079353333	After getting category custom	After call to function getCategoryCustom
19	0.59767389297485	Before getting category custom	Before call to function getCategoryCustom
20	0.60274386405945	After getting category custom	After call to function getCategoryCustom
21	0.60274696350098	End of GetCategoryList function	End of the function
22	0.6027569770813	Get Category List for Group	Before the call to getCategoryList function
23	0.60275983810425	Start of GetCategoryList function	Start of the function
24	0.60276389122009	Before getting categories	Query to get specific category list
25	0.60334587097168	End of getCategoryListByGroup Function	Before return()
26	1.2044458389282	App Controller End	End of the App controller (called before the controller of every page)
27	1.4499027729034	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.4542419910431	Before Get Options	Before the call to getOptions in the tpl class
29	1.5513508319855	After Get Options	After the call to getOptions in the tpl class
30	1.5513918399811	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.7600009441376	Finalizing debug	Before the debug is output to the page.
32	1.760018825531	End of App	This is the end of the app logging, final timestamp

Query Debug - 351 Database Queries. Total time 1.0818 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.225.117.244\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738829560'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-06 08:12:40' 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.225.117.244') >= INET_ATON(ip_start) AND INET_ATON('18.225.117.244') <= 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.225.117.244'
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 = '4950'
SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4950'
SELECT * FROM productcustomimages WHERE product_id = '4950'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4950' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4953'
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4953'
SELECT * FROM productcustomimages WHERE product_id = '4953'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4953' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4925'
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4925'
SELECT * FROM productcustomimages WHERE product_id = '4925'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4925' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4122'
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4122'
SELECT * FROM productcustomimages WHERE product_id = '4122'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4122' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2165'
SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '2165'
SELECT * FROM productcustomimages WHERE product_id = '2165'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2165' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4939'
SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4939'
SELECT * FROM productcustomimages WHERE product_id = '4939'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4939' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4930'
SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4930'
SELECT * FROM productcustomimages WHERE product_id = '4930'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4930' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4940'
SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4940'
SELECT * FROM productcustomimages WHERE product_id = '4940'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4940' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4954'
SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4954'
SELECT * FROM productcustomimages WHERE product_id = '4954'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4954' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '770'
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '770'
SELECT * FROM productcustomimages WHERE product_id = '770'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '770' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4948'
SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4948'
SELECT * FROM productcustomimages WHERE product_id = '4948'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4948' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4941'
SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4941'
SELECT * FROM productcustomimages WHERE product_id = '4941'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4941' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4937'
SELECT * FROM productimages WHERE product_id = '4937' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4937'
SELECT * FROM productcustomimages WHERE product_id = '4937'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4937' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4937' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4937' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1036'
SELECT * FROM productimages WHERE product_id = '1036' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1036'
SELECT * FROM productcustomimages WHERE product_id = '1036'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1036' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1036' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1036' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1036
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1036'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4932'
SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4932'
SELECT * FROM productcustomimages WHERE product_id = '4932'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4932' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1274'
SELECT * FROM productimages WHERE product_id = '1274' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1274'
SELECT * FROM productcustomimages WHERE product_id = '1274'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1274' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1274' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1274' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1274' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '850'
SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '850'
SELECT * FROM productcustomimages WHERE product_id = '850'
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 = '850'
                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     = '850'
                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 = 850
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '850' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 850
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '850'
                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 = '850'
                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     = '850'
                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 = 850
SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '850'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE parent_id = '850'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4891' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM products WHERE id = '1340'
SELECT * FROM productimages WHERE product_id = '1340' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1340'
SELECT * FROM productcustomimages WHERE product_id = '1340'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1340' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1340' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1340' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1340' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4954' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4937' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1036' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1274' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1340' 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.0024	0.0024080276489258	SELECT parameter, value FROM parameters
2	0.0036	0.0036470890045166	SELECT * FROM `bad_bots`
3	0.0006	0.00062799453735352	SET time_zone = 'Europe/London'
4	0.0018	0.00177001953125	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0035	0.0034730434417725	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.225.117.244\";}'
6	0.0031	0.0031290054321289	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738829560'
7	0.0043	0.004256010055542	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00077080726623535	UPDATE autorun SET lastrun = '2025-02-06 08:12:40' WHERE id = '13'
9	0.0008	0.00077319145202637	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0033	0.0032510757446289	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0006	0.0005950927734375	SELECT * FROM pages WHERE id = 52
12	0.0049	0.0048658847808838	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0263	0.02631688117981	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0009	0.00086688995361328	SELECT * FROM pages WHERE pagename = 'search'
15	0.0020	0.0019829273223877	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0027	0.0027289390563965	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0204	0.020417928695679	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.0029230117797852	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.0022	0.0022139549255371	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0007	0.00067687034606934	SELECT id FROM categories WHERE parent_id = '26'
21	0.0066	0.0065639019012451	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.0020	0.0020411014556885	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.0021	0.0021109580993652	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.0016	0.0016200542449951	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0005	0.00049400329589844	SELECT * FROM categorygroups WHERE id = '1'
26	0.0042	0.0042068958282471	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.0006859302520752	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0005	0.00053691864013672	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0006	0.0005650520324707	SELECT id FROM categories WHERE parent_id = '27'
30	0.0045	0.0044541358947754	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.00065898895263672	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.00065207481384277	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
33	0.0006	0.00059294700622559	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0005	0.00046896934509277	SELECT * FROM categorygroups WHERE id = '1'
35	0.0016	0.0015878677368164	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36	0.0005	0.00053191184997559	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0004	0.00040006637573242	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0004	0.00044608116149902	SELECT id FROM categories WHERE parent_id = '28'
39	0.0016	0.001640796661377	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
40	0.0005	0.00052618980407715	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.0005	0.00052905082702637	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
42	0.0005	0.00053906440734863	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0004	0.00043582916259766	SELECT * FROM categorygroups WHERE id = '1'
44	0.0006	0.00063395500183105	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
45	0.0005	0.00051593780517578	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0004	0.00041103363037109	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0005	0.00051212310791016	SELECT id FROM categories WHERE parent_id = '29'
48	0.0008	0.00084996223449707	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.0006	0.0005640983581543	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (29) AND p.disabled = 0
50	0.0005	0.00051712989807129	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
51	0.0005	0.00049996376037598	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0004	0.00041890144348145	SELECT * FROM categorygroups WHERE id = '1'
53	0.0007	0.00070500373840332	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.0006	0.00058913230895996	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55	0.0004	0.0004270076751709	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00047397613525391	SELECT id FROM categories WHERE parent_id = '30'
57	0.0007	0.00072002410888672	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
58	0.0005	0.0005340576171875	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
59	0.0005	0.00054407119750977	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
60	0.0005	0.00047087669372559	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0005	0.00048303604125977	SELECT * FROM categorygroups WHERE id = '1'
62	0.0007	0.00067901611328125	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63	0.0005	0.00053000450134277	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64	0.0004	0.00041103363037109	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.00046896934509277	SELECT id FROM categories WHERE parent_id = '31'
66	0.0008	0.00077295303344727	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.0005	0.00048017501831055	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
68	0.0006	0.00058507919311523	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
69	0.0005	0.00049901008605957	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0005	0.00050997734069824	SELECT * FROM categorygroups WHERE id = '1'
71	0.0005	0.00054383277893066	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0032	0.003242015838623	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0018	0.0018041133880615	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0008	0.00077009201049805	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.0021982192993164	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0022	0.0022130012512207	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0014	0.00136399269104	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.5821	0.58214807510376	SELECT * FROM ipgeocountries WHERE INET_ATON('18.225.117.244') >= INET_ATON(ip_start) AND INET_ATON('18.225.117.244') <= INET_ATON(ip_end)
79	0.0024	0.0023729801177979	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0013	0.0012640953063965	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0005	0.00054311752319336	SELECT * FROM pages WHERE pagename = 'search'
82	0.0056	0.0055570602416992	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0016	0.0016191005706787	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0026	0.0026371479034424	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0120	0.012018918991089	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0019	0.0019190311431885	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0007	0.00073814392089844	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0029	0.0029361248016357	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '18.225.117.244'
89	0.0011	0.0010619163513184	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.0007	0.00067496299743652	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.0047	0.0046608448028564	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.00060105323791504	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
93	0.0006	0.00057601928710938	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
94	0.0006	0.00063490867614746	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.0053	0.0053200721740723	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.0004	0.00042891502380371	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.00041103363037109	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.0007	0.00073003768920898	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.0007	0.00070810317993164	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.0043	0.0042550563812256	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.00047206878662109	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.0004	0.00037789344787598	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.00061416625976562	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.0052	0.0051519870758057	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%4%') OR (keyfeatures LIKE '%4%') OR (title LIKE '%4%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
105	0.0004	0.00038790702819824	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.00038313865661621	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.00051784515380859	SELECT * FROM products WHERE id = '4950'
108	0.0019	0.001939058303833	SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
109	0.0017	0.0016880035400391	SELECT * FROM product_image_select WHERE product_id = '4950'
110	0.0015	0.0015490055084229	SELECT * FROM productcustomimages WHERE product_id = '4950'
111	0.0026	0.0026462078094482	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
112	0.0023	0.0022940635681152	SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0006	0.00059795379638672	SELECT * FROM productoffers WHERE product_id = '4950' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0007	0.00065517425537109	SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115	0.0007	0.00072884559631348	SELECT * FROM products WHERE id = '4953'
116	0.0006	0.00059795379638672	SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
117	0.0007	0.00070285797119141	SELECT * FROM product_image_select WHERE product_id = '4953'
118	0.0005	0.00051689147949219	SELECT * FROM productcustomimages WHERE product_id = '4953'
119	0.0010	0.00099396705627441	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
120	0.0006	0.00061798095703125	SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
121	0.0005	0.0005490779876709	SELECT * FROM productoffers WHERE product_id = '4953' AND price > 0 ORDER BY price ASC LIMIT 1
122	0.0005	0.00049304962158203	SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123	0.0006	0.00063300132751465	SELECT * FROM products WHERE id = '4925'
124	0.0007	0.00069904327392578	SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
125	0.0007	0.00065279006958008	SELECT * FROM product_image_select WHERE product_id = '4925'
126	0.0005	0.00050592422485352	SELECT * FROM productcustomimages WHERE product_id = '4925'
127	0.0019	0.0019330978393555	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
128	0.0007	0.00066184997558594	SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
129	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '4925' AND price > 0 ORDER BY price ASC LIMIT 1
130	0.0004	0.00043797492980957	SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0006	0.0006258487701416	SELECT * FROM products WHERE id = '4122'
132	0.0008	0.00081896781921387	SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
133	0.0007	0.00067710876464844	SELECT * FROM product_image_select WHERE product_id = '4122'
134	0.0005	0.00045299530029297	SELECT * FROM productcustomimages WHERE product_id = '4122'
135	0.0017	0.001737117767334	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
136	0.0006	0.00058388710021973	SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
137	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '4122' AND price > 0 ORDER BY price ASC LIMIT 1
138	0.0007	0.00066208839416504	SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139	0.0007	0.00068902969360352	SELECT * FROM products WHERE id = '2165'
140	0.0009	0.00086116790771484	SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
141	0.0008	0.00079584121704102	SELECT * FROM product_image_select WHERE product_id = '2165'
142	0.0006	0.00056600570678711	SELECT * FROM productcustomimages WHERE product_id = '2165'
143	0.0010	0.00099015235900879	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
144	0.0009	0.00085306167602539	SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
145	0.0010	0.0009620189666748	SELECT * FROM productoffers WHERE product_id = '2165' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0005	0.00054693222045898	SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0010	0.00097298622131348	SELECT * FROM products WHERE id = '4939'
148	0.0011	0.0011420249938965	SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
149	0.0007	0.00069904327392578	SELECT * FROM product_image_select WHERE product_id = '4939'
150	0.0005	0.00051689147949219	SELECT * FROM productcustomimages WHERE product_id = '4939'
151	0.0012	0.0012469291687012	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
152	0.0007	0.00065016746520996	SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0006	0.00055289268493652	SELECT * FROM productoffers WHERE product_id = '4939' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0005	0.00048708915710449	SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155	0.0006	0.0006258487701416	SELECT * FROM products WHERE id = '4930'
156	0.0008	0.00084900856018066	SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
157	0.0006	0.00056719779968262	SELECT * FROM product_image_select WHERE product_id = '4930'
158	0.0004	0.00040388107299805	SELECT * FROM productcustomimages WHERE product_id = '4930'
159	0.0015	0.0015149116516113	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
160	0.0007	0.0006859302520752	SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
161	0.0005	0.00049400329589844	SELECT * FROM productoffers WHERE product_id = '4930' AND price > 0 ORDER BY price ASC LIMIT 1
162	0.0005	0.00051283836364746	SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163	0.0006	0.00064396858215332	SELECT * FROM products WHERE id = '4940'
164	0.0005	0.00048589706420898	SELECT * FROM productimages WHERE product_id = '4940' ORDER BY sortorder ASC
165	0.0006	0.00058507919311523	SELECT * FROM product_image_select WHERE product_id = '4940'
166	0.0004	0.00039196014404297	SELECT * FROM productcustomimages WHERE product_id = '4940'
167	0.0008	0.00083708763122559	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4940' AND a.name = n.originalname
168	0.0005	0.00050616264343262	SELECT * FROM productoffers WHERE product_id = '4940' AND merchantid = 'A1X6FK5RDHNB96'
169	0.0004	0.00039196014404297	SELECT * FROM productoffers WHERE product_id = '4940' AND price > 0 ORDER BY price ASC LIMIT 1
170	0.0004	0.00043511390686035	SELECT value FROM productattributes WHERE product_id = '4940' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171	0.0007	0.00065302848815918	SELECT * FROM products WHERE id = '4954'
172	0.0005	0.00046992301940918	SELECT * FROM productimages WHERE product_id = '4954' ORDER BY sortorder ASC
173	0.0006	0.00063610076904297	SELECT * FROM product_image_select WHERE product_id = '4954'
174	0.0004	0.00038313865661621	SELECT * FROM productcustomimages WHERE product_id = '4954'
175	0.0010	0.0009758472442627	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4954' AND a.name = n.originalname
176	0.0006	0.00055480003356934	SELECT * FROM productoffers WHERE product_id = '4954' AND merchantid = 'A1X6FK5RDHNB96'
177	0.0004	0.00043487548828125	SELECT * FROM productoffers WHERE product_id = '4954' AND price > 0 ORDER BY price ASC LIMIT 1
178	0.0005	0.00048208236694336	SELECT value FROM productattributes WHERE product_id = '4954' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
179	0.0006	0.00061392784118652	SELECT * FROM products WHERE id = '770'
180	0.0014	0.0014488697052002	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
181	0.0018	0.0018279552459717	SELECT * FROM product_image_select WHERE product_id = '770'
182	0.0008	0.00081515312194824	SELECT * FROM productcustomimages WHERE product_id = '770'
183	0.0032	0.0031740665435791	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '770' AND a.name = n.originalname
184	0.0010	0.0010430812835693	SELECT * FROM productoffers WHERE product_id = '770' AND merchantid = 'A1X6FK5RDHNB96'
185	0.0008	0.00079607963562012	SELECT * FROM productoffers WHERE product_id = '770' AND price > 0 ORDER BY price ASC LIMIT 1
186	0.0009	0.00088596343994141	SELECT value FROM productattributes WHERE product_id = '770' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
187	0.0010	0.0010378360748291	SELECT * FROM products WHERE id = '4948'
188	0.0009	0.00090694427490234	SELECT * FROM productimages WHERE product_id = '4948' ORDER BY sortorder ASC
189	0.0013	0.0012569427490234	SELECT * FROM product_image_select WHERE product_id = '4948'
190	0.0008	0.00076985359191895	SELECT * FROM productcustomimages WHERE product_id = '4948'
191	0.0020	0.0019750595092773	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4948' AND a.name = n.originalname
192	0.0007	0.00074386596679688	SELECT * FROM productoffers WHERE product_id = '4948' AND merchantid = 'A1X6FK5RDHNB96'
193	0.0007	0.00069499015808105	SELECT * FROM productoffers WHERE product_id = '4948' AND price > 0 ORDER BY price ASC LIMIT 1
194	0.0007	0.00068497657775879	SELECT value FROM productattributes WHERE product_id = '4948' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
195	0.0009	0.00087118148803711	SELECT * FROM products WHERE id = '4941'
196	0.0009	0.00089311599731445	SELECT * FROM productimages WHERE product_id = '4941' ORDER BY sortorder ASC
197	0.0027	0.0027248859405518	SELECT * FROM product_image_select WHERE product_id = '4941'
198	0.0011	0.0010521411895752	SELECT * FROM productcustomimages WHERE product_id = '4941'
199	0.0029	0.0029330253601074	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4941' AND a.name = n.originalname
200	0.0009	0.00088810920715332	SELECT * FROM productoffers WHERE product_id = '4941' AND merchantid = 'A1X6FK5RDHNB96'
201	0.0013	0.0013191699981689	SELECT * FROM productoffers WHERE product_id = '4941' AND price > 0 ORDER BY price ASC LIMIT 1
202	0.0009	0.00087499618530273	SELECT value FROM productattributes WHERE product_id = '4941' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
203	0.0018	0.0018320083618164	SELECT * FROM products WHERE id = '4937'
204	0.0013	0.001291036605835	SELECT * FROM productimages WHERE product_id = '4937' ORDER BY sortorder ASC
205	0.0011	0.001068115234375	SELECT * FROM product_image_select WHERE product_id = '4937'
206	0.0006	0.00063800811767578	SELECT * FROM productcustomimages WHERE product_id = '4937'
207	0.0021	0.0021450519561768	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4937' AND a.name = n.originalname
208	0.0011	0.001068115234375	SELECT * FROM productoffers WHERE product_id = '4937' AND merchantid = 'A1X6FK5RDHNB96'
209	0.0006	0.00057101249694824	SELECT * FROM productoffers WHERE product_id = '4937' AND price > 0 ORDER BY price ASC LIMIT 1
210	0.0007	0.00066709518432617	SELECT value FROM productattributes WHERE product_id = '4937' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211	0.0007	0.00071001052856445	SELECT * FROM products WHERE id = '1036'
212	0.0007	0.00074982643127441	SELECT * FROM productimages WHERE product_id = '1036' ORDER BY sortorder ASC
213	0.0007	0.00071191787719727	SELECT * FROM product_image_select WHERE product_id = '1036'
214	0.0005	0.00050687789916992	SELECT * FROM productcustomimages WHERE product_id = '1036'
215	0.0013	0.0012521743774414	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1036' AND a.name = n.originalname
216	0.0005	0.00054097175598145	SELECT * FROM productoffers WHERE product_id = '1036' AND merchantid = 'A1X6FK5RDHNB96'
217	0.0007	0.00067615509033203	SELECT * FROM productoffers WHERE product_id = '1036' AND price > 0 ORDER BY price ASC LIMIT 1
218	0.0004	0.00039005279541016	SELECT * FROM productoffers WHERE product_id = 1036 ORDER BY price ASC LIMIT 1
219	0.0006	0.00056815147399902	SELECT value FROM productattributes WHERE product_id = '1036' AND name = 'ListPriceAmount'
220	0.0005	0.00047492980957031	SELECT value FROM productattributes WHERE product_id = '1036' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221	0.0006	0.00063800811767578	SELECT * FROM products WHERE id = '4932'
222	0.0006	0.00058603286743164	SELECT * FROM productimages WHERE product_id = '4932' ORDER BY sortorder ASC
223	0.0007	0.00066399574279785	SELECT * FROM product_image_select WHERE product_id = '4932'
224	0.0004	0.00040602684020996	SELECT * FROM productcustomimages WHERE product_id = '4932'
225	0.0046	0.0046238899230957	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4932' AND a.name = n.originalname
226	0.0011	0.0011000633239746	SELECT * FROM productoffers WHERE product_id = '4932' AND merchantid = 'A1X6FK5RDHNB96'
227	0.0011	0.0010910034179688	SELECT * FROM productoffers WHERE product_id = '4932' AND price > 0 ORDER BY price ASC LIMIT 1
228	0.0018	0.0017960071563721	SELECT value FROM productattributes WHERE product_id = '4932' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229	0.0013	0.0012671947479248	SELECT * FROM products WHERE id = '1274'
230	0.0014	0.0014162063598633	SELECT * FROM productimages WHERE product_id = '1274' ORDER BY sortorder ASC
231	0.0015	0.0015349388122559	SELECT * FROM product_image_select WHERE product_id = '1274'
232	0.0009	0.00088214874267578	SELECT * FROM productcustomimages WHERE product_id = '1274'
233	0.0055	0.0054728984832764	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1274' AND a.name = n.originalname
234	0.0009	0.00085306167602539	SELECT * FROM productoffers WHERE product_id = '1274' AND merchantid = 'A1X6FK5RDHNB96'
235	0.0012	0.0012028217315674	SELECT * FROM productoffers WHERE product_id = '1274' AND price > 0 ORDER BY price ASC LIMIT 1
236	0.0021	0.0020549297332764	SELECT value FROM productattributes WHERE product_id = '1274' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237	0.0018	0.0018360614776611	SELECT * FROM products WHERE id = '850'
238	0.0023	0.0022850036621094	SELECT * FROM productimages WHERE product_id = '850' ORDER BY sortorder ASC
239	0.0015	0.0014817714691162	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '850' AND p.id = pi.product_id ORDER BY pi.sortorder
240	0.0014	0.0013840198516846	SELECT * FROM product_image_select WHERE product_id = '850'
241	0.0008	0.00083184242248535	SELECT * FROM productcustomimages WHERE product_id = '850'
242	0.0013	0.0012948513031006	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 = '850' GROUP BY o.product_id
243	0.0058	0.0057508945465088	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 = '850' GROUP BY n.displayname ORDER BY n.displayname DESC
244	0.0009	0.00088906288146973	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
245	0.0017	0.0016970634460449	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '850' AND a.name = n.originalname
246	0.0006	0.00059986114501953	SELECT * FROM productoffers WHERE product_id = '850' AND merchantid = 'A1X6FK5RDHNB96'
247	0.0006	0.00055909156799316	SELECT * FROM productoffers WHERE product_id = '850' AND price > 0 ORDER BY price ASC LIMIT 1
248	0.0005	0.00049901008605957	SELECT * FROM productoffers WHERE product_id = 850 ORDER BY price ASC LIMIT 1
249	0.0008	0.00075292587280273	SELECT value FROM productattributes WHERE product_id = '850' AND name = 'ListPriceAmount'
250	0.0007	0.0006711483001709	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 = '850' GROUP BY o.product_id
251	0.0011	0.0010631084442139	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 = '850' GROUP BY n.displayname ORDER BY n.displayname DESC
252	0.0008	0.00075006484985352	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 850
253	0.0009	0.00088882446289062	SELECT value FROM productattributes WHERE product_id = '850' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
254	0.0011	0.0010600090026855	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '850' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
255	0.0006	0.00063514709472656	SELECT * FROM products WHERE parent_id = '850'
256	0.0008	0.00083804130554199	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4891' AND a.name = n.originalname
257	0.0007	0.00068783760070801	SELECT * FROM productoffers WHERE product_id = '4891' AND merchantid = 'A1X6FK5RDHNB96'
258	0.0007	0.00065994262695312	SELECT * FROM productoffers WHERE product_id = '4891' AND price > 0 ORDER BY price ASC LIMIT 1
259	0.0007	0.00065803527832031	SELECT * FROM products WHERE id = '1340'
260	0.0007	0.00068998336791992	SELECT * FROM productimages WHERE product_id = '1340' ORDER BY sortorder ASC
261	0.0009	0.00088691711425781	SELECT * FROM product_image_select WHERE product_id = '1340'
262	0.0005	0.00053906440734863	SELECT * FROM productcustomimages WHERE product_id = '1340'
263	0.0016	0.0016000270843506	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1340' AND a.name = n.originalname
264	0.0007	0.00066995620727539	SELECT * FROM productoffers WHERE product_id = '1340' AND merchantid = 'A1X6FK5RDHNB96'
265	0.0012	0.0012068748474121	SELECT * FROM productoffers WHERE product_id = '1340' AND price > 0 ORDER BY price ASC LIMIT 1
266	0.0009	0.00093412399291992	SELECT value FROM productattributes WHERE product_id = '1340' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
267	0.0038	0.0038461685180664	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
268	0.0007	0.0006868839263916	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
269	0.0005	0.00053191184997559	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
270	0.0007	0.00068116188049316	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
271	0.0018	0.0018408298492432	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
272	0.0009	0.00089716911315918	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
273	0.0008	0.00081896781921387	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
274	0.0006	0.00057196617126465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4940' ORDER BY timestamp DESC
275	0.0005	0.00051403045654297	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4954' ORDER BY timestamp DESC
276	0.0006	0.00058484077453613	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '770' ORDER BY timestamp DESC
277	0.0006	0.00061917304992676	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4948' ORDER BY timestamp DESC
278	0.0005	0.00053787231445312	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4941' ORDER BY timestamp DESC
279	0.0006	0.00055503845214844	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4937' ORDER BY timestamp DESC
280	0.0006	0.00062298774719238	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1036' ORDER BY timestamp DESC
281	0.0013	0.0013332366943359	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4932' ORDER BY timestamp DESC
282	0.0010	0.00095486640930176	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1274' ORDER BY timestamp DESC
283	0.0007	0.00065302848815918	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '850' ORDER BY timestamp DESC
284	0.0010	0.001025915145874	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1340' ORDER BY timestamp DESC
285	0.0043	0.004317045211792	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
286	0.0031	0.0030550956726074	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
287	0.0012	0.001162052154541	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
288	0.0222	0.022150993347168	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
289	0.0019	0.0018770694732666	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
290	0.0006	0.00060510635375977	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
291	0.0006	0.00064516067504883	SELECT * FROM products WHERE id = 1626
292	0.0006	0.00060582160949707	SELECT * FROM products WHERE id = 4041
293	0.0006	0.00058507919311523	SELECT * FROM products WHERE id = 4312
294	0.0007	0.00065183639526367	SELECT * FROM products WHERE id = 777
295	0.0010	0.0010139942169189	SELECT * FROM products WHERE id = 3881
296	0.0009	0.0008690357208252	SELECT * FROM products WHERE id = 4213
297	0.0008	0.0008389949798584	SELECT * FROM products WHERE id = '1626'
298	0.0010	0.0009760856628418	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
299	0.0016	0.0015501976013184	SELECT * FROM product_image_select WHERE product_id = '1626'
300	0.0007	0.00072908401489258	SELECT * FROM productcustomimages WHERE product_id = '1626'
301	0.0025	0.0024988651275635	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
302	0.0012	0.0011510848999023	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
303	0.0008	0.00082111358642578	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
304	0.0010	0.00095486640930176	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
305	0.0013	0.0012741088867188	SELECT * FROM products WHERE id = '4041'
306	0.0009	0.00089001655578613	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
307	0.0013	0.001276969909668	SELECT * FROM product_image_select WHERE product_id = '4041'
308	0.0009	0.0009310245513916	SELECT * FROM productcustomimages WHERE product_id = '4041'
309	0.0033	0.0033481121063232	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
310	0.0010	0.00098586082458496	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
311	0.0007	0.0007321834564209	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
312	0.0007	0.0007469654083252	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
313	0.0009	0.00091981887817383	SELECT * FROM products WHERE id = '4312'
314	0.0010	0.00095915794372559	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
315	0.0013	0.0013101100921631	SELECT * FROM product_image_select WHERE product_id = '4312'
316	0.0006	0.00062680244445801	SELECT * FROM productcustomimages WHERE product_id = '4312'
317	0.0029	0.0028619766235352	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
318	0.0007	0.00069499015808105	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
319	0.0005	0.00054693222045898	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
320	0.0006	0.00058317184448242	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
321	0.0009	0.00088286399841309	SELECT * FROM products WHERE id = '777'
322	0.0006	0.00064802169799805	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
323	0.0010	0.001025915145874	SELECT * FROM product_image_select WHERE product_id = '777'
324	0.0005	0.00052905082702637	SELECT * FROM productcustomimages WHERE product_id = '777'
325	0.0019	0.0018990039825439	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
326	0.0008	0.00083398818969727	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
327	0.0006	0.00058078765869141	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
328	0.0007	0.00067400932312012	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
329	0.0008	0.0007939338684082	SELECT * FROM products WHERE id = '3881'
330	0.0009	0.00088191032409668	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
331	0.0009	0.00094008445739746	SELECT * FROM product_image_select WHERE product_id = '3881'
332	0.0006	0.00061988830566406	SELECT * FROM productcustomimages WHERE product_id = '3881'
333	0.0017	0.0017409324645996	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
334	0.0007	0.00073599815368652	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
335	0.0006	0.00060200691223145	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
336	0.0006	0.00063109397888184	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
337	0.0008	0.00078582763671875	SELECT * FROM products WHERE id = '4213'
338	0.0010	0.0010020732879639	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
339	0.0009	0.00093293190002441	SELECT * FROM product_image_select WHERE product_id = '4213'
340	0.0009	0.00093388557434082	SELECT * FROM productcustomimages WHERE product_id = '4213'
341	0.0033	0.00325608253479	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
342	0.0010	0.00099396705627441	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
343	0.0052	0.0052039623260498	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
344	0.0007	0.00069093704223633	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
345	0.0021	0.0020949840545654	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
346	0.0008	0.00078201293945312	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
347	0.0029	0.0028679370880127	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
348	0.0021	0.0021350383758545	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
349	0.0007	0.00072002410888672	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
350	0.0108	0.010806083679199	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
351	0.0012	0.0012080669403076	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "4"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.7600197792053 seconds

Query Debug - 351 Database Queries. Total time 1.0818 seconds