Explain Query (mysql)
EXPLAIN SELECT f.question as question_fr, fl.l_question as question_en, f.answer as answer_fr, fl.l_answer as answer_en, f.visible
FROM `faq` f
LEFT JOIN faqLang fl ON f.faq_id = fl.faq_id
WHERE f.visible = 1 AND f.faq_category_id = 6
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | f | ALL | 114 | 1.00 | Using where | |||||
| 1 | SIMPLE | fl | ALL | 114 | 100.00 | Using where; Using join buffer (hash join) |