SQL Debugger

Writing a complicated SQL query with the doctrine query builder can be a difficult task. kreXX offers some assistance here:

When analysing a query builder or a query object itself, kreXX tries to extract the sql query from the object.

$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable('pages');
$queryBuilder
    ->select('uid')
    ->from('pages')
    ->where($queryBuilder->expr()->eq('title', $queryBuilder->createNamedParameter('Home')));

krexx($queryBuilder);
$result = $queryBuilder->execute();
krexx($result);

SQL debugger in action