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 it
to be removed in a future MySQL release. Use the Performance Schema
instead; see
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-query-profil
ing.html.

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

