SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id as images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id 
  LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id 
  AND cscart_common_descriptions.object_holder = 'images' 
  AND cscart_common_descriptions.lang_code = 'en' 
WHERE 
  cscart_images_links.object_type = 'variant_image' 
  AND cscart_images_links.type = 'V' 
  AND cscart_images_links.object_id IN (
    149578, 
    149579, 
    218476, 
    215713, 
    215714, 
    215715, 
    215716, 
    215738, 
    215731, 
    237036, 
    237037, 
    215717, 
    242135, 
    241141, 
    215718, 
    215719, 
    215720, 
    215721, 
    215722, 
    241142, 
    215723, 
    215724, 
    215725, 
    215726, 
    215727, 
    215728, 
    215729, 
    215730, 
    241143, 
    215732, 
    241144, 
    215733, 
    215734, 
    215735, 
    242136, 
    242137, 
    215736, 
    215737, 
    242138, 
    241145, 
    220227, 
    215745, 
    215746, 
    233605, 
    215747, 
    215748, 
    215749, 
    215750, 
    215751, 
    237140, 
    237141, 
    215752, 
    215753, 
    215754, 
    215755, 
    215756, 
    215757, 
    215758, 
    215759, 
    215760, 
    215761, 
    215762, 
    215763, 
    215764, 
    215765, 
    215766, 
    215767, 
    215768, 
    215769, 
    215770, 
    215771, 
    215772, 
    215773, 
    215774, 
    215775, 
    227176, 
    227163, 
    227164, 
    227165, 
    227166, 
    227167, 
    227168, 
    227169, 
    227170, 
    227171, 
    227172, 
    227173, 
    227174, 
    228891, 
    228869, 
    228870, 
    228871, 
    228872, 
    228873, 
    228881, 
    228890, 
    228874, 
    228875, 
    228876, 
    228877, 
    228878, 
    228879, 
    228880, 
    228882, 
    228883, 
    228884, 
    228885, 
    233603, 
    245599, 
    245600, 
    245601, 
    245602, 
    245603, 
    245604, 
    245605, 
    245606, 
    233578, 
    233579, 
    233580, 
    233581, 
    233582, 
    239720, 
    233583, 
    237218, 
    237219, 
    233584, 
    233570, 
    246126, 
    233585, 
    233586, 
    233587, 
    233588, 
    233589, 
    246127, 
    233590, 
    233591, 
    233592, 
    233593, 
    233594, 
    233595, 
    233596, 
    233597, 
    246128, 
    233598, 
    246129, 
    233599, 
    233600, 
    233574, 
    233575, 
    233604, 
    233601, 
    233602, 
    233576, 
    246130, 
    233987, 
    233988, 
    233989, 
    233990, 
    233991, 
    238809, 
    238810, 
    197117, 
    197118, 
    15765, 
    15766
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00212

JSON explain

{
  "query_block": {
    "select_id": 1,
    "read_sorted_file": {
      "filesort": {
        "sort_key": "cscart_images_links.position, cscart_images_links.pair_id",
        "table": {
          "table_name": "cscart_images_links",
          "access_type": "range",
          "possible_keys": ["object_id"],
          "key": "object_id",
          "key_length": "81",
          "used_key_parts": ["object_id", "object_type", "type"],
          "rows": 165,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (149578,149579,218476,215713,215714,215715,215716,215738,215731,237036,237037,215717,242135,241141,215718,215719,215720,215721,215722,241142,215723,215724,215725,215726,215727,215728,215729,215730,241143,215732,241144,215733,215734,215735,242136,242137,215736,215737,242138,241145,220227,215745,215746,233605,215747,215748,215749,215750,215751,237140,237141,215752,215753,215754,215755,215756,215757,215758,215759,215760,215761,215762,215763,215764,215765,215766,215767,215768,215769,215770,215771,215772,215773,215774,215775,227176,227163,227164,227165,227166,227167,227168,227169,227170,227171,227172,227173,227174,228891,228869,228870,228871,228872,228873,228881,228890,228874,228875,228876,228877,228878,228879,228880,228882,228883,228884,228885,233603,245599,245600,245601,245602,245603,245604,245605,245606,233578,233579,233580,233581,233582,239720,233583,237218,237219,233584,233570,246126,233585,233586,233587,233588,233589,246127,233590,233591,233592,233593,233594,233595,233596,233597,246128,233598,246129,233599,233600,233574,233575,233604,233601,233602,233576,246130,233987,233988,233989,233990,233991,238809,238810,197117,197118,15765,15766)"
        }
      }
    },
    "table": {
      "table_name": "cscart_images",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "3",
      "used_key_parts": ["image_id"],
      "ref": ["cscart_migrate.cscart_images_links.detailed_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.detailed_id = cscart_images.image_id)"
    },
    "table": {
      "table_name": "cscart_common_descriptions",
      "access_type": "eq_ref",
      "possible_keys": ["PRIMARY"],
      "key": "PRIMARY",
      "key_length": "107",
      "used_key_parts": ["object_id", "lang_code", "object_holder"],
      "ref": ["cscart_migrate.cscart_images.image_id", "const", "const"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_common_descriptions.object_id = cscart_images.image_id and cscart_common_descriptions.object_holder = 'images' and cscart_common_descriptions.lang_code = 'en' and trigcond(cscart_images.image_id is not null))"
    }
  }
}

Result