Skip to content

Instantly share code, notes, and snippets.

@DavidBruchmann

DavidBruchmann/debug-sql

Forked from rvollebregt/debug-sql
Last active January 14, 2022 04:27
Show Gist options
  • Save DavidBruchmann/97615c14f8ff8384e81a05ff1a4031ba to your computer and use it in GitHub Desktop.
Save DavidBruchmann/97615c14f8ff8384e81a05ff1a4031ba to your computer and use it in GitHub Desktop.
Download ZIP
Debug SQL query in TYPO3 8 Extbase
Raw
debug-sql
/** @var ObjectManager $objm */
$dbParser = $this->objectManager->get(\TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbQueryParser::class);
$doctrineQueryBuilder = $dbParser->convertQueryToDoctrineQueryBuilder($query);
$sql = $doctrineQueryBuilder->getSQL();
$parameters = $doctrineQueryBuilder->getParameters();
\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump(['sql' => $sql, 'parameters' => $parameters], __METHOD__ . ':' . __LINE__);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment