| 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 | 1.788E-5 | mb_users | |||||||
| SELECT m.*, s.skin_dir FROM mb_users m, mb_skins s WHERE m.UID=1 AND s.skin_dir=m.Skin | 1.192E-5 | mb_users | |||||||
| SELECT DISTINCT perms_perm, perms_forum_id FROM mb_perms WHERE perms_group_id= OR perms_user_id= | 1.788E-5 | mb_perms | |||||||
| SELECT template_name, template_html FROM mb_templates WHERE template_skin='' AND (template_set='Main' OR template_set='topic') | 1.192E-5 | mb_templates | |||||||
| SELECT * FROM mb_replacements | 1.502E-5 | mb_replacements | |||||||
| REPLACE INTO mb_active (active_id, active_name, active_action, active_time, active_is_member, active_ip, active_user_agent) VALUES (, '', 'topic', 1775533159, 1, '216.73.216.30', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') | 7.15E-6 | ||||||||
| SELECT COUNT(PMID) AS messages FROM mb_pmsystem WHERE ToWho='' AND Folder='0' AND Viewed='0' | 1.192E-5 | mb_pmsystem | |||||||
| 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=17 AND f.forum_id=t.Forum | 1.311E-5 |