Time: 0.017030000686646 -- 2026-06-28 05:41:22.868 -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017648935317993 -- 2026-06-28 05:41:22.944 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017484903335571 -- 2026-06-28 05:41:23.760 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092298984527588 -- 2026-06-28 05:41:23.981 -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021875858306885 -- 2026-06-28 08:03:35.788 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089380741119385 -- 2026-06-28 08:03:35.994 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018651485443115 -- 2026-06-28 08:03:35.998 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044889450073242 -- 2026-06-28 08:03:36.002 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6O6wmMgPtn3Xo5dPfGQsPSI' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018150806427002 -- 2026-06-28 08:03:36.004 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020101070404053 -- 2026-06-28 08:03:36.006[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021748542785645 -- 2026-06-28 08:03:36.009[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00177001953125 -- 2026-06-28 08:03:36.011[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056960582733154 -- 2026-06-28 08:03:36.017[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2526 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046489238739014 -- 2026-06-28 08:03:36.101[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2526 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017988681793213 -- 2026-06-28 08:03:36.103[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020900011062622 -- 2026-06-28 08:03:36.157[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 139 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033750534057617 -- 2026-06-28 08:03:36.160[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9170,9149,9120) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092389583587646 -- 2026-06-28 08:03:41.353[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2526 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017249584197998 -- 2026-06-28 08:03:41.355[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.049463033676147 -- 2026-06-28 08:03:41.429[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 139 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/01' AND o.order_date <= '2026/06/28 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029430389404297 -- 2026-06-28 08:03:41.433[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9170,9149,9120,9038,9008,8960,8915,8835,8740,8686,8635,8545,8467) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014053106307983 -- 2026-06-28 08:03:59.260[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9120&extrafareApply_id=79706 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79706 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015621185302734 -- 2026-06-28 08:03:59.262[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9120&extrafareApply_id=79706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056009292602539 -- 2026-06-28 08:03:59.308[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9120&extrafareApply_id=79706 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79706 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016899108886719 -- 2026-06-28 08:03:59.310[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9120&extrafareApply_id=79706 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6700719 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015401840209961 -- 2026-06-28 08:03:59.311[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9120&extrafareApply_id=79706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001554012298584 -- 2026-06-28 08:03:59.337[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9120&extrafareApply_id=79706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01038384437561 -- 2026-06-28 09:36:44.278 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019688606262207 -- 2026-06-28 09:36:44.282 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028741359710693 -- 2026-06-28 09:36:44.285 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6L7U5CKBjB7EVFd4HMShE30' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019381046295166 -- 2026-06-28 09:36:44.287 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021510124206543 -- 2026-06-28 09:36:44.289[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024080276489258 -- 2026-06-28 09:36:44.292[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019130706787109 -- 2026-06-28 09:36:44.294[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026900768280029 -- 2026-06-28 09:36:44.296[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023541450500488 -- 2026-06-28 09:36:44.300[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2500 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018990039825439 -- 2026-06-28 09:36:44.303[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069448947906494 -- 2026-06-28 09:36:44.346[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 111 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023610591888428 -- 2026-06-28 09:36:44.348[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9181,9180,9179,9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080580711364746 -- 2026-06-28 09:36:44.351 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015053033828735 -- 2026-06-28 09:36:49.612[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9181&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029919147491455 -- 2026-06-28 09:36:49.615[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9181&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039660930633545 -- 2026-06-28 09:36:49.620[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9181&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9181 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010063886642456 -- 2026-06-28 09:37:51.560[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79790 and order_id = 9181 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022568702697754 -- 2026-06-28 09:37:51.562[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9181 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018150806427002 -- 2026-06-28 09:37:51.564[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011289119720459 -- 2026-06-28 09:38:02.581[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79790 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031039714813232 -- 2026-06-28 09:38:02.584[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 7.00 where extrafareApply_id = 79790 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094380378723145 -- 2026-06-28 09:38:30.975[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79790 and order_id = 9181 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084238052368164 -- 2026-06-28 09:38:33.224[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79790 and order_id = 9181 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016476154327393 -- 2026-06-28 09:38:35.552[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2500 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015392303466797 -- 2026-06-28 09:38:35.554[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057401657104492 -- 2026-06-28 09:38:35.585[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 111 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017929077148438 -- 2026-06-28 09:38:35.587[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9181,9180,9179,9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021885871887207 -- 2026-06-28 09:38:38.407[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9181&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031900405883789 -- 2026-06-28 09:38:38.410[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9181&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044500827789307 -- 2026-06-28 09:38:38.415[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9181&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9181 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094318389892578 -- 2026-06-28 09:38:38.889[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017709732055664 -- 2026-06-28 09:38:38.891[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025088787078857 -- 2026-06-28 09:38:38.893[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016369819641113 -- 2026-06-28 09:38:38.897[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2500 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016121864318848 -- 2026-06-28 09:38:38.899[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017240047454834 -- 2026-06-28 09:38:38.926[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 111 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001629114151001 -- 2026-06-28 09:38:38.927[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9181,9180,9179,9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021267890930176 -- 2026-06-28 10:59:22.535 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086138248443604 -- 2026-06-28 10:59:22.753 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021779537200928 -- 2026-06-28 10:59:22.757 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029349327087402 -- 2026-06-28 10:59:22.760 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6B9dXa9qNObDJcWbpTe3RBQ' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017061233520508 -- 2026-06-28 10:59:22.762 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019011497497559 -- 2026-06-28 10:59:22.764[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026941299438477 -- 2026-06-28 10:59:22.766[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017108917236328 -- 2026-06-28 10:59:22.768[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037500858306885 -- 2026-06-28 10:59:22.772[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021839141845703 -- 2026-06-28 10:59:22.776[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017509460449219 -- 2026-06-28 10:59:22.778[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083191394805908 -- 2026-06-28 10:59:22.817[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018038749694824 -- 2026-06-28 10:59:22.819[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082049369812012 -- 2026-06-28 10:59:27.244[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030429363250732 -- 2026-06-28 10:59:27.248[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027689933776855 -- 2026-06-28 10:59:27.250[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9173 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078961849212646 -- 2026-06-28 11:00:53.050[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79792 and order_id = 9173 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015618801116943 -- 2026-06-28 11:00:53.052[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9173 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014300346374512 -- 2026-06-28 11:00:53.053[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093259811401367 -- 2026-06-28 11:01:17.909[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028910636901855 -- 2026-06-28 11:01:17.912[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042140483856201 -- 2026-06-28 11:01:17.916[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9173 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093529224395752 -- 2026-06-28 11:03:33.814[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017850399017334 -- 2026-06-28 11:03:33.816[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025241374969482 -- 2026-06-28 11:03:33.819[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002147912979126 -- 2026-06-28 11:03:33.823[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017130374908447 -- 2026-06-28 11:03:33.824[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061120986938477 -- 2026-06-28 11:03:33.855[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018351078033447 -- 2026-06-28 11:03:33.857[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028805017471313 -- 2026-06-28 11:03:45.890[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79792 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016109943389893 -- 2026-06-28 11:03:45.892[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025980472564697 -- 2026-06-28 11:03:45.926[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79792 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016999244689941 -- 2026-06-28 11:03:45.928[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6717454 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096280574798584 -- 2026-06-28 11:04:20.369[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79792 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032570362091064 -- 2026-06-28 11:04:20.373[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 35.00 where extrafareApply_id = 79792 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088059902191162 -- 2026-06-28 11:05:02.686[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79792 and order_id = 9173 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011070013046265 -- 2026-06-28 11:05:05.162[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012378692626953 -- 2026-06-28 11:05:05.163[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047450065612793 -- 2026-06-28 11:05:05.192[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014269351959229 -- 2026-06-28 11:05:05.194[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066628456115723 -- 2026-06-28 11:05:07.857[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025169849395752 -- 2026-06-28 11:05:07.860[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031929016113281 -- 2026-06-28 11:05:07.863[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9173 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084469318389893 -- 2026-06-28 11:06:22.524[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015568733215332 -- 2026-06-28 11:06:22.525[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029281139373779 -- 2026-06-28 11:06:22.580[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017220973968506 -- 2026-06-28 11:06:22.582[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088000297546387 -- 2026-06-28 11:06:24.309[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002924919128418 -- 2026-06-28 11:06:24.312[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041680335998535 -- 2026-06-28 11:06:24.316[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9173 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081849098205566 -- 2026-06-28 11:07:40.426[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79793 and order_id = 9173 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018861293792725 -- 2026-06-28 11:07:40.429[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9173 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013949871063232 -- 2026-06-28 11:07:40.430[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015323162078857 -- 2026-06-28 11:08:00.732[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79793 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031330585479736 -- 2026-06-28 11:08:00.736[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 80.00 where extrafareApply_id = 79793 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095410346984863 -- 2026-06-28 11:08:55.280[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016889572143555 -- 2026-06-28 11:08:55.282[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059800148010254 -- 2026-06-28 11:08:55.314[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018899440765381 -- 2026-06-28 11:08:55.316[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096089839935303 -- 2026-06-28 11:08:56.440[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79792 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015878677368164 -- 2026-06-28 11:08:56.442[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025348663330078 -- 2026-06-28 11:08:56.475[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79792 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016429424285889 -- 2026-06-28 11:08:56.476[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6717454 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015389919281006 -- 2026-06-28 11:08:56.478[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015349388122559 -- 2026-06-28 11:08:56.480[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79792 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021552085876465 -- 2026-06-28 11:08:58.086[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017900466918945 -- 2026-06-28 11:08:58.088[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025849342346191 -- 2026-06-28 11:08:58.091[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016770362854004 -- 2026-06-28 11:08:58.094[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016388893127441 -- 2026-06-28 11:08:58.096[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00174880027771 -- 2026-06-28 11:08:58.124[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016400814056396 -- 2026-06-28 11:08:58.125[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073060989379883 -- 2026-06-28 11:09:46.276[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013618469238281 -- 2026-06-28 11:09:46.278[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020670890808105 -- 2026-06-28 11:09:46.280[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016629695892334 -- 2026-06-28 11:09:46.283[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013020038604736 -- 2026-06-28 11:09:46.285[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038070678710938 -- 2026-06-28 11:09:46.313[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014269351959229 -- 2026-06-28 11:09:46.315[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011035919189453 -- 2026-06-28 11:09:48.415[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79793 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016810894012451 -- 2026-06-28 11:09:48.417[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040309429168701 -- 2026-06-28 11:09:48.452[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79793 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018038749694824 -- 2026-06-28 11:09:48.454[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6717462 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016748905181885 -- 2026-06-28 11:09:48.456[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097298622131348 -- 2026-06-28 11:10:00.232[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79793 and order_id = 9173 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013958215713501 -- 2026-06-28 11:10:02.743[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015149116516113 -- 2026-06-28 11:10:02.745[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01708197593689 -- 2026-06-28 11:10:02.787[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017561912536621 -- 2026-06-28 11:10:02.788[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01039981842041 -- 2026-06-28 11:13:44.667[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79793 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018310546875 -- 2026-06-28 11:13:44.669[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030388832092285 -- 2026-06-28 11:13:44.704[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79793 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018599033355713 -- 2026-06-28 11:13:44.706[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6717462 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017189979553223 -- 2026-06-28 11:13:44.708[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017180442810059 -- 2026-06-28 11:13:44.710[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9173&extrafareApply_id=79793 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011766910552979 -- 2026-06-28 11:13:46.522[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016231536865234 -- 2026-06-28 11:13:46.524[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023770332336426 -- 2026-06-28 11:13:46.526[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019688606262207 -- 2026-06-28 11:13:46.530[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015199184417725 -- 2026-06-28 11:13:46.531[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053231716156006 -- 2026-06-28 11:13:46.562[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020408630371094 -- 2026-06-28 11:13:46.565[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9173,9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080578327178955 -- 2026-06-28 12:47:49.987 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010587930679321 -- 2026-06-28 12:47:50.299 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021119117736816 -- 2026-06-28 12:47:50.302 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030410289764404 -- 2026-06-28 12:47:50.306 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6Nr1c8mjP-leU6Bz6xWev9c' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020120143890381 -- 2026-06-28 12:47:50.308 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021779537200928 -- 2026-06-28 12:47:50.310[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023870468139648 -- 2026-06-28 12:47:50.313[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019588470458984 -- 2026-06-28 12:47:50.315[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028259754180908 -- 2026-06-28 12:47:50.318[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038731098175049 -- 2026-06-28 12:47:50.323[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3114 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019729137420654 -- 2026-06-28 12:47:50.325[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067391395568848 -- 2026-06-28 12:47:50.363[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 546 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023889541625977 -- 2026-06-28 12:47:50.366[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9178,9128,9082) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084688663482666 -- 2026-06-28 12:47:55.684[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042481422424316 -- 2026-06-28 12:47:55.689[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042130947113037 -- 2026-06-28 12:47:55.693[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9178 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090198516845703 -- 2026-06-28 12:49:39.441[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79794 and order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020291805267334 -- 2026-06-28 12:49:39.443[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015959739685059 -- 2026-06-28 12:49:39.445[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01289701461792 -- 2026-06-28 12:50:12.176[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79794 and order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021451950073242 -- 2026-06-28 12:50:15.985[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79794 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033919811248779 -- 2026-06-28 12:50:15.989[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 20.00 where extrafareApply_id = 79794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012914180755615 -- 2026-06-28 12:50:22.335[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79794 and order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010567903518677 -- 2026-06-28 12:50:24.812[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 3114 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016279220581055 -- 2026-06-28 12:50:24.814[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0062451362609863 -- 2026-06-28 12:50:24.845[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 546 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018718242645264 -- 2026-06-28 12:50:24.847[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9178,9128,9082) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095078945159912 -- 2026-06-28 12:51:45.883[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018010139465332 -- 2026-06-28 12:51:45.885[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025870800018311 -- 2026-06-28 12:51:45.888[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021171569824219 -- 2026-06-28 12:51:45.892[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3114 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017621517181396 -- 2026-06-28 12:51:45.894[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061721801757812 -- 2026-06-28 12:51:45.925[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 546 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019330978393555 -- 2026-06-28 12:51:45.927[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9178,9128,9082) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088939666748047 -- 2026-06-28 13:33:47.670 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017118453979492 -- 2026-06-28 13:33:47.673 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028672218322754 -- 2026-06-28 13:33:47.676 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6F-X6cItc7cy7G4lIeZtRtI' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019938945770264 -- 2026-06-28 13:33:47.678 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001823902130127 -- 2026-06-28 13:33:47.680[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020458698272705 -- 2026-06-28 13:33:47.683[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016710758209229 -- 2026-06-28 13:33:47.684[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032820701599121 -- 2026-06-28 13:33:47.688[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020129680633545 -- 2026-06-28 13:33:47.692[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3124 and acct_id = 49 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016438961029053 -- 2026-06-28 13:33:47.693[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058670043945312 -- 2026-06-28 13:33:47.735[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=49 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 555 OR IFNULL(oe_f.fleet_org_id,1) IN(1,520) ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021011829376221 -- 2026-06-28 13:33:47.737[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9144,9105,9103) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098190307617188 -- 2026-06-28 13:33:52.394[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79777 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013790130615234 -- 2026-06-28 13:33:52.396[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003931999206543 -- 2026-06-28 13:33:52.431[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79777 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014641284942627 -- 2026-06-28 13:33:52.433[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6714120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013511180877686 -- 2026-06-28 13:33:52.434[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013489723205566 -- 2026-06-28 13:33:52.436[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020999908447266 -- 2026-06-28 14:19:09.825 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017910003662109 -- 2026-06-28 14:19:09.829 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026309490203857 -- 2026-06-28 14:19:09.832 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6ABR6OBpi9ZgSw2yKdGgBaM' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017449855804443 -- 2026-06-28 14:19:09.834 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019469261169434 -- 2026-06-28 14:19:09.836[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021188259124756 -- 2026-06-28 14:19:09.838[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017220973968506 -- 2026-06-28 14:19:09.840[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030510425567627 -- 2026-06-28 14:19:09.843[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020699501037598 -- 2026-06-28 14:19:09.847[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2511 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001708984375 -- 2026-06-28 14:19:09.849[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039651393890381 -- 2026-06-28 14:19:09.883[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 122 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022411346435547 -- 2026-06-28 14:19:09.886[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9165,9143,9079) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097088813781738 -- 2026-06-28 14:19:28.720[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9165&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00337815284729 -- 2026-06-28 14:19:28.723[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9165&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004317045211792 -- 2026-06-28 14:19:28.728[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9165&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9165 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081019401550293 -- 2026-06-28 14:21:03.260[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79795 and order_id = 9165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001594066619873 -- 2026-06-28 14:21:03.262[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015208721160889 -- 2026-06-28 14:21:03.263[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092430114746094 -- 2026-06-28 14:21:37.967[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79795 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033509731292725 -- 2026-06-28 14:21:37.971[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 50.00 where extrafareApply_id = 79795 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010157108306885 -- 2026-06-28 14:21:42.961[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79795 and order_id = 9165 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009937047958374 -- 2026-06-28 14:21:45.473[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2511 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018479824066162 -- 2026-06-28 14:21:45.475[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023924827575684 -- 2026-06-28 14:21:45.525[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 122 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024518966674805 -- 2026-06-28 14:21:45.528[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9165,9143,9079) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080511569976807 -- 2026-06-28 14:21:49.293[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9165&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027360916137695 -- 2026-06-28 14:21:49.296[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9165&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039751529693604 -- 2026-06-28 14:21:49.300[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9165&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9165 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079901218414307 -- 2026-06-28 15:59:27.711 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093889236450195 -- 2026-06-28 15:59:27.921 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019450187683105 -- 2026-06-28 15:59:27.925 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028479099273682 -- 2026-06-28 15:59:27.928 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6F-X6cItc7cy7G4lIeZtRtI' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002187967300415 -- 2026-06-28 15:59:27.930 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027179718017578 -- 2026-06-28 15:59:27.933[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022659301757812 -- 2026-06-28 15:59:27.936[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018110275268555 -- 2026-06-28 15:59:27.938[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002295970916748 -- 2026-06-28 15:59:27.940[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023519992828369 -- 2026-06-28 15:59:27.944[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3124 and acct_id = 49 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018141269683838 -- 2026-06-28 15:59:27.946[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065100193023682 -- 2026-06-28 15:59:27.988[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=49 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 555 OR IFNULL(oe_f.fleet_org_id,1) IN(1,520) ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024209022521973 -- 2026-06-28 15:59:27.990[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9144,9105,9103) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098779201507568 -- 2026-06-28 15:59:41.628[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79777 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015189647674561 -- 2026-06-28 15:59:41.630[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041248798370361 -- 2026-06-28 15:59:41.664[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79777 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016319751739502 -- 2026-06-28 15:59:41.666[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6714120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015089511871338 -- 2026-06-28 15:59:41.668[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015289783477783 -- 2026-06-28 15:59:41.670[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010746002197266 -- 2026-06-28 15:59:51.221[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9105&extrafareApply_id=79659 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79659 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016388893127441 -- 2026-06-28 15:59:51.223[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9105&extrafareApply_id=79659 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042901039123535 -- 2026-06-28 15:59:51.258[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9105&extrafareApply_id=79659 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79659 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002284049987793 -- 2026-06-28 15:59:51.260[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9105&extrafareApply_id=79659 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6695108 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016281604766846 -- 2026-06-28 15:59:51.262[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9105&extrafareApply_id=79659 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016200542449951 -- 2026-06-28 15:59:51.264[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9105&extrafareApply_id=79659 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013159036636353 -- 2026-06-28 16:00:01.371[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9144&extrafareApply_id=79770 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79770 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018589496612549 -- 2026-06-28 16:00:01.373[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9144&extrafareApply_id=79770 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045719146728516 -- 2026-06-28 16:00:01.409[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9144&extrafareApply_id=79770 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79770 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020167827606201 -- 2026-06-28 16:00:01.412[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9144&extrafareApply_id=79770 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6713161 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018091201782227 -- 2026-06-28 16:00:01.414[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9144&extrafareApply_id=79770 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001823902130127 -- 2026-06-28 16:00:01.416[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9144&extrafareApply_id=79770 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074059963226318 -- 2026-06-28 16:10:58.933 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014910697937012 -- 2026-06-28 16:10:58.936 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024130344390869 -- 2026-06-28 16:10:58.938 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6Nr1c8mjP-leU6Bz6xWev9c' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014569759368896 -- 2026-06-28 16:10:58.940 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016469955444336 -- 2026-06-28 16:10:58.942[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018298625946045 -- 2026-06-28 16:10:58.944[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014190673828125 -- 2026-06-28 16:10:58.945[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028011798858643 -- 2026-06-28 16:10:58.948[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018150806427002 -- 2026-06-28 16:10:58.952[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3114 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014209747314453 -- 2026-06-28 16:10:58.953[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057220458984375 -- 2026-06-28 16:10:58.990[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 546 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018608570098877 -- 2026-06-28 16:10:58.992[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9178,9128,9082) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091760158538818 -- 2026-06-28 16:11:03.607[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023670196533203 -- 2026-06-28 16:11:03.610[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043652057647705 -- 2026-06-28 16:11:03.615[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=1 select 0 as extrafareapply_tslorder_id, 0 as extrafareApply_id,w_sl.copilot_driver, '' as fee_amt, 1 as status_id, o.order_id, o.order_no, 0 as is_close, o.pieces, o.weight, o.volume, o.calc_weight, o.acct_id, o.customer_id,route.route_name,w.truck_no,w.driver,o.order_date from dbtsl.v_tsl_order o left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_workch_order w_o on w_o.order_id = o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where o.order_id = 9178 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028098106384277 -- 2026-06-28 16:14:44.700[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79799 and order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021030902862549 -- 2026-06-28 16:14:44.703[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001633882522583 -- 2026-06-28 16:14:44.704[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011101007461548 -- 2026-06-28 16:14:48.227[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79799 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031771659851074 -- 2026-06-28 16:14:48.230[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 342.50 where extrafareApply_id = 79799 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0072321891784668 -- 2026-06-28 16:16:48.804[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79799 and order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091249942779541 -- 2026-06-28 16:16:50.446[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79799 and order_id = 9178 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008842945098877 -- 2026-06-28 16:16:53.034[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 3114 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015361309051514 -- 2026-06-28 16:16:53.036[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039758682250977 -- 2026-06-28 16:16:53.067[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 546 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017058849334717 -- 2026-06-28 16:16:53.069[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9178,9128,9082) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082950592041016 -- 2026-06-28 16:16:56.145[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015320777893066 -- 2026-06-28 16:16:56.147[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023789405822754 -- 2026-06-28 16:16:56.149[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001460075378418 -- 2026-06-28 16:16:56.152[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3114 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014162063598633 -- 2026-06-28 16:16:56.154[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015199184417725 -- 2026-06-28 16:16:56.181[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 546 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013949871063232 -- 2026-06-28 16:16:56.182[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9178,9128,9082) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014123916625977 -- 2026-06-28 16:17:13.087[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79794 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79794 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017249584197998 -- 2026-06-28 16:17:13.089[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035591125488281 -- 2026-06-28 16:17:13.123[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79794 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79794 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018210411071777 -- 2026-06-28 16:17:13.125[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79794 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6717664 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016889572143555 -- 2026-06-28 16:17:13.127[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016820430755615 -- 2026-06-28 16:17:13.129[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79794 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01078200340271 -- 2026-06-28 16:17:32.436 -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01031494140625 -- 2026-06-28 16:17:32.513[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=127 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017290115356445 -- 2026-06-28 16:17:32.514[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026021003723145 -- 2026-06-28 16:17:32.517[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 127 and cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029501914978027 -- 2026-06-28 16:17:32.522[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 SELECT driver_id,receiving_unit_id,salaryItem_tmplt_id FROM dbtsl.v_tsl_driver WHERE cont_id = 3114 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016198873519897 -- 2026-06-28 16:17:32.538[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 SELECT s.*,sd.*,c.shortname driver_name, s_e.extfield_json,group_concat(s.statement_no) statement_no, group_concat(s.statement_id) statement_ids, sum(s_d.sumSalary_amt) sumSalary_amt,sum(s_d.monthlyBonus_amt) monthlyBonus_amt, sum(s_d.monthlyDeduction_amt) monthlyDeduction_amt,sum(s_d.otherDeduction_amt) otherDeduction_amt, sum(s_d.sumDeduction_amt) sumDeduction_amt, date_format(s.start_date, '%Y-%m-%d') AS start_date, date_format(s.end_date, '%Y-%m-%d') AS end_date FROM dbtsl.tsl_statement s LEFT JOIN dbtsl.tsl_statement_ext s_e ON s.statement_id = s_e.statement_id LEFT JOIN dbsys.sys_customer c ON s.customer_id = c.customer_id LEFT JOIN dbtsl.tsl_statementex_driversalary s_d ON s.statement_id = s_d.statement_id LEFT JOIN dboa.oa_fareapply f ON f.fareApply_id = s_d.fareApply_id LEFT JOIN dbfin.fin_salarydata sd ON sd.salaryData_id = s_d.salaryData_id LEFT JOIN dboa.oa_fareapply fin_f ON sd.fareApply_id = fin_f.fareApply_id WHERE s.customer_id = 21326 AND s.acct_id = 47 AND s.statement_type_id = 2 AND (f.payStatus_id = 3 OR fin_f.payStatus_id = 3) AND s.start_date >= '2026-05-01' AND s.start_date <= '2026-06-30 23:59:59' GROUP BY IF(sd.salarydata_id IS NULL, UUID(), sd.salarydata_id) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070550441741943 -- 2026-06-28 16:17:32.545[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 SELECT salaryItem_name,field_name FROM dbfin.fin_salaryitem WHERE isenable = 1 AND salaryItem_tmplt_id = 55 AND is_effective = 1 AND salaryItem_id NOT IN(SELECT fin_salaryItem_id FROM dbtsl.tsl_driversalary2fin_setting WHERE acct_id = 47) ORDER BY salaryItem_sort ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023410797119141 -- 2026-06-28 16:17:51.687[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017220973968506 -- 2026-06-28 16:17:51.689[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016269683837891 -- 2026-06-28 16:17:51.690[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3114 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016231536865234 -- 2026-06-28 16:17:51.694[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3114 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016820430755615 -- 2026-06-28 16:17:51.695[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025605916976929 -- 2026-06-28 16:17:51.745[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 546 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016629695892334 -- 2026-06-28 16:17:51.747[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9178,9128,9082) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01124382019043 -- 2026-06-28 16:18:16.963[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79799 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79799 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001823902130127 -- 2026-06-28 16:18:16.965[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79799 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044929981231689 -- 2026-06-28 16:18:17.003[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79799 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79799 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019180774688721 -- 2026-06-28 16:18:17.005[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79799 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6718064 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018010139465332 -- 2026-06-28 16:18:17.007[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79799 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017790794372559 -- 2026-06-28 16:18:17.009[陈林-3114] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9178&extrafareApply_id=79799 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3114 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087251663208008 -- 2026-06-28 17:36:08.402 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091390609741211 -- 2026-06-28 17:36:08.942 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002406120300293 -- 2026-06-28 17:36:08.946 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028729438781738 -- 2026-06-28 17:36:08.949 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6NdOH57OC4zVYQ7haBQ2Tt4' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018541812896729 -- 2026-06-28 17:36:08.951 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020270347595215 -- 2026-06-28 17:36:08.953[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023250579833984 -- 2026-06-28 17:36:08.955[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018172264099121 -- 2026-06-28 17:36:08.957[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026340484619141 -- 2026-06-28 17:36:08.960[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2501 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022637844085693 -- 2026-06-28 17:36:08.964[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2501 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018229484558105 -- 2026-06-28 17:36:08.966[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024377107620239 -- 2026-06-28 17:36:09.021[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 112 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025191307067871 -- 2026-06-28 17:36:09.023[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9163,9123) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020702123641968 -- 2026-06-28 17:36:13.025[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&extrafareApply_id=79788 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79788 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019388198852539 -- 2026-06-28 17:36:13.028[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&extrafareApply_id=79788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048749446868896 -- 2026-06-28 17:36:13.064[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&extrafareApply_id=79788 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79788 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021030902862549 -- 2026-06-28 17:36:13.066[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&extrafareApply_id=79788 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6716460 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019650459289551 -- 2026-06-28 17:36:13.068[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&extrafareApply_id=79788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019240379333496 -- 2026-06-28 17:36:13.071[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&extrafareApply_id=79788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019078969955444 -- 2026-06-28 19:24:00.961 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087378025054932 -- 2026-06-28 19:24:01.002 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023159980773926 -- 2026-06-28 19:24:01.006 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026750564575195 -- 2026-06-28 19:24:01.008 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6Al1f_LAQvDi76x-IB0urE8' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001737117767334 -- 2026-06-28 19:24:01.010 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019400119781494 -- 2026-06-28 19:24:01.012[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022850036621094 -- 2026-06-28 19:24:01.015[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001741886138916 -- 2026-06-28 19:24:01.017[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024850368499756 -- 2026-06-28 19:24:01.019[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021240711212158 -- 2026-06-28 19:24:01.023[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2433 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017209053039551 -- 2026-06-28 19:24:01.025[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065360069274902 -- 2026-06-28 19:24:01.063[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 47 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021898984909058 -- 2026-06-28 19:24:09.146[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2433 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018010139465332 -- 2026-06-28 19:24:09.148[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055651664733887 -- 2026-06-28 19:24:09.178[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 47 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/17' AND o.order_date <= '2026/06/17 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001986026763916 -- 2026-06-28 19:24:09.180[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8991) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011735916137695 -- 2026-06-28 19:24:13.436[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79543 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79543 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018150806427002 -- 2026-06-28 19:24:13.438[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79543 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044729709625244 -- 2026-06-28 19:24:13.475[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79543 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79543 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019547939300537 -- 2026-06-28 19:24:13.477[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79543 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6681664 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017938613891602 -- 2026-06-28 19:24:13.479[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79543 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018129348754883 -- 2026-06-28 19:24:13.481[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79543 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018136978149414 -- 2026-06-28 19:24:21.061[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001427173614502 -- 2026-06-28 19:24:21.063[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001392126083374 -- 2026-06-28 19:24:21.065[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2433 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014050006866455 -- 2026-06-28 19:24:21.068[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2433 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013689994812012 -- 2026-06-28 19:24:21.069[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015227794647217 -- 2026-06-28 19:24:21.095[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 47 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092501640319824 -- 2026-06-28 19:24:28.980[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2433 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017421245574951 -- 2026-06-28 19:24:28.982[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016020059585571 -- 2026-06-28 19:24:29.023[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 47 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/17' AND o.order_date <= '2026/06/17 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017440319061279 -- 2026-06-28 19:24:29.025[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8991) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098550319671631 -- 2026-06-28 19:24:32.716[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79544 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001533031463623 -- 2026-06-28 19:24:32.718[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79544 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043659210205078 -- 2026-06-28 19:24:32.754[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79544 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79544 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017321109771729 -- 2026-06-28 19:24:32.756[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79544 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6681671 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015099048614502 -- 2026-06-28 19:24:32.758[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79544 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001533031463623 -- 2026-06-28 19:24:32.760[姜乐华-2433] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8991&extrafareApply_id=79544 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2433 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086929798126221 -- 2026-06-28 20:25:34.618 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075030326843262 -- 2026-06-28 20:25:34.760 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019869804382324 -- 2026-06-28 20:25:34.763 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023720264434814 -- 2026-06-28 20:25:34.766 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6GROgFfXHOfvclHbey_X7PY' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014870166778564 -- 2026-06-28 20:25:34.767 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001676082611084 -- 2026-06-28 20:25:34.769[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001964807510376 -- 2026-06-28 20:25:34.771[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014588832855225 -- 2026-06-28 20:25:34.773[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022518634796143 -- 2026-06-28 20:25:34.775[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2661 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019209384918213 -- 2026-06-28 20:25:34.779[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014710426330566 -- 2026-06-28 20:25:34.781[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076098442077637 -- 2026-06-28 20:25:34.820[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017788887023926 -- 2026-06-28 20:25:45.891[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017449855804443 -- 2026-06-28 20:25:45.893[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021367073059082 -- 2026-06-28 20:25:45.940[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/01' AND o.order_date <= '2026/06/28 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025680065155029 -- 2026-06-28 20:25:45.943[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8844,8683,8464) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010862112045288 -- 2026-06-28 20:25:48.456[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_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 dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016720294952393 -- 2026-06-28 20:25:48.458[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043120384216309 -- 2026-06-28 20:25:48.493[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79406 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017769336700439 -- 2026-06-28 20:25:48.495[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6667301 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016300678253174 -- 2026-06-28 20:25:48.497[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016248226165771 -- 2026-06-28 20:25:48.499[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087640285491943 -- 2026-06-28 22:25:58.564 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089609622955322 -- 2026-06-28 22:25:58.942 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001920223236084 -- 2026-06-28 22:25:58.945 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027191638946533 -- 2026-06-28 22:25:58.948 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6EXZHyVuRg87t7LgD02LsVc' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018229484558105 -- 2026-06-28 22:25:58.950 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019640922546387 -- 2026-06-28 22:25:58.952[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023529529571533 -- 2026-06-28 22:25:58.955[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017580986022949 -- 2026-06-28 22:25:58.956[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024721622467041 -- 2026-06-28 22:25:58.959[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2448 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00211501121521 -- 2026-06-28 22:25:58.963[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2448 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017430782318115 -- 2026-06-28 22:25:58.965[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044357776641846 -- 2026-06-28 22:25:58.999[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 62 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096089839935303 -- 2026-06-28 22:26:15.508[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2448 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018219947814941 -- 2026-06-28 22:26:15.510[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056970119476318 -- 2026-06-28 22:26:15.542[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 62 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' AND o.order_date <= '2026/06/28 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092499256134033 -- 2026-06-28 22:26:17.782[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2448 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017781257629395 -- 2026-06-28 22:26:17.784[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016878128051758 -- 2026-06-28 22:26:17.826[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 62 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/21' AND o.order_date <= '2026/06/28 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------