美文网首页
Laravel获取ORM的sql语句

Laravel获取ORM的sql语句

作者: IT行者q | 来源:发表于2020-04-10 21:24 被阅读0次

1获取的函数

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结果

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)
  }
}

相关文章

网友评论

      本文标题:Laravel获取ORM的sql语句

      本文链接:https://www.haomeiwen.com/subject/nkcjmhtx.html