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.image_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 (
    220318, 
    215376, 
    215377, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    223480, 
    223476, 
    223477, 
    224688, 
    224657, 
    224658, 
    224659, 
    224660, 
    224661, 
    224662, 
    224682, 
    224663, 
    237052, 
    237053, 
    224664, 
    224665, 
    224666, 
    224667, 
    224668, 
    224669, 
    224670, 
    224671, 
    224672, 
    224673, 
    224674, 
    224675, 
    224676, 
    224677, 
    224678, 
    224679, 
    224680, 
    224681, 
    224689, 
    224690, 
    224691, 
    224692, 
    224686, 
    224687, 
    224768, 
    224764, 
    224767, 
    224765, 
    224766, 
    224773, 
    224769, 
    224772, 
    224770, 
    224771, 
    231994, 
    231959, 
    231960, 
    231961, 
    231962, 
    231963, 
    231964, 
    237094, 
    237095, 
    231965, 
    231966, 
    231967, 
    231968, 
    231969, 
    231970, 
    231971, 
    231972, 
    231973, 
    231974, 
    231975, 
    231976, 
    231977, 
    231978, 
    231979, 
    231980, 
    231981, 
    231982, 
    231983, 
    231984, 
    231985, 
    231986, 
    231987, 
    231988, 
    231989, 
    231990, 
    231991, 
    231992, 
    231993, 
    233199, 
    233170, 
    233171, 
    233172, 
    233173, 
    233193, 
    233174, 
    233175, 
    233176, 
    233177, 
    233178, 
    233179, 
    233180, 
    233181, 
    233182, 
    233183, 
    233184, 
    233185, 
    233186, 
    233187, 
    233188, 
    233189, 
    233190, 
    233191, 
    233192, 
    233194, 
    233195, 
    233196, 
    233197, 
    233198, 
    233200, 
    233201, 
    233202, 
    233538, 
    233203, 
    233204
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00347

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": 141,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220318,215376,215377,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,223480,223476,223477,224688,224657,224658,224659,224660,224661,224662,224682,224663,237052,237053,224664,224665,224666,224667,224668,224669,224670,224671,224672,224673,224674,224675,224676,224677,224678,224679,224680,224681,224689,224690,224691,224692,224686,224687,224768,224764,224767,224765,224766,224773,224769,224772,224770,224771,231994,231959,231960,231961,231962,231963,231964,237094,237095,231965,231966,231967,231968,231969,231970,231971,231972,231973,231974,231975,231976,231977,231978,231979,231980,231981,231982,231983,231984,231985,231986,231987,231988,231989,231990,231991,231992,231993,233199,233170,233171,233172,233173,233193,233174,233175,233176,233177,233178,233179,233180,233181,233182,233183,233184,233185,233186,233187,233188,233189,233190,233191,233192,233194,233195,233196,233197,233198,233200,233201,233202,233538,233203,233204)"
        }
      }
    },
    "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.image_id"],
      "rows": 1,
      "filtered": 100,
      "attached_condition": "trigcond(cscart_images_links.image_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