LIMIT 查询2000条记录得表

Question

呵呵，连接没有关闭。总算搞明白了。
用SHOW PROCESSLIST看到得，只是奇怪SLEEP了几百秒得连接怎么还在，呵呵
我在连接池里面得abandon time 设置了60秒。
+----+--------+-----------+-------+---------+------+-------+------------------+
| Id | User   | Host      | db    | Command | Time | State | Info             |
+----+--------+-----------+-------+---------+------+-------+------------------+
|  7 | ODBC   | localhost | three | Query   | 0    | NULL  | SHOW PROCESSLIST |
| 32 | nobody | localhost | three | Sleep   | 146  |       | NULL             |
| 33 | nobody | localhost | three | Sleep   | 3    |       | NULL             |
| 34 | nobody | localhost | three | Sleep   | 9    |       | NULL             |
| 35 | nobody | localhost | three | Sleep   | 3    |       | NULL             |
| 36 | nobody | localhost | three | Sleep   | 219  |       | NULL             |
| 37 | nobody | localhost | three | Sleep   | 213  |       | NULL             |
+----+--------+-----------+-------+---------+------+-------+------------------+