| 1 |
SIMPLE |
sc |
index_merge |
idspectacle_2, idcontact, idcontact_festival |
idcontact, idcontact_festival |
5, 5 |
|
2 |
Using union(idcontact, idcontact_festival); Using where; Using temporary; Using filesort |
| 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 |
ct |
eq_ref |
PRIMARY, idextranetuser |
PRIMARY |
4 |
theatreok_dev.oc.idcontent |
1 |
Using where |
| 1 |
SIMPLE |
e |
eq_ref |
PRIMARY |
PRIMARY |
4 |
theatreok_dev.ct.idextranetuser |
1 |
|
| 1 |
SIMPLE |
cc |
eq_ref |
PRIMARY, idclassification |
PRIMARY |
8 |
theatreok_dev.oc.idcontent, const |
1 |
Using index; Distinct |