How To Convert Laravel Query To SQL Query

Websolutionstuff | Oct-27-2022 | Categories : Laravel MySQL

In this article, we will see how to convert a laravel query to an SQL query. Many times we required laravel query builder to its raw SQL query as a string. Laravel provides different ways to get raw SQL queries. You can get SQL queries using the toSql() query builder method. Also, you can use the laravel query log to get SQL queries in laravel. For getting the query logs we will use enableQueryLog() method.

 So, let's see how to get the raw SQL query from a laravel.

The toSql() Function:

In this example, we will use the toSql() method to get raw SQL queries. toSql() get the SQL representation of the query and return the string value. This method doesn't show the whole query if your query is more complex or if there are sub-queries.

SQL Query Example:

SELECT * FROM articles WHERE status='published';

Laravel Query Example:

$articles = Article::where('status', 'published')->get();

Use the toSql() method, you can just change the get() part in the above query with toSql().

$article = Article::where('status', 'published')->toSql();

Output:

"select * from `articles` where `status` = ?"

 

 

The enableQueryLog() Function:

Laravel can optionally log into the memory of all queries that have been run for the current request. You can enable the log using the enableQueryLog() method.

public function store(Request $request){
    \DB::enableQueryLog();

    Post::where('is_active', '=', '1')        
    ->orderBy('publish_date', 'desc')
    ->limit(15)
    ->get();

    dd(\DB::getQueryLog());
}

Output:

array:1 [▼
  0 => array:3 [▼
    "query" => "select * from `posts` where `is_active` = ? order by `publish_date` desc limit 15"
    "bindings" => array:1 [▶]
    "time" => 7.03
  ]
]

So, you can get out in array format with the query and execution time of the query.

\DB::enableQueryLog(); // Enable query log

// Your Eloquent query executed by using get()

dd(\DB::getQueryLog()); // Show results of log

 


You might also like:

Recommended Post
Featured Post
Crop Image Before Upload Using Croppie Plugin
Crop Image Before Upload Using...

In this article, we will see how to crop images before uploading using the croppie plugin. any times we have requir...

Read More

Aug-15-2020

Multi Step Form Example In Laravel
Multi Step Form Example In Lar...

Today in this post we will see multi step form example in laravel, here we will create laravel multi step form example.&...

Read More

Jul-21-2021

How To Add Bootstrap 5 Modal In Laravel 10
How To Add Bootstrap 5 Modal I...

In this article, we will see how to add the bootstrap 5 modal in laravel 10. Here, we will learn about the bootstra...

Read More

Apr-12-2023

How To Use Image Intervention In Laravel 9
How To Use Image Intervention...

In this article, we will see how to use image intervention in laravel 9. Here, we will learn about image intervention an...

Read More

Feb-13-2023