Time: 0.019000053405762 -- 25-12-02 01:05:11[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_edit?event=finish_truckwork_arvLoad select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2266 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020446062088013 -- 25-12-02 09:21:00 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040109157562256 -- 25-12-02 09:21:00 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048592090606689 -- 25-12-02 09:21:00 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='CaiJunDong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041840076446533 -- 25-12-02 09:21:00[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 47 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052330493927002 -- 25-12-02 09:21:00[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082859992980957 -- 25-12-02 09:21:00[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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 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_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 w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021079063415527 -- 25-12-02 09:31:16 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041661262512207 -- 25-12-02 09:31:16 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046517848968506 -- 25-12-02 09:31:16 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='encho' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044119358062744 -- 25-12-02 09:31:16[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 13 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004533052444458 -- 25-12-02 09:31:16[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008760929107666 -- 25-12-02 09:31:16[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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 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_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=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045719146728516 -- 25-12-02 09:31:16[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt 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(641) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020994901657104 -- 25-12-02 09:31:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046679973602295 -- 25-12-02 09:31:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&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 dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0067529678344727 -- 25-12-02 09:31:18[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&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 = 641 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022089004516602 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044331550598145 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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 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_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=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043611526489258 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt 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(641) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.041102886199951 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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 = 68255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034670829772949 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060241222381592 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 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 = 68255 and o.buzSystem_id = 15 and o.order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034770965576172 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5637794 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033531188964844 -- 25-12-02 09:31:20[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&extrafareApply_id=68255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016236066818237 -- 25-12-02 09:31:22[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003242015838623 -- 25-12-02 09:31:22[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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 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_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=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031859874725342 -- 25-12-02 09:31:22[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt 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(641) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020462036132812 -- 25-12-02 09:31:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040490627288818 -- 25-12-02 09:31:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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 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_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=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004019021987915 -- 25-12-02 09:31:27[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt 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(641) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018197774887085 -- 25-12-02 09:31:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035688877105713 -- 25-12-02 09:31:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&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 dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006119966506958 -- 25-12-02 09:31:28[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=641&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 = 641 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016463994979858 -- 25-12-02 09:31:35[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=save_order select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 68449 and order_id = 641 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031969547271729 -- 25-12-02 09:31:35[黄奕洪-2485] -- /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 = 2485 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027911901473999 -- 25-12-02 09:31:37[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2485 and acct_id = 13 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070199966430664 -- 25-12-02 09:31:37[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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 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_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=13 and o.buzSystem_id = 15 and w.driver_id = 9 AND (w.driver_id = 9 or w_sl.driver2_id = 9) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043420791625977 -- 25-12-02 09:31:37[黄奕洪-2485] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt 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(641) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024709939956665 -- 25-12-02 09:44:49 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019114017486572 -- 25-12-02 09:44:50[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22%7D&appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066790580749512 -- 25-12-02 09:44:50[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para=%7B%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22%7D&appid=ww5262fb147810c303&agentid=1000021 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 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_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 w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019052982330322 -- 25-12-02 09:44:55[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059490203857422 -- 25-12-02 09:44:55[蔡骏东-司机-2493] -- /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 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_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 w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' AND o.order_date <= '2025/12/02 23:59:59 ' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018107175827026 -- 25-12-02 11:27:04 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026700973510742 -- 25-12-02 11:27:05[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22}&appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059878826141357 -- 25-12-02 11:27:05[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?para={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22}&appid=ww5262fb147810c303&agentid=1000021 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 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_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 w.driver_id = 104 AND (w.driver_id = 104 or w_sl.driver2_id = 104) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018852949142456 -- 25-12-02 11:27:09[蔡骏东-司机-2493] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=query select driver_id from dbsys.sys_driver where cont_id = 2493 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019284963607788 -- 25-12-02 21:26:55[-2266] -- /buz/tsl/index.php/tsloprt/pickup_load_edit?event=truck_arvLoad select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2266 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019128799438477 -- 25-12-02 22:34:14 -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021270036697388 -- 25-12-02 22:34:59[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select driver_id from dbsys.sys_driver where cont_id = 2382 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041580200195312 -- 25-12-02 22:34:59[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2382 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032501935958862 -- 25-12-02 22:34:59[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} 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 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_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 oe_f.fleet_org_id IN(1,498) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047600269317627 -- 25-12-02 22:34:59[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?wxMenu_id=1&appid=ww5262fb147810c303&agentid=1000021¶={%22appid%22:%22ww5262fb147810c303%22,%22agentid%22:%221000021%22} select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt 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(732,731,730,729,728,727,726,725,724,723,722,721,720,719,718,717,716,715,714,713) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019052982330322 -- 25-12-02 22:35:11[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=732&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 = 2382 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042459964752197 -- 25-12-02 22:35:11[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=732&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 dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2382 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0065038204193115 -- 25-12-02 22:35:11[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=732&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 = 732 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016269207000732 -- 25-12-02 22:35:31[张娥-2382] -- /buz/tsl/index.php/tsloprt/get_customer_item SELECT customer_id AS `id`,shortname AS `text`,customer_id,cust_name,shortname,account_name, opening_bank,bank_account FROM dbsys.sys_customer WHERE isenable = 1 and acct_id = 47 limit 20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020318984985352 -- 25-12-02 22:36:24[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select driver_id from dbsys.sys_driver where cont_id = 2382 and acct_id = 47 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040438175201416 -- 25-12-02 22:36:24[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2382 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024916887283325 -- 25-12-02 22:36:24[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 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 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_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 oe_f.fleet_org_id IN(1,498) AND IFNULL(w.work_type_id,1) = 1 AND o.order_date >= '2025/11/25' GROUP BY o.order_id ORDER BY o.order_id DESC LIMIT 0,20 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041639804840088 -- 25-12-02 22:36:24[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?appid=ww5262fb147810c303&agentid=1000021 select e.extrafareApply_no,e.status_id extrafareapply_status_id,ef_tsl.extrafareApply_id,ef_tsl.order_id, e.apply_amt 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(732,731,730,729,728,727,726,725,724,723,722,721,720,719,718,717,716,715,714,713) and e.status_id <> 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016858100891113 -- 25-12-02 22:37:12[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=713&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 = 2382 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038189888000488 -- 25-12-02 22:37:12[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=713&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 dbsys.sys_driver d left join dbsys.sys_customer c on d.receiving_unit_id = c.customer_id where cont_id = 2382 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0057969093322754 -- 25-12-02 22:37:12[张娥-2382] -- /buz/tsl/index.php/tsloprt/driver_fareapply_list?event=driver_fareapply_edit&order_id=713&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 = 713 and o.buzSystem_id = 15 and w.work_type_id = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------