As of today you can view your MySQL slow query logs in the Control Panel.
It allows you to easily see which queries take the longest and the details about those queries.

Just visit the new menu item called MySQL Slow Logs on a selected hypernode to see the slow queries logs on your hypernodes.