http://www.stellarticket.co.in/en/member/tickets/xhr

id select_type table type possible_keys key key_len ref rows Extra
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