mysql 子查询与join性能对比

select sql_no_cache * from application_daily where application_info_id in
(select id from application_info where Team_TeamID=3)

select sql_no_cache * from application_daily where application_info_id in
 (161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190)

select sql_no_cache * from application_daily,application_info where
Team_TeamID=3 and application_daily.application_info_id=application_info.id

select sql_no_cache * from application_daily inner join application_info on
 (application_daily.application_info_id=application_info.id) where Team_TeamID=3