mysql – the best query replaces this query and which column would be indexed

my request like that

select id_request, username_request
from darkhast_follower
where darkhast_follower.id_request! = & # 39; 9762952594 & # 39;
AND darkhast_follower.status = 0
AND NOT exists (select null
since log_follow
where log_follow.other_id = darkhast_follower.id_request
AND log_follow.id = & # 39; 9762952594 & # 39; LIMIT 1)
LIMIT 1

log_follow has 30 million rows
and darkhast_follower has 1000 lines

log_follow indexed other_id and id

darkhast_follower indexed request_id and status

it's slow

I have 40k enable the user

soryy for bad english

- Server version: 5.7.23-log
- PHP Version: 5.6.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START THE TRANSACTION;
SET time_zone = "+00: 00";


/ *! 40101 SET @OLD_CHARACTER_SET_CLIENT = @@ CHARACTER_SET_CLIENT * /;
/ *! 40101 SET @OLD_CHARACTER_SET_RESULTS = @@ CHARACTER_SET_RESULTS * /;
/ *! 40101 SET @OLD_COLLATION_CONNECTION = @@ COLLATION_CONNECTION * /;
/ *! 40101 SET NAMES utf8mb4 * /;


- ------------------------------------------------- --- --------

-
- Table structure for the `darkhast_follower` table
-

CREATE TABLE `darkhast_follower` (
`IDD` int (11) NOT NULL,
`id` varchar (20) NOT NULL,
`username` varchar (65) NOT NULL,
`id_request` varchar (20) NOT NULL,
`username_request` varchar (65) NOT NULL,
`token_id` text NOT NULL,
`darkhasti` int (5) NOT NULL,
`daryafti` int (5) NOT NULL,
`date` text NOT NULL,
`status` tinyint (1) NOT NULL,
`gsm_sender` tinyint (1) NOT NULL,
`error_report` tinyin (3) NOT NULL,
`bot` tinyint (1) NOT NULL,
`back` tinyint (1) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

-
- Index for empty tables
-

-
- Index for the `darkhast_follower` table
-
ALTER TABLE `darkhast_follower`
ADD PRIMARY KEY (`IDD`),
ADD KEY `status` (` status`),
ADD KEY `id_request` (` id_request`);

-
- AUTO_INCREMENT for empty tables
-

-
- AUTO_INCREMENT for the `darkhast_follower` table
-
ALTER TABLE `darkhast_follower`
MODIFY `IDD` int (11) NOT NULL AUTO_INCREMENT;
COMMIT;

/ *! 40101 SET CHARACTER_SET_CLIENT = @ OLD_CHARACTER_SET_CLIENT * /;
/ *! 40101 SET CHARACTER_SET_RESULTS = @ OLD_CHARACTER_SET_RESULTS * /;
/ *! 40101 SET COLLATION_CONNECTION = @ OLD_COLLATION_CONNECTION * /;


SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START THE TRANSACTION;
SET time_zone = "+00: 00";


/ *! 40101 SET @OLD_CHARACTER_SET_CLIENT = @@ CHARACTER_SET_CLIENT * /;
/ *! 40101 SET @OLD_CHARACTER_SET_RESULTS = @@ CHARACTER_SET_RESULTS * /;
/ *! 40101 SET @OLD_COLLATION_CONNECTION = @@ COLLATION_CONNECTION * /;
/ *! 40101 SET NAMES utf8mb4 * /;

- ------------------------------------------------- --- --------

-
- Structure of the `log_follow` table
-

CREATE TABLE `log_follow` (
`IDD` int (11) NOT NULL,
`id` varchar (20) NOT NULL,
`username` varchar (65) NOT NULL,
`other_user` varchar (65) NOT NULL,
`other_id` varchar (20) NOT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8;

-
- Index for empty tables
-

-
- Index for the `log_follow` table
-
ALTER TABLE `log_follow`
ADD PRIMARY KEY (`IDD`),
ADD KEY `id` (` id`),
ADD KEY `other_id` (` other_id`);

-
- AUTO_INCREMENT for empty tables
-

-
- AUTO_INCREMENT for the `log_follow` table
-
ALTER TABLE `log_follow`
MODIFY `IDD` int (11) NOT NULL AUTO_INCREMENT;
COMMIT;

/ *! 40101 SET CHARACTER_SET_CLIENT = @ OLD_CHARACTER_SET_CLIENT * /;
/ *! 40101 SET CHARACTER_SET_RESULTS = @ OLD_CHARACTER_SET_RESULTS * /;
/ *! 40101 SET COLLATION_CONNECTION = @ OLD_COLLATION_CONNECTION * /;

darkhast_follower
log_follow