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 (
    220318, 
    215376, 
    215377, 
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    224224, 
    224225, 
    224226, 
    226326, 
    226327, 
    226328, 
    226329, 
    226330, 
    226331, 
    226332, 
    226333, 
    226434, 
    226438, 
    226435, 
    226436, 
    226437, 
    226439, 
    226443, 
    226440, 
    226441, 
    226442, 
    226444, 
    226448, 
    226445, 
    226446, 
    226447, 
    226449, 
    226453, 
    226450, 
    226451, 
    226452, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    226802, 
    226772, 
    226773, 
    226774, 
    226775, 
    226797, 
    226790, 
    237070, 
    237071, 
    226776, 
    241335, 
    226777, 
    226778, 
    226779, 
    226780, 
    226781, 
    241336, 
    226782, 
    226783, 
    226784, 
    226785, 
    226786, 
    226787, 
    226788, 
    226789, 
    241337, 
    226791, 
    241338, 
    226792, 
    226793, 
    226794, 
    226795, 
    226796, 
    241339, 
    242195, 
    242196, 
    242197, 
    242198, 
    226806, 
    226804, 
    226805, 
    226822, 
    226807, 
    226808, 
    226809, 
    226810, 
    226811, 
    226812, 
    226813, 
    226814, 
    226815, 
    226816, 
    226817, 
    226818, 
    226819, 
    226820, 
    243099, 
    243100, 
    243101, 
    243102, 
    228217, 
    228218, 
    228219, 
    228252, 
    228256, 
    228253, 
    228254, 
    228255, 
    228257, 
    228261, 
    228258, 
    228259, 
    228260, 
    228262, 
    228263, 
    228264, 
    228295, 
    228299, 
    228296, 
    228297, 
    228298, 
    228300, 
    228304, 
    228301, 
    228302, 
    228303, 
    228305, 
    228306, 
    228307, 
    228338, 
    228342, 
    228339, 
    228340, 
    228341, 
    228343, 
    228347, 
    228344, 
    228345, 
    228346, 
    237244, 
    237245, 
    237246
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00278

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": 157,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220318,215376,215377,223755,223756,223757,223758,223759,224224,224225,224226,226326,226327,226328,226329,226330,226331,226332,226333,226434,226438,226435,226436,226437,226439,226443,226440,226441,226442,226444,226448,226445,226446,226447,226449,226453,226450,226451,226452,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226802,226772,226773,226774,226775,226797,226790,237070,237071,226776,241335,226777,226778,226779,226780,226781,241336,226782,226783,226784,226785,226786,226787,226788,226789,241337,226791,241338,226792,226793,226794,226795,226796,241339,242195,242196,242197,242198,226806,226804,226805,226822,226807,226808,226809,226810,226811,226812,226813,226814,226815,226816,226817,226818,226819,226820,243099,243100,243101,243102,228217,228218,228219,228252,228256,228253,228254,228255,228257,228261,228258,228259,228260,228262,228263,228264,228295,228299,228296,228297,228298,228300,228304,228301,228302,228303,228305,228306,228307,228338,228342,228339,228340,228341,228343,228347,228344,228345,228346,237244,237245,237246)"
        }
      }
    },
    "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