| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | app | ALL | 1 | Using where | ||||
| 1 | SIMPLE | app.translation | eq_ref | PRIMARY, fk.app_translation.app_id, fk.app_translation.language_id | PRIMARY | 32 | showcase_sw6.app.id, const | 1 | Using where |
| 1 | SIMPLE | app.integration | eq_ref | PRIMARY | PRIMARY | 16 | showcase_sw6.app.integration_id | 1 | |
| 1 | SIMPLE | app.aclRole | eq_ref | PRIMARY | PRIMARY | 16 | showcase_sw6.app.acl_role_id | 1 |