Seems I'm better with jtag cables than with mysql queries. I just did some judicious adding of indexes and now the site should be responsive again.

Your link doesn't work for me. Here's the Google cache

https://webcache.googleusercontent.com/search?q=cache:V9xiN-...