perf: Ensure count query select minimal columns

perf: Ensure count query select minimal columns #8961