You currently have no items in your cart.

More Information

Above are the items you have added to your shopping basket. If you are ready to place your order, simply click "Checkout" above. You will be taken to Amazon and guided through the process of entering the details needed to complete your order, including your delivery address and payment option. Your details are 100% guaranteed to be completely secure.

If you are looking for more products why don't you continue looking through our store.

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.3015711307526	147	0.9273	0

App Total Time

DB Queries

DB Query Total Time

Amazon Requests

1.3015711307526

147

0.9273

No Amazon API Requests Made.

App Debug - Total Time 1.3015711307526 seconds

Number	Time From Start	Name	Description
1	0.25832319259644	Initialise	Initialise FSB Function
2	0.26121020317078	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.30442500114441	Start of getCategoryListByGroup Function	Before first category groups query
4	0.30542707443237	After initial query	Before first category groups query
5	0.30542802810669	Get Category List for Group	Before the call to getCategoryList function
6	0.3054301738739	Start of GetCategoryList function	Start of the function
7	0.30543112754822	Before getting categories	Query to get specific category list
8	0.30622816085815	After getting categories	Query to get specific category list
9	0.30622816085815	Before getting category custom	Before call to function getCategoryCustom
10	0.32146120071411	After getting category custom	After call to function getCategoryCustom
11	0.32146310806274	Before getting category custom	Before call to function getCategoryCustom
12	0.33262300491333	After getting category custom	After call to function getCategoryCustom
13	0.33262705802917	Before getting category custom	Before call to function getCategoryCustom
14	0.33740019798279	After getting category custom	After call to function getCategoryCustom
15	0.33740210533142	Before getting category custom	Before call to function getCategoryCustom
16	0.34079003334045	After getting category custom	After call to function getCategoryCustom
17	0.34079217910767	Before getting category custom	Before call to function getCategoryCustom
18	0.34395217895508	After getting category custom	After call to function getCategoryCustom
19	0.34395408630371	Before getting category custom	Before call to function getCategoryCustom
20	0.34703016281128	After getting category custom	After call to function getCategoryCustom
21	0.34703207015991	End of GetCategoryList function	End of the function
22	0.34703612327576	Get Category List for Group	Before the call to getCategoryList function
23	0.34703803062439	Start of GetCategoryList function	Start of the function
24	0.3470401763916	Before getting categories	Query to get specific category list
25	0.34738802909851	End of getCategoryListByGroup Function	Before return()
26	1.1070120334625	App Controller End	End of the App controller (called before the controller of every page)
27	1.1097111701965	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.1108090877533	Before Get Options	Before the call to getOptions in the tpl class
29	1.1813859939575	After Get Options	After the call to getOptions in the tpl class
30	1.1814250946045	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.3015601634979	Finalizing debug	Before the debug is output to the page.
32	1.3015701770782	End of App	This is the end of the app logging, final timestamp

Query Debug - 147 Database Queries. Total time 0.9273 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.249\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751321928'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'basket' LIMIT 1
SELECT * FROM pages WHERE id = 46
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 = 'basket'
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.249') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.249') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'basket'
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.0011	0.001107931137085	SELECT parameter, value FROM parameters
2	0.0036	0.0035719871520996	SELECT * FROM `bad_bots`
3	0.0003	0.00029706954956055	SET time_zone = 'Europe/London'
4	0.0005	0.000518798828125	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0013	0.0012819766998291	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"216.73.216.249\";}'
6	0.0010	0.00096392631530762	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1751321928'
7	0.0019	0.001939058303833	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0005	0.00049781799316406	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0014	0.00142502784729	SELECT id FROM pages WHERE pagename = 'basket' LIMIT 1
10	0.0004	0.00035810470581055	SELECT * FROM pages WHERE id = 46
11	0.0031	0.0031130313873291	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0390	0.039030075073242	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0006	0.00062394142150879	SELECT * FROM pages WHERE pagename = 'basket'
14	0.0010	0.00099802017211914	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0008	0.00078296661376953	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0054	0.0054199695587158	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
17	0.0010	0.0009920597076416	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18	0.0008	0.00077390670776367	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0003	0.00030899047851562	SELECT id FROM categories WHERE parent_id = '26'
20	0.0048	0.0048000812530518	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
21	0.0009	0.00090217590332031	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
22	0.0009	0.00087618827819824	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
23	0.0008	0.00076413154602051	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0003	0.00032687187194824	SELECT * FROM categorygroups WHERE id = '1'
25	0.0041	0.004082202911377	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
26	0.0006	0.00055909156799316	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27	0.0003	0.00033998489379883	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0004	0.0003819465637207	SELECT id FROM categories WHERE parent_id = '27'
29	0.0041	0.0041351318359375	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
30	0.0004	0.00043797492980957	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
31	0.0004	0.00042605400085449	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
32	0.0004	0.00037193298339844	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0003	0.00034189224243164	SELECT * FROM categorygroups WHERE id = '1'
34	0.0012	0.0012369155883789	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
35	0.0004	0.0003969669342041	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36	0.0003	0.00030398368835449	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0003	0.00031208992004395	SELECT id FROM categories WHERE parent_id = '28'
38	0.0012	0.0011599063873291	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
39	0.0003	0.00034904479980469	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
40	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 (28) AND c.prod_type = 'custom' AND cp.hide = 0
41	0.0003	0.00031590461730957	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0003	0.00027990341186523	SELECT * FROM categorygroups WHERE id = '1'
43	0.0005	0.00046110153198242	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
44	0.0003	0.00033092498779297	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45	0.0003	0.00028896331787109	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0003	0.00029516220092773	SELECT id FROM categories WHERE parent_id = '29'
47	0.0005	0.00046896934509277	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
48	0.0004	0.00035190582275391	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
49	0.0004	0.00037789344787598	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
50	0.0004	0.00044107437133789	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0003	0.00029897689819336	SELECT * FROM categorygroups WHERE id = '1'
52	0.0004	0.0003960132598877	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
53	0.0003	0.00032496452331543	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54	0.0003	0.00029706954956055	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0003	0.00030398368835449	SELECT id FROM categories WHERE parent_id = '30'
56	0.0004	0.00044608116149902	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
57	0.0004	0.0003509521484375	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
58	0.0004	0.00036501884460449	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
59	0.0003	0.00031304359436035	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0003	0.00029683113098145	SELECT * FROM categorygroups WHERE id = '1'
61	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 = 31
62	0.0003	0.00030183792114258	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63	0.0003	0.00027990341186523	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0003	0.00028896331787109	SELECT id FROM categories WHERE parent_id = '31'
65	0.0005	0.00045585632324219	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
66	0.0003	0.00032401084899902	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
67	0.0003	0.00034904479980469	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
68	0.0003	0.00030612945556641	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0003	0.00029993057250977	SELECT * FROM categorygroups WHERE id = '1'
70	0.0003	0.00034308433532715	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0020	0.0020360946655273	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0008	0.00078392028808594	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0004	0.00039005279541016	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
74	0.0006	0.00060296058654785	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0009	0.0009009838104248	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0006	0.0005800724029541	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.7505	0.75046515464783	SELECT * FROM ipgeocountries WHERE INET_ATON('216.73.216.249') >= INET_ATON(ip_start) AND INET_ATON('216.73.216.249') <= INET_ATON(ip_end)
78	0.0015	0.0015220642089844	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0006	0.00064921379089355	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0004	0.00040102005004883	SELECT * FROM pages WHERE pagename = 'basket'
81	0.0007	0.00074100494384766	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
82	0.0007	0.00072503089904785	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
83	0.0003	0.0002739429473877	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
84	0.0123	0.012256145477295	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
85	0.0014	0.0013940334320068	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
86	0.0011	0.0010769367218018	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
87	0.0004	0.00040078163146973	SELECT * FROM products WHERE id = 1626
88	0.0010	0.0010051727294922	SELECT * FROM products WHERE id = 4041
89	0.0005	0.00051999092102051	SELECT * FROM products WHERE id = 4312
90	0.0005	0.00046300888061523	SELECT * FROM products WHERE id = 777
91	0.0005	0.00050592422485352	SELECT * FROM products WHERE id = 3881
92	0.0005	0.00047492980957031	SELECT * FROM products WHERE id = 4213
93	0.0005	0.00047779083251953	SELECT * FROM products WHERE id = '1626'
94	0.0006	0.00059890747070312	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
95	0.0019	0.0019490718841553	SELECT * FROM product_image_select WHERE product_id = '1626'
96	0.0006	0.00058388710021973	SELECT * FROM productcustomimages WHERE product_id = '1626'
97	0.0033	0.0033178329467773	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
98	0.0006	0.00060009956359863	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
99	0.0005	0.00046300888061523	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
100	0.0006	0.00057387351989746	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101	0.0007	0.00069093704223633	SELECT * FROM products WHERE id = '4041'
102	0.0006	0.00061202049255371	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
103	0.0010	0.00098299980163574	SELECT * FROM product_image_select WHERE product_id = '4041'
104	0.0005	0.00048089027404785	SELECT * FROM productcustomimages WHERE product_id = '4041'
105	0.0016	0.0016188621520996	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
106	0.0007	0.00070381164550781	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
107	0.0006	0.00059819221496582	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
108	0.0007	0.00072097778320312	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109	0.0008	0.00075697898864746	SELECT * FROM products WHERE id = '4312'
110	0.0008	0.0007779598236084	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
111	0.0012	0.001201868057251	SELECT * FROM product_image_select WHERE product_id = '4312'
112	0.0006	0.00057005882263184	SELECT * FROM productcustomimages WHERE product_id = '4312'
113	0.0020	0.0020060539245605	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
114	0.0008	0.00078701972961426	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
115	0.0006	0.0005800724029541	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
116	0.0007	0.00070810317993164	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0008	0.00080490112304688	SELECT * FROM products WHERE id = '777'
118	0.0008	0.00083303451538086	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
119	0.0010	0.0010309219360352	SELECT * FROM product_image_select WHERE product_id = '777'
120	0.0005	0.00051188468933105	SELECT * FROM productcustomimages WHERE product_id = '777'
121	0.0016	0.0016460418701172	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
122	0.0006	0.00058794021606445	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0005	0.00047016143798828	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0006	0.00060009956359863	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125	0.0007	0.00071597099304199	SELECT * FROM products WHERE id = '3881'
126	0.0007	0.00072097778320312	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
127	0.0011	0.0010640621185303	SELECT * FROM product_image_select WHERE product_id = '3881'
128	0.0005	0.00049591064453125	SELECT * FROM productcustomimages WHERE product_id = '3881'
129	0.0016	0.0016059875488281	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
130	0.0006	0.00058889389038086	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
131	0.0005	0.00047707557678223	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
132	0.0006	0.00056099891662598	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0006	0.00063896179199219	SELECT * FROM products WHERE id = '4213'
134	0.0007	0.00068998336791992	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
135	0.0010	0.0010290145874023	SELECT * FROM product_image_select WHERE product_id = '4213'
136	0.0005	0.00045895576477051	SELECT * FROM productcustomimages WHERE product_id = '4213'
137	0.0016	0.0015630722045898	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
138	0.0006	0.00063610076904297	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0004	0.00044488906860352	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0006	0.00057196617126465	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141	0.0023	0.0022599697113037	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
142	0.0010	0.00098395347595215	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
143	0.0034	0.0034050941467285	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
144	0.0018	0.0017900466918945	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
145	0.0006	0.00064301490783691	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
146	0.0009	0.00085091590881348	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
147	0.0009	0.00089502334594727	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

More Information

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3015711307526 seconds

Query Debug - 147 Database Queries. Total time 0.9273 seconds

More Information

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.3015711307526 seconds

Query Debug - 147 Database Queries. Total time 0.9273 seconds