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 (
    222969, 
    222959, 
    222960, 
    222961, 
    222970, 
    222971, 
    222972, 
    222973, 
    222974, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    230828, 
    230827, 
    236566, 
    236531, 
    236532, 
    236533, 
    236534, 
    236535, 
    240476, 
    240477, 
    236536, 
    236537, 
    242827, 
    241610, 
    236538, 
    236539, 
    236540, 
    236541, 
    236542, 
    241611, 
    236543, 
    236544, 
    236545, 
    236546, 
    236547, 
    236548, 
    236549, 
    236550, 
    241612, 
    236551, 
    241613, 
    236552, 
    236553, 
    242828, 
    242829, 
    236554, 
    236555, 
    236556, 
    242830, 
    241614, 
    236561, 
    236562, 
    236563, 
    236564, 
    236565, 
    236598, 
    236567, 
    236568, 
    236569, 
    236570, 
    236571, 
    236572, 
    236592, 
    236573, 
    240478, 
    240479, 
    236574, 
    242831, 
    241615, 
    236575, 
    236576, 
    236577, 
    236578, 
    236579, 
    241616, 
    236580, 
    236581, 
    236582, 
    236583, 
    236584, 
    236585, 
    236586, 
    236587, 
    241617, 
    236588, 
    241618, 
    236589, 
    236590, 
    242832, 
    242833, 
    236603, 
    236604, 
    236591, 
    242834, 
    241619, 
    236635, 
    236605, 
    236606, 
    236607, 
    236608, 
    236609, 
    236629, 
    236610, 
    240480, 
    240481, 
    236611, 
    242835, 
    241620, 
    236612, 
    236613, 
    236614, 
    236615, 
    236616, 
    241621, 
    236617, 
    236618, 
    236619, 
    236620, 
    236621, 
    236622, 
    236623, 
    236624, 
    241622, 
    236625, 
    241623, 
    236626, 
    236627, 
    242836, 
    242837, 
    236640, 
    236641, 
    236628, 
    242838, 
    241624
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00184

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": 138,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (222969,222959,222960,222961,222970,222971,222972,222973,222974,223755,223756,223757,223758,223759,230828,230827,236566,236531,236532,236533,236534,236535,240476,240477,236536,236537,242827,241610,236538,236539,236540,236541,236542,241611,236543,236544,236545,236546,236547,236548,236549,236550,241612,236551,241613,236552,236553,242828,242829,236554,236555,236556,242830,241614,236561,236562,236563,236564,236565,236598,236567,236568,236569,236570,236571,236572,236592,236573,240478,240479,236574,242831,241615,236575,236576,236577,236578,236579,241616,236580,236581,236582,236583,236584,236585,236586,236587,241617,236588,241618,236589,236590,242832,242833,236603,236604,236591,242834,241619,236635,236605,236606,236607,236608,236609,236629,236610,240480,240481,236611,242835,241620,236612,236613,236614,236615,236616,241621,236617,236618,236619,236620,236621,236622,236623,236624,241622,236625,241623,236626,236627,242836,242837,236640,236641,236628,242838,241624)"
        }
      }
    },
    "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