+----+-------------+-------+--------+-----------------------------------------------------------+--------------+---------+------------------------+-------+---------------------------------+
| id | select_type | table | type   | possible_keys                                             | key          | key_len | ref                    | rows  | Extra                           |
+----+-------------+-------+--------+-----------------------------------------------------------+--------------+---------+------------------------+-------+---------------------------------+
|  1 | SIMPLE      | p     | ALL    | id,id_2                                                   | NULL         | NULL    | NULL                   | 21354 | Using temporary; Using filesort |
|  1 | SIMPLE      | cp    | ref    | PRIMARY,product_id,category_id,product_id_2,category_id_2 | product_id_2 | 4       | fonts.p.id             |     2 |                                 |
|  1 | SIMPLE      | c     | eq_ref | PRIMARY,parent_id,id,parent_id_2                          | PRIMARY      | 2       | fonts.cp.category_id   |     1 |                                 |
|  1 | SIMPLE      | ac    | eq_ref | PRIMARY,id                                                | PRIMARY      | 2       | fonts.c.parent_id      |     1 |                                 |
|  1 | SIMPLE      | co    | index  | PRIMARY,id                                                | PRIMARY      | 4       | NULL                   |     0 | Using index                     |
|  1 | SIMPLE      | d     | ALL    | PRIMARY,id                                                | NULL         | NULL    | NULL                   |   648 |                                 |
|  1 | SIMPLE      | v     | ALL    | PRIMARY,id                                                | NULL         | NULL    | NULL                   |   423 |                                 |
+----+-------------+-------+--------+-----------------------------------------------------------+--------------+---------+------------------------+-------+---------------------------------+