Which column to index for this query?
Do not say

!= 'null' 


Instead, say

IS NOT NULL


That is, unless you are actually storing the 4 characters "null" in a VARCHAR?

Indexes:

log_follow:  INDEX(other_id, id)   -- for the subquery
darkhast_follower:   no index is useful for this query


The query, as you have it, will scan darkhast_follower until it finds 5 rows matching the all the WHERE clauses. In doing so, it will check log_follow -- This task will be a table scan (slow) if you don't have a suitable index.  Else it will be fast.