how do you get the last executed query in symfony doctrine?
something like lastQuery()
$repository = $this->container->get('doctrine')->getRepository('AcmeUserBundle:User');
$query = $repository->createQueryBuilder('v')->where('v.name = :r ')->setParameters(array('r' =>id))->setMaxResults(1)->getQuery();
$result = $query->getOneOrNullResult() ;
echo "
";
print_r(array(
'sql' => $query->getSQL(),
'parameters' => $query->getParameters(),
));
echo "
";
Comments