sql语句查询,limit与order by 同时出现,应该order by在前面
eg:select orderid,status,createtime from orders where appid = :appId and userid = :userId order by createtime desc limit :page,:pageSize;
小细节,注意一下
eg:select orderid,status,createtime from orders where appid = :appId and userid = :userId order by createtime desc limit :page,:pageSize;
小细节,注意一下