mysql - How to debug a query in extbase?

Question

$query = $this->createQuery();

    return $query->matching($query->like('linker', "$linkerKey=$linkerValue"))
        ->setOrderings(array('crdate' => $ordering))
        ->execute();

How can i debug such a generated query in extbase? When creating the same query again (but without the execute() ) and trying to display it with var_dump or the internal t3lib_div::debug i just receive a blank page.

Answer 1

In version 8.7 LTS, another way needs to be taken:

$queryParser = $this->objectManager->get(TYPO3CMSExtbasePersistenceGenericStorageTypo3DbQueryParser::class);
TYPO3CMSExtbaseUtilityDebuggerUtility::var_dump($queryParser->convertQueryToDoctrineQueryBuilder($query)->getSQL());
TYPO3CMSExtbaseUtilityDebuggerUtility::var_dump($queryParser->convertQueryToDoctrineQueryBuilder($query)->getParameters());