## Description
Following ef90c22efda8a1d56d41eb0739d94733fb574f41, the delegated `_name_search` on `product.product` executed when performing a `name_search` on `product.template` is always unbounded (no limit). For non-selective domains on large databases, this can lead to manipulating extremely large lists of IDs, which are re-injected into other queries, resulting in performance regressions and excessive Postgres memory consumption.

We introduce an upper bound on the delegated `_name_search`. To avoid excessive iterations when there is no limit, the bound is set large enough but not so large that it causes blocking regressions. Each iteration becomes more selective than the previous one, as already found templates are excluded from the search scope.

## Benchmark
On a database with over half-million active products, a non-selective `name_search` that matches 1/3 of the products (For ex: `name='d', args=[('sale_ok', '=', True)]`, which happens during via dropdown of products on a `sale.order`):

|               | Before           | After |
|---------------|------------------|-------|
| Timings (hot) | 15min+ (timeout) | 50ms  |

## Reference
opw-4448182

---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

Forward-Port-Of: odoo/odoo#193293

An error occurs when the system tries to access single values from multiple records at [1].

Link [1]: https://github.com/odoo/enterprise/blob/2e1af04e36fcbdcd11e3a7e2994673b2c4a5cf85/social_youtube/models/res_config_settings.py#L19

Traceback On Sentry:

```
ValueError: Expected singleton: res.config.settings(105, 106)
  File "odoo/http.py", line 2366, in __call__
    response = request._serve_db()
  File "odoo/http.py", line 1894, in _serve_db
    return self._transactioning(
  File "odoo/http.py", line 1957, in _transactioning
    return service_model.retrying(func, env=self.env)
  File "odoo/service/model.py", line 137, in retrying
    result = func()
  File "odoo/http.py", line 1924, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "odoo/http.py", line 2171, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "odoo/addons/base/models/ir_http.py", line 329, in _dispatch
    result = endpoint(**request.params)
  File "odoo/http.py", line 727, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "addons/web/controllers/dataset.py", line 35, in call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "odoo/api.py", line 517, in call_kw
    result = getattr(recs, name)(*args, **kwargs)
  File "odoo/models.py", line 6090, in search_read
    return records._read_format(fnames=fields, **read_kwargs)
  File "odoo/models.py", line 4032, in _read_format
    vals[name] = convert(record[name], record, use_display_name)
  File "odoo/models.py", line 6999, in __getitem__
    return self._fields[key].__get__(self)
  File "odoo/fields.py", line 1291, in __get__
    self.compute_value(recs)
  File "odoo/fields.py", line 1473, in compute_value
    records._compute_field_value(self)
  File "odoo/models.py", line 5238, in _compute_field_value
    fields.determine(field.compute, self)
  File "odoo/fields.py", line 110, in determine
    return needle(*args)
  File "home/odoo/src/enterprise/18.0/social_youtube/models/res_config_settings.py", line 19, in _compute_youtube_oauth_client_id
    if self.env.user.has_group('social.group_social_manager') and self.youtube_use_own_account:
  File "odoo/fields.py", line 1232, in __get__
    record.ensure_one()
  File "odoo/models.py", line 6212, in ensure_one
    raise ValueError("Expected singleton: %s" % self)

```

To resolve this issue, Use an iteration(for loop) to iterate records one by one.

Sentry-6200420369

Forward-Port-Of: odoo/enterprise#76588