MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
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.30, “SHOW PROFILE Statement”.
      
          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
          Section 25.19.1, “Query Profiling Using Performance Schema”.