> just some common-sense SQL optimizations.

Thats probably it. Some beginner has written an n+1 query and the page is slow as shit now.