Hello,

AFAIR, IN queries are not well optimized.

Maybe something like this will help

select * from sys_products where
(select count(barcode) barcode from sys_barcode WHERE
sys_barcode.barcode=sys_products.barcode)>1