Do you know of any way to display queries executed in Lithium like in CakePHP? It might be easier for me to find the implementation. The executed query is displayed at the bottom of the page.
![Screenshot]http://imgur.com/ffNfQ
After receiving the answer, I added the code to my controller:
Volumes::applyFilter('find', function($self, $params, $chain) {
echo '<pre>===== self ======<br>';
var_dump($self);
echo '===== params ======<br>';
var_dump($params);
echo '===== chain ======<br>';
var_dump($chain);
echo '</pre>';
$next = $chain->next($self, $params, $chain);
return $next;
});
It gives me the output of all var_dump regarding self and params but I need to execute the SQL query.
Please see the screenshot http://imgur.com/ffNfQ
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
As @Nils suggested, you can leverage Lithium filters and write a simple query logger.
Imade one here. It logs the
readquery to a file in theproductenvironment.You should be able to customize and add filters to the
create,update, anddeleteactions to suit your needs.If you are looking for an out-of-the-box solution, such as Cake's debug toolbar, check out the
li3_perfproject: https://github.com/tmaiaroto/li3_perfFollowing all the suggestions from Nils and Mehdi, I created a new plugin that only displays query results and not vardump or print_r() of queries executed in Lithium using MongoDB.
Now it's really easier for me to find what it's doing.
You can view the project on Github:
https://github.com/nilamdoc/li3_show