Time: 0.0080258846282959 -- 2026-06-20 00:42:01.756 -- /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.010848045349121 -- 2026-06-20 02:09:01.775 -- /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.0079450607299805 -- 2026-06-20 05:05:16.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.0076131820678711 -- 2026-06-20 05:05:16.331 -- /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.001600980758667 -- 2026-06-20 05:05:16.335 -- /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.0024540424346924 -- 2026-06-20 05:05:16.337 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6ABR6OBpi9ZgSw2yKdGgBaM' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014989376068115 -- 2026-06-20 05:05:16.339 -- /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.0016779899597168 -- 2026-06-20 05:05:16.341[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018799304962158 -- 2026-06-20 05:05:16.343[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014760494232178 -- 2026-06-20 05:05:16.344[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022480487823486 -- 2026-06-20 05:05:16.347[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019440650939941 -- 2026-06-20 05:05:16.350[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2511 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014891624450684 -- 2026-06-20 05:05:16.352[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028681993484497 -- 2026-06-20 05:05:16.422[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 122 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021061897277832 -- 2026-06-20 05:05:16.424[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9013,8970,8920) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014766931533813 -- 2026-06-20 05:05:32.731[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9013&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030710697174072 -- 2026-06-20 05:05:32.734[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9013&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035209655761719 -- 2026-06-20 05:05:32.738[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9013&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 = 9013 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098028182983398 -- 2026-06-20 05:07:51.106[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79500 and order_id = 9013 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023019313812256 -- 2026-06-20 05:07:51.109[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select ifnull(close_id,1) close_id from dbtsl.tsl_orderex_fee where order_id = 9013 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001762866973877 -- 2026-06-20 05:07:51.111[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087330341339111 -- 2026-06-20 05:08:18.761[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee SELECT apply_amt FROM dboa.oa_extrafareapply WHERE extrafareApply_id= 79500 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028450489044189 -- 2026-06-20 05:08:18.764[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=sync_extrafareapply_tslorderFee update dboa.oa_extrafareapply_tslorder set fee_amt = 50.00 where extrafareApply_id = 79500 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018318176269531 -- 2026-06-20 05:08:34.776[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 79500 and order_id = 9013 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085160732269287 -- 2026-06-20 05:08:37.302[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select driver_id from dbsys.sys_driver where cont_id = 2511 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014679431915283 -- 2026-06-20 05:08:37.303[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023845911026001 -- 2026-06-20 05:08:37.352[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 122 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001708984375 -- 2026-06-20 05:08:37.354[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9013,8970,8920) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008181095123291 -- 2026-06-20 05:08:53.367[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9013&extrafareApply_id=1 select o.org_id,o.org_name,c.cont_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027730464935303 -- 2026-06-20 05:08:53.370[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9013&extrafareApply_id=1 select d.driver_id,d.driver_name,d.receiving_unit_id,c.shortname,c.account_name,c.bank_account,opening_bank from dbtsl.v_tsl_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032291412353516 -- 2026-06-20 05:08:53.373[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=9013&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 = 9013 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01398777961731 -- 2026-06-20 05:08:54.688[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017821788787842 -- 2026-06-20 05:08:54.689[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024750232696533 -- 2026-06-20 05:08:54.692[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016629695892334 -- 2026-06-20 05:08:54.695[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2511 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016741752624512 -- 2026-06-20 05:08:54.697[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017659664154053 -- 2026-06-20 05:08:54.724[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 122 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016899108886719 -- 2026-06-20 05:08:54.726[杨林-2511] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(9013,8970,8920) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015369892120361 -- 2026-06-20 10:20:52.975 -- /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.001863956451416 -- 2026-06-20 10:20:52.979 -- /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.0026381015777588 -- 2026-06-20 10:20:52.982 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbwechat.wechat_publicno_acct p_a on b.publicno_id = p_a.publicno_id left join dbsys.sys_contact c on b.cont_id = c.cont_id where b.publicno_id = 11 and b.openid='ocoGM6Fvthylzy546ri8ofGVDYGE' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001788854598999 -- 2026-06-20 10:20:52.984 -- /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.0019791126251221 -- 2026-06-20 10:20:52.986[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023281574249268 -- 2026-06-20 10:20:52.988[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017738342285156 -- 2026-06-20 10:20:52.990[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041658878326416 -- 2026-06-20 10:20:52.994[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2988 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038940906524658 -- 2026-06-20 10:20:53.060[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2988 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018100738525391 -- 2026-06-20 10:20:53.062[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014031887054443 -- 2026-06-20 10:20:53.108[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 522 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023500919342041 -- 2026-06-20 10:20:53.111[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8930) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011307001113892 -- 2026-06-20 10:20:59.578[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8930&extrafareApply_id=79392 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 = 79392 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017490386962891 -- 2026-06-20 10:20:59.580[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8930&extrafareApply_id=79392 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043740272521973 -- 2026-06-20 10:20:59.616[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8930&extrafareApply_id=79392 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 = 79392 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018141269683838 -- 2026-06-20 10:20:59.618[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8930&extrafareApply_id=79392 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6664512 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016939640045166 -- 2026-06-20 10:20:59.620[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8930&extrafareApply_id=79392 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017158985137939 -- 2026-06-20 10:20:59.646[曾璟洋-2988] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8930&extrafareApply_id=79392 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2988 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095090866088867 -- 2026-06-20 10:41:02.083 -- /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.0018470287322998 -- 2026-06-20 10:41:02.087 -- /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.0027220249176025 -- 2026-06-20 10:41:02.090 -- /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.0018129348754883 -- 2026-06-20 10:41:02.092 -- /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.0020051002502441 -- 2026-06-20 10:41:02.094[唐桂-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.0021910667419434 -- 2026-06-20 10:41:02.096[唐桂-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.0017971992492676 -- 2026-06-20 10:41:02.098[唐桂-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.002547025680542 -- 2026-06-20 10:41:02.101[唐桂-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.002126932144165 -- 2026-06-20 10:41:02.105[唐桂-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.0017950534820557 -- 2026-06-20 10:41:02.106[唐桂-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.0069060325622559 -- 2026-06-20 10:41:02.143[唐桂-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022609233856201 -- 2026-06-20 10:41:02.146[唐桂-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(8969,8934,8933) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095109939575195 -- 2026-06-20 10:54:19.167 -- /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.0098600387573242 -- 2026-06-20 10:54:19.572 -- /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.0017268657684326 -- 2026-06-20 10:54:19.575 -- /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.0026741027832031 -- 2026-06-20 10:54:19.578 -- /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='ocoGM6EXZHyVuRg87t7LgD02LsVc' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001655101776123 -- 2026-06-20 10:54:19.580 -- /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.0018379688262939 -- 2026-06-20 10:54:19.582[杨恩达-2448] -- /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.0021381378173828 -- 2026-06-20 10:54:19.584[杨恩达-2448] -- /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.0016460418701172 -- 2026-06-20 10:54:19.586[杨恩达-2448] -- /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 = 2448 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023579597473145 -- 2026-06-20 10:54:19.589[杨恩达-2448] -- /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 = 2448 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038681030273438 -- 2026-06-20 10:54:19.594[杨恩达-2448] -- /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 = 2448 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023370981216431 -- 2026-06-20 10:54:19.618[杨恩达-2448] -- /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 = 20025 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.003342866897583 -- 2026-06-20 10:54:19.621[杨恩达-2448] -- /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.0098099708557129 -- 2026-06-20 10:54:25.382[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT driver_id,receiving_unit_id,salaryItem_tmplt_id FROM dbtsl.v_tsl_driver WHERE cont_id = 2448 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044279098510742 -- 2026-06-20 10:54:25.387[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT s.*,sd.*,c.shortname driver_name, s_e.extfield_json,group_concat(s.statement_no) statement_no, group_concat(s.statement_id) statement_ids, sum(s_d.sumSalary_amt) sumSalary_amt,sum(s_d.monthlyBonus_amt) monthlyBonus_amt, sum(s_d.monthlyDeduction_amt) monthlyDeduction_amt,sum(s_d.otherDeduction_amt) otherDeduction_amt, sum(s_d.sumDeduction_amt) sumDeduction_amt, date_format(s.start_date, '%Y-%m-%d') AS start_date, date_format(s.end_date, '%Y-%m-%d') AS end_date FROM dbtsl.tsl_statement s LEFT JOIN dbtsl.tsl_statement_ext s_e ON s.statement_id = s_e.statement_id LEFT JOIN dbsys.sys_customer c ON s.customer_id = c.customer_id LEFT JOIN dbtsl.tsl_statementex_driversalary s_d ON s.statement_id = s_d.statement_id LEFT JOIN dboa.oa_fareapply f ON f.fareApply_id = s_d.fareApply_id LEFT JOIN dbfin.fin_salarydata sd ON sd.salaryData_id = s_d.salaryData_id LEFT JOIN dboa.oa_fareapply fin_f ON sd.fareApply_id = fin_f.fareApply_id WHERE s.customer_id = 20025 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.0015859603881836 -- 2026-06-20 10:54:25.389[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT salaryItem_name,field_name FROM dbfin.fin_salaryitem WHERE isenable = 1 AND salaryItem_tmplt_id = 55 AND is_effective = 1 AND salaryItem_id NOT IN(SELECT fin_salaryItem_id FROM dbtsl.tsl_driversalary2fin_setting WHERE acct_id = 47) ORDER BY salaryItem_sort ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016659021377563 -- 2026-06-20 10:54:26.738[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT driver_id,receiving_unit_id,salaryItem_tmplt_id FROM dbtsl.v_tsl_driver WHERE cont_id = 2448 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029549598693848 -- 2026-06-20 10:54:26.741[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT s.*,sd.*,c.shortname driver_name, s_e.extfield_json,group_concat(s.statement_no) statement_no, group_concat(s.statement_id) statement_ids, sum(s_d.sumSalary_amt) sumSalary_amt,sum(s_d.monthlyBonus_amt) monthlyBonus_amt, sum(s_d.monthlyDeduction_amt) monthlyDeduction_amt,sum(s_d.otherDeduction_amt) otherDeduction_amt, sum(s_d.sumDeduction_amt) sumDeduction_amt, date_format(s.start_date, '%Y-%m-%d') AS start_date, date_format(s.end_date, '%Y-%m-%d') AS end_date FROM dbtsl.tsl_statement s LEFT JOIN dbtsl.tsl_statement_ext s_e ON s.statement_id = s_e.statement_id LEFT JOIN dbsys.sys_customer c ON s.customer_id = c.customer_id LEFT JOIN dbtsl.tsl_statementex_driversalary s_d ON s.statement_id = s_d.statement_id LEFT JOIN dboa.oa_fareapply f ON f.fareApply_id = s_d.fareApply_id LEFT JOIN dbfin.fin_salarydata sd ON sd.salaryData_id = s_d.salaryData_id LEFT JOIN dboa.oa_fareapply fin_f ON sd.fareApply_id = fin_f.fareApply_id WHERE s.customer_id = 20025 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.001755952835083 -- 2026-06-20 10:54:26.743[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT salaryItem_name,field_name FROM dbfin.fin_salaryitem WHERE isenable = 1 AND salaryItem_tmplt_id = 55 AND is_effective = 1 AND salaryItem_id NOT IN(SELECT fin_salaryItem_id FROM dbtsl.tsl_driversalary2fin_setting WHERE acct_id = 47) ORDER BY salaryItem_sort ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019445896148682 -- 2026-06-20 10:54:28.700[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT driver_id,receiving_unit_id,salaryItem_tmplt_id FROM dbtsl.v_tsl_driver WHERE cont_id = 2448 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043678283691406 -- 2026-06-20 10:54:28.705[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT s.*,sd.*,c.shortname driver_name, s_e.extfield_json,group_concat(s.statement_no) statement_no, group_concat(s.statement_id) statement_ids, sum(s_d.sumSalary_amt) sumSalary_amt,sum(s_d.monthlyBonus_amt) monthlyBonus_amt, sum(s_d.monthlyDeduction_amt) monthlyDeduction_amt,sum(s_d.otherDeduction_amt) otherDeduction_amt, sum(s_d.sumDeduction_amt) sumDeduction_amt, date_format(s.start_date, '%Y-%m-%d') AS start_date, date_format(s.end_date, '%Y-%m-%d') AS end_date FROM dbtsl.tsl_statement s LEFT JOIN dbtsl.tsl_statement_ext s_e ON s.statement_id = s_e.statement_id LEFT JOIN dbsys.sys_customer c ON s.customer_id = c.customer_id LEFT JOIN dbtsl.tsl_statementex_driversalary s_d ON s.statement_id = s_d.statement_id LEFT JOIN dboa.oa_fareapply f ON f.fareApply_id = s_d.fareApply_id LEFT JOIN dbfin.fin_salarydata sd ON sd.salaryData_id = s_d.salaryData_id LEFT JOIN dboa.oa_fareapply fin_f ON sd.fareApply_id = fin_f.fareApply_id WHERE s.customer_id = 20025 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.0018930435180664 -- 2026-06-20 10:54:28.707[杨恩达-2448] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=query SELECT salaryItem_name,field_name FROM dbfin.fin_salaryitem WHERE isenable = 1 AND salaryItem_tmplt_id = 55 AND is_effective = 1 AND salaryItem_id NOT IN(SELECT fin_salaryItem_id FROM dbtsl.tsl_driversalary2fin_setting WHERE acct_id = 47) ORDER BY salaryItem_sort ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099048614501953 -- 2026-06-20 11:22:29.037 -- /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.0088069438934326 -- 2026-06-20 11:22:29.225 -- /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.0022599697113037 -- 2026-06-20 11:22:29.229 -- /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.0029420852661133 -- 2026-06-20 11:22:29.232 -- /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.0017518997192383 -- 2026-06-20 11:22:29.234 -- /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.0019311904907227 -- 2026-06-20 11:22:29.236[何照泽-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.0022470951080322 -- 2026-06-20 11:22:29.239[何照泽-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.0017120838165283 -- 2026-06-20 11:22:29.240[何照泽-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.0025238990783691 -- 2026-06-20 11:22:29.243[何照泽-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.0017709732055664 -- 2026-06-20 11:22:29.247[何照泽-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.0017020702362061 -- 2026-06-20 11:22:29.248[何照泽-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.024340152740479 -- 2026-06-20 11:22:29.303[何照泽-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018379688262939 -- 2026-06-20 11:22:29.306[何照泽-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(8988) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019188165664673 -- 2026-06-20 11:22:31.458[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8988&extrafareApply_id=79470 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 = 79470 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016980171203613 -- 2026-06-20 11:22:31.460[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8988&extrafareApply_id=79470 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026288032531738 -- 2026-06-20 11:22:31.492[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8988&extrafareApply_id=79470 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 = 79470 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018129348754883 -- 2026-06-20 11:22:31.494[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8988&extrafareApply_id=79470 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6674663 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016648769378662 -- 2026-06-20 11:22:31.496[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8988&extrafareApply_id=79470 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016589164733887 -- 2026-06-20 11:22:31.498[何照泽-2753] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8988&extrafareApply_id=79470 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2753 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010739088058472 -- 2026-06-20 11:41:12.285 -- /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-20 11:41:12.289 -- /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.00307297706604 -- 2026-06-20 11:41:12.292 -- /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.0018019676208496 -- 2026-06-20 11:41:12.294 -- /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.0020499229431152 -- 2026-06-20 11:41:12.296[陈伦建-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.0023598670959473 -- 2026-06-20 11:41:12.298[陈伦建-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.0017969608306885 -- 2026-06-20 11:41:12.300[陈伦建-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.0027060508728027 -- 2026-06-20 11:41:12.303[陈伦建-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.0021770000457764 -- 2026-06-20 11:41:12.307[陈伦建-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.0017850399017334 -- 2026-06-20 11:41:12.309[陈伦建-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.024383068084717 -- 2026-06-20 11:41:12.366[陈伦建-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026171207427979 -- 2026-06-20 11:41:12.369[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8967,8931) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010400056838989 -- 2026-06-20 11:41:13.613[陈伦建-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.0015671253204346 -- 2026-06-20 11:41:13.615[陈伦建-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.0042750835418701 -- 2026-06-20 11:41:13.651[陈伦建-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.0016860961914062 -- 2026-06-20 11:41:13.653[陈伦建-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.0015599727630615 -- 2026-06-20 11:41:13.655[陈伦建-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.0015721321105957 -- 2026-06-20 11:41:13.657[陈伦建-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.0095949172973633 -- 2026-06-20 11:41:15.289[陈伦建-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.001676082611084 -- 2026-06-20 11:41:15.291[陈伦建-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.0016961097717285 -- 2026-06-20 11:41:15.293[陈伦建-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.0016589164733887 -- 2026-06-20 11:41:15.297[陈伦建-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.0016720294952393 -- 2026-06-20 11:41:15.298[陈伦建-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.014080047607422 -- 2026-06-20 11:41:15.337[陈伦建-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017030239105225 -- 2026-06-20 11:41:15.339[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8967,8931) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014379024505615 -- 2026-06-20 12:06:27.471[陈伦建-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.0018491744995117 -- 2026-06-20 12:06:27.473[陈伦建-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.0027360916137695 -- 2026-06-20 12:06:27.476[陈伦建-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.002269983291626 -- 2026-06-20 12:06:27.480[陈伦建-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.0017971992492676 -- 2026-06-20 12:06:27.482[陈伦建-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.0066230297088623 -- 2026-06-20 12:06:27.513[陈伦建-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023601055145264 -- 2026-06-20 12:06:27.516[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8967,8931) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082120895385742 -- 2026-06-20 12:06:32.002[陈伦建-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.0015242099761963 -- 2026-06-20 12:06:32.004[陈伦建-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.047136783599854 -- 2026-06-20 12:06:32.077[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 533 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/05/22' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030910968780518 -- 2026-06-20 12:06:32.080[陈伦建-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,8461,8407,8376,8223) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01360297203064 -- 2026-06-20 12:52:34.988[陈伦建-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.0014381408691406 -- 2026-06-20 12:52:34.990[陈伦建-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.0023438930511475 -- 2026-06-20 12:52:34.992[陈伦建-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.0018749237060547 -- 2026-06-20 12:52:34.996[陈伦建-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.001413106918335 -- 2026-06-20 12:52:34.997[陈伦建-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.0063159465789795 -- 2026-06-20 12:52:35.034[陈伦建-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019960403442383 -- 2026-06-20 12:52:35.036[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8967,8931) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089089870452881 -- 2026-06-20 12:55:43.631 -- /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.0018019676208496 -- 2026-06-20 12:55:43.635 -- /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.0029258728027344 -- 2026-06-20 12:55:43.638 -- /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.0021278858184814 -- 2026-06-20 12:55:43.640 -- /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.0019590854644775 -- 2026-06-20 12:55:43.642[慕杨-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.0022001266479492 -- 2026-06-20 12:55:43.644[慕杨-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.0017378330230713 -- 2026-06-20 12:55:43.646[慕杨-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.0024709701538086 -- 2026-06-20 12:55:43.649[慕杨-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.0021250247955322 -- 2026-06-20 12:55:43.653[慕杨-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.0017170906066895 -- 2026-06-20 12:55:43.655[慕杨-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.022947072982788 -- 2026-06-20 12:55:43.708[慕杨-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023999214172363 -- 2026-06-20 12:55:43.711[慕杨-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(8937,8936,8935) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018856048583984 -- 2026-06-20 12:56:02.403[慕杨-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.0016789436340332 -- 2026-06-20 12:56:02.405[慕杨-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.0016989707946777 -- 2026-06-20 12:56:02.407[慕杨-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.0016829967498779 -- 2026-06-20 12:56:02.410[慕杨-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.0016720294952393 -- 2026-06-20 12:56:02.412[慕杨-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.023968935012817 -- 2026-06-20 12:56:02.460[慕杨-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017130374908447 -- 2026-06-20 12:56:02.462[慕杨-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(8937,8936,8935) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094242095947266 -- 2026-06-20 12:56:11.018[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8935&extrafareApply_id=79336 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 = 79336 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013692378997803 -- 2026-06-20 12:56:11.020[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8935&extrafareApply_id=79336 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043540000915527 -- 2026-06-20 12:56:11.056[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8935&extrafareApply_id=79336 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 = 79336 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015270709991455 -- 2026-06-20 12:56:11.058[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8935&extrafareApply_id=79336 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6659000 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013918876647949 -- 2026-06-20 12:56:11.059[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8935&extrafareApply_id=79336 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013759136199951 -- 2026-06-20 12:56:11.061[慕杨-2786] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8935&extrafareApply_id=79336 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2786 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084848403930664 -- 2026-06-20 14:25:16.565[唐桂-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.001594066619873 -- 2026-06-20 14:25:16.567[唐桂-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.0024290084838867 -- 2026-06-20 14:25:16.569[唐桂-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.0020968914031982 -- 2026-06-20 14:25:16.573[唐桂-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.001594066619873 -- 2026-06-20 14:25:16.575[唐桂-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.0085248947143555 -- 2026-06-20 14:25:16.597 -- /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.006558895111084 -- 2026-06-20 14:25:16.614[唐桂-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002223014831543 -- 2026-06-20 14:25:16.616[唐桂-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(8969,8934,8933) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011029005050659 -- 2026-06-20 14:48:36.139 -- /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.0015189647674561 -- 2026-06-20 14:48:36.142 -- /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.0023908615112305 -- 2026-06-20 14:48:36.144 -- /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.0094718933105469 -- 2026-06-20 14:48:55.942 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018160343170166 -- 2026-06-20 14:48:55.945 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='wxbcb1d4382ca8035f' and isenable=1 and publicno_type_id=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018289089202881 -- 2026-06-20 14:48:55.947 -- /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.019118785858154 -- 2026-06-20 14:53:47.046 -- /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.0015850067138672 -- 2026-06-20 14:53:47.049 -- /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.0024509429931641 -- 2026-06-20 14:53:47.052 -- /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.010663986206055 -- 2026-06-20 15:00:33.328 -- /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.0020101070404053 -- 2026-06-20 15:00:33.332 -- /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.0028090476989746 -- 2026-06-20 15:00:33.335 -- /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.0092761516571045 -- 2026-06-20 15:33:32.957 -- /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.0017468929290771 -- 2026-06-20 15:33:32.960 -- /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.0027060508728027 -- 2026-06-20 15:33:32.963 -- /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.015486001968384 -- 2026-06-20 15:34:51.957 -- /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.0018100738525391 -- 2026-06-20 15:34:51.961 -- /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.0025529861450195 -- 2026-06-20 15:34:51.963 -- /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.0096700191497803 -- 2026-06-20 15:38:27.141 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select publicno_type_id from dbwechat.wechat_publicno where appid='wxbcb1d4382ca8035f' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001823902130127 -- 2026-06-20 15:38:27.144 -- /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.0022468566894531 -- 2026-06-20 15:38:27.147 -- /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.0089418888092041 -- 2026-06-20 15:48:16.731[唐桂-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.0016849040985107 -- 2026-06-20 15:48:16.733[唐桂-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.0025660991668701 -- 2026-06-20 15:48:16.735[唐桂-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.00199294090271 -- 2026-06-20 15:48:16.739[唐桂-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.0016579627990723 -- 2026-06-20 15:48:16.741[唐桂-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.019889116287231 -- 2026-06-20 15:48:16.791[唐桂-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021610260009766 -- 2026-06-20 15:48:16.793[唐桂-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(8969,8934,8933) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00819993019104 -- 2026-06-20 17:19:48.465 -- /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.0091540813446045 -- 2026-06-20 17:19:48.503 -- /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.0023529529571533 -- 2026-06-20 17:19:48.507 -- /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.0030159950256348 -- 2026-06-20 17:19:48.510 -- /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='ocoGM6GROgFfXHOfvclHbey_X7PY' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018308162689209 -- 2026-06-20 17:19:48.512 -- /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.0020561218261719 -- 2026-06-20 17:19:48.514[刘先勇-2661] -- /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.0022928714752197 -- 2026-06-20 17:19:48.517[刘先勇-2661] -- /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.001816987991333 -- 2026-06-20 17:19:48.519[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026218891143799 -- 2026-06-20 17:19:48.521[刘先勇-2661] -- /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 = 2661 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022170543670654 -- 2026-06-20 17:19:48.525[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018320083618164 -- 2026-06-20 17:19:48.527[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0063550472259521 -- 2026-06-20 17:19:48.564[刘先勇-2661] -- /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 = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080559253692627 -- 2026-06-20 17:19:55.658[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015101432800293 -- 2026-06-20 17:19:55.660[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020141124725342 -- 2026-06-20 17:19:55.705[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/01' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021560192108154 -- 2026-06-20 17:19:55.707[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8844,8683,8464) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011057138442993 -- 2026-06-20 17:20:04.062[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,receive.shortname receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(w_ot.work_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbtsl.tsl_workex_other w_ot ON r.extrafareApply_id = w_ot.extrafareApply_id LEFT JOIN dbsys.sys_customer receive ON receive.customer_id = r.receiving_unit_id WHERE r.extrafareApply_id = 79406 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017790794372559 -- 2026-06-20 17:20:04.064[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038890838623047 -- 2026-06-20 17:20:04.100[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select efa_tsl.extrafareapply_tslorder_id recid, efa_tsl.extrafareapply_tslorder_id, efa_tsl.extrafareApply_id, efa_tsl.fee_amt, efa.status_id, o.order_id, o.order_no, efa.is_close, o.pieces, o.weight, o.volume, o.calc_weight, w.work_no, o.acct_id, o.customer_id,w.truck_no,route.route_name,w_sl.copilot_driver,w.driver,o.order_date from dboa.oa_extrafareapply_tslorder efa_tsl left join dboa.oa_extrafareApply efa ON efa.extrafareApply_id = efa_tsl.extrafareApply_id left join dbtsl.v_tsl_order o on efa_tsl.order_id = o.order_id left join dbtsl.tsl_orderex_ftl o_ftl on o_ftl.order_id = o.order_id left join dbtsl.tsl_route route on route.route_id = o_ftl.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id where efa_tsl.extrafareApply_id = 79406 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018689632415771 -- 2026-06-20 17:20:04.102[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6667301 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017368793487549 -- 2026-06-20 17:20:04.104[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017271041870117 -- 2026-06-20 17:20:04.106[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8464&extrafareApply_id=79406 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014619827270508 -- 2026-06-20 17:20:13.376[刘先勇-2661] -- /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.0013670921325684 -- 2026-06-20 17:20:13.378[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013830661773682 -- 2026-06-20 17:20:13.379[刘先勇-2661] -- /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 = 2661 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013589859008789 -- 2026-06-20 17:20:13.382[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014190673828125 -- 2026-06-20 17:20:13.384[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023324966430664 -- 2026-06-20 17:20:13.432[刘先勇-2661] -- /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 = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097358226776123 -- 2026-06-20 17:20:18.064[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015189647674561 -- 2026-06-20 17:20:18.065[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017583847045898 -- 2026-06-20 17:20:18.107[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/01' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016000270843506 -- 2026-06-20 17:20:18.109[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8844,8683,8464) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014800071716309 -- 2026-06-20 17:20:21.985[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79298 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 = 79298 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016171932220459 -- 2026-06-20 17:20:21.987[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79298 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042591094970703 -- 2026-06-20 17:20:22.022[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79298 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 = 79298 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016820430755615 -- 2026-06-20 17:20:22.024[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79298 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6653170 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015850067138672 -- 2026-06-20 17:20:22.025[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79298 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001572847366333 -- 2026-06-20 17:20:22.028[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79298 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093610286712646 -- 2026-06-20 17:20:25.717[刘先勇-2661] -- /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.0017309188842773 -- 2026-06-20 17:20:25.719[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017271041870117 -- 2026-06-20 17:20:25.721[刘先勇-2661] -- /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 = 2661 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017201900482178 -- 2026-06-20 17:20:25.724[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017309188842773 -- 2026-06-20 17:20:25.726[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018100738525391 -- 2026-06-20 17:20:25.753[刘先勇-2661] -- /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 = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092408657073975 -- 2026-06-20 17:20:29.429[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017471313476562 -- 2026-06-20 17:20:29.431[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017809152603149 -- 2026-06-20 17:20:29.474[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/01' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018019676208496 -- 2026-06-20 17:20:29.476[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8844,8683,8464) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099260807037354 -- 2026-06-20 17:20:30.542[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79340 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 = 79340 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014569759368896 -- 2026-06-20 17:20:30.543[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79340 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041899681091309 -- 2026-06-20 17:20:30.579[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79340 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 = 79340 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016069412231445 -- 2026-06-20 17:20:30.580[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79340 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6659532 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014488697052002 -- 2026-06-20 17:20:30.582[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79340 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001446008682251 -- 2026-06-20 17:20:30.584[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8844&extrafareApply_id=79340 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086629390716553 -- 2026-06-20 17:20:35.557[刘先勇-2661] -- /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.0015239715576172 -- 2026-06-20 17:20:35.559[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015289783477783 -- 2026-06-20 17:20:35.560[刘先勇-2661] -- /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 = 2661 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015110969543457 -- 2026-06-20 17:20:35.563[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014851093292236 -- 2026-06-20 17:20:35.565[刘先勇-2661] -- /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 = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014746904373169 -- 2026-06-20 17:20:35.604[刘先勇-2661] -- /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 = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080900192260742 -- 2026-06-20 17:20:38.438[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2661 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015928745269775 -- 2026-06-20 17:20:38.439[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016670227050781 -- 2026-06-20 17:20:38.466[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 238 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/01' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015947818756104 -- 2026-06-20 17:20:38.468[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8844,8683,8464) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02144193649292 -- 2026-06-20 17:20:40.957[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8683&extrafareApply_id=79211 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 = 79211 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017940998077393 -- 2026-06-20 17:20:40.959[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8683&extrafareApply_id=79211 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044891834259033 -- 2026-06-20 17:20:40.994[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8683&extrafareApply_id=79211 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 = 79211 and o.buzSystem_id = 15 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003324031829834 -- 2026-06-20 17:20:40.998[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8683&extrafareApply_id=79211 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6641379 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018131732940674 -- 2026-06-20 17:20:41.000[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8683&extrafareApply_id=79211 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017940998077393 -- 2026-06-20 17:20:41.002[刘先勇-2661] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=8683&extrafareApply_id=79211 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2661 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082159042358398 -- 2026-06-20 17:37:22.381 -- /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.0015521049499512 -- 2026-06-20 17:37:22.385 -- /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.002357006072998 -- 2026-06-20 17:37:22.387 -- /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.01019287109375 -- 2026-06-20 17:39:48.737 -- /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.025325059890747 -- 2026-06-20 17:39:50.823[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22}&appid=wxbcb1d4382ca8035f&wxMenu_id=126 select is_wxMenu_id from dbwechat.v_wechat_publicnoch_menu where wxMenu_id=126 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013761520385742 -- 2026-06-20 17:39:50.824[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22}&appid=wxbcb1d4382ca8035f&wxMenu_id=126 select cont_stafftype, bit_adminBuzSystem from dbsys.sys_contact where cont_id = 2442 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013530254364014 -- 2026-06-20 17:39:50.826[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22}&appid=wxbcb1d4382ca8035f&wxMenu_id=126 select count(1) cnt from dbwechat.wechat_cont_purview where wxMenu_id = 126 and cont_id = 2442 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019021034240723 -- 2026-06-20 17:39:50.829[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22}&appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2442 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014340877532959 -- 2026-06-20 17:39:50.831[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22}&appid=wxbcb1d4382ca8035f&wxMenu_id=126 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2442 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02062201499939 -- 2026-06-20 17:39:50.882[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22wxbcb1d4382ca8035f%22,%22wxMenu_id%22:%22126%22}&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 = 56 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088448524475098 -- 2026-06-20 17:40:14.084[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2442 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016529560089111 -- 2026-06-20 17:40:14.086[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2442 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018539190292358 -- 2026-06-20 17:40:14.130[闫富松-2442] -- /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 = 56 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/12' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082659721374512 -- 2026-06-20 17:40:24.825[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2442 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015361309051514 -- 2026-06-20 17:40:24.826[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2442 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016500949859619 -- 2026-06-20 17:40:24.854[闫富松-2442] -- /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 = 56 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/12' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087618827819824 -- 2026-06-20 17:40:29.776[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2442 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016469955444336 -- 2026-06-20 17:40:29.777[闫富松-2442] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2442 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016525983810425 -- 2026-06-20 17:40:29.819[闫富松-2442] -- /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 = 56 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/06' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009890079498291 -- 2026-06-20 17:41:43.090 -- /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.001878023147583 -- 2026-06-20 17:41:43.093 -- /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.0026149749755859 -- 2026-06-20 17:41:43.096 -- /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.018446922302246 -- 2026-06-20 18:00:22.681[唐桂-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.0016591548919678 -- 2026-06-20 18:00:22.683[唐桂-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.002094030380249 -- 2026-06-20 18:00:22.685[唐桂-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.002147912979126 -- 2026-06-20 18:00:22.689[唐桂-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.0016500949859619 -- 2026-06-20 18:00:22.691[唐桂-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.0062661170959473 -- 2026-06-20 18:00:22.727[唐桂-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021078586578369 -- 2026-06-20 18:00:22.729[唐桂-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(8969,8934,8933) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013501167297363 -- 2026-06-20 18:48:53.635[陈伦建-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.0017189979553223 -- 2026-06-20 18:48:53.637[陈伦建-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.0025820732116699 -- 2026-06-20 18:48:53.640[陈伦建-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.0020480155944824 -- 2026-06-20 18:48:53.644[陈伦建-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.0016829967498779 -- 2026-06-20 18:48:53.646[陈伦建-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.0067229270935059 -- 2026-06-20 18:48:53.683[陈伦建-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022108554840088 -- 2026-06-20 18:48:53.685[陈伦建-3003] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt,e.payStatus_id from dboa.oa_extrafareapply_tslorder ef_tsl left join dboa.oa_extrafareapply e on e.extrafareApply_id = ef_tsl.extrafareApply_id where ef_tsl.order_id in(8967,8931) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024029970169067 -- 2026-06-20 18:48:55.141[陈伦建-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.0015799999237061 -- 2026-06-20 18:48:55.143[陈伦建-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.0042440891265869 -- 2026-06-20 18:48:55.181[陈伦建-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.0016911029815674 -- 2026-06-20 18:48:55.182[陈伦建-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.0015561580657959 -- 2026-06-20 18:48:55.184[陈伦建-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.0015518665313721 -- 2026-06-20 18:48:55.186[陈伦建-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.010142087936401 -- 2026-06-20 18:55:25.638[唐桂-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.0019168853759766 -- 2026-06-20 18:55:25.641[唐桂-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.0026419162750244 -- 2026-06-20 18:55:25.643[唐桂-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.0022299289703369 -- 2026-06-20 18:55:25.647[唐桂-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-20 18:55:25.649[唐桂-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.0094199180603027 -- 2026-06-20 18:55:25.668 -- /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.023585081100464 -- 2026-06-20 18:55:25.703[唐桂-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024080276489258 -- 2026-06-20 18:55:25.706[唐桂-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(8969,8934,8933) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01002311706543 -- 2026-06-20 18:58:28.422[唐桂-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.0019009113311768 -- 2026-06-20 18:58:28.424[唐桂-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.0025780200958252 -- 2026-06-20 18:58:28.426[唐桂-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.0022327899932861 -- 2026-06-20 18:58:28.430[唐桂-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.0018551349639893 -- 2026-06-20 18:58:28.432[唐桂-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.0063860416412354 -- 2026-06-20 18:58:28.464[唐桂-2500] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 SELECT o.*,o.order_id recid,o_tn.content transnode_content,r.route_name,w.carrier_id,w.truck_no,w.driver, w_sl.copilot_driver,w_sl.fleet_carrier_id,w.driver_id,date_format(o.order_date,'%Y-%m-%d %H:%i') order_date FROM dbtsl.tsl_order o left join dbtsl.tsl_orderch_transnode o_tn on o.cur_transnode_id = o_tn.transnode_id left join dbtsl.tsl_orderex_fee o_fee on o.order_id = o_fee.order_id left join dbtsl.tsl_orderex_ftl oe_f on o.order_id = oe_f.order_id left join dbtsl.tsl_route r on r.route_id = oe_f.route_id left join dbtsl.tsl_workch_order w_o on o.order_id = w_o.order_id left join dbtsl.tsl_work w on w.work_id = w_o.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id left join dboa.oa_extrafareapply_tslorder ef_tsl on ef_tsl.order_id = o.order_id WHERE o.acct_id=47 and o.buzSystem_id = 15 and IFNULL(o_fee.close_id, 0) <= 1 AND ( w.driver_id = 111 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023369789123535 -- 2026-06-20 18:58:28.466[唐桂-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(8969,8934,8933) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090420246124268 -- 2026-06-20 19:21:43.938 -- /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.0017070770263672 -- 2026-06-20 19:21:43.942 -- /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.0028440952301025 -- 2026-06-20 19:21:43.945 -- /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='ocoGM6AN3aD-tqMC7JIg7w0z14-A' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016889572143555 -- 2026-06-20 19:21:43.947 -- /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.0018558502197266 -- 2026-06-20 19:21:43.949[赵红兵-2794] -- /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.0020289421081543 -- 2026-06-20 19:21:43.951[赵红兵-2794] -- /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.00164794921875 -- 2026-06-20 19:21:43.953[赵红兵-2794] -- /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 = 2794 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023298263549805 -- 2026-06-20 19:21:43.955[赵红兵-2794] -- /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 = 2794 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019829273223877 -- 2026-06-20 19:21:43.959[赵红兵-2794] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=wxbcb1d4382ca8035f&wxMenu_id=126 select driver_id from dbsys.sys_driver where cont_id = 2794 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016720294952393 -- 2026-06-20 19:21:43.961[赵红兵-2794] -- /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 = 2794 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0058560371398926 -- 2026-06-20 19:21:43.997[赵红兵-2794] -- /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 = 417 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2026/06/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081369876861572 -- 2026-06-20 19:22:06.185[赵红兵-2794] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2794 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015361309051514 -- 2026-06-20 19:22:06.187[赵红兵-2794] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2794 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023004055023193 -- 2026-06-20 19:22:06.235[赵红兵-2794] -- /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 = 417 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND w.truck_no like '%皖KP7866%' AND o.order_date >= '2026/06/13' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014140129089355 -- 2026-06-20 19:22:25.687[赵红兵-2794] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2794 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018107891082764 -- 2026-06-20 19:22:25.689[赵红兵-2794] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2794 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.047651052474976 -- 2026-06-20 19:22:25.762[赵红兵-2794] -- /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 = 417 OR IFNULL(oe_f.fleet_org_id,1) = 1 ) AND IFNULL(w.work_type_id,1) = 1 AND w.truck_no like '%皖KP7866%' AND o.order_date >= '2026/05/17' AND o.order_date <= '2026/06/20 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022151470184326 -- 2026-06-20 19:22:25.765[赵红兵-2794] -- /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(8296,8219,8155,8047,7954,7851) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010378122329712 -- 2026-06-20 19:28:31.875[慕杨-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.0018379688262939 -- 2026-06-20 19:28:31.877[慕杨-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.002673864364624 -- 2026-06-20 19:28:31.880[慕杨-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.0021698474884033 -- 2026-06-20 19:28:31.883[慕杨-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.0018148422241211 -- 2026-06-20 19:28:31.886[慕杨-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.0057530403137207 -- 2026-06-20 19:28:31.922[慕杨-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022799968719482 -- 2026-06-20 19:28:31.924[慕杨-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(8937,8936,8935) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094428062438965 -- 2026-06-20 19:30:15.982[唐桂-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.0018007755279541 -- 2026-06-20 19:30:15.984[唐桂-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.0025479793548584 -- 2026-06-20 19:30:15.987[唐桂-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.002147912979126 -- 2026-06-20 19:30:15.991[唐桂-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.001737117767334 -- 2026-06-20 19:30:15.992[唐桂-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.0060701370239258 -- 2026-06-20 19:30:16.355[唐桂-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/13' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022470951080322 -- 2026-06-20 19:30:16.357[唐桂-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(8969,8934,8933) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007957935333252 -- 2026-06-20 20:25:58.352 -- /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.012704133987427 -- 2026-06-20 20:25:58.633 -- /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.0017921924591064 -- 2026-06-20 20:25:58.636 -- /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.0027401447296143 -- 2026-06-20 20:25:58.639 -- /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='ocoGM6IpmRl6n-pZaj-xEdOpxQn0' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017669200897217 -- 2026-06-20 20:25:58.641 -- /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.0019559860229492 -- 2026-06-20 20:25:58.643[张雷-2498] -- /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.002349853515625 -- 2026-06-20 20:25:58.646[张雷-2498] -- /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.0017750263214111 -- 2026-06-20 20:25:58.648[张雷-2498] -- /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 = 2498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029449462890625 -- 2026-06-20 20:25:58.651[张雷-2498] -- /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 = 2498 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031399726867676 -- 2026-06-20 20:25:58.656[张雷-2498] -- /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 = 2498 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005418062210083 -- 2026-06-20 20:25:58.662[张雷-2498] -- /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 = 20087 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.0028281211853027 -- 2026-06-20 20:25:58.665[张雷-2498] -- /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.024539947509766 -- 2026-06-20 20:26:34.603[张雷-2498] -- /buz/tsl/index.php/tsloprt/driver_salary_list?event=driver_salary_edit&statement_ids=6666 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(6666) order by o.order_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089240074157715 -- 2026-06-20 20:26:42.233[张雷-2498] -- /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.0015401840209961 -- 2026-06-20 20:26:42.234[张雷-2498] -- /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 = 2498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015439987182617 -- 2026-06-20 20:26:42.236[张雷-2498] -- /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 = 2498 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027921199798584 -- 2026-06-20 20:26:42.241[张雷-2498] -- /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 = 2498 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059120655059814 -- 2026-06-20 20:26:42.247[张雷-2498] -- /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 = 20087 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.0015599727630615 -- 2026-06-20 20:26:42.248[张雷-2498] -- /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.010501861572266 -- 2026-06-20 20:28:52.399[张雷-2498] -- /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.0019371509552002 -- 2026-06-20 20:28:52.401[张雷-2498] -- /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 = 2498 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026359558105469 -- 2026-06-20 20:28:52.403[张雷-2498] -- /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 = 2498 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030150413513184 -- 2026-06-20 20:28:52.408[张雷-2498] -- /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 = 2498 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067479610443115 -- 2026-06-20 20:28:52.415[张雷-2498] -- /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 = 20087 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.0027961730957031 -- 2026-06-20 20:28:52.418[张雷-2498] -- /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.016201972961426 -- 2026-06-20 20:29:27.440[张雷-2498] -- /buz/tsl/index.php/tsloprt/driver_salary_list?para={%22event%22:%22driver_salary_edit%22,%22statement_ids%22:%226666%22}&event=driver_salary_edit&statement_ids=6666 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(6666) order by o.order_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095679759979248 -- 2026-06-20 20:32:07.149 -- /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.0018129348754883 -- 2026-06-20 20:32:07.153 -- /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.0028760433197021 -- 2026-06-20 20:32:07.156 -- /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='ocoGM6F9eiGD7Rk_4yMK55mb-C9o' and b.cont_id >1 and c.cont_isenable = 1 and c.acct_id = p_a.acct_id ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018110275268555 -- 2026-06-20 20:32:07.158 -- /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.0020239353179932 -- 2026-06-20 20:32:07.160[聂明清-2578] -- /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.0018978118896484 -- 2026-06-20 20:32:07.162[聂明清-2578] -- /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.0017580986022949 -- 2026-06-20 20:32:07.164[聂明清-2578] -- /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 = 2578 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002161979675293 -- 2026-06-20 20:32:07.166[聂明清-2578] -- /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 = 2578 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020051002502441 -- 2026-06-20 20:32:07.170[聂明清-2578] -- /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 = 2578 AND acct_id = 47 AND isenable = 1 AND driver_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038919448852539 -- 2026-06-20 20:32:07.174[聂明清-2578] -- /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 = 20225 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.0020489692687988 -- 2026-06-20 20:32:07.176[聂明清-2578] -- /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 ------------------------------------------------------------------------------------------------------------------------------------------------------