SELECT 
  f.faq_item_id, 
  f.faq_id, 
  f.position, 
  fd.question, 
  fd.answer, 
  fd.lang_code 
FROM 
  cscart_faq_items AS f 
  LEFT JOIN cscart_faq_descriptions AS fd ON fd.faq_item_id = f.faq_item_id 
  AND fd.lang_code = 'en' 
WHERE 
  1 
  AND f.faq_id = 1 
ORDER BY 
  f.position ASC

Query time 0.00066

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "f.position",
        "table": {
          "table_name": "f",
          "access_type": "ALL",
          "rows": 11,
          "filtered": 100,
          "attached_condition": "f.faq_id = 1"
        }
      }
    },
    "table": {
      "table_name": "fd",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "10",
      "used_key_parts": ["faq_item_id", "lang_code"],
      "ref": ["dev.f.faq_item_id", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(fd.lang_code = 'en')"
    }
  }
}

Result

faq_item_id faq_id position question answer lang_code
1 1 1 How does it work? How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work?How does it work? en
2 1 2 When do I get the details of my new account? When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account?When do I get the details of my new account? en
3 1 3 Where do I find the details of my new game account? Where do I find the details of my new game account?Where do I find the details of my new game account?Where do I find the details of my new game account?Where do I find the details of my new game account?Where do I find the details of my new game account?Where do I find the details of my new game account?Where do I find the details of my new game account?Where do I find the details of my new game account?Where do I find the details of my new game account? en
4 1 4 What if the game account I bought does not match the seller's description? What if the game account I bought does not match the seller's description?What if the game account I bought does not match the seller's description?What if the game account I bought does not match the seller's description?What if the game account I bought does not match the seller's description?What if the game account I bought does not match the seller's description?What if the game account I bought does not match the seller's description?What if the game account I bought does not match the seller's description?What if the game account I bought does not match the seller's description? en