It looks like it has something to do with this query... captured in the general MySQL query log.
ALTER TABLE `core_search_index` ADD KEY `followed_content` (`index_class`(248),`index_is_last_comment`,`index_hidden`,`index_date_commented`,`index_date_updated`);