20230518.log 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115
  1. [2023-05-18 17:45] 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` = 1 and `roles`.`identify` = administrator | 160.92 ms
  2. [2023-05-18 17:45] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = 好看看短剧模板 | 30.69 ms
  3. [2023-05-18 17:45] insert into `pay_templates` (`name`, `uid`, `status`, `updated_at`, `created_at`) values (好看看短剧模板, 0, 1, 2023-05-18 17:45:22, 2023-05-18 17:45:22) | 35.78 ms
  4. [2023-05-18 17:45] select * from `pay_products` where (`price` = 10 and `type` = FIEST_COIN and `given` = 1000) limit 1 | 30.51 ms
  5. [2023-05-18 17:45] insert into `pay_products` (`price`, `type`, `given`, `updated_at`, `created_at`) values (10, FIEST_COIN, 1000, 2023-05-18 17:45:22, 2023-05-18 17:45:22) | 38.1 ms
  6. [2023-05-18 17:45] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 34.97 ms
  7. [2023-05-18 17:45] insert into `pay_products` (`price`, `type`, `given`, `updated_at`, `created_at`) values (30, COIN, 0, 2023-05-18 17:45:22, 2023-05-18 17:45:22) | 36.28 ms
  8. [2023-05-18 17:45] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 30.54 ms
  9. [2023-05-18 17:45] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 30.27 ms
  10. [2023-05-18 17:45] insert into `pay_products` (`price`, `type`, `given`, `updated_at`, `created_at`) values (190, MONTH, 0, 2023-05-18 17:45:22, 2023-05-18 17:45:22) | 36.95 ms
  11. [2023-05-18 17:45] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 30.76 ms
  12. [2023-05-18 17:45] insert into `pay_products` (`price`, `type`, `given`, `updated_at`, `created_at`) values (290, YEAR, 0, 2023-05-18 17:45:22, 2023-05-18 17:45:22) | 35.47 ms
  13. [2023-05-18 17:45] insert into `pay_template_items` (`created_at`, `is_default`, `is_first_pay`, `pay_product_id`, `pay_template_id`, `sequence`, `status`, `updated_at`) values (2023-05-18 17:45:22, 0, 0, 7, 2, 1, 1, 2023-05-18 17:45:22), (2023-05-18 17:45:22, 1, 0, 8, 2, 2, 1, 2023-05-18 17:45:22), (2023-05-18 17:45:22, 0, 0, 2, 2, 3, 1, 2023-05-18 17:45:22), (2023-05-18 17:45:22, 0, 0, 9, 2, 4, 1, 2023-05-18 17:45:22), (2023-05-18 17:45:22, 0, 0, 10, 2, 5, 1, 2023-05-18 17:45:22) | 36.67 ms
  14. [2023-05-18 17:52] 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` = 1 and `roles`.`identify` = administrator | 120.27 ms
  15. [2023-05-18 17:52] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板 | 23.97 ms
  16. [2023-05-18 17:52] insert into `pay_templates` (`name`, `uid`, `status`, `updated_at`, `created_at`) values (AAAA模板, 0, 1, 2023-05-18 17:52:25, 2023-05-18 17:52:25) | 30.47 ms
  17. [2023-05-18 17:52] select * from `pay_products` where (`price` = 10 and `type` = FIEST_COIN and `given` = 10000) limit 1 | 29.72 ms
  18. [2023-05-18 17:52] insert into `pay_products` (`price`, `type`, `given`, `updated_at`, `created_at`) values (10, FIEST_COIN, 10000, 2023-05-18 17:52:25, 2023-05-18 17:52:25) | 28.78 ms
  19. [2023-05-18 17:52] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 23.15 ms
  20. [2023-05-18 17:52] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 25.12 ms
  21. [2023-05-18 17:52] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 23.23 ms
  22. [2023-05-18 17:52] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 23.82 ms
  23. [2023-05-18 17:52] insert into `pay_template_items` (`created_at`, `is_default`, `is_first_pay`, `pay_product_id`, `pay_template_id`, `sequence`, `status`, `updated_at`) values (2023-05-18 17:52:25, 0, 0, 11, 3, 1, 1, 2023-05-18 17:52:25), (2023-05-18 17:52:25, 1, 0, 8, 3, 2, 1, 2023-05-18 17:52:25), (2023-05-18 17:52:25, 0, 0, 2, 3, 3, 1, 2023-05-18 17:52:25), (2023-05-18 17:52:25, 0, 0, 9, 3, 4, 1, 2023-05-18 17:52:25), (2023-05-18 17:52:25, 0, 0, 10, 3, 5, 1, 2023-05-18 17:52:25) | 29.54 ms
  24. [2023-05-18 18: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` = 1 and `roles`.`identify` = administrator | 140.14 ms
  25. [2023-05-18 18:14] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板1 | 24.37 ms
  26. [2023-05-18 18:14] insert into `pay_templates` (`name`, `uid`, `status`, `updated_at`, `created_at`) values (AAAA模板1, 0, 1, 2023-05-18 18:14:00, 2023-05-18 18:14:00) | 29.35 ms
  27. [2023-05-18 18:14] select * from `pay_products` where (`price` = 10 and `type` = COIN and `given` = 1000) limit 1 | 24.26 ms
  28. [2023-05-18 18:14] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 24.18 ms
  29. [2023-05-18 18:14] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 24.92 ms
  30. [2023-05-18 18:14] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 24.66 ms
  31. [2023-05-18 18:14] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 24.27 ms
  32. [2023-05-18 18:14] insert into `pay_template_items` (`created_at`, `is_default`, `is_first_pay`, `pay_product_id`, `pay_template_id`, `sequence`, `status`, `updated_at`) values (2023-05-18 18:14:00, 1, 1, 7, 4, 1, 1, 2023-05-18 18:14:00), (2023-05-18 18:14:00, 0, 0, 8, 4, 2, 1, 2023-05-18 18:14:00), (2023-05-18 18:14:00, 0, 0, 2, 4, 3, 1, 2023-05-18 18:14:00), (2023-05-18 18:14:00, 0, 0, 9, 4, 4, 1, 2023-05-18 18:14:00), (2023-05-18 18:14:00, 0, 0, 10, 4, 5, 1, 2023-05-18 18:14:00) | 29.89 ms
  33. [2023-05-18 18:16] 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` = 1 and `roles`.`identify` = administrator | 158.8 ms
  34. [2023-05-18 18:16] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板1 | 31.51 ms
  35. [2023-05-18 18:16] insert into `pay_templates` (`name`, `uid`, `status`, `updated_at`, `created_at`) values (AAAA模板1, 0, 1, 2023-05-18 18:16:05, 2023-05-18 18:16:05) | 43.79 ms
  36. [2023-05-18 18:16] select * from `pay_products` where (`price` = 10 and `type` = COIN and `given` = 1000) limit 1 | 30.62 ms
  37. [2023-05-18 18:16] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 31.37 ms
  38. [2023-05-18 18:16] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 30.81 ms
  39. [2023-05-18 18:16] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 30.47 ms
  40. [2023-05-18 18:16] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 32.11 ms
  41. [2023-05-18 18:16] insert into `pay_template_items` (`created_at`, `is_default`, `is_first_pay`, `pay_product_id`, `pay_template_id`, `sequence`, `status`, `updated_at`) values (2023-05-18 18:16:05, 0, 1, 7, 5, 1, 1, 2023-05-18 18:16:05), (2023-05-18 18:16:05, 1, 0, 8, 5, 2, 1, 2023-05-18 18:16:05), (2023-05-18 18:16:05, 0, 0, 2, 5, 3, 1, 2023-05-18 18:16:05), (2023-05-18 18:16:05, 0, 0, 9, 5, 4, 1, 2023-05-18 18:16:05), (2023-05-18 18:16:05, 0, 0, 10, 5, 5, 1, 2023-05-18 18:16:05) | 39.92 ms
  42. [2023-05-18 18:17] 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` = 1 and `roles`.`identify` = administrator | 129.24 ms
  43. [2023-05-18 18:17] select count(*) as aggregate from `pay_templates` where (`uid` = 0 and `name` like %亿%) | 23.65 ms
  44. [2023-05-18 18:18] 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` = 1 and `roles`.`identify` = administrator | 140.41 ms
  45. [2023-05-18 18:18] select count(*) as aggregate from `pay_templates` where (`uid` = 0) | 26.63 ms
  46. [2023-05-18 18:18] select * from `pay_templates` where (`uid` = 0) limit 20 offset 0 | 27.85 ms
  47. [2023-05-18 18:21] 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` = 1 and `roles`.`identify` = administrator | 143.42 ms
  48. [2023-05-18 18:21] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 27.03 ms
  49. [2023-05-18 18:21] select `pay_products`.`price`, `pay_products`.`type`, `pay_products`.`given`, `pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `sequence` from `pay_template_items` inner join `pay_products` on `pay_products`.`id` = `pay_template_items`.`pay_product_id` where `pay_template_id` = 5 and `pay_template_items`.`status` = 1 order by `pay_template_items`.`sequence` asc | 30.85 ms
  50. [2023-05-18 18:32] 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` = 1 and `roles`.`identify` = administrator | 153.46 ms
  51. [2023-05-18 18:32] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板11 | 26.73 ms
  52. [2023-05-18 18:32] insert into `pay_templates` (`name`, `uid`, `status`, `updated_at`, `created_at`) values (AAAA模板11, 0, 1, 2023-05-18 18:32:14, 2023-05-18 18:32:14) | 31.57 ms
  53. [2023-05-18 18:32] select * from `pay_products` where (`price` = 10 and `type` = COIN and `given` = 1000) limit 1 | 27.67 ms
  54. [2023-05-18 18:32] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 27.5 ms
  55. [2023-05-18 18:32] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 26.35 ms
  56. [2023-05-18 18:32] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 26.78 ms
  57. [2023-05-18 18:32] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 26.51 ms
  58. [2023-05-18 18:32] insert into `pay_template_items` (`created_at`, `is_default`, `is_first_pay`, `pay_product_id`, `pay_template_id`, `sequence`, `status`, `updated_at`) values (2023-05-18 18:32:14, 0, 1, 7, 6, 1, 1, 2023-05-18 18:32:14), (2023-05-18 18:32:14, 1, 0, 8, 6, 2, 1, 2023-05-18 18:32:14), (2023-05-18 18:32:14, 0, 0, 2, 6, 3, 1, 2023-05-18 18:32:14), (2023-05-18 18:32:14, 0, 0, 9, 6, 4, 1, 2023-05-18 18:32:14), (2023-05-18 18:32:14, 0, 0, 10, 6, 5, 1, 2023-05-18 18:32:14) | 31.93 ms
  59. [2023-05-18 18:38] 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` = 1 and `roles`.`identify` = administrator | 147 ms
  60. [2023-05-18 18:38] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 26.16 ms
  61. [2023-05-18 18:38] select `pay_products`.`price`, `pay_products`.`type`, `pay_products`.`given`, `pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `sequence` from `pay_template_items` inner join `pay_products` on `pay_products`.`id` = `pay_template_items`.`pay_product_id` where `pay_template_id` = 5 and `pay_template_items`.`status` = 1 order by `pay_template_items`.`sequence` asc | 27.2 ms
  62. [2023-05-18 18:45] 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` = 1 and `roles`.`identify` = administrator | 93.92 ms
  63. [2023-05-18 18:45] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 18.4 ms
  64. [2023-05-18 18:45] update `pay_templates` set `name` = AAAA模板11, `pay_templates`.`updated_at` = 2023-05-18 18:45:21 where `id` = 5 | 25.61 ms
  65. [2023-05-18 18:45] update `pay_template_items` set `status` = 0, `pay_template_items`.`updated_at` = 2023-05-18 18:45:21 where `pay_template_id` = 5 | 22.9 ms
  66. [2023-05-18 18:45] select * from `pay_products` where (`price` = 9 and `type` = COIN and `given` = 1000) limit 1 | 18.8 ms
  67. [2023-05-18 18:45] insert into `pay_products` (`price`, `type`, `given`, `updated_at`, `created_at`) values (9, COIN, 1000, 2023-05-18 18:45:21, 2023-05-18 18:45:21) | 23.98 ms
  68. [2023-05-18 18:45] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 12 limit 1 | 18.21 ms
  69. [2023-05-18 18:45] insert into `pay_template_items` (`pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `status`, `sequence`, `created_at`, `updated_at`) values (5, 12, 1, 0, 1, 1, 2023-05-18 18:45:21, 2023-05-18 18:45:21) | 22.69 ms
  70. [2023-05-18 18:45] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 18.13 ms
  71. [2023-05-18 18:45] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 8 limit 1 | 18.17 ms
  72. [2023-05-18 18:45] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:45:21 where `id` = 22 | 24.81 ms
  73. [2023-05-18 18:45] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 22.19 ms
  74. [2023-05-18 18:45] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 2 limit 1 | 17.27 ms
  75. [2023-05-18 18:45] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:45:21 where `id` = 23 | 22.43 ms
  76. [2023-05-18 18:45] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 17.44 ms
  77. [2023-05-18 18:45] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 9 limit 1 | 17.62 ms
  78. [2023-05-18 18:45] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:45:21 where `id` = 24 | 22.43 ms
  79. [2023-05-18 18:45] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 18.32 ms
  80. [2023-05-18 18:45] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 10 limit 1 | 18.67 ms
  81. [2023-05-18 18:45] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:45:21 where `id` = 25 | 23.17 ms
  82. [2023-05-18 18:48] 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` = 1 and `roles`.`identify` = administrator | 110.49 ms
  83. [2023-05-18 18:48] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 24.35 ms
  84. [2023-05-18 18:48] update `pay_templates` set `status` = 0, `pay_templates`.`updated_at` = 2023-05-18 18:48:45 where `id` = 5 | 28.7 ms
  85. [2023-05-18 18:48] update `pay_template_items` set `status` = 0, `pay_template_items`.`updated_at` = 2023-05-18 18:48:45 where `pay_template_id` = 5 | 31.85 ms
  86. [2023-05-18 18:48] select * from `pay_products` where (`price` = 9 and `type` = COIN and `given` = 1000) limit 1 | 25.79 ms
  87. [2023-05-18 18:48] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 12 limit 1 | 21.49 ms
  88. [2023-05-18 18:48] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:48:45 where `id` = 31 | 23.82 ms
  89. [2023-05-18 18:48] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 20.96 ms
  90. [2023-05-18 18:48] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 8 limit 1 | 26.11 ms
  91. [2023-05-18 18:48] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:48:45 where `id` = 22 | 25.05 ms
  92. [2023-05-18 18:48] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 21.81 ms
  93. [2023-05-18 18:48] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 2 limit 1 | 20.71 ms
  94. [2023-05-18 18:48] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:48:45 where `id` = 23 | 27.11 ms
  95. [2023-05-18 18:48] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 20.33 ms
  96. [2023-05-18 18:48] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 9 limit 1 | 20.97 ms
  97. [2023-05-18 18:48] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:48:45 where `id` = 24 | 25.44 ms
  98. [2023-05-18 18:48] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 20.36 ms
  99. [2023-05-18 18:48] select * from `pay_template_items` where `pay_template_id` = 5 and `pay_product_id` = 10 limit 1 | 19.86 ms
  100. [2023-05-18 18:48] update `pay_template_items` set `status` = 1, `pay_template_items`.`updated_at` = 2023-05-18 18:48:45 where `id` = 25 | 24.63 ms
  101. [2023-05-18 19:01] 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` = 1 and `roles`.`identify` = administrator | 118.1 ms
  102. [2023-05-18 19:01] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 22.58 ms
  103. [2023-05-18 19:01] select `pay_products`.`price`, `pay_products`.`type`, `pay_products`.`given`, `pay_template_id`, `pay_product_id`, `is_first_pay`, `is_default`, `sequence` from `pay_template_items` inner join `pay_products` on `pay_products`.`id` = `pay_template_items`.`pay_product_id` where `pay_template_id` = 5 and `pay_template_items`.`status` = 1 order by `pay_template_items`.`sequence` asc | 22.55 ms