Are you sure this is not a new requirement or bug?

No, a requirements would be:
As a product owner, I want the most common queries to be optimized to spend less computing resources
As a product owner, I want the most common queries to be optimized to be faster for our users

(they are not good requirements without quantitative criteria)

Task Type

Sub-task

Description

I am specifically thinking of the lid requests. But others could need optimization.

One possible optimization for the lid request could be to re-introduce the creation of a latest product in opensearch whenever a product with the latest vid is pushed in opensearch with harvest. Doing so, we would be able to search lid by id, e.g. {lid}::latest instead of doing a pre-query with a term match on lid.