EXPLAIN SYNTAX
SELECT count()
FROM
(
    SELECT
        number AS key_a
    FROM numbers(20)
) AS a
WHERE ((key_a >= 1) AND (key_a <= 5)) OR ((key_a >= 5) AND (key_a <= 10)) OR ((key_a >= 10) AND (key_a <= 15))

┌─explain────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ SELECT count()                                                                                                         │
│ FROM                                                                                                                   │
│ (                                                                                                                      │
│     SELECT number AS key_a                                                                                             │
│     FROM numbers(20)                                                                                                   │
│     WHERE (((((key_a >= 10) AND (key_a >= 5)) AND (key_a <= 5)) AND (key_a <= 10)) AND (key_a >= 1)) AND (key_a <= 15) │
│ ) AS a                                                                                                                 │
│ WHERE (key_a <= 15) AND (key_a >= 1) AND (key_a <= 10) AND (key_a <= 5) AND (key_a >= 5) AND (key_a >= 10)             │
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

 set convert_query_to_cnf=0;
 
 EXPLAIN SYNTAX
SELECT count()
FROM
(
    SELECT number AS key_a
    FROM numbers(20)
) AS a
WHERE ((key_a >= 1) AND (key_a <= 5)) OR ((key_a >= 5) AND (key_a <= 10)) OR ((key_a >= 10) AND (key_a <= 15))

Query id: d2d4275f-07b2-412b-9eca-bc40e0b5d180

┌─explain────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ SELECT count()                                                                                                     │
│ FROM                                                                                                               │
│ (                                                                                                                  │
│     SELECT number AS key_a                                                                                         │
│     FROM numbers(20)                                                                                               │
│     WHERE ((key_a >= 1) AND (key_a <= 5)) OR ((key_a >= 5) AND (key_a <= 10)) OR ((key_a >= 10) AND (key_a <= 15)) │
│ ) AS a                                                                                                             │
│ WHERE ((key_a >= 1) AND (key_a <= 5)) OR ((key_a >= 5) AND (key_a <= 10)) OR ((key_a >= 10) AND (key_a <= 15))     │
└────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘

 set convert_query_to_cnf=1;
 
 EXPLAIN SYNTAX
SELECT count()
FROM
(
    SELECT number AS key_a
    FROM numbers(20)
) AS a
WHERE ((key_a >= 1) AND (key_a <= 5)) OR ((key_a >= 5) AND (key_a <= 10))

Query id: 966cb5fb-58a5-4bd2-b8aa-e39c8c7fc9e4

┌─explain─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ SELECT count()                                                                                                                                          │
│ FROM                                                                                                                                                    │
│ (                                                                                                                                                       │
│     SELECT number AS key_a                                                                                                                              │
│     FROM numbers(20)                                                                                                                                    │
│     WHERE ((((key_a <= 5) OR (key_a >= 5)) AND ((key_a <= 10) OR (key_a <= 5))) AND ((key_a >= 1) OR (key_a >= 5))) AND ((key_a >= 1) OR (key_a <= 10)) │
│ ) AS a                                                                                                                                                  │
│ WHERE ((key_a >= 1) OR (key_a <= 10)) AND ((key_a >= 1) OR (key_a >= 5)) AND ((key_a <= 10) OR (key_a <= 5)) AND ((key_a <= 5) OR (key_a >= 5))         │
└─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘