MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
SHOW PROFILES
The SHOW PROFILES statement,
together with SHOW PROFILE,
displays profiling information that indicates resource usage for
statements executed during the course of the current session.
For more information, see Section 13.7.5.31, “SHOW PROFILE Statement”.
These statements are deprecated as of MySQL 5.6.7; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Chapter 22, MySQL Performance Schema.