Symfony中的Doctrine查询中的指令？

$query = $em->createQuery('SELECT u FROM User u WHERE u.name = :name');
$user = $query->setParameter('name', 'John Doe')->getSingleResult();

$query = $em->createQuery('UPDATE User u SET u.name = :newName WHERE u.id = :id');
$query->setParameter('newName', 'Jane Doe')->setParameter('id', 1)->execute();

$query = $em->createQuery('DELETE FROM User u WHERE u.id = :id');
$query->setParameter('id', 1)->execute();

$user = new User();
$user->setName('John Doe');
$em->persist($user);
$em->flush();

$query = $em->createQuery('SELECT u, p FROM User u JOIN u.phoneNumbers p WHERE u.name = :name');
$user = $query->setParameter('name', 'John Doe')->getSingleResult();

$query = $em->createQuery('SELECT u FROM User u WHERE u.name = :name AND u.age > :age');
$user = $query->setParameter('name', 'John Doe')->setParameter('age', 18)->getSingleResult();

$query = $em->createQuery('SELECT u FROM User u ORDER BY u.name ASC');
$users = $query->getResult();

$query = $em->createQuery('SELECT u.name, COUNT(u) FROM User u GROUP BY u.name');
$users = $query->getResult();

$query = $em->createQuery('SELECT u.name, COUNT(u) FROM User u GROUP BY u.name HAVING COUNT(u) > :count');
$users = $query->setParameter('count', 10)->getResult();

$query = $em->createQuery('SELECT u FROM User u ORDER BY u.name ASC');
$users = $query->setMaxResults(10)->getResult();

$query = $em->createQuery('SELECT u FROM User u ORDER BY u.name ASC');
$users = $query->setFirstResult(10)->setMaxResults(10)->getResult();