| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | <derived2> | ALL | 3 | 100 | ||||||
| 2 | DERIVED | a0_ | index | PRIMARY, categorie_id | PRIMARY | 4 | 3 | 100 |
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | <derived2> | ALL | 3 | 100 | ||||||
| 2 | DERIVED | a0_ | index | PRIMARY, categorie_id | PRIMARY | 4 | 3 | 100 |