Ç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.00025	SET NAMES 'utf8'
0.00092	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.19.30.232' WHERE u.id=1
0.00107	UPDATE forum_online SET logged=1714407664, prev_url='https://oldforum.hermannhuppen.be//viewtopic.php?id=575&p=3' WHERE ident='3.19.30.232'
0.00044	SELECT o.* FROM forum_online AS o WHERE o.logged < 1714407364
0.00087	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.00164	SELECT p.id FROM forum_posts AS p WHERE p.topic_id=575 ORDER BY p.id LIMIT 50,25
0.00141	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.00069	UPDATE forum_topics SET num_views=num_views+1 WHERE id=575
0.00729	Temps total d'interrogation

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

Temps (s)

Interrogation

0.00025

SET NAMES 'utf8'

0.00092

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

0.00107

UPDATE forum_online SET logged=1714407664, prev_url='https://oldforum.hermannhuppen.be//viewtopic.php?id=575&p=3' WHERE ident='3.19.30.232'

0.00044

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

0.00087

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.00164

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

0.00141

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.00069

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

0.00729

Temps total d'interrogation