The purpose of this PR is to be able to process a lot of serial numbers at once. In receipt and deliveries
In the current situation, the number of serial already in stock has an impact on the perf (due to `update_available_quantity` that do a `_gather` on current stock). All the metrics below are made with 50 000 SN already in stock

Before (in seconds):
|| Receipt | Delivery |
|--------|--------|--------|
|100| 1.63 | 34.21 |
|5000| 87.04 | 242.56 |
|30 000| 563.75 | T.O. | 

After:
|| Receipt | Delivery |
|--------|--------|--------|
|100| 0.91 | 5.62 |
|5000| 47.21 | 56.28 |
|30 000| 195.27 | 307.80 | 

By operations/ receipts (for 5000):
|  | action_assign | button_validate | total |
|--------|--------|--------|--------|
| Before patch | 5.38 |  82.02 | 87.04 |
| After patch | 3.82 |  43.39 | 47.21  |

By operations/ deliveries (for 5000):
|  | action_assign |  button_validate | total |
|--------|--------|--------|--------|
| Before patch | 180.06 | 62.50 | 242.56 |
| After patch | 20.51 |35.77 | 56.28 |

The main issues:
- The constraint check on quant/stock.move.line are done one by one since there is nothing done in batch, same for computed field (Not fixed here)
![delivery-pre-patch](https://github.com/odoo/odoo/assets/5512395/8a7294f1-67b9-45aa-8aa9-8cf3cfc071be)
- The put away takes an important amount of times without any putaways rules
![putaways](https://github.com/odoo/odoo/assets/5512395/43e63984-2724-409e-ad31-91d193ea3c0c)
- The optimisation made in  #116803 was a good idea but it was only use in action_assign. `_action_assign` use strict=False in `_gather` (mts case). It means a child_of operator is in the domain, and it will perform an extra query anyway
- The lot_name matching to lot_id is made `stock.move.line` by `stock.move.line` on 30 000, half of the time is spent to find them.
![search_lot_name](https://github.com/odoo/odoo/assets/5512395/83a16210-f85e-4a48-bab8-7db269343b1c)

After some testing. The quant_cache could contain too many items than needed by the current operation. Example receive 1 serial number (that will not have an existing quant) will use a quant_cache with all the serial number of the products. As a result, the group by will be super slow. Allow to add an extra domain, to limit the cache size. /!\ could be dangerous if it filter out too much
![extra_domain](https://github.com/odoo/odoo/assets/5512395/42921423-b38d-4686-897f-d2a2c16e9d97)

Forward-Port-Of: odoo/odoo#154619
Forward-Port-Of: odoo/odoo#146494