sql优化求助

SELECT
	CONCAT(CODE, IFNULL(CLASS1, 0)) be1,
	CONCAT(CODE, IFNULL(CLASS2, 0)) be2,
	CONCAT(CODE, IFNULL(CLASS3, 0)) be3
FROM
	wms_item
HAVING
	be1 IN (
		'NC01食品',
		'20200427男鞋'
	)
OR be2 IN (
	'NC01食品',
	'20200427男鞋'
)
OR be3 IN (
	'NC01食品',
	'20200427男鞋'
)
LIMIT 1