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 (
    220318, 
    215376, 
    215377, 
    228071, 
    228069, 
    228070, 
    228102, 
    228072, 
    228073, 
    228074, 
    228075, 
    228076, 
    228077, 
    237170, 
    237171, 
    228078, 
    242721, 
    241120, 
    228079, 
    228080, 
    228081, 
    228082, 
    228083, 
    241121, 
    228084, 
    228085, 
    228086, 
    228087, 
    228088, 
    228089, 
    228090, 
    228091, 
    241122, 
    228092, 
    241123, 
    228093, 
    228094, 
    242722, 
    242723, 
    228095, 
    228096, 
    228097, 
    242724, 
    241124, 
    229352, 
    229346, 
    229347, 
    229348, 
    229349, 
    236650, 
    236498, 
    236468, 
    236469, 
    236470, 
    236471, 
    236493, 
    236486, 
    239867, 
    239868, 
    236472, 
    241640, 
    236473, 
    236474, 
    236475, 
    236476, 
    236477, 
    241641, 
    236478, 
    236479, 
    236480, 
    236481, 
    236482, 
    236483, 
    236484, 
    236485, 
    241642, 
    236487, 
    241643, 
    236488, 
    236489, 
    236490, 
    236491, 
    236492, 
    241644, 
    242852, 
    242853, 
    242854, 
    242855, 
    236530, 
    236499, 
    236500, 
    236501, 
    236502, 
    236503, 
    236504, 
    236505, 
    236506, 
    239869, 
    239870, 
    236507, 
    241645, 
    236508, 
    236509, 
    236510, 
    236511, 
    236512, 
    241646, 
    236513, 
    236514, 
    236515, 
    236516, 
    236517, 
    236518, 
    236519, 
    236520, 
    241647, 
    236521, 
    241648, 
    236522, 
    236523, 
    236524, 
    236525, 
    241649, 
    242856, 
    242857, 
    242858, 
    242859
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00215

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": 127,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220318,215376,215377,228071,228069,228070,228102,228072,228073,228074,228075,228076,228077,237170,237171,228078,242721,241120,228079,228080,228081,228082,228083,241121,228084,228085,228086,228087,228088,228089,228090,228091,241122,228092,241123,228093,228094,242722,242723,228095,228096,228097,242724,241124,229352,229346,229347,229348,229349,236650,236498,236468,236469,236470,236471,236493,236486,239867,239868,236472,241640,236473,236474,236475,236476,236477,241641,236478,236479,236480,236481,236482,236483,236484,236485,241642,236487,241643,236488,236489,236490,236491,236492,241644,242852,242853,242854,242855,236530,236499,236500,236501,236502,236503,236504,236505,236506,239869,239870,236507,241645,236508,236509,236510,236511,236512,241646,236513,236514,236515,236516,236517,236518,236519,236520,241647,236521,241648,236522,236523,236524,236525,241649,242856,242857,242858,242859)"
        }
      }
    },
    "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