• Announcement:

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

    Question and Answer Session! Questions Answered.

    CM Zack Community Manager community manager

    myth Member

    Ched Member

    MasterSirid Member

    Stone Premium Subscriber

    Tragic Premium Subscriber

    Ched Member

    Debug information

    Time (s) Query
    0.00006 SET NAMES 'utf8'
    0.00026 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.00014 UPDATE online SET logged=1506112813 WHERE ident='54.198.58.62'
    0.00007 SELECT user_id, ident, logged, idle FROM online WHERE logged<1506112513
    0.00008 SELECT thread_id, commented FROM comments WHERE id=14527
    0.00011 SELECT COUNT(id) FROM comments WHERE thread_id=2109 AND commented<1504666494
    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=2109 AND t.moved_to IS NULL
    0.00005 SELECT f.solved FROM forums AS f LEFT JOIN threads AS t ON (f.id = t.forum_id) WHERE t.id=2109
    0.00012 SELECT id FROM comments WHERE soft = 0 AND thread_id=2109 ORDER BY id LIMIT 0,20
    0.00024 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 (14527,14534,14542,14546,14559,14561,14601) ORDER BY p.id
    0.00008 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='8845' GROUP BY badge ASC
    0.00006 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='7301' GROUP BY badge ASC
    0.00010 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='20' GROUP BY badge ASC
    0.00010 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='9642' GROUP BY badge ASC
    0.00010 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='112' GROUP BY badge ASC
    0.00010 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='5601' GROUP BY badge ASC
    0.00010 SELECT badge_name, badge FROM user_forum_badge WHERE user_id='20' GROUP BY badge ASC
    0.00009 UPDATE threads SET num_views=num_views+1 WHERE id=2109
    Total query time: 0.002 s