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 (
    220173, 
    215556, 
    215557, 
    215558, 
    215559, 
    215560, 
    215561, 
    215562, 
    215563, 
    215564, 
    215565, 
    215566, 
    215567, 
    215568, 
    215569, 
    243103, 
    243104, 
    243105, 
    243106, 
    220320, 
    219237, 
    219238, 
    219239, 
    242973, 
    219241, 
    219249, 
    219250, 
    219252, 
    219253, 
    219254, 
    219255, 
    219256, 
    219257, 
    219258, 
    219259, 
    230564, 
    230565, 
    230566, 
    230567, 
    230568, 
    230569, 
    236289, 
    236254, 
    236255, 
    236256, 
    236257, 
    236258, 
    236259, 
    237327, 
    237328, 
    236260, 
    242060, 
    236261, 
    236262, 
    236263, 
    236264, 
    236265, 
    242061, 
    236266, 
    236267, 
    236268, 
    236269, 
    236270, 
    236271, 
    236272, 
    236273, 
    242062, 
    236274, 
    242063, 
    236275, 
    236276, 
    236277, 
    236278, 
    236279, 
    242064, 
    242680, 
    242681, 
    242682, 
    242683, 
    236325, 
    236290, 
    236291, 
    236292, 
    236293, 
    236294, 
    236295, 
    237329, 
    237330, 
    236296, 
    242070, 
    236297, 
    236298, 
    236299, 
    236300, 
    236301, 
    242071, 
    236302, 
    236303, 
    236304, 
    236305, 
    236306, 
    236307, 
    236308, 
    236309, 
    242072, 
    236310, 
    242073, 
    236311, 
    236312, 
    236313, 
    236314, 
    236315, 
    242074, 
    242684, 
    242685, 
    242686, 
    242687, 
    237331, 
    237332, 
    237333, 
    237334, 
    237335, 
    236358, 
    236326, 
    236327, 
    236328, 
    236329, 
    236330, 
    236331, 
    236332, 
    240938, 
    240939, 
    236333, 
    242065, 
    236334, 
    236335, 
    236336, 
    236337, 
    236338, 
    242066, 
    236339, 
    236340, 
    236341, 
    236342, 
    236343, 
    236344, 
    236345, 
    236346, 
    242067, 
    236347, 
    242068, 
    236348, 
    236349, 
    236350, 
    236351, 
    236352, 
    242069, 
    242688, 
    242689, 
    242690, 
    242691, 
    237336, 
    237337, 
    237338, 
    237339, 
    237340
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00256

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": 166,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220173,215556,215557,215558,215559,215560,215561,215562,215563,215564,215565,215566,215567,215568,215569,243103,243104,243105,243106,220320,219237,219238,219239,242973,219241,219249,219250,219252,219253,219254,219255,219256,219257,219258,219259,230564,230565,230566,230567,230568,230569,236289,236254,236255,236256,236257,236258,236259,237327,237328,236260,242060,236261,236262,236263,236264,236265,242061,236266,236267,236268,236269,236270,236271,236272,236273,242062,236274,242063,236275,236276,236277,236278,236279,242064,242680,242681,242682,242683,236325,236290,236291,236292,236293,236294,236295,237329,237330,236296,242070,236297,236298,236299,236300,236301,242071,236302,236303,236304,236305,236306,236307,236308,236309,242072,236310,242073,236311,236312,236313,236314,236315,242074,242684,242685,242686,242687,237331,237332,237333,237334,237335,236358,236326,236327,236328,236329,236330,236331,236332,240938,240939,236333,242065,236334,236335,236336,236337,236338,242066,236339,236340,236341,236342,236343,236344,236345,236346,242067,236347,242068,236348,236349,236350,236351,236352,242069,242688,242689,242690,242691,237336,237337,237338,237339,237340)"
        }
      }
    },
    "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