mysql中limit和order by同时使用时问题的解决
select * from (select * from p_picture order by id desc) id limit 0,10;

?