duanju_manage/storage/logs/query/20230621.log

[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 238.78 ms
[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 57.75 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 57.06 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 41.8 ms
[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 47.77 ms
[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 49.45 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 37.41 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 42.26 ms
[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 55.17 ms
[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 36.52 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 42.28 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 40.36 ms

[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 177.08 ms
[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 39.41 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 40.45 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 28.32 ms

[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 199.83 ms
[2023-06-21 13:53] select * from information_schema.tables where table_schema = test_zyduanju and table_name = migrations and table_type = 'BASE TABLE' | 36.42 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 41.53 ms
[2023-06-21 13:53] select `migration` from `migrations` order by `batch` asc, `migration` asc | 36.6 ms

[2023-06-21 13:53] insert into `users` (`username`, `email`, `password`, `creator_id`, `department_id`, `updated_at`, `created_at`) values (catchadmin, catch@admin.com, $2y$10$Bmy9amu03L.6ldhVnEfSIOxqv.Ovpmoc.aCYIJQlZAZV.VY1Fz5Ry, 1, 0, 1687326803, 1687326803) | 260.62 ms

[2023-06-21 13:57] select * from information_schema.tables where table_schema = test_zyduanju and table_name = video_stat_by_company and table_type = 'BASE TABLE' | 217.08 ms
[2023-06-21 13:57] desc video_stat_by_company | 86.99 ms

[2023-06-21 13:58] select * from information_schema.tables where table_schema = test_zyduanju and table_name = video_stat_by_user and table_type = 'BASE TABLE' | 151.02 ms
[2023-06-21 13:58] desc video_stat_by_user | 43.02 ms

[2023-06-21 15:11] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-13 and `day` <= 2023-06-13) limit 1 | 141.19 ms
[2023-06-21 15:11] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-13 and `day` <= 2023-06-13) | 31.37 ms

[2023-06-21 15:12] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) limit 1 | 151.76 ms
[2023-06-21 15:12] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) | 28.72 ms

[2023-06-21 15:13] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) limit 1 | 129.33 ms
[2023-06-21 15:13] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) | 25.92 ms

[2023-06-21 15:14] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) limit 1 | 129.01 ms
[2023-06-21 15:14] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) | 23.88 ms

[2023-06-21 15:15] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) limit 1 | 109.36 ms
[2023-06-21 15:15] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) | 22.39 ms

[2023-06-21 15:16] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) limit 1 | 167.07 ms
[2023-06-21 15:16] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) | 33.5 ms

[2023-06-21 15:17] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) limit 1 | 157.98 ms
[2023-06-21 15:17] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-14) | 29.25 ms

[2023-06-21 15:18] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 347.71 ms
[2023-06-21 15:18] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 25.13 ms
[2023-06-21 15:18] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 24.58 ms

[2023-06-21 15:28] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 352.81 ms
[2023-06-21 15:28] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 60.5 ms
[2023-06-21 15:28] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 79.1 ms

[2023-06-21 15:30] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 419.73 ms
[2023-06-21 15:30] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 109.94 ms
[2023-06-21 15:30] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 76.07 ms

[2023-06-21 15:30] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 343.21 ms
[2023-06-21 15:30] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 71.52 ms
[2023-06-21 15:30] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 63.13 ms

[2023-06-21 15:31] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 373.26 ms
[2023-06-21 15:31] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 68.98 ms
[2023-06-21 15:31] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 92.91 ms

[2023-06-21 15:36] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 313.74 ms
[2023-06-21 15:36] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 71.5 ms
[2023-06-21 15:36] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 58.99 ms

[2023-06-21 15:36] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 368.68 ms
[2023-06-21 15:36] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 90.33 ms
[2023-06-21 15:36] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 90.99 ms

[2023-06-21 15:40] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 1 | 346.82 ms
[2023-06-21 15:40] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) | 66.32 ms
[2023-06-21 15:40] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-21) limit 15 offset 0 | 62.07 ms

[2023-06-21 16:29] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-22) | 428.43 ms
[2023-06-21 16:29] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-22) limit 15 offset 0 | 71 ms

[2023-06-21 16:30] select count(*) as aggregate from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-22) | 440.18 ms
[2023-06-21 16:30] select `day`, `video_name`, `video_id`, `amount`, `charge_count`, `charge_user_num`, `play_count` from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-22) limit 15 offset 0 | 122.16 ms

[2023-06-21 16:31] select sum(amount) as amount,sum(charge_count) as charge_count,sum(charge_user_num) as charge_user_num from `video_stat_by_company` where (`user_id` = 2 and `is_delete` = 0 and `day` >= 2023-06-14 and `day` <= 2023-06-22) limit 1 | 1009.22 ms