You understanding of SQL is wrong ! If search field is indexed then MySQL do not examine rows at all, it get it directly, because it is indexed.

"SELECT *" is used in places where most of the fields are user or may be used - also it is not related to the query execution speed.

Also profiles are cached and once cached no access to database is performed to get particular profile info.