[stable27] fix: Split query to fetch board ids to avoid slow query join

[stable27] fix: Split query to fetch board ids to avoid slow query join #2048