0

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
1.5157949924469 238 0.8227 0


No Amazon API Requests Made.


App Debug - Total Time 1.5157949924469 seconds

Number Time From Start Name Description
1 0.54312610626221 Initialise Initialise FSB Function
2 0.54631900787354 App Controller Start Start of the App controller (called before the controller of every page)
3 0.58329296112061 Start of getCategoryListByGroup Function Before first category groups query
4 0.5840151309967 After initial query Before first category groups query
5 0.58401703834534 Get Category List for Group Before the call to getCategoryList function
6 0.58402109146118 Start of GetCategoryList function Start of the function
7 0.58402514457703 Before getting categories Query to get specific category list
8 0.58485293388367 After getting categories Query to get specific category list
9 0.58485412597656 Before getting category custom Before call to function getCategoryCustom
10 0.60558009147644 After getting category custom After call to function getCategoryCustom
11 0.6055850982666 Before getting category custom Before call to function getCategoryCustom
12 0.61763501167297 After getting category custom After call to function getCategoryCustom
13 0.61764097213745 Before getting category custom Before call to function getCategoryCustom
14 0.62479305267334 After getting category custom After call to function getCategoryCustom
15 0.6247980594635 Before getting category custom Before call to function getCategoryCustom
16 0.63021111488342 After getting category custom After call to function getCategoryCustom
17 0.63021492958069 Before getting category custom Before call to function getCategoryCustom
18 0.63559007644653 After getting category custom After call to function getCategoryCustom
19 0.63559412956238 Before getting category custom Before call to function getCategoryCustom
20 0.64084506034851 After getting category custom After call to function getCategoryCustom
21 0.64085006713867 End of GetCategoryList function End of the function
22 0.64086008071899 Get Category List for Group Before the call to getCategoryList function
23 0.64086294174194 Start of GetCategoryList function Start of the function
24 0.64086699485779 Before getting categories Query to get specific category list
25 0.6414589881897 End of getCategoryListByGroup Function Before return()
26 1.1820039749146 App Controller End End of the App controller (called before the controller of every page)
27 1.1981689929962 Start of GetCategoryList function Start of the function
28 1.1981749534607 Before getting categories Query to get specific category list
29 1.1992559432983 After getting categories Query to get specific category list
30 1.1992580890656 Before getting category custom Before call to function getCategoryCustom
31 1.2204051017761 After getting category custom After call to function getCategoryCustom
32 1.2204079627991 Before getting sub category list Before call to recursive function getCategoryList
33 1.2204120159149 Start of GetCategoryList function Start of the function
34 1.2204160690308 Before getting categories Query to get specific category list
35 1.221363067627 After getting sub category list After call to recursive function getCategoryList
36 1.2213671207428 Before getting category custom Before call to function getCategoryCustom
37 1.2389330863953 After getting category custom After call to function getCategoryCustom
38 1.2389359474182 Before getting sub category list Before call to recursive function getCategoryList
39 1.2389380931854 Start of GetCategoryList function Start of the function
40 1.2389421463013 Before getting categories Query to get specific category list
41 1.239541053772 After getting sub category list After call to recursive function getCategoryList
42 1.2395451068878 Before getting category custom Before call to function getCategoryCustom
43 1.2473630905151 After getting category custom After call to function getCategoryCustom
44 1.2473649978638 Before getting sub category list Before call to recursive function getCategoryList
45 1.2473680973053 Start of GetCategoryList function Start of the function
46 1.2473709583282 Before getting categories Query to get specific category list
47 1.247967004776 After getting sub category list After call to recursive function getCategoryList
48 1.2479701042175 Before getting category custom Before call to function getCategoryCustom
49 1.2532999515533 After getting category custom After call to function getCategoryCustom
50 1.2533020973206 Before getting sub category list Before call to recursive function getCategoryList
51 1.2533040046692 Start of GetCategoryList function Start of the function
52 1.2533071041107 Before getting categories Query to get specific category list
53 1.2539911270142 After getting sub category list After call to recursive function getCategoryList
54 1.2539939880371 Before getting category custom Before call to function getCategoryCustom
55 1.2593641281128 After getting category custom After call to function getCategoryCustom
56 1.2593669891357 Before getting sub category list Before call to recursive function getCategoryList
57 1.259369134903 Start of GetCategoryList function Start of the function
58 1.2593719959259 Before getting categories Query to get specific category list
59 1.259978055954 After getting sub category list After call to recursive function getCategoryList
60 1.2599809169769 Before getting category custom Before call to function getCategoryCustom
61 1.2655880451202 After getting category custom After call to function getCategoryCustom
62 1.2655899524689 Before getting sub category list Before call to recursive function getCategoryList
63 1.2655920982361 Start of GetCategoryList function Start of the function
64 1.2655959129333 Before getting categories Query to get specific category list
65 1.2662110328674 After getting sub category list After call to recursive function getCategoryList
66 1.2662150859833 End of GetCategoryList function End of the function
67 1.2997279167175 App_after Controller Start Start of the App_after controller (called after the controller of every page)
68 1.3007509708405 Before Get Options Before the call to getOptions in the tpl class
69 1.37508893013 After Get Options After the call to getOptions in the tpl class
70 1.3751349449158 App_after Controller End End of the App_after controller (called after the controller of every page)
71 1.5157780647278 Finalizing debug Before the debug is output to the page.
72 1.5157930850983 End of App This is the end of the app logging, final timestamp


Query Debug - 238 Database Queries. Total time 0.8227 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0026 0.0026278495788574
SELECT parameter, value FROM parameters
2 0.0065 0.0065281391143799
SELECT * FROM `bad_bots`
3 0.0005 0.00051403045654297
SET time_zone = 'Europe/London'
4 0.0010 0.0010001659393311
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0012 0.0012450218200684
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:12:\"3.142.156.67\";}'
6 0.0009 0.00094389915466309
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1722056230'
7 0.0015 0.0014619827270508
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0008 0.00077700614929199
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0009 0.00093698501586914
SELECT id FROM pages WHERE pagename = 'categories' LIMIT 1
10 0.0006 0.00058984756469727
SELECT * FROM pages WHERE id = 40
11 0.0028 0.0027768611907959
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0327 0.032678842544556
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0010 0.0010101795196533
SELECT * FROM pages WHERE pagename = 'categories'
14 0.0007 0.00071001052856445
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0008 0.00080704689025879
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0077 0.0076780319213867
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0009 0.00090503692626953
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0006 0.00060296058654785
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0007 0.0007331371307373
SELECT id FROM categories WHERE parent_id = '26'
20 0.0076 0.0076019763946533
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
21 0.0009 0.00093698501586914
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
22 0.0008 0.00080609321594238
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0007 0.00065803527832031
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0006 0.00063896179199219
SELECT * FROM categorygroups WHERE id = '1'
25 0.0038 0.0038340091705322
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
26 0.0006 0.00059294700622559
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0005 0.00046205520629883
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0005 0.00049400329589844
SELECT id FROM categories WHERE parent_id = '27'
29 0.0040 0.0040209293365479
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 
30 0.0007 0.0007481575012207
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 
31 0.0006 0.00063514709472656
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
32 0.0006 0.00058293342590332
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0005 0.00051498413085938
SELECT * FROM categorygroups WHERE id = '1'
34 0.0016 0.0015759468078613
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0006 0.00059890747070312
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0005 0.0004889965057373
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0005 0.00048708915710449
SELECT id FROM categories WHERE parent_id = '28'
38 0.0016 0.0016379356384277
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
39 0.0006 0.00056314468383789
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
40 0.0006 0.00058197975158691
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0006 0.00058388710021973
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0005 0.0004889965057373
SELECT * FROM categorygroups WHERE id = '1'
43 0.0007 0.00068783760070801
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
44 0.0006 0.0005640983581543
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0005 0.00050497055053711
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0005 0.00053882598876953
SELECT id FROM categories WHERE parent_id = '29'
47 0.0007 0.00073099136352539
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 
48 0.0006 0.00061392784118652
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 
49 0.0006 0.00064396858215332
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
50 0.0005 0.0005030632019043
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0005 0.00048184394836426
SELECT * FROM categorygroups WHERE id = '1'
52 0.0007 0.00068783760070801
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
53 0.0005 0.00053715705871582
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0004 0.00042510032653809
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0005 0.00047993659973145
SELECT id FROM categories WHERE parent_id = '30'
56 0.0008 0.00075078010559082
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 
57 0.0005 0.00053191184997559
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 
58 0.0008 0.00082087516784668
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
59 0.0006 0.00056910514831543
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0005 0.00045585632324219
SELECT * FROM categorygroups WHERE id = '1'
61 0.0007 0.00066208839416504
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0006 0.00055599212646484
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0004 0.00043821334838867
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0005 0.00045895576477051
SELECT id FROM categories WHERE parent_id = '31'
65 0.0008 0.00083684921264648
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
66 0.0005 0.00054192543029785
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
67 0.0006 0.00057291984558105
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0005 0.0005180835723877
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0005 0.00052213668823242
SELECT * FROM categorygroups WHERE id = '1'
70 0.0006 0.00057482719421387
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0016381740570068
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0007 0.00069689750671387
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0008 0.00080418586730957
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
74 0.0005 0.00051999092102051
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0011 0.0011401176452637
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0012 0.0011568069458008
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.5302 0.53015398979187
SELECT * FROM ipgeocountries WHERE INET_ATON('3.142.156.67') >= INET_ATON(ip_start) AND INET_ATON('3.142.156.67') <= INET_ATON(ip_end)
78 0.0014 0.0013718605041504
SELECT * FROM ipgeolocations WHERE geoname_id = '6252001'
79 0.0006 0.0006248950958252
SELECT * FROM countryredirects WHERE countrycode = 'US'
80 0.0006 0.00062894821166992
SELECT * FROM pages WHERE pagename = 'categories'
81 0.0011 0.0010530948638916
SELECT * FROM categories WHERE parent_id = '0'  AND hidden = 0 ORDER BY sortorder ASC
82 0.0077 0.0077140331268311
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
83 0.0007 0.00069808959960938
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
84 0.0005 0.00052404403686523
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
85 0.0005 0.00051617622375488
SELECT id FROM categories WHERE parent_id = '26'
86 0.0075 0.0075199604034424
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
87 0.0010 0.0010359287261963
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0 
88 0.0012 0.0012078285217285
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
89 0.0009 0.00092506408691406
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
90 0.0008 0.00080204010009766
SELECT * FROM categorygroups WHERE id = '1'
91 0.0009 0.00092911720275879
SELECT * FROM categories WHERE parent_id = '26'  AND hidden = 0 ORDER BY sortorder ASC
92 0.0068 0.0067868232727051
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
93 0.0008 0.00080394744873047
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
94 0.0006 0.0005650520324707
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
95 0.0006 0.00060820579528809
SELECT id FROM categories WHERE parent_id = '27'
96 0.0062 0.0062079429626465
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 
97 0.0007 0.00066018104553223
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 
98 0.0007 0.00065112113952637
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
99 0.0006 0.00056290626525879
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
100 0.0005 0.00053286552429199
SELECT * FROM categorygroups WHERE id = '1'
101 0.0006 0.00058412551879883
SELECT * FROM categories WHERE parent_id = '27'  AND hidden = 0 ORDER BY sortorder ASC
102 0.0018 0.0017871856689453
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
103 0.0006 0.00060200691223145
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
104 0.0005 0.00047802925109863
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
105 0.0005 0.00047206878662109
SELECT id FROM categories WHERE parent_id = '28'
106 0.0018 0.0018329620361328
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
107 0.0006 0.00062298774719238
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0 
108 0.0007 0.00066614151000977
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
109 0.0006 0.000640869140625
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
110 0.0006 0.00057411193847656
SELECT * FROM categorygroups WHERE id = '1'
111 0.0006 0.00058102607727051
SELECT * FROM categories WHERE parent_id = '28'  AND hidden = 0 ORDER BY sortorder ASC
112 0.0007 0.00070810317993164
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.0005 0.00053095817565918
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
114 0.0005 0.0005040168762207
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
115 0.0005 0.00046205520629883
SELECT id FROM categories WHERE parent_id = '29'
116 0.0008 0.00078010559082031
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 
117 0.0006 0.00057506561279297
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 
118 0.0006 0.00057101249694824
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
119 0.0005 0.00051689147949219
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
120 0.0005 0.00053787231445312
SELECT * FROM categorygroups WHERE id = '1'
121 0.0007 0.00066804885864258
SELECT * FROM categories WHERE parent_id = '29'  AND hidden = 0 ORDER BY sortorder ASC
122 0.0007 0.00074601173400879
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
123 0.0005 0.00053000450134277
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
124 0.0004 0.00044989585876465
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
125 0.0005 0.00046515464782715
SELECT id FROM categories WHERE parent_id = '30'
126 0.0008 0.00075817108154297
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 
127 0.0006 0.00057506561279297
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 
128 0.0006 0.00062894821166992
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
129 0.0006 0.00055909156799316
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
130 0.0005 0.00051403045654297
SELECT * FROM categorygroups WHERE id = '1'
131 0.0006 0.00058984756469727
SELECT * FROM categories WHERE parent_id = '30'  AND hidden = 0 ORDER BY sortorder ASC
132 0.0008 0.00076198577880859
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
133 0.0006 0.00055503845214844
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
134 0.0005 0.00048995018005371
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
135 0.0005 0.00048398971557617
SELECT id FROM categories WHERE parent_id = '31'
136 0.0009 0.00089597702026367
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1 
137 0.0006 0.00057411193847656
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0 
138 0.0006 0.00063395500183105
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
139 0.0006 0.00058984756469727
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
140 0.0005 0.00048112869262695
SELECT * FROM categorygroups WHERE id = '1'
141 0.0006 0.00060105323791504
SELECT * FROM categories WHERE parent_id = '31'  AND hidden = 0 ORDER BY sortorder ASC
142 0.0004 0.00040507316589355
SELECT id FROM categories WHERE parent_id = '26'
143 0.0009 0.00087094306945801
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (26) 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.0008 0.00075697898864746
SELECT * FROM productimages WHERE product_id = '4122' ORDER BY sortorder ASC
145 0.0077 0.0077109336853027
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
146 0.0021 0.0021421909332275
SELECT * FROM categoryimages WHERE category_id = 26
147 0.0005 0.00052213668823242
SELECT id FROM categories WHERE parent_id = '27'
148 0.0007 0.00070405006408691
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
149 0.0006 0.00064182281494141
SELECT * FROM productimages WHERE product_id = '862' ORDER BY sortorder ASC
150 0.0041 0.0041379928588867
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
151 0.0005 0.00052690505981445
SELECT * FROM categoryimages WHERE category_id = 27
152 0.0005 0.0004730224609375
SELECT id FROM categories WHERE parent_id = '28'
153 0.0017 0.0016601085662842
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (28) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
154 0.0007 0.00068092346191406
SELECT * FROM productimages WHERE product_id = '868' ORDER BY sortorder ASC
155 0.0015 0.001500129699707
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
156 0.0005 0.00054502487182617
SELECT * FROM categoryimages WHERE category_id = 28
157 0.0005 0.00047612190246582
SELECT id FROM categories WHERE parent_id = '29'
158 0.0007 0.00067806243896484
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
159 0.0007 0.00066494941711426
SELECT * FROM productimages WHERE product_id = '4925' ORDER BY sortorder ASC
160 0.0006 0.00056886672973633
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
161 0.0005 0.00048708915710449
SELECT * FROM categoryimages WHERE category_id = 29
162 0.0005 0.00050711631774902
SELECT id FROM categories WHERE parent_id = '30'
163 0.0006 0.00063109397888184
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.0006 0.00060296058654785
SELECT * FROM productimages WHERE product_id = '4926' ORDER BY sortorder ASC
165 0.0005 0.00054502487182617
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
166 0.0004 0.00044798851013184
SELECT * FROM categoryimages WHERE category_id = 30
167 0.0005 0.00049805641174316
SELECT id FROM categories WHERE parent_id = '31'
168 0.0006 0.00061583518981934
SELECT p.id FROM products p, products_categories c WHERE p.id = c.product_id AND c.category_id IN (31) AND p.hidden = 0 AND p.salesrank > 0 AND (p.price > 0 OR p.parent = 1) ORDER BY p.salesrank ASC LIMIT 1
169 0.0006 0.00061917304992676
SELECT * FROM productimages WHERE product_id = '4953' ORDER BY sortorder ASC
170 0.0006 0.00057196617126465
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
171 0.0004 0.00043487548828125
SELECT * FROM categoryimages WHERE category_id = 31
172 0.0006 0.00057101249694824
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
173 0.0005 0.00049614906311035
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
174 0.0004 0.00041508674621582
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
175 0.0141 0.014090061187744
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
176 0.0008 0.00081706047058105
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
177 0.0006 0.00061798095703125
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
178 0.0006 0.00059604644775391
SELECT * FROM products WHERE id = 1626
179 0.0006 0.00060200691223145
SELECT * FROM products WHERE id = 4041
180 0.0006 0.00064802169799805
SELECT * FROM products WHERE id = 4312
181 0.0006 0.00059986114501953
SELECT * FROM products WHERE id = 777
182 0.0006 0.00057482719421387
SELECT * FROM products WHERE id = 3881
183 0.0006 0.00064587593078613
SELECT * FROM products WHERE id = 4213
184 0.0006 0.00057387351989746
SELECT * FROM products WHERE id = '1626'
185 0.0005 0.00052094459533691
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
186 0.0007 0.00067520141601562
SELECT * FROM product_image_select WHERE product_id = '1626'
187 0.0005 0.00045895576477051
SELECT * FROM productcustomimages WHERE product_id = '1626'
188 0.0009 0.00085687637329102
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
189 0.0005 0.00051379203796387
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
190 0.0005 0.00045108795166016
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
191 0.0004 0.00044703483581543
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
192 0.0007 0.0006871223449707
SELECT * FROM products WHERE id = '4041'
193 0.0005 0.00048398971557617
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
194 0.0007 0.00065279006958008
SELECT * FROM product_image_select WHERE product_id = '4041'
195 0.0005 0.00046682357788086
SELECT * FROM productcustomimages WHERE product_id = '4041'
196 0.0013 0.0012879371643066
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
197 0.0006 0.00057482719421387
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
198 0.0006 0.00055980682373047
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
199 0.0005 0.00054097175598145
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
200 0.0007 0.00066304206848145
SELECT * FROM products WHERE id = '4312'
201 0.0005 0.00052905082702637
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
202 0.0007 0.00068211555480957
SELECT * FROM product_image_select WHERE product_id = '4312'
203 0.0004 0.00044512748718262
SELECT * FROM productcustomimages WHERE product_id = '4312'
204 0.0012 0.0012240409851074
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
205 0.0006 0.00058603286743164
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
206 0.0005 0.0005180835723877
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
207 0.0005 0.00050592422485352
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
208 0.0007 0.00065994262695312
SELECT * FROM products WHERE id = '777'
209 0.0005 0.00054407119750977
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
210 0.0009 0.00090694427490234
SELECT * FROM product_image_select WHERE product_id = '777'
211 0.0006 0.00061202049255371
SELECT * FROM productcustomimages WHERE product_id = '777'
212 0.0014 0.0014419555664062
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
213 0.0007 0.00066900253295898
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
214 0.0011 0.0010669231414795
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
215 0.0009 0.00094294548034668
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
216 0.0011 0.0011069774627686
SELECT * FROM products WHERE id = '3881'
217 0.0014 0.001352071762085
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
218 0.0015 0.001471996307373
SELECT * FROM product_image_select WHERE product_id = '3881'
219 0.0009 0.00088691711425781
SELECT * FROM productcustomimages WHERE product_id = '3881'
220 0.0029 0.0029029846191406
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
221 0.0010 0.0010111331939697
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
222 0.0008 0.00081110000610352
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
223 0.0011 0.0011451244354248
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
224 0.0014 0.0013608932495117
SELECT * FROM products WHERE id = '4213'
225 0.0014 0.0013689994812012
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
226 0.0013 0.0013201236724854
SELECT * FROM product_image_select WHERE product_id = '4213'
227 0.0008 0.00081396102905273
SELECT * FROM productcustomimages WHERE product_id = '4213'
228 0.0029 0.0028800964355469
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
229 0.0009 0.00089001655578613
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
230 0.0008 0.00075888633728027
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
231 0.0009 0.00087809562683105
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
232 0.0018 0.0017600059509277
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
233 0.0015 0.0014758110046387
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
234 0.0032 0.0032451152801514
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
235 0.0014 0.0013802051544189
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
236 0.0011 0.0010931491851807
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
237 0.0009 0.00086092948913574
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
238 0.0020 0.0019969940185547
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'