Slow load on main page

[pipermerriam]

What is wrong

The main page takes a while to load. This tends to indicate that there's an expensive query involved. Maybe something that doesn't have an index that should? Or otherwise something that could be cached?

How can it be fixed

What queries get run to load the main page and figure out if there's a missing index or whether something should be cached.