SELECT 
  a.*, 
  b.option_name, 
  b.internal_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' 
WHERE 
  a.product_id IN (
    95513, 95514, 95515, 95516, 95517, 95518, 
    95519, 95520, 95521, 95522, 95523, 
    95524, 95525, 95526, 95527, 95528, 
    95529, 95530, 95531, 95532, 95533, 
    95534, 95535, 95536, 95537, 95538, 
    95539, 95540, 95541, 95542, 95543, 
    95544, 95545, 95546, 95547, 95548, 
    95549, 95550, 95551, 95552, 95553, 
    95554, 96177, 96178, 96179, 96180, 
    96181, 96182, 96183, 96184, 96185, 
    96186, 96187, 96188, 96190, 96191, 
    96192, 96781, 96782, 96783, 96784, 
    96785, 96786, 96787, 96792, 96793, 
    96794, 96795, 96796, 96797, 96798, 
    96799, 96800, 96801, 96802, 96803, 
    96804, 96805, 96806, 96807, 96808, 
    96809, 96810, 96811, 96812, 96813, 
    96814, 96815, 96816, 96817, 96818, 
    96819, 96820, 96821, 96822, 96823
  ) 
  AND a.status = 'A' 
ORDER BY 
  a.position

Query time 0.00074

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "1.70"
    },
    "ordering_operation": {
      "using_filesort": true,
      "cost_info": {
        "sort_cost": "1.00"
      },
      "nested_loop": [
        {
          "table": {
            "table_name": "a",
            "access_type": "ALL",
            "possible_keys": [
              "c_status"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.25",
              "eval_cost": "0.10",
              "prefix_cost": "0.35",
              "data_read_per_join": "2K"
            },
            "used_columns": [
              "option_id",
              "product_id",
              "company_id",
              "option_type",
              "regexp",
              "required",
              "multiupload",
              "allowed_extensions",
              "max_file_size",
              "missing_variants_handling",
              "status",
              "position",
              "value"
            ],
            "attached_condition": "((`nuie_scalesta_net`.`a`.`product_id` in (95513,95514,95515,95516,95517,95518,95519,95520,95521,95522,95523,95524,95525,95526,95527,95528,95529,95530,95531,95532,95533,95534,95535,95536,95537,95538,95539,95540,95541,95542,95543,95544,95545,95546,95547,95548,95549,95550,95551,95552,95553,95554,96177,96178,96179,96180,96181,96182,96183,96184,96185,96186,96187,96188,96190,96191,96192,96781,96782,96783,96784,96785,96786,96787,96792,96793,96794,96795,96796,96797,96798,96799,96800,96801,96802,96803,96804,96805,96806,96807,96808,96809,96810,96811,96812,96813,96814,96815,96816,96817,96818,96819,96820,96821,96822,96823)) and (`nuie_scalesta_net`.`a`.`status` = 'A'))"
          }
        },
        {
          "table": {
            "table_name": "b",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "option_id",
              "lang_code"
            ],
            "key_length": "9",
            "ref": [
              "nuie_scalesta_net.a.option_id",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.25",
              "eval_cost": "0.10",
              "prefix_cost": "0.70",
              "data_read_per_join": "3K"
            },
            "used_columns": [
              "option_id",
              "lang_code",
              "option_name",
              "internal_option_name",
              "option_text",
              "description",
              "comment",
              "inner_hint",
              "incorrect_message"
            ]
          }
        }
      ]
    }
  }
}