SQL 语句: SELECT * FROM `tp_product` WHERE `money` >= 1 AND `money` <= 1111 AND ( ( FIND_IN_SET(0,label_ids) ) OR `title` LIKE '%名称%' ) ORDER BY `money` DESC
/** * @title 前台商品搜索框信息 * @description 前台商品搜索框信息 * @author dhl * @url /product/front_product/search_product * @param name:token require:1 default: desc:token * @param name:content require:1 default: desc:搜索的内容 * @param name:category_id require:1 default: desc:需要搜索的分类id * @param name:order require:1 default: desc:智能排序值:id * @param name:evaluate_score require:1 default: desc:好评优先值:desc * @param name:sales require:1 default: desc:人气优先值:desc * @param name:moneystart require:1 default: desc:开始价格区间 * @param name:moneyend require:1 default: desc:介绍价格区间 * @param name:pricedesc require:1 default: desc:价格由高到低值:de