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 (
    220130, 
    215658, 
    215659, 
    238245, 
    220143, 
    244558, 
    244559, 
    244560, 
    244561, 
    244562, 
    244563, 
    244564, 
    244565, 
    216947, 
    216948, 
    216949, 
    216950, 
    216951, 
    216952, 
    236882, 
    236883, 
    216953, 
    245122, 
    241590, 
    216954, 
    216955, 
    216956, 
    216957, 
    216958, 
    241591, 
    216959, 
    216960, 
    216961, 
    216962, 
    216963, 
    216964, 
    216965, 
    216966, 
    241592, 
    216967, 
    241593, 
    216968, 
    216969, 
    245123, 
    245124, 
    225920, 
    216970, 
    216971, 
    245125, 
    241594, 
    220231, 
    217630, 
    217631, 
    217632, 
    220265, 
    217019, 
    217020, 
    217021, 
    217022, 
    217023, 
    217024, 
    236888, 
    236889, 
    217025, 
    245126, 
    241595, 
    217026, 
    217027, 
    217028, 
    217029, 
    217030, 
    241596, 
    217031, 
    217032, 
    217033, 
    217034, 
    217035, 
    217036, 
    217037, 
    217038, 
    241597, 
    217039, 
    241598, 
    217040, 
    217041, 
    245127, 
    245128, 
    217042, 
    217043, 
    217044, 
    245129, 
    241599, 
    220266, 
    244566, 
    244567, 
    244568, 
    244569, 
    244570, 
    244571, 
    244572, 
    244573, 
    220269, 
    217095, 
    217096, 
    217097, 
    217098, 
    217099, 
    217100, 
    236886, 
    236887, 
    217101, 
    241605, 
    217102, 
    217103, 
    217104, 
    217105, 
    217106, 
    241606, 
    217107, 
    217108, 
    217109, 
    217110, 
    217111, 
    217112, 
    217113, 
    217114, 
    241607, 
    217115, 
    241608, 
    217116, 
    217117, 
    225921, 
    217118, 
    217119, 
    241609, 
    220270, 
    244582, 
    244583, 
    244584, 
    244585, 
    244586, 
    244587, 
    244588, 
    244589, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    230951, 
    230952, 
    230953, 
    230954, 
    238250, 
    238248, 
    238249
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00208

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": 159,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220130,215658,215659,238245,220143,244558,244559,244560,244561,244562,244563,244564,244565,216947,216948,216949,216950,216951,216952,236882,236883,216953,245122,241590,216954,216955,216956,216957,216958,241591,216959,216960,216961,216962,216963,216964,216965,216966,241592,216967,241593,216968,216969,245123,245124,225920,216970,216971,245125,241594,220231,217630,217631,217632,220265,217019,217020,217021,217022,217023,217024,236888,236889,217025,245126,241595,217026,217027,217028,217029,217030,241596,217031,217032,217033,217034,217035,217036,217037,217038,241597,217039,241598,217040,217041,245127,245128,217042,217043,217044,245129,241599,220266,244566,244567,244568,244569,244570,244571,244572,244573,220269,217095,217096,217097,217098,217099,217100,236886,236887,217101,241605,217102,217103,217104,217105,217106,241606,217107,217108,217109,217110,217111,217112,217113,217114,241607,217115,241608,217116,217117,225921,217118,217119,241609,220270,244582,244583,244584,244585,244586,244587,244588,244589,223755,223756,223757,223758,223759,223760,223761,223762,230951,230952,230953,230954,238250,238248,238249)"
        }
      }
    },
    "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