select row_number()over(order by xx)rownumber,users.name, goods.sname, orders.time form users left join orders on users.uid=orders.uid left join goods on orders.sid=goods.sid where rownumber between 开始个数 and 结束个数

select two.name,three.sname,one.time from 购买记录表 one left join 用户表 two on two.uid = one.uid left join 商品表 three on three.sid = one.sid limit 1,10

select u.name,g.sname,r.time from user u, good g , record r where u.uid=r.uid and g.sid=r.sid

select user.name,goods.sname,orders.time from user,goods,orders where user.uid=orders.uid and goods.sid=orders.sid limit (pageNow-1)*pageSize,pageSize;