Messages par Lucien Rouvère (Page 1)

Informations sur la performance des interrogations de la base de données
Temps (s)	Interrogation
0.00030	SET NAMES 'utf8'
0.00413	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='3.145.7.187' WHERE u.id=1
0.00041	REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '3.145.7.187', 1733339409, 'e87f2dc5117f7d510b032085b21403cd4fe60d73', 'https://oldforum.hermannhuppen.be//search.php?action=show_user_posts&user_id=136737')
0.00040	SELECT o.* FROM forum_online AS o WHERE o.logged < 1733339109
0.00034	DELETE FROM forum_online WHERE user_id=1 AND logged < 1733339109
0.00467	SELECT p.id AS pid, p.poster AS pposter, p.posted AS pposted, p.poster_id, p.message, p.hide_smilies, t.id AS tid, t.poster, t.subject, t.first_post_id, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_replies, t.forum_id, f.forum_name FROM forum_posts AS p INNER JOIN forum_topics AS t ON t.id=p.topic_id 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 p.poster_id=136737 ORDER BY pposted DESC
0.01025	Temps total d'interrogation

Options de recherche