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 (64821) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00116

JSON explain

{
  "query_block": {
    "select_id": 1,
    "filesort": {
      "sort_key": "a.position",
      "temporary_table": {
        "table": {
          "table_name": "c",
          "access_type": "ref",
          "possible_keys": ["PRIMARY", "product_id"],
          "key": "product_id",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "ref": ["const"],
          "rows": 14,
          "filtered": 100,
          "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
64821 22528 0 1 S N Y N 0 M A 0 not_option 0 1 0 0 0 (NEW) Light Source - DBL i 0 1 1 Light Source
64821 22529 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - DBL o 0 0 1 Shade Size
64821 22525 0 1 S N Y N 0 M A 10 not_option {} 3 0 11 5 0 (NEW) Exterior Finish - Loma o 0 0 1 Exterior Finish View Design File
64821 22526 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["22525","222205"],["22525","222228"],["22525","222210"],["22525","222225"],["22525","222226"],["22525","222227"],["22525","222229"],["22525","222223"],["22525","222224"],["22525","222222"],["22525","222206"],["22525","222213"],["22525","222207"],["22525","222208"],["22525","222211"],["22525","222212"],["22525","222214"],["22525","222215"],["22525","222216"],["22525","222217"],["22525","222218"],["22525","222219"],["22525","222220"],["22525","222221"],["22525","228805"],["22525","228806"],["22525","236902"],["22525","236903"],["22525","241506"],["22525","241507"],["22525","241508"],["22525","241504"],["22525","241505"],["22525","245354"],["22525","245355"],["22525","245356"],["22525","245353"]]}} 3 0 11 5 0 (NEW) Interior Finish - Loma o 0 0 1 Interior Finish View Design File
64821 22960 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["22525","222230"]]}} 3 0 11 5 0 (NEW) Interior Finish - Loma (Copper Ext.) o 0 0 1 Interior Finish View Design File
64821 22961 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["22525","222233"]]}} 3 0 11 5 0 (NEW) Interior Finish - Loma (Brass Ext.) o 0 0 1 Interior Finish <h1> </h1> View Design File
64821 23533 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["22525","222209"]]}} 3 0 11 5 0 (NEW) Interior Finish - Loma (Galv Ext.) o 0 0 1 Interior Finish View Design File
64821 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
64821 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
64821 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
64821 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
64821 22527 0 1 S N Y N 0 M A 30 not_option {"1":{"type":"ANY","items":[["22525","222205"],["22525","222228"],["22525","222210"],["22525","222225"],["22525","222226"],["22525","222227"],["22525","222229"],["22525","222223"],["22525","222209"],["22525","222230"],["22525","222231"],["22525","222233"],["22525","222234"],["22525","222232"],["22525","222224"],["22525","222222"],["22525","222206"],["22525","222213"],["22525","222207"],["22525","222208"],["22525","222211"],["22525","222212"],["22525","222214"],["22525","222215"],["22525","222216"],["22525","222217"],["22525","222218"],["22525","222219"],["22525","222220"],["22525","222221"],["22525","228805"],["22525","228806"],["22525","236902"],["22525","236903"],["22525","241506"],["22525","241507"],["22525","241508"],["22525","241504"],["22525","241505"],["22525","245354"],["22525","245355"],["22525","245356"],["22525","245353"]]}} 6 0 11 0 0 (NEW) Ceiling Canopy Finish - Loma - PC & NAT o 0 0 1 Ceiling Canopy Finish
64821 22541 0 1 S N Y N 0 M A 30 not_option {"1":{"type":"ANY","items":[["22525","244726"],["22525","244727"],["22525","244733"],["22525","244728"],["22525","244731"],["22525","244730"],["22525","244729"],["22525","244732"]]}} 6 0 11 0 0 (NEW) Ceiling Canopy Finish - Loma - MG o 0 0 1 Ceiling Canopy Finish
64821 21941 0 1 S N Y N 0 M A 55 not_option 11 0 0 0 0 (NEW) Socket Type - GU24 o 0 0 1 Socket Type