Cant retrieve record from large scale table row

I am using laravel framework.In my database records table have more then 400000 row. Now I want to retrieve record using some condition logic : need to match service id need to match status

but my application cant retrieve data (unable to handle this request). I am using query using this

foreach ($ven as $ven){
    $data = $ven->data;
    $record = $data ->records()->where('status','success')->get();
}

My status column already added in index.

Need suggestion

via Chebli Mohamed