Time: 0.017863035202026 -- 26-01-18 01:55:38 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035409927368164 -- 26-01-18 01:55:38 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044200420379639 -- 26-01-18 01:55:38 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037808418273926 -- 26-01-18 01:55:38[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018450021743774 -- 26-01-18 01:55:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027813196182251 -- 26-01-18 01:55:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=44018 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 44018 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067510604858398 -- 26-01-18 01:55:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=44018 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 44018 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056829452514648 -- 26-01-18 01:55:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=44018 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5931221 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033349990844727 -- 26-01-18 01:55:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=44018 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043008327484131 -- 26-01-18 01:55:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=44018 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5931221 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033409595489502 -- 26-01-18 01:55:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=44018 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016123056411743 -- 26-01-18 01:55:55[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=44018 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022442817687988 -- 26-01-18 01:55:55[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02397894859314 -- 26-01-18 01:55:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2244018%22}&event=edit_fareApply&fareApply_id=44018 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 44018 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031991004943848 -- 26-01-18 01:55:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2244018%22}&event=edit_fareApply&fareApply_id=44018 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 44018 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032119750976562 -- 26-01-18 01:55:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2244018%22}&event=edit_fareApply&fareApply_id=44018 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5931221 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031890869140625 -- 26-01-18 01:55:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2244018%22}&event=edit_fareApply&fareApply_id=44018 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032410621643066 -- 26-01-18 01:55:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2244018%22}&event=edit_fareApply&fareApply_id=44018 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5931221 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032000541687012 -- 26-01-18 01:55:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2244018%22}&event=edit_fareApply&fareApply_id=44018 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02991509437561 -- 26-01-18 08:31:44 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035779476165771 -- 26-01-18 08:31:44 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041050910949707 -- 26-01-18 08:31:44 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiuXiaoJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003756046295166 -- 26-01-18 08:31:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028786897659302 -- 26-01-18 08:31:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010816097259521 -- 26-01-18 08:31:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004889965057373 -- 26-01-18 08:31:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049378871917725 -- 26-01-18 08:31:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050809383392334 -- 26-01-18 08:31:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030305147171021 -- 26-01-18 08:31:50[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034031867980957 -- 26-01-18 08:31:50[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5921382 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032591819763184 -- 26-01-18 08:31:50[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031681060791016 -- 26-01-18 08:31:50[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019001007080078 -- 26-01-18 08:31:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042350292205811 -- 26-01-18 08:31:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035929679870605 -- 26-01-18 08:31:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003587007522583 -- 26-01-18 08:31:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036029815673828 -- 26-01-18 08:31:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018066883087158 -- 26-01-18 08:32:02[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018286943435669 -- 26-01-18 08:53:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045478343963623 -- 26-01-18 08:53:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040919780731201 -- 26-01-18 08:53:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039551258087158 -- 26-01-18 08:53:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040538311004639 -- 26-01-18 08:53:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016578912734985 -- 26-01-18 08:54:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032961368560791 -- 26-01-18 08:54:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5921382 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003216028213501 -- 26-01-18 08:54:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031359195709229 -- 26-01-18 08:54:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023190975189209 -- 26-01-18 08:54:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042421817779541 -- 26-01-18 08:54:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037319660186768 -- 26-01-18 08:54:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003809928894043 -- 26-01-18 08:54:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037131309509277 -- 26-01-18 08:54:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019022941589355 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43920 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033819675445557 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035548210144043 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5918278 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033838748931885 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033938884735107 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034110546112061 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5918278 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033679008483887 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021363019943237 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020946979522705 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019375801086426 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028452157974243 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018074989318848 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035848617553711 -- 26-01-18 08:54:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019108057022095 -- 26-01-18 08:54:15[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039429664611816 -- 26-01-18 08:54:15[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035591125488281 -- 26-01-18 08:54:15[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035920143127441 -- 26-01-18 08:54:15[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035469532012939 -- 26-01-18 08:54:15[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01821494102478 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44008 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 44008 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032579898834229 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44008 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034000873565674 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44008 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5929212 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032200813293457 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44008 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032119750976562 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44008 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032479763031006 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44008 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5929212 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032107830047607 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44008 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029101848602295 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%郑州华捷汽车销售有限公司%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017295837402344 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016248941421509 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027015924453735 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025611877441406 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031130313873291 -- 26-01-18 08:54:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017144918441772 -- 26-01-18 08:54:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037040710449219 -- 26-01-18 08:54:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034348964691162 -- 26-01-18 08:54:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034351348876953 -- 26-01-18 08:54:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034210681915283 -- 26-01-18 08:54:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029253005981445 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44009 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 44009 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031018257141113 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44009 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033059120178223 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44009 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5929236 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030961036682129 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44009 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030820369720459 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44009 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031378269195557 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44009 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5929236 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030910968780518 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=44009 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015860080718994 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016933917999268 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017725944519043 -- 26-01-18 08:54:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01690411567688 -- 26-01-18 08:54:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016161203384399 -- 26-01-18 08:54:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031871795654297 -- 26-01-18 08:54:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024038791656494 -- 26-01-18 08:54:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041971206665039 -- 26-01-18 08:54:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038940906524658 -- 26-01-18 08:54:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038979053497314 -- 26-01-18 08:54:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038950443267822 -- 26-01-18 08:54:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01704216003418 -- 26-01-18 10:31:20[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033330917358398 -- 26-01-18 10:31:20[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061759948730469 -- 26-01-18 10:31:20[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 71094 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018549919128418 -- 26-01-18 10:31:24[吴海红-2505] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017457008361816 -- 26-01-18 10:31:33[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-18 10:31:33[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028982877731323 -- 26-01-18 10:31:34[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035171508789062 -- 26-01-18 10:31:35[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051741600036621 -- 26-01-18 10:31:35[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 71094 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005547046661377 -- 26-01-18 10:31:35[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 3342 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015740871429443 -- 26-01-18 10:32:19[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031130313873291 -- 26-01-18 10:32:19[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043809413909912 -- 26-01-18 10:32:19[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 71094 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043799877166748 -- 26-01-18 10:32:19[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 3342 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017343044281006 -- 26-01-18 10:32:21[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-18 10:32:21[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046579837799072 -- 26-01-18 10:32:21[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 71094 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047838687896729 -- 26-01-18 10:32:21[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 3342 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017916917800903 -- 26-01-18 10:32:21[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017701148986816 -- 26-01-18 10:58:25 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017915010452271 -- 26-01-18 10:58:26 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036652088165283 -- 26-01-18 10:58:26 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041580200195312 -- 26-01-18 10:58:26 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038251876831055 -- 26-01-18 10:58:26[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019357204437256 -- 26-01-18 10:58:30[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017576932907104 -- 26-01-18 11:22:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041651725769043 -- 26-01-18 11:22:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037720203399658 -- 26-01-18 11:22:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039069652557373 -- 26-01-18 11:22:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038518905639648 -- 26-01-18 11:22:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019339799880981 -- 26-01-18 11:22:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7321 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7321 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036239624023438 -- 26-01-18 11:22:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7321 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5900252 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035319328308105 -- 26-01-18 11:22:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7321 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034780502319336 -- 26-01-18 11:22:30[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7321 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017286777496338 -- 26-01-18 11:22:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041608810424805 -- 26-01-18 11:22:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003795862197876 -- 26-01-18 11:22:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037989616394043 -- 26-01-18 11:22:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037658214569092 -- 26-01-18 11:22:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020133018493652 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43920 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036041736602783 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003770112991333 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5918278 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035998821258545 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035970211029053 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036449432373047 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5918278 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035910606384277 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43920 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016716003417969 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017037868499756 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017874956130981 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017091035842896 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017889976501465 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035951137542725 -- 26-01-18 11:22:36[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024506807327271 -- 26-01-18 11:22:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040397644042969 -- 26-01-18 11:22:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038230419158936 -- 26-01-18 11:22:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037899017333984 -- 26-01-18 11:22:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037930011749268 -- 26-01-18 11:22:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017672061920166 -- 26-01-18 11:33:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034739971160889 -- 26-01-18 11:33:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01743483543396 -- 26-01-18 11:33:52[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026738882064819 -- 26-01-18 11:33:57[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031669139862061 -- 26-01-18 11:33:57[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025652170181274 -- 26-01-18 11:33:58[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031909942626953 -- 26-01-18 11:33:58[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023154973983765 -- 26-01-18 11:34:02[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031960010528564 -- 26-01-18 11:34:02[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015748023986816 -- 26-01-18 11:34:02[曹乾国-2506] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016658067703247 -- 26-01-18 11:38:24[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032861232757568 -- 26-01-18 11:38:24[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018342971801758 -- 26-01-18 11:38:32[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035920143127441 -- 26-01-18 11:38:32[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017999887466431 -- 26-01-18 11:38:35[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017969846725464 -- 26-01-18 11:38:40[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035209655761719 -- 26-01-18 11:38:40[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016777038574219 -- 26-01-18 11:38:42[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032589435577393 -- 26-01-18 11:38:42[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022758007049561 -- 26-01-18 11:40:13[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034759044647217 -- 26-01-18 11:40:13[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027930974960327 -- 26-01-18 11:40:14[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032980442047119 -- 26-01-18 11:40:14[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016552925109863 -- 26-01-18 11:40:14[曹乾国-2506] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024366140365601 -- 26-01-18 11:40:15[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035090446472168 -- 26-01-18 11:40:15[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015843868255615 -- 26-01-18 11:40:15[曹乾国-2506] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017980098724365 -- 26-01-18 11:48:27[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 and e.extrafare_name like '%服务区补胎%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026186943054199 -- 26-01-18 11:49:47[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032248497009277 -- 26-01-18 11:49:48[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047719478607178 -- 26-01-18 11:49:48[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022282123565674 -- 26-01-18 11:53:08[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036201477050781 -- 26-01-18 11:53:08[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049238204956055 -- 26-01-18 11:53:09[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047910213470459 -- 26-01-18 11:53:09[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3343 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016402959823608 -- 26-01-18 11:53:10[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032680034637451 -- 26-01-18 11:53:10[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045099258422852 -- 26-01-18 11:53:10[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049660205841064 -- 26-01-18 11:53:10[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3343 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017297029495239 -- 26-01-18 11:53:44[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034239292144775 -- 26-01-18 11:53:44[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046360492706299 -- 26-01-18 11:53:44[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045042037963867 -- 26-01-18 11:53:44[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3343 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016831874847412 -- 26-01-18 11:53:46[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033390522003174 -- 26-01-18 11:53:46[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049328804016113 -- 26-01-18 11:53:46[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044040679931641 -- 26-01-18 11:53:46[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3343 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01741099357605 -- 26-01-18 11:59:14[杨林-2511] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030820846557617 -- 26-01-18 11:59:23[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037539005279541 -- 26-01-18 11:59:23[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050160884857178 -- 26-01-18 11:59:23[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 71096 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017157793045044 -- 26-01-18 12:00:08[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 26-01-18 12:00:08[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015805006027222 -- 26-01-18 12:00:12[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031261444091797 -- 26-01-18 12:00:12[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045020580291748 -- 26-01-18 12:00:12[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 71096 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049800872802734 -- 26-01-18 12:00:12[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2511,updatedby_id = 2511 where otherfee_id = 3344 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01586389541626 -- 26-01-18 12:00:12[杨林-2511] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01672101020813 -- 26-01-18 12:02:55[李云阳-2411] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017426013946533 -- 26-01-18 12:03:11[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034289360046387 -- 26-01-18 12:03:12[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049159526824951 -- 26-01-18 12:03:12[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2411,updatedby_id = 2411 where extrafareApply_id = 71097 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017002105712891 -- 26-01-18 12:03:14[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033571720123291 -- 26-01-18 12:03:14[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016528129577637 -- 26-01-18 12:03:47[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032351016998291 -- 26-01-18 12:03:47[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047409534454346 -- 26-01-18 12:03:47[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2411,updatedby_id = 2411 where extrafareApply_id = 71097 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049169063568115 -- 26-01-18 12:03:47[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2411,updatedby_id = 2411 where otherfee_id = 3345 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025519847869873 -- 26-01-18 13:14:08[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7386 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035400390625 -- 26-01-18 13:14:08[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034551620483398 -- 26-01-18 13:14:08[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035510063171387 -- 26-01-18 13:14:08[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5928324 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033919811248779 -- 26-01-18 13:14:08[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023941993713379 -- 26-01-18 13:14:13[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7385 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033390522003174 -- 26-01-18 13:14:13[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033159255981445 -- 26-01-18 13:14:13[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034859180450439 -- 26-01-18 13:14:13[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5928288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033140182495117 -- 26-01-18 13:14:13[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018187046051025 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 71074 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041100978851318 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 71074 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039830207824707 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 71074 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041530132293701 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 71074 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003450870513916 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034708976745605 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036070346832275 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5929589 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034389495849609 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034370422363281 -- 26-01-18 13:14:25[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2271074%22}&event=edit_extrafareApply&extrafareApply_id=71074 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015938997268677 -- 26-01-18 13:14:29[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7385 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030879974365234 -- 26-01-18 13:14:29[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031101703643799 -- 26-01-18 13:14:29[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003140926361084 -- 26-01-18 13:14:29[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5928288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031089782714844 -- 26-01-18 13:14:29[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227385%22}&event=edit_officialSeals&officialSeals_id=7385 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024610996246338 -- 26-01-18 13:14:31[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7386 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034608840942383 -- 26-01-18 13:14:31[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034549236297607 -- 26-01-18 13:14:31[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034959316253662 -- 26-01-18 13:14:31[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5928324 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034468173980713 -- 26-01-18 13:14:31[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227386%22}&event=edit_officialSeals&officialSeals_id=7386 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028631925582886 -- 26-01-18 13:22:03[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032429695129395 -- 26-01-18 13:22:03[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015845060348511 -- 26-01-18 13:22:04[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031208992004395 -- 26-01-18 13:22:04[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02600884437561 -- 26-01-18 13:22:10[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017262935638428 -- 26-01-18 13:22:18[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032780170440674 -- 26-01-18 13:22:18[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018334150314331 -- 26-01-18 13:22:19[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031728744506836 -- 26-01-18 13:22:19[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022312879562378 -- 26-01-18 13:22:21[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033879280090332 -- 26-01-18 13:22:22[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023568868637085 -- 26-01-18 13:22:22[曹乾国-2506] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017046928405762 -- 26-01-18 13:29:24[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 and e.extrafare_name like '%停车费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017697095870972 -- 26-01-18 13:29:39[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034770965576172 -- 26-01-18 13:29:39[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051720142364502 -- 26-01-18 13:29:40[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71098 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0171959400177 -- 26-01-18 13:30:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033979415893555 -- 26-01-18 13:30:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046589374542236 -- 26-01-18 13:30:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71098 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049278736114502 -- 26-01-18 13:30:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3346 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017436027526855 -- 26-01-18 13:30:54[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034401416778564 -- 26-01-18 13:30:55[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047190189361572 -- 26-01-18 13:30:55[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71098 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045571327209473 -- 26-01-18 13:30:55[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3346 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01623797416687 -- 26-01-18 13:31:36[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003180980682373 -- 26-01-18 13:31:36[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045888423919678 -- 26-01-18 13:31:36[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71098 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046730041503906 -- 26-01-18 13:31:36[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3346 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016479015350342 -- 26-01-18 13:31:39[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032598972320557 -- 26-01-18 13:31:39[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004504919052124 -- 26-01-18 13:31:39[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71098 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046908855438232 -- 26-01-18 13:31:39[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3346 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017963886260986 -- 26-01-18 13:32:10[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016078948974609 -- 26-01-18 13:32:17[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031380653381348 -- 26-01-18 13:32:17[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004478931427002 -- 26-01-18 13:32:17[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71098 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046689510345459 -- 26-01-18 13:32:17[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3346 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016289234161377 -- 26-01-18 13:32:20[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032000541687012 -- 26-01-18 13:32:20[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02157998085022 -- 26-01-18 13:32:24[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032989978790283 -- 26-01-18 13:32:24[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046541690826416 -- 26-01-18 13:32:24[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71098 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045650005340576 -- 26-01-18 13:32:24[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3346 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016196966171265 -- 26-01-18 13:32:25[曹乾国-2506] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017121076583862 -- 26-01-18 16:50:08[周荣宏-2407] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2407 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033731460571289 -- 26-01-18 16:50:08[周荣宏-2407] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2407 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025087118148804 -- 26-01-18 16:50:10[周荣宏-2407] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2407 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027783155441284 -- 26-01-18 16:50:27[周荣宏-2407] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2407 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019928932189941 -- 26-01-18 16:51:59[周荣宏-2407] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2407 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0173020362854 -- 26-01-18 16:52:17[周荣宏-2407] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2407 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01813793182373 -- 26-01-18 17:30:58[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017859220504761 -- 26-01-18 17:33:13[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035040378570557 -- 26-01-18 17:33:13[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00490403175354 -- 26-01-18 17:33:13[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71105 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026247978210449 -- 26-01-18 17:33:28[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016480922698975 -- 26-01-18 17:33:55[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032529830932617 -- 26-01-18 17:33:55[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017745971679688 -- 26-01-18 17:34:15[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035159587860107 -- 26-01-18 17:34:15[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004796028137207 -- 26-01-18 17:34:15[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71105 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052120685577393 -- 26-01-18 17:34:15[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3393 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01800799369812 -- 26-01-18 17:35:46[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031671524047852 -- 26-01-18 17:35:47[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004971981048584 -- 26-01-18 17:35:47[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71105 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00465989112854 -- 26-01-18 17:35:47[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3393 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016011953353882 -- 26-01-18 17:35:48[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003162145614624 -- 26-01-18 17:35:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045211315155029 -- 26-01-18 17:35:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71105 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042450428009033 -- 26-01-18 17:35:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3393 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018277168273926 -- 26-01-18 17:35:49[曹乾国-2506] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017077922821045 -- 26-01-18 17:43:53[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003331184387207 -- 26-01-18 17:43:53[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045108795166016 -- 26-01-18 17:43:53[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71106 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017385005950928 -- 26-01-18 17:44:02[曹乾国-2506] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017547130584717 -- 26-01-18 17:44:22[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034711360931396 -- 26-01-18 17:44:22[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01793098449707 -- 26-01-18 17:45:16[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035369396209717 -- 26-01-18 17:45:16[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049200057983398 -- 26-01-18 17:45:16[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71106 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053238868713379 -- 26-01-18 17:45:16[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3394 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018126964569092 -- 26-01-18 17:45:19[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035898685455322 -- 26-01-18 17:45:19[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053169727325439 -- 26-01-18 17:45:19[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2506,updatedby_id = 2506 where extrafareApply_id = 71106 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004688024520874 -- 26-01-18 17:45:19[曹乾国-2506] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2506,updatedby_id = 2506 where otherfee_id = 3394 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0155189037323 -- 26-01-18 17:45:19[曹乾国-2506] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029006958007812 -- 26-01-18 17:58:10[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1729198&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D666%26ship_city%3D%E5%8C%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032000541687012 -- 26-01-18 17:58:10[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1729198&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D666%26ship_city%3D%E5%8C%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031251907348633 -- 26-01-18 17:58:10[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1729198&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D666%26ship_city%3D%E5%8C%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032980442047119 -- 26-01-18 17:58:10[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1729198&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D666%26ship_city%3D%E5%8C%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1729198) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024027824401855 -- 26-01-18 17:58:11[唐敏-535] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017948150634766 -- 26-01-18 17:58:11[唐敏-535] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%唐敏%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028606176376343 -- 26-01-18 17:58:11[唐敏-535] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%北京办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019966125488281 -- 26-01-18 17:58:13[唐敏-535] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%唐敏%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016447067260742 -- 26-01-18 17:58:28[唐敏-535] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018156051635742 -- 26-01-18 17:58:59[唐敏-535] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 15 and e.extrafare_name like '%人工%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020096063613892 -- 26-01-18 17:59:05[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032730102539062 -- 26-01-18 17:59:05[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1729198) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031599998474121 -- 26-01-18 17:59:05[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02245306968689 -- 26-01-18 17:59:06[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 26-01-18 17:59:06[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015980005264282 -- 26-01-18 17:59:07[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031750202178955 -- 26-01-18 17:59:07[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015140056610107 -- 26-01-18 17:59:07[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016024827957153 -- 26-01-18 17:59:07[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02741003036499 -- 26-01-18 17:59:14[唐敏-535] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018194913864136 -- 26-01-18 17:59:16[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036289691925049 -- 26-01-18 17:59:16[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017554998397827 -- 26-01-18 17:59:18[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034868717193604 -- 26-01-18 17:59:18[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017847061157227 -- 26-01-18 17:59:19[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016170024871826 -- 26-01-18 17:59:20[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032360553741455 -- 26-01-18 17:59:20[唐敏-535] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016088962554932 -- 26-01-18 17:59:21[唐敏-535] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 535 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019293069839478 -- 26-01-18 18:20:52[陈更生-2441] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021795034408569 -- 26-01-18 18:21:07[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033600330352783 -- 26-01-18 18:21:07[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052890777587891 -- 26-01-18 18:21:07[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2441,updatedby_id = 2441 where extrafareApply_id = 71108 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016993999481201 -- 26-01-18 18:22:12[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00335693359375 -- 26-01-18 18:22:12[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046441555023193 -- 26-01-18 18:22:12[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2441,updatedby_id = 2441 where extrafareApply_id = 71108 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044460296630859 -- 26-01-18 18:22:12[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2441,updatedby_id = 2441 where otherfee_id = 3395 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016987085342407 -- 26-01-18 18:22:39[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033638477325439 -- 26-01-18 18:22:39[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048539638519287 -- 26-01-18 18:22:39[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2441,updatedby_id = 2441 where extrafareApply_id = 71108 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043637752532959 -- 26-01-18 18:22:39[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2441,updatedby_id = 2441 where otherfee_id = 3395 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01653790473938 -- 26-01-18 18:22:46[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032720565795898 -- 26-01-18 18:22:46[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049729347229004 -- 26-01-18 18:22:46[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2441,updatedby_id = 2441 where extrafareApply_id = 71108 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004706859588623 -- 26-01-18 18:22:46[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2441,updatedby_id = 2441 where otherfee_id = 3395 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016388893127441 -- 26-01-18 18:25:26[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032229423522949 -- 26-01-18 18:25:26[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046920776367188 -- 26-01-18 18:25:26[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2441,updatedby_id = 2441 where extrafareApply_id = 71108 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050299167633057 -- 26-01-18 18:25:26[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2441,updatedby_id = 2441 where otherfee_id = 3395 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016996145248413 -- 26-01-18 18:26:13[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033750534057617 -- 26-01-18 18:26:13[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2441 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004633903503418 -- 26-01-18 18:26:13[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2441,updatedby_id = 2441 where extrafareApply_id = 71108 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049049854278564 -- 26-01-18 18:26:13[陈更生-2441] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2441,updatedby_id = 2441 where otherfee_id = 3395 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017060995101929 -- 26-01-18 19:23:59[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033738613128662 -- 26-01-18 19:23:59[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032870769500732 -- 26-01-18 19:23:59[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034770965576172 -- 26-01-18 19:23:59[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1732150) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020888805389404 -- 26-01-18 19:23:59[李丹-751] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017079830169678 -- 26-01-18 19:23:59[李丹-751] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%李丹%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022945165634155 -- 26-01-18 19:23:59[李丹-751] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%上海办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019138813018799 -- 26-01-18 19:24:02[李丹-751] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%梁思聪%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017709016799927 -- 26-01-18 19:24:05[李丹-751] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018339872360229 -- 26-01-18 19:24:16[李丹-751] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 15 and e.extrafare_name like '%人工费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016347885131836 -- 26-01-18 19:24:29[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033531188964844 -- 26-01-18 19:24:29[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1732150) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032298564910889 -- 26-01-18 19:24:29[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017279863357544 -- 26-01-18 19:24:30[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030660629272461 -- 26-01-18 19:24:30[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024307012557983 -- 26-01-18 19:24:30[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033769607543945 -- 26-01-18 19:24:31[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016921997070312 -- 26-01-18 19:24:31[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033259391784668 -- 26-01-18 19:24:31[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027567148208618 -- 26-01-18 19:24:32[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016396045684814 -- 26-01-18 19:24:35[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032150745391846 -- 26-01-18 19:24:35[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01661205291748 -- 26-01-18 19:24:36[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032520294189453 -- 26-01-18 19:24:36[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031383991241455 -- 26-01-18 19:24:36[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017933130264282 -- 26-01-18 19:29:34 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036158561706543 -- 26-01-18 19:29:34 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041649341583252 -- 26-01-18 19:29:34 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiuXiaoJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037708282470703 -- 26-01-18 19:29:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018192052841187 -- 26-01-18 19:29:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01974081993103 -- 26-01-18 19:29:40[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040488243103027 -- 26-01-18 19:29:40[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037000179290771 -- 26-01-18 19:29:40[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003695011138916 -- 26-01-18 19:29:40[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036940574645996 -- 26-01-18 19:29:40[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018050909042358 -- 26-01-18 19:29:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7369 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033919811248779 -- 26-01-18 19:29:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5921382 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032417774200439 -- 26-01-18 19:29:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032320022583008 -- 26-01-18 19:29:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=7369 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018738985061646 -- 26-01-18 19:29:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041060447692871 -- 26-01-18 19:29:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037550926208496 -- 26-01-18 19:29:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037591457366943 -- 26-01-18 19:29:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037689208984375 -- 26-01-18 19:29:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017547130584717 -- 26-01-18 19:29:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43901 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43901 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031089782714844 -- 26-01-18 19:29:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43901 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003328800201416 -- 26-01-18 19:29:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43901 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5914160 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031290054321289 -- 26-01-18 19:29:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43901 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031261444091797 -- 26-01-18 19:29:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43901 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031709671020508 -- 26-01-18 19:29:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43901 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5914160 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031111240386963 -- 26-01-18 19:29:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43901 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028681039810181 -- 26-01-18 19:29:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016924142837524 -- 26-01-18 19:29:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018527984619141 -- 26-01-18 19:29:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026903867721558 -- 26-01-18 19:29:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01761794090271 -- 26-01-18 19:29:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035300254821777 -- 26-01-18 19:29:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022703886032104 -- 26-01-18 19:34:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032620429992676 -- 26-01-18 19:34:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031521320343018 -- 26-01-18 19:34:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033390522003174 -- 26-01-18 19:34:39[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1732150&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1732150) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025295972824097 -- 26-01-18 19:34:39[李丹-751] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017311096191406 -- 26-01-18 19:34:39[李丹-751] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%李丹%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021478176116943 -- 26-01-18 19:34:39[李丹-751] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%上海办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016197204589844 -- 26-01-18 20:09:39[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01752495765686 -- 26-01-18 20:10:33[李晓涛-2495] -- /buz/oa/index.php/oamgmt/oa_application?event=undoSubmit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016928911209106 -- 26-01-18 20:11:00[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033318996429443 -- 26-01-18 20:11:00[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016642093658447 -- 26-01-18 20:11:01[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032820701599121 -- 26-01-18 20:11:02[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019016027450562 -- 26-01-18 20:11:02[李晓涛-2495] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025881052017212 -- 26-01-18 20:11:43[李晓涛-2495] -- /buz/oa/index.php/oamgmt/oa_application?event=undoSubmit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016268968582153 -- 26-01-18 20:12:08[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031991004943848 -- 26-01-18 20:12:08[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018550157546997 -- 26-01-18 20:13:42[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036900043487549 -- 26-01-18 20:13:42[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016939878463745 -- 26-01-18 20:14:54[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033140182495117 -- 26-01-18 20:14:54[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045888423919678 -- 26-01-18 20:14:54[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71110 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015672922134399 -- 26-01-18 20:15:00[董国强-2434] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024391889572144 -- 26-01-18 20:16:41[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016201019287109 -- 26-01-18 20:17:07[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032141208648682 -- 26-01-18 20:17:07[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016197919845581 -- 26-01-18 20:17:08[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032918453216553 -- 26-01-18 20:17:08[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018307209014893 -- 26-01-18 20:17:08[李晓涛-2495] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017009973526001 -- 26-01-18 20:17:43[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003331184387207 -- 26-01-18 20:17:43[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016693115234375 -- 26-01-18 20:17:52[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033020973205566 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047109127044678 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71110 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048480033874512 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3396 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015987873077393 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016781091690063 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033378601074219 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047791004180908 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71110 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043349266052246 -- 26-01-18 20:17:53[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3396 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016229867935181 -- 26-01-18 20:17:54[董国强-2434] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022450923919678 -- 26-01-18 20:17:55[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031771659851074 -- 26-01-18 20:17:55[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047740936279297 -- 26-01-18 20:17:55[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71110 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045020580291748 -- 26-01-18 20:17:55[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3396 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01783013343811 -- 26-01-18 20:17:56[董国强-2434] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018075942993164 -- 26-01-18 20:23:18[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035650730133057 -- 26-01-18 20:23:18[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049808025360107 -- 26-01-18 20:23:18[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017613887786865 -- 26-01-18 20:23:24[董国强-2434] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016453981399536 -- 26-01-18 20:25:20[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032520294189453 -- 26-01-18 20:25:20[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048890113830566 -- 26-01-18 20:25:21[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050151348114014 -- 26-01-18 20:25:21[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023912191390991 -- 26-01-18 20:27:11[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030970573425293 -- 26-01-18 20:27:11[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046558380126953 -- 26-01-18 20:27:11[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043652057647705 -- 26-01-18 20:27:11[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016556978225708 -- 26-01-18 20:27:16[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00325608253479 -- 26-01-18 20:27:16[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046110153198242 -- 26-01-18 20:27:16[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046780109405518 -- 26-01-18 20:27:16[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01744818687439 -- 26-01-18 20:27:19[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034611225128174 -- 26-01-18 20:27:19[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047130584716797 -- 26-01-18 20:27:19[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049958229064941 -- 26-01-18 20:27:19[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022168874740601 -- 26-01-18 20:27:23[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031180381774902 -- 26-01-18 20:27:23[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043799877166748 -- 26-01-18 20:27:23[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044350624084473 -- 26-01-18 20:27:23[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016618967056274 -- 26-01-18 20:27:33[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032899379730225 -- 26-01-18 20:27:33[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004709005355835 -- 26-01-18 20:27:33[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050249099731445 -- 26-01-18 20:27:33[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024029970169067 -- 26-01-18 20:27:36[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-18 20:27:36[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048830509185791 -- 26-01-18 20:27:36[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050418376922607 -- 26-01-18 20:27:36[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015552997589111 -- 26-01-18 20:27:59[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030670166015625 -- 26-01-18 20:28:00[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044479370117188 -- 26-01-18 20:28:00[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044600963592529 -- 26-01-18 20:28:00[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01603889465332 -- 26-01-18 20:28:01[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031628608703613 -- 26-01-18 20:28:01[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044569969177246 -- 26-01-18 20:28:01[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042760372161865 -- 26-01-18 20:28:01[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017082929611206 -- 26-01-18 20:28:33[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033459663391113 -- 26-01-18 20:28:34[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018976926803589 -- 26-01-18 20:29:08[董国强-2434] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017166137695312 -- 26-01-18 20:30:12[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033760070800781 -- 26-01-18 20:30:12[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018858909606934 -- 26-01-18 20:30:14[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034739971160889 -- 26-01-18 20:30:14[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017781972885132 -- 26-01-18 20:30:16[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034911632537842 -- 26-01-18 20:30:16[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024258852005005 -- 26-01-18 20:30:19[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034081935882568 -- 26-01-18 20:30:19[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017199993133545 -- 26-01-18 20:30:20[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033369064331055 -- 26-01-18 20:30:20[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016113996505737 -- 26-01-18 20:30:24[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031828880310059 -- 26-01-18 20:30:24[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017040967941284 -- 26-01-18 20:30:29[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033721923828125 -- 26-01-18 20:30:29[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016139030456543 -- 26-01-18 20:31:17[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031800270080566 -- 26-01-18 20:31:17[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021777153015137 -- 26-01-18 20:31:18[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033669471740723 -- 26-01-18 20:31:18[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018183946609497 -- 26-01-18 20:31:20[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035789012908936 -- 26-01-18 20:31:20[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016576051712036 -- 26-01-18 20:31:44[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032730102539062 -- 26-01-18 20:31:44[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020159006118774 -- 26-01-18 20:31:50[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032939910888672 -- 26-01-18 20:31:50[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018517971038818 -- 26-01-18 20:32:37[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003654956817627 -- 26-01-18 20:32:37[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0174880027771 -- 26-01-18 20:32:44[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034298896789551 -- 26-01-18 20:32:44[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016456127166748 -- 26-01-18 20:32:47[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032351016998291 -- 26-01-18 20:32:47[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016041040420532 -- 26-01-18 20:48:31[董国强-2434] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026395082473755 -- 26-01-18 20:49:31[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033462047576904 -- 26-01-18 20:49:32[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046768188476562 -- 26-01-18 20:49:32[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71112 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016737937927246 -- 26-01-18 20:51:25[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032930374145508 -- 26-01-18 20:51:26[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046708583831787 -- 26-01-18 20:51:26[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71112 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049140453338623 -- 26-01-18 20:51:26[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3403 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022814035415649 -- 26-01-18 20:51:30[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035150051116943 -- 26-01-18 20:51:30[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049450397491455 -- 26-01-18 20:51:31[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71112 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046899318695068 -- 26-01-18 20:51:31[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3403 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016111850738525 -- 26-01-18 20:54:01[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031349658966064 -- 26-01-18 20:54:01[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044889450073242 -- 26-01-18 20:54:01[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71113 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017668962478638 -- 26-01-18 20:54:05[董国强-2434] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017186880111694 -- 26-01-18 20:56:04[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033528804779053 -- 26-01-18 20:56:04[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046098232269287 -- 26-01-18 20:56:04[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71113 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046181678771973 -- 26-01-18 20:56:04[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3404 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025143146514893 -- 26-01-18 20:56:07[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035629272460938 -- 26-01-18 20:56:07[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2434 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047481060028076 -- 26-01-18 20:56:08[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2434,updatedby_id = 2434 where extrafareApply_id = 71113 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046501159667969 -- 26-01-18 20:56:08[董国强-2434] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2434,updatedby_id = 2434 where otherfee_id = 3404 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01681113243103 -- 26-01-18 21:53:09[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032520294189453 -- 26-01-18 21:53:09[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046038627624512 -- 26-01-18 21:53:09[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2418,updatedby_id = 2418 where extrafareApply_id = 71121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016998052597046 -- 26-01-18 21:53:45[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033581256866455 -- 26-01-18 21:53:45[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004749059677124 -- 26-01-18 21:53:45[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2418,updatedby_id = 2418 where extrafareApply_id = 71121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049848556518555 -- 26-01-18 21:53:45[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2418,updatedby_id = 2418 where otherfee_id = 3415 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017425060272217 -- 26-01-18 21:53:48[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034580230712891 -- 26-01-18 21:53:48[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048689842224121 -- 26-01-18 21:53:48[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2418,updatedby_id = 2418 where extrafareApply_id = 71121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045630931854248 -- 26-01-18 21:53:48[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2418,updatedby_id = 2418 where otherfee_id = 3415 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017888069152832 -- 26-01-18 21:54:06[程博-2418] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025632858276367 -- 26-01-18 21:54:18[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031249523162842 -- 26-01-18 21:54:18[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0187668800354 -- 26-01-18 21:54:20[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003695011138916 -- 26-01-18 21:54:20[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050239562988281 -- 26-01-18 21:54:20[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2418,updatedby_id = 2418 where extrafareApply_id = 71121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048980712890625 -- 26-01-18 21:54:20[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2418,updatedby_id = 2418 where otherfee_id = 3415 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015893936157227 -- 26-01-18 21:54:22[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031330585479736 -- 26-01-18 21:54:22[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004594087600708 -- 26-01-18 21:54:22[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2418,updatedby_id = 2418 where extrafareApply_id = 71121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044000148773193 -- 26-01-18 21:54:22[程博-2418] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2418,updatedby_id = 2418 where otherfee_id = 3415 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017850160598755 -- 26-01-18 21:54:23[程博-2418] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2418 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016695022583008 -- 26-01-18 22:32:43 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033059120178223 -- 26-01-18 22:32:43 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041689872741699 -- 26-01-18 22:32:43 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='XiaoChun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035550594329834 -- 26-01-18 22:32:43[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021284103393555 -- 26-01-18 22:32:43[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016759872436523 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 117492 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032930374145508 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 select payment_id from dbthird.thd_payment where oa_payment_id = 117492 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003349781036377 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 134483 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003741979598999 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5932644 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031580924987793 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033340454101562 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032720565795898 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5932644 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031499862670898 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031490325927734 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032000541687012 -- 26-01-18 22:32:45[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117492 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017076969146729 -- 26-01-18 22:32:46[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=117492 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017218112945557 -- 26-01-18 22:32:47[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019829034805298 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 117491 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038819313049316 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 select payment_id from dbthird.thd_payment where oa_payment_id = 117491 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039498805999756 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 134482 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043151378631592 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5932643 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037479400634766 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037949085235596 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003882884979248 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5932643 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037670135498047 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037548542022705 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037729740142822 -- 26-01-18 22:32:48[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117491 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019692897796631 -- 26-01-18 22:32:49[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=117491 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016892194747925 -- 26-01-18 22:32:50[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02980899810791 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 117488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037689208984375 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 select payment_id from dbthird.thd_payment where oa_payment_id = 117488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038437843322754 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 134479 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041890144348145 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5932640 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036380290985107 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037100315093994 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037558078765869 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5932640 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036420822143555 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036311149597168 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036828517913818 -- 26-01-18 22:32:52[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117488 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024603843688965 -- 26-01-18 22:32:53[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=117488 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016963958740234 -- 26-01-18 22:32:54[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016829967498779 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 117235 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032861232757568 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 select payment_id from dbthird.thd_payment where oa_payment_id = 117235 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033729076385498 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 134296 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037088394165039 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5921963 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031859874725342 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032219886779785 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033190250396729 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5921963 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031709671020508 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031638145446777 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031969547271729 -- 26-01-18 22:32:56[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=117235 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017030954360962 -- 26-01-18 22:32:57[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=117235 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016419172286987 -- 26-01-18 22:32:57[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015861034393311 -- 26-01-18 23:16:31[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003108024597168 -- 26-01-18 23:16:31[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048549175262451 -- 26-01-18 23:16:31[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2497,updatedby_id = 2497 where extrafareApply_id = 71124 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017199039459229 -- 26-01-18 23:16:44[邹平-2497] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018375158309937 -- 26-01-18 23:17:19[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036020278930664 -- 26-01-18 23:17:19[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017219066619873 -- 26-01-18 23:17:23[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 26-01-18 23:17:23[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046539306640625 -- 26-01-18 23:17:23[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2497,updatedby_id = 2497 where extrafareApply_id = 71124 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045831203460693 -- 26-01-18 23:17:23[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2497,updatedby_id = 2497 where otherfee_id = 3418 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017950057983398 -- 26-01-18 23:18:49[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035450458526611 -- 26-01-18 23:18:49[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048668384552002 -- 26-01-18 23:18:49[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2497,updatedby_id = 2497 where extrafareApply_id = 71124 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045180320739746 -- 26-01-18 23:18:49[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2497,updatedby_id = 2497 where otherfee_id = 3418 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017211198806763 -- 26-01-18 23:18:49[邹平-2497] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016228199005127 -- 26-01-18 23:20:06[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032031536102295 -- 26-01-18 23:20:06[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050151348114014 -- 26-01-18 23:20:06[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2497,updatedby_id = 2497 where extrafareApply_id = 71125 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026480913162231 -- 26-01-18 23:20:16[邹平-2497] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017595052719116 -- 26-01-18 23:20:34[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034809112548828 -- 26-01-18 23:20:34[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028239011764526 -- 26-01-18 23:20:37[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035040378570557 -- 26-01-18 23:20:37[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049347877502441 -- 26-01-18 23:20:37[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2497,updatedby_id = 2497 where extrafareApply_id = 71125 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048239231109619 -- 26-01-18 23:20:37[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2497,updatedby_id = 2497 where otherfee_id = 3419 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016713857650757 -- 26-01-18 23:21:04[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033068656921387 -- 26-01-18 23:21:04[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045568943023682 -- 26-01-18 23:21:04[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2497,updatedby_id = 2497 where extrafareApply_id = 71125 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047049522399902 -- 26-01-18 23:21:04[邹平-2497] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2497,updatedby_id = 2497 where otherfee_id = 3419 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01714301109314 -- 26-01-18 23:21:04[邹平-2497] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2497 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028580188751221 -- 26-01-18 23:50:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------