| 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.00023079 | 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.00012994 | 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='profile') | 0.00020909 | mb_templates | range | Section | Section | 56 | 10 | Using where | |
| SELECT * FROM mb_replacements | 9.799E-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', 'profile', 1768263488, 0, '216.73.216.121', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') | 8.82E-6 | ||||||||
| SELECT m.*, g.group_name FROM mb_users m, mb_groups g WHERE m.UID=18 AND g.group_id=m.MemberGroup | 0.00016618 | mb_users | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| SELECT COUNT(p.post_id) AS ForumPosts, f.forum_id AS Forum, f.forum_name FROM mb_posts p, mb_topics t, mb_forums f WHERE p.Topic=t.TID AND t.Forum=f.forum_id AND p.post_author=18 GROUP BY t.Forum ORDER BY ForumPosts DESC | 0.00015903 | mb_posts | ALL | Topic | 149 | Using where; Using temporary; Using filesort | |||
| SELECT t.TID, t.Forum, t.Title, p.Time FROM mb_topics t, mb_posts p LEFT JOIN mb_forums f ON f.forum_id=t.Forum WHERE t.TID=p.Topic AND p.post_author=18 ORDER BY p.Time DESC LIMIT 1 | 0.00034618 | mb_topics | |||||||
| SELECT COUNT(post_id) as count FROM mb_posts WHERE post_author=18 | 9.704E-5 | mb_posts | ALL | 149 | Using where |