Get the Query Executed in Laravel 3/4

by

Laravel 4+

Note for Laravel 5 users: You’ll need to call DB::enableQueryLog() before executing the query. Either just above the line that runs the query or inside a middleware.

In Laravel 4 and later, you have to call DB::getQueryLog() to get all ran queries.

$queries = DB::getQueryLog();
$last_query = end($queries);

Or you can download a profiler package. I’d recommend barryvdh/laravel-debugbar, which is pretty neat. You can read for instructions on how to install in their repository.

Laravel 3

In Laravel 3, you can get the last executed query from an Eloquent model calling the static method last_query on the DB class.

DB::last_query();

This, however, requires that you enable the profiler option in application/config/database.php. Alternatively you could, as @dualed mentioned, enable the profiler option, in application/config/application.php or call DB::profile() to get all queries ran in the current request and their execution time.

More Related Contents:

  1. Get Specific Columns Using “With()” Function in Laravel Eloquent
  2. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  3. How do I get the query builder to output its raw SQL query as a string?
  4. Laravel Eloquent Query Using WHERE with OR AND OR?
  5. Add a custom attribute to a Laravel / Eloquent model on load?
  6. Creating and Update Laravel Eloquent
  7. How to sort a Laravel query builder result by multiple columns?
  8. How to Make Laravel Eloquent “IN” Query?
  9. Laravel Eloquent sort by relation table column
  10. Laravel Many to many self referencing table only works one way
  11. Laravel one to many relation with a one to one relation
  12. Get the Last Inserted Id Using Laravel Eloquent
  13. Bulk Insertion in Laravel using eloquent ORM
  14. How to insert multiple rows from a single query using eloquent/fluent
  15. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  16. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  17. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  18. Laravel Checking If a Record Exists
  19. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  20. How to exclude certains columns while using eloquent
  21. How to alias the name of a column in Eloquent
  22. Laravel $q->where() between dates
  23. Update without touching timestamps (Laravel)
  24. laravel collection to array
  25. Eloquent Parent-Child relationship on same model
  26. Natural ORDER in Laravel Eloquent ORM
  27. Laravel Eloquent: How to get only certain columns from joined tables
  28. How can I query raw via Eloquent?
  29. A __construct on an Eloquent Laravel Model
  30. How to get last insert id in Eloquent ORM laravel

Leave a Comment