@postblue indexes must be done to the value really used in WHERE part . Maybe notice.profileid  , notice.conversantion .  I don't have a lot with mysql-tuner but maybe because i'm alone (and then surely profileid). !gnusocial .

We can test and fix it in a upgrade .