SELECT ProductID,PharmacyID,CommonNames,Manufacturer,majorClassID,ClassID,UserID,ProductStock,ProductBatch,ProductDW,DosageForm,TyNames,ProductStandard,CompanyTitle,Brand,RetailPrice,PreferentialPrice,ProductType,SalesRecords,ThumbPic,AddTime,pinyinCode,ZhengjianSales,jianzhuang,IsHot,ParentPath,MethodUse,PharmacyTitle,ProductAttribute,CompanyName FROM `products_heap` WHERE IsPassed=1 and IsDeleted=0 and PhIsPassed=1 AND `ParentPath` like '%[10]%' AND BrandID = '7767' AND IsShelves = '1' AND DosageForm = '58' ORDER BY IsShelves DESC,ShelvesTime DESC, ProductID LIMIT 0,15