paramqueryexplain2

1	PRIMARY	hosts	ref	PRIMARY,host_group_id_ix,index_hosts_on_type,index_hosts_on_type_and_organization_id_and_location_id,index_hosts_on_type_and_location_id	index_hosts_on_type	768	const	7245	Using index condition; Using where; Using temporary; Using filesort
1	PRIMARY	hosts	eq_ref	PRIMARY,index_hosts_on_type,index_hosts_on_type_and_organization_id_and_location_id,index_hosts_on_type_and_location_id	PRIMARY	4	foreman.hosts.id	1	Using where; Distinct
1	PRIMARY	nics	ref	index_by_host	index_by_host	5	foreman.hosts.id	1	Using where; Distinct