1 |
SIMPLE |
u0_ |
ref |
IDX_C5FD9F7D6BF700BD, IDX_C5FD9F7D9395C3F3, IDX_C5FD9F7D3414710B |
IDX_C5FD9F7D6BF700BD |
5 |
const |
63 |
Using where; Using temporary; Using filesort |
1 |
SIMPLE |
u6_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
Stellar_UVDesk_internal.u0_.subGroup_id |
1 |
Using where; Using index; Distinct |
1 |
SIMPLE |
u8_ |
ref |
PRIMARY, IDX_CF4DF9E3700047D2 |
IDX_CF4DF9E3700047D2 |
4 |
Stellar_UVDesk_internal.u0_.id |
1 |
Using index; Distinct |
1 |
SIMPLE |
u2_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
Stellar_UVDesk_internal.u0_.agent_id |
1 |
Using where; Using index; Distinct |
1 |
SIMPLE |
u5_ |
eq_ref |
PRIMARY |
PRIMARY |
4 |
Stellar_UVDesk_internal.u0_.customer_id |
1 |
Using index; Distinct |
1 |
SIMPLE |
u9_ |
ref |
IDX_B1744733A76ED395 |
IDX_B1744733A76ED395 |
5 |
Stellar_UVDesk_internal.u2_.id |
1 |
Using where; Distinct |
1 |
SIMPLE |
u11_ |
ref |
PRIMARY, IDX_305F9C0E700047D2 |
IDX_305F9C0E700047D2 |
4 |
Stellar_UVDesk_internal.u0_.id |
1 |
Using index; Distinct |
1 |
SIMPLE |
u13_ |
ref |
IDX_B1744733A76ED395, IDX_B174473368771C43 |
IDX_B1744733A76ED395 |
5 |
Stellar_UVDesk_internal.u0_.customer_id |
1 |
Using where; Distinct |
1 |
SIMPLE |
u3_ |
ref |
IDX_637D7E5D700047D2 |
IDX_637D7E5D700047D2 |
5 |
Stellar_UVDesk_internal.u0_.id |
1 |
Using index; Distinct |