StackOverflow Question #60191901, MySQL

Language: Layout:

DROP TABLE IF EXISTS `table`;
    CREATE TABLE `table` (id INT, name VARCHAR(255), `date` DATETIME);
    INSERT INTO `table` (id, name, `date`) VALUES (10, 'a', '2020-01-08 20:40:00');
    INSERT INTO `table` (id, name, `date`) VALUES (9, 'b', '2020-01-08 20:40:00');
    INSERT INTO `table` (id, name, `date`) VALUES (8, 'c', '2020-01-08 20:40:00');
    INSERT INTO `table` (id, name, `date`) VALUES (500, 'd', '2020-01-06 22:49:00');
    INSERT INTO `table` (id, name, `date`) VALUES (7, 'e', '2020-01-06 22:00:00');

SELECT id, name, `date` FROM `table` ORDER BY `date` DESC, id DESC;

-- Set variable holding the record ID to get previous / next row ID for
    SET @r_id = 8;
    SELECT @r_id;

-- Previous ID
    SELECT id AS prev_id
    FROM `table`
    WHERE CONCAT(`date`, LPAD(id, @r_id, '0')) =
    (SELECT MAX(CONCAT(`date`, LPAD(id, @r_id, '0')))
     FROM `table`
     WHERE CONCAT(`date`, LPAD(id, @r_id, '0')) < (SELECT CONCAT(`date`, LPAD(id, @r_id, '0')) 
                                                   FROM `table`
                                                   WHERE id = @r_id));
    -- Next ID
    SELECT id AS next_id
    FROM `table`
    WHERE CONCAT(`date`, LPAD(id, @r_id, '0')) =
    (SELECT MIN(CONCAT(`date`, LPAD(id, @r_id, '0')))
     FROM `table`
     WHERE CONCAT(`date`, LPAD(id, @r_id, '0')) > (SELECT CONCAT(`date`, LPAD(id, 8, '0'))
                                                   FROM `table`
                                                   WHERE id = @r_id));


absolute service time: 0,39 sec