+----+--------------------+----------+------+---------------+--------+---------+--------+---------+----------------+
| id | select_type        | table    | type | possible_keys | key    | key_len | ref    | rows    | Extra          |
+----+--------------------+----------+------+---------------+--------+---------+--------+---------+----------------+
|  1 | PRIMARY            | tt       | ALL  | [NULL]        | [NULL] |  [NULL] | [NULL] |      48 | Using filesort |
|  2 | DEPENDENT SUBQUERY | userlogs | ALL  | enddatetime   | [NULL] |  [NULL] | [NULL] | 6581331 | Using where    |
+----+--------------------+----------+------+---------------+--------+---------+--------+---------+----------------+