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  - gt where status 1 - gt get      Or    posts  id  user id         User  find 1 - gt posts- gt get      Otherwise  at the very least how can I save all queries executed to laravel log

User · Answer

Laravel 5  Note that this is the procedural approach  which I use for quick debugging      DB  enableQueryLog            Run your queries                    Then to retrieve everything since you enabled the logging       queries   DB  getQueryLog        foreach  queries as  i  gt  query                Log  debug  Query  i      json encode  query            in your header  use        use DB       use Illuminate Support Facades Log    The output will look something like this  default log file is laravel log        2015-09-25 12 33 29  testing DEBUG  Query 0    query   select   from    users  where   user id         bindings    9    time  0 23       I know this question specified Laravel 3 4 but this page comes up when searching for a general answer  Newbies to Laravel may not know there is a difference between versions  Since I never see DD  enableQueryLog   mentioned in any of the answers I normally find  it may be specific to Laravel 5 - perhaps someone can comment on that

User · Answer

For Eloquent you can just do    result- gt getQuery  - gt toSql      But you need to remove the  - get    part from your query

User · Answer

There is very easy way to do it  from your laravel query just rename any column name  it will show you an error with your query

User · Answer

You can enable the  Profiler  in Laravel 3 by setting    profiler    gt  true    In your application config application php and application config database php  This enables a bar at the bottom of each page  One of its features is listing the executed queries and how long each one took

User · Answer

Laravel 4   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   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     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

User · Answer

Since the profiler is not yet out in Laravel 4  I ve created this helper function to see the SQL being generated          public static function q  all   true                  queries   DB  getQueryLog             if  all    false                 last query   end  queries               return  last query                     return  queries           NOTE  Set the  all flag to false if you only want the last SQL query   I keep this sort of functions in a class called DBH php  short for Database Helper  so I can call it from anywhere like this   dd DBH  q        Here is the output I get     In case you are wondering  I use Kint for the dd   formatting  http   raveren github io kint

User · Answer

in Laravel 4 you can actually use an Event Listener for database queries   Event  listen  illuminate query   function  sql   bindings        foreach   bindings as  val             sql   preg replace             val      sql  1              Log  info  sql         Place this snippet anywhere  e g  in start global php  It ll write the queries to the info log  storage log laravel log

User · Answer

Here is a quick Javascript snippet you can throw onto your master page template  As long as it s included  all queries will be output to your browser s Javascript Console  It prints them in an easily readable list  making it simple to browse around your site and see what queries are executing on each page   When you re done debugging  just remove it from your template    lt script type  text javascript  gt      var queries      json encode DB  getQueryLog            console log                                  Database Queries                                        console log           queries forEach function query            console log         query time           query query           query bindings 0                console log           console log                                  End Queries                                          lt  script gt

User · Answer

Event  listen  illuminate query   function  sql   param         Log  info  sql      with     join       param      lt br gt  n          put it in global php it will log your sql query

User · Answer

For Laraver 4 it s   DB  getQueryLog

User · Answer

Laravel 3 Another way to do this is   config database php   profiler    gt  true  For all Queries result  print r DB  profiler      For last Result  print r DB  last query

User · Answer

Last query print   queries    DB  getQueryLog     last query   end  queries       Add binding to query foreach   last query  bindings   as  val             last query  query     preg replace             val      last query  query    1     dd  last query

User · Answer

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

User · Answer

Using the query log doesnt give you the actual RAW query being executed  especially if there are bound values  This is the best approach to get the raw sql   DB  table  tablename  - gt toSql      or more involved    query   Article  whereIn  author id    1 2 3  - gt orderBy  published    desc  - gt toSql    dd  query

User · Answer

The Loic Sharma SQL profiler does support Laravel 4  I just installed it  The instructions are listed here  The steps are the following    Add          loic-sharma profiler    1 1    in the require section in composer json Perform self-update    php composer phar self-update in the console  Perform composer update    php composer phar update loic-sharma profiler in the console as well   Add  Profiler ProfilerServiceProvider   in the provider array in app php Add  Profiler           gt   Profiler Facades Profiler   in the aliasses array in app php as well  Run php artisan config publish loic-sharma profiler in the console

User · Answer

You can also listen for query events using this   DB  listen function  sql   bindings   time        var dump  sql         See the information from the docs here under Listening For Query Events

User · Answer

I would recommend using the Chrome extension Clockwork with the Laravel package https   github com itsgoingd clockwork  It s easy to install and use      Clockwork is a Chrome extension for PHP development  extending   Developer Tools with a new panel providing all kinds of information   useful for debugging and profiling your PHP scripts  including   information on request  headers  GET and POST data  cookies  session   data  database queries  routes  visualisation of application runtime   and more  Clockwork includes out of the box support for Laravel 4 and   Slim 2 based applications  you can add support for any other or custom   framework via an extensible API

User · Answer

To get the last executed query in laravel We will use DB  getQueryLog   function of laravel it return all executed queries  To get last query we will use end   function which return last executed query    student   DB  table  student  - gt get     query   DB  getQueryLog     lastQuery   end  query   print r  lastQuery     I have taken reference from http   www tutsway com how-to-get-the-last-executed-query-in-laravel php

User · Answer

Or as alternative to laravel 3 profiler you can use   https   github com paulboco profiler or https   github com barryvdh laravel-debugbar

User · Answer

L4 one-liner   which write query      q  DB  getQueryLog   dd end  q

User · Answer

In Laravel 8 x you can listen to the event by registering your query listener in a service provider as documented in laravel com website    header use Illuminate Support Facades DB  use Illuminate Support Facades Log   public function boot           DB  listen function   query                   Log  debug  quot SQL    quot     query- gt sql              You can then see all the queries in the laravel log file inside storage logs laravel log

[php] Get the Query Executed in Laravel 3/4

Laravel 5

Examples related to php

Examples related to laravel

Examples related to orm

Examples related to eloquent

Examples related to laravel-query-builder