How to get sql query in cakePHP

Question

I am using cakephp framework. I need SQL for following statement:

$vehicle = $this->Vehicle->find('all');

How can I do that?

Please guide me.

Thank you, Trupti

Check - https://stackoverflow.com/questions/2521225/cakephp-get-last-query-run — Sougata Bose, Nov 19 '19 at 11:19
Enable debug and add element('sql_dump'); ?> in footer, so that you can view all the sql queries in pages while developing — Ajith, Nov 19 '19 at 11:24
I'm curious why a new user is using a [10 year old version](https://github.com/cakephp/cakephp/releases/tag/1.2.5) of a framework? — AD7six, Nov 19 '19 at 11:26

ascsoftw · Accepted Answer · 2019-11-19T11:27:03.987

1

For Cakephp 1.x, you could use following code to get the last query

    $dbo = $this->Vehicle->getDatasource();
    $logs = $dbo->getLog();
    $lastLog = end($logs['log']);
    echo $lastLog['query'];

Alternatively, To get all the Queries executed in the Current HTTP Request, you can use the following code

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

You have to set the Debug Mode to 2 for this to work.

edited Nov 19 '19 at 11:27

answered Nov 19 '19 at 11:19

ascsoftw

Getting this error: Call to undefined method DboMysql::getLog() – Trupti Nov 19 '19 at 11:22

1 Answers1