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 (
    220164, 217704, 217705, 223755, 223756, 
    223757, 223758, 223759, 230381, 230382, 
    233635, 233606, 233607, 233608, 233609, 
    233610, 237270, 237271, 233611, 241418, 
    233612, 233613, 233614, 233615, 233616, 
    241419, 233617, 233618, 233619, 233620, 
    233621, 233622, 233623, 233624, 241420, 
    233625, 241421, 233626, 233627, 233628, 
    233629, 233630, 241422, 236690, 242227, 
    242228, 242229, 242230, 238258, 238256, 
    238257, 238294, 238259, 238260, 238261, 
    238262, 238263, 238295, 238264, 238297, 
    238298, 238265, 241413, 238266, 238267, 
    238268, 238269, 238270, 241414, 238271, 
    238272, 238273, 238274, 238275, 238276, 
    238277, 238278, 241415, 238279, 241416, 
    238280, 238281, 238282, 238283, 238284, 
    241417, 238296, 238289, 238290, 238291, 
    238292, 238293, 242223, 242224, 242225, 
    242226, 239337, 239336, 239341, 239338, 
    239339, 239340, 239342, 239617, 239618, 
    239619
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00153

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": 106,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220164,217704,217705,223755,223756,223757,223758,223759,230381,230382,233635,233606,233607,233608,233609,233610,237270,237271,233611,241418,233612,233613,233614,233615,233616,241419,233617,233618,233619,233620,233621,233622,233623,233624,241420,233625,241421,233626,233627,233628,233629,233630,241422,236690,242227,242228,242229,242230,238258,238256,238257,238294,238259,238260,238261,238262,238263,238295,238264,238297,238298,238265,241413,238266,238267,238268,238269,238270,241414,238271,238272,238273,238274,238275,238276,238277,238278,241415,238279,241416,238280,238281,238282,238283,238284,241417,238296,238289,238290,238291,238292,238293,242223,242224,242225,242226,239337,239336,239341,239338,239339,239340,239342,239617,239618,239619)"
        }
      }
    },
    "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