show processlist
select SQL_CALC_FOUND_ROWS ktvs_videos.video_id from ktvs_videos where ktvs_videos.status_id=1 and ktvs_videos.relative_post_date<=10000 and ktvs_videos.post_date<='2019-11-14 16:31:30' order by random1 limit 10
select FOUND_ROWS()
SELECT ktvs_videos.video_id, title as title, description as description, dir as dir, server_group_id, load_type_id, user_id, content_source_id, dvd_id, status_id, is_hd, is_private, access_level_id, is_locked, duration, file_formats, file_size, file_dimensions, file_url, pseudo_url, screen_amount, screen_main, screen_main_temp, embed, delete_reason, (rating/rating_amount) as rating, rating_amount, video_viewed, video_viewed_player, video_viewed_unique, video_viewed_paid, comments_count, favourites_count, purchases_count, tokens_required, release_year, post_date as post_date, last_time_view_date, added_date, rs_completed, admin_flag_id, af_custom1, af_custom2, af_custom3, custom1, custom2, custom3, gallery_url from ktvs_videos where ktvs_videos.status_id=1 and ktvs_videos.relative_post_date<=10000 and ktvs_videos.post_date<='2019-11-14 16:31:30' and ktvs_videos.video_id in (0,6) order by rand() LIMIT 1

正在看着

show processlist
select count(*) from ktvs_videos where ktvs_videos.status_id=1 and ktvs_videos.relative_post_date<=10000 and ktvs_videos.post_date<='2019-11-14 16:31:30'
SELECT ktvs_videos.video_id, title as title, description as description, dir as dir, server_group_id, load_type_id, user_id, content_source_id, dvd_id, status_id, is_hd, is_private, access_level_id, is_locked, duration, file_formats, file_size, file_dimensions, file_url, pseudo_url, screen_amount, screen_main, screen_main_temp, embed, delete_reason, (rating/rating_amount) as rating, rating_amount, video_viewed, video_viewed_player, video_viewed_unique, video_viewed_paid, comments_count, favourites_count, purchases_count, tokens_required, release_year, post_date as post_date, last_time_view_date, added_date, rs_completed, admin_flag_id, af_custom1, af_custom2, af_custom3, custom1, custom2, custom3, gallery_url from ktvs_videos where ktvs_videos.status_id=1 and ktvs_videos.relative_post_date<=10000 and ktvs_videos.post_date<='2019-11-14 16:31:30' order by post_date desc, ktvs_videos.video_id desc LIMIT 0, 24