| query | execution time | table(s) | type | possible keys | key | key length | ref | rows | extra |
| SELECT m.*, s.skin_dir FROM mb_users m, mb_skins s WHERE m.UID=1 AND s.skin_dir=m.Skin | 0.000211 | mb_users | system | PRIMARY | 1 | ||||
| SELECT DISTINCT perms_perm, perms_forum_id FROM mb_perms WHERE perms_group_id=3 OR perms_user_id=1 | 0.00011706 | mb_perms | ALL | 204 | Using where; Using temporary | ||||
| SELECT template_name, template_html FROM mb_templates WHERE template_skin='default' AND (template_set='Main' OR template_set='topic') | 0.00022292 | mb_templates | range | Section | Section | 56 | 11 | Using where | |
| SELECT * FROM mb_replacements | 9.704E-5 | mb_replacements | ALL | 15 | |||||
| REPLACE INTO mb_active (active_id, active_name, active_action, active_time, active_is_member, active_ip, active_user_agent) VALUES (1, 'Guest', 'topic', 1768236481, 0, '216.73.216.0', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') | 8.82E-6 | ||||||||
| SELECT t.Title, t.Description, t.modes, t.StarterID, t.Forum, t.Replies, t.poll_options, f.forum_name FROM mb_topics t, mb_forums f WHERE t.TID=1 AND f.forum_id=t.Forum | 0.00016594 | const | PRIMARY,Forum | PRIMARY | 4 | const | 1 | ||
| UPDATE mb_topics SET Views=Views+1 WHERE TID=1 | 9.06E-6 | mb_topics | |||||||
| SELECT Tree, forum_id, forum_name FROM mb_forums ORDER BY forum_id | 9.799E-5 | mb_forums | ALL | 7 | Using filesort | ||||
| SELECT p.post_emoticons, p.post_mbcode, p.Time, p.Post, p.post_author, p.post_id, p.post_ip, p.post_icon, p.post_edited_by, p.post_edited_time, m.Joined, m.Signature, m.Posts, m.UID, m.MemTitle, m.MemberGroup, m.Avatar, m.Name, m.Email, m.AIM, m.ICQ, m.Yahoo, m.Homepage, m.AvWidth, m.AvHeight, m.MSN, m.PM, m.ShowEmail, t.Icon, g.group_name FROM mb_posts p, mb_users m, mb_groups g, mb_membertitles t WHERE p.Topic='1' AND p.post_author = m.UID AND m.MemberGroup = g.group_id AND t.TitleID = m.Level ORDER BY p.Time LIMIT 0, 15 | 0.00023198 | ref | Topic | Topic | 4 | const | 19 | Using where; Using filesort |