+----+--------------------+-------+------+---------------+------+---------+------+---------+----------------------------------------------+
| id | select_type        | table | type | possible_keys | key  | key_len | ref  | rows    | Extra                                        |
+----+--------------------+-------+------+---------------+------+---------+------+---------+----------------------------------------------+
|  1 | PRIMARY            | post  | ALL  | NULL          | NULL | NULL    | NULL | 4715129 | Using where; Using temporary; Using filesort |
|  2 | DEPENDENT SUBQUERY | post  | ALL  | NULL          | NULL | NULL    | NULL | 4715129 | Using where                                  |
+----+--------------------+-------+------+---------------+------+---------+------+---------+----------------------------------------------+