以下是生成的SQL。
SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [lgcpcur].[f_id] desc) AS ROW_NUMBER FROM (SELECT [lgcpcur].[f_id],[lgcpcur].[f_ckid],[lgcpcur].[f_goodsid],[lgcpcur].[f_sh],[lgcpcur].[f_cur_xs],[lgcpcur].[f_cur_zs],[lgcpcur].[f_cur_zl],[lgcpcur].[f_cur_famt],goodsinfo.f_id AS goodsinfo__f_id,goodsinfo.f_bh AS goodsinfo__f_bh,goodsinfo.f_name AS goodsinfo__f_name,goodsinfo.f_gg AS goodsinfo__f_gg,goodsinfo.f_parent AS goodsinfo__f_parent,goodsinfo.f_lx AS goodsinfo__f_lx,goodsinfo.f_pb AS goodsinfo__f_pb,goodsinfo.f_gj AS goodsinfo__f_gj,goodsinfo.f_xinc AS goodsinfo__f_xinc,goodsinfo.f_xinz AS goodsinfo__f_xinz,goodsinfo.f_cd AS goodsinfo__f_cd,goodsinfo.f_szid AS goodsinfo__f_szid,goodsinfo.f_dw AS goodsinfo__f_dw,goodsinfo.f_js AS goodsinfo__f_js,goodsinfo.f_xz AS goodsinfo__f_xz,goodsinfo.f_zz AS goodsinfo__f_zz,goodsinfo.f_rz AS goodsinfo__f_rz,goodsinfo.f_kcsx AS goodsinfo__f_kcsx,goodsinfo.f_kcxx AS goodsinfo__f_kcxx,goodsinfo.f_zt AS goodsinfo__f_zt,goodsinfo.f_flid AS goodsinfo__f_flid FROM [xy_lgcpcur] [lgcpcur] LEFT JOIN [mm_goodsinfo] [goodsinfo] ON [lgcpcur].[f_goodsid]=[goodsinfo].[f_id]) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 10)


发现只要把 ROW_NUMBER() OVER ( ORDER BY [lgcpcur].[f_id] desc) AS ROW_NUMBER 这里的orderby 改成rand()语句是可以执行的。