Debug info from viewforum:
Time (s) Query
0.00064 SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=1987
0.00017 UPDATE online SET logged=1182769455 WHERE user_id=1987
0.00029 SELECT * FROM online WHERE logged<1182769155
0.00028 SELECT f.forum_name, f.redirect_url, f.moderators, f.num_topics, f.sort_by, fp.post_topics FROM forums AS f LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.id=19
0.00021 SELECT COUNT(id) FROM reports WHERE zapped IS NULL
0.00012 SELECT COUNT(a.id) AS LAST_ID FROM akismet AS a where a.poster!=""
0.00071 SELECT id, poster, subject, posted, last_post, last_post_id, last_poster, num_views, num_replies, closed, sticky, moved_to FROM topics WHERE forum_id=19 ORDER BY sticky DESC, last_post DESC LIMIT 0, 30
0.00058 SELECT search_for, replace_with FROM censoring
Total query time: 0.003 s
debug from viewtopic:
Time (s) Query
0.00063 SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=1987
0.00017 UPDATE online SET logged=1182769496 WHERE user_id=1987
0.00030 SELECT * FROM online WHERE logged<1182769196
0.00039 SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, s.user_id AS is_subscribed FROM topics AS t INNER JOIN forums AS f ON f.id=t.forum_id LEFT JOIN subscriptions AS s ON (t.id=s.topic_id AND s.user_id=1987) LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=3589 AND t.moved_to IS NULL
0.00022 SELECT COUNT(id) FROM reports WHERE zapped IS NULL
0.00013 SELECT COUNT(a.id) AS LAST_ID FROM akismet AS a where a.poster!=""
Total query time: 0.00184 s
