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, 
    220172, 
    238867, 
    215452, 
    238868, 
    215454, 
    238869, 
    215456, 
    238870, 
    215458, 
    238871, 
    215460, 
    238872, 
    215462, 
    220318, 
    215376, 
    215377, 
    222969, 
    222959, 
    222960, 
    222961, 
    222970, 
    222971, 
    222972, 
    222973, 
    222974, 
    222990, 
    222992, 
    222991, 
    223099, 
    223068, 
    223069, 
    223070, 
    223071, 
    223072, 
    223073, 
    223093, 
    223074, 
    237172, 
    237173, 
    223075, 
    242860, 
    241110, 
    223076, 
    223077, 
    223078, 
    223079, 
    223080, 
    241111, 
    223081, 
    223082, 
    223083, 
    223084, 
    223085, 
    223086, 
    223087, 
    223088, 
    241112, 
    223089, 
    241113, 
    223090, 
    223091, 
    242861, 
    234295, 
    242862, 
    234296, 
    223092, 
    242863, 
    241114, 
    223097, 
    223098, 
    223134, 
    223104, 
    223105, 
    223106, 
    223107, 
    223108, 
    223128, 
    223109, 
    237174, 
    237175, 
    223110, 
    242864, 
    241115, 
    223111, 
    223112, 
    223113, 
    223114, 
    223115, 
    241116, 
    223116, 
    223117, 
    223118, 
    223119, 
    223120, 
    223121, 
    223122, 
    223123, 
    241117, 
    223124, 
    241118, 
    223125, 
    223126, 
    242865, 
    242866, 
    234297, 
    234298, 
    223127, 
    242867, 
    241119, 
    223132, 
    223133, 
    223142, 
    223139, 
    223140, 
    223141, 
    223146, 
    223143, 
    223144, 
    223145, 
    223150, 
    223147, 
    223148, 
    223149
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00220

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": 166,
          "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,220172,238867,215452,238868,215454,238869,215456,238870,215458,238871,215460,238872,215462,220318,215376,215377,222969,222959,222960,222961,222970,222971,222972,222973,222974,222990,222992,222991,223099,223068,223069,223070,223071,223072,223073,223093,223074,237172,237173,223075,242860,241110,223076,223077,223078,223079,223080,241111,223081,223082,223083,223084,223085,223086,223087,223088,241112,223089,241113,223090,223091,242861,234295,242862,234296,223092,242863,241114,223097,223098,223134,223104,223105,223106,223107,223108,223128,223109,237174,237175,223110,242864,241115,223111,223112,223113,223114,223115,241116,223116,223117,223118,223119,223120,223121,223122,223123,241117,223124,241118,223125,223126,242865,242866,234297,234298,223127,242867,241119,223132,223133,223142,223139,223140,223141,223146,223143,223144,223145,223150,223147,223148,223149)"
        }
      }
    },
    "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