explain

select

  t1.id,t2.id

from

  t1 left join

  t2 on t2.id2 = t1.id and

        t2.id = (select dd.id

                 from t2 dd

                 where

                    dd.id2 = t1.id and

                    d1 > '2019-02-06 00:00:00'

                 order by

                   dd.d1 , dd.d2 , dd.id limit 1

                );

id     select_type     table   type    possible_keys   key     key_len ref     rows    Extra

1      PRIMARY t1      index   NULL    PRIMARY 4       NULL    3       Using index

1      PRIMARY t2      eq_ref  PRIMARY,id2     PRIMARY 4       func    1       Using where

2      DEPENDENT SUBQUERY      dd      ALL     id2,for_latest_sort     for_latest_sort 6       NULL    3       Range checked for each record (index map: 0x6)