Acasă Explorează Ajutor
Înregistrare Autentificare
xiaoqing
/
wxgzh
2
0
Bifurcare 0
Fisiere Probleme 0 Trageți solicitările 0 Wiki
Arbore: b739ab9f99
Ramuri Etichete
wxgzh
/
storage
/
logs
/
sql
/
sql-2024-10-14.log

sql-2024-10-14.log 17 KB
Istoric Crud

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 
  1. [2024-10-14T16:15:23.530084+08:00] sql.INFO: select * from `admin_users` where `id` = ''1'' limit 1  [ RunTime:11.65ms ]  [] []
    2. 

  2. [2024-10-14T16:15:23.542703+08:00] sql.INFO: insert into `admin_operation_log` (`user_id`, `path`, `method`, `ip`, `input`, `updated_at`, `created_at`) values ('1', ''admin'', ''GET'', ''127.0.0.1'', ''[]'', ''2024-10-14 16:15:23'', ''2024-10-14 16:15:23'')  [ RunTime:5.08ms ]  [] []
    3. 

  3. [2024-10-14T16:15:23.581051+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:6.86ms ]  [] []
    4. 

  4. [2024-10-14T16:15:23.591245+08:00] sql.INFO: select `admin_permissions`.*, `admin_role_permissions`.`role_id` as `pivot_role_id`, `admin_role_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_role_permissions` on `admin_permissions`.`id` = `admin_role_permissions`.`permission_id` where `admin_role_permissions`.`role_id` in (1)  [ RunTime:7.2ms ]  [] []
    5. 

  5. [2024-10-14T16:15:23.596492+08:00] sql.INFO: select `admin_permissions`.*, `admin_user_permissions`.`user_id` as `pivot_user_id`, `admin_user_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_user_permissions` on `admin_permissions`.`id` = `admin_user_permissions`.`permission_id` where `admin_user_permissions`.`user_id` = '1'  [ RunTime:3.98ms ]  [] []
    6. 

  6. [2024-10-14T16:15:23.649964+08:00] sql.INFO: select *, `order` ROOT from `admin_menu` order by ROOT ASC,`order`  [ RunTime:4.18ms ]  [] []
    7. 

  7. [2024-10-14T16:15:23.654965+08:00] sql.INFO: select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 16, 19, 20, 21, 22, 23, 27, 28, 29, 30, 32, 33, 34, 37, 38, 39, 40, 41)  [ RunTime:4.02ms ]  [] []
    8. 

  8. [2024-10-14T16:15:23.661657+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:0.54ms ]  [] []
    9. 

  9. [2024-10-14T16:15:37.281374+08:00] sql.INFO: select * from `admin_users` where `id` = ''1'' limit 1  [ RunTime:24.58ms ]  [] []
    10. 

  10. [2024-10-14T16:15:37.288692+08:00] sql.INFO: insert into `admin_operation_log` (`user_id`, `path`, `method`, `ip`, `input`, `updated_at`, `created_at`) values ('1', ''admin'', ''GET'', ''127.0.0.1'', ''[]'', ''2024-10-14 16:15:37'', ''2024-10-14 16:15:37'')  [ RunTime:3.04ms ]  [] []
    11. 

  11. [2024-10-14T16:15:37.307247+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:5.39ms ]  [] []
    12. 

  12. [2024-10-14T16:15:37.312680+08:00] sql.INFO: select `admin_permissions`.*, `admin_role_permissions`.`role_id` as `pivot_role_id`, `admin_role_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_role_permissions` on `admin_permissions`.`id` = `admin_role_permissions`.`permission_id` where `admin_role_permissions`.`role_id` in (1)  [ RunTime:3.6ms ]  [] []
    13. 

  13. [2024-10-14T16:15:37.315028+08:00] sql.INFO: select `admin_permissions`.*, `admin_user_permissions`.`user_id` as `pivot_user_id`, `admin_user_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_user_permissions` on `admin_permissions`.`id` = `admin_user_permissions`.`permission_id` where `admin_user_permissions`.`user_id` = '1'  [ RunTime:1.51ms ]  [] []
    14. 

  14. [2024-10-14T16:15:37.346624+08:00] sql.INFO: select *, `order` ROOT from `admin_menu` order by ROOT ASC,`order`  [ RunTime:1.93ms ]  [] []
    15. 

  15. [2024-10-14T16:15:37.349636+08:00] sql.INFO: select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 16, 19, 20, 21, 22, 23, 27, 28, 29, 30, 32, 33, 34, 37, 38, 39, 40, 41)  [ RunTime:2.07ms ]  [] []
    16. 

  16. [2024-10-14T16:15:37.355698+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:0.52ms ]  [] []
    17. 

  17. [2024-10-14T16:15:53.892203+08:00] sql.INFO: select * from `admin_users` where `id` = ''1'' limit 1  [ RunTime:5.79ms ]  [] []
    18. 

  18. [2024-10-14T16:15:53.898922+08:00] sql.INFO: insert into `admin_operation_log` (`user_id`, `path`, `method`, `ip`, `input`, `updated_at`, `created_at`) values ('1', ''admin'', ''GET'', ''127.0.0.1'', ''[]'', ''2024-10-14 16:15:53'', ''2024-10-14 16:15:53'')  [ RunTime:3ms ]  [] []
    19. 

  19. [2024-10-14T16:15:53.918135+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:3.33ms ]  [] []
    20. 

  20. [2024-10-14T16:15:53.922389+08:00] sql.INFO: select `admin_permissions`.*, `admin_role_permissions`.`role_id` as `pivot_role_id`, `admin_role_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_role_permissions` on `admin_permissions`.`id` = `admin_role_permissions`.`permission_id` where `admin_role_permissions`.`role_id` in (1)  [ RunTime:2.62ms ]  [] []
    21. 

  21. [2024-10-14T16:15:53.925287+08:00] sql.INFO: select `admin_permissions`.*, `admin_user_permissions`.`user_id` as `pivot_user_id`, `admin_user_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_user_permissions` on `admin_permissions`.`id` = `admin_user_permissions`.`permission_id` where `admin_user_permissions`.`user_id` = '1'  [ RunTime:2.12ms ]  [] []
    22. 

  22. [2024-10-14T16:15:53.947392+08:00] sql.INFO: select *, `order` ROOT from `admin_menu` order by ROOT ASC,`order`  [ RunTime:1.81ms ]  [] []
    23. 

  23. [2024-10-14T16:15:53.950523+08:00] sql.INFO: select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 16, 19, 20, 21, 22, 23, 27, 28, 29, 30, 32, 33, 34, 37, 38, 39, 40, 41)  [ RunTime:2.2ms ]  [] []
    24. 

  24. [2024-10-14T16:15:53.955480+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:0.42ms ]  [] []
    25. 

  25. [2024-10-14T16:16:21.120358+08:00] sql.INFO: select * from `admin_users` where `id` = ''1'' limit 1  [ RunTime:4.66ms ]  [] []
    26. 

  26. [2024-10-14T16:16:21.306777+08:00] sql.INFO: select * from `admin_users` where `id` = ''1'' limit 1  [ RunTime:24.87ms ]  [] []
    27. 

  27. [2024-10-14T16:17:46.069252+08:00] sql.INFO: select * from `admin_users` where `id` = '1' limit 1  [ RunTime:7.4ms ]  [] []
    28. 

  28. [2024-10-14T16:17:46.079664+08:00] sql.INFO: insert into `admin_operation_log` (`user_id`, `path`, `method`, `ip`, `input`, `updated_at`, `created_at`) values ('1', ''admin'', ''GET'', ''127.0.0.1'', ''[]'', ''2024-10-14 16:17:46'', ''2024-10-14 16:17:46'')  [ RunTime:4.7ms ]  [] []
    29. 

  29. [2024-10-14T16:17:46.105508+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:7.86ms ]  [] []
    30. 

  30. [2024-10-14T16:17:46.110609+08:00] sql.INFO: select `admin_permissions`.*, `admin_role_permissions`.`role_id` as `pivot_role_id`, `admin_role_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_role_permissions` on `admin_permissions`.`id` = `admin_role_permissions`.`permission_id` where `admin_role_permissions`.`role_id` in (1)  [ RunTime:3.17ms ]  [] []
    31. 

  31. [2024-10-14T16:17:46.114499+08:00] sql.INFO: select `admin_permissions`.*, `admin_user_permissions`.`user_id` as `pivot_user_id`, `admin_user_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_user_permissions` on `admin_permissions`.`id` = `admin_user_permissions`.`permission_id` where `admin_user_permissions`.`user_id` = '1'  [ RunTime:2.96ms ]  [] []
    32. 

  32. [2024-10-14T16:17:46.157477+08:00] sql.INFO: select *, `order` ROOT from `admin_menu` order by ROOT ASC,`order`  [ RunTime:2.38ms ]  [] []
    33. 

  33. [2024-10-14T16:17:46.160493+08:00] sql.INFO: select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 16, 19, 20, 21, 22, 23, 27, 28, 29, 30, 32, 33, 34, 37, 38, 39, 40, 41)  [ RunTime:2.03ms ]  [] []
    34. 

  34. [2024-10-14T16:17:46.167159+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:0.61ms ]  [] []
    35. 

  35. [2024-10-14T16:18:10.459129+08:00] sql.INFO: select * from `admin_users` where `id` = '1' limit 1  [ RunTime:9.24ms ]  [] []
    36. 

  36. [2024-10-14T16:18:10.466152+08:00] sql.INFO: insert into `admin_operation_log` (`user_id`, `path`, `method`, `ip`, `input`, `updated_at`, `created_at`) values ('1', ''admin'', ''GET'', ''127.0.0.1'', ''[]'', ''2024-10-14 16:18:10'', ''2024-10-14 16:18:10'')  [ RunTime:3.14ms ]  [] []
    37. 

  37. [2024-10-14T16:18:10.483541+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:2.91ms ]  [] []
    38. 

  38. [2024-10-14T16:18:10.489388+08:00] sql.INFO: select `admin_permissions`.*, `admin_role_permissions`.`role_id` as `pivot_role_id`, `admin_role_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_role_permissions` on `admin_permissions`.`id` = `admin_role_permissions`.`permission_id` where `admin_role_permissions`.`role_id` in (1)  [ RunTime:4.46ms ]  [] []
    39. 

  39. [2024-10-14T16:18:10.492023+08:00] sql.INFO: select `admin_permissions`.*, `admin_user_permissions`.`user_id` as `pivot_user_id`, `admin_user_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_user_permissions` on `admin_permissions`.`id` = `admin_user_permissions`.`permission_id` where `admin_user_permissions`.`user_id` = '1'  [ RunTime:1.77ms ]  [] []
    40. 

  40. [2024-10-14T16:18:10.510275+08:00] sql.INFO: select *, `order` ROOT from `admin_menu` order by ROOT ASC,`order`  [ RunTime:1.84ms ]  [] []
    41. 

  41. [2024-10-14T16:18:10.513983+08:00] sql.INFO: select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 16, 19, 20, 21, 22, 23, 27, 28, 29, 30, 32, 33, 34, 37, 38, 39, 40, 41)  [ RunTime:2.85ms ]  [] []
    42. 

  42. [2024-10-14T16:18:10.518137+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:0.5ms ]  [] []
    43. 

  43. [2024-10-14T16:18:37.546492+08:00] sql.INFO: select * from `admin_users` where `id` = ''1'' limit 1  [ RunTime:19.8ms ]  [] []
    44. 

  44. [2024-10-14T16:18:37.552936+08:00] sql.INFO: insert into `admin_operation_log` (`user_id`, `path`, `method`, `ip`, `input`, `updated_at`, `created_at`) values ('1', ''admin'', ''GET'', ''127.0.0.1'', ''[]'', ''2024-10-14 16:18:37'', ''2024-10-14 16:18:37'')  [ RunTime:2.93ms ]  [] []
    45. 

  45. [2024-10-14T16:18:37.573967+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:3.18ms ]  [] []
    46. 

  46. [2024-10-14T16:18:37.578892+08:00] sql.INFO: select `admin_permissions`.*, `admin_role_permissions`.`role_id` as `pivot_role_id`, `admin_role_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_role_permissions` on `admin_permissions`.`id` = `admin_role_permissions`.`permission_id` where `admin_role_permissions`.`role_id` in (1)  [ RunTime:3.4ms ]  [] []
    47. 

  47. [2024-10-14T16:18:37.581590+08:00] sql.INFO: select `admin_permissions`.*, `admin_user_permissions`.`user_id` as `pivot_user_id`, `admin_user_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_user_permissions` on `admin_permissions`.`id` = `admin_user_permissions`.`permission_id` where `admin_user_permissions`.`user_id` = '1'  [ RunTime:1.75ms ]  [] []
    48. 

  48. [2024-10-14T16:18:37.601468+08:00] sql.INFO: select *, `order` ROOT from `admin_menu` order by ROOT ASC,`order`  [ RunTime:1.8ms ]  [] []
    49. 

  49. [2024-10-14T16:18:37.606203+08:00] sql.INFO: select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 16, 19, 20, 21, 22, 23, 27, 28, 29, 30, 32, 33, 34, 37, 38, 39, 40, 41)  [ RunTime:3.8ms ]  [] []
    50. 

  50. [2024-10-14T16:18:37.611653+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:0.61ms ]  [] []
    51. 

  51. [2024-10-14T16:18:56.037832+08:00] sql.INFO: select * from `admin_users` where `id` = '1' limit 1  [ RunTime:18.44ms ]  [] []
    52. 

  52. [2024-10-14T16:18:56.043841+08:00] sql.INFO: insert into `admin_operation_log` (`user_id`, `path`, `method`, `ip`, `input`, `updated_at`, `created_at`) values ('1', ''admin/activities'', ''GET'', ''127.0.0.1'', ''{"_pjax":"#pjax-container"}'', ''2024-10-14 16:18:56'', ''2024-10-14 16:18:56'')  [ RunTime:3.47ms ]  [] []
    53. 

  53. [2024-10-14T16:18:56.062715+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:6.05ms ]  [] []
    54. 

  54. [2024-10-14T16:18:56.067396+08:00] sql.INFO: select `admin_permissions`.*, `admin_role_permissions`.`role_id` as `pivot_role_id`, `admin_role_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_role_permissions` on `admin_permissions`.`id` = `admin_role_permissions`.`permission_id` where `admin_role_permissions`.`role_id` in (1)  [ RunTime:3.12ms ]  [] []
    55. 

  55. [2024-10-14T16:18:56.071302+08:00] sql.INFO: select `admin_permissions`.*, `admin_user_permissions`.`user_id` as `pivot_user_id`, `admin_user_permissions`.`permission_id` as `pivot_permission_id` from `admin_permissions` inner join `admin_user_permissions` on `admin_permissions`.`id` = `admin_user_permissions`.`permission_id` where `admin_user_permissions`.`user_id` = '1'  [ RunTime:3.07ms ]  [] []
    56. 

  56. [2024-10-14T16:18:56.100460+08:00] sql.INFO: select count(*) as aggregate from `four_activities` where `four_activities`.`deleted_at` is null  [ RunTime:1.87ms ]  [] []
    57. 

  57. [2024-10-14T16:18:56.101473+08:00] sql.INFO: select * from `four_activities` where `four_activities`.`deleted_at` is null limit 20 offset 0  [ RunTime:0.4ms ]  [] []
    58. 

  58. [2024-10-14T16:18:56.108001+08:00] sql.INFO: select `admin_roles`.*, `admin_role_users`.`user_id` as `pivot_user_id`, `admin_role_users`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_users` on `admin_roles`.`id` = `admin_role_users`.`role_id` where `admin_role_users`.`user_id` = '1'  [ RunTime:0.61ms ]  [] []
    59. 

  59. [2024-10-14T16:18:56.159493+08:00] sql.INFO: select *, `order` ROOT from `admin_menu` order by ROOT ASC,`order`  [ RunTime:2.52ms ]  [] []
    60. 

  60. [2024-10-14T16:18:56.163407+08:00] sql.INFO: select `admin_roles`.*, `admin_role_menu`.`menu_id` as `pivot_menu_id`, `admin_role_menu`.`role_id` as `pivot_role_id` from `admin_roles` inner join `admin_role_menu` on `admin_roles`.`id` = `admin_role_menu`.`role_id` where `admin_role_menu`.`menu_id` in (2, 3, 4, 5, 6, 7, 8, 9, 10, 15, 16, 19, 20, 21, 22, 23, 27, 28, 29, 30, 32, 33, 34, 37, 38, 39, 40, 41)  [ RunTime:2.92ms ]  [] []
    61.