Time: 0.019950866699219 -- 25-08-11 08:47:47[段乐-1218] -- /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= 1218 AND (t.status_id < 5  ) 
and tps.procstep_type_id in (5,1) 
 order by qctask_id desc
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.023669004440308 -- 25-08-11 08:47:49[段乐-1218] -- /buz/fls/index.php/qctask/query_his_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, 
c.cont_name responsor,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 dbsys.sys_contact c ON t.responsor_id = c.cont_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 
where t.responsor_id= 1218 AND t.status_id >= 5 limit 0,20
------------------------------------------------------------------------------------------------------------------------------------------------------
Time: 0.029003858566284 -- 25-08-11 08:47:53[段乐-1218] -- /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
------------------------------------------------------------------------------------------------------------------------------------------------------