and where in laravel eloquent code example

Example 1: find or fail laravel

$model = App\Models\Flight::findOrFail(1);

$model = App\Models\Flight::where('legs', '>', 100)->firstOrFail();

Example 2: eloquent where in

$users = DB::table('users')->whereIn('id', array(1, 2, 3))->get()

Example 3: where () laravel Eloquent

//los signos de igualdad pueden ser: ">=", "<=", "=", ">", "<"
$user = User::where("estado","=",1)->find(10);

Example 4: laravel find query

use App\Models\Destination;
use App\Models\Flight;

return Destination::addSelect(['last_flight' => Flight::select('name')
    ->whereColumn('destination_id', 'destinations.id')
    ->orderBy('arrived_at', 'desc')
    ->limit(1)
])->get();

Example 5: laravel where and where

Table::where('Column', Value)->where('NewColumn', Value)->get();