Articles

Page	Created On	Last Updated

We are ready to help with whatever you need. To ensure you get a fast and considered response, please contact us via email - simply enter your details below and we will get back to you as soon as possible.

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
1.0169541835785	147	0.1643	0

App Total Time

DB Queries

DB Query Total Time

Amazon Requests

1.0169541835785

147

0.1643

No Amazon API Requests Made.

App Debug - Total Time 1.0169541835785 seconds

Number	Time From Start	Name	Description
1	0.7408230304718	Initialise	Initialise FSB Function
2	0.74148607254028	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.74446415901184	Start of getCategoryListByGroup Function	Before first category groups query
4	0.74503016471863	After initial query	Before first category groups query
5	0.74503207206726	Get Category List for Group	Before the call to getCategoryList function
6	0.74503517150879	Start of GetCategoryList function	Start of the function
7	0.74503707885742	Before getting categories	Query to get specific category list
8	0.74539709091187	After getting categories	Query to get specific category list
9	0.74539804458618	Before getting category custom	Before call to function getCategoryCustom
10	0.7478461265564	After getting category custom	After call to function getCategoryCustom
11	0.74784803390503	Before getting category custom	Before call to function getCategoryCustom
12	0.76377105712891	After getting category custom	After call to function getCategoryCustom
13	0.76377415657043	Before getting category custom	Before call to function getCategoryCustom
14	0.77075099945068	After getting category custom	After call to function getCategoryCustom
15	0.7707531452179	Before getting category custom	Before call to function getCategoryCustom
16	0.7804970741272	After getting category custom	After call to function getCategoryCustom
17	0.78050017356873	Before getting category custom	Before call to function getCategoryCustom
18	0.78604817390442	After getting category custom	After call to function getCategoryCustom
19	0.78605103492737	Before getting category custom	Before call to function getCategoryCustom
20	0.79015016555786	After getting category custom	After call to function getCategoryCustom
21	0.79015207290649	End of GetCategoryList function	End of the function
22	0.79015898704529	Get Category List for Group	Before the call to getCategoryList function
23	0.7901611328125	Start of GetCategoryList function	Start of the function
24	0.79016399383545	Before getting categories	Query to get specific category list
25	0.79051613807678	End of getCategoryListByGroup Function	Before return()
26	0.87288999557495	App Controller End	End of the App controller (called before the controller of every page)
27	0.90005207061768	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
28	0.90080404281616	Before Get Options	Before the call to getOptions in the tpl class
29	0.92903614044189	After Get Options	After the call to getOptions in the tpl class
30	0.92907500267029	App_after Controller End	End of the App_after controller (called after the controller of every page)
31	1.0169279575348	Finalizing debug	Before the debug is output to the page.
32	1.0169520378113	End of App	This is the end of the app logging, final timestamp

Query Debug - 147 Database Queries. Total time 0.1643 seconds


SELECT parameter, value FROM parameters
SELECT * FROM `bad_bots`
SET time_zone = 'Europe/London'
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.140.185.170\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1713297401'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2024-04-16 19:56:41' WHERE id = '15'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
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 = 'articles'
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.140.185.170') >= INET_ATON(ip_start) AND INET_ATON('3.140.185.170') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'articles'
SELECT * FROM pages WHERE xmlsitemap = 1 AND core = 0 ORDER BY `created_on` DESC
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
SELECT * FROM products WHERE id = 1626
SELECT * FROM products WHERE id = 4041
SELECT * FROM products WHERE id = 4312
SELECT * FROM products WHERE id = 777
SELECT * FROM products WHERE id = 4213
SELECT * FROM products WHERE id = 3881
SELECT * FROM products WHERE id = '1626'
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '1626'
SELECT * FROM productcustomimages WHERE product_id = '1626'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4041'
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4041'
SELECT * FROM productcustomimages WHERE product_id = '4041'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4312'
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4312'
SELECT * FROM productcustomimages WHERE product_id = '4312'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '777'
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '777'
SELECT * FROM productcustomimages WHERE product_id = '777'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '4213'
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '4213'
SELECT * FROM productcustomimages WHERE product_id = '4213'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '3881'
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '3881'
SELECT * FROM productcustomimages WHERE product_id = '3881'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0005	0.00045204162597656	SELECT parameter, value FROM parameters
2	0.0013	0.0013091564178467	SELECT * FROM `bad_bots`
3	0.0004	0.00035595893859863	SET time_zone = 'Europe/London'
4	0.0003	0.0003359317779541	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0008	0.00083208084106445	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"3.140.185.170\";}'
6	0.0007	0.0007021427154541	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1713297401'
7	0.0010	0.0010340213775635	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0005	0.00046992301940918	UPDATE autorun SET lastrun = '2024-04-16 19:56:41' WHERE id = '15'
9	0.0003	0.00028014183044434	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0006	0.00055599212646484	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
11	0.0009	0.00088787078857422	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
12	0.0010	0.0010139942169189	SELECT * FROM pages WHERE pagename = 'articles'
13	0.0006	0.00055289268493652	SELECT * FROM categorygroups ORDER BY sortorder ASC
14	0.0003	0.00033998489379883	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
15	0.0002	0.00022006034851074	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
16	0.0002	0.00024604797363281	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
17	0.0004	0.00041294097900391	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
18	0.0002	0.00022220611572266	SELECT id FROM categories WHERE parent_id = '26'
19	0.0002	0.00021886825561523	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
20	0.0002	0.00022196769714355	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
21	0.0003	0.00031185150146484	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
22	0.0002	0.00023698806762695	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
23	0.0003	0.0002601146697998	SELECT * FROM categorygroups WHERE id = '1'
24	0.0078	0.0077610015869141	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
25	0.0003	0.00026106834411621	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
26	0.0002	0.00024294853210449	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
27	0.0002	0.00023412704467773	SELECT id FROM categories WHERE parent_id = '27'
28	0.0062	0.0062429904937744	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
29	0.0003	0.00026392936706543	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
30	0.0002	0.0002448558807373	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
31	0.0002	0.00021815299987793	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
32	0.0003	0.00034213066101074	SELECT * FROM categorygroups WHERE id = '1'
33	0.0021	0.0021331310272217	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
34	0.0002	0.00024986267089844	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
35	0.0002	0.00022411346435547	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
36	0.0002	0.00022411346435547	SELECT id FROM categories WHERE parent_id = '28'
37	0.0021	0.0021169185638428	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
38	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 (28) AND p.disabled = 0
39	0.0004	0.00038695335388184	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
40	0.0006	0.0005500316619873	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
41	0.0006	0.00055694580078125	SELECT * FROM categorygroups WHERE id = '1'
42	0.0008	0.00081896781921387	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
43	0.0007	0.00073003768920898	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
44	0.0007	0.00073790550231934	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
45	0.0011	0.0011239051818848	SELECT id FROM categories WHERE parent_id = '29'
46	0.0011	0.0011420249938965	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
47	0.0011	0.0011429786682129	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
48	0.0011	0.0011320114135742	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
49	0.0011	0.0011239051818848	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
50	0.0017	0.0017020702362061	SELECT * FROM categorygroups WHERE id = '1'
51	0.0017	0.0017080307006836	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
52	0.0011	0.0011250972747803	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
53	0.0004	0.00038599967956543	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
54	0.0003	0.00027298927307129	SELECT id FROM categories WHERE parent_id = '30'
55	0.0008	0.00075793266296387	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
56	0.0003	0.00029182434082031	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
57	0.0004	0.00037002563476562	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
58	0.0003	0.00025796890258789	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
59	0.0003	0.00028300285339355	SELECT * FROM categorygroups WHERE id = '1'
60	0.0008	0.00078988075256348	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
61	0.0003	0.00026893615722656	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
62	0.0002	0.00023293495178223	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
63	0.0003	0.00027799606323242	SELECT id FROM categories WHERE parent_id = '31'
64	0.0009	0.00087308883666992	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
65	0.0003	0.00030303001403809	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
66	0.0006	0.00063204765319824	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
67	0.0003	0.00030398368835449	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
68	0.0003	0.00033402442932129	SELECT * FROM categorygroups WHERE id = '1'
69	0.0003	0.00034189224243164	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
70	0.0003	0.00027799606323242	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
71	0.0003	0.00030398368835449	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
72	0.0004	0.00038886070251465	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
73	0.0003	0.00029182434082031	SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
74	0.0003	0.00031304359436035	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
75	0.0007	0.00069594383239746	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
76	0.0777	0.077721118927002	SELECT * FROM ipgeocountries WHERE INET_ATON('3.140.185.170') >= INET_ATON(ip_start) AND INET_ATON('3.140.185.170') <= INET_ATON(ip_end)
77	0.0005	0.00046277046203613	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
78	0.0004	0.0003511905670166	SELECT * FROM countryredirects WHERE countrycode = 'US'
79	0.0006	0.00056004524230957	SELECT * FROM pages WHERE pagename = 'articles'
80	0.0012	0.0012099742889404	SELECT * FROM pages WHERE xmlsitemap = 1 AND core = 0 ORDER BY `created_on` DESC
81	0.0004	0.00038480758666992	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
82	0.0003	0.0002901554107666	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
83	0.0003	0.00034213066101074	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
84	0.0004	0.00043797492980957	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.0003	0.00031113624572754	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.0003	0.00029897689819336	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.00039911270141602	SELECT * FROM products WHERE id = 1626
88	0.0005	0.0005030632019043	SELECT * FROM products WHERE id = 4041
89	0.0005	0.00049090385437012	SELECT * FROM products WHERE id = 4312
90	0.0005	0.00051712989807129	SELECT * FROM products WHERE id = 777
91	0.0005	0.0004889965057373	SELECT * FROM products WHERE id = 4213
92	0.0010	0.00098013877868652	SELECT * FROM products WHERE id = 3881
93	0.0007	0.00073814392089844	SELECT * FROM products WHERE id = '1626'
94	0.0003	0.00031304359436035	SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
95	0.0003	0.00029993057250977	SELECT * FROM product_image_select WHERE product_id = '1626'
96	0.0003	0.00029897689819336	SELECT * FROM productcustomimages WHERE product_id = '1626'
97	0.0003	0.00030398368835449	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
98	0.0003	0.0003359317779541	SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
99	0.0003	0.0003211498260498	SELECT * FROM productoffers WHERE product_id = '1626' AND price > 0 ORDER BY price ASC LIMIT 1
100	0.0003	0.00030994415283203	SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
101	0.0004	0.00040888786315918	SELECT * FROM products WHERE id = '4041'
102	0.0003	0.00030708312988281	SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
103	0.0007	0.00074887275695801	SELECT * FROM product_image_select WHERE product_id = '4041'
104	0.0003	0.00030708312988281	SELECT * FROM productcustomimages WHERE product_id = '4041'
105	0.0003	0.00030994415283203	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
106	0.0003	0.0003049373626709	SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
107	0.0003	0.0003199577331543	SELECT * FROM productoffers WHERE product_id = '4041' AND price > 0 ORDER BY price ASC LIMIT 1
108	0.0003	0.00027799606323242	SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
109	0.0004	0.00040197372436523	SELECT * FROM products WHERE id = '4312'
110	0.0003	0.00029706954956055	SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
111	0.0003	0.00031399726867676	SELECT * FROM product_image_select WHERE product_id = '4312'
112	0.0004	0.00035691261291504	SELECT * FROM productcustomimages WHERE product_id = '4312'
113	0.0003	0.00031399726867676	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
114	0.0003	0.00031113624572754	SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
115	0.0003	0.0003199577331543	SELECT * FROM productoffers WHERE product_id = '4312' AND price > 0 ORDER BY price ASC LIMIT 1
116	0.0003	0.00029397010803223	SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
117	0.0004	0.00040102005004883	SELECT * FROM products WHERE id = '777'
118	0.0003	0.00029802322387695	SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
119	0.0003	0.00029397010803223	SELECT * FROM product_image_select WHERE product_id = '777'
120	0.0003	0.00029683113098145	SELECT * FROM productcustomimages WHERE product_id = '777'
121	0.0003	0.0003211498260498	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
122	0.0003	0.00031614303588867	SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
123	0.0003	0.00032901763916016	SELECT * FROM productoffers WHERE product_id = '777' AND price > 0 ORDER BY price ASC LIMIT 1
124	0.0003	0.00034809112548828	SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
125	0.0004	0.00040292739868164	SELECT * FROM products WHERE id = '4213'
126	0.0005	0.00050997734069824	SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
127	0.0003	0.00028204917907715	SELECT * FROM product_image_select WHERE product_id = '4213'
128	0.0003	0.00034403800964355	SELECT * FROM productcustomimages WHERE product_id = '4213'
129	0.0003	0.00034809112548828	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
130	0.0004	0.00035905838012695	SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
131	0.0004	0.00035715103149414	SELECT * FROM productoffers WHERE product_id = '4213' AND price > 0 ORDER BY price ASC LIMIT 1
132	0.0003	0.00029897689819336	SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
133	0.0004	0.00043201446533203	SELECT * FROM products WHERE id = '3881'
134	0.0006	0.00064182281494141	SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
135	0.0023	0.0022709369659424	SELECT * FROM product_image_select WHERE product_id = '3881'
136	0.0003	0.00032186508178711	SELECT * FROM productcustomimages WHERE product_id = '3881'
137	0.0003	0.00033402442932129	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
138	0.0003	0.00031590461730957	SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
139	0.0004	0.00039792060852051	SELECT * FROM productoffers WHERE product_id = '3881' AND price > 0 ORDER BY price ASC LIMIT 1
140	0.0003	0.00028705596923828	SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141	0.0004	0.00041794776916504	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
142	0.0004	0.00037813186645508	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
143	0.0006	0.00062894821166992	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
144	0.0005	0.00051283836364746	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
145	0.0006	0.00055980682373047	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
146	0.0006	0.00059294700622559	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
147	0.0005	0.00051093101501465	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'

Articles

Browse Categories

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.0169541835785 seconds

Query Debug - 147 Database Queries. Total time 0.1643 seconds

Articles

Browse Categories

Wait! We have a something for you...

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 1.0169541835785 seconds

Query Debug - 147 Database Queries. Total time 0.1643 seconds