.png){kind=small}
Explain:
id越大优先执行
PROFILES:
可以查看sql执行具体每一步的执行耗时，可用于区别耗时是在网络传输还是在sql执行期间。
SET profiling = 1;
-----SQL;
SHOW PROFILES; (查看query_id)
SHOW PROFILE FOR QUERY 238;
SELECT SUM(Duration) AS TotalDuration
FROM information_schema.profiling
WHERE Query_ID = 238;