AD MySQL performance

gistfile1.txt

Query	
SELECT node.nid AS nid, node.title AS node_title, commerce_product_field_data_field_product_reference.product_id AS commerce_product_field_data_field_product_reference_product_, node.created AS node_created, 'node' AS field_data_field_product_images_node_entity_type, 'node' AS field_data_body_node_entity_type, 'node' AS field_data_field_product_discount_blurb_node_entity_type, 'commerce_product' AS field_data_field_eligible_for_offers_commerce_product_entity
FROM 
{node} node
LEFT JOIN {field_data_field_product_reference} field_data_field_product_reference ON node.nid = field_data_field_product_reference.entity_id AND (field_data_field_product_reference.entity_type = 'node' AND field_data_field_product_reference.deleted = '0')
LEFT JOIN {commerce_product} commerce_product_field_data_field_product_reference ON field_data_field_product_reference.field_product_reference_product_id = commerce_product_field_data_field_product_reference.product_id
INNER JOIN {field_data_field_on_sale_now} field_data_field_on_sale_now ON node.nid = field_data_field_on_sale_now.entity_id AND (field_data_field_on_sale_now.entity_type = 'node' AND field_data_field_on_sale_now.deleted = '0')
WHERE (( (node.status = '1') AND (node.type IN  ('product_display')) AND (field_data_field_on_sale_now.field_on_sale_now_value = '1') ))
ORDER BY node_created DESC
LIMIT 10 OFFSET 0
Title	
Path	This display has no path.
Query build time	1.5 ms
Query execute time	0.86 ms
View render time