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.00033	SET NAMES 'utf8'
0.00489	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.132.213.245' WHERE u.id=1
0.00044	REPLACE INTO forum_online (user_id, ident, logged, csrf_token, prev_url) VALUES(1, '3.132.213.245', 1743756465, 'de3d7a45966773b0cafb82d16a998a54ea3af4b6', 'https://oldforum.hermannhuppen.be//viewtopic.php?pid=4688')
0.00037	SELECT o.* FROM forum_online AS o WHERE o.logged < 1743756165
0.00185	SELECT p.topic_id, p.posted FROM forum_posts AS p WHERE p.id=4688
0.00071	SELECT COUNT(p.id) FROM forum_posts AS p WHERE p.topic_id=278 AND p.posted<1267526565
0.00511	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.00065	SELECT p.id FROM forum_posts AS p WHERE p.topic_id=278 ORDER BY p.id LIMIT 0,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 (4688) ORDER BY p.id
0.00047	UPDATE forum_topics SET num_views=num_views+1 WHERE id=278
0.01565	Temps total d'interrogation

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

Temps (s)

Interrogation

0.00033

SET NAMES 'utf8'

0.00489

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

0.00044

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

0.00037

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

0.00185

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

0.00071

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

0.00511

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

SELECT p.id FROM forum_posts AS p WHERE p.topic_id=278 ORDER BY p.id LIMIT 0,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 (4688) ORDER BY p.id

0.00047

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

0.01565

Temps total d'interrogation