Using query() in Eloquent

What difference does it make to use this when making a query to the db? I have a coworker who always puts this is his queries but I don't think it's needed as the query is executed the same with or without it. for example:

What is the difference in these:

 $var= Model::query()->findOrFail($id);

 $var= Model::findOrFail($id);

I'm just wondering what is the point of doing this and for what?

automica

4 years ago

Level 54

@msslgomez in your case, it makes no difference, but if you were chaining then its neater and more readable.

eg:

$var = Model::query()
    ->where('some-field','some-value')
    ->where('some-field2','some-value2')
    ->sortAsc()
    ->get();

eggplantSword

4 years ago

Level 9

@automica it does look nicer but I can omit that and my code would be shorter, does it make a difference in performance?

automica

4 years ago

Level 54

@msslgomez no difference in performance as eloquent is converted to sql before its ran anyway.

tykus

4 years ago

Level 104

There is no difference.

The query method does have the advantage, when building larger queries, of IDE completions because it returns the Eloquent Builder instance. Some devs will also take advantage of query to align multi-line queries for readability

Also checkout this Codecourse short series

Please or to participate in this conversation.