Ça, je connaissais pas... (Page 3) - Hermann

Ça, je connaissais pas... (Page 3 de 3)

Hermann Huppen » Hermann » Ça, je connaissais pas...

Pages Précédent 1 2 3

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

Flux RSS du sujet

Messages [ 51 to 51 of 51 ]

51 Réponse par Frenchoïd 23-06-2013 11:35:14

Frenchoïd
Membre
Hors ligne

Date d'enregistrement: 03-06-2008
Messages: 2'618

Re: Ça, je connaissais pas...

Et merci Hermann d'accepter qu'Yves vous interroge pour satisfaire la curiosité de quelques grands malades, tout gars qu'ils sont...

Messages [ 51 to 51 of 51 ]

Pages Précédent 1 2 3

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

Hermann Huppen » Hermann » Ça, je connaissais pas...

Informations sur la performance des interrogations de la base de données
Temps (s)	Interrogation
0.00040	SET NAMES 'utf8'
0.00656	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.138.37.69' WHERE u.id=1
0.00056	REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '3.138.37.69', 1733246482, '57087313a353976bc583c680e16ae59fca4fae0b', 'https://oldforum.hermannhuppen.be//viewtopic.php?pid=13874')
0.00067	SELECT o.* FROM forum_online AS o WHERE o.logged < 1733246182
0.00130	SELECT p.topic_id, p.posted FROM forum_posts AS p WHERE p.id=13874
0.00052	SELECT COUNT(p.id) FROM forum_posts AS p WHERE p.topic_id=575 AND p.posted<1371983714
0.00298	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=575 AND t.moved_to IS NULL
0.00063	SELECT p.id FROM forum_posts AS p WHERE p.topic_id=575 ORDER BY p.id LIMIT 50,25
0.00083	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 (13874) ORDER BY p.id
0.00045	UPDATE forum_topics SET num_views=num_views+1 WHERE id=575
0.01490	Temps total d'interrogation

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

Temps (s)

Interrogation

0.00040

SET NAMES 'utf8'

0.00656

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

0.00056

REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '3.138.37.69', 1733246482, '57087313a353976bc583c680e16ae59fca4fae0b', 'https://oldforum.hermannhuppen.be//viewtopic.php?pid=13874')

0.00067

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

0.00130

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

0.00052

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

0.00298

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

0.00063

SELECT p.id FROM forum_posts AS p WHERE p.topic_id=575 ORDER BY p.id LIMIT 50,25

0.00083

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

0.00045

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

0.01490

Temps total d'interrogation