How to get the raw SQL query from the Laravel Query Builder

Question

Using Laravel Eloquent methods The first method to get the query of an Eloquent call is by using the toSql() method. This method returns the query without running it – good if you don't want to alter data and only get the query – but this method doesn't show the whole query if your query is more complex or if there are sub-queries.

enter code here

App\User::query()
    ->where('created_at', '<', now()->subYear())
    ->with('assignedApps', 'courses')
    ->orderBy('email', 'asc')
    ->limit(5)
    ->toSql();

Mitesh Rathod · Accepted Answer · 2022-01-19 06:19:50Z

2

If you want to show all the queries, then you will have to enable the query log. DB::enableQueryLog

\DB::enableQueryLog(); // enable the query log before your modal

App\User::query()
    ->where('created_at', '<', now()->subYear())
    ->with('assignedApps', 'courses')
    ->orderBy('email', 'asc')
    ->limit(5)
    ->get();

dd(DB::getQueryLog()); // after your query, dump and die get query log.

It will return all queries result with values

answered Jan 19, 2022 at 6:19

Mitesh Rathod

1,0699 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Niyanta Bhayani Over a year ago

Also, It's showing how much time it'll take to execute queries. One other benefit is It'll show all the queries between enabled to get log so you can see all queries at a time.

Collectives™ on Stack Overflow

How to get the raw SQL query from the Laravel Query Builder

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related