品牌查询优化

yujian

2019-04-28 8ee3de7c4a0526e4f3640063afc2fd0ddf811f76

品牌查询优化

 fanli/src/main/java/com/yeshi/fanli/mapping/brand/BrandClassShopMapper.xml

@@ -164,7 +164,7 @@
          <if test="state != null">
              AND cp.`bcs_state` = #{state}
          </if>
    ORDER BY cp.`bcs_cid`,cp.`bcs_top` DESC,cp.`bcs_orderby`
    ORDER BY cp.`bcs_top` DESC,cp.`bcs_orderby`
      LIMIT ${start},${count}
  </select>