Explain Query (mysql)
EXPLAIN SELECT LCASE(parent) as parent,LCASE(child) as child, ai.name , ai.type
FROM authitemchild ac
LEFT JOIN authitem ai ON ai.name = ac.child
ORDER BY `ai`.`type` DESC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ac | index | child | 257 | 2352 | 100.00 | Using index; Using temporary; Using filesort | |||
| 1 | SIMPLE | ai | eq_ref | PRIMARY | PRIMARY | 257 | securelufacom.ac.child | 1 | 100.00 |