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 (64723, 64275, 65083, 64276) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00125

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": 30,
          "filtered": 100,
          "attached_condition": "c.product_id in (64723,64275,65083,64276)",
          "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
64723 22143 0 1 S N Y N 0 M A 0 not_option 0 1 0 0 0 (NEW) Light Source - RWS No Nautical i 0 1 1 Light Source
64275 22955 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - DBG o 0 0 1 Shade Size
64723 22127 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - RWS - Sconce o 0 0 1 Shade Size
65083 22126 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - RWS i 0 0 1 Shade Size
64275 22952 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Shade Finish (2) - PC & Limited PTMP o 0 0 2 Shade Finish View Design File
64276 22952 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Shade Finish (2) - PC & Limited PTMP o 0 0 2 Shade Finish View Design File
64723 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
65083 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
64275 22951 0 1 S N Y N 0 M A 14 not_option 3 0 0 0 0 (NEW) Arm Finish - PC & Limited PTMP o 0 0 1 Arm Finish
64276 22951 0 1 S N Y N 0 M A 14 not_option 3 0 0 0 0 (NEW) Arm Finish - PC & Limited PTMP o 0 0 1 Arm Finish
64275 21954 0 1 S N Y N 0 M A 16 not_option 3 0 8 0 21353 (NEW) Cords - No Twist o 0 0 1 Cords View Design File
64276 21954 0 1 S N Y N 0 M A 16 not_option 3 0 8 0 21353 (NEW) Cords - No Twist o 0 0 1 Cords View Design File
64275 22950 0 1 S N Y N 0 M A 25 not_option 5 0 11 0 0 (NEW) Socket Finish & Switch o 0 0 1 Socket Finish & Switch
64276 22950 0 1 S N Y N 0 M A 25 not_option 5 0 11 0 0 (NEW) Socket Finish & Switch o 0 0 1 Socket Finish & Switch
64723 22144 0 1 S N Y N 0 M A 32 not_option 3 0 11 0 0 (NEW) Shade Accessory - Standard RLM Sconce - Guard & Glass Only o 0 0 1 Shade Accessory
64723 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
64723 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
64723 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
64723 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
64723 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
64723 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
64723 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
64723 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
65083 22675 0 1 S N Y N 0 M A 47 not_option 12 0 0 0 0 (NEW) Lumens - 850-1250 i 0 1 1 Lumens
64723 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
65083 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
64275 22246 0 1 S N Y N 0 M A 60 not_option {} 0 0 11 -5 0 (NEW) Green Creative Bulbs o 0 0 1 Bulbs
64276 22246 0 1 S N Y N 0 M A 60 not_option {} 0 0 11 -5 0 (NEW) Green Creative Bulbs o 0 0 1 Bulbs
65083 22645 0 1 S N Y N 0 M A 60 not_option 14 0 0 0 0 (NEW) LED Lens o 0 0 1 LED Lens
65083 23594 0 1 S N Y N 0 M A 65 not_option {} 8 0 0 0 0 (NEW) Dusk-to-Dawn Photocell - LED Sconce o 0 0 1 Dusk-to-Dawn Photocell