use App\Order;
public function show(Order $order) {
$data = $order->all();
return dd($order->getQueryLog());
有没有办法在Laravel中显示由eloquent构建的查询?
我试了getQueryLog();
,但不起作用
use App\Order;
public function show(Order $order) {
$data = $order->all();
return dd($order->getQueryLog());
有没有办法在Laravel中显示由eloquent构建的查询?
我试了getQueryLog();
,但不起作用
首先,必须启用查询日志(log)
DB::connection()->enableQueryLog();
then you can use below code to see the query log
$queries = DB::getQueryLog();
如果要查看上次执行的查询
$last_query = end($queries);
to know more about logging see this https://laravel.com/docs/5.0/database#query-logging
Example
public function show(Order $order){
\DB::connection()->enableQueryLog();
$data = $order->all();
$queries = \DB::getQueryLog();
return dd($queries);
}