{"flag":true,"single":true,"pageTitle":"get last executed query (toSql) in laravel DB:","post":{"id":29,"user_id":"1","slug":"get-last-executed-query-in-laravel-db--4kvy","title":"get last executed query (toSql) in laravel DB:","body":"<pre class=\"language-markup\"><code>dd($users-&gt;toSql(), $users-&gt;getBindings());<\/code><\/pre>\r\n<p>OR<\/p>\r\n<pre class=\"language-markup\"><code>$users = \\App\\Models\\User::where('name', 'like', 'a%');\r\n$sql = $users-&gt;toSql();\r\necho $sql;die;\r\n<\/code><\/pre>\r\n<p>OR<\/p>\r\n<pre class=\"language-markup\"><code>DB::enableQueryLog();\r\n\/\/all queried here it also tell you each query responce time\r\n\r\n            $all_business = \\App\\Models\\Business::with(['categories'])\r\n                -&gt;withCount('reviews')\r\n                -&gt;whereNotNull('business_name')\r\n                -&gt;paginate(10);\r\n\r\ndd(DB::getQueryLog());<\/code><\/pre>\r\n<p>First of all ADD use DB; at top<\/p>\r\n<pre class=\"language-markup\"><code>DB::connection()-&gt;enableQueryLog();\r\n$favorites = DB::table('fav_items') -&gt;paginate(10);\r\n$query = DB::getQueryLog();\r\n$lastQuery = end($query);\r\ndd($lastQuery['query']);<\/code><\/pre>\r\n<p>&nbsp;<\/p>\r\n<p>OR<\/p>\r\n<pre class=\"language-markup\"><code>$sqlis = \\App\\Models\\Users::where('email',\"abc@gmail.com\")-&gt;toSql();\r\ndd($sqlis);<\/code><\/pre>","category_id":"2","is_private":"0","created_at":"2023-03-17T00:50:46.000000Z","updated_at":"2026-04-21T01:03:34.000000Z","category":{"id":2,"user_id":"1","name":"Laravel Core","slug":"laravel-nhyt","parent_id":"1","created_at":"2023-03-14T03:58:27.000000Z","updated_at":"2023-03-20T11:30:50.000000Z"},"user":{"id":1,"name":"R GONDAL","email":"rizikmw@gmail.com","email_verified_at":null,"two_factor_confirmed_at":null,"current_team_id":"1","profile_photo_path":null,"created_at":"2023-03-12T10:49:33.000000Z","updated_at":"2025-01-10T12:59:00.000000Z","profile_photo_url":"https:\/\/ui-avatars.com\/api\/?name=R+G&color=7F9CF5&background=EBF4FF"}},"pageDesc":"dd($users-&gt;toSql(), $users-&gt;getBindings()); OR $users = \\App\\Models\\User::where('name', 'like', 'a%'); $sql = $users-&gt;toSql(); echo - get last executed query (toSql) in laravel DB: (Updated: April 21, 2026) - Read more about get last executed query (toSql) in laravel DB: at my programming site [SITE]","categories":[]}