TYPO3 Debug last SQL Statement¶
You often need to debug your SQL-Statements. That isn’t difficult, because TYPO3 give you easy to use functions for this situation:
$GLOBALS['TYPO3_DB']->store_lastBuiltQuery = 1; // Execute your code and query. echo $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery;
Just add the first line before you execute your SQL-Statement. Then echo the Query with the second line after you executed it.
Of course this only will work if you execute the queries with the TYPO3 functions.