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, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    226576, 
    226546, 
    226547, 
    226548, 
    226549, 
    226571, 
    226564, 
    237098, 
    237099, 
    226550, 
    241305, 
    226551, 
    226552, 
    226553, 
    226554, 
    226555, 
    241306, 
    226556, 
    226557, 
    226558, 
    226559, 
    226560, 
    226561, 
    226562, 
    226563, 
    241307, 
    226565, 
    241308, 
    226566, 
    226567, 
    226568, 
    226569, 
    226570, 
    241309, 
    242517, 
    242518, 
    242519, 
    242520, 
    229781, 
    229782, 
    229783, 
    229784, 
    229785, 
    226880, 
    226867, 
    226869, 
    226871, 
    226873, 
    226875, 
    226877, 
    226908, 
    230589, 
    226905, 
    226906, 
    226907, 
    226921, 
    226910, 
    226912, 
    226914, 
    226916, 
    226918, 
    226920, 
    228262, 
    228263, 
    228264, 
    228295, 
    228299, 
    228296, 
    228297, 
    228298, 
    228300, 
    228304, 
    228301, 
    228302, 
    228303, 
    240924, 
    240894, 
    240895, 
    240896, 
    240897, 
    240898, 
    240918, 
    240899, 
    240929, 
    240930, 
    240900, 
    241320, 
    240901, 
    240902, 
    240903, 
    240904, 
    240905, 
    241321, 
    240906, 
    240907, 
    240908, 
    240909, 
    240910, 
    240911, 
    240912, 
    240913, 
    241322, 
    240914, 
    241323, 
    240915, 
    240916, 
    240931, 
    240917, 
    241324, 
    240919, 
    240920, 
    240921, 
    240922, 
    240923, 
    242529, 
    242530, 
    242531, 
    242532
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00302

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": 137,
          "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,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226576,226546,226547,226548,226549,226571,226564,237098,237099,226550,241305,226551,226552,226553,226554,226555,241306,226556,226557,226558,226559,226560,226561,226562,226563,241307,226565,241308,226566,226567,226568,226569,226570,241309,242517,242518,242519,242520,229781,229782,229783,229784,229785,226880,226867,226869,226871,226873,226875,226877,226908,230589,226905,226906,226907,226921,226910,226912,226914,226916,226918,226920,228262,228263,228264,228295,228299,228296,228297,228298,228300,228304,228301,228302,228303,240924,240894,240895,240896,240897,240898,240918,240899,240929,240930,240900,241320,240901,240902,240903,240904,240905,241321,240906,240907,240908,240909,240910,240911,240912,240913,241322,240914,241323,240915,240916,240931,240917,241324,240919,240920,240921,240922,240923,242529,242530,242531,242532)"
        }
      }
    },
    "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