bonus
/
hd_real_name
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
hd_real_name/logs/sys-back.log.sql.2023-06-28.0

546 lines
61 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

2023-06-28 10:10:22,720 [main] Starting SecurityApplication using Java 1.8.0_25 on BNS-BD19 with PID 15284 (E:\work\gz_workspace\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\gzRealNameBackstageManageWeb)
2023-06-28 10:10:22,727 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2023-06-28 10:10:22,727 [main] No active profile set, falling back to default profiles: default
2023-06-28 10:10:32,702 [main] SSHConnectionListener initialized ... !
2023-06-28 10:10:32,705 [main] Filter 'tokenFilter' configured for use
2023-06-28 10:10:34,980 [main] Started SecurityApplication in 13.118 seconds (JVM running for 15.399)
2023-06-28 10:15:05,532 [http-nio-1918-exec-9] 验证码：D5KH用户输入：d5kh
2023-06-28 10:15:06,411 [http-nio-1918-exec-9] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2023-06-28 10:15:06,461 [http-nio-1918-exec-9] ==> Parameters: bnsAdmin(String)
2023-06-28 10:15:06,530 [http-nio-1918-exec-9] <== Total: 1
2023-06-28 10:15:06,541 [http-nio-1918-exec-9] ==> Preparing: select distinct p.* from sys_permission p inner join sys_role_permission rp on p.id = rp.permissionId inner join sys_role_user ru on ru.roleId = rp.roleId where ru.userId = ? and p.is_active = '1' order by p.sort
2023-06-28 10:15:06,542 [http-nio-1918-exec-9] ==> Parameters: 249(Long)
2023-06-28 10:15:06,634 [http-nio-1918-exec-9] <== Total: 150
2023-06-28 10:15:06,778 [taskExecutor-1] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2023-06-28 10:15:06,782 [taskExecutor-1] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2023-06-28 10:15:06,865 [taskExecutor-1] <== Updates: 1
2023-06-28 10:15:20,003 [http-nio-1918-exec-5] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 10:15:20,004 [http-nio-1918-exec-5] ==> Parameters:
2023-06-28 10:15:20,043 [http-nio-1918-exec-5] <== Total: 1
2023-06-28 10:15:20,044 [http-nio-1918-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 10:15:20,045 [http-nio-1918-exec-5] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 10:15:20,087 [http-nio-1918-exec-5] <== Total: 4
2023-06-28 10:17:40,409 [main] Starting SecurityApplication using Java 1.8.0_25 on BNS-BD19 with PID 10860 (E:\work\gz_workspace\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\gzRealNameBackstageManageWeb)
2023-06-28 10:17:40,413 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2023-06-28 10:17:40,414 [main] No active profile set, falling back to default profiles: default
2023-06-28 10:17:44,581 [main] SSHConnectionListener initialized ... !
2023-06-28 10:17:44,584 [main] Filter 'tokenFilter' configured for use
2023-06-28 10:17:46,522 [main] Started SecurityApplication in 6.615 seconds (JVM running for 8.283)
2023-06-28 10:18:35,873 [http-nio-1920-exec-2] 验证码：66RW用户输入：66rw
2023-06-28 10:18:36,535 [http-nio-1920-exec-2] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2023-06-28 10:18:36,552 [http-nio-1920-exec-2] ==> Parameters: bnsAdmin(String)
2023-06-28 10:18:36,617 [http-nio-1920-exec-2] <== Total: 1
2023-06-28 10:18:36,626 [http-nio-1920-exec-2] ==> Preparing: select distinct p.* from sys_permission p inner join sys_role_permission rp on p.id = rp.permissionId inner join sys_role_user ru on ru.roleId = rp.roleId where ru.userId = ? and p.is_active = '1' order by p.sort
2023-06-28 10:18:36,627 [http-nio-1920-exec-2] ==> Parameters: 249(Long)
2023-06-28 10:18:36,720 [http-nio-1920-exec-2] <== Total: 150
2023-06-28 10:18:36,822 [taskExecutor-1] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2023-06-28 10:18:36,826 [taskExecutor-1] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2023-06-28 10:18:36,914 [taskExecutor-1] <== Updates: 1
2023-06-28 10:18:41,482 [http-nio-1920-exec-2] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 10:18:41,483 [http-nio-1920-exec-2] ==> Parameters:
2023-06-28 10:18:41,526 [http-nio-1920-exec-2] <== Total: 1
2023-06-28 10:18:41,527 [http-nio-1920-exec-2] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 10:18:41,528 [http-nio-1920-exec-2] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 10:18:41,571 [http-nio-1920-exec-2] <== Total: 4
2023-06-28 10:56:35,540 [http-nio-1920-exec-7] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 10:56:35,542 [http-nio-1920-exec-7] ==> Parameters:
2023-06-28 10:56:35,583 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 10:56:35,584 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 10:56:35,585 [http-nio-1920-exec-7] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 10:56:35,630 [http-nio-1920-exec-7] <== Total: 4
2023-06-28 10:59:17,211 [http-nio-1920-exec-8] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 10:59:17,211 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 10:59:17,251 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 10:59:17,252 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 10:59:17,253 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 10:59:17,296 [http-nio-1920-exec-8] <== Total: 4
2023-06-28 11:02:12,909 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:02:12,909 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 11:02:12,949 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 11:02:12,950 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:02:12,951 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:02:12,994 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 11:09:23,093 [http-nio-1920-exec-8] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:09:23,094 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 11:09:23,144 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 11:09:23,145 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:09:23,145 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:09:23,204 [http-nio-1920-exec-8] <== Total: 4
2023-06-28 11:11:51,336 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:11:51,337 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 11:11:51,378 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 11:11:51,379 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:11:51,380 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:11:51,429 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 11:11:53,833 [http-nio-1920-exec-6] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:11:53,835 [http-nio-1920-exec-6] ==> Parameters:
2023-06-28 11:11:53,878 [http-nio-1920-exec-6] <== Total: 1
2023-06-28 11:11:53,881 [http-nio-1920-exec-6] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:11:53,882 [http-nio-1920-exec-6] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:11:53,927 [http-nio-1920-exec-6] <== Total: 4
2023-06-28 11:11:54,733 [http-nio-1920-exec-4] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:11:54,734 [http-nio-1920-exec-4] ==> Parameters:
2023-06-28 11:11:54,775 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 11:11:54,775 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:11:54,776 [http-nio-1920-exec-4] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:11:54,818 [http-nio-1920-exec-4] <== Total: 4
2023-06-28 11:14:21,250 [http-nio-1920-exec-5] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:14:21,251 [http-nio-1920-exec-5] ==> Parameters:
2023-06-28 11:14:21,296 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 11:14:21,297 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:14:21,298 [http-nio-1920-exec-5] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:14:21,340 [http-nio-1920-exec-5] <== Total: 4
2023-06-28 11:20:35,628 [http-nio-1920-exec-4] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:20:35,629 [http-nio-1920-exec-4] ==> Parameters:
2023-06-28 11:20:35,672 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 11:20:35,673 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:20:35,673 [http-nio-1920-exec-4] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:20:35,719 [http-nio-1920-exec-4] <== Total: 4
2023-06-28 11:21:21,387 [http-nio-1920-exec-9] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:21:21,387 [http-nio-1920-exec-9] ==> Parameters:
2023-06-28 11:21:21,428 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 11:21:21,429 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:21:21,430 [http-nio-1920-exec-9] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:21:21,474 [http-nio-1920-exec-9] <== Total: 4
2023-06-28 11:21:37,557 [http-nio-1920-exec-8] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:21:37,558 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 11:21:37,608 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 11:21:37,609 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:21:37,609 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:21:37,653 [http-nio-1920-exec-8] <== Total: 4
2023-06-28 11:21:54,759 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:21:54,759 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 11:21:54,801 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 11:21:54,802 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:21:54,803 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:21:54,846 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 11:22:03,428 [http-nio-1920-exec-7] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:22:03,429 [http-nio-1920-exec-7] ==> Parameters:
2023-06-28 11:22:03,472 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 11:22:03,472 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:22:03,473 [http-nio-1920-exec-7] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:22:03,515 [http-nio-1920-exec-7] <== Total: 4
2023-06-28 11:22:44,283 [http-nio-1920-exec-9] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:22:44,283 [http-nio-1920-exec-9] ==> Parameters:
2023-06-28 11:22:44,325 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 11:22:44,326 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:22:44,327 [http-nio-1920-exec-9] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:22:44,370 [http-nio-1920-exec-9] <== Total: 4
2023-06-28 11:23:13,202 [http-nio-1920-exec-3] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:23:13,203 [http-nio-1920-exec-3] ==> Parameters:
2023-06-28 11:23:13,248 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 11:23:13,249 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:23:13,250 [http-nio-1920-exec-3] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:23:13,297 [http-nio-1920-exec-3] <== Total: 4
2023-06-28 11:27:27,438 [http-nio-1920-exec-5] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:27:27,439 [http-nio-1920-exec-5] ==> Parameters:
2023-06-28 11:27:27,481 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 11:27:27,483 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:27:27,483 [http-nio-1920-exec-5] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:27:27,525 [http-nio-1920-exec-5] <== Total: 4
2023-06-28 11:29:03,037 [http-nio-1920-exec-3] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 11:29:03,037 [http-nio-1920-exec-3] ==> Parameters:
2023-06-28 11:29:03,077 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 11:29:03,078 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 11:29:03,078 [http-nio-1920-exec-3] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 11:29:03,121 [http-nio-1920-exec-3] <== Total: 4
2023-06-28 13:15:16,157 [http-nio-1920-exec-10] 验证码：TEFF用户输入：teff
2023-06-28 13:15:16,686 [http-nio-1920-exec-10] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2023-06-28 13:15:16,691 [http-nio-1920-exec-10] ==> Parameters: bnsAdmin(String)
2023-06-28 13:15:16,743 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 13:15:16,749 [http-nio-1920-exec-10] ==> Preparing: select distinct p.* from sys_permission p inner join sys_role_permission rp on p.id = rp.permissionId inner join sys_role_user ru on ru.roleId = rp.roleId where ru.userId = ? and p.is_active = '1' order by p.sort
2023-06-28 13:15:16,750 [http-nio-1920-exec-10] ==> Parameters: 249(Long)
2023-06-28 13:15:16,836 [http-nio-1920-exec-10] <== Total: 150
2023-06-28 13:15:16,935 [taskExecutor-2] ==> Preparing: insert into sys_logs(userId, module, flag, remark, createTime) values(?, ?, ?, ?, now())
2023-06-28 13:15:16,938 [taskExecutor-2] ==> Parameters: 249(Long), 登陆(String), true(Boolean), null
2023-06-28 13:15:17,020 [taskExecutor-2] <== Updates: 1
2023-06-28 13:15:41,668 [http-nio-1920-exec-2] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 13:15:41,669 [http-nio-1920-exec-2] ==> Parameters:
2023-06-28 13:15:41,711 [http-nio-1920-exec-2] <== Total: 1
2023-06-28 13:15:41,712 [http-nio-1920-exec-2] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 13:15:41,712 [http-nio-1920-exec-2] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 13:15:41,753 [http-nio-1920-exec-2] <== Total: 4
2023-06-28 13:21:13,409 [http-nio-1920-exec-6] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 13:21:13,409 [http-nio-1920-exec-6] ==> Parameters:
2023-06-28 13:21:13,459 [http-nio-1920-exec-6] <== Total: 1
2023-06-28 13:21:13,460 [http-nio-1920-exec-6] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 13:21:13,460 [http-nio-1920-exec-6] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 13:21:13,508 [http-nio-1920-exec-6] <== Total: 4
2023-06-28 13:36:34,928 [http-nio-1920-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 13:36:34,949 [http-nio-1920-exec-3] ==> Parameters: null
2023-06-28 13:36:34,991 [http-nio-1920-exec-3] <== Total: 0
2023-06-28 13:36:34,994 [http-nio-1920-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 13:36:34,995 [http-nio-1920-exec-3] ==> Parameters: null
2023-06-28 13:36:35,036 [http-nio-1920-exec-3] <== Total: 0
2023-06-28 13:36:35,046 [http-nio-1920-exec-3] ==> Preparing: SELECT count(bw.ID_NUMBER) FROM bm_worker bw left join bm_worker_record bwr on bwr.ID_NUMBER = bw.ID_NUMBER left join pm_organization po on po.ID = bwr.ORG_ID where bw.IS_ACTIVE=1 and bwr.IS_ACTIVE=1 and po.IS_ACTIVE=1
2023-06-28 13:36:35,047 [http-nio-1920-exec-3] ==> Parameters:
2023-06-28 13:36:35,175 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 13:36:35,176 [http-nio-1920-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 13:36:35,177 [http-nio-1920-exec-3] ==> Parameters: null
2023-06-28 13:36:35,218 [http-nio-1920-exec-3] <== Total: 0
2023-06-28 13:36:35,220 [http-nio-1920-exec-3] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 13:36:35,221 [http-nio-1920-exec-3] ==> Parameters: null
2023-06-28 13:36:35,261 [http-nio-1920-exec-3] <== Total: 0
2023-06-28 13:36:35,265 [http-nio-1920-exec-3] ==> Preparing: SELECT a.ID_NUMBER, sum( a.num ) AS totalNum, group_concat( a.photoName ) AS photoName, group_concat( a.photoPath ) AS photoPath, group_concat( a.uploadTime ) AS uploadTime, a.`name`, a.sex, a.ethnic, a.birthday, a.address, a.issureAuthority, a.signDate, a.expiryDate, a.phone FROM ( SELECT bw.ID_NUMBER, count( bwp.ID_NUMBER ) AS num, group_concat( CASE bwp.PHOTO_TYPE WHEN '1' THEN '正面身份证' WHEN '2' THEN '反面身份证' WHEN '3' THEN '人脸' WHEN '4' THEN '银行卡' WHEN '5' THEN '签名照' ELSE '异常照片类型' END ) AS photoName, group_concat( PHOTO_PATH ) AS photoPath, group_concat( bwp.upload_time ) AS uploadTime, bw.NAME AS NAME, bw.SEX AS sex, bw.ETHNIC AS ethnic, bw.BIRTHDAY AS birthday, bw.ADDRESS AS address, bw.ISSUEAUTHORITY AS issureAuthority, bw.SIGN_DATE AS signDate, bw.EXPIRY_DATE AS expiryDate, bw.phone FROM bm_worker bw LEFT JOIN bm_worker_photo bwp ON bw.ID_NUMBER = bwp.ID_NUMBER AND bwp.IS_ACTIVE = '1' WHERE bw.ID_NUMBER != '' AND bw.IS_ACTIVE = '1' GROUP BY bw.ID_NUMBER ) a LEFT JOIN bm_worker_record bwr ON bwr.ID_NUMBER = a.ID_NUMBER LEFT JOIN pm_organization po ON po.ID = bwr.ORG_ID WHERE bwr.IS_ACTIVE='1' and po.IS_ACTIVE='1' GROUP BY a.ID_NUMBER limit ?, ?
2023-06-28 13:36:35,266 [http-nio-1920-exec-3] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 13:36:35,759 [http-nio-1920-exec-3] <== Total: 10
2023-06-28 15:04:54,601 [main] Starting SecurityApplication using Java 1.8.0_25 on BNS-BD19 with PID 29148 (E:\work\gz_workspace\gzRealNameBackstageManageWeb\target\classes started by admin in E:\work\gz_workspace\gzRealNameBackstageManageWeb)
2023-06-28 15:04:54,604 [main] Running with Spring Boot v2.4.5, Spring v5.3.6
2023-06-28 15:04:54,605 [main] No active profile set, falling back to default profiles: default
2023-06-28 15:05:09,142 [main] SSHConnectionListener initialized ... !
2023-06-28 15:05:09,145 [main] Filter 'tokenFilter' configured for use
2023-06-28 15:05:11,506 [main] Started SecurityApplication in 17.619 seconds (JVM running for 19.889)
2023-06-28 15:05:19,550 [http-nio-1920-exec-3] ==> Preparing: select t.id as userId,t.* from sys_user t where t.USERNAME = ? and IS_ACTIVE = 1 and examine_status = 1
2023-06-28 15:05:19,584 [http-nio-1920-exec-3] ==> Parameters: bnsAdmin(String)
2023-06-28 15:05:19,688 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 15:05:19,698 [http-nio-1920-exec-3] ==> Preparing: select distinct p.* from sys_permission p inner join sys_role_permission rp on p.id = rp.permissionId inner join sys_role_user ru on ru.roleId = rp.roleId where ru.userId = ? and p.is_active = '1' order by p.sort
2023-06-28 15:05:19,699 [http-nio-1920-exec-3] ==> Parameters: 249(Long)
2023-06-28 15:05:19,795 [http-nio-1920-exec-3] <== Total: 150
2023-06-28 15:05:20,017 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:05:20,018 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 15:05:20,058 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 15:05:20,059 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:05:20,060 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:05:20,101 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 15:06:17,140 [http-nio-1920-exec-7] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:06:17,140 [http-nio-1920-exec-7] ==> Parameters:
2023-06-28 15:06:17,181 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 15:06:17,182 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:06:17,183 [http-nio-1920-exec-7] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:06:17,224 [http-nio-1920-exec-7] <== Total: 4
2023-06-28 15:06:20,881 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:06:20,882 [http-nio-1920-exec-8] ==> Parameters: 7(Long)
2023-06-28 15:06:20,925 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 15:08:06,013 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:08:06,014 [http-nio-1920-exec-9] ==> Parameters: 7(Long)
2023-06-28 15:08:06,057 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 15:13:01,402 [http-nio-1920-exec-7] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:13:01,404 [http-nio-1920-exec-7] ==> Parameters:
2023-06-28 15:13:01,446 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 15:13:01,447 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:13:01,447 [http-nio-1920-exec-7] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:13:01,488 [http-nio-1920-exec-7] <== Total: 4
2023-06-28 15:13:11,809 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:13:11,810 [http-nio-1920-exec-8] ==> Parameters: 7(Long)
2023-06-28 15:13:11,855 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 15:14:13,827 [http-nio-1920-exec-8] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:14:13,827 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 15:14:13,869 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 15:14:13,870 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:14:13,871 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:14:13,912 [http-nio-1920-exec-8] <== Total: 4
2023-06-28 15:14:20,820 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:14:20,820 [http-nio-1920-exec-4] ==> Parameters: 7(Long)
2023-06-28 15:14:20,863 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 15:16:36,946 [http-nio-1920-exec-8] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:16:36,946 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 15:16:36,988 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 15:16:36,990 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:16:36,991 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:16:37,034 [http-nio-1920-exec-8] <== Total: 4
2023-06-28 15:16:38,573 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:16:38,574 [http-nio-1920-exec-10] ==> Parameters: 7(Long)
2023-06-28 15:16:38,615 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 15:16:58,588 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:16:58,589 [http-nio-1920-exec-3] ==> Parameters: 7(Long)
2023-06-28 15:16:58,630 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 15:18:25,567 [http-nio-1920-exec-4] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:18:25,567 [http-nio-1920-exec-4] ==> Parameters:
2023-06-28 15:18:25,608 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 15:18:25,609 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:18:25,609 [http-nio-1920-exec-4] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:18:25,649 [http-nio-1920-exec-4] <== Total: 4
2023-06-28 15:18:27,015 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:18:27,015 [http-nio-1920-exec-9] ==> Parameters: 7(Long)
2023-06-28 15:18:27,057 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 15:19:18,121 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:19:18,122 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 15:19:18,162 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 15:19:18,163 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:19:18,163 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:19:18,204 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 15:19:19,246 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:19:19,247 [http-nio-1920-exec-8] ==> Parameters: 7(Long)
2023-06-28 15:19:19,288 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 15:21:15,408 [http-nio-1920-exec-6] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 15:21:15,409 [http-nio-1920-exec-6] ==> Parameters: null
2023-06-28 15:21:15,450 [http-nio-1920-exec-6] <== Total: 0
2023-06-28 15:21:15,451 [http-nio-1920-exec-6] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-06-28 15:21:15,452 [http-nio-1920-exec-6] ==> Parameters:
2023-06-28 15:21:15,494 [http-nio-1920-exec-6] <== Total: 12
2023-06-28 15:21:15,559 [http-nio-1920-exec-9] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 15:21:15,559 [http-nio-1920-exec-9] ==> Parameters: null
2023-06-28 15:21:15,599 [http-nio-1920-exec-9] <== Total: 0
2023-06-28 15:21:15,600 [http-nio-1920-exec-9] ==> Preparing: select ID,`NAME` FROM bm_project WHERE IS_ACTIVE = '1' and status = ? ORDER BY `NAME` asc
2023-06-28 15:21:15,601 [http-nio-1920-exec-9] ==> Parameters: 在建(String)
2023-06-28 15:21:15,686 [http-nio-1920-exec-9] <== Total: 245
2023-06-28 15:21:15,827 [http-nio-1920-exec-1] ==> Preparing: SELECT COUNT(1) FROM bm_project bp LEFT JOIN pm_company pc on bp.company_id = pc.ID where bp.IS_ACTIVE = 1 and bp.`STATUS` =?
2023-06-28 15:21:15,828 [http-nio-1920-exec-1] ==> Parameters: 在建(String)
2023-06-28 15:21:15,868 [http-nio-1920-exec-1] <== Total: 1
2023-06-28 15:21:15,869 [http-nio-1920-exec-1] ==> Preparing: SELECT bp.id ,pc.`org_name` as orgName,bp.name as name,bp.pro_type as proType,sdd.name as voltageLevel,bp.status as status, bp.origin AS origin,bp.is_push as isPush, bp.push_time as pushTime FROM bm_project bp LEFT JOIN pm_company pc on bp.company_id = pc.ID LEFT JOIN sys_dic_detail sdd on sdd.id = bp.voltage_level where bp.IS_ACTIVE = 1 and bp.`STATUS` =? limit ?, ?
2023-06-28 15:21:15,870 [http-nio-1920-exec-1] ==> Parameters: 在建(String), 0(Integer), 10(Integer)
2023-06-28 15:21:15,911 [http-nio-1920-exec-1] <== Total: 10
2023-06-28 15:21:17,538 [http-nio-1920-exec-4] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 15:21:17,539 [http-nio-1920-exec-4] ==> Parameters: null
2023-06-28 15:21:17,579 [http-nio-1920-exec-4] <== Total: 0
2023-06-28 15:21:17,580 [http-nio-1920-exec-4] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-06-28 15:21:17,581 [http-nio-1920-exec-4] ==> Parameters:
2023-06-28 15:21:17,623 [http-nio-1920-exec-4] <== Total: 12
2023-06-28 15:21:17,639 [http-nio-1920-exec-7] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 15:21:17,639 [http-nio-1920-exec-7] ==> Parameters: null
2023-06-28 15:21:17,679 [http-nio-1920-exec-7] <== Total: 0
2023-06-28 15:21:17,680 [http-nio-1920-exec-7] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-06-28 15:21:17,680 [http-nio-1920-exec-7] ==> Parameters:
2023-06-28 15:21:17,720 [http-nio-1920-exec-7] <== Total: 12
2023-06-28 15:21:17,739 [http-nio-1920-exec-9] ==> Preparing: select id, name from sys_dic_detail where dic_type = 5 and is_active = '1'
2023-06-28 15:21:17,741 [http-nio-1920-exec-9] ==> Parameters:
2023-06-28 15:21:17,783 [http-nio-1920-exec-9] <== Total: 10
2023-06-28 15:21:17,796 [http-nio-1920-exec-2] ==> Preparing: select id, name from sys_dic_detail where dic_type = 4 and is_active = '1'
2023-06-28 15:21:17,799 [http-nio-1920-exec-2] ==> Parameters:
2023-06-28 15:21:17,846 [http-nio-1920-exec-2] <== Total: 35
2023-06-28 15:21:17,846 [http-nio-1920-exec-5] ==> Preparing: select id, CONCAT(CODE,'-',`name`) as registerAddressCode from sys_dic_detail where dic_type = '2' and is_active = '1'
2023-06-28 15:21:17,847 [http-nio-1920-exec-5] ==> Parameters:
2023-06-28 15:21:17,925 [http-nio-1920-exec-5] <== Total: 168
2023-06-28 15:21:24,503 [http-nio-1920-exec-7] id：90
2023-06-28 15:21:24,526 [http-nio-1920-exec-7] ==> Preparing: select bp.id, bp.org_id as orgId, bp.company_id as companyId, pm.org_name as orgName, bp.name as name, bp.abbreviation as abbreviation, bp.pro_type as proType, bp.status as status, spo.id as voltageLevelId, bp.`power_grid` as powerGrid, bp.`origin` as origin, bp.`lon` as lon, bp.`lat` as lat, bp.record_id as recordId, bp.`start_time` as startTime, bp.`end_time` as endTime, bp.`contractSigningDate` as contractSigningDate, bp.`contractPrice` as contractPrice, bp.`isRegistered` as isRegistered, sdd.id as registerAddressCodeId, CONCAT(sdd.code ,'-',sdd.`name`) as registerAddressCode, bp.`isInsurance`, bp.`payment_type`, bp.`security_payments`, bp.`payment_file`, bp.`payDate` as payDate, bp.`labourSpecialName` as labourSpecialName, bp.`labourSpecialPhone` as labourSpecialPhone, bp.`labourSpecialIdCard` as labourSpecialIdCard, bp.`board_file` as boardFile, bp.`project_manager` as projectManager, bp.`phone` as phone, bp.`manager_number` as managerNumber, bp.`approachDate` as approachDate, bp.`pro_leader` as proLeader, sd.id as bankAccountId, bp.`special_bank_type` as specialBankType, bp.`open_bank_type` as openBankType, bp.`account_name` as accountName, bp.`pro_leader_phone` as proLeaderPhone, bp.`open_bank_number` as openBankNumber, bp.`bank_name` as bankName, bp.`pay_way` as payWay, bp.`construction_contract_url` as constructionContractUrl, bp.`set_tlement_date` as setTlementDate, bp.`set_tlement_cycle` as setTlementCycle, bp.`set_tlement_amount` as setTlementAmount, bp.`account_balance` as accountBalance, bp.tripartiteAgreementUrl as tripartiteAgreementUrl, a.securityMaymentsNum as securityMaymentsNum, a.securityName, a.fileType, a.securityMaymentsFilePaths, a.securityMaymentsFileId, b.broadNum, b.broadFilePaths, b.boardFileId, bpfp1.org_name AS orgName, bpfp1.org_credit_code AS orgCreditCode, bpfp1.register_address AS orgRegisterAddress, bpfp1.project_manager AS orgProjectManager, bpfp1.project_manager_phone AS orgProjectManagerPhone, bpfp1.project_manager_id_card_num AS orgProjectManagerIdCardNum, bpfp1.project_manager_approach_date AS orgApproachDate , bpfp2.org_name AS orgDesignName, bpfp2.org_credit_code AS orgDesignCreditCode, bpfp2.project_manager AS orgDesignProjectManager, bpfp2.project_manager_phone AS orgDesignProjectManagerPhone, bpfp2.project_manager_id_card_num AS orgDesignProjectManagerIdCardNum , bpfp3.org_name AS orgOwnerName, bpfp3.org_credit_code AS orgOwnerCreditCode, bpfp3.project_manager AS orgOwnerProjectManager, bpfp3.project_manager_phone AS orgOwnerProjectManagerPhone, bpfp3.project_manager_id_card_num AS orgOwnerProjectManagerIdCardNum , bpfp4.org_name AS orgSupervisionName, bpfp4.org_credit_code AS orgSupervisionCreditCode, bpfp4.project_manager AS orgSupervisionProjectManager, bpfp4.project_manager_phone AS orgSupervisionProjectManagerPhone, bpfp4.project_manager_id_card_num AS orgSupervisionProjectManagerIdCardNum , bpfp5.org_name AS orgSurveyName, bpfp5.org_credit_code AS orgSurveyCreditCode, bpfp5.project_manager AS orgSurveyProjectManager, bpfp5.project_manager_phone AS orgSurveyProjectManagerPhone, bpfp5.project_manager_id_card_num AS orgSurveyProjectManagerIdCardNum FROM bm_project bp LEFT JOIN bm_project_five_parties bpfp1 ON bpfp1.pro_id = bp.id AND bpfp1.`type` = '1' AND bpfp1.is_active = '1' LEFT JOIN bm_project_five_parties bpfp2 ON bpfp2.pro_id = bp.id AND bpfp2.`type` = '2' AND bpfp2.is_active = '1' LEFT JOIN bm_project_five_parties bpfp3 ON bpfp3.pro_id = bp.id AND bpfp3.`type` = '3' AND bpfp3.is_active = '1' LEFT JOIN bm_project_five_parties bpfp4 ON bpfp4.pro_id = bp.id AND bpfp4.`type` = '4' AND bpfp4.is_active = '1' LEFT JOIN bm_project_five_parties bpfp5 ON bpfp5.pro_id = bp.id AND bpfp5.`type` = '5' AND bpfp5.is_active = '1' LEFT JOIN pm_company pm on pm.ID = bp.company_id LEFT JOIN sys_dic_detail sdd on sdd.id = bp.registerAddressCode LEFT JOIN sys_dic_detail sd on sd.id = bp.bank_account LEFT JOIN sys_dic_detail spo on spo.id = bp.voltage_level left join ( select id, pro_id, GROUP_CONCAT(file_name) as securityName, GROUP_CONCAT(file_type) as fileType, count(1) as securityMaymentsNum, GROUP_CONCAT(file_path) as securityMaymentsFilePaths, GROUP_CONCAT(id) AS securityMaymentsFileId from bm_project_file where pro_id = ? and is_active = '1' and accessory_type = '0' group by accessory_type ) a on a.pro_id = bp.id left join ( select id, pro_id, file_name as boradFileName, count(1) as broadNum, GROUP_CONCAT(file_path) as broadFilePaths, GROUP_CONCAT(id) AS boardFileId from bm_project_file where pro_id = ? and is_active = '1' and accessory_type = '1' group by accessory_type ) b on b.pro_id = bp.id WHERE bp.IS_ACTIVE = '1' AND bp.ID = ?
2023-06-28 15:21:24,529 [http-nio-1920-exec-7] ==> Parameters: 90(String), 90(String), 90(String)
2023-06-28 15:21:24,615 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 15:21:24,745 [http-nio-1920-exec-2] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 15:21:24,746 [http-nio-1920-exec-2] ==> Parameters: null
2023-06-28 15:21:24,750 [http-nio-1920-exec-6] ==> Preparing: select id, name from sys_dic_detail where dic_type = 5 and is_active = '1'
2023-06-28 15:21:24,751 [http-nio-1920-exec-6] ==> Parameters:
2023-06-28 15:21:24,803 [http-nio-1920-exec-2] <== Total: 0
2023-06-28 15:21:24,804 [http-nio-1920-exec-5] ==> Preparing: select id, CONCAT(CODE,'-',`name`) as registerAddressCode from sys_dic_detail where dic_type = '2' and is_active = '1'
2023-06-28 15:21:24,804 [http-nio-1920-exec-5] ==> Parameters:
2023-06-28 15:21:24,844 [http-nio-1920-exec-6] <== Total: 10
2023-06-28 15:21:24,844 [http-nio-1920-exec-1] ==> Preparing: select id, name from sys_dic_detail where dic_type = 4 and is_active = '1'
2023-06-28 15:21:24,845 [http-nio-1920-exec-1] ==> Parameters:
2023-06-28 15:21:24,885 [http-nio-1920-exec-5] <== Total: 168
2023-06-28 15:21:24,886 [http-nio-1920-exec-2] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-06-28 15:21:24,886 [http-nio-1920-exec-2] ==> Parameters:
2023-06-28 15:21:24,974 [http-nio-1920-exec-1] <== Total: 35
2023-06-28 15:21:25,014 [http-nio-1920-exec-2] <== Total: 12
2023-06-28 15:21:45,927 [http-nio-1920-exec-6] id：94
2023-06-28 15:21:45,928 [http-nio-1920-exec-6] ==> Preparing: select bp.id, bp.org_id as orgId, bp.company_id as companyId, pm.org_name as orgName, bp.name as name, bp.abbreviation as abbreviation, bp.pro_type as proType, bp.status as status, spo.id as voltageLevelId, bp.`power_grid` as powerGrid, bp.`origin` as origin, bp.`lon` as lon, bp.`lat` as lat, bp.record_id as recordId, bp.`start_time` as startTime, bp.`end_time` as endTime, bp.`contractSigningDate` as contractSigningDate, bp.`contractPrice` as contractPrice, bp.`isRegistered` as isRegistered, sdd.id as registerAddressCodeId, CONCAT(sdd.code ,'-',sdd.`name`) as registerAddressCode, bp.`isInsurance`, bp.`payment_type`, bp.`security_payments`, bp.`payment_file`, bp.`payDate` as payDate, bp.`labourSpecialName` as labourSpecialName, bp.`labourSpecialPhone` as labourSpecialPhone, bp.`labourSpecialIdCard` as labourSpecialIdCard, bp.`board_file` as boardFile, bp.`project_manager` as projectManager, bp.`phone` as phone, bp.`manager_number` as managerNumber, bp.`approachDate` as approachDate, bp.`pro_leader` as proLeader, sd.id as bankAccountId, bp.`special_bank_type` as specialBankType, bp.`open_bank_type` as openBankType, bp.`account_name` as accountName, bp.`pro_leader_phone` as proLeaderPhone, bp.`open_bank_number` as openBankNumber, bp.`bank_name` as bankName, bp.`pay_way` as payWay, bp.`construction_contract_url` as constructionContractUrl, bp.`set_tlement_date` as setTlementDate, bp.`set_tlement_cycle` as setTlementCycle, bp.`set_tlement_amount` as setTlementAmount, bp.`account_balance` as accountBalance, bp.tripartiteAgreementUrl as tripartiteAgreementUrl, a.securityMaymentsNum as securityMaymentsNum, a.securityName, a.fileType, a.securityMaymentsFilePaths, a.securityMaymentsFileId, b.broadNum, b.broadFilePaths, b.boardFileId, bpfp1.org_name AS orgName, bpfp1.org_credit_code AS orgCreditCode, bpfp1.register_address AS orgRegisterAddress, bpfp1.project_manager AS orgProjectManager, bpfp1.project_manager_phone AS orgProjectManagerPhone, bpfp1.project_manager_id_card_num AS orgProjectManagerIdCardNum, bpfp1.project_manager_approach_date AS orgApproachDate , bpfp2.org_name AS orgDesignName, bpfp2.org_credit_code AS orgDesignCreditCode, bpfp2.project_manager AS orgDesignProjectManager, bpfp2.project_manager_phone AS orgDesignProjectManagerPhone, bpfp2.project_manager_id_card_num AS orgDesignProjectManagerIdCardNum , bpfp3.org_name AS orgOwnerName, bpfp3.org_credit_code AS orgOwnerCreditCode, bpfp3.project_manager AS orgOwnerProjectManager, bpfp3.project_manager_phone AS orgOwnerProjectManagerPhone, bpfp3.project_manager_id_card_num AS orgOwnerProjectManagerIdCardNum , bpfp4.org_name AS orgSupervisionName, bpfp4.org_credit_code AS orgSupervisionCreditCode, bpfp4.project_manager AS orgSupervisionProjectManager, bpfp4.project_manager_phone AS orgSupervisionProjectManagerPhone, bpfp4.project_manager_id_card_num AS orgSupervisionProjectManagerIdCardNum , bpfp5.org_name AS orgSurveyName, bpfp5.org_credit_code AS orgSurveyCreditCode, bpfp5.project_manager AS orgSurveyProjectManager, bpfp5.project_manager_phone AS orgSurveyProjectManagerPhone, bpfp5.project_manager_id_card_num AS orgSurveyProjectManagerIdCardNum FROM bm_project bp LEFT JOIN bm_project_five_parties bpfp1 ON bpfp1.pro_id = bp.id AND bpfp1.`type` = '1' AND bpfp1.is_active = '1' LEFT JOIN bm_project_five_parties bpfp2 ON bpfp2.pro_id = bp.id AND bpfp2.`type` = '2' AND bpfp2.is_active = '1' LEFT JOIN bm_project_five_parties bpfp3 ON bpfp3.pro_id = bp.id AND bpfp3.`type` = '3' AND bpfp3.is_active = '1' LEFT JOIN bm_project_five_parties bpfp4 ON bpfp4.pro_id = bp.id AND bpfp4.`type` = '4' AND bpfp4.is_active = '1' LEFT JOIN bm_project_five_parties bpfp5 ON bpfp5.pro_id = bp.id AND bpfp5.`type` = '5' AND bpfp5.is_active = '1' LEFT JOIN pm_company pm on pm.ID = bp.company_id LEFT JOIN sys_dic_detail sdd on sdd.id = bp.registerAddressCode LEFT JOIN sys_dic_detail sd on sd.id = bp.bank_account LEFT JOIN sys_dic_detail spo on spo.id = bp.voltage_level left join ( select id, pro_id, GROUP_CONCAT(file_name) as securityName, GROUP_CONCAT(file_type) as fileType, count(1) as securityMaymentsNum, GROUP_CONCAT(file_path) as securityMaymentsFilePaths, GROUP_CONCAT(id) AS securityMaymentsFileId from bm_project_file where pro_id = ? and is_active = '1' and accessory_type = '0' group by accessory_type ) a on a.pro_id = bp.id left join ( select id, pro_id, file_name as boradFileName, count(1) as broadNum, GROUP_CONCAT(file_path) as broadFilePaths, GROUP_CONCAT(id) AS boardFileId from bm_project_file where pro_id = ? and is_active = '1' and accessory_type = '1' group by accessory_type ) b on b.pro_id = bp.id WHERE bp.IS_ACTIVE = '1' AND bp.ID = ?
2023-06-28 15:21:45,930 [http-nio-1920-exec-6] ==> Parameters: 94(String), 94(String), 94(String)
2023-06-28 15:21:45,979 [http-nio-1920-exec-6] <== Total: 1
2023-06-28 15:21:46,060 [http-nio-1920-exec-1] ==> Preparing: select COMPANY_ID as companyId from pm_organization where ID = ? and IS_ACTIVE = '1'
2023-06-28 15:21:46,061 [http-nio-1920-exec-1] ==> Parameters: null
2023-06-28 15:21:46,076 [http-nio-1920-exec-8] ==> Preparing: select id, name from sys_dic_detail where dic_type = 5 and is_active = '1'
2023-06-28 15:21:46,077 [http-nio-1920-exec-2] ==> Preparing: select id, CONCAT(CODE,'-',`name`) as registerAddressCode from sys_dic_detail where dic_type = '2' and is_active = '1'
2023-06-28 15:21:46,077 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 15:21:46,077 [http-nio-1920-exec-2] ==> Parameters:
2023-06-28 15:21:46,099 [http-nio-1920-exec-1] <== Total: 0
2023-06-28 15:21:46,100 [http-nio-1920-exec-3] ==> Preparing: select id, name from sys_dic_detail where dic_type = 4 and is_active = '1'
2023-06-28 15:21:46,101 [http-nio-1920-exec-3] ==> Parameters:
2023-06-28 15:21:46,143 [http-nio-1920-exec-8] <== Total: 10
2023-06-28 15:21:46,144 [http-nio-1920-exec-1] ==> Preparing: select ID, `org_name` as name from pm_company where IS_ACTIVE = 1
2023-06-28 15:21:46,144 [http-nio-1920-exec-2] <== Total: 168
2023-06-28 15:21:46,144 [http-nio-1920-exec-1] ==> Parameters:
2023-06-28 15:21:46,181 [http-nio-1920-exec-3] <== Total: 35
2023-06-28 15:21:46,220 [http-nio-1920-exec-1] <== Total: 12
2023-06-28 15:31:00,360 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:31:00,361 [http-nio-1920-exec-8] ==> Parameters: 7(Long)
2023-06-28 15:31:00,408 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 15:32:07,003 [http-nio-1920-exec-8] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:32:07,003 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 15:32:07,043 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 15:32:07,044 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:32:07,045 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:32:07,087 [http-nio-1920-exec-8] <== Total: 4
2023-06-28 15:32:08,826 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:32:08,827 [http-nio-1920-exec-5] ==> Parameters: 7(Long)
2023-06-28 15:32:08,869 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 15:33:52,020 [http-nio-1920-exec-4] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:33:52,021 [http-nio-1920-exec-4] ==> Parameters:
2023-06-28 15:33:52,062 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 15:33:52,063 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:33:52,063 [http-nio-1920-exec-4] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:33:52,103 [http-nio-1920-exec-4] <== Total: 4
2023-06-28 15:33:53,527 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:33:53,528 [http-nio-1920-exec-3] ==> Parameters: 7(Long)
2023-06-28 15:33:53,573 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 15:41:17,734 [http-nio-1920-exec-7] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:41:17,735 [http-nio-1920-exec-7] ==> Parameters:
2023-06-28 15:41:17,778 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 15:41:17,779 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:41:17,779 [http-nio-1920-exec-7] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:41:17,825 [http-nio-1920-exec-7] <== Total: 4
2023-06-28 15:41:19,259 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:41:19,260 [http-nio-1920-exec-5] ==> Parameters: 7(Long)
2023-06-28 15:41:19,301 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 15:41:54,515 [http-nio-1920-exec-3] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:41:54,516 [http-nio-1920-exec-3] ==> Parameters:
2023-06-28 15:41:54,557 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 15:41:54,558 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:41:54,559 [http-nio-1920-exec-3] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:41:54,610 [http-nio-1920-exec-3] <== Total: 4
2023-06-28 15:41:56,131 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:41:56,132 [http-nio-1920-exec-9] ==> Parameters: 7(Long)
2023-06-28 15:41:56,178 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 15:43:28,598 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:43:28,599 [http-nio-1920-exec-9] ==> Parameters: 7(Long)
2023-06-28 15:43:28,639 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 15:50:32,454 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:50:32,455 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 15:50:32,495 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 15:50:32,496 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:50:32,496 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:50:32,538 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 15:50:33,730 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:50:33,731 [http-nio-1920-exec-7] ==> Parameters: 7(Long)
2023-06-28 15:50:33,771 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 15:51:45,352 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:51:45,353 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 15:51:45,393 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 15:51:45,394 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:51:45,394 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:51:45,438 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 15:51:47,051 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:51:47,065 [http-nio-1920-exec-3] ==> Parameters: 7(Long)
2023-06-28 15:51:47,108 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 15:52:07,316 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:52:07,317 [http-nio-1920-exec-4] ==> Parameters: 7(Long)
2023-06-28 15:52:07,356 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 15:55:46,548 [http-nio-1920-exec-1] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 15:55:46,549 [http-nio-1920-exec-1] ==> Parameters:
2023-06-28 15:55:46,589 [http-nio-1920-exec-1] <== Total: 1
2023-06-28 15:55:46,590 [http-nio-1920-exec-1] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 15:55:46,591 [http-nio-1920-exec-1] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 15:55:46,632 [http-nio-1920-exec-1] <== Total: 4
2023-06-28 15:55:48,582 [http-nio-1920-exec-2] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:55:48,583 [http-nio-1920-exec-2] ==> Parameters: 7(Long)
2023-06-28 15:55:48,623 [http-nio-1920-exec-2] <== Total: 1
2023-06-28 15:57:38,823 [http-nio-1920-exec-1] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 15:57:38,824 [http-nio-1920-exec-1] ==> Parameters: 7(Long)
2023-06-28 15:57:38,865 [http-nio-1920-exec-1] <== Total: 1
2023-06-28 16:10:08,138 [http-nio-1920-exec-2] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:10:08,139 [http-nio-1920-exec-2] ==> Parameters:
2023-06-28 16:10:08,181 [http-nio-1920-exec-2] <== Total: 1
2023-06-28 16:10:08,182 [http-nio-1920-exec-2] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:10:08,182 [http-nio-1920-exec-2] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:10:08,227 [http-nio-1920-exec-2] <== Total: 4
2023-06-28 16:10:09,947 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 16:10:09,948 [http-nio-1920-exec-8] ==> Parameters: 7(Long)
2023-06-28 16:10:09,991 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 16:10:59,033 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 16:10:59,033 [http-nio-1920-exec-4] ==> Parameters: 7(Long)
2023-06-28 16:10:59,077 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 16:14:03,795 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 16:14:03,796 [http-nio-1920-exec-5] ==> Parameters: 7(Long)
2023-06-28 16:14:03,839 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 16:14:08,807 [http-nio-1920-exec-4] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:14:08,807 [http-nio-1920-exec-4] ==> Parameters:
2023-06-28 16:14:08,847 [http-nio-1920-exec-4] <== Total: 1
2023-06-28 16:14:08,848 [http-nio-1920-exec-4] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:14:08,848 [http-nio-1920-exec-4] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:14:08,889 [http-nio-1920-exec-4] <== Total: 4
2023-06-28 16:14:12,478 [http-nio-1920-exec-8] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:14:12,479 [http-nio-1920-exec-8] ==> Parameters:
2023-06-28 16:14:12,518 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 16:14:12,519 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:14:12,520 [http-nio-1920-exec-8] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:14:12,561 [http-nio-1920-exec-8] <== Total: 4
2023-06-28 16:19:33,978 [http-nio-1920-exec-6] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:19:33,996 [http-nio-1920-exec-6] ==> Parameters:
2023-06-28 16:19:34,036 [http-nio-1920-exec-6] <== Total: 1
2023-06-28 16:19:34,037 [http-nio-1920-exec-6] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:19:34,037 [http-nio-1920-exec-6] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:19:34,079 [http-nio-1920-exec-6] <== Total: 4
2023-06-28 16:19:39,663 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 16:19:39,664 [http-nio-1920-exec-7] ==> Parameters: 7(Long)
2023-06-28 16:19:39,709 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 16:20:01,985 [http-nio-1920-exec-7] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:20:01,986 [http-nio-1920-exec-7] ==> Parameters:
2023-06-28 16:20:02,027 [http-nio-1920-exec-7] <== Total: 1
2023-06-28 16:20:02,027 [http-nio-1920-exec-2] ==> Preparing: update bm_miss_enum set china_des = ?,eng_des = ? where id = ?
2023-06-28 16:20:02,029 [http-nio-1920-exec-2] ==> Parameters: 图片尤文提(String), contractAppendix(String), null
2023-06-28 16:20:02,205 [http-nio-1920-exec-2] <== Updates: 0
2023-06-28 16:20:02,205 [http-nio-1920-exec-7] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:20:02,206 [http-nio-1920-exec-7] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:20:02,287 [http-nio-1920-exec-7] <== Total: 4
2023-06-28 16:20:02,663 [http-nio-1920-exec-3] ==> Preparing: update bm_miss_enum set pic = ? where id = ?
2023-06-28 16:20:02,665 [http-nio-1920-exec-3] ==> Parameters: missEnum/2023/5/20230628_V5cbjRFK_dddddddd.jpeg(String), 7(String)
2023-06-28 16:20:02,745 [http-nio-1920-exec-3] <== Updates: 1
2023-06-28 16:20:06,959 [http-nio-1920-exec-10] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:20:06,959 [http-nio-1920-exec-10] ==> Parameters:
2023-06-28 16:20:06,998 [http-nio-1920-exec-10] <== Total: 1
2023-06-28 16:20:06,998 [http-nio-1920-exec-10] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:20:06,999 [http-nio-1920-exec-10] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:20:07,039 [http-nio-1920-exec-10] <== Total: 4
2023-06-28 16:25:09,000 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 16:25:09,000 [http-nio-1920-exec-5] ==> Parameters: 7(Long)
2023-06-28 16:25:09,041 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 16:25:27,194 [http-nio-1920-exec-6] ==> Preparing: update bm_miss_enum set china_des = ?,eng_des = ? where id = ?
2023-06-28 16:25:27,196 [http-nio-1920-exec-6] ==> Parameters: 逗号分隔(String), contraaaaa(String), 7(Long)
2023-06-28 16:25:27,283 [http-nio-1920-exec-5] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:25:27,284 [http-nio-1920-exec-5] ==> Parameters:
2023-06-28 16:25:27,323 [http-nio-1920-exec-6] <== Updates: 1
2023-06-28 16:25:27,405 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 16:25:27,406 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:25:27,407 [http-nio-1920-exec-5] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:25:27,426 [http-nio-1920-exec-10] ==> Preparing: update bm_miss_enum set pic = ? where id = ?
2023-06-28 16:25:27,427 [http-nio-1920-exec-10] ==> Parameters: missEnum/2023/5/20230628_q7i498ED_ddddddd.jpeg(String), 7(String)
2023-06-28 16:25:27,445 [http-nio-1920-exec-5] <== Total: 4
2023-06-28 16:25:27,532 [http-nio-1920-exec-10] <== Updates: 1
2023-06-28 16:25:29,131 [http-nio-1920-exec-9] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:25:29,132 [http-nio-1920-exec-9] ==> Parameters:
2023-06-28 16:25:29,171 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 16:25:29,172 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:25:29,172 [http-nio-1920-exec-9] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:25:29,212 [http-nio-1920-exec-9] <== Total: 4
2023-06-28 16:25:45,356 [http-nio-1920-exec-8] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 16:25:45,356 [http-nio-1920-exec-8] ==> Parameters: 7(Long)
2023-06-28 16:25:45,404 [http-nio-1920-exec-8] <== Total: 1
2023-06-28 16:26:42,352 [http-nio-1920-exec-7] ==> Preparing: update bm_miss_enum set china_des = ?,eng_des = ? where id = ?
2023-06-28 16:26:42,353 [http-nio-1920-exec-7] ==> Parameters: 逗号分隔1(String), contraaaaa1(String), 7(Long)
2023-06-28 16:26:42,438 [http-nio-1920-exec-9] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:26:42,438 [http-nio-1920-exec-9] ==> Parameters:
2023-06-28 16:26:42,478 [http-nio-1920-exec-7] <== Updates: 1
2023-06-28 16:26:42,566 [http-nio-1920-exec-9] <== Total: 1
2023-06-28 16:26:42,567 [http-nio-1920-exec-9] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:26:42,568 [http-nio-1920-exec-9] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:26:42,609 [http-nio-1920-exec-9] <== Total: 4
2023-06-28 16:26:47,293 [http-nio-1920-exec-2] ==> Preparing: update bm_miss_enum set pic = ? where id = ?
2023-06-28 16:26:47,294 [http-nio-1920-exec-2] ==> Parameters: missEnum/2023/5/20230628_itXYgxyz_hhhhhhh.jpeg(String), 7(String)
2023-06-28 16:26:47,374 [http-nio-1920-exec-2] <== Updates: 1
2023-06-28 16:27:24,509 [http-nio-1920-exec-5] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:27:24,510 [http-nio-1920-exec-5] ==> Parameters:
2023-06-28 16:27:24,550 [http-nio-1920-exec-5] <== Total: 1
2023-06-28 16:27:24,550 [http-nio-1920-exec-5] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:27:24,551 [http-nio-1920-exec-5] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:27:24,593 [http-nio-1920-exec-5] <== Total: 4
2023-06-28 16:28:10,609 [http-nio-1920-exec-2] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' and id = ?
2023-06-28 16:28:10,610 [http-nio-1920-exec-2] ==> Parameters: 7(Long)
2023-06-28 16:28:10,649 [http-nio-1920-exec-2] <== Total: 1
2023-06-28 16:28:31,439 [http-nio-1920-exec-10] ==> Preparing: update bm_miss_enum set china_des = ?,eng_des = ? where id = ?
2023-06-28 16:28:31,440 [http-nio-1920-exec-10] ==> Parameters: 逗号分隔2(String), contraaaaa3(String), 7(Long)
2023-06-28 16:28:31,521 [http-nio-1920-exec-3] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:28:31,522 [http-nio-1920-exec-3] ==> Parameters:
2023-06-28 16:28:31,560 [http-nio-1920-exec-10] <== Updates: 1
2023-06-28 16:28:31,578 [http-nio-1920-exec-6] ==> Preparing: update bm_miss_enum set pic = ? where id = ?
2023-06-28 16:28:31,579 [http-nio-1920-exec-6] ==> Parameters: missEnum/2023/5/20230628_4p3BilD7_fasfa.jpg(String), 7(String)
2023-06-28 16:28:31,617 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 16:28:31,618 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:28:31,618 [http-nio-1920-exec-3] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:28:31,696 [http-nio-1920-exec-3] <== Total: 4
2023-06-28 16:28:31,783 [http-nio-1920-exec-6] <== Updates: 1
2023-06-28 16:28:34,400 [http-nio-1920-exec-2] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:28:34,401 [http-nio-1920-exec-2] ==> Parameters:
2023-06-28 16:28:34,441 [http-nio-1920-exec-2] <== Total: 1
2023-06-28 16:28:34,442 [http-nio-1920-exec-2] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:28:34,443 [http-nio-1920-exec-2] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:28:34,485 [http-nio-1920-exec-2] <== Total: 4
2023-06-28 16:29:13,714 [http-nio-1920-exec-10] ==> Preparing: insert into bm_miss_enum(china_des,eng_des) value(?,?)
2023-06-28 16:29:13,716 [http-nio-1920-exec-10] ==> Parameters: 图片尤文提(String), contractAppendix(String)
2023-06-28 16:29:13,799 [http-nio-1920-exec-10] <== Updates: 1
2023-06-28 16:29:13,932 [http-nio-1920-exec-9] ==> Preparing: update bm_miss_enum set pic = ? where id = ?
2023-06-28 16:29:13,933 [http-nio-1920-exec-9] ==> Parameters: missEnum/2023/5/20230628_bpmARgW6_dddddddd.jpeg(String), 12(String)
2023-06-28 16:29:14,014 [http-nio-1920-exec-9] <== Updates: 1
2023-06-28 16:29:18,890 [http-nio-1920-exec-3] ==> Preparing: SELECT count(id) FROM bm_miss_enum WHERE is_active = '1'
2023-06-28 16:29:18,890 [http-nio-1920-exec-3] ==> Parameters:
2023-06-28 16:29:18,930 [http-nio-1920-exec-3] <== Total: 1
2023-06-28 16:29:18,931 [http-nio-1920-exec-3] ==> Preparing: SELECT id, china_des, eng_des, pic FROM bm_miss_enum WHERE is_active = '1' limit ?,?
2023-06-28 16:29:18,931 [http-nio-1920-exec-3] ==> Parameters: 0(Integer), 10(Integer)
2023-06-28 16:29:18,974 [http-nio-1920-exec-3] <== Total: 5
Reference in New Issue View Git Blame Copy Permalink