下边是有带平底二字的商品的.看到日志里的查询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版本
{{item.user_info.nickname ? item.user_info.nickname : item.user_name}}
作者 管理员 企业
{{itemf.name}}
{{itemc.user_info.nickname}}
{{itemc.user_name}}
回复 {{itemc.comment_user_info.nickname}}
{{itemf.name}}