Say:
select * from shyl_color_list1 where navid= order by paixu asc,id desc limit 8
select * from shyl_color_list1 where navid= order by paixu asc,id desc limit 8