Time: 0.011259078979492 -- 26-03-29 00:03:36 -- /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.0016651153564453 -- 26-03-29 00:03:36 -- /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.0025618076324463 -- 26-03-29 00:03:36 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GuoRongBo' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001816987991333 -- 26-03-29 00:03:36[郭荣波-35] -- /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.0092010498046875 -- 26-03-29 00:03:36[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089170932769775 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 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 = 124309 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021510124206543 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 select payment_id from dbthird.thd_payment where oa_payment_id = 124309 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017428398132324 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 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 = 139311 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021219253540039 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 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 = 6286838 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015449523925781 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017030239105225 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 select * from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016539096832275 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286838 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015609264373779 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015380382537842 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015630722045898 -- 26-03-29 00:03:38[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124309 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018699169158936 -- 26-03-29 00:03:39[郭荣波-35] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124309 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017545938491821 -- 26-03-29 00:03:39[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008620023727417 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 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 = 124307 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019991397857666 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 select payment_id from dbthird.thd_payment where oa_payment_id = 124307 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020201206207275 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 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 = 139309 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001978874206543 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 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 = 6286802 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014750957489014 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023370981216431 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 select * from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001737117767334 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286802 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00148606300354 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014770030975342 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015120506286621 -- 26-03-29 00:03:40[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124307 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012730121612549 -- 26-03-29 00:03:41[郭荣波-35] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124307 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010630130767822 -- 26-03-29 00:03:42[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075728893280029 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 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 = 124306 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017509460449219 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 select payment_id from dbthird.thd_payment where oa_payment_id = 124306 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018019676208496 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 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 = 139308 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017650127410889 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 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 = 6286788 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012679100036621 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016376972198486 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 select * from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014219284057617 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286788 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001288890838623 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012710094451904 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001317024230957 -- 26-03-29 00:03:43[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124306 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076949596405029 -- 26-03-29 00:03:44[郭荣波-35] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124306 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015682935714722 -- 26-03-29 00:03:44[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087521076202393 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 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 = 124304 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021569728851318 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 select payment_id from dbthird.thd_payment where oa_payment_id = 124304 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021448135375977 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 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 = 139306 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021100044250488 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 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 = 6286779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00160813331604 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016441345214844 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 select * from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017609596252441 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286779 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016138553619385 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016050338745117 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016391277313232 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078251361846924 -- 26-03-29 00:03:46[郭荣波-35] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021385908126831 -- 26-03-29 00:03:47[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082828998565674 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 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 = 124302 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016419887542725 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 select payment_id from dbthird.thd_payment where oa_payment_id = 124302 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017101764678955 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 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 = 139304 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016429424285889 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 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 = 6286722 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015048980712891 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016792058944702 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 select * from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017788410186768 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286722 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015161037445068 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015089511871338 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015079975128174 -- 26-03-29 00:03:48[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124302 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007194995880127 -- 26-03-29 00:03:49[郭荣波-35] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124302 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073668956756592 -- 26-03-29 00:03:49[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018354892730713 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 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 = 124301 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018219947814941 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 select payment_id from dbthird.thd_payment where oa_payment_id = 124301 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018210411071777 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 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 = 139303 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001788854598999 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 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 = 6286716 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012860298156738 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013674020767212 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 select * from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014388561248779 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286716 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012791156768799 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001262903213501 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012979507446289 -- 26-03-29 00:03:50[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077900886535645 -- 26-03-29 00:03:51[郭荣波-35] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074658393859863 -- 26-03-29 00:03:52[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081439018249512 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 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 = 124282 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016310214996338 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 select payment_id from dbthird.thd_payment where oa_payment_id = 124282 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016679763793945 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 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 = 139284 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001633882522583 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 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 = 6286204 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014960765838623 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015270709991455 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 select * from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016250610351562 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286204 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014858245849609 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014767646789551 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014989376068115 -- 26-03-29 00:03:53[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124282 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077049732208252 -- 26-03-29 00:03:54[郭荣波-35] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124282 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014539003372192 -- 26-03-29 00:03:55[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083041191101074 -- 26-03-29 00:10:33[刘永飞-2475] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087368488311768 -- 26-03-29 00:11:16[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017271041870117 -- 26-03-29 00:11:16[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033159255981445 -- 26-03-29 00:11:16[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2475,updatedby_id = 2475 where extrafareApply_id = 74695 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013293981552124 -- 26-03-29 00:15:13[刘永飞-2475] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018256902694702 -- 26-03-29 00:16:00[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016448497772217 -- 26-03-29 00:16:00[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036752223968506 -- 26-03-29 00:16:01[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2475,updatedby_id = 2475 where extrafareApply_id = 74696 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075540542602539 -- 26-03-29 00:16:42[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00148606300354 -- 26-03-29 00:16:43[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029869079589844 -- 26-03-29 00:16:43[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2475,updatedby_id = 2475 where extrafareApply_id = 74696 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028259754180908 -- 26-03-29 00:16:43[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2475,updatedby_id = 2475 where otherfee_id = 7997 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018237113952637 -- 26-03-29 00:16:46[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016419887542725 -- 26-03-29 00:16:46[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037848949432373 -- 26-03-29 00:16:46[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2475,updatedby_id = 2475 where extrafareApply_id = 74696 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034081935882568 -- 26-03-29 00:16:46[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2475,updatedby_id = 2475 where otherfee_id = 7997 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008713960647583 -- 26-03-29 00:17:35[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017180442810059 -- 26-03-29 00:17:35[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031449794769287 -- 26-03-29 00:17:35[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2475,updatedby_id = 2475 where extrafareApply_id = 74696 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038619041442871 -- 26-03-29 00:17:35[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2475,updatedby_id = 2475 where otherfee_id = 7997 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013214111328125 -- 26-03-29 00:18:06[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018398761749268 -- 26-03-29 00:18:06[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036230087280273 -- 26-03-29 00:18:06[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2475,updatedby_id = 2475 where extrafareApply_id = 74696 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032238960266113 -- 26-03-29 00:18:06[刘永飞-2475] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2475,updatedby_id = 2475 where otherfee_id = 7997 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084018707275391 -- 26-03-29 00:22:53[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016710758209229 -- 26-03-29 00:22:53[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076301097869873 -- 26-03-29 00:23:24[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014700889587402 -- 26-03-29 00:23:24[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009044885635376 -- 26-03-29 00:23:49[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017709732055664 -- 26-03-29 00:23:49[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02143406867981 -- 26-03-29 00:24:04[刘永飞-2475] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 and e.extrafare_name like '%停车费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017745018005371 -- 26-03-29 00:24:22[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016419887542725 -- 26-03-29 00:24:22[刘永飞-2475] -- /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 = 2475 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013130187988281 -- 26-03-29 08:10:07[关云-169] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 169 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015266180038452 -- 26-03-29 08:55:11 -- /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.0096969604492188 -- 26-03-29 08:55:12[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028555154800415 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 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 = 124406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021920204162598 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 select payment_id from dbthird.thd_payment where oa_payment_id = 124406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002208948135376 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 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 = 139341 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038399696350098 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 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 = 6288863 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017030239105225 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019240379333496 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018298625946045 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6288863 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016980171203613 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016961097717285 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017049312591553 -- 26-03-29 08:55:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010141849517822 -- 26-03-29 08:55:15[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069980621337891 -- 26-03-29 08:55:16[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016079902648926 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 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 = 124291 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017311573028564 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 select payment_id from dbthird.thd_payment where oa_payment_id = 124291 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017809867858887 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 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 = 139293 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023019313812256 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 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 = 6286547 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016028881072998 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016699075698853 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017428398132324 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6286547 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016078948974609 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015799999237061 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016398429870605 -- 26-03-29 08:55:17[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=124291 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022414922714233 -- 26-03-29 08:55:18[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=124291 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019792079925537 -- 26-03-29 08:55:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008469820022583 -- 26-03-29 09:13:38 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015878677368164 -- 26-03-29 09:13:38 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024991035461426 -- 26-03-29 09:13:38 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00177001953125 -- 26-03-29 09:13:38[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01641583442688 -- 26-03-29 09:13:39[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010200023651123 -- 26-03-29 09:29:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010138034820557 -- 26-03-29 11:14:40[王杰-2508] -- /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 = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019750595092773 -- 26-03-29 11:14:40[王杰-2508] -- /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 = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035300254821777 -- 26-03-29 11:14:40[王杰-2508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2508,updatedby_id = 2508 where extrafareApply_id = 74697 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013006210327148 -- 26-03-29 11:14:43[王杰-2508] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017633199691772 -- 26-03-29 11:14:55[王杰-2508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014340877532959 -- 26-03-29 11:14:55[王杰-2508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00856614112854 -- 26-03-29 11:15:24[王杰-2508] -- /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 = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016660690307617 -- 26-03-29 11:15:24[王杰-2508] -- /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 = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030341148376465 -- 26-03-29 11:15:24[王杰-2508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2508,updatedby_id = 2508 where extrafareApply_id = 74697 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037028789520264 -- 26-03-29 11:15:24[王杰-2508] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2508,updatedby_id = 2508 where otherfee_id = 8003 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022963047027588 -- 26-03-29 11:15:24[王杰-2508] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076138973236084 -- 26-03-29 11:15:24[王杰-2508] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082409381866455 -- 26-03-29 11:15:27[王杰-2508] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2508 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085430145263672 -- 26-03-29 11:16:06 -- /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.0097188949584961 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 74697 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016288757324219 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 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 = 74697 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018818378448486 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 74697 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017111301422119 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 74697 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014979839324951 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014591217041016 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015969276428223 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6289282 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014450550079346 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014128684997559 -- 26-03-29 11:20:09[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2274697%22}&event=edit_extrafareApply&extrafareApply_id=74697 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076160430908203 -- 26-03-29 11:20:14[胡元元-2384] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=74697 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070531368255615 -- 26-03-29 11:20:15[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021781921386719 -- 26-03-29 12:53:49 -- /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.0016579627990723 -- 26-03-29 12:53:49 -- /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.0021779537200928 -- 26-03-29 12:53:49 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiuXiaoJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017762184143066 -- 26-03-29 12:53:49[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016672849655151 -- 26-03-29 12:53:50[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015755891799927 -- 26-03-29 12:53:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 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 = 46796 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022320747375488 -- 26-03-29 12:53:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022170543670654 -- 26-03-29 12:53:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 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 = 6288879 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016100406646729 -- 26-03-29 12:53:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017499923706055 -- 26-03-29 12:53:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6288879 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016148090362549 -- 26-03-29 12:53:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014982938766479 -- 26-03-29 12:53:58[刘晓进-2544] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=46796 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011666059494019 -- 26-03-29 12:53:59[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010171175003052 -- 26-03-29 12:54:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 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 = 46796 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019240379333496 -- 26-03-29 12:54:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019240379333496 -- 26-03-29 12:54:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 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 = 6288879 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001924991607666 -- 26-03-29 12:54:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001945972442627 -- 26-03-29 12:54:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6288879 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019040107727051 -- 26-03-29 12:54:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46796 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013544082641602 -- 26-03-29 12:54:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089390277862549 -- 26-03-29 12:54:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 46760 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018019676208496 -- 26-03-29 12:54:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46760 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018219947814941 -- 26-03-29 12:54:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012969970703125 -- 26-03-29 12:54:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014598369598389 -- 26-03-29 12:54:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012919902801514 -- 26-03-29 12:54:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020382881164551 -- 26-03-29 12:55:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022580623626709 -- 26-03-29 12:55:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020909309387207 -- 26-03-29 12:55:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030078887939453 -- 26-03-29 12:55:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025639533996582 -- 26-03-29 12:55:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014204025268555 -- 26-03-29 12:55:37[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016569137573242 -- 26-03-29 12:55:38[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 46760 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020639896392822 -- 26-03-29 12:55:38[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46760 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020499229431152 -- 26-03-29 12:55:38[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00154709815979 -- 26-03-29 12:55:38[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016961097717285 -- 26-03-29 12:55:38[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015649795532227 -- 26-03-29 12:55:38[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081169605255127 -- 26-03-29 12:56:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085771083831787 -- 26-03-29 12:56:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 46760 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021090507507324 -- 26-03-29 12:56:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46760 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020711421966553 -- 26-03-29 12:56:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015699863433838 -- 26-03-29 12:56:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017430782318115 -- 26-03-29 12:56:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015490055084229 -- 26-03-29 12:56:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016875028610229 -- 26-03-29 12:56:17[刘晓进-2544] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070798397064209 -- 26-03-29 12:56:18[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083720684051514 -- 26-03-29 12:56:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 46760 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015959739685059 -- 26-03-29 12:56:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46760 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015718936920166 -- 26-03-29 12:56:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 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 = 6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015490055084229 -- 26-03-29 12:56:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015900135040283 -- 26-03-29 12:56:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6283109 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015652179718018 -- 26-03-29 12:56:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46760 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018909931182861 -- 26-03-29 12:56:28[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092470645904541 -- 26-03-29 18:51:12 -- /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.0017437934875488 -- 26-03-29 18:51:12 -- /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.0022799968719482 -- 26-03-29 18:51:12 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019569396972656 -- 26-03-29 18:51:12[吴凌刚-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.020228862762451 -- 26-03-29 18:51:17[吴凌刚-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012992143630981 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 74698 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017740726470947 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 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 = 74698 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021629333496094 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 74698 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018379688262939 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 74698 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015478134155273 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015928745269775 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017349720001221 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6289320 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015671253204346 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015599727630615 -- 26-03-29 18:51:18[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021136999130249 -- 26-03-29 18:51:21[吴凌刚-279] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=74698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013005971908569 -- 26-03-29 18:51:21[吴凌刚-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017989873886108 -- 26-03-29 20:12:29[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018188953399658 -- 26-03-29 20:12:29[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033671855926514 -- 26-03-29 20:12:29[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74704 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012064218521118 -- 26-03-29 20:12:38[吴海红-2505] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070619583129883 -- 26-03-29 20:12:52[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013279914855957 -- 26-03-29 20:12:52[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096218585968018 -- 26-03-29 20:13:14[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018658638000488 -- 26-03-29 20:13:14[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031909942626953 -- 26-03-29 20:13:14[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74704 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00301194190979 -- 26-03-29 20:13:14[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 8007 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079760551452637 -- 26-03-29 20:13:16[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001446008682251 -- 26-03-29 20:13:16[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027010440826416 -- 26-03-29 20:13:16[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74704 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028800964355469 -- 26-03-29 20:13:16[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 8007 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017704963684082 -- 26-03-29 20:13:16[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013488054275513 -- 26-03-29 20:13:16[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086069107055664 -- 26-03-29 20:13:24[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086150169372559 -- 26-03-29 20:16:53[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016601085662842 -- 26-03-29 20:16:53[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004127025604248 -- 26-03-29 20:16:53[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74705 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01679515838623 -- 26-03-29 20:17:07[吴海红-2505] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017359972000122 -- 26-03-29 20:17:21[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014848709106445 -- 26-03-29 20:17:21[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020903825759888 -- 26-03-29 20:18:09[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001317024230957 -- 26-03-29 20:18:09[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026090145111084 -- 26-03-29 20:18:09[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74705 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022909641265869 -- 26-03-29 20:18:09[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 8008 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087339878082275 -- 26-03-29 20:18:12[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016591548919678 -- 26-03-29 20:18:12[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029840469360352 -- 26-03-29 20:18:12[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74705 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026359558105469 -- 26-03-29 20:18:12[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 8008 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013412952423096 -- 26-03-29 20:18:12[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084841251373291 -- 26-03-29 20:18:12[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083091259002686 -- 26-03-29 20:18:14[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086450576782227 -- 26-03-29 20:19:48[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016419887542725 -- 26-03-29 20:19:48[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029060840606689 -- 26-03-29 20:19:49[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74706 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009998083114624 -- 26-03-29 20:19:53[吴海红-2505] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093441009521484 -- 26-03-29 20:20:10[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017859935760498 -- 26-03-29 20:20:10[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074260234832764 -- 26-03-29 20:20:28[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014350414276123 -- 26-03-29 20:20:28[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026350021362305 -- 26-03-29 20:20:28[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2505,updatedby_id = 2505 where extrafareApply_id = 74706 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027740001678467 -- 26-03-29 20:20:28[吴海红-2505] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2505,updatedby_id = 2505 where otherfee_id = 8009 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095810890197754 -- 26-03-29 20:20:28[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012579917907715 -- 26-03-29 20:20:28[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021065950393677 -- 26-03-29 20:20:30[吴海红-2505] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2505 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------