The "select" method retrieves all the entities for the input key list and sorts according to the user settings. Paging is taken into account when retrieving
the results. The result is a list of the entity objects containing all top level elements (restricted to the given page).
NOTE: Results usually need multiple one-to-many collections to be fetched. Although this could be done in one query with eager fetching, this strategy is not
recommended as it will lead to a potentially large Cartesian product. Therefore, the collections are initialized in separate queries during the mapping
stage. If the returned results are small (maxRows parameters is set appropriately), a single query is likely faster, but probably not by enough to consider
the optimization under these conditions.