Do not join with the target table of Many2One for clause on id
When the clause on a Many2One result in a search domain on the target as [('id', <operator>, <value>)]
, there is no point to make a join, the clause can be applied directly on the column of the field.