Optimized database queries using: Indexes, inlcudes and cached columns.