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

问题描述

有没有一种方法可以让 CakePHP 按需转储其 SQL 日志?我想执行代码直到我的控制器中的某个点为止，并查看已运行的 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屋！