SELECT name, basic, information
  from users
 where filter = something

ALTER table users add index (filter, name, basic, information);