gistfile1.txt

Candidate index on node__body : entity_id, deleted, langcode

SELECT node_field_data.created AS node_field_data_created, node_field_data.nid AS nid
FROM node_field_data node_field_data
LEFT JOIN node__body node__body ON node_field_data.nid = node__body.entity_id
AND (
node__body.deleted =  '0'
AND node__body.langcode = node_field_data.langcode
)
WHERE (
node_field_data.status =  '1'
)
ORDER BY node_field_data_created DESC 
LIMIT 10 
OFFSET 0