id,select_type,table,type,possible_keys,key,key_len,ref,rows,Extra
1,SIMPLE,l,ALL,\N,\N,\N,\N,40599,Using where; Using temporary; Using filesort
1,SIMPLE,i,ALL,ips,\N,\N,\N,111799,Range checked for each record (index map: 0x2)