使用mysql profiling功能剖析单条查询

http://blog.youkuaiyun.com/caomiao2006/article/details/52140965

SET profiling=1;

-- 你的查询语句
select * from yin_order_info where order_id =1233;

SHOW PROFILES;

从上述结果里取得　Query_ID
假设上述SQL语句Query_ID为22，则执行
SHOW PROFILE FOR QUERY 22;