paramqueryexplain1

1	PRIMARY	hosts	ref	PRIMARY,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_and_location_id	768	const	7586	Using where; Using index
1	PRIMARY	hosts	eq_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	PRIMARY	4	foreman.hosts.id	1	Using where
1	PRIMARY	nics	ref	index_by_host	index_by_host	5	foreman.hosts.id	1	Using where