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 (
    218476, 
    215713, 
    215714, 
    215715, 
    215716, 
    215738, 
    215731, 
    237036, 
    237037, 
    215717, 
    242135, 
    241141, 
    215718, 
    215719, 
    215720, 
    215721, 
    215722, 
    241142, 
    215723, 
    215724, 
    215725, 
    215726, 
    215727, 
    215728, 
    215729, 
    215730, 
    241143, 
    215732, 
    241144, 
    215733, 
    215734, 
    215735, 
    242136, 
    242137, 
    215736, 
    215737, 
    242138, 
    241145, 
    220181, 
    217235, 
    217236, 
    217264, 
    217237, 
    217238, 
    217239, 
    217240, 
    217241, 
    237038, 
    237039, 
    217242, 
    242657, 
    241261, 
    217243, 
    217244, 
    217245, 
    217246, 
    217247, 
    241262, 
    217248, 
    217249, 
    217250, 
    217251, 
    217252, 
    217253, 
    217254, 
    217255, 
    241263, 
    217256, 
    241264, 
    217257, 
    217258, 
    242658, 
    242659, 
    243002, 
    230712, 
    217259, 
    242660, 
    241265, 
    220272, 
    217308, 
    217309, 
    217310, 
    217311, 
    217312, 
    217313, 
    237062, 
    237063, 
    217314, 
    242263, 
    241171, 
    217315, 
    217316, 
    217317, 
    217318, 
    217319, 
    241172, 
    217320, 
    217321, 
    217322, 
    217323, 
    217324, 
    217325, 
    217326, 
    217327, 
    241173, 
    217328, 
    241174, 
    217329, 
    217330, 
    242264, 
    242265, 
    217331, 
    217332, 
    217333, 
    242266, 
    241175, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    223760, 
    223761, 
    223762, 
    224224, 
    224225, 
    224226, 
    224892, 
    224889, 
    238255, 
    228071, 
    228069, 
    228070, 
    231939, 
    231910, 
    231911, 
    231912, 
    231913, 
    231933, 
    231914, 
    231915, 
    231916, 
    231917, 
    231918, 
    231919, 
    231920, 
    231921, 
    231922, 
    231923, 
    231924, 
    231925, 
    231926, 
    231928, 
    231929, 
    231930, 
    231931, 
    231932, 
    231934, 
    231935, 
    231936, 
    231937, 
    233559, 
    233557, 
    233558, 
    233560
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00336

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": 165,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (218476,215713,215714,215715,215716,215738,215731,237036,237037,215717,242135,241141,215718,215719,215720,215721,215722,241142,215723,215724,215725,215726,215727,215728,215729,215730,241143,215732,241144,215733,215734,215735,242136,242137,215736,215737,242138,241145,220181,217235,217236,217264,217237,217238,217239,217240,217241,237038,237039,217242,242657,241261,217243,217244,217245,217246,217247,241262,217248,217249,217250,217251,217252,217253,217254,217255,241263,217256,241264,217257,217258,242658,242659,243002,230712,217259,242660,241265,220272,217308,217309,217310,217311,217312,217313,237062,237063,217314,242263,241171,217315,217316,217317,217318,217319,241172,217320,217321,217322,217323,217324,217325,217326,217327,241173,217328,241174,217329,217330,242264,242265,217331,217332,217333,242266,241175,223755,223756,223757,223758,223759,223760,223761,223762,224224,224225,224226,224892,224889,238255,228071,228069,228070,231939,231910,231911,231912,231913,231933,231914,231915,231916,231917,231918,231919,231920,231921,231922,231923,231924,231925,231926,231928,231929,231930,231931,231932,231934,231935,231936,231937,233559,233557,233558,233560)"
        }
      }
    },
    "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