refactor(perf): replace account subquery with 'in' condition (backport #39023)

refactor(perf): replace account subquery with 'in' condition (backport #39023) #18431