Syntax:
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 [HELP SHOW PROFILE].

*Note*:

The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect
them to be removed in a future MySQL release. Use the Performance
Schema instead; see
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profil
ing.html.

URL: https://dev.mysql.com/doc/refman/5.7/en/show-profiles.html

