下邊是有帶平底二字的商品的.看到日志里的查詢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條件里有個AND 0 = 1這樣的條件.看了代碼每發(fā)現(xiàn)這個0=1是哪里來的.
這個是怎么多出來的0 =1 的查詢條件的?.
1.7.3版本