DBD (Page 1) - Toute la BD

Pages 1

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

1 Sujet par bua 02-03-2010 11:42:45

bua
Membre
Hors ligne

Date d'enregistrement: 07-10-2009
Messages: 332

Sujet: DBD

Le DBD de Mars rend un magnifique hommage à l ' ami Tibet , avec plein de dessins et de textes , entre humour et tristesse ... un numéro incontournable !

Messages [ 1 ]

Pages 1

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

Informations sur la performance des interrogations de la base de données
Temps (s)	Interrogation
0.00039	SET NAMES 'utf8'
0.00133	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.149.251.155' WHERE u.id=1
0.00087	REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '3.149.251.155', 1714256446, 'dd5635f2979803d0e724842fd01042b3ead01079', 'https://oldforum.hermannhuppen.be//viewtopic.php?pid=4688')
0.00057	SELECT o.* FROM forum_online AS o WHERE o.logged < 1714256146
0.00055	DELETE FROM forum_online WHERE user_id=1 AND logged < 1714256146
0.00064	SELECT p.topic_id, p.posted FROM forum_posts AS p WHERE p.id=4688
0.00163	SELECT COUNT(p.id) FROM forum_posts AS p WHERE p.topic_id=278 AND p.posted<1267526565
0.00074	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=278 AND t.moved_to IS NULL
0.00044	SELECT p.id FROM forum_posts AS p WHERE p.topic_id=278 ORDER BY p.id LIMIT 0,25
0.00087	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 (4688) ORDER BY p.id
0.00062	UPDATE forum_topics SET num_views=num_views+1 WHERE id=278
0.00865	Temps total d'interrogation

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

Temps (s)

Interrogation

0.00039

SET NAMES 'utf8'

0.00133

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

0.00087

REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '3.149.251.155', 1714256446, 'dd5635f2979803d0e724842fd01042b3ead01079', 'https://oldforum.hermannhuppen.be//viewtopic.php?pid=4688')

0.00057

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

0.00055

DELETE FROM forum_online WHERE user_id=1 AND logged < 1714256146

0.00064

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

0.00163

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

0.00074

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

0.00044

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

0.00087

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

0.00062

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

0.00865

Temps total d'interrogation