Paginator should set limit in WHERE IN query

[msiwak-edi]

In some cases, the database optimizer cannot correctly decide to use indexes in queries with WHERE IN. The solution is to force the index or, in cases like a paginator, to limit the query.

However, the paginator now clears the maxResults:

orm/src/Tools/Pagination/Paginator.php

Line 139 in b1f8253

$whereInQuery->setFirstResult(0)->setMaxResults(null);

Some proof
Without limit:

With limit: