Answered by : wideeyed-wombat-jcnk2oqb5mxt

$log = $this->User->getDataSource()->getLog(false, false);
debug($log);

Source : https://stackoverflow.com/questions/3647065/how-can-i-see-cakephps-sql-dump-in-the-controller | Last Update : Sun, 08 Aug 21

Answered by : wideeyed-wombat-jcnk2oqb5mxt

$db =& ConnectionManager::getDataSource('default');
$db->showLog();

Source : https://stackoverflow.com/questions/3647065/how-can-i-see-cakephps-sql-dump-in-the-controller | Last Update : Sun, 08 Aug 21

Answered by : wideeyed-wombat-jcnk2oqb5mxt

debug($this->User->lastQuery()); 

Source : https://stackoverflow.com/questions/3647065/how-can-i-see-cakephps-sql-dump-in-the-controller | Last Update : Sun, 08 Aug 21