mysql 如何查看sql语句执行时间

查看执行时间

1 show profiles; 
2 show variables;查看profiling 是否是on状态； 
3 如果是off，则 set profiling = 1； 
4 执行自己的sql语句； 
5 show profiles；就可以查到sql语句的执行时间；

 

实例操作：

mysql> show variables like '%profiling%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| have_profiling         | YES   |
| profiling              | ON    |
| profiling_history_size | 15    |
+------------------------+-------+
3 rows in set (0.14 sec)

如果 profiling 是off，  则

mysql> set profiling=1;


执行自己的 sql 语句后

mysql> show  profiles;
+----------+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Query_ID | Duration    | Query                                                                                                                                                                                                                                                                                                      |
+----------+-------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|        1 | 55.04466800 | select a.s*****************otScore, a.hot_star as hotLevel, b.title as itemName, b.pic_url as picUrl,
     ifnull(b.cprice,b.sprice) as price, b.first_day_sale as sale
     from ( select item_id, shop_id, zhiyi_tag, hot_score, hot_s |