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 (
    217850, 215160, 215161, 215162, 215163, 
    215164, 216935, 215165, 237214, 237215, 
    215166, 242623, 215167, 215168, 215169, 
    215170, 215171, 242624, 215172, 215173, 
    215174, 215175, 215176, 215177, 215178, 
    215179, 242625, 215180, 242626, 215181, 
    215182, 215183, 215184, 242627, 227898, 
    227868, 227869, 227870, 227871, 227893, 
    227886, 237216, 237217, 227872, 242618, 
    227873, 227874, 227875, 227876, 227877, 
    242619, 227878, 227879, 227880, 227881, 
    227882, 227883, 227884, 227885, 242620, 
    227887, 242621, 227888, 227889, 227890, 
    227891, 227892, 242622, 227894, 227895, 
    227896, 227897, 229549, 229514, 229515, 
    229516, 229517, 229518, 229519, 237050, 
    237051, 229520, 229521, 229522, 229523, 
    229524, 229525, 229526, 229527, 229528, 
    229529, 229530, 229531, 229532, 229533, 
    229534, 229535, 229536, 229537, 229538, 
    229539, 229540, 229541, 229542, 229543, 
    229544, 229545, 229546, 229547, 229548
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00321

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": 110,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (217850,215160,215161,215162,215163,215164,216935,215165,237214,237215,215166,242623,215167,215168,215169,215170,215171,242624,215172,215173,215174,215175,215176,215177,215178,215179,242625,215180,242626,215181,215182,215183,215184,242627,227898,227868,227869,227870,227871,227893,227886,237216,237217,227872,242618,227873,227874,227875,227876,227877,242619,227878,227879,227880,227881,227882,227883,227884,227885,242620,227887,242621,227888,227889,227890,227891,227892,242622,227894,227895,227896,227897,229549,229514,229515,229516,229517,229518,229519,237050,237051,229520,229521,229522,229523,229524,229525,229526,229527,229528,229529,229530,229531,229532,229533,229534,229535,229536,229537,229538,229539,229540,229541,229542,229543,229544,229545,229546,229547,229548)"
        }
      }
    },
    "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