+----+-------------+-----------------+--------+---------------------------------------------------------------+--------------------------+---------+-----------------------+------+--------------------------------------+
| id | select_type | table           | type   | possible_keys                                                 | key                      | key_len | ref                   | rows | Extra                                |
+----+-------------+-----------------+--------+---------------------------------------------------------------+--------------------------+---------+-----------------------+------+--------------------------------------+
|  1 | SIMPLE      | map_products    | ALL    | PRIMARY                                                       | NULL                     |    NULL | NULL                  |  342 | Using temporary; Using filesort      |
|  1 | SIMPLE      | bugs            | ref    | bugs_assigned_to_idx,bugs_creation_ts_idx,bugs_product_id_idx | bugs_product_id_idx      |       2 | bugs.map_products.id  |  686 | Using where                          |
|  1 | SIMPLE      | map_assigned_to | eq_ref | PRIMARY                                                       | PRIMARY                  |       3 | bugs.bugs.assigned_to |    1 |                                      |
|  1 | SIMPLE      | longdescs_LD0   | ref    | longdescs_bug_id_idx,longdescs_who_idx                        | longdescs_bug_id_idx     |       3 | bugs.bugs.bug_id      |    4 | Using where                          |
|  1 | SIMPLE      | bug_status      | eq_ref | bug_status_value_idx                                          | bug_status_value_idx     |      64 | bugs.bugs.bug_status  |    1 |                                      |
|  1 | SIMPLE      | bug_group_map   | ref    | bug_group_map_bug_id_idx                                      | bug_group_map_bug_id_idx |       3 | bugs.bugs.bug_id      |    1 | Using where; Using index; Not exists |
+----+-------------+-----------------+--------+---------------------------------------------------------------+--------------------------+---------+-----------------------+------+--------------------------------------+