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

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE u7_ range PRIMARY, IDX_C5FD9F7D6BF700BD, IDX_C5FD9F7D9395C3F3, IDX_C5FD9F7D3414710B IDX_C5FD9F7D6BF700BD 9 15 Using index condition; Using where; Using temporary; Using filesort
1 SIMPLE u2_ eq_ref PRIMARY PRIMARY 4 Stellar_UVDesk_internal.u7_.type_id 1 Using where
1 SIMPLE u1_ eq_ref PRIMARY PRIMARY 4 Stellar_UVDesk_internal.u7_.subGroup_id 1 Using where
1 SIMPLE u11_ ref PRIMARY, IDX_CF4DF9E3700047D2 IDX_CF4DF9E3700047D2 4 Stellar_UVDesk_internal.u7_.id 1 Using index
1 SIMPLE u3_ eq_ref PRIMARY PRIMARY 4 Stellar_UVDesk_internal.u7_.agent_id 1 Using where
1 SIMPLE u5_ eq_ref PRIMARY PRIMARY 4 Stellar_UVDesk_internal.u7_.customer_id 1
1 SIMPLE u4_ ref IDX_B1744733A76ED395 IDX_B1744733A76ED395 5 Stellar_UVDesk_internal.u3_.id 1 Using where
1 SIMPLE u13_ ref PRIMARY, IDX_305F9C0E700047D2 IDX_305F9C0E700047D2 4 Stellar_UVDesk_internal.u7_.id 1 Using index
1 SIMPLE u0_ eq_ref PRIMARY PRIMARY 4 Stellar_UVDesk_internal.u7_.group_id 1 Using where
1 SIMPLE u6_ ref IDX_B1744733A76ED395, IDX_B174473368771C43 IDX_B1744733A76ED395 5 Stellar_UVDesk_internal.u7_.customer_id 1 Using where
1 SIMPLE u9_ ref IDX_637D7E5D700047D2 IDX_637D7E5D700047D2 5 Stellar_UVDesk_internal.u7_.id 1 Using index
1 SIMPLE u8_ ALL PRIMARY 1 Using where; Using join buffer (flat, BNL join)