Queries for deleting messages are not optimal on mariadb/mysql

public function cleanup_all_notifications(int $notificationdeletetime): void {

    global $DB;

    $DB->delete_records_select('message_popup_notifications',

        'notificationid IN (SELECT id FROM {notifications} WHERE timecreated < ?)', [$notificationdeletetime]);

}

public function cleanup_all_notifications(int $notificationdeletetime): void {

    global $DB;

    $DB->delete_records_select(

        'message_popup_notifications',

        'EXISTS (

                 SELECT id 

                   FROM {notifications}

                  WHERE timecreated < ? AND id = {message_popup_notifications}.notificationid

                 )',

        [$notificationdeletetime]

    );

}