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

Query time 0.00100

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": 15,
          "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
62173 22857 0 1 S N Y N 0 M A 0 not_option 0 1 0 0 0 (NEW) Light Source - Australia i 0 1 1 Light Source
62173 22858 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - ULM o 0 0 1 Shade Size
62173 22859 0 1 S N Y N 0 M A 10 not_option 3 0 0 0 0 (NEW) Finishes - Australia o 0 0 1 Shade & Top Finish View Design File
62173 21947 0 1 S N Y N 0 M A 15 not_option 4 0 0 0 0 (NEW) Mounting Options - Stem i 0 1 2 Mounting Options View Stem Design File
62173 22880 0 1 S N Y N 0 M A 20 not_option {"1":{"type":"ANY","items":[["22859","227198"],["22859","227223"],["22859","227219"],["22859","227220"],["22859","227221"],["22859","227222"],["22859","227203"],["22859","227202"],["22859","227218"],["22859","227217"],["22859","227199"],["22859","227207"],["22859","227200"],["22859","227201"],["22859","227204"],["22859","227206"],["22859","227208"],["22859","227216"],["22859","227209"],["22859","227210"],["22859","227211"],["22859","227212"],["22859","227213"],["22859","227214"],["22859","227215"],["22859","237054"],["22859","237055"],["22859","241976"],["22859","241977"],["22859","241978"],["22859","241974"],["22859","241975"],["22859","242737"],["22859","242738"],["22859","242739"],["22859","227203"],["22859","242736"]]}} 5 0 0 0 0 (NEW) Mounting Finish - Australia o 0 0 1 Stem & Canopy Finish
62173 22881 0 1 S N Y N 0 M A 20 not_option {"1":{"type":"ANY","items":[["22859","227228"],["22859","227229"],["22859","227231"],["22859","227232"],["22859","227230"]]}} 5 0 0 0 0 (NEW) Mounting Finish - Australia - No SAS o 0 0 1 Stem & Canopy Finish
62173 22863 0 1 S N Y N 0 M A 23 not_option {"1":{"type":"ANY","items":[["22859","227198"],["22859","227223"],["22859","227219"],["22859","227220"],["22859","227226"],["22859","227221"],["22859","227222"],["22859","227203"],["22859","227202"],["22859","227218"],["22859","227217"],["22859","227199"],["22859","227207"],["22859","227200"],["22859","227201"],["22859","227204"],["22859","227224"],["22859","227205"],["22859","227206"],["22859","227208"],["22859","227216"],["22859","227209"],["22859","227210"],["22859","227211"],["22859","227212"],["22859","227213"],["22859","227214"],["22859","227215"],["22859","237054"],["22859","237055"],["22859","241976"],["22859","241977"],["22859","241978"],["22859","241974"],["22859","241975"]]}} 7 0 0 0 0 (NEW) Cap Option - PC Australia Stem/Gooseneck o 0 0 1 Cap Option
62173 22864 0 1 S N Y N 0 M A 23 not_option {"1":{"type":"ANY","items":[["22859","227228"],["22859","227229"],["22859","227230"]]}} 7 0 0 0 0 (NEW) Cap Option - COP Australia Stem/Gooseneck o 0 0 1 Cap Option
62173 22865 0 1 S N Y N 0 M A 23 not_option {"1":{"type":"ANY","items":[["22859","227231"],["22859","227232"]]}} 7 0 0 0 0 (NEW) Cap Option - BRS Australia Stem/Gooseneck o 0 0 1 Cap Option
62173 22882 0 1 S N Y N 0 M A 25 not_option {"1":{"type":"ANY","items":[["22881","227555"],["22881","227589"],["22881","227575"],["22881","227576"],["22881","227577"],["22881","227587"],["22881","227588"],["22881","227578"],["22881","227559"],["22881","227574"],["22881","227579"],["22881","227560"],["22881","227573"],["22881","227556"],["22881","227564"],["22881","227557"],["22881","227558"],["22881","227561"],["22881","227586"],["22881","227562"],["22881","227563"],["22881","227565"],["22881","227572"],["22881","227566"],["22881","227567"],["22881","227568"],["22881","227569"],["22881","227570"],["22881","227571"],["22880","227520"],["22880","227524"],["22880","227541"],["22880","227542"],["22880","227552"],["22880","227553"],["22880","227543"],["22880","227554"],["22880","227544"],["22880","227525"],["22880","227540"],["22880","227539"],["22880","227521"],["22880","227529"],["22880","227522"],["22880","227523"],["22880","227526"],["22880","227551"],["22880","227527"],["22880","227528"],["22880","227530"],["22880","227538"],["22880","227531"],["22880","227532"],["22880","227533"],["22880","227534"],["22880","227535"],["22880","227536"],["22880","227537"],["22880","227519"],["22881","237168"],["22881","237169"],["22880","237166"],["22880","237167"]]}} 7 0 11 0 0 (NEW) Canopy - Australia - Stem o 0 0 1 Canopy
62173 22883 0 1 S N Y N 0 M A 25 not_option {"1":{"type":"ANY","items":[["22881","227580"],["22881","227581"],["22881","227582"],["22880","227545"],["22880","227546"],["22880","227547"]]}} 7 0 11 0 0 (NEW) Canopy - Australia - Copper Stem o 0 0 1 Canopy
62173 22884 0 1 S N Y N 0 M A 25 not_option {"1":{"type":"ANY","items":[["22881","227583"],["22881","227584"],["22880","227548"],["22880","227549"]]}} 7 0 11 0 0 (NEW) Canopy - Australia - Brass Stem o 0 0 1 Canopy
62173 22872 0 1 S N Y N 0 M A 35 not_option {} 8 0 0 0 0 (NEW) Guard Finish - Australia o 0 0 1 Guard Finish
62173 22852 0 1 S N Y N 0 M A 40 not_option {} 9 0 0 0 0 (NEW) Glass Option - Australia o 0 0 1 Glass Option
62173 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