Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Drupal 8 - Print raw SQL queries for debugging
<?php
/**
* Debugging using the database connection.
*/
/** @var \Drupal\Core\Database\Connection */
$connection = \Drupal::service('database');
$query = $connection->select('node', 'node');
$query->fields('node', ['nid'])
->condition('node.type', 'page')
// Debug.
dump($query->__toString());
<?php
/**
* Debugging using the query factory.
*/
// Update the Drupal\Core\Entity\Query\Sql\Query & change the property $sqlQuery to be public then...
$queryFactory = \Drupal::service('entity.query');
$query = $queryFactory->get('node');
$query->condition('type', 'page'):
// Debug.
dump($query->execute());
dump($query->sqlQuery->__toString());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.