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

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'