MariaDB 10.4.4 problem "exists"

I have 2 similar queries:

1st with execution time of 0.002s

SELECT *
FROM `table1`
WHERE (`order_id` = 1234
O (EXISTS
(SELECT *
OF `accounts`
WHERE `table1``member_id` =` accounts``id`)
And there is
(SELECT *
OF `accounts`
WHERE `accounts``name` = & # 39; test & # 39;)))
ORDER BY `table1``id

and 2nd with execution time 2.5 s.

SELECT *
FROM `table1`
WHERE (`order_id` = 1234
Or there is
(SELECT *
OF `accounts`
WHERE `table1``member_id` =` accounts``id`
AND (`accounts``name` = & # 39; test & # 39;)))
ORDER BY `table1``id

Table1 has around 2 million records, accounts around 30k

Everything is indexed.

CREATE TABLE `accounts` (
`id` int (10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar (255) COLLATE utf8_unicode_ci NOT NULL,
`group_id` int (11) NOT NULL DEFAULT 2,
PRIMARY KEY (`id`),
KEY `name` (` name`),
KEY `group_id` (` group_id`),
) MOTOR = InnoDB AUTO_INCREMENT = 33261 DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci

CREATE TABLE `table1` (
`id` int (10) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int (11) NOT NULL,
`order_type` varchar (255) COLLATE utf8_unicode_ci DEFAULT NULL,
`member_id` int (11) NOT NULL,
`date` int (11) NOT NULL,
`created_at` timestamp NOT NULL DEFAULT current_timestamp (),
`updated_at` timestamp NOT NULL DEFAULT current_timestamp (),
PRIMARY KEY (`id`),
KEY `table1_order_id_index` (` order_id`),
KEY `member_id_2` (` member_id`)
) MOTOR = InnoDB AUTO_INCREMENT = 1985597 DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci

explain1:

+ ------ + -------------- + ----------- + ------- + ------- ------------------- + ---------- + --------- + ------- + - -------- + -------------------------- +
| id | select_type | table | type | possible_keywords | key | key_len | ref | rows | Extra |
+ ------ + -------------- + ----------- + ------- + ------- ------------------- + ---------- + --------- + ------- + - -------- + -------------------------- +
| 1 | PRIMARY | table1 | index | table1_order_id_index | PRIMARY | 4 | NULL | 1965346 | Using where |
| 3 | SUBQUERY | accounts | ref | name | name | 767 | const | 1 | Using where; Using the index |
| 2 | Materialized | accounts | index | Primary, id | group_id | 4 | NULL | 32558 | Using the index | ---------- + ---------- + --------- + ------- + ------- - + - ------------------------- +

explain2:

+ ------ + -------------- + ----------- + ------- + ------- ------------------- + --------- + --------- + ------ + --- ------ + -------------------------- +
| id | select_type | table | type | possible_keywords | key | key_len | ref | rows | Extra |
+ ------ + -------------- + ----------- + ------- + ------- ------------------- + --------- + --------- + ------ + --- ------ + -------------------------- +
| 1 | PRIMARY | table1 | index | table1_order_id_index | PRIMARY | 4 | NULL | 1965348 | Using where |
| 2 | Materialized | accounts | rank | PRIMARY, ID, name | name | 767 | NULL | 1 | Using where; Using the index |
+ ------ + -------------- + ----------- + ------- + ------- ------------------- + --------- + --------- + ------ + --- ------ + -------------------------- +

Who wants to explain why pull apart exists Is it faster than one?

The engine is InnoDB