Mage2\Catalog\Controllers\ProductViewController::_getProductBySlug PHP Method

    private function _getProductBySlug($slug)
    {
        $slugAttribute = ProductAttribute::where('identifier', '=', 'slug')->get()->first();
        $productVarcharValue = ProductVarcharValue::where('product_attribute_id', '=', $slugAttribute->id)->where('value', '=', $slug)->where('website_id', '=', $this->websiteId)->get()->first();
        $product = Product::findorfail($productVarcharValue->product_id);
        return $product;
    }