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 (
    223755, 
    223756, 
    223757, 
    223758, 
    223759, 
    230828, 
    230827, 
    232268, 
    232269, 
    232270, 
    232300, 
    232275, 
    232277, 
    232279, 
    232387, 
    244590, 
    244591, 
    244592, 
    244593, 
    244594, 
    244595, 
    244596, 
    244597, 
    232357, 
    232358, 
    232359, 
    232360, 
    232361, 
    232362, 
    237026, 
    237027, 
    232363, 
    245142, 
    241146, 
    232364, 
    232365, 
    232366, 
    232367, 
    232368, 
    241147, 
    232369, 
    232370, 
    232371, 
    232372, 
    232373, 
    232374, 
    232375, 
    232376, 
    241148, 
    232377, 
    241149, 
    232378, 
    232379, 
    245143, 
    245144, 
    232388, 
    232380, 
    232381, 
    245145, 
    241150, 
    232382, 
    232383, 
    232384, 
    232385, 
    232386, 
    232392, 
    232389, 
    232390, 
    232391, 
    232408, 
    232400, 
    232401, 
    232402, 
    232419, 
    232411, 
    232412, 
    232413, 
    232430, 
    232422, 
    232423, 
    232424, 
    232459, 
    232433, 
    232434, 
    232435, 
    232436, 
    232437, 
    232438, 
    240467, 
    240468, 
    232439, 
    245146, 
    241151, 
    232440, 
    232441, 
    232442, 
    232443, 
    232444, 
    241152, 
    232445, 
    232446, 
    232447, 
    232448, 
    232449, 
    232450, 
    232451, 
    232452, 
    241153, 
    232453, 
    241154, 
    232454, 
    232455, 
    245147, 
    245148, 
    232456, 
    232457, 
    232458, 
    245149, 
    241155, 
    232472, 
    244606, 
    244607, 
    244608, 
    244609, 
    244610, 
    244611, 
    244612, 
    244613, 
    232962, 
    232963, 
    232964, 
    232975, 
    232969, 
    232970, 
    234804, 
    234801, 
    234802, 
    234803
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00294

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": 138,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (223755,223756,223757,223758,223759,230828,230827,232268,232269,232270,232300,232275,232277,232279,232387,244590,244591,244592,244593,244594,244595,244596,244597,232357,232358,232359,232360,232361,232362,237026,237027,232363,245142,241146,232364,232365,232366,232367,232368,241147,232369,232370,232371,232372,232373,232374,232375,232376,241148,232377,241149,232378,232379,245143,245144,232388,232380,232381,245145,241150,232382,232383,232384,232385,232386,232392,232389,232390,232391,232408,232400,232401,232402,232419,232411,232412,232413,232430,232422,232423,232424,232459,232433,232434,232435,232436,232437,232438,240467,240468,232439,245146,241151,232440,232441,232442,232443,232444,241152,232445,232446,232447,232448,232449,232450,232451,232452,241153,232453,241154,232454,232455,245147,245148,232456,232457,232458,245149,241155,232472,244606,244607,244608,244609,244610,244611,244612,244613,232962,232963,232964,232975,232969,232970,234804,234801,234802,234803)"
        }
      }
    },
    "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