'pdo_mysql',
    'user'     => 'root',
    'password' => 'test',
    'dbname'   => 'test',
);

$config = Setup::createAnnotationMetadataConfiguration($paths, $isDevMode);
$logger = new \Doctrine\DBAL\Logging\DebugStack();
$config->setSQLLogger($logger);
$entityManager = EntityManager::create($dbParams, $config);


/**
 * @Entity
 * @Table(name="shop")
 */
class Shop {

  /** @Id @GeneratedValue @Column(type="integer") */
  public $id;

  /** @Column(type="string") */
  public $name;

  /**
   * @OneToMany(targetEntity="Goods", mappedBy="shop")
   */
  public $goods;


  public function __construct() {
  }
}

/**
 * @Entity
 * @Table(name="goods")
 */
class Goods {

  /** @Id @GeneratedValue @Column(type="integer") */
  public $id;

  /** @Column(name="id_shop")*/
  public $idShop;

  /**
   * @ManyToOne(targetEntity="Shop", inversedBy="goods", fetch="EAGER")
   * @JoinColumn(name="id_shop", referencedColumnName="id")
   **/
  public $shop;

  /** @Column */
  public $name;

}

$shopRepository = $entityManager->getRepository('\Shop');
$shops = $shopRepository->findAll();

echo "
\n";
//print_r($shops);

foreach ($shops as $shop) {
  //$shop->goods = null;
  //print_r($shop);


  echo $shop->id."-";
  echo count($shop->goods)."\n";
  foreach ($shop->goods as $goods) {
    echo $goods->name.";";
  }
  echo "\n";

}

foreach ($logger->queries as $q) {
  echo SqlFormatter::format($q['sql'])."
\r\n";
}

?>