Slow SQL Query..

Hey guys.

I have a highly customized WP size that uses apache/php/mysql

I found these really slow queries that run constantly and take 4-7seconds each time. I believe its killing the CPU

Im seeking to know what they are, if they are normal and if not how to fix/remove

[Code moderated as per the Forum Rules. Please use the pastebin]

Thank you!