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¶