How to identify what is causing unusual high CPU load in MySQL?
The slowlog.  Granted, this picks up on both high CPU and high I/O, but still it will give you what you are looking for.

Suggestions on digesting, etc: http://mysql.rjweb.org/doc.php/mysql_analysis#slow_queries_and_slowlog

Often the 'cure' is an appropriate composite index.