如何在mysql中两次在1个表中选择同一列

如果我理解正确，您想枚举0和1，然后将其分组：

select max(case when mode = 0 then time end),
       max(case when mode = 1 then time end)
from (select l.*,
             (@rn := if(@m = mode, @rn + 1,
                        if(@m := mode, 1, 1)
                       )
             ) as rn
      from logs l cross join
           (select @rn := 0, @m := -1) params
      order by mode, time
     ) l
group by rn;