SELECT id_product,reference FROM `ps_product` WHERE reference IN ('10304054','5481FB0023552','1H0955325','1H1955603')Array
(
    [0] => 10304054
    [1] => 5481FB0023552
    [2] => 1H0955325
    [3] => 1H1955603
)
Array
(
)