fix: Split query to fetch board ids to avoid slow query join

fix: Split query to fetch board ids to avoid slow query join #7984