Time: 0.020596981048584 -- 25-05-03 11:29:28 -- /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.0041878223419189 -- 25-05-03 11:29:28 -- /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.0050060749053955 -- 25-05-03 11:29:28 -- /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='WangXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043058395385742 -- 25-05-03 11:29:28[王翔-928] -- /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.015703916549683 -- 25-05-03 11:29:29[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021093130111694 -- 25-05-03 12:28:34[李晓庆-370] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 370 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017810106277466 -- 25-05-03 12:28:34[李晓庆-370] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 370 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018661022186279 -- 25-05-03 12:28:36[李晓庆-370] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 370 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017471075057983 -- 25-05-03 21:02:47[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 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 = 35270 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057659149169922 -- 25-05-03 21:02:47[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35270 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040538311004639 -- 25-05-03 21:02:47[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 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 = 4567842 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033309459686279 -- 25-05-03 21:02:47[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034110546112061 -- 25-05-03 21:02:47[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 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 = 4567842 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032191276550293 -- 25-05-03 21:02:47[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02737283706665 -- 25-05-03 21:03:13[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 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 = 35270 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036239624023438 -- 25-05-03 21:03:13[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 35270 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036690235137939 -- 25-05-03 21:03:13[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 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 = 4567842 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036039352416992 -- 25-05-03 21:03:13[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036320686340332 -- 25-05-03 21:03:13[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 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 = 4567842 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036139488220215 -- 25-05-03 21:03:13[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2235270%22}&event=edit_fareApply&fareApply_id=35270 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020800113677979 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 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 = 93177 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041348934173584 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 select payment_id from dbthird.thd_payment where oa_payment_id = 93177 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004155158996582 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 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 = 4567832 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003680944442749 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038421154022217 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 select * from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038468837738037 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 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 = 4567832 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003695011138916 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037188529968262 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037438869476318 -- 25-05-03 21:03:23[周少云-2059] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_payment%22,%22payment_id%22:%2293177%22}&event=edit_payment&payment_id=93177 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2059 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015143871307373 -- 25-05-03 22:08:04[陈景才-844] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 844 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017720937728882 -- 25-05-03 22:08:04[陈景才-844] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 844 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018517017364502 -- 25-05-03 22:08:06[陈景才-844] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 844 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------