Search Results for "4"

Nittoh Sangyo Co., Ltd. La boîte à thé J...

only €20,00

View

Add to Cart

Coffret Rooibos Saveurs d'un Soir - La R...

only €12,80

View

Add to Cart

Promotion -10%! SoBuy® FRG83-N Grande Bo...

only €34,95

View

Add to Cart

N° 1419: Thé vert bio "Bancha japon...

only €25,28

View

Add to Cart

Nittoh Sangyo Co., Ltd. La boîte à thé J...

only €20,00

View

Add to Cart

LUNA VOW Lune Vow Thé Céramique Japonais...

only €27,51

View

Add to Cart

A0127 Boîte à thé Boîte scellée Boîte à ...

View to See Price

View

Add to Cart

Shuzhen,Boîtes à thé en Bois Boîtes à th...

only €28,31

View

Add to Cart

Lipton Thé Vert Marrakech Mint 10 Capsul...

View to See Price

View

Add to Cart

Boîte à thé avec couvercle coffret Tea B...

View to See Price

View

Add to Cart

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

View to See Price

View

Add to Cart

Elephant Bio Infusion Coffret decouverte...

View to See Price

View

Add to Cart

Creano 264 Boîte Déco Lot de 6 fleurs de...

only €17,90

View

Add to Cart

Yamako- Boîte à thé est Ikarasa. L, Quat...

only €34,90

View

Add to Cart

Vivaraise Tapis de Bain Etia

from €28,90

View

Add to Cart

'ToCi Boîte à thé "Tea – Boîte à th...

only €22,73

View

Add to Cart

Vivaraise Serviette de Toilette Bora Roo...

only €12,90

View

Add to Cart

Argent uni à thé/cuisine Boîte de rangem...

only €20,69

View

Add to Cart

37 to 54 of 336 products

Product Filters (more)

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.7296440601349	382	1.2349	0

No Amazon API Requests Made.

App Debug - Total Time 1.7296440601349 seconds

Number	Time From Start	Name	Description
1	0.47940015792847	Initialise	Initialise FSB Function
2	0.4835000038147	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.53427004814148	Start of getCategoryListByGroup Function	Before first category groups query
4	0.53515815734863	After initial query	Before first category groups query
5	0.53515911102295	Get Category List for Group	Before the call to getCategoryList function
6	0.5351619720459	Start of GetCategoryList function	Start of the function
7	0.53516411781311	Before getting categories	Query to get specific category list
8	0.53593301773071	After getting categories	Query to get specific category list
9	0.53593516349792	Before getting category custom	Before call to function getCategoryCustom
10	0.55109214782715	After getting category custom	After call to function getCategoryCustom
11	0.55109405517578	Before getting category custom	Before call to function getCategoryCustom
12	0.55951118469238	After getting category custom	After call to function getCategoryCustom
13	0.5595121383667	Before getting category custom	Before call to function getCategoryCustom
14	0.56397795677185	After getting category custom	After call to function getCategoryCustom
15	0.56398010253906	Before getting category custom	Before call to function getCategoryCustom
16	0.56710910797119	After getting category custom	After call to function getCategoryCustom
17	0.56711006164551	Before getting category custom	Before call to function getCategoryCustom
18	0.57051515579224	After getting category custom	After call to function getCategoryCustom
19	0.57051706314087	Before getting category custom	Before call to function getCategoryCustom
20	0.57389616966248	After getting category custom	After call to function getCategoryCustom
21	0.57389807701111	End of GetCategoryList function	End of the function
22	0.57390403747559	Get Category List for Group	Before the call to getCategoryList function
23	0.5739049911499	Start of GetCategoryList function	Start of the function
24	0.5739061832428	Before getting categories	Query to get specific category list
25	0.57424211502075	End of getCategoryListByGroup Function	Before return()
26	1.4940371513367	App Controller End	End of the App controller (called before the controller of every page)
27	1.6683850288391	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.6693871021271	Before Get Options	Before the call to getOptions in the tpl class
29	1.7072269916534	After Get Options	After the call to getOptions in the tpl class
30	1.7072601318359	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.7296359539032	Finalizing debug	Before the debug is output to the page.
32	1.7296431064606	End of App	This is the end of the app logging, final timestamp

Query Debug - 382 Database Queries. Total time 1.2349 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.68\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751027170'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2025-06-27 12:26:10' 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('216.73.216.68') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.68') <= 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(), '216.73.216.68'
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 = '3828'
SELECT * FROM productimages WHERE product_id = '3828' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3828'
SELECT * FROM productcustomimages WHERE product_id = '3828'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3828' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3828' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3828' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1093'
SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1093'
SELECT * FROM productcustomimages WHERE product_id = '1093'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1093' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1354'
SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1354'
SELECT * FROM productcustomimages WHERE product_id = '1354'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1354' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4910'
SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4910'
SELECT * FROM productcustomimages WHERE product_id = '4910'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4910' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3826'
SELECT * FROM productimages WHERE product_id = '3826' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3826'
SELECT * FROM productcustomimages WHERE product_id = '3826'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3826' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3826' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3826' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3826
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3826'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '3826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3555'
SELECT * FROM productimages WHERE product_id = '3555' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3555'
SELECT * FROM productcustomimages WHERE product_id = '3555'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3555' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3555' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3555' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3555' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3693'
SELECT * FROM productimages WHERE product_id = '3693' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3693' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '3693'
SELECT * FROM productcustomimages WHERE product_id = '3693'
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 = '3693'
                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     = '3693'
                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 = 3693
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3693' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 3693
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '3693'
                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 = '3693'
                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     = '3693'
                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 = 3693
SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '3693'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '3853'
SELECT * FROM productimages WHERE product_id = '3853' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3853'
SELECT * FROM productcustomimages WHERE product_id = '3853'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3853' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3853' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3853' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1094'
SELECT * FROM productimages WHERE product_id = '1094' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1094'
SELECT * FROM productcustomimages WHERE product_id = '1094'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1094' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1094' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1094' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1094
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1094'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '1094' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1536'
SELECT * FROM productimages WHERE product_id = '1536' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1536' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '1536'
SELECT * FROM productcustomimages WHERE product_id = '1536'
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 = '1536'
                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     = '1536'
                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 = 1536
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1536' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1536' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1536' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 1536
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '1536'
                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 = '1536'
                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     = '1536'
                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 = 1536
SELECT value FROM productattributes WHERE product_id = '1536' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '1536'
SELECT * FROM products WHERE id = '4242'
SELECT * FROM productimages WHERE product_id = '4242' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4242'
SELECT * FROM productcustomimages WHERE product_id = '4242'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4242' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4242' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4242' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4242
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4242'
                AND name = 'ListPriceAmount'
SELECT value FROM productattributes WHERE product_id = '4242' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4914'
SELECT * FROM productimages WHERE product_id = '4914' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4914' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4914'
SELECT * FROM productcustomimages WHERE product_id = '4914'
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 = '4914'
                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     = '4914'
                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 = 4914
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4914' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4914' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4914' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4914
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4914'
                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 = '4914'
                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     = '4914'
                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 = 4914
SELECT value FROM productattributes WHERE product_id = '4914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE parent_id = '4914'
SELECT * FROM products WHERE id = '1426'
SELECT * FROM productimages WHERE product_id = '1426' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1426'
SELECT * FROM productcustomimages WHERE product_id = '1426'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1426' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1426' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1426' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1426' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3022'
SELECT * FROM productimages WHERE product_id = '3022' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3022'
SELECT * FROM productcustomimages WHERE product_id = '3022'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3022' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3022' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3022' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3022' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4556'
SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4556' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '4556'
SELECT * FROM productcustomimages WHERE product_id = '4556'
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 = '4556'
                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     = '4556'
                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 = 4556
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4556' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 4556
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '4556'
                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 = '4556'
                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     = '4556'
                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 = 4556
SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4556'
                  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     = '4556'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM products WHERE id = '1458'
SELECT * FROM productimages WHERE product_id = '1458' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1458'
SELECT * FROM productcustomimages WHERE product_id = '1458'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1458' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1458' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1458' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1458' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4256'
SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4256'
SELECT * FROM productcustomimages WHERE product_id = '4256'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4256' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '1349'
SELECT * FROM productimages WHERE product_id = '1349' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1349'
SELECT * FROM productcustomimages WHERE product_id = '1349'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1349' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1349' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1349' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1349' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3828' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1093' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1354' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4910' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3826' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3555' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3693' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3853' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1094' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1536' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4242' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4914' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1426' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3022' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4556' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1458' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4256' ORDER BY timestamp DESC
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1349' 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.0015	0.0014748573303223	SELECT parameter, value FROM parameters
2	0.0056	0.0055527687072754	SELECT * FROM `bad_bots`
3	0.0004	0.00037789344787598	SET time_zone = 'Europe/London'
4	0.0013	0.0013461112976074	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0013	0.001338005065918	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.68\";}'
6	0.0013	0.0013489723205566	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751027170'
7	0.0024	0.0023870468139648	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0005	0.00052404403686523	UPDATE autorun SET lastrun = '2025-06-27 12:26:10' WHERE id = '16'
9	0.0007	0.00069713592529297	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0022	0.0022017955780029	SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
11	0.0005	0.00054502487182617	SELECT * FROM pages WHERE id = 52
12	0.0037	0.0036659240722656	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0461	0.046104907989502	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0005	0.00049400329589844	SELECT * FROM pages WHERE pagename = 'search'
15	0.0009	0.00087809562683105	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0008	0.00075387954711914	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0057	0.0056800842285156	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.0010	0.0010089874267578	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.0007	0.00066089630126953	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0003	0.00031614303588867	SELECT id FROM categories WHERE parent_id = '26'
21	0.0048	0.0047509670257568	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.0009	0.00085687637329102	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.0008	0.00076508522033691	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.0007	0.0007319450378418	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0003	0.00031089782714844	SELECT * FROM categorygroups WHERE id = '1'
26	0.0031	0.0031092166900635	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.0003	0.00034499168395996	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.0003	0.00027179718017578	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0003	0.00028085708618164	SELECT id FROM categories WHERE parent_id = '27'
30	0.0031	0.0030560493469238	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.0004	0.00040292739868164	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.0004	0.0003509521484375	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.0003	0.00030112266540527	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0003	0.0002751350402832	SELECT * FROM categorygroups WHERE id = '1'
35	0.0011	0.0010879039764404	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.0003	0.0003199577331543	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.0003	0.00025796890258789	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0003	0.0002748966217041	SELECT id FROM categories WHERE parent_id = '28'
39	0.0012	0.0011889934539795	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.0004	0.00036191940307617	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.0003	0.00034403800964355	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.0003	0.00031208992004395	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0003	0.00028800964355469	SELECT * FROM categorygroups WHERE id = '1'
44	0.0004	0.00040197372436523	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.0003	0.0003058910369873	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.0003	0.00025582313537598	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0003	0.00027203559875488	SELECT id FROM categories WHERE parent_id = '29'
48	0.0004	0.00043797492980957	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.0003	0.00034618377685547	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.0004	0.00037288665771484	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (29) AND c.prod_type = 'custom' AND cp.hide = 0
51	0.0004	0.00036501884460449	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0003	0.00032877922058105	SELECT * FROM categorygroups WHERE id = '1'
53	0.0004	0.00042414665222168	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.0003	0.0003361701965332	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
55	0.0003	0.00029206275939941	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0003	0.00032186508178711	SELECT id FROM categories WHERE parent_id = '30'
57	0.0005	0.00051403045654297	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
58	0.0004	0.00037288665771484	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.0004	0.00038886070251465	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
60	0.0004	0.00037097930908203	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0003	0.00033378601074219	SELECT * FROM categorygroups WHERE id = '1'
62	0.0004	0.0004429817199707	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.0003	0.00033998489379883	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
64	0.0003	0.00031399726867676	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0003	0.00031304359436035	SELECT id FROM categories WHERE parent_id = '31'
66	0.0005	0.00050210952758789	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.0003	0.00032186508178711	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.0004	0.00042295455932617	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (31) AND c.prod_type = 'custom' AND cp.hide = 0
69	0.0004	0.00037097930908203	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0003	0.00030016899108887	SELECT * FROM categorygroups WHERE id = '1'
71	0.0003	0.00033187866210938	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0022	0.0021529197692871	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0010	0.00098705291748047	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0004	0.00042414665222168	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.0007	0.00074291229248047	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0010	0.0010471343994141	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0007	0.00067806243896484	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.9081	0.90806603431702	SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.68') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.68') <= INET_ATON(ip_end)
79	0.0028	0.0028040409088135	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0013	0.0012710094451904	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0006	0.00060296058654785	SELECT * FROM pages WHERE pagename = 'search'
82	0.0116	0.011620998382568	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
83	0.0031	0.0030710697174072	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
84	0.0019	0.0018579959869385	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
85	0.0104	0.010425806045532	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
86	0.0024	0.0024480819702148	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
87	0.0005	0.00054097175598145	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
88	0.0013	0.001262903213501	INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT '4', NOW(), '216.73.216.68'
89	0.0009	0.00093817710876465	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.00046610832214355	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.0066	0.0066399574279785	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.00051188468933105	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.0003	0.00032806396484375	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.0003	0.00033998489379883	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.0038	0.0038058757781982	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.0003	0.00030708312988281	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.0002	0.0002131462097168	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.0003	0.00031399726867676	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.0003	0.00030708312988281	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.0032	0.003154993057251	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.0002	0.00023508071899414	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.0002	0.00021004676818848	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.0003	0.00030303001403809	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.0038	0.0037658214569092	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.0002	0.00023102760314941	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.0002	0.00023794174194336	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.0003	0.00029087066650391	SELECT * FROM products WHERE id = '3828'
108	0.0010	0.00097203254699707	SELECT * FROM productimages WHERE product_id = '3828' ORDER BY sortorder ASC
109	0.0009	0.00090789794921875	SELECT * FROM product_image_select WHERE product_id = '3828'
110	0.0006	0.00060296058654785	SELECT * FROM productcustomimages WHERE product_id = '3828'
111	0.0011	0.0010700225830078	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3828' AND a.name = n.originalname
112	0.0007	0.0006859302520752	SELECT * FROM productoffers WHERE product_id = '3828' AND merchantid = 'A1X6FK5RDHNB96'
113	0.0003	0.00029802322387695	SELECT * FROM productoffers WHERE product_id = '3828' AND price > 0 ORDER BY price ASC LIMIT 1
114	0.0003	0.00034999847412109	SELECT value FROM productattributes WHERE product_id = '3828' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
115	0.0003	0.00033807754516602	SELECT * FROM products WHERE id = '1093'
116	0.0003	0.00033688545227051	SELECT * FROM productimages WHERE product_id = '1093' ORDER BY sortorder ASC
117	0.0004	0.00043606758117676	SELECT * FROM product_image_select WHERE product_id = '1093'
118	0.0003	0.00026702880859375	SELECT * FROM productcustomimages WHERE product_id = '1093'
119	0.0006	0.00056600570678711	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1093' AND a.name = n.originalname
120	0.0003	0.00031208992004395	SELECT * FROM productoffers WHERE product_id = '1093' AND merchantid = 'A1X6FK5RDHNB96'
121	0.0003	0.0002591609954834	SELECT * FROM productoffers WHERE product_id = '1093' AND price > 0 ORDER BY price ASC LIMIT 1
122	0.0003	0.00026607513427734	SELECT value FROM productattributes WHERE product_id = '1093' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
123	0.0003	0.00032591819763184	SELECT * FROM products WHERE id = '1354'
124	0.0004	0.0003819465637207	SELECT * FROM productimages WHERE product_id = '1354' ORDER BY sortorder ASC
125	0.0005	0.00046014785766602	SELECT * FROM product_image_select WHERE product_id = '1354'
126	0.0006	0.00060081481933594	SELECT * FROM productcustomimages WHERE product_id = '1354'
127	0.0007	0.00066804885864258	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1354' AND a.name = n.originalname
128	0.0003	0.0003359317779541	SELECT * FROM productoffers WHERE product_id = '1354' AND merchantid = 'A1X6FK5RDHNB96'
129	0.0003	0.00026297569274902	SELECT * FROM productoffers WHERE product_id = '1354' AND price > 0 ORDER BY price ASC LIMIT 1
130	0.0003	0.00025796890258789	SELECT value FROM productattributes WHERE product_id = '1354' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131	0.0003	0.00032520294189453	SELECT * FROM products WHERE id = '4910'
132	0.0003	0.00031805038452148	SELECT * FROM productimages WHERE product_id = '4910' ORDER BY sortorder ASC
133	0.0014	0.0013570785522461	SELECT * FROM product_image_select WHERE product_id = '4910'
134	0.0003	0.00029611587524414	SELECT * FROM productcustomimages WHERE product_id = '4910'
135	0.0007	0.00068402290344238	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4910' AND a.name = n.originalname
136	0.0003	0.00029993057250977	SELECT * FROM productoffers WHERE product_id = '4910' AND merchantid = 'A1X6FK5RDHNB96'
137	0.0003	0.00026178359985352	SELECT * FROM productoffers WHERE product_id = '4910' AND price > 0 ORDER BY price ASC LIMIT 1
138	0.0003	0.00026512145996094	SELECT value FROM productattributes WHERE product_id = '4910' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
139	0.0009	0.00094103813171387	SELECT * FROM products WHERE id = '3826'
140	0.0006	0.00057506561279297	SELECT * FROM productimages WHERE product_id = '3826' ORDER BY sortorder ASC
141	0.0011	0.0010840892791748	SELECT * FROM product_image_select WHERE product_id = '3826'
142	0.0005	0.00050616264343262	SELECT * FROM productcustomimages WHERE product_id = '3826'
143	0.0015	0.0014660358428955	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3826' AND a.name = n.originalname
144	0.0003	0.00032496452331543	SELECT * FROM productoffers WHERE product_id = '3826' AND merchantid = 'A1X6FK5RDHNB96'
145	0.0003	0.00027108192443848	SELECT * FROM productoffers WHERE product_id = '3826' AND price > 0 ORDER BY price ASC LIMIT 1
146	0.0006	0.00055408477783203	SELECT * FROM productoffers WHERE product_id = 3826 ORDER BY price ASC LIMIT 1
147	0.0003	0.0002589225769043	SELECT value FROM productattributes WHERE product_id = '3826' AND name = 'ListPriceAmount'
148	0.0010	0.0010409355163574	SELECT value FROM productattributes WHERE product_id = '3826' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
149	0.0007	0.00071215629577637	SELECT * FROM products WHERE id = '3555'
150	0.0006	0.00060391426086426	SELECT * FROM productimages WHERE product_id = '3555' ORDER BY sortorder ASC
151	0.0010	0.00095510482788086	SELECT * FROM product_image_select WHERE product_id = '3555'
152	0.0005	0.00051307678222656	SELECT * FROM productcustomimages WHERE product_id = '3555'
153	0.0014	0.0014371871948242	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3555' AND a.name = n.originalname
154	0.0006	0.00059413909912109	SELECT * FROM productoffers WHERE product_id = '3555' AND merchantid = 'A1X6FK5RDHNB96'
155	0.0005	0.00047397613525391	SELECT * FROM productoffers WHERE product_id = '3555' AND price > 0 ORDER BY price ASC LIMIT 1
156	0.0005	0.00051784515380859	SELECT value FROM productattributes WHERE product_id = '3555' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
157	0.0007	0.00069093704223633	SELECT * FROM products WHERE id = '3693'
158	0.0006	0.0006110668182373	SELECT * FROM productimages WHERE product_id = '3693' ORDER BY sortorder ASC
159	0.0007	0.00067591667175293	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '3693' AND p.id = pi.product_id ORDER BY pi.sortorder
160	0.0009	0.0009009838104248	SELECT * FROM product_image_select WHERE product_id = '3693'
161	0.0005	0.00048184394836426	SELECT * FROM productcustomimages WHERE product_id = '3693'
162	0.0007	0.00065803527832031	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 = '3693' GROUP BY o.product_id
163	0.0027	0.0027368068695068	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 = '3693' GROUP BY n.displayname ORDER BY n.displayname DESC
164	0.0006	0.00063705444335938	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3693
165	0.0016	0.0015888214111328	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3693' AND a.name = n.originalname
166	0.0004	0.00043010711669922	SELECT * FROM productoffers WHERE product_id = '3693' AND merchantid = 'A1X6FK5RDHNB96'
167	0.0004	0.00043010711669922	SELECT * FROM productoffers WHERE product_id = '3693' AND price > 0 ORDER BY price ASC LIMIT 1
168	0.0004	0.00038909912109375	SELECT * FROM productoffers WHERE product_id = 3693 ORDER BY price ASC LIMIT 1
169	0.0005	0.00050711631774902	SELECT value FROM productattributes WHERE product_id = '3693' AND name = 'ListPriceAmount'
170	0.0005	0.00048995018005371	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 = '3693' GROUP BY o.product_id
171	0.0009	0.00086593627929688	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 = '3693' GROUP BY n.displayname ORDER BY n.displayname DESC
172	0.0005	0.00051617622375488	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 3693
173	0.0007	0.00067305564880371	SELECT value FROM productattributes WHERE product_id = '3693' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
174	0.0008	0.0007779598236084	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '3693' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
175	0.0005	0.0004580020904541	SELECT * FROM products WHERE id = '3853'
176	0.0006	0.00060701370239258	SELECT * FROM productimages WHERE product_id = '3853' ORDER BY sortorder ASC
177	0.0009	0.00092196464538574	SELECT * FROM product_image_select WHERE product_id = '3853'
178	0.0005	0.00051617622375488	SELECT * FROM productcustomimages WHERE product_id = '3853'
179	0.0011	0.0011341571807861	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3853' AND a.name = n.originalname
180	0.0006	0.00058102607727051	SELECT * FROM productoffers WHERE product_id = '3853' AND merchantid = 'A1X6FK5RDHNB96'
181	0.0005	0.00046706199645996	SELECT * FROM productoffers WHERE product_id = '3853' AND price > 0 ORDER BY price ASC LIMIT 1
182	0.0005	0.00049185752868652	SELECT value FROM productattributes WHERE product_id = '3853' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
183	0.0006	0.00060200691223145	SELECT * FROM products WHERE id = '1094'
184	0.0007	0.00067806243896484	SELECT * FROM productimages WHERE product_id = '1094' ORDER BY sortorder ASC
185	0.0009	0.00091695785522461	SELECT * FROM product_image_select WHERE product_id = '1094'
186	0.0005	0.00048089027404785	SELECT * FROM productcustomimages WHERE product_id = '1094'
187	0.0013	0.0012850761413574	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1094' AND a.name = n.originalname
188	0.0006	0.00057005882263184	SELECT * FROM productoffers WHERE product_id = '1094' AND merchantid = 'A1X6FK5RDHNB96'
189	0.0005	0.00047898292541504	SELECT * FROM productoffers WHERE product_id = '1094' AND price > 0 ORDER BY price ASC LIMIT 1
190	0.0004	0.00042986869812012	SELECT * FROM productoffers WHERE product_id = 1094 ORDER BY price ASC LIMIT 1
191	0.0004	0.0004429817199707	SELECT value FROM productattributes WHERE product_id = '1094' AND name = 'ListPriceAmount'
192	0.0005	0.00048208236694336	SELECT value FROM productattributes WHERE product_id = '1094' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
193	0.0006	0.00060009956359863	SELECT * FROM products WHERE id = '1536'
194	0.0006	0.00057005882263184	SELECT * FROM productimages WHERE product_id = '1536' ORDER BY sortorder ASC
195	0.0005	0.00047397613525391	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '1536' AND p.id = pi.product_id ORDER BY pi.sortorder
196	0.0010	0.00096893310546875	SELECT * FROM product_image_select WHERE product_id = '1536'
197	0.0005	0.00048995018005371	SELECT * FROM productcustomimages WHERE product_id = '1536'
198	0.0006	0.00062799453735352	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 = '1536' GROUP BY o.product_id
199	0.0007	0.00072121620178223	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 = '1536' GROUP BY n.displayname ORDER BY n.displayname DESC
200	0.0004	0.00042295455932617	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1536
201	0.0011	0.0011169910430908	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1536' AND a.name = n.originalname
202	0.0006	0.00064706802368164	SELECT * FROM productoffers WHERE product_id = '1536' AND merchantid = 'A1X6FK5RDHNB96'
203	0.0005	0.00045013427734375	SELECT * FROM productoffers WHERE product_id = '1536' AND price > 0 ORDER BY price ASC LIMIT 1
204	0.0004	0.0003969669342041	SELECT * FROM productoffers WHERE product_id = 1536 ORDER BY price ASC LIMIT 1
205	0.0004	0.00044989585876465	SELECT value FROM productattributes WHERE product_id = '1536' AND name = 'ListPriceAmount'
206	0.0005	0.00049400329589844	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 = '1536' GROUP BY o.product_id
207	0.0008	0.00076103210449219	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 = '1536' GROUP BY n.displayname ORDER BY n.displayname DESC
208	0.0004	0.00041985511779785	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 1536
209	0.0007	0.0007319450378418	SELECT value FROM productattributes WHERE product_id = '1536' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
210	0.0004	0.00043702125549316	SELECT * FROM products WHERE parent_id = '1536'
211	0.0005	0.00047206878662109	SELECT * FROM products WHERE id = '4242'
212	0.0006	0.00059914588928223	SELECT * FROM productimages WHERE product_id = '4242' ORDER BY sortorder ASC
213	0.0010	0.00095891952514648	SELECT * FROM product_image_select WHERE product_id = '4242'
214	0.0005	0.0004889965057373	SELECT * FROM productcustomimages WHERE product_id = '4242'
215	0.0012	0.0012099742889404	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4242' AND a.name = n.originalname
216	0.0006	0.00062799453735352	SELECT * FROM productoffers WHERE product_id = '4242' AND merchantid = 'A1X6FK5RDHNB96'
217	0.0004	0.00043416023254395	SELECT * FROM productoffers WHERE product_id = '4242' AND price > 0 ORDER BY price ASC LIMIT 1
218	0.0004	0.00039410591125488	SELECT * FROM productoffers WHERE product_id = 4242 ORDER BY price ASC LIMIT 1
219	0.0005	0.00046110153198242	SELECT value FROM productattributes WHERE product_id = '4242' AND name = 'ListPriceAmount'
220	0.0007	0.00070905685424805	SELECT value FROM productattributes WHERE product_id = '4242' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
221	0.0006	0.00061607360839844	SELECT * FROM products WHERE id = '4914'
222	0.0008	0.0007939338684082	SELECT * FROM productimages WHERE product_id = '4914' ORDER BY sortorder ASC
223	0.0006	0.00055718421936035	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4914' AND p.id = pi.product_id ORDER BY pi.sortorder
224	0.0008	0.00075602531433105	SELECT * FROM product_image_select WHERE product_id = '4914'
225	0.0004	0.00041294097900391	SELECT * FROM productcustomimages WHERE product_id = '4914'
226	0.0005	0.00051689147949219	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 = '4914' GROUP BY o.product_id
227	0.0006	0.00060796737670898	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 = '4914' GROUP BY n.displayname ORDER BY n.displayname DESC
228	0.0004	0.00036406517028809	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4914
229	0.0014	0.0014421939849854	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4914' AND a.name = n.originalname
230	0.0004	0.00037193298339844	SELECT * FROM productoffers WHERE product_id = '4914' AND merchantid = 'A1X6FK5RDHNB96'
231	0.0004	0.00037598609924316	SELECT * FROM productoffers WHERE product_id = '4914' AND price > 0 ORDER BY price ASC LIMIT 1
232	0.0003	0.00034284591674805	SELECT * FROM productoffers WHERE product_id = 4914 ORDER BY price ASC LIMIT 1
233	0.0004	0.00037789344787598	SELECT value FROM productattributes WHERE product_id = '4914' AND name = 'ListPriceAmount'
234	0.0004	0.00039100646972656	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 = '4914' GROUP BY o.product_id
235	0.0007	0.0007169246673584	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 = '4914' GROUP BY n.displayname ORDER BY n.displayname DESC
236	0.0004	0.0003969669342041	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4914
237	0.0006	0.0005800724029541	SELECT value FROM productattributes WHERE product_id = '4914' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
238	0.0005	0.00048398971557617	SELECT * FROM products WHERE parent_id = '4914'
239	0.0005	0.00045299530029297	SELECT * FROM products WHERE id = '1426'
240	0.0007	0.00065398216247559	SELECT * FROM productimages WHERE product_id = '1426' ORDER BY sortorder ASC
241	0.0008	0.00081491470336914	SELECT * FROM product_image_select WHERE product_id = '1426'
242	0.0004	0.00042414665222168	SELECT * FROM productcustomimages WHERE product_id = '1426'
243	0.0017	0.0017249584197998	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1426' AND a.name = n.originalname
244	0.0007	0.00069379806518555	SELECT * FROM productoffers WHERE product_id = '1426' AND merchantid = 'A1X6FK5RDHNB96'
245	0.0005	0.00045680999755859	SELECT * FROM productoffers WHERE product_id = '1426' AND price > 0 ORDER BY price ASC LIMIT 1
246	0.0006	0.00057411193847656	SELECT value FROM productattributes WHERE product_id = '1426' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
247	0.0006	0.00061392784118652	SELECT * FROM products WHERE id = '3022'
248	0.0006	0.00059199333190918	SELECT * FROM productimages WHERE product_id = '3022' ORDER BY sortorder ASC
249	0.0008	0.0007941722869873	SELECT * FROM product_image_select WHERE product_id = '3022'
250	0.0005	0.0004889965057373	SELECT * FROM productcustomimages WHERE product_id = '3022'
251	0.0009	0.00093793869018555	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3022' AND a.name = n.originalname
252	0.0005	0.0005488395690918	SELECT * FROM productoffers WHERE product_id = '3022' AND merchantid = 'A1X6FK5RDHNB96'
253	0.0004	0.00037622451782227	SELECT * FROM productoffers WHERE product_id = '3022' AND price > 0 ORDER BY price ASC LIMIT 1
254	0.0005	0.00048613548278809	SELECT value FROM productattributes WHERE product_id = '3022' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
255	0.0005	0.0005030632019043	SELECT * FROM products WHERE id = '4556'
256	0.0005	0.00054192543029785	SELECT * FROM productimages WHERE product_id = '4556' ORDER BY sortorder ASC
257	0.0007	0.0006718635559082	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4556' AND p.id = pi.product_id ORDER BY pi.sortorder
258	0.0007	0.00074982643127441	SELECT * FROM product_image_select WHERE product_id = '4556'
259	0.0004	0.00037193298339844	SELECT * FROM productcustomimages WHERE product_id = '4556'
260	0.0006	0.00061798095703125	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 = '4556' GROUP BY o.product_id
261	0.0011	0.0010578632354736	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 = '4556' GROUP BY n.displayname ORDER BY n.displayname DESC
262	0.0007	0.00065803527832031	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
263	0.0012	0.001168966293335	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4556' AND a.name = n.originalname
264	0.0003	0.00032711029052734	SELECT * FROM productoffers WHERE product_id = '4556' AND merchantid = 'A1X6FK5RDHNB96'
265	0.0003	0.0003349781036377	SELECT * FROM productoffers WHERE product_id = '4556' AND price > 0 ORDER BY price ASC LIMIT 1
266	0.0003	0.00030517578125	SELECT * FROM productoffers WHERE product_id = 4556 ORDER BY price ASC LIMIT 1
267	0.0003	0.00034689903259277	SELECT value FROM productattributes WHERE product_id = '4556' AND name = 'ListPriceAmount'
268	0.0005	0.00053906440734863	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 = '4556' GROUP BY o.product_id
269	0.0009	0.00090909004211426	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 = '4556' GROUP BY n.displayname ORDER BY n.displayname DESC
270	0.0003	0.00033402442932129	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4556
271	0.0004	0.00035691261291504	SELECT value FROM productattributes WHERE product_id = '4556' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
272	0.0005	0.00048995018005371	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4556' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
273	0.0004	0.00044393539428711	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '4556' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
274	0.0003	0.00027298927307129	SELECT * FROM products WHERE id = '1458'
275	0.0004	0.00038790702819824	SELECT * FROM productimages WHERE product_id = '1458' ORDER BY sortorder ASC
276	0.0005	0.0004889965057373	SELECT * FROM product_image_select WHERE product_id = '1458'
277	0.0003	0.00030303001403809	SELECT * FROM productcustomimages WHERE product_id = '1458'
278	0.0007	0.00069403648376465	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1458' AND a.name = n.originalname
279	0.0004	0.00036787986755371	SELECT * FROM productoffers WHERE product_id = '1458' AND merchantid = 'A1X6FK5RDHNB96'
280	0.0003	0.00027298927307129	SELECT * FROM productoffers WHERE product_id = '1458' AND price > 0 ORDER BY price ASC LIMIT 1
281	0.0003	0.0003049373626709	SELECT value FROM productattributes WHERE product_id = '1458' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
282	0.0003	0.00032496452331543	SELECT * FROM products WHERE id = '4256'
283	0.0003	0.00034594535827637	SELECT * FROM productimages WHERE product_id = '4256' ORDER BY sortorder ASC
284	0.0005	0.00045895576477051	SELECT * FROM product_image_select WHERE product_id = '4256'
285	0.0003	0.00028681755065918	SELECT * FROM productcustomimages WHERE product_id = '4256'
286	0.0008	0.0008080005645752	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4256' AND a.name = n.originalname
287	0.0003	0.00032305717468262	SELECT * FROM productoffers WHERE product_id = '4256' AND merchantid = 'A1X6FK5RDHNB96'
288	0.0003	0.00027704238891602	SELECT * FROM productoffers WHERE product_id = '4256' AND price > 0 ORDER BY price ASC LIMIT 1
289	0.0003	0.00033092498779297	SELECT value FROM productattributes WHERE product_id = '4256' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
290	0.0004	0.00035786628723145	SELECT * FROM products WHERE id = '1349'
291	0.0004	0.00036287307739258	SELECT * FROM productimages WHERE product_id = '1349' ORDER BY sortorder ASC
292	0.0005	0.00045204162597656	SELECT * FROM product_image_select WHERE product_id = '1349'
293	0.0003	0.00028514862060547	SELECT * FROM productcustomimages WHERE product_id = '1349'
294	0.0006	0.00058889389038086	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1349' AND a.name = n.originalname
295	0.0003	0.00031685829162598	SELECT * FROM productoffers WHERE product_id = '1349' AND merchantid = 'A1X6FK5RDHNB96'
296	0.0003	0.00027585029602051	SELECT * FROM productoffers WHERE product_id = '1349' AND price > 0 ORDER BY price ASC LIMIT 1
297	0.0003	0.00033187866210938	SELECT value FROM productattributes WHERE product_id = '1349' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
298	0.0009	0.00092005729675293	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3828' ORDER BY timestamp DESC
299	0.0002	0.00023603439331055	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1093' ORDER BY timestamp DESC
300	0.0002	0.00024104118347168	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1354' ORDER BY timestamp DESC
301	0.0002	0.00021505355834961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4910' ORDER BY timestamp DESC
302	0.0002	0.00021505355834961	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3826' ORDER BY timestamp DESC
303	0.0002	0.00024294853210449	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3555' ORDER BY timestamp DESC
304	0.0002	0.00020408630371094	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3693' ORDER BY timestamp DESC
305	0.0002	0.00020098686218262	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3853' ORDER BY timestamp DESC
306	0.0002	0.00019502639770508	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1094' ORDER BY timestamp DESC
307	0.0003	0.00025796890258789	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1536' ORDER BY timestamp DESC
308	0.0002	0.00020313262939453	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4242' ORDER BY timestamp DESC
309	0.0002	0.00020289421081543	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4914' ORDER BY timestamp DESC
310	0.0002	0.0001981258392334	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1426' ORDER BY timestamp DESC
311	0.0002	0.00020313262939453	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '3022' ORDER BY timestamp DESC
312	0.0002	0.00020718574523926	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4556' ORDER BY timestamp DESC
313	0.0002	0.0001990795135498	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1458' ORDER BY timestamp DESC
314	0.0002	0.00020694732666016	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4256' ORDER BY timestamp DESC
315	0.0002	0.00020003318786621	SELECT * FROM customerreviews WHERE approved = 1 AND productid = '1349' ORDER BY timestamp DESC
316	0.0008	0.00075697898864746	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
317	0.0007	0.00069880485534668	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
318	0.0003	0.00026988983154297	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
319	0.0119	0.011880159378052	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
320	0.0010	0.00097990036010742	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
321	0.0003	0.00034904479980469	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
322	0.0003	0.00034284591674805	SELECT * FROM products WHERE id = 1626
323	0.0003	0.00025701522827148	SELECT * FROM products WHERE id = 4041
324	0.0003	0.00027608871459961	SELECT * FROM products WHERE id = 4312
325	0.0003	0.00025200843811035	SELECT * FROM products WHERE id = 777
326	0.0002	0.0002439022064209	SELECT * FROM products WHERE id = 3881
327	0.0003	0.00027298927307129	SELECT * FROM products WHERE id = 4213
328	0.0002	0.00024008750915527	SELECT * FROM products WHERE id = '1626'
329	0.0003	0.0003058910369873	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
330	0.0004	0.00043797492980957	SELECT * FROM product_image_select WHERE product_id = '1626'
331	0.0003	0.00028085708618164	SELECT * FROM productcustomimages WHERE product_id = '1626'
332	0.0006	0.00059103965759277	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
333	0.0003	0.00032496452331543	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
334	0.0003	0.00027608871459961	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
335	0.0003	0.00028586387634277	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
336	0.0004	0.00035810470581055	SELECT * FROM products WHERE id = '4041'
337	0.0004	0.00036501884460449	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
338	0.0004	0.0004420280456543	SELECT * FROM product_image_select WHERE product_id = '4041'
339	0.0003	0.00026607513427734	SELECT * FROM productcustomimages WHERE product_id = '4041'
340	0.0007	0.00070500373840332	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
341	0.0003	0.00030088424682617	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
342	0.0003	0.00026082992553711	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
343	0.0003	0.00026798248291016	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
344	0.0004	0.00037407875061035	SELECT * FROM products WHERE id = '4312'
345	0.0003	0.00030303001403809	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
346	0.0004	0.00044488906860352	SELECT * FROM product_image_select WHERE product_id = '4312'
347	0.0003	0.00026202201843262	SELECT * FROM productcustomimages WHERE product_id = '4312'
348	0.0007	0.000701904296875	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
349	0.0003	0.00031113624572754	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
350	0.0003	0.00026202201843262	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
351	0.0003	0.00026106834411621	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
352	0.0003	0.00032591819763184	SELECT * FROM products WHERE id = '777'
353	0.0003	0.00030612945556641	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
354	0.0005	0.00046586990356445	SELECT * FROM product_image_select WHERE product_id = '777'
355	0.0003	0.00026702880859375	SELECT * FROM productcustomimages WHERE product_id = '777'
356	0.0006	0.00064420700073242	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
357	0.0003	0.00029897689819336	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
358	0.0003	0.00025415420532227	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
359	0.0003	0.00027179718017578	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
360	0.0003	0.00033783912658691	SELECT * FROM products WHERE id = '3881'
361	0.0003	0.00034999847412109	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
362	0.0004	0.00043487548828125	SELECT * FROM product_image_select WHERE product_id = '3881'
363	0.0003	0.00026297569274902	SELECT * FROM productcustomimages WHERE product_id = '3881'
364	0.0007	0.0006861686706543	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
365	0.0003	0.00034284591674805	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
366	0.0003	0.0002598762512207	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
367	0.0003	0.00029897689819336	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
368	0.0003	0.00032806396484375	SELECT * FROM products WHERE id = '4213'
369	0.0003	0.00033998489379883	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
370	0.0004	0.00043582916259766	SELECT * FROM product_image_select WHERE product_id = '4213'
371	0.0003	0.0002598762512207	SELECT * FROM productcustomimages WHERE product_id = '4213'
372	0.0007	0.00068807601928711	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
373	0.0003	0.0003049373626709	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
374	0.0003	0.00027894973754883	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
375	0.0003	0.00027203559875488	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
376	0.0010	0.001046895980835	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
377	0.0005	0.00053787231445312	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
378	0.0015	0.0014681816101074	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
379	0.0008	0.00083684921264648	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
380	0.0003	0.00034999847412109	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
381	0.0004	0.00044703483581543	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
382	0.0004	0.00043916702270508	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Search Results for "4"

Product Filters (more)

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.7296440601349 seconds

Query Debug - 382 Database Queries. Total time 1.2349 seconds