Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.1557989120483	148	0.0881	0

No Amazon API Requests Made.

App Debug - Total Time 1.1557989120483 seconds

Number	Time From Start	Name	Description
1	0.95812487602234	Initialise	Initialise FSB Function
2	0.96071696281433	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.96387505531311	Start of getCategoryListByGroup Function	Before first category groups query
4	0.96416997909546	After initial query	Before first category groups query
5	0.96417188644409	Get Category List for Group	Before the call to getCategoryList function
6	0.96417593955994	Start of GetCategoryList function	Start of the function
7	0.9641809463501	Before getting categories	Query to get specific category list
8	0.96460604667664	After getting categories	Query to get specific category list
9	0.96460890769958	Before getting category custom	Before call to function getCategoryCustom
10	0.98644804954529	After getting category custom	After call to function getCategoryCustom
11	0.98645305633545	Before getting category custom	Before call to function getCategoryCustom
12	0.99958395957947	After getting category custom	After call to function getCategoryCustom
13	0.99958801269531	Before getting category custom	Before call to function getCategoryCustom
14	1.005588054657	After getting category custom	After call to function getCategoryCustom
15	1.0055918693542	Before getting category custom	Before call to function getCategoryCustom
16	1.0096299648285	After getting category custom	After call to function getCategoryCustom
17	1.00963306427	Before getting category custom	Before call to function getCategoryCustom
18	1.0136830806732	After getting category custom	After call to function getCategoryCustom
19	1.0136859416962	Before getting category custom	Before call to function getCategoryCustom
20	1.0167188644409	After getting category custom	After call to function getCategoryCustom
21	1.0167229175568	End of GetCategoryList function	End of the function
22	1.0167319774628	Get Category List for Group	Before the call to getCategoryList function
23	1.0167360305786	Start of GetCategoryList function	Start of the function
24	1.0167400836945	Before getting categories	Query to get specific category list
25	1.0170938968658	End of getCategoryListByGroup Function	Before return()
26	1.0226049423218	App Controller End	End of the App controller (called before the controller of every page)
27	1.0518870353699	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	1.052631855011	Before Get Options	Before the call to getOptions in the tpl class
29	1.0763599872589	After Get Options	After the call to getOptions in the tpl class
30	1.0764138698578	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.1557760238647	Finalizing debug	Before the debug is output to the page.
32	1.1557970046997	End of App	This is the end of the app logging, final timestamp

Query Debug - 148 Database Queries. Total time 0.0881 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:\"3.22.181.209\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1714067673'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2024-04-25 17:54:33' WHERE id = '16'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'newsletter' LIMIT 1
SELECT * FROM pages WHERE id = 55
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 = 'newsletter'
SELECT * FROM categorygroups ORDER BY sortorder ASC
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
SELECT id FROM categories WHERE parent_id = '26'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '27'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
SELECT id FROM categories WHERE parent_id = '28'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '29'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '30'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
SELECT * FROM categorygroups WHERE id = '1'
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
SELECT id FROM categories WHERE parent_id = '31'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('3.22.181.209') >= INET_ATON(ip_start) AND INET_ATON('3.22.181.209') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'newsletter'
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.0007	0.00069308280944824	SELECT parameter, value FROM parameters
2	0.0012	0.0012068748474121	SELECT * FROM `bad_bots`
3	0.0003	0.00031495094299316	SET time_zone = 'Europe/London'
4	0.0003	0.00032401084899902	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0006	0.00058317184448242	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.22.181.209\";}'
6	0.0007	0.00069093704223633	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1714067673'
7	0.0005	0.00049686431884766	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0013	0.0013070106506348	UPDATE autorun SET lastrun = '2024-04-25 17:54:33' WHERE id = '16'
9	0.0003	0.00030398368835449	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0008	0.00083804130554199	SELECT id FROM pages WHERE pagename = 'newsletter' LIMIT 1
11	0.0006	0.00058293342590332	SELECT * FROM pages WHERE id = 55
12	0.0008	0.00082612037658691	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
13	0.0007	0.0007469654083252	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
14	0.0008	0.00075697898864746	SELECT * FROM pages WHERE pagename = 'newsletter'
15	0.0003	0.00027894973754883	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0004	0.00039887428283691	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0086	0.0085799694061279	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.0006	0.00058913230895996	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.0003	0.00027108192443848	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
20	0.0003	0.00025200843811035	SELECT id FROM categories WHERE parent_id = '26'
21	0.0097	0.0097498893737793	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.0013	0.0013251304626465	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.00031304359436035	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.0002598762512207	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
25	0.0003	0.00031304359436035	SELECT * FROM categorygroups WHERE id = '1'
26	0.0050	0.0049619674682617	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.0007	0.00070810317993164	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
28	0.0003	0.00031113624572754	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
29	0.0004	0.00037503242492676	SELECT id FROM categories WHERE parent_id = '27'
30	0.0055	0.0055179595947266	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.00026988983154297	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.00029492378234863	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.00025701522827148	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
34	0.0003	0.00027799606323242	SELECT * FROM categorygroups WHERE id = '1'
35	0.0015	0.001488208770752	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.0008	0.00080990791320801	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
37	0.0004	0.00035500526428223	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
38	0.0003	0.00030803680419922	SELECT id FROM categories WHERE parent_id = '28'
39	0.0016	0.001615047454834	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.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 (28) AND p.disabled = 0
41	0.0003	0.0003349781036377	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.00031495094299316	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
43	0.0003	0.00030016899108887	SELECT * FROM categorygroups WHERE id = '1'
44	0.0006	0.00057101249694824	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.00036406517028809	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
46	0.0003	0.00031518936157227	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
47	0.0003	0.00034499168395996	SELECT id FROM categories WHERE parent_id = '29'
48	0.0007	0.00067782402038574	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.0008	0.00077390670776367	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.00026392936706543	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.00032901763916016	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
52	0.0003	0.00026702880859375	SELECT * FROM categorygroups WHERE id = '1'
53	0.0006	0.00057888031005859	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.00026988983154297	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.00027608871459961	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
56	0.0003	0.00025796890258789	SELECT id FROM categories WHERE parent_id = '30'
57	0.0007	0.00066590309143066	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
58	0.0008	0.00080013275146484	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.00034379959106445	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (30) AND c.prod_type = 'custom' AND cp.hide = 0
60	0.0004	0.00041317939758301	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
61	0.0003	0.00031185150146484	SELECT * FROM categorygroups WHERE id = '1'
62	0.0003	0.00032305717468262	SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
63	0.0003	0.00029897689819336	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.00033307075500488	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
65	0.0003	0.00031900405883789	SELECT id FROM categories WHERE parent_id = '31'
66	0.0003	0.00031113624572754	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.00034809112548828	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.00030398368835449	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.00030303001403809	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
70	0.0004	0.00035214424133301	SELECT * FROM categorygroups WHERE id = '1'
71	0.0003	0.00033712387084961	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
72	0.0006	0.00055122375488281	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
73	0.0004	0.00035500526428223	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
74	0.0003	0.00031208992004395	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.00030708312988281	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
76	0.0003	0.0002901554107666	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
77	0.0006	0.00064802169799805	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
78	0.0003	0.00028896331787109	SELECT * FROM ipgeocountries WHERE INET_ATON('3.22.181.209') >= INET_ATON(ip_start) AND INET_ATON('3.22.181.209') <= INET_ATON(ip_end)
79	0.0003	0.00029706954956055	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
80	0.0003	0.00026106834411621	SELECT * FROM countryredirects WHERE countrycode = 'US'
81	0.0004	0.0004432201385498	SELECT * FROM pages WHERE pagename = 'newsletter'
82	0.0004	0.00035715103149414	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
83	0.0003	0.00032401084899902	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
84	0.0003	0.00026798248291016	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
85	0.0003	0.00028491020202637	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
86	0.0003	0.00028300285339355	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
87	0.0003	0.00030398368835449	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
88	0.0004	0.00036287307739258	SELECT * FROM products WHERE id = 1626
89	0.0005	0.00050902366638184	SELECT * FROM products WHERE id = 4041
90	0.0005	0.00049400329589844	SELECT * FROM products WHERE id = 4312
91	0.0005	0.00053715705871582	SELECT * FROM products WHERE id = 777
92	0.0005	0.00048303604125977	SELECT * FROM products WHERE id = 4213
93	0.0005	0.00048184394836426	SELECT * FROM products WHERE id = 3881
94	0.0005	0.00046277046203613	SELECT * FROM products WHERE id = '1626'
95	0.0003	0.00028586387634277	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
96	0.0003	0.00026416778564453	SELECT * FROM product_image_select WHERE product_id = '1626'
97	0.0003	0.00027203559875488	SELECT * FROM productcustomimages WHERE product_id = '1626'
98	0.0003	0.00025200843811035	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
99	0.0004	0.00040888786315918	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
100	0.0003	0.00026488304138184	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
101	0.0003	0.00028109550476074	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
102	0.0004	0.00036215782165527	SELECT * FROM products WHERE id = '4041'
103	0.0002	0.00024199485778809	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
104	0.0002	0.00024914741516113	SELECT * FROM product_image_select WHERE product_id = '4041'
105	0.0002	0.00022792816162109	SELECT * FROM productcustomimages WHERE product_id = '4041'
106	0.0002	0.00024199485778809	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
107	0.0003	0.00025296211242676	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
108	0.0003	0.00027894973754883	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
109	0.0002	0.0002291202545166	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
110	0.0004	0.00036907196044922	SELECT * FROM products WHERE id = '4312'
111	0.0002	0.00023913383483887	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
112	0.0003	0.00032901763916016	SELECT * FROM product_image_select WHERE product_id = '4312'
113	0.0002	0.00024986267089844	SELECT * FROM productcustomimages WHERE product_id = '4312'
114	0.0003	0.00027108192443848	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
115	0.0003	0.00028300285339355	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
116	0.0003	0.00029397010803223	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
117	0.0002	0.00024199485778809	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
118	0.0003	0.00033116340637207	SELECT * FROM products WHERE id = '777'
119	0.0004	0.00040411949157715	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
120	0.0003	0.0002598762512207	SELECT * FROM product_image_select WHERE product_id = '777'
121	0.0003	0.00026202201843262	SELECT * FROM productcustomimages WHERE product_id = '777'
122	0.0003	0.00026512145996094	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
123	0.0003	0.00026202201843262	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
124	0.0003	0.00027608871459961	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
125	0.0003	0.00030684471130371	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
126	0.0004	0.00036787986755371	SELECT * FROM products WHERE id = '4213'
127	0.0004	0.0004432201385498	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
128	0.0003	0.00025105476379395	SELECT * FROM product_image_select WHERE product_id = '4213'
129	0.0002	0.00024199485778809	SELECT * FROM productcustomimages WHERE product_id = '4213'
130	0.0002	0.00024890899658203	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
131	0.0003	0.00026321411132812	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
132	0.0003	0.00027799606323242	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
133	0.0003	0.0002598762512207	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
134	0.0004	0.00036001205444336	SELECT * FROM products WHERE id = '3881'
135	0.0004	0.0004420280456543	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
136	0.0005	0.00046396255493164	SELECT * FROM product_image_select WHERE product_id = '3881'
137	0.0003	0.00031399726867676	SELECT * FROM productcustomimages WHERE product_id = '3881'
138	0.0003	0.00027108192443848	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
139	0.0003	0.00026202201843262	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
140	0.0003	0.00026893615722656	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
141	0.0002	0.00023007392883301	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
142	0.0004	0.00039386749267578	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
143	0.0005	0.00053715705871582	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
144	0.0005	0.00051188468933105	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
145	0.0006	0.00055694580078125	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
146	0.0006	0.00055885314941406	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
147	0.0005	0.00046300888061523	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
148	0.0005	0.00053000450134277	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.1557989120483 seconds

Query Debug - 148 Database Queries. Total time 0.0881 seconds