Ok, I don't necessarily think it's just that query. It seems to randomly hang anywhere (some places seem to hang more consistently). While it's hanging I can run queries through phpmyadmin just fine (even then My Buddies query).

Odd thing is, even if it's hanging in one tab. I can open up another and still get some pages to load up, even one that hung before.

I can't think of any changes in 7.5 that would cause this. Like you said, even trying to submit a control panel page (one that only adds to the admin log) might end up hanging.

Normally, if it's a query causing issues, when you look at the processlist, that query will be listed. I'm not seeing it at all, the processlist is normally empty. Catch a query once in a while, but disappears from the list quickly as it should.

Will check a few more things that I can think of.