switch setup of entity tables to we check the base table first

Sascha Grossenbacherrequested to merge
issue/drupal-3589831:3589831-optimize-entity-queries into main

Closes #3589831

Merge request reports