hd_real_name/logs/sys-back.log.sql.2024-07-25.0

21 lines
3.8 KiB
Plaintext

2024-07-25 14:47:36,057 [main] Starting SecurityApplication using Java 1.8.0_322 on BNS-BD19 with PID 25504 (E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\smz\gzRealNameBackstageManageWeb)
2024-07-25 14:47:36,126 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2024-07-25 14:47:36,129 [main] No active profile set, falling back to default profiles: default
2024-07-25 14:47:48,924 [main] Filter 'tokenFilter' configured for use
2024-07-25 14:47:53,125 [main] Started SecurityApplication in 18.27 seconds (JVM running for 20.016)
2024-07-25 14:47:53,132 [taskExecutor-3] --------红名单定时器启动------
2024-07-25 14:47:53,133 [taskExecutor-2] --------无信号班组有效期消息通知启动------
2024-07-25 14:47:53,133 [taskExecutor-1] --------无信号班组有效期消息通知启动------
2024-07-25 14:47:53,638 [taskExecutor-2] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = 1 and bnst.examine_status = '4'
2024-07-25 14:47:53,671 [taskExecutor-2] ==> Parameters:
2024-07-25 14:47:53,690 [taskExecutor-1] ==> Preparing: SELECT bnst.id AS id, bp.ID AS proId, bp.`name` AS proName, bs.ID AS subId, bs.SUB_NAME AS subName, bst.ID AS teamId, bst.`NAME` AS teamName, bnst.start_time AS startTime, bnst.stop_time AS stopTime, bnst.remark AS remark, bnst.examine_status AS examineStatus, bnst.examine_opinion AS examineOpinion, bnst.upload_id AS uploadId, su.USERNAME AS uploadName, GROUP_CONCAT(bnstf.file_name) AS fileName, GROUP_CONCAT(bnstf.file_path) AS filePath FROM bm_no_signal_team bnst LEFT JOIN bm_no_signal_team_file bnstf ON bnstf.no_signal_team_id = bnst.id LEFT JOIN bm_project bp ON bp.ID = bnst.pro_id LEFT JOIN bm_subcontractor bs ON bs.ID = bnst.sub_id LEFT JOIN bm_sub_team bst ON bst.ID = bnst.team_id LEFT JOIN sys_user su ON su.ID = bnst.upload_id WHERE bnst.is_active = '1' and bnst.examine_status = '1'
2024-07-25 14:47:53,691 [taskExecutor-1] ==> Parameters:
2024-07-25 14:47:53,729 [taskExecutor-1] <== Total: 1
2024-07-25 14:47:53,729 [taskExecutor-2] <== Total: 1
2024-07-25 14:47:53,732 [taskExecutor-3] ==> Preparing: SELECT a.id_number AS `key`, a.pro_id AS `value` FROM ( SELECT bwg.id_number, bwg.pro_id, bwg.org_id, COUNT( id_number ) AS likeData, IFNULL( brs.red_num, '100' ) AS num FROM bm_worker_give bwg LEFT JOIN pm_organization po on po.id = bwg.org_id LEFT JOIN pm_company pc on pc.id = po.COMPANY_ID LEFT JOIN bm_redlist_set brs ON brs.org_id = pc.id WHERE bwg.IS_ACTIVE = '1' GROUP BY bwg.id_number, bwg.pro_id HAVING COUNT( id_number ) >= num ) a LEFT JOIN bm_redlist_worker brw ON brw.ID_NUMBER = a.id_number -- AND brw.pro_id = a.pro_id WHERE brw.ID_NUMBER IS NULL
2024-07-25 14:47:53,734 [taskExecutor-1] --------无信号班组有效期消息通知结束------
2024-07-25 14:47:53,734 [taskExecutor-2] --------无信号班组有效期消息通知结束------
2024-07-25 14:47:53,734 [taskExecutor-3] ==> Parameters:
2024-07-25 14:47:53,745 [taskExecutor-3] <== Total: 0
2024-07-25 14:47:53,747 [taskExecutor-3] --------红名单定时器结束,共推数据0条------