Print last executed query in Cakephp 2.0

Print last executed query in Cakephp 2.0 : For each developer it becomes very important to print the last executed query in all frameworks. It helps much in development for debugging the queries. Here we are going to explain the method how you can print the last executed query in cakephp 2.0.

Print last executed query in Cakephp 2.0

You can print last executed query in cakephp as below-

  $dbo = $this->getDatasource();
  // or $dbo = $this->Model->getDatasource();
  $log = $dbo->getLog();
  $last_log = end($log['log']);
  return $last_log['query'];

The above example will print the last executed query in cakephp2.0

Add Comment

📖 Read More

• 1. Get Current Url in Cakephp
• 2. Cakephp Join Multiple tables
• 3. Cakephp get url parameters
• 4. Cakephp get ip Address
• 5. Cakephp Left Join Query

• 6. Cakephp Right Join Query
• 7. Cakephp Get Table name And Column Details
• 8. Cakephp Get Base Url