MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t 
(
  id integer primary key,
  data int
)
insert into t values (1, 100), (2, 200), (3, 300);

Records: 3  Duplicates: 0  Warnings: 0


explain analyze format = tree
select *
from t
where id = 2
  or data > 50


EXPLAIN


-> Filter: ((t.id = 2) or (t.`data` > 50))  (cost=0.55 rows=2) (actual time=0.387..0.393 rows=3 loops=1)
    -> Table scan on t  (cost=0.55 rows=3) (actual time=0.047..0.052 rows=3 loops=1)