Have you enabled and looked at the slow query log?

https://dev.mysql.com/doc/refman/5.7/en/log-destinations.html

Here's a broad approach: https://coderpad.io/blog/development/optimize-query-performance-mysql/

@matt