Laravel print last executed SQL query with Query log

Question

DB::enableQueryLog();
$mines = Cranks::where([['crank_id', '=', $this->crank_id], ['mine_id', 'like', '%'.$script_value->mine_id.'%'] ])->get();
$querylog =  DB::getQueryLog();
dd($querylog);
exit;

This code prints the query log with bind array and all - How can I get the pure SQL, so I can run it in PhpMyAdmin

I would install the debug bar. It lists all queries made by a request. — GluePear
– GluePear, Commented Feb 28, 2019 at 13:14
As far as I know, you can't. The best I've found is to turn on logging with SET GLOBAL general_log = 1 in the database, run the query, turn logging back off (set to 0), then check the general log to see the exact query that was run. — aynber
– aynber, Commented Feb 28, 2019 at 13:31

Ritesh Khatri · Accepted Answer · 2019-02-28 13:11:15Z

1

using toSql() function you can print your query, like

$mines = Cranks::where([['crank_id', '=', $this->crank_id], ['mine_id', 'like', '%'.$script_value->mine_id.'%'] ])->toSql();
echo $mines;

answered Feb 28, 2019 at 13:11

Ritesh Khatri

1,31115 silver badges30 bronze badges

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

3 Comments

mujuonly Over a year ago

This doesn't show the values is in query - I cannot run in PhpMyAdmin by copy pasting the output of this

Ritesh Khatri Over a year ago

yeah it doesn't show the dynamic values in query but you can separately echo the values and make you query, or you can go through laarvel debugger tool which provide you exact query. anyways sorry.

Ritesh Khatri Over a year ago

Please review this question how-can-i-get-the-raw-query-string-from-laravels-query-builder-before-executing

Collectives™ on Stack Overflow

Laravel print last executed SQL query with Query log

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related