Time: 0.01875901222229 -- 25-11-30 08:12:27 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018877029418945 -- 25-11-30 08:12:27 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037260055541992 -- 25-11-30 08:12:27 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042200088500977 -- 25-11-30 08:12:27 -- /buz/oa/index.php/oamgmt/oa_application?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='LiuXiangXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039100646972656 -- 25-11-30 08:12:27[刘湘湘-1515] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021116971969604 -- 25-11-30 08:12:28[刘湘湘-1515] -- /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 = 1515 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056869983673096 -- 25-11-30 08:12:28[刘湘湘-1515] -- /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 = 1515 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052750110626221 -- 25-11-30 08:12:28[刘湘湘-1515] -- /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 = 1515 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053300857543945 -- 25-11-30 08:12:28[刘湘湘-1515] -- /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 = 1515 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053858757019043 -- 25-11-30 08:12:28[刘湘湘-1515] -- /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= 1515 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026502132415771 -- 25-11-30 08:12:31[刘湘湘-1515] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_taskrept&task_id=5346 SELECT t.task_id,t.task_no,t.owner_id,t.status_id,t.task_type_id,t.task_title,t.task_description,t.assign_finish_time,t.assign_finish_time,t.createdon,t.updatedon, t.issued_cont_id,t.department_id,t.appr_proc_id,t.cur_appr_id_str,t.appr_ver,createdby.cont_name createdby,updatedby.cont_name updatedby, cont.cont_name issued_cont,org.org_name department,apro.appr_proc_name appr_proc FROM dboa.oa_task t LEFT JOIN dboa.oa_appr_process apro ON t.appr_proc_id = apro.appr_proc_id LEFT JOIN dbsys.sys_org org ON t.department_id = org.org_id LEFT JOIN dbsys.sys_contact cont ON t.issued_cont_id = cont.cont_id LEFT JOIN dbsys.sys_contact createdby ON t.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON t.updatedby_id = updatedby.cont_id WHERE t.task_id = 5346 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048079490661621 -- 25-11-30 08:12:31[刘湘湘-1515] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_taskrept&task_id=5346 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1515 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019788980484009 -- 25-11-30 08:23:50 -- /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.0039529800415039 -- 25-11-30 08:23:50 -- /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.0046250820159912 -- 25-11-30 08:23:50 -- /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.0042710304260254 -- 25-11-30 08:23:50[吴凌刚-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.018681049346924 -- 25-11-30 08:23:50[吴凌刚-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.017812013626099 -- 25-11-30 10:11:17[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1658094&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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 = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035440921783447 -- 25-11-30 10:11:17[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1658094&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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.0034360885620117 -- 25-11-30 10:11:17[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1658094&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036029815673828 -- 25-11-30 10:11:17[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1658094&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%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 (1658094) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033204793930054 -- 25-11-30 10:11:17[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1658094&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034492015838623 -- 25-11-30 10:11:17[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1658094&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025529146194458 -- 25-11-30 10:11:18[陈同照-1165] -- /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.019968032836914 -- 25-11-30 10:11:18[陈同照-1165] -- /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.023093938827515 -- 25-11-30 10:11:18[陈同照-1165] -- /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.025782823562622 -- 25-11-30 10:11:32[陈同照-1165] -- /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.018916130065918 -- 25-11-30 10:11:48[陈同照-1165] -- /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.021581172943115 -- 25-11-30 10:12:41[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227000%22}&event=edit_officialSeals&officialSeals_id=7000 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7000 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021731853485107 -- 25-11-30 10:12:43[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041420459747314 -- 25-11-30 10:12:43[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040979385375977 -- 25-11-30 10:12:43[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042531490325928 -- 25-11-30 10:12:43[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040559768676758 -- 25-11-30 10:12:43[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025415897369385 -- 25-11-30 10:12:47[陈同照-1165] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 15 and e.extrafare_name like '%叉车费，150人工费50%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024527072906494 -- 25-11-30 10:12:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020430088043213 -- 25-11-30 10:12:48[吴凌刚-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.021500110626221 -- 25-11-30 10:12:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041868686676025 -- 25-11-30 10:12:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042030811309814 -- 25-11-30 10:12:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042669773101807 -- 25-11-30 10:12:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041940212249756 -- 25-11-30 10:12:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019761085510254 -- 25-11-30 10:13:44[陈同照-1165] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 15 and e.extrafare_name like '%叉车费150人工费50%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021661043167114 -- 25-11-30 10:13:47[陈同照-1165] -- /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.0042688846588135 -- 25-11-30 10:13:47[陈同照-1165] -- /buz/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.0043370723724365 -- 25-11-30 10:13:47[陈同照-1165] -- /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 (1658094) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042829513549805 -- 25-11-30 10:13:47[陈同照-1165] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061008930206299 -- 25-11-30 10:13:47[陈同照-1165] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1165,updatedby_id = 1165 where extrafareApply_id = 68388 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059778690338135 -- 25-11-30 10:13:47[陈同照-1165] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1165,updatedby_id = 1165 where otherfee_id = 69963 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024309873580933 -- 25-11-30 10:13:53[陈同照-1165] -- /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.0047600269317627 -- 25-11-30 10:13:53[陈同照-1165] -- /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.0047872066497803 -- 25-11-30 10:13:53[陈同照-1165] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030303001403809 -- 25-11-30 10:13:55[陈同照-1165] -- /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.0040309429168701 -- 25-11-30 10:13:55[陈同照-1165] -- /buz/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.0041060447692871 -- 25-11-30 10:13:55[陈同照-1165] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057029724121094 -- 25-11-30 10:13:55[陈同照-1165] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1165,updatedby_id = 1165 where extrafareApply_id = 68388 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058760643005371 -- 25-11-30 10:13:55[陈同照-1165] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1165,updatedby_id = 1165 where otherfee_id = 69963 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020048856735229 -- 25-11-30 10:13:55[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022032022476196 -- 25-11-30 10:13:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041451454162598 -- 25-11-30 10:13:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041019916534424 -- 25-11-30 10:13:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042469501495361 -- 25-11-30 10:13:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040440559387207 -- 25-11-30 10:13:59[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022125959396362 -- 25-11-30 10:22:13[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042212009429932 -- 25-11-30 10:22:13[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042159557342529 -- 25-11-30 10:22:13[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042960643768311 -- 25-11-30 10:22:13[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041379928588867 -- 25-11-30 10:22:13[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022715091705322 -- 25-11-30 10:22:16[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021541833877563 -- 25-11-30 10:22:17[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032288074493408 -- 25-11-30 10:22:18[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6998 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042159557342529 -- 25-11-30 10:22:18[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040349960327148 -- 25-11-30 10:22:18[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042269229888916 -- 25-11-30 10:22:18[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5653383 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040140151977539 -- 25-11-30 10:22:18[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020975112915039 -- 25-11-30 10:22:20[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020149946212769 -- 25-11-30 10:22:21[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020821094512939 -- 25-11-30 10:22:22[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6997 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039501190185547 -- 25-11-30 10:22:22[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037398338317871 -- 25-11-30 10:22:22[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039050579071045 -- 25-11-30 10:22:22[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5653048 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037190914154053 -- 25-11-30 10:22:22[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018882036209106 -- 25-11-30 10:22:23[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019977807998657 -- 25-11-30 10:22:24[石教华-26] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 26 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020524024963379 -- 25-11-30 10:25:10 -- /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.004148006439209 -- 25-11-30 10:25:10 -- /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.0046238899230957 -- 25-11-30 10:25:10 -- /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='YuZeXu' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043141841888428 -- 25-11-30 10:25:10[余泽旭-927] -- /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.019438028335571 -- 25-11-30 10:25:10[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021126985549927 -- 25-11-30 10:25:11[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6998 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042319297790527 -- 25-11-30 10:25:11[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040590763092041 -- 25-11-30 10:25:11[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042350292205811 -- 25-11-30 10:25:11[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5653383 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040900707244873 -- 25-11-30 10:25:11[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022588014602661 -- 25-11-30 10:25:13[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020500183105469 -- 25-11-30 10:25:14[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017549991607666 -- 25-11-30 10:31:05 -- /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.0034148693084717 -- 25-11-30 10:31:05 -- /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.0039169788360596 -- 25-11-30 10:31:05 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035901069641113 -- 25-11-30 10:31:05[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01811408996582 -- 25-11-30 10:31:05[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021511077880859 -- 25-11-30 10:31:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040359497070312 -- 25-11-30 10:31:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039670467376709 -- 25-11-30 10:31:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041348934173584 -- 25-11-30 10:31:07[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039689540863037 -- 25-11-30 10:31:07[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021186828613281 -- 25-11-30 10:31:09[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019500017166138 -- 25-11-30 10:31:10[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021273136138916 -- 25-11-30 10:31:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6998 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040731430053711 -- 25-11-30 10:31:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select org_id,org_name from dbsys.sys_org where corp_acct_id = 23 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039269924163818 -- 25-11-30 10:31:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040910243988037 -- 25-11-30 10:31:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5653383 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039269924163818 -- 25-11-30 10:31:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6998 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017697095870972 -- 25-11-30 10:31:12[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023130893707275 -- 25-11-30 10:31:13[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021913051605225 -- 25-11-30 10:31:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6997 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043118000030518 -- 25-11-30 10:31:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040750503540039 -- 25-11-30 10:31:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042321681976318 -- 25-11-30 10:31:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5653048 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041110515594482 -- 25-11-30 10:31:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=6997 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023940801620483 -- 25-11-30 10:31:15[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018816947937012 -- 25-11-30 10:31:16[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033736228942871 -- 25-11-30 10:38: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.022814989089966 -- 25-11-30 10:38:53[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040409564971924 -- 25-11-30 10:38:53[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039310455322266 -- 25-11-30 10:38:53[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040740966796875 -- 25-11-30 10:38:53[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039360523223877 -- 25-11-30 10:38:53[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022065162658691 -- 25-11-30 10:39:33[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043048858642578 -- 25-11-30 10:39:33[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042929649353027 -- 25-11-30 10:39:33[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043258666992188 -- 25-11-30 10:39:33[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043079853057861 -- 25-11-30 10:39:33[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022340059280396 -- 25-11-30 12:20:12[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68388 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 68388 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039920806884766 -- 25-11-30 12:20:13[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68388 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040509700775146 -- 25-11-30 12:20:13[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68388 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041890144348145 -- 25-11-30 12:20:13[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68388 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656218 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040490627288818 -- 25-11-30 12:20:13[陈同照-1165] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D469%26ship_city%3D%E4%B8%9C%E8%8E%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68388 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022362947463989 -- 25-11-30 12:20:13[陈同照-1165] -- /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.030562877655029 -- 25-11-30 12:20:13[陈同照-1165] -- /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.021920919418335 -- 25-11-30 12:20:13[陈同照-1165] -- /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.020458936691284 -- 25-11-30 13:04:53[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 67800 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035960674285889 -- 25-11-30 13:04:53[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036158561706543 -- 25-11-30 13:04:53[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037238597869873 -- 25-11-30 13:04:53[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5570298 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035800933837891 -- 25-11-30 13:04:53[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02008581161499 -- 25-11-30 13:04:54[梁汉东-1251] -- /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.021767854690552 -- 25-11-30 13:04:54[梁汉东-1251] -- /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.023897171020508 -- 25-11-30 13:04:54[梁汉东-1251] -- /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.023669004440308 -- 25-11-30 13:05:46[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 68322 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042738914489746 -- 25-11-30 13:05:46[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043261051177979 -- 25-11-30 13:05:46[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004439115524292 -- 25-11-30 13:05:46[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5652991 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042788982391357 -- 25-11-30 13:05:46[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042598247528076 -- 25-11-30 13:05:46[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019768953323364 -- 25-11-30 13:05:46[梁汉东-1251] -- /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.023590087890625 -- 25-11-30 13:05:47[梁汉东-1251] -- /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.019792079925537 -- 25-11-30 13:05:47[梁汉东-1251] -- /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.019089937210083 -- 25-11-30 13:06:03[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 68322 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035610198974609 -- 25-11-30 13:06:03[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034749507904053 -- 25-11-30 13:06:03[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036659240722656 -- 25-11-30 13:06:03[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5652991 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034539699554443 -- 25-11-30 13:06:03[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003446102142334 -- 25-11-30 13:06:03[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=68322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021329164505005 -- 25-11-30 13:06:06[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 67800 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038869380950928 -- 25-11-30 13:06:06[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039029121398926 -- 25-11-30 13:06:06[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004047155380249 -- 25-11-30 13:06:06[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5570298 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003882884979248 -- 25-11-30 13:06:06[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=67800 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018562078475952 -- 25-11-30 17:50:31[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1646646&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%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 = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003695011138916 -- 25-11-30 17:50:31[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1646646&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035889148712158 -- 25-11-30 17:50:31[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1646646&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041389465332031 -- 25-11-30 17:50:31[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1646646&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%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 (1646646) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040390491485596 -- 25-11-30 17:50:31[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1646646&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036149024963379 -- 25-11-30 17:50:31[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1646646&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D428%26ship_city%3D%E9%95%BF%E6%B2%99%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030955076217651 -- 25-11-30 17:50:31[彭铸-825] -- /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.033017873764038 -- 25-11-30 17:50:31[彭铸-825] -- /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.029977083206177 -- 25-11-30 17:50:31[彭铸-825] -- /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.026704072952271 -- 25-11-30 17:50:35[彭铸-825] -- /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.019959926605225 -- 25-11-30 17:50:42[彭铸-825] -- /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.01957893371582 -- 25-11-30 17:51:18[彭铸-825] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 15 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022439002990723 -- 25-11-30 17:51:42[彭铸-825] -- /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.0043871402740479 -- 25-11-30 17:51:42[彭铸-825] -- /buz/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.004486083984375 -- 25-11-30 17:51:42[彭铸-825] -- /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 (1646646) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045080184936523 -- 25-11-30 17:51:42[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063700675964355 -- 25-11-30 17:51:42[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 68403 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059540271759033 -- 25-11-30 17:51:42[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 69977 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023916959762573 -- 25-11-30 17:51:56[彭铸-825] -- /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.0046939849853516 -- 25-11-30 17:51:56[彭铸-825] -- /buz/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.0047190189361572 -- 25-11-30 17:51:56[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065979957580566 -- 25-11-30 17:51:56[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 68403 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0062451362609863 -- 25-11-30 17:51:56[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 69977 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030495166778564 -- 25-11-30 17:51:59[彭铸-825] -- /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.0039880275726318 -- 25-11-30 17:51:59[彭铸-825] -- /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.0040600299835205 -- 25-11-30 17:51:59[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020888805389404 -- 25-11-30 17:52:01[彭铸-825] -- /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.0040929317474365 -- 25-11-30 17:52:01[彭铸-825] -- /buz/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.0041189193725586 -- 25-11-30 17:52:01[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056231021881104 -- 25-11-30 17:52:01[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 68403 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055010318756104 -- 25-11-30 17:52:01[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 69977 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029327869415283 -- 25-11-30 17:52:01[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018693923950195 -- 25-11-30 17:52:11[彭铸-825] -- /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.0037140846252441 -- 25-11-30 17:52:11[彭铸-825] -- /buz/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.0037400722503662 -- 25-11-30 17:52:11[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005202054977417 -- 25-11-30 17:52:11[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 68403 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052559375762939 -- 25-11-30 17:52:11[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 69977 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01981520652771 -- 25-11-30 17:52:11[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020792007446289 -- 25-11-30 18:02:45[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68289 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041899681091309 -- 25-11-30 18:02:45[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 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 = 68289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044431686401367 -- 25-11-30 18:02:45[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 68289 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046360492706299 -- 25-11-30 18:02:45[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 68289 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040938854217529 -- 25-11-30 18:02:45[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040349960327148 -- 25-11-30 18:02:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041370391845703 -- 25-11-30 18:02:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5647431 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039889812469482 -- 25-11-30 18:02:46[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020672798156738 -- 25-11-30 18:02:49[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=68289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025285959243774 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019323825836182 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68289 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038459300994873 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 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 = 68289 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037910938262939 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 68289 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040678977966309 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 68289 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037899017333984 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003864049911499 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038390159606934 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5647431 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037920475006104 -- 25-11-30 18:02:50[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268289%22}&event=edit_extrafareApply&extrafareApply_id=68289 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021204948425293 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68288 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035378932952881 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 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 = 68288 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038530826568604 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 68288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038869380950928 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 68288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033071041107178 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033259391784668 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034332275390625 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5647378 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032999515533447 -- 25-11-30 18:02:55[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019360065460205 -- 25-11-30 18:02:58[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=68288 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023554086685181 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017834901809692 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68288 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035090446472168 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 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 = 68288 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034401416778564 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 68288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042011737823486 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 68288 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034680366516113 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034928321838379 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035200119018555 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5647378 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034730434417725 -- 25-11-30 18:02:59[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268288%22}&event=edit_extrafareApply&extrafareApply_id=68288 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02396297454834 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68121 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051379203796387 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 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 = 68121 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050070285797119 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 68121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051720142364502 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 68121 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004525899887085 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045840740203857 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047039985656738 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5620226 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045380592346191 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045340061187744 -- 25-11-30 18:03:06[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2268121%22}&event=edit_extrafareApply&extrafareApply_id=68121 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024760007858276 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 67993 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036938190460205 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 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 = 67993 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039889812469482 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 67993 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040979385375977 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 67993 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034289360046387 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034267902374268 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035440921783447 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5591710 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034101009368896 -- 25-11-30 18:03:20[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2267993%22}&event=edit_extrafareApply&extrafareApply_id=67993 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023488998413086 -- 25-11-30 18:43:02[王双玉-2164] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2164 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017236948013306 -- 25-11-30 18:43:07[王双玉-2164] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2164 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033119916915894 -- 25-11-30 18:43:14[王双玉-2164] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2164 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025876998901367 -- 25-11-30 19:08:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054190158843994 -- 25-11-30 19:08:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050399303436279 -- 25-11-30 19:08:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053179264068604 -- 25-11-30 19:08:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005479097366333 -- 25-11-30 19:08:00[李磊-753] -- /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= 753 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021050214767456 -- 25-11-30 19:08:07[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply 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 = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041790008544922 -- 25-11-30 19:08:07[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031538009643555 -- 25-11-30 19:08:07[李磊-753] -- /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.033955097198486 -- 25-11-30 19:08:07[李磊-753] -- /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.021245002746582 -- 25-11-30 19:08:07[李磊-753] -- /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.017139911651611 -- 25-11-30 19:08:07[李磊-753] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018100023269653 -- 25-11-30 19:08:07[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036439895629883 -- 25-11-30 19:08:07[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 15 and p.project_id not in (85,83,87,1,28) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.041933059692383 -- 25-11-30 19:08:10[李磊-753] -- /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.018232107162476 -- 25-11-30 19:08:17[李磊-753] -- /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.01996111869812 -- 25-11-30 19:08:53[李磊-753] -- /buz/oa/index.php/oamgmt/fareApply_application?event=save_fareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02521800994873 -- 25-11-30 19:08:56[李磊-753] -- /buz/oa/index.php/oamgmt/get_fareitem_item select * from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051860809326172 -- 25-11-30 19:08:56[李磊-753] -- /buz/oa/index.php/oamgmt/get_fareitem_item select fi.fareitem_name `title`,fi.fareitem_id `value` from dboa.oa_fareitem fi left join dboa.oa_fareitem_issue fi_i on fi.fareitem_id = fi_i.fareitem_id where fi_i.issue_acct_id = 15 and fi.fare_type_id = 2 and fi.fare_attr_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033540725708008 -- 25-11-30 19:08:56[李磊-753] -- /buz/oa/index.php/oamgmt/get_fareitem_item select fi.fareitem_name `title`,fi.fareitem_id `value` from dboa.oa_fareitem fi where fi.acct_id = 15 and fi.fare_type_id = 2 and fi.fare_attr_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020287990570068 -- 25-11-30 19:09:50[李磊-753] -- /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.032164096832275 -- 25-11-30 19:09:52[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042018890380859 -- 25-11-30 19:09:52[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 15 and p.project_id not in (85,83,87,1,28) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020774841308594 -- 25-11-30 19:10:11[李磊-753] -- /buz/oa/index.php/oamgmt/fareApply_application?event=save_fareApply_item select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040678977966309 -- 25-11-30 19:10:11[李磊-753] -- /buz/oa/index.php/oamgmt/fareApply_application?event=save_fareApply_item select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01931095123291 -- 25-11-30 19:10:12[李磊-753] -- /buz/oa/index.php/oamgmt/get_fareitem_item select * from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047869682312012 -- 25-11-30 19:10:12[李磊-753] -- /buz/oa/index.php/oamgmt/get_fareitem_item select fi.fareitem_name `title`,fi.fareitem_id `value` from dboa.oa_fareitem fi left join dboa.oa_fareitem_issue fi_i on fi.fareitem_id = fi_i.fareitem_id where fi_i.issue_acct_id = 15 and fi.fare_type_id = 2 and fi.fare_attr_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038750171661377 -- 25-11-30 19:10:12[李磊-753] -- /buz/oa/index.php/oamgmt/get_fareitem_item select fi.fareitem_name `title`,fi.fareitem_id `value` from dboa.oa_fareitem fi where fi.acct_id = 15 and fi.fare_type_id = 2 and fi.fare_attr_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023093938827515 -- 25-11-30 19:11:02[李磊-753] -- /buz/oa/index.php/oamgmt/fareApply_application?event=save_fareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02229380607605 -- 25-11-30 19:11:18[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021951913833618 -- 25-11-30 19:11:40[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025122880935669 -- 25-11-30 19:11:42[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049800872802734 -- 25-11-30 19:11:42[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048980712890625 -- 25-11-30 19:11:42[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052521228790283 -- 25-11-30 19:11:42[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052521228790283 -- 25-11-30 19:11:42[李磊-753] -- /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= 753 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024106979370117 -- 25-11-30 19:11:43[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H-%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 42006 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044360160827637 -- 25-11-30 19:11:43[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044682025909424 -- 25-11-30 19:11:43[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5658181 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044338703155518 -- 25-11-30 19:11:43[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044209957122803 -- 25-11-30 19:11:43[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044510364532471 -- 25-11-30 19:11:43[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5658181 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004453182220459 -- 25-11-30 19:11:43[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025922060012817 -- 25-11-30 19:11:43[李磊-753] -- /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.017146110534668 -- 25-11-30 19:11:43[李磊-753] -- /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.018357992172241 -- 25-11-30 19:11:43[李磊-753] -- /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.027040958404541 -- 25-11-30 19:11:44[李磊-753] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018525838851929 -- 25-11-30 19:11:44[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00376296043396 -- 25-11-30 19:11:44[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 15 and p.project_id not in (85,83,87,1,28) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018608808517456 -- 25-11-30 19:12:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036609172821045 -- 25-11-30 19:12:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039999485015869 -- 25-11-30 19:12:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039210319519043 -- 25-11-30 19:12:00[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038819313049316 -- 25-11-30 19:12:00[李磊-753] -- /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= 753 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019641160964966 -- 25-11-30 19:12:01[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H-%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 42006 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038130283355713 -- 25-11-30 19:12:01[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038650035858154 -- 25-11-30 19:12:01[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5658181 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038268566131592 -- 25-11-30 19:12:01[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038189888000488 -- 25-11-30 19:12:01[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038759708404541 -- 25-11-30 19:12:01[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5658181 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038158893585205 -- 25-11-30 19:12:01[李磊-753] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42006 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021410942077637 -- 25-11-30 19:12:02[李磊-753] -- /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.018976211547852 -- 25-11-30 19:12:02[李磊-753] -- /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.017096042633057 -- 25-11-30 19:12:02[李磊-753] -- /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.020463943481445 -- 25-11-30 19:12:02[李磊-753] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 15 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020896911621094 -- 25-11-30 19:12:02[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041060447692871 -- 25-11-30 19:12:02[李磊-753] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 15 and p.project_id not in (85,83,87,1,28) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019171953201294 -- 25-11-30 19:12:04[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040779113769531 -- 25-11-30 19:12:04[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036470890045166 -- 25-11-30 19:12:04[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003960132598877 -- 25-11-30 19:12:04[李磊-753] -- /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 = 753 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039980411529541 -- 25-11-30 19:12:04[李磊-753] -- /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= 753 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027141094207764 -- 25-11-30 19:56:45[吴凌刚-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.022784948348999 -- 25-11-30 19:56:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7001 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042669773101807 -- 25-11-30 19:56:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041508674621582 -- 25-11-30 19:56:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043179988861084 -- 25-11-30 19:56:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5656213 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041630268096924 -- 25-11-30 19:56:49[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%227001%22}&event=edit_officialSeals&officialSeals_id=7001 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023056983947754 -- 25-11-30 22:09:15 -- /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.0045368671417236 -- 25-11-30 22:09:15 -- /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.0050411224365234 -- 25-11-30 22:09:15 -- /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='KouBinNan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047659873962402 -- 25-11-30 22:09:15[寇彬楠-1097] -- /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.017328023910522 -- 25-11-30 22:09:15[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026305913925171 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 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 = 112467 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056610107421875 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 select payment_id from dbthird.thd_payment where oa_payment_id = 112467 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054938793182373 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 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 = 130445 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061450004577637 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 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 = 5653377 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049839019775391 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051338672637939 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 select * from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050961971282959 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5653377 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049879550933838 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049779415130615 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050230026245117 -- 25-11-30 22:09:16[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112467 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020938873291016 -- 25-11-30 22:09:17[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=112467 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024158954620361 -- 25-11-30 22:09:18[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019762992858887 -- 25-11-30 22:09:18[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 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 = 112460 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041251182556152 -- 25-11-30 22:09:18[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 select payment_id from dbthird.thd_payment where oa_payment_id = 112460 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004223108291626 -- 25-11-30 22:09:18[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 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 = 130438 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004127025604248 -- 25-11-30 22:09:18[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 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 = 5652955 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036880970001221 -- 25-11-30 22:09:18[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037238597869873 -- 25-11-30 22:09:19[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 select * from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003831148147583 -- 25-11-30 22:09:19[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5652955 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036778450012207 -- 25-11-30 22:09:19[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036690235137939 -- 25-11-30 22:09:19[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037178993225098 -- 25-11-30 22:09:19[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=112460 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024276971817017 -- 25-11-30 22:09:20[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=112460 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02137017250061 -- 25-11-30 22:09:20[寇彬楠-1097] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1097 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024721145629883 -- 25-11-30 23:20:10[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1653454,1653235,1652810&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.004910945892334 -- 25-11-30 23:20:10[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1653454,1653235,1652810&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.0048120021820068 -- 25-11-30 23:20:10[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1653454,1653235,1652810&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.0050070285797119 -- 25-11-30 23:20:10[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1653454,1653235,1652810&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 (1653454,1653235,1652810) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051751136779785 -- 25-11-30 23:20:10[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1653454,1653235,1652810&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,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047681331634521 -- 25-11-30 23:20:10[吴文超-755] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1653454,1653235,1652810&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.022851943969727 -- 25-11-30 23:20:10[吴文超-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.018546104431152 -- 25-11-30 23:20:11[吴文超-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.026372909545898 -- 25-11-30 23:20:11[吴文超-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.025804996490479 -- 25-11-30 23:20:18[吴文超-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.017792940139771 -- 25-11-30 23:20:45[吴文超-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.024539947509766 -- 25-11-30 23:20:56[吴文超-755] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 15 and e.extrafare_name like '%卸货费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023028135299683 -- 25-11-30 23:22:43[吴文超-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.0046908855438232 -- 25-11-30 23:22:43[吴文超-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 (1653454,1653235,1652810) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045120716094971 -- 25-11-30 23:22:43[吴文超-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.032800912857056 -- 25-11-30 23:22:45[吴文超-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.004464864730835 -- 25-11-30 23:22:45[吴文超-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.021026849746704 -- 25-11-30 23:22:46[吴文超-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.0041828155517578 -- 25-11-30 23:22:46[吴文超-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.021713972091675 -- 25-11-30 23:23:05[吴文超-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.0043361186981201 -- 25-11-30 23:23:05[吴文超-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.021428108215332 -- 25-11-30 23:23:07[吴文超-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.0038590431213379 -- 25-11-30 23:23:07[吴文超-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.018908977508545 -- 25-11-30 23:23:07[吴文超-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.019855976104736 -- 25-11-30 23:23: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.0039510726928711 -- 25-11-30 23:23:12[吴文超-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.024760007858276 -- 25-11-30 23:23: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.0049538612365723 -- 25-11-30 23:23: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.019363164901733 -- 25-11-30 23:23: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.025615930557251 -- 25-11-30 23:23:21[吴文超-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.0041129589080811 -- 25-11-30 23:23:21[吴文超-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.021639823913574 -- 25-11-30 23:23:22[吴文超-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.0042707920074463 -- 25-11-30 23:23:22[吴文超-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.016698837280273 -- 25-11-30 23:23:22[吴文超-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 ------------------------------------------------------------------------------------------------------------------------------------------------------