Select Top 19 user_id,netname,birthday,education,marriage,homejob,zhome from users with(index(IX_users_search)) Where sex='女' and subHide<=1 and (nhome=1 and homejob2='龙岩') and want=0 and user_id>=230233 and user_id<=270233 order by regDATE Desc