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 (
    220170, 
    215381, 
    215382, 
    215383, 
    215384, 
    215385, 
    215394, 
    215403, 
    215386, 
    215387, 
    215388, 
    215389, 
    215390, 
    215391, 
    215392, 
    215395, 
    215396, 
    215397, 
    215398, 
    220318, 
    215376, 
    215377, 
    223650, 
    223620, 
    223621, 
    223622, 
    223623, 
    223624, 
    244420, 
    223625, 
    237192, 
    237193, 
    223626, 
    242239, 
    241433, 
    223627, 
    223628, 
    223629, 
    223630, 
    223631, 
    241434, 
    223632, 
    223633, 
    223634, 
    223635, 
    223636, 
    223637, 
    223638, 
    223639, 
    241435, 
    223640, 
    241436, 
    223641, 
    223642, 
    242240, 
    242241, 
    223643, 
    223644, 
    223645, 
    242242, 
    241437, 
    228384, 
    228385, 
    228386, 
    243113, 
    243117, 
    243118, 
    243119, 
    244311, 
    244285, 
    244286, 
    244287, 
    244288, 
    244310, 
    244303, 
    244312, 
    244313, 
    244289, 
    244314, 
    244290, 
    244291, 
    244292, 
    244293, 
    244294, 
    244315, 
    244295, 
    244296, 
    244297, 
    244298, 
    244299, 
    244300, 
    244301, 
    244302, 
    244316, 
    244317, 
    244304, 
    244305, 
    244306, 
    244307, 
    244308, 
    244309, 
    244318, 
    244319, 
    244320, 
    244321, 
    244322, 
    244354, 
    244330, 
    244328, 
    244329, 
    244331, 
    244353, 
    244346, 
    244355, 
    244356, 
    244332, 
    244357, 
    244333, 
    244334, 
    244335, 
    244336, 
    244337, 
    244358, 
    244338, 
    244339, 
    244340, 
    244341, 
    244342, 
    244343, 
    244344, 
    244345, 
    244359, 
    244360, 
    244347, 
    244348, 
    244349, 
    244350, 
    244351, 
    244352, 
    244361, 
    244362, 
    244363, 
    244364, 
    244365, 
    244404, 
    244405, 
    244406, 
    244407, 
    244379, 
    244408, 
    244380, 
    244381, 
    244382, 
    244383, 
    244409, 
    244410, 
    244384, 
    244411, 
    244385, 
    244386, 
    244387, 
    244388, 
    244389, 
    244412, 
    244390, 
    244391, 
    244392, 
    244393, 
    244394, 
    244395, 
    244396, 
    244397, 
    244413, 
    244398, 
    244399, 
    244414, 
    244400, 
    244401, 
    244402, 
    244403, 
    244415, 
    244416, 
    244417, 
    244418, 
    244419, 
    244454, 
    244455, 
    244456, 
    244457
  ) 
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": 189,
          "filtered": 100,
          "index_condition": "cscart_images_links.object_type = 'variant_image' and cscart_images_links.`type` = 'V' and cscart_images_links.object_id in (220170,215381,215382,215383,215384,215385,215394,215403,215386,215387,215388,215389,215390,215391,215392,215395,215396,215397,215398,220318,215376,215377,223650,223620,223621,223622,223623,223624,244420,223625,237192,237193,223626,242239,241433,223627,223628,223629,223630,223631,241434,223632,223633,223634,223635,223636,223637,223638,223639,241435,223640,241436,223641,223642,242240,242241,223643,223644,223645,242242,241437,228384,228385,228386,243113,243117,243118,243119,244311,244285,244286,244287,244288,244310,244303,244312,244313,244289,244314,244290,244291,244292,244293,244294,244315,244295,244296,244297,244298,244299,244300,244301,244302,244316,244317,244304,244305,244306,244307,244308,244309,244318,244319,244320,244321,244322,244354,244330,244328,244329,244331,244353,244346,244355,244356,244332,244357,244333,244334,244335,244336,244337,244358,244338,244339,244340,244341,244342,244343,244344,244345,244359,244360,244347,244348,244349,244350,244351,244352,244361,244362,244363,244364,244365,244404,244405,244406,244407,244379,244408,244380,244381,244382,244383,244409,244410,244384,244411,244385,244386,244387,244388,244389,244412,244390,244391,244392,244393,244394,244395,244396,244397,244413,244398,244399,244414,244400,244401,244402,244403,244415,244416,244417,244418,244419,244454,244455,244456,244457)"
        }
      }
    },
    "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

pair_id object_id object_type image_id detailed_id type position image_type show_gallery gallery_category_id image_path alt image_x image_y images_image_id
33339 215376 variant_image 45572 0 V 0 D 0 0
33340 215377 variant_image 45573 0 V 0 D 0 0
33348 215381 variant_image 45581 0 V 0 D 0 0
33349 215382 variant_image 45582 0 V 0 D 0 0
33350 215383 variant_image 45583 0 V 0 D 0 0
33351 215384 variant_image 45584 0 V 0 D 0 0
33352 215385 variant_image 45585 0 V 0 D 0 0
33353 215386 variant_image 45586 0 V 0 D 0 0
33354 215387 variant_image 45587 0 V 0 D 0 0
33355 215388 variant_image 45588 0 V 0 D 0 0
33356 215389 variant_image 45589 0 V 0 D 0 0
33357 215390 variant_image 45590 0 V 0 D 0 0
33358 215391 variant_image 45591 0 V 0 D 0 0
33359 215392 variant_image 45592 0 V 0 D 0 0
33361 215394 variant_image 45594 0 V 0 D 0 0
33362 215395 variant_image 45595 0 V 0 D 0 0
33363 215396 variant_image 45596 0 V 0 D 0 0
33364 215397 variant_image 45597 0 V 0 D 0 0
33365 215398 variant_image 45598 0 V 0 D 0 0
33674 215403 variant_image 45907 0 V 0 D 0 0
41894 223620 variant_image 54127 0 V 0 D 0 0
41895 223621 variant_image 54128 0 V 0 D 0 0
41896 223622 variant_image 54129 0 V 0 D 0 0
41897 223623 variant_image 54130 0 V 0 D 0 0
41898 223624 variant_image 54131 0 V 0 D 0 0
41899 223625 variant_image 54132 0 V 0 D 0 0
41900 223626 variant_image 54133 0 V 0 D 0 0
41901 223627 variant_image 54134 0 V 0 D 0 0
41902 223628 variant_image 54135 0 V 0 D 0 0
41903 223629 variant_image 54136 0 V 0 D 0 0
41904 223630 variant_image 54137 0 V 0 D 0 0
41905 223631 variant_image 54138 0 V 0 D 0 0
41906 223632 variant_image 54139 0 V 0 D 0 0
41907 223633 variant_image 54140 0 V 0 D 0 0
41908 223634 variant_image 54141 0 V 0 D 0 0
41909 223635 variant_image 54142 0 V 0 D 0 0
41910 223636 variant_image 54143 0 V 0 D 0 0
41911 223637 variant_image 54144 0 V 0 D 0 0
41912 223638 variant_image 54145 0 V 0 D 0 0
41913 223639 variant_image 54146 0 V 0 D 0 0
41914 223640 variant_image 54147 0 V 0 D 0 0
41915 223641 variant_image 54148 0 V 0 D 0 0
41916 223642 variant_image 54149 0 V 0 D 0 0
41917 223643 variant_image 54150 0 V 0 D 0 0
41918 223644 variant_image 54151 0 V 0 D 0 0
41919 223645 variant_image 54152 0 V 0 D 0 0
59939 237192 variant_image 72172 0 V 0 D 0 0
59940 237193 variant_image 72173 0 V 0 D 0 0
70968 241433 variant_image 83201 0 V 0 D 0 0
70969 241434 variant_image 83202 0 V 0 D 0 0
70970 241435 variant_image 83203 0 V 0 D 0 0
70971 241436 variant_image 83204 0 V 0 D 0 0
70972 241437 variant_image 83205 0 V 0 D 0 0
71802 242239 variant_image 84035 0 V 0 D 0 0
71803 242240 variant_image 84036 0 V 0 D 0 0
71804 242241 variant_image 84037 0 V 0 D 0 0
71805 242242 variant_image 84038 0 V 0 D 0 0
74012 244285 variant_image 86245 0 V 0 D 0 0
74013 244286 variant_image 86246 0 V 0 D 0 0
74014 244287 variant_image 86247 0 V 0 D 0 0
74015 244288 variant_image 86248 0 V 0 D 0 0
74016 244289 variant_image 86249 0 V 0 D 0 0
74017 244290 variant_image 86250 0 V 0 D 0 0
74018 244291 variant_image 86251 0 V 0 D 0 0
74019 244292 variant_image 86252 0 V 0 D 0 0
74020 244293 variant_image 86253 0 V 0 D 0 0
74021 244294 variant_image 86254 0 V 0 D 0 0
74022 244295 variant_image 86255 0 V 0 D 0 0
74023 244296 variant_image 86256 0 V 0 D 0 0
74024 244297 variant_image 86257 0 V 0 D 0 0
74025 244298 variant_image 86258 0 V 0 D 0 0
74026 244299 variant_image 86259 0 V 0 D 0 0
74027 244300 variant_image 86260 0 V 0 D 0 0
74028 244301 variant_image 86261 0 V 0 D 0 0
74029 244302 variant_image 86262 0 V 0 D 0 0
74030 244303 variant_image 86263 0 V 0 D 0 0
74031 244304 variant_image 86264 0 V 0 D 0 0
74032 244305 variant_image 86265 0 V 0 D 0 0
74033 244306 variant_image 86266 0 V 0 D 0 0
74034 244307 variant_image 86267 0 V 0 D 0 0
74035 244308 variant_image 86268 0 V 0 D 0 0
74036 244309 variant_image 86269 0 V 0 D 0 0
74037 244310 variant_image 86270 0 V 0 D 0 0
74038 244312 variant_image 86271 0 V 0 D 0 0
74039 244313 variant_image 86272 0 V 0 D 0 0
74040 244314 variant_image 86273 0 V 0 D 0 0
74041 244315 variant_image 86274 0 V 0 D 0 0
74042 244316 variant_image 86275 0 V 0 D 0 0
74043 244317 variant_image 86276 0 V 0 D 0 0
74044 244318 variant_image 86277 0 V 0 D 0 0
74045 244319 variant_image 86278 0 V 0 D 0 0
74046 244320 variant_image 86279 0 V 0 D 0 0
74047 244321 variant_image 86280 0 V 0 D 0 0
74048 244322 variant_image 86281 0 V 0 D 0 0
74054 244328 variant_image 86287 0 V 0 D 0 0
74055 244329 variant_image 86288 0 V 0 D 0 0
74056 244330 variant_image 86289 0 V 0 D 0 0
74057 244331 variant_image 86290 0 V 0 D 0 0
74058 244332 variant_image 86291 0 V 0 D 0 0
74059 244333 variant_image 86292 0 V 0 D 0 0
74060 244334 variant_image 86293 0 V 0 D 0 0
74061 244335 variant_image 86294 0 V 0 D 0 0
74062 244336 variant_image 86295 0 V 0 D 0 0
74063 244337 variant_image 86296 0 V 0 D 0 0
74064 244338 variant_image 86297 0 V 0 D 0 0
74065 244339 variant_image 86298 0 V 0 D 0 0
74066 244340 variant_image 86299 0 V 0 D 0 0
74067 244341 variant_image 86300 0 V 0 D 0 0
74068 244342 variant_image 86301 0 V 0 D 0 0
74069 244343 variant_image 86302 0 V 0 D 0 0
74070 244344 variant_image 86303 0 V 0 D 0 0
74071 244345 variant_image 86304 0 V 0 D 0 0
74072 244346 variant_image 86305 0 V 0 D 0 0
74073 244347 variant_image 86306 0 V 0 D 0 0
74074 244348 variant_image 86307 0 V 0 D 0 0
74075 244349 variant_image 86308 0 V 0 D 0 0
74076 244350 variant_image 86309 0 V 0 D 0 0
74077 244351 variant_image 86310 0 V 0 D 0 0
74078 244352 variant_image 86311 0 V 0 D 0 0
74079 244353 variant_image 86312 0 V 0 D 0 0
74080 244355 variant_image 86313 0 V 0 D 0 0
74081 244356 variant_image 86314 0 V 0 D 0 0
74082 244357 variant_image 86315 0 V 0 D 0 0
74083 244358 variant_image 86316 0 V 0 D 0 0
74084 244359 variant_image 86317 0 V 0 D 0 0
74085 244360 variant_image 86318 0 V 0 D 0 0
74086 244361 variant_image 86319 0 V 0 D 0 0
74087 244362 variant_image 86320 0 V 0 D 0 0
74088 244363 variant_image 86321 0 V 0 D 0 0
74089 244364 variant_image 86322 0 V 0 D 0 0
74090 244365 variant_image 86323 0 V 0 D 0 0
74121 244379 variant_image 86354 0 V 0 D 0 0
74122 244380 variant_image 86355 0 V 0 D 0 0
74123 244381 variant_image 86356 0 V 0 D 0 0
74124 244382 variant_image 86357 0 V 0 D 0 0
74125 244383 variant_image 86358 0 V 0 D 0 0
74126 244384 variant_image 86359 0 V 0 D 0 0
74127 244385 variant_image 86360 0 V 0 D 0 0
74128 244386 variant_image 86361 0 V 0 D 0 0
74129 244387 variant_image 86362 0 V 0 D 0 0
74130 244388 variant_image 86363 0 V 0 D 0 0
74131 244389 variant_image 86364 0 V 0 D 0 0
74132 244390 variant_image 86365 0 V 0 D 0 0
74133 244391 variant_image 86366 0 V 0 D 0 0
74134 244392 variant_image 86367 0 V 0 D 0 0
74135 244393 variant_image 86368 0 V 0 D 0 0
74136 244394 variant_image 86369 0 V 0 D 0 0
74137 244395 variant_image 86370 0 V 0 D 0 0
74138 244396 variant_image 86371 0 V 0 D 0 0
74139 244397 variant_image 86372 0 V 0 D 0 0
74140 244398 variant_image 86373 0 V 0 D 0 0
74141 244399 variant_image 86374 0 V 0 D 0 0
74142 244400 variant_image 86375 0 V 0 D 0 0
74143 244401 variant_image 86376 0 V 0 D 0 0
74144 244402 variant_image 86377 0 V 0 D 0 0
74145 244403 variant_image 86378 0 V 0 D 0 0
74146 244405 variant_image 86379 0 V 0 D 0 0
74147 244406 variant_image 86380 0 V 0 D 0 0
74148 244407 variant_image 86381 0 V 0 D 0 0
74149 244408 variant_image 86382 0 V 0 D 0 0
74150 244409 variant_image 86383 0 V 0 D 0 0
74151 244410 variant_image 86384 0 V 0 D 0 0
74152 244411 variant_image 86385 0 V 0 D 0 0
74153 244412 variant_image 86386 0 V 0 D 0 0
74154 244413 variant_image 86387 0 V 0 D 0 0
74155 244414 variant_image 86388 0 V 0 D 0 0
74156 244415 variant_image 86389 0 V 0 D 0 0
74157 244416 variant_image 86390 0 V 0 D 0 0
74158 244417 variant_image 86391 0 V 0 D 0 0
74159 244418 variant_image 86392 0 V 0 D 0 0
74160 244419 variant_image 86393 0 V 0 D 0 0
74162 244420 variant_image 86395 0 V 0 D 0 0
74193 244455 variant_image 86426 0 V 0 D 0 0
74194 244456 variant_image 86427 0 V 0 D 0 0
74195 244457 variant_image 86428 0 V 0 D 0 0