站直了，别趴下

$em = $this->getEntityManager; $qb = $em->createQueryBuilder; $qb->select(array('a', 'c')) ->from('Sdz\BlogBundle\Entity\Article', 'a') ->leftJoin('a.comments', 'c'); $query = $qb->getQuery(); $results = $query->getResult(); return $results; 同时select 多个table

NOW() INTERVAL 1 HOUR if you wannt to comapre somthing, try to use this; ->andWhere('o.actionTime > :date') ->setParameters(array('status' =>$status, 'userId'=>$userId,'date'=>new \DateTime('-12 hour')));