CREATE INDEX index_1 ON fusion_comments (comment_type, comment_item_id); CREATE INDEX index_2 ON fusion_comments (comment_item_id, comment_type, comment_hidden, comment_public); CREATE INDEX index_3 ON fusion_comments (comment_name);