rendered paste body+----+-------------+-------+--------+-----------------------------------------------------------------------------------------+----------+---------+-----------------------------+------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+-----------------------------------------------------------------------------------------+----------+---------+-----------------------------+------+---------------------------------+
| 1 | SIMPLE | v | ref | PRIMARY,col2_id,col2_idcol1,col5,col2_ids | col5 | 4 | const | 1494 | Using temporary; Using filesort |
| 1 | SIMPLE | b | eq_ref | PRIMARY | PRIMARY | 4 | project.v.col2_id | 1 | Using where |
| 1 | SIMPLE | s | ref | unique_col4_col1,site_col3_col1_id,site_col3_col4_id,col1_id | col1_id | 4 | project.v.id | 11 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY | PRIMARY | 4 | project.s.col4_id | 1 | Using where |
+----+-------------+-------+--------+-----------------------------------------------------------------------------------------+----------+---------+-----------------------------+------+---------------------------------+
4 rows in set (0.00 sec)