Time: 0.016852140426636 -- 2026-07-03 09:34:35.779[米松涛-3168] -- /buz/fls/index.php/qctask/query_task
SELECT w.workplace_name,DATE_FORMAT(t.issued_date,'%Y-%m-%d %H:%i') issued_date, 
DATE_FORMAT(t.assign_finish_time,'%Y-%m-%d %H:%i') assign_finish_time,t.qctask_no,t.status_id,t.qctask_id, 
t.responsor_id,p.process_id,p.process_name,t.workplace_id,t.task_type_id,tr.parent_qctask_id excpt_task_id 
FROM dbqc.qc_task t 
LEFT JOIN dbsys.sys_workplace w ON t.workplace_id = w.workplace_id 
LEFT JOIN dbqc.qc_process p ON t.process_id = p.process_id 
LEFT JOIN dbqc.qc_task_relation tr ON t.qctask_id = tr.qctask_id 
LEFT JOIN dbqc.qc_task_procstep tps ON t.qctask_id = tps.qctask_id 
where tps.responsor_id= 3168 AND t.exc_status_id = 1 
and tps.procstep_type_id in (2,4) 
 order by qctask_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------