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 (
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    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, 
    226735, 
    226736, 
    226737, 
    226738, 
    226739, 
    228252, 
    228256, 
    228253, 
    228254, 
    228255, 
    228257, 
    228261, 
    228258, 
    228259, 
    228260, 
    236721, 
    236691, 
    236692, 
    236693, 
    236694, 
    236709, 
    237234, 
    237235, 
    236695, 
    241340, 
    236696, 
    236697, 
    236698, 
    236699, 
    236700, 
    241341, 
    236701, 
    236702, 
    236703, 
    236704, 
    236705, 
    236706, 
    236707, 
    236708, 
    241342, 
    236710, 
    241343, 
    236711, 
    236712, 
    236713, 
    236714, 
    236715, 
    241344, 
    242541, 
    242542, 
    242543, 
    242544, 
    238237, 
    238238, 
    238239, 
    239910, 
    239875, 
    239876, 
    239877, 
    239878, 
    239880, 
    239911, 
    239912, 
    239881, 
    241453, 
    239882, 
    239883, 
    239884, 
    239885, 
    239886, 
    241454, 
    239887, 
    239888, 
    239889, 
    239890, 
    239891, 
    239892, 
    239893, 
    239894, 
    241455, 
    239895, 
    241456, 
    239896, 
    239897, 
    239898, 
    239899, 
    239900, 
    241457, 
    242247, 
    242248, 
    242249, 
    242250
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00295

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": 144,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,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,226735,226736,226737,226738,226739,228252,228256,228253,228254,228255,228257,228261,228258,228259,228260,236721,236691,236692,236693,236694,236709,237234,237235,236695,241340,236696,236697,236698,236699,236700,241341,236701,236702,236703,236704,236705,236706,236707,236708,241342,236710,241343,236711,236712,236713,236714,236715,241344,242541,242542,242543,242544,238237,238238,238239,239910,239875,239876,239877,239878,239880,239911,239912,239881,241453,239882,239883,239884,239885,239886,241454,239887,239888,239889,239890,239891,239892,239893,239894,241455,239895,241456,239896,239897,239898,239899,239900,241457,242247,242248,242249,242250)"
        }
      }
    },
    "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