Why first() is not using LIMIT in it's query?

first() method is to get only the first one in the record. If you want to have other records, you should use get() which will return an amount set by LIMIT

first() use limit 1 in the query.

DB::enableQueryLog();

User::where('id',1)->first()

dd(DB::getQueryLog());

array:1 [
  0 => array:3 [
    "query" => "select * from `users` where `id` = ? limit 1"
    "bindings" => array:1 [
      0 => 1
    ]
    "time" => 1.46
  ]
]

@timurlan156 The first() method returns the first element in the collection where get() method returns a collection and first returns a single model instance. So I guess we cannot use limit in first method()

Sorry, it DOES use LIMIT