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 (
    220122, 218479, 218480, 220139, 244854, 
    244855, 244856, 244857, 244858, 244859, 
    244860, 244861, 218570, 218571, 218572, 
    218573, 218574, 218575, 236892, 236893, 
    218576, 245284, 241625, 218577, 218578, 
    218579, 218580, 218581, 241626, 218582, 
    218583, 218584, 218585, 218586, 218587, 
    218588, 218589, 241627, 218590, 241628, 
    218591, 218592, 245285, 245286, 225922, 
    218593, 218594, 245287, 241629, 220238, 
    219398, 219399, 220280, 244862, 244863, 
    244864, 244865, 244866, 244867, 244868, 
    244869, 220281, 218648, 218649, 218650, 
    218651, 218652, 218653, 236896, 236897, 
    218654, 241630, 218655, 218656, 218657, 
    218658, 218659, 241631, 218660, 218661, 
    218662, 218663, 218664, 218665, 218666, 
    218667, 241632, 218668, 241633, 218669, 
    218670, 225923, 218671, 218672, 241634, 
    220303, 215974, 215975, 220307, 215660, 
    215661, 215662, 215663, 215664, 215665, 
    215666, 215667, 215668, 215669, 215670, 
    215671, 215672, 215673, 243095, 243096, 
    243097, 243098, 220309, 215976, 215977, 
    220317, 217132, 217133
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00230

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": 123,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220122,218479,218480,220139,244854,244855,244856,244857,244858,244859,244860,244861,218570,218571,218572,218573,218574,218575,236892,236893,218576,245284,241625,218577,218578,218579,218580,218581,241626,218582,218583,218584,218585,218586,218587,218588,218589,241627,218590,241628,218591,218592,245285,245286,225922,218593,218594,245287,241629,220238,219398,219399,220280,244862,244863,244864,244865,244866,244867,244868,244869,220281,218648,218649,218650,218651,218652,218653,236896,236897,218654,241630,218655,218656,218657,218658,218659,241631,218660,218661,218662,218663,218664,218665,218666,218667,241632,218668,241633,218669,218670,225923,218671,218672,241634,220303,215974,215975,220307,215660,215661,215662,215663,215664,215665,215666,215667,215668,215669,215670,215671,215672,215673,243095,243096,243097,243098,220309,215976,215977,220317,217132,217133)"
        }
      }
    },
    "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