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 (
    65103, 65454, 65102, 65596, 65597, 65683, 
    65608, 65612, 65602, 65610, 65611, 
    65598, 65873, 65965
  ) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00134

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": 45,
          "filtered": 100,
          "attached_condition": "c.product_id in (65103,65454,65102,65596,65597,65683,65608,65612,65602,65610,65611,65598,65873,65965)",
          "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
65873 22934 0 1 S N Y N 0 M A 0 not_option 0 1 0 0 0 (NEW) Light Source i 0 1 1 Light Source
65965 22934 0 1 S N Y N 0 M A 0 not_option 0 1 0 0 0 (NEW) Light Source i 0 1 1 Light Source
65873 23876 0 1 S N Y N 0 M A 2 not_option 1 0 14 1 0 (NEW) Shade Size - Duo o 0 0 1 Shade Size
65965 24027 0 1 S N N N 0 M A 2 not_option 1 0 0 0 0 (NEW!) Shade Size - Isos (fixed) o 0 0 1 Shade Size
65102 23848 0 1 S N N N 0 M A 5 not_option 0 0 0 0 0 (NEW) Shade Size - SBS28 i 0 1 1 Shade Size
65103 23848 0 1 S N N N 0 M A 5 not_option 0 0 0 0 0 (NEW) Shade Size - SBS28 i 0 1 1 Shade Size
65102 23831 0 1 S N Y N 0 M A 10 not_option 3 0 11 0 0 (NEW) Finishes - with Painted & Natural o 0 0 1 Shade Finish View Design File
65103 23831 0 1 S N Y N 0 M A 10 not_option 3 0 11 0 0 (NEW) Finishes - with Painted & Natural o 0 0 1 Shade Finish View Design File
65454 23523 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 21210 (NEW) Finishes - PC & Limited PTMP (Flush) o 0 0 2 Finishes View Design File
65873 23883 0 1 S N Y N 0 M A 10 not_option {} 3 0 11 5 0 (NEW) Top Shade Finish - Duo o 0 0 1 Top Shade Finish View Design File
65965 24012 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 21352 (NEW!) Finishes - Powder Coat (Exterior Isos) o 0 0 2 Exterior Finish View Design File
65965 24013 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["24012","244285"],["24012","244306"],["24012","244302"],["24012","244303"],["24012","244316"],["24012","244304"],["24012","244317"],["24012","244305"],["24012","244320"],["24012","244300"],["24012","244321"],["24012","244307"],["24012","244308"],["24012","244309"],["24012","244322"],["24012","244318"],["24012","244301"],["24012","244299"],["24012","244286"],["24012","244290"],["24012","244312"],["24012","244287"],["24012","244313"],["24012","244288"],["24012","244289"],["24012","244319"],["24012","244314"],["24012","244291"],["24012","244298"],["24012","244292"],["24012","244293"],["24012","244294"],["24012","244315"],["24012","244295"],["24012","244296"],["24012","244297"]]}} 3 0 0 0 21352 (NEW!) Finishes - Powder Coat (Interior Isos) o 0 0 2 Interior Finish View Design File
65103 21951 0 1 S N Y N 0 M A 12 not_option 3 0 0 0 0 (NEW) Chain Option i 0 1 1 Chain Option View Chain Design File
65873 23884 0 1 S N Y N 0 M A 12 not_option {} 4 0 11 5 0 (NEW) Bottom Shade Finish - Duo o 0 0 1 Bottom Shade Finish View Design File
65873 23885 0 1 S N Y N 0 M A 14 not_option {"1":{"type":"ANY","items":[["23884","242322"],["23884","242343"],["23884","242340"],["23884","242341"],["23884","242327"],["23884","242354"],["23884","242342"],["23884","242355"],["23884","242344"],["23884","242338"],["23884","242345"],["23884","242346"],["23884","242356"],["23884","242326"],["23884","242339"],["23884","242337"],["23884","242323"],["23884","242329"],["23884","242350"],["23884","242324"],["23884","242351"],["23884","242325"],["23884","242328"],["23884","242352"],["23884","242330"],["23884","242336"],["23884","242331"],["23884","242332"],["23884","242333"],["23884","242353"],["23884","242334"],["23884","242335"],["23884","242949"]]}} 5 0 11 5 21126 (NEW) Bottom Shade Interior Finish - Duo o 0 0 1 Bottom Shade Interior Finish View Design File
65873 23887 0 1 S N Y N 0 M A 14 not_option {"1":{"type":"ANY","items":[["23884","242431"]]}} 3 0 11 5 0 (NEW) Bottom Shade Interior Finish - Duo (Copper Ext.) o 0 0 1 Bottom Shade Interior Finish View Design File
65873 23888 0 1 S N Y N 0 M A 14 not_option {"1":{"type":"ANY","items":[["23884","242347"]]}} 3 0 11 5 0 (NEW) Bottom Shade Interior Finish - Duo (Brass Ext.) o 0 0 1 Bottom Shade Interior Finish View Design File
65102 22853 0 1 S N Y N 0 M A 15 not_option 4 0 0 0 0 (NEW) Mounting Options - Stem - No Flush i 0 1 2 Mounting Options View Stem Design File
65873 23875 0 1 S N Y N 0 M A 15 not_option 6 0 11 5 0 (NEW) Wooden Accent - Duo o 0 0 1 Wooden Accent
65873 23877 0 1 S N Y N 0 M A 15 not_option 4 0 0 0 0 (NEW) Mounting Option - .25 Stem i 0 1 1 Mounting Option
65965 21943 0 1 S N Y N 0 M A 15 not_option 3 0 8 0 0 (NEW) Cords o 0 0 1 Cords View Cord Design File
65103 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
65965 23900 0 1 S N N N 0 M A 19 not_option 3 0 0 0 0 (NEW) Cord & Cable Length - Studio (3 Lengths) i 0 1 1 Cord & Cable Length
65454 23524 0 1 S N Y N 0 M A 20 not_option {} 4 0 0 0 0 (NEW) Mounting Finish - PC & Limited PTMP (Flush) o 0 0 1 Mounting Finish
65873 23886 0 1 S N Y N 0 M A 20 not_option {} 8 0 11 5 0 (NEW) Mounting Finish - Duo o 0 0 1 Mounting Finish View Design File
65965 24016 0 1 S N Y N 0 M A 20 not_option 5 0 0 0 0 (NEW) Top Cover Finish - Isos o 0 0 1 Top Cover Finish
65102 23833 0 1 S N Y N 0 M A 30 not_option {} 5 0 0 0 18281 (NEW) Mounting Finish - with Painted & Natural Copper o 0 0 1 Mounting Finish View Design File
65103 23834 0 1 S N Y N 0 M A 30 not_option {} 7 0 11 0 0 (NEW) Chain & Canopy Finish - with Painted & Natural Copper o 0 0 1 Chain & Canopy Finish View Design File
65965 22631 0 1 S N Y N 0 M A 30 not_option 5 0 0 0 0 (NEW) Ceiling Canopy Finish - PC & Limited PTMP - NO SAS o 0 0 1 Ceiling Canopy Finish
65102 23836 0 1 S N Y N 0 M A 55 not_option 8 0 0 0 0 (NEW) Socket Type - with E26/3 (Sinclair) o 0 0 1 Socket Type
65103 23836 0 1 S N Y N 0 M A 55 not_option 8 0 0 0 0 (NEW) Socket Type - with E26/3 (Sinclair) o 0 0 1 Socket Type
65454 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
65873 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
65965 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
65102 22757 0 1 S N Y N 0 M A 65 not_option {"1":{"type":"ANY","items":[["22756","225840"],["23772","239873"],["23772","240409"],["23772","240412"],["23772","240411"],["23836","240296"]]}} 9 0 11 0 0 (NEW) Socket Cover Finish - E26/3/5 o 0 0 1 Socket Cover Finish View Design File
65103 22757 0 1 S N Y N 0 M A 65 not_option {"1":{"type":"ANY","items":[["22756","225840"],["23772","239873"],["23772","240409"],["23772","240412"],["23772","240411"],["23836","240296"]]}} 9 0 11 0 0 (NEW) Socket Cover Finish - E26/3/5 o 0 0 1 Socket Cover Finish View Design File