id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | u0_ | ALL | 1 | Using where; Using temporary; Using filesort | ||||
1 | SIMPLE | u3_ | ref | PRIMARY, IDX_EF981927666E4E08 | IDX_EF981927666E4E08 | 4 | Stellar_UVDesk_internal.u0_.id | 1 | Using index |
1 | SIMPLE | u1_ | eq_ref | PRIMARY | PRIMARY | 4 | Stellar_UVDesk_internal.u3_.ticket_type_id | 1 | Using where |
1 | SIMPLE | u2_ | ALL | IDX_B9C261B1A1E5E0D4 | 1 | Using where; Using join buffer (flat, BNL join) |