20230509.log 5.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041
  1. [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
  2. [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
  3. [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
  4. [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
  5. [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
  6. [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
  7. [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
  8. [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
  9. [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
  10. [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
  11. [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
  12. [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
  13. [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
  14. [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
  15. [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
  16. [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
  17. [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
  18. [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
  19. [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
  20. [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
  21. [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
  22. [2023-05-09 10:08] select * from `miniprogram` where `miniprogram`.`id` = 17 limit 1 | 119.2 ms
  23. [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
  24. [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
  25. [2023-05-09 10:08] select * from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 17 limit 1 | 21.05 ms
  26. [2023-05-09 10:14] select * from `miniprogram` where `miniprogram`.`id` = 17 limit 1 | 97.8 ms
  27. [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
  28. [2023-05-09 10:14] select * from `user_has_miniprograms` where `uid` = 2 and `miniprogram_id` = 17 limit 1 | 19.36 ms
  29. [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
  30. [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
  31. [2023-05-09 10:14] select * from `user_has_miniprograms` where `uid` = 5 and `miniprogram_id` = 17 limit 1 | 19.15 ms
  32. [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