
下邊是有帶平底二字的商品的.看到日志里的查詢sql
SELECT S?.product_id?,S?.store_name?,S?.image?,activity_id?,S?.keyword?,S?.price?,S?.mer_id?,spu_id?,S?.status?,store_info?,brand_id?,cate_id?,unit_name?,S?.star?,S?.rank?,S?.sort?,sales?,S?.product_type?,rate?,reply_count?,extension_type?,S?.sys_labels?,S?.mer_labels?,P?.delivery_way?,P?.delivery_free? FROM eb_store_spu? S? LEFT JOIN eb_store_product? P? ON S?.product_id?=P?.product_id? WHERE ( ( S?.store_name? LIKE '%平底%' OR S?.keyword? LIKE '%平底%' ) ) AND 0 = 1 AND P?.is_gift_bag? = '0' AND S?.product_type? = '0' AND mer_status? = '1' AND S?.status? = '1' ORDER BY S?.star? DESC,S?.rank? DESC,S?.create_time? DESC LIMIT 0,30
發(fā)現(xiàn)where條件里有個(gè)AND 0 = 1這樣的條件.看了代碼每發(fā)現(xiàn)這個(gè)0=1是哪里來的.
這個(gè)是怎么多出來的0 =1 的查詢條件的?.
1.7.3版本

