共执行 19 个查询,用时 0.151784 秒,gzip开启,占用内存 1.02 MB,程序执行时间 0.273756 秒
SQL语句列表:
行1:SELECT v.id AS room_id, v.sort_num, v.group_id, v.user_id, v.city, v.title, v.cate_id, v.live_in, v.video_type, v.room_type, (v.robot_num + v.virtual_watch_number + v.watch_number) as watch_number, v.head_image,v.thumb_head_image, v.xpoint,v.ypoint, u.v_type, u.v_icon, u.nick_name,u.user_level FROM fanwe_video v LEFT JOIN fanwe_user u ON u.id = v.user_id where v.live_in in (1,3) and v.room_type = 3 order by v.create_time,v.sort_num desc,v.sort desc 0.0021181106567383
行2:SHOW TABLES LIKE'fanwe_video_prop_201905' 0.0034160614013672
行3:SELECT MAX(id) from fanwe_video_prop_201905 0.0015058517456055
行4:SHOW TABLES LIKE'fanwe_video_prop_201906' 0.0018858909606934
行5:select u.id as user_id ,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,sum(v.total_ticket) as use_ticket ,u.is_authentication,v.video_id as room_id from fanwe_user as u INNER JOIN fanwe_video_prop_201906 as v on u.id = v.to_user_id where u.is_effect=1 and v.create_d = day(curdate()) and is_red_envelope = 0 GROUP BY to_user_id order BY sum(v.total_ticket) desc limit 0,10 0.0017120838165283
行6:select u.id as user_id ,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,sum(v.total_ticket) as use_ticket ,u.is_authentication,v.video_id as room_id from fanwe_user as u INNER JOIN fanwe_video_prop_201906 as v on u.id = v.to_user_id where v.create_ym=201906 and is_red_envelope = 0 GROUP BY to_user_id order BY sum(v.total_ticket) desc limit 0,10 0.0017271041870117
行7:select u.id as user_id ,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,sum(v.total_ticket) as use_ticket ,u.is_authentication,v.video_id as room_id from fanwe_user as u INNER JOIN fanwe_video_prop_201906 as v on u.id = v.to_user_id where v.create_w = week(curdate()) and is_red_envelope = 0 GROUP BY to_user_id order BY sum(v.total_ticket) desc limit 0,10 0.0016858577728271
行8:select u.id as user_id,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,u.ticket as ticket,u.is_authentication from fanwe_user as u where u.is_effect=1 and u.ticket>0 order BY u.ticket desc limit 0,10 0.053226947784424
行9:SELECT v.id AS room_id, v.sort_num, v.group_id, v.user_id, v.city, v.title, v.cate_id, v.live_in, v.video_type, v.room_type, (v.robot_num + v.virtual_watch_number + v.watch_number) as watch_number, v.head_image,v.thumb_head_image, v.xpoint,v.ypoint, u.v_type, u.v_icon, u.nick_name,u.user_level FROM fanwe_video v LEFT JOIN fanwe_user u ON u.id = v.user_id where v.live_in in (1,3) and v.room_type = 3 order by v.create_time,v.sort_num desc,v.sort desc 0.0019841194152832
行10:SHOW TABLES LIKE'fanwe_video_prop_201905' 0.0019268989562988
行11:SELECT MAX(id) from fanwe_video_prop_201905 0.0014801025390625
行12:SHOW TABLES LIKE'fanwe_video_prop_201906' 0.0018730163574219
行13:select u.id as user_id ,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,sum(v.total_diamonds) as ticket ,u.is_authentication from fanwe_video_prop_201906 as v LEFT JOIN fanwe_user as u on u.id = v.from_user_id where u.is_effect=1 and v.create_ym=201906 GROUP BY v.from_user_id order BY sum(v.total_diamonds) desc limit 0,10 0.0017468929290771
行14:select u.id as user_id ,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,sum(v.total_diamonds) as ticket ,u.is_authentication from fanwe_video_prop_201906 as v LEFT JOIN fanwe_user as u on u.id = v.from_user_id where u.is_effect=1 and v.create_ym=201906 and v.create_d=27 GROUP BY v.from_user_id order BY sum(v.total_diamonds) desc limit 0,10 0.001629114151001
行15:select u.id as user_id ,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,sum(v.total_diamonds) as use_ticket ,u.is_authentication,v.video_id as room_id from fanwe_user as u INNER JOIN fanwe_video_prop_201906 as v on u.id = v.from_user_id where u.is_effect=1 and v.create_w = week(curdate()) GROUP BY from_user_id order BY sum(v.total_diamonds) desc limit 0,10 0.0017030239105225
行16:select u.id as user_id ,u.nick_name,u.v_type,u.v_icon,u.head_image,u.sex,u.user_level,u.use_diamonds as ticket ,u.is_authentication from fanwe_user as u where u.is_effect=1 and u.use_diamonds>0 order BY u.use_diamonds desc limit 0,10 0.047041893005371
行17:select a.id,a.title,a.content,a.create_time from fanwe_article as a left join fanwe_article_cate as ac on ac.id = a.cate_id where a.is_delete = 0 and a.is_effect = 1 and ac.type_id = 4 order by a.sort desc,a.create_time desc limit 0,10 0.0018150806427002
行18:select count(a.id) from fanwe_article as a left join fanwe_article_cate as ac on ac.id = a.cate_id where a.is_delete = 0 and a.is_effect = 1 and ac.type_id = 4 0.0015590190887451
行19:SELECT id as user_id,nick_name FROM fanwe_user where is_admin=1 0.021746873855591