--+-------------+-------+--------+----------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------------------------------------------+

| id | select_type | table | type   | possible_keys                                | key                  | key_len | ref                                       | rows  | Extra                                        |

+----+-------------+-------+--------+----------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------------------------------------------+

|  1 | SIMPLE      | c     | range  | BOARD_THREAD_PARENT,BOARD_PARENT             | BOARD_THREAD_PARENT  |       1 | NULL                                      | 46088 | Using where; Using temporary; Using filesort |

|  1 | SIMPLE      | ct    | ref    | DATE_THREAD,THREAD_DATE                      | THREAD_DATE          |       5 | zooomclan.c.thread_id                     |    21 | Using where; Not exists                      |

|  1 | SIMPLE      | tt    | eq_ref | BOARD_THREAD_COMMENT                         | BOARD_THREAD_COMMENT |       5 | zooomclan.c.board,zooomclan.c.thread_id   |     1 |                                              |

|  1 | SIMPLE      | t     | eq_ref | PRIMARY                                      | PRIMARY              |       4 | zooomclan.tt.comment_id                   |     1 |                                              |

|  1 | SIMPLE      | cnum  | ref    | BOARD_THREAD_PARENT,THREAD_DATE,BOARD_PARENT | BOARD_THREAD_PARENT  |       6 | zooomclan.tt.board,zooomclan.tt.thread_id |    20 |                                              |

|  1 | SIMPLE      | s     | eq_ref | PRIMARY,id                                   | PRIMARY              |       4 | zooomclan.c.thread_id                     |     1 | Using index                                  |

|  1 | SIMPLE      | b     | eq_ref | PRIMARY                                      | PRIMARY              |       4 | zooomclan.c.thread_id                     |     1 | Using index                                  |

|  1 | SIMPLE      | p     | eq_ref | PRIMARY                                      | PRIMARY              |       8 | zooomclan.c.thread_id                     |     1 |                                              |

|  1 | SIMPLE      | g     | eq_ref | PRIMARY                                      | PRIMARY              |       8 | zooomclan.p.album,zooomclan.p.album       |     1 |                                              |

|  1 | SIMPLE      | ge    | eq_ref | PRIMARY                                      | PRIMARY              |       4 | zooomclan.g.event                         |     1 | Using index                                  |

|  1 | SIMPLE      | lu    | eq_ref | PRIMARY                                      | PRIMARY              |       4 | zooomclan.c.user_id                       |     1 |                                              |

|  1 | SIMPLE      | tu    | eq_ref | PRIMARY                                      | PRIMARY              |       4 | zooomclan.t.user_id                       |     1 |                                              |

+----+-------------+-------+--------+----------------------------------------------+----------------------+---------+-------------------------------------------+-------+----------------------------------------------+