The follower count is visibly wrong

• A profile shows 1,240 followers but listing the followers returns 1,207.
• The discrepancy varies per user and grows over time.

SELECT u.follower_count AS cached, count(f.id) AS actual
FROM users u LEFT JOIN follows f ON f.followee_id = u.id
WHERE u.id = 7 GROUP BY u.follower_count;
  cached: 1240   actual: 1207   drift: 33