| # | Duration: | Query: |
| 1. | 0.00033212 | SELECT * FROM ubb_settings |
| 2. | 0.00024605 | SELECT moderator FROM ubb_forums WHERE moderator != '' |
| 3. | 0.00023007 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY' |
| 4. | 0.00016403 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH' |
| 5. | 0.00018191 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls' |
| 6. | 0.00014901 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj' |
| 7. | 0.00013709 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam' |
| 8. | 0.00014901 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54' |
| 9. | 0.00014901 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen' |
| 10. | 0.00016403 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus' |
| 11. | 0.00019503 | SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser' |
| 12. | 0.00017405 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes' |
| 13. | 0.00013494 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber' |
| 14. | 0.00015521 | SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB' |
| 15. | 0.00065207 | SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robots ORDER BY strlen DESC |
| 16. | 0.00057697 | DELETE FROM ubb_whosonline WHERE ip = '3.231.230.177' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1627977340' |
| 17. | 0.00020385 | INSERT INTO ubb_whosonline (username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.231.230.177', LPAD('1627977940', '15', '0'), '/stats.php', '0', '') |
| 18. | 0.00019908 | DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.231.230.177') OR (onlinetime < '1627891540')) |
| 19. | 0.00011396 | DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.231.230.177') OR (onlinetime < '1627891540')) |
| 20. | 0.00008702 | INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.231.230.177', '1627977940') |
| 21. | 0.00024605 | SELECT * FROM ubb_themes WHERE themeid = '1' |
| 22. | 0.00015283 | SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC |
| 23. | 0.00019598 | SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '231' OR ip2 = '-1') AND (ip3 = '230' OR ip3 = '-1') AND (ip4 = '177' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1') |
| 24. | 0.00060105 | 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 |
| 25. | 0.00053716 | SELECT name, template FROM ubb_templates WHERE name IN ('stats', 'css', 'error', 'footer', 'footer_querynum', 'footer_load', 'footer_phpsql', 'footer_totaltime', 'header', 'message', 'meta_tags', 'shadow', 'shadow2') |
| 26. | 0.00022316 | SELECT code, url FROM ubb_smilies WHERE type = 'smiley' |
| 27. | 0.00011396 | SELECT find, replace1 FROM ubb_words |
| 28. | 0.00022411 | SELECT COUNT(uid) FROM ubb_members UNION ALL SELECT COUNT(tid) FROM ubb_threads UNION ALL SELECT COUNT(pid) FROM ubb_posts |
| 29. | 0.00049782 | SELECT regdate FROM ubb_members ORDER BY regdate LIMIT 0, 1 |
| 30. | 0.00064802 | SELECT COUNT(fid) FROM ubb_forums WHERE type = 'forum' |
| 31. | 0.00037098 | SELECT COUNT(fid) FROM ubb_forums WHERE type = 'forum' AND status = 'on' |
| 32. | 0.00260186 | SELECT COUNT(postnum) FROM ubb_members WHERE postnum > '0' |
| 33. | 0.01021194 | SELECT SUM(postnum) FROM ubb_members |
| 34. | 0.00036311 | SELECT SUM(posts) FROM ubb_forums |
| 35. | 0.03024912 | SELECT SUM(replies) FROM ubb_threads |
| 36. | 0.11297894 | SELECT t.views, t.tid, t.subject FROM ubb_threads t, ubb_forums f WHERE f.private != '5' AND f.private != '3' AND f.private != '2' AND f.userlist = '' AND f.password = '' AND f.fid = t.fid AND f.status = 'on' ORDER BY views DESC LIMIT 0,5 |
| 37. | 0.08587503 | SELECT t.replies, t.tid, t.subject FROM ubb_threads t, ubb_forums f WHERE f.private != '5' AND f.private != '3' AND f.private != '2' AND f.userlist = '' AND f.password = '' AND f.fid = t.fid AND f.status = 'on' ORDER BY replies DESC LIMIT 0,5 |
| 38. | 0.05063915 | SELECT l.dateline as lp_dateline, l.pid as lp_pid, t.tid, t.subject FROM ubb_threads t, ubb_forums f, ubb_lastposts l WHERE f.private != '5' AND f.private != '3' AND f.private != '2' AND f.userlist = '' AND f.password = '' AND l.tid = t.tid AND f.fid = t.fid AND f.status = 'on' ORDER BY l.dateline DESC LIMIT 0,5 |
| 39. | 0.00112104 | SELECT f.posts, f.threads, f.fid, f.name FROM ubb_forums f WHERE f.private != '5' AND f.private != '3' AND f.private != '2' AND f.userlist = '' AND f.password = '' AND f.fid = f.fid AND f.type = 'forum' OR f.type = 'sub' AND f.status = 'on' ORDER BY posts DESC LIMIT 0, 1 |
| 40. | 0.00028491 | SELECT uid, username, regdate, postnum, COUNT(postnum) AS Total FROM ubb_members WHERE regdate <='1627891540' GROUP BY postnum ORDER BY postnum DESC LIMIT 1 |
Forum Stats
