SELECT 
  netting_cp_installment_options.*, 
  netting_cp_installment_option_descriptions.name, 
  netting_cp_installment_option_descriptions.short_description, 
  netting_cp_installment_option_descriptions.description, 
  netting_cp_installment_option_descriptions.lang_code 
FROM 
  netting_cp_installment_options 
  LEFT JOIN netting_cp_installment_option_descriptions ON netting_cp_installment_option_descriptions.installment_option_id = netting_cp_installment_options.installment_option_id 
  AND netting_cp_installment_option_descriptions.lang_code = 'en' 
WHERE 
  1 
  AND netting_cp_installment_options.status = 'A' 
ORDER BY 
  netting_cp_installment_options.position asc, 
  netting_cp_installment_options.installment_option_id desc

Query time 0.00031

JSON explain

{
  "query_block": {
    "select_id": 1,
    "const_condition": "1",
    "nested_loop": [
      {
        "table": {
          "table_name": "netting_cp_installment_options",
          "access_type": "system",
          "rows": 1,
          "filtered": 100
        }
      },
      {
        "table": {
          "table_name": "netting_cp_installment_option_descriptions",
          "access_type": "const",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["installment_option_id", "lang_code"],
          "ref": ["const", "const"],
          "rows": 1,
          "filtered": 100
        }
      }
    ]
  }
}

Result

installment_option_id storefront_id first_payment_type pay_shipping_on_place_order min_order_sum max_order_sum number_of_payments interval_type interval_value position status name short_description description lang_code
1 0 F Y 1000 0 1 D 30 0 A Net 30 Payment Due in 30 Days <p>‍Payment is due within thirty (30) days from the date of purchase.</p> en