Divers (Page 2) - Hermann Huppen

Informations sur la performance des interrogations de la base de données
Temps (s)	Interrogation
0.00062	SET NAMES 'utf8'
0.01239	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.191.189.124' WHERE u.id=1
0.00040	REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '18.191.189.124', 1732180126, '6ec4a9bea747ac5d3ef84ca9fae65cfc3b6a06e1', 'https://oldforum.hermannhuppen.be//viewforum.php?id=20&p=2')
0.00050	SELECT o.* FROM forum_online AS o WHERE o.logged < 1732179826
0.00036	DELETE FROM forum_online WHERE user_id=1 AND logged < 1732179826
0.00233	SELECT f.forum_name, f.redirect_url, f.moderators, f.num_topics, f.sort_by, fp.post_topics FROM forum_forums AS f 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 f.id=20
0.00188	SELECT t.id FROM forum_topics AS t WHERE t.forum_id=20 ORDER BY t.sticky DESC, t.last_post DESC LIMIT 30, 30
0.00066	SELECT t.id, t.poster, t.subject, t.posted, t.first_post_id, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to FROM forum_topics AS t WHERE t.id IN (239,194,227,226,225,221,197,195,206,200,199) ORDER BY t.sticky DESC, t.last_post DESC
0.01914	Temps total d'interrogation