Model::where('id', 1) ->pluck('name', 'surname') ->all();
//Eloquent: Get specific columns (not all the row). Pluck returns an array. Model::where('id', 1)->pluck('name', 'surname'); // If you only want to get the result value: Model::where('id', 1)->value('name');
$result = DB::Table('table_name')->select('column1','column2')->where('id',1)->get();
ModelName::where('a', 1)->get(['column1','column2']);
ModelName::find($id, ['name', 'surname']);