t, MySQL - rextester

Language: Layout:

DROP TABLE IF EXISTS records;
DROP TABLE IF EXISTS NPCs;
DROP TABLE IF EXISTS QuestStages;
DROP TABLE IF EXISTS LinkedQuests;

CREATE TABLE records
    (`recordid` int, `userid` int, `platform` varchar(4), `track` varchar(14), `trackid` int, `bike` varchar(9), `time` float, `faults` int, `date` datetime, `verified` varchar(3), `wr` varchar(3))
;
    
INSERT INTO records
    (`recordid`, `userid`, `platform`, `track`, `trackid`, `bike`, `time`, `faults`, `date`, `verified`, `wr`)
VALUES
    (412, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 90.456, 6, '2017-02-18 19:54:27', 'yes', 'yes'),
    (413, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 75.458, 4, '2017-02-18 19:54:39', 'yes', 'yes'),
    (414, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 77.885, 2, '2017-02-18 19:55:02', 'yes', 'yes'),
    (415, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 59.441, 1, '2017-02-18 19:55:12', 'yes', 'yes'),
    (416, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 52.145, 0, '2017-02-18 19:55:21', 'yes', 'yes'),
    (417, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 48.444, 0, '2017-02-18 19:55:26', 'yes', 'yes'),
    (418, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 42.753, 0, '2017-02-18 19:55:33', 'yes', 'yes'),
    (419, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 39.701, 0, '2017-02-18 19:55:42', 'yes', 'yes'),
    (420, 1, 'Xbox', 'Inferno IV', 40, 'Pit Viper', 745.159, 254, '2017-02-18 20:17:35', 'yes', 'yes'),
    (421, 1, 'Xbox', 'Inferno IV', 40, 'Pit Viper', 575.169, 128, '2017-02-18 20:17:50', 'yes', 'yes'),
    (422, 1, 'Xbox', 'Inferno IV', 40, 'Pit Viper', 465.456, 101, '2017-02-18 20:18:12', 'yes', 'yes'),
    (423, 1, 'Xbox', 'Inferno IV', 40, 'Pit Viper', 321.247, 75, '2017-02-18 20:18:29', 'yes', 'yes'),
    (424, 1, 'Xbox', 'Inferno IV', 40, 'Pit Viper', 236.456, 35, '2017-02-18 20:18:58', 'yes', 'yes'),
    (425, 1, 'Xbox', 'Inferno IV', 40, 'Pit Viper', 165.359, 25, '2017-02-18 20:19:17', 'yes', 'yes'),
    (426, 1, 'Xbox', 'Waterworks', 2, 'Pit Viper', 45.452, 457, '2017-02-18 23:13:12', 'yes', 'yes'),
    (427, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 34.123, 0, '2017-02-18 23:21:47', 'yes', 'yes'),
    (428, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 32.254, 0, '2017-02-18 23:24:32', 'yes', 'yes'),
    (429, 1, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 31.169, 0, '2017-02-18 23:25:33', 'yes', 'yes'),
    (430, 1, 'Xbox', 'Waterworks', 2, 'Pit Viper', 50.000, 0, '2017-02-20 20:06:23', 'yes', 'yes'),
    (431, 3, 'Xbox', 'Turbine Terror', 1, 'Pit Viper', 25.123, 0, '2017-02-20 20:21:54', 'no', 'yes')
;

SELECT records.userid, 
       records.platform, 
       records.track, 
       records.bike,  
       records.time, 
       records.faults, 
       records.date,
       @row := IF( @track = records.track, 
                   @row + 1,
                   IF(@track := records.track,
                      1,
                      1
                     )
                 ) as rn
FROM records 
CROSS JOIN (SELECT @row := 0, @track := '') as par
WHERE records.userid = 1
ORDER BY records.trackid ASC,
         records.faults ASC,
         records.time ASC;

SELECT *
FROM (
        SELECT records.userid, 
               records.platform, 
               records.track, 
               records.bike,  
               records.time, 
               records.faults, 
               records.date,
               @row := IF( @track = records.track, 
                           @row + 1,
                           IF(@track := records.track,
                              1,
                              1
                             )
                         ) as rn
        FROM records 
        CROSS JOIN (SELECT @row := 0, @track := '') as par
        WHERE records.userid = 1
        ORDER BY records.trackid ASC,
                 records.faults ASC,
                 records.time ASC
     ) as T
WHERE T.rn = 1;


absolute service time: 0,36 sec