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 (
    61937, 62229, 64353, 64350, 62246, 64355, 
    62843, 63513, 63467, 63510, 63852, 
    62979, 63853, 63515, 63810, 63854, 
    63806, 64946, 64865, 64863, 64947
  ) 
  AND a.product_id = 0 
  AND status = 'A' 
ORDER BY 
  a.position

Query time 0.00217

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": 92,
          "filtered": 100,
          "attached_condition": "c.product_id in (61937,62229,64353,64350,62246,64355,62843,63513,63467,63510,63852,62979,63853,63515,63810,63854,63806,64946,64865,64863,64947)",
          "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
62843 23073 0 1 S N Y N 0 M A 2 not_option 2 0 0 0 0 (NEW) Light Option - SCP04 o 0 1 2 Light Option
63510 22688 0 1 S N Y N 0 M A 9 not_option {} 2 0 0 0 0 (NEW) Mounting Finish - Downtown Double o 0 0 2 Mounting Finish View Design File
61937 22679 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Cup Finish - Downtown o 0 0 2 Cup Finish View Design File
62229 22685 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 19544 (NEW) Cup & Mounting Finish - Downtown Sconce o 0 0 2 Finish View Design File
62246 22685 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 19544 (NEW) Cup & Mounting Finish - Downtown Sconce o 0 0 2 Finish View Design File
62979 22679 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Cup Finish - Downtown o 0 0 2 Cup Finish View Design File
63467 22683 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Cup & Mounting Finish - Downtown Stem o 0 0 2 Finish View Design File
63510 22679 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Cup Finish - Downtown o 0 0 2 Cup Finish View Design File
63513 22685 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 19544 (NEW) Cup & Mounting Finish - Downtown Sconce o 0 0 2 Finish View Design File
63515 22685 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 19544 (NEW) Cup & Mounting Finish - Downtown Sconce o 0 0 2 Finish View Design File
63806 23221 0 1 S N Y N 0 M A 10 not_option 2 0 0 0 17951 (NEW) Finishes - PC + PTMP + BRS o 0 0 1 Finishes View Design File
63810 23221 0 1 S N Y N 0 M A 10 not_option 2 0 0 0 17951 (NEW) Finishes - PC + PTMP + BRS o 0 0 1 Finishes View Design File
63852 22732 0 1 S N Y N 0 M A 10 not_option {} 3 0 0 0 0 (NEW) Cup & Canopy Finish - PC & Limited PTMP o 0 0 2 Cup & Canopy Finish View Design File
63853 22732 0 1 S N Y N 0 M A 10 not_option {} 3 0 0 0 0 (NEW) Cup & Canopy Finish - PC & Limited PTMP o 0 0 2 Cup & Canopy Finish View Design File
63854 22732 0 1 S N Y N 0 M A 10 not_option {} 3 0 0 0 0 (NEW) Cup & Canopy Finish - PC & Limited PTMP o 0 0 2 Cup & Canopy Finish View Design File
64350 22683 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 0 (NEW) Cup & Mounting Finish - Downtown Stem o 0 0 2 Finish View Design File
64353 22685 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 19544 (NEW) Cup & Mounting Finish - Downtown Sconce o 0 0 2 Finish View Design File
64355 22685 0 1 S N Y N 0 M A 10 not_option {} 2 0 0 0 19544 (NEW) Cup & Mounting Finish - Downtown Sconce o 0 0 2 Finish View Design File
64863 22834 0 1 S N Y N 0 M A 10 not_option 2 0 11 5 0 (NEW) Wood Option - Timber + Ore PINDY o 0 0 1 Wood Option
64865 22834 0 1 S N Y N 0 M A 10 not_option 2 0 11 5 0 (NEW) Wood Option - Timber + Ore PINDY o 0 0 1 Wood Option
64865 22838 0 1 S N Y N 0 M A 10 not_option {} 3 0 0 0 0 (NEW) Mounting Finish - Timber + Ore WPINDY o 0 0 2 Mounting Finish View Design File
64946 22834 0 1 S N Y N 0 M A 10 not_option 2 0 11 5 0 (NEW) Wood Option - Timber + Ore PINDY o 0 0 1 Wood Option
64946 22838 0 1 S N Y N 0 M A 10 not_option {} 3 0 0 0 0 (NEW) Mounting Finish - Timber + Ore WPINDY o 0 0 2 Mounting Finish View Design File
64947 22834 0 1 S N Y N 0 M A 10 not_option 2 0 11 5 0 (NEW) Wood Option - Timber + Ore PINDY o 0 0 1 Wood Option
61937 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
62843 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
62979 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
63852 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
63853 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
63854 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
64863 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
64947 23857 0 1 S N Y N 0 M A 14 not_option 5 0 0 0 0 (NEW) Cord Length i 0 1 1 Cord Length
61937 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
61937 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
61937 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
62843 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
62843 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
62843 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
62979 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
62979 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
62979 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
63467 22684 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Mounting Option - Downtown Stem i 0 1 1 Mounting Option
63806 22310 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Mounting Option - Parabolic i 0 1 1 Mounting Option
63810 22310 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Mounting Option - Parabolic i 0 1 1 Mounting Option
63852 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
63852 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
63852 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
63853 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
63853 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
63853 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
63854 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
63854 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
63854 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
64350 22684 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Mounting Option - Downtown Stem i 0 1 1 Mounting Option
64353 22690 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Mounting Option - Downtown Swing Arm o 0 0 1 Mounting Option
64355 22690 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Mounting Option - Downtown Swing Arm o 0 0 1 Mounting Option
64863 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
64863 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
64863 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
64946 22690 0 1 S N Y N 0 M A 15 not_option 3 0 0 0 0 (NEW) Mounting Option - Downtown Swing Arm o 0 0 1 Mounting Option
64947 23858 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240506"]]}} 3 0 8 0 0 (NEW) Cords - 7ft o 0 0 1 Cords View Cord Design File
64947 23859 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240508"]]}} 3 0 8 0 0 (NEW) Cords - 12ft o 0 0 1 Cords View Cord Design File
64947 23860 0 1 S N Y N 0 M A 15 not_option {"1":{"type":"ANY","items":[["23857","240509"]]}} 3 0 8 0 0 (NEW) Cords - 20ft o 0 0 1 Cords View Cord Design File
62246 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
63515 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
64355 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
62979 22687 0 1 S N Y N 0 M A 20 not_option 4 0 0 0 0 (NEW) Ceiling Canopy Finish - KAO o 0 0 1 Ceiling Canopy Finish
64947 23320 0 1 S N Y N 0 M A 20 not_option 5 0 0 0 0 (NEW) Ceiling Canopy Finish - PC & Limited PTMP - No SAS o 0 0 1 Ceiling Canopy Finish
61937 22681 0 1 S N Y N 0 M A 30 not_option {} 4 0 0 0 0 (NEW) Ceiling Canopy Finish - Downtown o 0 0 2 Ceiling Canopy Finish View Design File
64863 22835 0 1 S N Y N 0 M A 30 not_option 5 0 0 0 0 (NEW) Ceiling Canopy Finish - Timber + Ore o 0 0 1 Ceiling Canopy Finish
61937 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
62229 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
62246 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
62843 22634 0 1 S N Y N 0 M A 60 not_option {"1":{"type":"ANY","items":[["23062","230443"]]}} 0 0 11 -5 0 (NEW) Green Creative Bulbs x 3 Chandeliers o 0 0 1 Bulbs
62843 22635 0 1 S N Y N 0 M A 60 not_option {"1":{"type":"ANY","items":[["23062","230444"]]}} 0 0 11 -5 0 (NEW) Green Creative Bulbs x 5 Chandeliers o 0 0 1 Bulbs
62979 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
63467 22691 0 1 S N Y N 0 M A 60 not_option {} 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x3 o 0 0 1 Bulbs
63510 22689 0 1 S N Y N 0 M A 60 not_option 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x2 o 0 0 1 Bulbs
63513 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
63515 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
63806 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
63810 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
63852 22691 0 1 S N Y N 0 M A 60 not_option {} 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x3 o 0 0 1 Bulbs
63853 22730 0 1 S N Y N 0 M A 60 not_option 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x4 o 0 0 1 Bulbs
63854 22731 0 1 S N Y N 0 M A 60 not_option {} 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x5 o 0 0 1 Bulbs
64350 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
64353 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
64355 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
64863 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
64865 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
64946 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
64947 22691 0 1 S N Y N 0 M A 60 not_option {} 0 0 11 -5 0 (NEW) Bulbs - Green Creative + Tala x3 o 0 0 1 Bulbs