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 (
    220318, 
    215376, 
    215377, 
    226326, 
    226327, 
    226328, 
    226329, 
    226330, 
    226331, 
    226332, 
    226333, 
    226373, 
    226338, 
    226339, 
    226340, 
    226341, 
    226342, 
    226343, 
    237048, 
    237049, 
    226344, 
    241325, 
    226345, 
    226346, 
    226347, 
    226348, 
    226349, 
    241326, 
    226350, 
    226351, 
    226352, 
    226353, 
    226354, 
    226355, 
    226356, 
    226357, 
    241327, 
    226358, 
    241328, 
    226359, 
    226360, 
    226361, 
    226362, 
    226363, 
    241329, 
    242533, 
    242534, 
    242535, 
    242536, 
    226368, 
    226369, 
    226370, 
    226371, 
    226372, 
    226403, 
    226374, 
    226375, 
    226376, 
    226377, 
    226397, 
    226378, 
    226379, 
    226380, 
    226381, 
    226382, 
    226383, 
    226384, 
    226385, 
    226386, 
    226387, 
    226388, 
    226389, 
    226390, 
    226391, 
    226392, 
    226393, 
    226394, 
    226395, 
    226396, 
    226398, 
    226399, 
    226400, 
    226401, 
    226402, 
    226433, 
    226404, 
    226405, 
    226406, 
    226407, 
    226427, 
    226408, 
    226409, 
    226410, 
    226411, 
    226412, 
    226413, 
    226414, 
    226415, 
    226416, 
    226417, 
    226418, 
    226419, 
    226420, 
    226421, 
    226422, 
    226423, 
    226424, 
    226425, 
    226426, 
    226428, 
    226429, 
    226430, 
    226431, 
    226432, 
    226434, 
    226438, 
    226435, 
    226436, 
    226437, 
    226439, 
    226443, 
    226440, 
    226441, 
    226442, 
    226444, 
    226448, 
    226445, 
    226446, 
    226447, 
    226449, 
    226453, 
    226450, 
    226451, 
    226452, 
    226485, 
    226455, 
    226457, 
    226462, 
    226481, 
    244281, 
    226465, 
    226466, 
    244282, 
    239948, 
    226470, 
    226472, 
    226474, 
    226477, 
    226478, 
    226483, 
    226490, 
    226486, 
    226487, 
    233539, 
    226488, 
    226489, 
    226495, 
    226491, 
    226492, 
    226493, 
    226494, 
    226500, 
    226496, 
    226497, 
    226498, 
    226499
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00339

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 (220318,215376,215377,226326,226327,226328,226329,226330,226331,226332,226333,226373,226338,226339,226340,226341,226342,226343,237048,237049,226344,241325,226345,226346,226347,226348,226349,241326,226350,226351,226352,226353,226354,226355,226356,226357,241327,226358,241328,226359,226360,226361,226362,226363,241329,242533,242534,242535,242536,226368,226369,226370,226371,226372,226403,226374,226375,226376,226377,226397,226378,226379,226380,226381,226382,226383,226384,226385,226386,226387,226388,226389,226390,226391,226392,226393,226394,226395,226396,226398,226399,226400,226401,226402,226433,226404,226405,226406,226407,226427,226408,226409,226410,226411,226412,226413,226414,226415,226416,226417,226418,226419,226420,226421,226422,226423,226424,226425,226426,226428,226429,226430,226431,226432,226434,226438,226435,226436,226437,226439,226443,226440,226441,226442,226444,226448,226445,226446,226447,226449,226453,226450,226451,226452,226485,226455,226457,226462,226481,244281,226465,226466,244282,239948,226470,226472,226474,226477,226478,226483,226490,226486,226487,233539,226488,226489,226495,226491,226492,226493,226494,226500,226496,226497,226498,226499)"
        }
      }
    },
    "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