查看mysql 语句执行时间

           开启profile==》查询表==》显示时间

1. mysql> set profiling=1;
   Query OK, 0 rows affected (0.00 sec)

2. mysql> select * from t_user;

3. mysql> show profiles;
   +----------+----------+----------------------+
   | Query_ID | Duration | Query                |
   +----------+----------+----------------------+
   |        1 | 0.277744 | select * from t_user |
   +----------+----------+----------------------+
   1 row in set

转载于:https://my.oschina.net/yangfeima/blog/665544