Explain Query (mysql)
EXPLAIN SELECT `t`.`interactive_question_answer_id` AS `t0_c0`, `t`.`parent_id` AS `t0_c1`, `t`.`type` AS `t0_c2`, `t`.`value` AS `t0_c3`, `t`.`root` AS `t0_c4`, `t`.`lft` AS `t0_c5`, `t`.`rgt` AS `t0_c6`, `t`.`level` AS `t0_c7`, `i18nInteractiveQA`.`l_id` AS `t1_c0`, `i18nInteractiveQA`.`interactive_question_answer_id` AS `t1_c1`, `i18nInteractiveQA`.`lang_id` AS `t1_c2`, `i18nInteractiveQA`.`l_value` AS `t1_c3` FROM `interactive_questions_answers` `t` LEFT OUTER JOIN `interactive_questions_answersLang` `i18nInteractiveQA` ON (`i18nInteractiveQA`.`interactive_question_answer_id`=`t`.`interactive_question_answer_id`) AND (i18nInteractiveQA.lang_id='en') WHERE (`t`.`interactive_question_answer_id`=4)
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | ||
| 1 | SIMPLE | i18nInteractiveQA | ALL | 242 | 100.00 | Using where |