Trolling and personal attacks will be deleted immediately.
Think positive; how would you make this place better? Are there any features you've seen elsewhere which work? Are there any features here which make
it difficult to use?
We want your feedback.
[ Total Views: 3165 | Total Replies: 1 | Thread Id: 108993 ]
SELECT moderator FROM ubb_forums WHERE moderator != ''
3.
0.00011802
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
4.
0.00013781
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
5.
0.00006700
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
6.
0.00006700
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
7.
0.00005817
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
8.
0.00006294
SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
9.
0.00006294
SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
10.
0.00005889
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
11.
0.00006080
SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
12.
0.00005603
SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
13.
0.00006413
SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
14.
0.00006509
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.
0.00031781
SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robotsORDER BY strlen DESC
16.
0.00009012
SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '108993'
17.
0.00012684
DELETE FROM ubb_whosonline WHERE ip = '3.235.176.80' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1652994003'
18.
0.00007010
INSERT INTO ubb_whosonline(username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.235.176.80', LPAD('1652994603', '15', '0'), '/viewtopic.php?tid=108993', '0', '')
19.
0.00008106
DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.235.176.80') OR (onlinetime < '1652908203'))
20.
0.00004506
DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.235.176.80') OR (onlinetime < '1652908203'))
21.
0.00003791
INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.235.176.80', '1652994603')
22.
0.00008416
SELECT * FROM ubb_themes WHERE themeid = '1'
23.
0.00004888
SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.
0.00006080
SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '235' OR ip2 = '-1') AND (ip3 = '176' OR ip3 = '-1') AND (ip4 = '80' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.
0.00024891
SELECT fid, type, name, fup, status, private, userlist, password FROM ubb_forums WHERE private != '5' AND private != '3' AND private != '2' AND userlist = '' AND password = '' AND status = 'on' ORDER BY displayorder
SELECT t.tid, t.fid, t.subject, t.views, t.replies, t.closed, t.topped, l.uid as lp_uid, l.username as lp_user, l.dateline as lp_dateline, l.pid as lp_pid FROM ubb_threads t LEFT JOIN ubb_lastposts l ON l.tid = t.tid WHERE t.tid = '108993'
29.
0.00008392
SELECT * FROM ubb_forums WHERE fid='85' AND status='on'
30.
0.00004506
SELECT name, fid, private, userlist FROM ubb_forums WHERE fid = '11'
31.
0.00006294
SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
32.
0.00003099
SELECT find, replace1 FROM ubb_words
33.
0.00007010
SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
34.
0.00006890
UPDATEubb_threads SET views = views+1 WHERE tid = '108993' LIMIT 1
35.
0.00006604
SELECT COUNT(pid) FROM ubb_posts WHERE tid = '108993'
36.
0.00048900
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 108993 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline < x.dateline AND t.fid = '85' ORDER BY l.dateline DESC LIMIT 1
37.
0.00036693
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 108993 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline > x.dateline AND t.fid = '85' ORDER BY l.dateline ASC LIMIT 1
38.
0.00006008
SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '108993'
39.
0.00006509
SELECT pid FROM ubb_posts WHERE tid = '108993' ORDER BY pid LIMIT 0, 30
40.
0.00006604
SELECT * FROM ubb_attachments WHERE pid IN('1012813', '1012823')
41.
0.00018692
SELECT p.*, m.*,w.time FROM ubb_posts p LEFT JOIN ubb_members m ON m.username = p.author LEFT JOIN ubb_whosonline w ON p.author = w.username WHERE p.fid = '85' AND p.tid = '108993' ORDER BY p.pid ASC LIMIT 0, 30
