下边是有带平底二字的商品的.看到日志里的查询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
发现where条件里有个AND 0 = 1这样的条件.看了代码每发现这个0=1是哪里来的.
这个是怎么多出来的0 =1 的查询条件的?.
1.7.3版本
