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.00028586 |
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.00014806 |
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.00023913 |
mb_templates |
range |
Section |
Section |
56 |
|
10 |
Using where |
SELECT * FROM mb_replacements |
0.00011802 |
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', 1716009325, 0, '3.149.238.159', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') |
9.06E-6 |
|
|
|
|
|
|
|
|
SELECT m.*, g.group_name FROM mb_users m, mb_groups g WHERE m.UID=7 AND g.group_id=m.MemberGroup |
0.00018501 |
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=7
GROUP BY t.Forum
ORDER BY ForumPosts DESC |
0.00211692 |
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=7
ORDER BY p.Time DESC
LIMIT 1 |
0.00043988 |
mb_topics |
|
|
|
|
|
|
|
SELECT COUNT(post_id) as count FROM mb_posts WHERE post_author=7 |
0.00010395 |
mb_posts |
ALL |
|
|
|
|
149 |
Using where |