id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i6	ALL	PRIMARY,instance_id	NULL	NULL	NULL	1	Using temporary; Using filesort
1	SIMPLE	i13	ref	PRIMARY,object_id,objects_name1_idx	objects_name1_idx	130	const	1	Using where; Using index
1	SIMPLE	i11	ref	contacts_object_id_idx	contacts_object_id_idx	9	icinga.i13.object_id	1	Using where; Using index
1	SIMPLE	i4	index	NULL	idx_all	35	NULL	3042	Using index; Using join buffer
1	SIMPLE	i	eq_ref	PRIMARY,servicegroup_id,instance_id,servicegroups_i_id_idx,idx_all	PRIMARY	8	icinga.i4.servicegroup_id	1	Using where
1	SIMPLE	i3	ref	service_object_id,services_combined_object_idx	service_object_id	9	icinga.i4.service_object_id	1	Using where; Using index
1	SIMPLE	i5	ref	object_id	object_id	9	icinga.i4.service_object_id	1	Using where
1	SIMPLE	i8	index	NULL	idx_all	35	NULL	3042	Using where; Using index; Using join buffer
1	SIMPLE	i12	index	NULL	idx_all	35	NULL	295	Using where; Using index; Using join buffer
1	SIMPLE	i10	ALL	NULL	NULL	NULL	NULL	3483	Using join buffer
1	SIMPLE	i7	eq_ref	PRIMARY,service_id,service_object_id,services_combined_object_idx	PRIMARY	8	icinga.i10.service_id	1	Using where
1	SIMPLE	i9	eq_ref	PRIMARY,contactgroup_id	PRIMARY	8	icinga.i12.contactgroup_id	1	Using where
1	SIMPLE	i2	eq_ref	PRIMARY,object_id	PRIMARY	8	icinga.i.servicegroup_object_id	1