Time: 0.018166065216064 -- 25-07-20 07:58:34[蔡江波-625] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 625 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028578042984009 -- 25-07-20 07:58:34[蔡江波-625] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 625 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018388986587524 -- 25-07-20 07:58:36[蔡江波-625] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 625 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018835067749023 -- 25-07-20 09:55:09 -- /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.023838996887207 -- 25-07-20 09:55:09 -- /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.0036909580230713 -- 25-07-20 09:55:09 -- /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.0040361881256104 -- 25-07-20 09:55:09 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033810138702393 -- 25-07-20 09:55:09[张体海-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.026997804641724 -- 25-07-20 09:55:10[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028555870056152 -- 25-07-20 09:55:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37828 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 = 37828 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049281120300293 -- 25-07-20 09:55:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37828 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37828 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058071613311768 -- 25-07-20 09:55:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37828 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 = 4953197 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043060779571533 -- 25-07-20 09:55:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37828 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048630237579346 -- 25-07-20 09:55:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37828 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4953197 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042939186096191 -- 25-07-20 09:55:12[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37828 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0211501121521 -- 25-07-20 09:55:15[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022513866424561 -- 25-07-20 09:55:17[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028872013092041 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 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 = 101330 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039820671081543 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 select payment_id from dbthird.thd_payment where oa_payment_id = 101330 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051140785217285 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 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 = 119720 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039520263671875 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 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 = 4960154 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034248828887939 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035521984100342 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 select * from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035500526428223 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4960154 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034110546112061 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034019947052002 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034780502319336 -- 25-07-20 09:55:20[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101330 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022011041641235 -- 25-07-20 10:41:48 -- /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.0042688846588135 -- 25-07-20 10:41:48 -- /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.0051290988922119 -- 25-07-20 10:41:48 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044949054718018 -- 25-07-20 10:41:48[吴凌刚-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.021281957626343 -- 25-07-20 10:41:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027361154556274 -- 25-07-20 10:41:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 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 = 37878 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051798820495605 -- 25-07-20 10:41:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37878 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051929950714111 -- 25-07-20 10:41:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 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 = 4961072 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045959949493408 -- 25-07-20 10:41:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004796028137207 -- 25-07-20 10:41:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961072 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046210289001465 -- 25-07-20 10:41:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023561000823975 -- 25-07-20 10:42:10[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01836085319519 -- 25-07-20 10:42:11[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 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 = 37878 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035841464996338 -- 25-07-20 10:42:11[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37878 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035851001739502 -- 25-07-20 10:42:11[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 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 = 4961072 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035691261291504 -- 25-07-20 10:42:11[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036320686340332 -- 25-07-20 10:42:11[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961072 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035891532897949 -- 25-07-20 10:42:11[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019436836242676 -- 25-07-20 10:42:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=37878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016844987869263 -- 25-07-20 10:42:13[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026732206344604 -- 25-07-20 10:42:15[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 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 = 37878 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037939548492432 -- 25-07-20 10:42:15[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37878 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037910938262939 -- 25-07-20 10:42:15[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 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 = 4961072 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037648677825928 -- 25-07-20 10:42:15[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003831148147583 -- 25-07-20 10:42:15[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961072 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037569999694824 -- 25-07-20 10:42:15[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37878 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017436027526855 -- 25-07-20 10:42: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 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019745111465454 -- 25-07-20 11:25:24[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027212142944336 -- 25-07-20 11:25:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63730 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 = 63730 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048239231109619 -- 25-07-20 11:25:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63730 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63730 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048410892486572 -- 25-07-20 11:25:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63730 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 63730 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042910575866699 -- 25-07-20 11:25:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042998790740967 -- 25-07-20 11:25:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004472017288208 -- 25-07-20 11:25:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63730 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961407 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042979717254639 -- 25-07-20 11:25:25[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=63730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016962766647339 -- 25-07-20 11:25:42[吴凌刚-279] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=63730 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017471075057983 -- 25-07-20 11:25:42[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017051935195923 -- 25-07-20 13:16:27[廖茂玲-289] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019634008407593 -- 25-07-20 13:16:27[廖茂玲-289] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020416975021362 -- 25-07-20 13:16:31[廖茂玲-289] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031594038009644 -- 25-07-20 13:16:32[廖茂玲-289] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018385887145996 -- 25-07-20 13:16:33[廖茂玲-289] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025391817092896 -- 25-07-20 14:55:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 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 = 101353 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032980442047119 -- 25-07-20 14:55:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 select payment_id from dbthird.thd_payment where oa_payment_id = 101353 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 25-07-20 14:55:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 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 = 119739 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038020610809326 -- 25-07-20 14:55:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 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 = 4961558 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 25-07-20 14:55:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 25-07-20 14:55:19[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033140182495117 -- 25-07-20 14:55:19[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961558 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032079219818115 -- 25-07-20 14:55:19[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031888484954834 -- 25-07-20 14:55:19[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032508373260498 -- 25-07-20 14:55:19[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101353%22%7D&event=edit_payment&payment_id=101353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02211594581604 -- 25-07-20 14:55:20[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=101353 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01976490020752 -- 25-07-20 14:55:20[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019947052001953 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 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 = 101352 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034580230712891 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 select payment_id from dbthird.thd_payment where oa_payment_id = 101352 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035347938537598 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 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 = 119738 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039091110229492 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 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 = 4961557 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033421516418457 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034351348876953 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003493070602417 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961557 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033469200134277 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033490657806396 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033841133117676 -- 25-07-20 14:55:23[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101352 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018527030944824 -- 25-07-20 14:55:25[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=101352 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025284051895142 -- 25-07-20 14:55:25[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022078990936279 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 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 = 101354 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043349266052246 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 select payment_id from dbthird.thd_payment where oa_payment_id = 101354 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044808387756348 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 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 = 119740 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048158168792725 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 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 = 4961559 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042099952697754 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042860507965088 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043430328369141 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961559 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004209041595459 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042128562927246 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042240619659424 -- 25-07-20 14:55:27[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01650595664978 -- 25-07-20 14:55:29[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018825054168701 -- 25-07-20 14:55:29[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02147388458252 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 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 = 101357 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042541027069092 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select payment_id from dbthird.thd_payment where oa_payment_id = 101357 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043039321899414 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 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 = 119743 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046730041503906 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 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 = 4961567 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042030811309814 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043289661407471 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042738914489746 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961567 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041329860687256 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004119873046875 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041470527648926 -- 25-07-20 15:01:58[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018571853637695 -- 25-07-20 15:02:00[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028576135635376 -- 25-07-20 15:02:00[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017674922943115 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 101356 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033290386199951 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select payment_id from dbthird.thd_payment where oa_payment_id = 101356 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034160614013672 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 119742 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033597946166992 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 4961561 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032219886779785 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032920837402344 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034098625183105 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961561 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032138824462891 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032079219818115 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032520294189453 -- 25-07-20 15:02:03[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016998052597046 -- 25-07-20 15:02:05[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020231008529663 -- 25-07-20 15:02:05[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026599884033203 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 101356 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038309097290039 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select payment_id from dbthird.thd_payment where oa_payment_id = 101356 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038540363311768 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 119742 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038309097290039 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 4961561 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038449764251709 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039010047912598 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038471221923828 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961561 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038259029388428 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038349628448486 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038650035858154 -- 25-07-20 15:02:07[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03000807762146 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 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 = 101355 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036389827728271 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select payment_id from dbthird.thd_payment where oa_payment_id = 101355 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037271976470947 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 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 = 119741 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036730766296387 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 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 = 4961560 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035321712493896 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035879611968994 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036940574645996 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961560 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035529136657715 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003525972366333 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035738945007324 -- 25-07-20 15:02:09[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023509979248047 -- 25-07-20 15:02:13[肖春-283] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018265008926392 -- 25-07-20 15:02:14[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029417037963867 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 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 = 101354 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040068626403809 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 select payment_id from dbthird.thd_payment where oa_payment_id = 101354 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040748119354248 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 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 = 119740 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040631294250488 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 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 = 4961559 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038888454437256 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039458274841309 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040359497070312 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961559 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038919448852539 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038821697235107 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003896951675415 -- 25-07-20 15:02:18[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101354%22%7D&event=edit_payment&payment_id=101354 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021696090698242 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 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 = 101355 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037820339202881 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select payment_id from dbthird.thd_payment where oa_payment_id = 101355 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038180351257324 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 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 = 119741 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037841796875 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 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 = 4961560 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037760734558105 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038049221038818 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037660598754883 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961560 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037729740142822 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037641525268555 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037961006164551 -- 25-07-20 15:02:21[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101355%22%7D&event=edit_payment&payment_id=101355 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018528938293457 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 101356 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036520957946777 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select payment_id from dbthird.thd_payment where oa_payment_id = 101356 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037209987640381 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 119742 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004094123840332 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 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 = 4961561 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035319328308105 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035808086395264 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036818981170654 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961561 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035278797149658 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035231113433838 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035641193389893 -- 25-07-20 15:02:24[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101356%22%7D&event=edit_payment&payment_id=101356 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022315979003906 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 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 = 101357 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040030479431152 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select payment_id from dbthird.thd_payment where oa_payment_id = 101357 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040831565856934 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 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 = 119743 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004518985748291 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 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 = 4961567 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039169788360596 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039770603179932 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select * from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040750503540039 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961567 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039229393005371 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038938522338867 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039410591125488 -- 25-07-20 15:02:28[肖春-283] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_payment%22,%22payment_id%22:%22101357%22%7D&event=edit_payment&payment_id=101357 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 283 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024574995040894 -- 25-07-20 15:43:54[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048840045928955 -- 25-07-20 15:43:54[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047659873962402 -- 25-07-20 15:43:54[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004953145980835 -- 25-07-20 15:43:54[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1474253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005202054977417 -- 25-07-20 15:43:54[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022053003311157 -- 25-07-20 15:43:55[李丹-751] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025960922241211 -- 25-07-20 15:43:55[李丹-751] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%李丹%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016355037689209 -- 25-07-20 15:43:55[李丹-751] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%上海办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020035028457642 -- 25-07-20 15:44:02[李丹-751] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%常用%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02159595489502 -- 25-07-20 15:44:11[李丹-751] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025672912597656 -- 25-07-20 15:44:25[李丹-751] -- /buz/oa/index.php/oamgmt/get_extrafare_item select extrafare_name,extrafare_id from dboa.oa_extrafare where acct_id = 15 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020378828048706 -- 25-07-20 15:45:18[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040409564971924 -- 25-07-20 15:45:18[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041239261627197 -- 25-07-20 15:45:18[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1474253) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039939880371094 -- 25-07-20 15:45:18[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065510272979736 -- 25-07-20 15:45:19[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 751,updatedby_id = 751 where extrafareApply_id = 63732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054798126220703 -- 25-07-20 15:45:19[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 751,updatedby_id = 751 where otherfee_id = 65730 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021188020706177 -- 25-07-20 15:45:19[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037910938262939 -- 25-07-20 15:45:19[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038189888000488 -- 25-07-20 15:45:20[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019691228866577 -- 25-07-20 15:45:20[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003856897354126 -- 25-07-20 15:45:20[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038928985595703 -- 25-07-20 15:45:20[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052928924560547 -- 25-07-20 15:45:21[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 751,updatedby_id = 751 where extrafareApply_id = 63732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050020217895508 -- 25-07-20 15:45:21[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 751,updatedby_id = 751 where otherfee_id = 65730 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023833036422729 -- 25-07-20 15:45:24[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031960010528564 -- 25-07-20 15:45:24[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032579898834229 -- 25-07-20 15:45:24[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044729709625244 -- 25-07-20 15:45:24[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 751,updatedby_id = 751 where extrafareApply_id = 63732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044450759887695 -- 25-07-20 15:45:24[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 751,updatedby_id = 751 where otherfee_id = 65730 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017431974411011 -- 25-07-20 15:45:24[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015651226043701 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030550956726074 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030560493469238 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031008720397949 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1474253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003605842590332 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1474253&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028873920440674 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021352052688599 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%李丹%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021830081939697 -- 25-07-20 15:45:28[李丹-751] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%上海办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020900964736938 -- 25-07-20 17:50:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263732%22}&event=edit_extrafareApply&extrafareApply_id=63732 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 = 63732 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046160221099854 -- 25-07-20 17:50:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263732%22}&event=edit_extrafareApply&extrafareApply_id=63732 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046889781951904 -- 25-07-20 17:50:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263732%22}&event=edit_extrafareApply&extrafareApply_id=63732 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 63732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040981769561768 -- 25-07-20 17:50:43[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263732%22}&event=edit_extrafareApply&extrafareApply_id=63732 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040349960327148 -- 25-07-20 17:50:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263732%22}&event=edit_extrafareApply&extrafareApply_id=63732 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004216194152832 -- 25-07-20 17:50:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263732%22}&event=edit_extrafareApply&extrafareApply_id=63732 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961624 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040369033813477 -- 25-07-20 17:50:44[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263732%22}&event=edit_extrafareApply&extrafareApply_id=63732 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019276142120361 -- 25-07-20 18:23:55 -- /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.0037698745727539 -- 25-07-20 18:23:55 -- /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.0042359828948975 -- 25-07-20 18:23:55 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='YangQun' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039529800415039 -- 25-07-20 18:23:55[杨群-2017] -- /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= 39 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031720876693726 -- 25-07-20 18:23:56[杨群-2017] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2017 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0156090259552 -- 25-07-20 18:24:00[杨群-2017] -- /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 = 2017 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035758018493652 -- 25-07-20 18:24:00[杨群-2017] -- /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 = 2017 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036289691925049 -- 25-07-20 18:24:00[杨群-2017] -- /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 = 2017 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043749809265137 -- 25-07-20 18:24:00[杨群-2017] -- /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 = 2017 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048480033874512 -- 25-07-20 18:24:00[杨群-2017] -- /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= 2017 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015395164489746 -- 25-07-20 19:38:54 -- /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.021637916564941 -- 25-07-20 19:38:54 -- /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.0039699077606201 -- 25-07-20 19:38:54 -- /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.0044260025024414 -- 25-07-20 19:38:54 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041282176971436 -- 25-07-20 19:38:54[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019107818603516 -- 25-07-20 19:38:55[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023421049118042 -- 25-07-20 20:14:05[李绩秀-510] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 510 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020937204360962 -- 25-07-20 20:14:05[李绩秀-510] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 510 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022119998931885 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044169425964355 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043470859527588 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044970512390137 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1457278) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049359798431396 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020776987075806 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027971029281616 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017673969268799 -- 25-07-20 22:25:44[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023432016372681 -- 25-07-20 22:25:48[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%式汉%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02210807800293 -- 25-07-20 22:25:57[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%武汉%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020349979400635 -- 25-07-20 22:26:04[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022556066513062 -- 25-07-20 22:26:12[吴文超-755] -- /buz/oa/index.php/oamgmt/get_extrafare_item select extrafare_name,extrafare_id from dboa.oa_extrafare where acct_id = 15 and extrafare_name like '%卸货%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017884016036987 -- 25-07-20 22:27:49[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034658908843994 -- 25-07-20 22:27:49[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035130977630615 -- 25-07-20 22:27:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1457278) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033600330352783 -- 25-07-20 22:27:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004673957824707 -- 25-07-20 22:27:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044980049133301 -- 25-07-20 22:27:50[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 65732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016872882843018 -- 25-07-20 22:27:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032658576965332 -- 25-07-20 22:27:52[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033137798309326 -- 25-07-20 22:27:53[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056769847869873 -- 25-07-20 22:27:53[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004706859588623 -- 25-07-20 22:27:53[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 65732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018283128738403 -- 25-07-20 22:27:54[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035581588745117 -- 25-07-20 22:27:54[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035841464996338 -- 25-07-20 22:27:54[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018484115600586 -- 25-07-20 22:28:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036160945892334 -- 25-07-20 22:28:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036389827728271 -- 25-07-20 22:28:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049049854278564 -- 25-07-20 22:28:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047178268432617 -- 25-07-20 22:28:11[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 65732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01836895942688 -- 25-07-20 22:28:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036001205444336 -- 25-07-20 22:28:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003619909286499 -- 25-07-20 22:28:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063531398773193 -- 25-07-20 22:28:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 755,updatedby_id = 755 where extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047891139984131 -- 25-07-20 22:28:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 755,updatedby_id = 755 where otherfee_id = 65732 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019998788833618 -- 25-07-20 22:28:13[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016832113265991 -- 25-07-20 22:28:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033371448516846 -- 25-07-20 22:28:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032460689544678 -- 25-07-20 22:28:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034301280975342 -- 25-07-20 22:28:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1457278) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038471221923828 -- 25-07-20 22:28:44[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1457278&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01907205581665 -- 25-07-20 22:30:14[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 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 = 63734 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041971206665039 -- 25-07-20 22:30:14[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003899097442627 -- 25-07-20 22:30:14[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037388801574707 -- 25-07-20 22:30:14[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036909580230713 -- 25-07-20 22:30:14[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038309097290039 -- 25-07-20 22:30:14[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961923 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036659240722656 -- 25-07-20 22:30:14[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020610094070435 -- 25-07-20 22:30:54[吴展如-1710] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=63734 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019275903701782 -- 25-07-20 22:30:54[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021120071411133 -- 25-07-20 22:30:55[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 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 = 63734 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041160583496094 -- 25-07-20 22:30:55[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044441223144531 -- 25-07-20 22:30:55[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 63734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041139125823975 -- 25-07-20 22:30:55[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041379928588867 -- 25-07-20 22:30:55[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041549205780029 -- 25-07-20 22:30:55[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 4961923 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040969848632812 -- 25-07-20 22:30:55[吴展如-1710] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263734%22}&event=edit_extrafareApply&extrafareApply_id=63734 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1710 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017924070358276 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035660266876221 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034298896789551 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036709308624268 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1462986,1461429) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038418769836426 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025033950805664 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022905111312866 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024064064025879 -- 25-07-20 22:35:51[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025968074798584 -- 25-07-20 22:35:57[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%武汉%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017516136169434 -- 25-07-20 22:36:06[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%项目三%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018184900283813 -- 25-07-20 22:36:48[吴文超-755] -- /buz/oa/index.php/oamgmt/get_extrafare_item select extrafare_name,extrafare_id from dboa.oa_extrafare where acct_id = 15 and extrafare_name like '%卸%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030416965484619 -- 25-07-20 22:38:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048089027404785 -- 25-07-20 22:38:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1462986,1461429) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046570301055908 -- 25-07-20 22:38:13[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019649028778076 -- 25-07-20 22:38:15[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038750171661377 -- 25-07-20 22:38:15[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017126798629761 -- 25-07-20 22:38:16[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033731460571289 -- 25-07-20 22:38:16[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022564888000488 -- 25-07-20 22:38:35[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044529438018799 -- 25-07-20 22:38:35[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023225069046021 -- 25-07-20 22:38:36[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045840740203857 -- 25-07-20 22:38:36[吴文超-755] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017241954803467 -- 25-07-20 22:38:36[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019381999969482 -- 25-07-20 22:39:11[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038690567016602 -- 25-07-20 22:39:11[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003760814666748 -- 25-07-20 22:39:11[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 755 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039451122283936 -- 25-07-20 22:39:11[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1462986,1461429) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045120716094971 -- 25-07-20 22:39:11[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1462986,1461429&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D391%26ship_city%3D%E6%AD%A6%E6%B1%89%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025563955307007 -- 25-07-20 22:39:12[吴文超-755] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022087097167969 -- 25-07-20 22:39:12[吴文超-755] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%吴文超%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020619869232178 -- 25-07-20 22:39:12[吴文超-755] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.org_name like '%武汉办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------