The most frequently access parts of the site are always in flux with users constantly adding, removing, and editing content.
I don’t know how you could statically generate that. At most, you could memoize the parts of the page that haven’t changed yet and return them without a complete lookup, but keeping that in synch with a database is not an easy problem.