from users with(index(IX_users_search)) Where nhome=1 and sex='女' and subHide=0 and netnameok=1 and want=0 and user_id>=10001 and zhaoqin=2 and marry<=3