Detailed explanation of laravel sql statement query

When using laravel, data problems often occur due to problems with sql statements.

Recommended: laravel tutorial

By default, Laravel logs all queries running the current request in memory. However, in some cases, such as when inserting a large number of rows, this may cause the application to use excess memory. To disable the log, you can use the disableQueryLog method:

You can use it when operating DB classes or ORM

DB::connection()->enableQueryLog();  
// 获取已执行的查询数组  
DB::table('user')->orderBy('addtime','asc')->where(['status'=>1])->get();
//
$log = DB::getQueryLog();  
dd($log); //打印sql语句

There is also a way to see the native sql statement, which is Laravel Debugging tool debug bar

https://github.com/barryvdh/laravel-debugbar

The above is the detailed content of Detailed explanation of laravel sql statement query. For more information, please follow other related articles on the PHP Chinese website!