Explain Query (mysql)
EXPLAIN SELECT `t`.`mkt_content_id` AS `t0_c0`, `t`.`context` AS `t0_c1`, `t`.`action` AS `t0_c2`, `t`.`type` AS `t0_c3`, `t`.`text` AS `t0_c4`, `multilangMktContent`.`mkt_contentLang_id` AS `t1_c0`, `multilangMktContent`.`mkt_content_id` AS `t1_c1`, `multilangMktContent`.`text` AS `t1_c2`, `multilangMktContent`.`lang` AS `t1_c3` FROM `mkt_content` `t` LEFT OUTER JOIN `mkt_contentLang` `multilangMktContent` ON (`multilangMktContent`.`mkt_content_id`=`t`.`mkt_content_id`) WHERE (`t`.`action`='FilterPopUp')
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | ALL | 18 | 10.00 | Using where | |||||
| 1 | SIMPLE | multilangMktContent | ref | fk_mkt_content_lang | fk_mkt_content_lang | 4 | securelufacom.t.mkt_content_id | 1 | 100.00 |