Time: 0.015975952148438 -- 25-05-31 01:50:13 -- /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.0032510757446289 -- 25-05-31 01:50:13 -- /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.0037691593170166 -- 25-05-31 01:50:13 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhuXiaoFeng' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 25-05-31 01:50:13[朱小凤-937] -- /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.017735958099365 -- 25-05-31 01:50:13[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020550012588501 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 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 = 96379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042910575866699 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 select payment_id from dbthird.thd_payment where oa_payment_id = 96379 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054688453674316 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 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 = 114898 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047650337219238 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 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 = 4713224 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038120746612549 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003972053527832 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 select * from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039448738098145 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4713224 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038149356842041 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003777027130127 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038530826568604 -- 25-05-31 01:50:16[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96379 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01832103729248 -- 25-05-31 01:50:17[朱小凤-937] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=96379 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019870042800903 -- 25-05-31 01:50:18[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016769886016846 -- 25-05-31 07:39:18[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236333%22%7D&event=edit_fareApply&fareApply_id=36333 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 = 36333 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033829212188721 -- 25-05-31 07:39:18[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236333%22%7D&event=edit_fareApply&fareApply_id=36333 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36333 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039329528808594 -- 25-05-31 07:39:18[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236333%22%7D&event=edit_fareApply&fareApply_id=36333 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 = 4716347 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033359527587891 -- 25-05-31 07:39:18[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236333%22%7D&event=edit_fareApply&fareApply_id=36333 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034539699554443 -- 25-05-31 07:39:18[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236333%22%7D&event=edit_fareApply&fareApply_id=36333 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716347 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032460689544678 -- 25-05-31 07:39:18[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236333%22%7D&event=edit_fareApply&fareApply_id=36333 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015864849090576 -- 25-05-31 07:39:22[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36333 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027738094329834 -- 25-05-31 07:39:22[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017693996429443 -- 25-05-31 07:39:24[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36329 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 = 36329 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035829544067383 -- 25-05-31 07:39:24[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36329 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36329 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004004955291748 -- 25-05-31 07:39:24[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36329 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 = 4716331 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003446102142334 -- 25-05-31 07:39:24[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003605842590332 -- 25-05-31 07:39:24[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36329 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716331 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034480094909668 -- 25-05-31 07:39:24[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017289876937866 -- 25-05-31 07:39:29[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36329 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016743898391724 -- 25-05-31 07:39:29[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025092124938965 -- 25-05-31 07:39:30[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36330 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 = 36330 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033130645751953 -- 25-05-31 07:39:30[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36330 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36330 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037670135498047 -- 25-05-31 07:39:30[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36330 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 = 4716332 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003201961517334 -- 25-05-31 07:39:30[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033831596374512 -- 25-05-31 07:39:30[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36330 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716332 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031759738922119 -- 25-05-31 07:39:30[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01926589012146 -- 25-05-31 07:39:34[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018209934234619 -- 25-05-31 07:39:35[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015472173690796 -- 25-05-31 07:39:36[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36331 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 = 36331 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031330585479736 -- 25-05-31 07:39:36[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36331 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36331 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035510063171387 -- 25-05-31 07:39:36[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36331 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 = 4716342 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030300617218018 -- 25-05-31 07:39:36[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36331 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032200813293457 -- 25-05-31 07:39:36[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36331 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716342 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030319690704346 -- 25-05-31 07:39:36[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36331 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021737098693848 -- 25-05-31 07:39:41[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36331 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018640041351318 -- 25-05-31 07:39:42[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01857590675354 -- 25-05-31 07:39:42[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36332 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 = 36332 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035591125488281 -- 25-05-31 07:39:42[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36332 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36332 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035529136657715 -- 25-05-31 07:39:42[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36332 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 = 4716343 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034160614013672 -- 25-05-31 07:39:42[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36332 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00357985496521 -- 25-05-31 07:39:43[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36332 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716343 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 25-05-31 07:39:43[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36332 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019069194793701 -- 25-05-31 07:39:47[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36332 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0174880027771 -- 25-05-31 07:39:48[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030171871185303 -- 25-05-31 09:12:01[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236269%22}&event=edit_fareApply&fareApply_id=36269 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 = 36269 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043041706085205 -- 25-05-31 09:12:01[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236269%22}&event=edit_fareApply&fareApply_id=36269 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36269 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042819976806641 -- 25-05-31 09:12:01[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236269%22}&event=edit_fareApply&fareApply_id=36269 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 = 4703676 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037479400634766 -- 25-05-31 09:12:01[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236269%22}&event=edit_fareApply&fareApply_id=36269 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039229393005371 -- 25-05-31 09:12:01[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236269%22}&event=edit_fareApply&fareApply_id=36269 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4703676 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003695011138916 -- 25-05-31 09:12:01[刘伍-933] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2236269%22}&event=edit_fareApply&fareApply_id=36269 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01672101020813 -- 25-05-31 10:06:31[李明娥-478] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 478 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019496202468872 -- 25-05-31 10:34:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 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 = 61980 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044600963592529 -- 25-05-31 10:34:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61980 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044348239898682 -- 25-05-31 10:34:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 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 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 = 61980 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038051605224609 -- 25-05-31 10:34:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003777027130127 -- 25-05-31 10:34:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039141178131104 -- 25-05-31 10:34:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4715872 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037510395050049 -- 25-05-31 10:34:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019762992858887 -- 25-05-31 10:34:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 61936 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004019021987915 -- 25-05-31 10:34:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040957927703857 -- 25-05-31 10:34:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 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 = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034949779510498 -- 25-05-31 10:34:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035221576690674 -- 25-05-31 10:34:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036659240722656 -- 25-05-31 10:34:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4712702 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034859180450439 -- 25-05-31 10:34:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02585506439209 -- 25-05-31 10:54:10[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 61936 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040109157562256 -- 25-05-31 10:54:10[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039479732513428 -- 25-05-31 10:54:10[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 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 = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034379959106445 -- 25-05-31 10:54:10[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034000873565674 -- 25-05-31 10:54:10[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003511905670166 -- 25-05-31 10:54:10[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4712702 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033469200134277 -- 25-05-31 10:54:10[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026569843292236 -- 25-05-31 10:54:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 61933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041239261627197 -- 25-05-31 10:54:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043380260467529 -- 25-05-31 10:54:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 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 = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035910606384277 -- 25-05-31 10:54:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036289691925049 -- 25-05-31 10:54:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003777027130127 -- 25-05-31 10:54:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711919 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036020278930664 -- 25-05-31 10:54:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015774011611938 -- 25-05-31 10:56:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 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 = 61877 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035688877105713 -- 25-05-31 10:56:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61877 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003605842590332 -- 25-05-31 10:56:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 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 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 = 61877 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030980110168457 -- 25-05-31 10:56:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030500888824463 -- 25-05-31 10:56:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031988620758057 -- 25-05-31 10:57:00[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4707763 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030310153961182 -- 25-05-31 10:57:00[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026889085769653 -- 25-05-31 10:57:07[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 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 = 61876 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041749477386475 -- 25-05-31 10:57:07[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61876 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042679309844971 -- 25-05-31 10:57:07[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 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 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 = 61876 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004021167755127 -- 25-05-31 10:57:07[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040628910064697 -- 25-05-31 10:57:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041909217834473 -- 25-05-31 10:57:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4707759 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040199756622314 -- 25-05-31 10:57:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017204999923706 -- 25-05-31 10:57:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 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 = 61869 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037360191345215 -- 25-05-31 10:57:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61869 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038719177246094 -- 25-05-31 10:57:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 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 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 = 61869 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032508373260498 -- 25-05-31 10:57:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032620429992676 -- 25-05-31 10:57:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034048557281494 -- 25-05-31 10:57:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4706695 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032310485839844 -- 25-05-31 10:57:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016325950622559 -- 25-05-31 11:13:39 -- /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.025113105773926 -- 25-05-31 11:13:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042829513549805 -- 25-05-31 11:13:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013599872589111 -- 25-05-31 11:13:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046260356903076 -- 25-05-31 11:13:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049018859863281 -- 25-05-31 11:13:42[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020648002624512 -- 25-05-31 11:13:47[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment 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 = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041840076446533 -- 25-05-31 11:13:47[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041420459747314 -- 25-05-31 11:13:47[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046029090881348 -- 25-05-31 11:13:47[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016272068023682 -- 25-05-31 11:13:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003673791885376 -- 25-05-31 11:13:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052051544189453 -- 25-05-31 11:13:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035908222198486 -- 25-05-31 11:13:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035810470581055 -- 25-05-31 11:13:55[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027482986450195 -- 25-05-31 11:13:58[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment 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 = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030968189239502 -- 25-05-31 11:13:58[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030901432037354 -- 25-05-31 11:13:58[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032060146331787 -- 25-05-31 11:13:58[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028057098388672 -- 25-05-31 11:14:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003777027130127 -- 25-05-31 11:14:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042850971221924 -- 25-05-31 11:14:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037269592285156 -- 25-05-31 11:14:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003741979598999 -- 25-05-31 11:14:00[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01750111579895 -- 25-05-31 11:22:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035140514373779 -- 25-05-31 11:22:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040450096130371 -- 25-05-31 11:22:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039379596710205 -- 25-05-31 11:22:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038580894470215 -- 25-05-31 11:22:42[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021533012390137 -- 25-05-31 11:22:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039069652557373 -- 25-05-31 11:22:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040440559387207 -- 25-05-31 11:22:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038378238677979 -- 25-05-31 11:22:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038249492645264 -- 25-05-31 11:22:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019180059432983 -- 25-05-31 11:22:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041120052337646 -- 25-05-31 11:22:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042798519134521 -- 25-05-31 11:22:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041007995605469 -- 25-05-31 11:22:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040428638458252 -- 25-05-31 11:22:58[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025069952011108 -- 25-05-31 11:25:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037298202514648 -- 25-05-31 11:25:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038390159606934 -- 25-05-31 11:25:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036671161651611 -- 25-05-31 11:25:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003654956817627 -- 25-05-31 11:25:06[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020449876785278 -- 25-05-31 11:31:33[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045509338378906 -- 25-05-31 11:31:33[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004647970199585 -- 25-05-31 11:31:33[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004457950592041 -- 25-05-31 11:31:33[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044329166412354 -- 25-05-31 11:31:33[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020659923553467 -- 25-05-31 11:31:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038208961486816 -- 25-05-31 11:31:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039689540863037 -- 25-05-31 11:31:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037341117858887 -- 25-05-31 11:31:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037357807159424 -- 25-05-31 11:31:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020102977752686 -- 25-05-31 11:31:44[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044450759887695 -- 25-05-31 11:31:44[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045280456542969 -- 25-05-31 11:31:44[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043599605560303 -- 25-05-31 11:31:44[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043799877166748 -- 25-05-31 11:31:44[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025596857070923 -- 25-05-31 11:31:45[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038259029388428 -- 25-05-31 11:31:45[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038530826568604 -- 25-05-31 11:31:45[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038149356842041 -- 25-05-31 11:31:45[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038230419158936 -- 25-05-31 11:31:45[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020378828048706 -- 25-05-31 11:31:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043349266052246 -- 25-05-31 11:31:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044810771942139 -- 25-05-31 11:31:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043199062347412 -- 25-05-31 11:31:55[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042979717254639 -- 25-05-31 11:31:55[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022761106491089 -- 25-05-31 13:22:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038988590240479 -- 25-05-31 13:22:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004356861114502 -- 25-05-31 13:22:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039310455322266 -- 25-05-31 13:22:06[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038330554962158 -- 25-05-31 13:22:06[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021533012390137 -- 25-05-31 13:22:07[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037670135498047 -- 25-05-31 13:22:07[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039129257202148 -- 25-05-31 13:22:07[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036962032318115 -- 25-05-31 13:22:07[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037169456481934 -- 25-05-31 13:22:07[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016424894332886 -- 25-05-31 13:22:11[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003547191619873 -- 25-05-31 13:22:11[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040829181671143 -- 25-05-31 13:22:11[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035109519958496 -- 25-05-31 13:22:11[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034990310668945 -- 25-05-31 13:22:11[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017350196838379 -- 25-05-31 14:17:13[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040900707244873 -- 25-05-31 14:17:13[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043787956237793 -- 25-05-31 14:17:13[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039651393890381 -- 25-05-31 14:17:13[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039458274841309 -- 25-05-31 14:17:13[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018259048461914 -- 25-05-31 14:17:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031659603118896 -- 25-05-31 14:17:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032379627227783 -- 25-05-31 14:17:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030472278594971 -- 25-05-31 14:17:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003061056137085 -- 25-05-31 14:17:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018013000488281 -- 25-05-31 14:17:21[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004000186920166 -- 25-05-31 14:17:21[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044488906860352 -- 25-05-31 14:17:21[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038959980010986 -- 25-05-31 14:17:21[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039079189300537 -- 25-05-31 14:17:21[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020779848098755 -- 25-05-31 14:18:13 -- /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.019931793212891 -- 25-05-31 15:17:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043301582336426 -- 25-05-31 15:17:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044090747833252 -- 25-05-31 15:17:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043079853057861 -- 25-05-31 15:17:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004209041595459 -- 25-05-31 15:17:42[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020490884780884 -- 25-05-31 15:17:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036420822143555 -- 25-05-31 15:17:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038430690765381 -- 25-05-31 15:17:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003593921661377 -- 25-05-31 15:17:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035858154296875 -- 25-05-31 15:17:43[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017820119857788 -- 25-05-31 15:17:49[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035419464111328 -- 25-05-31 15:17:49[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040850639343262 -- 25-05-31 15:17:49[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035269260406494 -- 25-05-31 15:17:49[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035278797149658 -- 25-05-31 15:17:49[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019367933273315 -- 25-05-31 15:17:53[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038490295410156 -- 25-05-31 15:17:53[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043959617614746 -- 25-05-31 15:17:53[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038261413574219 -- 25-05-31 15:17:53[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038349628448486 -- 25-05-31 15:17:53[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015928983688354 -- 25-05-31 15:17:53[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030839443206787 -- 25-05-31 15:17:53[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031270980834961 -- 25-05-31 15:17:53[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030848979949951 -- 25-05-31 15:17:53[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030980110168457 -- 25-05-31 15:17:53[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02031397819519 -- 25-05-31 15:17:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044660568237305 -- 25-05-31 15:17:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050039291381836 -- 25-05-31 15:17:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044050216674805 -- 25-05-31 15:17:58[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044181346893311 -- 25-05-31 15:17:58[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020375967025757 -- 25-05-31 16:05:18[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045161247253418 -- 25-05-31 16:05:18[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049819946289062 -- 25-05-31 16:05:18[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044469833374023 -- 25-05-31 16:05:18[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044150352478027 -- 25-05-31 16:05:18[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017433881759644 -- 25-05-31 16:05:19[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032200813293457 -- 25-05-31 16:05:19[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033738613128662 -- 25-05-31 16:05:19[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030980110168457 -- 25-05-31 16:05:19[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031158924102783 -- 25-05-31 16:05:19[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023595094680786 -- 25-05-31 16:05:23[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034160614013672 -- 25-05-31 16:05:23[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039341449737549 -- 25-05-31 16:05:23[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034370422363281 -- 25-05-31 16:05:23[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034031867980957 -- 25-05-31 16:05:23[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017493963241577 -- 25-05-31 16:21:36[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003896951675415 -- 25-05-31 16:21:36[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039939880371094 -- 25-05-31 16:21:36[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00394606590271 -- 25-05-31 16:21:36[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003889799118042 -- 25-05-31 16:21:36[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020832061767578 -- 25-05-31 16:21:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030279159545898 -- 25-05-31 16:21:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031068325042725 -- 25-05-31 16:21:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029399394989014 -- 25-05-31 16:21:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029170513153076 -- 25-05-31 16:21:37[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026015043258667 -- 25-05-31 16:21:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037541389465332 -- 25-05-31 16:21:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038599967956543 -- 25-05-31 16:21:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036780834197998 -- 25-05-31 16:21:42[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037839412689209 -- 25-05-31 16:21:42[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018008947372437 -- 25-05-31 16:25:27 -- /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.0035610198974609 -- 25-05-31 16:25:27 -- /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.0040171146392822 -- 25-05-31 16:25:27 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037620067596436 -- 25-05-31 16:25:27[张进-414] -- /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.019716024398804 -- 25-05-31 16:25:27[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023138046264648 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 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 = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036430358886719 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select payment_id from dbthird.thd_payment where oa_payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037410259246826 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 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 = 114925 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042550563812256 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 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 = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035469532012939 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037000179290771 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select * from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036919116973877 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035240650177002 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035409927368164 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035560131072998 -- 25-05-31 16:25:28[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021445035934448 -- 25-05-31 16:25:29[张进-414] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023018836975098 -- 25-05-31 16:25:30[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015468120574951 -- 25-05-31 16:25:30[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36328 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 = 36328 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00364089012146 -- 25-05-31 16:25:30[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36328 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36328 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035138130187988 -- 25-05-31 16:25:30[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36328 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 = 4715705 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029921531677246 -- 25-05-31 16:25:30[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36328 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032219886779785 -- 25-05-31 16:25:31[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36328 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4715705 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030019283294678 -- 25-05-31 16:25:31[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36328 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026674032211304 -- 25-05-31 16:25:32[张进-414] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36328 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03034496307373 -- 25-05-31 16:25:32[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018744945526123 -- 25-05-31 16:25:33[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36327 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 = 36327 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040180683135986 -- 25-05-31 16:25:33[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36327 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36327 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052540302276611 -- 25-05-31 16:25:33[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36327 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 = 4715704 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035700798034668 -- 25-05-31 16:25:33[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36327 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037181377410889 -- 25-05-31 16:25:33[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36327 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4715704 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035479068756104 -- 25-05-31 16:25:33[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36327 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024708032608032 -- 25-05-31 16:25:34[张进-414] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36327 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018142938613892 -- 25-05-31 16:25:35[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020129919052124 -- 25-05-31 16:25:35[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5728 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 = 5728 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037939548492432 -- 25-05-31 16:25:35[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5728 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036962032318115 -- 25-05-31 16:25:35[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5728 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038561820983887 -- 25-05-31 16:25:36[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5728 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4703583 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037209987640381 -- 25-05-31 16:25:36[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=5728 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016046047210693 -- 25-05-31 16:25:37[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025897026062012 -- 25-05-31 16:25:38[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3572 select a.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(a.purch_apply_date,'%Y-%m-%d') apply_date,1 appr_type_id,p.appr_proc_name, date_format(a.purch_end_date,'%Y-%m-%d') purch_end_date from dbpurc.purc_apply a LEFT JOIN dbsys.sys_contact c ON a.purch_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON a.purch_department_id = org.org_id LEFT JOIN dbsys.sys_contact cr on a.createdby_id = cr.cont_id LEFT JOIN dbsys.sys_contact up on a.updatedby_id = up.cont_id LEFT JOIN dboa.oa_appr_process p ON a.appr_proc_id = p.appr_proc_id where a.purcapply_id = 3572 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054159164428711 -- 25-05-31 16:25:38[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3572 select * from dbpurc.purc_apply_product where purcapply_id = 3572 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036039352416992 -- 25-05-31 16:25:38[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3572 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01747989654541 -- 25-05-31 16:25:39[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015841960906982 -- 25-05-31 16:25:40[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024248838424683 -- 25-05-31 16:25:40[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3572 select a.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(a.purch_apply_date,'%Y-%m-%d') apply_date,1 appr_type_id,p.appr_proc_name, date_format(a.purch_end_date,'%Y-%m-%d') purch_end_date from dbpurc.purc_apply a LEFT JOIN dbsys.sys_contact c ON a.purch_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON a.purch_department_id = org.org_id LEFT JOIN dbsys.sys_contact cr on a.createdby_id = cr.cont_id LEFT JOIN dbsys.sys_contact up on a.updatedby_id = up.cont_id LEFT JOIN dboa.oa_appr_process p ON a.appr_proc_id = p.appr_proc_id where a.purcapply_id = 3572 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030181407928467 -- 25-05-31 16:25:40[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3572 select * from dbpurc.purc_apply_product where purcapply_id = 3572 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030379295349121 -- 25-05-31 16:25:40[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3572 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028065919876099 -- 25-05-31 16:26:16[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031280517578125 -- 25-05-31 16:26:16[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036559104919434 -- 25-05-31 16:26:16[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035459995269775 -- 25-05-31 16:26:16[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034739971160889 -- 25-05-31 16:26:16[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021543025970459 -- 25-05-31 16:26:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040299892425537 -- 25-05-31 16:26:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041179656982422 -- 25-05-31 16:26:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039329528808594 -- 25-05-31 16:26:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039381980895996 -- 25-05-31 16:26:17[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016979932785034 -- 25-05-31 16:26:20[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037038326263428 -- 25-05-31 16:26:20[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038559436798096 -- 25-05-31 16:26:20[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037078857421875 -- 25-05-31 16:26:20[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036399364471436 -- 25-05-31 16:26:20[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024999856948853 -- 25-05-31 16:31:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040309429168701 -- 25-05-31 16:31:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041530132293701 -- 25-05-31 16:31:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039529800415039 -- 25-05-31 16:31:00[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039308071136475 -- 25-05-31 16:31:00[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026749849319458 -- 25-05-31 16:31:01[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 SELECT p.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc,of.costAlloc_type_id, apply.cont_name apply_cont,org.org_name department,receiving.cust_disp_name receiving_unit,13 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account,IFNULL(of.otherfee_id,1) otherfee_id FROM dboa.oa_payment p LEFT JOIN dboa.oa_appr_process o ON p.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON p.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON p.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON p.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON p.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id LEFT JOIN dbthird.thd_otherfee of ON p.payment_id = of.oa_payment_id WHERE p.payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004284143447876 -- 25-05-31 16:31:01[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043079853057861 -- 25-05-31 16:31:01[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041158199310303 -- 25-05-31 16:31:01[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040950775146484 -- 25-05-31 16:31:01[李玲-1286] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1286 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017582893371582 -- 25-05-31 16:31:04[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035581588745117 -- 25-05-31 16:31:04[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040688514709473 -- 25-05-31 16:31:04[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035190582275391 -- 25-05-31 16:31:04[李玲-1286] -- /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 = 1286 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035240650177002 -- 25-05-31 16:31:04[李玲-1286] -- /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= 1286 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018236875534058 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 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 = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039989948272705 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 select payment_id from dbthird.thd_payment where oa_payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036919116973877 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 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 = 114925 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040080547332764 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 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 = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035860538482666 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037109851837158 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 select * from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036399364471436 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035021305084229 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003507137298584 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035238265991211 -- 25-05-31 16:35:44[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22}&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017539978027344 -- 25-05-31 16:35:49[朱玲-297] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020890951156616 -- 25-05-31 16:35:50[朱玲-297] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 297 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017928123474121 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 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 = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035271644592285 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select payment_id from dbthird.thd_payment where oa_payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035989284515381 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 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 = 114925 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040938854217529 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 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 = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034871101379395 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023273944854736 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select * from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035629272460938 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034239292144775 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033938884735107 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034379959106445 -- 25-05-31 16:40:23[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018133878707886 -- 25-05-31 16:40:33[李晓瑜-298] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019906997680664 -- 25-05-31 16:40:33[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019363164901733 -- 25-05-31 16:58:00 -- /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.003864049911499 -- 25-05-31 16:58:00 -- /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.0043501853942871 -- 25-05-31 16:58:00 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040690898895264 -- 25-05-31 16:58:00[高祥-33] -- /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= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.035063982009888 -- 25-05-31 16:58:00[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019819021224976 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 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 = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033948421478271 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select payment_id from dbthird.thd_payment where oa_payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003464937210083 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 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 = 114925 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040957927703857 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 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 = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032458305358887 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029039859771729 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select * from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034711360931396 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00325608253479 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032389163970947 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032980442047119 -- 25-05-31 16:58:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019820928573608 -- 25-05-31 16:58:02[高祥-33] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030289888381958 -- 25-05-31 16:58:03[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017163991928101 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 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 = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033788681030273 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select payment_id from dbthird.thd_payment where oa_payment_id = 96406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034639835357666 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 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 = 114925 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038101673126221 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 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 = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00331711769104 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034379959106445 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select * from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033769607543945 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4716998 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032339096069336 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032310485839844 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033090114593506 -- 25-05-31 17:00:20[李晓瑜-298] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%2296406%22%7D&event=edit_payment&payment_id=96406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016239881515503 -- 25-05-31 19:34:59 -- /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.0032610893249512 -- 25-05-31 19:34:59 -- /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.0037469863891602 -- 25-05-31 19:34:59 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id 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.003507137298584 -- 25-05-31 19:34:59[吴凌刚-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.017861843109131 -- 25-05-31 19:35:00[吴凌刚-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.018259048461914 -- 25-05-31 19:35:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36336 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 = 36336 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036511421203613 -- 25-05-31 19:35:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36336 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36336 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042660236358643 -- 25-05-31 19:35:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36336 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 = 4719617 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003464937210083 -- 25-05-31 19:35:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36336 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037298202514648 -- 25-05-31 19:35:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36336 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4719617 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035030841827393 -- 25-05-31 19:35:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36336 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019289970397949 -- 25-05-31 19:35:06[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36336 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020190954208374 -- 25-05-31 19:35:06[吴凌刚-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.017827033996582 -- 25-05-31 19:35:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 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 = 36335 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035769939422607 -- 25-05-31 19:35:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36335 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040090084075928 -- 25-05-31 19:35:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 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 = 4719609 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034050941467285 -- 25-05-31 19:35:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00360107421875 -- 25-05-31 19:35:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4719609 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003413200378418 -- 25-05-31 19:35:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018132925033569 -- 25-05-31 19:35:16[吴凌刚-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.01643180847168 -- 25-05-31 19:35:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 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 = 36335 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031988620758057 -- 25-05-31 19:35:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36335 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032110214233398 -- 25-05-31 19:35:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 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 = 4719609 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031781196594238 -- 25-05-31 19:35:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032341480255127 -- 25-05-31 19:35:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4719609 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031900405883789 -- 25-05-31 19:35:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36335 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029640913009644 -- 25-05-31 19:35:19[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36335 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018026113510132 -- 25-05-31 19:35:20[吴凌刚-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.034632921218872 -- 25-05-31 19:35:20[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36334 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 = 36334 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037779808044434 -- 25-05-31 19:35:20[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36334 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36334 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041830539703369 -- 25-05-31 19:35:20[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36334 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 = 4719608 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036017894744873 -- 25-05-31 19:35:20[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36334 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037949085235596 -- 25-05-31 19:35:20[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36334 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4719608 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036020278930664 -- 25-05-31 19:35:21[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36334 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019091129302979 -- 25-05-31 19:35:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36334 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021227836608887 -- 25-05-31 19:35:26[吴凌刚-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.017967939376831 -- 25-05-31 19:48:25[吴凌刚-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.017976999282837 -- 25-05-31 19:48:26[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36338 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 = 36338 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003605842590332 -- 25-05-31 19:48:26[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36338 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36338 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040991306304932 -- 25-05-31 19:48:26[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36338 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 = 4719624 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003425121307373 -- 25-05-31 19:48:26[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36338 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036759376525879 -- 25-05-31 19:48:26[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36338 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4719624 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034298896789551 -- 25-05-31 19:48:26[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36338 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02442193031311 -- 25-05-31 19:48:30[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36338 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016669988632202 -- 25-05-31 19:48:31[吴凌刚-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.017853021621704 -- 25-05-31 19:48:32[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36337 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 = 36337 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035338401794434 -- 25-05-31 19:48:32[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36337 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 36337 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039808750152588 -- 25-05-31 19:48:32[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36337 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 = 4719619 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 25-05-31 19:48:32[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36337 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003587007522583 -- 25-05-31 19:48:32[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36337 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4719619 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034019947052002 -- 25-05-31 19:48:32[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=36337 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019329071044922 -- 25-05-31 19:48:34[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=36337 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020528793334961 -- 25-05-31 19:48:35[吴凌刚-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.021845102310181 -- 25-05-31 21:14:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 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 = 61980 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033390522003174 -- 25-05-31 21:14:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61980 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034208297729492 -- 25-05-31 21:14:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 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 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 = 61980 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032439231872559 -- 25-05-31 21:14:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003216028213501 -- 25-05-31 21:14:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033669471740723 -- 25-05-31 21:14:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4715872 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031700134277344 -- 25-05-31 21:14:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261980%22}&event=edit_extrafareApply&extrafareApply_id=61980 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018721103668213 -- 25-05-31 21:14:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 61936 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034959316253662 -- 25-05-31 21:14:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031571388244629 -- 25-05-31 21:14:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 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 = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028998851776123 -- 25-05-31 21:14:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002910852432251 -- 25-05-31 21:14:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030500888824463 -- 25-05-31 21:14:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4712702 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028789043426514 -- 25-05-31 21:14:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028517007827759 -- 25-05-31 21:15:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 61933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038659572601318 -- 25-05-31 21:15:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039489269256592 -- 25-05-31 21:15:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 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 = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037739276885986 -- 25-05-31 21:15:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037050247192383 -- 25-05-31 21:15:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00388503074646 -- 25-05-31 21:15:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711919 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036959648132324 -- 25-05-31 21:15:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021723985671997 -- 25-05-31 21:16:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 = 61927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043399333953857 -- 25-05-31 21:16:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004364013671875 -- 25-05-31 21:16:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 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 = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037951469421387 -- 25-05-31 21:16:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037829875946045 -- 25-05-31 21:16:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039291381835938 -- 25-05-31 21:16:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003748893737793 -- 25-05-31 21:16:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018984794616699 -- 25-05-31 21:16:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 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 = 61877 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004101037979126 -- 25-05-31 21:16:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61877 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041651725769043 -- 25-05-31 21:16:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 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 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 = 61877 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035731792449951 -- 25-05-31 21:16:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036001205444336 -- 25-05-31 21:16:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037498474121094 -- 25-05-31 21:16:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4707763 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035908222198486 -- 25-05-31 21:16:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261877%22}&event=edit_extrafareApply&extrafareApply_id=61877 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016812801361084 -- 25-05-31 21:17:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 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 = 61876 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033900737762451 -- 25-05-31 21:17:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61876 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034720897674561 -- 25-05-31 21:17:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 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 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 = 61876 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031931400299072 -- 25-05-31 21:17:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032250881195068 -- 25-05-31 21:17:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033910274505615 -- 25-05-31 21:17:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4707759 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032069683074951 -- 25-05-31 21:17:05[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261876%22}&event=edit_extrafareApply&extrafareApply_id=61876 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018821954727173 -- 25-05-31 21:17:13[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261724%22}&event=edit_extrafareApply&extrafareApply_id=61724 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 61724 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035550594329834 -- 25-05-31 21:17:13[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261724%22}&event=edit_extrafareApply&extrafareApply_id=61724 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035839080810547 -- 25-05-31 21:17:13[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261724%22}&event=edit_extrafareApply&extrafareApply_id=61724 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037930011749268 -- 25-05-31 21:17:13[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261724%22}&event=edit_extrafareApply&extrafareApply_id=61724 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4687415 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036289691925049 -- 25-05-31 21:17:13[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261724%22}&event=edit_extrafareApply&extrafareApply_id=61724 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.040776968002319 -- 25-05-31 21:17:13[张昭霞-2107] -- /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 =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%鹏海达%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020717859268188 -- 25-05-31 21:17:13[张昭霞-2107] -- /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 = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%张昭霞%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02457594871521 -- 25-05-31 21:17:13[张昭霞-2107] -- /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 = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019914150238037 -- 25-05-31 22:36:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 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 = 61869 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045990943908691 -- 25-05-31 22:36:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61869 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045449733734131 -- 25-05-31 22:36:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 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 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 = 61869 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039889812469482 -- 25-05-31 22:36:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003925085067749 -- 25-05-31 22:36:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040519237518311 -- 25-05-31 22:36:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4706695 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003903865814209 -- 25-05-31 22:36:19[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261869%22}&event=edit_extrafareApply&extrafareApply_id=61869 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015239953994751 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 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 = 61874 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034499168395996 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61874 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035660266876221 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 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 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 = 61874 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029919147491455 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029799938201904 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031070709228516 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4707277 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029242038726807 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029158592224121 -- 25-05-31 22:37:03[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261874%22}&event=edit_extrafareApply&extrafareApply_id=61874 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024317026138306 -- 25-05-31 22:37:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 = 61927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040321350097656 -- 25-05-31 22:37:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004072904586792 -- 25-05-31 22:37:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 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 = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033681392669678 -- 25-05-31 22:37:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003364086151123 -- 25-05-31 22:37:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035209655761719 -- 25-05-31 22:37:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033400058746338 -- 25-05-31 22:37:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019792079925537 -- 25-05-31 22:38:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 = 61927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038948059082031 -- 25-05-31 22:38:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039069652557373 -- 25-05-31 22:38:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 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 = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038712024688721 -- 25-05-31 22:38:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038928985595703 -- 25-05-31 22:38:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039341449737549 -- 25-05-31 22:38:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038728713989258 -- 25-05-31 22:38:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021808862686157 -- 25-05-31 22:38:18[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 61933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046770572662354 -- 25-05-31 22:38:18[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004767894744873 -- 25-05-31 22:38:18[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 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 = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041370391845703 -- 25-05-31 22:38:18[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041790008544922 -- 25-05-31 22:38:18[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004317045211792 -- 25-05-31 22:38:18[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711919 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041460990905762 -- 25-05-31 22:38:18[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023907899856567 -- 25-05-31 22:38:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 61936 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030779838562012 -- 25-05-31 22:38:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036170482635498 -- 25-05-31 22:38:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 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 = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029280185699463 -- 25-05-31 22:38:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00295090675354 -- 25-05-31 22:38:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031020641326904 -- 25-05-31 22:38:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4712702 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029168128967285 -- 25-05-31 22:38:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022045135498047 -- 25-05-31 22:38:42[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018693923950195 -- 25-05-31 22:38:42[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024245977401733 -- 25-05-31 22:38:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 = 61936 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036458969116211 -- 25-05-31 22:38:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042209625244141 -- 25-05-31 22:38:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 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 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 = 61936 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 25-05-31 22:38:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036518573760986 -- 25-05-31 22:38:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036759376525879 -- 25-05-31 22:38:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4712702 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036098957061768 -- 25-05-31 22:38:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261936%22}&event=edit_extrafareApply&extrafareApply_id=61936 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016281127929688 -- 25-05-31 22:38:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 61933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031111240386963 -- 25-05-31 22:38:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033600330352783 -- 25-05-31 22:38:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 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 = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031030178070068 -- 25-05-31 22:38:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031399726867676 -- 25-05-31 22:38:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032899379730225 -- 25-05-31 22:38:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711919 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031228065490723 -- 25-05-31 22:38:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026414155960083 -- 25-05-31 22:38:48[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026583909988403 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021370887756348 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 = 61933 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041258335113525 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044200420379639 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 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 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 = 61933 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041189193725586 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041229724884033 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041379928588867 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711919 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040879249572754 -- 25-05-31 22:38:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261933%22}&event=edit_extrafareApply&extrafareApply_id=61933 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017158985137939 -- 25-05-31 22:38:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 = 61927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032680034637451 -- 25-05-31 22:38:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039470195770264 -- 25-05-31 22:38:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 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 = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032839775085449 -- 25-05-31 22:38:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033118724822998 -- 25-05-31 22:38:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034890174865723 -- 25-05-31 22:38:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032968521118164 -- 25-05-31 22:38:52[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020910978317261 -- 25-05-31 22:38:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016615152359009 -- 25-05-31 22:38:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026028156280518 -- 25-05-31 22:38:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 = 61927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031249523162842 -- 25-05-31 22:38:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033750534057617 -- 25-05-31 22:38:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 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 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 = 61927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031249523162842 -- 25-05-31 22:38:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003140926361084 -- 25-05-31 22:38:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031599998474121 -- 25-05-31 22:38:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4711816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031120777130127 -- 25-05-31 22:38:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2261927%22}&event=edit_extrafareApply&extrafareApply_id=61927 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021281003952026 -- 25-05-31 23:50:18[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038509368896484 -- 25-05-31 23:50:18[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.0037519931793213 -- 25-05-31 23:50:18[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039501190185547 -- 25-05-31 23:50:18[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 (1416888) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041038990020752 -- 25-05-31 23:50:18[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022503137588501 -- 25-05-31 23:50:18[彭宗平-508] -- /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.026516914367676 -- 25-05-31 23:50:19[彭宗平-508] -- /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.019206047058105 -- 25-05-31 23:50:19[彭宗平-508] -- /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.029275894165039 -- 25-05-31 23:50:23[彭宗平-508] -- /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.016752958297729 -- 25-05-31 23:50:34[彭宗平-508] -- /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.032622098922729 -- 25-05-31 23:50:42[彭宗平-508] -- /buz/oa/index.php/oamgmt/get_extrafare_item select extrafare_name,extrafare_id from dboa.oa_extrafare where acct_id = 15 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018409967422485 -- 25-05-31 23:52:12[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037050247192383 -- 25-05-31 23:52:12[彭宗平-508] -- /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 (1416888) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035641193389893 -- 25-05-31 23:52:12[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017868995666504 -- 25-05-31 23:52:13[彭宗平-508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034899711608887 -- 25-05-31 23:52:13[彭宗平-508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015376091003418 -- 25-05-31 23:52:14[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029969215393066 -- 25-05-31 23:52:14[彭宗平-508] -- /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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019810199737549 -- 25-05-31 23:52:15[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01862907409668 -- 25-05-31 23:55:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036890506744385 -- 25-05-31 23:55:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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.0035889148712158 -- 25-05-31 23:55:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003777027130127 -- 25-05-31 23:55:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%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 (1416888) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030133008956909 -- 25-05-31 23:55:24[彭宗平-508] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1416888&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D307%26ship_city%3D%E6%B5%8E%E5%8D%97%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024224996566772 -- 25-05-31 23:55:24[彭宗平-508] -- /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.018538951873779 -- 25-05-31 23:55:25[彭宗平-508] -- /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.018903970718384 -- 25-05-31 23:55:25[彭宗平-508] -- /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 ------------------------------------------------------------------------------------------------------------------------------------------------------