Optimization of a narrow queries in Mysql

Hello, you need to do an audit and figure out which queries in the database should be optimized, and then these requests to optimize. We suspect some php files most loaded dB when you use them, but we could be wrong.

What is it: competitors use clickers in certain places of the site and this page opens very slow, although the server we have a powerful (free resources 90%). We understand that this is due to existing bottlenecks, if they optimize, that they have more such opportunity.