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