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.00319099 |
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.00126505 |
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.00113487 |
mb_templates |
range |
Section |
Section |
56 |
|
11 |
Using where |
SELECT * FROM mb_replacements |
0.00110888 |
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', 1716017533, 0, '3.16.1.195', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)') |
1.001E-5 |
|
|
|
|
|
|
|
|
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=22 AND
f.forum_id=t.Forum |
0.00340581 |
|
const |
PRIMARY,Forum |
PRIMARY |
4 |
const |
1 |
|
UPDATE mb_topics SET Views=Views+1 WHERE TID=22 |
1.001E-5 |
mb_topics |
|
|
|
|
|
|
|
SELECT Tree, forum_id, forum_name FROM mb_forums ORDER BY forum_id |
9.394E-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='22' 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.00240517 |
|
ref |
Topic |
Topic |
4 |
const |
5 |
Using where; Using filesort |