多条件搜索商品信息sql语句优化的问题

Question

SELECT
a.goods_id,
a.goods_name,
a.selling_price,
a.purchase_price,
a.bar_code,
a.picture
FROM
t_supplier_goods_library a
WHERE a.status = 1
AND EXISTS
(SELECT
1
FROM
t_goods_stock b
WHERE a.goods_id = b.goods_id
AND b.stock_num > 0
AND b.stock_org_id = 10047)
AND (
a.goods_name LIKE '%奶%'
OR a.brand_name LIKE '%奶%'
OR EXISTS
(SELECT
1
FROM
t_goods_type b
WHERE a.goods_type_id_2 = b.goods_type_id
AND b.goods_level = 2
AND b.goods_type LIKE '%奶%')
)
就一个商品信息搜索sql因为查询了三张表导致速度很慢要五六秒才能反映过来
我的解决办法是把三张表搜素的关键冗余到一张表然后查询
我先想知道这样做是对还是错

Answer 1

SELECT a.goods_id, a.goods_name, a.selling_price, a.purchase_price, a.bar_code
, a.picture
FROM t_supplier_goods_library a
WHERE a.status = 1
AND EXISTS (
SELECT 1
FROM t_goods_stock b
WHERE a.goods_id = b.goods_id
AND b.stock_num > 0
AND b.stock_org_id = 10047
)
AND (a.goods_name LIKE '%奶%'
OR a.brand_name LIKE '%奶%'
OR EXISTS (
SELECT 1
FROM t_goods_type b
WHERE a.goods_type_id_2 = b.goods_type_id
AND b.goods_level = 2
AND b.goods_type LIKE '%奶%'
))