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: 749 | Total Replies: 9 | Thread Id: 113843 ]
SELECT moderator FROM ubb_forums WHERE moderator != ''
3.
0.00018311
SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
4.
0.00017190
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
5.
0.00018620
SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
6.
0.00013304
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
7.
0.00012779
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
8.
0.00012994
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
9.
0.00012589
SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
10.
0.00012898
SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
11.
0.00011611
SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
12.
0.00014806
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
13.
0.00012302
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
14.
0.00019193
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.
0.00057292
SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robotsORDER BY strlen DESC
16.
0.00026202
SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '113843'
17.
0.00037217
DELETE FROM ubb_whosonline WHERE ip = '3.239.192.241' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1614451363'
18.
0.00017190
INSERT INTO ubb_whosonline(username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.239.192.241', LPAD('1614451963', '15', '0'), '/viewtopic.php?tid=113843&page=1', '0', '')
19.
0.00017405
DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.239.192.241') OR (onlinetime < '1614365563'))
20.
0.00011182
DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.239.192.241') OR (onlinetime < '1614365563'))
21.
0.00012302
INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.239.192.241', '1614451963')
22.
0.00035715
SELECT * FROM ubb_themes WHERE themeid = '1'
23.
0.00014305
SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.
0.00016403
SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '239' OR ip2 = '-1') AND (ip3 = '192' OR ip3 = '-1') AND (ip4 = '241' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.
0.00056505
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 = '113843'
29.
0.00017905
SELECT * FROM ubb_forums WHERE fid='85' AND status='on'
30.
0.00015593
SELECT name, fid, private, userlist FROM ubb_forums WHERE fid = '11'
31.
0.00013208
SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
32.
0.00012183
SELECT find, replace1 FROM ubb_words
33.
0.00017905
SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
34.
0.00016189
UPDATEubb_threads SET views = views+1 WHERE tid = '113843' LIMIT 1
35.
0.00016999
SELECT COUNT(pid) FROM ubb_posts WHERE tid = '113843'
36.
0.00079298
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 113843 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.00066280
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 113843 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.00011802
SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '113843'
39.
0.00018907
SELECT pid FROM ubb_posts WHERE tid = '113843' ORDER BY pid LIMIT 0, 30
40.
0.00018406
SELECT * FROM ubb_attachments WHERE pid IN('1043622', '1043623', '1043624', '1043625', '1043626', '1043631', '1043636', '1043976', '1043978', '1044048')
41.
0.00071406
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 = '113843' ORDER BY p.pid ASC LIMIT 0, 30