explain SELECT date_add(create_date, INTERVAL 4 HOUR ) , MAX(session_number) sn
                    FROM line_load
                    WHERE date(date_add(create_date, INTERVAL 4 HOUR )) = '2018-04-05 23:59:59'
                    AND record_id_enterprise = 1
                    GROUP BY Extract(DAY_MINUTE FROM create_date)
                    ORDER BY create_date ASC;

alter table LINE_LOAD add index date_ent_index (CREATE_DATE, RECORD_ID_ENTERPRISE);

explain SELECT CREATE_DATE, RECORD_ID_ENTERPRISE
        FROM line_load
        WHERE CREATE_DATE > '2018-04-05 00:00:00' and CREATE_DATE < '2018-04-05 23:59:59'
          AND record_id_enterprise = 1
        GROUP BY Extract(DAY_MINUTE FROM create_date)
        ORDER BY create_date ASC;