| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | bigregions | ALL | PRIMARY | 18 | Using temporary; Using filesort | |||
| 1 | SIMPLE | regions | ref | PRIMARY, idbigregion | idbigregion | 2 | theatreok_dev.bigregions.idbigregion | 1 | |
| 1 | SIMPLE | departements | ref | idregion | idregion | 1 | theatreok_dev.regions.idregion | 1 |