explain select `Id`,`User`,`Friend`,`Text`,`Status`,`Datum` from `msg` USE INDEX(msg6) WHERE `Friend`='24811467' AND `Del`!='24811467' ORDER by `Id` DESC;

CREATE TABLE `msg` (
 `Id` int(11) NOT NULL,
 `User` int(11) NOT NULL,
 `Friend` int(11) NOT NULL,
 `Datum` varchar(255) NOT NULL,
 `Text` varchar(1210) NOT NULL,
 `Status` int(11) NOT NULL,
 `Del` int(11) NOT NULL,
 `Cas` int(11) NOT NULL,
 KEY `msg1` (`Friend`,`User`,`Status`),
 KEY `User` (`User`),
 KEY `Friend` (`Friend`),
 KEY `Status` (`Status`),
 KEY `Del` (`Del`),
 KEY `Id` (`Id`),
 KEY `msg2` (`Friend`,`User`),
 KEY `msg3` (`Del`,`User`,`Friend`),
 KEY `msg4` (`User`,`Friend`,`Id`),
 KEY `msg5` (`Friend`,`User`,`Status`,`Id`),
 KEY `msg6` (`Friend`,`Del`,`Id`),
 KEY `msg7` (`Friend`,`Del`),
 KEY `msg8` (`User`,`Friend`),
 KEY `msg9` (`Cas`,`Status`)
) ENGINE=MyISAM AUTO_INCREMENT=6955100 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXE