Time: 0.018413066864014 -- 2026-06-14 02:33:55.516 -- /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.012883901596069 -- 2026-06-14 02:34:01.176[刘强-2507] -- /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.0017969608306885 -- 2026-06-14 02:34:01.178[刘强-2507] -- /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 = 2507 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050480365753174 -- 2026-06-14 02:34:01.183[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003093957901001 -- 2026-06-14 02:34:01.188[刘强-2507] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2507 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017349720001221 -- 2026-06-14 02:34:01.190[刘强-2507] -- /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 = 2507 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025413036346436 -- 2026-06-14 02:34:01.258[刘强-2507] -- /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 = 118 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012953042984009 -- 2026-06-14 02:34:08.026[刘强-2507] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2507 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014119148254395 -- 2026-06-14 02:34:08.028[刘强-2507] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2507 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023960828781128 -- 2026-06-14 02:34:08.077[刘强-2507] -- /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 = 118 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/05/22' AND o.order_date <= '2026/06/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056569576263428 -- 2026-06-14 02:34:08.082[刘强-2507] -- /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(8554,8479,8239,8177,8102) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008124828338623 -- 2026-06-14 02:34:15.926[刘强-2507] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8102&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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058310031890869 -- 2026-06-14 02:34:15.932[刘强-2507] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8102&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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050239562988281 -- 2026-06-14 02:34:15.938[刘强-2507] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8102&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 = 8102 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010244131088257 -- 2026-06-14 02:34:17.946[刘强-2507] -- /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.0018341541290283 -- 2026-06-14 02:34:17.948[刘强-2507] -- /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 = 2507 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018429756164551 -- 2026-06-14 02:34:17.950[刘强-2507] -- /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 = 2507 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018250942230225 -- 2026-06-14 02:34:17.954[刘强-2507] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2507 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018250942230225 -- 2026-06-14 02:34:17.956[刘强-2507] -- /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 = 2507 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014511823654175 -- 2026-06-14 02:34:17.995[刘强-2507] -- /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 = 118 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014203071594238 -- 2026-06-14 02:57:55.467 -- /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.0085618495941162 -- 2026-06-14 05:28:47.396 -- /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.0017499923706055 -- 2026-06-14 05:28:47.399 -- /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.0050239562988281 -- 2026-06-14 05:28:47.404 -- /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.0016849040985107 -- 2026-06-14 05:28:47.406 -- /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.0019209384918213 -- 2026-06-14 05:28:47.408[杨恩达-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.0022671222686768 -- 2026-06-14 05:28:47.411[杨恩达-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.0016720294952393 -- 2026-06-14 05:28:47.412[杨恩达-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.0024728775024414 -- 2026-06-14 05:28:47.415[杨恩达-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.0022609233856201 -- 2026-06-14 05:28:47.419[杨恩达-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.001666784286499 -- 2026-06-14 05:28:47.421[杨恩达-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.019160985946655 -- 2026-06-14 05:28:47.474[杨恩达-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/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020326852798462 -- 2026-06-14 05:28:58.477[杨恩达-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.0017800331115723 -- 2026-06-14 05:28:58.479[杨恩达-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.031651020050049 -- 2026-06-14 05:28:58.536[杨恩达-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/04/30' AND o.order_date <= '2026/06/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005620002746582 -- 2026-06-14 05:28:58.542[杨恩达-2448] -- /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(8241,8170,7785,7717,7656,7517,7352,7334,7302) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021246194839478 -- 2026-06-14 05:29:08.172[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78756 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 = 78756 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017020702362061 -- 2026-06-14 05:29:08.174[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78756 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049848556518555 -- 2026-06-14 05:29:08.221[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78756 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 = 78756 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001838207244873 -- 2026-06-14 05:29:08.223[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78756 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6604376 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016660690307617 -- 2026-06-14 05:29:08.225[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78756 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016589164733887 -- 2026-06-14 05:29:08.228[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78756 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090291500091553 -- 2026-06-14 05:29:15.367[杨恩达-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.0015830993652344 -- 2026-06-14 05:29:15.369[杨恩达-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.0015931129455566 -- 2026-06-14 05:29:15.371[杨恩达-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.0015761852264404 -- 2026-06-14 05:29:15.374[杨恩达-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.0015649795532227 -- 2026-06-14 05:29:15.376[杨恩达-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.0016930103302002 -- 2026-06-14 05:29:15.403[杨恩达-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/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086419582366943 -- 2026-06-14 05:29:26.733[杨恩达-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.0016188621520996 -- 2026-06-14 05:29:26.734[杨恩达-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.045439004898071 -- 2026-06-14 05:29:26.806[杨恩达-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/05/01' AND o.order_date <= '2026/06/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016510486602783 -- 2026-06-14 05:29:26.807[杨恩达-2448] -- /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(8241,8170,7785,7717,7656,7517,7352,7334,7302) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011794805526733 -- 2026-06-14 05:29:31.486[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78494 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 = 78494 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017001628875732 -- 2026-06-14 05:29:31.488[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78494 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043289661407471 -- 2026-06-14 05:29:31.524[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78494 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 = 78494 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00177001953125 -- 2026-06-14 05:29:31.525[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78494 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6579176 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001662015914917 -- 2026-06-14 05:29:31.527[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78494 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016520023345947 -- 2026-06-14 05:29:31.529[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8241&extrafareApply_id=78494 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020592927932739 -- 2026-06-14 05:29:36.763[杨恩达-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.0017340183258057 -- 2026-06-14 05:29:36.765[杨恩达-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.0017220973968506 -- 2026-06-14 05:29:36.767[杨恩达-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.0017359256744385 -- 2026-06-14 05:29:36.771[杨恩达-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.0017068386077881 -- 2026-06-14 05:29:36.772[杨恩达-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.0018069744110107 -- 2026-06-14 05:29:36.799[杨恩达-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/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009465217590332 -- 2026-06-14 06:23:34.173 -- /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.0018379688262939 -- 2026-06-14 06:23:34.177 -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 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.002856969833374 -- 2026-06-14 06:23:34.180 -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 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='ocoGM6HyWvJN4PbDu-6Xp5xRBUlE' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018501281738281 -- 2026-06-14 06:23:34.182 -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020298957824707 -- 2026-06-14 06:23:34.184[杨芳-2999] -- /buz/tsl/index.php/tsloprt/driver_salary_list?appid=wxbcb1d4382ca8035f&wxMenu_id=127 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019588470458984 -- 2026-06-14 06:23:34.187[杨芳-2999] -- /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.0017881393432617 -- 2026-06-14 06:23:34.188[杨芳-2999] -- /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 = 2999 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031301975250244 -- 2026-06-14 06:23:34.192[杨芳-2999] -- /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 = 2999 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047361850738525 -- 2026-06-14 06:23:34.198[杨芳-2999] -- /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 = 2999 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017730951309204 -- 2026-06-14 06:23:34.216[杨芳-2999] -- /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 = 21181 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.0067660808563232 -- 2026-06-14 06:23:34.223[杨芳-2999] -- /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.017327070236206 -- 2026-06-14 06:23:47.430[杨芳-2999] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT driver_id,receiving_unit_id,salaryItem_tmplt_id FROM dbtsl.v_tsl_driver WHERE cont_id = 2999 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039608478546143 -- 2026-06-14 06:23:47.434[杨芳-2999] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query 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 = 21181 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/05/31 23:59:59' GROUP BY IF(sd.salarydata_id IS NULL, UUID(), sd.salarydata_id) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013518333435059 -- 2026-06-14 06:23:47.435[杨芳-2999] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query 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.010608911514282 -- 2026-06-14 06:23:51.272[杨芳-2999] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT driver_id,receiving_unit_id,salaryItem_tmplt_id FROM dbtsl.v_tsl_driver WHERE cont_id = 2999 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045051574707031 -- 2026-06-14 06:23:51.276[杨芳-2999] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query 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 = 21181 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/05/31 23:59:59' GROUP BY IF(sd.salarydata_id IS NULL, UUID(), sd.salarydata_id) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017490386962891 -- 2026-06-14 06:23:51.278[杨芳-2999] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query 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.0091478824615479 -- 2026-06-14 07:34:05.031 -- /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.0018091201782227 -- 2026-06-14 07:34:05.035 -- /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.0026471614837646 -- 2026-06-14 07:34:05.037 -- /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='ocoGM6BRbU8sl7gGeSDUfb3FsN2Q' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017762184143066 -- 2026-06-14 07:34:05.039 -- /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.0019721984863281 -- 2026-06-14 07:34:05.041[张民彦-2462] -- /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.0021789073944092 -- 2026-06-14 07:34:05.044[张民彦-2462] -- /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.0017528533935547 -- 2026-06-14 07:34:05.046[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024011135101318 -- 2026-06-14 07:34:05.048[张民彦-2462] -- /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 = 2462 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002100944519043 -- 2026-06-14 07:34:05.052[张民彦-2462] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2462 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017490386962891 -- 2026-06-14 07:34:05.054[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.040009021759033 -- 2026-06-14 07:34:05.138[张民彦-2462] -- /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 = 76 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022509098052979 -- 2026-06-14 07:34:05.140[张民彦-2462] -- /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(8742) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090420246124268 -- 2026-06-14 07:54:59.475[曾璟洋-2988] -- /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.0016660690307617 -- 2026-06-14 07:54:59.476[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024449825286865 -- 2026-06-14 07:54:59.479[曾璟洋-2988] -- /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 = 2988 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022051334381104 -- 2026-06-14 07:54:59.557[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001655101776123 -- 2026-06-14 07:54:59.558[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017921924591064 -- 2026-06-14 07:54:59.610[曾璟洋-2988] -- /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 = 522 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003126859664917 -- 2026-06-14 07:54:59.613[曾璟洋-2988] -- /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(8854,8704,8703) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009357213973999 -- 2026-06-14 07:55:07.733[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019049644470215 -- 2026-06-14 07:55:07.735[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.038210153579712 -- 2026-06-14 07:55:07.799[曾璟洋-2988] -- /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 = 522 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/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029211044311523 -- 2026-06-14 07:55:07.802[曾璟洋-2988] -- /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(8854,8704,8703,8534,8462) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011776924133301 -- 2026-06-14 07:55:12.469[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 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 = 78911 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017938613891602 -- 2026-06-14 07:55:12.471[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045459270477295 -- 2026-06-14 07:55:12.508[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 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 = 78911 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018949508666992 -- 2026-06-14 07:55:12.510[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6616725 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017588138580322 -- 2026-06-14 07:55:12.512[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017869472503662 -- 2026-06-14 07:55:12.536[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095939636230469 -- 2026-06-14 07:55:19.267[曾璟洋-2988] -- /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.0017099380493164 -- 2026-06-14 07:55:19.269[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017130374908447 -- 2026-06-14 07:55:19.271[曾璟洋-2988] -- /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 = 2988 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001727819442749 -- 2026-06-14 07:55:19.274[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016839504241943 -- 2026-06-14 07:55:19.276[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017790794372559 -- 2026-06-14 07:55:19.303[曾璟洋-2988] -- /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 = 522 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016880035400391 -- 2026-06-14 07:55:19.305[曾璟洋-2988] -- /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(8854,8704,8703) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011687040328979 -- 2026-06-14 07:55:23.003[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 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 = 79238 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001727819442749 -- 2026-06-14 07:55:23.005[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023159980773926 -- 2026-06-14 07:55:23.039[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 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 = 79238 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002345085144043 -- 2026-06-14 07:55:23.042[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6646041 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017008781433105 -- 2026-06-14 07:55:23.044[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017080307006836 -- 2026-06-14 07:55:23.046[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079529285430908 -- 2026-06-14 09:58:55.524 -- /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.0094239711761475 -- 2026-06-14 09:58:55.526[陈伦建-3003] -- /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.0017809867858887 -- 2026-06-14 09:58:55.528[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027041435241699 -- 2026-06-14 09:58:55.531[陈伦建-3003] -- /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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021250247955322 -- 2026-06-14 09:58:55.550[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017440319061279 -- 2026-06-14 09:58:55.552[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03934907913208 -- 2026-06-14 09:58:55.625[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026180744171143 -- 2026-06-14 09:58:55.628[陈伦建-3003] -- /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(8810,8706) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013370990753174 -- 2026-06-14 09:59:03.186[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014691352844238 -- 2026-06-14 09:59:03.187[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026403903961182 -- 2026-06-14 09:59:03.238[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/05/22' AND o.order_date <= '2026/06/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022799968719482 -- 2026-06-14 09:59:03.241[陈伦建-3003] -- /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(8810,8706,8705,8590,8461,8407,8376,8223) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092639923095703 -- 2026-06-14 10:40:42.867[陈伦建-3003] -- /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.0017039775848389 -- 2026-06-14 10:40:42.869[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025880336761475 -- 2026-06-14 10:40:42.872[陈伦建-3003] -- /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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021381378173828 -- 2026-06-14 10:40:42.876[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016481876373291 -- 2026-06-14 10:40:42.878[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018847942352295 -- 2026-06-14 10:40:42.927[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022819042205811 -- 2026-06-14 10:40:42.930[陈伦建-3003] -- /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(8810,8706) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021681070327759 -- 2026-06-14 10:40:45.362[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031471252441406 -- 2026-06-14 10:40:45.365[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040919780731201 -- 2026-06-14 10:40:45.370[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 8810 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015769958496094 -- 2026-06-14 10:41:11.312[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79299 and order_id = 8810 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002194881439209 -- 2026-06-14 10:41:11.314[陈伦建-3003] -- /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 = 8810 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017609596252441 -- 2026-06-14 10:41:11.316[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021424055099487 -- 2026-06-14 10:41:18.775[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79299 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033209323883057 -- 2026-06-14 10:41:18.778[陈伦建-3003] -- /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 = 79299 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019101142883301 -- 2026-06-14 10:42:17.271[陈伦建-3003] -- /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.0016689300537109 -- 2026-06-14 10:42:17.273[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023980140686035 -- 2026-06-14 10:42:17.276[陈伦建-3003] -- /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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001978874206543 -- 2026-06-14 10:42:17.279[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00152587890625 -- 2026-06-14 10:42:17.281[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018092155456543 -- 2026-06-14 10:42:17.324[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001835823059082 -- 2026-06-14 10:42:17.326[陈伦建-3003] -- /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(8810,8706) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013272047042847 -- 2026-06-14 10:42:19.641[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 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 = 79299 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016458034515381 -- 2026-06-14 10:42:19.643[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035669803619385 -- 2026-06-14 10:42:19.676[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 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 = 79299 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016388893127441 -- 2026-06-14 10:42:19.678[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6653755 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016231536865234 -- 2026-06-14 10:42:19.680[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017339944839478 -- 2026-06-14 10:42:27.353[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79299 and order_id = 8810 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077760219573975 -- 2026-06-14 10:42:29.619[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001492977142334 -- 2026-06-14 10:42:29.620[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017903089523315 -- 2026-06-14 10:42:29.663[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016970634460449 -- 2026-06-14 10:42:29.665[陈伦建-3003] -- /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(8810,8706) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021408081054688 -- 2026-06-14 10:42:31.664[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 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 = 79299 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012280941009521 -- 2026-06-14 10:42:31.666[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030391216278076 -- 2026-06-14 10:42:31.699[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 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 = 79299 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001230001449585 -- 2026-06-14 10:42:31.700[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6653755 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012068748474121 -- 2026-06-14 10:42:31.701[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012168884277344 -- 2026-06-14 10:42:31.703[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&extrafareApply_id=79299 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090229511260986 -- 2026-06-14 10:42:32.026[陈伦建-3003] -- /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.0016839504241943 -- 2026-06-14 10:42:32.028[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016858577728271 -- 2026-06-14 10:42:32.030[陈伦建-3003] -- /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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016610622406006 -- 2026-06-14 10:42:32.033[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016698837280273 -- 2026-06-14 10:42:32.035[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023920059204102 -- 2026-06-14 10:42:32.083[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017030239105225 -- 2026-06-14 10:42:32.085[陈伦建-3003] -- /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(8810,8706) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090501308441162 -- 2026-06-14 10:59:19.022 -- /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.0016951560974121 -- 2026-06-14 10:59:19.025 -- /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.0028579235076904 -- 2026-06-14 10:59:19.029 -- /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='ocoGM6Fvthylzy546ri8ofGVDYGE' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016639232635498 -- 2026-06-14 10:59:19.030 -- /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.0018570423126221 -- 2026-06-14 10:59:19.032[曾璟洋-2988] -- /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.0021700859069824 -- 2026-06-14 10:59:19.035[曾璟洋-2988] -- /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.0016500949859619 -- 2026-06-14 10:59:19.036[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024809837341309 -- 2026-06-14 10:59:19.039[曾璟洋-2988] -- /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 = 2988 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002129077911377 -- 2026-06-14 10:59:19.043[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016582012176514 -- 2026-06-14 10:59:19.045[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018697023391724 -- 2026-06-14 10:59:19.094[曾璟洋-2988] -- /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 = 522 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021579265594482 -- 2026-06-14 10:59:19.096[曾璟洋-2988] -- /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(8854,8704,8703) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010538101196289 -- 2026-06-14 10:59:26.061[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 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 = 79238 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016250610351562 -- 2026-06-14 10:59:26.062[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043652057647705 -- 2026-06-14 10:59:26.097[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 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 = 79238 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023090839385986 -- 2026-06-14 10:59:26.099[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6646041 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016179084777832 -- 2026-06-14 10:59:26.101[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016050338745117 -- 2026-06-14 10:59:26.103[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8854&extrafareApply_id=79238 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012929916381836 -- 2026-06-14 10:59:36.373[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016610622406006 -- 2026-06-14 10:59:36.375[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033751964569092 -- 2026-06-14 10:59:36.434[曾璟洋-2988] -- /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 = 522 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/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002324104309082 -- 2026-06-14 10:59:36.436[曾璟洋-2988] -- /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(8854,8704,8703,8534,8462) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018110990524292 -- 2026-06-14 10:59:42.944[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 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 = 78911 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016670227050781 -- 2026-06-14 10:59:42.946[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042788982391357 -- 2026-06-14 10:59:42.982[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 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 = 78911 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017621517181396 -- 2026-06-14 10:59:42.984[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6616725 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015881061553955 -- 2026-06-14 10:59:42.986[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015799999237061 -- 2026-06-14 10:59:42.988[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8534&extrafareApply_id=78911 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013473033905029 -- 2026-06-14 10:59:46.893[曾璟洋-2988] -- /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.0016160011291504 -- 2026-06-14 10:59:46.895[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015881061553955 -- 2026-06-14 10:59:46.897[曾璟洋-2988] -- /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 = 2988 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001568078994751 -- 2026-06-14 10:59:46.900[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001600980758667 -- 2026-06-14 10:59:46.902[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016829967498779 -- 2026-06-14 10:59:46.929[曾璟洋-2988] -- /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 = 522 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016069412231445 -- 2026-06-14 10:59:46.931[曾璟洋-2988] -- /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(8854,8704,8703) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014936923980713 -- 2026-06-14 12:04:00.652 -- /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.0083930492401123 -- 2026-06-14 12:04:15.080 -- /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.0022029876708984 -- 2026-06-14 12:04:15.084 -- /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.0029900074005127 -- 2026-06-14 12:04:15.087 -- /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='ocoGM6G2GU1h2dM1E8lkLsMf5Amk' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016739368438721 -- 2026-06-14 12:04:15.089 -- /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.0018379688262939 -- 2026-06-14 12:04:15.091[蔡易辰-2674] -- /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.0020561218261719 -- 2026-06-14 12:04:15.093[蔡易辰-2674] -- /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.0016641616821289 -- 2026-06-14 12:04:15.095[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024309158325195 -- 2026-06-14 12:04:15.098[蔡易辰-2674] -- /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 = 2674 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021219253540039 -- 2026-06-14 12:04:15.101[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2674 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016360282897949 -- 2026-06-14 12:04:15.103[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018621921539307 -- 2026-06-14 12:04:15.155[蔡易辰-2674] -- /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 = 277 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022451877593994 -- 2026-06-14 12:04:15.158[蔡易辰-2674] -- /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(8843,8718) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017389059066772 -- 2026-06-14 12:04:32.260[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&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 = 2674 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033631324768066 -- 2026-06-14 12:04:32.263[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&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 = 2674 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044040679931641 -- 2026-06-14 12:04:32.268[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&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 = 8843 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019934177398682 -- 2026-06-14 12:06:25.161[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79300 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019161701202393 -- 2026-06-14 12:06:25.163[蔡易辰-2674] -- /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 = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013878345489502 -- 2026-06-14 12:06:25.164[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011322975158691 -- 2026-06-14 12:07:16.837[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79300 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077140331268311 -- 2026-06-14 12:07:19.475[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79300 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080599784851074 -- 2026-06-14 12:07:48.915[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003291130065918 -- 2026-06-14 12:07:48.919[蔡易辰-2674] -- /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 = 79300 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093438625335693 -- 2026-06-14 12:07:50.875[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79300 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009009838104248 -- 2026-06-14 12:07:52.655[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79300 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024828910827637 -- 2026-06-14 12:07:55.345[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2674 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018689632415771 -- 2026-06-14 12:07:55.347[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017450094223022 -- 2026-06-14 12:07:55.390[蔡易辰-2674] -- /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 = 277 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020802021026611 -- 2026-06-14 12:07:55.392[蔡易辰-2674] -- /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(8843,8718) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019940853118896 -- 2026-06-14 12:07:57.947[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79300 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 = 79300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013589859008789 -- 2026-06-14 12:07:57.949[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79300 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020010471343994 -- 2026-06-14 12:07:57.982[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79300 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 = 79300 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001439094543457 -- 2026-06-14 12:07:57.983[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79300 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6654237 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013389587402344 -- 2026-06-14 12:07:57.985[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79300 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013461112976074 -- 2026-06-14 12:07:57.987[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79300 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087969303131104 -- 2026-06-14 12:08:13.925[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2674 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016880035400391 -- 2026-06-14 12:08:13.927[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013877153396606 -- 2026-06-14 12:08:13.966[蔡易辰-2674] -- /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 = 277 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016570091247559 -- 2026-06-14 12:08:13.968[蔡易辰-2674] -- /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(8843,8718) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091569423675537 -- 2026-06-14 12:08:16.448[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&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 = 2674 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027809143066406 -- 2026-06-14 12:08:16.451[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&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 = 2674 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022990703582764 -- 2026-06-14 12:08:16.454[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&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 = 8843 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094289779663086 -- 2026-06-14 12:09:51.512[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018560886383057 -- 2026-06-14 12:09:51.514[蔡易辰-2674] -- /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 = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001755952835083 -- 2026-06-14 12:09:51.516[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022073030471802 -- 2026-06-14 12:10:06.119[曾璟洋-2988] -- /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.0020618438720703 -- 2026-06-14 12:10:06.122[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027759075164795 -- 2026-06-14 12:10:06.125[曾璟洋-2988] -- /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 = 2988 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023419857025146 -- 2026-06-14 12:10:06.129[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019600391387939 -- 2026-06-14 12:10:06.131[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017903089523315 -- 2026-06-14 12:10:06.180[曾璟洋-2988] -- /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 = 522 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021440982818604 -- 2026-06-14 12:10:06.182[曾璟洋-2988] -- /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(8854,8704,8703) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081348419189453 -- 2026-06-14 12:10:45.191[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089530944824219 -- 2026-06-14 12:10:58.867[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084168910980225 -- 2026-06-14 12:11:32.956[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007796049118042 -- 2026-06-14 12:11:35.584[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082859992980957 -- 2026-06-14 12:11:45.422[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013424158096313 -- 2026-06-14 12:11:47.027[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086419582366943 -- 2026-06-14 12:11:51.667[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79301 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030438899993896 -- 2026-06-14 12:11:51.670[蔡易辰-2674] -- /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 = 79301 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016921997070312 -- 2026-06-14 12:11:53.831[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014189958572388 -- 2026-06-14 12:11:55.273[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79301 and order_id = 8843 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098559856414795 -- 2026-06-14 12:11:57.904[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2674 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017449855804443 -- 2026-06-14 12:11:57.906[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016812801361084 -- 2026-06-14 12:11:57.948[蔡易辰-2674] -- /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 = 277 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019750595092773 -- 2026-06-14 12:11:57.950[蔡易辰-2674] -- /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(8843,8718) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010360956192017 -- 2026-06-14 12:12:02.869[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79301 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 = 79301 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017471313476562 -- 2026-06-14 12:12:02.871[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035550594329834 -- 2026-06-14 12:12:02.905[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79301 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 = 79301 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018448829650879 -- 2026-06-14 12:12:02.907[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79301 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6654238 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017268657684326 -- 2026-06-14 12:12:02.909[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017149448394775 -- 2026-06-14 12:12:02.911[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8843&extrafareApply_id=79301 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096070766448975 -- 2026-06-14 12:12:46.052 -- /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.001823902130127 -- 2026-06-14 12:12:46.056 -- /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.0028839111328125 -- 2026-06-14 12:12:46.059 -- /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='ocoGM6ErsNJCjp6bVP78Fq7U6Ez0' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021438598632812 -- 2026-06-14 12:12:46.061 -- /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.0019781589508057 -- 2026-06-14 12:12:46.063[慕杨-2786] -- /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.0021770000457764 -- 2026-06-14 12:12:46.065[慕杨-2786] -- /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.0017619132995605 -- 2026-06-14 12:12:46.067[慕杨-2786] -- /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 = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024521350860596 -- 2026-06-14 12:12:46.070[慕杨-2786] -- /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 = 2786 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021378993988037 -- 2026-06-14 12:12:46.074[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2786 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017690658569336 -- 2026-06-14 12:12:46.076[慕杨-2786] -- /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 = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.037932872772217 -- 2026-06-14 12:12:46.147[慕杨-2786] -- /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 = 412 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019750595092773 -- 2026-06-14 12:12:46.149[慕杨-2786] -- /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(8856,8783,8709,8708) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021533966064453 -- 2026-06-14 12:12:49.396[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2674 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015480518341064 -- 2026-06-14 12:12:49.398[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016188621520996 -- 2026-06-14 12:12:49.425[蔡易辰-2674] -- /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 = 277 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015552043914795 -- 2026-06-14 12:12:49.427[蔡易辰-2674] -- /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(8843,8718) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0072431564331055 -- 2026-06-14 12:13:44.521[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8718&extrafareApply_id=79176 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 = 79176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001244068145752 -- 2026-06-14 12:13:44.523[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8718&extrafareApply_id=79176 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019309520721436 -- 2026-06-14 12:13:44.554[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8718&extrafareApply_id=79176 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 = 79176 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014369487762451 -- 2026-06-14 12:13:44.556[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8718&extrafareApply_id=79176 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6637796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012390613555908 -- 2026-06-14 12:13:44.557[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8718&extrafareApply_id=79176 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012409687042236 -- 2026-06-14 12:13:44.559[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8718&extrafareApply_id=79176 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023988008499146 -- 2026-06-14 14:56:22.241[曾璟洋-2988] -- /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.0019450187683105 -- 2026-06-14 14:56:22.243[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027809143066406 -- 2026-06-14 14:56:22.246[曾璟洋-2988] -- /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 = 2988 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022890567779541 -- 2026-06-14 14:56:22.250[曾璟洋-2988] -- /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 = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019049644470215 -- 2026-06-14 14:56:22.252[曾璟洋-2988] -- /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 = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019248008728027 -- 2026-06-14 14:56:22.303[曾璟洋-2988] -- /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 = 522 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025842189788818 -- 2026-06-14 14:56:22.306[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126&wx_header=1 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(8854,8704,8703) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013324022293091 -- 2026-06-14 17:48:57.932 -- /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.0089352130889893 -- 2026-06-14 17:48:58.233 -- /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.002316951751709 -- 2026-06-14 17:48:58.237 -- /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.0029740333557129 -- 2026-06-14 17:48:58.240 -- /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='ocoGM6FKu0CQrBRdvMco-5bL__kA' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017671585083008 -- 2026-06-14 17:48:58.242 -- /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.0019679069519043 -- 2026-06-14 17:48:58.244[杨志涛-2609] -- /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.0021920204162598 -- 2026-06-14 17:48:58.246[杨志涛-2609] -- /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.0017588138580322 -- 2026-06-14 17:48:58.248[杨志涛-2609] -- /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 = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025408267974854 -- 2026-06-14 17:48:58.251[杨志涛-2609] -- /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 = 2609 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022010803222656 -- 2026-06-14 17:48:58.255[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2609 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017499923706055 -- 2026-06-14 17:48:58.257[杨志涛-2609] -- /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 = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018614053726196 -- 2026-06-14 17:48:58.306[杨志涛-2609] -- /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 = 200 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019009113311768 -- 2026-06-14 17:48:58.308[杨志涛-2609] -- /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(8884,8802,8685) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019726991653442 -- 2026-06-14 17:49:03.687[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8802&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 = 2609 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031828880310059 -- 2026-06-14 17:49:03.690[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8802&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 = 2609 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041201114654541 -- 2026-06-14 17:49:03.695[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8802&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 = 8802 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017961978912354 -- 2026-06-14 17:50:19.682[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79307 and order_id = 8802 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022859573364258 -- 2026-06-14 17:50:19.685[杨志涛-2609] -- /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 = 8802 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018408298492432 -- 2026-06-14 17:50:19.687[杨志涛-2609] -- /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 = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017315864562988 -- 2026-06-14 17:50:58.862[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79307 and order_id = 8802 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079169273376465 -- 2026-06-14 17:51:01.093[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79307 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029041767120361 -- 2026-06-14 17:51:01.096[杨志涛-2609] -- /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 = 79307 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094060897827148 -- 2026-06-14 17:51:02.573[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79307 and order_id = 8802 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013351917266846 -- 2026-06-14 17:51:05.258[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2609 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014989376068115 -- 2026-06-14 17:51:05.260[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2609 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031508207321167 -- 2026-06-14 17:51:05.318[杨志涛-2609] -- /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 = 200 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018010139465332 -- 2026-06-14 17:51:05.320[杨志涛-2609] -- /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(8884,8802,8685) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099830627441406 -- 2026-06-14 17:51:17.334[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8802&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 = 2609 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032360553741455 -- 2026-06-14 17:51:17.338[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8802&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 = 2609 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046539306640625 -- 2026-06-14 17:51:17.343[杨志涛-2609] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8802&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 = 8802 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013040065765381 -- 2026-06-14 20:31:04.749 -- /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.0074989795684814 -- 2026-06-14 20:31:04.757 -- /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.0019638538360596 -- 2026-06-14 20:31:04.761 -- /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.0027151107788086 -- 2026-06-14 20:31:04.764 -- /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='ocoGM6E4uwfvEArPVO5xKkZIYlvc' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018010139465332 -- 2026-06-14 20:31:04.766 -- /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.0017101764678955 -- 2026-06-14 20:31:04.768[陈伦建-3003] -- /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.0019900798797607 -- 2026-06-14 20:31:04.770[陈伦建-3003] -- /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.0014970302581787 -- 2026-06-14 20:31:04.771[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023219585418701 -- 2026-06-14 20:31:04.774[陈伦建-3003] -- /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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018811225891113 -- 2026-06-14 20:31:04.777[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001488208770752 -- 2026-06-14 20:31:04.779[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018299102783203 -- 2026-06-14 20:31:04.828[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021119117736816 -- 2026-06-14 20:31:04.830[陈伦建-3003] -- /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(8810,8706) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0072848796844482 -- 2026-06-14 20:31:06.567[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025570392608643 -- 2026-06-14 20:31:06.570[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037569999694824 -- 2026-06-14 20:31:06.574[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 8810 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014370918273926 -- 2026-06-14 20:31:42.017[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79308 and order_id = 8810 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021700859069824 -- 2026-06-14 20:31:42.020[陈伦建-3003] -- /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 = 8810 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016860961914062 -- 2026-06-14 20:31:42.022[陈伦建-3003] -- /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 = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021951913833618 -- 2026-06-14 20:31:48.680[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79308 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002802848815918 -- 2026-06-14 20:31:48.683[陈伦建-3003] -- /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 = 79308 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011469125747681 -- 2026-06-14 20:32:02.980[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79308 and order_id = 8810 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015356063842773 -- 2026-06-14 20:32:05.254[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 3003 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018160343170166 -- 2026-06-14 20:32:05.256[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017193078994751 -- 2026-06-14 20:32:05.299[陈伦建-3003] -- /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 = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024480819702148 -- 2026-06-14 20:32:05.301[陈伦建-3003] -- /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(8810,8706) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019570112228394 -- 2026-06-14 20:32:10.678[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031909942626953 -- 2026-06-14 20:32:10.681[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 3003 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041251182556152 -- 2026-06-14 20:32:10.686[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8810&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 = 8810 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081570148468018 -- 2026-06-14 21:58:17.666 -- /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.0087130069732666 -- 2026-06-14 21:58:18.022 -- /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.0018348693847656 -- 2026-06-14 21:58:18.025 -- /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.0026810169219971 -- 2026-06-14 21:58:18.028 -- /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='ocoGM6ErsNJCjp6bVP78Fq7U6Ez0' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017490386962891 -- 2026-06-14 21:58:18.030 -- /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.0019519329071045 -- 2026-06-14 21:58:18.032[慕杨-2786] -- /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.0021250247955322 -- 2026-06-14 21:58:18.034[慕杨-2786] -- /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.0017411708831787 -- 2026-06-14 21:58:18.036[慕杨-2786] -- /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 = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025899410247803 -- 2026-06-14 21:58:18.039[慕杨-2786] -- /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 = 2786 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002161979675293 -- 2026-06-14 21:58:18.043[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2786 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017068386077881 -- 2026-06-14 21:58:18.045[慕杨-2786] -- /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 = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018078088760376 -- 2026-06-14 21:58:18.095[慕杨-2786] -- /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 = 412 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002202033996582 -- 2026-06-14 21:58:18.097[慕杨-2786] -- /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(8856,8783,8709,8708) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022706031799316 -- 2026-06-14 22:53:42.847 -- /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.0018510818481445 -- 2026-06-14 22:53:42.850 -- /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.0029408931732178 -- 2026-06-14 22:53:42.853 -- /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.0018150806427002 -- 2026-06-14 22:53:42.855 -- /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.002004861831665 -- 2026-06-14 22:53:42.857[唐桂-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.0018680095672607 -- 2026-06-14 22:53:42.859[唐桂-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.0017430782318115 -- 2026-06-14 22:53:42.861[唐桂-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.0025589466094971 -- 2026-06-14 22:53:42.864[唐桂-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.0022268295288086 -- 2026-06-14 22:53:42.868[唐桂-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.0017769336700439 -- 2026-06-14 22:53:42.870[唐桂-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.020304918289185 -- 2026-06-14 22:53:42.921[唐桂-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/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022931098937988 -- 2026-06-14 22:53:42.923[唐桂-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(8855,8811,8782,8707) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079269409179688 -- 2026-06-14 22:53:57.429[唐桂-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.0014381408691406 -- 2026-06-14 22:53:57.431[唐桂-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.0014081001281738 -- 2026-06-14 22:53:57.432[唐桂-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.001399040222168 -- 2026-06-14 22:53:57.436[唐桂-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.0013940334320068 -- 2026-06-14 22:53:57.437[唐桂-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.0015170574188232 -- 2026-06-14 22:53:57.464[唐桂-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/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014219284057617 -- 2026-06-14 22:53:57.465[唐桂-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(8855,8811,8782,8707) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023682117462158 -- 2026-06-14 23:12:14.693 -- /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.012682914733887 -- 2026-06-14 23:12:16.102[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22%7D&appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014510154724121 -- 2026-06-14 23:12:16.104[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22%7D&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.0014550685882568 -- 2026-06-14 23:12:16.105[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22%7D&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.0019369125366211 -- 2026-06-14 23:12:16.109[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22%7D&appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2526 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015339851379395 -- 2026-06-14 23:12:16.111[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22%7D&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.017205953598022 -- 2026-06-14 23:12:16.158[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22%7D&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/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020198822021484 -- 2026-06-14 23:12:16.161[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22%7D&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(8835,8740,8686) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01024317741394 -- 2026-06-14 23:12:22.970[胡晓露-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.0015039443969727 -- 2026-06-14 23:12:22.972[胡晓露-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.027404069900513 -- 2026-06-14 23:12:23.024[胡晓露-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/05/01' AND o.order_date <= '2026/06/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022828578948975 -- 2026-06-14 23:12:23.026[胡晓露-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(8835,8740,8686,8635,8545,8467,8443,8313,8232,8179,8092,8091,7998,7874,7781,7716,7579,7539,7411,7341) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015089988708496 -- 2026-06-14 23:12:37.631[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8545&extrafareApply_id=78964 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 = 78964 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015571117401123 -- 2026-06-14 23:12:37.633[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8545&extrafareApply_id=78964 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026009082794189 -- 2026-06-14 23:12:37.665[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8545&extrafareApply_id=78964 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 = 78964 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017218589782715 -- 2026-06-14 23:12:37.667[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8545&extrafareApply_id=78964 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6621031 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015459060668945 -- 2026-06-14 23:12:37.669[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8545&extrafareApply_id=78964 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001582145690918 -- 2026-06-14 23:12:37.671[胡晓露-2526] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8545&extrafareApply_id=78964 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2526 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091989040374756 -- 2026-06-14 23:12:43.872[胡晓露-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.0016632080078125 -- 2026-06-14 23:12:43.874[胡晓露-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.0016450881958008 -- 2026-06-14 23:12:43.876[胡晓露-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.0016419887542725 -- 2026-06-14 23:12:43.879[胡晓露-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.0016438961029053 -- 2026-06-14 23:12:43.881[胡晓露-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.0017828941345215 -- 2026-06-14 23:12:43.908[胡晓露-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/07' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016510486602783 -- 2026-06-14 23:12:43.910[胡晓露-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(8835,8740,8686) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011834144592285 -- 2026-06-14 23:12:48.980[胡晓露-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.0017051696777344 -- 2026-06-14 23:12:48.982[胡晓露-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.018615961074829 -- 2026-06-14 23:12:49.025[胡晓露-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/14 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001986026763916 -- 2026-06-14 23:12:49.027[胡晓露-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(8835,8740,8686,8635,8545,8467) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------