1獲取的函數(shù)

DB::connection()->enableQueryLog();

          $collectors = DB::table('admin_roles')
                ->join('admin_role_users', 'admin_roles.id', '=', 'admin_role_users.role_id')
                ->join('admin_users', 'admin_users.id', '=', 'admin_role_users.user_id')
                ->where('admin_roles.slug', '=', 'collector')
                ->where('admin_roles.tenant_id', '=', $this->tenant_id())
                ->select('admin_users.id', 'admin_users.name')
                ->get();

var_dump(DB::getQueryLog());

2結(jié)果

array(1) {
  [0]=>
  array(3) {
    ["query"]=>
    string(292) "select `admin_users`.`id`, `admin_users`.`name` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` inner join `admin_users` on `admin_users`.`id` = `admin_role_users`.`user_id` where `admin_roles`.`slug` = ? and `admin_roles`.`tenant_id` = ?"
    ["bindings"]=>
    array(2) {
      [0]=>
      string(9) "collector"
      [1]=>
      string(7) "SDFDSFS"
    }
    ["time"]=>
    float(0.36)
  }
}