How to apply second orderBy in query?

Question

Laravel

The code

Model::orderBy('field','desc')
     ->take(100)
     ->orderBy('field','asc')
     ->take(50)
     ->get();

Uses only the first orderBy. Second sorting only from the collection?

Answer 1

Well, I can still understand double sorting. But what are you trying to achieve with the second limit, what result do you expect? Are you really trying to sort the same field first in descending order and then in ascending order? What result do you expect in this case?
In general, multiple sorting is indicated in this way - under the hood, Eloquent collects all sorts into an array and applies them one by one. The problem you have is that the request is somehow meaningless.