第一种:
开启profile
2 | Query OK, 0 rows affected (0.00 sec) |
eg:
1 | mysql> select * from test_1; |
3 | +----------+------------+----------------------+ |
4 | | Query_ID | Duration | Query | |
5 | +----------+------------+----------------------+ |
6 | | 1 | 0.84718100 | select * from test_1 | |
7 | +----------+------------+----------------------+ |
第二种:(通过时间差查看)
delimiter //
set @d=now();
select * from comment;
select timestampdiff(second,@d,now());
delimiter ;
Query OK, 0 rows affected (1 min 55.58 sec)
+----------------------------------+
| timestampdiff(second, @d, now()) |
+----------------------------------+
| 2 |
+----------------------------------+
1 row in set (1 min 55.58 sec)
原文出自:http://my.oschina.net/yyping/blog/108245
转载于:https://blog.51cto.com/yyping2008/1139760