Time: 0.021898984909058 -- 25-12-02 18:33:56[李湘芸-2009] -- /buz/fls/index.php/qctask/query_task
SELECT qctype.qctype_name,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.qctype_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_type qctype ON t.qctype_id = qctype.qctype_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= 2009 AND (t.status_id < 5  ) 
and tps.procstep_type_id in (5,1) 
 order by qctask_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------