SELECT A.id, A.ts, TIMEDIFF (B.ts,A.ts) AS timedifference
FROM log A INNER JOIN log B ON B.id = (A.id + 1)
ORDER BY TIMEDIFF (B.ts,A.ts) DESC
SELECT A.id, A.ts, CONVERT(TIMEDIFF (B.ts,A.ts),CHAR) AS timedifference,a.offset,a.input_offset
FROM log A INNER JOIN log B ON B.id = (A.id + 1)
ORDER BY TIMEDIFF (B.ts,A.ts) DESC