ALTER TABLE `tranware`.`message_log` ADD INDEX `id_index`(`message_id`); ALTER TABLE `tranware`.`message_log` ADD INDEX `receiver_index`(`receiver`); ALTER TABLE `tranware`.`message_log` ADD INDEX `sender_index`(`sender`);