<?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());