Search Results for ""

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

Pellini Caffè, Café en grains Pellini Es...

€25,90 €17,51

View

Add to Cart

Marque Amazon Solimo café en grains 2 kg...

only €23,99

View

Add to Cart

YOGI - Infusion BIO Défenses Immunitaire...

only €2,21

View

Add to Cart

Kumiko Matcha - thé matcha premium bio d...

only €35,00

View

Add to Cart

Lipton Coffret Thés et Infusions, Assort...

only €16,99

View

Add to Cart

Matcha Premium 200 gr

from €8,99

View

Add to Cart

English Tea Shop Rooibos - 1 x 20 Tea Ba...

only €4,20

View

Add to Cart

Rooibos Capetown Bio 200g

only €14,99

View

Add to Cart

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

only €19,90

View

Add to Cart

Rooibos aux baies sauvages Bio 200g

only €14,99

View

Add to Cart

Alter Eco Thé Blanc Rooibos Nature Bio e...

only €9,99

View

Add to Cart

Thé Rouge Rooibos Afrique Bio 1 kg

only €29,97

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

Thé vert nature Sencha Bio 200 gr

€12,97 €10,97

View

Add to Cart

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

only €32,97

View

Add to Cart

1 to 18 of 1192 products

1
2
3
4
Next ›

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.7437930107117	345	1.2201	0

No Amazon API Requests Made.

App Debug - Total Time 1.7437930107117 seconds

Number	Time From Start	Name	Description
1	0.36294007301331	Initialise	Initialise FSB Function
2	0.36957788467407	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.41059398651123	Start of getCategoryListByGroup Function	Before first category groups query
4	0.41202592849731	After initial query	Before first category groups query
5	0.41202688217163	Get Category List for Group	Before the call to getCategoryList function
6	0.41202998161316	Start of GetCategoryList function	Start of the function
7	0.41203308105469	Before getting categories	Query to get specific category list
8	0.41353988647461	After getting categories	Query to get specific category list
9	0.4135410785675	Before getting category custom	Before call to function getCategoryCustom
10	0.43856692314148	After getting category custom	After call to function getCategoryCustom
11	0.43856906890869	Before getting category custom	Before call to function getCategoryCustom
12	0.45047688484192	After getting category custom	After call to function getCategoryCustom
13	0.45047998428345	Before getting category custom	Before call to function getCategoryCustom
14	0.45697689056396	After getting category custom	After call to function getCategoryCustom
15	0.45697689056396	Before getting category custom	Before call to function getCategoryCustom
16	0.46172499656677	After getting category custom	After call to function getCategoryCustom
17	0.46172595024109	Before getting category custom	Before call to function getCategoryCustom
18	0.46680688858032	After getting category custom	After call to function getCategoryCustom
19	0.46680808067322	Before getting category custom	Before call to function getCategoryCustom
20	0.47144889831543	After getting category custom	After call to function getCategoryCustom
21	0.47145104408264	End of GetCategoryList function	End of the function
22	0.4714560508728	Get Category List for Group	Before the call to getCategoryList function
23	0.47145700454712	Start of GetCategoryList function	Start of the function
24	0.47145795822144	Before getting categories	Query to get specific category list
25	0.47190093994141	End of getCategoryListByGroup Function	Before return()
26	1.2822771072388	App Controller End	End of the App controller (called before the controller of every page)
27	1.4985349178314	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.5001540184021	Before Get Options	Before the call to getOptions in the tpl class
29	1.5666189193726	After Get Options	After the call to getOptions in the tpl class
30	1.5666570663452	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.7437839508057	Finalizing debug	Before the debug is output to the page.
32	1.7437920570374	End of App	This is the end of the app logging, final timestamp

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

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

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

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

		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 '%%') OR (title LIKE '%%'))
		AND hide = 0
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%%') OR (title LIKE '%%'))
		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 = '4933'
SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4933'
SELECT * FROM productcustomimages WHERE product_id = '4933'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4933' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4926'
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4926'
SELECT * FROM productcustomimages WHERE product_id = '4926'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4926' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4926' 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 = '868'
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '868'
SELECT * FROM productcustomimages WHERE product_id = '868'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '868' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4919'
SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4919'
SELECT * FROM productcustomimages WHERE product_id = '4919'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4919' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '2029'
SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '2029'
SELECT * FROM productcustomimages WHERE product_id = '2029'
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 = '2029'
                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     = '2029'
                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 = 2029
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '2029' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 2029
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '2029'
                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 = '2029'
                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     = '2029'
                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 = 2029
SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '2029'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '862'
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '862'
SELECT * FROM productcustomimages WHERE product_id = '862'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '862' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1011'
SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1011'
SELECT * FROM productcustomimages WHERE product_id = '1011'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1011' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1011' 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 = '1010'
SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1010'
SELECT * FROM productcustomimages WHERE product_id = '1010'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1010' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1140'
SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1140'
SELECT * FROM productcustomimages WHERE product_id = '1140'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1140' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1061'
SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1061'
SELECT * FROM productcustomimages WHERE product_id = '1061'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1061' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1061' 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 = '1110'
SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1110'
SELECT * FROM productcustomimages WHERE product_id = '1110'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1110' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1110' 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 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 = '4933' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' 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 = '868' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' 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 = '1010' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' 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 = '1110' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' 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.0026	0.0026390552520752	SELECT parameter, value FROM parameters
2	0.0079	0.0079109668731689	SELECT * FROM `bad_bots`
3	0.0005	0.00045585632324219	SET time_zone = 'Europe/London'
4	0.0030	0.0030369758605957	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0029	0.0028729438781738	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.144.255.53\";}'
6	0.0030	0.0030360221862793	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1746791010'
7	0.0036	0.0036380290985107	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0008	0.00081086158752441	UPDATE autorun SET lastrun = '2025-05-09 11:43:30' WHERE id = '16'
9	0.0010	0.00097513198852539	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0045	0.0045139789581299	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0006	0.00063610076904297	SELECT * FROM pages WHERE id = 52
12	0.0058	0.00577712059021	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0340	0.033978939056396	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0008	0.00078511238098145	SELECT * FROM pages WHERE pagename = 'search'
15	0.0014	0.0014200210571289	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0015	0.0014910697937012	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0084	0.0083589553833008	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
18	0.0024	0.0023939609527588	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.0016	0.0016019344329834	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0005	0.00051021575927734	SELECT id FROM categories WHERE parent_id = '26'
21	0.0069	0.0069141387939453	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
22	0.0017	0.0017449855804443	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.0016	0.0015790462493896	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.0014	0.001439094543457	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0004	0.00039505958557129	SELECT * FROM categorygroups WHERE id = '1'
26	0.0037	0.0036680698394775	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.0005	0.00053286552429199	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.00045204162597656	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0004	0.0004270076751709	SELECT id FROM categories WHERE parent_id = '27'
30	0.0049	0.0048580169677734	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
31	0.0005	0.00052094459533691	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (27) AND p.disabled = 0
32	0.0005	0.00052499771118164	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (27) AND c.prod_type = 'custom' AND cp.hide = 0
33	0.0005	0.00049185752868652	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0004	0.00039410591125488	SELECT * FROM categorygroups WHERE id = '1'
35	0.0014	0.0013530254364014	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
36	0.0006	0.00057888031005859	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0005	0.00046205520629883	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0004	0.00042986869812012	SELECT id FROM categories WHERE parent_id = '28'
39	0.0015	0.0015261173248291	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
40	0.0006	0.00055813789367676	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
41	0.0006	0.00061988830566406	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.00053596496582031	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0004	0.00040602684020996	SELECT * FROM categorygroups WHERE id = '1'
44	0.0006	0.000640869140625	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.00048995018005371	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0005	0.00045299530029297	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0004	0.0004119873046875	SELECT id FROM categories WHERE parent_id = '29'
48	0.0007	0.00065016746520996	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
49	0.0005	0.00049400329589844	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.00053000450134277	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.00054788589477539	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0005	0.00050806999206543	SELECT * FROM categorygroups WHERE id = '1'
53	0.0007	0.00073385238647461	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.00058603286743164	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.0005	0.00049614906311035	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00052905082702637	SELECT id FROM categories WHERE parent_id = '30'
57	0.0007	0.00070977210998535	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.00047898292541504	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.00054812431335449	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.00053215026855469	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0004	0.00043916702270508	SELECT * FROM categorygroups WHERE id = '1'
62	0.0006	0.00063300132751465	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.00047397613525391	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.00038290023803711	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.0004730224609375	SELECT id FROM categories WHERE parent_id = '31'
66	0.0007	0.00073409080505371	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.00050210952758789	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
68	0.0005	0.00053095817565918	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.00046396255493164	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0004	0.00042414665222168	SELECT * FROM categorygroups WHERE id = '1'
71	0.0004	0.00043916702270508	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0028	0.0028009414672852	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0016	0.0015900135040283	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0005	0.00051999092102051	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.0011	0.0011069774627686	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0012	0.0011560916900635	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0007	0.00072216987609863	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.7971	0.7970609664917	SELECT * FROM ipgeocountries WHERE INET_ATON('3.144.255.53') >= INET_ATON(ip_start) AND INET_ATON('3.144.255.53') <= INET_ATON(ip_end)
79	0.0024	0.002377986907959	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0015	0.0015089511871338	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0011	0.0011160373687744	SELECT * FROM pages WHERE pagename = 'search'
82	0.0077	0.0077040195465088	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0017	0.0017349720001221	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0038	0.0037610530853271	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0198	0.019753932952881	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0032	0.0031559467315674	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0009	0.00085306167602539	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0026	0.0025978088378906	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '', NOW(), '3.144.255.53'
89	0.0012	0.0011610984802246	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0007	0.00066113471984863	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
91	0.0074	0.0073568820953369	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '') OR (keyfeatures LIKE '') OR (title LIKE '')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
92	0.0006	0.00058794021606445	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '') OR (title LIKE '')) AND hide = 0
93	0.0006	0.00058984756469727	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '') OR (title LIKE '')) AND hide = 0
94	0.0006	0.00060105323791504	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
95	0.0067	0.0067470073699951	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%%') OR (keyfeatures LIKE '%%') OR (title LIKE '%%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1
96	0.0005	0.00049090385437012	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%%') OR (title LIKE '%%')) AND hide = 0
97	0.0004	0.0003659725189209	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%%') OR (title LIKE '%%')) AND hide = 0
98	0.0006	0.00062108039855957	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
99	0.0006	0.0005640983581543	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
100	0.0066	0.0066018104553223	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '') OR (keyfeatures LIKE '') OR (title LIKE '')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
101	0.0004	0.00042200088500977	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '') OR (title LIKE '')) AND hide = 0
102	0.0003	0.00030899047851562	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '') OR (title LIKE '')) AND hide = 0
103	0.0007	0.00074005126953125	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' 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 ('+'), 'bundle' AS type FROM bundles b WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1 ORDER BY salesrank ASC
104	0.0060	0.0059990882873535	SELECT DISTINCT (p.id), salesrank, price, linktitle, 'product' AS type FROM products p WHERE ((description LIKE '%%') OR (keyfeatures LIKE '%%') OR (title LIKE '%%')) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 ORDER BY salesrank ASC
105	0.0003	0.00030994415283203	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '%%') OR (title LIKE '%%')) AND hide = 0
106	0.0003	0.0003209114074707	SELECT DISTINCT (p.id), price, linktitle, 'customproduct' AS type FROM custom_products p WHERE ((description LIKE '%%') OR (title LIKE '%%')) AND hide = 0
107	0.0004	0.00035810470581055	SELECT * FROM products WHERE id = '4950'
108	0.0015	0.0014619827270508	SELECT * FROM productimages WHERE product_id = '4950' ORDER BY sortorder ASC
109	0.0013	0.0012550354003906	SELECT * FROM product_image_select WHERE product_id = '4950'
110	0.0011	0.0010900497436523	SELECT * FROM productcustomimages WHERE product_id = '4950'
111	0.0017	0.0017340183258057	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4950' AND a.name = n.originalname
112	0.0012	0.0011961460113525	SELECT * FROM productoffers WHERE product_id = '4950' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0005	0.0005040168762207	SELECT * FROM productoffers WHERE product_id = '4950' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0007	0.00068306922912598	SELECT value FROM productattributes WHERE product_id = '4950' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115	0.0005	0.0005190372467041	SELECT * FROM products WHERE id = '4953'
116	0.0004	0.00043606758117676	SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
117	0.0005	0.0005490779876709	SELECT * FROM product_image_select WHERE product_id = '4953'
118	0.0003	0.00032806396484375	SELECT * FROM productcustomimages WHERE product_id = '4953'
119	0.0008	0.0007939338684082	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4953' AND a.name = n.originalname
120	0.0005	0.00048613548278809	SELECT * FROM productoffers WHERE product_id = '4953' AND merchantid = 'A1X6FK5RDHNB96'
121	0.0005	0.00045299530029297	SELECT * FROM productoffers WHERE product_id = '4953' AND price > 0 ORDER BY price ASC LIMIT 1
122	0.0004	0.00041794776916504	SELECT value FROM productattributes WHERE product_id = '4953' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123	0.0005	0.00049495697021484	SELECT * FROM products WHERE id = '4933'
124	0.0005	0.00048613548278809	SELECT * FROM productimages WHERE product_id = '4933' ORDER BY sortorder ASC
125	0.0006	0.00055098533630371	SELECT * FROM product_image_select WHERE product_id = '4933'
126	0.0005	0.00045180320739746	SELECT * FROM productcustomimages WHERE product_id = '4933'
127	0.0011	0.0011239051818848	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4933' AND a.name = n.originalname
128	0.0004	0.00042891502380371	SELECT * FROM productoffers WHERE product_id = '4933' AND merchantid = 'A1X6FK5RDHNB96'
129	0.0004	0.00039291381835938	SELECT * FROM productoffers WHERE product_id = '4933' AND price > 0 ORDER BY price ASC LIMIT 1
130	0.0004	0.00040292739868164	SELECT value FROM productattributes WHERE product_id = '4933' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0005	0.00047111511230469	SELECT * FROM products WHERE id = '4926'
132	0.0005	0.00048494338989258	SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
133	0.0006	0.00056004524230957	SELECT * FROM product_image_select WHERE product_id = '4926'
134	0.0004	0.00035214424133301	SELECT * FROM productcustomimages WHERE product_id = '4926'
135	0.0011	0.001115083694458	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4926' AND a.name = n.originalname
136	0.0005	0.00050187110900879	SELECT * FROM productoffers WHERE product_id = '4926' AND merchantid = 'A1X6FK5RDHNB96'
137	0.0003	0.00034594535827637	SELECT * FROM productoffers WHERE product_id = '4926' AND price > 0 ORDER BY price ASC LIMIT 1
138	0.0004	0.00036096572875977	SELECT value FROM productattributes WHERE product_id = '4926' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139	0.0005	0.00051283836364746	SELECT * FROM products WHERE id = '4925'
140	0.0006	0.00055217742919922	SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
141	0.0008	0.00075292587280273	SELECT * FROM product_image_select WHERE product_id = '4925'
142	0.0004	0.00042414665222168	SELECT * FROM productcustomimages WHERE product_id = '4925'
143	0.0012	0.0011849403381348	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4925' AND a.name = n.originalname
144	0.0005	0.00052595138549805	SELECT * FROM productoffers WHERE product_id = '4925' AND merchantid = 'A1X6FK5RDHNB96'
145	0.0004	0.00037002563476562	SELECT * FROM productoffers WHERE product_id = '4925' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0004	0.00038599967956543	SELECT value FROM productattributes WHERE product_id = '4925' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0005	0.00050187110900879	SELECT * FROM products WHERE id = '868'
148	0.0006	0.00056195259094238	SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
149	0.0006	0.00057005882263184	SELECT * FROM product_image_select WHERE product_id = '868'
150	0.0004	0.00035214424133301	SELECT * FROM productcustomimages WHERE product_id = '868'
151	0.0008	0.00081491470336914	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '868' AND a.name = n.originalname
152	0.0013	0.0012590885162354	SELECT * FROM productoffers WHERE product_id = '868' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0010	0.00096297264099121	SELECT * FROM productoffers WHERE product_id = '868' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0008	0.0008399486541748	SELECT value FROM productattributes WHERE product_id = '868' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
155	0.0010	0.0010499954223633	SELECT * FROM products WHERE id = '4919'
156	0.0012	0.0011730194091797	SELECT * FROM productimages WHERE product_id = '4919' ORDER BY sortorder ASC
157	0.0014	0.0014278888702393	SELECT * FROM product_image_select WHERE product_id = '4919'
158	0.0007	0.00069093704223633	SELECT * FROM productcustomimages WHERE product_id = '4919'
159	0.0056	0.0055668354034424	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4919' AND a.name = n.originalname
160	0.0019	0.0018768310546875	SELECT * FROM productoffers WHERE product_id = '4919' AND merchantid = 'A1X6FK5RDHNB96'
161	0.0009	0.00085091590881348	SELECT * FROM productoffers WHERE product_id = '4919' AND price > 0 ORDER BY price ASC LIMIT 1
162	0.0008	0.00078511238098145	SELECT value FROM productattributes WHERE product_id = '4919' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
163	0.0013	0.0012829303741455	SELECT * FROM products WHERE id = '2029'
164	0.0012	0.0011601448059082	SELECT * FROM productimages WHERE product_id = '2029' ORDER BY sortorder ASC
165	0.0020	0.0020089149475098	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '2029' AND p.id = pi.product_id ORDER BY pi.sortorder
166	0.0011	0.0010988712310791	SELECT * FROM product_image_select WHERE product_id = '2029'
167	0.0007	0.00067496299743652	SELECT * FROM productcustomimages WHERE product_id = '2029'
168	0.0010	0.00096893310546875	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 = '2029' GROUP BY o.product_id
169	0.0044	0.0043990612030029	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 = '2029' GROUP BY n.displayname ORDER BY n.displayname DESC
170	0.0007	0.00068306922912598	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
171	0.0012	0.0012099742889404	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2029' AND a.name = n.originalname
172	0.0004	0.00043392181396484	SELECT * FROM productoffers WHERE product_id = '2029' AND merchantid = 'A1X6FK5RDHNB96'
173	0.0004	0.00039982795715332	SELECT * FROM productoffers WHERE product_id = '2029' AND price > 0 ORDER BY price ASC LIMIT 1
174	0.0003	0.00032496452331543	SELECT * FROM productoffers WHERE product_id = 2029 ORDER BY price ASC LIMIT 1
175	0.0004	0.00040102005004883	SELECT value FROM productattributes WHERE product_id = '2029' AND name = 'ListPriceAmount'
176	0.0005	0.00049686431884766	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 = '2029' GROUP BY o.product_id
177	0.0009	0.00086617469787598	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 = '2029' GROUP BY n.displayname ORDER BY n.displayname DESC
178	0.0005	0.00046992301940918	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 2029
179	0.0007	0.00066590309143066	SELECT value FROM productattributes WHERE product_id = '2029' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
180	0.0008	0.00083684921264648	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '2029' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
181	0.0004	0.00042986869812012	SELECT * FROM products WHERE id = '862'
182	0.0006	0.00060701370239258	SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
183	0.0008	0.00081896781921387	SELECT * FROM product_image_select WHERE product_id = '862'
184	0.0005	0.0004570484161377	SELECT * FROM productcustomimages WHERE product_id = '862'
185	0.0011	0.001101016998291	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '862' AND a.name = n.originalname
186	0.0006	0.00055313110351562	SELECT * FROM productoffers WHERE product_id = '862' AND merchantid = 'A1X6FK5RDHNB96'
187	0.0004	0.00044107437133789	SELECT * FROM productoffers WHERE product_id = '862' AND price > 0 ORDER BY price ASC LIMIT 1
188	0.0005	0.00051116943359375	SELECT value FROM productattributes WHERE product_id = '862' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
189	0.0007	0.0007479190826416	SELECT * FROM products WHERE id = '1011'
190	0.0006	0.00062298774719238	SELECT * FROM productimages WHERE product_id = '1011' ORDER BY sortorder ASC
191	0.0006	0.00055789947509766	SELECT * FROM product_image_select WHERE product_id = '1011'
192	0.0004	0.00043392181396484	SELECT * FROM productcustomimages WHERE product_id = '1011'
193	0.0010	0.0010488033294678	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1011' AND a.name = n.originalname
194	0.0005	0.00051498413085938	SELECT * FROM productoffers WHERE product_id = '1011' AND merchantid = 'A1X6FK5RDHNB96'
195	0.0004	0.00039792060852051	SELECT * FROM productoffers WHERE product_id = '1011' AND price > 0 ORDER BY price ASC LIMIT 1
196	0.0004	0.00040602684020996	SELECT value FROM productattributes WHERE product_id = '1011' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197	0.0005	0.00050091743469238	SELECT * FROM products WHERE id = '4122'
198	0.0005	0.00053191184997559	SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
199	0.0007	0.000701904296875	SELECT * FROM product_image_select WHERE product_id = '4122'
200	0.0005	0.00046896934509277	SELECT * FROM productcustomimages WHERE product_id = '4122'
201	0.0011	0.0010848045349121	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4122' AND a.name = n.originalname
202	0.0004	0.00044584274291992	SELECT * FROM productoffers WHERE product_id = '4122' AND merchantid = 'A1X6FK5RDHNB96'
203	0.0004	0.00038003921508789	SELECT * FROM productoffers WHERE product_id = '4122' AND price > 0 ORDER BY price ASC LIMIT 1
204	0.0004	0.00035285949707031	SELECT value FROM productattributes WHERE product_id = '4122' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
205	0.0006	0.00056982040405273	SELECT * FROM products WHERE id = '1010'
206	0.0006	0.00055694580078125	SELECT * FROM productimages WHERE product_id = '1010' ORDER BY sortorder ASC
207	0.0007	0.00066304206848145	SELECT * FROM product_image_select WHERE product_id = '1010'
208	0.0004	0.00044393539428711	SELECT * FROM productcustomimages WHERE product_id = '1010'
209	0.0012	0.0011568069458008	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1010' AND a.name = n.originalname
210	0.0005	0.00049710273742676	SELECT * FROM productoffers WHERE product_id = '1010' AND merchantid = 'A1X6FK5RDHNB96'
211	0.0004	0.00037193298339844	SELECT * FROM productoffers WHERE product_id = '1010' AND price > 0 ORDER BY price ASC LIMIT 1
212	0.0004	0.0003969669342041	SELECT value FROM productattributes WHERE product_id = '1010' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213	0.0005	0.00053596496582031	SELECT * FROM products WHERE id = '1140'
214	0.0005	0.00052618980407715	SELECT * FROM productimages WHERE product_id = '1140' ORDER BY sortorder ASC
215	0.0006	0.00059390068054199	SELECT * FROM product_image_select WHERE product_id = '1140'
216	0.0003	0.00034499168395996	SELECT * FROM productcustomimages WHERE product_id = '1140'
217	0.0008	0.00076699256896973	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1140' AND a.name = n.originalname
218	0.0005	0.00045084953308105	SELECT * FROM productoffers WHERE product_id = '1140' AND merchantid = 'A1X6FK5RDHNB96'
219	0.0004	0.00035381317138672	SELECT * FROM productoffers WHERE product_id = '1140' AND price > 0 ORDER BY price ASC LIMIT 1
220	0.0004	0.00042486190795898	SELECT value FROM productattributes WHERE product_id = '1140' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221	0.0004	0.00044918060302734	SELECT * FROM products WHERE id = '1061'
222	0.0006	0.00060009956359863	SELECT * FROM productimages WHERE product_id = '1061' ORDER BY sortorder ASC
223	0.0005	0.00054287910461426	SELECT * FROM product_image_select WHERE product_id = '1061'
224	0.0004	0.00039219856262207	SELECT * FROM productcustomimages WHERE product_id = '1061'
225	0.0011	0.0010519027709961	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1061' AND a.name = n.originalname
226	0.0004	0.00044083595275879	SELECT * FROM productoffers WHERE product_id = '1061' AND merchantid = 'A1X6FK5RDHNB96'
227	0.0004	0.00043320655822754	SELECT * FROM productoffers WHERE product_id = '1061' AND price > 0 ORDER BY price ASC LIMIT 1
228	0.0004	0.00040698051452637	SELECT value FROM productattributes WHERE product_id = '1061' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
229	0.0005	0.00052881240844727	SELECT * FROM products WHERE id = '2165'
230	0.0005	0.00048995018005371	SELECT * FROM productimages WHERE product_id = '2165' ORDER BY sortorder ASC
231	0.0006	0.00064182281494141	SELECT * FROM product_image_select WHERE product_id = '2165'
232	0.0004	0.0003960132598877	SELECT * FROM productcustomimages WHERE product_id = '2165'
233	0.0029	0.0028579235076904	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '2165' AND a.name = n.originalname
234	0.0016	0.0016231536865234	SELECT * FROM productoffers WHERE product_id = '2165' AND merchantid = 'A1X6FK5RDHNB96'
235	0.0007	0.00071191787719727	SELECT * FROM productoffers WHERE product_id = '2165' AND price > 0 ORDER BY price ASC LIMIT 1
236	0.0009	0.00089097023010254	SELECT value FROM productattributes WHERE product_id = '2165' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
237	0.0010	0.00098419189453125	SELECT * FROM products WHERE id = '4939'
238	0.0009	0.00090503692626953	SELECT * FROM productimages WHERE product_id = '4939' ORDER BY sortorder ASC
239	0.0014	0.0014441013336182	SELECT * FROM product_image_select WHERE product_id = '4939'
240	0.0008	0.00076508522033691	SELECT * FROM productcustomimages WHERE product_id = '4939'
241	0.0020	0.0019998550415039	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4939' AND a.name = n.originalname
242	0.0008	0.00075411796569824	SELECT * FROM productoffers WHERE product_id = '4939' AND merchantid = 'A1X6FK5RDHNB96'
243	0.0007	0.00070095062255859	SELECT * FROM productoffers WHERE product_id = '4939' AND price > 0 ORDER BY price ASC LIMIT 1
244	0.0006	0.0006101131439209	SELECT value FROM productattributes WHERE product_id = '4939' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
245	0.0008	0.00075387954711914	SELECT * FROM products WHERE id = '1110'
246	0.0008	0.00082492828369141	SELECT * FROM productimages WHERE product_id = '1110' ORDER BY sortorder ASC
247	0.0009	0.00087308883666992	SELECT * FROM product_image_select WHERE product_id = '1110'
248	0.0006	0.00063014030456543	SELECT * FROM productcustomimages WHERE product_id = '1110'
249	0.0024	0.0024099349975586	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1110' AND a.name = n.originalname
250	0.0008	0.00075817108154297	SELECT * FROM productoffers WHERE product_id = '1110' AND merchantid = 'A1X6FK5RDHNB96'
251	0.0007	0.00070786476135254	SELECT * FROM productoffers WHERE product_id = '1110' AND price > 0 ORDER BY price ASC LIMIT 1
252	0.0005	0.00049018859863281	SELECT value FROM productattributes WHERE product_id = '1110' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
253	0.0008	0.00083208084106445	SELECT * FROM products WHERE id = '4930'
254	0.0006	0.00064492225646973	SELECT * FROM productimages WHERE product_id = '4930' ORDER BY sortorder ASC
255	0.0008	0.00079202651977539	SELECT * FROM product_image_select WHERE product_id = '4930'
256	0.0009	0.00085210800170898	SELECT * FROM productcustomimages WHERE product_id = '4930'
257	0.0016	0.0015981197357178	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4930' AND a.name = n.originalname
258	0.0006	0.00061893463134766	SELECT * FROM productoffers WHERE product_id = '4930' AND merchantid = 'A1X6FK5RDHNB96'
259	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '4930' AND price > 0 ORDER BY price ASC LIMIT 1
260	0.0005	0.0005040168762207	SELECT value FROM productattributes WHERE product_id = '4930' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
261	0.0024	0.00235915184021	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4950' ORDER BY timestamp DESC
262	0.0004	0.00035810470581055	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4953' ORDER BY timestamp DESC
263	0.0004	0.00041484832763672	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4933' ORDER BY timestamp DESC
264	0.0005	0.0005190372467041	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4926' ORDER BY timestamp DESC
265	0.0003	0.00034689903259277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4925' ORDER BY timestamp DESC
266	0.0004	0.00037097930908203	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '868' ORDER BY timestamp DESC
267	0.0005	0.00048184394836426	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4919' ORDER BY timestamp DESC
268	0.0004	0.00036406517028809	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2029' ORDER BY timestamp DESC
269	0.0004	0.00039005279541016	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '862' ORDER BY timestamp DESC
270	0.0004	0.00038886070251465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1011' ORDER BY timestamp DESC
271	0.0004	0.00040602684020996	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4122' ORDER BY timestamp DESC
272	0.0003	0.00026416778564453	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1010' ORDER BY timestamp DESC
273	0.0003	0.00026917457580566	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1140' ORDER BY timestamp DESC
274	0.0004	0.0003669261932373	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1061' ORDER BY timestamp DESC
275	0.0003	0.00026893615722656	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '2165' ORDER BY timestamp DESC
276	0.0003	0.00027894973754883	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4939' ORDER BY timestamp DESC
277	0.0003	0.00025701522827148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1110' ORDER BY timestamp DESC
278	0.0047	0.0046930313110352	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4930' ORDER BY timestamp DESC
279	0.0017	0.0016558170318604	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
280	0.0012	0.001244068145752	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
281	0.0003	0.00032591819763184	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
282	0.0154	0.015407800674438	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
283	0.0021	0.0021181106567383	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
284	0.0005	0.00054693222045898	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
285	0.0005	0.00054192543029785	SELECT * FROM products WHERE id = 1626
286	0.0005	0.00046181678771973	SELECT * FROM products WHERE id = 4041
287	0.0004	0.00044703483581543	SELECT * FROM products WHERE id = 4312
288	0.0006	0.00060296058654785	SELECT * FROM products WHERE id = 777
289	0.0005	0.00054502487182617	SELECT * FROM products WHERE id = 3881
290	0.0004	0.00041913986206055	SELECT * FROM products WHERE id = 4213
291	0.0005	0.00053501129150391	SELECT * FROM products WHERE id = '1626'
292	0.0005	0.00045108795166016	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
293	0.0006	0.00061702728271484	SELECT * FROM product_image_select WHERE product_id = '1626'
294	0.0005	0.0004880428314209	SELECT * FROM productcustomimages WHERE product_id = '1626'
295	0.0008	0.00080990791320801	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
296	0.0005	0.00048112869262695	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
297	0.0004	0.00037407875061035	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
298	0.0004	0.00039315223693848	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
299	0.0005	0.00048303604125977	SELECT * FROM products WHERE id = '4041'
300	0.0004	0.00042819976806641	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
301	0.0007	0.00066781044006348	SELECT * FROM product_image_select WHERE product_id = '4041'
302	0.0005	0.00050497055053711	SELECT * FROM productcustomimages WHERE product_id = '4041'
303	0.0018	0.0017750263214111	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
304	0.0005	0.00047206878662109	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
305	0.0004	0.00036287307739258	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
306	0.0005	0.00052094459533691	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
307	0.0010	0.0010130405426025	SELECT * FROM products WHERE id = '4312'
308	0.0007	0.0006721019744873	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
309	0.0010	0.0010349750518799	SELECT * FROM product_image_select WHERE product_id = '4312'
310	0.0007	0.00067710876464844	SELECT * FROM productcustomimages WHERE product_id = '4312'
311	0.0024	0.0024089813232422	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
312	0.0008	0.00076103210449219	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
313	0.0006	0.00064682960510254	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
314	0.0007	0.00068116188049316	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
315	0.0009	0.00093388557434082	SELECT * FROM products WHERE id = '777'
316	0.0007	0.00073885917663574	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
317	0.0006	0.00060296058654785	SELECT * FROM product_image_select WHERE product_id = '777'
318	0.0004	0.00043606758117676	SELECT * FROM productcustomimages WHERE product_id = '777'
319	0.0010	0.0010249614715576	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
320	0.0007	0.00071597099304199	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
321	0.0005	0.00046396255493164	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
322	0.0005	0.00048303604125977	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
323	0.0006	0.00060606002807617	SELECT * FROM products WHERE id = '3881'
324	0.0006	0.00055599212646484	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
325	0.0012	0.0011639595031738	SELECT * FROM product_image_select WHERE product_id = '3881'
326	0.0007	0.0007319450378418	SELECT * FROM productcustomimages WHERE product_id = '3881'
327	0.0017	0.0016500949859619	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
328	0.0007	0.0006859302520752	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
329	0.0005	0.00045180320739746	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
330	0.0008	0.00081300735473633	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
331	0.0006	0.00064802169799805	SELECT * FROM products WHERE id = '4213'
332	0.0006	0.00055313110351562	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
333	0.0006	0.00064492225646973	SELECT * FROM product_image_select WHERE product_id = '4213'
334	0.0005	0.00047707557678223	SELECT * FROM productcustomimages WHERE product_id = '4213'
335	0.0020	0.0019869804382324	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
336	0.0006	0.00056600570678711	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
337	0.0006	0.00061702728271484	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
338	0.0005	0.0005340576171875	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
339	0.0026	0.0025920867919922	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
340	0.0008	0.00079488754272461	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
341	0.0030	0.0030009746551514	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
342	0.0018	0.0017938613891602	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
343	0.0005	0.00046396255493164	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
344	0.0012	0.0012369155883789	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
345	0.0013	0.0012519359588623	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for ""

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.7437930107117 seconds

Query Debug - 345 Database Queries. Total time 1.2201 seconds