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.55607891082764 220 0.1295 0


No Amazon API Requests Made.


App Debug - Total Time 0.55607891082764 seconds

Number Time From Start Name Description
1 0.37969207763672 Initialise Initialise FSB Function
2 0.38073897361755 App Controller Start Start of the App controller (called before the controller of every page)
3 0.38773584365845 Start of getCategoryListByGroup Function Before first category groups query
4 0.387934923172 After initial query Before first category groups query
5 0.38793587684631 Get Category List for Group Before the call to getCategoryList function
6 0.38793897628784 Start of GetCategoryList function Start of the function
7 0.38794207572937 Before getting categories Query to get specific category list
8 0.38824391365051 After getting categories Query to get specific category list
9 0.38824486732483 Before getting category custom Before call to function getCategoryCustom
10 0.38990688323975 After getting category custom After call to function getCategoryCustom
11 0.38990807533264 Before getting category custom Before call to function getCategoryCustom
12 0.39112687110901 After getting category custom After call to function getCategoryCustom
13 0.39112901687622 Before getting category custom Before call to function getCategoryCustom
14 0.39241290092468 After getting category custom After call to function getCategoryCustom
15 0.39241504669189 Before getting category custom Before call to function getCategoryCustom
16 0.39349484443665 After getting category custom After call to function getCategoryCustom
17 0.39349603652954 End of GetCategoryList function End of the function
18 0.39349985122681 Get Category List for Group Before the call to getCategoryList function
19 0.3935010433197 Start of GetCategoryList function Start of the function
20 0.39350295066833 Before getting categories Query to get specific category list
21 0.39363884925842 End of getCategoryListByGroup Function Before return()
22 0.45546197891235 App Controller End End of the App controller (called before the controller of every page)
23 0.45847296714783 Start of GetCategoryList function Start of the function
24 0.45847702026367 Before getting categories Query to get specific category list
25 0.45867586135864 After getting categories Query to get specific category list
26 0.45867800712585 Before getting category custom Before call to function getCategoryCustom
27 0.45990490913391 After getting category custom After call to function getCategoryCustom
28 0.45990705490112 Before getting sub category list Before call to recursive function getCategoryList
29 0.45990800857544 Start of GetCategoryList function Start of the function
30 0.45990896224976 Before getting categories Query to get specific category list
31 0.46002697944641 After getting sub category list After call to recursive function getCategoryList
32 0.46002793312073 Before getting category custom Before call to function getCategoryCustom
33 0.46119785308838 After getting category custom After call to function getCategoryCustom
34 0.46119904518127 Before getting sub category list Before call to recursive function getCategoryList
35 0.46119999885559 Start of GetCategoryList function Start of the function
36 0.46120095252991 Before getting categories Query to get specific category list
37 0.4613299369812 After getting sub category list After call to recursive function getCategoryList
38 0.46133089065552 Before getting category custom Before call to function getCategoryCustom
39 0.4625780582428 After getting category custom After call to function getCategoryCustom
40 0.46257901191711 Before getting sub category list Before call to recursive function getCategoryList
41 0.46257996559143 Start of GetCategoryList function Start of the function
42 0.46258091926575 Before getting categories Query to get specific category list
43 0.46269392967224 After getting sub category list After call to recursive function getCategoryList
44 0.46269488334656 Before getting category custom Before call to function getCategoryCustom
45 0.46373105049133 After getting category custom After call to function getCategoryCustom
46 0.46373200416565 Before getting sub category list Before call to recursive function getCategoryList
47 0.46373200416565 Start of GetCategoryList function Start of the function
48 0.46373391151428 Before getting categories Query to get specific category list
49 0.46384787559509 After getting sub category list After call to recursive function getCategoryList
50 0.46384787559509 End of GetCategoryList function End of the function
51 0.47170686721802 App_after Controller Start Start of the App_after controller (called after the controller of every page)
52 0.47324299812317 Before Get Options Before the call to getOptions in the tpl class
53 0.51737284660339 After Get Options After the call to getOptions in the tpl class
54 0.51742100715637 App_after Controller End End of the App_after controller (called after the controller of every page)
55 0.55606889724731 Finalizing debug Before the debug is output to the page.
56 0.55607891082764 End of App This is the end of the app logging, final timestamp


Query Debug - 220 Database Queries. Total time 0.1295 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0003 0.00028395652770996
SELECT parameter, value FROM parameters
2 0.0008 0.00077486038208008
SELECT * FROM `bad_bots`
3 0.0002 0.00015807151794434
SET time_zone = 'Europe/London'
4 0.0002 0.00018310546875
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0006 0.00062203407287598
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.238.95.208\";}'
6 0.0005 0.00053286552429199
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1632269025'
7 0.0004 0.00037598609924316
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0005 0.00047779083251953
UPDATE autorun SET lastrun = '2021-09-22 00:03:45' WHERE id = '17'
9 0.0001 0.0001380443572998
SELECT * FROM version ORDER BY installed DESC LIMIT 1
10 0.0002 0.00019383430480957
SELECT id FROM pages WHERE pagename = 'categories' LIMIT 1
11 0.0001 0.00011491775512695
SELECT * FROM pages WHERE id = 38
12 0.0004 0.00037789344787598
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid'
13 0.0059 0.0058810710906982
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND language = 'en'
14 0.0002 0.00022220611572266
SELECT * FROM pages WHERE pagename = 'categories'
15 0.0002 0.00018501281738281
SELECT * FROM categorygroups ORDER BY sortorder ASC
16 0.0003 0.00026607513427734
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
17 0.0004 0.00035381317138672
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.0002 0.00019001960754395
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 0.00012707710266113
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
20 0.0001 8.7976455688477E-5
SELECT id FROM categories WHERE parent_id = '27'
21 0.0002 0.00024104118347168
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 0.00014376640319824
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.0002 0.00018095970153809
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 0.00013184547424316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
25 0.0001 8.7976455688477E-5
SELECT * FROM categorygroups WHERE id = '1'
26 0.0002 0.00023889541625977
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 0.00011396408081055
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 7.4148178100586E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
29 0.0001 8.392333984375E-5
SELECT id FROM categories WHERE parent_id = '29'
30 0.0003 0.00026607513427734
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 8.6069107055664E-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 9.9897384643555E-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 7.7009201049805E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
34 0.0001 8.5830688476562E-5
SELECT * FROM categorygroups WHERE id = '1'
35 0.0003 0.00028491020202637
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 0.00010013580322266
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 8.3208084106445E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
38 0.0001 8.2969665527344E-5
SELECT id FROM categories WHERE parent_id = '30'
39 0.0003 0.00029087066650391
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 8.4877014160156E-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 9.7990036010742E-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 7.319450378418E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
43 0.0001 8.6069107055664E-5
SELECT * FROM categorygroups WHERE id = '1'
44 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 = 38
45 0.0001 9.7990036010742E-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 7.2002410888672E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
47 0.0001 8.2015991210938E-5
SELECT id FROM categories WHERE parent_id = '38'
48 0.0002 0.00019001960754395
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 8.2969665527344E-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 0.00011205673217773
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 7.2002410888672E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
52 0.0001 8.5115432739258E-5
SELECT * FROM categorygroups WHERE id = '1'
53 0.0001 0.00012612342834473
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
54 0.0005 0.00049495697021484
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
55 0.0005 0.0004580020904541
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
56 0.0002 0.00017809867858887
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.00022006034851074
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid' AND optionuid = 'DISPLAY_CREDIT_ICON'
58 0.0003 0.00033712387084961
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
59 0.0579 0.057906866073608
SELECT * FROM ipgeocountries WHERE INET_ATON('3.238.95.208') >= INET_ATON(ip_start) AND INET_ATON('3.238.95.208') <= INET_ATON(ip_end)
60 0.0006 0.00059604644775391
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
61 0.0002 0.00015878677368164
SELECT * FROM countryredirects WHERE countrycode = 'US'
62 0.0002 0.00019192695617676
SELECT * FROM pages WHERE pagename = 'categories'
63 0.0002 0.00018215179443359
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY sortorder ASC
64 0.0002 0.00024104118347168
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.00011491775512695
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 7.7009201049805E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
67 0.0001 0.00010108947753906
SELECT id FROM categories WHERE parent_id = '27'
68 0.0002 0.00022006034851074
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.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 
70 0.0001 0.00010085105895996
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 7.2956085205078E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
72 0.0001 8.6069107055664E-5
SELECT * FROM categorygroups WHERE id = '1'
73 0.0001 0.00011014938354492
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
74 0.0002 0.00024676322937012
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 0.0001060962677002
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 6.8902969360352E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
77 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '29'
78 0.0002 0.0002439022064209
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 8.1777572631836E-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 9.608268737793E-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 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
82 0.0001 8.2015991210938E-5
SELECT * FROM categorygroups WHERE id = '1'
83 0.0001 0.00012016296386719
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
84 0.0003 0.00028181076049805
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 9.2983245849609E-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 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
87 0.0001 7.7009201049805E-5
SELECT id FROM categories WHERE parent_id = '30'
88 0.0003 0.00028395652770996
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 9.7990036010742E-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 9.2983245849609E-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
91 0.0001 6.9141387939453E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
92 0.0001 7.9870223999023E-5
SELECT * FROM categorygroups WHERE id = '1'
93 0.0001 0.00010514259338379
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
94 0.0002 0.00017189979553223
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.2983245849609E-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 6.7949295043945E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 38
97 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '38'
98 0.0002 0.00020790100097656
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 8.082389831543E-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 9.3936920166016E-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 7.7009201049805E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '38'
102 0.0001 8.0108642578125E-5
SELECT * FROM categorygroups WHERE id = '1'
103 0.0001 0.0001070499420166
SELECT * FROM categories WHERE parent_id = '38'  AND hidden = 0 ORDER BY sortorder ASC
104 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '27'
105 0.0007 0.00072407722473145
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.0018 0.0018489360809326
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
107 0.0002 0.00019502639770508
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.0005 0.00054693222045898
SELECT * FROM categoryimages WHERE category_id = 27
109 0.0001 7.9870223999023E-5
SELECT id FROM categories WHERE parent_id = '29'
110 0.0003 0.0002751350402832
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.0006 0.00057387351989746
SELECT * FROM productimages WHERE product_id = '790' ORDER BY sortorder ASC
112 0.0002 0.00023221969604492
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 9.2029571533203E-5
SELECT * FROM categoryimages WHERE category_id = 29
114 0.0001 7.8916549682617E-5
SELECT id FROM categories WHERE parent_id = '30'
115 0.0003 0.00029587745666504
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.00012016296386719
SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
117 0.0003 0.00030899047851562
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 8.0108642578125E-5
SELECT * FROM categoryimages WHERE category_id = 30
119 0.0001 8.7976455688477E-5
SELECT id FROM categories WHERE parent_id = '38'
120 0.0002 0.0001981258392334
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.0003 0.00033092498779297
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
122 0.0002 0.00018787384033203
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 8.2015991210938E-5
SELECT * FROM categoryimages WHERE category_id = 38
124 0.0006 0.00057196617126465
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid'
125 0.0014 0.0013539791107178
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 0.00010991096496582
SELECT * FROM pages WHERE id = 38
128 0.0001 0.00010585784912109
SELECT * FROM categories WHERE id = '27'
129 0.0002 0.00018405914306641
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 7.2956085205078E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
131 0.0001 7.7962875366211E-5
SELECT id FROM categories WHERE parent_id = '27'
132 0.0002 0.00020003318786621
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.8943710327148E-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.7990036010742E-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 6.9856643676758E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
136 0.0002 0.00018477439880371
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.9141387939453E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
138 0.0002 0.0001838207244873
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 8.6069107055664E-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 9.5129013061523E-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 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
142 0.0001 9.2983245849609E-5
SELECT id FROM categories WHERE parent_id = '27'
143 0.0002 0.0001990795135498
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.00014901161193848
SELECT * FROM productimages WHERE product_id = '819' ORDER BY sortorder ASC
145 0.0001 8.2969665527344E-5
SELECT * FROM categoryimages WHERE category_id = 27
146 0.0001 8.2969665527344E-5
SELECT * FROM categorygroups WHERE id = '1'
147 0.0002 0.00020194053649902
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 9.2029571533203E-5
SELECT * FROM categories WHERE id = '30'
149 0.0003 0.00028896331787109
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.8187713623047E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
151 0.0001 8.4877014160156E-5
SELECT id FROM categories WHERE parent_id = '30'
152 0.0003 0.00027894973754883
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.9870223999023E-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 9.2983245849609E-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 6.8902969360352E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
156 0.0003 0.00028491020202637
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 6.6995620727539E-5
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
158 0.0003 0.00027704238891602
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.8201293945312E-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 9.608268737793E-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 6.7949295043945E-5
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
162 0.0001 9.6797943115234E-5
SELECT id FROM categories WHERE parent_id = '30'
163 0.0003 0.00029897689819336
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.00012898445129395
SELECT * FROM productimages WHERE product_id = '775' ORDER BY sortorder ASC
165 0.0001 7.9870223999023E-5
SELECT * FROM categoryimages WHERE category_id = 30
166 0.0001 8.1062316894531E-5
SELECT * FROM categorygroups WHERE id = '1'
167 0.0003 0.00028800964355469
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 0.00010895729064941
SELECT * FROM pages WHERE id = 59
169 0.0001 9.918212890625E-5
SELECT * FROM pages WHERE id = 55
170 0.0004 0.00043392181396484
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 0.00013017654418945
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:1632269026;s:8:\"products\";a:0:{}}' WHERE id = '8'
172 0.0002 0.00023293495178223
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.00010085105895996
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:1632269026;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.0001380443572998
SELECT * FROM products WHERE id = 7004
175 0.0001 0.00011396408081055
SELECT * FROM products WHERE id = 7011
176 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = 7045
177 0.0001 0.00011205673217773
SELECT * FROM products WHERE id = '7004'
178 0.0001 0.00013208389282227
SELECT * FROM productimages WHERE product_id = '7004' ORDER BY sortorder ASC
179 0.0006 0.00064587593078613
SELECT * FROM product_image_select WHERE product_id = '7004'
180 0.0006 0.0005638599395752
SELECT * FROM productcustomimages WHERE product_id = '7004'
181 0.0198 0.019829988479614
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7004' AND a.name = n.originalname
182 0.0005 0.00047492980957031
SELECT * FROM productoffers WHERE product_id = '7004' AND merchantid = 'ATVPDKIKX0DER'
183 0.0002 0.00019598007202148
SELECT * FROM productoffers
                WHERE product_id = '7004' AND price > 0
                ORDER BY price ASC LIMIT 1
184 0.0002 0.0001828670501709
SELECT value FROM productattributes WHERE product_id = '7004' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
185 0.0002 0.00015902519226074
SELECT * FROM products WHERE id = '7011'
186 0.0001 0.00012898445129395
SELECT * FROM productimages WHERE product_id = '7011' ORDER BY sortorder ASC
187 0.0002 0.00017094612121582
SELECT * FROM product_image_select WHERE product_id = '7011'
188 0.0001 0.00012779235839844
SELECT * FROM productcustomimages WHERE product_id = '7011'
189 0.0011 0.0010948181152344
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7011' AND a.name = n.originalname
190 0.0001 0.00011777877807617
SELECT * FROM productoffers WHERE product_id = '7011' AND merchantid = 'ATVPDKIKX0DER'
191 0.0001 0.00012302398681641
SELECT * FROM productoffers
                WHERE product_id = '7011' AND price > 0
                ORDER BY price ASC LIMIT 1
192 0.0001 0.0001060962677002
SELECT * FROM productoffers
                WHERE product_id = 7011
                ORDER BY price ASC LIMIT 1
193 0.0001 0.00012779235839844
SELECT value FROM productattributes
                WHERE product_id = '7011'
                AND name = 'ListPriceAmount'
194 0.0001 0.00013113021850586
SELECT * FROM products WHERE id = '7045'
195 0.0001 0.00012016296386719
SELECT * FROM productimages WHERE product_id = '7045' ORDER BY sortorder ASC
196 0.0002 0.00016403198242188
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.0002 0.00015997886657715
SELECT * FROM product_image_select WHERE product_id = '7045'
198 0.0001 0.00010204315185547
SELECT * FROM productcustomimages WHERE product_id = '7045'
199 0.0002 0.00015616416931152
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.0013 0.0012722015380859
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.00013113021850586
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.0009 0.00085306167602539
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '7045' AND a.name = n.originalname
203 0.0001 0.0001070499420166
SELECT * FROM productoffers WHERE product_id = '7045' AND merchantid = 'ATVPDKIKX0DER'
204 0.0001 0.00011014938354492
SELECT * FROM productoffers
                WHERE product_id = '7045' AND price > 0
                ORDER BY price ASC LIMIT 1
205 0.0001 0.00011897087097168
SELECT * FROM productoffers
                WHERE product_id = 7045
                ORDER BY price ASC LIMIT 1
206 0.0001 0.00012493133544922
SELECT value FROM productattributes
                WHERE product_id = '7045'
                AND name = 'ListPriceAmount'
207 0.0001 0.00013899803161621
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.00017690658569336
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.00012898445129395
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.0002 0.00016593933105469
SELECT value FROM productattributes WHERE product_id = '7045' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
211 0.0002 0.00017499923706055
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.0002 0.00015616416931152
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.0008 0.00082206726074219
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'header' ORDER BY sortorder ASC
214 0.0002 0.0001981258392334
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND area = 'footer' ORDER BY sortorder ASC
215 0.0017 0.0016500949859619
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid' AND skinuid = ''
216 0.0007 0.0006709098815918
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
217 0.0002 0.00017905235290527
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid'
218 0.0003 0.00025701522827148
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
219 0.0002 0.00021910667419434
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'
220 0.0002 0.00015807151794434
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid' AND imageuid = 'HEAD_LOGO'