How does the query builder handle
Does it simply do a
Limit 1 or does it do some advanced checking to make sure if only 1 row is returned?
In rare cases, the application may want to ensure that ONLY 1 row will be returned. Perhaps
->first() is not the best solution?
Any insight or direction is greatly appreciated!
Best How To :
first() method will always return one result or
null if no results are found. Here's all it does:
public function first($columns = array('*'))
$results = $this->take(1)->get($columns);
return count($results) > 0 ? reset($results) : null;
The difference to just using
limit(1)) is that it actually just returns one result object, by calling
first() obviously executes the query. The others don't)