We previously took into account all possible Message-IDs found in the References header of incoming messages. We also don't try to match the `In-Reply-To` header separately, since it is supposed to be appended to the `References` header, when present.

This is all specified in RFC5322, section 3.6.4:
   https://datatracker.ietf.org/doc/html/rfc5322#section-3.6.4

However, for very long threads, the `References` field can contain dozens or even hundreds of previous Message-IDs, even though we generally care only about the last one.

This can be an issue for databases with a large number of messages, as the query planner could mistakenly choose a suboptimal plan (e.g. a Seq Scan or filtered Index Scan), rather than looping on the `message_id` index, which is the best plan.

Here we truncate the list of References to only include the last 32 ones. For most threads this will make no difference, as they have less than 32 referencs. For very long threads it should still pick up the last known Message-ID without trouble. And if the last 32 messages aren't known by the system, it's unlikely that the message should still be considered part of earlier threads - it's been sidetracked elsewhere.

PS: also simplify the `order` clause, as no secondary sort criterion is going to work after `ORDER BY id`.

# ARCHIVED PR
That's pull request was splited in two separate prs
`PART 1`: https://github.com/odoo/enterprise/pull/67683
`PART 2`: https://github.com/odoo/enterprise/pull/67684

## mrp_workorder: fix quantity consumed operation

With the new way of computing the quantity consumed,
it is no longer necessary to mark the move_raw_ids in
this function, since we call button_finish method right
after. In button_finish, we take responsability for
marking it as picked and updating the quantity consumed

## clean up _post_inventory tests

This commit add 2 simple refactor to our existing
tests, they are:
-> _post_inventory
calling button_mark_done() will call _post_inventory,
so, it is not needed to call _post_inventory to test
the flow.
-> consumed quantities
Fixing some tests to make sure that the current
flow will not mark the picked as box when we change
the quantity produced.

## stock_barcode_mrp: fix misstyping on saveFormView

Before the commit, the condition inside saveFormView
was returning True, because the same content was fit
in two diferents types. The fix for it was just assert
the id and the name of the content.

task: 3810344