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 (
    224029, 
    224030, 
    224031, 
    224038, 
    224035, 
    224036, 
    224037, 
    224078, 
    224043, 
    224044, 
    224045, 
    224046, 
    224047, 
    224048, 
    237122, 
    237123, 
    224049, 
    242075, 
    224050, 
    224051, 
    224052, 
    224053, 
    224054, 
    242076, 
    224055, 
    224056, 
    224057, 
    224058, 
    224059, 
    224060, 
    224061, 
    224062, 
    242077, 
    224063, 
    242078, 
    224064, 
    224065, 
    224066, 
    224067, 
    224068, 
    242079, 
    224073, 
    224074, 
    242756, 
    242757, 
    242758, 
    242759, 
    224111, 
    224112, 
    224079, 
    224080, 
    224082, 
    224083, 
    224084, 
    237124, 
    237125, 
    224085, 
    242080, 
    224086, 
    224087, 
    224088, 
    224089, 
    224090, 
    242081, 
    224091, 
    224092, 
    224093, 
    224094, 
    224095, 
    224096, 
    224097, 
    224098, 
    242082, 
    224099, 
    242083, 
    224100, 
    224101, 
    224102, 
    224103, 
    224104, 
    242084, 
    242760, 
    242761, 
    242762, 
    242763, 
    224153, 
    224223, 
    215002, 
    215003, 
    215004, 
    215005, 
    224183, 
    224154, 
    224155, 
    224156, 
    224157, 
    224158, 
    224159, 
    224160, 
    239308, 
    239309, 
    224161, 
    242085, 
    224162, 
    224163, 
    224164, 
    224165, 
    224166, 
    242086, 
    224167, 
    224168, 
    224169, 
    224170, 
    224171, 
    224172, 
    224173, 
    224174, 
    242087, 
    224175, 
    242088, 
    224176, 
    224177, 
    224178, 
    224179, 
    224180, 
    242089, 
    224181, 
    224182, 
    242872, 
    242873, 
    242874, 
    242875
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00168

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": 132,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (224029,224030,224031,224038,224035,224036,224037,224078,224043,224044,224045,224046,224047,224048,237122,237123,224049,242075,224050,224051,224052,224053,224054,242076,224055,224056,224057,224058,224059,224060,224061,224062,242077,224063,242078,224064,224065,224066,224067,224068,242079,224073,224074,242756,242757,242758,242759,224111,224112,224079,224080,224082,224083,224084,237124,237125,224085,242080,224086,224087,224088,224089,224090,242081,224091,224092,224093,224094,224095,224096,224097,224098,242082,224099,242083,224100,224101,224102,224103,224104,242084,242760,242761,242762,242763,224153,224223,215002,215003,215004,215005,224183,224154,224155,224156,224157,224158,224159,224160,239308,239309,224161,242085,224162,224163,224164,224165,224166,242086,224167,224168,224169,224170,224171,224172,224173,224174,242087,224175,242088,224176,224177,224178,224179,224180,242089,224181,224182,242872,242873,242874,242875)"
        }
      }
    },
    "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