How to print query in Symfony?

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18

use DoctrineDBALConnection;
use DoctrineDBALQueryQueryBuilder;

// Get the doctrine connection
$connection = $this->getDoctrine()->getConnection();

// Create a query builder
$queryBuilder = new QueryBuilder($connection);

// Build your query
$queryBuilder
    ->select('*')
    ->from('users', 'u')
    ->where('u.id = :id')
    ->setParameter(':id', 1);

// Print the generated SQL
echo $queryBuilder->getSQL();

1

$result = $queryBuilder->execute();