| 1 | | Replying to [comment:37 shanebp]: |
| 2 | | > boone- |
| 3 | | > |
| 4 | | > |
| 5 | | > {{{ |
| 6 | | > EXPLAIN SELECT a . * , u.user_email, u.user_nicename, u.user_login, u.display_name, pd.value AS user_fullname |
| 7 | | > FROM wp_bp_activity a, wp_users u, wp_bp_xprofile_data pd |
| 8 | | > WHERE u.ID = a.user_id |
| 9 | | > AND pd.user_id = a.user_id |
| 10 | | > AND pd.field_id =1 |
| 11 | | > AND a.type = 'activity_comment' |
| 12 | | > AND a.item_id =577900 |
| 13 | | > AND a.mptt_left |
| 14 | | > BETWEEN 1 |
| 15 | | > AND 4 |
| 16 | | > ORDER BY a.date_recorded ASC ; |
| 17 | | > |
| 18 | | > |
| 19 | | > |
| 20 | | > |
| 21 | | > id select_type table type possible_keys key key_len ref rows Extra |
| 22 | | > 1 SIMPLE a ref user_id,item_id,type,mptt_left type 227 const 32148 Using where; Using filesort |
| 23 | | > 1 SIMPLE u eq_ref PRIMARY PRIMARY 8 PRIME.a.user_id 1 Using where |
| 24 | | > 1 SIMPLE pd ref field_id,user_id user_id 8 PRIME.a.user_id 12 Using where |
| 25 | | > }}} |
| | 1 | boone - I don't have command-line access. And it seems phpmyadmin makes the Explain output hard to copy/paste. |
| | 2 | |
| | 3 | So here's a screenshot, lol: explain_sharebp.gif |