$result=DB::query(
                    "SELECT product.*, productPharmacy.cost,  productPharmacy.quantity, productPharmacy.idManufacturer, manufacturer.name AS manufacturer
                        FROM product, productPharmacy, manufacturer
                        WHERE
                            LOWER(product.name) LIKE LOWER(%s)
                            AND productPharmacy.idPharmacy = %i
                            AND product.idSync = productPharmacy.idProduct
                            AND productPharmacy.idManufacturer = manufacturer.idSync
                    ORDER BY product.name
                    LIMIT %i, %i",
                    '%'.$search.'%',
                    $pharmID,
                    $size*($page-1),
                    $size);