Search Results for "4"

boîte à thé, recouvert de papier de soie...

View to See Price

View

Add to Cart

Alice de la collection Boîte en bois ave...

View to See Price

View

Add to Cart

LUNA VOW Luna Vœu Japonais Céramique Boî...

View to See Price

View

Add to Cart

CARMANI - Motif inspiré de la nature, Co...

View to See Price

View

Add to Cart

Dragonfly Rooibos Breakfast Tea 40 per p...

View to See Price

View

Add to Cart

Elephant - The Rooibos Pomme Cannelle 40...

View to See Price

View

Add to Cart

Ocun Eternal Pants

View to See Price

View

Add to Cart

Neuf en bois Blanc 9 Compartiment Sachet...

View to See Price

View

Add to Cart

Elephant - The Rooibos Pomme Cannelle 40...

View to See Price

View

Add to Cart

Alter Éco - Thé Rooibos Au Caramel 40G -...

only €30,61

View

Add to Cart

Alter Éco - Thé Rooibos Bio 40G - Prix U...

only €28,51

View

Add to Cart

Mason Cash Authority Thé café Sucre Boît...

View to See Price

View

Add to Cart

Alter Éco - Thé Rooibos Bio 40G - Lot De...

View to See Price

View

Add to Cart

Alter Éco - Thé Rooibos Bio 40G - Lot De...

only €36,84

View

Add to Cart

Alter Éco - Thé Rooibos Au Caramel 40G -...

only €39,22

View

Add to Cart

GLQ Boîtes à thé/Boîtes métalliques Rond...

View to See Price

View

Add to Cart

SoBuy FRG259-N Boîte de rangement Boîte ...

View to See Price

View

Add to Cart

MK447B Boîte à thé en bambou 12 comparti...

View to See Price

View

Add to Cart

289 to 306 of 336 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
3.0807847976685	388	0.9400	0

No Amazon API Requests Made.

App Debug - Total Time 3.0807847976685 seconds

Number	Time From Start	Name	Description
1	2.0177597999573	Initialise	Initialise FSB Function
2	2.0216507911682	App Controller Start	Start of the App controller (called before the controller of every page)
3	2.0671827793121	Start of getCategoryListByGroup Function	Before first category groups query
4	2.0686528682709	After initial query	Before first category groups query
5	2.0686550140381	Get Category List for Group	Before the call to getCategoryList function
6	2.0686588287354	Start of GetCategoryList function	Start of the function
7	2.0686619281769	Before getting categories	Query to get specific category list
8	2.0702078342438	After getting categories	Query to get specific category list
9	2.070209980011	Before getting category custom	Before call to function getCategoryCustom
10	2.0923209190369	After getting category custom	After call to function getCategoryCustom
11	2.0923237800598	Before getting category custom	Before call to function getCategoryCustom
12	2.1053688526154	After getting category custom	After call to function getCategoryCustom
13	2.1053709983826	Before getting category custom	Before call to function getCategoryCustom
14	2.11416888237	After getting category custom	After call to function getCategoryCustom
15	2.1141707897186	Before getting category custom	Before call to function getCategoryCustom
16	2.1225328445435	After getting category custom	After call to function getCategoryCustom
17	2.1225349903107	Before getting category custom	Before call to function getCategoryCustom
18	2.1291038990021	After getting category custom	After call to function getCategoryCustom
19	2.1291058063507	Before getting category custom	Before call to function getCategoryCustom
20	2.1353068351746	After getting category custom	After call to function getCategoryCustom
21	2.1353099346161	End of GetCategoryList function	End of the function
22	2.1353158950806	Get Category List for Group	Before the call to getCategoryList function
23	2.1353178024292	Start of GetCategoryList function	Start of the function
24	2.135321855545	Before getting categories	Query to get specific category list
25	2.1359148025513	End of getCategoryListByGroup Function	Before return()
26	2.633535861969	App Controller End	End of the App controller (called before the controller of every page)
27	2.8639698028564	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	2.867250919342	Before Get Options	Before the call to getOptions in the tpl class
29	2.9505319595337	After Get Options	After the call to getOptions in the tpl class
30	2.9505639076233	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	3.080766916275	Finalizing debug	Before the debug is output to the page.
32	3.0807828903198	End of App	This is the end of the app logging, final timestamp

Query Debug - 388 Database Queries. Total time 0.9400 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:11:\"3.22.250.18\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738827657'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-02-06 07:40:57' 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.22.250.18') >= INET_ATON(ip_start) AND INET_ATON('3.22.250.18') <= 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(), '3.22.250.18'
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 = '3124'
SELECT * FROM productimages WHERE product_id = '3124' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3124'
SELECT * FROM productcustomimages WHERE product_id = '3124'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3124' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3124' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3124' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3124
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3124'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3124' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3129'
SELECT * FROM productimages WHERE product_id = '3129' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3129'
SELECT * FROM productcustomimages WHERE product_id = '3129'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3129' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3129' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3129' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3129
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3129'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3129' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3175'
SELECT * FROM productimages WHERE product_id = '3175' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3175'
SELECT * FROM productcustomimages WHERE product_id = '3175'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3175' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3175' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3175' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3175
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3175'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3601'
SELECT * FROM productimages WHERE product_id = '3601' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3601'
SELECT * FROM productcustomimages WHERE product_id = '3601'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3601' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3601' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3601' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3601
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3601'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3252'
SELECT * FROM productimages WHERE product_id = '3252' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3252'
SELECT * FROM productcustomimages WHERE product_id = '3252'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3252' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3252' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3252' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3252
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3252'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3590'
SELECT * FROM productimages WHERE product_id = '3590' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3590'
SELECT * FROM productcustomimages WHERE product_id = '3590'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3590' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3590' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3590' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3590
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3590'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3590' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3434'
SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3434'
SELECT * FROM productcustomimages WHERE product_id = '3434'
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 = '3434'
                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     = '3434'
                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 = 3434
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3434' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3434
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3434'
                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 = '3434'
                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     = '3434'
                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 = 3434
SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3434'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '3472'
SELECT * FROM productimages WHERE product_id = '3472' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3472'
SELECT * FROM productcustomimages WHERE product_id = '3472'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3472' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3472' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3472' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3472
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3472'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3523'
SELECT * FROM productimages WHERE product_id = '3523' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3523' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3523'
SELECT * FROM productcustomimages WHERE product_id = '3523'
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 = '3523'
                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     = '3523'
                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 = 3523
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3523' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3523' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3523' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3523
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3523'
                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 = '3523'
                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     = '3523'
                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 = 3523
SELECT value FROM productattributes WHERE product_id = '3523' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '3523'
SELECT * FROM products WHERE id = '3524'
SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3524'
SELECT * FROM productcustomimages WHERE product_id = '3524'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3524' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3525'
SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3525'
SELECT * FROM productcustomimages WHERE product_id = '3525'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3525' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3856'
SELECT * FROM productimages WHERE product_id = '3856' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3856'
SELECT * FROM productcustomimages WHERE product_id = '3856'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3856' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3856' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3856' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3856
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3856'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3856' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3578'
SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3578'
SELECT * FROM productcustomimages WHERE product_id = '3578'
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 = '3578'
                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     = '3578'
                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 = 3578
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3578' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3578
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3578'
                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 = '3578'
                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     = '3578'
                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 = 3578
SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '3578'
SELECT * FROM products WHERE id = '3587'
SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3587'
SELECT * FROM productcustomimages WHERE product_id = '3587'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3587' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3588'
SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3588'
SELECT * FROM productcustomimages WHERE product_id = '3588'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3588' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3600'
SELECT * FROM productimages WHERE product_id = '3600' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3600'
SELECT * FROM productcustomimages WHERE product_id = '3600'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3600' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3600' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3600' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3600
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3600'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3738'
SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3738'
SELECT * FROM productcustomimages WHERE product_id = '3738'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3738' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3738
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3738'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3623'
SELECT * FROM productimages WHERE product_id = '3623' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3623'
SELECT * FROM productcustomimages WHERE product_id = '3623'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3623' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3623' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3623' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3623
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3623'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3623' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3124' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3129' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3175' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3601' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3252' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3590' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3472' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3523' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3524' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3525' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3856' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3578' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3587' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3588' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3600' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3623' 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.0021	0.0020999908447266	SELECT parameter, value FROM parameters
2	0.0060	0.0060200691223145	SELECT * FROM `bad_bots`
3	0.0004	0.00039887428283691	SET time_zone = 'Europe/London'
4	0.0021	0.0021450519561768	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0021	0.0020980834960938	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:11:\"3.22.250.18\";}'
6	0.0016	0.0016000270843506	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1738827657'
7	0.0027	0.0026910305023193	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0004	0.00043511390686035	UPDATE autorun SET lastrun = '2025-02-06 07:40:57' WHERE id = '16'
9	0.0007	0.0006568431854248	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0021	0.0021319389343262	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0005	0.00046014785766602	SELECT * FROM pages WHERE id = 52
12	0.0074	0.0074450969696045	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0370	0.036979198455811	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0006	0.00062394142150879	SELECT * FROM pages WHERE pagename = 'search'
15	0.0015	0.0014579296112061	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0015	0.0015201568603516	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0080	0.0080339908599854	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.0016	0.0015912055969238	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.0012	0.0012421607971191	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0004	0.00044703483581543	SELECT id FROM categories WHERE parent_id = '26'
21	0.0057	0.005666971206665	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
22	0.0015	0.0015110969543457	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.0015	0.0014948844909668	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.0015	0.0015039443969727	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0005	0.00051307678222656	SELECT * FROM categorygroups WHERE id = '1'
26	0.0053	0.0052990913391113	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.0008	0.00075292587280273	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.00049805641174316	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0005	0.00050115585327148	SELECT id FROM categories WHERE parent_id = '27'
30	0.0038	0.0038390159606934	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.0006	0.00059008598327637	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.00051999092102051	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.0005030632019043	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0005	0.00045585632324219	SELECT * FROM categorygroups WHERE id = '1'
35	0.0015	0.0014779567718506	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.00047707557678223	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.00042605400085449	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0007	0.00073599815368652	SELECT id FROM categories WHERE parent_id = '28'
39	0.0029	0.0028550624847412	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.0007	0.00070977210998535	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (28) AND p.disabled = 0
41	0.0008	0.00075507164001465	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (28) AND c.prod_type = 'custom' AND cp.hide = 0
42	0.0007	0.00070309638977051	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0006	0.0005650520324707	SELECT * FROM categorygroups WHERE id = '1'
44	0.0011	0.0010800361633301	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.0008	0.00080585479736328	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.0006	0.00059390068054199	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0006	0.00055813789367676	SELECT id FROM categories WHERE parent_id = '29'
48	0.0011	0.001115083694458	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.0011	0.0010850429534912	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.0016	0.0016300678253174	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
51	0.0007	0.00069594383239746	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0007	0.00070881843566895	SELECT * FROM categorygroups WHERE id = '1'
53	0.0009	0.00090312957763672	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.00064516067504883	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.00049901008605957	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0005	0.00053906440734863	SELECT id FROM categories WHERE parent_id = '30'
57	0.0010	0.00099515914916992	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.0008	0.00078201293945312	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (30) AND p.disabled = 0
59	0.0009	0.0008690357208252	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.0007	0.00066399574279785	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0006	0.00058889389038086	SELECT * FROM categorygroups WHERE id = '1'
62	0.0008	0.00080084800720215	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63	0.0006	0.0006248950958252	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.0005	0.00049400329589844	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0005	0.00049495697021484	SELECT id FROM categories WHERE parent_id = '31'
66	0.0011	0.001060962677002	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
67	0.0007	0.00068497657775879	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (31) AND p.disabled = 0
68	0.0008	0.00076985359191895	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
69	0.0006	0.00063395500183105	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0006	0.00055503845214844	SELECT * FROM categorygroups WHERE id = '1'
71	0.0006	0.00058293342590332	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0036	0.0035910606384277	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0018	0.0018208026885986	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0007	0.0006721019744873	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.0014	0.0014071464538574	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0015	0.0015089511871338	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0011	0.0011091232299805	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.4821	0.48207187652588	SELECT * FROM ipgeocountries WHERE INET_ATON('3.22.250.18') >= INET_ATON(ip_start) AND INET_ATON('3.22.250.18') <= INET_ATON(ip_end)
79	0.0022	0.0022299289703369	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0012	0.0012140274047852	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0006	0.00059103965759277	SELECT * FROM pages WHERE pagename = 'search'
82	0.0053	0.0053069591522217	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0016	0.0015630722045898	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0015	0.001478910446167	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0052	0.0052011013031006	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0016	0.0015721321105957	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0005	0.00049686431884766	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0013	0.0013031959533691	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '3.22.250.18'
89	0.0007	0.00070500373840332	SELECT DISTINCT (p.id), salesrank, price, linktitle, MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) as searchrelevance, 'product' AS type FROM products p WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND enabled = 1 AND hidden = 0 AND parent_id = 0 AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title) AGAINST ('+4'), 'bundle' AS type FROM bundles b WHERE MATCH (title) AGAINST ('+4' IN BOOLEAN MODE) AND b.disabled = 0 AND 1 = 1
90	0.0005	0.00051999092102051	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.0039	0.0038959980010986	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.0005	0.00048494338989258	SELECT DISTINCT (p.id), price, linktitle, 'ebayproduct' AS type FROM ebay_products p WHERE ((description LIKE '4') OR (title LIKE '4')) AND hide = 0
93	0.0005	0.00050592422485352	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.0005	0.00052285194396973	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.0045	0.0045318603515625	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.00036215782165527	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.00036120414733887	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.0005	0.00051498413085938	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.0005	0.00054502487182617	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.0038	0.0037848949432373	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.0004	0.00041294097900391	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.0008	0.00084018707275391	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.0012	0.0012209415435791	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.0129	0.012864112854004	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.0006	0.00056004524230957	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.0010	0.00095009803771973	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.0006	0.0006260871887207	SELECT * FROM products WHERE id = '3124'
108	0.0025	0.0024878978729248	SELECT * FROM productimages WHERE product_id = '3124' ORDER BY sortorder ASC
109	0.0021	0.0020899772644043	SELECT * FROM product_image_select WHERE product_id = '3124'
110	0.0016	0.0015900135040283	SELECT * FROM productcustomimages WHERE product_id = '3124'
111	0.0022	0.0021710395812988	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3124' AND a.name = n.originalname
112	0.0019	0.0018701553344727	SELECT * FROM productoffers WHERE product_id = '3124' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0005	0.00054812431335449	SELECT * FROM productoffers WHERE product_id = '3124' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0005	0.00047492980957031	SELECT * FROM productoffers WHERE product_id = 3124 ORDER BY price ASC LIMIT 1
115	0.0006	0.00061702728271484	SELECT value FROM productattributes WHERE product_id = '3124' AND name = 'ListPriceAmount'
116	0.0006	0.00055098533630371	SELECT value FROM productattributes WHERE product_id = '3124' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0006	0.0006251335144043	SELECT * FROM products WHERE id = '3129'
118	0.0005	0.00048613548278809	SELECT * FROM productimages WHERE product_id = '3129' ORDER BY sortorder ASC
119	0.0006	0.00064516067504883	SELECT * FROM product_image_select WHERE product_id = '3129'
120	0.0004	0.00042891502380371	SELECT * FROM productcustomimages WHERE product_id = '3129'
121	0.0015	0.0015249252319336	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3129' AND a.name = n.originalname
122	0.0006	0.0005500316619873	SELECT * FROM productoffers WHERE product_id = '3129' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0005	0.00046992301940918	SELECT * FROM productoffers WHERE product_id = '3129' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0004	0.00040102005004883	SELECT * FROM productoffers WHERE product_id = 3129 ORDER BY price ASC LIMIT 1
125	0.0004	0.0004270076751709	SELECT value FROM productattributes WHERE product_id = '3129' AND name = 'ListPriceAmount'
126	0.0005	0.00047206878662109	SELECT value FROM productattributes WHERE product_id = '3129' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
127	0.0006	0.00057697296142578	SELECT * FROM products WHERE id = '3175'
128	0.0007	0.00071907043457031	SELECT * FROM productimages WHERE product_id = '3175' ORDER BY sortorder ASC
129	0.0007	0.00066399574279785	SELECT * FROM product_image_select WHERE product_id = '3175'
130	0.0004	0.00044798851013184	SELECT * FROM productcustomimages WHERE product_id = '3175'
131	0.0011	0.0011200904846191	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3175' AND a.name = n.originalname
132	0.0006	0.00056004524230957	SELECT * FROM productoffers WHERE product_id = '3175' AND merchantid = 'A1X6FK5RDHNB96'
133	0.0005	0.00046515464782715	SELECT * FROM productoffers WHERE product_id = '3175' AND price > 0 ORDER BY price ASC LIMIT 1
134	0.0004	0.0004279613494873	SELECT * FROM productoffers WHERE product_id = 3175 ORDER BY price ASC LIMIT 1
135	0.0004	0.00042915344238281	SELECT value FROM productattributes WHERE product_id = '3175' AND name = 'ListPriceAmount'
136	0.0005	0.00047898292541504	SELECT value FROM productattributes WHERE product_id = '3175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
137	0.0006	0.00064706802368164	SELECT * FROM products WHERE id = '3601'
138	0.0005	0.0004889965057373	SELECT * FROM productimages WHERE product_id = '3601' ORDER BY sortorder ASC
139	0.0006	0.00064992904663086	SELECT * FROM product_image_select WHERE product_id = '3601'
140	0.0005	0.0004730224609375	SELECT * FROM productcustomimages WHERE product_id = '3601'
141	0.0009	0.00089311599731445	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3601' AND a.name = n.originalname
142	0.0005	0.00050616264343262	SELECT * FROM productoffers WHERE product_id = '3601' AND merchantid = 'A1X6FK5RDHNB96'
143	0.0005	0.0004580020904541	SELECT * FROM productoffers WHERE product_id = '3601' AND price > 0 ORDER BY price ASC LIMIT 1
144	0.0004	0.0003809928894043	SELECT * FROM productoffers WHERE product_id = 3601 ORDER BY price ASC LIMIT 1
145	0.0004	0.00043201446533203	SELECT value FROM productattributes WHERE product_id = '3601' AND name = 'ListPriceAmount'
146	0.0004	0.00044608116149902	SELECT value FROM productattributes WHERE product_id = '3601' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
147	0.0006	0.00057196617126465	SELECT * FROM products WHERE id = '3252'
148	0.0005	0.00050091743469238	SELECT * FROM productimages WHERE product_id = '3252' ORDER BY sortorder ASC
149	0.0007	0.00066494941711426	SELECT * FROM product_image_select WHERE product_id = '3252'
150	0.0005	0.00045013427734375	SELECT * FROM productcustomimages WHERE product_id = '3252'
151	0.0009	0.00089502334594727	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3252' AND a.name = n.originalname
152	0.0007	0.00068092346191406	SELECT * FROM productoffers WHERE product_id = '3252' AND merchantid = 'A1X6FK5RDHNB96'
153	0.0006	0.00055098533630371	SELECT * FROM productoffers WHERE product_id = '3252' AND price > 0 ORDER BY price ASC LIMIT 1
154	0.0006	0.00057101249694824	SELECT * FROM productoffers WHERE product_id = 3252 ORDER BY price ASC LIMIT 1
155	0.0005	0.00054597854614258	SELECT value FROM productattributes WHERE product_id = '3252' AND name = 'ListPriceAmount'
156	0.0006	0.00064706802368164	SELECT value FROM productattributes WHERE product_id = '3252' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157	0.0007	0.00071597099304199	SELECT * FROM products WHERE id = '3590'
158	0.0007	0.0006861686706543	SELECT * FROM productimages WHERE product_id = '3590' ORDER BY sortorder ASC
159	0.0008	0.00081586837768555	SELECT * FROM product_image_select WHERE product_id = '3590'
160	0.0005	0.00049805641174316	SELECT * FROM productcustomimages WHERE product_id = '3590'
161	0.0011	0.0011160373687744	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3590' AND a.name = n.originalname
162	0.0006	0.000640869140625	SELECT * FROM productoffers WHERE product_id = '3590' AND merchantid = 'A1X6FK5RDHNB96'
163	0.0005	0.00050187110900879	SELECT * FROM productoffers WHERE product_id = '3590' AND price > 0 ORDER BY price ASC LIMIT 1
164	0.0004	0.00039482116699219	SELECT * FROM productoffers WHERE product_id = 3590 ORDER BY price ASC LIMIT 1
165	0.0005	0.00046896934509277	SELECT value FROM productattributes WHERE product_id = '3590' AND name = 'ListPriceAmount'
166	0.0005	0.00054001808166504	SELECT value FROM productattributes WHERE product_id = '3590' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
167	0.0006	0.00058603286743164	SELECT * FROM products WHERE id = '3434'
168	0.0011	0.001086950302124	SELECT * FROM productimages WHERE product_id = '3434' ORDER BY sortorder ASC
169	0.0014	0.0013959407806396	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3434' AND p.id = pi.product_id ORDER BY pi.sortorder
170	0.0007	0.00072503089904785	SELECT * FROM product_image_select WHERE product_id = '3434'
171	0.0005	0.00046014785766602	SELECT * FROM productcustomimages WHERE product_id = '3434'
172	0.0007	0.00069999694824219	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 = '3434' GROUP BY o.product_id
173	0.0036	0.0036020278930664	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 = '3434' GROUP BY n.displayname ORDER BY n.displayname DESC
174	0.0008	0.00076699256896973	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
175	0.0011	0.0011060237884521	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3434' AND a.name = n.originalname
176	0.0005	0.00045108795166016	SELECT * FROM productoffers WHERE product_id = '3434' AND merchantid = 'A1X6FK5RDHNB96'
177	0.0004	0.00044798851013184	SELECT * FROM productoffers WHERE product_id = '3434' AND price > 0 ORDER BY price ASC LIMIT 1
178	0.0005	0.00047898292541504	SELECT * FROM productoffers WHERE product_id = 3434 ORDER BY price ASC LIMIT 1
179	0.0005	0.00046491622924805	SELECT value FROM productattributes WHERE product_id = '3434' AND name = 'ListPriceAmount'
180	0.0006	0.00063490867614746	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 = '3434' GROUP BY o.product_id
181	0.0013	0.0013070106506348	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 = '3434' GROUP BY n.displayname ORDER BY n.displayname DESC
182	0.0006	0.00057411193847656	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3434
183	0.0006	0.00063109397888184	SELECT value FROM productattributes WHERE product_id = '3434' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
184	0.0009	0.00090193748474121	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3434' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
185	0.0009	0.00089216232299805	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3434' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
186	0.0005	0.00050497055053711	SELECT * FROM products WHERE id = '3472'
187	0.0006	0.00057005882263184	SELECT * FROM productimages WHERE product_id = '3472' ORDER BY sortorder ASC
188	0.0007	0.00068211555480957	SELECT * FROM product_image_select WHERE product_id = '3472'
189	0.0005	0.0005040168762207	SELECT * FROM productcustomimages WHERE product_id = '3472'
190	0.0011	0.0010871887207031	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3472' AND a.name = n.originalname
191	0.0005	0.00051212310791016	SELECT * FROM productoffers WHERE product_id = '3472' AND merchantid = 'A1X6FK5RDHNB96'
192	0.0004	0.00043487548828125	SELECT * FROM productoffers WHERE product_id = '3472' AND price > 0 ORDER BY price ASC LIMIT 1
193	0.0004	0.0003809928894043	SELECT * FROM productoffers WHERE product_id = 3472 ORDER BY price ASC LIMIT 1
194	0.0004	0.00044608116149902	SELECT value FROM productattributes WHERE product_id = '3472' AND name = 'ListPriceAmount'
195	0.0005	0.00047492980957031	SELECT value FROM productattributes WHERE product_id = '3472' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
196	0.0006	0.00059294700622559	SELECT * FROM products WHERE id = '3523'
197	0.0006	0.00058722496032715	SELECT * FROM productimages WHERE product_id = '3523' ORDER BY sortorder ASC
198	0.0005	0.00048089027404785	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3523' AND p.id = pi.product_id ORDER BY pi.sortorder
199	0.0006	0.00063610076904297	SELECT * FROM product_image_select WHERE product_id = '3523'
200	0.0004	0.00043892860412598	SELECT * FROM productcustomimages WHERE product_id = '3523'
201	0.0006	0.00055384635925293	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 = '3523' GROUP BY o.product_id
202	0.0007	0.00072789192199707	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 = '3523' GROUP BY n.displayname ORDER BY n.displayname DESC
203	0.0005	0.00054192543029785	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3523
204	0.0009	0.00092315673828125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3523' AND a.name = n.originalname
205	0.0004	0.00043106079101562	SELECT * FROM productoffers WHERE product_id = '3523' AND merchantid = 'A1X6FK5RDHNB96'
206	0.0004	0.00043702125549316	SELECT * FROM productoffers WHERE product_id = '3523' AND price > 0 ORDER BY price ASC LIMIT 1
207	0.0004	0.00041913986206055	SELECT * FROM productoffers WHERE product_id = 3523 ORDER BY price ASC LIMIT 1
208	0.0004	0.00044894218444824	SELECT value FROM productattributes WHERE product_id = '3523' AND name = 'ListPriceAmount'
209	0.0005	0.00050783157348633	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 = '3523' GROUP BY o.product_id
210	0.0006	0.00063109397888184	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 = '3523' GROUP BY n.displayname ORDER BY n.displayname DESC
211	0.0004	0.00041890144348145	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3523
212	0.0006	0.00056600570678711	SELECT value FROM productattributes WHERE product_id = '3523' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
213	0.0005	0.00048303604125977	SELECT * FROM products WHERE parent_id = '3523'
214	0.0006	0.00064301490783691	SELECT * FROM products WHERE id = '3524'
215	0.0005	0.000518798828125	SELECT * FROM productimages WHERE product_id = '3524' ORDER BY sortorder ASC
216	0.0007	0.00068092346191406	SELECT * FROM product_image_select WHERE product_id = '3524'
217	0.0005	0.00045299530029297	SELECT * FROM productcustomimages WHERE product_id = '3524'
218	0.0009	0.00093293190002441	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3524' AND a.name = n.originalname
219	0.0005	0.00053715705871582	SELECT * FROM productoffers WHERE product_id = '3524' AND merchantid = 'A1X6FK5RDHNB96'
220	0.0005	0.00047492980957031	SELECT * FROM productoffers WHERE product_id = '3524' AND price > 0 ORDER BY price ASC LIMIT 1
221	0.0004	0.00043606758117676	SELECT value FROM productattributes WHERE product_id = '3524' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
222	0.0007	0.00067400932312012	SELECT * FROM products WHERE id = '3525'
223	0.0006	0.00057315826416016	SELECT * FROM productimages WHERE product_id = '3525' ORDER BY sortorder ASC
224	0.0007	0.00067281723022461	SELECT * FROM product_image_select WHERE product_id = '3525'
225	0.0005	0.00049209594726562	SELECT * FROM productcustomimages WHERE product_id = '3525'
226	0.0009	0.0009160041809082	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3525' AND a.name = n.originalname
227	0.0006	0.00055193901062012	SELECT * FROM productoffers WHERE product_id = '3525' AND merchantid = 'A1X6FK5RDHNB96'
228	0.0005	0.00048995018005371	SELECT * FROM productoffers WHERE product_id = '3525' AND price > 0 ORDER BY price ASC LIMIT 1
229	0.0006	0.0005638599395752	SELECT value FROM productattributes WHERE product_id = '3525' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
230	0.0007	0.00066995620727539	SELECT * FROM products WHERE id = '3856'
231	0.0005	0.00052380561828613	SELECT * FROM productimages WHERE product_id = '3856' ORDER BY sortorder ASC
232	0.0007	0.00069403648376465	SELECT * FROM product_image_select WHERE product_id = '3856'
233	0.0005	0.00048708915710449	SELECT * FROM productcustomimages WHERE product_id = '3856'
234	0.0018	0.0017809867858887	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3856' AND a.name = n.originalname
235	0.0006	0.00063705444335938	SELECT * FROM productoffers WHERE product_id = '3856' AND merchantid = 'A1X6FK5RDHNB96'
236	0.0005	0.00046396255493164	SELECT * FROM productoffers WHERE product_id = '3856' AND price > 0 ORDER BY price ASC LIMIT 1
237	0.0005	0.00047993659973145	SELECT * FROM productoffers WHERE product_id = 3856 ORDER BY price ASC LIMIT 1
238	0.0005	0.00050711631774902	SELECT value FROM productattributes WHERE product_id = '3856' AND name = 'ListPriceAmount'
239	0.0006	0.00056314468383789	SELECT value FROM productattributes WHERE product_id = '3856' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240	0.0006	0.00060892105102539	SELECT * FROM products WHERE id = '3578'
241	0.0006	0.00062394142150879	SELECT * FROM productimages WHERE product_id = '3578' ORDER BY sortorder ASC
242	0.0010	0.0009911060333252	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3578' AND p.id = pi.product_id ORDER BY pi.sortorder
243	0.0014	0.0013859272003174	SELECT * FROM product_image_select WHERE product_id = '3578'
244	0.0007	0.00069999694824219	SELECT * FROM productcustomimages WHERE product_id = '3578'
245	0.0013	0.0012750625610352	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 = '3578' GROUP BY o.product_id
246	0.0015	0.0015349388122559	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 = '3578' GROUP BY n.displayname ORDER BY n.displayname DESC
247	0.0007	0.00071382522583008	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
248	0.0020	0.002018928527832	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3578' AND a.name = n.originalname
249	0.0007	0.0007469654083252	SELECT * FROM productoffers WHERE product_id = '3578' AND merchantid = 'A1X6FK5RDHNB96'
250	0.0006	0.0006401538848877	SELECT * FROM productoffers WHERE product_id = '3578' AND price > 0 ORDER BY price ASC LIMIT 1
251	0.0006	0.00056195259094238	SELECT * FROM productoffers WHERE product_id = 3578 ORDER BY price ASC LIMIT 1
252	0.0008	0.00083780288696289	SELECT value FROM productattributes WHERE product_id = '3578' AND name = 'ListPriceAmount'
253	0.0008	0.00082612037658691	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 = '3578' GROUP BY o.product_id
254	0.0012	0.0012340545654297	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 = '3578' GROUP BY n.displayname ORDER BY n.displayname DESC
255	0.0006	0.0006411075592041	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3578
256	0.0011	0.0011069774627686	SELECT value FROM productattributes WHERE product_id = '3578' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
257	0.0008	0.00077581405639648	SELECT * FROM products WHERE parent_id = '3578'
258	0.0008	0.00082302093505859	SELECT * FROM products WHERE id = '3587'
259	0.0010	0.00099897384643555	SELECT * FROM productimages WHERE product_id = '3587' ORDER BY sortorder ASC
260	0.0011	0.0011389255523682	SELECT * FROM product_image_select WHERE product_id = '3587'
261	0.0007	0.0006709098815918	SELECT * FROM productcustomimages WHERE product_id = '3587'
262	0.0017	0.0016510486602783	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3587' AND a.name = n.originalname
263	0.0009	0.00085806846618652	SELECT * FROM productoffers WHERE product_id = '3587' AND merchantid = 'A1X6FK5RDHNB96'
264	0.0007	0.0006558895111084	SELECT * FROM productoffers WHERE product_id = '3587' AND price > 0 ORDER BY price ASC LIMIT 1
265	0.0008	0.0007779598236084	SELECT value FROM productattributes WHERE product_id = '3587' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
266	0.0009	0.00092482566833496	SELECT * FROM products WHERE id = '3588'
267	0.0008	0.00084996223449707	SELECT * FROM productimages WHERE product_id = '3588' ORDER BY sortorder ASC
268	0.0011	0.0010619163513184	SELECT * FROM product_image_select WHERE product_id = '3588'
269	0.0007	0.00066518783569336	SELECT * FROM productcustomimages WHERE product_id = '3588'
270	0.0017	0.0016629695892334	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3588' AND a.name = n.originalname
271	0.0014	0.00142502784729	SELECT * FROM productoffers WHERE product_id = '3588' AND merchantid = 'A1X6FK5RDHNB96'
272	0.0008	0.00082802772521973	SELECT * FROM productoffers WHERE product_id = '3588' AND price > 0 ORDER BY price ASC LIMIT 1
273	0.0007	0.00074911117553711	SELECT value FROM productattributes WHERE product_id = '3588' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
274	0.0009	0.00086307525634766	SELECT * FROM products WHERE id = '3600'
275	0.0008	0.00078010559082031	SELECT * FROM productimages WHERE product_id = '3600' ORDER BY sortorder ASC
276	0.0009	0.00092792510986328	SELECT * FROM product_image_select WHERE product_id = '3600'
277	0.0006	0.0005638599395752	SELECT * FROM productcustomimages WHERE product_id = '3600'
278	0.0013	0.0013210773468018	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3600' AND a.name = n.originalname
279	0.0007	0.00067806243896484	SELECT * FROM productoffers WHERE product_id = '3600' AND merchantid = 'A1X6FK5RDHNB96'
280	0.0006	0.00056314468383789	SELECT * FROM productoffers WHERE product_id = '3600' AND price > 0 ORDER BY price ASC LIMIT 1
281	0.0005	0.00051093101501465	SELECT * FROM productoffers WHERE product_id = 3600 ORDER BY price ASC LIMIT 1
282	0.0005	0.0005488395690918	SELECT value FROM productattributes WHERE product_id = '3600' AND name = 'ListPriceAmount'
283	0.0007	0.00066494941711426	SELECT value FROM productattributes WHERE product_id = '3600' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284	0.0008	0.00079488754272461	SELECT * FROM products WHERE id = '3738'
285	0.0032	0.0032320022583008	SELECT * FROM productimages WHERE product_id = '3738' ORDER BY sortorder ASC
286	0.0015	0.0015380382537842	SELECT * FROM product_image_select WHERE product_id = '3738'
287	0.0010	0.00095295906066895	SELECT * FROM productcustomimages WHERE product_id = '3738'
288	0.0033	0.0032899379730225	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3738' AND a.name = n.originalname
289	0.0015	0.0014569759368896	SELECT * FROM productoffers WHERE product_id = '3738' AND merchantid = 'A1X6FK5RDHNB96'
290	0.0010	0.00098395347595215	SELECT * FROM productoffers WHERE product_id = '3738' AND price > 0 ORDER BY price ASC LIMIT 1
291	0.0008	0.00080108642578125	SELECT * FROM productoffers WHERE product_id = 3738 ORDER BY price ASC LIMIT 1
292	0.0012	0.0012068748474121	SELECT value FROM productattributes WHERE product_id = '3738' AND name = 'ListPriceAmount'
293	0.0010	0.0010039806365967	SELECT value FROM productattributes WHERE product_id = '3738' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
294	0.0012	0.0012168884277344	SELECT * FROM products WHERE id = '3623'
295	0.0010	0.00096297264099121	SELECT * FROM productimages WHERE product_id = '3623' ORDER BY sortorder ASC
296	0.0014	0.0014040470123291	SELECT * FROM product_image_select WHERE product_id = '3623'
297	0.0008	0.00078797340393066	SELECT * FROM productcustomimages WHERE product_id = '3623'
298	0.0019	0.00189208984375	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3623' AND a.name = n.originalname
299	0.0010	0.00098586082458496	SELECT * FROM productoffers WHERE product_id = '3623' AND merchantid = 'A1X6FK5RDHNB96'
300	0.0007	0.00068998336791992	SELECT * FROM productoffers WHERE product_id = '3623' AND price > 0 ORDER BY price ASC LIMIT 1
301	0.0007	0.00065088272094727	SELECT * FROM productoffers WHERE product_id = 3623 ORDER BY price ASC LIMIT 1
302	0.0007	0.0007319450378418	SELECT value FROM productattributes WHERE product_id = '3623' AND name = 'ListPriceAmount'
303	0.0009	0.00089097023010254	SELECT value FROM productattributes WHERE product_id = '3623' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
304	0.0033	0.003303050994873	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3124' ORDER BY timestamp DESC
305	0.0005	0.00053501129150391	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3129' ORDER BY timestamp DESC
306	0.0005	0.00049090385437012	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3175' ORDER BY timestamp DESC
307	0.0005	0.0004570484161377	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3601' ORDER BY timestamp DESC
308	0.0005	0.00051093101501465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3252' ORDER BY timestamp DESC
309	0.0005	0.00050115585327148	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3590' ORDER BY timestamp DESC
310	0.0005	0.00052094459533691	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3434' ORDER BY timestamp DESC
311	0.0005	0.00050806999206543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3472' ORDER BY timestamp DESC
312	0.0005	0.00049209594726562	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3523' ORDER BY timestamp DESC
313	0.0005	0.00046610832214355	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3524' ORDER BY timestamp DESC
314	0.0005	0.00046896934509277	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3525' ORDER BY timestamp DESC
315	0.0005	0.00045418739318848	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3856' ORDER BY timestamp DESC
316	0.0004	0.00043487548828125	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3578' ORDER BY timestamp DESC
317	0.0005	0.0004889965057373	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3587' ORDER BY timestamp DESC
318	0.0005	0.00048494338989258	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3588' ORDER BY timestamp DESC
319	0.0006	0.00057196617126465	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3600' ORDER BY timestamp DESC
320	0.0005	0.00053215026855469	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3738' ORDER BY timestamp DESC
321	0.0005	0.00045084953308105	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3623' ORDER BY timestamp DESC
322	0.0030	0.003032922744751	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
323	0.0026	0.0026159286499023	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
324	0.0006	0.00059604644775391	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
325	0.0213	0.021327018737793	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
326	0.0019	0.0019309520721436	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
327	0.0007	0.00071907043457031	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
328	0.0006	0.00060200691223145	SELECT * FROM products WHERE id = 1626
329	0.0006	0.00060701370239258	SELECT * FROM products WHERE id = 4041
330	0.0006	0.00057792663574219	SELECT * FROM products WHERE id = 4312
331	0.0008	0.00077486038208008	SELECT * FROM products WHERE id = 777
332	0.0007	0.00066804885864258	SELECT * FROM products WHERE id = 3881
333	0.0006	0.00059294700622559	SELECT * FROM products WHERE id = 4213
334	0.0006	0.00060701370239258	SELECT * FROM products WHERE id = '1626'
335	0.0005	0.000518798828125	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
336	0.0006	0.00059199333190918	SELECT * FROM product_image_select WHERE product_id = '1626'
337	0.0005	0.00047588348388672	SELECT * FROM productcustomimages WHERE product_id = '1626'
338	0.0009	0.00089192390441895	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
339	0.0006	0.00057196617126465	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
340	0.0005	0.00046586990356445	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
341	0.0013	0.0012640953063965	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
342	0.0011	0.0010888576507568	SELECT * FROM products WHERE id = '4041'
343	0.0009	0.00092196464538574	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
344	0.0013	0.0013270378112793	SELECT * FROM product_image_select WHERE product_id = '4041'
345	0.0007	0.00070595741271973	SELECT * FROM productcustomimages WHERE product_id = '4041'
346	0.0028	0.0028271675109863	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
347	0.0009	0.00092196464538574	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
348	0.0008	0.00077199935913086	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
349	0.0010	0.0010101795196533	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
350	0.0011	0.0010550022125244	SELECT * FROM products WHERE id = '4312'
351	0.0008	0.00077700614929199	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
352	0.0012	0.0011918544769287	SELECT * FROM product_image_select WHERE product_id = '4312'
353	0.0007	0.00066494941711426	SELECT * FROM productcustomimages WHERE product_id = '4312'
354	0.0022	0.0022461414337158	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
355	0.0008	0.00082802772521973	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
356	0.0007	0.00067687034606934	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
357	0.0008	0.0007789134979248	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
358	0.0009	0.00093197822570801	SELECT * FROM products WHERE id = '777'
359	0.0009	0.0008699893951416	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
360	0.0011	0.0011279582977295	SELECT * FROM product_image_select WHERE product_id = '777'
361	0.0006	0.00059604644775391	SELECT * FROM productcustomimages WHERE product_id = '777'
362	0.0018	0.0018131732940674	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
363	0.0007	0.00073385238647461	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
364	0.0006	0.00057196617126465	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
365	0.0007	0.00070095062255859	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
366	0.0009	0.0008540153503418	SELECT * FROM products WHERE id = '3881'
367	0.0009	0.00092697143554688	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
368	0.0009	0.0009160041809082	SELECT * FROM product_image_select WHERE product_id = '3881'
369	0.0005	0.00054788589477539	SELECT * FROM productcustomimages WHERE product_id = '3881'
370	0.0022	0.0021538734436035	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
371	0.0007	0.0006868839263916	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
372	0.0005	0.00050497055053711	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
373	0.0005	0.00052595138549805	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
374	0.0007	0.00072479248046875	SELECT * FROM products WHERE id = '4213'
375	0.0009	0.00088596343994141	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
376	0.0008	0.00076198577880859	SELECT * FROM product_image_select WHERE product_id = '4213'
377	0.0005	0.00046515464782715	SELECT * FROM productcustomimages WHERE product_id = '4213'
378	0.0016	0.0016098022460938	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
379	0.0006	0.0006251335144043	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
380	0.0005	0.00048112869262695	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
381	0.0005	0.00051212310791016	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
382	0.0025	0.0025320053100586	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
383	0.0010	0.00097203254699707	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
384	0.0031	0.0031170845031738	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
385	0.0020	0.0019829273223877	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
386	0.0008	0.00079798698425293	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
387	0.0013	0.0013320446014404	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
388	0.0015	0.0015392303466797	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 3.0807847976685 seconds

Query Debug - 388 Database Queries. Total time 0.9400 seconds