Search options (Page 1 of 2)

Debuginformation
Time (s)     Query
0.00080     SELECT u.*, g.*, o.logged, o.idle FROM foo_users AS u INNER JOIN foo_groups AS g ON u.group_id=g.g_id LEFT JOIN foo_online AS o ON o.user_id=u.id WHERE u.id=2
0.00020     UPDATE foo_online SET logged=1105302827 WHERE user_id=2
0.00028     SELECT * FROM foo_online WHERE logged<1105302527
0.00051     SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, s.user_id AS is_subscribed FROM foo_topics AS t INNER JOIN foo_forums AS f ON f.id=t.forum_id LEFT JOIN foo_subscriptions AS s ON (t.id=s.topic_id AND s.user_id=2) LEFT JOIN foo_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=50 AND t.moved_to IS NULL
0.00024     SELECT COUNT(id) FROM foo_reports WHERE zapped IS NULL
0.00214     SELECT DISTINCT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM foo_posts AS p INNER JOIN foo_users AS u ON u.id=p.poster_id INNER JOIN foo_groups AS g ON g.g_id=u.group_id LEFT JOIN foo_online AS o ON (o.user_id=u.id AND o.idle=0) WHERE p.topic_id=50 ORDER BY p.id LIMIT 0,25
0.00033     UPDATE LOW_PRIORITY foo_topics SET num_views=num_views+1 WHERE id=50
Total query time: 0.0045 s