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 (
    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, 
    220144, 
    215513, 
    215516, 
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    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, 
    228134, 
    228104, 
    228105, 
    228106, 
    228107, 
    228108, 
    228110, 
    242725, 
    242726, 
    228111, 
    241136, 
    228112, 
    228113, 
    228114, 
    228115, 
    228116, 
    241137, 
    228117, 
    228118, 
    228119, 
    228120, 
    228121, 
    228122, 
    228123, 
    228124, 
    241138, 
    228125, 
    241139, 
    228126, 
    228127, 
    228216, 
    228128, 
    228129, 
    241140, 
    242717, 
    242718, 
    242719, 
    242720, 
    228175, 
    228176, 
    228177, 
    228215, 
    228208, 
    228209, 
    228210
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00393

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": 154,
          "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,220144,215513,215516,220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,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,228134,228104,228105,228106,228107,228108,228110,242725,242726,228111,241136,228112,228113,228114,228115,228116,241137,228117,228118,228119,228120,228121,228122,228123,228124,241138,228125,241139,228126,228127,228216,228128,228129,241140,242717,242718,242719,242720,228175,228176,228177,228215,228208,228209,228210)"
        }
      }
    },
    "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