Performance: Missing index for image_attach.nid

I turned on Devel mysql log; those two queries took too much time:

47773.51 ms 

execute 

SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid FROM node node LEFT JOIN content_type_product node_data_field_brand ON node.vid = node_data_field_brand.vid LEFT JOIN node node_node_data_field_brand ON node_data_field_brand.field_brand_nid = node_node_data_field_brand.nid LEFT JOIN image_attach image_attach ON node.nid = image_attach.nid LEFT JOIN image_attach node_node_data_field_brand__image_attach ON node_node_data_field_brand.nid = node_node_data_field_brand__image_attach.nid WHERE node.type in ('product') ) count_alias

47879.11 ms

execute

SELECT DISTINCT(node.nid) AS nid, node.title AS node_title, image_attach.iid AS image_attach_iid, node_node_data_field_brand__image_attach.iid AS node_node_data_field_brand__image_attach_iid FROM node node LEFT JOIN content_type_product node_data_field_brand ON node.vid = node_data_field_brand.vid LEFT JOIN node node_node_data_field_brand ON node_data_field_brand.field_brand_nid = node_node_data_field_brand.nid LEFT JOIN image_attach image_attach ON node.nid = image_attach.nid LEFT JOIN image_attach node_node_data_field_brand__image_attach ON node_node_data_field_brand.nid = node_node_data_field_brand__image_attach.nid WHERE node.type in ('product') ORDER BY node_title ASC LIMIT 0, 50

Also, attached image based on node reference doesn't work.