Geplaatst: 05-06-04 12:05 0,0010068416595459 seconds
SELECT t.topic_id, t.topic_title, t.topic_poster, t.topic_status, t.topic_ad, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, t.topic_first_post_id, f.forum_name, f.forum_status, f.forum_id, f.cat_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments, f.events_forum , COUNT(p2.post_id) AS prev_posts FROM topics t, forums f, posts p, posts p2 WHERE p.post_id = 4238904 AND t.topic_id = p.topic_id AND p2.topic_id = p.topic_id AND p2.post_id <= 4238904 AND f.forum_id = t.forum_id GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_ad, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, t.topic_first_post_id, f.forum_name, f.forum_status, f.forum_id, f.cat_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments ORDER BY p.post_id ASC
0,011112928390503 seconds
SELECT u.*, s.* FROM sessions s, users u WHERE s.session_id = '0a9aedfd277465c6579764fb94ffb' AND u.user_id = s.session_user_id
0,0030670166015625 seconds
SELECT * FROM themes WHERE themes_id = 2
0,0010020732879639 seconds
SELECT a.forum_id, a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_mod FROM auth_access a, user_group ug WHERE ug.user_id = 2602 AND ug.user_pending = 0 AND a.group_id = ug.group_id AND a.forum_id = 25
0,0010278224945068 seconds
SELECT notify_status FROM topics_watch WHERE topic_id = 245030 AND user_id = 2602
0,00054001808166504 seconds
SELECT u.username, u.user_id, u.user_level, u.user_posts, u.user_from, u.user_postcode, u.user_website, u.user_email, u.user_icq, u.user_jabber, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, (YEAR(CURRENT_DATE)-YEAR(u.user_dob)) - (RIGHT(CURRENT_DATE,5) 0,035374879837036 seconds
SELECT * FROM ranks ORDER BY rank_special, rank_min
0,017024993896484 seconds
SELECT word, replacement FROM words
0,0032000541687012 seconds
UPDATE LOW_PRIORITY lastread SET forum_id = 25, lasttime = UNIX_TIMESTAMP()+2 WHERE topic_id = 245030 AND user_id = 2602
0,0019629001617432 seconds
UPDATE views SET views=views+1 WHERE day = NOW() && user_id = 2602
0,0005190372467041 seconds
UPDATE topics SET topic_views = topic_views + 1 WHERE topic_id = 245030
0,00043892860412598 seconds
Dit staat nu onder alle topics die ik open
