How to debug the last sql statement in Typo3

Hey … it’s very simple to get the last sql statement. Before the execution of the statement write this:

$GLOBALS['TYPO3_DB']->store_lastBuiltQuery = 1;

Then execute the statement. After that you can query the sql string with:

echo $GLOBALS['TYPO3_DB']->debug_lastBuiltQuery;