optimize prepaid balance query, #24846