duanju_manage/storage/logs/query/20230518.log

[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
[2023-05-18 17:45] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = 好看看短剧模板 | 30.69 ms
[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
[2023-05-18 17:45] select * from `pay_products` where (`price` = 10 and `type` = FIEST_COIN and `given` = 1000) limit 1 | 30.51 ms
[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
[2023-05-18 17:45] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 34.97 ms
[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
[2023-05-18 17:45] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 30.54 ms
[2023-05-18 17:45] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 30.27 ms
[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
[2023-05-18 17:45] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 30.76 ms
[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
[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

[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
[2023-05-18 17:52] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板 | 23.97 ms
[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
[2023-05-18 17:52] select * from `pay_products` where (`price` = 10 and `type` = FIEST_COIN and `given` = 10000) limit 1 | 29.72 ms
[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
[2023-05-18 17:52] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 23.15 ms
[2023-05-18 17:52] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 25.12 ms
[2023-05-18 17:52] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 23.23 ms
[2023-05-18 17:52] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 23.82 ms
[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

[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
[2023-05-18 18:14] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板1 | 24.37 ms
[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
[2023-05-18 18:14] select * from `pay_products` where (`price` = 10 and `type` = COIN and `given` = 1000) limit 1 | 24.26 ms
[2023-05-18 18:14] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 24.18 ms
[2023-05-18 18:14] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 24.92 ms
[2023-05-18 18:14] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 24.66 ms
[2023-05-18 18:14] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 24.27 ms
[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

[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
[2023-05-18 18:16] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板1 | 31.51 ms
[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
[2023-05-18 18:16] select * from `pay_products` where (`price` = 10 and `type` = COIN and `given` = 1000) limit 1 | 30.62 ms
[2023-05-18 18:16] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 31.37 ms
[2023-05-18 18:16] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 30.81 ms
[2023-05-18 18:16] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 30.47 ms
[2023-05-18 18:16] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 32.11 ms
[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

[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
[2023-05-18 18:17] select count(*) as aggregate from `pay_templates` where (`uid` = 0 and `name` like %亿%) | 23.65 ms

[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
[2023-05-18 18:18] select count(*) as aggregate from `pay_templates` where (`uid` = 0) | 26.63 ms
[2023-05-18 18:18] select * from `pay_templates` where (`uid` = 0) limit 20 offset 0 | 27.85 ms

[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
[2023-05-18 18:21] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 27.03 ms
[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

[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
[2023-05-18 18:32] select count(*) as aggregate from `pay_templates` where `uid` = 0 and `name` = AAAA模板11 | 26.73 ms
[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
[2023-05-18 18:32] select * from `pay_products` where (`price` = 10 and `type` = COIN and `given` = 1000) limit 1 | 27.67 ms
[2023-05-18 18:32] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 27.5 ms
[2023-05-18 18:32] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 26.35 ms
[2023-05-18 18:32] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 26.78 ms
[2023-05-18 18:32] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 26.51 ms
[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

[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
[2023-05-18 18:38] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 26.16 ms
[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

[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
[2023-05-18 18:45] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 18.4 ms
[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
[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
[2023-05-18 18:45] select * from `pay_products` where (`price` = 9 and `type` = COIN and `given` = 1000) limit 1 | 18.8 ms
[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
[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
[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
[2023-05-18 18:45] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 18.13 ms
[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
[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
[2023-05-18 18:45] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 22.19 ms
[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
[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
[2023-05-18 18:45] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 17.44 ms
[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
[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
[2023-05-18 18:45] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 18.32 ms
[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
[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

[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
[2023-05-18 18:48] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 24.35 ms
[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
[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
[2023-05-18 18:48] select * from `pay_products` where (`price` = 9 and `type` = COIN and `given` = 1000) limit 1 | 25.79 ms
[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
[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
[2023-05-18 18:48] select * from `pay_products` where (`price` = 30 and `type` = COIN and `given` = 0) limit 1 | 20.96 ms
[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
[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
[2023-05-18 18:48] select * from `pay_products` where (`price` = 50 and `type` = COIN and `given` = 4000) limit 1 | 21.81 ms
[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
[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
[2023-05-18 18:48] select * from `pay_products` where (`price` = 190 and `type` = MONTH and `given` = 0) limit 1 | 20.33 ms
[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
[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
[2023-05-18 18:48] select * from `pay_products` where (`price` = 290 and `type` = YEAR and `given` = 0) limit 1 | 20.36 ms
[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
[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

[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
[2023-05-18 19:01] select * from `pay_templates` where `uid` = 0 and `id` = 5 limit 1 | 22.58 ms
[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