| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | media | range | PRIMARY | PRIMARY | 16 | 2 | Using where | |
| 1 | SIMPLE | media.mediaFolder | eq_ref | PRIMARY | PRIMARY | 16 | showcase_sw6.media.media_folder_id | 1 | Using where |
| 1 | SIMPLE | media.translation | eq_ref | PRIMARY, fk.media_translation.language_id | PRIMARY | 32 | showcase_sw6.media.id, const | 1 | Using where |
| 1 | SIMPLE | media.mediaFolder.defaultFolder | eq_ref | PRIMARY | PRIMARY | 16 | showcase_sw6.media.mediaFolder.default_folder_id | 1 | Using where |