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.