mysql> show processlist;
+--------+----------------------+-----------+--------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+----------------------+-----------+--------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| 174706 | root | localhost | discuz | Query | 3 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174757 | root | localhost | discuz | Query | 44 | Locked | UPDATE cdb_threads SET views=views+1 WHERE tid='43545' |
| 174857 | root | localhost | discuz | Query | 14 | NULL | UPDATE cdb_threads SET views=views+1 WHERE tid='157905' |
| 174859 | root | localhost | discuz | Query | 3 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174871 | root | localhost | discuz | Query | 2 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174873 | root | localhost | discuz | Query | 3 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174875 | root | localhost | discuz | Query | 12 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='162133' |
| 174889 | root | localhost | discuz | Query | 3 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174891 | root | localhost | discuz | Query | 2 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174892 | root | localhost | discuz | Query | 8 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='122516' |
| 174897 | root | localhost | discuz | Query | 8 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='162196' |
| 174900 | root | localhost | discuz | Query | 9 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='21821' |
| 174901 | root | localhost | discuz | Query | 8 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='162202' |
| 174907 | root | localhost | discuz | Sleep | 1 | | NULL |
| 174912 | root | localhost | discuz | Query | 1 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174915 | root | localhost | discuz | Query | 7 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='162196' |
| 174917 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 174918 | root | localhost | discuz | Query | 2 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='119884' |
| 174923 | root | localhost | discuz | Query | 2 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='20840' |
| 174926 | root | localhost | discuz | Query | 1 | Sorting result | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174927 | root | localhost | discuz | Query | 1 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='18730' |
| 174928 | root | localhost | discuz | Query | 1 | System lock | UPDATE cdb_threads SET views=views+1 WHERE tid='2533' |
| 174932 | root | localhost | discuz | Sleep | 1 | | NULL |
| 174933 | root | localhost | discuz | Query | 1 | Reopen tables | UPDATE cdb_threads SET views=views+1 WHERE tid='125889' |
| 174934 | root | localhost | discuz | Sleep | 1 | | NULL |
| 174935 | root | localhost | discuz | Query | 1 | Writing to net | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174936 | root | localhost | discuz | Query | 1 | Writing to net | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174937 | root | localhost | discuz | Query | 0 | statistics | SELECT t.fid AS fid,
t.tid AS tid,
t.subject AS subject,
t.author AS auth |
| 174938 | root | localhost | discuz | Sleep | 1 | | NULL |
| 174939 | root | localhost | discuz | Query | 1 | statistics | SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS f |
| 174940 | root | localhost | discuz | Query | 0 | NULL | SELECT p.tid AS tid,
p.pid AS pid,
p.dateline AS dateline,
p.author AS au |
| 174941 | unauthenticated user | localhost | NULL | Connect | NULL | login | NULL |
+--------+----------------------+-----------+--------+---------+------+----------------+-------------------------------------------------