left join without order, 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 name ASC
) as users
    LEFT JOIN request_for_friendship
    AS request_for_friendship_copy
    ON
    (
        request_for_friendship_copy.from_id = 1
        AND
        request_for_friendship_copy.to_id = users.id
    )
    OR
    (
        request_for_friendship_copy.from_id = users.id
        AND
        request_for_friendship_copy.to_id = 1
    );


absolute service time: 0,43 sec