[#3548313] fix: Make faster entity queries querying the latest revision with lots of revisions on 10.5

Liam Morlandrequested to merge
issue/drupal-3548313:3548313-updating-to-10.5.3 into 10.5.x

Closes #3548313.

This is has the same content as !13268 (closed).

Merge request reports