Festival de Roch'Fort en Bulles (Page 1) - Hermann

Hermann Huppen » Hermann » Festival de Roch'Fort en Bulles

Pages 1

Vous devez vous identifier ou vous inscrire pour pouvoir rédiger une réponse

1 Sujet par Yves H 27-08-2015 09:43:59

Yves H
Administrateur
Hors ligne

Date d'enregistrement: 26-02-2008
Messages: 6'408

Sujet: Festival de Roch'Fort en Bulles

Pour cause de force majeure, Hermann ne pourra être présent à Rochefort-sur-Mer (5 et 6 septembre). Il s'en excuse et vous fixe rendez-vous à Auvers-sur-Oise les 26 et 27 septembre prochains.

Messages [ 1 ]

Pages 1

Vous devez vous identifier ou vous inscrire pour pouvoir rédiger une réponse

Hermann Huppen » Hermann » Festival de Roch'Fort en Bulles

Informations sur la performance des interrogations de la base de données
Temps (s)	Interrogation
0.00028	SET NAMES 'utf8'
0.00110	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.217.84.171' WHERE u.id=1
0.00039	REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '18.217.84.171', 1713577473, '1b96982dc5dd94f27bd6d41b44ebcf72c70b2321', 'https://oldforum.hermannhuppen.be/viewtopic.php?pid=17307')
0.00051	SELECT o.* FROM forum_online AS o WHERE o.logged < 1713577173
0.00045	DELETE FROM forum_online WHERE user_id=1 AND logged < 1713577173
0.00047	SELECT p.topic_id, p.posted FROM forum_posts AS p WHERE p.id=17307
0.00086	SELECT COUNT(p.id) FROM forum_posts AS p WHERE p.topic_id=643 AND p.posted<1440665039
0.00089	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=643 AND t.moved_to IS NULL
0.00086	SELECT p.id FROM forum_posts AS p WHERE p.topic_id=643 ORDER BY p.id LIMIT 0,25
0.00138	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 (17307) ORDER BY p.id
0.00077	UPDATE forum_topics SET num_views=num_views+1 WHERE id=643
0.00796	Temps total d'interrogation

Informations sur la performance des interrogations de la base de données

Temps (s)

Interrogation

0.00028

SET NAMES 'utf8'

0.00110

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.217.84.171' WHERE u.id=1

0.00039

REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '18.217.84.171', 1713577473, '1b96982dc5dd94f27bd6d41b44ebcf72c70b2321', 'https://oldforum.hermannhuppen.be/viewtopic.php?pid=17307')

0.00051

SELECT o.* FROM forum_online AS o WHERE o.logged < 1713577173

0.00045

DELETE FROM forum_online WHERE user_id=1 AND logged < 1713577173

0.00047

SELECT p.topic_id, p.posted FROM forum_posts AS p WHERE p.id=17307

0.00086

SELECT COUNT(p.id) FROM forum_posts AS p WHERE p.topic_id=643 AND p.posted<1440665039

0.00089

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=643 AND t.moved_to IS NULL

0.00086

SELECT p.id FROM forum_posts AS p WHERE p.topic_id=643 ORDER BY p.id LIMIT 0,25

0.00138

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 (17307) ORDER BY p.id

0.00077

UPDATE forum_topics SET num_views=num_views+1 WHERE id=643

0.00796

Temps total d'interrogation