How can I see CakePHP's SQL dump in the controller?

Question

Is there any of the way that one can cause CakePHP to dump its SQL log on demand? I would like to execute code up until a point in my controller and see what SQL has been run.

Answer 1

Try the following:

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

You will need to do this for each data source if you are having more than one though.

Check out here for more information.

Join the SQL Training course if you want to gain more knowledge in SQL.