SELECT 
  c.product_id AS cur_product_id, 
  a.*, 
  b.option_name, 
  b.option_text, 
  b.description, 
  b.inner_hint, 
  b.incorrect_message, 
  b.comment 
FROM 
  cscart_product_options as a 
  LEFT JOIN cscart_product_options_descriptions as b ON a.option_id = b.option_id 
  AND b.lang_code = 'en' 
  LEFT JOIN cscart_product_global_option_links as c ON c.option_id = a.option_id 
WHERE 
  c.product_id IN (65836, 65956) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00122

JSON explain

{
  "query_block": {
    "select_id": 1,
    "filesort": {
      "sort_key": "a.position",
      "temporary_table": {
        "table": {
          "table_name": "c",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "product_id",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "rows": 16,
          "filtered": 100,
          "attached_condition": "c.product_id in (65836,65956)",
          "using_index": true
        },
        "table": {
          "table_name": "a",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY", "c_status"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["option_id"],
          "ref": ["cscart_migrate.c.option_id"],
          "rows": 1,
          "filtered": 73.88316345,
          "attached_condition": "a.product_id = 0 and a.`status` = 'A'"
        },
        "table": {
          "table_name": "b",
          "access_type": "eq_ref",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "9",
          "used_key_parts": ["option_id", "lang_code"],
          "ref": ["cscart_migrate.c.option_id", "const"],
          "rows": 1,
          "filtered": 100,
          "attached_condition": "trigcond(b.lang_code = 'en')"
        }
      }
    }
  }
}

Result

cur_product_id option_id product_id company_id option_type inventory regexp required multiupload allowed_extensions max_file_size missing_variants_handling status position value google_export_name_option visibility spec_sheet_url sku_column is_master_option variant_text_size variant_vertical_spacing design_file_attachment_id alt_name variant_text_location base_variant_id variant_style variant_block_size option_name option_text description inner_hint incorrect_message comment
65836 23864 0 1 S N Y N 0 M A 2 not_option 1 0 14 1 0 (NEW) Shade Size - CVR o 0 0 1 Shade Size
65956 24008 0 1 S N Y N 0 M A 2 not_option 1 0 14 1 0 (NEW) Shade Size - CVR (Flush) o 0 0 1 Shade Size
65836 23878 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 21015 (NEW!) Finishes - Powder Coat (Exterior Carver) o 0 0 2 Exterior Finish View Design File
65956 23878 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 21015 (NEW!) Finishes - Powder Coat (Exterior Carver) o 0 0 2 Exterior Finish View Design File
65836 23879 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["23878","240818"],["23878","240841"],["23878","240850"],["23878","240837"],["23878","240851"],["23878","240838"],["23878","240839"],["23878","242953"],["23878","242954"],["23878","240840"],["23878","240842"],["23878","240835"],["23878","242955"],["23878","240853"],["23878","240843"],["23878","240836"],["23878","240834"],["23878","240819"],["23878","240824"],["23878","240845"],["23878","240820"],["23878","240846"],["23878","240821"],["23878","240822"],["23878","242952"],["23878","240848"],["23878","240823"],["23878","240825"],["23878","240833"],["23878","240826"],["23878","240827"],["23878","240849"],["23878","240828"],["23878","240829"],["23878","240830"],["23878","240831"],["23878","240832"]]}} 2 0 0 0 0 (NEW!) Finishes - Powder Coat (Interior Carver) o 0 0 2 Interior Finish View Design File
65836 24009 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["23878","242956"]]}} 3 0 11 5 21015 (NEW) Interior Finish - Carver (Copper Ext.) o 0 0 1 Interior Finish View Design File
65836 24010 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["23878","242959"]]}} 3 0 11 5 21015 (NEW) Interior Finish - Carver (Brass Ext.) o 0 0 1 Interior Finish View Design File
65956 23879 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["23878","240818"],["23878","240841"],["23878","240850"],["23878","240837"],["23878","240851"],["23878","240838"],["23878","240839"],["23878","242953"],["23878","242954"],["23878","240840"],["23878","240842"],["23878","240835"],["23878","242955"],["23878","240853"],["23878","240843"],["23878","240836"],["23878","240834"],["23878","240819"],["23878","240824"],["23878","240845"],["23878","240820"],["23878","240846"],["23878","240821"],["23878","240822"],["23878","242952"],["23878","240848"],["23878","240823"],["23878","240825"],["23878","240833"],["23878","240826"],["23878","240827"],["23878","240849"],["23878","240828"],["23878","240829"],["23878","240830"],["23878","240831"],["23878","240832"]]}} 2 0 0 0 0 (NEW!) Finishes - Powder Coat (Interior Carver) o 0 0 2 Interior Finish View Design File
65956 24009 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["23878","242956"]]}} 3 0 11 5 21015 (NEW) Interior Finish - Carver (Copper Ext.) o 0 0 1 Interior Finish View Design File
65956 24010 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["23878","242959"]]}} 3 0 11 5 21015 (NEW) Interior Finish - Carver (Brass Ext.) o 0 0 1 Interior Finish View Design File
65836 23865 0 1 S N Y N 0 M A 12 not_option 2 0 11 5 0 (NEW) Wood Diffuser - Timber + Ore CVR o 0 0 1 Wood Diffuser
65956 23865 0 1 S N Y N 0 M A 12 not_option 2 0 11 5 0 (NEW) Wood Diffuser - Timber + Ore CVR o 0 0 1 Wood Diffuser
65836 23880 0 1 S N N N 0 M A 55 not_option 7 0 0 0 0 (NEW) Lumens - Carver i 0 1 1 Lumens
65956 23880 0 1 S N N N 0 M A 55 not_option 7 0 0 0 0 (NEW) Lumens - Carver i 0 1 1 Lumens
65836 22644 0 1 S N Y N 0 M A 58 not_option 13 0 0 0 0 (NEW) Color Temperature o 0 0 1 Color Temperature
65956 22644 0 1 S N Y N 0 M A 58 not_option 13 0 0 0 0 (NEW) Color Temperature o 0 0 1 Color Temperature