mysql 当ID为UUID 如何取最新一条

SELECT
        tmp.intention_log_id
        FROM(
        SELECT
        @cur_intention_id := t.intention_id AS cur_intention_id,
        IF (
        @pre_intention_id = @cur_intention_id,
        @rank := @rank + 1,
        @rank := 1
        ) AS rank,
        @pre_intention_id := @cur_intention_id AS pre_intention_id,
        t.*
        FROM
        (
        SELECT
        csrl.*
        FROM
        cus_serve_relation_log csrl
        ORDER BY
        csrl.create_date DESC
        ) t
        ) tmp
        WHERE
        tmp.rank = 1


后面发现一个问题，就是需要初始化，不然第一次查询会出现1，1的情况
(SELECT @cur_intention_id := '', @rank := 1, @pre_intention_id := '') t2