学说 2 使用太多 SQL 查询加载一对多关联与 fetch 模式急切

but it does not work as described.

我的代码:

class User{
    /**
     * @ORMOneToMany(targetEntity="Address", mappedBy="user", indexBy="id", fetch="EAGER")
     */
    protected $addresses;
    public function __construct(){
        $this->addresses = new ArrayCollection();
    }
}

class Address{
    /**
     * @ORMManyToOne(targetEntity="User", inversedBy="addresses")
     * @ORMJoinColumns({
     *   @ORMJoinColumn(name="UserId", referencedColumnName="id")
     * })
     */
    private $user;
}

class UserRepository{
    public function findUsersWithAddresses(){
        return $this->getEntityManager()
            ->createQuery('SELECT u FROM MyBundle:User u ORDER BY u.name ASC')
            ->setFetchMode('MyBundleEntityUser', 'addresses', DoctrineORMMappingClassMetadata::FETCH_EAGER)
            ->setMaxResults(10)
            ->getResult();
    }
}

方法 UserRepository::findUsersWithAddresses() 执行 11 个 SQL 查询.