rendered paste bodymysql> explain members;+-----------------------------+--------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-----------------------------+--------------+------+-----+---------+----------------+| id | int(11) | NO | PRI | NULL | auto_increment | | name | varchar(255) | YES | | NULL | | | member_since | date | YES | | NULL | | | city | varchar(255) | YES | | NULL | | | last_active | datetime | YES | | NULL | | | description | text | YES | | NULL | | | login | varchar(40) | YES | MUL | NULL | | | email | varchar(255) | YES | | NULL | | | crypted_password | varchar(40) | YES | | NULL | | | salt | varchar(40) | YES | | NULL | | | created_at | datetime | YES | | NULL | | | updated_at | datetime | YES | | NULL | | | remember_token | varchar(255) | YES | | NULL | | | remember_token_expires_at | datetime | YES | | NULL | | | mtype | varchar(6) | YES | | NULL | | | avatar_id | int(11) | YES | | NULL | | | banned_at | datetime | YES | | NULL | | | scivantage_id | varchar(255) | YES | | NULL | | | member_url | varchar(255) | YES | | NULL | | | member_url_customized | tinyint(1) | YES | | 0 | | | hide_address | tinyint(1) | YES | | 0 | | | only_messages_from_followed | tinyint(1) | YES | | 0 | | | publish_trades | tinyint(1) | YES | | 0 | | | publish_historical_trades | tinyint(1) | YES | | 0 | | | publish_trade_quantity | tinyint(1) | YES | | 0 | | | investment_experience_id | int(11) | YES | | NULL | | | investment_amount_id | int(11) | YES | | NULL | | | trading_account | varchar(8) | YES | | NULL | | | occupation | varchar(255) | YES | | NULL | | | state | varchar(255) | YES | | NULL | | | country | varchar(255) | YES | | NULL | | | alert_message_id | int(11) | YES | | NULL | | | publish_portfolio | tinyint(1) | YES | | 0 | | | email_private_message | tinyint(1) | YES | | 1 | | | email_comment | tinyint(1) | YES | | 1 | | | email_trade_note_request | tinyint(1) | YES | | 1 | | | email_new_subscriber | tinyint(1) | YES | | 1 | | | featured | tinyint(1) | YES | | NULL | | | age_group_id | int(11) | YES | | NULL | | | publish_portfolio_quantity | tinyint(1) | YES | | NULL | | | trade_count | int(11) | NO | | 0 | | | public_profile | tinyint(1) | YES | | 0 | | | display_roi | tinyint(1) | YES | | 0 | | +-----------------------------+--------------+------+-----+---------+----------------+43 rows in set (0.00 sec)mysql> show indexes from members;+---------+------------+------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |+---------+------------+------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+| members | 0 | PRIMARY | 1 | id | A | 19668 | NULL | NULL | | BTREE | | | members | 1 | index_members_on_login | 1 | login | A | 19668 | NULL | NULL | YES | BTREE | | +---------+------------+------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+2 rows in set (0.00 sec)mysql>