chris-at-github
1/19/2015 - 4:39 PM

Methode um Extbase SQl zu debuggen

Methode um Extbase SQl zu debuggen

public function debugQuery(\TYPO3\CMS\Extbase\Persistence\Generic\QueryResult $queryResult) {
  $GLOBALS['TYPO3_DB']->debugOuput = 2;
  $GLOBALS['TYPO3_DB']->store_lastBuiltQuery = true;
  $queryResult->toArray();
  
  echo $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery;

  $GLOBALS['TYPO3_DB']->store_lastBuiltQuery = false;
  $GLOBALS['TYPO3_DB']->explainOutput = false;
  $GLOBALS['TYPO3_DB']->debugOuput = false;
}
$queryParser = $this->objectManager->get(\TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbQueryParser::class);
echo ($queryParser->convertQueryToDoctrineQueryBuilder($query)->getSQL());
\TYPO3\CMS\Extbase\Utility\DebuggerUtility::var_dump($queryParser->convertQueryToDoctrineQueryBuilder($query)->getParameters());