How We Use Cookies

A cookie is a small piece of text sent to your browser by a website you visit. It helps the website to remember information about your visit like your preferred language, the contents of your basket and other settings. That can make your next visit easier and the site more useful to you. Cookies play an important role. Without them, using the web would be a much more frustrating experience.

We use cookies for many purposes to help our website improve and to make your experience better. We use them, for example, to count how many visitors we receive to a page. Our privacy policy explains how we protect your privacy in our use of cookies and other information.

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.555832862854	147	0.8308	0

App Total Time

DB Queries

DB Query Total Time

Amazon Requests

1.555832862854

147

0.8308

No Amazon API Requests Made.

App Debug - Total Time 1.555832862854 seconds

Number	Time From Start	Name	Description
1	0.66244387626648	Initialise	Initialise FSB Function
2	0.6713719367981	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.71204996109009	Start of getCategoryListByGroup Function	Before first category groups query
4	0.7146589756012	After initial query	Before first category groups query
5	0.71465992927551	Get Category List for Group	Before the call to getCategoryList function
6	0.71466398239136	Start of GetCategoryList function	Start of the function
7	0.7146680355072	Before getting categories	Query to get specific category list
8	0.71540784835815	After getting categories	Query to get specific category list
9	0.71540904045105	Before getting category custom	Before call to function getCategoryCustom
10	0.73297095298767	After getting category custom	After call to function getCategoryCustom
11	0.7329740524292	Before getting category custom	Before call to function getCategoryCustom
12	0.74478101730347	After getting category custom	After call to function getCategoryCustom
13	0.7447829246521	Before getting category custom	Before call to function getCategoryCustom
14	0.75325489044189	After getting category custom	After call to function getCategoryCustom
15	0.75325703620911	Before getting category custom	Before call to function getCategoryCustom
16	0.7591290473938	After getting category custom	After call to function getCategoryCustom
17	0.75913095474243	Before getting category custom	Before call to function getCategoryCustom
18	0.76577997207642	After getting category custom	After call to function getCategoryCustom
19	0.76578187942505	Before getting category custom	Before call to function getCategoryCustom
20	0.77467107772827	After getting category custom	After call to function getCategoryCustom
21	0.77467393875122	End of GetCategoryList function	End of the function
22	0.77468085289001	Get Category List for Group	Before the call to getCategoryList function
23	0.77468395233154	Start of GetCategoryList function	Start of the function
24	0.77468705177307	Before getting categories	Query to get specific category list
25	0.77568697929382	End of getCategoryListByGroup Function	Before return()
26	1.3294188976288	App Controller End	End of the App controller (called before the controller of every page)
27	1.3645870685577	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.3686819076538	Before Get Options	Before the call to getOptions in the tpl class
29	1.501827955246	After Get Options	After the call to getOptions in the tpl class
30	1.5018630027771	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.5558090209961	Finalizing debug	Before the debug is output to the page.
32	1.5558309555054	End of App	This is the end of the app logging, final timestamp

Query Debug - 147 Database Queries. Total time 0.8308 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:\"18.118.142.230\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722074049'
SELECT * FROM autorun ORDER BY lastrun ASC
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'cookie-consent' LIMIT 1
SELECT * FROM pages WHERE id = 33
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 = 'cookie-consent'
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('18.118.142.230') >= INET_ATON(ip_start) AND INET_ATON('18.118.142.230') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'cookie-consent'
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.0013	0.0012609958648682	SELECT parameter, value FROM parameters
2	0.0082	0.0082309246063232	SELECT * FROM `bad_bots`
3	0.0004	0.0004420280456543	SET time_zone = 'Europe/London'
4	0.0010	0.0010240077972412	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0038	0.0038089752197266	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"18.118.142.230\";}'
6	0.0035	0.0034739971160889	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722074049'
7	0.0065	0.0065159797668457	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0014	0.0013768672943115	SELECT * FROM version ORDER BY installed DESC LIMIT 1
9	0.0062	0.0062098503112793	SELECT id FROM pages WHERE pagename = 'cookie-consent' LIMIT 1
10	0.0008	0.00078201293945312	SELECT * FROM pages WHERE id = 33
11	0.0054	0.005399227142334	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12	0.0337	0.033673048019409	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13	0.0011	0.0011191368103027	SELECT * FROM pages WHERE pagename = 'cookie-consent'
14	0.0026	0.0025949478149414	SELECT * FROM categorygroups ORDER BY sortorder ASC
15	0.0007	0.00072097778320312	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
16	0.0062	0.0062079429626465	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.0008	0.00082778930664062	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.0005	0.000518798828125	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19	0.0005	0.00052094459533691	SELECT id FROM categories WHERE parent_id = '26'
20	0.0066	0.0065701007843018	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.0008	0.000823974609375	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.0008	0.00081300735473633	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.0007	0.00065803527832031	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24	0.0005	0.00051307678222656	SELECT * FROM categorygroups WHERE id = '1'
25	0.0037	0.0037109851837158	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.0007	0.00065112113952637	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.0005	0.00045394897460938	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28	0.0005	0.00049090385437012	SELECT id FROM categories WHERE parent_id = '27'
29	0.0039	0.003864049911499	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.0007	0.00069999694824219	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.0007	0.0007331371307373	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.0006	0.00059795379638672	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33	0.0005	0.00052404403686523	SELECT * FROM categorygroups WHERE id = '1'
34	0.0016	0.0015709400177002	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.0007	0.00070500373840332	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.0006	0.00060796737670898	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37	0.0007	0.00066208839416504	SELECT id FROM categories WHERE parent_id = '28'
38	0.0020	0.0019509792327881	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.0007	0.00068306922912598	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.0011	0.0010809898376465	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.0006	0.00060319900512695	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42	0.0005	0.00052285194396973	SELECT * FROM categorygroups WHERE id = '1'
43	0.0008	0.00078010559082031	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.0006	0.00063204765319824	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.0005	0.00046610832214355	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46	0.0005	0.00048589706420898	SELECT id FROM categories WHERE parent_id = '29'
47	0.0009	0.00092101097106934	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.0006	0.0006108283996582	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.0007	0.00069713592529297	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.0007	0.00067496299743652	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51	0.0005	0.00051093101501465	SELECT * FROM categorygroups WHERE id = '1'
52	0.0009	0.00085902214050293	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.0006	0.00064897537231445	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.0006	0.00057578086853027	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55	0.0005	0.00045299530029297	SELECT id FROM categories WHERE parent_id = '30'
56	0.0011	0.001147985458374	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.0007	0.00066590309143066	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.0007	0.00072693824768066	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.0006	0.00060391426086426	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60	0.0009	0.00087499618530273	SELECT * FROM categorygroups WHERE id = '1'
61	0.0008	0.00081586837768555	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.0006	0.00061702728271484	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.0005	0.00046586990356445	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64	0.0005	0.00054597854614258	SELECT id FROM categories WHERE parent_id = '31'
65	0.0022	0.0021848678588867	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.0011	0.0011119842529297	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.0012	0.0011770725250244	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.0011	0.0010669231414795	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69	0.0008	0.00081205368041992	SELECT * FROM categorygroups WHERE id = '1'
70	0.0010	0.00098991394042969	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
71	0.0089	0.0089099407196045	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72	0.0038	0.0037820339202881	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73	0.0009	0.00093889236450195	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.0024	0.0024380683898926	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75	0.0022	0.002202033996582	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76	0.0018	0.0017709732055664	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77	0.5287	0.52872681617737	SELECT * FROM ipgeocountries WHERE INET_ATON('18.118.142.230') >= INET_ATON(ip_start) AND INET_ATON('18.118.142.230') <= INET_ATON(ip_end)
78	0.0023	0.0023190975189209	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79	0.0014	0.001431941986084	SELECT * FROM countryredirects WHERE countrycode = 'US'
80	0.0013	0.0013151168823242	SELECT * FROM pages WHERE pagename = 'cookie-consent'
81	0.0039	0.0038888454437256	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
82	0.0032	0.0032289028167725	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
83	0.0008	0.00077199935913086	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
84	0.0430	0.043012857437134	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.0041	0.0040690898895264	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.0028	0.002838134765625	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.0009	0.00092196464538574	SELECT * FROM products WHERE id = 1626
88	0.0009	0.00087594985961914	SELECT * FROM products WHERE id = 4041
89	0.0006	0.00061988830566406	SELECT * FROM products WHERE id = 4312
90	0.0009	0.00088810920715332	SELECT * FROM products WHERE id = 777
91	0.0011	0.0010838508605957	SELECT * FROM products WHERE id = 3881
92	0.0010	0.00096607208251953	SELECT * FROM products WHERE id = 4213
93	0.0008	0.00082612037658691	SELECT * FROM products WHERE id = '1626'
94	0.0013	0.0012640953063965	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
95	0.0043	0.0043361186981201	SELECT * FROM product_image_select WHERE product_id = '1626'
96	0.0011	0.0011429786682129	SELECT * FROM productcustomimages WHERE product_id = '1626'
97	0.0067	0.0067288875579834	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
98	0.0009	0.00094294548034668	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
99	0.0009	0.00089693069458008	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
100	0.0008	0.00084781646728516	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101	0.0010	0.00095415115356445	SELECT * FROM products WHERE id = '4041'
102	0.0007	0.00068807601928711	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
103	0.0010	0.0010170936584473	SELECT * FROM product_image_select WHERE product_id = '4041'
104	0.0006	0.00059413909912109	SELECT * FROM productcustomimages WHERE product_id = '4041'
105	0.0018	0.0018279552459717	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
106	0.0008	0.00078487396240234	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
107	0.0006	0.00061488151550293	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
108	0.0007	0.00070500373840332	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109	0.0009	0.00089597702026367	SELECT * FROM products WHERE id = '4312'
110	0.0009	0.00089597702026367	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
111	0.0011	0.0010628700256348	SELECT * FROM product_image_select WHERE product_id = '4312'
112	0.0007	0.0006721019744873	SELECT * FROM productcustomimages WHERE product_id = '4312'
113	0.0017	0.0016632080078125	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
114	0.0007	0.00065302848815918	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
115	0.0007	0.0007178783416748	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
116	0.0008	0.00084686279296875	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0009	0.00092101097106934	SELECT * FROM products WHERE id = '777'
118	0.0008	0.00080990791320801	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
119	0.0012	0.0012209415435791	SELECT * FROM product_image_select WHERE product_id = '777'
120	0.0009	0.00094389915466309	SELECT * FROM productcustomimages WHERE product_id = '777'
121	0.0015	0.0015389919281006	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.00062990188598633	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0006	0.00057482719421387	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0005	0.0005190372467041	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125	0.0008	0.00075602531433105	SELECT * FROM products WHERE id = '3881'
126	0.0008	0.00077581405639648	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
127	0.0008	0.00079107284545898	SELECT * FROM product_image_select WHERE product_id = '3881'
128	0.0007	0.00065779685974121	SELECT * FROM productcustomimages WHERE product_id = '3881'
129	0.0016	0.0016040802001953	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.00064206123352051	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
131	0.0010	0.0010249614715576	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
132	0.0010	0.0010221004486084	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0013	0.0013020038604736	SELECT * FROM products WHERE id = '4213'
134	0.0013	0.001317024230957	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
135	0.0016	0.0015790462493896	SELECT * FROM product_image_select WHERE product_id = '4213'
136	0.0009	0.00088214874267578	SELECT * FROM productcustomimages WHERE product_id = '4213'
137	0.0033	0.0032889842987061	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
138	0.0011	0.0011188983917236	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0009	0.00086498260498047	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0009	0.00086116790771484	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141	0.0052	0.0051629543304443	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
142	0.0016	0.0016348361968994	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
143	0.0063	0.0062642097473145	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
144	0.0043	0.0043449401855469	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
145	0.0010	0.0010027885437012	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
146	0.0010	0.00098180770874023	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
147	0.0008	0.00083613395690918	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

How We Use Cookies

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.555832862854 seconds

Query Debug - 147 Database Queries. Total time 0.8308 seconds

How We Use Cookies

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.555832862854 seconds

Query Debug - 147 Database Queries. Total time 0.8308 seconds