共执行 3 个查询,用时 0.026669 秒,gzip开启,占用内存 610.73 KB,程序执行时间 0.086032 秒
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.live_image,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 and v.cate_id =219 and v.room_type = 3 order by v.sort_num desc limit 0,12 0.001957893371582
行2:SELECT count(id) from fanwe_video v where v.live_in in (1,3) and v.room_type = 3 and v.cate_id = 219 0.0015950202941895
行3:SELECT id as user_id,nick_name FROM fanwe_user where is_admin=1 0.023115873336792