理代数西.都成
SELECT T1.* FROM (
SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY [P.WeightValue] desc) AS ROW_NUMBER FROM (
SELECT [P].[Classid],[P].[Typeid],[P].[Brandid],[P].[Productid],[P].[Productname],[P].[Productno],[P].[Price],[P].[Mktprice],[P].[Cost],[P].[Stockamount],[P].[Minqty],[P].[Unit],[P].[Weight],[P].[Spec],[P].[Pdtspec],[P].[Specdesc],P.Productpic + '_180X180.jpg' as Productpic,[P].[Created],[P].[Modified],[P].[Listtime],[P].[Isonsale],[P].[Viewcount],[P].[Buycount],[P].[productcolor],[P].[Integral],[P].[Points],[P].[FirstLetter],[P].[productMaxNum],[P].[PYName],[P].[BarCode],[P].[BigUnit],[P].[UnitRate],[P].[BigUnit2],[P].[UnitRate2],[P].[BigUnit3],[P].[UnitRate3],[P].[WeightUnit],[P].[Subtitle],[P].[IsWeb],[P].[IsApp],[P].[StoreId],[P].[OnSaleTime],[P].[IsOpenTieredPrice],[S].[StoreName] FROM [products] [P] INNER JOIN Class_GetIdsByParentIds(0) C ON [P].[Classid]=[C].[id] INNER JOIN [Store] [S] ON [S].[Id]=[P].[StoreId] WHERE [Inrecycled] = :where_Inrecycled
) AS thinkphp
) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 0 + 1 AND 0 + 20)
TP 框架 生成 的SQL语句，相当于在内存里有几个临时表数据，肯定会影响性能吧
