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, 
    224224, 
    224225, 
    224226, 
    226326, 
    226327, 
    226328, 
    226329, 
    226330, 
    226434, 
    226438, 
    226435, 
    226436, 
    226437, 
    226439, 
    226443, 
    226440, 
    226441, 
    226442, 
    226444, 
    226448, 
    226445, 
    226446, 
    226447, 
    226449, 
    226453, 
    226450, 
    226451, 
    226452, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    226612, 
    226577, 
    226578, 
    226579, 
    226580, 
    226581, 
    226582, 
    237138, 
    237139, 
    226583, 
    241310, 
    226584, 
    226585, 
    226586, 
    226587, 
    226588, 
    241311, 
    226589, 
    226590, 
    226591, 
    226592, 
    226593, 
    226594, 
    226595, 
    226596, 
    241312, 
    226597, 
    241313, 
    226598, 
    226599, 
    226600, 
    226601, 
    226602, 
    241314, 
    242521, 
    242522, 
    242523, 
    242524, 
    226607, 
    226608, 
    226609, 
    226610, 
    226611, 
    231695, 
    231693, 
    231694, 
    231698, 
    231696, 
    231697, 
    240507, 
    240506, 
    240508, 
    240509, 
    240605, 
    240583, 
    240584, 
    240585, 
    240586, 
    240587, 
    240595, 
    240604, 
    240588, 
    240589, 
    240590, 
    240591, 
    240592, 
    240593, 
    240594, 
    243079, 
    243080, 
    243081, 
    243082, 
    240628, 
    240606, 
    240607, 
    240608, 
    240609, 
    240610, 
    240618, 
    240627, 
    240611, 
    240612, 
    240613, 
    240614, 
    240615, 
    240616, 
    240617, 
    243083, 
    243084, 
    243085, 
    243086, 
    240651, 
    240629, 
    240630, 
    240631, 
    240632, 
    240633, 
    240641, 
    240650, 
    240634, 
    240635, 
    240636, 
    240637, 
    240638, 
    240639, 
    240640, 
    243087, 
    243088, 
    243089, 
    243090
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00243

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 (223755,223756,223757,223758,223759,224224,224225,224226,226326,226327,226328,226329,226330,226434,226438,226435,226436,226437,226439,226443,226440,226441,226442,226444,226448,226445,226446,226447,226449,226453,226450,226451,226452,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226612,226577,226578,226579,226580,226581,226582,237138,237139,226583,241310,226584,226585,226586,226587,226588,241311,226589,226590,226591,226592,226593,226594,226595,226596,241312,226597,241313,226598,226599,226600,226601,226602,241314,242521,242522,242523,242524,226607,226608,226609,226610,226611,231695,231693,231694,231698,231696,231697,240507,240506,240508,240509,240605,240583,240584,240585,240586,240587,240595,240604,240588,240589,240590,240591,240592,240593,240594,243079,243080,243081,243082,240628,240606,240607,240608,240609,240610,240618,240627,240611,240612,240613,240614,240615,240616,240617,243083,243084,243085,243086,240651,240629,240630,240631,240632,240633,240641,240650,240634,240635,240636,240637,240638,240639,240640,243087,243088,243089,243090)"
        }
      }
    },
    "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