magento2 load query

SELECT `e`.*, `stock_status_index`.`stock_status` AS `is_salable`

FROM `catalog_product_entity` AS `e`

INNER JOIN `cataloginventory_stock_status` AS `stock_status_index`
    ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1

WHERE (stock_status_index.stock_status = 1)