| 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.000247 | 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.00012302 | 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='forum') | 0.00020504 | mb_templates | range | Section | Section | 56 | 13 | Using where | |
| SELECT * FROM mb_replacements | 9.608E-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', 'forum', 1716007891, 0, '18.116.67.177', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') | 8.11E-6 | ||||||||
| SELECT forum_parent FROM mb_forums WHERE forum_id=3 | 0.00011897 | mb_forums | const | PRIMARY | PRIMARY | 2 | const | 1 | |
| SELECT COUNT(TID) AS count FROM mb_topics WHERE Forum=3 | 0.00035191 | mb_topics | ref | Forum | Forum | 2 | const | 4 | |
| SELECT f.forum_id, f.forum_parent, f.forum_name, f.Position, f.Description, f.Topics, f.Replies, f.forum_lastpost, t.TID as LastTopicID, t.Title as LastPost, t.Edited as LastTime, m.Name as LastPoster, m.UID as LastPosterID FROM mb_forums f LEFT JOIN mb_posts p ON p.post_id = f.forum_lastpost LEFT JOIN mb_topics t ON t.TID = p.Topic LEFT JOIN mb_users m ON m.UID = p.post_author WHERE f.forum_parent=3 ORDER BY f.forum_parent, f.Position | 0.0002079 | mb_forums | ref | Parent | Parent | 2 | const | 1 | Using where; Using filesort |
| SELECT forum_id, forum_parent, Tree, forum_name, Position FROM mb_forums ORDER BY Position ASC | 9.704E-5 | mb_forums | ALL | 7 | Using filesort | ||||
| SELECT t.TID, t.Title, t.last_poster, t.StarterID, t.Replies, t.modes, t.Edited, t.Icon, t.Views, t.Description, t.moved, s.Name AS topic_starter, m.Name AS last_poster_name FROM mb_topics t, mb_users m, mb_users s WHERE t.Forum=3 AND m.UID=t.last_poster AND s.UID=t.StarterID ORDER BY (t.modes & 16) DESC, t.Edited DESC LIMIT 0, 20 | 0.00032401 | mb_topics | ref | Forum | Forum | 2 | const | 4 | Using where; Using filesort |
| SELECT Tree, forum_id, forum_name FROM mb_forums ORDER BY forum_id | 9.608E-5 | mb_forums | ALL | 7 | Using filesort |