Generate The Raw MySQL Query From Laravel Query Builder

Question

How can i get mysql query of a laravel query

Convert:

App\User::where('balance','>',0)->where(...)->get(); 

To:

SELECT * FROM users WHERE `balance`>0 and ... 

Answer 1

use toSql() method of laravel to get the query to be executed like

App\User::where('balance','>',0)->where(...)->toSql(); 

But Laravel will not show you parameters in your query, because they are bound after preparation of the query. To get the bind parameters, use this

$query=App\User::where('balance','>',0)->where(...); print_r($query->getBindings() ); 

enable the query log as DB::enableQueryLog() and then output to the screen the last queries ran you can use this,

dd(DB::getQueryLog()); 

Answer 2

you can add this function to your helpers

function getRealQuery($query, $dumpIt = false) {     $params = array_map(function ($item) {         return "'{$item}'";     }, $query->getBindings());     $result = str_replace_array('\?', $params, $query->toSql());     if ($dumpIt) {         dd($result);     }     return $result; } 

---

and use like this:

getRealQuery(App\User::where('balance','>',0)->where(...),true)