Magento2 带field的查询操作 Entity collection

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();

$collection = $objectManager->get('Magento\Directory\Model\ResourceModel\Region\Collection');

$collection->addAttributeToFilter($field, [ 'in' => $arr ]);
$collection->addAttributeToSort($field, 'desc');
$collection->addStoreFilter();
$collection->addUrlRewrite();
$collection->setPageSize( 10 );
$collection->addAttributeToSelect($field);

带field的查询
Entity collection有查询field的能力，只要查询条件里跟field有关，就会自动把field所在的表join到查询中

$collection->addAttributeToSelect($field, 'left'); // 等同于select xx as field ... left join xxx
$collection->addAttributeToFilter($field, 'field > 0')// 等同于where field > 0
$collection->setOrder($field, 'ASC'); // 等同于order by xxx ASC