1234567891011121314151617181920212223242526272829303132333435363738394041 |
- [2023-05-09 09:37] select `users`.`username`, `users`.`id` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `roles`.`identify` = company | 146.17 ms
- [2023-05-09 09:37] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 13 and `is_enabled` = 1 | 38.64 ms
- [2023-05-09 09:37] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 13 and `is_enabled` = 1 | 35.98 ms
- [2023-05-09 09:50] select `users`.`username`, `users`.`id` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `roles`.`identify` = company | 135.11 ms
- [2023-05-09 09:50] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 13 and `is_enabled` = 1 | 27.43 ms
- [2023-05-09 09:50] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 13 and `is_enabled` = 1 | 25.66 ms
- [2023-05-09 09:52] select `users`.`username`, `users`.`id` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `roles`.`identify` = company | 159.44 ms
- [2023-05-09 09:52] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 13 and `is_enabled` = 1 | 32.32 ms
- [2023-05-09 09:52] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 13 and `is_enabled` = 1 | 30.35 ms
- [2023-05-09 09:54] select `users`.`username`, `users`.`id` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `roles`.`identify` = company | 148.64 ms
- [2023-05-09 09:54] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 13 and `is_enabled` = 1 | 26.86 ms
- [2023-05-09 09:54] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 13 and `is_enabled` = 1 | 26.19 ms
- [2023-05-09 10:00] select `users`.`username`, `users`.`id` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `roles`.`identify` = company | 142.74 ms
- [2023-05-09 10:00] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 13 and `is_enabled` = 1 | 27.34 ms
- [2023-05-09 10:00] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 13 and `is_enabled` = 1 | 26.6 ms
- [2023-05-09 10:00] select `users`.`username`, `users`.`id` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `roles`.`identify` = company | 110.65 ms
- [2023-05-09 10:00] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 13 and `is_enabled` = 1 | 27.26 ms
- [2023-05-09 10:00] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 13 and `is_enabled` = 1 | 22.03 ms
- [2023-05-09 10:00] select `users`.`username`, `users`.`id` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `roles`.`identify` = company | 144.22 ms
- [2023-05-09 10:00] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 13 and `is_enabled` = 1 | 43.04 ms
- [2023-05-09 10:00] select count(*) as aggregate from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 13 and `is_enabled` = 1 | 30.11 ms
- [2023-05-09 10:08] select * from `miniprogram` where `miniprogram`.`id` = 17 limit 1 | 119.2 ms
- [2023-05-09 10:08] select `roles`.`identify` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `users`.`id` = 2 limit 1 | 26.24 ms
- [2023-05-09 10:08] select `roles`.`identify` from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `users`.`id` = 5 limit 1 | 19.76 ms
- [2023-05-09 10:08] select * from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 17 limit 1 | 21.05 ms
- [2023-05-09 10:14] select * from `miniprogram` where `miniprogram`.`id` = 17 limit 1 | 97.8 ms
- [2023-05-09 10:14] select count(*) as aggregate from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `users`.`id` = 2 and `roles`.`identify` = company | 22.04 ms
- [2023-05-09 10:14] select * from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 17 limit 1 | 19.36 ms
- [2023-05-09 10:14] insert into `user_has_miniprograms` (`uid`, `miniprogram_id`, `is_enabled`, `updated_at`, `created_at`) values (2, 17, 1, 2023-05-09 10:14:48, 2023-05-09 10:14:48) | 24.56 ms
- [2023-05-09 10:14] select count(*) as aggregate from `users` inner join `user_has_roles` on `user_has_roles`.`user_id` = `users`.`id` inner join `roles` on `roles`.`id` = `user_has_roles`.`role_id` where `users`.`id` = 5 and `roles`.`identify` = company | 19.07 ms
- [2023-05-09 10:14] select * from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 17 limit 1 | 19.15 ms
- [2023-05-09 10:14] update `user_has_miniprograms` set `is_enabled` = 1, `user_has_miniprograms`.`updated_at` = 2023-05-09 10:14:48 where `id` = 79 | 24.31 ms
|