| 0.00508 |
SELECT u.*, g.*, o.logged, o.idle FROM users AS u INNER JOIN groups AS g ON u.group_id=g.g_id LEFT JOIN online AS o ON o.user_id=u.id WHERE u.id=2 |
| 0.00078 |
UPDATE online SET logged=1193936576 WHERE user_id=2 |
| 0.00081 |
SELECT * FROM online WHERE logged<1193936276 |
| 0.00081 |
DELETE FROM online WHERE ident='88.108.252.211' |
| 0.00213 |
SELECT COUNT(id)-1 FROM users |
| 0.00125 |
SELECT id, username FROM users ORDER BY registered DESC LIMIT 1 |
| 0.00147 |
SELECT SUM(num_topics), SUM(num_posts) FROM forums |
| 0.00179 |
SELECT user_id, ident FROM online WHERE idle=0 ORDER BY ident |
| 0.00943 |
SELECT username, num_posts, id FROM users WHERE id > 1 ORDER BY num_posts DESC LIMIT 5 |
| 0.00426 |
SELECT COUNT(id) FROM reports WHERE zapped IS NULL |
| 0.00209 |
SELECT COUNT(id) FROM messages WHERE showed=0 AND owner=2 |
| 0.00324 |
SELECT *, (SELECT COUNT(id) AS `clancount` FROM users WHERE clanid=clans.id AND clanverif='1') AS `clancount` FROM clans ORDER BY clanname DESC |
| Total query time: 0.03314 s |
