• Announcement:

    EXPLORE AND JOIN OTHER ACTIVE MEMBERS IN RUNESCAPE CLASSIC - A FANTASY MMORPG ADVENTURE! THIS IS RSCLEGACY!

    Can we reduce pray mage and range?

    Bison Member

    king roland Member

    Bison Member

    Tragic Premium Subscriber

    Debug information

    Time (s) Query
    0.00006 SET NAMES 'utf8'
    0.00020 SELECT u.*, g.*, o.logged, o.last_comment, o.last_search FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.ident='54.198.58.62' WHERE u.id=1
    0.00006 UPDATE online SET logged=1506113137 WHERE ident='54.198.58.62'
    0.00009 SELECT user_id, ident, logged, idle FROM online WHERE logged<1506112837
    0.00009 SELECT thread_id, commented FROM comments WHERE id=7015
    0.00011 SELECT COUNT(id) FROM comments WHERE thread_id=1171 AND commented<1495159664
    0.00014 SELECT t.subject, t.commenter, t.closed, t.num_replies, t.pinned, t.important, t.solved AS answer, t.first_comment_id, f.id AS forum_id, f.forum_name, f.moderators, fp.comment FROM threads AS t INNER JOIN forums AS f ON f.id=t.forum_id LEFT JOIN forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=1171 AND t.moved_to IS NULL
    0.00006 SELECT f.solved FROM forums AS f LEFT JOIN threads AS t ON (f.id = t.forum_id) WHERE t.id=1171
    0.00012 SELECT id FROM comments WHERE soft = 0 AND thread_id=1171 ORDER BY id LIMIT 0,20
    0.00022 SELECT u.gold_time, u.premium_time, u.email, u.title, u.url, u.location, u.signature, u.email_setting, u.num_comments, u.registered, u.admin_note, p.id, p.commenter AS username, p.commenter_id, p.commenter_ip, p.commenter_email, p.message, p.admin_note, p.hide_smilies, p.commented, p.edited, p.edited_by, p.marked, p.soft, g.g_id, g.g_user_title, o.user_id AS is_online FROM comments AS p INNER JOIN users AS u ON u.id=p.commenter_id INNER JOIN groups AS g ON g.g_id=u.group_id LEFT JOIN online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.id IN (7015,7038,7067,7073) ORDER BY p.id
    0.00011 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='5664' GROUP BY badge ASC
    0.00011 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='6185' GROUP BY badge ASC
    0.00010 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='5664' GROUP BY badge ASC
    0.00010 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='5601' GROUP BY badge ASC
    0.00009 UPDATE threads SET num_views=num_views+1 WHERE id=1171
    Total query time: 0.00166 s