id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE object_multimedia index_merge idobject, idrole, idmultimedia, object idmultimedia, idrole 4, 3 1 Using intersect(idmultimedia, idrole); Using where; Using filesort
1 SIMPLE contacts eq_ref PRIMARY PRIMARY 4 theatreok_dev.object_multimedia.idobject 1