id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | u1_ | ref | PRIMARY, IDX_EFD454DDA76ED395 | IDX_EFD454DDA76ED395 | 5 | const | 1 | Using where; Using index |
1 | SIMPLE | u2_ | ref | PRIMARY, IDX_305F9C0E700047D2, IDX_305F9C0E33B92F39 | IDX_305F9C0E33B92F39 | 4 | Stellar_UVDesk_internal.u1_.id | 1 | Using index |
1 | SIMPLE | u0_ | eq_ref | PRIMARY | PRIMARY | 4 | Stellar_UVDesk_internal.u2_.ticket_id | 1 | Using index |