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 (
    220137, 
    217978, 
    217979, 
    217980, 
    217981, 
    217982, 
    217983, 
    237042, 
    237043, 
    217984, 
    242635, 
    241100, 
    217985, 
    217986, 
    217987, 
    217988, 
    217989, 
    241101, 
    217990, 
    217991, 
    217992, 
    217993, 
    217994, 
    217995, 
    217996, 
    217997, 
    241102, 
    217998, 
    241103, 
    217999, 
    218000, 
    242636, 
    242637, 
    218001, 
    218002, 
    218003, 
    242638, 
    241104, 
    218008, 
    218009, 
    218010, 
    218011, 
    218012, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    224883, 
    224851, 
    224852, 
    224853, 
    224854, 
    224855, 
    224856, 
    224857, 
    237152, 
    237153, 
    224858, 
    242653, 
    241725, 
    224859, 
    224860, 
    224861, 
    224862, 
    224863, 
    241726, 
    224864, 
    224865, 
    224866, 
    224867, 
    224868, 
    224869, 
    224870, 
    224871, 
    241727, 
    224872, 
    241728, 
    224873, 
    224874, 
    242654, 
    242655, 
    224875, 
    224876, 
    224877, 
    242656, 
    241729, 
    224878, 
    224879, 
    224880, 
    224881, 
    224882, 
    229794, 
    229786, 
    229787, 
    229788, 
    230828, 
    230827, 
    240507, 
    240506, 
    240508, 
    240509, 
    240536, 
    240514, 
    240515, 
    240516, 
    240517, 
    240518, 
    240526, 
    240535, 
    240519, 
    240520, 
    240521, 
    240522, 
    240523, 
    240524, 
    240525, 
    240527, 
    240528, 
    240529, 
    240530, 
    240559, 
    240537, 
    240538, 
    240539, 
    240540, 
    240541, 
    240549, 
    240558, 
    240542, 
    240543, 
    240544, 
    240545, 
    240546, 
    240547, 
    240548, 
    240550, 
    240551, 
    240552, 
    240553, 
    240582, 
    240560, 
    240561, 
    240562, 
    240563, 
    240564, 
    240572, 
    240581, 
    240565, 
    240566, 
    240567, 
    240568, 
    240569, 
    240570, 
    240571, 
    240573, 
    240574, 
    240575, 
    240576
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00364

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 (220137,217978,217979,217980,217981,217982,217983,237042,237043,217984,242635,241100,217985,217986,217987,217988,217989,241101,217990,217991,217992,217993,217994,217995,217996,217997,241102,217998,241103,217999,218000,242636,242637,218001,218002,218003,242638,241104,218008,218009,218010,218011,218012,223755,223756,223757,223758,223759,224883,224851,224852,224853,224854,224855,224856,224857,237152,237153,224858,242653,241725,224859,224860,224861,224862,224863,241726,224864,224865,224866,224867,224868,224869,224870,224871,241727,224872,241728,224873,224874,242654,242655,224875,224876,224877,242656,241729,224878,224879,224880,224881,224882,229794,229786,229787,229788,230828,230827,240507,240506,240508,240509,240536,240514,240515,240516,240517,240518,240526,240535,240519,240520,240521,240522,240523,240524,240525,240527,240528,240529,240530,240559,240537,240538,240539,240540,240541,240549,240558,240542,240543,240544,240545,240546,240547,240548,240550,240551,240552,240553,240582,240560,240561,240562,240563,240564,240572,240581,240565,240566,240567,240568,240569,240570,240571,240573,240574,240575,240576)"
        }
      }
    },
    "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