How to put many different values ​​in one laravel sql query?

Question

Laravel

I have this sql question:

foreach($id as $myid){
User::where('id', $myid)->get();
}

There are more than 100,000 values ​​in foreach and when requested, laravel takes a very long time to load or just gives a timeout.

How to do it all in one request or is there another implementation option?

Answer 1

documentation describes your case https://laravel.com/docs/9.x/queries#additional-wh...

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