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, 
    226373, 
    226338, 
    226339, 
    226340, 
    226341, 
    226342, 
    226343, 
    237048, 
    237049, 
    226344, 
    241325, 
    226345, 
    226346, 
    226347, 
    226348, 
    226349, 
    241326, 
    226350, 
    226351, 
    226352, 
    226353, 
    226354, 
    226355, 
    226356, 
    226357, 
    241327, 
    226358, 
    241328, 
    226359, 
    226360, 
    226361, 
    226362, 
    226363, 
    241329, 
    242533, 
    242534, 
    242535, 
    242536, 
    226368, 
    226369, 
    226370, 
    226371, 
    226372, 
    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, 
    231662, 
    231633, 
    231634, 
    231635, 
    231636, 
    231656, 
    231637, 
    231638, 
    231639, 
    231640, 
    231641, 
    231642, 
    231643, 
    231644, 
    231645, 
    231646, 
    231647, 
    231648, 
    231649, 
    231651, 
    231652, 
    231653, 
    231654, 
    231655, 
    231657, 
    231658, 
    231659, 
    231660, 
    231692, 
    231663, 
    231664, 
    231665, 
    231666, 
    231686, 
    231667, 
    231668, 
    231669, 
    231670, 
    231671, 
    231672, 
    231673, 
    231674, 
    231675, 
    231676, 
    231677, 
    231678, 
    231679, 
    231681, 
    231682, 
    231683, 
    231684, 
    231685, 
    231687, 
    231688, 
    231689, 
    231690, 
    231703, 
    231701, 
    231702, 
    233543, 
    231706, 
    231704, 
    231705, 
    231709, 
    231707, 
    231708
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00294

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": 158,
          "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,226373,226338,226339,226340,226341,226342,226343,237048,237049,226344,241325,226345,226346,226347,226348,226349,241326,226350,226351,226352,226353,226354,226355,226356,226357,241327,226358,241328,226359,226360,226361,226362,226363,241329,242533,242534,242535,242536,226368,226369,226370,226371,226372,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,231662,231633,231634,231635,231636,231656,231637,231638,231639,231640,231641,231642,231643,231644,231645,231646,231647,231648,231649,231651,231652,231653,231654,231655,231657,231658,231659,231660,231692,231663,231664,231665,231666,231686,231667,231668,231669,231670,231671,231672,231673,231674,231675,231676,231677,231678,231679,231681,231682,231683,231684,231685,231687,231688,231689,231690,231703,231701,231702,233543,231706,231704,231705,231709,231707,231708)"
        }
      }
    },
    "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