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>