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 (
    220238, 
    219398, 
    219399, 
    220272, 
    217308, 
    217309, 
    217310, 
    217311, 
    217312, 
    217313, 
    237062, 
    237063, 
    217314, 
    242263, 
    241171, 
    217315, 
    217316, 
    217317, 
    217318, 
    217319, 
    241172, 
    217320, 
    217321, 
    217322, 
    217323, 
    217324, 
    217325, 
    217326, 
    217327, 
    241173, 
    217328, 
    241174, 
    217329, 
    217330, 
    242264, 
    242265, 
    217331, 
    217332, 
    217333, 
    242266, 
    241175, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    224224, 
    224225, 
    224226, 
    231944, 
    231941, 
    231943, 
    236498, 
    236468, 
    236469, 
    236470, 
    236471, 
    236493, 
    236486, 
    239867, 
    239868, 
    236472, 
    241640, 
    236473, 
    236474, 
    236475, 
    236476, 
    236477, 
    241641, 
    236478, 
    236479, 
    236480, 
    236481, 
    236482, 
    236483, 
    236484, 
    236485, 
    241642, 
    236487, 
    241643, 
    236488, 
    236489, 
    236490, 
    236491, 
    236492, 
    241644, 
    242852, 
    242853, 
    242854, 
    242855, 
    236530, 
    236499, 
    236500, 
    236501, 
    236502, 
    236503, 
    236504, 
    236505, 
    236506, 
    239869, 
    239870, 
    236507, 
    241645, 
    236508, 
    236509, 
    236510, 
    236511, 
    236512, 
    241646, 
    236513, 
    236514, 
    236515, 
    236516, 
    236517, 
    236518, 
    236519, 
    236520, 
    241647, 
    236521, 
    241648, 
    236522, 
    236523, 
    236524, 
    236525, 
    241649, 
    242856, 
    242857, 
    242858, 
    242859
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00250

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": 132,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220238,219398,219399,220272,217308,217309,217310,217311,217312,217313,237062,237063,217314,242263,241171,217315,217316,217317,217318,217319,241172,217320,217321,217322,217323,217324,217325,217326,217327,241173,217328,241174,217329,217330,242264,242265,217331,217332,217333,242266,241175,223755,223756,223757,223758,223759,223760,223761,223762,224224,224225,224226,231944,231941,231943,236498,236468,236469,236470,236471,236493,236486,239867,239868,236472,241640,236473,236474,236475,236476,236477,241641,236478,236479,236480,236481,236482,236483,236484,236485,241642,236487,241643,236488,236489,236490,236491,236492,241644,242852,242853,242854,242855,236530,236499,236500,236501,236502,236503,236504,236505,236506,239869,239870,236507,241645,236508,236509,236510,236511,236512,241646,236513,236514,236515,236516,236517,236518,236519,236520,241647,236521,241648,236522,236523,236524,236525,241649,242856,242857,242858,242859)"
        }
      }
    },
    "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