0.00041 |
SET NAMES 'utf8' |
0.00731 |
SELECT u.*, g.*, o.logged, o.csrf_token, o.prev_url, o.last_post, o.last_search FROM forum_users AS u INNER JOIN forum_groups AS g ON g.g_id=u.group_id LEFT JOIN forum_online AS o ON o.ident='18.117.103.185' WHERE u.id=1 |
0.00049 |
REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '18.117.103.185', 1732487404, '9f55dbe8a901fc395476a14c3a2a3f6a0339b5af', 'https://oldforum.hermannhuppen.be//viewtopic.php?pid=6744') |
0.00058 |
SELECT o.* FROM forum_online AS o WHERE o.logged < 1732487104 |
0.00053 |
DELETE FROM forum_online WHERE user_id=1 AND logged < 1732487104 |
0.00209 |
SELECT p.topic_id, p.posted FROM forum_posts AS p WHERE p.id=6744 |
0.00136 |
SELECT COUNT(p.id) FROM forum_posts AS p WHERE p.topic_id=279 AND p.posted<1290010748 |
0.00671 |
SELECT t.subject, t.first_post_id, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies FROM forum_topics AS t INNER JOIN forum_forums AS f ON f.id=t.forum_id LEFT JOIN forum_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=2) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=279 AND t.moved_to IS NULL |
0.00192 |
SELECT p.id FROM forum_posts AS p WHERE p.topic_id=279 ORDER BY p.id LIMIT 75,25 |
0.00593 |
SELECT u.email, u.title, u.url, u.location, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, u.avatar, u.avatar_width, u.avatar_height, 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 forum_posts AS p INNER JOIN forum_users AS u ON u.id=p.poster_id INNER JOIN forum_groups AS g ON g.g_id=u.group_id LEFT JOIN forum_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.id IN (5689,5692,5693,5694,5697,5738,5742,5974,5980,6003,6011,6013,6015,6735,6736,6737,6738,6739,6741,6742,6744,6747,6748,6751,6752) ORDER BY p.id |
0.00206 |
UPDATE forum_topics SET num_views=num_views+1 WHERE id=279 |
0.02939 |
Temps total d'interrogation |