Time: 0.022125959396362 -- 25-12-03 17:11:18[蔡骏东-司机-2493] -- /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= 2493 AND (t.status_id < 5  ) 
and tps.procstep_type_id in (5,1) 
 order by qctask_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.021256923675537 -- 25-12-03 17:11:23[蔡骏东-司机-2493] -- /buz/fls/index.php/qctask/query_excprept_task
select t.*,w.workplace_name from dbqc.qc_task t left join dbsys.sys_workplace w on t.workplace_id=w.workplace_id where t.qctask_id = limit 1
------------------------------------------------------------------------------------------------------------------------------------------------------