php – Symfony2 Doctrine Eager在查询中加载

我使用Symfony 2.4.2我有两个Doctrine实体.名称：城市和城镇.

关系结构：

城市 – > Town = OneToMany
镇 – > City = ManyToOne

实体/ City.PHP

/**
 * @ORM\OneToMany(targetEntity="Town",mappedBy="city")
 */
private $towns;

实体/ Town.PHP

/**
 * @ORM\ManyToOne(targetEntity="City",inversedBy="towns")
 * @ORM\Joincolumn(name="city_id",referencedcolumnName="id")
 */
private $city;

其中In Query未在第二和第三项中运行.

1-)Town =>城市查询(工作)Profiler SS：http://prntscr.com/34lx9q

$query = $this->_entitymanager->createQuery('SELECT town FROM PersonalSiteBundle:Town town');
$query->setFetchMode(
    'Personal\SiteBundle\Entity\Town',"city",\Doctrine\ORM\Mapping\ClassMetadata::FETCH_EAGER
);
$query->execute();

2-)Town => City Query(Not Working)Profiler SS：http://prntscr.com/34ly4h

$query = $this->_entitymanager->createQuery('SELECT town FROM PersonalSiteBundle:Town town');
$query->setFetchMode(
    'Personal\SiteBundle\Entity\Town',\Doctrine\ORM\Mapping\ClassMetadata::FETCH_EAGER
);
$query->execute(array(),Query::HYDRATE_ARRAY);

3-)City => Town Query(Not Working)Profiler SS：http://prntscr.com/34ly4h

$query = $this->_entitymanager->createQuery('SELECT city FROM PersonalSiteBundle:City city');
$query->setFetchMode(
    'Personal\SiteBundle\Entity\City',"towns",Query::HYDRATE_ARRAY);

$qb = $this->createQueryBuilder('city')
    ->addSELEct('town')
    ->innerJoin('town.city','city');
$cities = $qb->getQuery()->getResult();