$log_list = $log
->field('l.*')
->where($mac_no)
->alias('l')
->join('qxj_mac m','m.mac_id = l.mac_id','left')
->where($where_m)
->field('m.mac_no,m.mac_mobile')
->join('qxj_admin_user h','h.admin_id = m.holder_id','left')
->where($where_h)
->field('h.user_name,h.name,h.mobile')
->order('l.use_time','desc')
->paginate(10,true,[
'query'=>[
'mac_no'=>$mac_no,
'start_time'=>$start_time,
'end_time'=>$end_time,
'keyword'=>$keyword,
]
]);
上面这段是什么意思?
select l.*,h.user_name,h.name,h.mobile,m.mac_no,m.mac_mobile from qx_mac_illegal_log l
LEFT JOIN qxj_mac m ON l.mac_id = m.mac_id
LEFT JOIN qxj_admin_user h ON h.admin_id = m.holder_id
where m.mac_mobile=1064857461530 and l.log_id=198
可以改成上面的格式吗?