包含大 OR 的 SQL，硬解析慢，如何优化

obclient [new]> select execute_time,get_plan_time, query_sql from oceanbase.gv$ob_sql_audit where trace_id='YA6240BEE9193-00063603FD7C99D6-0-0';
+--------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| execute_time | get_plan_time | query_sql                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |
+--------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|          210 |          8878 | select *
from t1
where (
        c1 = 1
        and c2 = 2
    )
    or (
        c1 = 4
        and c2 = 5
    )
    or (
        c1 = 7
        and c2 = 8
    )
    or (
        c1 = 10
        and c2 = 11
    )
    or (
        c1 = 11
        and c2 = 21
    )
    or (
        c1 = 41
        and c2 = 51
    )
    or (
        c1 = 7
        and c2 = 81
    )
    or (
        c1 = 101
        and c2 = 111
    )
        or (
        c1 = 42
        and c2 = 52
    )
    or (
        c1 = 72
        and c2 = 82
    )
    or (
        c1 = 102
        and c2 = 112
    )
    or (
        c1 = 112
        and c2 = 212
    )
    or (
        c1 = 412
        and c2 = 512
    )
    or (
        c1 = 72
        and c2 = 812
    )
    or (
        c1 = 1012
        and c2 = 1112
    )
    and c3 = 7 |
+--------------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.206 sec)

obclient [new]> select execute_time,get_plan_time, query_sql from oceanbase.gv$ob_sql_audit where trace_id='YA6240BEE9193-00063603FD7C99D9-0-0';
+--------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| execute_time | get_plan_time | query_sql                                                                                                                                                                  |
+--------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|          285 |          2609 | select * from t1 where (c1,c2) in((1,2),(4,5),(7,8),(10,11),(11,21),(41,51),(71,81),(101,111),(42,52),(72,82),(102,112),(112,212),(412,52),(712,812),(1012,1112)) and c3=7 |
+--------------+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.203 sec)