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 (
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    230828, 
    230827, 
    232268, 
    232269, 
    232270, 
    232300, 
    232275, 
    232277, 
    232279, 
    232392, 
    232389, 
    232390, 
    232391, 
    232597, 
    244670, 
    244671, 
    244672, 
    244673, 
    244674, 
    244675, 
    244676, 
    244677, 
    232567, 
    232568, 
    232569, 
    232570, 
    232571, 
    232572, 
    237018, 
    237019, 
    232573, 
    245232, 
    241271, 
    232574, 
    232575, 
    232576, 
    232577, 
    232578, 
    241272, 
    232579, 
    232580, 
    232581, 
    232582, 
    232583, 
    232584, 
    232585, 
    232586, 
    241273, 
    232587, 
    241274, 
    232588, 
    232589, 
    245233, 
    245234, 
    232598, 
    232590, 
    232591, 
    245235, 
    232592, 
    241275, 
    232593, 
    232594, 
    232595, 
    232596, 
    232621, 
    232613, 
    232614, 
    232615, 
    232632, 
    232624, 
    232625, 
    232626, 
    232643, 
    232635, 
    232636, 
    232637, 
    232712, 
    232686, 
    232687, 
    232688, 
    232689, 
    232690, 
    232691, 
    241286, 
    241287, 
    232692, 
    245236, 
    241276, 
    232693, 
    232694, 
    232695, 
    232696, 
    232697, 
    241277, 
    232698, 
    232699, 
    232700, 
    232701, 
    232702, 
    232703, 
    232704, 
    232705, 
    241278, 
    232706, 
    241279, 
    232707, 
    232708, 
    245237, 
    245238, 
    232709, 
    232710, 
    232711, 
    245239, 
    241280, 
    232725, 
    244678, 
    244679, 
    244680, 
    244681, 
    244682, 
    244683, 
    244684, 
    244685, 
    232965, 
    232966, 
    232967, 
    232975, 
    232969, 
    232970, 
    234810, 
    234807, 
    234808, 
    234809
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00198

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 (223755,223756,223757,223758,223759,230828,230827,232268,232269,232270,232300,232275,232277,232279,232392,232389,232390,232391,232597,244670,244671,244672,244673,244674,244675,244676,244677,232567,232568,232569,232570,232571,232572,237018,237019,232573,245232,241271,232574,232575,232576,232577,232578,241272,232579,232580,232581,232582,232583,232584,232585,232586,241273,232587,241274,232588,232589,245233,245234,232598,232590,232591,245235,232592,241275,232593,232594,232595,232596,232621,232613,232614,232615,232632,232624,232625,232626,232643,232635,232636,232637,232712,232686,232687,232688,232689,232690,232691,241286,241287,232692,245236,241276,232693,232694,232695,232696,232697,241277,232698,232699,232700,232701,232702,232703,232704,232705,241278,232706,241279,232707,232708,245237,245238,232709,232710,232711,245239,241280,232725,244678,244679,244680,244681,244682,244683,244684,244685,232965,232966,232967,232975,232969,232970,234810,234807,234808,234809)"
        }
      }
    },
    "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