1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465 |
- [2024-12-13 03:16:28] sql.INFO: [25.19] select `role`.*, (select count(*) from `role_user` where `role`.`id` = `role_user`.`role_id`) as `users_count` from `role` limit 100 offset 0 [] []
- [2024-12-13 03:16:28] sql.INFO: [21.15] select count(*) as aggregate from `role` [] []
- [2024-12-13 03:18:48] sql.INFO: [1157.39] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '90' limit 1 [] []
- [2024-12-13 03:18:48] sql.INFO: [1134.23] select `role`.*, (select count(*) from `role_user` where `role`.`id` = `role_user`.`role_id`) as `users_count` from `role` limit 100 offset 0 [] []
- [2024-12-13 03:18:48] sql.INFO: [17.1] select count(*) as aggregate from `role` [] []
- [2024-12-13 03:18:50] sql.INFO: [18.71] select * from `user` where (`user_name` = '15633964621' and `id` != '90') limit 1 [] []
- [2024-12-13 03:18:51] sql.INFO: [875.92] update `user` set `user_name` = '15633964621', `avatar` = '', `type_id` = '10000', `mobile` = '1563396462', `status` = '1', `email` = '', `admin_id` = '80', `nickname` = '', `last_login_ip` = '172.17.0.1', `user`.`updated_at` = '2024-12-13 03:18:50' where (`id` = '90') [] []
- [2024-12-13 03:18:52] sql.INFO: [875.21] update `user_info` set `id_card` = '', `gender` = '2', `real_name` = '我是英雄海111', `job` = '', `city_id` = '0', `birthday` = '', `number` = '', `city_arr_id` = '', `from_time` = '', `business_name` = '', `to_time` = '', `long_time` = '0', `native_place_id` = '0', `native_place_arr_id` = '', `qq` = '', `zip_code` = '', `address_arr_id` = '', `address_id` = '0', `address` = '', `other` = '', `remark` = '', `fax` = '', `position` = '', `legal_person_real_name` = '', `legal_person_mobile` = '', `legal_person_id_card` = '', `administrative_unit_arr_id` = '', `administrative_unit_id` = '0', `user_info`.`updated_at` = '2024-12-13 03:18:51' where (`user_id` = '90') [] []
- [2024-12-13 03:18:55] sql.INFO: [2733.68] update `role_user` set `role_id` = '1', `admin_user_id` = '80', `role_user`.`updated_at` = '2024-12-13 03:18:52' where (`user_id` = '90') [] []
- [2024-12-13 03:19:36] sql.INFO: [235.52] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` [] []
- [2024-12-13 03:19:36] sql.INFO: [38.87] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-13 03:20:02] sql.INFO: [683.31] select `role`.*, (select count(*) from `role_user` where `role`.`id` = `role_user`.`role_id`) as `users_count` from `role` limit 100 offset 0 [] []
- [2024-12-13 03:20:02] sql.INFO: [17.08] select count(*) as aggregate from `role` [] []
- [2024-12-13 03:20:05] sql.INFO: [3088.38] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '90' limit 1 [] []
- [2024-12-13 03:29:38] sql.INFO: [89.84] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` [] []
- [2024-12-13 03:29:38] sql.INFO: [49.41] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-13 03:29:43] sql.INFO: [44.21] select `role`.*, (select count(*) from `role_user` where `role`.`id` = `role_user`.`role_id`) as `users_count` from `role` limit 100 offset 0 [] []
- [2024-12-13 03:29:43] sql.INFO: [235.56] select count(*) as aggregate from `role` [] []
- [2024-12-13 03:29:43] sql.INFO: [295.24] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '83' limit 1 [] []
- [2024-12-13 03:29:43] sql.INFO: [22.93] select `role`.*, (select count(*) from `role_user` where `role`.`id` = `role_user`.`role_id`) as `users_count` from `role` limit 100 offset 0 [] []
- [2024-12-13 03:29:43] sql.INFO: [22.19] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '83' limit 1 [] []
- [2024-12-13 03:29:43] sql.INFO: [18.24] select count(*) as aggregate from `role` [] []
- [2024-12-13 03:29:59] sql.INFO: [25.13] select * from `user` where (`user_name` = '15822222222' and `id` != '83') limit 1 [] []
- [2024-12-13 05:04:35] sql.INFO: [515.88] select * from `user` where (`user_name` = '15822222222' and `id` != '83') limit 1 [] []
- [2024-12-13 06:34:42] sql.INFO: [95.11] select * from `user` where (`user_name` = '15822222222' and `id` != '83') limit 1 [] []
- [2024-12-13 06:36:09] sql.INFO: [72] select * from `user` where (`user_name` = '15822222222' and `id` != '83') limit 1 [] []
- [2024-12-13 06:36:59] sql.INFO: [18.81] select * from `user` where (`user_name` = '15822222222' and `id` != '83') limit 1 [] []
- [2024-12-13 06:41:28] sql.INFO: [536.15] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` [] []
- [2024-12-13 06:41:28] sql.INFO: [51.31] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-13 06:41:35] sql.INFO: [83.92] select `role`.*, (select count(*) from `role_user` where `role`.`id` = `role_user`.`role_id`) as `users_count` from `role` limit 100 offset 0 [] []
- [2024-12-13 06:41:35] sql.INFO: [15.6] select count(*) as aggregate from `role` [] []
- [2024-12-13 06:41:35] sql.INFO: [17.74] select `role`.*, (select count(*) from `role_user` where `role`.`id` = `role_user`.`role_id`) as `users_count` from `role` limit 100 offset 0 [] []
- [2024-12-13 06:41:35] sql.INFO: [15.48] select count(*) as aggregate from `role` [] []
- [2024-12-13 06:41:35] sql.INFO: [312.79] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '89' limit 1 [] []
- [2024-12-13 06:41:35] sql.INFO: [34.23] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '89' limit 1 [] []
- [2024-12-13 06:45:11] sql.INFO: [287.82] select * from `user` where (`user_name` = '15313123016' and `id` != '89') limit 1 [] []
- [2024-12-13 06:45:12] sql.INFO: [278.22] update `user` set `user_name` = '15313123016', `avatar` = 'http://183.131.25.186:9501/image/20241212/1733992824207935.png', `type_id` = '4', `mobile` = '15313123016', `status` = '1', `email` = '15313123016@qq.com', `admin_id` = '80', `nickname` = '', `last_login_ip` = '172.17.0.1', `user`.`updated_at` = '2024-12-13 06:45:11' where (`id` = '89') [] []
- [2024-12-13 06:45:12] sql.INFO: [235.29] update `user_info` set `id_card` = '15313123016', `gender` = '1', `real_name` = '龙哥国服程咬金', `job` = '', `city_id` = '0', `birthday` = '1982-03-04 00:00:00', `number` = '108', `city_arr_id` = '["0"]', `from_time` = '', `business_name` = '', `to_time` = '', `long_time` = '1', `native_place_id` = '33', `native_place_arr_id` = '[33]', `qq` = '153131230161', `zip_code` = '110000', `address_arr_id` = '[33]', `address_id` = '33', `address` = '刘村找我', `other` = '[]', `remark` = '这个新皮肤不错', `fax` = '', `position` = '', `legal_person_real_name` = '', `legal_person_mobile` = '', `legal_person_id_card` = '', `administrative_unit_arr_id` = '', `administrative_unit_id` = '0', `user_info`.`updated_at` = '2024-12-13 06:45:12' where (`user_id` = '89') [] []
- [2024-12-13 06:45:12] sql.INFO: [20.46] update `role_user` set `role_id` = '1', `admin_user_id` = '80', `role_user`.`updated_at` = '2024-12-13 06:45:12' where (`user_id` = '89') [] []
- [2024-12-13 06:45:13] sql.INFO: [21.92] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` [] []
- [2024-12-13 06:45:14] sql.INFO: [1264.46] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-13 07:05:01] sql.INFO: [1737.92] select * from `role_user` left join `role` on `role`.`id` = `role_user`.`role_id` where (`role_user`.`user_id` = '80') limit 1 [] []
- [2024-12-13 07:05:02] sql.INFO: [352.02] select * from `menu` where `id` in ('77', '78', '79', '80', '113', '115', '83', '84', '85', '86', '89', '88', '96', '112', '93', '94', '95', '99', '103', '114', '101', '102', '107', '108') [] []
- [2024-12-13 07:05:02] sql.INFO: [12348.89] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '80' limit 1 [] []
- [2024-12-13 07:05:03] sql.INFO: [883.4] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` [] []
- [2024-12-13 07:05:03] sql.INFO: [21.31] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-13 07:05:44] sql.INFO: [197.78] select `user`.*, `user_info`.`id` as `user_info_id`, `user_info`.`real_name`, `user_info`.`id_card`, `user_info`.`birthday`, `user_info`.`gender`, `user_info`.`city_id`, `user_info`.`business_name`, `user_info`.`job`, `user_info`.`number`, `user_info`.`city_arr_id`, `user_info`.`from_time`, `user_info`.`to_time`, `user_info`.`long_time`, `user_info`.`native_place_id`, `user_info`.`native_place_arr_id`, `user_info`.`qq`, `user_info`.`zip_code`, `user_info`.`address_arr_id`, `user_info`.`address_id`, `user_info`.`address`, `user_info`.`other`, `user_info`.`remark`, `user_info`.`fax`, `user_info`.`position`, `user_info`.`legal_person_real_name`, `user_info`.`legal_person_mobile`, `user_info`.`legal_person_id_card`, `user_info`.`administrative_unit_arr_id`, `user_info`.`administrative_unit_id`, `role_user`.`role_id` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` where `user`.`id` = '80' limit 1 [] []
- [2024-12-13 07:05:44] sql.INFO: [135.74] select * from `role_user` left join `role` on `role`.`id` = `role_user`.`role_id` where (`role_user`.`user_id` = '80') limit 1 [] []
- [2024-12-13 07:05:44] sql.INFO: [201.56] select * from `menu` where `id` in ('77', '78', '79', '80', '113', '115', '83', '84', '85', '86', '89', '88', '96', '112', '93', '94', '95', '99', '103', '114', '101', '102', '107', '108') [] []
- [2024-12-13 07:05:45] sql.INFO: [150.83] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` [] []
- [2024-12-13 07:05:45] sql.INFO: [145.46] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-20 02:44:15] sql.INFO: [490.82] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` [] []
- [2024-12-20 02:44:15] sql.INFO: [232.14] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-20 02:47:55] sql.INFO: [73.85] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` [] []
- [2024-12-20 02:47:55] sql.INFO: [17.05] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `userA`.`nickname` as `admin_nickname`, `role`.`role_name` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user` as `userA` on `user`.`admin_id` = `userA`.`id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-20 03:03:34] sql.INFO: [725.82] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` [] []
- [2024-12-20 03:03:35] sql.INFO: [872.5] select `user`.`id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `user_infoA`.`real_name` as `real_name`, `role`.`role_name` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-20 03:16:41] sql.INFO: [2155.69] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` [] []
- [2024-12-20 03:16:43] sql.INFO: [1790.25] select `user`.`id`, `user`.`admin_id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `user_infoA`.`real_name` as `real_name`, `role`.`role_name` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-20 03:17:34] sql.INFO: [60.85] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` [] []
- [2024-12-20 03:17:34] sql.INFO: [18.58] select `user`.`id`, `user`.`admin_id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `user_infoA`.`real_name` as `admin_real_name`, `role`.`role_name` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_info`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-20 03:18:45] sql.INFO: [2351.09] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_infoA`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` [] []
- [2024-12-20 03:18:45] sql.INFO: [45.31] select `user`.`id`, `user`.`admin_id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `user_infoA`.`real_name` as `admin_real_name`, `role`.`role_name` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_infoA`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` order by `user`.`id` desc limit 10 offset 0 [] []
- [2024-12-20 03:19:00] sql.INFO: [30288.49] select count(*) as aggregate from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_infoA`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` [] []
- [2024-12-20 03:19:00] sql.INFO: [19.01] select `user`.`id`, `user`.`admin_id`, `user`.`user_name`, `user_info`.`real_name`, `user`.`mobile`, `user`.`type_id`, `user`.`created_at`, `user`.`status`, `user_infoA`.`real_name` as `admin_real_name`, `role`.`role_name` from `user` left join `user_info` on `user`.`id` = `user_info`.`user_id` left join `user_info` as `user_infoA` on `user`.`admin_id` = `user_infoA`.`user_id` left join `role_user` on `role_user`.`user_id` = `user`.`id` left join `role` on `role`.`id` = `role_user`.`role_id` order by `user`.`id` desc limit 10 offset 0 [] []
|