Method getProductCodes

public static function getProductCodes($id)
{
    $db = Factory::getDBO();
    $wheres = array();
    $wheres[] = ' a.id = ' . (int) $id;
    $query = ' SELECT a.sku, a.upc, a.ean, a.jan, a.isbn, a.mpn, a.serial_number' . ' FROM #__phocacart_products AS a' . ' WHERE ' . implode(' AND ', $wheres) . ' ORDER BY a.id' . ' LIMIT 1';
    $db->setQuery($query);
    $productCodes = $db->loadAssoc();
    return $productCodes;
}