Get the Query Executed in Laravel 3/4

Question

How can I retrieve the raw executed SQL query in Laravel 3/4 using Laravel Query Builder or Eloquent ORM?

For example, something like this:

DB::table('users')->where_status(1)->get();

Or:

(posts (id, user_id, ...))

User::find(1)->posts->get();

Otherwise, at the very least how can I save all queries executed to laravel.log?

Answer 1

For Laraver 4 it's

DB::getQueryLog()

Answer 2

If you are using Laravel 5 you need to insert this before query or on middleware :

\DB::enableQueryLog();