<p>Is there any way to see an overview of what kind of queries are spent the most time on every day on MySQL?</p>

You can always set up query logging as described here:
http://dev.mysql.com/doc/refman/5.0/en/query-log.html