Debug SQL Queries in TYPO3 Repository (Extbase)

gistfile1.txt

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 . '\'';
    }
    krsort($search);
    krsort($replace);
    $sql = str_replace($search, $replace, $doctrineSql);
    echo($sql . '<hr>');
    echo($doctrineSql . '<hr>');
    die();
}