mysql> show full processlist;
+--------+------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Id     | User | Host      | db          | Command | Time | State        | Info                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
+--------+------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 295865 | root | localhost | NULL        | Query   |    0 | NULL         | show full processlist                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| 296105 | root | localhost | smartorrent | Query   |    0 | Locked       | UPDATE bts_users SET last_seen = '1175971510', last_seen_where = '' WHERE uid = '379107'                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| 296106 | root | localhost | smartorrent | Query   |    1 | Sending data | SELECT t.torrentid, t.name, t.filesize, t.catid, t.submitter, t.submit_date, t.votes, t.score, t.info_hash, t.hidden,
                        xf.fid, xf.seeders, xf.leechers, xf.completed, 
                        c.name AS cname, c.catid,
                        c2.name AS c2name, c2.catid AS cid,
                        u.username, u.class,
                        ug.openhtml, ug.closehtml
                        FROM bts_torrents t
                        LEFT JOIN bts_cats c ON c.catid=t.catid
                        LEFT JOIN bts_cats c2 ON c2.catid=t.subcat
                        INNER JOIN xbt_files xf ON xf.info_hash=t.info_hash
                        INNER JOIN bts_users u ON u.uid=t.submitter
                        INNER JOIN bts_usergroups ug ON ug.gid=u.class AND hidden != 1 AND t.dead != 1                                                              |
| 296108 | root | localhost | smartorrent | Query   |    1 | Sending data | SELECT t.torrentid, t.name, t.filesize, t.catid, t.submitter, t.submit_date, t.votes, t.score, t.info_hash, t.hidden,
                        xf.fid, xf.seeders, xf.leechers, xf.completed, 
                        c.name AS cname, c.catid,
                        c2.name AS c2name, c2.catid AS cid,
                        u.username, u.class,
                        ug.openhtml, ug.closehtml
                        FROM bts_torrents t
                        LEFT JOIN bts_cats c ON c.catid=t.catid
                        LEFT JOIN bts_cats c2 ON c2.catid=t.subcat
                        INNER JOIN xbt_files xf ON xf.info_hash=t.info_hash
                        INNER JOIN bts_users u ON u.uid=t.submitter
                        INNER JOIN bts_usergroups ug ON ug.gid=u.class AND hidden != 1 AND t.dead != 1                                                              |
| 296110 | root | localhost | smartorrent | Query   |    0 | Locked       | SELECT t.torrentid, t.name, t.filesize, t.catid, t.submitter, t.submit_date, t.votes, t.score, t.info_hash, t.hidden,
                        xf.fid, xf.seeders, xf.leechers, xf.completed, 
                        c.name AS cname, c.catid,
                        c2.name AS c2name, c2.catid AS cid,
                        u.username, u.class,
                        ug.openhtml, ug.closehtml
                        FROM bts_torrents t
                        LEFT JOIN bts_cats c ON c.catid=t.catid
                        LEFT JOIN bts_cats c2 ON c2.catid=t.subcat
                        INNER JOIN xbt_files xf ON xf.info_hash=t.info_hash
                        INNER JOIN bts_users u ON u.uid=t.submitter
                        INNER JOIN bts_usergroups ug ON ug.gid=u.class WHERE t.name LIKE '%%' AND hidden != 1 AND t.dead != 1 ORDER BY t.torrentid DESC LIMIT 60,30 |
| 296111 | root | localhost | smartorrent | Query   |    0 | Locked       | SELECT t.id, t.tid, t.text, t.date, u.username, u.ccount, u.reg_date, ug.class, ug.openhtml, ug.closehtml
                                                                        FROM bts_tcomments t
                                                                        LEFT JOIN bts_users u ON u.uid = t.poster
                                                                        LEFT JOIN bts_usergroups ug ON ug.gid = u.class
                                                                WHERE t.tid =29187
                                                                        ORDER BY t.date DESC LIMIT 0,10                                                                                                                                                                                                                                                                                                                                               |
| 296112 | root | localhost | smartorrent | Query   |    0 | Locked       | SELECT count(*) as c FROM bts_users                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |
| 296113 | root | localhost | smartorrent | Query   |    0 | Locked       | SELECT t.torrentid, t.name, t.filesize, t.catid, t.submitter, t.submit_date, t.votes, t.score, t.info_hash, t.hidden,
                        xf.fid, xf.seeders, xf.leechers, xf.completed, 
                        c.name AS cname, c.catid,
                        c2.name AS c2name, c2.catid AS cid,
                        u.username, u.class,
                        ug.openhtml, ug.closehtml
                        FROM bts_torrents t
                        LEFT JOIN bts_cats c ON c.catid=t.catid
                        LEFT JOIN bts_cats c2 ON c2.catid=t.subcat
                        INNER JOIN xbt_files xf ON xf.info_hash=t.info_hash
                        INNER JOIN bts_users u ON u.uid=t.submitter
                        INNER JOIN bts_usergroups ug ON ug.gid=u.class WHERE t.name LIKE '%%' AND hidden != 1 AND t.dead != 1 ORDER BY t.torrentid DESC LIMIT 30,30 |
+--------+------+-----------+-------------+---------+------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
8 rows in set (0.00 sec)

mysql>