perf(messages): caches unread messages count to reduce queries

Fixes #6942, #6640