经典联合查询 ，以表ipdateaex为主，如果表swbase有和他相同的数据，就提取

$list = $connect -> field('
yr_ipdataex.id as id,
yr_ipdataex.ip as ip,
yr_ipdataex.status as status,
yr_ipdataex.succeed as succeed,
yr_ipdataex.fail as fail,
yr_swbase.name as swname ,
yr_ipdataex.last_time as last_time,
yr_swbase.telnet as telnet, 
yr_swbase.ssh as ssh
') ->  where($map) -> join(' yr_swbase ON yr_ipdataex.iplong = yr_swbase.iplong ')-> limit('0,1024') -> select();