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 (
    62186, 62187, 62188, 62185, 63811, 62189, 
    63815, 63813, 63812, 63814, 64853, 
    65616
  ) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00159

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": 59,
          "filtered": 100,
          "attached_condition": "c.product_id in (62186,62187,62188,62185,63811,62189,63815,63813,63812,63814,64853,65616)",
          "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
62185 22566 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - SBA Lamp o 0 1 1 Shade Size
62186 22565 0 1 S N Y N 0 M A 2 not_option 2 0 14 0 0 (NEW) Shade Size - WHD Lamp i 0 1 1 Shade Size
62187 22567 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - WHS Lamp i 0 1 1 Shade Size
62188 22568 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - AUS Lamp o 0 1 1 Shade Size
62189 22569 0 1 S N Y N 0 M A 2 not_option 2 0 14 1 0 (NEW) Shade Size - YDM Lamp o 0 1 1 Shade Size
62185 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
62186 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
62187 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
62188 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
62189 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
63811 22573 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Shade/Base Finish - Floor Lamps o 0 0 2 Shade/Base Finish View Design File
63812 22573 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Shade/Base Finish - Floor Lamps o 0 0 2 Shade/Base Finish View Design File
63813 22573 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Shade/Base Finish - Floor Lamps o 0 0 2 Shade/Base Finish View Design File
63814 22573 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Shade/Base Finish - Floor Lamps o 0 0 2 Shade/Base Finish View Design File
63815 22573 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Shade/Base Finish - Floor Lamps o 0 0 2 Shade/Base Finish View Design File
64853 22575 0 1 S N Y N 0 M A 10 not_option 2 0 0 5 0 (NEW) Shade/Base Finish - Lovell o 0 0 1 Shade/Base Finish View Design File
65616 23710 0 1 S N Y N 0 M A 10 not_option {} 1 0 11 5 19863 (NEW) Exterior Shade & Lamp Stem/Base Finish - Loma Lamp o 0 0 1 Exterior Shade & Lamp Stem/Base Finish View Design File
65616 23711 0 1 S N Y N 0 M A 11 not_option {"1":{"type":"ANY","items":[["23710","239178"],["23710","239194"],["23710","239202"],["23710","239201"],["23710","239200"],["23710","239199"],["23710","239198"],["23710","239183"],["23710","239197"],["23710","239196"],["23710","239195"],["23710","239193"],["23710","239179"],["23710","239192"],["23710","239191"],["23710","239190"],["23710","239189"],["23710","239188"],["23710","239187"],["23710","239186"],["23710","239185"],["23710","239184"],["23710","239181"],["23710","239206"],["23710","239180"],["23710","239205"],["23710","241738"],["23710","241739"],["23710","242909"],["23710","242910"],["23710","242911"],["23710","241740"],["23710","241736"],["23710","242908"],["23710","241737"]]}} 3 0 11 5 19863 (NEW) Interior Finish - Loma Lamp o 0 0 1 Interior Finish View Design File
62185 22570 0 1 S N Y N 0 M A 14 not_option 4 0 0 0 0 (NEW) Lamp Stem Length - Desk i 0 1 1 Lamp Stem Length
62186 22570 0 1 S N Y N 0 M A 14 not_option 4 0 0 0 0 (NEW) Lamp Stem Length - Desk i 0 1 1 Lamp Stem Length
62187 22570 0 1 S N Y N 0 M A 14 not_option 4 0 0 0 0 (NEW) Lamp Stem Length - Desk i 0 1 1 Lamp Stem Length
62188 22570 0 1 S N Y N 0 M A 14 not_option 4 0 0 0 0 (NEW) Lamp Stem Length - Desk i 0 1 1 Lamp Stem Length
62189 22570 0 1 S N Y N 0 M A 14 not_option 4 0 0 0 0 (NEW) Lamp Stem Length - Desk i 0 1 1 Lamp Stem Length
65616 22570 0 1 S N Y N 0 M A 14 not_option 4 0 0 0 0 (NEW) Lamp Stem Length - Desk i 0 1 1 Lamp Stem Length
63811 22574 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Stem Finish - Floor Lamps o 0 0 1 Stem Finish
63812 22574 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Stem Finish - Floor Lamps o 0 0 1 Stem Finish
63813 22574 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Stem Finish - Floor Lamps o 0 0 1 Stem Finish
63814 22574 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Stem Finish - Floor Lamps o 0 0 1 Stem Finish
63815 22574 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Stem Finish - Floor Lamps o 0 0 1 Stem Finish
64853 22576 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Stem Finish - Lovell o 0 0 1 Stem Finish
62185 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
62186 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
62187 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
62188 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
62189 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
63811 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
63812 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
63813 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
63814 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
63815 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
64853 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
65616 22571 0 1 S N Y N 0 M A 17 not_option 5 0 8 0 0 (NEW) Cords - Lamps o 0 0 1 Cords View Design File
62185 23059 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug Finish - Table Lamps o 0 0 1 Plug Finish
62186 23059 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug Finish - Table Lamps o 0 0 1 Plug Finish
62187 23059 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug Finish - Table Lamps o 0 0 1 Plug Finish
62188 23059 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug Finish - Table Lamps o 0 0 1 Plug Finish
62189 23059 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug Finish - Table Lamps o 0 0 1 Plug Finish
63811 22572 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug & Switch Finish - Lamps o 0 0 1 Plug & Switch Finish
63812 22572 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug & Switch Finish - Lamps o 0 0 1 Plug & Switch Finish
63813 22572 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug & Switch Finish - Lamps o 0 0 1 Plug & Switch Finish
63814 22572 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug & Switch Finish - Lamps o 0 0 1 Plug & Switch Finish
63815 22572 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug & Switch Finish - Lamps o 0 0 1 Plug & Switch Finish
64853 22572 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug & Switch Finish - Lamps o 0 0 1 Plug & Switch Finish
65616 23059 0 1 S N Y N 0 M A 20 not_option 6 0 0 0 0 (NEW) Plug Finish - Table Lamps o 0 0 1 Plug Finish
63811 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
63812 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
63813 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
63814 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
63815 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