| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | rbac_auth_assignment | NULL | ref | PRIMARY | PRIMARY | 194 | const | 295 | 100 | Using index; Using temporary; Using filesort; Start temporary |
| 1 | SIMPLE | user | NULL | eq_ref | PRIMARY,idx_user_profile_rating | PRIMARY | 4 | playtennis_dev.rbac_auth_assignment.user_id | 1 | 5 | Using where; End temporary |