fchaussin

function debug($query){
    $doctrineObj = $this->objectManager
        ->get(\TYPO3\CMS\Extbase\Persistence\Generic\Storage\Typo3DbQueryParser::class)
        ->convertQueryToDoctrineQueryBuilder($query);
    $doctrineSql = $doctrineObj->getSQL();
    $params = $doctrineObj->getParameters();
    $search =  $replace = [];
    foreach ($params as $k => $v) {
        $search[] = ':' . $k;
        $replace[] = '\'' . $v . '\'';