id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY multimedias ref publish publish 1 const 7743 Using where; Using index
3 MATERIALIZED object_multimedia ref idobject, idmultimedia, object idobject 5 const, const 2 Using where; Using index
3 MATERIALIZED multimedias eq_ref PRIMARY, evenement, sujet_titre, avignondate, type, idextranetuser, idextranetuser_producteur, idcontact_producteur, publish PRIMARY 4 theatreok_dev.object_multimedia.idmultimedia 1 Using index
2 MATERIALIZED object_multimedia range idobject, idmultimedia, object idobject 5 259 Using where; Using index
2 MATERIALIZED multimedias eq_ref PRIMARY, evenement, sujet_titre, avignondate, type, idextranetuser, idextranetuser_producteur, idcontact_producteur, publish PRIMARY 4 theatreok_dev.object_multimedia.idmultimedia 1 Using index