select not exist in other table, MySQL

Language: Layout:

DROP TABLE IF EXISTS `profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO `profiles` VALUES (1,'WILLIAM'),(2,'JOHN'),(3,'ROBERT'),(4,'MICHAEL'),(5,'JAMES'),(6,'DAVID'),(7,'RICHARD'),(8,'CHARLES'),(9,'JOSEPH'),(10,'THOMAS');

DROP TABLE IF EXISTS `request_for_friendship`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `request_for_friendship` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from_id` int(11) NOT NULL,
  `to_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO `request_for_friendship` VALUES (1,1,2),(2,1,3),(3,1,8),(5,4,1),(6,9,1);

SELECT *
FROM
    (
        SELECT * FROM profiles ORDER BY id DESC
    ) AS users
WHERE
    NOT EXISTS (
        SELECT *
        FROM request_for_friendship
        WHERE
            (
                request_for_friendship.from_id = 1
                AND
                request_for_friendship.to_id = users.id
            )
            OR
            (
                request_for_friendship.from_id = users.id
                AND
                request_for_friendship.to_id = 1
            )
    )


absolute service time: 0,45 sec