rendered paste body+----+-------------+-----------------+--------+---------------------------------------------------------------+--------------------------+---------+-----------------------+------+--------------------------------------+
| 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 |
+----+-------------+-----------------+--------+---------------------------------------------------------------+--------------------------+---------+-----------------------+------+--------------------------------------+