Please explain what this sql code does

select substring_INDEX(user_host, "[",1) as user, convert(argument using utf8) as command from mysql.general_log where substring_INDEX(user_host, "[",1) like '310%' and substring_INDEX(user_host, "[",1) NOT like '310student' and convert(argument using utf8) like 'SELECT%' and convert(argument using utf8) like '%student%';