mysql> EXPLAIN SELECT members.`id` AS t0_r0, members.`name` AS t0_r1, members.`member_since` AS t0_r2, members.`city` AS t0_r3, members.`last_active` AS t0_r4, members.`description` AS t0_r5, members.`login` AS t0_r6, members.`email` AS t0_r7, members.`crypted_password` AS t0_r8, members.`salt` AS t0_r9, members.`created_at` AS t0_r10, members.`updated_at` AS t0_r11, members.`remember_token` AS t0_r12, members.`remember_token_expires_at` AS t0_r13, members.`mtype` AS t0_r14, members.`avatar_id` AS t0_r15, members.`banned_at` AS t0_r16, members.`scivantage_id` AS t0_r17, members.`member_url` AS t0_r18, members.`member_url_customized` AS t0_r19, members.`hide_address` AS t0_r20, members.`only_messages_from_followed` AS t0_r21, members.`publish_trades` AS t0_r22, members.`publish_historical_trades` AS t0_r23, members.`publish_trade_quantity` AS t0_r24, members.`investment_experience_id` AS t0_r25, members.`investment_amount_id` AS t0_r26, members.`trading_account` AS t0_r27, members.`occupation` AS t0_r28, members.`state` AS t0_r29, members.`country` AS t0_r30, members.`alert_message_id` AS t0_r31, members.`publish_portfolio` AS t0_r32, members.`email_private_message` AS t0_r33, members.`email_comment` AS t0_r34, members.`email_trade_note_request` AS t0_r35, members.`email_new_subscriber` AS t0_r36, members.`featured` AS t0_r37, members.`age_group_id` AS t0_r38, members.`publish_portfolio_quantity` AS t0_r39, members.`trade_count` AS t0_r40, members.`public_profile` AS t0_r41, members.`display_roi` AS t0_r42, member_counts.`id` AS t1_r0, member_counts.`member_id` AS t1_r1, member_counts.`trade_note_count` AS t1_r2, member_counts.`blog_count` AS t1_r3, member_counts.`tagged_item_count` AS t1_r4, member_counts.`group_count` AS t1_r5, member_counts.`subscription_count` AS t1_r6 FROM members LEFT OUTER JOIN member_counts ON member_counts.member_id = members.id WHERE (members.public_profile = 1) ORDER BY `trade_count` DESC LIMIT 0, 20;+----+--------------------+-----------------+-------+----------------------------------------------------+----------------------------------------+---------+-------------------+-------+----------------------------------------------+| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |+----+--------------------+-----------------+-------+----------------------------------------------------+----------------------------------------+---------+-------------------+-------+----------------------------------------------+| 1 | PRIMARY | members | ALL | NULL | NULL | NULL | NULL | 19668 | Using where; Using temporary; Using filesort | | 1 | PRIMARY | <derived2> | ALL | NULL | NULL | NULL | NULL | 20005 | | | 2 | DERIVED | members | index | NULL | PRIMARY | 4 | NULL | 19668 | Using index | | 7 | DEPENDENT SUBQUERY | subscriptions | ref | index_subscriptions_on_subscribed_id | index_subscriptions_on_subscribed_id | 5 | tk.members.id | 1 | Using where; Using index | | 6 | DEPENDENT SUBQUERY | groups_members | ref | index_groups_members_on_member_id | index_groups_members_on_member_id | 5 | tk.members.id | 1 | Using where; Using index | | 5 | DEPENDENT SUBQUERY | member_tags | ref | PRIMARY,index_member_tags_on_member_id | index_member_tags_on_member_id | 5 | tk.members.id | 8 | Using where; Using index | | 5 | DEPENDENT SUBQUERY | member_taggings | ref | index_member_taggings_on_member_tag_id | index_member_taggings_on_member_tag_id | 5 | tk.member_tags.id | 1 | Using where | | 4 | DEPENDENT SUBQUERY | postings | ref | index_postings_on_member_id,index_postings_on_type | index_postings_on_member_id | 5 | tk.members.id | 5 | Using where | | 3 | DEPENDENT SUBQUERY | postings | ref | index_postings_on_member_id,index_postings_on_type | index_postings_on_member_id | 5 | tk.members.id | 5 | Using where | +----+--------------------+-----------------+-------+----------------------------------------------------+----------------------------------------+---------+-------------------+-------+----------------------------------------------+9 rows in set (1.25 sec)