| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | app | ALL | 2 | Using where | ||||
| 1 | SIMPLE | app.translation | eq_ref|filter | PRIMARY, fk.app_translation.app_id, fk.app_translation.language_id | fk.app_translation.app_id|fk.app_translation.language_id | 32|16 | babynovasql4.app.id, const | 1 (50%) | Using where; Using rowid filter |
| 1 | SIMPLE | app.integration | eq_ref | PRIMARY | PRIMARY | 16 | babynovasql4.app.integration_id | 1 | |
| 1 | SIMPLE | app.aclRole | eq_ref | PRIMARY | PRIMARY | 16 | babynovasql4.app.acl_role_id | 1 |