解决主键非整形取最新一条数据

        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