Best Sellers

Sorry, we currently have no available products here.

37 to 20 of 20 products

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
0.86232495307922	160	0.2101	0

App Total Time

DB Queries

DB Query Total Time

Amazon Requests

0.86232495307922

160

0.2101

No Amazon API Requests Made.

App Debug - Total Time 0.86232495307922 seconds

Number	Time From Start	Name	Description
1	0.58178091049194	Initialise	Initialise FSB Function
2	0.59426498413086	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.59823703765869	Start of getCategoryListByGroup Function	Before first category groups query
4	0.59932684898376	After initial query	Before first category groups query
5	0.59932994842529	Get Category List for Group	Before the call to getCategoryList function
6	0.59933996200562	Start of GetCategoryList function	Start of the function
7	0.59934496879578	Before getting categories	Query to get specific category list
8	0.59981989860535	After getting categories	Query to get specific category list
9	0.59982204437256	Before getting category custom	Before call to function getCategoryCustom
10	0.60302305221558	After getting category custom	After call to function getCategoryCustom
11	0.60302686691284	Before getting category custom	Before call to function getCategoryCustom
12	0.6239800453186	After getting category custom	After call to function getCategoryCustom
13	0.62398600578308	Before getting category custom	Before call to function getCategoryCustom
14	0.63116788864136	After getting category custom	After call to function getCategoryCustom
15	0.63117289543152	Before getting category custom	Before call to function getCategoryCustom
16	0.63702392578125	After getting category custom	After call to function getCategoryCustom
17	0.63702797889709	Before getting category custom	Before call to function getCategoryCustom
18	0.64313197135925	After getting category custom	After call to function getCategoryCustom
19	0.6431360244751	Before getting category custom	Before call to function getCategoryCustom
20	0.64985084533691	After getting category custom	After call to function getCategoryCustom
21	0.64985489845276	End of GetCategoryList function	End of the function
22	0.64986300468445	Get Category List for Group	Before the call to getCategoryList function
23	0.64986491203308	Start of GetCategoryList function	Start of the function
24	0.64986801147461	Before getting categories	Query to get specific category list
25	0.65023589134216	End of getCategoryListByGroup Function	Before return()
26	0.74586200714111	App Controller End	End of the App controller (called before the controller of every page)
27	0.79565191268921	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	0.79624199867249	Before Get Options	Before the call to getOptions in the tpl class
29	0.81927585601807	After Get Options	After the call to getOptions in the tpl class
30	0.81931185722351	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	0.86230206489563	Finalizing debug	Before the debug is output to the page.
32	0.86232399940491	End of App	This is the end of the app logging, final timestamp

Query Debug - 160 Database Queries. Total time 0.2101 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"13.58.60.192\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1714687535'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2024-05-02 22:05:35' WHERE id = '16'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
SELECT * FROM pages WHERE id = 44
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 = 'best-sellers'
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('13.58.60.192') >= INET_ATON(ip_start) AND INET_ATON('13.58.60.192') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'best-sellers'
SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers|3|bestselling|18'
DELETE FROM cachefiles WHERE identifier = 'page_bestsellers|3|bestselling|18'
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
SELECT id,asin FROM products p
		WHERE enabled = 1
		AND parent_id = 0
		AND hidden = 0
		
		AND salesrank <> 0
		AND 1 = 1
		ORDER BY salesrank ASC
		LIMIT 20
SELECT id FROM custom_products p
		WHERE hide = 0
		AND bestseller = 1
		LIMIT 20
SELECT id,listingtype FROM ebay_products p
		WHERE hide = 0
		ORDER BY soldcount DESC
		LIMIT 20
SELECT * FROM products p
		WHERE enabled = 1
		AND parent_id = 0
		AND hidden = 0
		
		AND salesrank <> 0
		AND 1 = 1
		AND id IN (4950,4953,4933,4926,4925,868,4919,2029,862,1011,4122,1010,1140,1061,2165,4939,1110,4930,1160,4940)
		ORDER BY salesrank ASC
		LIMIT 36, 18
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 = 4213
SELECT * FROM products WHERE id = 3881
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 = '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 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 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.0005	0.00050616264343262	SELECT parameter, value FROM parameters
2	0.0015	0.0014801025390625	SELECT * FROM `bad_bots`
3	0.0004	0.00040602684020996	SET time_zone = 'Europe/London'
4	0.0004	0.00036311149597168	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0011	0.0011129379272461	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"13.58.60.192\";}'
6	0.0008	0.00078487396240234	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1714687535'
7	0.0006	0.00062322616577148	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0010	0.00095915794372559	UPDATE autorun SET lastrun = '2024-05-02 22:05:35' WHERE id = '16'
9	0.0004	0.00036907196044922	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0086	0.0085959434509277	SELECT id FROM pages WHERE pagename = 'best-sellers' LIMIT 1
11	0.0029	0.0029129981994629	SELECT * FROM pages WHERE id = 44
12	0.0007	0.00074481964111328	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0008	0.00080299377441406	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0015	0.0015170574188232	SELECT * FROM pages WHERE pagename = 'best-sellers'
15	0.0011	0.0010709762573242	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0004	0.00043892860412598	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0003	0.00034689903259277	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.0004	0.00035905838012695	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.0004	0.00038790702819824	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0003	0.00034713745117188	SELECT id FROM categories WHERE parent_id = '26'
21	0.0003	0.00030899047851562	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.0003	0.00034093856811523	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.0003	0.00033402442932129	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.0003	0.00029492378234863	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0003	0.00031399726867676	SELECT * FROM categorygroups WHERE id = '1'
26	0.0098	0.009814977645874	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.0014	0.0013728141784668	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.0004	0.0003509521484375	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0004	0.00035810470581055	SELECT id FROM categories WHERE parent_id = '27'
30	0.0077	0.0076899528503418	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.0003	0.00032591819763184	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.0003	0.00029587745666504	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.00027704238891602	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0003	0.00026202201843262	SELECT * FROM categorygroups WHERE id = '1'
35	0.0026	0.0026099681854248	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.00032687187194824	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.00029492378234863	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0003	0.00031614303588867	SELECT id FROM categories WHERE parent_id = '28'
39	0.0021	0.0020918846130371	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.00043082237243652	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.00030994415283203	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.00031709671020508	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0003	0.00032711029052734	SELECT * FROM categorygroups WHERE id = '1'
44	0.0016	0.0015859603881836	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.0004	0.00035881996154785	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0004	0.00039410591125488	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0003	0.0003359317779541	SELECT id FROM categories WHERE parent_id = '29'
48	0.0017	0.0017490386962891	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.00033307075500488	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.0003	0.00029587745666504	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.0003	0.00029587745666504	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0003	0.00033903121948242	SELECT * FROM categorygroups WHERE id = '1'
53	0.0011	0.0011138916015625	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.00033116340637207	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.00030207633972168	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0003	0.00028300285339355	SELECT id FROM categories WHERE parent_id = '30'
57	0.0009	0.00093388557434082	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.0020	0.0020270347595215	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.0003	0.00030994415283203	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.0003	0.00033688545227051	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0003	0.00031900405883789	SELECT * FROM categorygroups WHERE id = '1'
62	0.0009	0.00091218948364258	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.0020	0.0019729137420654	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.00031185150146484	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0003	0.00029206275939941	SELECT id FROM categories WHERE parent_id = '31'
66	0.0020	0.0019650459289551	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.00034284591674805	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.0003	0.00027799606323242	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.0003	0.00026607513427734	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0003	0.00026607513427734	SELECT * FROM categorygroups WHERE id = '1'
71	0.0004	0.00035810470581055	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0003	0.00030708312988281	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0003	0.00034379959106445	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0005	0.00050020217895508	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.0003	0.00029993057250977	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0003	0.00029993057250977	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0007	0.0006561279296875	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.0904	0.090413093566895	SELECT * FROM ipgeocountries WHERE INET_ATON('13.58.60.192') >= INET_ATON(ip_start) AND INET_ATON('13.58.60.192') <= INET_ATON(ip_end)
79	0.0004	0.0003809928894043	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0003	0.00028896331787109	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0004	0.00043296813964844	SELECT * FROM pages WHERE pagename = 'best-sellers'
82	0.0016	0.0015990734100342	SELECT * FROM cachefiles WHERE identifier = 'page_bestsellers\|3\|bestselling\|18'
83	0.0011	0.0010621547698975	DELETE FROM cachefiles WHERE identifier = 'page_bestsellers\|3\|bestselling\|18'
84	0.0139	0.013917922973633	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
85	0.0004	0.00036406517028809	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
86	0.0003	0.00033903121948242	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
87	0.0003	0.00033402442932129	SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
88	0.0003	0.00033402442932129	SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
89	0.0003	0.00034308433532715	SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
90	0.0010	0.0010490417480469	SELECT id,asin FROM products p WHERE enabled = 1 AND parent_id = 0 AND hidden = 0 AND salesrank <> 0 AND 1 = 1 ORDER BY salesrank ASC LIMIT 20
91	0.0006	0.00058412551879883	SELECT id FROM custom_products p WHERE hide = 0 AND bestseller = 1 LIMIT 20
92	0.0006	0.0005640983581543	SELECT id,listingtype FROM ebay_products p WHERE hide = 0 ORDER BY soldcount DESC LIMIT 20
93	0.0010	0.0010108947753906	SELECT * FROM products p WHERE enabled = 1 AND parent_id = 0 AND hidden = 0 AND salesrank <> 0 AND 1 = 1 AND id IN (4950,4953,4933,4926,4925,868,4919,2029,862,1011,4122,1010,1140,1061,2165,4939,1110,4930,1160,4940) ORDER BY salesrank ASC LIMIT 36, 18
94	0.0004	0.00035715103149414	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
95	0.0003	0.00027108192443848	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
96	0.0002	0.00023794174194336	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
97	0.0003	0.00032496452331543	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
98	0.0003	0.00026202201843262	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
99	0.0002	0.00022792816162109	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
100	0.0003	0.00033903121948242	SELECT * FROM products WHERE id = 1626
101	0.0005	0.00047802925109863	SELECT * FROM products WHERE id = 4041
102	0.0004	0.00036287307739258	SELECT * FROM products WHERE id = 4312
103	0.0003	0.00034594535827637	SELECT * FROM products WHERE id = 777
104	0.0005	0.00053501129150391	SELECT * FROM products WHERE id = 4213
105	0.0005	0.00045418739318848	SELECT * FROM products WHERE id = 3881
106	0.0004	0.00039291381835938	SELECT * FROM products WHERE id = '1626'
107	0.0003	0.00025391578674316	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
108	0.0002	0.00024509429931641	SELECT * FROM product_image_select WHERE product_id = '1626'
109	0.0003	0.00027894973754883	SELECT * FROM productcustomimages WHERE product_id = '1626'
110	0.0003	0.0003209114074707	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
111	0.0002	0.00024914741516113	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
112	0.0004	0.00036096572875977	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
113	0.0003	0.00032806396484375	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
114	0.0005	0.00046801567077637	SELECT * FROM products WHERE id = '4041'
115	0.0004	0.0004429817199707	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
116	0.0004	0.00042486190795898	SELECT * FROM product_image_select WHERE product_id = '4041'
117	0.0002	0.00023198127746582	SELECT * FROM productcustomimages WHERE product_id = '4041'
118	0.0003	0.00031685829162598	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
119	0.0003	0.0003209114074707	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
120	0.0002	0.00024986267089844	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
121	0.0002	0.00022220611572266	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
122	0.0003	0.00034999847412109	SELECT * FROM products WHERE id = '4312'
123	0.0003	0.00027990341186523	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
124	0.0002	0.00024604797363281	SELECT * FROM product_image_select WHERE product_id = '4312'
125	0.0002	0.00023412704467773	SELECT * FROM productcustomimages WHERE product_id = '4312'
126	0.0003	0.00025510787963867	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
127	0.0002	0.00024008750915527	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
128	0.0003	0.00025606155395508	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
129	0.0003	0.00029301643371582	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
130	0.0003	0.00033998489379883	SELECT * FROM products WHERE id = '777'
131	0.0002	0.00024104118347168	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
132	0.0002	0.0002281665802002	SELECT * FROM product_image_select WHERE product_id = '777'
133	0.0002	0.00023007392883301	SELECT * FROM productcustomimages WHERE product_id = '777'
134	0.0003	0.00032401084899902	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
135	0.0003	0.00026297569274902	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
136	0.0003	0.00025415420532227	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
137	0.0003	0.00032401084899902	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
138	0.0004	0.00036382675170898	SELECT * FROM products WHERE id = '4213'
139	0.0004	0.00043201446533203	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
140	0.0002	0.00024890899658203	SELECT * FROM product_image_select WHERE product_id = '4213'
141	0.0003	0.00025820732116699	SELECT * FROM productcustomimages WHERE product_id = '4213'
142	0.0002	0.00023818016052246	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
143	0.0002	0.00023102760314941	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
144	0.0003	0.00025200843811035	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
145	0.0002	0.0002129077911377	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
146	0.0003	0.00033187866210938	SELECT * FROM products WHERE id = '3881'
147	0.0005	0.00046801567077637	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
148	0.0004	0.00042295455932617	SELECT * FROM product_image_select WHERE product_id = '3881'
149	0.0003	0.00026297569274902	SELECT * FROM productcustomimages WHERE product_id = '3881'
150	0.0003	0.00027990341186523	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
151	0.0005	0.00047993659973145	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
152	0.0003	0.00033807754516602	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
153	0.0002	0.00023412704467773	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
154	0.0003	0.00034213066101074	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
155	0.0008	0.00075483322143555	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
156	0.0006	0.00062704086303711	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
157	0.0007	0.00073003768920898	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
158	0.0004	0.0004429817199707	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
159	0.0005	0.00051498413085938	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
160	0.0005	0.00046586990356445	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Best Sellers

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 0.86232495307922 seconds

Query Debug - 160 Database Queries. Total time 0.2101 seconds

Best Sellers

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 0.86232495307922 seconds

Query Debug - 160 Database Queries. Total time 0.2101 seconds