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 (
    220155, 219969, 219970, 219971, 219972, 
    224600, 220322, 220323, 220324, 220325, 
    220326, 220327, 220328, 237178, 237179, 
    220329, 241813, 220330, 220331, 220332, 
    220333, 220334, 241814, 220335, 220336, 
    220337, 220338, 220339, 220340, 220341, 
    220342, 241815, 220343, 241816, 220344, 
    220345, 220346, 220347, 220348, 241817, 
    242127, 242128, 242129, 242130, 220353, 
    220354, 220355, 220356, 220357, 220358, 
    220359, 220360, 220361, 220362, 220363, 
    220364, 220365, 237180, 237181, 220366, 
    220386, 241818, 220367, 220368, 220369, 
    220370, 220371, 241819, 220372, 220373, 
    220374, 220375, 220376, 220377, 220378, 
    220379, 241820, 220380, 241821, 220381, 
    220382, 220388, 220383, 220384, 220385, 
    241822, 242131, 242132, 242133, 242134, 
    222654, 222642, 222643, 222644, 242976, 
    222647
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00136

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": 96,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220155,219969,219970,219971,219972,224600,220322,220323,220324,220325,220326,220327,220328,237178,237179,220329,241813,220330,220331,220332,220333,220334,241814,220335,220336,220337,220338,220339,220340,220341,220342,241815,220343,241816,220344,220345,220346,220347,220348,241817,242127,242128,242129,242130,220353,220354,220355,220356,220357,220358,220359,220360,220361,220362,220363,220364,220365,237180,237181,220366,220386,241818,220367,220368,220369,220370,220371,241819,220372,220373,220374,220375,220376,220377,220378,220379,241820,220380,241821,220381,220382,220388,220383,220384,220385,241822,242131,242132,242133,242134,222654,222642,222643,222644,242976,222647)"
        }
      }
    },
    "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