Odd. I can run that query from the SQL command window and it comes back right away. I added an index on the entry id, which made it even quicker.
Debugging the showprofile page and it definitely hangs on that query. Run a show processlist while it's hanging, and it's not showing that query at all.
Definitely getting hangs in other places as well, like you said, even submitting a control panel update. I tried doing one where the only SQL query it does is add to the admin log table and that's hanging as well.
So it doesn't necessarily appear to be that query. It hangs when I try to bring up the database tools like in the control panel as well. Right now it's hanging when I try to even bring up the control panel page.
Do you have anything like phpmyadmin installed?
