20230506.log 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147
  1. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 178.03 ms
  2. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 28.46 ms
  3. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 28.09 ms
  4. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 26.65 ms
  5. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 27.76 ms
  6. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 28.73 ms
  7. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 26.1 ms
  8. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 26.44 ms
  9. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 27.06 ms
  10. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 28.36 ms
  11. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 26.95 ms
  12. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 27.78 ms
  13. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 154.93 ms
  14. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 31.75 ms
  15. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 31.06 ms
  16. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 34.55 ms
  17. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 150.77 ms
  18. [2023-05-06 10:41] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 31.06 ms
  19. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 28.43 ms
  20. [2023-05-06 10:41] select `migration` from `migrations` order by `batch` asc, `migration` asc | 31.92 ms
  21. [2023-05-06 10:41] insert into `users` (`username`, `email`, `password`, `creator_id`, `department_id`, `updated_at`, `created_at`) values (catchadmin, catch@admin.com, $2y$10$40ZKwXdztkB7TVojDgn2f.GBuYf6Q7ozbiOY/PIFPzF75W9wzvUoe, 1, 0, 1683340919, 1683340919) | 169.07 ms
  22. [2023-05-06 11:15] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 702 limit 1 | 156.59 ms
  23. [2023-05-06 11:15] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 702 limit 1 | 32.75 ms
  24. [2023-05-06 11:15] select * from `users` where `email` = catch@admin.com and `users`.`deleted_at` = 0 limit 1 | 137.04 ms
  25. [2023-05-06 11:15] insert into `log_login` (`account`, `login_ip`, `browser`, `platform`, `login_at`, `status`) values (catch@admin.com, 127.0.0.1, Chrome, Windows, 1683342940, 1) | 32.61 ms
  26. [2023-05-06 11:15] update `users` set `login_at` = 1683342940, `users`.`updated_at` = 1683342940 where `id` = 1 | 32.6 ms
  27. [2023-05-06 11:15] insert into `personal_access_tokens` (`name`, `token`, `abilities`, `expires_at`, `tokenable_id`, `tokenable_type`, `updated_at`, `created_at`) values (token, 46a6305bc24517c30e23ab1edbd2e57dac88598a9a77b30948645e80ed9ffb47, ["*"], , 1, Modules\User\Models\User, 2023-05-06 11:15:40, 2023-05-06 11:15:40) | 33.7 ms
  28. [2023-05-06 11:15] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 168.8 ms
  29. [2023-05-06 11:15] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 33.35 ms
  30. [2023-05-06 11:15] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:15:41, `personal_access_tokens`.`updated_at` = 2023-05-06 11:15:41 where `id` = 188 | 37.24 ms
  31. [2023-05-06 11:15] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (user, user@online, 1, GET, 200, 1683342941, 358, 127.0.0.1, [], 1683342941) | 36.15 ms
  32. [2023-05-06 11:15] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 105.03 ms
  33. [2023-05-06 11:15] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 20.52 ms
  34. [2023-05-06 11:15] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:15:51, `personal_access_tokens`.`updated_at` = 2023-05-06 11:15:51 where `id` = 188 | 25.06 ms
  35. [2023-05-06 11:15] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (user, user@online, 1, GET, 200, 1683342950, 288, 127.0.0.1, [], 1683342951) | 29.8 ms
  36. [2023-05-06 11:15] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 102.03 ms
  37. [2023-05-06 11:15] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 20.39 ms
  38. [2023-05-06 11:15] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:15:55, `personal_access_tokens`.`updated_at` = 2023-05-06 11:15:55 where `id` = 188 | 24.83 ms
  39. [2023-05-06 11:15] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (develop, module@index, 1, GET, 200, 1683342954, 257, 127.0.0.1, {"page":"1","limit":"10"}, 1683342955) | 24.01 ms
  40. [2023-05-06 11:17] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 148.46 ms
  41. [2023-05-06 11:17] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 29.51 ms
  42. [2023-05-06 11:17] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:17:49, `personal_access_tokens`.`updated_at` = 2023-05-06 11:17:49 where `id` = 188 | 34.97 ms
  43. [2023-05-06 11:17] select count(*) as aggregate from `schemas` where `schemas`.`deleted_at` = 0 | 31.27 ms
  44. [2023-05-06 11:17] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (develop, schema@index, 1, GET, 200, 1683343069, 368, 127.0.0.1, {"page":"1","limit":"10"}, 1683343069) | 39.65 ms
  45. [2023-05-06 11:17] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 137.51 ms
  46. [2023-05-06 11:17] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 38.75 ms
  47. [2023-05-06 11:17] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:17:51, `personal_access_tokens`.`updated_at` = 2023-05-06 11:17:51 where `id` = 188 | 42.79 ms
  48. [2023-05-06 11:17] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (develop, module@index, 1, GET, 200, 1683343071, 336, 127.0.0.1, {"page":"1","limit":"10"}, 1683343072) | 30.44 ms
  49. [2023-05-06 11:37] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 129.22 ms
  50. [2023-05-06 11:37] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 40.27 ms
  51. [2023-05-06 11:37] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:37:02, `personal_access_tokens`.`updated_at` = 2023-05-06 11:37:02 where `id` = 188 | 32.22 ms
  52. [2023-05-06 11:37] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (user, user@online, 1, GET, 200, 1683344222, 345, 127.0.0.1, [], 1683344222) | 30.49 ms
  53. [2023-05-06 11:37] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 169.52 ms
  54. [2023-05-06 11:37] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 34.14 ms
  55. [2023-05-06 11:37] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:37:03, `personal_access_tokens`.`updated_at` = 2023-05-06 11:37:03 where `id` = 188 | 37.15 ms
  56. [2023-05-06 11:37] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (develop, module@index, 1, GET, 200, 1683344223, 344, 127.0.0.1, {"page":"1","limit":"10"}, 1683344223) | 38.25 ms
  57. [2023-05-06 11:44] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 156.89 ms
  58. [2023-05-06 11:44] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 27.31 ms
  59. [2023-05-06 11:44] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:44:09, `personal_access_tokens`.`updated_at` = 2023-05-06 11:44:09 where `id` = 188 | 33.83 ms
  60. [2023-05-06 11:44] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (develop, module@store, 1, POST, 200, 1683344649, 392, 127.0.0.1, {"title":"后台管理","path":"manage","keywords":"manage","description":"后台管理相关功能","dirs":{"controllers":true,"models":true,"database":true,"requests":false}}, 1683344649) | 35.43 ms
  61. [2023-05-06 11:44] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 140.96 ms
  62. [2023-05-06 11:44] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 23.65 ms
  63. [2023-05-06 11:44] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:44:10, `personal_access_tokens`.`updated_at` = 2023-05-06 11:44:10 where `id` = 188 | 32.37 ms
  64. [2023-05-06 11:44] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (develop, module@index, 1, GET, 200, 1683344650, 305, 127.0.0.1, {"page":"1","limit":"10"}, 1683344650) | 32.91 ms
  65. [2023-05-06 11:46] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 131.62 ms
  66. [2023-05-06 11:46] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 30.08 ms
  67. [2023-05-06 11:46] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:46:25, `personal_access_tokens`.`updated_at` = 2023-05-06 11:46:25 where `id` = 188 | 32.09 ms
  68. [2023-05-06 11:46] select count(*) as aggregate from `schemas` where `schemas`.`deleted_at` = 0 | 28.86 ms
  69. [2023-05-06 11:46] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (develop, schema@index, 1, GET, 200, 1683344785, 340, 127.0.0.1, {"page":"1","limit":"10"}, 1683344785) | 37.31 ms
  70. [2023-05-06 11:46] select * from `personal_access_tokens` where `personal_access_tokens`.`id` = 188 limit 1 | 144.31 ms
  71. [2023-05-06 11:46] select * from `users` where `users`.`id` = 1 and `users`.`deleted_at` = 0 limit 1 | 44.49 ms
  72. [2023-05-06 11:46] update `personal_access_tokens` set `last_used_at` = 2023-05-06 11:46:30, `personal_access_tokens`.`updated_at` = 2023-05-06 11:46:30 where `id` = 188 | 34.43 ms
  73. [2023-05-06 11:46] insert into `log_operate` (`module`, `action`, `creator_id`, `http_method`, `http_code`, `start_at`, `time_taken`, `ip`, `params`, `created_at`) values (common, option@index, 1, GET, 200, 1683344789, 328, 127.0.0.1, [], 1683344790) | 34.69 ms
  74. [2023-05-06 13:46] select * from information_schema.tables where table_schema = test_zyduanju and table_name = miniprogram and table_type = 'BASE TABLE' | 167.89 ms
  75. [2023-05-06 13:46] desc miniprogram | 30.05 ms
  76. [2023-05-06 16:56] insert into `miniprogram` (`name`, `company`, `type`, `appsecret`, `appid`, `remark`, `updated_at`, `created_at`) values (三个亿短剧, 三个二集团, 1, 2f6594bb595dfa256b5512e43a32a3d3, wx4edhag3gwshgh3gt, 一天充值一个亿, 2023-05-06 16:56:29, 2023-05-06 16:56:29) | 142.65 ms
  77. [2023-05-06 16:58] select count(*) as aggregate from `miniprogram` where `appid` = wx4edhag3gwshgh3gt | 104.21 ms
  78. [2023-05-06 17:07] select count(*) as aggregate from `miniprogram` where `appid` = wx9d389a73b4fwsbbeae | 110.32 ms
  79. [2023-05-06 17:07] select count(*) as aggregate from `miniprogram` where `appid` = wx9d389a73b4fwsbbeae | 112.6 ms
  80. [2023-05-06 17:07] insert into `miniprogram` (`name`, `company`, `type`, `appsecret`, `appid`, `status`, `remark`, `updated_at`, `created_at`) values (三个十万短剧, 三个二集团, 1, 2f6594bb595dfa256b5523ta1shqa3d3, wx9d389a73b4fwsbbeae, 1, 一天充值十个W, 2023-05-06 17:07:52, 2023-05-06 17:07:52) | 26.93 ms
  81. [2023-05-06 17:09] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts54154sseae | 202.88 ms
  82. [2023-05-06 17:14] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts54154sseae | 139.17 ms
  83. [2023-05-06 17:17] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts54154sseae | 126.29 ms
  84. [2023-05-06 17:19] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts54154sseae | 132.01 ms
  85. [2023-05-06 17:20] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts54154sseae | 118.86 ms
  86. [2023-05-06 17:20] insert into `miniprogram` (`name`, `company`, `type`, `appsecret`, `appid`, `status`, `remark`, `updated_at`, `created_at`) values (三个十千短剧, 三个三集团, 1, 2f659djhsjsfa256b5523ta1shqa3d3, wx934fgts54154sseae, 1, , 2023-05-06 17:20:12, 2023-05-06 17:20:12) | 27.91 ms
  87. [2023-05-06 17:21] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts54154sseae | 161.15 ms
  88. [2023-05-06 17:21] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts5415641fgtjhuswsae | 132.2 ms
  89. [2023-05-06 17:21] insert into `miniprogram` (`name`, `company`, `type`, `appsecret`, `appid`, `status`, `remark`, `updated_at`, `created_at`) values (三个十千短剧, 三个三集团, 1, 2f659djhsjsfa256b5523ta1shqa3d3, wx934fgts5415641fgtjhuswsae, 1, , 2023-05-06 17:21:30, 2023-05-06 17:21:30) | 32.08 ms
  90. [2023-05-06 17:22] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts5415641fgtjhuswsae | 401.39 ms
  91. [2023-05-06 17:22] insert into `miniprogram` (`name`, `company`, `type`, `appsecret`, `appid`, `status`, `remark`, `updated_at`, `created_at`) values (三个十千短剧, 三个三集团, 1, 2f659djhsjsfa256b5523ta1shqa3d3, wx934fgts5415641fgtjhuswsae, 1, , 2023-05-06 17:22:08, 2023-05-06 17:22:08) | 40.12 ms
  92. [2023-05-06 17:33] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts5415641fgtjhuswsae | 155.9 ms
  93. [2023-05-06 17:33] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts5415641fgtjhuswsae | 139.9 ms
  94. [2023-05-06 17:34] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts5415641fgtjhuswsae | 175.98 ms
  95. [2023-05-06 17:34] insert into `miniprogram` (`name`, `company`, `type`, `appsecret`, `appid`, `status`, `remark`, `updated_at`, `created_at`) values (三个十千短剧, 三个三集团, 1, 2f659djhsjsfa256b5523ta1shqa3d3, wx934fgts5415641fgtjhuswsae, 1, , 2023-05-06 17:34:07, 2023-05-06 17:34:07) | 37.82 ms
  96. [2023-05-06 17:44] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts5415641fgtjhuswsae | 123.82 ms
  97. [2023-05-06 17:45] select count(*) as aggregate from `miniprogram` | 145.12 ms
  98. [2023-05-06 17:45] select * from `miniprogram` limit 20 offset 0 | 30.07 ms
  99. [2023-05-06 17:53] select count(*) as aggregate from `miniprogram` | 124.09 ms
  100. [2023-05-06 17:53] select * from `miniprogram` limit 20 offset 0 | 23.76 ms
  101. [2023-05-06 17:53] select count(*) as aggregate from `miniprogram` | 112.99 ms
  102. [2023-05-06 17:53] select * from `miniprogram` limit 20 offset 0 | 19.3 ms
  103. [2023-05-06 18:26] select count(*) as aggregate from `miniprogram` where `appid` = wx934fgts5415641fgtjhuswsae | 102.76 ms
  104. [2023-05-06 18:26] select count(*) as aggregate from `miniprogram` where `appid` = wxts5415641fgtjhuswsae | 144.48 ms
  105. [2023-05-06 18:26] insert into `miniprogram` (`name`, `play_name`, `company`, `type`, `appsecret`, `appid`, `status`, `remark`, `updated_at`, `created_at`) values (三个十千短剧, 三个十千短剧, 三个三集团, 1, 2f659djhsjsfa256b5523ta1shqa3d3, wxts5415641fgtjhuswsae, 1, , 2023-05-06 18:26:59, 2023-05-06 18:26:59) | 32.85 ms
  106. [2023-05-06 18:59] select count(*) as aggregate from `miniprogram` where `appid` = wxts5415641fgtjhuswsae13 | 188.33 ms
  107. [2023-05-06 18:59] update `miniprogram` set `name` = 三个十千短剧, `play_name` = 三个十千短剧, `company` = 三个三集团, `type` = 1, `appsecret` = 2f659djhsjsfa256b5523ta1shqa3d313, `appid` = wxts5415641fgtjhuswsae13, `status` = 1, `miniprogram`.`updated_at` = 2023-05-06 18:59:20 where `id` = 13 | 39.37 ms