Answers for "laravel query builder explain"

laravel query builder select

use IlluminateSupportFacadesDB;

$users = DB::table('users')
            ->select('name', 'email as user_email')
            ->get();

Laravel query builder toSql

$query = DB::table('table')->whereIn('some_field', [1,2,30]);

$sql = $query->toSql();

$bindings = $query->getBindings();