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.00035	SET NAMES 'utf8'
0.00358	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='13.58.61.197' WHERE u.id=1
0.00055	REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '13.58.61.197', 1733243995, '6c2196d18b71b2296833ab4d4bb13a8b8d2ffbe6', 'https://oldforum.hermannhuppen.be//viewtopic.php?id=278')
0.00062	SELECT o.* FROM forum_online AS o WHERE o.logged < 1733243695
0.00283	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.00133	SELECT p.id FROM forum_posts AS p WHERE p.topic_id=278 ORDER BY p.id LIMIT 0,25
0.00077	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.00044	UPDATE forum_topics SET num_views=num_views+1 WHERE id=278
0.01047	Temps total d'interrogation

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

Temps (s)

Interrogation

0.00035

SET NAMES 'utf8'

0.00358

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

0.00055

REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '13.58.61.197', 1733243995, '6c2196d18b71b2296833ab4d4bb13a8b8d2ffbe6', 'https://oldforum.hermannhuppen.be//viewtopic.php?id=278')

0.00062

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

0.00283

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

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

0.00077

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

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

0.01047

Temps total d'interrogation