如何在控制器中看到CakePHP的SQL转储？ [英] How can I see CakePHP's SQL dump in the controller?

问题描述

有没有办法让CakePHP根据需要转储其SQL日志？

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

推荐答案

试试这个：

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

http://api.cakephp.org/2.3/class-Model.html#_getDataSource

您必须这样做每个数据源，如果你有多个。

You will have to do this for each datasource if you have more than one though.

这篇关于如何在控制器中看到CakePHP的SQL转储？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！