1 |
SIMPLE |
sc |
index_merge |
idspectacle_2, idcontact, idcontact_festival |
idcontact, idcontact_festival |
5, 5 |
|
2 |
Using union(idcontact, idcontact_festival); Using where |
1 |
SIMPLE |
s |
eq_ref |
PRIMARY |
PRIMARY |
4 |
theatreok_dev.sc.idspectacle |
1 |
Using where |
1 |
SIMPLE |
oc |
ref |
PRIMARY, idcontent |
PRIMARY |
4 |
theatreok_dev.sc.idspectacle |
2 |
Using index |
1 |
SIMPLE |
cc |
eq_ref |
PRIMARY, idclassification |
PRIMARY |
8 |
theatreok_dev.oc.idcontent, const |
1 |
Using index |
1 |
SIMPLE |
ct |
eq_ref |
PRIMARY |
PRIMARY |
4 |
theatreok_dev.oc.idcontent |
1 |
Using where |