[tpearl5]

and this one was really lagging in profiles:

SELECT
		u.username, s.* 
		FROM n_xperience_stats_changes AS s
		INNER JOIN n_user AS u ON u.userid=s.userid
		WHERE s.ismajor = 1
		AND s.dateline>1390089600 AND s.dateline<1405727999
		AND s.userid=1
		ORDER BY s.dateline DESC
		LIMIT 20

Solution: Add an index on userid and dateline (both in the same index)