SELECT id_product,reference FROM `ps_product` WHERE reference IN ('54283WNA','4497261','95517457','OP9361414','808218643R','4396401')Array
(
    [0] => 54283WNA
    [1] => 4497261
    [2] => 95517457
    [3] => OP9361414
    [4] => 808218643R
    [5] => 4396401
)
Array
(
)