The MySQL slow query log is one helpful tool that helps system administrators to determine which queries are taking a longer-than-normal time to run. The only thing is.. how to read it so it's helpful?
If you don't have the slow query log enabled yet, do that first: mysql enable slow query...