Time: 0.0098481178283691 -- 2026-06-27 02:42:17.538 -- /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.0090620517730713 -- 2026-06-27 02:42:17.619 -- /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.0092668533325195 -- 2026-06-27 04:16:08.795 -- /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.008613109588623 -- 2026-06-27 04:16:19.990 -- /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.010178089141846 -- 2026-06-27 09:04:08.200 -- /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.0078129768371582 -- 2026-06-27 09:04:08.319 -- /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.0021049976348877 -- 2026-06-27 09:04:08.323 -- /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.0047149658203125 -- 2026-06-27 09:04:08.328 -- /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.0016038417816162 -- 2026-06-27 09:04:08.329 -- /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.0017590522766113 -- 2026-06-27 09:04:08.331[蔡易辰-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.0019400119781494 -- 2026-06-27 09:04:08.333[蔡易辰-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.0015480518341064 -- 2026-06-27 09:04:08.335[蔡易辰-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.0051140785217285 -- 2026-06-27 09:04:08.340[蔡易辰-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.0028409957885742 -- 2026-06-27 09:04:08.406[蔡易辰-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.0015370845794678 -- 2026-06-27 09:04:08.408[蔡易辰-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.010849952697754 -- 2026-06-27 09:04:08.452[蔡易辰-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016329288482666 -- 2026-06-27 09:04:08.454[蔡易辰-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(9153,9126,9072) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011704921722412 -- 2026-06-27 09:04:17.286[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9126&extrafareApply_id=79698 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 = 79698 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019009113311768 -- 2026-06-27 09:04:17.288[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9126&extrafareApply_id=79698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002932071685791 -- 2026-06-27 09:04:17.321[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9126&extrafareApply_id=79698 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 = 79698 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020060539245605 -- 2026-06-27 09:04:17.323[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9126&extrafareApply_id=79698 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6700221 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018911361694336 -- 2026-06-27 09:04:17.325[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9126&extrafareApply_id=79698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019299983978271 -- 2026-06-27 09:04:17.351[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9126&extrafareApply_id=79698 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085749626159668 -- 2026-06-27 09:04:35.029[蔡易辰-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.0016529560089111 -- 2026-06-27 09:04:35.031[蔡易辰-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.0021839141845703 -- 2026-06-27 09:04:35.034[蔡易辰-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.0016911029815674 -- 2026-06-27 09:04:35.037[蔡易辰-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.0016300678253174 -- 2026-06-27 09:04:35.039[蔡易辰-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.0033807754516602 -- 2026-06-27 09:04:35.067[蔡易辰-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017600059509277 -- 2026-06-27 09:04:35.069[蔡易辰-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(9153,9126,9072) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098569393157959 -- 2026-06-27 09:04:39.038[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&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.0029029846191406 -- 2026-06-27 09:04:39.041[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&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.002485990524292 -- 2026-06-27 09:04:39.044[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&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 = 9153 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094830989837646 -- 2026-06-27 09:07:35.124[蔡易辰-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.0018219947814941 -- 2026-06-27 09:07:35.126[蔡易辰-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.0027058124542236 -- 2026-06-27 09:07:35.129[蔡易辰-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.0021791458129883 -- 2026-06-27 09:07:35.133[蔡易辰-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.001788854598999 -- 2026-06-27 09:07:35.135[蔡易辰-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.024831056594849 -- 2026-06-27 09:07:35.184[蔡易辰-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022461414337158 -- 2026-06-27 09:07:35.187[蔡易辰-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(9153,9126,9072) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095889568328857 -- 2026-06-27 09:07:52.118[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&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.0029041767120361 -- 2026-06-27 09:07:52.121[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&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.0023369789123535 -- 2026-06-27 09:07:52.123[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&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 = 9153 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01844310760498 -- 2026-06-27 09:09:12.021[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79768 and order_id = 9153 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019152164459229 -- 2026-06-27 09:09:12.023[蔡易辰-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 = 9153 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018138885498047 -- 2026-06-27 09:09:12.025[蔡易辰-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.0097799301147461 -- 2026-06-27 09:09:34.755[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79768 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031349658966064 -- 2026-06-27 09:09:34.758[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 35.00 where extrafareApply_id = 79768 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012612104415894 -- 2026-06-27 09:09:37.999[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79768 and order_id = 9153 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0071890354156494 -- 2026-06-27 09:10:00.314[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79768 and order_id = 9153 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082941055297852 -- 2026-06-27 09:10:02.365[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79768 and order_id = 9153 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021997928619385 -- 2026-06-27 09:10:04.984[蔡易辰-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.0018439292907715 -- 2026-06-27 09:10:04.986[蔡易辰-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.0043230056762695 -- 2026-06-27 09:10:05.016[蔡易辰-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020451545715332 -- 2026-06-27 09:10:05.018[蔡易辰-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(9153,9126,9072) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020821094512939 -- 2026-06-27 09:10:08.982[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 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 = 79748 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017158985137939 -- 2026-06-27 09:10:08.984[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026199817657471 -- 2026-06-27 09:10:09.017[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 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 = 79748 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017549991607666 -- 2026-06-27 09:10:09.019[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6708080 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016241073608398 -- 2026-06-27 09:10:09.021[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016241073608398 -- 2026-06-27 09:10:09.023[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096619129180908 -- 2026-06-27 10:26:27.196 -- /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.020400047302246 -- 2026-06-27 10:26:27.821 -- /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.002086877822876 -- 2026-06-27 10:26:27.825 -- /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.00335693359375 -- 2026-06-27 10:26:27.829 -- /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.0018510818481445 -- 2026-06-27 10:26:27.831 -- /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.0017328262329102 -- 2026-06-27 10:26:27.833[慕杨-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.0019340515136719 -- 2026-06-27 10:26:27.835[慕杨-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.0014770030975342 -- 2026-06-27 10:26:27.836[慕杨-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.0023529529571533 -- 2026-06-27 10:26:27.839[慕杨-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.0015418529510498 -- 2026-06-27 10:26:27.842[慕杨-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.0015039443969727 -- 2026-06-27 10:26:27.844[慕杨-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.0223548412323 -- 2026-06-27 10:26:27.897[慕杨-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019800662994385 -- 2026-06-27 10:26:27.899[慕杨-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(9117,9116) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097770690917969 -- 2026-06-27 10:26:51.009 -- /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.0093448162078857 -- 2026-06-27 10:26:51.440[慕杨-2786] -- /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.0017189979553223 -- 2026-06-27 10:26:51.441[慕杨-2786] -- /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 = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024919509887695 -- 2026-06-27 10:26:51.444[慕杨-2786] -- /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 = 2786 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028259754180908 -- 2026-06-27 10:26:51.449[慕杨-2786] -- /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 = 2786 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017040014266968 -- 2026-06-27 10:26:51.466[慕杨-2786] -- /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 = 20908 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.0068418979644775 -- 2026-06-27 10:26:51.473[慕杨-2786] -- /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.011111974716187 -- 2026-06-27 10:27:23.858[慕杨-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.0015599727630615 -- 2026-06-27 10:27:23.860[慕杨-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.0024380683898926 -- 2026-06-27 10:27:23.862[慕杨-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.0019960403442383 -- 2026-06-27 10:27:23.866[慕杨-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.0016350746154785 -- 2026-06-27 10:27:23.868[慕杨-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.023462057113647 -- 2026-06-27 10:27:23.917[慕杨-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002140998840332 -- 2026-06-27 10:27:23.919[慕杨-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(9117,9116) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021369934082031 -- 2026-06-27 10:27:29.833[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9116&extrafareApply_id=79641 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 = 79641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017378330230713 -- 2026-06-27 10:27:29.835[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9116&extrafareApply_id=79641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044040679931641 -- 2026-06-27 10:27:29.871[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9116&extrafareApply_id=79641 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 = 79641 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018630027770996 -- 2026-06-27 10:27:29.873[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9116&extrafareApply_id=79641 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6691454 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017387866973877 -- 2026-06-27 10:27:29.875[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9116&extrafareApply_id=79641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001708984375 -- 2026-06-27 10:27:29.877[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9116&extrafareApply_id=79641 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014430999755859 -- 2026-06-27 10:28:12.462[慕杨-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.0016899108886719 -- 2026-06-27 10:28:12.464[慕杨-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.0024387836456299 -- 2026-06-27 10:28:12.466[慕杨-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.002032995223999 -- 2026-06-27 10:28:12.470[慕杨-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.0016810894012451 -- 2026-06-27 10:28:12.472[慕杨-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.02328896522522 -- 2026-06-27 10:28:12.520[慕杨-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022749900817871 -- 2026-06-27 10:28:12.523[慕杨-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(9117,9116) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020417928695679 -- 2026-06-27 10:30:52.824[蔡易辰-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.0016601085662842 -- 2026-06-27 10:30:52.826[蔡易辰-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.0037660598754883 -- 2026-06-27 10:30:52.859[蔡易辰-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017869472503662 -- 2026-06-27 10:30:52.861[蔡易辰-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(9153,9126,9072) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02180004119873 -- 2026-06-27 10:31:41.224[慕杨-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.0016138553619385 -- 2026-06-27 10:31:41.225[慕杨-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.0024309158325195 -- 2026-06-27 10:31:41.228[慕杨-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.0019569396972656 -- 2026-06-27 10:31:41.231[慕杨-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.0015840530395508 -- 2026-06-27 10:31:41.233[慕杨-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.024395942687988 -- 2026-06-27 10:31:41.283[慕杨-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016899108886719 -- 2026-06-27 10:31:41.285[慕杨-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(9117,9116) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094649791717529 -- 2026-06-27 10:44:49.944 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017569065093994 -- 2026-06-27 10:44:49.948 -- /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.0029788017272949 -- 2026-06-27 10:44:49.951 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6B9dXa9qNObDJcWbpTe3RBQ' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017111301422119 -- 2026-06-27 10:44:49.953 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019011497497559 -- 2026-06-27 10:44:49.955[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002216100692749 -- 2026-06-27 10:44:49.957[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017149448394775 -- 2026-06-27 10:44:49.959[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025460720062256 -- 2026-06-27 10:44:49.962[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2753 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020620822906494 -- 2026-06-27 10:44:49.965[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2753 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016920566558838 -- 2026-06-27 10:44:49.967[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063209533691406 -- 2026-06-27 10:44:50.004[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 378 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018479824066162 -- 2026-06-27 10:44:50.006[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9151,9118,9074) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088541507720947 -- 2026-06-27 11:25:43.223 -- /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.01202917098999 -- 2026-06-27 11:25:43.893 -- /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.0023331642150879 -- 2026-06-27 11:25:43.897 -- /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.0027039051055908 -- 2026-06-27 11:25:43.899 -- /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='ocoGM6DyOK431eWqAPMnb381Ce9k' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099828243255615 -- 2026-06-27 11:30:59.444 -- /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.0019440650939941 -- 2026-06-27 11:30:59.447 -- /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.003101110458374 -- 2026-06-27 11:30:59.451 -- /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.0019290447235107 -- 2026-06-27 11:30:59.453 -- /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.002068042755127 -- 2026-06-27 11:30:59.455[唐桂-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.0022759437561035 -- 2026-06-27 11:30:59.457[唐桂-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.0018770694732666 -- 2026-06-27 11:30:59.459[唐桂-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.0038740634918213 -- 2026-06-27 11:30:59.463[唐桂-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.002295970916748 -- 2026-06-27 11:30:59.467[唐桂-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.0018689632415771 -- 2026-06-27 11:30:59.469[唐桂-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.005713939666748 -- 2026-06-27 11:30:59.516[唐桂-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019659996032715 -- 2026-06-27 11:30:59.518[唐桂-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(9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011529922485352 -- 2026-06-27 12:30:48.010 -- /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.0065610408782959 -- 2026-06-27 12:30:48.290 -- /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.001802921295166 -- 2026-06-27 12:30:48.294 -- /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.0022189617156982 -- 2026-06-27 12:30:48.296 -- /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='ocoGM6GzGeeQ8S8ZiS_8ELLDG1H4' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078060626983643 -- 2026-06-27 13:12:11.559 -- /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.0015590190887451 -- 2026-06-27 13:12:11.562 -- /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.0024819374084473 -- 2026-06-27 13:12:11.564 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6F-X6cItc7cy7G4lIeZtRtI' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001845121383667 -- 2026-06-27 13:12:11.566 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select buzSystem_id from dbsys.sys_acctCH_buzSystem where acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016939640045166 -- 2026-06-27 13:12:11.568[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019121170043945 -- 2026-06-27 13:12:11.570[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014870166778564 -- 2026-06-27 13:12:11.572[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019879341125488 -- 2026-06-27 13:12:11.574[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015218257904053 -- 2026-06-27 13:12:11.577[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3124 and acct_id = 49 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014958381652832 -- 2026-06-27 13:12:11.579[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01824688911438 -- 2026-06-27 13:12:11.632[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=49 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 555 OR IFNULL(oe_f.fleet_org_id,1) IN(1,520) ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016651153564453 -- 2026-06-27 13:12:11.634[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9144,9105,9103) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088720321655273 -- 2026-06-27 13:12:54.739[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&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 = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029308795928955 -- 2026-06-27 13:12:54.742[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&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 = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041260719299316 -- 2026-06-27 13:12:54.746[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&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 = 9103 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088710784912109 -- 2026-06-27 13:14:08.682[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015509128570557 -- 2026-06-27 13:14:08.683[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015439987182617 -- 2026-06-27 13:14:08.685[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015640258789062 -- 2026-06-27 13:14:08.688[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3124 and acct_id = 49 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015430450439453 -- 2026-06-27 13:14:08.690[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016419887542725 -- 2026-06-27 13:14:08.717[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=49 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 555 OR IFNULL(oe_f.fleet_org_id,1) IN(1,520) ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001554012298584 -- 2026-06-27 13:14:08.719[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9144,9105,9103) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01001501083374 -- 2026-06-27 13:14:11.153[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&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 = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031139850616455 -- 2026-06-27 13:14:11.156[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&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 = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042681694030762 -- 2026-06-27 13:14:11.161[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&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 = 9103 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023896932601929 -- 2026-06-27 13:18:48.878[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79777 and order_id = 9103 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023159980773926 -- 2026-06-27 13:18:48.880[程刚-3124] -- /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 = 9103 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018270015716553 -- 2026-06-27 13:18:48.882[程刚-3124] -- /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 = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023668050765991 -- 2026-06-27 13:18:54.098[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79777 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037860870361328 -- 2026-06-27 13:18:54.102[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 200.00 where extrafareApply_id = 79777 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013807058334351 -- 2026-06-27 13:19:22.665[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79777 and order_id = 9103 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090889930725098 -- 2026-06-27 13:19:24.647[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79777 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029749870300293 -- 2026-06-27 13:19:24.650[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 950.00 where extrafareApply_id = 79777 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090839862823486 -- 2026-06-27 13:20:08.879[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017690658569336 -- 2026-06-27 13:20:08.881[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024049282073975 -- 2026-06-27 13:20:08.884[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 3124 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022470951080322 -- 2026-06-27 13:20:08.888[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 3124 and acct_id = 49 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016558170318604 -- 2026-06-27 13:20:08.890[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024555206298828 -- 2026-06-27 13:20:08.940[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=49 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 555 OR IFNULL(oe_f.fleet_org_id,1) IN(1,520) ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019049644470215 -- 2026-06-27 13:20:08.942[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9144,9105,9103) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01128888130188 -- 2026-06-27 13:20:12.984[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79777 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017640590667725 -- 2026-06-27 13:20:12.986[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037190914154053 -- 2026-06-27 13:20:13.021[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79777 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017440319061279 -- 2026-06-27 13:20:13.023[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6714120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017359256744385 -- 2026-06-27 13:20:13.025[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015769958496094 -- 2026-06-27 13:21:09.576[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79777 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001533031463623 -- 2026-06-27 13:21:09.577[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021750926971436 -- 2026-06-27 13:21:09.610[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79777 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015249252319336 -- 2026-06-27 13:21:09.612[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6714120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015051364898682 -- 2026-06-27 13:21:09.613[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018831014633179 -- 2026-06-27 13:21:13.589[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79777 and order_id = 9103 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097479820251465 -- 2026-06-27 13:21:16.056[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 3124 and acct_id = 49 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017340183258057 -- 2026-06-27 13:21:16.058[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02396297454834 -- 2026-06-27 13:21:16.107[程刚-3124] -- /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=49 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 555 OR IFNULL(oe_f.fleet_org_id,1) IN(1,520) ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019800662994385 -- 2026-06-27 13:21:16.109[程刚-3124] -- /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(9144,9105,9103) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010437965393066 -- 2026-06-27 13:21:38.773[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79777 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016870498657227 -- 2026-06-27 13:21:38.775[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041139125823975 -- 2026-06-27 13:21:38.808[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79777 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016682147979736 -- 2026-06-27 13:21:38.810[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6714120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016689300537109 -- 2026-06-27 13:21:38.812[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016489028930664 -- 2026-06-27 13:21:38.814[程刚-3124] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9103&extrafareApply_id=79777 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3124 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01012396812439 -- 2026-06-27 14:39:11.909 -- /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.0090539455413818 -- 2026-06-27 14:39:12.269 -- /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.0018560886383057 -- 2026-06-27 14:39:12.272 -- /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.0027790069580078 -- 2026-06-27 14:39:12.275 -- /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.00205397605896 -- 2026-06-27 14:39:12.277 -- /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.0020380020141602 -- 2026-06-27 14:39:12.280[蔡易辰-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.0021810531616211 -- 2026-06-27 14:39:12.282[蔡易辰-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.0017120838165283 -- 2026-06-27 14:39:12.284[蔡易辰-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.0025379657745361 -- 2026-06-27 14:39:12.286[蔡易辰-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.0020840167999268 -- 2026-06-27 14:39:12.290[蔡易辰-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.0017030239105225 -- 2026-06-27 14:39:12.292[蔡易辰-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.019643068313599 -- 2026-06-27 14:39:12.343[蔡易辰-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019829273223877 -- 2026-06-27 14:39:12.345[蔡易辰-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(9153,9126,9072) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022589921951294 -- 2026-06-27 14:39:16.957[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 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 = 79748 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001694917678833 -- 2026-06-27 14:39:16.959[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040571689605713 -- 2026-06-27 14:39:16.995[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 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 = 79748 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018119812011719 -- 2026-06-27 14:39:16.997[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6708080 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016849040985107 -- 2026-06-27 14:39:16.999[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016779899597168 -- 2026-06-27 14:39:17.001[蔡易辰-2674] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9153&extrafareApply_id=79748 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015743970870972 -- 2026-06-27 16:46:57.399 -- /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.010439872741699 -- 2026-06-27 16:46:58.026 -- /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.0022461414337158 -- 2026-06-27 16:46:58.030 -- /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.0029220581054688 -- 2026-06-27 16:46:58.033 -- /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='ocoGM6En0FVw6i-Y5Q2X1t2Tcl2I' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021059513092041 -- 2026-06-27 16:46:58.035 -- /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.0025990009307861 -- 2026-06-27 16:46:58.038[周庭龙-2420] -- /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.0021069049835205 -- 2026-06-27 16:46:58.040[周庭龙-2420] -- /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.0017080307006836 -- 2026-06-27 16:46:58.042[周庭龙-2420] -- /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 = 2420 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024538040161133 -- 2026-06-27 16:46:58.045[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020508766174316 -- 2026-06-27 16:46:58.048[周庭龙-2420] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2420 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016810894012451 -- 2026-06-27 16:46:58.050[周庭龙-2420] -- /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 = 2420 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039911270141602 -- 2026-06-27 16:46:58.085[周庭龙-2420] -- /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 = 34 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018370151519775 -- 2026-06-27 16:46:58.087[周庭龙-2420] -- /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(9174,9152,9125) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011275053024292 -- 2026-06-27 16:48:09.349 -- /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.008882999420166 -- 2026-06-27 16:48:09.615[周庭龙-2420] -- /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.0016598701477051 -- 2026-06-27 16:48:09.617[周庭龙-2420] -- /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 = 2420 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023231506347656 -- 2026-06-27 16:48:09.619[周庭龙-2420] -- /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 = 2420 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030460357666016 -- 2026-06-27 16:48:09.624[周庭龙-2420] -- /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 = 2420 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059630870819092 -- 2026-06-27 16:48:09.630[周庭龙-2420] -- /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 = 19998 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.0027201175689697 -- 2026-06-27 16:48:09.633[周庭龙-2420] -- /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.019588947296143 -- 2026-06-27 19:58:42.594[师利仙-2472] -- /buz/tsl/index.php/tsloprt/driver_salary_list?para={%22event%22:%22driver_salary_edit%22,%22statement_ids%22:%226637%22}&event=driver_salary_edit&statement_ids=6637 SELECT i.*,w.work_no no,w.work_id,DATE_FORMAT(o.order_date,'%Y-%m-%d %H:%i') order_date, w.work_type_id,w_ot.otherWork_type_id, w.notes,c.shortname driver_name, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon,w.carrier_id,w.carrier_id customer_id,o.route_name,o.order_no,o.order_id, o.truck_no FROM dbtsl.tsl_invoice i LEFT JOIN dbsys.sys_customer c ON i.inv_cust_id = c.customer_id LEFT JOIN dbtsl.tsl_work w ON i.source_tblName = 'dbtsl.tsl_work' and i.source_fldVal = w.work_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON w_ot.work_id = w.work_id LEFT JOIN dbtsl.tsl_workch_order w_o ON w_o.work_id = w.work_id LEFT JOIN dbtsl.v_ftl_order o ON o.order_id = w_o.order_id WHERE i.statement_id in(6637) order by o.order_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010845899581909 -- 2026-06-27 19:59:06.693[师利仙-2472] -- /buz/tsl/index.php/tsloprt/driver_salary_list?para={%22event%22:%22driver_salary_edit%22,%22statement_ids%22:%226637%22}&event=driver_salary_edit&statement_ids=6637 SELECT i.*,w.work_no no,w.work_id,DATE_FORMAT(o.order_date,'%Y-%m-%d %H:%i') order_date, w.work_type_id,w_ot.otherWork_type_id, w.notes,c.shortname driver_name, DATE_FORMAT(w.createdon,'%Y-%m-%d') createdon,w.carrier_id,w.carrier_id customer_id,o.route_name,o.order_no,o.order_id, o.truck_no FROM dbtsl.tsl_invoice i LEFT JOIN dbsys.sys_customer c ON i.inv_cust_id = c.customer_id LEFT JOIN dbtsl.tsl_work w ON i.source_tblName = 'dbtsl.tsl_work' and i.source_fldVal = w.work_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON w_ot.work_id = w.work_id LEFT JOIN dbtsl.tsl_workch_order w_o ON w_o.work_id = w.work_id LEFT JOIN dbtsl.v_ftl_order o ON o.order_id = w_o.order_id WHERE i.statement_id in(6637) order by o.order_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074598789215088 -- 2026-06-27 19:59:31.097 -- /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.0084958076477051 -- 2026-06-27 19:59:31.536 -- /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.0016100406646729 -- 2026-06-27 19:59:31.539 -- /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.0016071796417236 -- 2026-06-27 19:59:31.541 -- /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='ocoGM6EjIafJqX2jNjvJnTInvcPY' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015869140625 -- 2026-06-27 19:59:31.543 -- /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.0019819736480713 -- 2026-06-27 19:59:31.545[师利仙-2472] -- /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.0021929740905762 -- 2026-06-27 19:59:31.547[师利仙-2472] -- /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.0017070770263672 -- 2026-06-27 19:59:31.549[师利仙-2472] -- /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 = 2472 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024640560150146 -- 2026-06-27 19:59:31.552[师利仙-2472] -- /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 = 2472 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027987957000732 -- 2026-06-27 19:59:31.556[师利仙-2472] -- /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 = 2472 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047011375427246 -- 2026-06-27 19:59:31.561[师利仙-2472] -- /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 = 20049 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.0027389526367188 -- 2026-06-27 19:59:31.564[师利仙-2472] -- /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.010152816772461 -- 2026-06-27 20:20:31.820 -- /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.0081331729888916 -- 2026-06-27 20:20:31.997 -- /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.0021600723266602 -- 2026-06-27 20:20:32.001 -- /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.0025229454040527 -- 2026-06-27 20:20:32.004 -- /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.0016160011291504 -- 2026-06-27 20:20:32.006 -- /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.0018289089202881 -- 2026-06-27 20:20:32.008[陈伦建-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.0019850730895996 -- 2026-06-27 20:20:32.010[陈伦建-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.0015799999237061 -- 2026-06-27 20:20:32.011[陈伦建-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.0024430751800537 -- 2026-06-27 20:20:32.014[陈伦建-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.0020501613616943 -- 2026-06-27 20:20:32.018[陈伦建-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.0015799999237061 -- 2026-06-27 20:20:32.019[陈伦建-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.018525123596191 -- 2026-06-27 20:20:32.070[陈伦建-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010601997375488 -- 2026-06-27 20:20:36.292[陈伦建-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.0017499923706055 -- 2026-06-27 20:20:36.294[陈伦建-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.047527074813843 -- 2026-06-27 20:20:36.368[陈伦建-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/06/04' AND o.order_date <= '2026/06/27 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002687931060791 -- 2026-06-27 20:20:36.371[陈伦建-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(8967,8931,8810,8706,8705,8590) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025315999984741 -- 2026-06-27 20:20:37.408[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8931&extrafareApply_id=79342 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 = 79342 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018699169158936 -- 2026-06-27 20:20:37.410[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8931&extrafareApply_id=79342 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024349689483643 -- 2026-06-27 20:20:37.443[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8931&extrafareApply_id=79342 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 = 79342 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001945972442627 -- 2026-06-27 20:20:37.445[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8931&extrafareApply_id=79342 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6660009 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018458366394043 -- 2026-06-27 20:20:37.447[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8931&extrafareApply_id=79342 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018579959869385 -- 2026-06-27 20:20:37.450[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8931&extrafareApply_id=79342 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 3003 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082690715789795 -- 2026-06-27 20:20:39.394[陈伦建-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.0014328956604004 -- 2026-06-27 20:20:39.395[陈伦建-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.001413106918335 -- 2026-06-27 20:20:39.397[陈伦建-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.0014188289642334 -- 2026-06-27 20:20:39.400[陈伦建-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.0013999938964844 -- 2026-06-27 20:20:39.401[陈伦建-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.0015048980712891 -- 2026-06-27 20:20:39.428[陈伦建-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011101961135864 -- 2026-06-27 21:13:15.912 -- /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.0087969303131104 -- 2026-06-27 21:13:17.153 -- /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.0018680095672607 -- 2026-06-27 21:13:17.156 -- /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.0027179718017578 -- 2026-06-27 21:13:17.159 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6NdOH57OC4zVYQ7haBQ2Tt4' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017540454864502 -- 2026-06-27 21:13:17.161 -- /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.0019609928131104 -- 2026-06-27 21:13:17.163[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022549629211426 -- 2026-06-27 21:13:17.166[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017158985137939 -- 2026-06-27 21:13:17.167[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025038719177246 -- 2026-06-27 21:13:17.170[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2501 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021708011627197 -- 2026-06-27 21:13:17.174[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2501 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017321109771729 -- 2026-06-27 21:13:17.176[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0068490505218506 -- 2026-06-27 21:13:17.213[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 112 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00229811668396 -- 2026-06-27 21:13:17.215[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9163,9123,9037) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009544849395752 -- 2026-06-27 21:13:24.095[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9123&extrafareApply_id=79716 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 = 79716 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014550685882568 -- 2026-06-27 21:13:24.096[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9123&extrafareApply_id=79716 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041859149932861 -- 2026-06-27 21:13:24.133[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9123&extrafareApply_id=79716 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 = 79716 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015439987182617 -- 2026-06-27 21:13:24.135[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9123&extrafareApply_id=79716 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6702239 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014090538024902 -- 2026-06-27 21:13:24.136[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9123&extrafareApply_id=79716 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014128684997559 -- 2026-06-27 21:13:24.138[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9123&extrafareApply_id=79716 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016948938369751 -- 2026-06-27 21:13:28.282[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&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 = 2501 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032241344451904 -- 2026-06-27 21:13:28.286[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&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 = 2501 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004371166229248 -- 2026-06-27 21:13:28.290[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&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 = 9163 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097711086273193 -- 2026-06-27 21:13:33.446[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79788 and order_id = 9163 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021929740905762 -- 2026-06-27 21:13:33.449[肖路路-2501] -- /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 = 9163 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017440319061279 -- 2026-06-27 21:13:33.450[肖路路-2501] -- /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 = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083470344543457 -- 2026-06-27 21:17:04.089[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79788 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035390853881836 -- 2026-06-27 21:17:04.092[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 115.00 where extrafareApply_id = 79788 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074739456176758 -- 2026-06-27 21:17:16.001[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79788 and order_id = 9163 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01008415222168 -- 2026-06-27 21:17:19.006[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2501 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018630027770996 -- 2026-06-27 21:17:19.008[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005918025970459 -- 2026-06-27 21:17:19.039[肖路路-2501] -- /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 = 112 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020301342010498 -- 2026-06-27 21:17:19.042[肖路路-2501] -- /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(9163,9123,9037) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096909999847412 -- 2026-06-27 21:17:21.790[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&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 = 2501 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032479763031006 -- 2026-06-27 21:17:21.794[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&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 = 2501 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044121742248535 -- 2026-06-27 21:17:21.798[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9163&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 = 9163 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079829692840576 -- 2026-06-27 21:18:54.134[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014650821685791 -- 2026-06-27 21:18:54.136[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021779537200928 -- 2026-06-27 21:18:54.138[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2501 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013659000396729 -- 2026-06-27 21:18:54.142[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2501 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013411045074463 -- 2026-06-27 21:18:54.143[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2501 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014660358428955 -- 2026-06-27 21:18:54.171[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 112 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013749599456787 -- 2026-06-27 21:18:54.172[肖路路-2501] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9163,9123,9037) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088720321655273 -- 2026-06-27 21:23:53.820 -- /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.0017549991607666 -- 2026-06-27 21:23:53.823 -- /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.0025720596313477 -- 2026-06-27 21:23:53.826 -- /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.0017409324645996 -- 2026-06-27 21:23:53.828 -- /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.0019230842590332 -- 2026-06-27 21:23:53.830[唐桂-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.0021438598632812 -- 2026-06-27 21:23:53.832[唐桂-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.0017039775848389 -- 2026-06-27 21:23:53.834[唐桂-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.0024008750915527 -- 2026-06-27 21:23:53.837[唐桂-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.002079963684082 -- 2026-06-27 21:23:53.840[唐桂-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.001708984375 -- 2026-06-27 21:23:53.842[唐桂-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.019685983657837 -- 2026-06-27 21:23:53.893[唐桂-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019490718841553 -- 2026-06-27 21:23:53.895[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9181,9180,9179,9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020206928253174 -- 2026-06-27 21:26:40.622[唐桂-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.001708984375 -- 2026-06-27 21:26:40.624[唐桂-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.0021250247955322 -- 2026-06-27 21:26:40.627[唐桂-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.0016870498657227 -- 2026-06-27 21:26:40.630[唐桂-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.0016529560089111 -- 2026-06-27 21:26:40.632[唐桂-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.0036149024963379 -- 2026-06-27 21:26:40.660[唐桂-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001762866973877 -- 2026-06-27 21:26:40.662[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9181,9180,9179,9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018276929855347 -- 2026-06-27 21:26:44.620[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9180&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023889541625977 -- 2026-06-27 21:26:44.623[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9180&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019099712371826 -- 2026-06-27 21:26:44.625[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9180&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 = 9180 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097150802612305 -- 2026-06-27 21:27:51.009[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79789 and order_id = 9180 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022130012512207 -- 2026-06-27 21:27:51.012[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9180 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017690658569336 -- 2026-06-27 21:27:51.014[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096259117126465 -- 2026-06-27 21:28:12.105[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79789 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034959316253662 -- 2026-06-27 21:28:12.108[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 60.00 where extrafareApply_id = 79789 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015223979949951 -- 2026-06-27 21:28:35.971[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79789 and order_id = 9180 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01306414604187 -- 2026-06-27 21:28:39.310[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79789 and order_id = 9180 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090329647064209 -- 2026-06-27 21:28:41.639[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2500 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001600980758667 -- 2026-06-27 21:28:41.641[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2500 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060160160064697 -- 2026-06-27 21:28:41.673[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 111 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018041133880615 -- 2026-06-27 21:28:41.675[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9181,9180,9179,9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011480093002319 -- 2026-06-27 21:28:45.268[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9180&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026450157165527 -- 2026-06-27 21:28:45.271[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9180&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00217604637146 -- 2026-06-27 21:28:45.273[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9180&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 = 9180 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093250274658203 -- 2026-06-27 21:28:45.774[唐桂-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.0018010139465332 -- 2026-06-27 21:28:45.776[唐桂-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.0022618770599365 -- 2026-06-27 21:28:45.779[唐桂-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.0017049312591553 -- 2026-06-27 21:28:45.782[唐桂-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.0016751289367676 -- 2026-06-27 21:28:45.784[唐桂-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.0017940998077393 -- 2026-06-27 21:28:45.811[唐桂-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/20' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016858577728271 -- 2026-06-27 21:28:45.813[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9181,9180,9179,9115) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------