0 items

All Our Categories

Our full list of categories on the website is shown below. Simply click to view our products and find out more information on them.

Debug Overview

App Total Time	DB Queries	DB Query Total Time	Amazon Requests
0.4817521572113	220	0.0585	0

No Amazon API Requests Made.

App Debug - Total Time 0.4817521572113 seconds

Number	Time From Start	Name	Description
1	0.39925599098206	Initialise	Initialise FSB Function
2	0.39980816841125	App Controller Start	Start of the App controller (called before the controller of every page)
3	0.40414810180664	Start of getCategoryListByGroup Function	Before first category groups query
4	0.40423703193665	After initial query	Before first category groups query
5	0.40423703193665	Get Category List for Group	Before the call to getCategoryList function
6	0.40423917770386	Start of GetCategoryList function	Start of the function
7	0.40424108505249	Before getting categories	Query to get specific category list
8	0.40437412261963	After getting categories	Query to get specific category list
9	0.40437412261963	Before getting category custom	Before call to function getCategoryCustom
10	0.40543103218079	After getting category custom	After call to function getCategoryCustom
11	0.40543603897095	Before getting category custom	Before call to function getCategoryCustom
12	0.40644907951355	After getting category custom	After call to function getCategoryCustom
13	0.40645098686218	Before getting category custom	Before call to function getCategoryCustom
14	0.40752911567688	After getting category custom	After call to function getCategoryCustom
15	0.4075300693512	Before getting category custom	Before call to function getCategoryCustom
16	0.40844416618347	After getting category custom	After call to function getCategoryCustom
17	0.40844511985779	End of GetCategoryList function	End of the function
18	0.40844798088074	Get Category List for Group	Before the call to getCategoryList function
19	0.40844917297363	Start of GetCategoryList function	Start of the function
20	0.40845012664795	Before getting categories	Query to get specific category list
21	0.40855717658997	End of getCategoryListByGroup Function	Before return()
22	0.4378399848938	App Controller End	End of the App controller (called before the controller of every page)
23	0.43883800506592	Start of GetCategoryList function	Start of the function
24	0.43884110450745	Before getting categories	Query to get specific category list
25	0.43897700309753	After getting categories	Query to get specific category list
26	0.43897700309753	Before getting category custom	Before call to function getCategoryCustom
27	0.44001221656799	After getting category custom	After call to function getCategoryCustom
28	0.44001317024231	Before getting sub category list	Before call to recursive function getCategoryList
29	0.44001412391663	Start of GetCategoryList function	Start of the function
30	0.44001603126526	Before getting categories	Query to get specific category list
31	0.44013118743896	After getting sub category list	After call to recursive function getCategoryList
32	0.44013214111328	Before getting category custom	Before call to function getCategoryCustom
33	0.44118118286133	After getting category custom	After call to function getCategoryCustom
34	0.44118213653564	Before getting sub category list	Before call to recursive function getCategoryList
35	0.44118309020996	Start of GetCategoryList function	Start of the function
36	0.44118404388428	Before getting categories	Query to get specific category list
37	0.4412841796875	After getting sub category list	After call to recursive function getCategoryList
38	0.44128513336182	Before getting category custom	Before call to function getCategoryCustom
39	0.44241714477539	After getting category custom	After call to function getCategoryCustom
40	0.44241714477539	Before getting sub category list	Before call to recursive function getCategoryList
41	0.44241809844971	Start of GetCategoryList function	Start of the function
42	0.44241905212402	Before getting categories	Query to get specific category list
43	0.44251799583435	After getting sub category list	After call to recursive function getCategoryList
44	0.44251918792725	Before getting category custom	Before call to function getCategoryCustom
45	0.44344615936279	After getting category custom	After call to function getCategoryCustom
46	0.44344615936279	Before getting sub category list	Before call to recursive function getCategoryList
47	0.44344711303711	Start of GetCategoryList function	Start of the function
48	0.44344902038574	Before getting categories	Query to get specific category list
49	0.44354701042175	After getting sub category list	After call to recursive function getCategoryList
50	0.44354820251465	End of GetCategoryList function	End of the function
51	0.44692420959473	App_after Controller Start	Start of the App_after controller (called after the controller of every page)
52	0.4471480846405	Before Get Options	Before the call to getOptions in the tpl class
53	0.46119904518127	After Get Options	After the call to getOptions in the tpl class
54	0.46122598648071	App_after Controller End	End of the App_after controller (called after the controller of every page)
55	0.48174500465393	Finalizing debug	Before the debug is output to the page.
56	0.48175120353699	End of App	This is the end of the app logging, final timestamp

Query Debug - 220 Database Queries. Total time 0.0585 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:\"34.239.152.207\";}'
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679628062'
SELECT * FROM autorun ORDER BY lastrun ASC
UPDATE autorun SET lastrun = '2023-03-24 03:21:02' WHERE id = '13'
SELECT * FROM version ORDER BY installed DESC LIMIT 1
SELECT id FROM pages WHERE pagename = 'categories' LIMIT 1
SELECT * FROM pages WHERE id = 38
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
SELECT * FROM pages WHERE pagename = 'categories'
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 = 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 = 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 = 38
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
SELECT id FROM categories WHERE parent_id = '38'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  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 (38)
				  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 (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
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-fluid' 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 value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
SELECT * FROM countryredirects WHERE countrycode = 'US'
SELECT * FROM pages WHERE pagename = 'categories'
SELECT * FROM categories WHERE parent_id = '0'  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 = 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 * FROM categories WHERE parent_id = '27'  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 = 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 * FROM categories WHERE parent_id = '29'  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 = 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 * FROM categories WHERE parent_id = '30'  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 = 38
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
SELECT id FROM categories WHERE parent_id = '38'
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (38)
				  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 (38)
				  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 (38)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
SELECT * FROM categorygroups WHERE id = '1'
SELECT * FROM categories WHERE parent_id = '38'  AND hidden = 0 ORDER BY sortorder ASC
SELECT id FROM categories WHERE parent_id = '27'
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '770' 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 = 27
SELECT * FROM categoryimages WHERE category_id = 27
SELECT id FROM categories WHERE parent_id = '29'
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '825' 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 = 29
SELECT * FROM categoryimages WHERE category_id = 29
SELECT id FROM categories WHERE parent_id = '30'
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '785' 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 = 30
SELECT * FROM categoryimages WHERE category_id = 30
SELECT id FROM categories WHERE parent_id = '38'
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (38) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '7007' 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 = 38
SELECT * FROM categoryimages WHERE category_id = 38
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
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 * FROM pages WHERE id = 38
SELECT * FROM categories WHERE id = '27'
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(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 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(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_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 id FROM categories WHERE parent_id = '27'
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 27
SELECT * FROM categorygroups WHERE id = '1'
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '27'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
SELECT * FROM categories WHERE id = '30'
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(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 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(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_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 id FROM categories WHERE parent_id = '30'
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
SELECT * FROM categoryimages WHERE category_id = 30
SELECT * FROM categorygroups WHERE id = '1'
SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice
		FROM products p, products_categories c
		WHERE p.id = c.product_id
		  AND c.category_id = '30'
		  AND p.offers > 0
		  AND p.hidden = 0
		  AND p.enabled = 1
		  AND p.parent = 0
		  AND p.price > 0
SELECT * FROM pages WHERE id = 59
SELECT * FROM pages WHERE id = 55
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (32)) AND p.parent_id = 0
UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:0:\"\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"32\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1679628062;s:8:\"products\";a:0:{}}' WHERE id = '8'
SELECT DISTINCT p.id FROM products p, productoffers o
            WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (38)) AND p.parent_id = 0 LIMIT 3
UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"3\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"38\";}s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1679628062;s:8:\"products\";a:3:{i:0;s:11:\"7004|amazon\";i:1;s:11:\"7011|amazon\";i:2;s:11:\"7045|amazon\";}}' WHERE id = '16'
SELECT * FROM products WHERE id = 7004
SELECT * FROM products WHERE id = 7011
SELECT * FROM products WHERE id = 7045
SELECT * FROM products WHERE id = '7004'
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7004'
SELECT * FROM productcustomimages WHERE product_id = '7004'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT * FROM products WHERE id = '7011'
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
SELECT * FROM product_image_select WHERE product_id = '7011'
SELECT * FROM productcustomimages WHERE product_id = '7011'
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
SELECT * FROM products WHERE id = '7045'
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
SELECT * FROM product_image_select WHERE product_id = '7045'
SELECT * FROM productcustomimages WHERE product_id = '7045'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '7045'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '7045'
                GROUP BY o.product_id
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '7045'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '7045'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'

Number	Time (Seconds)	Time (Milliseconds)	Query
1	0.0002	0.00020813941955566	SELECT parameter, value FROM parameters
2	0.0003	0.00028014183044434	SELECT * FROM `bad_bots`
3	0.0002	0.00015115737915039	SET time_zone = 'Europe/London'
4	0.0001	9.3936920166016E-5	SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5	0.0001	0.00013613700866699	INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:14:\"34.239.152.207\";}'
6	0.0001	0.00010919570922852	INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1679628062'
7	0.0001	0.00012993812561035	SELECT * FROM autorun ORDER BY lastrun ASC
8	0.0004	0.00042390823364258	UPDATE autorun SET lastrun = '2023-03-24 03:21:02' WHERE id = '13'
9	0.0001	8.702278137207E-5	SELECT * FROM version ORDER BY installed DESC LIMIT 1
10	0.0001	0.00010418891906738	SELECT id FROM pages WHERE pagename = 'categories' LIMIT 1
11	0.0001	8.5830688476562E-5	SELECT * FROM pages WHERE id = 38
12	0.0003	0.00031399726867676	SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13	0.0035	0.0034608840942383	SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14	0.0001	0.00014019012451172	SELECT * FROM pages WHERE pagename = 'categories'
15	0.0001	7.9154968261719E-5	SELECT * FROM categorygroups ORDER BY sortorder ASC
16	0.0001	0.00011897087097168	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1' AND hidden = 0 ORDER BY sortorder ASC
17	0.0002	0.00020003318786621	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
18	0.0001	9.918212890625E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
19	0.0001	6.2227249145508E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20	0.0001	6.6041946411133E-5	SELECT id FROM categories WHERE parent_id = '27'
21	0.0002	0.00020694732666016	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
22	0.0001	9.9897384643555E-5	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
23	0.0001	9.7036361694336E-5	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
24	0.0001	6.413459777832E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25	0.0001	6.9856643676758E-5	SELECT * FROM categorygroups WHERE id = '1'
26	0.0002	0.00020003318786621	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
27	0.0001	8.9168548583984E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
28	0.0001	5.8174133300781E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29	0.0001	6.6041946411133E-5	SELECT id FROM categories WHERE parent_id = '29'
30	0.0002	0.00022983551025391	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
31	0.0001	7.5101852416992E-5	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
32	0.0001	8.392333984375E-5	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
33	0.0001	5.8889389038086E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34	0.0001	6.8902969360352E-5	SELECT * FROM categorygroups WHERE id = '1'
35	0.0002	0.00023388862609863	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
36	0.0001	8.6069107055664E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
37	0.0001	5.6982040405273E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38	0.0001	6.5088272094727E-5	SELECT id FROM categories WHERE parent_id = '30'
39	0.0003	0.00026988983154297	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
40	0.0001	7.3909759521484E-5	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
41	0.0001	8.2015991210938E-5	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
42	0.0001	5.793571472168E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43	0.0001	6.6995620727539E-5	SELECT * FROM categorygroups WHERE id = '1'
44	0.0002	0.0001530647277832	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 = 38
45	0.0001	8.702278137207E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
46	0.0001	5.7220458984375E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47	0.0001	6.413459777832E-5	SELECT id FROM categories WHERE parent_id = '38'
48	0.0002	0.00018811225891113	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (38) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
49	0.0001	7.5101852416992E-5	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (38) AND p.disabled = 0
50	0.0001	8.2015991210938E-5	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (38) AND c.prod_type = 'custom' AND cp.hide = 0
51	0.0001	5.8889389038086E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52	0.0001	6.7949295043945E-5	SELECT * FROM categorygroups WHERE id = '1'
53	0.0001	9.8943710327148E-5	SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2' AND hidden = 0 ORDER BY sortorder ASC
54	0.0004	0.0003669261932373	SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55	0.0002	0.00016689300537109	SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56	0.0002	0.00016212463378906	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
57	0.0002	0.00017690658569336	SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58	0.0003	0.00031304359436035	SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59	0.0272	0.027201890945435	SELECT * FROM ipgeocountries WHERE INET_ATON('34.239.152.207') >= INET_ATON(ip_start) AND INET_ATON('34.239.152.207') <= INET_ATON(ip_end)
60	0.0001	0.00014710426330566	SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61	0.0001	6.5803527832031E-5	SELECT * FROM countryredirects WHERE countrycode = 'US'
62	0.0001	0.00011801719665527	SELECT * FROM pages WHERE pagename = 'categories'
63	0.0001	0.0001220703125	SELECT * FROM categories WHERE parent_id = '0' AND hidden = 0 ORDER BY sortorder ASC
64	0.0002	0.00018692016601562	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
65	0.0001	0.00012588500976562	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
66	0.0001	6.0081481933594E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
67	0.0001	6.4849853515625E-5	SELECT id FROM categories WHERE parent_id = '27'
68	0.0002	0.00018501281738281	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
69	0.0001	9.2983245849609E-5	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
70	0.0001	8.6784362792969E-5	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
71	0.0001	5.793571472168E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
72	0.0001	7.6055526733398E-5	SELECT * FROM categorygroups WHERE id = '1'
73	0.0001	0.0001060962677002	SELECT * FROM categories WHERE parent_id = '27' AND hidden = 0 ORDER BY sortorder ASC
74	0.0002	0.00023198127746582	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
75	0.0001	8.702278137207E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
76	0.0001	5.6028366088867E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
77	0.0001	6.2942504882812E-5	SELECT id FROM categories WHERE parent_id = '29'
78	0.0002	0.0002138614654541	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
79	0.0001	7.2956085205078E-5	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
80	0.0001	8.9883804321289E-5	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
81	0.0001	7.9154968261719E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
82	0.0001	6.9141387939453E-5	SELECT * FROM categorygroups WHERE id = '1'
83	0.0001	9.2029571533203E-5	SELECT * FROM categories WHERE parent_id = '29' AND hidden = 0 ORDER BY sortorder ASC
84	0.0002	0.0002291202545166	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
85	0.0001	8.392333984375E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
86	0.0001	5.6028366088867E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
87	0.0001	7.3909759521484E-5	SELECT id FROM categories WHERE parent_id = '30'
88	0.0003	0.00025582313537598	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
89	0.0001	8.7976455688477E-5	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
90	0.0001	0.0001227855682373	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
91	0.0001	6.0796737670898E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
92	0.0001	6.6041946411133E-5	SELECT * FROM categorygroups WHERE id = '1'
93	0.0001	9.1075897216797E-5	SELECT * FROM categories WHERE parent_id = '30' AND hidden = 0 ORDER BY sortorder ASC
94	0.0002	0.00015091896057129	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 = 38
95	0.0001	9.608268737793E-5	SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 38
96	0.0001	7.1048736572266E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
97	0.0001	6.7949295043945E-5	SELECT id FROM categories WHERE parent_id = '38'
98	0.0002	0.00018119812011719	SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (38) AND p.parent_id = 0 AND p.hidden = 0 AND p.enabled = 1
99	0.0001	7.2002410888672E-5	SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c WHERE p.id = c.bundle_id AND c.category_id IN (38) AND p.disabled = 0
100	0.0001	7.9870223999023E-5	SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c WHERE cp.id = c.product_id AND c.category_id IN (38) AND c.prod_type = 'custom' AND cp.hide = 0
101	0.0001	5.6982040405273E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
102	0.0001	6.5088272094727E-5	SELECT * FROM categorygroups WHERE id = '1'
103	0.0001	9.1075897216797E-5	SELECT * FROM categories WHERE parent_id = '38' AND hidden = 0 ORDER BY sortorder ASC
104	0.0001	6.413459777832E-5	SELECT id FROM categories WHERE parent_id = '27'
105	0.0002	0.00019693374633789	SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
106	0.0001	0.00011897087097168	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
107	0.0002	0.00017809867858887	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
108	0.0001	7.5817108154297E-5	SELECT * FROM categoryimages WHERE category_id = 27
109	0.0001	6.1988830566406E-5	SELECT id FROM categories WHERE parent_id = '29'
110	0.0002	0.0002138614654541	SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (29) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
111	0.0001	0.00013494491577148	SELECT * FROM productimages WHERE product_id = '825' ORDER BY sortorder ASC
112	0.0002	0.00020098686218262	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
113	0.0001	7.0095062255859E-5	SELECT * FROM categoryimages WHERE category_id = 29
114	0.0001	7.4863433837891E-5	SELECT id FROM categories WHERE parent_id = '30'
115	0.0003	0.0003211498260498	SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
116	0.0001	0.00011897087097168	SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
117	0.0002	0.0002448558807373	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
118	0.0001	7.1048736572266E-5	SELECT * FROM categoryimages WHERE category_id = 30
119	0.0001	6.1988830566406E-5	SELECT id FROM categories WHERE parent_id = '38'
120	0.0002	0.00019407272338867	SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (38) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
121	0.0001	0.00011396408081055	SELECT * FROM productimages WHERE product_id = '7007' ORDER BY sortorder ASC
122	0.0001	0.00014901161193848	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 = 38
123	0.0001	6.8902969360352E-5	SELECT * FROM categoryimages WHERE category_id = 38
124	0.0001	0.00010204315185547	SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
125	0.0001	8.2015991210938E-5	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
126	0.0001	8.2015991210938E-5	SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
127	0.0001	9.7036361694336E-5	SELECT * FROM pages WHERE id = 38
128	0.0001	8.2015991210938E-5	SELECT * FROM categories WHERE id = '27'
129	0.0002	0.00015401840209961	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
130	0.0001	6.103515625E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
131	0.0001	6.2942504882812E-5	SELECT id FROM categories WHERE parent_id = '27'
132	0.0002	0.00016212463378906	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
133	0.0001	9.7036361694336E-5	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
134	0.0001	9.8943710327148E-5	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
135	0.0001	8.702278137207E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
136	0.0001	0.00014996528625488	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
137	0.0001	6.0081481933594E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
138	0.0002	0.00015878677368164	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
139	0.0001	7.1048736572266E-5	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
140	0.0001	8.2015991210938E-5	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
141	0.0001	5.6982040405273E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
142	0.0001	6.103515625E-5	SELECT id FROM categories WHERE parent_id = '27'
143	0.0002	0.00019621849060059	SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (27) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
144	0.0001	0.00014209747314453	SELECT * FROM productimages WHERE product_id = '770' ORDER BY sortorder ASC
145	0.0001	7.0095062255859E-5	SELECT * FROM categoryimages WHERE category_id = 27
146	0.0001	6.6995620727539E-5	SELECT * FROM categorygroups WHERE id = '1'
147	0.0002	0.00017619132995605	SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id = '27' AND p.offers > 0 AND p.hidden = 0 AND p.enabled = 1 AND p.parent = 0 AND p.price > 0
148	0.0001	8.2969665527344E-5	SELECT * FROM categories WHERE id = '30'
149	0.0002	0.00022411346435547	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
150	0.0001	6.9856643676758E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
151	0.0001	7.8916549682617E-5	SELECT id FROM categories WHERE parent_id = '30'
152	0.0003	0.00027298927307129	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
153	0.0001	7.2956085205078E-5	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
154	0.0001	8.082389831543E-5	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
155	0.0001	5.6028366088867E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
156	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 = 30
157	0.0001	5.8889389038086E-5	SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
158	0.0003	0.00028491020202637	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
159	0.0001	7.2956085205078E-5	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
160	0.0001	8.1777572631836E-5	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
161	0.0001	5.6028366088867E-5	SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
162	0.0001	6.1988830566406E-5	SELECT id FROM categories WHERE parent_id = '30'
163	0.0003	0.00025081634521484	SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (30) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
164	0.0001	0.00011515617370605	SELECT * FROM productimages WHERE product_id = '785' ORDER BY sortorder ASC
165	0.0001	7.7009201049805E-5	SELECT * FROM categoryimages WHERE category_id = 30
166	0.0001	8.0108642578125E-5	SELECT * FROM categorygroups WHERE id = '1'
167	0.0002	0.00024604797363281	SELECT MIN(p.price) as minprice, MAX(p.price) as maxprice FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id = '30' AND p.offers > 0 AND p.hidden = 0 AND p.enabled = 1 AND p.parent = 0 AND p.price > 0
168	0.0001	8.2969665527344E-5	SELECT * FROM pages WHERE id = 59
169	0.0001	8.392333984375E-5	SELECT * FROM pages WHERE id = 55
170	0.0001	0.00013589859008789	SELECT DISTINCT p.id FROM products p, productoffers o WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (32)) AND p.parent_id = 0
171	0.0001	9.7990036010742E-5	UPDATE template_options SET value = 'a:11:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:0:\"\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"32\";}s:10:\"updatetime\";s:1:\"0\";s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1679628062;s:8:\"products\";a:0:{}}' WHERE id = '8'
172	0.0002	0.00021100044250488	SELECT DISTINCT p.id FROM products p, productoffers o WHERE p.id IN (SELECT DISTINCT(pc.product_id) FROM products_categories pc WHERE pc.product_id = p.id AND pc.category_id IN (38)) AND p.parent_id = 0 LIMIT 3
173	0.0001	0.00012898445129395	UPDATE template_options SET value = 'a:10:{s:14:\"populationtype\";s:9:\"automatic\";s:12:\"productcount\";s:1:\"3\";s:12:\"maxsalesrank\";s:0:\"\";s:8:\"minprice\";s:1:\"0\";s:8:\"maxprice\";s:1:\"0\";s:9:\"minimages\";s:0:\"\";s:10:\"categories\";a:1:{i:0;s:2:\"38\";}s:13:\"selectiontype\";s:6:\"random\";s:11:\"lastupdated\";i:1679628062;s:8:\"products\";a:3:{i:0;s:11:\"7004\|amazon\";i:1;s:11:\"7011\|amazon\";i:2;s:11:\"7045\|amazon\";}}' WHERE id = '16'
174	0.0001	0.00011396408081055	SELECT * FROM products WHERE id = 7004
175	0.0001	0.00010299682617188	SELECT * FROM products WHERE id = 7011
176	0.0001	9.9897384643555E-5	SELECT * FROM products WHERE id = 7045
177	0.0001	0.00010395050048828	SELECT * FROM products WHERE id = '7004'
178	0.0001	0.00011396408081055	SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
179	0.0001	0.00014400482177734	SELECT * FROM product_image_select WHERE product_id = '7004'
180	0.0001	0.00010299682617188	SELECT * FROM productcustomimages WHERE product_id = '7004'
181	0.0005	0.00051307678222656	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
182	0.0001	0.00014519691467285	SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
183	0.0001	0.00014209747314453	SELECT * FROM productoffers WHERE product_id = '7004' AND price > 0 ORDER BY price ASC LIMIT 1
184	0.0001	0.00014901161193848	SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185	0.0001	0.00011610984802246	SELECT * FROM products WHERE id = '7011'
186	0.0001	9.7990036010742E-5	SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
187	0.0001	0.00012993812561035	SELECT * FROM product_image_select WHERE product_id = '7011'
188	0.0001	8.4877014160156E-5	SELECT * FROM productcustomimages WHERE product_id = '7011'
189	0.0006	0.0005640983581543	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
190	0.0001	9.2029571533203E-5	SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
191	0.0001	9.6797943115234E-5	SELECT * FROM productoffers WHERE product_id = '7011' AND price > 0 ORDER BY price ASC LIMIT 1
192	0.0001	9.0837478637695E-5	SELECT * FROM productoffers WHERE product_id = 7011 ORDER BY price ASC LIMIT 1
193	0.0001	0.00010800361633301	SELECT value FROM productattributes WHERE product_id = '7011' AND name = 'ListPriceAmount'
194	0.0001	0.00010895729064941	SELECT * FROM products WHERE id = '7045'
195	0.0001	0.00010395050048828	SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
196	0.0001	0.00013089179992676	SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '7045' AND p.id = pi.product_id ORDER BY pi.sortorder
197	0.0001	0.00013089179992676	SELECT * FROM product_image_select WHERE product_id = '7045'
198	0.0001	8.5115432739258E-5	SELECT * FROM productcustomimages WHERE product_id = '7045'
199	0.0001	0.00012898445129395	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '7045' GROUP BY o.product_id
200	0.0002	0.00016999244689941	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '7045' GROUP BY n.displayname ORDER BY n.displayname DESC
201	0.0001	0.0001070499420166	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
202	0.0006	0.0005791187286377	SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
203	0.0001	9.1075897216797E-5	SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
204	0.0001	9.7036361694336E-5	SELECT * FROM productoffers WHERE product_id = '7045' AND price > 0 ORDER BY price ASC LIMIT 1
205	0.0001	8.9883804321289E-5	SELECT * FROM productoffers WHERE product_id = 7045 ORDER BY price ASC LIMIT 1
206	0.0001	0.00010395050048828	SELECT value FROM productattributes WHERE product_id = '7045' AND name = 'ListPriceAmount'
207	0.0001	0.00014495849609375	SELECT o.product_id, MIN(o.price) as price, p.customprice FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = '7045' GROUP BY o.product_id
208	0.0002	0.00015616416931152	SELECT n.displayname, o.name FROM productoptionnames n, productoptions o, products p WHERE n.originalname = o.name AND o.product_id = p.id AND p.parent_id = '7045' GROUP BY n.displayname ORDER BY n.displayname DESC
209	0.0001	0.00010490417480469	SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 7045
210	0.0001	0.00013494491577148	SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211	0.0001	0.00014185905456543	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '7045' AND p.id = o.product_id AND o.name = 'Size' GROUP BY o.value ORDER BY o.value ASC
212	0.0001	0.00013899803161621	SELECT o.value FROM products p, productoptions o WHERE p.parent_id = '7045' AND p.id = o.product_id AND o.name = 'Color' GROUP BY o.value ORDER BY o.value ASC
213	0.0002	0.00022006034851074	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
214	0.0002	0.00016903877258301	SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
215	0.0003	0.00029492378234863	SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
216	0.0002	0.0001528263092041	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
217	0.0002	0.0001530647277832	SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
218	0.0002	0.00020599365234375	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
219	0.0001	0.0001380443572998	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
220	0.0001	0.0001218318939209	SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'

All Our Categories

Books

Home & Kitchen

Military Kids

Lawyer Gift Mugs

Connect with Us!

Browse Categories

Connect with us!

Debug Overview

No Amazon API Requests Made.

App Debug - Total Time 0.4817521572113 seconds

Query Debug - 220 Database Queries. Total time 0.0585 seconds