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 (63816, 64026, 64738, 65770) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00135

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": 24,
          "filtered": 100,
          "attached_condition": "c.product_id in (63816,64026,64738,65770)",
          "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
64738 22203 0 1 S N Y N 0 M A 0 not_option 0 1 0 0 0 (NEW) Light Source - SBA No Nautical i 0 1 1 Light Source
64738 22204 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - SBA - Sconce o 0 0 1 Shade Size
63816 23122 0 1 S N N N 0 M A 5 not_option 1 0 0 0 0 (NEW) Light Option - Vanity Strip i 0 0 1 Light Option
63816 21970 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Finishes (1) - PC & Limited PTMP o 0 0 2 Finishes View Design File
64738 22013 0 1 S N Y N 0 M A 10 not_option 2 0 0 5 13190 (NEW) Finishes - Standard RLM Sconces o 0 0 1 Finishes View Design File
65770 23773 0 1 S N Y N 0 M A 10 not_option 2 0 0 0 20396 (NEW) Finishes - (PC No Galvanized) o 0 0 1 Finishes View Design File
64738 22014 0 1 S N Y N 0 M A 32 not_option 3 0 11 0 0 (NEW) Shade Accessory - Standard RLM Sconces o 0 0 1 Shade Accessory View Design File
64738 22015 0 1 S N Y N 0 M A 35 not_option {"2":{"type":"ANY","items":[["22014","216980"],["22028","217139"],["22144","218152"],["22039","217305"],["23569","237782"]]}} 4 0 0 0 0 (NEW) Glass Option - WGG - Standard RLM Sconces o 0 0 1 Glass Option
64738 22018 0 1 S N Y N 0 M A 35 not_option {"1":{"type":"ANY","items":[["22014","216981"],["22028","217140"],["22144","218153"],["22039","217306"],["23569","237783"]]}} 4 0 0 0 0 (NEW) Glass Option - CGG - Standard RLM Sconces o 0 0 1 Glass Option
64738 22019 0 1 S N Y N 0 M A 35 not_option {"1":{"type":"ANY","items":[["22014","216982"],["22028","217141"],["22144","218154"],["22039","217307"],["23569","237784"]]}} 4 0 0 0 0 (NEW) Glass Option - TGG - Standard RLM Sconces o 0 0 1 Glass Option
64738 22020 0 1 S N Y N 0 M A 40 not_option {"1":{"type":"ANY","items":[["22014","216978"],["22067","217631"]]},"2":{"type":"ANY","items":[["22013","216947"],["22013","216966"],["22013","216952"],["22013","216967"],["22013","216968"],["22013","216969"],["22013","216970"],["22013","216964"],["22013","216971"],["22013","216951"],["22013","216965"],["22013","216948"],["22013","216954"],["22013","216949"],["22013","216950"],["22013","216953"],["22013","216955"],["22013","216963"],["22013","216956"],["22013","216957"],["22013","216958"],["22013","216959"],["22013","216960"],["22013","216961"],["22013","216962"],["22013","225920"],["22013","236882"],["22013","236883"],["22013","245125"],["22013","245123"],["22013","245124"],["22013","245122"]]}} 5 0 0 0 0 (NEW) Acrylic Diffuser Cage Finish - PC - Standard RLM Sconces o 0 0 1 Acrylic Diffuser Cage Finish
64738 22021 0 1 S N Y N 0 M A 40 not_option {"1":{"type":"ANY","items":[["22014","216978"],["22067","217631"]]},"2":{"type":"ANY","items":[["22013","244558"],["22013","244559"],["22013","244565"],["22013","244560"],["22013","244563"],["22013","244562"],["22013","244561"],["22013","244564"]]}} 5 0 0 0 0 (NEW) Acrylic Diffuser Cage Finish - MG - Standard RLM Sconces o 0 0 1 Acrylic Diffuser Cage Finish
64738 22022 0 1 S N Y N 0 M A 40 not_option {"1":{"type":"ANY","items":[["22014","216981"],["22014","216982"],["22014","216980"],["22144","218153"],["22144","218154"],["22144","218152"],["22039","217305"],["22039","217307"],["22039","217306"],["23569","237783"],["23569","237784"],["23569","237782"]]},"2":{"type":"ANY","items":[["22013","244558"],["22013","244559"],["22013","244565"],["22013","244560"],["22013","244563"],["22013","244562"],["22013","244561"],["22013","244564"]]}} 5 0 0 0 0 (NEW) Guard Finish - MG - Standard RLM Sconces o 0 0 1 Guard Finish
64738 22023 0 1 S N Y N 0 M A 40 not_option {"1":{"type":"ANY","items":[["22014","216981"],["22014","216982"],["22014","216980"],["22144","218153"],["22144","218154"],["22144","218152"],["22039","217305"],["22039","217307"],["22039","217306"],["23569","237783"],["23569","237784"],["23569","237782"]]},"2":{"type":"ANY","items":[["22013","216947"],["22013","216966"],["22013","216952"],["22013","216967"],["22013","216968"],["22013","216969"],["22013","216970"],["22013","216964"],["22013","216971"],["22013","216951"],["22013","216965"],["22013","216948"],["22013","216954"],["22013","216949"],["22013","216950"],["22013","216953"],["22013","216955"],["22013","216963"],["22013","216956"],["22013","216957"],["22013","216958"],["22013","216959"],["22013","216960"],["22013","216961"],["22013","216962"],["22013","216947"],["22013","216966"],["22013","216952"],["22013","216967"],["22013","216968"],["22013","216969"],["22013","216970"],["22013","216964"],["22013","216971"],["22013","216951"],["22013","216965"],["22013","216948"],["22013","216954"],["22013","216949"],["22013","216950"],["22013","216953"],["22013","216955"],["22013","216963"],["22013","216956"],["22013","216957"],["22013","216958"],["22013","216959"],["22013","216960"],["22013","216961"],["22013","216962"],["22013","225920"],["22013","236882"],["22013","236883"],["22013","245125"],["22013","245123"],["22013","245124"],["22013","245122"]]}} 5 0 0 0 0 (NEW) Guard Finish - PC - Standard RLM Sconces o 0 0 1 Guard Finish
64738 22025 0 1 S N Y N 0 M A 40 not_option {"1":{"type":"ANY","items":[["22014","216979"],["22067","217632"],["22254","219399"],["22039","217304"],["23569","237781"],["22911","228070"]]},"2":{"type":"ANY","items":[["22013","244558"],["22013","244559"],["22013","244565"],["22013","244560"],["22013","244563"],["22013","244562"],["22013","244561"],["22013","244564"]]}} 5 0 0 0 0 (NEW) Wire Cage Finish - MG - Standard RLM Sconces o 0 0 1 Wire Cage Finish
64738 22024 0 1 S N Y N 0 M A 40 not_option {"1":{"type":"ANY","items":[["22014","216979"],["22067","217632"],["22254","219399"],["22039","217304"],["22254","219399"],["23569","237781"],["22911","228070"]]},"2":{"type":"ANY","items":[["22013","216969"],["22013","225920"],["22013","216968"],["22013","216966"],["22013","216952"],["22013","216967"],["22013","216970"],["22013","216971"],["22013","216951"],["22013","216965"],["22013","216964"],["22013","216953"],["22013","216954"],["22013","216950"],["22013","216948"],["22013","216949"],["22013","216955"],["22013","216956"],["22013","216961"],["22013","216962"],["22013","216963"],["22013","216960"],["22013","216959"],["22013","216957"],["22013","216958"],["22013","216947"],["21970","215733"],["21970","215734"],["21970","215732"],["21970","215731"],["21970","215729"],["21970","215730"],["21970","215740"],["21970","215741"],["21970","215738"],["21970","215742"],["21970","215737"],["21970","215735"],["21970","215736"],["21970","215728"],["21970","215727"],["21970","215739"],["21970","215718"],["21970","215717"],["21970","215716"],["21970","215714"],["21970","215715"],["21970","215719"],["21970","215720"],["21970","215725"],["21970","215726"],["21970","215724"],["21970","215723"],["21970","215721"],["21970","215722"],["21970","215713"],["22013","236882"],["22013","236883"]]}} 5 0 0 0 0 (NEW) Wire Cage Finish - PC - Standard RLM Sconces o 0 0 1 Wire Cage Finish
64738 21961 0 1 S N Y N 0 M A 43 not_option 6 0 0 0 0 (NEW) Plug-in Option o 0 0 1 Plug-in Option
64738 21967 0 1 S N Y N 0 M A 44 not_option {"1":{"type":"ANY","items":[["21961","215617"],["23540","236844"],["21984","215975"],["23586","238105"]]}} 6 0 8 0 0 (NEW) Plug-in Cord Option o 0 0 1 Plug-in Cord Option View Cord Design File
64738 21962 0 1 S N Y N 0 M A 45 not_option {"1":{"type":"ANY","items":[["21961","215616"]]}} 8 0 0 0 0 (NEW) Dusk-to-Dawn Photocell - Sconce o 0 0 1 Dusk-to-Dawn Photocell
64738 22026 0 1 S N Y N 0 M A 55 not_option 8 0 0 0 0 (NEW) Socket Type - GU24 - RLM Sconces o 0 0 1 Socket Type
63816 23318 0 1 S N Y N 0 M A 60 not_option {"1":{"type":"ANY","items":[["23122","230910"]]}} 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x3 (Multi - No Large) o 0 0 1 Bulbs
63816 23319 0 1 S N Y N 0 M A 60 not_option {"1":{"type":"ANY","items":[["23122","230911"]]}} 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x5 (Multi - No Large) o 0 0 1 Bulbs
64026 22878 0 1 S N Y N 0 M A 60 not_option 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x5 (No Large) o 0 0 1 Bulbs
65770 22247 0 1 S N Y N 0 M A 60 not_option 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala o 0 0 1 Bulbs